Page 406 - ANALYSIS.XLS

City of McAllen, Texas
Inter-Departmental Service Fund
Working Capital Summary

Adjusted
Actual Budget Estimated Budget Four Year Plan
18-19 19-20 19-20 20-21 21-22 22-23 23-24 24-25
RESOURCES

BEGINNING WORKING CAPITAL $ 813,020 $ 961,323 $ 982,806 $ 507,146 $ 730,583 $ 832,044 $ 954,504 $ 1,101,965
Revenues:
Fleet Operations-Labor and Overhead 350,688 350,000 350,000 350,000 350,000 350,000 350,000 350,000
Fuel Charge Adjustment 122,471 120,000 115,000 120,000 120,000 120,000 120,000 120,000
Sales 4,493,599 3,700,000 4,700,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000
Miscellaneous 43,206 15,000 20,000 20,000 20,000 20,000 15,000 20,000
Total Revenues 5,009,964 4,185,000 5,185,000 4,490,000 4,090,000 4,090,000 4,190,000 4,495,000
TOTAL RESOURCES $ 5,822,984 $ 5,146,323 $ 6,167,806 $ 4,997,146 $ 4,820,583 $ 4,922,044 $ 5,144,504 $ 5,596,965

APPROPRIATIONS
Expenses:
Fleet Operations $ 4,630,744 $ 3,671,557 $ 4,792,607 $ 3,710,082 $ 3,808,645 $ 3,808,645 $ 3,808,645 $ 3,808,645
Materials Management 147,559 157,589 155,339 156,563 156,563 156,563 156,563 156,563
Insurance Liability & Workmen's Comp. 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600
Capital Outlay 36,729 933,600 678,600 382,700 21,000 - 75,000 57,800
Other Financing Sources (Uses):
Transfers Out - Health Insurance Fund 72,450 31,784 31,784 14,886 - - - -

Debt Service - Motorola Lease Payment 278 731 731 731 731 731 731 731

TOTAL APPROPRIATIONS 4,889,360 4,796,861 5,660,661 4,266,562 3,988,539 3,967,539 4,042,539 4,025,339
Other Items Affecting Working Capital 49,183 - - - - - - -
ENDING WORKING CAPITAL $ 982,806 $ 349,461 $ 507,146 $ 730,583 $ 832,044 $ 954,504 $ 1,101,965 $ 1,571,626

-356-