Detailed findings

1. Establish control to independently review the payment certificate calculation template (design effectiveness)

Overall rating: Low

Impact:

Low

Likelihood:

Unlikely

Observation:

The contract between the City and the contractor allows vehicle operating rates, wing plow operator rates, and drivers' standby rates to be adjusted at 85% of the increase or decrease in the CPI Transportation component at the start of each contract year, with the initial increase occurring on November 1, 2017. We noted the use of incorrect CPI rates for both the 2017/2018 and 2018/2019 season. These resulted in total overpayment of $37,752 over the course of the two seasons.

A summary of the calculation factors follows below

Season

CPI factor calculated by the City

Our CPI factor calculation

Over payment

Dec 2017/2018

4.80%

4.08%

$14,373

Dec 2018/2019

3.32%

2.55%

$23,379



Total

$37,752

Based on our detection of the error, management has acted and recovered the full amount from the contractor as of January 2020. Management recovered this amount by deducting half the value on each of the November and December 2019 payment certificates

Implication:

The City incurred financial loss due to overpayment made to the contractor

Recommendation:

To ensure accuracy of future contractor payment, management should consider having an independent review of the payment certificate calculation template prior to each snow season. This review should check the operating rates and formulas.

Management Action Plan

Prior to each season, the Contracts Coordinator will prepare the adjusted rates for the applicable contract items based on the Consumer Price Index, Transportation component for Ontario. The Contracts Coordinator will submit these numbers to Finance for verification.

Responsible party:

Contract Co-ordinator

Due date:

Q4 Annually