Appendix
Appendix B: Fleet Replacement Plan – 5-year excerpt
October 12, 2021Page 713 sections
Projected vehicle replacement costs and reserve balance continuity schedules for 2021-2026.
2023 replacement cost: $1,120,000 for Superior E-One2026 replacement cost: $850,000 for Brush Truck
Appendix B
Page 71
Fleet Replacement Plan – 5-year excerpt
Page 71
Town of View Royal
Fleet Replacement Plan
2022-2026 Financial Plan-Draft
| Vehicles | Fire / Municipal | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|---|
| 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 | 70,000 | |||||
| 2006 John Deere #2305 | Municipal | 40,000 | |||||
| 2007 Chevrolet Silverado 1 Ton | Municipal | 70,000 | |||||
| 2007 John Deere #3520 | Municipal | 56,400 | |||||
| 2010 Nissan Frontier | Municipal | 55,000 | |||||
| 2011 Ford Ranger Splash (Building) | Municipal | ||||||
| 2012 Mitsubishi Dump | Municipal | ||||||
| 2013 Honda Fit | Municipal | ||||||
| 2015 Chevrolet Colorado (Bylaw) | Municipal | ||||||
| 2019 Hyundai Ionic | Municipal | ||||||
| 1990 Mack Emergency Rescue | Fire | ||||||
| 1991 Navistar International Brush Truck | Fire | 850,000 | |||||
| 1992 Superior E-One | Fire | 1,120,000 | |||||
| 2000 Zodiac | Fire | 50,000 | |||||
| 2002 Chevrolet Venture | Fire | ||||||
| 2005 Smeal Spartan Aerial | Fire | 75,000 | |||||
| 2009 Chevrolet Tahoe | Fire | ||||||
| 2012 Smeal Spartan Gladiator | Fire | ||||||
| 2016 Ford F150 | Fire | 77,000 | |||||
| 2016 Ford F150 | Fire | 77,000 | |||||
| 2019 Chevrolet Tahoe | Fire | ||||||
| Subtotal | 303,000 | 70,000 | 1,190,000 | 55,000 | 100,000 | 1,004,000 |
| Funding source | Fire / Municipal | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|---|
| Fire Dept M&E Reserve | Fire | (125,000) | - | - | - | - | (154,000) |
| Machinery & Equipment Reserve | Municipal | (178,000) | (70,000) | (70,000) | (55,000) | (100,000) | - |
| Debt | - | - | (1,120,000) | - | - | (850,000) | |
| Grants or other | - | - | - | - | - | - | |
| Subtotal | (303,000) | (70,000) | (1,190,000) | (55,000) | (100,000) | (1,004,000) | |
| Check | - | - | - | - | - | - |
Continuity Schedules
Fire Dept M&E Reserve
| 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | ||
|---|---|---|---|---|---|---|---|
| Opening bal | 158,487 | 66,797 | 100,773 | 135,428 | 170,777 | 206,833 | |
| Contribution | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 |
| Draws | (125,000) | - | - | - | - | (154,000) | |
| Interest earned (assuming 2%) | 1,310 | 1,976 | 2,655 | 3,349 | 4,056 | 1,697 | |
| Ending bal | 66,797 | 100,773 | 135,428 | 170,777 | 206,833 | 86,530 |
Machinery & Equipment Reserve
| 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | ||
|---|---|---|---|---|---|---|---|
| Opening balance | 334,608 | 224,508 | 222,368 | 220,188 | 233,258 | 200,698 | |
| Contribution | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 |
| Draws | (178,000) | (70,000) | (70,000) | (55,000) | (100,000) | - | |
| Interest earned (assuming 2%) | 4,400 | 4,360 | 4,320 | 4,570 | 3,940 | 5,280 | |
| Ending balance | 224,508 | 222,368 | 220,188 | 233,258 | 200,698 | 269,478 |
Page 71
Extracted from: 2021 10 12 Committee of the Whole Agenda - Agenda - Pdf