Page 77 - DWGFY24AdoptedBudget

180-PRFDC FUND SUMMARY

BEGINNING FUND BALANCE 553,365 581,220 675,759 678,595 678,595 664,266 Variance Calculations

FY 22/23 FY 23/24
FY 22/23 Actual + Proposed Budget FY 23/24
FY 22/23 FY 23/24
Over/(Under)
FY 19/20 FY 20/21 FY 21/22 TOTAL Projected Proposed Budget
REVENUE CATEGORY Amended Proposed
Actual Actual Actual Actual plus Over/(Under) Over/(Under)
FY 22/23 Actual
Budget Budget
Projected FY 22/23 FY 22/23 Budget
plus
Budget Projected
Sales & Use Tax 125,517 139,042 148,169 151,913 151,083 151,083 (830) 0 (830) -1%
Total Charges for Service - - - 1,500 1,500 1,500 - - - 0%
Other Revenue 8,451 28,411 4,593 4,300 71,722 22,100 67,422 (49,622) 17,800 81%
Other Sources 2,667 20,777 425 - 25,000 - 25,000 (25,000) -
TOTAL REVENUE 136,634 188,229 153,188 157,713 249,305 174,683 91,592 (74,622) 16,970 10%

FY 22/23 FY 23/24
FY 22/23 Actual + Proposed Budget FY 23/24
FY 22/23 FY 23/24
Over/(Under)
FY 19/20 FY 20/21 FY 21/22 TOTAL Projected Proposed Budget
EXPENDITURE CATEGORY Amended Proposed
Actual Actual Actual Actual plus Over/(Under) Over/(Under)
FY 22/23 Actual
Budget Budget
plus
Projected FY 22/23 FY 22/23 Budget
Budget Projected

Personnel Salary & Wages 29,085 30,841 35,383 40,264 35,833 53,527 (4,431) 17,694 13,263 25%
Personnel Taxes & Benefits 14,100 12,362 16,585 20,078 17,320 23,635 (2,758) 6,315 3,556 15%
Training & Travel - 165 - 525 261 190 (264) (72) (336) -177%
Materials & Supplies 764 3,297 4,700 4,270 4,738 6,255 468 1,518 1,985 32%
Utilities 5,232 5,055 6,870 7,722 6,681 7,237 (1,041) 556 (485) -7%
Maintenance 4,151 12,579 32,869 14,703 8,540 16,446 (6,163) 7,906 1,743 11%
Consultants 28,597 4,103 39,415 50,655 33,877 2,000 (16,778) (31,877) (48,655) -2433%
Contractual 3,207 5,538 6,231 6,349 5,936 6,777 (413) 842 428 6%
Other Expenses 4,083 4,587 8,299 10,140 8,378 13,415 (1,762) 5,037 3,275 24%
Capital Outlay 19,560 15,163 - 56,755 142,071 - 85,316 (142,071) (56,755)
Other Uses - - - - - - - - -
TOTAL EXPENDITURES 108,779 93,690 150,352 211,461 263,635 129,482 52,174 (134,153) (81,979) -63%

REVENUE OVER EXPENDITURES 27,855 94,539 2,836 (53,748) (14,330) 45,201 39,418 59,531 98,949 219%

ENDING FUND BALANCE 581,220 675,759 678,595 624,847 664,266 709,467