Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
MR-1218 Finance
NORTH AUGUSTA FINANCE DEPARTMENT North Augusta j1 South Carolina's Muerfront CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF DECEMBER, 2018 1/25/2019 GF.NF.RAL FUND REVENUES EXPENSES SURPLUS 0E61CM 2018 2017 2018 2017 2018 2017 Mmn61,, YI1) Mon161Y YTD M-11d, YID Momldy I YTD Monddy YI'D M—U, YID AR 1,119,593 1,419593 1,22,688 1,22,688 1,159,531 1,159,531 1,074,289 1,074,289 M,062 260962 146,399 146,399 MR 1.453,600 2,873,193 [,44],99] 2,668,685 1966,742 3,M,273 1.570900 2,615,189 (513,142) 1253,0801 11229031 23,496 MAR 3,296,900 6,170,093 3,]95,82] 6,1 4,512 1.258,262 4,384535 1,503,951 0.149,140 2,038,638 1,785,558 2,291,876 2,315,372 APR 3,513,803 9,683,896 3,505,674 9,970,186 1,387,5.£1 5,]]2,088 1,244,552 5,393,692 2,1ffi,250 3,911,808 2,261,122 4,576,&94 M:11'* 808,100 10.491,9961 1,20,Ml 11,239,630 1,526,539 ],298,62] 1,536,207 6,929,899 018,&991 3,193,369 12G6,7C31 4,309)31 PSE 2,fi94,795 19,186,791 2,38,C53 13,620,288 1,YIbfi3% 8673,265 1,0]8,]]7 8,008,676 1,420,157 4,618,526 1,801,876 5,611,07 ULY Y 945,871 15,532,662 801,934 14,422,217 1,598,431 10,171,696 1,413,430 9,422,156 747,440 5,360,966 (611,546) 5,00,061 AUG 451,623 15984.285 529,297 14,951,514 1,343,235 11.495,131 1,283,380 1,705,536 (871,812) &439,141 0.51,083) 4.215978 SEPT 2]7541 16,261,826 471,806 15,423,320 1,'243,857 12,738,988 1,264,856 11,970,392 (966316) 9A22,838 093,050) 3,452,928 OGT M,70 16,870,595 70,796 16,169,116 1,614,070 14.413,0.58 1]83,881 13,754,273 (1,065,301) 2,457,53] (1,038,085) 2,414,8&9 NOV 654,900 17,525,05 42,734 16689,850 1.218,159 15,031,217 1,121,151 14,880,424 (563,259) 1,894,278 (705,417) 1,709,126 DEC 65],499 18,182,936 45$`236 17,043,086 1597,9301],216,147 1,728,464 16,608.988 (93],491) 95,]8] (1,275,228) Jit,198 P.,0--I,f—d—I- d,m 7/1ss avPns«1.4/1 YEAR-TO-DATE BALANCE 7,000,000 6,000,000 5,000,000 4,000,000 ii 3 3,000,000 2,000,000 --- 1,000,000 \\; 0 (1,000,000) JAN FEB MAR APR MAY* JUNE JULY AUG SEPT OCT NOV DEC X2013 X2014 �2015 X2016 .2017 =2018 L3serfiahe/H0914k1 This Month: December 2018 Page I of 6 1/25!2019 STORMWATER UTIIM FUND REVENUES EXPENSES SURPLUS(DEFICPFI 2018 201] 2018 2017 2018 2017 S1omIJvI YPD M-111, I YTD MmOhly YTD M-do, }TD Mo,n6b YTD M.1day YTD AN 66,961 66,901 66,175 66,175 37,769 37,769 28,721 28,721 29,192 29,192 37,454 37,454 FEB 66,146 138,IW 64517 13,692 48,383 86,152 &4,230 61,951 17,763 46,955 31,487 68,741 MAR 68,081 201,188 64,572 195,464 37,630 123,782 354]1 97,422 30,451 77400 29,101 97,842 APR 66,305 267,493 65599 26,X63 42,0911 165,872 37,358 134,780 24,215 101,621 28,241 146,083 MAY 6,519 334,012 65389 326,452 65,471 231,343 V,154 183,934 1,04X 102,669 16,235 142,818 UNE 69,015 403,027 66,mg 393,121 X;4,513 Y04,856 32,027 415,961 35,502 138,171 34,844 177,160 JULY 66,698 469,125 65,213 458,334 45,519 310,375 61,676 211,637 21,179 159,350 3,537 18,697 AUG 66,944 536,671 61,406 525,7W 116,784 441,159 55,989 333,626 (49,838) 109,512 11,417 192,114 SEEP 69,305 605y76 65.92E 591,662 53,X11 480,970 3,86J 370,493IH 29,055 221,109 OCT 70,824 67fi,300 65419 657,081 541119 535,389 58,107 428.660 >,PSY `22$421 NOV 67,4A1 ]4A,Jfl1 fiJ„5AJ J2d,618 4'1,1`23 5)),512 35881 4(#.54131,656 260,077 DEC 73,0&4 816,864 66,091 J90,]LS 55591 633,106 56,969 521,510 9,128 269,205 YEAR-TO-DATE BALANCE 350,000 _...._ 300,000 - 250,000 I - 200,000 , 1ea,7sR i 150,000 ......... 100,000 50,000 E 0 7 (50,000) - JAN IEB MAR APR MAY 1L,NL JULY AUG SEPT OCT NOV DEC 12013 +2014 �2015 r 2016 rt•2017 � 2018 L.,&he/FI0914t2 This Montle December 2018 Palle 2 016 1/25/2019 SANITATION SERVICES FUND REVENUES EXPENSES SURPLUS(DEFICFD 2018 401] 2018 2017 2018 2017 MomNy ]TD M-d! YTD M.mOth PPD Mouddy YTD Mond,], YTD MonWly I YTD AN mjm 35,IW 297,001 297,001 341,573 341,573 30],65] 30],65] 8,52] 8,527 (10,656) (10,656) FEB 308,941 1159,0.41 369,289 666,290 583,964 925,537 426$69 734.226 (275,023) (26,496) (57,280) (67,936) MAR 382,278 1,041,319 318,541 981,834 515,919 1,441,256 550,331 1,284,55] (13A,441) (3.99,93]) (231,787) (299,723) APR' 364,995 1,406,314 383,335 1,368,169 509,075 1,950,331 274,223 1,558,780 (141,080) (544,017) 109,112 (1W,611) MAY 401,043 1,80],35] 422,975 1,791,144 391,823 2,312,154 336,090 1,894,870 9,220 (534,]9]) 3,885 (IM,726) UNE 415,]]8 2,223,135 398,859 2,19,W3 274,152 2,616,3W 283,985 2,158,855 141,626 (393,171) 134,8]4 31,148 IDLY 371,311 Y,59A,416 445]2J 2,635,]2] 361,046 2,9]],35'1 354,9W 2,513,761 10,'165 (382,9W) 90,818 141,906 AUG 442,206 3,0:16,652 32,119 2,961,846 290,491 3,26],843 270,560 2,784,321 151,715 (231,191) 55,559 1]],52.5 SEPT 38,99] 3,417,649 325,289 3,33],135 2]2,4]8 8$40,321 293,965 3.078,286 108$19 (122,672) 81324 258,819 OCI' 543,992 3,W1,041 390,196 3,]21,931 338,254 3,8]8,5]5 386,406 3,464,692 205,]38 83,066 3,]90J2626NOV 3]2,014 4,333,655 3119,739 4097,069 390,209 4,214,]84 261,2115 3,]25,95] 35,805 11N,AT 108,473DEC 51156] 4865,222 448506 4,545,575 U8,179 4,562,963 374,826 4,100,]83 163,388 484,'154 ]3,680 'Inoreased expense for 2018,as compared to die Pnor year,is rebind to refurbisl.n nl of We MRF .mp , lease pwd�se,v�d a incl cosh. YEAR-TO-DATE BALANCE 600,000 400,000 200,000 0 (200,000) 282,259 (400,000) (600,000) (800,000) JAN FEB MAR APR' MAY NNE JULY AUG SEPT OCT NOV DEC ♦2013 +2014 X2015 W16 XWP �N118 Izswli,WFI0914#3 'Ilm Month: December 2018 Page 3 of 6 1/2512019 WATERWORKS & SEWER SYSTEM RER'F.bT1E9 E.RPENSPS BORPLOB 0)EMICR) 2018 2017 2018 2017 2018 20 17 MmnlJy 1I NI Witp- YTD MmnldS YID NI.WdlYID Mm,Jd1 5TD M-114)' YM AN 815,752 841,752 ]]2,189 ]]2,109 593,360 .593,360 49,819 490,819 21$392 252,392 281,370 281,370 FEB 862,127 1,707,879 806,179 1,.5]74.48 825,667 1,417,027 898,2!6 1,389,065 38,J60 290,852 N2,M6 189,303 MAR 773,554 2,481433 751,851 2,330,219 1.2145,{90 2,623,517 6114,109 4303,174 (32436) (13$084) 13622581 (174955) APR 80,11G11 2290493 783350 31113,569 755,511 3,3]91158 690,954 3,191,128 53,519 (88,565) 92,3% (80559) NAI 898,612 4,189,105 786,748 3.4.,317 80,763 4,185,821 772]25 3,966,833 91,849 3,284 14,023 (6 6) JI NE 857,321 5,OM,W 853,024 4,753,341 627,601 4,013422 5161495 11,562218 229,724 233,W8 256,629 1N,093 JULY 811,603 5,892.03 L063,274 5,816,615 801,W2 5,61Ln4 812,04 5,375912 44,251 277,259 250,610 W,703 AUG 880,982 6,773,015 BD,B93 6b46514 720OW 6,335,&12 742jW 6,118$02 160,414 43],6]3 8]403 528,012 .SEPT 876,669 7,649,684 95904i 7,ti0359 63{257 6,969579 665,9&1 6,7844&5 242,432 680,105 293,02 821,074 OCF 889,193 B,SA&877 795,212 8,10,801 754439 7,721018 330,908 7,615,393 131,751 811,859 185,6661 785408 NOV 865,278 94M,1i5 893~313 9,191,131 Q9ti484 8,360$114 6]4,]9'1 8,290,Itl3 448,791 111443458 418,553 1,003,951 DF 80,2D 1,249,375 816,383 10,110,527 6070,026 9430,528 989,964 9,280,147 (224,806)1 818,84~ aw8l)l 830480 YEAXTO-DATE BALANCE 1,000,000 ------ 818,847 800,000 600,000 ---- - 400,000 200,000 0 (200.000) - (400,000) �_ • _ (600,000) - - --- -- (800,000) -- -- JAN FEB MAR APR MAY JUST JULY AO(, SEPT OCT NON' UI4 .2013 .2014 �2015 y 2016 X2017 X2018 La ,fi, e/FI09UW4 This Mon& December 2018 Page 4 of 6 1/252019 DEPARTMENT COMPARATIVE DATA (2017-2018) OPERATING FUNDS& 2017 2018 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 12 MO-100.0096 BUDGET BALANCE GENERAL FUND(10): CITY COUNCIL 171,894.89 177,04581 98.61% 179,546.00 2,500.19 ADMINISTRATION 298,187.78 385,333.98 100.14% 384,803.00 530.98 INFORMATION TECHNOLOGY 259,836.97 265,941.43 91.58% 290,404.00 24,462.57 JUSTICE&LAW 703,187.99 651,575.06 90.81% 717,238.00 65,662.94 COMMUNITY PROMOTION 92,984.23 72,0.5189 96.29% 74,831.00 2,779.11 FINANCE 424,355.10 437,328.991 100.56% 484,889.00 -2,439.99 HUMAN RESOURCES 217,596.32 277,464.21 116.74% 237,680.00 -39,784.21 BUILDING STANDARDS 367,809.78 438,474.73 112.87% 388,469.00 50,005.73 PLANNING&DEVELOPMENT 219,059.17 177,750.06 63.6996 279,09.5.00 101,344.94 CM BUILDINGS 314,055.98 321,658.51 98.43% 326,797.00 5,138.49 PROPERTY MAINTENANCE 1,268,815.50 1,322,897.76 101.2896 1,306,187.00 -16,710.76 PUBLIC SAFETY 7,866,301.73 8,420,971.49 100.731% 8,360,016.00 .60,955.49 ENGINEERING 189,901.92 207,282.93 100.87% 205,488.00 -1,794.93 STREETLIGHTS&SIGNALS 485,324.25 483,900.05 99.61% 485,670.00 1,769.95 STREETS&DRAINS 863,723.52 908,826.12 101.48% 895,575.00 -13,251.12 RECREATION 1,050,311.54 901,840.16 101.88% 885,235.00 -16,605.16 PARKS 568,578.58 453,180.17 85.29'% 531,320.00 78,139.83 COMMUNITY CENTER 175,526.70 163,140.67 93.21% 175,016.00 11,875.33 TOURISM 215,659.43 398,889.61 101.24% 394,021.00 -4,968.61 RVP ACTIVITIES CENTER 855,776.77 760,59354 95.84,x, 793,603.00 33,009.46 GENERAL FUND TOTAL 16,608,888.15 17,226,147.17 99.31% 17,345,883.00 119,755.83 STORMWATER UT L[TY FUND(11): INFORMATION TECHNOLOGY 29,370.14 23,050.53 92.29% 24,975.00 1,924.47 STORMWA'I'F.R 489,225.71 607,017.51 80.70% 752,198.00 145,180.49 HUMAN RESOURCES 2,914.07 3,037.99 83.85% 3,623.00 585.01 STORMWATER FUND TOTAL 521,509.92 633,106.03 8L08'% 780,796.00 14709.97 SANITATION FUND(13): INFORMATION TECHNOLOGY 57,443.74 59,468.14 97.5196 60,985.00 1,51686 SANITATION 2,366,891.38 2,563,250.33 100.40% 2,553,111.00 -10,139.33 RECYLING 1,506,418.87 1,711,924.07 101.83% 1,681,237.00 -30,687.07 HUMAN RESOURCES 14,855.72 13,836.12 75.44% 18,341.00 4,504.88 TRANSHAS 155,173.00 214,484.00 100.00% 214,484.00 0.00 SANITATION FUND TOTAL 4,100,782.71 4,562,962.66 100.77% 4,528,158.00 -34,804.66 O&M FUND(21): INFORMATION TECHNOLOGY 325,630.23 303,874.60 85.61% 354,944.00 51,069.40 HUMAN RESOURCES 12,570.05 10,856.29 71.65% 15,151.00 4,294.71 UTILITIES FINANCE 468,852.82 495,336.81 96.53% 513,145.00 17,808.19 U-HLITIES ADMINISTRATION 585,819.55 570554.80 90.56% 629,998.00 59,443.20 WATER OPERATIONS 748,699.14 743,771.17 03.25% 7, 612.00 53,840.83 WATER PRODUCTION 1,391,848.73 1,432,345.75 93.01% 1,539,554.00 107,208.25 WASTEWATER(OPERATIONS 3,510,895.77 3,516,293.91 91.25% 3,853,413.00 337,119.09 TRANSFERS 383,395.00 478,767.00 100.00% 478,767.00 0.00 O&-MFUND TOTAL 7,427,711.29 7,551,800.33 92.29%1 8,182,584.001 630,783.67 La.rfidre/H0914#5 This Month:December 2018 page!)oC 6 GALLONS OF WATER BILLED 1/252019 2013 2014 2015 2016 2017 2018 AN 87,534,100 67,527,800 66,593,800 80,612,500 66,226,500 70,472,600 FEB 79331,600 70,558,900 64,180,000 63,228,900 67,248,700 71,463,100 MAR 72,718,000 59,501,800 61,4L,100 63,146,800 66,873,200 63,382,800 APR 83,519,700 66,036,800 69,821,800 75,996300 76,591,700 67,096,100 MAY 104,337,300 87,006,600 78,135,500 91,865,700 95,937,000 92,208,400 UN 143,562,6001 102,185,100 114,293,800 117,019,167 110,442,100 97,377,300 JUL 133,404,400 119,881,100 130,932,600 127,708,867 104,063,100 105,927,100 AUG 107,485366 110,592,200 128369,800 123,927,500 103,060,200 99,041,700 SEP 106,427,500 128,709,100 115,214,244 128,532,700 110,350,200 103,480,400 OCT 126,482,300 102,242,400 96,463,100 101300,800 95,226,700 105,219,900 NOV 103,845,700 82 484,300 70,516,400 109,895,800 99,336,800 82,158,600 DEC 74,656,800 78370,200 73,391,300 83,710,800 78,090,700 69,352,:400 TOTAL 1,223300,366 1,075,596,300 1,069,307,444 1,166,945,834 1,073,446,900 1,027,179,700 GALLONS OF WATER BIT 1 200,000,000 180,000,000 160,000,000 140,000,000 120,000,000 IOO,OOQ000 80,000,000 60,000,000 40,000,000 69352300 20,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC LssccfidN/F10914gfi This MonOc December 2018 Page 6 of 6