Appendix
Appendix B Fleet Replacement Plan – 5-year excerpt
November 8, 2022Page 352 sections
A 5-year financial plan (2023-2027) detailing projected vehicle replacement costs and reserve funding.
$1,485,000 total projected replacement costs in 2023$1,000,000 projected for 1991 Navistar replacement in 2026$1,400,000 projected for 1992 Superior E-One replacement in 2023
Appendix B
Page 35
Fleet Replacement Plan – 5-year excerpt
Town of View Royal
Fleet Replacement Plan
2023-2027 Financial Plan
| Vehicles | Fire / Municipal | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 |
|---|---|---|---|---|---|---|---|
| 1996 Kubota | Municipal | 81,600 | |||||
| 2019 Chevrolet Silverado 1/2 Ton | Municipal | ||||||
| 2003 Ford F350 - Dually Dump | Municipal | 100,000 | |||||
| 2004 Ford Ranger (Mitsubishi) | Municipal | ||||||
| 2006 Ford F350 - Single rear wheel drive | Municipal | 85,000 | |||||
| 2006 John Deere #2305 | Municipal | ||||||
| 2007 Chevrolet Silverado 1 Ton | Municipal | 85,000 | |||||
| 2007 John Deere #3520 | Municipal | ||||||
| 2010 Nissan Frontier | Municipal | 55,000 | |||||
| 2011 Ford Ranger Splash (Building) | Municipal | ||||||
| 2012 Mitsubishi Dump | Municipal | ||||||
| 2013 Honda Fit | Municipal | 55,000 | |||||
| 2015 Chevrolet Colorado (Bylaw) | Municipal | ||||||
| 2019 Hyundai Ionic | Municipal | ||||||
| 2019 Mack Emergency Rescue #36 | Fire | ||||||
| 1991 Navistar Int'l Brush Truck #32 | Fire | 1,000,000 | |||||
| 1992 Superior E-One #38 | Fire | 1,400,000 | |||||
| 2000 Zodiac #34 | Fire | 49,000 | |||||
| 2002 Chevrolet Venture | Fire | ||||||
| 2005 Smeal Spartan Aerial #35 | Fire | 47,000 | |||||
| 2009 Chevrolet Tahoe | Fire | ||||||
| 2012 Smeal Spartan Gladiator #39 | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2019 Chevrolet Tahoe | Fire | ||||||
| Subtotal | 262,600 | 1,485,000 | 55,000 | 100,000 | 1,000,000 | 55,000 |
| Funding source | Fire / Municipal | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 |
|---|---|---|---|---|---|---|---|
| Fire Dept M&E Reserve | Fire | (96,000) | - | - | - | - | - |
| Machinery & Equipment Reserve | Municipal | (166,600) | (85,000) | (55,000) | (100,000) | - | (55,000) |
| Debt | - | - | - | - | (1,000,000) | - | |
| Grants or other | - | (1,400,000) | - | - | - | - | |
| Subtotal | (262,600) | (1,485,000) | (55,000) | (100,000) | (1,000,000) | (55,000) | |
| Check | - | - | - | - | - | - |
Continuity Schedules
Fire Dept M&E Reserve
| 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | |
|---|---|---|---|---|---|---|
| Opening bal | 197,373 | 136,043 | 171,404 | 207,472 | 244,261 | 281,786 |
| Contribution | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 |
| Draws | (96,000) | - | - | - | - | - |
| Interest earned (assuming 2%) | 2,670 | 3,361 | 4,068 | 4,789 | 5,525 | 6,276 |
| Ending bal | 136,043 | 171,404 | 207,472 | 244,261 | 281,786 | 320,062 |
Machinery & Equipment Reserve
| 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | |
|---|---|---|---|---|---|---|
| Opening balance | 304,198 | 205,118 | 187,288 | 199,708 | 166,468 | 234,568 |
| Contribution | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 |
| Draws | (166,600) | (85,000) | (55,000) | (100,000) | - | (55,000) |
| Interest earned (assuming 2%) | 4,020 | 3,670 | 3,920 | 3,260 | 4,600 | 4,860 |
| Ending balance | 205,118 | 187,288 | 199,708 | 166,468 | 234,568 | 247,928 |
Page 35
Extracted from: 2022 11 08 Committee of the Whole Agenda - Agenda - Pdf