Lean Maintenance Calculators
A collection of our most popular calculators in Excel format for off-line use

Read more

Calculate Overall Equipment Effectiveness (OEE)



Total available time during the week (all shift-hours) Hours
Total downtime including scheduled and unscheduled maintenance, set-up times, lack of personnel, meetings... Hours
Theoretical maximum output per hour (Ideal Run or Cycle Time in bottleneck) (output per hour)

Total Production during the period (Actual output)  
Output that had to be re-worked or scrapped  



Download

Do you need this calculator in Excel format? Download the WCM Calculators bundle (It includes OEE, LCC, Spare Parts, MTBF, z-score, DPMO, Takt, and Kanban calculators)

All WCM Calculators (Excel) $39 USD

Widget

Add this calculator to your web site or blog

Use this form for estimation.

Take a specific period (for example, a week or a month) and change the default values in the form.

Follow the example used as the default values in the form: The press-line at Example Ltd. schedules 76 shift-hours per week.

During Week #42, about 8,200 articles were produced, but 35 of them failed to pass quality control. The press-line, for different reasons, has not been running for 18 hours during the week. The theoretical maximum output is 200 articles per hour.

What is Overall Equipment Effectiveness ?

O.E.E. is a tool that combines multiple manufacturing issues and data points to provide information about the process. It is an all-inclusive benchmarking tool that serves to gauge the various sub-components of the manufacturing process (i.e., availability, performance and quality)—and used to measure actual improvements on 5S, WCM, Lean Manufacturing, TPM, Kaizen and Six Sigma. When using O.E.E with these management systems the

After all factors are taken into account, the result is converted (transmuted) in percentage. The results (in %), therefore, can be regarded as a preview of the existing production efficiency of a particular line, cell or machine.

As we all know, manufactured goods are a result of a complex production process—and without the proper measuring tools and formula, expect your business to run blindly even in the light of day. Having the right metrics, Overall Equipment Effectivenes provides you a window to analyze out-of-the-ordinary issues and gives you an established framework for improving the whole manufacturing process.

There are dozens of formulas, systems and metrics being used to improve the whole manufacturing process, but only Overall Equipment Effectivenes correctly reduces complex production problems into simple, easy-to-follow steps in handling data and information. The tool helps you to methodically improve the process using basic measurements.

The good thing about using Overall Equipment Effectiveness is that this particular measuring tool cannot be manipulated. It is a very simple metric that immediately indicates the current status of a manufacturing process. Somehow it also becomes a multifaceted tool allowing you to understand the effect of the various issues in the manufacturing process and how they affect the entire process.

The biggest advantage is that it allows companies to have separate business functions by applying/using a single,

Overall Equipment Effectiveness is by far the most effective benchmarking tool in making sound management decisions.

Useful Formulas:

OEE = Actual output / Theoretical maximum output = Availability Ratio x Performance Ratio x Quality Ratio

• Availability Ratio — The share of the actual production time and the planned production time. All planned stops and breakdowns will reduce the availability ratio, including set-up times, preventive maintenance, breakdowns and lack of operators. The only time that you may choose to deduct from the availability ratio is lack of orders.

• Performance Ratio — Loss of production due to under-utilization of the machinery. In other words, losses are incurred when the equipment is not run with full speed. Short, unregistered, stops may affect the performance ratio as well.

• Quality Ratio — The amount of the production that has to be discharged or scrapped.

Oskar Olofsson, 2009









Pages with the most "likes":

1 5S PowerPoint - Five Steps to a Better Workplace

2 Kaizen - The zen of doing it better, and making it better

3 Z-value: Setting the Standard

4 Kanban Calculator- A Card to Pull Production

5 MTBF and MTBR




I am a Swedish-based Lean consultant, and the owner of the World-Class-Manufacturing.com web site.

Contact Oskar Olofsson



© WCM Consulting AB, Vaxholm, Sweden