Finance and Administration Report: Capital Project Update
A status update on the Town's approved 2020 capital expenditures, including budgeted vs. actual costs and projected completion dates for various infrastructure projects.
Town of View Royal Finance and Administration Report
TO: Council DATE: September 8, 2020 FROM: Steven Vella, Manager of Accounting MEETING: September 15, 2020
Capital Project Update
RECOMMENDATION:
THAT the Committee receive the September 15, 2020 Capital Project Update Report for information.
CHIEF ADMINISTRATIVE OFFICER’S COMMENTS:
I concur with the recommendation.
PURPOSE OF REPORT:
To provide Council with information regarding Capital Project expenditures and projected completion dates.
INFORMATION:
For 2020, the Town has approved capital expenditures of $3,578,125. The attached report outlines budgeted and actual expenditures to August 31, 2020 and current projected completion dates. Due to timing differences between internal reporting timelines and invoices from vendors, there may exist variances between reported costs and actual costs of some projects. As invoices are processed, a more complete calculation of actual variances will be made.
RECOMMENDATION:
THAT the Committee receive the September 15, 2020 Capital Project Update Report for information.
Town of View Royal Capital Project Update Report
For period ending August 31, 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 | - | 45,000 | 45,000 | 0% | Complete |
| Road Projects | |||||||
| 11105 Road Projects | 1168 | Six Mile Rd improvements | - | 96,000 | 96,000 | 0% | Nov-20 |
| 11105 Road Projects | 1192 | Island Hwy upgrades - Hart Rd. to Wilfert Rd. (2019 c/f) | - | 200,000 | 200,000 | 0% | Deferred (partial) |
| Other Transportation Projects | |||||||
| 11106 Other Transportation Projects | 1203 | Ready Step Roll program | - | 25,000 | 25,000 | 0% | Complete |
| Signal Projects | |||||||
| SUB-TOTAL | 10,439 | 401,000 | 390,561 | ||||
| Sewer | |||||||
| Lift Station Projects | |||||||
| 11702 Lift Stations | 1162 | Thetis Cove pump station upgrade | 31,913 | 453,000 | 421,087 | 7% | 2021 |
| SUB-TOTAL | 31,913 | 453,000 | 421,087 | ||||
| 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) | 10,887 | 17,290 | 6,403 | 63% | Sep-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% | Oct-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 | - | 45,000 | 45,000 | Sep-20 | |
| 11304 Park Vehicles | 1230 | Parks vehicle replacement - 2007 John Deere | - | 56,400 | 56,400 | Nov-20 | |
| SUB-TOTAL | 105,686 | 456,405 | 350,719 | ||||
| Building Improvements | |||||||
| Buidling 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) | - | 520,000 | 520,000 | 0% | Dec-20 |
| 12102 Fire - Vehicles | 1209 | Rescue 36 equipment | 16,084 | 150,000 | 133,916 | 11% | 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 | 41,979 | 799,500 | 757,521 | ||||
| Emergency Services | |||||||
| Emergency Program Equipment Projects | |||||||
| 12202 Emerg Prog Equipment | 0849 | ESS equipment and supplies | 10,699 | 20,000 | 9,301 | 53% | Dec-20 |
| 12202 Emerg Prog Equipment | 0850 | EOC equipment and supplies | 13,281 | 12,000 | (1,281) | 111% | Complete |
| SUB-TOTAL | 23,980 | 32,000 | 8,020 | ||||
| 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 | 34,574 | - | (34,574) | Sep-20 | |
| 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 | 16,886 | 40,000 | 23,114 | 42% | Dec-20 |
| Information Technology Software Projects | |||||||
| 13103 Information Tech - Software | 1039 | Microsoft Office Productivity Suite upgrade | - | 68,000 | 68,000 | 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% | Complete |
| SUB-TOTAL | 804,218 | 1,230,700 | 426,482 | ||||
| Total 2020 Capital Projects | 1,018,215 | 3,578,125 | 2,559,910 |



