Page 3 - Dalworthington Gardens FY21 Budget

09/17/2020

110-GENERAL FUND SUMMARY

Beginning Fund Balance 724,999 536,895 481,141 551,410 551,410 559,132

FY 19/20 FY 20/21
Projected Proposed
FY 19/20 FY 19/20 9 FY 19/20 FY 20/21
FY 16/17 FY 17/18 FY 18/19 FY 19/20 Over/(Under) Budget
REVENUE CATEGORY Amended months Sep - 3 months Jul- Proposed
Actual Actual Actual Act/Proj FY 19/20 Over/(Under)
Budget Jun Actual Sep Projected Budget
Amended FY 19/20
Budget Projected
Property Tax 799,279 966,050 1,614,754 1,660,817 1,642,576 20,001 1,662,577 1,822,578 1,759 160,002
Sales & Use Tax 396,127 404,027 429,937 421,057 366,180 115,381 481,561 480,003 60,505 (1,558)
Franchise Fees 359,645 340,612 370,884 368,921 348,309 7,648 355,958 348,635 (12,963) (7,323)
Licenses & Permits 198,685 97,791 85,294 71,915 49,672 17,675 67,347 61,500 (4,568) (5,847)
Fines & Fees 496,368 488,795 490,660 474,700 288,584 62,334 350,918 419,320 (123,783) 68,403
Service Charges & Fees 51,050 57,993 70,790 125,756 88,223 27,608 115,831 115,939 (9,924) 108
Donations 10,969 11,829 8,853 500 2,338 - 2,338 2,500 1,838 162
Gas Royalties 397,197 306,034 202,527 125,000 107,549 18,598 126,146 60,000 1,146 (66,146)
Miscellaneous Revenue 31,468 33,527 36,161 30,000 20,513 6,467 26,980 17,100 (3,020) (9,880)

Other Sources 5,886 115,428 20,300 10,000 - 611,310 611,310 25,000 601,310 (586,310)

TOTAL REVENUE 2,746,675 2,822,085 3,330,159 3,288,665 2,913,943 887,022 3,800,966 3,352,575 512,300 (448,391)
77% 23% 100%
FY 19/20 FY 20/21
Projected Proposed
FY 19/20 FY 19/20 9 FY 19/20 FY 20/21
FY 16/17 FY 17/18 FY 18/19 FY 19/20 Over/(Under) Budget
EXPENSE CATEGORY Amended months Sep - 3 months Jul- Proposed
Actual Actual Actual Act/Proj FY 19/20 Over/(Under)
Budget Jun Actual Sep Projected Budget
Amended FY 19/20
Budget Projected
Personnel Salary & Wages 1,357,374 1,261,127 1,231,495 1,533,960 1,080,324 313,181 1,393,505 1,584,700 (140,456) 191,196

Personnel Taxes & Benefits 613,606 588,324 555,412 635,256 444,917 129,351 574,268 686,609 (60,988) 112,341
Training & Travel 30,785 7,585 25,506 59,334 17,007 22,261 39,269 64,638 (20,066) 25,370

Materials & Supplies 88,672 100,279 148,623 152,683 55,814 71,694 127,508 169,813 (25,175) 42,305

Utilities 84,882 75,634 60,831 83,808 50,067 18,894 72,137 74,121 (11,671) 1,984
Bad Debt 533 - -

Maintenance 58,429 86,210 113,842 83,559 54,388 29,789 84,177 101,220 618 17,043
Consultants 272,310 214,491 184,950 194,567 125,432 41,230 166,662 170,785 (27,906) 4,123
Contractual 271,238 296,798 268,759 301,024 225,828 66,215 292,043 294,026 (8,981) 1,983
Other Expenses 118,555 128,228 127,505 59,335 18,862 34,669 53,531 124,168 (5,804) 70,637
Capital Outlay - 119,163 199,823 14,113 13,080 841,354 854,433 10,000 840,320 (844,433)
Other Uses 38,395 - 18,200 10,000 - 10,000 10,000 10,000 - -

Transfer to Gas Reserve - - 224,943 125,000 107,114 18,598 125,712 60,000 712 (65,712)
Transfer to Fire Truck Fund - - 100,000 25,000 - - - - (25,000) -
TOTAL EXPENSES 2,934,778 2,877,839 3,259,889 3,277,639 2,192,832 1,597,236 3,793,244 3,350,081 515,605 (443,163)

58% 42% 100%

REVENUE OVER EXPENSES (188,104) (55,754) 70,270 11,026 721,111 (710,214) 7,722 2,494 (3,305) (5,228)

ENDING FUND BALANCE 536,895 481,141 551,410 562,437 721,111 (710,214) 559,132 561,626

Page 2 of 48