BACKGROUND & CHALLENGE
A Texas based Oil & Gas provider that maintains andinstalls pumping equipment, provides engineering services, and offers monitoring services for product quality assurance.
This client had historically experienced unpredictable changes in their forecasting model. These changes resulted in lower asset utilization and forecasting anomalies that
were extremely costly to fix. The client used a 5-year model and a quarterly plan to create a monthly production and revenue forecast. Unexpected abnormalities could
automatically cause their report to adjust the monthly estimates of output and income and disrupt the drilling process. As a result, if an alert were inadvertently
triggered and caused a production shutdown, the client would lose millions of dollars in unnecessary downtime.
SOLUTION
Sparkhound worked with key stakeholders and internal delivery team experts to significantly improve the forecasting and utilization processes. We also developed a new process to keep the existing drills running while expanding drilling capabilities.
Solution Details:
-
Created forecasting alerts based on meticulously derived thresholds
-
Identified and re-evaluated critical process areas impacting forecasts. This resulted in fewer unplanned stoppages and less costs.
-
Developed custom SQL reports
OUTCOMES
-
A crucial alert system that allowed for immediate human intervention during breakdowns and stoppages
-
Near real-time “What If?” analysis on all projections and forecasts
-
Valuable alerts on budgeting, forecasting, and planning inconsistencies
Share this
You May Also Like
These Related Stories