OEE Calculation In Microsoft Excel: Illustration With Practical Example

Рет қаралды 32,797

Күн бұрын

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

Пікірлер: 36

@khalidnawaz6536 3 жыл бұрын

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

@learnandapply 3 жыл бұрын

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

@maheshwani8813 2 жыл бұрын

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

@learnandapply 2 жыл бұрын

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

@tiramixulighteu6822 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Excellent tutorial

@learnandapply 2 жыл бұрын

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

@khalidnawaz6536 3 жыл бұрын

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 3 жыл бұрын

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

@muhammadhurairabinwaheed3020 2 жыл бұрын

Very well explained

@learnandapply 2 жыл бұрын

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

@dechatunmeesuk2126 3 жыл бұрын

Thank you so much

@learnandapply 3 жыл бұрын

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 2 жыл бұрын

Thank you brother

@learnandapply 2 жыл бұрын

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

@Rahulkumar-yh8oo 3 жыл бұрын

Thank you sir

@learnandapply 3 жыл бұрын

You're welcome ☺

@khalidnawaz6536 3 жыл бұрын

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 3 жыл бұрын

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

@khalidnawaz6536 3 жыл бұрын

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

@rudreshjoshi8693 2 жыл бұрын

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 2 жыл бұрын

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

@chineduodoh9832 8 ай бұрын

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

@learnandapply 8 ай бұрын

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

@ajitraut5029 3 жыл бұрын

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 3 жыл бұрын

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