Appendix
Budget Variance and Project Schedules (A, B, and C)
September 12, 2023Pages 79–813 sections
Consolidated budget variance tables and project status lists for non-core and capital works.
Total Capital project budget: $6,663,270Actual Capital expenditure YTD: $605,294Six Mile Rd roundabout budget: $2,385,000
Schedule A – 2023 Consolidated Budget Variance
Revenue
| Category | 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Taxation | $ 11,316,271 | $ 11,318,193 | $ 1,922 | 0% under budget | $10,207,973 | $ 10,208,319 |
| User fees | 703,338 | 3,065,159 | 2,361,821 | 77% under budget | 640,245 | 2,979,060 |
| Sales of services | 1,142,023 | 918,800 | (223,223) | 24% over budget | 1,139,612 | 846,695 |
| Penalties and fines | 77,443 | 76,000 | (1,443) | 2% over budget | 100,420 | 60,000 |
| Investment income | 576,795 | 115,000 | (461,795) | 402% over budget | (112,162) | 115,000 |
| Other revenue | 236,119 | 298,950 | 62,831 | 21% under budget | 1,161,299 | 247,635 |
| Government grants and transfers | 6,397,616 | 8,079,172 | 1,681,556 | 21% under budget | 2,398,907 | 2,666,440 |
| Contributions from developers and others | 176,250 | 1,059,090 | 882,840 | 83% under budget | 1,379,540 | 95,000 |
| Development cost charges | - | 681,255 | 681,255 | 100% under budget | - | 496,503 |
| Transfers from reserves | - | 1,736,820 | 1,736,820 | 100% under budget | - | 1,346,427 |
| Transfers from reserve accounts | - | 5,702,556 | 5,702,556 | 100% under budget | - | 3,653,336 |
| Transfers from accumulated surplus | - | 266,150 | 266,150 | 100% under budget | - | 450,538 |
| Transfers from equity in capital assets | - | 3,200,270 | 3,200,270 | 100% under budget | 77,418 | 3,143,400 |
| Internal cost allocations | 544,295 | 544,295 | - | 0% under budget | - | 533,626 |
| Revenue Total | $ 21,170,150 | $ 37,061,710 | $ 15,891,560 | 43% under budget | $16,993,253 | $ 26,841,979 |
Expense
| Category | 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| General government services | $ 1,834,390 | $ 3,574,654 | $ 1,740,264 | 49% budget remaining | $ 1,933,638 | $ 2,917,318 |
| Protective services | 2,512,333 | 6,035,421 | 3,523,088 | 58% budget remaining | 3,340,000 | 6,322,713 |
| Transportation services | 1,381,611 | 6,330,553 | 4,948,942 | 78% budget remaining | 2,524,664 | 3,891,755 |
| Environmental health services | 2,225,718 | 3,456,314 | 1,230,596 | 36% budget remaining | 2,134,871 | 3,169,444 |
| Development services | 363,835 | 753,608 | 389,773 | 52% budget remaining | 442,659 | 623,439 |
| Parks services | 628,471 | 2,321,212 | 1,692,741 | 73% budget remaining | 638,167 | 1,699,218 |
| Recreation and culture services | 1,024,082 | 1,372,072 | 347,990 | 25% budget remaining | 1,051,168 | 1,386,083 |
| Interest on debt | 108,556 | 217,112 | 108,556 | 50% budget remaining | 217,112 | 217,112 |
| Principal payment on debt | 184,364 | 315,615 | 131,251 | 42% budget remaining | 315,615 | 315,615 |
| Amortization | - | 3,200,270 | 3,200,270 | 100% budget remaining | 77,418 | 3,143,400 |
| Internal cost allocations | 544,295 | 544,295 | - | 0% budget remaining | - | 533,626 |
| Transfers to reserves | 5,528,250 | 6,392,000 | 863,750 | 14% budget remaining | 1,148,000 | 606,300 |
| Transfers to reserve accounts | 1,349,805 | 2,548,584 | 1,198,779 | 47% budget remaining | 1,769,388 | 2,015,956 |
| Expense Total | 17,685,711 | 37,061,710 | 19,375,999 | 52% budget remaining | 15,592,700 | 26,841,979 |
| Grand Total | $3,484,439 | $0 | ($3,484,439) | $1,400,553 | $0 |
Page 79–81
Schedule B – 2023 Non-core Projects
| Project | CC Code | Est. Completion | Project budget | Project actual | Project variance | Variance % |
|---|---|---|---|---|---|---|
| General Government Services | ||||||
| Admin Buildings | ||||||
| Energy audit - Town Hall | 510-04 | Dec 2023 | $ 8,310 | $ 3,063 | $ 5,248 | 63% budget remaining |
| Administration | ||||||
| Accessible BC Act implementation | 140-15 | Dec 2023 | 5,100 | - | 5,100 | 100% budget remaining |
| Truth and Reconciliation awareness | 140-11 | Dec 2023 | 10,000 | - | 10,000 | 100% budget remaining |
| Finance | ||||||
| Strategic Asset Management Plan | 150-03 | Dec 2023 | 20,000 | - | 20,000 | 100% budget remaining |
| Sustainable Infrastructure Replacement Plan | 150-02 | Dec 2023 | 20,300 | - | 20,300 | 100% budget remaining |
| Information Technology | ||||||
| Cyber security policies and process | 160-11 | Nov 2023 | 10,000 | - | 10,000 | 100% budget remaining |
| Information security strategic plan | 160-10 | Oct 2023 | 8,500 | - | 8,500 | 100% budget remaining |
| Information Technology Coordinator | 160-14 | Jul 2023 | 46,725 | - | 46,725 | 100% budget remaining |
| IT asset inventory solution | 160-09 | Dec 2023 | 8,500 | - | 8,500 | 100% budget remaining |
| IT disaster recovery plan | 160-06 | Jan 2023 | 10,000 | 2,846 | 7,154 | 72% budget remaining |
| Multi-factor authentication | 160-08 | Dec 2023 | 10,000 | 3,242 | 6,758 | 68% budget remaining |
| Public Relations | ||||||
| Volunteer community improvement program | 120-05 | Dec 2023 | 2,500 | - | 2,500 | 100% budget remaining |
| Protective Services | ||||||
| Emergency Program | ||||||
| EOC training and education | 230-02 | May 2023 | 5,500 | 3,000 | 2,500 | 45% budget remaining |
| Extreme heat risk reduction study | 230-06 | Oct 2023 | 30,000 | - | 30,000 | 100% budget remaining |
| Fire Building | ||||||
| Energy audit - Public Safety Building | 510-29 | Dec 2023 | 5,550 | 2,063 | 3,488 | 63% budget remaining |
| Fire General | ||||||
| Community wildfire protection plan update | 210-03 | Dec 2023 | 33,000 | - | 33,000 | 100% budget remaining |
| Wildfire fuel management | 210-04 | Dec 2023 | 25,000 | - | 25,000 | 100% budget remaining |
| Fire Volunteers | ||||||
| Volunteer firefighter qualifications compensation | 211-03 | May 2023 | 24,000 | - | 24,000 | 100% budget remaining |
| Transportation Services | ||||||
| Traffic Calming | ||||||
| Stormont Road traffic calming | 323-01 | Dec 2023 | 8,000 | - | 8,000 | 100% budget remaining |
| Transportation-General | ||||||
| Active Transportation Network Plan | 310-08 | May 2023 | 57,428 | 48,404 | 9,024 | 16% budget remaining |
| Development Services | ||||||
| Planning and Development Services | ||||||
| Coastal Adaptation Plan | 510-28 | Dec 2023 | 60,000 | - | 60,000 | 100% budget remaining |
| Community engagement strategy | 510-22 | Dec 2023 | 80,000 | - | 80,000 | 100% budget remaining |
| Official Community Plan review | 510-02 | Dec 2023 | 41,000 | 5,502 | 35,498 | 87% budget remaining |
| Off-street parking review | 510-32 | Dec 2023 | 35,000 | - | 35,000 | 100% budget remaining |
| Parks Services | ||||||
| Parks, Rec & Culture-General | ||||||
| Public art acquisition-mural | 710-01 | Dec 2023 | 35,000 | 10,000 | 25,000 | 71% budget remaining |
| Urban forestry strategy | 310-14 | Dec 2023 | 82,500 | - | 82,500 | 100% budget remaining |
| Grand Total | $ 681,913 | $ 78,120 | $603,793 | 89% budget remaining |
Page 79–81
Schedule C – 2023 Capital Projects
| Project | CC Code | Est. Completion | Project budget | Project actual | Project variance | Variance % |
|---|---|---|---|---|---|---|
| General Government Services | ||||||
| Administration | ||||||
| Records information management system | 1038 | Dec 2023 | $ 168,000 | $ 1,050 | $ 166,950 | 99% budget remaining |
| Building Improvements | ||||||
| Council Chambers modifications | 1138 | Jan 2023 | 34,200 | 38,353 | (4,153) | 12% over budget |
| Ergonomic workstation replacement | 1226 | Dec 2023 | 145,000 | - | 145,000 | 100% budget remaining |
| Town Hall HVAC replacements | 1272 | Aug 2023 | 110,000 | - | 110,000 | 100% budget remaining |
| Information Technology | ||||||
| IT infrastructure hardware replacements | 1044 | Oct 2023 | 96,700 | 12,306 | 84,394 | 87% budget remaining |
| IT workstation ever-greening | 1070 | Oct 2023 | 42,500 | 11,284 | 31,216 | 73% budget remaining |
| Phone service replacement | 1037 | Oct 2023 | 35,000 | - | 35,000 | 100% budget remaining |
| Protective Services | ||||||
| Emerg Prog Equipment | ||||||
| Emergency Operations Centre equipment | 0850 | Apr 2023 | 5,000 | 4,776 | 224 | 4% budget remaining |
| Fire - Buildings | ||||||
| Fire training ground improvements | 1149 | Dec 2023 | 50,000 | 13,321 | 36,679 | 73% budget remaining |
| Public Safety Building envelope repairs | 1032 | Oct 2023 | 100,000 | - | 100,000 | 100% budget remaining |
| Public Safety Building landscaping | 1208 | Jul 2023 | 35,000 | - | 35,000 | 100% budget remaining |
| Public Safety Building security gate | 1264 | Sep 2023 | 25,000 | - | 25,000 | 100% budget remaining |
| Fire - Furniture and Equipment | ||||||
| Firefighting hose replacement | 1150 | Jun 2023 | 25,000 | - | 25,000 | 100% budget remaining |
| SCBA cylinder and battery replacements | 1101 | Jun 2023 | 35,000 | 26,232 | 8,768 | 25% budget remaining |
| Police Services | ||||||
| RCMP building capital projects | 1152 | Dec 2023 | 20,000 | 4,705 | 15,295 | 76% budget remaining |
| RCMP building design validation | 1266 | Dec 2023 | 186,720 | - | 186,720 | 100% budget remaining |
| Transportation Services | ||||||
| Bus Shelters | ||||||
| Bus shelter installation program | 0058 | Dec 2023 | 45,000 | - | 45,000 | 100% budget remaining |
| Other Transportation Projects | ||||||
| Intersection safety improvements at trail crossings | 1265 | Dec 2023 | 20,000 | - | 20,000 | 100% budget remaining |
| Road Projects | ||||||
| Intersection improvements-Helmcken Rd at Watkiss Way | 1085 | Dec 2023 | 60,000 | - | 60,000 | 100% budget remaining |
| Island Hwy upgrades-Helmcken Rd to Beaumont Ave | 1111 | Dec 2023 | 100,000 | - | 100,000 | 100% budget remaining |
| Six Mile Rd hydro works | 1260 | Dec 2023 | 300,000 | 1,000 | 299,000 | 100% budget remaining |
| Six Mile Rd roundabout | 1252 | Dec 2023 | 2,385,000 | 51,562 | 2,333,438 | 98% budget remaining |
| Six Mile Road cross-section review | 1168 | Dec 2023 | 5,000 | 5,273 | (273) | 5% over budget |
| Sidewalks | ||||||
| Atkins Road sidewalk-Anya Court to Langford border | 1234 | Dec 2023 | 30,000 | - | 30,000 | 100% budget remaining |
| Curb & sidewalk replacement-Eagle Creek Village to Helmcken/Burnside | 1189 | Dec 2023 | 100,000 | 2,650 | 97,350 | 97% budget remaining |
| Jedburgh Rd sidewalk | 1204 | Dec 2023 | 28,000 | - | 28,000 | 100% budget remaining |
| Signals | ||||||
| Traffic signal upgrades-collector road intersections | 1270 | Dec 2023 | 16,700 | - | 16,700 | 100% budget remaining |
| Traffic signal upgrades-Island Hwy | 1261 | Dec 2023 | 68,000 | - | 68,000 | 100% budget remaining |
| Street Lighting | ||||||
| LED lighting upgrade | 1194 | Dec 2023 | 30,000 | - | 30,000 | 100% budget remaining |
| Pedestrian lighting improvements | 1236 | Dec 2023 | 22,700 | - | 22,700 | 100% budget remaining |
| St. Giles Street lighting improvements | 1269 | Dec 2023 | 20,000 | - | 20,000 | 100% budget remaining |
| Environmental Services | ||||||
| Lift Stations | ||||||
| Helmcken Bay pump station upgrade | 1211 | Apr 2023 | 301,500 | 301,497 | 3 | 0% budget remaining |
| Packers pump station upgrade | 1163 | Dec 2023 | 670,000 | 1,978 | 668,022 | 100% budget remaining |
| Parks Services | ||||||
| Park Development | ||||||
| View Royal Park-design | 1028 | Dec 2023 | 13,875 | 9,612 | 4,263 | 31% budget remaining |
| View Royal Park-fencing & garbage receptacles | 1268 | Dec 2023 | 78,700 | - | 78,700 | 100% budget remaining |
| View Royal Park-saltwater marsh/wetland | 1267 | Dec 2023 | 272,625 | - | 272,625 | 100% budget remaining |
| View Royal Park-soft landscaping | 1258 | Dec 2023 | 232,800 | - | 232,800 | 100% budget remaining |
| Watkiss Way Community Park development | 1241 | Dec 2023 | 15,000 | - | 15,000 | 100% budget remaining |
| Park Improvements | ||||||
| Centennial Park diamond #4 fencing improvement | 1218 | Dec 2023 | 40,250 | - | 40,250 | 100% budget remaining |
| Chancellor Park playground replacement | 1254 | Dec 2023 | 300,000 | - | 300,000 | 100% budget remaining |
| Knollwood Park playground replacement | 1199 | Dec 2023 | 100,000 | - | 100,000 | 100% budget remaining |
| Stillwater Road waterfront access | 1245 | Dec 2023 | 40,000 | - | 40,000 | 100% budget remaining |
| Thomas Road waterfront access | 1244 | Dec 2023 | 40,000 | 1,966 | 38,034 | 95% budget remaining |
| Park Vehicles | ||||||
| 1996 Kubota replacement | 1067 | Apr 2023 | 33,000 | 32,779 | 221 | 1% budget remaining |
| 2006 Ford F350 replacement | 1253 | May 2023 | 62,000 | 60,922 | 1,078 | 2% budget remaining |
| 2007 Chev 1-ton pickup replacement | 1271 | Dec 2023 | 85,000 | - | 85,000 | 100% budget remaining |
| Riding mower replacement | 1250 | Apr 2023 | 25,000 | 24,028 | 972 | 4% budget remaining |
| Small trailer with cargo rack | 1221 | Dec 2023 | 10,000 | - | 10,000 | 100% budget remaining |
| Grand Total | $6,663,270 | $ 605,294 | $6,057,976 | 91% budget remaining |
Page 79–81
Extracted from: 2023 09 12 Committee of the Whole Agenda - Agenda - Pdf