Loading...
04/22CITY OF NORTH AUGUSTA Monthly Departmental Reports April 2022 NORTH AUGUSTA FINANCE DEPARTMENT CAMMIE T. HAYES CHIEF FINANCAL OFFICER FOR THE MONTH OF APRIL 2022 Laserfiche/FI0914#1 This Month: April 2022 Page 1 of 6 REVENUES EXPENSES SURPLUS (DEFICIT) Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 331,467 331,467 285,912 285,912 1,356,165 1,356,165 1,227,455 1,227,455 (1,024,698)(1,024,698)(941,543)(941,543) FEB 1,881,266 2,212,733 1,173,571 1,459,483 2,015,527 3,371,692 1,469,895 2,697,350 (134,261)(1,158,959)(296,324)(1,237,867) MAR *3,103,105 5,315,838 5,343,804 6,803,287 1,997,891 5,369,583 2,091,233 4,788,583 1,105,214 (53,745)3,252,571 2,014,704 APR *5,133,403 10,449,241 3,618,498 10,421,785 1,486,970 6,856,553 1,427,588 6,216,171 3,646,433 3,592,688 2,190,910 4,205,614 MAY 1,566,372 11,988,157 1,345,418 7,561,589 220,954 4,426,568 JUNE 4,211,278 16,199,435 1,251,782 8,813,371 2,959,496 7,386,064 JULY 1,726,713 17,926,148 1,677,531 10,490,902 49,182 7,435,246 AUG 645,216 18,571,364 2,013,611 12,504,513 (1,368,395)6,066,851 SEPT 360,130 18,931,494 1,214,249 13,718,762 (854,119)5,212,732 OCT 483,545 19,415,039 1,349,666 15,068,428 (866,121)4,346,611 NOV 499,497 19,914,536 1,355,410 16,423,838 (855,913)3,490,698 DEC 744,288 20,658,824 1,873,634 18,297,472 (1,129,346)2,361,352 * Mortgage Company tax payments were posted in April vs March of the previous year. 202120212021 GENERAL FUND 2022 20222022 (2,000,000) (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 8,000,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2021 2022 3,592,688 Laserfiche/FI0914#2 This Month: April 2022 Page 2 of 6 STORMWATER UTILITY FUND REVENUES EXPENSES SURPLUS (DEFICIT) Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 71,624 71,624 69,198 69,198 50,163 50,163 45,763 45,763 21,461 21,461 23,435 23,435 FEB 71,071 142,695 69,595 138,793 95,814 145,977 85,693 131,456 (24,743)(3,282)(16,098)7,337 MAR 74,685 217,380 72,298 211,091 103,863 249,840 109,010 240,466 (29,178)(32,460)(36,712)(29,375) APR 72,883 290,263 74,075 285,166 53,393 303,233 42,672 283,138 19,490 (12,970)31,403 2,028 MAY 74,885 360,051 46,915 330,053 27,970 29,998 JUNE 73,429 433,480 52,818 382,871 20,611 50,609 JULY 70,129 503,609 58,150 441,021 11,979 62,588 AUG 72,059 575,668 62,882 503,903 9,177 71,765 SEPT 71,465 647,133 97,746 601,649 (26,281)45,484 OCT 72,567 719,700 44,726 646,375 27,841 73,325 NOV 71,956 791,656 48,919 695,294 23,037 96,362 DEC 70,882 862,538 58,535 753,829 12,347 108,709 202120222021202220212022 (50,000) 0 50,000 100,000 150,000 200,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2021 2022 (12,970) Lynnhurst Drainage Project Laserfiche/FI0914#3 This Month: April 2022 Page 3 of 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 329,729 329,729 296,066 296,066 291,170 291,170 291,136 291,136 38,559 38,559 4,930 4,930 FEB 363,420 693,149 335,101 631,167 636,486 927,657 531,142 822,278 (273,066)(234,508)(196,041)(191,111) MAR 331,807 1,024,956 436,550 1,067,717 729,267 1,656,924 961,771 1,784,049 (397,460)(631,968)(525,221)(716,332) APR 330,660 1,355,616 534,965 1,602,682 269,090 1,926,014 315,020 2,099,069 61,570 (570,398) 219,945 (496,387) MAY 325,938 1,928,620 302,919 2,401,988 23,019 (473,368) JUNE 523,260 2,451,880 417,946 2,819,934 105,314 (368,054) JULY 335,190 2,787,070 349,852 3,169,786 (14,662)(382,716) AUG 543,397 3,330,467 399,107 3,568,893 144,290 (238,426) SEPT 334,275 3,664,742 275,923 3,844,816 58,352 (180,074) OCT 452,080 4,116,822 267,059 4,111,875 185,021 4,947 NOV 475,383 4,592,205 254,772 4,366,647 220,611 225,558 DEC 399,086 4,991,291 322,036 4,688,683 77,050 302,608 SANITATION SERVICES FUND 202120222022202220212021 REVENUES EXPENSES SURPLUS (DEFICIT) (800,000) (600,000) (400,000) (200,000) 0 200,000 400,000 JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YEAR-TO-DATE BALANCE 5yr average 2021 2022 (570,398) Laserfiche/FI0914#4 This Month: April 2022 Page 4 of 6 Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD Monthly YTD JAN 947,293 947,293 906,303 906,303 612,289 612,289 531,399 531,399 335,004 335,004 374,904 374,904 FEB *961,985 1,909,278 888,369 1,794,672 1,069,091 1,681,380 846,690 1,378,089 (107,106)227,898 41,679 416,583 MAR 941,228 2,850,506 943,703 2,738,375 1,780,285 3,461,665 1,852,628 3,230,717 (839,057)(611,159)(908,925)(492,342) APR 959,699 3,810,205 957,475 3,695,850 942,994 4,404,659 835,746 4,066,463 16,705 (594,454) 121,729 (370,613) MAY 998,247 4,694,097 775,048 4,841,511 223,199 (147,414) JUNE 987,456 5,681,553 686,097 5,527,608 301,359 153,945 JULY 1,015,807 6,697,360 852,436 6,380,044 163,371 317,316 AUG 1,030,950 7,728,310 844,162 7,224,206 186,788 504,104 SEPT 1,025,177 8,753,487 748,492 7,972,698 276,685 780,789 OCT 973,337 9,726,824 867,462 8,840,160 105,875 886,664 NOV 954,980 10,681,804 882,736 9,722,896 72,244 958,908 DEC 918,277 11,600,081 1,212,309 10,935,205 (294,032)664,876 WATERWORKS & SEWER SYSTEM REVENUES EXPENSES SURPLUS (DEFICIT) * 2021 Bond refinancing modified the principal due date 2022 2022 2022 202120212021 (800,000) (600,000) (400,000) (200,000) - 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 5yr average 2021 2022 (594,454) OPERATING FUNDS &2021 2022 YTD PERCENT ANNUAL DEPARTMENTS EXPENDED EXPENDED 4 MO 33.33%BUDGET BALANCE GENERAL FUND (10): CITY COUNCIL 58,031.00 57,249.73 30.13%189,979.00 132,729.27 ADMINISTRATION 149,347.32 173,228.87 31.16%555,935.00 382,706.13 INFORMATION TECHNOLOGY 204,792.16 241,983.32 30.59%791,140.00 549,156.68 JUSTICE & LAW 203,397.71 138,247.50 16.77%824,526.00 686,278.50 COMMUNITY PROMOTION 9,237.09 14,473.44 27.15%53,301.00 38,827.56 FINANCE 189,266.27 196,811.53 37.76%521,184.00 324,372.47 HUMAN RESOURCES 88,747.52 84,307.68 27.59%305,618.00 221,310.32 BUILDING STANDARDS 148,843.04 144,704.88 30.37%476,540.00 331,835.12 PLANNING & DEVELOPMENT 133,181.90 165,403.06 18.82%879,010.00 713,606.94 CITY BUILDINGS 72,124.24 111,018.46 25.05%443,229.00 332,210.54 PROPERTY MAINTENANCE 580,077.99 633,913.88 39.75%1,594,573.00 960,659.12 PUBLIC SAFETY 3,105,150.96 3,510,608.40 37.62%9,331,396.00 5,820,787.60 ENGINEERING 81,140.57 97,660.66 33.28%293,488.00 195,827.34 STREET LIGHTS & SIGNALS 99,119.39 121,615.06 24.25%501,603.00 379,987.94 STREETS & DRAINS 332,637.19 329,726.51 32.46%1,015,933.00 686,206.49 RECREATION 375,468.23 422,793.62 38.03%1,111,671.00 688,877.38 PARKS 122,250.20 171,839.82 28.30%607,296.00 435,456.18 COMMUNITY CENTER 26,577.39 31,771.38 26.91%118,059.00 86,287.62 TOURISM 75,710.54 37,235.03 12.18%305,817.00 268,581.97 RVP ACTIVITIES CENTER 161,070.24 171,960.56 21.35%805,524.00 633,563.44 GENERAL FUND TOTAL 6,216,170.95 6,856,553.39 33.08%20,725,822.00 13,869,268.61 STORMWATER UTILITY FUND (11): STORMWATER 255,814.19 273,597.96 33.15%825,262.00 551,664.04 TRANSFERS 27,324.00 29,635.00 100.00%29,635.00 0.00 STORMWATER FUND TOTAL 283,138.19 303,232.96 35.47%854,897.00 551,664.04 SANITATION FUND (13): SANITATION 1,142,557.65 1,139,058.16 38.39%2,967,435.00 1,828,376.84 RECYLING 570,005.83 385,907.90 20.98%1,839,208.00 1,453,300.10 TRANSFERS 386,506.00 401,048.00 100.00%401,048.00 0.00SANITATION FUND TOTAL 2,099,069.48 1,926,014.06 36.98%5,207,691.00 3,281,676.94 O & M FUND (21): UTILITIES FINANCE 219,953.27 222,898.27 34.48%646,540.00 423,641.73 UTILITIES ADMINISTRATION 146,635.78 176,510.66 31.93%552,864.00 376,353.34 WATER OPERATIONS 259,724.27 260,461.13 35.33%737,126.00 476,664.87 WATER PRODUCTION 551,472.31 553,664.88 35.13%1,576,261.00 1,022,596.12 WASTEWATER OPERATIONS 1,505,133.51 1,454,644.64 29.04%5,009,009.00 3,554,364.36 TRANSFERS 835,547.00 840,240.00 100.00%840,240.00 0.00 O & M FUND TOTAL 3,518,466.14 3,508,419.58 37.47%9,362,040.00 5,853,620.42 Laserfiche/FI0914#5 Page 5 of 6 DEPARTMENT COMPARATIVE DATA (2021-2022) This Month: April 2022 Laserfiche/FI0914#6 This Month: April 2022 Page 6 of 6 2017 2018 2019 2020 2021 2022 JAN 66,226,500 70,472,600 68,059,100 73,297,800 77,362,500 79,042,500 FEB 67,248,700 71,463,100 66,272,900 68,291,100 77,776,300 80,774,000 MAR 66,873,200 63,382,300 61,423,300 69,352,900 75,948,700 77,803,700 APR 76,591,700 67,096,100 75,454,200 76,253,900 88,695,300 90,212,500 MAY 95,937,000 92,208,400 88,165,300 99,465,100 118,713,300 JUN 110,442,100 97,377,300 129,536,200 125,121,100 136,873,300 JUL 104,063,100 105,927,100 129,809,800 129,776,700 131,817,700 AUG 103,060,200 99,041,700 135,105,800 132,624,000 146,944,500 SEP 110,350,200 103,480,400 116,113,900 119,071,431 127,111,500 OCT 95,226,700 105,219,800 123,284,600 116,900,300 114,022,000 NOV 99,336,800 82,158,600 103,718,900 99,996,700 113,542,500 DEC 78,090,700 69,352,300 71,605,400 89,801,400 87,608,000 TOTAL 1,073,446,900 1,027,179,700 1,168,549,400 1,199,952,431 1,296,415,600 327,832,700 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 2021 2022 90,212,500 North Augusta Parks, Recreation & Tourism Rick Meyer, Director Monthly Report For April, 2022 SPORTS ACTIVITY REPORT Particpation Sport Number of Teams Participants Prior Year In City Out City Coaches Current Month YTD Prior YTD Basketball $0 $7,732 $7,020 Baseball 56 634 578 358 276 168 Fall Baseball Softball -Adult Softball -Youth 25 276 207 180 96 75 Spring Soccer 54 667 578 445 222 108 Fall Soccer Cheerleading Football Volleyball $0 $500 $0 Activity Jazzercise Tennis MISCELLANEOUS RENTALS Month YTD Month Mo. Prior Year 2022 2021 7 20 $1,065 $650 $2,710 $5,465 Month YTD Month 2022 12 30 $4,877 $16,106 Shelter Revenues Trolley Rentals Trolley Revenues Shelter Rentals $0 $1,500 125 $1,237 -$70 YTD Participants YTDApril Revenue $80 $37,735 Prior YTD $0 $302 $162 $500 $51,670$105 Revenues $0 $1,269 $13,280 $33,833 $19,871 $43,324 2022 2021 2020 2019 2018 Jan.13,996$ 10.07%10.07%$13,996 $13,118 $17,431 $26,184 $20,829 Feb.19,905$ 14.32%24.39%$33,901 $30,321 $38,791 $51,369 $43,872 Mar.16,044$ 11.54%35.93%$49,945 $43,373 $49,379 $70,565 $58,380 Apr.11,521$ 8.29%44.22%$61,466 $55,523 $49,379 $84,836 $68,719 May 0.00%$67,540 $49,777 $96,815 $80,397 June 0.00%$85,589 $53,772 $110,820 $96,248 July 0.00%$93,695 $61,028 $124,496 $111,646 Aug.0.00%$113,952 $68,772 $142,034 $130,045 Sept.0.00%$126,885 $75,790 $151,281 $141,288 Oct.0.00%$137,182 $83,000 $161,783 $151,731 Nov.0.00%$152,036 $93,288 $174,729 $166,243 Dec.0.00%$165,393 $104,303 $188,679 $178,750 Total 61,466$ 44.22%44.22%61,466$ 165,393$ $104,303 $188,679 178,750$ April 2022 Prior YTD 3,860 18,856 19,812 19,346 101,796 93,349 23,206 120,652 113,161 Activities Center Members Attendance Activities Center Visitors Attendance Activities Center Total Attendance Riverview Park Activities Center Revenue / Participation Revenue for Current Month % 2022 Budget Recouped Month % 2022 Budget Recouped YTD Cumulative Activities Center Revenue $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 $200,000 1 2 3 4 5 6 7 8 9 10 11 12 Revenue 2018 2019 2020 2021 2022 $61,466 New Memberships Membership Renewals Monthly Total Resident Memberships Non-Resident Memberships Jan. 117 146 263 198 65 Feb. 110 136 246 193 53 Mar. 110 152 262 194 68 Apr. 68 115 183 149 34 May Jun. Jul. Aug. Sept. Oct. Nov. Dec. Totals 405 549 954 734 220 Activities Center Membership Breakdown Resident Memberships 77% Non-Resident Memberships 23% Resident vs Non-Resident Memberships Resident Memberships Non-Resident Memberships New Memberships 42% Membership Renewals 58% New vs Renewed Memberships New Memberships Membership Renewals 2022 2021 2020 2019 2018 2022 2021 2020 2019 2018 Jan 263 300 352 448 343 263 300 352 448 343 Feb 246 257 337 467 345 509 557 689 915 688 Mar 262 199 203 359 296 771 756 892 1274 984 April 183 199 0 252 212 954 955 892 1526 1196 May 243 4 219 260 1198 896 1745 1456 June 349 92 328 349 1547 988 2073 1805 July 148 80 251 312 1695 1068 2324 2117 Aug 290 98 265 307 1985 1166 2589 2424 Sept 209 131 196 215 2194 1297 2785 2639 Oct 193 148 168 173 2387 1445 2953 2812 Nov 216 239 238 232 2603 1684 3191 3044 Dec 222 193 273 277 2825 1877 3464 3321 954 2825 1877 3464 3321 Cumulative Membership TotalsMonthly Membership Totals 0 500 1000 1500 2000 2500 3000 3500 4000 Cumulative Membership Totals 2018 2019 2020 2021 2022 954 JAN FEB MAR APR MAY JUNE JUL AUG SEP OCT NOV DEC 2018 $9,050 $8,088 $25,504 $31,423 $29,432 $22,227 $20,993 -$1,480 $6,680 $11,936 $544 $7,552 2019 $10,193 $10,090 $20,782 $39,643 $40,678 $11,232 $28,607 -$924 $11,932 $12,755 $7,441 $1,582 2020 $13,519 $10,221 $6,469 -$529 $13 $12,570 $15,069 $3,192 $2,612 $11,899 $3,909 -$234 2021 $8,206 $7,698 $24,165 $36,437 $43,725 $18,580 $34,395 $17,270 -$5,701 $7,672 $9,665 $1,003 2022 $11,516 $6,579 $27,196 $28,535 2018 $9,050 $17,138 $42,642 $75,459 $104,891 $127,118 $148,111 $146,631 $153,311 $165,247 $165,791 $173,342 2019 $10,193 $20,283 $41,065 $80,708 $121,387 $132,619 $161,227 $160,303 $172,234 $184,990 $192,431 $194,013 2020 $13,519 $23,740 $30,209 $29,680 $29,694 $42,263 $57,333 $60,525 $63,136 $75,035 $78,944 $78,710 2021 $8,206 $15,905 $40,070 $76,507 $120,232 $138,812 $173,207 $190,447 $184,746 $192,418 $202,084 $203,087 2022 $11,516 $18,095 $45,291 $73,826 Concession Revenue Monthly Year-to-Date Cumulative Concession Revenue $0 $50,000 $100,000 $150,000 $200,000 $250,000 2018 2019 2020 2021 2022 $73,826 Month YTD Month Mth YTD Prior YTD Prior Year Banquet $2,400 Civic Group 6 14 $425 $1,050 Parties 2 14 $3,771 $1,500 $15,420 $4,800 Miscellaneous 5 15 $1,855 -$475 $7,722 -$475 Industry Meetings 1 4 $75 $720 $6,575 $720 Weddings 1 $1,500 $3,700 $3,300 Reunion $500 $1,000 $1,300 Linen (#times used) City/PSD Training Church 1 Maude Edenfield Shelter TOTAL 20 73 $7,726 $2,570 $34,942 $14,335 $25 $825 REVENUES COMMUNITY CENTER Community Center Revenue $100 $1,240 RENTALS Community Meetings 6 24 $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 2018 2019 2020 2021 2022 $34,942 2022 2021 2020 2019 2018 Jan.14,249$ 33.29%33.29%$14,249 $3,540 $8,820 $9,675 $7,221 Feb.4,581$ 10.70%44.00%$18,830 $5,790 $15,120 $17,861 $16,052 Mar.8,386$ 19.59%63.59%$27,216 $11,765 $15,195 $22,886 $21,602 Apr.7,726$ 18.05%81.64%$34,942 $14,335 $11,435 $31,800 $24,722 May $16,258 $9,560 $35,423 $33,403 June $20,903 $11,800 $39,364 $42,018 July $24,153 $11,170 $44,900 $48,653 Aug.$33,643 $10,465 $49,382 $50,453 Sept.$38,153 $12,790 $54,057 $50,671 Oct.$63,336 $15,865 $60,651 $57,749 Nov.$67,033 $18,145 $61,701 $59,632 Dec.$77,398 $22,500 $71,593 $63,345 Total 34,942$ 81.64%81.64%$34,942 $77,398 $22,500 $71,593 $63,345 Community Center Revenue Community Center Revenue Revenue for Current Month % '22 Budget Recouped in Month % '22 Budget Recouped YTD Cumulative Community Center Revenue $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 2018 2019 2020 2021 2022 $34,942 REVENUES Month YTD Month Mth YTD Prior YTD Prior Year Banquet Civic Group 2 Parties 1 4 $500 $5,481 $4,000 Community Meetings 2 City Meetings 5 13 Classes Industry Meetings 3 NA AHC 3 Weddings 2 -$500 $2,500 $11,250 Reunion $650 Linen $1,446 $1,565 Public Hearing Equipment Rental Miscellaneous 3 3 $1,000 $1,000 $6 TOTAL 9 32 $1,000 $3,946 $6,481 $17,471 RENTALS MUNICIPAL CENTER $6,481 $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 Jan.Feb.Mar.Apr.May June July Aug.Sept.Oct.Nov.Dec. Municipal Center Revenue 2018 2019 2020 2021 2022 2022 2021 2020 2019 2018 Jan.$4,500 11.14%11.14%$4,500 $4,000 $5,412 $15,654 $7,911 Feb.$1,281 3.17%14.31%$5,781 $4,750 $12,128 $23,504 $16,233 Mar.-$300 -0.74%13.57%$5,481 $13,525 $19,778 $24,448 $29,792 Apr.$1,000 2.48%16.04%$6,481 $17,471 $17,878 $25,998 $35,426 May $21,564 $17,878 $38,198 $45,956 June $21,864 $15,928 $45,100 $52,256 July $29,862 $18,168 $51,915 $71,633 Aug.$31,442 $21,218 $56,560 $86,658 Sept.$32,092 $24,218 $66,290 $86,731 Oct.$46,201 $27,118 $70,838 $92,204 Nov.$49,736 $35,468 $75,838 $99,204 Dec.$74,470 $37,836 $78,834 $105,334 Total 6,481$ 16.04%16.04%$6,481 $74,470 $37,836 $78,834 $105,334 Municipal Center Revenue Revenue for Current Month % '22 Budget Recoupd in Month % '22 Budget Recouped YTD Cumulative Municipal Center Revenue $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 $200,000 Jan.Feb.Mar.Apr.May June July Aug.Sept.Oct.Nov.Dec. Municipal Center Revenue 2018 2019 2020 2021 2022 $6,481