Case Study #4
Strategic Business Planning
Need:
Align manufacturing capacity and demand forecasting for business planning
Solution:
Consolidate Varied Data Inputs
Consolidate Production, Demand Forecast, and Inventory data
Create easy-to-follow reporting system
Establish automatic updates from data inputs
S&OP data visualization process consolidates
Result:
Data-visualization of complicated data sets
- System incorporates Manufacturing Capacity, Demand Forecasting and Inventory / Backlog data
- New reporting process quickly identifies and illustrates business goal alignment
Data Visualization Example:
Situation: Product #1 March Position
- April: Demand begins to exceed Capacity
- September: Sales Backlog recovered
- September: Excess inventory will be created
Business decisions options:
- Raise Demand (i.e. sales incentive programs)
- Decrease capacity (close factories, layoff personnel)
- Maintain capacity (increase Inventory)
