Refuse Fund 540 - Residential Rate Increase Projections Prepared: February 22, 2023
Revenue Actual Projected (Inc rate proj - 8 mo.)
Key Object Revenue Description Est. % Incr. FY2122 FY2223 FY2324 FY2425 FY2526 FY2627 FY2728 CC Approved Residential Rate Increase 4.58% 3.02%
CM Proposed Residential Rate Increase 2.92% 4.48% 6.50% 6.50% 6.50% 540 347102 City - Recycling Fee 224,517.58 52,663.88 56,148.03 60,435.10 64,363.38 68,547.00 73,002.55 540 347110 Curbside Residential 14,179,311.01 14,804,815.50 15,784,276.04 16,989,452.23 18,093,766.63 19,269,861.46 20,522,402.45 540 347111 City Addl Automated Waste 484,797.63 521,864.46 556,390.09 598,872.12 637,798.81 679,255.74 723,407.36 540 347120 Driveway Residential 118,087.74 121,775.44 129,831.89 139,744.94 148,828.36 158,502.20 168,804.85 540 347130 Backyard Residential 28,511.63 29,196.24 31,127.81 33,504.51 35,682.31 38,001.66 40,471.76 540 347140 Disabled Residential 178,265.80 186,435.60 198,769.85 213,946.52 227,853.04 242,663.49 258,436.62 540 347200 Mobile Home Park 41,101.96 42,955.76 45,797.64 49,294.42 52,498.56 55,910.97 59,545.18 540 347250 Private Hauler Multi-Fam Units 78,692.86 82,981.56 88,471.47 95,226.53 101,416.26 108,008.31 115,028.85 540 347270 City Multi-Family Units 583,457.09 607,258.80 647,433.97 696,867.47 742,163.86 790,404.51 841,780.80 540 347430 Outside Contract - Hauler 5,703,412.06 5,954,743.86 6,348,699.23 6,833,441.21 7,277,614.89 7,750,659.86 8,254,452.75 540 347610 City Sale Addl Auto Container 2.0% 44,745.39 44,467.72 45,357.07 46,264.22 47,189.50 48,133.29 49,095.96 540 347902 Administrative Fees - Refuse 4.4% 6,896,559.25 6,785,000.00 7,083,540.00 7,395,215.76 7,720,605.25 8,060,311.88 8,414,965.61 540 348553 Enforecemnt Notice of Violation 800.00 - - - - - 540 353250 Parking Fines-Street Sweeping 5.0% 1,205,336.84 1,131,071.58 1,187,625.16 1,247,006.42 1,309,356.74 1,374,824.57 1,443,565.80 540 371100 Interest From Investments 2.0% 54,798.05 53,148.98 54,211.96 55,296.20 56,402.12 57,530.17 58,680.77 540 371110 GASB31 Adjustment (215,447.12) - - - - - 540 374200 Miscellaneous Receipts 4.0% 1,334.93 12,000.00 6,500.00 6,760.00 7,030.40 7,311.62 7,604.08 540 374421 Curbside Material Revenue - 214,977.82 - 0 0 0 0 540 985110 Operating Trnsfr from 110 Fund 693,718.00 - - - - - - 540 374801 Settlement Recovery - - - - - 540 380020 Sale of Equipment 7,500.00 - - - - - Total Revenue 30,302,000.70 30,652,857.20 32,264,180.22 34,461,327.66 36,522,570.11 38,709,926.72 41,031,245.39 Additional Funding Awarded
1. ARPA funds for 8 additional refuse trucks 4,000,000.00
2. ARPA funds for replacement revenues lost during COVID. 2,000,000.00
3. Additional Revenues for sweepers and refuse trucks 5,000,000.00 Total Revenue and Additional Revenue Expected 30,302,000.70 41,652,857.20 32,264,180.22 34,461,327.66 36,522,570.11 38,709,926.72 41,031,245.39 Expenditures Actual Projected
Section Est. % Incr. FY2122 FY2223 FY2324 FY2425 FY2526 FY2627 FY2728 4130000 PUBLIC WORKS - SOLID WASTE-ADMIN 3% 716,533.51 815,263.79 798,521.70 822,477.35 847,151.68 872,566.23 898,743.21 4130100 PUBLIC WORKS - COLLECTION 3% 16,936,892.57 22,148,816.85 21,147,973.30 21,782,412.50 22,435,884.87 23,108,961.42 23,802,230.26 4130200 PUBLIC WORKS - REFUSE DISPOSAL 3% 598,782.45 574,409.87 591,642.17 609,391.43 627,673.17 646,503.37 665,898.47 4130300 PUBLIC WORKS - PRIVATE HAULERS 3% 6,163,470.20 6,789,986.44 6,593,725.74 6,791,537.52 6,995,283.64 7,205,142.15 7,421,296.42 4130400 PUBLIC WORKS - STREET SWEEPING 3% 3,471,598.61 3,996,567.89 4,003,164.93 4,123,259.87 4,246,957.67 4,374,366.40 4,505,597.39 4130500 PUBLIC WORKS - SUNDRY/GG 142,251.36 140,528.06 140,528.06 140,528.06 140,528.06 140,528.06 140,528.06 000000 PUBLIC WORKS - FUND 540 BALANCE SHEET / REVENUE 1,441,925.33 (341,133.10) 212,287.08 212,287.08 212,287.08 212,287.08 212,287.08 Additional Budgeted Items
1. Current budget-$500K/Refuse Truck and $485K/Sweeper. Purchase add'l 2/1 in FY2324 through FY2728-Help keep fleet under 14 years. 600,000.00 600,000.00 600,000.00 600,000.00 600,000.00
2. Add 5-relief drivers to prior levels (increase coverage minimize OT) 3% 412,500.00 566,500.00 583,495.00 600,999.85 619,029.85
3. Add technology software technology needs - meet State requirements 0% 308,000.00 286,000.00 286,000.00 286,000.00 286,000.00
4. Add funding for Tequesquite Landfill Flare Station 1,200,000.00
5. Add 2 EC Inspectors to Sewer that utilize a portion of their time to assist with Refuse mandates 3% 30,000.00 30,900.00 31,827.00 32,781.81 33,765.26
6. Purchase 8 Refuse Trucks with ARPA funding, if received. 4,000,000.00
7. Purchase 10 Refuse Trucks/Sweepers with Additional funding, if received. 5,000,000.00 Total Expenditures 29,471,454.03 43,124,439.80 36,038,342.98 35,965,293.81 37,007,088.17 38,080,136.36 39,185,376.00 Projected Net Income/(Loss) 830,546.67 (1,471,582.60) (3,774,162.75) (1,503,966.16) (484,518.06) 629,790.36 1,845,869.39 Working Capital
Fund 540 - Beginning Refuse Fund Working Capital - Estimated 6,515,555.03 7,346,101.70 5,874,519.10 2,100,356.35 596,390.19 111,872.13 741,662.48 Increase / (Use of) Cash Reserves 830,546.67 (1,471,582.60) (3,774,162.75) (1,503,966.16) (484,518.06) 629,790.36 1,845,869.39 Fund 540 - Ending Refuse Fund Working Capital - Estimated 7,346,101.70$ 5,874,519.10$ 2,100,356.35$ 596,390.19$ 111,872.13$ 741,662.48$ 2,587,531.88$ Expenditure - Section Name
Revenue - Approved Rate Increases Revenue - Proposed Rate Increase Projections Expenditures - Current / Previous Yr.
Expenditures - 5-Yr Projections