OTIF means on time and in full. In this worksheet, it is the percentage of eligible shipments that meet both the agreed delivery-time rule and the complete-quantity rule. Define those rules before calculating the percentage; a number without its denominator and conditions is difficult to compare.
This is an original measurement example for business use. It is not WTM’s reported service performance, a customer scorecard or a claim about an industry average.
Use the intersection, not two separate percentages
Suppose 100 eligible shipments were due in a period. Ninety-four met the agreed time rule, 97 met the quantity rule, and 92 met both. OTIF is therefore 92 ÷ 100 × 100 = 92%.
You cannot simply average 94% and 97%, or multiply them, to recover the observed intersection. Count the shipments that actually passed both checks.
Shipment-level OTIF calculator
Planning arithmetic only. No rates, carrier classification or loading capacity are certified. Inputs stay in this browser.
JavaScript is off. The formulas and worked examples below remain available.
The calculator divides the number meeting both rules by the total eligible shipments. It does not infer the intersection from separate on-time and in-full totals.
Define the measurement contract
| Rule | Decision to record |
|---|---|
| Measurement unit | Shipment, order or order line? |
| Time commitment | Which accepted window and timezone? |
| Completion event | Arrival, unloading or accepted handoff? |
| In-full criterion | Outer handling units or verified order contents? |
| Reporting population | Which shipments were due in the period? |
| Exceptions | How are cancellations, changes and missing records handled? |
Keep those rules stable across periods. Show exclusions separately instead of silently removing difficult shipments from the denominator.
Use due shipments, not only easy-to-find completed ones
If the purpose is to measure commitments due this month, filtering only deliveries completed this month can omit overdue shipments. Build the eligible set from the defined commitment and determine the outcome for each member of that set.
A missing record is not automatic proof of success. Give it an explicit unresolved category and explain how it affects the displayed result until investigated.
Distinguish transport from contents fulfilment
The carrier may document receiving three sealed pallets without checking the product count inside them. Choose the in-full definition appropriate to the question. A transport handling-unit score and a retailer’s complete-order score can differ without either calculation being arithmetically wrong.
Use our count hierarchy reference to define the level being measured.
Make the result useful
After calculating OTIF, group exceptions by observable reason and assign an action. A recurring late release at the supplier requires a different response from a receiving appointment mismatch. Do not turn the metric into a blame label without reviewing the records.
WTM’s shipment history and delivery documents can support your own review alongside the customer and order data you maintain. Use the freight scorecard guide to place OTIF beside other defined measures, and discuss actual requirements with our freight team before the next movement.
