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

Поделиться
HTML-код
  • Опубликовано: 19 янв 2025

Комментарии • 66

  • @MohammadEnamulKabir-k5p
    @MohammadEnamulKabir-k5p Месяц назад

    Great video, being a practitioner in Supply chain - I find your video super value adding. Thank you

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

  • @mohamedshaheen1995
    @mohamedshaheen1995 Год назад

    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

  • @RoopasR-s7y
    @RoopasR-s7y Год назад +1

    Thank you for sharing. This is insightful.

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

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

  • @abodunrinadewoletemitayo7867
    @abodunrinadewoletemitayo7867 Год назад +1

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

  • @abdoukarimdiop7530
    @abdoukarimdiop7530 Год назад

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

  • @hazemshatat7442
    @hazemshatat7442 Год назад +1

    Great Content, Thank you for the effort!

  • @eimranjettey8244
    @eimranjettey8244 2 года назад +2

    Really appreciate your content
    Please do keep it up

    • @abcsc
      @abcsc  2 года назад

      Thank you! Yes I will 😉

  • @mohammadabid4945
    @mohammadabid4945 4 месяца назад

    Wonderful video, very informative. Thank you so much.

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

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

  • @1005pramu
    @1005pramu 2 года назад +1

    Great Explanation.... keep it up

    • @abcsc
      @abcsc  2 года назад

      Thanks Raj, I will !

  • @theinnocenttruth
    @theinnocenttruth 2 года назад

    STRONG VIDEO, KEEP IT UP BRO

    • @abcsc
      @abcsc  2 года назад

      Thanks, will do!

  • @itsmylife8639
    @itsmylife8639 3 года назад +1

    Excellent work.

    • @abcsc
      @abcsc  3 года назад

      Thanks Saurabh :-)

  • @austinrulex
    @austinrulex Год назад

    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

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

  • @PREDATORPOLAND
    @PREDATORPOLAND 3 года назад +1

    Very interesting presentation

    • @abcsc
      @abcsc  3 года назад

      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!

  • @aj8237
    @aj8237 2 года назад

    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!

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

  • @al-venturesbyallanflores3602
    @al-venturesbyallanflores3602 3 года назад +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  3 года назад

      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.

  • @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  2 года назад +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  2 года назад

      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

  • @angelcrmmlozanoiturria3975
    @angelcrmmlozanoiturria3975 Год назад

    Great, clear, righty.

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj Год назад

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

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

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

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

  • @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 Год назад

    Also share a dashboard forecast accuracy measured

  • @ARIZABEST
    @ARIZABEST 9 месяцев назад

    What "Quality issues" exactly measures?

    • @abcsc
      @abcsc  8 месяцев назад

      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.

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

  • @NS_Kat
    @NS_Kat 7 месяцев назад

    Thank you.

    • @abcsc
      @abcsc  5 месяцев назад

      😊

  • @bharatrasve3566
    @bharatrasve3566 7 месяцев назад

    Use match insted row

  • @miku1408
    @miku1408 2 года назад

    What is the duration of your workshop?

    • @abcsc
      @abcsc  2 года назад

      1h30!

  • @ilonasemicheva3129
    @ilonasemicheva3129 2 года назад

    😊