Page 80 - CityofDalworthingtonGardensFY25AdoptedBudget

185-CCPD FUND SUMMARY

BEGINNING FUND BALANCE 88,043 202,438 307,294 252,576 252,576 29,856 Variance Calculations

F
FY 23/24 Y 24/25
Actual + Proposed FY 24/25
FY 23/24
FY 23/24 FY 24/25 Projected Budget Proposed Budget
FY 20/21 FY 21/22 FY 22/23 TOTAL
Over/(Under)
REVENUE CATEGORY Amended Proposed Over/(Under) Over/(Under)
Actual Actual Actual Actual plus
FY 23/24 Actual
Budget Budget FY 23/24 FY 23/24 Amended
Projected
Amended plus Budget
Budget Projected
Sales & Use Tax 276,653 294,486 285,849 299,770 254,224 254,355 (45,546) 131 (45,415) -18%
Other Revenue 89 821 7,719 7,200 6,367 3,205 (833) (3,162) (3,995) -125%
Other Sources - 9,200 81,198 10,000 10,000 10,000 - - - 0%
TOTAL REVENUE 276,742 304,507 374,766 316,970 270,591 267,560 (46,378) (3,031) (49,410) -18%

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

Personnel Salary & Wages 131,092 110,195 117,226 170,521 183,391 86,877 12,869 (96,513) (83,644) -96%
Personnel Taxes & Benefits 9,379 53,186 57,641 92,782 94,696 49,361 1,914 (45,335) (43,421) -88%
Materials & Supplies 56 - 4,622 - 34,647 - 34,647 (34,647) -
Consultants - - - - - - - - -
Contractual - - - 14,000 10,950 16,300 (3,050) 5,350 2,300 14%
Other Expenses - - 19,250 - 19,248 19,248 19,248 - 19,248 100%

Capital Outlay 21,820 36,269 230,744 202,208 150,379 90,000 (51,829) (60,379) (112,208) -125%
Other Uses - - - - - - - - -
TOTAL EXPENDITURES 162,347 199,650 429,484 479,511 493,311 261,787 13,800 (231,524) (217,725) -83%

REVENUE OVER EXPENDITURES 114,395 104,856 (54,718) (162,542) (222,720) 5,773 (60,178) 228,493 168,315 2915%

ENDING FUND BALANCE 202,438 307,294 252,576 90,034 29,856 35,630

140,528 163,381 198,740 277,303 342,932 171,787
385 448 544 760 940 471
34,651 40,286 49,004 68,376 84,559 42,358
526 687 464 119 32 76