Case study
Capacity Planning Dashboard
The core business question is simple: can the current work-center capacity support the planned weekly product mix?
Inputs
Product demand, routings, operation process times, tool counts, hours per week, and target OEE.
Outputs
Required load, available capacity, utilization, capacity gap, required tools, and bottleneck status.
Model logic
Required load hours = weekly demand × process time minutes per unit ÷ 60
Available capacity hours = tool count × hours per tool per week × target OEE
Utilization = required load hours ÷ available capacity hours
Capacity gap = available capacity hours − required load hours