Most KPI arguments on the shop floor are not formula problems. They are denominator problems. OEE, OOE and TEEP multiply the same three ratios; what changes is the block of time you divide by. MTBF and MTTR come from the same stop log but describe reliability rather than effectiveness. This cheat sheet fixes the time model first, derives every KPI from it, and carries one production line through all of them so you can see the numbers move. The Excel calculator that comes with it implements every formula on the same model, so the six KPIs are always consistent with each other.
What you get
- The KPI cheat sheet (PDF, 7 pages): the six time blocks from calendar time to fully productive time, OEE with the shortcut check, OOE, TEEP and utilization, line effectiveness at the constraint, MTBF, MTTR, MTTF and inherent availability, the ISO 22400-2 vocabulary mapped to what you already track, the TRS/TRG/TRE equivalents, nine mistakes that make KPIs incomparable, and the benchmarks used carefully.
- The multi-KPI calculator (Excel): a Shift sheet (OEE, OOE, components, shortcut check, lost sellable parts), a Week sheet (14 shifts, time-weighted OEE, utilization, TEEP), a Reliability sheet (failure log, MTBF, MTTR, inherent availability, failure rate; changeovers excluded automatically), a Line sheet (up to 8 stations, constraint identified, line effectiveness at the constraint), a TRS sheet for French reporting and a glossary. Yellow cells are inputs, grey cells are formulas.
One worked example, carried through every KPI
One line, one 8-hour shift. Shift time 480 min, planned break and cleaning 30 min, unplanned stops and changeovers 47 min, ideal cycle time 1.00 min per part, 372 parts produced, 358 good.
| KPI | Denominator | Calculation | Result |
|---|---|---|---|
| Availability | Planned production time | 403 / 450 | 89.6% |
| Performance | Run time | (1.00 x 372) / 403 | 92.3% |
| Quality | Total count | 358 / 372 | 96.2% |
| OEE | Planned production time (450 min) | 358 / 450 | 79.6% |
| OOE | Scheduled time (480 min) | 358 / 480 | 74.6% |
| TEEP (week, 10 shifts) | Calendar time (10,080 min) | 3,580 / 10,080 | 35.5% |
| MTBF (week) | 6 breakdowns | 67.2 h / 6 | 11.2 h |
| MTTR (week) | 330 min of repair | 330 / 6 | 55 min |
The 5-point gap between OEE and OOE is the cost of the 30 planned minutes. The gap between OEE and TEEP is unscheduled capacity. The sheet explains which gap calls for a maintenance action, a scheduling decision or a capital decision.
Who this is for
Plant managers and continuous improvement leads who need one definition across lines and sites, maintenance managers who need MTBF and MTTR from the same data as OEE, and anyone preparing an OEE reporting standard for a group, an auditor or an MES vendor. If you already use our OEE calculator template or the MTBF and MTTR calculator, this pack is the layer above them: the definitions that make the numbers comparable.
Download the cheat sheet and the calculator
Fill in the form and both files are sent to your e-mail address.
Guided pilot
Where Excel stops
A spreadsheet is the right tool to agree definitions and to run the first Pareto. It is the wrong tool to capture minor stops, because nobody logs a 40-second stop by hand, and minor stops are usually the largest availability loss on a line running above 70% OEE. TEEPTRAK captures every stop automatically from a sensor on the machine, without touching the PLC, and computes the KPIs on this sheet in real time. Across 450+ plants, the first effect is usually that the reported OEE drops before it rises, because manual logs miss minor stops. One documented case, Hutchinson, moved OEE from 47% to 72% once the losses became visible and were worked in sequence.
Related reading: OEE vs TEEP vs OOE vs utilization and manufacturing KPIs beyond OEE.
Frequently asked questions
What is the difference between OEE, OOE and TEEP?
All three multiply availability, performance and quality. They differ by the time they divide by: OEE uses planned production time, OOE uses scheduled shift time (so planned downtime counts as a loss) and TEEP uses calendar time, 24 hours a day, 7 days a week. On the worked example in the sheet, the same shift gives OEE 79.6%, OOE 74.6% and TEEP 35.5%.
How do MTBF and MTTR relate to OEE?
They come from the same stop log but answer a reliability question. MTBF is total operating time divided by the number of breakdowns; MTTR is total repair time divided by the number of repairs. Only breakdowns count: changeovers and material shortages are availability losses in OEE but not reliability events.
What is inside the Excel calculator?
Five linked sheets on one time model: a shift calculator (OEE, OOE, three components, shortcut check), a week roll-up with time-weighted OEE, utilization and TEEP, a reliability log for MTBF, MTTR and inherent availability, a line sheet that computes effectiveness at the constraint, and a TRS/TRG/TRE sheet for French reporting. Inputs are yellow, formulas grey.
Is 85% OEE the right target for my plant?
Not automatically. The 85% figure is Nakajima’s world-class benchmark (90% availability x 95% performance x 99% quality) for discrete manufacturing. A high-mix job shop with 20 changeovers a shift and an automated packaging line should not be judged against the same number. Build a Pareto of losses before setting a target.
0 Comments