I'm a Swedish-based Lean consultant, and the owner of the free World-Class-Manufacturing.com web site.
In short, I teach key descision makers how to get a cost-effective and robust production.
Contact Oskar Olofsson Lean Maintenance Calculators
A collection of our most popular calculators in Excel format for off-line use
View all products
 |
TPM / Lean Maintenance Pages |
OEE - calculator
Calculate Overall Equipment Effectiveness
Use this form to estimate the OEE ratio.
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 ?
OEE 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 benefits become tangible and noteworthy.
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, OEE 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 OEE correctly reduces complex production problems into simple, easy-to-follow steps in handling data and information. The OEE 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.
OEE 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 of OEE is that it allows companies to have separate business functions by applying/using a single, easy-to-understand formula.
Overall Equipment Effectiveness is by far the most effective benchmarking tool in making sound management decisions.
Useful Formulas:
OEE = Actual output / Theoretical maximum output
OEE = 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
Download
| OEE Calculator in Excel format | $9 USD |
| All WCM calculators (OEE, LCC, Spare Parts, MTBF, z-score, DPMO, Takt, Kanban) | $39 USD |
Widget
Add this calculator to your web site or blog
  |
We are using the Fastspring e-Commerce platform for secure payment and convenient file transfer. A number of payment options are possible including purchace order. Once you have completed the payment process, you will receive an e-mail with the download link. We will refund your full purchase price if you are not satisfied. |