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

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

КОМЕНТАРІ • 65

  • @RoopasR-s7y
    @RoopasR-s7y 10 місяців тому +1

    Thank you for sharing. This is insightful.

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

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

  • @mohamedshaheen1995
    @mohamedshaheen1995 10 місяців тому

    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

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

  • @eimranjettey8244
    @eimranjettey8244 2 роки тому +2

    Really appreciate your content
    Please do keep it up

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

      Thank you! Yes I will 😉

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

    Great Content, Thank you for the effort!

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

  • @mohammadabid4945
    @mohammadabid4945 Місяць тому

    Wonderful video, very informative. Thank you so much.

  • @abdoukarimdiop7530
    @abdoukarimdiop7530 11 місяців тому

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

  • @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 🙏

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

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

    Great video, love the supply chain dashboard.

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

      Glad you liked it!

  • @shribalaji838
    @shribalaji838 3 роки тому +2

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

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

      Thanks Shri 🙏. More tools and videos coming soon 🔜

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

    Great Explanation.... keep it up

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

      Thanks Raj, I will !

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

    Excellent work.

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

      Thanks Saurabh :-)

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

    Great, clear, righty.

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

    Very interesting presentation

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

      Thanks 😁

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

    STRONG VIDEO, KEEP IT UP BRO

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

      Thanks, will do!

  • @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!

  • @ASHISHSHARMA-mt4nj
    @ASHISHSHARMA-mt4nj 2 роки тому

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

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

      Thank you, more to come!

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

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

  • @m.farhanhidayat6215
    @m.farhanhidayat6215 Рік тому

    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 ?

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

  • @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/

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

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

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

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

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

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

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

      @@abcsc noted sir

  • @trevelynpillay8021
    @trevelynpillay8021 2 роки тому +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

  • @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?

  • @NS_Kat
    @NS_Kat 3 місяці тому

    Thank you.

    • @abcsc
      @abcsc  Місяць тому

      😊

  • @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/
      😉

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj Рік тому

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

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj Рік тому

    Also share a dashboard forecast accuracy measured

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

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

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

      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.

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

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

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

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

  • @ARIZABEST
    @ARIZABEST 6 місяців тому

    What "Quality issues" exactly measures?

    • @abcsc
      @abcsc  5 місяців тому

      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.

  • @bharatrasve3566
    @bharatrasve3566 4 місяці тому

    Use match insted row

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

    😊

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

    What is the duration of your workshop?