Blog / Metrics
Metrics · Guide

Manufacturing KPI Formulas: A Full Cheat Sheet

OL By OEE Lab Editorial |Updated 2 November 2026 |7 min read
Short answer

This is a reference of manufacturing KPI formulas with one worked number each. The core one is OEE = availability x performance x quality, or good units x ideal cycle time / planned time. In the example shift below, that gives 72.0%. Before comparing any two figures, check that they use the same time base.

The example shift

Most formulas below use one hypothetical shift, so that you can trace each number. Where a KPI needs a longer period, the row gives its own numbers.

Planned time 480 min, stops 72 min, run time 408 min
Ideal cycle time 1.2 s (ideal rate 50 units/min)
Total units 18,000, rejects 720, good first time 17,280
Hypothetical inputs. Rejects are 450 scrap and 270 rework. Stops are 30 min changeover and 42 min unplanned.

Need to know which KPIs to choose, and not how to work them out? Go to the list of production KPIs, which also shows how the losses of a shift add up.

OEE and time-based effectiveness

KPIFormulaWorked number
Availabilityrun time / planned time408 / 480 = 85.0%
Performancetotal units x ideal cycle / run time18,000 x 1.2 s / 24,480 s = 88.2%
Qualitygood units / total units17,280 / 18,000 = 96.0%
OEEavailability x performance x quality0.85 x 0.882 x 0.96 = 72.0%
OEE, short formgood units x ideal cycle / planned time17,280 x 1.2 s / 28,800 s = 72.0%
TEEPOEE x planned time / all calendar time72.0% x 480 / 1,440 = 24.0%
OOEgood units x ideal cycle / staffed time345.6 min / 540 min = 64.0%
OEE as in Overall Equipment Effectiveness (R. C. Hansen, 2001). OOE uses a hypothetical 540-minute staffed window here. It has no single definition, so check its time base.

The two OEE rows must give the same answer, which makes them a handy check on your data. Try it in the OEE calculator.

The last three rows look like rival scores, but they share one numerator. Only the time you divide by changes.

OEE: 480 planned min72.0%
OOE: 540 staffed min64.0%
TEEP: 1,440 calendar min24.0%
Good minutes = 17,280 x 1.2 s = 345.6 min. Same output, three time bases, three answers.

Output, flow and delivery

