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.
Nothing matches that. Try a shorter word.
higher is better lower is better. Within each category, A to Z.
Production 9
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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
| KPI | Formula | Typical range | Tools |
|---|---|---|---|
| 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 |