Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12.31.2020 December
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF DECEMBER, 2020 Laserfiche/FI0914#1 This Month: December 2020 Page 1 of 6 REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 2 0 2 0 2 0 2 0 2 0 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 1,277,303 1,277,303 1,380,934 1,380,934 1,451,999 1,451,999 1,323,136 1,323,136 (174,696)(174,696)57,798 57,798 FEB 1,868,911 3,146,214 1,658,695 3,039,629 1,849,717 3,301,716 1,723,448 3,046,584 19,194 (155,502)(64,753)(6,955) MAR 2,909,787 6,056,001 2,140,822 5,180,451 1,690,051 4,991,767 1,671,764 4,718,348 1,219,736 1,064,234 469,058 462,103 APR 3,341,492 9,397,493 4,324,373 9,504,824 1,492,290 6,484,057 1,789,807 6,508,155 1,849,202 2,913,436 2,534,566 2,996,669 MAY 1,697,482 11,094,975 1,429,984 10,934,808 1,121,327 7,605,384 1,330,968 7,839,123 576,155 3,489,591 99,016 3,095,685 JUNE*2,605,814 13,700,789 4,529,490 15,464,298 1,120,594 8,725,978 1,347,319 9,186,442 1,485,220 4,974,811 3,182,171 6,277,856 JULY 1,875,937 15,576,726 988,789 16,453,087 1,674,077 10,400,055 1,780,636 10,967,078 201,860 5,176,671 (791,847)5,486,009 AUG 805,878 16,382,604 458,759 16,911,846 1,236,097 11,636,152 1,119,016 12,086,094 (430,219)4,746,452 (660,257)4,825,752 SEPT 294,944 16,677,548 391,025 17,302,871 1,680,737 13,316,889 1,417,657 13,503,751 (1,385,793)3,360,659 (1,026,632)3,799,120 OCT 642,151 17,319,699 788,019 18,090,890 1,263,754 14,580,643 1,862,149 15,365,900 (621,603)2,739,056 (1,074,130)2,724,990 NOV 500,591 17,820,290 405,966 18,496,856 1,215,467 15,796,110 1,308,683 16,674,583 (714,876)2,024,180 (902,717)1,822,273 DEC 742,501 18,562,791 704,984 19,201,840 1,758,958 17,555,068 1,911,174 18,585,757 (1,016,457)1,007,723 (1,206,190)616,083 * Business license payment received in July vs June for the prior year. 2 0 1 92 0 1 92 0 1 9 GENERAL FUND -1000000 0 1000000 2000000 3000000 4000000 5000000 6000000 7000000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2019 2020 1,007,723 Laserfiche/FI0914#2 This Month: December 2020 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 2 0 2 0 1 9 2 0 2 0 2 0 1 9 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 73,049 73,049 68,228 68,228 40,202 40,202 37,913 37,913 32,847 32,847 30,315 30,315 FEB 69,277 142,326 69,151 137,379 71,122 111,324 54,834 92,747 (1,845)31,002 14,317 44,632 MAR 73,217 215,543 71,585 208,964 84,033 195,357 51,554 144,301 (10,816)20,186 20,031 64,663 APR 74,472 290,015 68,835 277,799 45,777 241,134 86,041 230,342 28,695 48,881 (17,206)47,457 MAY 69,082 359,097 71,629 349,428 43,437 284,571 40,799 271,141 25,645 74,526 30,830 78,287 JUNE 71,436 430,533 71,391 420,819 56,220 340,791 54,476 325,617 15,216 89,742 16,915 95,202 JULY 69,375 499,908 68,676 489,495 46,844 387,635 72,149 397,766 22,531 112,273 (3,473)91,729 AUG 70,457 570,365 73,488 562,983 50,075 437,710 45,341 443,107 20,382 132,655 28,147 119,876 SEPT 69,401 639,766 68,988 631,971 57,927 495,637 36,324 479,431 11,474 144,129 32,664 152,540 OCT*71,465 711,231 103,129 735,100 406,427 902,064 61,509 540,940 (334,962)(190,833)41,620 194,160 NOV*373,232 1,084,463 69,441 804,541 345,035 1,247,099 41,151 582,091 28,197 (162,636)28,290 222,450 DEC*69,831 1,154,294 69,092 873,633 268,146 1,515,245 59,023 641,114 (198,315)(360,951)10,069 232,519 * See Resolution 2020-15 related to the Lynnhurst Drainage Improvement Project. 2 0 2 0 2 0 1 9 (400,000) (300,000) (200,000) (100,000) 0 100,000 200,000 300,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2019 2020 (360,951)* Laserfiche/FI0914#3 This Month: December 2020 Page 3 of 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 296,442 296,442 295,207 295,207 308,448 308,448 326,136 326,136 (12,006)(12,006)(30,929)(30,929) FEB 304,511 600,953 311,097 606,304 522,555 831,003 450,190 776,326 (218,044)(230,050)(139,093)(170,022) MAR 409,700 1,010,653 378,176 984,480 729,600 1,560,603 799,318 1,575,644 (319,900)(549,950)(421,142)(591,164) APR 420,588 1,431,241 371,525 1,356,005 403,820 1,964,423 355,212 1,930,856 16,768 (533,182)16,313 (574,851) MAY 429,191 1,860,432 374,269 1,730,274 309,095 2,273,518 284,457 2,215,313 120,096 (413,086)89,812 (485,039) JUNE 437,092 2,297,524 396,621 2,126,895 305,929 2,579,447 291,850 2,507,163 131,163 (281,923)104,771 (380,268) JULY 376,272 2,673,796 379,385 2,506,280 419,024 2,998,471 353,125 2,860,288 (42,752)(324,675)26,260 (354,008) AUG 429,821 3,103,617 379,666 2,885,946 286,987 3,285,458 325,048 3,185,336 142,834 (181,841)54,618 (299,390) SEPT*542,566 3,646,183 376,820 3,262,766 361,781 3,647,239 260,334 3,445,670 180,785 (1,056)116,486 (182,904) OCT 320,576 3,966,759 393,531 3,656,297 281,611 3,928,850 400,214 3,845,884 38,965 37,909 (6,683)(189,587) NOV*498,822 4,465,581 371,886 4,028,183 277,235 4,206,085 284,491 4,130,375 221,587 259,496 87,395 (102,192) DEC 553,622 5,019,203 601,501 4,629,684 397,821 4,603,906 380,484 4,510,859 155,801 415,297 221,017 118,825 *Payment for tipping fees received earlier than normal. SANITATION SERVICES FUND 2 0 1 92 0 2 0 2 0 2 0 2 0 2 02 0 1 9 2 0 1 9 REVENUES EXPENSES SURPLUS (DEFICIT) (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 5yr average 2019 2020 415,297 Laserfiche/FI0914#4 This Month: December 2020 Page 4 of 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 904,302 904,302 864,457 864,457 571,996 571,996 608,909 608,909 332,306 332,306 255,548 255,548 FEB 893,156 1,797,458 875,804 1,740,261 874,011 1,446,007 824,109 1,433,018 19,145 351,451 51,695 307,243 MAR 909,561 2,707,019 842,846 2,583,107 1,595,793 3,041,800 1,615,645 3,048,663 (686,232)(334,781)(772,799)(465,556) APR 889,859 3,596,878 779,818 3,362,925 989,924 4,031,724 740,015 3,788,678 (100,065)(434,846)39,803 (425,753) MAY 892,255 4,489,133 843,658 4,206,583 706,329 4,738,053 726,733 4,515,411 185,926 (248,920)116,925 (308,828) JUNE 966,757 5,455,890 953,968 5,160,551 651,136 5,389,189 726,445 5,241,856 315,621 66,701 227,523 (81,305) JULY 956,362 6,412,252 912,733 6,073,284 790,149 6,179,338 863,813 6,105,669 166,213 232,914 48,920 (32,385) AUG 983,776 7,396,028 976,601 7,049,885 731,963 6,911,301 781,031 6,886,700 251,813 484,727 195,570 163,185 SEPT 939,065 8,335,093 909,931 7,959,816 853,767 7,765,068 783,247 7,669,947 85,298 570,025 126,684 289,869 OCT 941,184 9,276,277 914,188 8,874,004 800,405 8,565,473 971,659 8,641,606 140,779 710,804 (57,471)232,398 NOV 903,963 10,180,240 878,063 9,752,067 718,800 9,284,273 613,391 9,254,997 185,163 895,967 264,672 497,070 DEC 970,113 11,150,353 842,825 10,594,892 1,212,374 10,496,647 1,028,292 10,283,289 (242,261) 653,706 (185,467) 311,603 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) 2 0 2 0 2 0 2 0 2 0 2 0 2 0 1 92 0 1 92 0 1 9 (600,000) (400,000) (200,000) - 200,000 400,000 600,000 800,000 1,000,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2019 2020 653,706 OPERATING FUNDS &2019 2020 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 12 MO=100%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 165,935.45 180,482.06 99.34%181,678.00 1,195.94 ADMINISTRATION 424,377.41 334,407.08 80.55%415,140.00 80,732.92 INFORMATION TECHNOLOGY 786,274.94 735,298.58 97.85%751,467.00 16,168.42 JUSTICE & LAW 742,240.78 688,114.86 84.73%812,170.00 124,055.14 COMMUNITY PROMOTION 75,712.40 57,554.69 87.08%66,097.00 8,542.31 FINANCE 410,727.49 467,480.57 103.90%449,917.00 -17,563.57 HUMAN RESOURCES 259,376.25 240,730.56 94.94%253,572.00 12,841.44 BUILDING STANDARDS 393,047.96 400,126.32 97.02%412,429.00 12,302.68 PLANNING & DEVELOPMENT 343,039.08 436,546.48 95.71%456,129.00 19,582.52 CITY BUILDINGS 291,755.21 308,385.63 101.09%305,053.00 -3,332.63 PROPERTY MAINTENANCE 1,403,896.44 1,484,819.17 102.11%1,454,173.00 -30,646.17 PUBLIC SAFETY 8,773,351.30 8,478,545.09 97.27%8,716,761.00 238,215.91 ENGINEERING 237,741.74 242,044.64 96.22%251,551.00 9,506.36 STREET LIGHTS & SIGNALS 475,839.11 469,101.63 98.80%474,818.00 5,716.37 STREETS & DRAINS 920,708.64 863,868.23 93.81%920,849.00 56,980.77 RECREATION 1,009,397.98 864,900.62 97.06%891,062.00 26,161.38 PARKS 409,531.54 361,996.66 68.29%530,116.00 168,119.34 COMMUNITY CENTER 181,478.31 163,577.24 108.10%151,316.00 -12,261.24 TOURISM 383,572.18 189,541.93 75.89%249,750.00 60,208.07 RVP ACTIVITIES CENTER 897,753.03 587,546.10 93.16%630,685.00 43,138.90 GENERAL FUND TOTAL 18,585,757.24 17,555,068.14 95.54%18,374,733.00 819,664.86 STORMWATER UTILITY FUND (11): STORMWATER 613,384.52 1,487,092.38 136.25%1,091,472.00 -395,620.38 TRANSFERS 27,729.00 28,153.00 100.00%28,153.00 0.00 STORMWATER FUND TOTAL 641,113.52 1,515,245.38 135.34%1,119,625.00 -395,620.38 SANITATION FUND (13): INFORMATION TECHNOLOGY 6,253.09 6,253.09 99.94%6,257.00 3.91 SANITATION 2,554,515.58 2,664,442.78 100.52%2,650,534.00 -13,908.78 RECYLING 1,587,640.03 1,557,234.05 96.56%1,612,652.00 55,417.95 TRANSFERS 362,450.00 375,976.00 100.00%375,976.00 0.00 SANITATION FUND TOTAL 4,510,858.70 4,603,905.92 99.11%4,645,419.00 41,513.08 O & M FUND (21): INFORMATION TECHNOLOGY 4,982.00 4,982.00 100.00%4,982.00 0.00 UTILITIES FINANCE 557,191.89 592,183.41 103.90%569,943.00 -22,240.41 UTILITIES ADMINISTRATION 475,394.07 494,907.80 92.01%537,860.00 42,952.20 WATER OPERATIONS 774,833.31 713,578.72 91.77%777,551.00 63,972.28 WATER PRODUCTION 1,499,591.22 1,564,182.27 97.37%1,606,432.00 42,249.73 WASTEWATER OPERATIONS 4,478,683.65 4,960,803.58 108.74%4,562,201.00 -398,602.58 TRANSFERS 740,173.00 798,831.00 100.00%798,831.00 0.00 O & M FUND TOTAL 8,530,849.14 9,129,468.78 103.07%8,857,800.00 -271,668.78 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2019-2020) This Month: December 2020 Laserfiche/FI0914#6 This Month: December 2020 Page 6 of 6 2015 2016 2017 2018 2019 2020 JAN 66,593,800 80,612,500 66,226,500 70,472,600 68,059,100 73,297,800 FEB 64,130,000 63,228,900 67,248,700 71,463,100 66,272,900 68,291,100 MAR 61,445,100 63,146,800 66,873,200 63,382,300 61,423,300 69,352,900 APR 69,821,800 75,996,300 76,591,700 67,096,100 75,454,200 76,253,900 MAY 78,135,500 91,865,700 95,937,000 92,208,400 88,165,300 99,465,100 JUN 114,293,800 117,019,167 110,442,100 97,377,300 129,536,200 125,121,100 JUL 130,932,600 127,708,867 104,063,100 105,927,100 129,809,800 129,776,700 AUG 128,369,800 123,927,500 103,060,200 99,041,700 135,105,800 132,624,000 SEP 115,214,244 128,532,700 110,350,200 103,480,400 116,113,900 119,071,431 OCT 96,463,100 101,300,800 95,226,700 105,219,800 123,284,600 116,900,300 NOV 70,516,400 109,895,800 99,336,800 82,158,600 103,718,900 99,996,700 DEC 73,391,300 83,710,800 78,090,700 69,352,300 71,605,400 89,801,400 TOTAL 1,069,307,444 1,166,945,834 1,073,446,900 1,027,179,700 1,168,549,400 1,199,952,431 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 5yr average 2019 2020 89,801,400