Supply Chain KPI Service: OTIF, DIFOT, Fill Rate: Calculation & Formulas in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ส.ค. 2024

ความคิดเห็น • 64

  • @mohamedshaheen1995
    @mohamedshaheen1995 8 หลายเดือนก่อน

    Love it DIFOT - I usually calculate the DIFOT internally and also External Customer Service level as well, however customer measure us with their over value vs delivered value and not with the date of delivery , data accuracy is the biggest challenge to get better clarity of visibility - tracking is top priority to crack it

  • @filangeshosho5986
    @filangeshosho5986 2 ปีที่แล้ว +1

    I like the way you explain and I start my associate degre in logistic supply this year.

    • @abcsc
      @abcsc  2 ปีที่แล้ว +1

      Thank you! I try to explain it simply

  • @rossdally6880
    @rossdally6880 ปีที่แล้ว

    Thanks so much for this I have just joined a manufacturing company. So this all applies and to better my knowledge across the board.

  • @vincentwamakowe8376
    @vincentwamakowe8376 ปีที่แล้ว +1

    Thank you so much Sir for this info. It's very informative. I only deal with OTIF and Fill Rate. Today I have learned more than what I knew as I also understood i needed more than that. All thanks to you. God Bless you 🙏

  • @abodunrinadewoletemitayo7867
    @abodunrinadewoletemitayo7867 ปีที่แล้ว +1

    Thank you for your lesson i really gain a lot and i am looking forward to learn more from you.

  • @obedass
    @obedass 2 ปีที่แล้ว +3

    Great videos keep it up
    Very power full videos
    We really appreciate your efforts to share your experience and knowledge with us
    We hope to continue posting new videos🙏👍

    • @abcsc
      @abcsc  2 ปีที่แล้ว +1

      Thanks a lot Obedas :-) I have new supply chain and inventory management tutorials coming very soon ! Take care

  • @user-zq1cn9gi3h
    @user-zq1cn9gi3h 9 หลายเดือนก่อน +1

    Thank you for sharing. This is insightful.

  • @eimranjettey8244
    @eimranjettey8244 2 ปีที่แล้ว +2

    Really appreciate your content
    Please do keep it up

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Thank you! Yes I will 😉

  • @abdoukarimdiop7530
    @abdoukarimdiop7530 9 หลายเดือนก่อน

    Thank you i’ve learnt so many things visualizing this vidéo

  • @shribalaji838
    @shribalaji838 2 ปีที่แล้ว +2

    Very informative and very well explained. Than Looking forward to more videos from you!!

    • @abcsc
      @abcsc  2 ปีที่แล้ว +1

      Thanks Shri 🙏. More tools and videos coming soon 🔜

  • @hazemshatat7442
    @hazemshatat7442 11 หลายเดือนก่อน +1

    Great Content, Thank you for the effort!

  • @viaseung
    @viaseung 2 ปีที่แล้ว +1

    Great video, love the supply chain dashboard.

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Glad you liked it!

  • @itsmylife8639
    @itsmylife8639 2 ปีที่แล้ว +1

    Excellent work.

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Thanks Saurabh :-)

  • @1005pramu
    @1005pramu 2 ปีที่แล้ว +1

    Great Explanation.... keep it up

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Thanks Raj, I will !

  • @PREDATORPOLAND
    @PREDATORPOLAND 2 ปีที่แล้ว +1

    Very interesting presentation

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Thanks 😁

  • @ASHISHSHARMA-mt4nj
    @ASHISHSHARMA-mt4nj 2 ปีที่แล้ว

    Good very informative...waiting for more videos with Real life examples.

    • @abcsc
      @abcsc  ปีที่แล้ว

      Thank you, more to come!

  • @abcsc
    @abcsc  2 ปีที่แล้ว

    How do you track your service ? What is your main challenge ? Tell me in the comments

    • @christianvandenberg4350
      @christianvandenberg4350 2 ปีที่แล้ว +2

      The consequences of poor forecast accuracy leading to high inventories or low whereas my cs suffers as well as creating additional costing as changes in frozen period causing additional costing of manufacturing a product .
      Tracking today : cs (otif) /doh / supplier otif / ss coverage / qa rft
      Applying Scor-p model would help to get more grip on your chain (reliability/responsiveness/agility/cost/asset management)

  • @angelcrmmlozanoiturria3975
    @angelcrmmlozanoiturria3975 ปีที่แล้ว

    Great, clear, righty.

  • @theinnocenttruth
    @theinnocenttruth 2 ปีที่แล้ว

    STRONG VIDEO, KEEP IT UP BRO

    • @abcsc
      @abcsc  ปีที่แล้ว

      Thanks, will do!

  • @zulkhaireesulaiman8575
    @zulkhaireesulaiman8575 2 ปีที่แล้ว +2

    I'd love if you made available the full supply chain dashboard that you made, 15:38 . informative video as always!

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      It is a dashboard from my SCM Metrics course: abcsupplychain.com/scm-metrics/

  • @NS_Kat
    @NS_Kat 2 หลายเดือนก่อน

    Thank you.

    • @abcsc
      @abcsc  3 วันที่ผ่านมา

      😊

  • @bharatrasve3566
    @bharatrasve3566 2 หลายเดือนก่อน

    Use match insted row

  • @ajayiaustin-rulex7996
    @ajayiaustin-rulex7996 ปีที่แล้ว

    Thanks so much. You were silent about fill rate until you mentioned something about it towards the end while speaking on data accuracy. Is it equivalent to sth you have mentioned in the course of the video or it is another KPI that is trackable. want you to clarify sir

  • @YAlife721
    @YAlife721 2 ปีที่แล้ว +2

    Hello Sir,
    It was nice information which you have shared with us...
    Can also please share information on Demand forecasting and budget planning in same excel sheet...?

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Thanks Mohd, I will definitely share more information about demand forecasting and planning. Stay tuned 🚀

    • @YAlife721
      @YAlife721 2 ปีที่แล้ว +1

      Thank you sir ....
      That will great....hope you share with us soon ...

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      My pleasure Mohd. New videos & tools coming very soon. Don’t forget to subscribe to get notified 🚀

    • @YAlife721
      @YAlife721 2 ปีที่แล้ว

      @@abcsc noted sir

  • @al-venturesbyallanflores3602
    @al-venturesbyallanflores3602 2 ปีที่แล้ว +1

    How do you treat back orders in the OTIF calculation? Say originally a back order since 3 months ago, do you always consider it in the monthly calculation until fully served?

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Hello Allan ! Good question. The backorders are considered in the OTIF calculation only with the date of the order. They are not repeated in the calculation each month, except if the order is cancelled and re-created (in some companies they cancel the orders after x days). Once the order has been delivered, the DIF goes back to 100% but the DIFOT remains at 0 if the delay is not fulfilled.

  • @voanhtuan5913
    @voanhtuan5913 2 ปีที่แล้ว +1

    tks abcsupplychain
    you can share more book or source online learn for logistics specialist

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      Have a look at my website abcsupplychain.com/
      😉

  • @ay6___9cy63
    @ay6___9cy63 ปีที่แล้ว

    Very informative and good video. I would to hear from your opinion/suggestion for (1)we have SKUs which sell in different UOM (yes, 1 same SKU, but it can be sent in carton, inner box and some SKU can be delivered in gram/KG) (2) we thought of using value (selling price) seeing the complexity to get one uniform UOM for >3000 SKU we have, to calculate DIFOT. But there are various noises and top management want to see it in volume (quantity). How can we go about it?

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj 11 หลายเดือนก่อน

    Also share a dashboard forecast accuracy measured

  • @trevelynpillay8021
    @trevelynpillay8021 ปีที่แล้ว +1

    How do you measure Otifs on a volume basis? I mean if one DC that pushes a small volume meets OTIF easily, how do you justify that against a high volume DC?

    • @abcsc
      @abcsc  ปีที่แล้ว +1

      Hello Trevelyn Pillay! Not sure to get what you mean? OTIF is a percentage so it doesn't depend on the volumes

    • @abcsc
      @abcsc  ปีที่แล้ว

      Hi, you're welcome! In this case, I was talking about a crisis situation, so you want to be safe only for the most predictable items ;) Your inventory policy depends on your own strategy

  • @ehsankhakbazan409
    @ehsankhakbazan409 ปีที่แล้ว

    Thank you. I have a question. Why did you calculate DIFOT as a multiplication of DOT,DOQ and DIF. I don't understand the logic behind it. By definition it is the number of orders that are both delivered in time and complete or partial.

  • @aj8237
    @aj8237 ปีที่แล้ว

    Hello, I would like to know when the next time you will be hosting your master class. Please advise. No matter what browser, there was no sign up button on the link you provided. Thanks!

  • @zewdutessema1222
    @zewdutessema1222 2 ปีที่แล้ว +1

    Thanks for this, Can customer satisfaction rate indicate inventory management performance especially in health facilities? Thank you again///

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      You need to track both service and inventory turnover (stock turn) to find the right balance between overstock and shortage. These are 2 separate KPIs that you should use. I am going to publish another video about the second one very soon.

  • @m.farhanhidayat6215
    @m.farhanhidayat6215 11 หลายเดือนก่อน

    Thank you so much for your information. If you don't mide, can i get the file about the dashboard that you showed in that video 15:45 ?

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj 11 หลายเดือนก่อน

    Hi Edouard,
    Could you pls share a excel base dashboard for this service level kpi to track service level

  • @ARIZABEST
    @ARIZABEST 4 หลายเดือนก่อน

    What "Quality issues" exactly measures?

    • @abcsc
      @abcsc  3 หลายเดือนก่อน

      Hi! This is just the count of items delivered that do not meet the quality specifications agreed upon with the supplier, without any categorization of the defects.

  • @viaseung
    @viaseung 2 ปีที่แล้ว

    Awesome video and love your supply chain dashboard, how do I get an access on it? (15:35 purple dashboard)

    • @abcsc
      @abcsc  2 ปีที่แล้ว

      It is a dashboard from my SCM Metrics course: abcsupplychain.com/scm-metrics/

    • @viaseung
      @viaseung 2 ปีที่แล้ว

      @@abcsc thanks! Will check out.

  • @miku1408
    @miku1408 2 ปีที่แล้ว

    What is the duration of your workshop?

    • @abcsc
      @abcsc  ปีที่แล้ว

      1h30!

  • @ilonasemicheva3129
    @ilonasemicheva3129 ปีที่แล้ว

    😊