Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12.31.2019 December
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF DECEMBER, 2019 Laserfiche/FI0914#1 This Month: December 2019 Page 1 of 6 REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 9 2 0 1 9 2 0 1 9 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 1,380,934 1,380,934 1,419,593 1,419,593 1,323,136 1,323,136 1,159,531 1,159,531 57,798 57,798 260,062 260,062 FEB 1,658,695 3,039,629 1,453,600 2,873,193 1,723,448 3,046,584 1,966,742 3,126,273 (64,753)(6,955)(513,142)(253,080) MAR 2,140,822 5,180,451 3,296,900 6,170,093 1,671,764 4,718,348 1,258,262 4,384,535 469,058 462,103 2,038,638 1,785,558 APR 4,324,373 9,504,824 3,513,803 9,683,896 1,789,807 6,508,155 1,387,553 5,772,088 2,534,566 2,996,669 2,126,250 3,911,808 MAY 1,429,984 10,934,808 808,100 10,491,996 1,330,968 7,839,123 1,526,539 7,298,627 99,016 3,095,685 (718,439)3,193,369 JUNE*4,529,490 15,464,298 2,694,795 13,186,791 1,347,319 9,186,442 1,274,638 8,573,265 3,182,171 6,277,856 1,420,157 4,613,526 JULY 988,789 16,453,087 2,345,871 15,532,662 1,780,636 10,967,078 1,598,431 10,171,696 (791,847)5,486,009 747,440 5,360,966 AUG 458,759 16,911,846 451,623 15,984,285 1,119,016 12,086,094 1,323,435 11,495,131 (660,257)4,825,752 (871,812)4,489,154 SEPT 391,025 17,302,871 277,541 16,261,826 1,417,657 13,503,751 1,243,857 12,738,988 (1,026,632)3,799,120 (966,316)3,522,838 OCT 788,019 18,090,890 608,769 16,870,595 1,862,149 15,365,900 1,674,070 14,413,058 (1,074,130)2,724,990 (1,065,301)2,457,537 NOV 405,966 18,496,856 654,900 17,525,495 1,308,683 16,674,583 1,218,159 15,631,217 (902,717)1,822,273 (563,259)1,894,278 DEC 704,984 19,201,840 657,439 18,182,934 1,911,174 18,585,757 1,594,930 17,226,147 (1,206,190)616,083 (937,491)956,787 * Business license payment received in June vs July for the prior year. 2 0 1 82 0 1 82 0 1 8 GENERAL FUND (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 2014 2015 2016 2017 2018 2019 616,083 Laserfiche/FI0914#2 This Month: December 2019 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 1 9 2 0 1 8 2 0 1 9 2 0 1 8 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 68,228 68,228 66,961 66,961 37,913 37,913 37,769 37,769 30,315 30,315 29,192 29,192 FEB 69,151 137,379 66,146 133,107 54,834 92,747 48,383 86,152 14,317 44,632 17,763 46,955 MAR 71,585 208,964 68,081 201,188 51,554 144,301 37,630 123,782 20,031 64,663 30,451 77,406 APR 68,835 277,799 66,305 267,493 86,041 230,342 42,090 165,872 (17,206)47,457 24,215 101,621 MAY 71,629 349,428 66,519 334,012 40,799 271,141 65,471 231,343 30,830 78,287 1,048 102,669 JUNE 71,391 420,819 69,015 403,027 54,476 325,617 33,513 264,856 16,915 95,202 35,502 138,171 JULY 68,676 489,495 66,698 469,725 72,149 397,766 45,519 310,375 (3,473)91,729 21,179 159,350 AUG 73,488 562,983 66,946 536,671 45,341 443,107 116,784 427,159 28,147 119,876 (49,838)109,512 SEPT 68,988 631,971 69,305 605,976 36,324 479,431 53,811 480,970 32,664 152,540 15,494 125,006 OCT 103,129 735,100 70,324 676,300 61,509 540,940 54,419 535,389 41,620 194,160 15,905 140,911 NOV 69,441 804,541 67,481 743,781 41,151 582,091 42,123 577,512 28,290 222,450 25,358 166,269 DEC 69,092 873,633 73,083 816,864 59,023 641,114 55,594 633,106 10,069 232,519 17,489 183,758 2 0 1 9 2 0 1 8 (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 2014 2015 2016 2017 2018 2019 232,519 Laserfiche/FI0914#3 This Month: December 2019 Page 3 of 6 SANITATION SERVICES 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 295,207 295,207 350,100 350,100 326,136 326,136 341,573 341,573 (30,929)(30,929)8,527 8,527 FEB 311,097 606,304 308,941 659,041 450,190 776,326 583,964 925,537 (139,093)(170,022)(275,023)(266,496) MAR 378,176 984,480 382,278 1,041,319 799,318 1,575,644 515,719 1,441,256 (421,142)(591,164)(133,441)(399,937) APR 371,525 1,356,005 364,995 1,406,314 355,212 1,930,856 509,075 1,950,331 16,313 (574,851)(144,080)(544,017) MAY 374,269 1,730,274 401,043 1,807,357 284,457 2,215,313 391,823 2,342,154 89,812 (485,039)9,220 (534,797) JUNE 396,621 2,126,895 415,778 2,223,135 291,850 2,507,163 274,152 2,616,306 104,771 (380,268)141,626 (393,171) JULY 379,385 2,506,280 371,311 2,594,446 353,125 2,860,288 361,046 2,977,352 26,260 (354,008)10,265 (382,906) AUG 379,666 2,885,946 442,206 3,036,652 325,048 3,185,336 290,491 3,267,843 54,618 (299,390)151,715 (231,191) SEPT 376,820 3,262,766 380,997 3,417,649 260,334 3,445,670 272,478 3,540,321 116,486 (182,904)108,519 (122,672) OCT 393,531 3,656,297 543,992 3,961,641 400,214 3,845,884 338,254 3,878,575 (6,683)(189,587)205,738 83,066 NOV 371,886 4,028,183 372,014 4,333,655 284,491 4,130,375 336,209 4,214,784 87,395 (102,192)35,805 118,871 DEC 601,501 4,629,684 511,567 4,845,222 380,484 4,510,859 348,179 4,562,963 221,017 118,825 163,388 282,259 2 0 1 9 2 0 1 9 2 0 1 9 (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 2014 2015 2016 2017 2018 2019 118,825 Laserfiche/FI0914#4 This Month: December 2019 Page 4 of 6 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 864,457 864,457 845,752 845,752 608,909 608,909 593,360 593,360 255,548 255,548 252,392 252,392 FEB 875,804 1,740,261 862,127 1,707,879 824,109 1,433,018 823,667 1,417,027 51,695 307,243 38,460 290,852 MAR 842,846 2,583,107 773,554 2,481,433 1,615,645 3,048,663 1,206,490 2,623,517 (772,799)(465,556)(432,936)(142,084) APR 779,818 3,362,925 809,060 3,290,493 740,015 3,788,678 755,541 3,379,058 39,803 (425,753)53,519 (88,565) MAY 843,658 4,206,583 898,612 4,189,105 726,733 4,515,411 806,763 4,185,821 116,925 (308,828)91,849 3,284 JUNE 953,968 5,160,551 857,325 5,046,430 726,445 5,241,856 627,601 4,813,422 227,523 (81,305)229,724 233,008 JULY 912,733 6,073,284 845,603 5,892,033 863,813 6,105,669 801,352 5,614,774 48,920 (32,385)44,251 277,259 AUG 976,601 7,049,885 880,982 6,773,015 781,031 6,886,700 720,568 6,335,342 195,570 163,185 160,414 437,673 SEPT 909,931 7,959,816 876,669 7,649,684 783,247 7,669,947 634,237 6,969,579 126,684 289,869 242,432 680,105 OCT 914,188 8,874,004 889,193 8,538,877 971,659 8,641,606 754,439 7,724,018 (57,471)232,398 134,754 814,859 NOV 878,063 9,752,067 865,278 9,404,155 613,391 9,254,997 636,484 8,360,502 264,672 497,070 228,794 1,043,653 DEC 842,825 10,594,892 845,220 10,249,375 1,028,292 10,283,289 1,070,026 9,430,528 (185,467) 311,603 (224,806) 818,847 2 0 1 9 2 0 1 9 2 0 1 9 2 0 1 82 0 1 82 0 1 8 (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 2014 2015 2016 2017 2018 2019 311,603 OPERATING FUNDS &2018 2019 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 12 MO=100%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 177,045.81 165,935.45 89.57%185,261.00 19,325.55 ADMINISTRATION 385,333.98 424,377.41 77.53%547,337.00 122,959.59 INFORMATION TECHNOLOGY 265,941.43 786,274.94 100.80%780,057.00 -6,217.94 JUSTICE & LAW 651,575.06 742,240.78 93.08%797,399.00 55,158.22 COMMUNITY PROMOTION 72,051.89 75,712.40 102.06%74,187.00 -1,525.40 FINANCE 437,328.99 410,727.49 93.55%439,038.00 28,310.51 HUMAN RESOURCES 277,464.21 259,376.25 86.21%300,851.00 41,474.75 BUILDING STANDARDS 438,474.73 393,047.96 91.02%431,828.00 38,780.04 PLANNING & DEVELOPMENT 177,750.06 343,039.08 83.06%412,999.00 69,959.92 CITY BUILDINGS 321,658.51 291,755.21 77.25%377,666.00 85,910.79 PROPERTY MAINTENANCE 1,322,897.76 1,403,896.44 101.07%1,389,086.00 -14,810.44 PUBLIC SAFETY 8,420,971.49 8,773,351.30 102.06%8,596,074.00 -177,277.30 ENGINEERING 207,282.93 237,741.74 96.84%245,507.00 7,765.26 STREET LIGHTS & SIGNALS 483,900.05 475,839.11 97.52%487,952.00 12,112.89 STREETS & DRAINS 908,826.12 920,708.64 98.90%930,912.00 10,203.36 RECREATION 901,840.16 1,009,397.98 105.35%958,177.00 -51,220.98 PARKS 453,180.17 409,531.54 88.13%464,709.00 55,177.46 COMMUNITY CENTER 163,140.67 181,478.31 103.07%176,079.00 -5,399.31 TOURISM 398,889.61 383,572.18 96.54%397,330.00 13,757.82 RVP ACTIVITIES CENTER 760,593.54 897,753.03 113.36%791,919.00 -105,834.03 GENERAL FUND TOTAL 17,226,147.17 18,585,757.24 98.94%18,784,368.00 198,610.76 STORMWATER UTILITY FUND (11): INFORMATION TECHNOLOGY 23,050.53 0.00 0.00%0.00 0.00 STORMWATER 607,017.51 613,384.52 79.22%774,254.00 160,869.48 HUMAN RESOURCES 3,037.99 0.00 0.00%0.00 0.00 TRANSFERS 0.00 27,729.00 100.00%27,729.00 0.00 STORMWATER FUND TOTAL 633,106.03 641,113.52 79.94%801,983.00 160,869.48 SANITATION FUND (13): INFORMATION TECHNOLOGY 59,468.14 6,253.09 99.94%6,257.00 3.91 SANITATION 2,563,250.33 2,554,515.58 100.90%2,531,820.00 -22,695.58 RECYLING 1,711,924.07 1,587,640.03 100.88%1,573,817.00 -13,823.03 HUMAN RESOURCES 13,836.12 0.00 0.00%0.00 0.00 TRANSFERS 214,484.00 362,450.00 100.00%362,450.00 0.00 SANITATION FUND TOTAL 4,562,962.66 4,510,858.70 100.82%4,474,344.00 -36,514.70 O & M FUND (21): INFORMATION TECHNOLOGY 303,874.60 4,982.00 100.00%4,982.00 0.00 HUMAN RESOURCES 10,856.29 0.00 0.00%0.00 0.00 UTILITIES FINANCE 495,336.81 557,191.89 105.74%526,923.00 -30,268.89 UTILITIES ADMINISTRATION 570,554.80 475,394.07 92.12%516,078.00 40,683.93 WATER OPERATIONS 743,771.17 774,833.31 94.34%821,363.00 46,529.69 WATER PRODUCTION 1,432,345.75 1,499,591.22 93.17%1,609,557.00 109,965.78 WASTEWATER OPERATIONS 3,516,293.91 4,478,683.65 104.70%4,277,817.00 -200,866.65 TRANSFERS 478,767.00 740,173.00 100.00%740,173.00 0.00 O & M FUND TOTAL 7,551,800.33 8,530,849.14 100.40%8,496,893.00 -33,956.14 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2018-2019) This Month: December 2019 Laserfiche/FI0914#6 This Month: December 2019 Page 6 of 6 2014 2015 2016 2017 2018 2019 JAN 67,527,800 66,593,800 80,612,500 66,226,500 70,472,600 68,059,100 FEB 70,558,900 64,130,000 63,228,900 67,248,700 71,463,100 66,272,900 MAR 59,501,800 61,445,100 63,146,800 66,873,200 63,382,300 61,423,300 APR 66,036,800 69,821,800 75,996,300 76,591,700 67,096,100 75,454,200 MAY 87,006,600 78,135,500 91,865,700 95,937,000 92,208,400 88,165,300 JUN*102,185,100 114,293,800 117,019,167 110,442,100 97,377,300 129,536,200 JUL*119,881,100 130,932,600 127,708,867 104,063,100 105,927,100 129,809,800 AUG 110,592,200 128,369,800 123,927,500 103,060,200 99,041,700 135,105,800 SEP 128,709,100 115,214,244 128,532,700 110,350,200 103,480,400 116,113,900 OCT 102,242,400 96,463,100 101,300,800 95,226,700 105,219,800 123,284,600 NOV 82,984,300 70,516,400 109,895,800 99,336,800 82,158,600 103,718,900 DEC 78,370,200 73,391,300 83,710,800 78,090,700 69,352,300 71,605,400 TOTAL 1,075,596,300 1,069,307,444 1,166,945,834 1,073,446,900 1,027,179,700 1,168,549,400 *Increase primarily related to a spike in residential watering and decreased rainfall. 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 2014 2015 2016 2017 2018 2019 71,605,400