Page 48 - DWGFY24AdoptedBudget

120-ENTERPRISE FUND SUMMARY

WORKING CAPITAL BEGINNING BALANCE (136,174) 154,835 518,100 665,236 665,236 629,905 Variance Calculations

FY 23/24
FY 22/23 FY 23/24 Proposed
FY 22/23 Proposed Budget
FY 22/23 FY 23/24 Projected 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 FY 22/23 Actual
Budget Budget FY 22/23 FY 22/23 Amended
Projected plus
Amended Budget Budget
Projected
Water/Sewer Sales & Fees 1,717,979 1,737,297 2,083,626 1,962,274 1,996,925 2,318,125 34,650 321,200 355,850 15.4%

Charges for Services 186,636 190,306 194,286 199,827 198,220 212,957 (1,607) 14,736 13,130 6.2%

Other Revenue 163,733 53,425 126,400 19,436 44,355 40,163 24,919 (4,192) 20,727 51.6%

Other Sources 463,024 - 5,125 5,187 21,656 - 16,469 (21,656) (5,187)
TOTAL REVENUE 2,531,373 1,981,028 2,409,437 2,186,725 2,261,156 2,571,244 74,431 310,088 384,519 15.0%

FY 23/24
FY 22/23 FY 23/24 Proposed
FY 22/23 Proposed Budget
FY 22/23 FY 23/24 Projected Budget
FY 19/20 FY 20/21 FY 21/22 TOTAL Over/(Under)
EXPENSE 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 plus
Amended Budget Budget
Projected
Personnel Salary & Wages 256,904 277,046 279,084 324,819 304,664 352,063 (20,155) 47,399 27,244 7.7%
Personnel Taxes & Benefits 88,697 91,048 82,575 148,323 133,933 166,247 (14,391) 32,314 17,924 10.8%
Training & Travel 980 2,958 4,511 9,725 4,876 7,734 (4,849) 2,858 (1,991) -25.7%
Materials & Supplies 37,178 39,729 31,774 37,265 35,182 34,400 (2,083) (782) (2,864) -8.3%
Utilities 15,638 35,694 27,241 29,694 29,597 32,259 (96) 2,661 2,565 8.0%
Maintenance 38,019 45,224 153,964 133,936 138,542 120,087 4,606 (18,455) (13,849) -11.5%
Consultants 11,403 15,646 46,119 41,754 42,445 43,920 691 1,475 2,166 4.9%
Contractual 1,050,064 1,064,745 1,245,072 1,263,097 1,427,677 1,381,897 164,580 (45,780) 118,800 8.6%
Debt 9,184 91,852 91,767 91,792 93,565 93,565 1,773 - 1,773 1.9%
Other Expenses 111,022 68,659 5,334 7,106 5,648 4,601 (1,458) (1,047) (2,505) -54.4%
Other Uses 26,323 - 66,000 66,000 66,000 66,000 - - - 0.0%
Capital Outlay 583,899 45,811 192,157 75,759 15,358 248,377 (60,401) 233,019 172,618 69.5%
TOTAL EXPENSES 2,229,311 1,778,411 2,225,597 2,229,269 2,297,487 2,551,149 68,218 253,662 321,881 12.6%

REVENUE OVER EXPENSES 302,062 202,617 183,840 (42,544) (36,331) 20,095 6,213 56,426 62,639
Committed capital towards $67K Hydro Excavator (20,000)
- - -
Revenue over Expenses adjusted 302,062 202,617 183,840 (42,544) (36,331) 95 6,213 56,426 62,639