KPIFormulaWorked number
Throughputgood units / scheduled hours17,280 / 8 = 2,160 per hour
Actual cycle timerun time / total units24,480 s / 18,000 = 1.36 s
Takt timeavailable time / customer demand28,800 s / 18,000 = 1.6 s
Plan attainmentgood units / planned units17,280 / 18,500 = 93.4%
Schedule adherencejobs run as scheduled / jobs scheduled9 / 10 = 90.0%
On-time deliveryorders on time / orders shipped188 / 200 = 94.0%
Capacity utilizationactual output / maximum output86,400 / 108,000 = 80.0%
Lead time (Little's law)work in process / throughput4,320 / 2,160 per hour = 2 hours
Value-added ratiovalue-added time / lead time6 min / 120 min = 5.0%
Throughput uses scheduled hours here. Always say which base you used.

Cap plan attainment per product, so extra output on one item cannot hide a miss on another.

Takt time comes from demand, so it says what the line must do. Here the shift made one good unit every 28,800 / 17,280 = 1.67 s, slower than the 1.6 s takt.

Quality

KPIFormulaWorked number
First pass yieldgood first time / units entering17,280 / 18,000 = 96.0%
Final yield(good first time + reworked good) / units entering17,550 / 18,000 = 97.5%
Rolled throughput yieldFPY1 x FPY2 x FPY30.98 x 0.96 x 0.99 = 93.1%
Scrap ratescrap units / total units450 / 18,000 = 2.5%
Rework ratereworked units / total units270 / 18,000 = 1.5%
Defective PPMdefective units / total units x 1,000,000720 / 18,000 x 1,000,000 = 40,000
DPMOdefects / (units x opportunities) x 1,000,000900 / (18,000 x 5) x 1,000,000 = 10,000
Customer return rateunits returned / units shipped24 / 6,000 = 0.4%
Rework counts as a reject in OEE quality and FPY, since it was not right the first time.

Scrap and rework rates share a base here, so 2.5% + 1.5% + 96.0% first pass yield = 100%. The guide to first pass yield goes deeper.

Downtime and reliability

KPIFormulaWorked number
Downtime %stop time / planned time72 / 480 = 15.0%
Unplanned downtime %unplanned stop time / planned time42 / 480 = 8.8%
Changeover sharechangeover time / planned time30 / 480 = 6.3%
Mean time between stopsrun time / number of stops408 / 24 = 17 min
MTBFoperating time / failures160 h / 8 = 20 h
MTTRtotal restoration time / failures12 h / 8 = 1.5 h
Inherent availabilityMTBF / (MTBF + MTTR)20 / 21.5 = 93.0%
Failure ratefailures / operating time8 / 160 h = 0.05 per hour
MTTFtotal operating time / failed items48,000 h / 6 = 8,000 h
PM compliancePMs done on time / PMs due46 / 50 = 92.0%
MTBF and MTTR use one month of hypothetical data. MTTF is for items replaced and not repaired.

The IEC vocabulary defines MTBF on operating time and MTTR as mean time to restoration, which includes waiting for parts and people. Others read it as hands-on repair only, so state which one you mean.

Inherent availability is not OEE availability, which also counts changeovers and other stops. Strictly, it uses hands-on repair time, so with waiting included in MTTR the result is closer to operational availability.

Work out your own with the MTBF and MTTR calculator.

People, cost, stock, energy and safety

KPIFormulaWorked number
Units per labor hourgood units / labor hours17,280 / 48 = 360
Overtime shareovertime hours / regular hours96 / 1,600 = 6.0%
Absence ratehours absent / hours scheduled40 / 1,600 = 2.5%
Cost per unit(material + labor + overhead) / good units8,640 / 17,280 = 0.50
Cost of poor qualityscrap cost + rework cost + other failure cost450 x 0.50 + 270 x 0.20 = 279
Inventory turnscost of goods sold / average inventory1,200,000 / 200,000 = 6.0
Days of inventory365 / inventory turns365 / 6 = 60.8 days
Energy per unitenergy used / good units1,728 kWh / 17,280 = 0.10 kWh
TRIRrecordable injuries and illnesses x 200,000 / hours worked2 x 200,000 / 160,000 = 2.5
LTIFRlost-time injuries x 1,000,000 / hours worked1 x 1,000,000 / 160,000 = 6.25
The 200,000 is OSHA's base: 100 employees x 40 hours x 50 weeks (BLS formula). LTIFR per million hours is as used by Safe Work Australia, and other bodies may differ. Money figures are in any currency.

Cost per unit falls with higher OEE only if the extra output gets sold, as explained in cost per unit. Compare a safety rate only with one on the same base, since 200,000 and 1,000,000 hours give very different numbers.

Five errors that break these formulas

  • Averaging percentages. To combine lines, add up the minutes, then divide. See how to average OEE across machines.
  • Mixing time bases. One report uses planned time, another uses run time, and the two can't be compared.
  • Using top speed for some products only. Set an ideal rate for each product, or performance will drift when the mix changes.
  • Counting rework as good. It pushes up quality and hides the time that repairs cost.
  • Mismatched units. Cycle time in seconds and run time in minutes is a common source of a wrong answer, so convert before you divide.

How to use this sheet

Write the definitions you adopt into one page, including how breaks, changeovers and rework count. A formula only helps when everyone runs it the same way.

Then connect each number to a goal with a KPI tree. It will show which of these you really need.

See it live in Fabrico

Most of the inputs above are the same few numbers: time, stops and counts. Fabrico, a light MES for OEE, takes them live from PLCs or IoT sensors, with add-on AI cameras counting output where a machine has no usable signal, and shows OEE per line and shift. See how Fabrico calculates OEE.

What people ask next

What is the formula for OEE?

OEE = availability x performance x quality. It equals good units x ideal cycle time / planned production time, which is a useful cross-check. See availability, performance and quality for each factor.

How do you calculate MTBF and MTTR?

MTBF = operating time / number of failures. MTTR = total restoration time / number of failures. Use the same equipment and period for both, and try the MTBF and MTTR calculator.

What is the difference between first pass yield and quality in OEE?

Often none, when both count only units right the first time. They can differ if FPY is measured at a step while OEE quality is measured at the line's exit. See how to calculate first pass yield.

How do you calculate throughput?

Throughput = good units / time. Use scheduled hours for the line's real pace, or run hours to see its speed while running, and state which one you chose. See how to calculate throughput.

Can I use these formulas in Excel?

Yes. Put the raw inputs in their own cells, then let every KPI refer to those cells, so that one correction updates the whole sheet. The guide to the OEE formula in Excel shows the layout.

See OEE per line and shift on your own machines

Fabrico is a light MES for OEE. It takes stops, speed and counts from PLCs or IoT sensors, with add-on AI cameras counting output where a machine has no usable signal, and operators tag the cause at the line.

Book a Fabrico demo

← More OEE Lab guides · Open the OEE calculator →

OEE essentials: OEE calculator · What is OEE · Six big losses · Availability · TEEP · Cost of downtime · OEE benchmark · Free OEE tracker · Free OEE software · How to track downtime · How to implement OEE · Light MES vs full MES