Page 258 - ANALYSIS.XLS

City of McAllen, Texas
Sanitation Fund
Working Capital Summary

Actual Adj. Budget Estimated Budget
18-19 19-20 19-20 20-21

RESOURCES
BEGINNING WORKING CAPITAL $ 11,271,259 $ 12,521,468 $ 13,405,909 $ 13,840,305

Revenues:
Residential Collection 6,421,845 6,550,000 6,350,000 6,475,000
Commercial Collection 8,606,968 8,550,000 8,325,000 8,350,000
Industrial Collection 268,071 260,000 250,000 250,000
Brush Collection 2,603,117 2,411,000 2,401,000 2,401,000
Recycling Fee 1,284,394 1,200,000 1,150,000 1,175,000
Recycling Sales 466,285 500,000 300,000 500,000
Drop-off Disposal Fee 445 2,000 1,000 2,000
Roll-off System 1,382,850 1,350,000 1,225,000 1,300,000
Composting 257,900 300,000 250,000 300,000
Brush Disposal 47,585 30,000 30,000 30,000
Garbage Franchise Tax 86,933 60,000 60,000 60,000

Fixed Assets - Sale of Property 84,386 - 40,000 -
Reimbursements - - 3,000 -
Miscellaneous 15,813 - 11,000 -

Interest Earned 295,713 - 94,000 138,403
Total Revenues 21,822,306 21,213,000 20,490,000 20,981,403

TOTAL RESOURCES $ 33,093,565 $ 33,734,468 $ 33,895,909 $ 34,821,708

APPROPRIATIONS

Expenses:
Composting $ 904,445 $ 878,516 $ 847,355 $ 879,141
Residential 3,892,746 3,998,841 3,817,964 3,940,932
Commercial Box 4,709,338 4,900,428 4,631,898 4,730,550
Roll-Off 1,009,649 1,042,725 977,982 1,072,760
Brush Collection 3,489,148 3,484,317 3,484,566 3,324,881
Recycling 1,676,819 1,726,773 1,728,492 1,761,634
Street Cleaning 470,736 530,171 527,961 508,754
Administration 2,697,853 2,469,133 2,280,581 2,456,933
Liability Insurance 104,034 104,034 104,034 104,034
Capital Outlay 568,032 1,544,500 1,413,437 1,130,450
Other Agencies 41,550 41,550 41,550 41,550
Total Operating Expenses 19,564,350 20,720,988 19,855,820 19,951,619

Other Financing Sources (Uses):
Transfers Out - Health Insurance Fund 455,401 199,784 199,784 103,496

TOTAL APPROPRIATIONS 20,019,751 20,920,772 20,055,604 20,055,115

Revenues over/(under) Expenditures 1,802,555 292,228 434,396 926,288
Other Items Affecting Working Capital 332,094 - - -

ENDING WORKING CAPITAL $ 13,405,909 $ 12,813,696 $ 13,840,305 $ 14,766,593

-208-