Appendix
Appendix B Fleet Replacement Plan – 5-year excerpt
October 10, 2023Page 352 sections
Financial forecast for vehicle replacements from 2023 through 2028, detailing funding sources.
2024 planned vehicle expenditures: $1,805,000Fire Dept M&E Reserve contribution: $56,000 annuallyMachinery & Equipment Reserve contribution: $63,500 annually
Report to Committee of the Whole
Re: Vehicle Fleet Replacement Plan Meeting Date: October 10, 2023
Page 35
Appendix B: Fleet Replacement Plan – 5-year excerpt
Town of View Royal Fleet Replacement Plan 2024-2028 Financial Plan
| Vehicles | Fire / Municipal | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|
| 1996 Kubota | Municipal | 33,000 | |||||
| 2003 Ford F350 - Dually Dump | Municipal | 100,000 | |||||
| 2010 Nissan Frontier | Municipal | 55,000 | |||||
| 2011 Ford Ranger Splash | Municipal | ||||||
| 2012 Mitsubishi Dump | Municipal | ||||||
| 2013 Honda Fit | Municipal | 55,000 | |||||
| 2019 Chevrolet Silverado 1500 | Municipal | ||||||
| 2019 Hyundai Ionic | Municipal | ||||||
| 2020 Mitsubishi PHEV | Municipal | ||||||
| 2021 John Deere #1025R | Municipal | ||||||
| 2021 John Deere #3039R | Municipal | ||||||
| 2023 Chevrolet Silverado 1500 | Municipal | 62,000 | |||||
| 2023 Chevrolet 1 Ton | Municipal | 85,000 | |||||
| 1991 Navistar Int'l Brush Truck #32 | Fire | 350,000 | |||||
| 1992 Superior E-One #38 | Fire | 1,400,000 | |||||
| 2000 Zodiac #34 | Fire | ||||||
| 2002 Chevrolet Venture #300 | Fire | 55,000 | |||||
| 2005 Smeal Spartan Aerial #35 | Fire | ||||||
| 2009 Chevrolet Tahoe #31 | Fire | ||||||
| 2012 Smeal Spartan Gladiator #39 | Fire | ||||||
| 2015 Chevrolet Colorado #302 | Fire | ||||||
| 2016 Ford F150 #33 | Fire | ||||||
| 2016 Ford F150 #37 | Fire | ||||||
| 2019 Chevrolet Tahoe #30 | Fire | ||||||
| 2019 SVI Emergency Rescue #36 | Fire | ||||||
| Fire Hose Inventory | Fire | 25,000 | 27,600 | ||||
| SCBA Inventory | Fire | 35,000 | 38,600 | ||||
| Subtotal | 240,000 | 1,805,000 | 155,000 | - | 55,000 | 66,200 |
Funding Source
| Funding source | Fire / Municipal | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|
| Fire Dept M&E Reserve | Fire | (60,000) | - | (55,000) | - | - | (66,200) |
| Machinery & Equipment Reserve | Municipal | (180,000) | (55,000) | (100,000) | - | (55,000) | - |
| Debt | - | - | - | - | - | - | |
| Grants or other | - | (1,750,000) | - | - | - | - | |
| Subtotal | (240,000) | (1,805,000) | (155,000) | - | (55,000) | (66,200) | |
| Check | - | - | - | - | - | - |
Continuity Schedules
Fire Dept M&E Reserve
| Description | Annual Contribution | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|
| Opening bal | 140,089 | 114,331 | 173,738 | 178,233 | 238,918 | 300,816 | |
| Contribution | 56,000 | 32,000 | 56,000 | 56,000 | 56,000 | 56,000 | 56,000 |
| Draws | (60,000) | - | (55,000) | - | - | (66,200) | |
| Interest earned (assuming 2%) | 2,242 | 3,407 | 3,495 | 4,685 | 5,898 | 5,812 | |
| Ending bal | 114,331 | 173,738 | 178,233 | 238,918 | 300,816 | 296,428 |
Machinery & Equipment Reserve
| Description | Annual Contribution | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|
| Opening balance | 371,044 | 259,634 | 273,494 | 241,734 | 311,334 | 326,234 | |
| Contribution | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 |
| Draws | (180,000) | (55,000) | (100,000) | - | (55,000) | - | |
| Interest earned (assuming 2%) | 5,090 | 5,360 | 4,740 | 6,100 | 6,400 | 7,790 | |
| Ending balance | 259,634 | 273,494 | 241,734 | 311,334 | 326,234 | 397,524 |
Page 35
Extracted from: 2023 10 10 Committee of the Whole Agenda - Agenda - Pdf