DF CONSULTING
I fix problems.

Lean toolkit / 15

OEE Calculator

Availability times performance times quality. Enter one shift and the three losses separate themselves, so you know whether you are losing time, speed or parts.

XLSX templatePDF template Entries stay in this browser

Ideal cycle time is the fastest the machine has ever run a good part, not the rate on the quote. Planned production time excludes time you chose not to run; everything else you lose is downtime.

World class is often quoted as 85%. Ignore the benchmark and watch your own trend. A machine that is not the constraint does not need a high OEE, it needs to be available when the constraint calls for it.

The shift

One machine, one shift

Example figures are loaded. Replace them with your shift.

Result

Where the time went

Run time—minutes
Lost to stops—minutes
Lost to speed—minutes
Lost to rejects—pieces

Where the losses sit

Minutes lost by cause — work the top two, nothing else
Loss categoryMinutes lostShareCountermeasure and owner
Total minutes lost0

Working on something harder than a worksheet?

Tools do not fix processes. People with a method do.

I am David Fowles. I have spent 25 years in nuclear operations, power generation field service, manufacturing quality and supply chain, and I build the capability to keep an improvement after I leave. If one of these sheets has shown you something you would rather not solve alone, say so.

Email me See what I do

david@df-consulting.net
Connecticut, United States