An OEE calculation template gives manufacturers a structured worksheet for computing Overall Equipment Effectiveness from the three component metrics — Availability, Performance, and Quality — and identifying which of the Six Big Losses is consuming the most production capacity. OEE is calculated as the product of all three components: a line running at 90% Availability, 95% Performance, and 98% Quality produces an OEE of 83.8%, with 16.2% of planned production capacity lost to downtime, speed loss, and quality defects. Getting the OEE formula correct — particularly the ideal cycle time baseline and the inclusion of rework in quality losses — is what separates an OEE number that drives improvement from an OEE number that tells a comfortable story about a line that is underperforming. This template walks through every input, formula, and worked example.
Replace Your OEE Excel Template With Real-Time iFactory OEE Tracking
iFactory calculates OEE automatically from machine count data and timestamped downtime events — Availability, Performance, Quality, and Six Big Losses ranked by shift, line, and plant. No spreadsheet to fill in, no formula to verify every shift.
OEE Inputs — What You Need Before You Calculate
Three input values are required to calculate OEE: planned production time, run time (planned production time minus downtime), ideal cycle time, total units produced, and good units produced. The most important of these is the ideal cycle time — the maximum speed the machine can run, not the speed it is currently running. Using actual speed as the Performance baseline is the single most common OEE calculation error and the one that most consistently produces a false OEE picture. The second most common error is excluding rework from the quality loss count, which overstates Quality and produces a composite OEE that is systematically optimistic.
Planned Production Time
Total scheduled hours in the measurement period minus all planned stops: breaks, scheduled maintenance, no-order periods. This is the denominator of Availability. Example: 8-hour shift minus 30 minutes of breaks = 450 minutes PPT.
Ideal Cycle Time
The maximum rate the machine can produce — the nameplate rate or engineered standard. NOT the current running rate. If the machine's nameplate says 150 units/hour, ideal cycle time is 24 seconds/unit. This value is fixed by engineering and reviewed quarterly.
Unplanned Downtime Duration
Total minutes of unplanned stops during the measurement period — from timestamped downtime event log, not estimated. Changeover time is recorded separately but may be excluded or included depending on your OEE scope definition.
Total Units Produced
All units produced during run time: good units plus scrapped units plus reworked units. NOT good units only. Total count is the denominator of Performance.
Good Units (First Pass)
Units that passed all quality checks on the first attempt — no rework. Reworked units that eventually pass are NOT good units for OEE purposes. They are quality losses.
Measurement Period
Shift, day, week, or month. OEE is most actionable at shift level because shift-level data enables supervisors to act on the specific loss within the production cycle. Weekly or monthly OEE trends are useful for management review but too lagged for operational response.
OEE Calculation — Live Worked Example
The calculator below shows a complete shift OEE calculation with real input values — 450-minute planned production time, 47 minutes of downtime, 940 units produced at a 24-second ideal cycle time, and 912 good units first pass. The result is 80.9% OEE — below the 85% world-class benchmark, with Availability as the largest loss component.
Availability — Downtime as a Proportion of Planned Time
Availability measures the proportion of planned production time during which the machine was actually running. It is calculated as run time divided by planned production time. The definition of planned production time is the most important definitional choice in the OEE calculation — it determines the Availability denominator. Planned stops (breaks, scheduled maintenance) must be excluded from the denominator. Including them would make Availability appear lower than it actually is and would inflate the apparent magnitude of the Availability improvement opportunity.
| Input | Value | Unit | Notes |
|---|---|---|---|
| Shift duration | 480 | min | 8-hour shift |
| Planned stops (breaks) | 30 | min | Two 15-min breaks — excluded from PPT |
| Planned Production Time (PPT) | 450 | min | 480 − 30 |
| Unplanned downtime | 47 | min | 3 events this shift |
| Run Time | 403 | min | 450 − 47 |
| Availability | 89.6% | 403 / 450 = 0.896 | |
| Ideal cycle time | 24 | sec/unit | Nameplate rate — locked by engineering |
| Total units produced | 940 | units | Good + scrap + rework |
| Performance | 93.1% | (24s × 940) / (403 × 60s) = 0.931 | |
| Good units (first pass) | 912 | units | No rework included |
| Quality | 97.0% | 912 / 940 = 0.970 | |
| OEE | 80.9% | 0.896 × 0.931 × 0.970 |
In this worked example, 47 minutes of unplanned downtime on a 450-minute planned production time produces an Availability of 89.6%. The downtime consumed approximately 10% of available production capacity — representing 10.4% of planned production time lost to equipment failure or stoppages.
Performance — How Close to Ideal Speed
Performance measures how close the actual production rate was to the ideal cycle time during the period the machine was running. It is calculated as (ideal cycle time × total count) divided by run time. Performance below 100% indicates either reduced speed running (the machine is producing deliberately slower than its ideal rate) or minor stoppages (brief stops under five minutes that operators clear without logging). Both are Speed Loss categories in the Six Big Losses framework. A Performance rate that never drops below 97% on a complex machining line is almost certainly the result of an ideal cycle time that is set too slow — not a line that is genuinely running near nameplate speed.
Quality — First-Pass Yield in the OEE Context
Quality measures the proportion of total units produced that were conforming on the first pass — without rework. It is calculated as good units divided by total units. The critical discipline is including rework in the quality loss count: a unit that fails first inspection, gets reworked, and eventually passes is a quality loss in OEE terms. It consumed machine time to produce incorrectly and additional labour time to rework. Excluding it from the quality loss count overstates OEE Quality and hides the true cost of process non-conformance. A quality rate that never drops below 99.5% in a high-volume, complex manufacturing environment almost certainly excludes rework.
Six Big Losses — From OEE Number to Improvement Priority
The Six Big Losses framework translates the three OEE components into six specific loss categories, each with a distinct improvement methodology. An OEE number alone tells you how much capacity you are losing; the Six Big Losses tells you where it is going and how to get it back. The largest loss category for a shift is the highest-value improvement opportunity for the next shift or the next production meeting.
| Loss Category | OEE Component | Definition | Improvement Method |
|---|---|---|---|
| Equipment Failure | Availability | Unplanned breakdowns requiring maintenance intervention | Predictive/preventive maintenance, MTBF improvement |
| Setup & Adjustment | Availability | Changeover time, trial runs, product adjustments | SMED (Single Minute Exchange of Die) |
| Minor Stoppages | Performance | Stops under 5 min cleared by operator — often unlogged | Eliminate jamming, improve material flow, poka-yoke |
| Reduced Speed | Performance | Running below ideal cycle time for any reason | Root cause analysis of speed reduction, retrain to standard |
| Startup Rejects | Quality | Scrap and rework during process stabilisation at start of run | Reduce warm-up, improve first-off process, standard startup |
| Production Rejects | Quality | Scrap and rework during steady-state production | SPC, IPQC, root cause on top defect codes |
iFactory Calculates OEE Live — Six Big Losses Ranked Every Shift
iFactory captures downtime, machine counts, and quality results in real time — calculates Availability, Performance, and Quality automatically — and ranks the Six Big Losses by impact. No OEE worksheet to fill in, no formula errors, no end-of-shift manual entry.
OEE Calculation Checklist — 25 Items
Use this checklist to verify your OEE calculation inputs and formula application. Common errors in OEE calculation are captured in the High priority items — verify each before using OEE data for performance management or improvement targeting.
| # | Checklist Item | Type | Priority | Photo | Required | Critical |
|---|---|---|---|---|---|---|
| 1 | Planned production time defined and agreed — scheduled hours minus planned stops | Pass/Fail | High | — | ✓ | ✓ |
| 2 | Ideal cycle time locked — engineered or nameplate rate, not current actual rate | Pass/Fail | High | — | ✓ | ✓ |
| 3 | Total unplanned downtime duration recorded for the measurement period | Numeric | High | — | ✓ | ✓ |
| 4 | Total units produced (good + scrap + rework) counted accurately for the period | Numeric | High | — | ✓ | ✓ |
| 5 | Good units count verified — excludes rework and scrap, first-pass only | Numeric | High | — | ✓ | ✓ |
| # | Checklist Item | Type | Priority | Photo | Required | Critical |
|---|---|---|---|---|---|---|
| 6 | Run time = planned production time minus unplanned downtime duration | Numeric | High | — | ✓ | ✓ |
| 7 | Availability = run time / planned production time | Numeric | High | — | ✓ | ✓ |
| 8 | Availability expressed as decimal (0.0–1.0) before multiplying in OEE formula | Pass/Fail | High | — | ✓ | ✓ |
| 9 | Planned stops correctly excluded from denominator — breaks, maintenance, no-orders | Pass/Fail | High | — | ✓ | ✓ |
| 10 | Availability result reviewed — value above 0.95 on first implementation warrants data check | Pass/Fail | Med | — | ✓ | — |
| # | Checklist Item | Type | Priority | Photo | Required | Critical |
|---|---|---|---|---|---|---|
| 11 | Performance = (ideal cycle time × total count) / run time | Numeric | High | — | ✓ | ✓ |
| 12 | Ideal cycle time in same unit as run time (seconds per unit if run time in seconds) | Pass/Fail | High | — | ✓ | ✓ |
| 13 | Performance cannot exceed 1.0 (100%) — any result above 1.0 indicates ideal cycle time is too slow | Pass/Fail | High | — | ✓ | ✓ |
| 14 | Total count includes good + scrap + rework — not good units only | Pass/Fail | High | — | ✓ | ✓ |
| 15 | Performance below 0.85 investigated for speed reduction practices or minor stoppages | Pass/Fail | Med | — | ✓ | — |
| # | Checklist Item | Type | Priority | Photo | Required | Critical |
|---|---|---|---|---|---|---|
| 16 | Quality = good count / total count | Numeric | High | — | ✓ | ✓ |
| 17 | Good count excludes all rework — reworked units counted as quality loss | Pass/Fail | High | — | ✓ | ✓ |
| 18 | Quality rate above 0.995 in a complex process warrants rework inclusion check | Pass/Fail | High | — | ✓ | ✓ |
| 19 | Startup rejects coded separately if being tracked — reduces first-run startup losses | Pass/Fail | Med | — | ✓ | — |
| 20 | Quality expressed as decimal (0.0–1.0) before multiplying in OEE formula | Pass/Fail | High | — | ✓ | ✓ |
| # | Checklist Item | Type | Priority | Photo | Required | Critical |
|---|---|---|---|---|---|---|
| 21 | OEE = Availability × Performance × Quality | Numeric | High | — | ✓ | ✓ |
| 22 | OEE result between 0 and 1 — expressed as % by multiplying by 100 | Pass/Fail | High | — | ✓ | ✓ |
| 23 | Six Big Losses classified and quantified: Equipment Failure, Setup, Minor Stops, Speed Loss, Startup Rejects, Production Rejects | Pass/Fail | High | — | ✓ | ✓ |
| 24 | Largest loss category identified — top improvement priority for next shift | Pass/Fail | High | — | ✓ | ✓ |
| 25 | OEE baseline recorded — minimum 4 weeks of data before setting improvement targets | Pass/Fail | Med | — | ✓ | — |
Frequently Asked Questions
What is the OEE formula?
OEE = Availability × Performance × Quality. Availability = Run Time / Planned Production Time. Performance = (Ideal Cycle Time × Total Count) / Run Time. Quality = Good Count / Total Count. All three components are expressed as decimals between 0 and 1 before multiplication. The result is also between 0 and 1 — multiply by 100 to express as a percentage. A world-class OEE of 85% is produced by Availability of approximately 90%, Performance of approximately 95%, and Quality of approximately 99.5%.
What is ideal cycle time in OEE and why does it matter?
Ideal cycle time is the maximum production rate achievable by the machine under optimal conditions — typically the nameplate rate or the engineering standard set for the process. It is the Performance baseline: if the machine produces at ideal cycle time for the entire run time, Performance = 100%. If it produces slower, Performance is below 100%. The most common OEE calculation error is using the average actual running rate as the ideal cycle time. This makes Performance permanently close to 100% and hides speed loss entirely — the most common and most recoverable OEE loss category in most manufacturing operations.
Why should rework be included in OEE quality calculations?
Rework must be included in OEE Quality loss because reworked units consumed machine time to produce incorrectly and additional labour time to correct. A unit that fails first inspection, gets reworked by an operator, and eventually passes final inspection is a quality failure that cost production capacity — even if it ultimately ships to the customer. OEE Quality = Good Count (first-pass only) / Total Count. Excluding rework consistently overstates Quality and understates the cost of process non-conformance. Book a Demo to see how iFactory captures rework in the Quality OEE calculation.
What OEE is considered good in manufacturing?
World-class OEE for discrete manufacturing is widely cited as 85%, produced by Availability around 90%, Performance around 95%, and Quality around 99.5%. For process manufacturing (continuous flow), world-class OEE is approximately 65% because process lines have longer and more complex changeovers and more planned maintenance requirements. The more important benchmark than a world-class target is your own trend — consistent improvement from your current baseline toward a stretch target is more operationally meaningful than achieving a generic benchmark.
How does iFactory replace an OEE Excel template?
iFactory replaces the OEE Excel template by capturing every OEE input automatically: machine counter data for production count, timestamped downtime events for Availability, and inspection results for Quality. The ideal cycle time is locked by engineering in the system configuration and cannot be changed by operators. OEE is calculated per shift and per line automatically — with Availability, Performance, Quality, and Six Big Losses breakdown displayed on the shift dashboard. No spreadsheet, no formula entry, no data transcription. Book a Demo to see the OEE module.
iFactory OEE — Live, Accurate, Six Big Losses Ranked Every Shift
iFactory captures every OEE input in real time, calculates OEE automatically with your locked ideal cycle time, and displays the Six Big Losses Pareto for every shift. Replace your OEE calculation template with live OEE that drives daily improvement action.