Home / Calculators / OTIF calculator
Supplier performance and risk
OTIF calculator: on-time in-full delivery rate
Enter the total orders received, the orders on time, the orders in full and the orders that were both. You get each rate and the OTIF score.
OTIF is the share of orders that arrived both on time and in full. At the default numbers the on-time rate is 89.0%, the in-full rate is 92.0% and OTIF is 83.5%.
Written by Procurement VMS Editorial Team · Reviewed by Michael, Procurement Advisor Expert · Updated
Your numbers
The boxes start with an example so you can see how it works. Replace them with your own figures.
Your result
OTIF is below 90 percent. See which side drags the score down, since late and short deliveries have different causes and different fixes.
| On-time rate | 89.0% |
|---|---|
| In-full rate | 92.0% |
| OTIF rate | 83.5% |
| Orders that missed the standard | 198 orders |
| Points lost to the weaker of the two | 11.0% |
The currency box changes the label only. Enter amounts in the currency you choose.
Free PDF and Excel
Save this result as a PDF guide and an Excel model
Free to download. You enter your name, work email and phone number, and the files are ready at once.
- PDF guide with the formula, a worked example and a checklist of what to enter
- Excel model with live formulas, so your own numbers recalculate at once
- Ready at once after the form, with no account to create
The files open with the example numbers from the page. Type yours over the blue cells in the Excel file. The calculator on this page is free to use without a form.
How the OTIF calculator works
The formula
OTIF = orders on time and in full / total orders x 100. On-time rate = orders on time / total orders. In-full rate = orders in full / total orders.
OTIF is a strict measure. An order counts only if it arrived inside the agreed window and with the full quantity. A supplier that is 98 percent on time and 98 percent in full can still score below 97 percent OTIF.
Define the window and the quantity tolerance with the supplier before you measure. Without an agreed definition the score becomes a dispute.
The example numbers are illustrative and are not benchmarks. Use your own data for any decision.
How to use it with your own data
- Agree what on time and in full mean: the delivery window and any quantity tolerance.
- Count orders from your receiving records for the period.
- Compare the on-time and in-full rates to see which one to fix first.
Mistakes that skew the answer
Counting from the promised date the supplier set
Measure against the date in your purchase order, or the date you both agreed.
Mixing partial deliveries
A split delivery is in full only when the last part arrives, so decide how to treat it.
Reporting one number for all suppliers
Averages hide the problem suppliers. Report by supplier and category.
What to do with the result
Record the result on your supplier scorecard and use it in performance reviews. For quality, track the PPM defect rate, and add both to your procurement KPI dashboard.
Questions about the OTIF calculator
What does OTIF stand for?
OTIF stands for on time, in full. It measures the share of orders delivered on the agreed date and in the agreed quantity.
What is a good OTIF score?
Targets differ by industry. Many buyers set targets in the 90s and agree a figure with each supplier.
How is OTIF different from on-time delivery?
On-time delivery ignores quantity. OTIF needs both.
Do I need to include quality?
OTIF covers delivery only. Some firms extend it to OTIFNE, adding no errors, to include documents and quality.