Appendix
Town of View Royal Capital Project Update Report
December 8, 2020Page 162 sections
A detailed spreadsheet outlining specific capital projects in transportation, sewer, parks, and other departments with budget vs. actual costs.
Period ending November 30, 2020Total 2020 Capital Projects Budget: $3,578,125Year to Date Expenditure: $1,810,139Variance: $1,767,986
Town of View Royal
Page 16
Capital Project Update Report
For period ending November 30, 2020
| 2020 Capital Projects | Cost Centre | Description | Year to Date | Budget Amount | Variance | % Var | Expected Completion |
|---|---|---|---|---|---|---|---|
| Transportation | |||||||
| Sidewalk Projects | |||||||
| 11101 Sidewalks | 1205 | Watkiss Way sidewalk - Eagle Creek to Stoneridge Drive | - | 25,000 | 25,000 | 0% | Deferred |
| 11101 Sidewalks | 1231 | Eltham Rd sidewalk | 10,439 | 10,000 | (439) | 104% | Complete |
| Street Lighting Projects | |||||||
| 11103 Street Lighting | 1194 | Island Hwy LED lighting upgrade Yr 2 | 43,554 | 45,000 | 1,446 | 97% | Complete |
| Road Projects | |||||||
| 11105 Road Projects | 1168 | Six Mile Rd improvements | 10,291 | 96,000 | 85,709 | 11% | Dec-20 |
| 11105 Road Projects | 1192 | Island Hwy upgrades - Hart Rd. to Wilfert Rd. (2019 c/f) | - | 200,000 | 200,000 | 0% | Deferred (175,000) |
| Other Transportation Projects | |||||||
| 11106 Other Transportation Projects | 1203 | Ready Step Roll program | 20,803 | 25,000 | 4,197 | 83% | Complete |
| Signal Projects | |||||||
| SUB-TOTAL | 85,087 | 401,000 | 315,913 | ||||
| Sewer | |||||||
| Lift Station Projects | |||||||
| 11702 Lift Stations | 1162 | Thetis Cove pump station upgrade | 94,139 | 453,000 | 358,861 | 21% | 2021 |
| SUB-TOTAL | 94,139 | 453,000 | 358,861 | ||||
| Parks | |||||||
| Park Improvement Projects | |||||||
| 11302 Park Improvements | 0901 | Development of road ends | - | 20,000 | 20,000 | 0% | Deferred |
| 11302 Park Improvements | 1127 | MacLennan Trail improvements - guard rails and paving (2019 c/f) | 20,000 | 20,000 | - | 100% | Complete |
| 11302 Park Improvements | 1165 | Beaumont access improvements (2019 c/f) | 19,471 | 17,290 | (2,181) | 113% | Dec-20 |
| 11302 Park Improvements | 1177 | Playground replacement program - Marler Park (2019 c/f) | 11,619 | 10,615 | (1,004) | 109% | Complete |
| 11302 Park Improvements | 1215 | Portage Park West staircase | 60,612 | 60,000 | (612) | 101% | Complete |
| 11302 Park Improvements | 1216 | Portage Park toilets | - | 4,500 | 4,500 | 0% | Deferred |
| 11302 Park Improvements | 1217 | Centennial Park toilets | - | 4,500 | 4,500 | 0% | Deferred |
| 11302 Park Improvements | 1219 | View Royal Park water fountain | - | 13,000 | 13,000 | 0% | Deferred |
| 11302 Park Improvements | 1220 | View Royal Park swing set replacement | - | 25,000 | 25,000 | 0% | Deferred |
| 11302 Park Improvements | 2022 | Playground replacement program - Knollwood Park | 231 | 85,000 | 84,769 | 0% | 2021 |
| Park Vehicle Projects | |||||||
| 11304 Park Vehicles | 1067 | Kubota tractor/backhoe (2019 c/f) | - | 81,600 | 81,600 | 0% | Dec-20 |
| 11304 Park Vehicles | 1132 | 1/2 ton pickup replacement (2019 c/f) | 2,337 | 3,500 | 1,163 | 67% | Complete |
| 11304 Park Vehicles | 1221 | Small trailer with cargo rack | - | 10,000 | 10,000 | 0% | Deferred |
| 11304 Park Vehicles | 1229 | Parks vehicle replacement - 2004 Ford Ranger | 39,982 | 45,000 | 5,018 | Complete | |
| 11304 Park Vehicles | 1230 | Parks vehicle replacement - 2007 John Deere | - | 56,400 | 56,400 | Dec-20 | |
| SUB-TOTAL | 154,252 | 456,405 | 302,153 | ||||
| Building Improvements | |||||||
| Building Improvement Projects | |||||||
| 11401 Building Improvements | 1226 | Ergonomic workstation replacement | - | 93,600 | 93,600 | 0% | Deferred |
| 11401 Building Improvements | 1232 | Town Hall lunchroom renovation | - | 50,000 | 50,000 | 0% | Deferred |
| SUB-TOTAL | - | 143,600 | 143,600 | ||||
| Fire Services | |||||||
| Fire Building Projects | |||||||
| 12101 Fire - Buildings | 1207 | Firefighter decontamination room | - | 15,500 | 15,500 | 0% | 2021 |
| Fire Vehicle Projects | |||||||
| 12102 Fire - Vehicles | 0845 | Fire apparatus Ladder 35 upgrades | - | 65,000 | 65,000 | 0% | Deferred |
| 12102 Fire - Vehicles | 1033 | Rescue Truck (2019 c/f) | 492,091 | 520,000 | 27,909 | 95% | Dec-20 |
| 12102 Fire - Vehicles | 1209 | Rescue 36 equipment | 96,456 | 150,000 | 53,544 | 64% | Dec-20 |
| Fire Furniture and Equipment Projects | |||||||
| 12103 Fire - Furniture and Equip | 1227 | Public Safety Building - Public art (2019 c/f) | 16,000 | 35,000 | 19,000 | 46% | Mar-21 |
| 12103 Fire - Furniture and Equip | 1181 | Fire dispatch - mobile terminal Yr 3 | 9,895 | 14,000 | 4,105 | 71% | Dec-20 |
| SUB-TOTAL | 614,442 | 799,500 | 185,058 | ||||
| Emergency Services | |||||||
| Emergency Program Equipment Projects | |||||||
| 12202 Emerg Prog Equipment | 0849 | ESS equipment and supplies | 19,275 | 20,000 | 725 | 96% | Dec-20 |
| 12202 Emerg Prog Equipment | 0850 | EOC equipment and supplies | 13,281 | 12,000 | (1,281) | 111% | Complete |
| SUB-TOTAL | 32,556 | 32,000 | (556) | ||||
| Police Services | |||||||
| Police Machinery and Equipment Projects | |||||||
| 12301 Police Services | 1103 | RCMP building renovation | - | 20,000 | 20,000 | 0% | Ongoing |
| 12301 Police Services | 1152 | RCMP capital projects | - | 41,920 | 41,920 | 0% | Ongoing |
| SUB-TOTAL | - | 61,920 | 61,920 | ||||
| Administration / General Government | |||||||
| Administration Projects | |||||||
| 13101 Administration - Software | 1038 | Records information management system | - | 165,000 | 165,000 | 0% | Deferred |
| 13101 Administration - Software | 1225 | Council meeting webcasting | 38,067 | - | (38,067) | Complete | |
| Information Technology Hardware Projects | |||||||
| 13103 Information Tech - Hardware | 1044 | IT infrastructure hardware replacements (server/switches) | 1,400 | 3,000 | 1,600 | 47% | Dec-20 |
| 13103 Information Tech - Hardware | 1070 | IT workstation evergreening | 38,575 | 40,000 | 1,425 | 96% | Dec-20 |
| Information Technology Software Projects | |||||||
| 13103 Information Tech - Software | 1039 | Microsoft Office Productivity Suite upgrade | 263 | 68,000 | 67,738 | 0% | 2021 |
| 13103 Information Tech - Software | 1186 | Secondary suites online renewal | - | 25,000 | 25,000 | 0% | Deferred |
| 13103 Information Tech - Software | 4858 | Vadim iCity Online upgrade | - | 29,700 | 29,700 | 0% | Dec-20 |
| Land Acquisition Projects | |||||||
| 13201 Land Acquisitions | 1054 | Land Acquisitions - Legal (2019 c/f) | - | 150,000 | 150,000 | 0% | Ongoing |
| 13201 Land Acquisitions | 1233 | Little Rd parkland acquisition | 751,358 | 750,000 | (1,358) | 100% | Completed |
| SUB-TOTAL | 829,663 | 1,230,700 | 401,037 | ||||
| Total 2020 Capital Projects | 1,810,139 | 3,578,125 | 1,767,986 |
Page 16
Extracted from: 2020 12 08 Committee of the Whole Agenda - Agenda - Pdf