Staff Report #7
May 30, 2018
To All Commissioners
Re: Financial Update – Capital Budget Programs – April 30, 2018
Recommendation
That the report be NOTED and FILED.
Background
Summarized in the table below is the 2018 Capital Program Summary for the four month period ending April 30, 2018.
Summary of 2018 Capital Budget Program Activity
Four Months Ending April 30, 2018
| Amount | ||||
| Under Budget | ||||
| Description | Actual | Budget | (Over Budget) | |
| Program | ||||
| Stop Upgrades | $ 21,278 | $ 110,000 | $ 88,722 | |
| Service Fleet | 33,971 | 40,000 | 6,029 | |
| Shop Equipment | 19,852 | 200,000 | 180,148 | |
| Software and Hardware | 97,416 | 600,000 | 502,584 | |
| Facility Upgrades | 6,064 | 300,000 | 293,936 | |
| Bus Replacement (8) | – | 4,560,800 | 4,560,800 | |
| Bus Expansion (4) | 75,348 | 2,378,400 | 2,303,052 | |
| Fleet Radio Replacement | – | 625,000 | 625,000 | |
| TMP 2030 – BRT Strategy | – | 1,500,000 | 1,500,000 | |
| Fare Processing Equipment | – | 1,495,000 | 1,495,000 | |
| Smart Card Program | – | 605,000 | 605,000 | |
| Total | $ 253,930 | $ 12,414,200 | $ 12,160,270 | |
| Funding | ||||
| Provincial Gas Tax | $ 41,425 | $ 5,502,200 | $ 5,460,775 | |
| Capital Program Reserve | 131,092 | 627,000 | 495,908 | |
| City of London | 81,416 | 4,785,000 | 4,703,588 | |
| Federal Gas Tax | – | 1,500,000 | 1,500,000 | |
| Total | $ 253,930 | $ 12,414,200 | $ 12,160,270 | |
The following programs are underway through the first four months of the year, with narrative focusing on the YTD progress and may be duplicated from previous months.
Stop Upgrades
The costs incurred to date are attributable to the remaining expenditures from the 2017 shelter installs. As outlined in Staff Report #2, dated April 25, 2018, an additional $73,000 was requested and approved to carry out the planned 2018 shelter program (10 shelters). The remaining $89,000 in the budget will enable the purchase and installation of these 10 shelters.
Service Fleet
The costs incurred to date are attributable to the purchase of a new service van. Outstanding expenditures are related to the lighting kits and ancillary equipment required for the van. See Staff Report #8, dated April 25, 2018.
Shop Equipment
Expenditures incurred to date relate to the ongoing monthly purchase of shop tools. The items indicated in Staff Report #8, dated April 25, 2018 as completed all currently have invoices outstanding.
Software and Hardware
The costs incurred to date are attributable to the replacement of the Specialized scheduling system and other workstation and networking equipment replacements. Work on these projects is scheduled to continue for the remainder of the year.
Bus Purchases
The costs incurred to date are attributable to the early purchase of ancillary equipment required for the 2018 bus expansion and replacement projects. Staff Report #8, dated April 25, 2018 discusses the timing and issues related to these programs.
The remaining programs are scheduled to commence in the remainder of 2018. Administration will continue to monitor actual to budget performance and report to the Commission on a monthly basis.
Recommended by:
Mike Gregor, Director of Finance
Concurred in by:
Kelly S. Paleczny, General Manager