OEE (Overall Equipment Effectiveness) Calculator
Calculates Overall Equipment Effectiveness (OEE = Availability × Performance × Quality) from your shift, downtime, and production data, then goes a step further: translates each of the three loss categories — downtime, slow cycles, and scrap — into an annual dollar cost, and automatically tells you which one is costing you the most. Built for plant managers, operations directors, and continuous improvement teams who already track OEE but have never seen it converted into a dollar figure that justifies (or doesn't) an improvement project.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.
Availability × Performance × Quality
The standard OEE formula computed correctly from your shift time, planned breaks, downtime, cycle time, and scrap counts — not a shortcut approximation.
Each Loss Converted to a Dollar Cost
Downtime, slow cycles, and scrap are each annualized into a dollar figure — turning an abstract percentage into a number a CFO can weigh against an improvement project's cost.
Automatically Ranks Your Biggest Loss
Compares the annualized cost of all three loss categories and names the single biggest one — which often isn't the factor with the lowest raw percentage.
Frequently Asked Questions
What is OEE and how is it calculated?
Overall Equipment Effectiveness (OEE) is a single percentage that captures how much of your planned production time is actually making good parts at full speed. It's the product of three factors: Availability (was the equipment running when scheduled?), Performance (was it running at full speed?), and Quality (did it make good parts?). The formula is OEE = Availability × Performance × Quality.
Using the calculator's defaults: an 8-hour (480-minute) shift with 60 minutes of planned breaks leaves 420 minutes of planned production time. Subtract 45 minutes of unplanned downtime and you get 375 minutes of actual operating time — an Availability of 89.3%. Running at 1 second per unit ideal cycle time but only producing 19,500 units in those 375 minutes gives a Performance of 86.7%. Of those 19,500 units, 18,720 passed inspection — a Quality of 96%. Multiply the three together: 89.3% × 86.7% × 96% = 74.3% OEE.
Why does OEE multiply the three factors instead of averaging them?
Because multiplication punishes weakness in any single area far more severely than an average would, which is closer to how production losses actually compound. Three scores of 90% each might look "pretty good" if you averaged them, but multiplied together they produce an OEE of just 72.9% (0.9 × 0.9 × 0.9) — a nearly 30-point gap between what feels intuitively fine and what the math actually says.
This is also why chasing a single high score in one category (say, running the line at maximum speed to boost Performance) can backfire if it drives up scrap and drags Quality down — the multiplication means a gain in one factor is worthless if it's offset by a loss in another. OEE forces you to improve all three together rather than over-optimizing one at the expense of the others.
What's a good OEE score, and what does mine actually cost me?
A world-class OEE score is generally considered 85% or higher, though most manufacturers realistically operate in the 60-75% range and treat that as a normal starting point for improvement. A score in the 40s or below usually signals a real, addressable problem rather than just "normal" inefficiency.
But the percentage alone doesn't tell you whether fixing it is worth the investment — that's what the calculator's dollar breakdown is for. Using the defaults, a 74.3% OEE on this line corresponds to $4,342,500 a year in lost contribution margin and wasted scrap cost, spread across downtime ($1,687,500), slow cycles ($1,875,000), and quality issues ($780,000). A CFO doesn't fund "we should improve our OEE" — they fund "we're losing $4.3 million a year and here's the biggest piece of it."
Which of the three OEE losses should I fix first — downtime, speed, or quality?
Whichever one costs you the most money, not necessarily whichever percentage looks worst. A Quality score of 96% might look like your best-performing factor, but if defective units are expensive to produce, that "small" loss can still be a meaningful cost — while a much lower Availability percentage might be cheaper to fix than it looks, if downtime minutes have a lower dollar cost per unit than scrapped units do.
The calculator handles this automatically: it compares the annualized dollar cost of all three loss categories and names your single biggest one. Using the defaults, that's Performance — running at 86.7% of ideal speed costs $1,875,000 a year, more than downtime or scrap individually. That's a very different conclusion than looking at the raw percentages alone (Availability's 89.3% is actually the lowest of the three scores), which is exactly why a percentage-only view can point you at the wrong fix.
Does a low OEE score always mean the equipment itself is the problem?
Not necessarily — OEE measures the combined effect of equipment, process, and people, and the root cause of a low score is often organizational rather than mechanical. Frequent short stops that don't get logged, inconsistent operator technique between shifts, changeovers that take longer than they should, or upstream material quality issues can all drag down OEE without the equipment itself being at fault.
That's part of why running this calculator per line, per shift, and over time matters more than a single snapshot: if OEE looks fine on the day shift but drops on nights, the equipment isn't the variable — something about that shift's process or staffing is. Track the same line across shifts and over weeks, and the pattern in Availability, Performance, and Quality will usually point you toward whether the fix is mechanical (repair or upgrade the equipment) or operational (standardize the process around it).
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.