Building a Decision Support System for Raw Material Imports

A Power BI decision support system that brings consumption, stock, supplier and market price data together to plan raw material imports.

Industry
Manufacturing
Business type
A leading manufacturing company
Tools
Power BI Desktop, Power BI Service, Power BI Mobile, DAX

Based on our experience across multiple client projects; not specific to any one client.

Power BI decision support dashboard for raw material imports with inventory, prices and suppliers

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

Looking for similar results?

Share your reporting challenge, and we will propose a solution tailored to your business.