# OEE Formula Quick Reference Table > Source: https://netray.co/tools/oee-formula-quick-reference-table > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A searchable lookup of the standard OEE family formulas, with what each one needs as input and the usual pitfalls. ## Category mes-shop-floor ## Industry Discrete Manufacturing ## Audience - Plant manager - Continuous improvement manager - Process engineer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Metric **Key:** metric **Type:** text #### Formula **Key:** formula **Type:** text #### Unit **Key:** unit **Type:** text #### Inputs you must collect **Key:** inputs **Type:** text #### Note **Key:** note **Type:** text **Rows:** **Metric:** Availability **Formula:** Run time / Planned production time **Unit:** % **Inputs:** Run time, planned production time **Note:** Planned production time excludes scheduled breaks and planned shutdowns in the classic OEE model. **Metric:** Run time **Formula:** Planned production time - Stop time **Unit:** minutes **Inputs:** Stop events with start and end **Note:** Count every stop above your minimum threshold, including changeovers. **Metric:** Performance **Formula:** (Ideal cycle time x Total count) / Run time **Unit:** % **Inputs:** Ideal cycle time, total count, run time **Note:** Ideal cycle time must come from the best demonstrated or rated speed, not the average. **Metric:** Performance (rate form) **Formula:** Actual rate / Ideal rate **Unit:** % **Inputs:** Actual units per hour, ideal units per hour **Note:** Equivalent to the cycle time form when run time is measured correctly. **Metric:** Quality **Formula:** Good count / Total count **Unit:** % **Inputs:** Good count, total count **Note:** Rework counts as not good in first pass OEE. **Metric:** OEE **Formula:** Availability x Performance x Quality **Unit:** % **Inputs:** The three factors above **Note:** Multiply as fractions, then show as a percent. **Metric:** OEE (time form) **Formula:** (Good count x Ideal cycle time) / Planned production time **Unit:** % **Inputs:** Good count, ideal cycle time, planned time **Note:** Same answer as the three factor form; useful as a cross check. **Metric:** Fully productive time **Formula:** Good count x Ideal cycle time **Unit:** minutes **Inputs:** Good count, ideal cycle time **Note:** The time that produced only good parts at ideal speed. **Metric:** Loading **Formula:** Planned production time / Calendar time **Unit:** % **Inputs:** Planned production time, calendar time **Note:** Shows how much of the calendar the plant chooses to run. **Metric:** TEEP **Formula:** OEE x Loading **Unit:** % **Inputs:** OEE, loading **Note:** TEEP is OEE measured against all calendar time. **Metric:** Utilization **Formula:** Actual run time / Scheduled time **Unit:** % **Inputs:** Run time, scheduled time **Note:** Not the same as availability if your scheduled time includes planned stops. **Metric:** MTBF **Formula:** Total operating time / Number of failures **Unit:** hours **Inputs:** Operating hours, failure count **Note:** Use operating time, not calendar time. **Metric:** MTTR **Formula:** Total repair time / Number of repairs **Unit:** hours **Inputs:** Repair durations, repair count **Note:** Decide in advance whether waiting for parts is included. **Metric:** Inherent availability **Formula:** MTBF / (MTBF + MTTR) **Unit:** % **Inputs:** MTBF, MTTR **Note:** A design view that ignores planned maintenance and logistics delay. **Metric:** Takt time **Formula:** Available production time / Customer demand **Unit:** minutes per unit **Inputs:** Available time, demand **Note:** A demand based pace, not a machine speed. **Metric:** First pass yield **Formula:** Units passed first time / Units started **Unit:** % **Inputs:** Units started, units passed without rework **Note:** Differs from the quality factor if you start units that are never counted as total count. **Metric:** Scrap rate **Formula:** Scrapped units / Total units produced **Unit:** % **Inputs:** Scrap count, total count **Note:** Often reported alongside OEE quality loss. **Metric:** Changeover share **Formula:** Total changeover time / Planned production time **Unit:** % **Inputs:** Changeover durations **Note:** A direct view of the setup loss inside availability. **Metric:** Cycle time ratio **Formula:** Ideal cycle time / Actual average cycle time **Unit:** % **Inputs:** Ideal and actual cycle time **Note:** Quick performance estimate when you lack counts. **Metric:** OEE loss (points) **Formula:** 100% - OEE **Unit:** % **Inputs:** OEE **Note:** Split the loss across availability, performance and quality to prioritise action. **Notes:** Definitions vary by plant. Write down which time bases and thresholds you use so numbers stay comparable between lines and over time. ## Content **Intro:** OEE is simple arithmetic wrapped in definitions that people argue about. This table lists each formula in the OEE family with the inputs you need, so a team can agree on one version and use it everywhere. **Sections:** #### How to use the table **Body:** Search by metric name or by an input such as ideal cycle time. Find the formula, check the inputs column to see what you must record at the machine, then read the note for the usual trap. Use the PDF export as a shared definition sheet for a line, a plant or an ERP project, so everyone calculates the same way. **Bullets:** - Pick one time base and stick to it - Document the minimum stop length you count - Confirm which count your ERP backflushes #### The method behind OEE **Body:** OEE splits lost production into three groups: stops (availability), slow running and small stops (performance) and defects (quality). Multiplying the three factors gives the share of planned time that produced good parts at ideal speed. TEEP widens the base to all calendar time so that unused shifts also show up as a loss. MTBF and MTTR explain the availability factor from the maintenance side. #### Reading the numbers **Body:** A line at 85% availability, 90% performance and 98% quality has an OEE of about 75%. The weakest factor is not always the best place to start; pick the loss that is cheapest to fix and largest in minutes. Compare lines only when they share the same definitions of ideal cycle time and planned time. #### Common mistakes **Body:** Teams most often use the average cycle time as the ideal, which hides performance loss. Others leave changeovers out of downtime, count rework as good, or compare OEE across lines that use different planned time rules. Fix the definitions before you chase the number. **Cta:** If the inputs live in your ERP and MES, we can help calculate these metrics from your production history without spreadsheet copying. **Faq:** #### Is OEE the same as productivity? **Answer:** No. OEE measures how well a machine or line uses its planned time to make good parts at ideal speed. Productivity usually compares output to labour or cost input. A line can have a high OEE and poor labour productivity, or the reverse. #### What ideal cycle time should I use? **Answer:** Use the fastest rate the equipment can sustain with good quality, from the rated speed or the best demonstrated run. Do not use the average. If you use the average, performance will look close to 100% and the speed losses will be invisible. #### Should planned maintenance count against OEE? **Answer:** In the classic model, planned downtime outside planned production time is excluded, and TEEP shows it as a loss. Many plants count it inside OEE instead. Either is fine if documented and used consistently across all lines. #### Can OEE be above 100%? **Answer:** Not if the inputs are right. A figure above 100% usually means the ideal cycle time is too slow, the count includes parts from another period, or the run time is understated. Treat it as a data error to investigate. ## Search terms oee formula, oee formula cheat sheet, availability performance quality formula, teep formula, mtbf mttr formula, oee calculation excel formula, manufacturing kpi formulas, net operating time formula --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json