Page 116 - Kennedale Budget FY21

FUND SUMMARY: WATER/SEWER FUND
10 | WATER / SEWER FUND SUMMARY
2017–2018 2018–2019 2019–2020 2019–2020 2020–2021
REVENUES
ACTUAL ACTUAL APPROVED PROJECTED APPROVED
Water Service 2,671,310 2,376,545 1,941,782 1,941,782 2,128,290
Sewer Service 1,716,161 1,660,530 1,669,203 1,669,203 1,700,194
Sewer Surcharge 15,002 13,189 11,978 11,978 2,705
Penalties 62,536 53,673 50,873 14,450 13,231
Administrative Fees 17,608 15,080 15,150 4,500 3,762
Water Tap Fees - - 5,050 5,050 2,856
Meter Purchase / Install 56,281 10,501 11,933 11,933 3,645
Sewer Tap Fees - 5,050 5,050 1,768
Engineer Revew Fees 1,000 8,643 6,924 6,924 6,120
Sanitation Billing Fees 23,920 18,979 16,798 16,798 15,507
Other Fees - Water / Sewer 9,385 10,170 10,423 10,423 1,984
Sales Tax 118 114 101 101 139
Arlington Operator Cost - 300,874 354,500
Investment Income 14,284 37,606 37,814 37,814 19,179
Miscellaneous Income 2,106 31,404 31,718 31,718 4,911
Cash Over / Under 41 1 - -
Sale of Parts / Assets 1,006 345 1,010 37,750 1,000
Transfer In - Water Impact Fund 153,573 152,525 152,525 152,525 -
Transfer In - Sewer Impact Fund 60,000 60,000 60,000 35,000 -
Transfer In- Roadway Impact Fund 187,525
Total Revenues $ 4,804,331 $ 4,449,305 $ 4,028,331 $ 4,293,873 $ 4,447,316

2017–2018 2018–2019 2019–2020 2019–2020 2020–2021
EXPENDITURES
ACTUAL ACTUAL APPROVED PROJECTED APPROVED
Utility Billing 1,412,952 1,380,723 1,518,390 1,719,049 1,460,295
Operations 1,324,783 1,061,011 1,385,154 1,522,435 1,375,369
Debt Service 175,327 337,171 354,505 354,505 358,559
Capital Projects 15,519 8,670 415,000 415,000 600,000
Non-Departmental 1,441,811 1,395,296 677,889 677,889 710,477
Total Expenditures $ 4,370,392 $ 4,182,872 $ 4,350,938 $ 4,688,878 $ 4,504,700

Total Revenues Over (Under) Exp $ 433,939 $ 266,434 $ (322,607) $ (395,005) $ (57,384)
00-Other Funding Sources In (Out):

TOTAL Other In (Out) $ - $ - $ - $ -

NET CHANGE IN FUND BALANCE $ 433,939 $ 266,434 $ (322,607) $ (395,005) $ (57,384)
BEGINNING FUND BALANCE - OCTOBER 1 1,045,984 1,682,545 2,471,302 2,076,297
ENDING FUND BALANCE - SEPTEMBER 30 1,479,923 2,471,302 1,359,938 2,076,297 2,018,912
AVERAGE DAILY EXPENDITURES (730) 884 1,082 157
NUMBER OF DAYS RESERVE - 1,539 1,919 12,842
FUND BALANCE AS A % OF EXPENDITURES 59.08% 31.26% 44.28% 44.82%

1 0 8