Appendix
Appendix B Fleet Replacement Plan – 5-year excerpt
November 10, 2020Page 762 sections
Financial projection for fleet replacement spending and reserve fund continuity through 2025.
$740,000 in debt planned for 2022 fire vehicle replacement$380,000 fire replacement planned for 2021
Appendix B
Page 76
Fleet Replacement Plan – 5-year excerpt
Town of View Royal Fleet Replacement Plan 2021-2025 Financial Plan-Draft
| Vehicles | Fire / Municipal | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|---|---|
| 1996 Kubota | Municipal | 81,600 | |||||
| 2001 Chevrolet Silverado 1/2 Ton | Municipal | ||||||
| 2003 Ford F350 - Dually Dump | Municipal | 100,000 | |||||
| 2004 Ford Ranger | Municipal | 45,000 | |||||
| 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 | 520,000 | |||||
| 1991 Navistar International Brush Truck | Fire | ||||||
| 1992 Superior E-One | Fire | 380,000 | 740,000 | ||||
| 2000 Zodiac | Fire | 50,000 | |||||
| 2002 Chevrolet Venture | Fire | ||||||
| 2005 Smeal Spartan Aerial | Fire | ||||||
| 2009 Chevrolet Tahoe | Fire | ||||||
| 2012 Smeal Spartan Gladiator | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2019 Chevrolet Tahoe | Fire | ||||||
| Subtotal | 703,000 | 470,000 | 810,000 | 70,000 | 55,000 | 100,000 |
| Funding source | Fire / Municipal | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|---|---|
| Fire Dept M&E Reserve | Fire | - | (50,000) | - | - | - | - |
| Machinery & Equipment Reserve | Municipal | (183,000) | (40,000) | (70,000) | (70,000) | (55,000) | (100,000) |
| Debt | - | - | (740,000) | - | - | - | |
| Grants or other | (520,000) | (380,000) | |||||
| Subtotal | (703,000) | (470,000) | (810,000) | (70,000) | (55,000) | (100,000) |
Continuity Schedules
Fire Dept M&E Reserve
| 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | |
|---|---|---|---|---|---|---|
| Opening bal | 124,619 | 157,711 | 140,465 | 173,874 | 207,951 | 242,710 |
| Contribution | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
| Draws | - | (50,000) | - | - | - | - |
| Interest earned (assuming 2%) | 3,092 | 2,754 | 3,409 | 4,077 | 4,759 | 5,454 |
| Ending bal | 157,711 | 140,465 | 173,874 | 207,951 | 242,710 | 278,164 |
Machinery & Equipment Reserve
| 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | |
|---|---|---|---|---|---|---|
| Opening balance | 303,177 | 187,347 | 215,067 | 212,737 | 210,357 | 223,237 |
| Contribution | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 |
| Draws | (183,000) | (40,000) | (70,000) | (70,000) | (55,000) | (100,000) |
| Interest earned (assuming 2%) | 3,670 | 4,220 | 4,170 | 4,120 | 4,380 | 3,730 |
| Ending balance | 187,347 | 215,067 | 212,737 | 210,357 | 223,237 | 190,467 |
Page 76
Extracted from: 2020 11 10 Committee of the Whole Agenda - Agenda - Pdf