Enterprise Resource Management Service Statement of Operations - Quarter 2 Financial Update (2017) (in thousands of dollars)
| Year to Date | Annual | |||||||
|---|---|---|---|---|---|---|---|---|
| Budget | Actual | Budget vs. Actual Variance Favourable/(Unfavourable) | Budget | Forecast | Budget vs. Forecast Variance Favourable/(Unfavourable) | |||
| Expenses | ||||||||
| Compensation | $5,538 | $5,336 | $202 | 3.6% | $10,942 | $10,724 | $218 | 2.0% |
| Administrative | 2,156 | 3,268 | -1,112 | (51.6%) | 3,926 | 5,465 | -1,540 | (39.2%) |
| Operational & Supply | 25 | 36 | -11 | (43.4%) | 48 | 89 | -41 | (86.5%) |
| Occupancy & Infrastructure | 3,457 | 3,222 | 236 | 6.8% | 6,866 | 6,563 | 302 | 4.4% |
| Equipment, Vehicles, Technology | 41 | 80 | -39 | (95.2%) | 82 | 120 | -39 | (47.7%) |
| Community Assistance | 0 | 0 | 0 | 0.0% | 0 | 0 | 0 | 0.0% |
| Financial Expenditures | 3 | 1 | 1 | 59.1% | 5 | 4 | 1 | 29.5% |
| Total Expenses | 11,219 | 11,942 | -723 | (6.4%) | 21,868 | 22,965 | -1,098 | (5.0%) |
| Revenues | ||||||||
| Federal & Provincial Grants | -30 | -21 | -9 | 31.3% | -60 | -59 | -1 | 1.3% |
| By-Law Charges & Sales | -120 | -137 | 18 | (14.8%) | -240 | -237 | -3 | 1.1% |
| Other Revenue | -152 | -225 | 73 | (48.1%) | -232 | -316 | 85 | (36.7%) |
| Total Revenues | -302 | -383 | 81 | (27.0%) | -531 | -613 | 81 | (15.3%) |
| Intercompany Charges | ||||||||
| Intercompany Charges | 13 | -36 | 49 | 386.3% | 24 | -5 | 29 | 123.1% |
| Total Intercompany Charges | 13 | -36 | 49 | 386.3% | 24 | -5 | 29 | 123.1% |
| Net Expenditure (Revenue) Before Transfers & Indirect Allocations | 10,930 | 11,523 | -593 | (5.4%) | 21,360 | 22,347 | -987 | (4.6%) |
| Transfers | ||||||||
| Transfers From Funds | -449 | -452 | 3 | (0.7%) | -726 | -730 | 3 | (0.4%) |
| Transfers To Funds | 11 | 24 | -12 | (113.6%) | 24 | 36 | -12 | (53.2%) |
| Expense Allocations to Capital | -1 | 0 | -1 | 100.0% | -2 | -1 | -1 | 50.0% |
| Total Transfers | -439 | -428 | -11 | 2.4% | -705 | -695 | -11 | 1.5% |
| Indirect Allocations & Debt | ||||||||
| Indirect Allocation | -10,491 | -11,095 | 604 | (5.8%) | -20,654 | -21,652 | 998 | (4.8%) |
| Total Indirect Allocations & Debt | -10,491 | -11,095 | 604 | (5.8%) | -20,654 | -21,652 | 998 | (4.8%) |
| Net Expenditure (Revenue) After Transfers & Indirect Allocation | 0 | 0 | 0 | 100.0% | 0 | 0 | 0 | 242.9% |
Variance Analysis (in thousands of dollars)
Enterprise Resource Management Services is operating a year-to-date deficit before indirect allocations of $604 and forecasting a total deficit before indirect allocations of $998. The following factors have contributed to these variances:
Compensation
The favourable year-to-date variance and forecasted variances of $202 and $218 is a result of vacancies in Financial Management and Planning, Procurement and Strategic Acquisitions, and Legal Services.
Administrative
The unfavourable year-to-date and forecasted variances of $1,112 and $1,540 is a result of a large claim payout and higher than anticipated forecasted claims payouts. Claims payouts are subject to a separate committee report.
Operational & Supply
The unfavourable year-to-date and forecasted variances of $11 and $41 is a result of higher than anticipated costs related to the Regional HQ cafeteria. Operational changes being planned for Q3 2017 for the cafeteria to reduce costs.
Occupancy & Infrastructure
The favourable year-to-date and forecasted variances of $236 and $302 is a result of the delay of the build of the Niagara Falls Public Health Facility as well as lower than anticipated electricity, grounds and landscaping costs.
Equipment, Vehicles, Technology
The unfavourable year-to-date of $39 is a result of higher than anticipated generator costs. The unfavourable variance is anticipated to continue throughout the year.
Other Revenue
The favourable year-to-date and forecasted variances $73 and $85 is a result of new telecom tower and lease revenue.
Intercompany Charges
The favourable year-to-date and forecasted variances of $49 and $29 is a result of external funding to cover specific SAEO related expenditures in Financial Management and Planning.
Community Impacts & Achievements
Construction, Energy and Facilities Management
- Job Order Contracting (JOC) pilot - This project has been awarded, training has been completed and the first few projects have been entered into the system. This is an innovative new procurement method which will help to expedite projects and minimize change orders. This is a first for all of Ontario. It is a good demonstration of partnership between CE&FM, Procurement and contractors.
- Provincial Offences Court Facility (POCF) - Currently tracking on budget and on schedule with anticipated opening in fall 2017.
Financial Management and Planning
- The budget control policy and development charges by-law were approved by Council.
- Completed the first year end and audit after PeopleSoft implementation with new auditors and obtained a clean audit opinion.
© Niagara Region - 1815 Sir Isaac Brock Way, Thorold, ON, L2V 4T7 - Phone: 905-980-6000, Toll-free: 1-800-263-7215
