OTD & OTIF Calculation in Excel

This Video Covers extensive information about. ·OTD & OTIF
Download Excel template for analysis all Inventory KPI’s at - docs.google.co...
Visit our website for learning online certification courses at sitmi.in/
Like our Facebook page for more knowledge resources / sitmiedu
SITMI Academy

[@eddiel506]

This is very useful, simple and well explained. Many thanks

[@ayobelajarexcel3239]

Very useful, thanks, hope my customer will accept to this method, coz they got their own way to calculate OTD.. 😂

[@annagorokhovskaya2972]

Very very useful!

[@Valor110]

This doesnt make any sense. You have 5th column Oder quantity 400, and 400 Quantity delivered, they were delivered in full yes, but late by 2 days. You have delivered in Full as Yes, but % set as 0.

[@sitmiacademy]

That is the main difference between OTIF and OTD, Even if everything is delivered (In Full) but not within time (On time) then it is always zero. OTIF is either zero or hundred.

[@sudhirGH]

Very simple and easy to understand for beginner