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

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

[@user-zq1cn9gi3h]

Thank you for sharing. This is insightful.

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

[@abodunrinadewoletemitayo7867]

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

[@abdoukarimdiop7530]

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

[@hazemshatat7442]

Great Content, Thank you for the effort!

[@shribalaji838]

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

[@abcsc]

Thanks Shri 🙏. More tools and videos coming soon 🔜

[@viaseung]

Great video, love the supply chain dashboard.

[@abcsc]

Glad you liked it!

[@obedass]

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]

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

[@eimranjettey8244]

Really appreciate your content Please do keep it up

[@abcsc]

Thank you! Yes I will 😉

[@filangeshosho5986]

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

[@abcsc]

Thank you! I try to explain it simply

[@itsmylife8639]

Excellent work.

[@abcsc]

Thanks Saurabh :-)

[@angelcrmmlozanoiturria3975]

Great, clear, righty.

[@1005pramu]

Great Explanation.... keep it up

[@abcsc]

Thanks Raj, I will !

[@PREDATORPOLAND]

Very interesting presentation

[@abcsc]

Thanks 😁

[@theinnocenttruth]

STRONG VIDEO, KEEP IT UP BRO

[@abcsc]

Thanks, will do!

[@ASHISHSHARMA-mt4nj]

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

[@abcsc]

Thank you, more to come!

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

[@abcsc]

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

[@christianvandenberg4350]

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)

[@zulkhaireesulaiman8575]

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

[@abcsc]

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

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

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

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

[@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]

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]

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.

[@zewdutessema1222]

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

[@abcsc]

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.

[@SantoshDas-qc1wj]

Also share a dashboard forecast accuracy measured

[@YAlife721]

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]

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

[@YAlife721]

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

[@abcsc]

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

[@YAlife721]

@@abcsc noted sir

[@SantoshDas-qc1wj]

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

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

[@voanhtuan5913]

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

[@abcsc]

Have a look at my website abcsupplychain.com/ 😉

[@bharatrasve3566]

Use match insted row

[@viaseung]

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

[@abcsc]

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

[@viaseung]

@@abcsc thanks! Will check out.

[@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]

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

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

[@ilonasemicheva3129]

😊

[@ARIZABEST]

What "Quality issues" exactly measures?

[@abcsc]

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]

What is the duration of your workshop?

[@abcsc]

1h30!