Manufacturing
FMCG Manufacturer Cuts Stockouts 65% with AI Demand Forecasting
Replacing spreadsheet-based forecasting with an AI platform on Microsoft Fabric that predicts demand at SKU-location-week granularity.
Solution
AI Demand Forecasting
Industry
Manufacturing & Industrial
Company Size
Project Overview
client
FMCG Manufacturer
industry
Manufacturing & Industrial
solution
AI Demand Forecasting
technologies
Microsoft Fabric, Azure Machine Learning, Dynamics 365 Supply Chain, Power BI, Azure OpenAI
duration
5 Months
region
MENA & Africa
The Challenge
Forecast accuracy at SKU level was below 60%, driving alternating cycles of stockouts and obsolete inventory.
- 1Spreadsheet-based forecasting unable to handle SKU complexity
- 260% SKU-level forecast accuracy driving stockouts and obsolescence
- 3Promotional events handled manually with poor lift modeling
Our Solution
CloudGate built an ML-based forecasting platform with promotion, seasonality, and event handling, integrated with planning systems.
- ML-based SKU-location-week demand forecasting
- Promotion lift modeling with what-if scenarios
- Planner copilot for exception management
The Results
-65%
STOCKOUTS
+18 pts
FORECAST ACCURACY
-20%
OBSOLETE INVENTORY
- Improved on-shelf availability across the top 200 SKUs
Technologies Used
Microsoft FabricAzure Machine LearningDynamics 365 Supply ChainPower BIAzure OpenAI
