Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05.31.2020 May
NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES, DIRECTOR FOR THE MONTH OF MAY, 2020 Laserfiche/FI0914#1 This Month: May 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*4,529,490 15,464,298 1,347,319 9,186,442 3,182,171 6,277,856 JULY 988,789 16,453,087 1,780,636 10,967,078 (791,847)5,486,009 AUG 458,759 16,911,846 1,119,016 12,086,094 (660,257)4,825,752 SEPT 391,025 17,302,871 1,417,657 13,503,751 (1,026,632)3,799,120 OCT 788,019 18,090,890 1,862,149 15,365,900 (1,074,130)2,724,990 NOV 405,966 18,496,856 1,308,683 16,674,583 (902,717)1,822,273 DEC 704,984 19,201,840 1,911,174 18,585,757 (1,206,190)616,083 * Business license payment received in June vs July for the prior year. 2 0 1 92 0 1 92 0 1 9 GENERAL FUND (1,000,000) - 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 5yr average 2019 2020 3,489,591 Laserfiche/FI0914#2 This Month: May 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,391 420,819 54,476 325,617 16,915 95,202 JULY 68,676 489,495 72,149 397,766 (3,473)91,729 AUG 73,488 562,983 45,341 443,107 28,147 119,876 SEPT 68,988 631,971 36,324 479,431 32,664 152,540 OCT 103,129 735,100 61,509 540,940 41,620 194,160 NOV 69,441 804,541 41,151 582,091 28,290 222,450 DEC 69,092 873,633 59,023 641,114 10,069 232,519 2 0 2 0 2 0 1 9 0 50,000 100,000 150,000 200,000 250,000 300,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2019 2020 74,526 Laserfiche/FI0914#3 This Month: May 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 396,621 2,126,895 291,850 2,507,163 104,771 (380,268) JULY 379,385 2,506,280 353,125 2,860,288 26,260 (354,008) AUG 379,666 2,885,946 325,048 3,185,336 54,618 (299,390) SEPT 376,820 3,262,766 260,334 3,445,670 116,486 (182,904) OCT 393,531 3,656,297 400,214 3,845,884 (6,683)(189,587) NOV 371,886 4,028,183 284,491 4,130,375 87,395 (102,192) DEC 601,501 4,629,684 380,484 4,510,859 221,017 118,825 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) (700,000) (600,000) (500,000) (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 (413,086) Laserfiche/FI0914#4 This Month: May 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 953,968 5,160,551 726,445 5,241,856 227,523 (81,305) JULY 912,733 6,073,284 863,813 6,105,669 48,920 (32,385) AUG 976,601 7,049,885 781,031 6,886,700 195,570 163,185 SEPT 909,931 7,959,816 783,247 7,669,947 126,684 289,869 OCT 914,188 8,874,004 971,659 8,641,606 (57,471)232,398 NOV 878,063 9,752,067 613,391 9,254,997 264,672 497,070 DEC 842,825 10,594,892 1,028,292 10,283,289 (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 -600000 -400000 -200000 0 200000 400000 600000 800000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2019 2020 (248,920) OPERATING FUNDS &2019 2020 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 5 MO=41.67%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 62,941.77 69,667.72 38.35%181,678.00 112,010.28 ADMINISTRATION 115,098.65 107,745.62 21.41%503,360.00 395,614.38 INFORMATION TECHNOLOGY 288,564.45 329,978.10 42.58%775,043.00 445,064.90 JUSTICE & LAW 301,093.24 197,793.10 24.35%812,170.00 614,376.90 COMMUNITY PROMOTION 30,700.56 40,051.45 60.59%66,097.00 26,045.55 FINANCE 177,579.91 215,355.88 47.73%451,239.00 235,883.12 HUMAN RESOURCES 103,440.38 91,372.59 35.95%254,200.00 162,827.41 BUILDING STANDARDS 164,646.87 169,223.04 38.22%442,726.00 273,502.96 PLANNING & DEVELOPMENT 142,415.73 165,222.94 36.13%457,295.00 292,072.06 CITY BUILDINGS 99,231.81 122,480.89 39.50%310,053.00 187,572.11 PROPERTY MAINTENANCE 660,225.19 670,454.25 45.99%1,457,929.00 787,474.75 PUBLIC SAFETY 3,950,632.81 3,843,131.25 43.46%8,843,667.00 5,000,535.75 ENGINEERING 101,617.08 105,669.53 41.88%252,334.00 146,664.47 STREET LIGHTS & SIGNALS 171,026.17 131,150.06 27.62%474,818.00 343,667.94 STREETS & DRAINS 427,281.66 392,942.13 42.58%922,937.00 529,994.87 RECREATION 445,036.44 410,231.67 45.07%910,228.00 499,996.33 PARKS 177,838.01 151,485.22 25.88%585,244.00 433,758.78 COMMUNITY CENTER 64,349.78 64,811.45 38.31%169,165.00 104,353.55 TOURISM 92,966.86 88,276.73 21.65%407,681.00 319,404.27 RVP ACTIVITIES CENTER 262,435.18 238,340.47 28.48%837,004.00 598,663.53 GENERAL FUND TOTAL 7,839,122.55 7,605,384.09 39.79%19,114,868.00 11,509,483.91 STORMWATER UTILITY FUND (11): STORMWATER 243,411.96 256,418.48 23.49%1,091,472.00 835,053.52 TRANSFERS 27,729.00 28,153.00 100.00%28,153.00 0.00 STORMWATER FUND TOTAL 271,140.96 284,571.48 25.42%1,119,625.00 835,053.52 SANITATION FUND (13): INFORMATION TECHNOLOGY 6,253.09 6,253.09 99.94%6,257.00 3.91 SANITATION 1,167,448.09 1,172,451.61 44.23%2,650,534.00 1,478,082.39 RECYLING 679,162.01 718,837.47 44.57%1,612,652.00 893,814.53 TRANSFERS 362,450.00 375,976.00 100.00%375,976.00 0.00 SANITATION FUND TOTAL 2,215,313.19 2,273,518.17 48.94%4,645,419.00 2,371,900.83 O & M FUND (21): INFORMATION TECHNOLOGY 4,982.00 4,982.00 100.00%4,982.00 0.00 UTILITIES FINANCE 232,214.08 246,883.97 43.32%569,943.00 323,059.03 UTILITIES ADMINISTRATION 208,025.68 224,125.85 41.67%537,860.00 313,734.15 WATER OPERATIONS 351,945.00 294,942.60 37.93%777,551.00 482,608.40 WATER PRODUCTION 631,211.65 695,220.56 43.28%1,606,432.00 911,211.44 WASTEWATER OPERATIONS 1,597,004.17 1,922,581.79 42.14%4,562,201.00 2,639,619.21 TRANSFERS 740,173.00 798,831.00 100.00%798,831.00 0.00 O & M FUND TOTAL 3,765,555.58 4,187,567.77 47.28%8,857,800.00 4,670,232.23 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2019-2020) This Month: May 2020 Laserfiche/FI0914#6 This Month: May 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 JUL*130,932,600 127,708,867 104,063,100 105,927,100 129,809,800 AUG 128,369,800 123,927,500 103,060,200 99,041,700 135,105,800 SEP 115,214,244 128,532,700 110,350,200 103,480,400 116,113,900 OCT 96,463,100 101,300,800 95,226,700 105,219,800 123,284,600 NOV 70,516,400 109,895,800 99,336,800 82,158,600 103,718,900 DEC 73,391,300 83,710,800 78,090,700 69,352,300 71,605,400 TOTAL 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 5yr average 2019 2020 99,465,100