Page 200 - ANALYSIS.XLS
P. 200
City of McAllen, Texas
Water Depreciation
Working Capital Summary
Actual Adj. Budget Estimated Budget
18-19 19-20 19-20 20-21
RESOURCES
BEGINNING WORKING CAPITAL $ 8,071,909 $ 6,969,924 $ 6,545,207 $ 6,104,502
Revenues:
Interest Earned 164,756 103,019 137,199 61,045
Valuation Allowance 44,440 - (4,606) -
Total Revenues 209,196 103,019 132,593 61,045
Other Financing Sources:
Transfer In - Water Fund 1,590,160 1,600,986 1,594,252 1,606,935
Total Revenues and Other Sources 1,799,356 1,704,005 1,726,845 1,667,980
TOTAL RESOURCES $ 9,871,263 $ 8,673,929 $ 8,272,052 $ 7,772,482
APPROPRIATIONS
Operating Expenses:
Administration and General $ 58,953 $ - $ - $ -
Water Treatment Plant 373,001 518,850 453,000 274,900
Water Laboratory - 44,500 38,093 3,250
Water Line Maintenance 432,120 881,520 930,000 848,015
Water Meter Readers 27,617 59,500 49,368 93,000
Utility Billing 3,314 - - -
Customer Relations 2,209 - - -
Total Operations 897,214 1,504,370 1,470,461 1,219,165
Capital Projects:
CDBG Projects $ 18,110 $ 100,000 $ 100,000 $ 100,000
Waterline Extensions - 400,000 44,090 -
Balboa Waterline Phase 2 - 400,000 200,000 20,000
SWTP Expansion Filter/Clarifier - 250,000 143,000 107,000
Ware Rd. Wide Waterline Reloc Mi 3-Trenton - 9,200 - -
Hackberry Waterline Replacement 17th-19th - 100,000 20,000 100,000
Kendlewood Waterline Replacement 17th-20th - 100,000 20,000 100,000
N. 29th Street Waterline 311,373 - - -
New Reservoir Embankment Reinforcement - - 50,000 1,000,000
Uvalde Soccer Park - 70,000 70,000 -
SWTP Filter Underdrain Replacement 257,309 - - -
SWTP Electrical Generator Project - 150,000 50,000 100,000
Taylor Rd. Utility Adjustments (IH 2-Pecan) - - - 30,000
Ware Rd. Utility Adjustments (SH 107-Monte Cristo) - - - 20,000
Annual Waterline Replacement - - - 500,000
Annual Water Tower Rehabilitation - - - 700,000
ERP Project - - - 630,020
Total Capital Projects 586,792 1,579,200 697,090 3,407,020
TOTAL APPROPRIATIONS 1,484,006 3,083,570 2,167,551 4,626,185
Revenues over/(under) Expenditures 315,350 (1,379,565) (440,706) (2,958,205)
Adjustments for accruals (1,842,051) - - -
ENDING WORKING CAPITAL $ 6,545,207 $ 5,590,359 $ 6,104,502 $ 3,146,297
-150-
