Page 67 - PowerPoint Presentation

UTILITY FUND 500
Program Summary
Fiscal Year 2022
Audited Adopted Revised Proposed FY 2022 Proposed FY 2022 Proposed
Actuals Budget Budget Budget vs vs
FY 2020 FY 2021 FY 2021 FY 2022 FY 2021 Adopted FY 2021 Revised

REVENUES & OTHER SOURCES

1 Charge for Service 6,052,109 5,426,589 5,459,132 5,337,455 (89,134) -2% (121,677) -2%

2 Permits & Fees Utility 344,533 268,011 268,011 342,411 74,400 28% 74,400 28%

3 Investment Earnings 54,995 55,853 10,000 15,000 (40,853) -73% 5,000 50%

4 Contributions - - - - - 0% - 0%
5 Donations - - - - - 0% - 0%
6 Misc Income 14,112 18,025 18,025 18,025 - 0% - 0%

7 Total Revenues 6,465,748 5,768,478 5,755,168 5,712,891 (55,587) -1% (42,277) -1%

8 GRAND TOTAL REVENUES & OTHER SOURCES 6,465,748 5,768,478 5,755,168 5,712,891 (55,587) -1% (42,277) -1%

EXPENSES & OTHER USES

9 Compensated Absences (23,027) 9,195 9,195 9,195 - 0% - 0%
10 Transfers Out 410,866 543,088 543,088 582,764 39,676 7% 39,676 7%
11 Taxes - - - 3,930 3,930 100% 3,930 100%

12 Total Payroll and Related 387,839 552,283 552,283 595,889 43,606 8% 43,606 8%

13 Capital Outlay 44,781 31,055 31,055 38,055 7,000 23% 7,000 23%

14 Debt Service 1,982,542 1,031,671 288,671 1,020,857 (10,814) -1% 732,186 254%
15 Leases and Rentals - 1,500 1,500 1,500 - 0% - 0%
16 Rent & Utilities 163,781 188,328 188,328 191,297 2,969 2% 2,969 2%

17 Repair & Maintenance 299,880 161,065 161,065 154,065 (7,000) -4% (7,000) -4%
18 Services 2,891,836 3,478,444 3,478,444 3,487,444 9,000 0% 9,000 0%

19 Supplies 7,891 7,040 7,040 9,540 2,500 36% 2,500 36%
20 Travel & Training 165 7,795 7,795 7,795 - 0% - 0%
21 Operations and Maintenance 5,390,875 4,906,898 4,163,898 4,910,553 3,655 0% 746,655 18%

22 SUB-TOTAL OPERATIONS and MAINTENANCE EXPENSES 5,778,714 5,459,181 4,716,181 5,506,442 47,261 1% 790,261 17%

23 Transfer out to Fund 100 General Fund 77,158 68,000 192,588 68,000 - 0% (124,588) -65%
24 Transfer out to Fund 505 Utility Vehicle 20,000 60,000 60,000 65,000 5,000 8% 5,000 8%

25 Transfer out to Fund 510 Utility M&R - 30,000 30,000 350,000 320,000 1067% 320,000 1067%

26 Total Transfers Out and Other Uses 97,158 158,000 282,588 483,000 325,000 206% 200,412 71%

27 SUB-TOTAL NON-OPERATING EXPENSES 97,158 158,000 282,588 483,000 325,000 206% 200,412 71%

28 GRAND TOTAL ALL EXPENSES & OTHER USES 5,875,871 5,617,181 4,998,769 5,989,442 372,261 7% 990,673 20%
SUMMARY
29 EXCESS REVENUES OVER(UNDER) EXPENSES 589,877 151,297 756,399 (276,551) (427,848) -283% (1,032,950) -137%

30 FUND BALANCE, BEGINNING (Working Capital) 4,840,299 5,430,176 5,430,176 6,186,575 756,399 14% 756,399 14%

31 FUND BALANCE, ENDING (WORKING CAPITAL) $ 5,430,176 $ 5,581,473 $ 6,186,575 $ 5,910,023 $ 328,551 6% $ (276,551) -4%

32 Restricted/Assigned/Committed Funds 1,127,750 1,120,982 1,120,982 982,982 (138,000) -12% (138,000) -12%

33 UNASSIGNED FUND BALANCE, ENDING $ 4,302,426 $ 4,460,491 $ 5,065,593 $ 4,927,041 $ 466,551 10% $ (138,551) -3%

RESTRICTED/ASSIGNED/COMMITTED FUNDS
34 Hillwood $ 888,000 $ 888,000 $ 888,000 750,000 (138,000) -16% (138,000) -16%

35 Deposits 239,750 232,982 232,982 232,982 - 0% - 0%
36 - 0% - 0%
37 TOTAL RESTRICTED/ASSIGNED/COMMITTED FUNDS $ 1,127,750 $ 1,120,982 $ 1,120,982 $ 982,982 $ (138,000) -12% $ (138,000) 62 -12%