OTIF and fill rate calculator
Calculate on-time, in-full and OTIF rates plus line and unit fill rates from one set of order counts, and see why one week can score both 90% and 99%.
Plan a tracking project
Calculator
On time in full (OTIF) and fill rate both describe whether customers got what they ordered when they expected it, but they count different things. The same week of deliveries can score 90% on one measure and nearly 99% on another. This calculator works out the five common rates from one set of counts, so you can see the difference side by side and choose which one to report.
How to use the calculator
- Orders due in the period. Count orders whose due date falls in the period, whether or not they shipped.
- Orders on time, orders in full, and orders that were both. Count each against your written definition. The number that were both can never exceed either count on its own; the calculator checks this.
- Order lines and lines shipped complete.
- Units ordered and units shipped.
The formulas
On-time rate = orders on time ÷ orders due
In-full rate = orders in full ÷ orders due
OTIF = orders both on time and in full ÷ orders due
Line fill rate = lines shipped complete ÷ order lines
Unit fill rate = units shipped ÷ units ordered
OTIF is counted order by order. It is not the on-time rate multiplied by the in-full rate.
Example (fictional). A distributor had 640 orders due in a month. 598 arrived on time, 611 arrived in full, and 579 were both. The orders held 4,210 lines, of which 4,105 shipped complete, and 51,800 units, of which 51,120 shipped.
- On-time rate: 598 ÷ 640 = 93.4%
- In-full rate: 611 ÷ 640 = 95.5%
- OTIF: 579 ÷ 640 = 90.5%
- Line fill rate: 4,105 ÷ 4,210 = 97.5%
- Unit fill rate: 51,120 ÷ 51,800 = 98.7%
Reading the result
The same month scores anywhere from 90.5% to 98.7%. A warehouse reporting unit fill rate and a customer measuring OTIF are both right, and they will still disagree in the quarterly review.
Break down the failures. 61 orders missed OTIF. 42 were late and 29 were short, which adds up to 71, so 10 orders were both late and short. Multiplying the two rates (93.4% × 95.5%) gives 89.2%, which is wrong because the failures overlap.
The shortfall is small in units and large in orders: 680 missing units, about 1.3% of the total, were enough to break 29 orders. If customers measure in full by order, protecting complete orders matters more than raising overall unit availability. That is a question for allocation rules and for safety stock on the items that cause most short lines.
ASCM’s perfect order goes further than OTIF: an order that is “on time, complete, accurate, and undamaged.” OTIF covers the first two. Accuracy and condition need receiving and claims data from the customer side.
Write the definition next to the number
- On time against what? The requested date, the promised date or a delivery window? Measured at shipment or at the customer’s dock?
- How early is too early? Some customers count early deliveries as failures.
- In full by what rule? Every unit of every line, or within a tolerance? Do substitutions count?
- Which orders? Are cancelled orders, customer-caused delays and agreed partial shipments excluded?
Common mistakes
- Dividing by orders shipped instead of orders due, which hides the orders that never left.
- Measuring against a re-promised date, which turns a late order into an on-time one.
- Multiplying the two rates instead of counting orders that met both.
- Using your ship date when the customer measures delivery.
- One blended number across customers who define OTIF differently.
When the simple model stops working
- Customer scorecards and compliance programs with their own definitions, measurement points and penalties.
- Orders delivered in several shipments, where on time needs a rule for each part.
- Delivery measurement. On time at the customer needs carrier delivery events, not just your ship confirmation. Map them with the tracking milestone map.
- Root cause. A rate shows the size of the problem. Reason codes for each failed order show where it comes from.
When OTIF is assembled by hand from ERP exports and carrier portals every month, the report is late and arguable. Capturing delivery events and exception reasons as they happen is the work of shipment tracking software.
Scope your project.
Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.