OEE Calculation In Microsoft Excel: Illustration With Practical Example

Поділитися
Вставка
  • Опубліковано 2 лис 2024

КОМЕНТАРІ • 36

  • @maheshwani8813
    @maheshwani8813 3 роки тому +1

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

    • @learnandapply
      @learnandapply  3 роки тому

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

  • @ojoolufemi1817
    @ojoolufemi1817 Рік тому +1

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

    • @learnandapply
      @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.

  • @barsvelioglu2276
    @barsvelioglu2276 2 роки тому +1

    Excellent tutorial

    • @learnandapply
      @learnandapply  2 роки тому

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

  • @khalidnawaz6536
    @khalidnawaz6536 3 роки тому +1

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

    • @learnandapply
      @learnandapply  3 роки тому

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

  • @tiramixulighteu6822
    @tiramixulighteu6822 3 роки тому +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
      @learnandapply  3 роки тому

      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.

  • @muhammadhurairabinwaheed3020
    @muhammadhurairabinwaheed3020 2 роки тому +1

    Very well explained

    • @learnandapply
      @learnandapply  2 роки тому

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

  • @abdullahkashwah9235
    @abdullahkashwah9235 2 роки тому +1

    Thank you brother

    • @learnandapply
      @learnandapply  2 роки тому

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

  • @khalidnawaz6536
    @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
      @learnandapply  3 роки тому

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

  • @chineduodoh9832
    @chineduodoh9832 Рік тому +1

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

    • @learnandapply
      @learnandapply  Рік тому

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

  • @dechatunmeesuk2126
    @dechatunmeesuk2126 3 роки тому +1

    Thank you so much

    • @learnandapply
      @learnandapply  3 роки тому

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

  • @Rahulkumar-yh8oo
    @Rahulkumar-yh8oo 3 роки тому +1

    Thank you sir

  • @khalidnawaz6536
    @khalidnawaz6536 3 роки тому

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

  • @khalidnawaz6536
    @khalidnawaz6536 3 роки тому +1

    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
      @learnandapply  3 роки тому

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

  • @MuhammadSiddiqueSulehria
    @MuhammadSiddiqueSulehria 9 місяців тому +1

    Ideal cycle time mean ...?

    • @learnandapply
      @learnandapply  9 місяців тому

      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)

  • @rudreshjoshi8693
    @rudreshjoshi8693 3 роки тому

    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
      @learnandapply  3 роки тому

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

  • @subramaniananandhamoorthy3249
    @subramaniananandhamoorthy3249 2 роки тому +1

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

    • @learnandapply
      @learnandapply  2 роки тому

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

  • @ajitraut5029
    @ajitraut5029 3 роки тому +1

    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
      @learnandapply  3 роки тому

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

  • @rongwong1431
    @rongwong1431 2 роки тому +1

    india

  • @khalidnawaz6536
    @khalidnawaz6536 3 роки тому

    I think it should be 86.85%

    • @learnandapply
      @learnandapply  3 роки тому

      Please take total values with decimals.
      0.008 is actually 0.008333