Case Study:
Mining 3-Month Rolling Forecast
Case Study:
Mining 3-Month
Rolling Forecast
Client Challenge
The client's weekly operational planning process was manual and involved multiple teams communicating through email and Excel files, leading to difficulty in meeting deadlines and managing timing and dependencies.
- Managers were spending excessive amounts of time putting together weekly reports and slides.
- It was difficult to understand how the forecast was changing week-to-week and to hold the departments accountable.
As a result of these challenges the operational management team was forced to be reactive instead of proactive in their decision-making.
The Solution
- Implement an integrated rolling forecast tool on the Qerent platform which automated the data ingestion process directly from source systems and streamlined planning process.
- Workflows tracking and email notifications and reminders were integrated into the solution. This facilitated and centralized the planning process in a coherent way across multiple teams.
- Reporting from the model was automated in a way that minimized effort require for weekly planning meetings.
Solution Value
- The turnaround time needed to put together the 3MRF forecasts was significantly reduced by approximately 70%, which allows for decisions to be made in a proactive agile manner.
- In addition, managers did not need to manually create reports and presentations for the weekly planning meetings.