Forecast vs Actual
Our client had spent significantly less on a contract than was forecast, they wanted to understand what had gone differently and whether their forecasting methods could be improved for future bids.
After sourcing the data, we modelled the spend and consumption quantities, producing a comparison visual of the actual against forecast.
This output showed that only 0.4% of extremely high cost and low consumption component parts had differed from what had been forecasted. Furthermore, similar results could be identified in other contracts working in the favour of our client’s customer.
All data visualisations were presented to our client and handed over for their use in a positive conversation with their customer.
Understanding how well you actually delivered to the customer
The data outputs were key to enabling a productive conversation between our client and their customer, resulting not only in saving the monetary reimbursement but also maintaining the valuable relationship.