Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
MR-0818 Finance
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF AUGUST, 2018 9/18/2018 Laserfiche/FI0914#1 This Month: August 2018 Page 1 of 6 GENERAL FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 8 2 0 1 8 2 0 1 8 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 1,419,593 1,419,593 1,220,688 1,220,688 1,159,531 1,159,531 1,074,289 1,074,289 260,062 260,062 146,399 146,399 FEB 1,453,600 2,873,193 1,447,997 2,668,685 1,966,742 3,126,273 1,570,900 2,645,189 (513,142)(253,080)(122,903)23,496 MAR 3,296,900 6,170,093 3,795,827 6,464,512 1,258,262 4,384,535 1,503,951 4,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,553 5,772,088 1,244,552 5,393,692 2,126,250 3,911,808 2,261,122 4,576,494 MAY*808,100 10,491,996 1,269,444 11,239,630 1,526,539 7,298,627 1,536,207 6,929,899 (718,439)3,193,369 (266,763)4,309,731 JUNE 2,694,795 13,186,791 2,380,653 13,620,283 1,274,638 8,573,265 1,078,777 8,008,676 1,420,157 4,613,526 1,301,876 5,611,607 JULY 2,345,871 15,532,662 801,934 14,422,217 1,598,431 10,171,696 1,413,480 9,422,156 747,440 5,360,966 (611,546)5,000,061 AUG 451,623 15,984,285 529,297 14,951,514 1,323,435 11,495,131 1,283,380 10,705,536 (871,812)4,489,154 (754,083)4,245,978 SEPT 471,806 15,423,320 1,264,856 11,970,392 (793,050)3,452,928 OCT 745,796 16,169,116 1,783,881 13,754,273 (1,038,085)2,414,843 NOV 420,734 16,589,850 1,126,151 14,880,424 (705,417)1,709,426 DEC 453,236 17,043,086 1,728,464 16,608,888 (1,275,228)434,198 * Per Council, franchise fee payments are now due 7/1 as opposed to 4/1 2 0 1 72 0 1 72 0 1 7 (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 2013 2014 2015 2016 2017 2018 4,489,154 9/18/2018 Laserfiche/FI0914#2 This Month: August 2018 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 8 2 0 1 8 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 66,961 66,961 66,175 66,175 37,769 37,769 28,721 28,721 29,192 29,192 37,454 37,454 FEB 66,146 133,107 64,517 130,692 48,383 86,152 33,230 61,951 17,763 46,955 31,287 68,741 MAR 68,081 201,188 64,572 195,264 37,630 123,782 35,471 97,422 30,451 77,406 29,101 97,842 APR 66,305 267,493 65,599 260,863 42,090 165,872 37,358 134,780 24,215 101,621 28,241 126,083 MAY 66,519 334,012 65,389 326,252 65,471 231,343 49,154 183,934 1,048 102,669 16,235 142,318 JUNE 69,015 403,027 66,869 393,121 33,513 264,856 32,027 215,961 35,502 138,171 34,842 177,160 JULY 66,698 469,725 65,213 458,334 45,519 310,375 61,676 277,637 21,179 159,350 3,537 180,697 AUG 66,946 536,671 67,406 525,740 116,784 427,159 55,989 333,626 (49,838)109,512 11,417 192,114 SEPT 65,922 591,662 36,867 370,493 29,055 221,169 OCT 65,419 657,081 58,167 428,660 7,252 228,421 NOV 67,537 724,618 35,881 464,541 31,656 260,077 DEC 66,097 790,715 56,969 521,510 9,128 269,205 2 0 1 8 2 0 1 72 0 1 72 0 1 7 (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 2013 2014 2015 2016 2017 2018 109,512 9/18/2018 Laserfiche/FI0914#3 This Month: August 2018 Page 3 of 6 SANITATION SERVICES FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 7 2 0 1 7 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 350,100 350,100 297,001 297,001 341,573 341,573 307,657 307,657 8,527 8,527 (10,656)(10,656) FEB 308,941 659,041 369,289 666,290 583,964 925,537 426,569 734,226 (275,023)(266,496)(57,280)(67,936) MAR 382,278 1,041,319 318,544 984,834 515,719 1,441,256 550,331 1,284,557 (133,441)(399,937)(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 (144,080)(544,017)109,112 (190,611) MAY 401,043 1,807,357 422,975 1,791,144 391,823 2,342,154 336,090 1,894,870 9,220 (534,797)86,885 (103,726) JUNE 415,778 2,223,135 398,859 2,190,003 274,152 2,616,306 263,985 2,158,855 141,626 (393,171)134,874 31,148 JULY 371,311 2,594,446 445,724 2,635,727 361,046 2,977,352 354,906 2,513,761 10,265 (382,906)90,818 121,966 AUG 442,206 3,036,652 326,119 2,961,846 290,491 3,267,843 270,560 2,784,321 151,715 (231,191) 55,559 177,525 SEPT 375,289 3,337,135 293,965 3,078,286 81,324 258,849 OCT 390,196 3,727,331 386,406 3,464,692 3,790 262,639 NOV 369,738 4,097,069 261,265 3,725,957 108,473 371,112 DEC 448,506 4,545,575 374,826 4,100,783 73,680 444,792 * Increased expense for 2018, as compared to the prior year, is related to refurbishment of the MRF compactor, lease purchse, and personnel costs. 2 0 1 8 2 0 1 8 2 0 1 8 (800,000) (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 2013 2014 2015 2016 2017 2018 (231,191) 9/18/2018 Laserfiche/FI0914#4 This Month: August 2018 Page 4 of 6 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 7 2 0 1 7 2 0 1 7 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 845,752 845,752 772,189 772,189 593,360 593,360 490,819 490,819 252,392 252,392 281,370 281,370 FEB 862,127 1,707,879 806,179 1,578,368 823,667 1,417,027 898,246 1,389,065 38,460 290,852 (92,067)189,303 MAR 773,554 2,481,433 751,851 2,330,219 1,206,490 2,623,517 1,114,109 2,503,174 (432,936)(142,084)(362,258)(172,955) APR 809,060 3,290,493 783,350 3,113,569 755,541 3,379,058 690,954 3,194,128 53,519 (88,565)92,396 (80,559) MAY 898,612 4,189,105 786,748 3,900,317 806,763 4,185,821 772,725 3,966,853 91,849 3,284 14,023 (66,536) JUNE 857,325 5,046,430 853,024 4,753,341 627,601 4,813,422 596,395 4,563,248 229,724 233,008 256,629 190,093 JULY 845,603 5,892,033 1,063,274 5,816,615 801,352 5,614,774 812,664 5,375,912 44,251 277,259 250,610 440,703 AUG 880,982 6,773,015 829,899 6,646,514 720,568 6,335,342 742,590 6,118,502 160,414 437,673 87,309 528,012 SEPT 959,045 7,605,559 665,983 6,784,485 293,062 821,074 OCT 795,242 8,400,801 830,908 7,615,393 (35,666)785,408 NOV 893,343 9,294,144 674,790 8,290,183 218,553 1,003,961 DEC 816,383 10,110,527 989,964 9,280,147 (173,581)830,380 2 0 1 8 2 0 1 8 2 0 1 8 (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 2013 2014 2015 2016 2017 2018 437,673 9/18/2018 OPERATING FUNDS &2017 2018 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 8 MO=66.6%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 105,512.93 110,326.94 61.45%179,546.00 69,219.06 ADMINISTRATION 182,032.82 259,256.12 67.37%384,803.00 125,546.88 INFORMATION TECHNOLOGY 153,358.68 166,186.96 57.23%290,404.00 124,217.04 JUSTICE & LAW 448,542.81 404,684.18 56.42%717,238.00 312,553.82 COMMUNITY PROMOTION 69,080.01 50,153.61 67.02%74,831.00 24,677.39 FINANCE 277,532.15 295,688.02 67.99%434,889.00 139,200.98 HUMAN RESOURCES 122,919.25 181,558.66 76.39%237,680.00 56,121.34 BUILDING STANDARDS 233,711.57 272,381.27 70.12%388,469.00 116,087.73 PLANNING & DEVELOPMENT 155,281.20 86,825.24 31.11%279,095.00 192,269.76 CITY BUILDINGS 184,315.35 227,643.82 69.66%326,797.00 99,153.18 PROPERTY MAINTENANCE 847,054.27 949,058.12 72.66%1,306,187.00 357,128.88 PUBLIC SAFETY 5,126,875.09 5,641,606.37 67.48%8,360,016.00 2,718,409.63 ENGINEERING 122,732.67 139,890.10 68.08%205,488.00 65,597.90 STREET LIGHTS & SIGNALS 265,496.83 296,971.90 61.15%485,670.00 188,698.10 STREETS & DRAINS 563,707.68 612,666.95 68.41%895,575.00 282,908.05 RECREATION 642,608.21 634,460.37 71.67%885,235.00 250,774.63 PARKS 399,215.38 313,542.12 59.01%531,320.00 217,777.88 COMMUNITY CENTER 106,896.42 105,589.69 60.33%175,016.00 69,426.31 TOURISM 133,574.10 196,591.85 49.89%394,021.00 197,429.15 RVP ACTIVITIES CENTER 565,088.71 550,048.92 69.31%793,603.00 243,554.08 GENERAL FUND TOTAL 10,705,536.13 11,495,131.21 66.27%17,345,883.00 5,850,751.79 STORMWATER UTILITY FUND (11): INFORMATION TECHNOLOGY 26,911.75 22,472.99 89.98%24,975.00 2,502.01 STORMWATER 305,116.51 403,021.41 53.58%752,198.00 349,176.59 HUMAN RESOURCES 1,597.79 1,664.57 0.21%780,796.00 779,131.43 STORMWATER FUND TOTAL 333,626.05 427,158.97 27.42%1,557,969.00 1,130,810.03 SANITATION FUND (13): INFORMATION TECHNOLOGY 44,493.36 46,279.84 75.89%60,985.00 14,705.16 SANITATION 1,578,159.83 1,730,627.43 67.79%2,553,111.00 822,483.57 RECYLING 999,486.72 1,268,178.26 75.43%1,681,237.00 413,058.74 HUMAN RESOURCES 7,007.89 8,273.94 45.11%18,341.00 10,067.06 TRANSFERS 155,173.00 214,484.00 100.00%214,484.00 0.00 SANITATION FUND TOTAL 2,784,320.80 3,267,843.47 72.17%4,528,158.00 1,260,314.53 O & M FUND (21): INFORMATION TECHNOLOGY 148,784.67 168,058.70 47.35%354,944.00 186,885.30 HUMAN RESOURCES 5,361.96 5,633.16 37.18%15,151.00 9,517.84 UTILITIES FINANCE 301,131.80 328,552.70 64.03%513,145.00 184,592.30 UTILITIES ADMINISTRATION 364,670.63 383,852.30 60.93%629,998.00 246,145.70 WATER OPERATIONS 560,558.32 549,906.82 68.94%797,612.00 247,705.18 WATER PRODUCTION 905,837.09 1,030,828.05 66.96%1,539,554.00 508,725.95 WASTEWATER OPERATIONS 2,157,625.09 2,111,932.69 54.81%3,853,413.00 1,741,480.31 TRANSFERS 383,395.00 478,767.00 100.00%478,767.00 0.00 O & M FUND TOTAL 4,827,364.56 5,057,531.42 61.81%8,182,584.00 3,125,052.58 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2017-2018) This Month: August 2018 9/18/2018 Laserfiche/FI0914#6 This Month: August 2018 Page 6 of 6 2013 2014 2015 2016 2017 2018 JAN 87,534,100 67,527,800 66,593,800 80,612,500 66,226,500 70,472,600 FEB 79,331,600 70,558,900 64,130,000 63,228,900 67,248,700 71,463,100 MAR 72,713,000 59,501,800 61,445,100 63,146,800 66,873,200 63,382,300 APR 83,519,700 66,036,800 69,821,800 75,996,300 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 JUN 143,562,600 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,485,366 110,592,200 128,369,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 OCT 126,482,300 102,242,400 96,463,100 101,300,800 95,226,700 NOV 103,845,700 82,984,300 70,516,400 109,895,800 99,336,800 DEC 74,656,800 78,370,200 73,391,300 83,710,800 78,090,700 TOTAL 1,223,300,366 1,075,596,300 1,069,307,444 1,166,945,834 1,073,446,900 666,968,600 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 2013 2014 2015 2016 2017 2018 99,041,700