Page 83 - City of DWG FY 2022-23 BUDGET

180-PRFDC FUND SUMMARY

BEGINNING FUND BALANCE 555,139 553,365 581,220 675,759 675,759 653,074 Variance Calculations

FY 21/22 FY 22/23
FY 21/22 Actual + Proposed Budget FY 22/23
FY 21/22 FY 22/23
FY 18/19 FY 19/20 FY 20/21 TOTAL Projected Proposed Budget
Over/(Under)
REVENUE CATEGORY Amended Proposed
FY 21/22 Actual
Actual Actual Actual Actual plus Over/(Under) Over/(Under)
Budget Budget
plus
Projected FY 21/22 FY 21/22 Budget
Budget Projected
Sales & Use Tax 105,706 125,517 139,042 133,584 147,488 151,913 13,905 4,425 18,330 12%
Other Revenue 11,875 8,451 28,411 1,980 3,593 4,300 1,613 707 2,320 54%
Other Sources - 2,667 20,777 - 425 - 425 (425) -
TOTAL REVENUE 117,581 136,634 188,229 135,564 151,506 156,213 15,943 4,707 20,650 13%

FY 21/22 FY 22/23
FY 21/22 Actual + Proposed Budget FY 22/23
FY 21/22 FY 22/23
FY 18/19 FY 19/20 FY 20/21 TOTAL Projected Proposed Budget
Over/(Under)
EXPENDITURE CATEGORY Amended Proposed
FY 21/22 Actual
Actual Actual Actual Actual plus Over/(Under) Over/(Under)
Budget Budget
Projected FY 21/22 FY 21/22 Budget
plus
Budget Projected
Personnel Salary & Wages 23,941 29,085 30,841 42,022 34,565 40,264 (7,457) 5,699 (1,758) -4%
Personnel Taxes & Benefits 11,690 14,100 12,362 23,264 16,184 20,078 (7,080) 3,894 (3,186) -16%
Training & Travel - - 165 569 532 525 (37) (7) (44) -8%
Materials & Supplies 9,923 764 3,297 7,004 5,689 4,030 (1,315) (1,659) (2,974) -74%
Utilities 7,156 5,232 5,055 6,799 7,320 7,722 521 402 923 12%
Maintenance 22,852 4,151 12,579 30,965 33,971 14,300 3,005 (19,671) (16,665) -117%
Consultants 6,572 28,597 4,103 53,000 53,531 51,605 531 (1,926) (1,395) -3%
Contractual 2,359 3,207 5,538 5,976 6,231 6,349 255 118 373 6%

Other Expenses 5,465 4,083 4,587 10,500 9,414 9,190 (1,086) (224) (1,310) -14%
Capital Outlay 29,398 19,560 15,163 50,000 6,755 50,000 (43,245) 43,245 - 0%
Other Uses - - - - - - - - -
TOTAL EXPENDITURES 119,356 108,779 93,690 230,099 174,192 204,063 (55,908) 29,871 (26,036) -13%

REVENUE OVER EXPENDITURES (1,775) 27,855 94,539 (94,536) (22,685) (47,850) 71,851 (25,165) 46,686 -98%

ENDING FUND BALANCE 553,365 581,219.88 675,759 581,223 653,074 605,224

Assigned Fund Balance for Park
Playground Grant 1,200 1,200 33,025 33,025 33,225
Unassigned Fund Balance 552,165 580,020 642,734 548,198 619,849 605,224