Appendix
Appendix B: Fleet Replacement Plan – 5-year excerpt
October 8, 2019Page 311 section
A financial spreadsheet detailing planned vehicle expenditures and reserve balances from 2019 to 2024.
2021 expenditure: $1,126,000 for Superior E-One2019 total subtotal: $581,600
Committee of the Whole Report
Re: Vehicle Fleet Replacement Plan Update Meeting Date: October 8, 2019
Appendix B
Fleet Replacement Plan – 5-year excerpt
Town of View Royal Fleet Replacement Plan 2020-2024 Financial Plan
| Vehicles | Fire / Municipal | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|---|---|
| 1996 Kubota | Municipal | 81,600 | |||||
| 2001 Chevrolet Silverado 1/2 Ton | Municipal | 35,000 | |||||
| 2003 Ford F350 - Dually Dump | Municipal | ||||||
| 2004 Ford Ranger | Municipal | 45,000 | |||||
| 2006 Ford F350 - Single rear wheel drive | Municipal | 80,640 | |||||
| 2006 John Deere #2305 | Municipal | 40,000 | |||||
| 2007 Chevrolet Silverado 1 Ton | Municipal | 45,900 | |||||
| 2007 John Deere #3520 | Municipal | 56,400 | |||||
| 2010 Nissan Frontier | Municipal | 45,000 | |||||
| 2011 Ford Ranger Splash (Bldg.) | Municipal | ||||||
| 2012 Mitsubishi Dump | Municipal | ||||||
| 2013 Honda Fit | Municipal | ||||||
| 2015 Chevrolet Colorado (Bylaw) | Municipal | ||||||
| 2019 Hyundai Ionic | Municipal | ||||||
| 1990 Mack Emergency Rescue | Fire | 380,000 | 520,000 | ||||
| 1991 Navistar International Brush Truck | Fire | ||||||
| 1992 Superior E-One | Fire | 1,126,000 | |||||
| 2000 Zodiac | Fire | 50,000 | |||||
| 2002 Chevrolet Venture (Emerg Prog 2020) | Fire | ||||||
| 2005 Smeal Spartan Aerial | Fire | ||||||
| 2009 Chevrolet Tahoe | Fire | 85,000 | |||||
| 2012 Smeal Spartan Gladiator | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2016 Ford F150 | Fire | ||||||
| 2019 Chevrolet Tahoe | Fire | ||||||
| Subtotal | 581,600 | 621,400 | 1,166,000 | 95,900 | 80,640 | 45,000 |
| Funding source | Fire / Municipal | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|---|---|
| Fire Dept M&E Reserve | Fire | (305,000) | - | - | (50,000) | - | - |
| Machinery & Equipment Reserve | Municipal | (116,600) | (101,400) | (40,000) | (45,900) | (80,640) | (45,000) |
| Grants or other | (160,000) | (520,000) | (1,126,000) | ||||
| Subtotal | (581,600) | (621,400) | (1,166,000) | (95,900) | (80,640) | (45,000) |
Continuity Schedules
Fire Dept M&E Reserve
| 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | ||
|---|---|---|---|---|---|---|---|
| Opening bal | 391,357 | 118,684 | 151,658 | 185,291 | 168,597 | 202,569 | |
| Contribution | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
| Draws | (305,000) | - | - | (50,000) | - | - | |
| Interest earned (assuming 2%) | 2,327 | 2,974 | 3,633 | 3,306 | 3,972 | 4,651 | |
| Ending bal | 118,684 | 151,658 | 185,291 | 168,597 | 202,569 | 237,220 |
Machinery & Equipment Reserve
| 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | ||
|---|---|---|---|---|---|---|---|
| Opening balance | 259,751 | 208,961 | 174,481 | 201,941 | 223,931 | 210,931 | |
| Contribution | 63,500 | 61,710 | 63,500 | 63,500 | 63,500 | 63,500 | 63,500 |
| Draws | (116,600) | (101,400) | (40,000) | (45,900) | (80,640) | (45,000) | |
| Interest earned (assuming 2%) | 4,100 | 3,420 | 3,960 | 4,390 | 4,140 | 4,590 | |
| Ending balance | 208,961 | 174,481 | 201,941 | 223,931 | 210,931 | 234,021 |
Page 31
Extracted from: 2019 10 08 Committee of the Whole Agenda - Agenda - Pdf