Page 90 - City of DWG FY 2022-23 BUDGET

185-CCPD FUND SUMMARY

BEGINNING FUND BALANCE 18,805 60,129 88,043 202,438 202,438 25,756 Variance Calculations

FY 21/22 Y 22/23
F
Actual + Proposed FY 22/23
FY 21/22
FY 21/22 FY 22/23 Projected Budget Proposed Budget
FY 18/19 FY 19/20 FY 20/21 TOTAL
Over/(Under)
REVENUE CATEGORY Amended Proposed Over/(Under) Over/(Under)
Actual Actual Actual Actual plus
FY 21/22 Actual
Budget Budget FY 21/22 FY 21/22 Amended
Projected
Amended plus Budget
Budget Projected

Sales & Use Tax 206,185 250,195 276,653 267,167 293,023 301,813 25,856 8,791 34,646 11%
Other Revenue 339 525 89 95 661 750 566 89 655 87%
Other Sources 18,200 13,450 - 20,000 65,872 10,000 45,872 (55,872) (10,000) -100%

TOTAL REVENUE 224,724 264,170 276,742 287,262 359,555 312,563 72,294 (46,992) 25,302 8%

FY 21/22 Y 22/23
F
Actual + Proposed FY 22/23 Proposed
FY 21/22
FY 21/22 FY 22/23 Projected Budget Budget
FY 18/19 FY 19/20 FY 20/21 TOTAL
Over/(Under)
EXPENDITURE CATEGORY Amended Proposed Over/(Under) Over/(Under)
Actual Actual Actual Actual plus
FY 21/22 Actual
Budget Budget FY 21/22 FY 21/22 Amended
Projected
Amended plus Budget
Budget Projected
Personnel Salary & Wages 138,993 73,253 131,092 102,900 108,256 111,197 5,356 2,941 8,297 7%
Personnel Taxes & Benefits 10,110 5,225 9,379 49,718 51,155 55,668 1,437 4,513 5,950 11%

Materials & Supplies - 2 56 18,962 - - (18,962) - (18,962)
Consultants - - - - - - - - -
Contractual - - - 5,000 5,000 5,000 - - - 0%
Other Expenses 101 7 - - - - - - -
Capital Outlay 34,196 157,770 21,820 276,367 371,827 120,000 95,460 (251,827) (156,367) -130%
Other Uses - - - - - - - - -
TOTAL EXPENDITURES 183,400 236,256 162,347 452,947 536,237 291,864 (12,169) 7,454 (161,083) -55%

REVENUE OVER EXPENDITURES 41,324 27,914 114,395 (165,685) (176,682) 20,699 (10,997) 197,381 186,384 900%

ENDING FUND BALANCE 60,129 88,043 202,438 36,752 25,756 46,455