Loading...
Kalispell SWMP_Final DraftSOLID WASTE MASTER PLAN SUBMITTED TO City of Kalispell, Montana May 15, 2024            MAY 2024 JUN 2024 JUL 2024 AUG 2024 SEPT 2024 OCT 2024 NOV 2024 DEC 2024 JAN 2025 FEB 2025 MAR 2025 APR 2025 MAY 2025 JUN 2025 JUL 2025 AUG 2025 SEPT 2025 OCT 2025 NOV 2025 DEC 2025 JAN 2026 FEB 2026 MAR 2026 APR 2026 MAY 2026 JUN 2026 JUL 2026 AUG 2026 OCT 2026 NOV 2026 DEC 2026 JAN 2027 FEB 2027 MAR 2027 APR 2027 MAY 2027 MAY 2024 JUN 2024 JUL 2024 AUG 2024 SEPT 2024 OCT 2024 NOV 2024 DEC 2024 JAN 2025 FEB 2025 MAR 2025 APR 2025 MAY 2025 JUN 2025 JUL 2025 AUG 2025 SEPT 2025 OCT 2025 NOV 2025 DEC 2025 JAN 2026 FEB 2026 MAR 2026 APR 2026 MAY 2026 JUN 2026 JUL 2026 AUG 2026 OCT 2026 NOV 2026 DEC 2026 JAN 2027 FEB 2027 MAR 2027 APR 2027 MAY 2027 Front Load Commercial Service Bulky Item Collection Planning for Growth Financial Policies Transition and Train Staff Develop Front Load Ordinance Make Front Load Policy Decisions Adopt Front Load Ordinance Procure Front Load Vehicles Public Education and Outreach Procure Dumpsters and Deliver to Customers Procure ASL Vehicle Make Policy Decisions Service Implementation - Cleanup Events Service Implementation - Scheduled Bulky Collection Make Policy Decisions Develop City-Wide Fee Ordinance Adopt City-Wide Fee Ordinance Service Implementation Develop Bulky Item Collection Ordinance Adopt Bulky Item Collection Ordinance Hire and Train ASL Operator Equipment Housing Expansion - Procurement of Design Firm Equipment Housing Expansion - Design Phase Equipment Housing Expansion - Construction Figure ES-1: Business Alternatives and Strategies Timeline                                                                                                                         MAY 2024 JUN 2024 JUL 2024 AUG 2024 SEPT 2024 OCT 2024 NOV 2024 DEC 2024 JAN 2025 FEB 2025 MAR 2025 APR 2025 MAY 2025 JUN 2025 JUL 2025 AUG 2025 SEPT 2025 OCT 2025 NOV 2025 DEC 2025 JAN 2026 FEB 2026 MAR 2026 APR 2026 MAY 2026 JUN 2026 JUL 2026 AUG 2026 OCT 2026 NOV 2026 DEC 2026 JAN 2027 FEB 2027 MAR 2027 APR 2027 MAY 2027 MAY 2024 JUN 2024 JUL 2024 AUG 2024 SEPT 2024 OCT 2024 NOV 2024 DEC 2024 JAN 2025 FEB 2025 MAR 2025 APR 2025 MAY 2025 JUN 2025 JUL 2025 AUG 2025 SEPT 2025 OCT 2025 NOV 2025 DEC 2025 JAN 2026 FEB 2026 MAR 2026 APR 2026 MAY 2026 JUN 2026 JUL 2026 AUG 2026 OCT 2026 NOV 2026 DEC 2026 JAN 2027 FEB 2027 MAR 2027 APR 2027 MAY 2027 Front Load Commercial Service Bulky Item Collection Planning for Growth Financial Policies Transition and Train Staff Develop Front Load Ordinance Make Front Load Policy Decisions Adopt Front Load Ordinance Procure Front Load Vehicles Public Education and Outreach Procure Dumpsters and Deliver to Customers Procure ASL Vehicle Make Policy Decisions Service Implementation - Cleanup Events Service Implementation - Scheduled Bulky Collection Make Policy Decisions Develop City-Wide Fee Ordinance Adopt City-Wide Fee Ordinance Service Implementation Develop Bulky Item Collection Ordinance Adopt Bulky Item Collection Ordinance Hire and Train ASL Operator Equipment Housing Expansion - Procurement of Design Firm Equipment Housing Expansion - Design Phase Equipment Housing Expansion - Construction Figure 7-1: Business Alternatives and Strategies Timeline Schedule 1: Test Year City of Kalispell Cost of Service and Rate Model DRAFT Account Account Description Actual FY 20/21 Actual FY21/22 Budget 22/23 Proposed Budget FY23/24 Adjustments Test Year Notes Collection 110 Salaries & Wages $407,955 $436,062 $526,843 $569,256 $40,222 $609,478 A 112 Severance $0 $14,859 $0 $0 $0 121 Overtime/Call Outs $5,284 $4,683 $6,500 $8,000 $8,000 153 Health Insurance $92,225 $90,730 $124,920 $110,316 $19,210 $129,526 A 155 Retirement - PERD $32,127 $36,108 $41,736 $45,597 $3,786 $49,383 A 213 Office Equip/ Computer Equip & Supplies $12,065 $12,962 $16,500 $16,500 $1,000 $17,500 A 218 Non Capital Equip.- Garbage Containers $36,577 $37,422 $69,125 $71,200 ($6,200)$65,000 A 229 Other Supplies/Safety Equip/Consumable Tools $4,176 $3,802 $5,500 $5,500 $1,000 $6,500 A 231 Gas and Oil $44,195 $78,362 $73,000 $116,000 $3,900 $119,900 A 341 Electricity $1,631 $1,408 $2,050 $2,050 $2,050 344 Natural Gas $2,214 $2,363 $4,500 $4,500 $4,500 345 Telephone $1,907 $2,198 $3,500 $3,500 $3,500 354 Contract & Consultant Services $9,281 $12,229 $122,000 $157,000 ($113,000)$44,000 B 362 Equipment Maint. & Supplies/Radios $1,277 $7,810 $55,000 $55,000 $55,000 366 Building Maintenance $3,787 $427 $5,000 $5,000 $5,000 373 Dues & Training $417 $1,043 $8,000 $10,000 $10,000 388 Medical Services $200 $1,045 $700 $900 $900 510 Property & Liability Ins. $20,507 $30,643 $24,861 $27,056 $4,352 $31,408 A 512 Uninsured Loss - Deductible $0 $0 $4,000 $4,000 $11,000 $15,000 A 521 Central Garage Transfer $88,650 $112,444 $92,039 $109,052 $3,708 $112,760 A 522 Administrative Transfer $41,572 $46,041 $43,982 $49,324 $11,773 $61,097 A 528 Information Tech. Transfer $33,293 $47,008 $41,978 $49,695 $7,682 $57,377 A 820 Alley Paving - transfer to Gas Tax $40,000 $40,000 $40,000 $40,000 $40,000 Miscellaneous Disposal Costs $3,500 $3,500 C Total Collection $892,839 $1,019,649 $1,311,734 $1,459,446 ($8,067)$1,451,379 Capital Outlay -Replacement (10120) 944 Machinery & Equipment $495,630 $6,257 $900,000 $900,000 ($900,000)$0 D 600 Debt Service - Garbage Truck $0 $0 $0 $57,938 $52,762 $110,700 E Total Capital Outlay - Replacement $495,630 $6,257 $900,000 $957,938 ($847,238)$110,700 Depreciation (fund replacement account) 831 Depreciation (fund replacement account)$150,000 $150,000 $150,000 $150,000 $50,000 $200,000 A Total Depreciation (fund replacement account)$150,000 $150,000 $150,000 $150,000 $50,000 $200,000 Total Expenses $1,538,469 $1,175,906 $2,361,734 $2,567,384 $1,762,079 Revenue Offsets 343410 Assessments $0 ($931,926)($1,120,000)($1,192,000)$1,192,000 $0 F 343410 Assessments-designated for equipment replacement $0 ($150,000)($150,000)($150,000)$150,000 $0 F 343420 garbage collections billed (part year)$0 ($30,293)($29,185)($30,000)$30,000 $0 F 363040 Penalty & Interest $0 ($3,259)($2,000)($2,000)($2,000) 371010 Interest Earnings $0 ($6,667)($5,000)($15,000)($15,000) Inception of loan - 5 Yr. Garbage Truck Loan $0 $0 $0 ($450,000)$450,000 $0 F 343360 Misc./Sale of Asset $0 ($2,510)($2,500)$0 $0 Total Revenue Offsets $0 ($1,124,655)($1,308,685)($1,839,000)$1,822,000 ($17,000) Total Revenue Requirement $1,538,469 $51,251 $1,053,049 $728,384 $1,016,695 $1,745,079 Notes A. B. C.Adjusted to reflect disposal and towing costs for abandoned vehicles and illegal dumping. D. E. F. Adjusted based on conversations with City staff on to reflect budgetted FY 2025 costs. Adjusted to reflect annualized consultancy costs, including Solid Waste Master Plan and cost of service updates. Adjusted to reflect test year budgeted cash purchases for capital improvement and vehicle replacement. Revenue zeroed out to reflect revenue requirement for reconciliation through rates. Adjusted to reflect test year interest payments of a 5-year loan for vehicle replacement. Principal amounting to $450,000 accounted for in FY 2024 budget. Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 2: Forecast City of Kalispell Cost of Service and Rate Model DRAFT Account Account Description Test Year Basis of Inflation FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Notes Collection 110 Salaries & Wages $609,478 Salary (Adjusted)$609,478 $756,376 $852,837 $891,215 $931,320 $973,229 $1,017,025 $1,062,791 $1,110,616 $1,160,594 112 Severance $0 No Inflation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 121 Overtime/Call Outs $8,000 Overtime $8,000 $9,928 $11,194 $11,698 $12,224 $12,775 $13,349 $13,950 $14,578 $15,234 153 Health Insurance $129,526 Healthcare (Adjusted)$129,526 $159,976 $179,514 $186,695 $194,163 $201,929 $210,006 $218,407 $227,143 $236,229 155 Retirement - PERD $49,383 Benefits (Adjusted)$49,383 $60,992 $68,442 $71,179 $74,026 $76,987 $80,067 $83,270 $86,600 $90,064 213 Office Equip/ Computer Equip & Supplies $17,500 General 1 $17,500 $18,095 $18,710 $19,346 $20,004 $20,684 $21,388 $22,115 $22,867 $23,644 218 Non Capital Equip.- Garbage Containers $65,000 General 1 $65,000 $67,210 $69,495 $71,858 $74,301 $76,827 $79,440 $82,140 $84,933 $87,821 229 Other Supplies/Safety Equip/Consumable Tools $6,500 Headcount (adjusted)$6,500 $7,446 $8,034 $8,235 $8,441 $8,652 $8,868 $9,090 $9,317 $9,550 231 Gas and Oil $119,900 Fuel (Adjusted)$119,900 $139,619 $167,004 $172,682 $178,553 $184,624 $190,901 $197,392 $204,103 $211,043 341 Electricity $2,050 General 1 $2,050 $2,120 $2,192 $2,266 $2,343 $2,423 $2,505 $2,591 $2,679 $2,770 344 Natural Gas $4,500 General 1 $4,500 $4,653 $4,811 $4,975 $5,144 $5,319 $5,500 $5,687 $5,880 $6,080 345 Telephone $3,500 General 1 $3,500 $3,619 $3,742 $3,869 $4,001 $4,137 $4,278 $4,423 $4,573 $4,729 354 Contract & Consultant Services $44,000 No Inflation $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 362 Equipment Maint. & Supplies/Radios $55,000 Equipment Maintenance (Adjusted)$55,000 $64,063 $74,789 $77,332 $79,961 $82,680 $85,491 $88,397 $91,403 $94,511 366 Building Maintenance $5,000 General 2 $5,000 $5,125 $5,253 $5,384 $5,519 $5,657 $5,798 $5,943 $6,092 $6,244 373 Dues & Training $10,000 Headcount (adjusted)$10,000 $11,456 $12,360 $12,669 $12,986 $13,311 $13,643 $13,985 $14,334 $14,693 388 Medical Services $900 General 2 $900 $923 $946 $969 $993 $1,018 $1,044 $1,070 $1,097 $1,124 510 Property & Liability Ins. $31,408 General 1 $31,408 $32,476 $33,580 $34,722 $35,902 $37,123 $38,385 $39,690 $41,040 $42,435 512 Uninsured Loss - Deductible $15,000 General 1 $15,000 $15,510 $16,037 $16,583 $17,146 $17,729 $18,332 $18,955 $19,600 $20,266 521 Central Garage Transfer $112,760 General 1 $112,760 $116,594 $120,558 $124,657 $128,895 $133,278 $137,809 $142,495 $147,340 $152,349 522 Administrative Transfer $61,097 Admin Transfer $61,097 $71,350 $79,075 $82,111 $85,272 $88,563 $91,988 $95,554 $99,267 $103,132 528 Information Tech. Transfer $57,377 General 1 $57,377 $59,328 $61,345 $63,431 $65,587 $67,817 $70,123 $72,507 $74,973 $77,522 820 Alley Paving - transfer to Gas Tax $40,000 No Inflation $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 Miscellaneous Disposal Costs $3,500 No Inflation $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 430840 Capital Outlay -Replacement (10120) 944 Machinery & Equipment $0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 600 Debt Service - Garbage Truck $110,700 No Inflation $110,700 $266,609 $469,311 $464,136 $368,961 $368,961 $288,120 $80,243 $80,243 $80,243 A Depreciation (fund replacement account) 831 Depreciation (fund replacement account)$200,000 General 1 $200,000 $206,800 $213,831 $221,101 $228,619 $236,392 $244,429 $252,740 $261,333 $270,218 B Total $1,762,079 $1,762,079 $2,167,767 $2,560,562 $2,634,615 $2,621,864 $2,707,616 $2,715,990 $2,600,934 $2,697,510 $2,797,994 Revenue Offsets 343410 Assessments $0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 343410 Assessments-designated for equipment replacement $0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 343420 garbage collections billed (part year)$0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 363040 Penalty & Interest ($2,000)Interest ($2,000)($2,000)($2,000)($2,000)($2,000)($2,000)($2,000)($2,000)($2,000)($2,000) 371010 Interest Earnings ($15,000)Interest ($15,000)($15,000)($15,000)($15,000)($15,000)($15,000)($15,000)($15,000)($15,000)($15,000) 0 Inception of loan - 5 Yr. Garbage Truck Loan $0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 343360 Misc./Sale of Asset $0 Not Used $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total ($17,000)($17,000)($17,000)($17,000)($17,000)($17,000)($17,000)($17,000)($17,000)($17,000)($17,000) Total Revenue Requirement $1,745,079 $1,745,079 $2,150,767 $2,543,562 $2,617,615 $2,604,864 $2,690,616 $2,698,990 $2,583,934 $2,680,510 $2,780,994 A. Debt Service schedule calculated based on current and future equipment and facility needs. B. Equipment replacement escalated to account for increasing cost of trucks over time Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 3: Year 1 Allocations City of Kalispell Cost of Service and Rate Model DRAFT Object Account Description FY 2025 Basis of Allocation Administration Residential 90- Gallon Containers 300&400-Gallon Containers Alley Cleanup Commercial Green Bin Collection Public Education and Outreach Spring Cleanup Animal Removal Junk Vehicle Removal Downtown Association Litter Abatement City Facilities Total Collection 110 Salaries & Wages $609,478 Salary 31%25%17%9%15%0%1%0%0%1%0%0%100% 112 Severance $0 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 121 Overtime/Call Outs $8,000 Overtime 0%32%21%12%19%0%15%1%0%1%0%0%100% 153 Health Insurance $129,526 Salary 31%25%17%9%15%0%1%0%0%1%0%0%100% 155 Retirement - PERD $49,383 Salary 31%25%17%9%15%0%1%0%0%1%0%0%100% 213 Office Equip/ Computer Equip & Supplies $17,500 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 218 Non Capital Equip.- Garbage Containers $65,000 Container Repair 0%65%29%0%6%0%0%0%0%0%0%0%100% 229 Other Supplies/Safety Equip/Consumable Tools $6,500 Headcount 25% 25% 16% 13% 18% 0% 1% 1% 0% 1% 0% 0%100% 231 Gas and Oil $119,900 Equipment Fuel 2%36%37%8%17%0%0%0%0%0%0%0%100% 341 Electricity $2,050 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 344 Natural Gas $4,500 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 345 Telephone $3,500 Equipment Count 12%28%33%10%17%0%0%0%0%0%0%0%100% 354 Contract & Consultant Services $44,000 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 362 Equipment Maint. & Supplies/Radios $55,000 Equipment Maintenance 0%33%40%8%17%0%0%0%0%0%0%0%100% 366 Building Maintenance $5,000 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 373 Dues & Training $10,000 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 388 Medical Services $900 Salary 31%25%17%9%15%0%1%0%0%1%0%0%100% 510 Property & Liability Ins. $31,408 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 512 Uninsured Loss - Deductible $15,000 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 521 Central Garage Transfer $112,760 Equipment Maintenance 0%33%40%8%17%0%0%0%0%0%0%0%100% 522 Administrative Transfer $61,097 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 528 Information Tech. Transfer $57,377 Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 820 Alley Paving - transfer to Gas Tax $40,000 Alley Paving 0%0%100%0%0%0%0%0%0%0%0%0%100% Miscellaneous Disposal Costs $3,500 Landfill Disposal 0%0%0%0%0%0%0%0%33%0%67%0%100% Capital Outlay -Replacement (10120) 944 Machinery & Equipment $0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% 600 Debt Service - Garbage Truck $110,700 CIP 0%50%50%0%0%0%0%0%0%0%0%0%100% Depreciation (fund replacement account) 831 Depreciation (fund replacement account)$200,000 Depreciation 4%31%38%8%18%0%1%0%1%0%0%0%100% Total Expenses $1,762,079 Revenue Offsets 343410 Assessments $0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% 343410 Assessments-designated for equipment replacement $0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% 343420 garbage collections billed (part year)$0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% 363040 Penalty & Interest ($2,000)Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% 371010 Interest Earnings ($15,000)Direct-Administration 100%0%0%0%0%0%0%0%0%0%0%0%100% Inception of loan - 5 Yr. Garbage Truck Loan $0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% 343360 Misc./Sale of Asset $0 Not Used 0%0%0%0%0%0%0%0%0%0%0%0%0% Total Revenue Offsets ($17,000) Total Revenue Requirement $1,745,079 Burns & McDonnell Page 1 of 2 5/14/2024 Schedule 3: Year 1 Allocations City of Kalispell Cost of Service and Rate Model DRAFT Object Account Description FY 2025 Basis of Allocation Collection 110 Salaries & Wages $609,478 Salary 112 Severance $0 Direct-Administration 121 Overtime/Call Outs $8,000 Overtime 153 Health Insurance $129,526 Salary 155 Retirement - PERD $49,383 Salary 213 Office Equip/ Computer Equip & Supplies $17,500 Direct-Administration 218 Non Capital Equip.- Garbage Containers $65,000 Container Repair 229 Other Supplies/Safety Equip/Consumable Tools $6,500 Headcount 231 Gas and Oil $119,900 Equipment Fuel 341 Electricity $2,050 Direct-Administration 344 Natural Gas $4,500 Direct-Administration 345 Telephone $3,500 Equipment Count 354 Contract & Consultant Services $44,000 Direct-Administration 362 Equipment Maint. & Supplies/Radios $55,000 Equipment Maintenance 366 Building Maintenance $5,000 Direct-Administration 373 Dues & Training $10,000 Direct-Administration 388 Medical Services $900 Salary 510 Property & Liability Ins. $31,408 Direct-Administration 512 Uninsured Loss - Deductible $15,000 Direct-Administration 521 Central Garage Transfer $112,760 Equipment Maintenance 522 Administrative Transfer $61,097 Direct-Administration 528 Information Tech. Transfer $57,377 Direct-Administration 820 Alley Paving - transfer to Gas Tax $40,000 Alley Paving Miscellaneous Disposal Costs $3,500 Landfill Disposal Capital Outlay -Replacement (10120) 944 Machinery & Equipment $0 Not Used 600 Debt Service - Garbage Truck $110,700 CIP Depreciation (fund replacement account) 831 Depreciation (fund replacement account)$200,000 Depreciation Total Expenses $1,762,079 Revenue Offsets 343410 Assessments $0 Not Used 343410 Assessments-designated for equipment replacement $0 Not Used 343420 garbage collections billed (part year)$0 Not Used 363040 Penalty & Interest ($2,000)Direct-Administration 371010 Interest Earnings ($15,000)Direct-Administration Inception of loan - 5 Yr. Garbage Truck Loan $0 Not Used 343360 Misc./Sale of Asset $0 Not Used Total Revenue Offsets ($17,000) Total Revenue Requirement $1,745,079 Administration Residential 90- Gallon Containers 300&400-Gallon Containers Alley Cleanup Commercial Green Bin Collection Public Education and Outreach Spring Cleanup Animal Removal Junk Vehicle Removal Downtown Association Litter Abatement City Facilities Total $190,084 $154,979 $102,823 $56,441 $92,201 $718 $4,273 $2,974 $291 $3,287 $917 $490 $609,478 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,536 $1,683 $924 $1,509 $0 $1,223 $49 $0 $54 $15 $8 $8,000 $40,397 $32,936 $21,852 $11,995 $19,595 $153 $908 $632 $62 $699 $195 $104 $129,526 $15,402 $12,557 $8,331 $4,573 $7,471 $58 $346 $241 $24 $266 $74 $40 $49,383 $17,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,500$0 $41,997 $18,987 $0 $4,015 $0 $0 $0 $0 $0 $0 $0 $65,000 $1,599 $1,653 $1,072 $837 $1,146 $7 $57 $41 $2 $69 $11 $6 $6,500 $2,127 $42,735 $44,214 $9,081 $20,725 $56 $289 $243 $233 $56 $125 $16 $119,900 $2,050 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,050 $4,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,500 $412 $978 $1,142 $350 $587 $4 $10 $6 $4 $4 $2 $0 $3,500 $44,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $44,000 $154 $18,411 $22,253 $4,178 $9,547 $14 $154 $83 $140 $14 $46 $6 $55,000$5,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,000$10,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,000 $281 $229 $152 $83 $136 $1 $6 $4 $0 $5 $1 $1 $900 $31,408 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,408 $15,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $15,000 $316 $37,746 $45,623 $8,566 $19,574 $29 $315 $171 $286 $29 $94 $12 $112,760 $61,097 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $61,097 $57,377 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $57,377$0 $0 $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000$0 $0 $0 $0 $0 $0 $0 $0 $1,155 $0 $2,345 $0 $3,500 $498,703 $346,757 $308,132 $97,027 $176,506 $1,040 $7,582 $4,445 $2,196 $4,483 $3,826 $683 $1,451,379 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $55,350 $55,350 $0 $0 $0 $0 $0 $0 $0 $0 $0 $110,700 $0 $55,350 $55,350 $0 $0 $0 $0 $0 $0 $0 $0 $0 $110,700 $8,314 $61,905 $75,510 $16,024 $36,130 $0 $1,058 $0 $1,058 $0 $0 $0 $200,000$8,314 $61,905 $75,510 $16,024 $36,130 $0 $1,058 $0 $1,058 $0 $0 $0 $200,000 $507,017 $464,012 $438,992 $113,051 $212,636 $1,040 $8,640 $4,445 $3,254 $4,483 $3,826 $683 $1,762,079 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($2,000) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($2,000)($15,000) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($15,000)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($17,000)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($17,000) $490,017 $464,012 $438,992 $113,051 $212,636 $1,040 $8,640 $4,445 $3,254 $4,483 $3,826 $683 $3,507,158 Burns & McDonnell Page 2 of 2 5/14/2024 Schedule 4: Revenue Requirement City of Kalispell Cost of Service and Rate Model DRAFT Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Administration $490,017 $518,080 $542,930 $563,261 $584,418 $606,434 $629,344 $653,187 $678,001 $703,825 Residential 90-Gallon Containers $464,012 $509,397 $602,440 $616,754 $586,739 $605,011 $624,009 $560,613 $581,155 $602,517 300&400-Gallon Containers $438,992 $475,449 $732,360 $748,544 $720,465 $740,741 $761,815 $658,993 $681,760 $705,424 Alley Cleanup $113,051 $193,945 $199,540 $206,678 $214,112 $221,855 $208,094 $216,496 $225,248 $234,365 Commercial Green Bin Collection $212,636 $424,886 $436,252 $451,278 $466,924 $483,215 $441,973 $459,638 $478,033 $497,189 Public Education and Outreach $1,040 $1,094 $1,137 $1,185 $1,235 $1,287 $1,342 $1,399 $1,458 $1,520 Spring Cleanup $8,640 $10,487 $10,958 $11,377 $11,814 $12,269 $11,934 $12,429 $12,944 $13,481 Animal Removal $4,445 $4,696 $4,878 $5,083 $5,297 $5,520 $5,753 $5,995 $6,249 $6,513 Junk Vehicle Removal $3,254 $3,402 $3,447 $3,526 $3,607 $3,691 $3,778 $3,869 $3,962 $4,059 Downtown Association $4,483 $4,692 $4,895 $5,107 $5,328 $5,559 $5,800 $6,051 $6,314 $6,588 Litter Abatement $3,826 $3,921 $3,976 $4,043 $4,113 $4,185 $4,261 $4,340 $4,423 $4,509 City Facilities $683 $718 $748 $780 $813 $848 $885 $923 $963 $1,004 Total Revenue Requirement $1,745,079 $2,150,767 $2,543,562 $2,617,615 $2,604,864 $2,690,616 $2,698,990 $2,583,934 $2,680,510 $2,780,994 Cost Center Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 5: Residential Cost of Service City of Kalispell Cost of Service and Rate Model DRAFT Cost Centers FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Administration $311,854 $329,714 $345,528 $358,467 $371,932 $385,943 $400,524 $415,697 $431,489 $447,924 Residential 90-Gallon Containers $443,535 $486,918 $575,855 $589,537 $560,847 $578,312 $596,473 $535,874 $555,510 $575,928 300&400-Gallon Containers $244,760 $265,087 $408,328 $417,351 $401,696 $413,001 $424,751 $367,422 $380,116 $393,310 Alley Cleanup $113,051 $193,945 $199,540 $206,678 $214,112 $221,855 $208,094 $216,496 $225,248 $234,365 Public Education and Outreach $347 $365 $379 $395 $412 $429 $447 $466 $486 $507 Spring Cleanup $8,640 $10,487 $10,958 $11,377 $11,814 $12,269 $11,934 $12,429 $12,944 $13,481 Total Residential Revenue Requirement $1,122,188 $1,286,515 $1,540,589 $1,583,805 $1,560,812 $1,611,809 $1,642,223 $1,548,385 $1,605,793 $1,665,515 Residential Customers 90-gallon 3,859 3,951 4,045 4,141 4,240 4,341 4,445 4,551 4,660 4,771 300-gallon 3,574 3,574 3,574 3,574 3,574 3,574 3,574 3,574 3,574 3,574 Total 7,433 7,524 7,619 7,715 7,814 7,915 8,019 8,125 8,233 8,345 Cost Centers Administration $3.50 $3.65 $3.78 $3.87 $3.97 $4.06 $4.16 $4.26 $4.37 $4.47 Residential 90-Gallon Containers $4.97 $5.39 $6.30 $6.37 $5.98 $6.09 $6.20 $5.50 $5.62 $5.75 300&400-Gallon Containers $2.74 $2.94 $4.47 $4.51 $4.28 $4.35 $4.41 $3.77 $3.85 $3.93 Alley Cleanup $1.27 $2.15 $2.18 $2.23 $2.28 $2.34 $2.16 $2.22 $2.28 $2.34 Commercial Green Bin Collection $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Public Education and Outreach $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 Spring Cleanup $0.10 $0.12 $0.12 $0.12 $0.13 $0.13 $0.12 $0.13 $0.13 $0.13 Cost of Service per Household per Month $12.58 $14.25 $16.85 $17.11 $16.65 $16.97 $17.07 $15.88 $16.25 $16.63 Cost of Service per Household per Assessment $151 $171 $202 $205 $200 $204 $205 $191 $195 $200 Residential Assessment $141 $148 $148 $148 $148 $148 $148 $148 $148 $148 Difference ($10)($23)($54)($57)($52)($56)($57)($43)($47)($52) Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 6: Commercial 300 & 400-Gallon Cost of Service City of Kalispell Cost of Service and Rate Model DRAFT Cost Centers FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Administration $58,292 $61,630 $64,586 $67,005 $69,522 $72,141 $74,866 $77,702 $80,654 $83,726 300&400-Gallon Containers $183,150 $198,360 $305,545 $312,297 $300,582 $309,042 $317,834 $274,936 $284,434 $294,307 Public Education and Outreach $347 $365 $379 $395 $412 $429 $447 $466 $486 $507 Total Residential Revenue Requirement $241,789 $260,355 $370,510 $379,697 $370,516 $381,611 $393,147 $353,104 $365,575 $378,540 Collection $241,789 $260,355 $370,510 $379,697 $370,516 $381,611 $393,147 $353,104 $365,575 $378,540 Disposal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Residential Revenue Requirement $241,789 $260,355 $370,510 $379,697 $370,516 $381,611 $393,147 $353,104 $365,575 $378,540 Commercial 300-gallon Customers 315 319 324 328 332 337 341 346 350 355 Annual 300-gallon Collections 23,183 23,490 23,801 24,116 24,436 24,759 25,087 25,420 25,756 26,097 300-gallon Collections per Month 1,932 1,958 1,983 2,010 2,036 2,063 2,091 2,118 2,146 2,175 400-gallon Customers 173 173 173 173 173 173 173 173 173 173 Annual 400-gallon Collections 14,456 14,456 14,456 14,456 14,456 14,456 14,456 14,456 14,456 14,456 400-gallon Collections per Month 1,205 1,205 1,205 1,205 1,205 1,205 1,205 1,205 1,205 1,205 Cost per Collection $6.42 $6.86 $9.68 $9.84 $9.53 $9.73 $9.94 $8.86 $9.09 $9.33 Commercial Gallons in the Field 163,736 164,988 166,256 167,542 168,844 170,164 171,501 172,856 174,229 175,620 Annual Gallons Collected 12,737,309 12,829,422 12,922,755 13,017,324 13,113,145 13,210,236 13,308,612 13,408,292 13,509,291 13,611,628 Disposal Cost per Gallon $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Burns & McDonnell Page 1 of 2 5/14/2024 Schedule 6: Commercial 300 & 400-Gallon Cost of Service City of Kalispell Cost of Service and Rate Model DRAFT 1 2 3 4 5 FY 2025 300-gallons $27.84 $55.67 $83.51 $111.35 $139.18 400-gallons $27.84 $55.67 $83.51 $111.35 $139.18 FY 2026 300-gallons $29.73 $59.46 $89.20 $118.93 $148.66 400-gallons $29.73 $59.46 $89.20 $118.93 $148.66 FY 2027 300-gallons $41.97 $83.93 $125.90 $167.87 $209.84 400-gallons $41.97 $83.93 $125.90 $167.87 $209.84 FY 2028 300-gallons $42.66 $85.31 $127.97 $170.62 $213.28 400-gallons $42.66 $85.31 $127.97 $170.62 $213.28 FY 2029 300-gallons $41.28 $82.57 $123.85 $165.13 $206.41 400-gallons $41.28 $82.57 $123.85 $165.13 $206.41 FY 2030 300-gallons $42.17 $84.34 $126.50 $168.67 $210.84 400-gallons $42.17 $84.34 $126.50 $168.67 $210.84 FY 2031 300-gallons $43.08 $86.17 $129.25 $172.33 $215.41 400-gallons $43.08 $86.17 $129.25 $172.33 $215.41 FY 2032 300-gallons $38.37 $76.74 $115.12 $153.49 $191.86 400-gallons $38.37 $76.74 $115.12 $153.49 $191.86 FY 2033 300-gallons $39.39 $78.79 $118.18 $157.58 $196.97 400-gallons $39.39 $78.79 $118.18 $157.58 $196.97 FY 2034 300-gallons $40.45 $80.90 $121.35 $161.80 $202.24 400-gallons $40.45 $80.90 $121.35 $161.80 $202.24 Monthly Refuse Cost of Service Based on Collections per WeekCommercial 300&400-gallon Collections Burns & McDonnell Page 2 of 2 5/14/2024 Schedule 7: Commercial Green Bin Cost of Service City of Kalispell Cost of Service and Rate Model DRAFT Cost Centers FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Administration $98,995 $104,664 $109,685 $113,792 $118,066 $122,514 $127,142 $131,959 $136,972 $142,189 Commercial Green Bin Collection $212,636 $424,886 $436,252 $451,278 $466,924 $483,215 $441,973 $459,638 $478,033 $497,189 Public Education and Outreach $347 $365 $379 $395 $412 $429 $447 $466 $486 $507 Total Residential Revenue Requirement $311,978 $529,915 $546,316 $565,465 $585,401 $606,158 $569,563 $592,064 $615,492 $639,885 Collection Cost $311,978 $529,915 $546,316 $565,465 $585,401 $606,158 $569,563 $592,064 $615,492 $639,885 Disposal Cost $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Cost $311,978 $529,915 $546,316 $565,465 $585,401 $606,158 $569,563 $592,064 $615,492 $639,885 Commercial Green Bin Customers 155 157 159 161 163 166 168 170 172 175 Annual Green Bin Collections 19,864 20,127 20,393 20,663 20,937 21,214 21,495 21,780 22,068 22,361 Green Bin Collections per Month 1,655 1,677 1,699 1,722 1,745 1,768 1,791 1,815 1,839 1,863 Cost per Collection $15.71 $26.33 $26.79 $27.37 $27.96 $28.57 $26.50 $27.18 $27.89 $28.62 Annual Cubic Yards Collected 39,727 40,253 40,787 41,327 41,874 42,429 42,991 43,560 44,137 44,722 Annual Gallons Collected 8,023,879 8,130,150 8,237,828 8,346,932 8,457,481 8,569,495 8,682,992 8,797,992 8,914,515 9,032,582 Disposal Cost per CY $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Disposal Cost per Gallon $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Cost per CY $7.85 $13.16 $13.39 $13.68 $13.98 $14.29 $13.25 $13.59 $13.95 $14.31 Cost per Gallon $0.04 $0.07 $0.07 $0.07 $0.07 $0.07 $0.07 $0.07 $0.07 $0.07 2 CY Green Bins 1 2 3 4 5 FY 2025 $68.06 $136.12 $204.18 $272.24 $340.30 FY 2026 $114.09 $228.18 $342.28 $456.37 $570.46 FY 2027 $116.09 $232.17 $348.26 $464.34 $580.43 FY 2028 $118.58 $237.17 $355.75 $474.34 $592.92 FY 2029 $121.16 $242.32 $363.48 $484.64 $605.80 FY 2030 $123.82 $247.63 $371.45 $495.27 $619.08 FY 2031 $114.82 $229.64 $344.46 $459.28 $574.10 FY 2032 $117.80 $235.59 $353.39 $471.19 $588.98 FY 2033 $120.86 $241.71 $362.57 $483.43 $604.29 FY 2034 $124.00 $248.01 $372.01 $496.02 $620.02 Monthly Refuse Cost of Service Based on Collections per Week Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 8: Additional City Services Cost of Service City of Kalispell Cost of Service and Rate Model DRAFT Cost Centers FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Administration $20,877 $22,072 $23,131 $23,997 $24,898 $25,836 $26,812 $27,828 $28,885 $29,986 Residential 90-Gallon Containers $20,476 $22,479 $26,585 $27,217 $25,892 $26,698 $27,537 $24,739 $25,646 $26,588 300&400-Gallon Containers $11,082 $12,002 $18,487 $18,896 $18,187 $18,699 $19,231 $16,635 $17,210 $17,807 Animal Removal $4,445 $4,696 $4,878 $5,083 $5,297 $5,520 $5,753 $5,995 $6,249 $6,513 Junk Vehicle Removal $3,254 $3,402 $3,447 $3,526 $3,607 $3,691 $3,778 $3,869 $3,962 $4,059 Downtown Association $4,483 $4,692 $4,895 $5,107 $5,328 $5,559 $5,800 $6,051 $6,314 $6,588 Litter Abatement $3,826 $3,921 $3,976 $4,043 $4,113 $4,185 $4,261 $4,340 $4,423 $4,509 City Facilities $683 $718 $748 $780 $813 $848 $885 $923 $963 $1,004 Total Additional City Services Revenue Requirement $69,125 $73,982 $86,147 $88,648 $88,135 $91,037 $94,057 $90,381 $93,651 $97,054 Total City Parcels 10,617 10,617 10,617 10,617 10,617 10,617 10,617 10,617 10,617 10,617 Annual Revenue Requirement per Total Parcels $6.51 $6.97 $8.11 $8.35 $8.30 $8.57 $8.86 $8.51 $8.82 $9.14 Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 9: Current Revenue City of Kalispell Cost of Service and Rate Model DRAFT FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Residential Curbside $489,073 $526,187 $539,341 $552,825 $566,645 $580,812 $595,332 $610,215 $625,471 $641,107 300-gallon Alley $503,912 $528,929 $528,929 $528,929 $528,929 $528,929 $528,929 $528,929 $528,929 $528,929 Total Residential Revenue $992,985 $1,055,116 $1,068,271 $1,081,754 $1,095,575 $1,109,741 $1,124,261 $1,139,145 $1,154,400 $1,170,037 Commercial 90-gallon $55,004 $58,499 $59,274 $60,059 $60,855 $61,661 $62,477 $63,305 $64,143 $64,993 300-gallon $190,814 $202,828 $205,514 $208,236 $210,994 $213,788 $216,620 $219,489 $222,396 $225,341 400-gallon $145,116 $152,344 $152,344 $152,344 $152,344 $152,344 $152,344 $152,344 $152,344 $152,344 Green Bin $199,400 $212,105 $214,914 $217,760 $220,644 $223,567 $226,528 $229,528 $232,568 $235,648 Total Commercial Revenue $590,335 $625,776 $632,046 $638,399 $644,837 $651,360 $657,969 $664,665 $671,451 $678,326 Total Solid Waste Revenue $1,583,320 $1,680,892 $1,700,317 $1,720,154 $1,740,412 $1,761,100 $1,782,230 $1,803,810 $1,825,851 $1,848,362 Burns & McDonnell Page 1 of 1 5/14/2024 Schedule 10: Net Revenue City of Kalispell Cost of Service and Rate Model DRAFT FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 FY 2032 FY 2033 FY 2034 Residential Revenue Requirement ($1,122,188)($1,286,515)($1,540,589)($1,583,805)($1,560,812)($1,611,809)($1,642,223)($1,548,385)($1,605,793)($1,665,515) Revenue $1,047,989 $1,113,615 $1,127,545 $1,141,813 $1,156,429 $1,171,402 $1,186,738 $1,202,449 $1,218,543 $1,235,029 Net Revenue ($74,199)($172,900)($413,044)($441,992)($404,382)($440,407)($455,484)($345,936)($387,250)($430,486) Commercial 300&400-gallon Revenue Requirement ($241,789)($260,355)($370,510)($379,697)($370,516)($381,611)($393,147)($353,104)($365,575)($378,540) Revenue $335,930 $355,172 $357,858 $360,580 $363,338 $366,132 $368,964 $371,833 $374,740 $377,685 Net Revenue $94,142 $94,817 ($12,652)($19,117)($7,178)($15,479)($24,184)$18,728 $9,165 ($855) Commercial Green Bin Revenue Requirement ($311,978)($529,915)($546,316)($565,465)($585,401)($606,158)($569,563)($592,064)($615,492)($639,885) Revenue $199,400 $212,105 $214,914 $217,760 $220,644 $223,567 $226,528 $229,528 $232,568 $235,648 Net Revenue ($112,577)($317,810)($331,402)($347,705)($364,757)($382,591)($343,035)($362,536)($382,924)($404,237) Additional City Services Revenue Requirement ($69,125)($73,982)($86,147)($88,648)($88,135)($91,037)($94,057)($90,381)($93,651)($97,054) Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Net Revenue ($69,125)($73,982)($86,147)($88,648)($88,135)($91,037)($94,057)($90,381)($93,651)($97,054) Total Revenue Requirement ($1,745,079)($2,150,767)($2,543,562)($2,617,615)($2,604,864)($2,690,616)($2,698,990)($2,583,934)($2,680,510)($2,780,994) Total Revenue $1,583,320 $1,680,892 $1,700,317 $1,720,154 $1,740,412 $1,761,100 $1,782,230 $1,803,810 $1,825,851 $1,848,362 Total Net Revenue ($161,759)($469,875)($843,245)($897,461)($864,453)($929,515)($916,760)($780,124)($854,659)($932,632) Cumulative Net Revenue ($161,759)($631,635)($1,474,880)($2,372,341)($3,236,794)($4,166,309)($5,083,069)($5,863,193)($6,717,853)($7,650,485) Reserve Requirement $698,032 $860,307 $1,017,425 $1,047,046 $1,041,946 $1,076,246 $1,079,596 $1,033,574 $1,072,204 $1,112,398 Beginning Balance $1,029,276 $867,517 $397,641 ($445,604)($1,343,065)($2,207,518)($3,137,033)($4,053,793)($4,833,917)($5,688,577) Total Net Revenue ($161,759)($469,875)($843,245)($897,461)($864,453)($929,515)($916,760)($780,124)($854,659)($932,632) Ending Balance $867,517 $397,641 ($445,604)($1,343,065)($2,207,518)($3,137,033)($4,053,793)($4,833,917)($5,688,577)($6,621,209) Over/Under Reserve Requirement $169,485 ($462,666)($1,463,028)($2,390,111)($3,249,463)($4,213,279)($5,133,389)($5,867,491)($6,760,781)($7,733,606) Burns & McDonnell Page 1 of 1 5/14/2024 6200 Bridge Point Pkwy #400 Austin, TX 78730 burnsmcd.com