Page 84 - DWGFY24AdoptedBudget

185-CCPD FUND SUMMARY

BEGINNING FUND BALANCE 60,129 88,043 202,438 307,294 307,294 159,024 Variance Calculations

FY 22/23 Y 23/24
F
Actual + Proposed FY 23/24
FY 22/23
FY 22/23 FY 23/24 Projected Budget Proposed Budget
FY 19/20 FY 20/21 FY 21/22 TOTAL
Over/(Under)
REVENUE CATEGORY Amended Proposed Over/(Under) Over/(Under)
Actual Actual Actual Actual plus
Budget Budget FY 22/23 FY 22/23 Amended
FY 22/23 Actual
Projected
Amended plus Budget
Budget Projected
Sales & Use Tax 250,195 276,653 294,486 301,813 299,769 299,770 (2,044) 1 (2,044) -1%
Other Revenue 525 89 821 750 7,427 7,200 6,677 (227) 6,450 90%
Other Sources 13,450 - 9,200 66,672 66,672 10,000 - (56,672) (56,672) -567%
TOTAL REVENUE 264,170 276,742 304,507 369,235 373,868 316,970 4,633 (56,899) (52,266) -16%

F
FY 22/23 Y 23/24
Actual + Proposed FY 23/24 Proposed
FY 22/23
FY 22/23 FY 23/24 Projected Budget Budget
FY 19/20 FY 20/21 FY 21/22 TOTAL
Over/(Under)
EXPENDITURE CATEGORY Amended Proposed Over/(Under) Over/(Under)
Actual Actual Actual Actual plus
FY 22/23 Actual
Budget Budget FY 22/23 FY 22/23 Amended
Projected
Amended plus Budget
Budget Projected
Personnel Salary & Wages 73,253 131,092 110,195 111,197 116,430 170,521 5,233 54,091 59,324 35%
Personnel Taxes & Benefits 5,225 9,379 53,186 55,668 57,511 92,782 1,843 35,272 37,115 40%
Materials & Supplies 2 56 - 23,584 23,584 - (0) (23,584) (23,584)

Consultants - - - - - - - - -
Contractual - - - 5,000 - 14,000 (5,000) 14,000 9,000 64%
Other Expenses 7 - - - - - - - -
Capital Outlay 157,770 21,820 36,269 438,514 324,614 140,000 (113,900) (184,614) (298,514) -213%
Other Uses - - - - - - - - -
TOTAL EXPENDITURES 236,256 162,347 199,650 633,962 522,139 417,303 (111,824) (104,835) (216,659) -52%

REVENUE OVER EXPENDITURES 27,914 114,395 104,856 (264,727) (148,270) (100,334) 116,457 47,936 164,393 -164%

ENDING FUND BALANCE 88,043 202,438 307,294 42,567 159,024 58,690