Page 42 - Dalworthington Gardens FY21 Budget

09/17/2020

120-ENTERPRISE FUND SUMMARY

Claim on Cash Beginning Balance (206,271) (177,024) (136,173) 26,101

FY 19/20 FY 20/21
r
P
FY 19/20 FY 20/21 Projected oposed Budget
FY 16/17 FY 17/18 FY 18/19 FY 19/20
O
REVENUE CATEGORY Amended Proposed Over/(Under) der)
v
/
(U
n
r
e
Actual Actual Actual Projected
9
F
Budget Budget FY 19/20 /20
1
Y
Amended Budget Projected

Water/Sewer Sales & Fees 1,492,984 1,583,936 1,482,572 1,687,648 1,749,555 1,706,898 61,908 (42,657)
Charges for Services 176,715 168,481 176,248 187,588 187,874 188,654 285 780
Other Revenue 227,113 45,368 40,904 120,874 116,631 37,081 (4,243) (79,550)
Other Sources 838,644 154,563 4,151 - 467,825 - 467,825 (467,825)
TOTAL REVENUE 2,735,456 1,952,347 1,703,875 1,996,110 2,521,885 1,932,633 525,775 (589,252)
FY 19/20 FY 20/21
r
FY 19/20 FY 20/21 Projected oposed Budget
P
FY 16/17 FY 17/18 FY 18/19 FY 19/20
r
v
O
EXPENSE CATEGORY Amended Proposed Over/(Under) der)
(U
n
e
/
Actual Actual Actual Projected
F
9
Budget Budget FY 19/20 /20
1
Y
Amended Budget Projected
Personnel Salary & Wages 192,183 249,076 228,077 260,576 257,979 271,827 (2,596) 13,848
Personnel Taxes & Benefits 92,833 106,291 84,740 104,745 109,717 126,487 4,971 16,770

Training & Travel 200 1,050 1,633 3,000 1,601 7,179 (1,400) 5,578
Materials & Supplies 20,046 21,626 32,632 46,589 32,928 50,956 (13,661) 18,028
Utilities 27,653 31,409 29,925 14,616 15,156 15,238 540 82
Bad Debt 19,459 - - - - - - -
Maintenance 35,491 10,227 41,902 53,615 39,562 47,169 (14,053) 7,607
Consultants 10,141 11,805 15,282 12,224 11,753 10,600 (471) (1,153)

Contractual 1,089,440 1,135,478 1,123,217 1,092,213 1,136,877 1,067,513 44,665 (69,364)

Debt - - 9,225 9,225 91,843 - 82,618
Other Expenses (includes Depreciation) 181,648 188,352 231,192 305,841 304,565 280,979 (1,276) (23,586)
Other Uses - 211,254 - - - - - -
Capital Outlay - 121,441 633,798 - 512,357 (633,798)
TOTAL EXPENSES 1,669,094 1,966,569 1,788,600 2,024,085 2,553,161 1,969,790 529,076 (583,371)
REVENUE OVER EXPENSES 1,066,362 (14,222) (84,726) (27,975) (31,276) (37,157) (3,301) (5,882)
Add Back Depreciation 155,155 158,755 193,550 165,000
Deduct Capital Purchases (not shown in expense) (53,375) (20,956)
Adjustment for changes to OPEB and pension (non-cash exp) (3,277) (13,123)
Adjustment for change in compensated absences (non-cash exp) 4,057 5,149

Interest earned on Restricted Cash accounts (2,401) (4,248)
Transfers Out (56,691) -
Working Capital (177,024) (136,173) 26,101 153,944

Page 22 of 48