Lean Manufacturing OEE Spreadsheet

Measuring and optimizing the utilization of machines

What is OEE?

OEE is used to measure the utilization of machines. OEE gives the overall utilization and shows the loss factors in detail.

In this way, the potential for improvements is very visible. It is not only visible on which machines to focus, but also how the capacity is increased on the machines.

Advantages when using OEE

Knowledge of machine utilization and loss factors when using an OEE measuring gives all possibilities to improve the capacity.

An improvement of the utilization at a bottleneck by 10% – increases the capacity in a value stream by 10%!

Knowledge of loss factors gives a clear picture of the way to prioritize the effort to improve capacity.

Results when using OEE

In typical manufacturing companies the machine utilization at bottlenecks is often below 50%!

Normally this can be raised to at least 80%. This means that the overall capacity can be improved by 60% - without major investments!

View demo to see how the spredsheet works

> View demo

Download a free OEE spreadsheet ready to use

No restrictions!

The spreadsheet includes:

  • Guidance on how to register and calculate OEE.
  • Guidance on using OEE results.
  • Form to register losses on machines.
  • Calculation sheets to calculate OEE and loss factors.
  • OEE graphs.
  • OEE development graphs.