Introduction
A manufacturer importing raw materials planned purchases with spreadsheets and emails. Without a clear view of consumption, stock, supplier lead times or market prices, it faced stockouts, over-ordering and missed savings.
Business challenge
- No visibility into internal consumption or production forecasts
- Stock data scattered across warehouses
- No insight into supplier lead times
- No comparison with market and competitor pricing
- Spreadsheets and emails causing delays, stockouts and over-ordering
Requirements
- Consolidate consumption and projected requirements
- Track inventory across plants and warehouses
- Supplier pricing, delivery times and number of sources per material
- Market price comparison
- Scenario planning and cost-benefit analysis
The solution
Data model
- ERP, inventory reports, supplier records and market price data in one model
- Consumption forecasts from historical trends and production schedules
Role-based dashboards
- Views for procurement, finance and operations
- Stock vs forecasted need, supplier lead times, vendor count per material and import cost per vendor
- Market price benchmarking
What-if analysis
- DAX and parameters to test scenarios such as delaying an order, splitting it between vendors or switching supplier
- Shared through the Power BI Service on web and mobile apps
Outcome
- Clear visibility across the supply chain
- More accurate demand forecasting and inventory planning
- Faster sourcing with lower risk of stockouts and overstock
- Stronger position in supplier negotiations
- Proactive cost management
Tools used
- Power BI Desktop
- Power BI Service
- Power BI Mobile
- DAX


