Page 237 - Budget FY 2022-2023 - Update

Adopted Budget 2023 City of McAllen, Texas

WATER DEPRECIATION
Fund Balance Summary

Actual Adj. Budget Estimated Budget
20-21 21-22 21-22 22-23

RESOURCES

BEGINNING WORKING CAPITAL $ 6,838,365 $ 6,025,703 $ 6,494,160 $ 3,999,977

Revenues:
Interest Earned $ 50,021 $ 22,559 $ 21,618 $ 24,000
Valuation Allowance (5,528) - - -

Total Revenues 44,493 22,559 21,618 24,000

Other Financing Sources:
Transfer In - Water Fund 1,575,935 1,698,664 1,608,631 1,768,040

Total Revenues and Other Sources 1,620,428 1,721,223 1,630,249 1,792,040

TOTAL RESOURCES $ 8,458,793 $ 7,746,926 $ 8,124,409 $ 5,792,017

APPROPRIATIONS

Operating Expenses:
Water Treatment Plant $ 204,208 $ 207,750 $ 199,489 $ 285,760
Water Lab 2,592 23,500 21,508 -
Water Line Maintenance 450,306 869,605 869,605 1,052,930
Water Meter Readers - 199,000 199,000 -
Customer Relations - - - 27,000

Total Operations 657,106 1,299,855 1,289,602 1,365,690

Capital Projects:
Annual Water Tower Rehabilitation 34,550 - - 700,000
Annual Waterline Replacement 49,400 500,000 96,400 800,000
CDBG Projects 100,000 100,000 100,000 100,000
Concrete Steel Pipe Rehab/Replacement Phase 1 - 750,000 300,000 450,000
Daffodil Road Waterline Replacement - 475,000 200,000 275,000
ERP Project - 630,020 800,000 -
Hackberry Waterline Replacement 17th-19th - 100,000 100,000 -
Kendlewood Waterline Replacement 17th-20th - 100,000 100,000 -
New Reservior Embankment Reinforcement 829,583 - - -
NWTP Chain and Flight Sludge Collector Replacement - - - 600,000
SWTP Electrical Generator Project 79,000 250,000 100,000 150,000
SWTP Exp Filter/Clarifier 144,662 200,000 98,430 5,000
SWTP Tube Replacement - 800,000 600,000 200,000
Taylor Road Utility Adjustment (IH 2-Pecan) 18,615 350,000 340,000 10,000
Taylor Road Utility Adjustments Business 83 - Daffodil - - - 30,000
Total Capital Projects 1,255,810 4,255,020 2,834,830 3,320,000

TOTAL APPROPRIATIONS $ 1,912,917 $ 5,554,875 $ 4,124,432 $ 4,685,690

Revenues over/(under) Expenditures (292,489) (3,833,652) (2,494,183) (2,893,649)

Adjustments for accruals (51,716) - - -

ENDING WORKING CAPITAL $ 6,494,160 $ 2,192,051 $ 3,999,977 $ 1,106,327

- 235 - Table of Contents