Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Finance MR 1207
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF DECEMBER, 2017 1/30/2018 Laserfiche/FI0914#1 This Month: December 2017 Page 1 of 6 GENERAL FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 1,220,688 1,220,688 879,231 879,231 1,074,289 1,074,289 1,209,330 1,209,330 146,399 146,399 (330,100)(330,100) FEB 1,447,997 2,668,685 1,718,808 2,598,039 1,570,900 2,645,189 1,156,718 2,366,049 (122,903)23,496 562,090 231,990 MAR 3,795,827 6,464,512 3,854,717 6,452,756 1,503,951 4,149,140 1,707,952 4,074,001 2,291,876 2,315,372 2,146,764 2,378,755 APR 3,505,674 9,970,186 4,092,389 10,545,145 1,244,552 5,393,692 1,367,857 5,441,858 2,261,122 4,576,494 2,724,532 5,103,287 MAY 1,269,444 11,239,630 914,006 11,459,151 1,536,207 6,929,899 1,516,854 6,958,712 (266,763)4,309,731 (602,848)4,500,439 JUNE 2,380,653 13,620,283 2,003,866 13,463,017 1,078,777 8,008,676 1,045,104 8,003,816 1,301,876 5,611,607 958,762 5,459,201 JULY 801,934 14,422,217 840,735 14,303,752 1,413,480 9,422,156 1,340,243 9,344,059 (611,546)5,000,061 (499,508)4,959,693 AUG 529,297 14,951,514 622,383 14,926,135 1,283,380 10,705,536 1,451,043 10,795,102 (754,083)4,245,978 (828,660)4,131,033 SEPT 471,806 15,423,320 351,809 15,277,944 1,264,856 11,970,392 1,400,111 12,195,213 (793,050)3,452,928 (1,048,302)3,082,731 OCT 745,796 16,169,116 512,260 15,790,204 1,783,881 13,754,273 830,586 13,025,799 (1,038,085)2,414,843 (318,326)2,764,405 NOV 420,734 16,589,850 537,277 16,327,481 1,126,151 14,880,424 1,476,971 14,502,770 (705,417)1,709,426 (939,694)1,824,711 DEC 453,236 17,043,086 490,286 16,817,767 1,728,464 16,608,888 1,497,900 16,000,670 (1,275,228)434,198 (1,007,614)817,097 (1,000,000) 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2012 2013 2014 2015 2016 2017 434,198 1/30/2018 Laserfiche/FI0914#2 This Month: December 2017 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 66,175 66,175 63,313 63,313 28,721 28,721 33,542 33,542 37,454 37,454 29,772 29,772 FEB 64,517 130,692 63,622 126,935 33,230 61,951 27,210 60,752 31,287 68,741 36,412 66,183 MAR 64,572 195,264 64,005 190,940 35,471 97,422 31,138 91,890 29,101 97,842 32,867 99,050 APR 65,599 260,863 63,678 254,618 37,358 134,780 40,438 132,328 28,241 126,083 23,240 122,290 MAY 65,389 326,252 67,182 321,800 49,154 183,934 37,826 170,154 16,235 142,318 29,356 151,646 JUNE 66,869 393,121 67,944 389,744 32,027 215,961 38,260 208,414 34,842 177,160 29,685 181,330 JULY 65,213 458,334 63,258 453,002 61,676 277,637 41,533 249,947 3,537 180,697 21,725 203,055 AUG 67,406 525,740 64,055 517,057 55,989 333,626 37,061 287,008 11,417 192,114 26,994 230,049 SEPT 65,922 591,662 63,690 580,747 36,867 370,493 44,718 331,726 29,055 221,169 18,972 249,021 OCT 65,419 657,081 64,942 645,689 58,167 428,660 31,773 363,499 7,252 228,421 33,169 282,190 NOV 67,537 724,618 64,209 709,899 35,881 464,541 43,822 407,321 31,656 260,077 20,387 302,578 DEC 66,097 790,715 65,451 775,350 56,969 521,510 36,574 443,895 9,128 269,205 28,877 331,455 (50,000) 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2012 2013 2014 2015 2016 2017 269,205 1/30/2018 Laserfiche/FI0914#3 This Month: December 2017 Page 3 of 6 SANITATION SERVICES FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 297,001 297,001 294,081 294,081 307,657 307,657 328,936 328,936 (10,656)(10,656)(34,856)(34,856) FEB 369,289 666,290 309,355 603,435 426,569 734,226 209,125 538,062 (57,280)(67,936)100,229 65,373 MAR 318,544 984,834 351,008 954,443 550,331 1,284,557 798,693 1,336,755 (231,787)(299,723)(447,685)(382,312) APR 383,335 1,368,169 345,411 1,299,854 274,223 1,558,780 302,373 1,639,128 109,112 (190,611)43,038 (339,274) MAY 422,975 1,791,144 363,828 1,663,682 336,090 1,894,870 337,424 1,976,552 86,885 (103,726)26,404 (312,870) JUNE 398,859 2,190,003 374,116 2,037,798 263,985 2,158,855 255,044 2,231,596 134,874 31,148 119,072 (193,798) JULY 445,724 2,635,727 407,900 2,445,698 354,906 2,513,761 293,440 2,525,036 90,818 121,966 114,460 (79,338) AUG 326,119 2,961,846 307,390 2,753,088 270,560 2,784,321 332,353 2,857,389 55,559 177,525 (24,963)(104,301) SEPT 375,289 3,337,135 354,929 3,108,017 293,965 3,078,286 349,521 3,206,910 81,324 258,849 5,408 (98,893) OCT 390,196 3,727,331 368,765 3,476,782 386,406 3,464,692 193,610 3,400,520 3,790 262,639 175,155 76,262 NOV 369,738 4,097,069 368,833 3,845,615 261,265 3,725,957 350,741 3,751,261 108,473 371,112 18,092 94,354 DEC 448,506 4,545,575 492,869 4,338,484 374,826 4,100,783 350,284 4,101,545 73,680 444,792 142,585 236,939 (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 2012 2013 2014 2015 2016 2017 444,792 1/30/2018 Laserfiche/FI0914#4 This Month: December 2017 Page 4 of 6 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 772,189 772,189 802,426 802,426 490,819 490,819 592,654 592,654 281,370 281,370 209,772 209,772 FEB 806,179 1,578,368 687,000 1,489,426 898,246 1,389,065 478,555 1,071,209 (92,067)189,303 208,445 418,217 MAR 751,851 2,330,219 756,516 2,245,942 1,114,109 2,503,174 1,255,081 2,326,290 (362,258)(172,955)(498,565)(80,348) APR 783,350 3,113,569 780,990 3,026,932 690,954 3,194,128 1,035,616 3,361,906 92,396 (80,559)(254,626)(334,974) MAY 786,748 3,900,317 774,681 3,801,613 772,725 3,966,853 709,913 4,071,819 14,023 (66,536)64,768 (270,206) JUNE 853,024 4,753,341 871,105 4,672,718 596,395 4,563,248 573,471 4,645,290 256,629 190,093 297,634 27,429 JULY*1,063,274 5,816,615 874,174 5,546,892 812,664 5,375,912 775,951 5,421,240 250,610 440,703 98,223 125,651 AUG*829,899 6,646,514 818,838 6,365,730 742,590 6,118,502 708,203 6,129,443 87,309 528,012 110,636 236,287 SEPT*959,045 7,605,559 845,344 7,211,074 665,983 6,784,485 601,561 6,731,004 293,062 821,074 243,783 480,070 OCT*795,242 8,400,801 795,792 8,006,866 830,908 7,615,393 762,869 7,493,873 (35,666)785,408 32,923 512,993 NOV*893,343 9,294,144 809,789 8,816,655 674,790 8,290,183 703,146 8,197,019 218,553 1,003,961 106,643 619,636 DEC*816,383 10,110,527 794,724 9,611,379 989,964 9,280,147 951,086 9,148,105 (173,581)830,380 (156,362)463,274 *Increase in revenue primarily attributed to unbudgeted increases in water and sewer tap fees related to new development at the Village at Hammond's Ferr (800,000) (600,000) (400,000) (200,000) 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JAN FEB MAR APR MAY JUNE JULY*AUG*SEPT*OCT*NOV*DEC* YEAR-TO-DATE BALANCE 2012 2013 2014 2015 2016 2017 830,380 1/30/2018 OPERATING FUNDS &2016 YTD 2017 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 12 MO=100%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 166,059.00 171,894.89 95.35%180,274.00 8,379.11 ADMINISTRATION 241,647.43 298,187.78 109.78%271,632.00 -26,555.78 INFORMATION TECHNOLOGY 233,634.43 259,836.97 93.79%277,054.00 17,217.03 JUSTICE & LAW 762,894.84 703,187.99 87.47%803,887.00 100,699.01 COMMUNITY PROMOTION 99,836.07 92,984.23 100.85%92,196.00 -788.23 FINANCE 390,827.68 424,355.10 102.92%412,335.00 -12,020.10 HUMAN RESOURCES 182,972.66 217,596.32 98.78%220,282.00 2,685.68 BUILDING STANDARDS 349,121.08 367,809.78 99.98%367,867.00 57.22 PLANNING & DEVELOPMENT 237,464.21 219,059.17 78.81%277,946.00 58,886.83 CITY BUILDINGS 297,436.29 314,055.98 94.94%330,781.00 16,725.02 PUBLIC SAFETY 7,672,819.51 7,866,301.73 98.35%7,998,399.00 132,097.27 ENGINEERING 149,524.88 189,901.92 97.10%195,576.00 5,674.08 STREET LIGHTS & SIGNALS 424,773.10 485,324.25 103.82%467,450.00 -17,874.25 STREETS & DRAINS 792,184.47 863,723.52 98.54%876,531.00 12,807.48 RECREATION 1,043,119.39 1,050,311.54 106.48%986,369.00 -63,942.54 PARKS 532,274.39 568,578.58 95.90%592,912.00 24,333.42 PROPERTY MAINTENANCE 1,196,707.66 1,268,815.50 102.58%1,236,880.00 -31,935.50 COMMUNITY CENTER 162,504.31 175,526.70 105.76%165,965.00 -9,561.70 TOURISM 210,296.80 215,659.43 98.24%219,528.00 3,868.57 RVP ACTIVITIES CENTER 854,571.57 855,776.77 101.56%842,640.00 -13,136.77 GENERAL FUND TOTAL 16,000,669.77 16,608,888.15 98.77%16,816,504.00 207,615.85 STORMWATER UTILITY FUND (11): INFORMATION TECHNOLOGY 31,421.72 29,370.14 89.07%32,975.00 3,604.86 STORMWATER 409,374.94 489,225.71 67.54%724,338.00 235,112.29 HUMAN RESOURCES 3,098.65 2,914.07 95.20%3,061.00 146.93 STORMWATER FUND TOTAL 443,895.31 521,509.92 68.59%760,374.00 238,864.08 SANITATION FUND (13): INFORMATION TECHNOLOGY 70,210.26 57,443.74 97.06%59,183.00 1,739.26 SANITATION 2,390,517.87 2,366,891.38 97.15%2,436,400.00 69,508.62 RECYLING 1,469,949.49 1,506,418.87 101.41%1,485,421.00 -20,997.87 HUMAN RESOURCES 13,873.91 14,855.72 89.99%16,509.00 1,653.28 TRANSFERS 156,993.00 155,173.00 100.00%155,173.00 0.00 SANITATION FUND TOTAL 4,101,544.53 4,100,782.71 98.75%4,152,686.00 51,903.29 O & M FUND (21): INFORMATION TECHNOLOGY 289,523.31 325,630.23 94.94%342,993.00 17,362.77 HUMAN RESOURCES 13,516.91 12,570.05 84.31%14,909.00 2,338.95 UTILITIES FINANCE 444,383.06 468,852.82 98.62%475,402.00 6,549.18 UTILITIES ADMINISTRATION 556,978.77 585,819.55 95.80%611,476.00 25,656.45 WATER OPERATIONS 734,341.34 748,699.14 99.14%755,195.00 6,495.86 WATER PRODUCTION 1,370,719.11 1,391,848.73 99.88%1,393,579.00 1,730.27 WASTEWATER OPERATIONS 3,327,985.20 3,510,895.77 97.84%3,588,346.00 77,450.23 TRANSFERS 383,950.00 383,395.00 100.00%383,395.00 0.00 O & M FUND TOTAL 7,121,397.70 7,427,711.29 98.18%7,565,295.00 137,583.71 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2016-2017) This Month: December 2017 1/30/2018 Laserfiche/FI0914#6 This Month: December 2017 Page 6 of 6 2012 2013 2014 2015 2016 2017 JAN 76,992,000 87,534,100 67,527,800 66,593,800 80,612,500 66,226,500 FEB 78,702,600 79,331,600 70,558,900 64,130,000 63,228,900 67,248,700 MAR 80,193,900 72,713,000 59,501,800 61,445,100 63,146,800 66,873,200 APR 107,772,100 83,519,700 66,036,800 69,821,800 75,996,300 76,591,700 MAY 122,523,900 104,337,300 87,006,600 78,135,500 91,865,700 95,937,000 JUN 161,618,200 143,562,600 102,185,100 114,293,800 117,019,167 110,442,100 JUL 156,023,900 133,404,400 119,881,100 130,932,600 127,708,867 104,063,100 AUG 163,228,300 107,485,366 110,592,200 128,369,800 123,927,500 103,060,200 SEP 133,551,000 106,427,500 128,709,100 115,214,244 128,532,700 110,350,200 OCT 124,179,100 126,482,300 102,242,400 96,463,100 101,300,800 95,226,700 NOV 104,181,700 103,845,700 82,984,300 70,516,400 109,895,800 99,336,800 DEC 95,810,200 74,656,800 78,370,200 73,391,300 83,710,800 78,090,700 TOTAL 1,404,776,900 1,223,300,366 1,075,596,300 1,069,307,444 1,166,945,834 1,073,446,900 GALLONS OF WATER BILLED 0 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 160,000,000 180,000,000 200,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC GALLONS OF WATER BILLED 2012 2013 2014 2015 2016 2017 78,090,700