OEE Calculation In Microsoft Excel: Illustration With Practical Example

To learn Lean Six Sigma most Effectively and Practically visit vijaysabale.co/join
To attend an online coaching program: vijaysabale.co/training
Hello Friends,
This is the 3rd video on OEE and we are going to learn how to use Microsoft Excel to calculate OEE with the help of a Practical Example.
We are going to learn the formulae and the meaning for each of the terms used in the calculation of Overall Equipment Effectiveness (OEE):
1. Total Available Time
2. Planned Shutdown
3. Scheduled Operating Time
4. Downtime Loss
5. Ideal Cycle Time
6. Operating Time
7. Net (Effective) Operating Time
8. Speed Loss
9. Total Production
10. Good Production
11. Production Rejects
12. Availability Rate
13. Performance Rate
14. Quality Rate, and
15. Overall Equipment Effectiveness (OEE)
I am sure you will like it.
If you want to download a FREE excel template to understand OEE calculation and its implementation in real-life, then click on this link:
vijaysabale.ck.page/oee
In the previous video, we had seen 8 practical reasons why one should go for Lean Six Sigma certification. If you want to download the pdf for this content (all the 8 reasons), then please get it through this link:
vijaysabale.ck.page/pdfguide
Some important links about LEARN & APPLY:
🏫 Know about LEARN & APPLY: www.learnandapply.org/
👨🏽🏫 Know about Myself (Trainer/Coach): vijaysabale.com/
You can also visit our Learning Management System (LMS) 📚📖📑 to access online courses at:
www.successfulcareerhub.com/p...
0:00 Introduction
0:29 All Terms in OEE
5:03 Data For OEE
5:34 What is the correct way of calculating OEE
6:55 Factors of OEE
8:38 Relationship between OEE Factors
And finally, thank you for watching…
#oee #oeeexample #oeeexcel #oeecalculation #leansixsigma #learnandapply #sixsigma #successfulcareerhub

[@khalidnawaz6536]

Excellent work sir. Please keep posting all good material. So we will learn it from your best skills. Keep it up!

[@learnandapply]

Thank you so much for your valuable comments and appreciation 😊🙏

[@maheshwani8813]

Excellent sir, Very good explained after watching video everybody can easily understand OEE calculation concept.

[@learnandapply]

Thank you so much Mahesh for your valuable comments and appreciation ☺🙏

[@tiramixulighteu6822]

I find this video very useful. I just want to ask about the differences between Planned Shutdown and Downtime loss. I hope I will receive your explanation soon. Thank you in advance!!

[@learnandapply]

Thank you so much for your valuable comments and appreciation.
The planned shutdown is a scheduled loss like a lack of orders from customers, whereas downtime loss is due to some unplanned incidences like machines not functioning.

[@barsvelioglu2276]

Excellent tutorial

[@learnandapply]

Thank you so much for your valuable comments and appreciation 🙏☺

[@khalidnawaz6536]

This is really an excellent demonstration about to Clculate OEE.. One thing is miscalculation about finding The Performance. The calculation of the performance should be 86.87% which you showed 97.4% in the example. You may Review and can change the %age value of Performance. Thanks

[@learnandapply]

Can you please recheck the values? Where did you get the performance rate of 97.4%?🤔

[@muhammadhurairabinwaheed3020]

Very well explained

[@learnandapply]

Thank you so much for your valuable comments and appreciation 🙏☺

[@dechatunmeesuk2126]

Thank you so much

[@learnandapply]

Your welcome and thank you so much for your valuable comments!😊

[@ojoolufemi1817]

Hello, thank you for the video, very informative. Please how do one calculate OEE for multiple machines?

[@learnandapply]

Hi Ojo, thank you for your valuable comment and appreciation!
You can use the multiplication of OEE's for these machines to indicate cumulative OEE.

[@abdullahkashwah9235]

Thank you brother

[@learnandapply]

You're welcome and thank you so much for your valuable comments 🙏☺

[@Rahulkumar-yh8oo]

Thank you sir

[@learnandapply]

You're welcome ☺

[@khalidnawaz6536]

Sir, cn you upload a video that can show that how we can use these data by plotting a graph on excel nd that will be awesome for all the viewers. Thanks

[@learnandapply]

Ok, thank you so much for your valuable comments and suggestions 😊🙏

[@khalidnawaz6536]

Performance: Ideal cycle time (0.008)× total production time( 1900) ÷ operating tiime (17.5)

[@rudreshjoshi8693]

Suppost it given that downtime is 10 min and cleaning time is 15 min then do we need to subtract cleaning time in operations time?? Please answer as soon as possible

[@learnandapply]

Please treat cleaning time as downtime. Though it is needed in some processes, it can be improved.

[@chineduodoh9832]

Thanks for all you do, please can you share the excel file?

[@learnandapply]

Thank you for your valuable comments and appreciation! 🙏☺️
It's already there in the description.

[@ajitraut5029]

When organisation keep machine running 24hrs by giving 1or2 extra manpower then they consider total time ie 24hr for calculation. And when organisation gives time to operator for lunch, snacks etc.. and there is no extra operator to run machine during this breaks then they minus that time from available time for OEE calculation.

[@learnandapply]

Well said. Thank you so much for your valuable comments! 😊

[@subramaniananandhamoorthy3249]

why we are multiplying hundred with all outputs in oee second formula sheet

[@learnandapply]

Just to convert them in percentage.
Thank you for your valuable comments. 🙏☺

[@MuhammadSiddiqueSulehria]

Ideal cycle time mean ...?

[@learnandapply]

Ideal cycle time is the minimum time required to produce single unit. (It is either given my machine manufacturer or calculated by time-motion study)

[@rongwong1431]

india

[@khalidnawaz6536]

I think it should be 86.85%

[@learnandapply]

Please take total values with decimals.
0.008 is actually 0.008333