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

Download the Excel File (OTIF & Availability Rate calculations) here :
abcsupplychain.com/download-s...
FREE Workshop to master the best metrics for your Supply Chain: abcsupplychain.com/free-suppl...
▬▬▬▬▬▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬▬▬▬▬▬▬
►Service KPIs Introduction :
00:00 Introduction KPI Supply chain Service
01:12 Profitable Supply Chain : 3 main KPIS
03:58 3 Pillars to track the Customer Service Level
04:44 Service Rate or Availability Rate ? (Coca-Cola & Walmart Example)
08:16 Using Quantity ? Value ? Volume ? Weight ?
►Excel Step-by-Step tutorial:
09:10 Availability Rate calculation
12:04 DIF (Delivery In Full)
13:10 DOQ (Delivery on Quality)
13:42 DOT (Delivery on Time)
14:42 OTIF (On Time, In Full) aka DIFOT, SIFOT
16:10 5 Mistakes to avoid when tracking Service Rates / OTIF
19:38 My final advice
▬▬▬▬▬▬▬▬▬▬▬▬▬▬ LINKS ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
TOOLS & EXCEL (free) : abcsupplychain.com/en/tools-e...
MY BLOG : abcsupplychain.com
#supplychain #logistics #servicelevel #fillrate #otif #difot #kpi

Пікірлер: 63

  • @abodunrinadewoletemitayo7867
    @abodunrinadewoletemitayo7867 Жыл бұрын

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

  • @user-zq1cn9gi3h
    @user-zq1cn9gi3h7 ай бұрын

    Thank you for sharing. This is insightful.

  • @hazemshatat7442
    @hazemshatat744210 ай бұрын

    Great Content, Thank you for the effort!

  • @shribalaji838
    @shribalaji8382 жыл бұрын

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

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thanks Shri 🙏. More tools and videos coming soon 🔜

  • @abdoukarimdiop7530
    @abdoukarimdiop75307 ай бұрын

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

  • @eimranjettey8244
    @eimranjettey82442 жыл бұрын

    Really appreciate your content Please do keep it up

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thank you! Yes I will 😉

  • @filangeshosho5986
    @filangeshosho59862 жыл бұрын

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

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thank you! I try to explain it simply

  • @itsmylife8639
    @itsmylife86392 жыл бұрын

    Excellent work.

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thanks Saurabh :-)

  • @viaseung
    @viaseung2 жыл бұрын

    Great video, love the supply chain dashboard.

  • @abcsc

    @abcsc

    Жыл бұрын

    Glad you liked it!

  • @obedass
    @obedass2 жыл бұрын

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

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

  • @NS_Kat
    @NS_Kat19 күн бұрын

    Thank you.

  • @vincentwamakowe8376
    @vincentwamakowe8376 Жыл бұрын

    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 🙏

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

  • @angelcrmmlozanoiturria3975
    @angelcrmmlozanoiturria3975 Жыл бұрын

    Great, clear, righty.

  • @1005pramu
    @1005pramu2 жыл бұрын

    Great Explanation.... keep it up

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thanks Raj, I will !

  • @PREDATORPOLAND
    @PREDATORPOLAND2 жыл бұрын

    Very interesting presentation

  • @abcsc

    @abcsc

    2 жыл бұрын

    Thanks 😁

  • @ASHISHSHARMA-mt4nj
    @ASHISHSHARMA-mt4nj Жыл бұрын

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

  • @abcsc

    @abcsc

    Жыл бұрын

    Thank you, more to come!

  • @theinnocenttruth
    @theinnocenttruth Жыл бұрын

    STRONG VIDEO, KEEP IT UP BRO

  • @abcsc

    @abcsc

    Жыл бұрын

    Thanks, will do!

  • @mohamedshaheen1995
    @mohamedshaheen19957 ай бұрын

    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

  • @zulkhaireesulaiman8575
    @zulkhaireesulaiman85752 жыл бұрын

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

  • @abcsc

    @abcsc

    Жыл бұрын

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

  • @abcsc
    @abcsc2 жыл бұрын

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

  • @christianvandenberg4350

    @christianvandenberg4350

    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)

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

  • @YAlife721
    @YAlife7212 жыл бұрын

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

    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

  • @m.farhanhidayat6215
    @m.farhanhidayat621510 ай бұрын

    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 ?

  • @al-venturesbyallanflores3602
    @al-venturesbyallanflores36022 жыл бұрын

    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.

  • @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
    @zewdutessema12222 жыл бұрын

    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.

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

  • @voanhtuan5913
    @voanhtuan59132 жыл бұрын

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

  • @viaseung
    @viaseung2 жыл бұрын

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

  • @abcsc

    @abcsc

    Жыл бұрын

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

  • @viaseung

    @viaseung

    Жыл бұрын

    @@abcsc thanks! Will check out.

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj10 ай бұрын

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

  • @ilonasemicheva3129
    @ilonasemicheva3129 Жыл бұрын

    😊

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

  • @bharatrasve3566
    @bharatrasve3566Ай бұрын

    Use match insted row

  • @SantoshDas-qc1wj
    @SantoshDas-qc1wj10 ай бұрын

    Also share a dashboard forecast accuracy measured

  • @trevelynpillay8021
    @trevelynpillay8021 Жыл бұрын

    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

    Жыл бұрын

    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

  • @ARIZABEST
    @ARIZABEST3 ай бұрын

    What "Quality issues" exactly measures?

  • @abcsc

    @abcsc

    2 ай бұрын

    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.

  • @miku1408
    @miku1408 Жыл бұрын

    What is the duration of your workshop?

  • @abcsc

    @abcsc

    Жыл бұрын

    1h30!