OTIF (On-Time In-Full): Formula, Targets and Retail Fines
OTIF, short for on-time in-full, is the share of deliveries that reach the customer inside the agreed window with every unit ordered. Retailers use it to grade suppliers and to fine the ones that miss. We give the formula, show how one delivery can score 0% or 96% depending on how it is counted, and set out which misses belong to a brand's 3PL.
Quick summary
- OTIF is the share of orders, lines or cases delivered inside the agreed window and in the full quantity ordered, expressed as a percentage.
- The formula is on-time, in-full deliveries divided by total deliveries, times 100, so 90 complete, on-time orders out of 100 score 90%.
- The same delivery can score 0%, 92% or 96% depending on whether the retailer counts orders, lines or cases.
- Walmart began fining suppliers in 2017 and by 2019 wanted 87% of full truckloads inside a 2-day window, with fines of 3% of the cost of goods sold.
- Early deliveries can count as misses, because on time means inside a window, not before a deadline.
- A 3PL owns pick accuracy, the ship-by date, routing requests, carton labels and the ASN, and its contract should say which chargebacks it covers.
What OTIF means
OTIF, on-time in-full, measures how often deliveries arrive when agreed and complete. It has 2 tests, and a delivery has to pass both:
- On time: it arrived inside the agreed delivery window, or by the agreed date where there is no window.
- In full: it carried the full quantity of every item ordered, to the right location.
The same measure goes by DIFOT, delivered in full on time. It is a KPI on both sides of a trade relationship: retailers use it to score suppliers, and suppliers use it to score their own warehouses, 3PLs and carriers.
How to calculate OTIF
OTIF = deliveries that were on time and in full ÷ total deliveries x 100.
- Define the window: the date or range of dates that counts as on time, and whether early counts as late.
- Define the unit: orders, order lines or cases.
- Count the units that passed both tests in the period.
- Divide by all units delivered in the period.
A month with 100 orders, of which 90 arrived on time and complete, scores 90%. That arithmetic is the easy part. Steps 1 and 2 decide the score, and they are set by whoever is doing the measuring.
One delivery scored 3 ways
Take one retail purchase order: 12 lines of 40 cases each, 480 cases in all. One line ships 20 cases short. The retailer’s window is Wednesday to Thursday.
| Measured by | In full | OTIF if it arrives Wednesday | OTIF if it arrives Tuesday, a day early |
|---|---|---|---|
| Order | 0 of 1 orders complete | 0% | 0% |
| Line | 11 of 12 lines complete | 92% | 0% |
| Case | 460 of 480 cases delivered | 96% | 0% |
The same truck scores 0%, 92% or 96% depending only on the unit of measure. Arriving a day early takes every version to 0%, because no unit on it was on time. A brand and its 3PL that agree to “95% OTIF” without naming the unit and the window have agreed on a number, not a standard.
What a good OTIF score is
There is no industry standard, because retailers define the window, the unit and the data differently. A good score is the one the retailer or the contract requires, measured the way they measure it.
Walmart’s program shows how targets move. From August 2017, Walmart required suppliers to deliver 100% of products at the must-arrive-by date 75% of the time, with a 3% fine based on the shipment’s value and fines for early and short deliveries as well as late ones. It raised the requirement to 85% in 2018 and, in 2019, to 87% for full truckloads inside a 2-day window, with the fine stated as 3% of the cost of goods sold. It also said it would split the single measure into separate on-time and in-full scores. Those figures are history; current targets and fine rules come from each retailer’s own supplier terms.
OTIF vs OTD vs fill rate
| Measure | What it tests | Measured at | Blind spot |
|---|---|---|---|
| OTIF | Timing and quantity | The customer’s dock | None of the 3, if defined tightly |
| OTD (on-time delivery) | Timing only | The customer’s dock | Short deliveries |
| Fill rate | Quantity only | Usually the warehouse, at shipping | Late or early arrival |
| On-time ship rate | Timing of the handoff | The carrier’s first scan | Transit and receiving delays |
For a brand shipping direct to consumers, the nearest measure is on-time ship rate, one of the order fulfillment metrics that stop at the carrier’s first scan rather than the customer’s door.
Who owns an OTIF miss
A retail OTIF miss can start in 4 places, and the retailer’s scorecard rarely says which:
| Owner | Typical misses | Evidence to ask for |
|---|---|---|
| Brand | Stock-outs, POs accepted beyond stock, late PO confirmation, wrong case pack or GTIN in the retailer’s item file | Stock by SKU at PO acceptance |
| 3PL | Short or wrong picks, missed ship-by date, late routing request or appointment, wrong carton labels or ASN, poor load build | Ship date against ship-by date per PO, ASN accuracy |
| Carrier | Late pickup, transit delay, missed appointment | Pickup and delivery timestamps |
| Retailer DC | Receiving backlog, rescheduled appointment | Appointment history, receiving date |
Sets add a way to short a line. A PO line of pre-built kits is only as full as its scarcest component, so one late insert can short a line of 1,000 finished sets while every other component sits on the shelf.
The fixes follow the owners:
- Measure the retailer’s way: the same unit, window and data source, taken from the retailer’s scorecard rather than the 3PL’s ship log.
- Cut at acceptance, not at the dock: check PO quantities against stock the day the PO arrives, and agree any short line with the buyer before the truck is loaded.
- Route on day 1: submit the routing request and book the appointment the day the PO is released.
- Scan at pick and at load: case counts and carton labels checked against the ASN before the trailer is closed.
- Review misses by owner weekly: and dispute the retailer’s own errors inside its dispute window.
Rescue shipments are the expensive fix. When a small PO is rushed by parcel to make the window, the carrier bills each carton on the greater of its actual and dimensional weight, and the rescue can cost more than the fine it avoids.
Writing OTIF into a 3PL agreement
A 3PL built for ecommerce fulfillment is usually measured on same-day shipping and pick accuracy. Retail OTIF adds routing requests, delivery appointments, carton labels and ASNs, and each needs its own line in the agreement, with the retailer’s chargebacks split by who caused them.
Frequently asked questions
What does OTIF stand for?
OTIF stands for on-time in-full. It measures the share of deliveries that arrive inside the agreed window with the full quantity ordered. It is also called DIFOT, for delivered in full, on time.
Is OTIF a KPI?
Yes. OTIF is a key performance indicator for delivery reliability, used by retailers to score suppliers and by suppliers to score their warehouses and carriers. It is only comparable between 2 parties when both measure it the same way.
How is OTIF calculated?
Divide the deliveries that were both on time and in full by total deliveries, and multiply by 100. If 90 of 100 orders arrived on time and complete, OTIF is 90%. The result depends on whether you count orders, lines or cases, and on what counts as on time.
What is the difference between OTD and OTIF?
OTD, on-time delivery, measures only whether a delivery arrived when promised. OTIF adds the quantity test, so a delivery that arrives on time but short passes OTD and fails OTIF. OTIF can never be higher than OTD measured the same way.
What is a good OTIF rate?
A good OTIF rate is the one your retailer or contract requires, because definitions differ too much for a single industry figure. Walmart asked for 75% when it began fining suppliers in 2017 and 87% by 2019, measured its own way. Set an internal target above the retailer's and measure it on the retailer's terms.
What is OTIF vs fill rate?
Fill rate measures how much of an order shipped, usually when it leaves the warehouse, with no time test. OTIF measures quantity and timing together at the customer's dock. A shipment can have a 100% fill rate and still fail OTIF by arriving outside the window.
Does an early delivery count against OTIF?
In retail programs that use a delivery window, yes: on time means inside the window, not before a deadline. Walmart fined early deliveries along with late and short ones from the start of its program in 2017. Check the retailer's own definition before shipping ahead of schedule.
Who is responsible for OTIF when a 3PL ships the order?
The retailer fines the supplier, so the brand pays first, whoever caused the miss. The 3PL is responsible for the steps it controls, such as picking, shipping by the ship-by date, routing requests, carton labels and the ASN. Its contract should say which chargebacks it reimburses.