PlantOps BI

Manufacturing KPI Library

Every metric that belongs on a plant scorecard: what it means, how to calculate it, what good looks like, and the DAX to build it in Power BI.

higher is better lower is better. Within each category, A to Z.

Production 9

KPIFormulaTypical rangeTools
Capacity Utilization ↑ Actual output ÷ maximum practical capacity 80 to 85% is a healthy operating range for most discrete plants; sustained 95%+ leaves no slack for maintenance or demand spikes CalculatorDAX
Changeover Time (SMED) ↓ Time from last good unit of the previous run to first good unit of the next run Many plants start at 45 to 90 minutes; SMED programs typically target under 10 minutes for the internal (machine-stopped) portion CalculatorDAX
Cycle Time ↓ Run time ÷ units produced Actual cycle time within 5 to 10% of engineered ideal is healthy; wider variance points at process instability CalculatorDAX
MTBF (Mean Time Between Failures) ↑ Total operating time ÷ number of failures Varies by asset complexity; track the trend on a fixed failure definition rather than chasing an absolute hours target CalculatorDAX
MTTR (Mean Time to Repair) ↓ Total repair time ÷ number of repairs Under 1 hour is strong for straightforward mechanical repairs; complex electrical or controls failures often run several hours even in a well-run shop CalculatorDAX
OEE (Overall Equipment Effectiveness) ↑ Availability × Performance × Quality 40 to 60% typical; 85% is world-class discrete manufacturing CalculatorDAX
Schedule Attainment ↑ Units produced ÷ units scheduled (per line, per week) 85% is the most common target; 95%+ sustained suggests soft schedules CalculatorDAX
Takt Time Available production time ÷ customer demand No universal benchmark: takt time is specific to each line and product, and resets whenever demand or available time changes CalculatorDAX
Unplanned Downtime % ↓ Unplanned downtime minutes ÷ total planned production minutes Under 5% is strong for mature equipment; 10%+ usually means maintenance is reactive instead of preventive CalculatorDAX

Quality 3

KPIFormulaTypical rangeTools
Defect PPM (Parts per Million) ↓ (Defective units ÷ total units produced) × 1,000,000 Automotive Tier 1 suppliers often target under 50 PPM; general manufacturing frequently runs in the hundreds to low thousands CalculatorDAX
First Pass Yield (FPY) ↑ Units passing a process step correctly on the first attempt ÷ total units started 90%+ is solid for most discrete assembly steps; below 80% signals a process or training gap worth a root-cause pass CalculatorDAX
Scrap Rate ↓ Scrap units (or scrap cost) ÷ total units produced (or total cost) Under 1-2% is typical for mature discrete lines; above 5% usually points to a process capability issue, not operator error CalculatorDAX

Delivery 3

KPIFormulaTypical rangeTools
On-Time Delivery (OTD) ↑ Orders delivered on or before the promised date ÷ orders due 95%+ is a common target for finished goods; under 90% usually points to scheduling, not logistics CalculatorDAX
OTIF (On Time in Full) ↑ Orders delivered on time AND at full ordered quantity ÷ orders due 90-95% is strong on most CPG scorecards; many retailers apply deductions below 95% CalculatorDAX
Past-Due Backlog ↓ Count (or $ value) of open orders past their promised date No external benchmark; the target is zero net growth month over month on a promise date that doesn't move CalculatorDAX

Safety 1

KPIFormulaTypical rangeTools
TRIR (Total Recordable Incident Rate) ↓ Recordable incidents × 200,000 ÷ total hours worked Varies by NAICS code; BLS publishes annual industry averages, many discrete manufacturers target under 2.0 CalculatorDAX

Inventory 2

KPIFormulaTypical rangeTools
Inventory Days on Hand ↓ (Average inventory value ÷ COGS) × 365 Finished goods commonly target 30 to 60 days; raw material target depends on supplier lead time, not a general number CalculatorDAX
Inventory Turns ↑ Cost of goods sold ÷ average inventory value 6-12 turns/year is typical for discrete manufacturers; under 4 usually means excess or slow-moving stock CalculatorDAX

Financial 1

KPIFormulaTypical rangeTools
4-Wall Margin ↑ (Plant revenue - plant-controllable costs) ÷ plant revenue Varies widely by industry and product mix; track trend against your own plant budget rather than an external number CalculatorDAX

Labor 3

KPIFormulaTypical rangeTools
Absenteeism Rate ↓ Unplanned absence hours ÷ total scheduled hours 2-3% is typical for manufacturing; above 5% usually strains scheduling and overtime spend CalculatorDAX
Labor Productivity ↑ Units produced ÷ total labor hours No universal target; track trend against your own baseline, ideally normalized to standard hours earned rather than raw units CalculatorDAX
Overtime Percentage ↓ Overtime hours ÷ total hours worked Under 5% is typical for a well-staffed plant; sustained overtime above 10% usually signals structural understaffing, not a temporary surge CalculatorDAX