A customer does not experience delivery performance as separate warehouse metrics. From the customer’s perspective, the question is simpler: did the complete order arrive when it was promised?
OTIF, or On Time In Full, measures exactly that. An order passes OTIF only when it satisfies both conditions at the same time: it meets the agreed delivery timing and the complete committed quantity is delivered.
In this guide, you will learn what OTIF means, how to calculate it, how On Time and In Full differ, which rules should be defined before measuring the KPI, how to handle common exceptions, and how to investigate poor results. You can also download a free OTIF Excel tracker designed for basic-to-intermediate business use.
Quick answer: OTIF measures the percentage of eligible orders that meet both the delivery-time requirement and the full-quantity requirement. It is evaluated order by order. You should not calculate OTIF by simply averaging your On Time percentage and your In Full percentage.
Table of Contents
- What Is OTIF?
- OTIF Formula
- On Time vs. In Full vs. OTIF
- Define Your OTIF Rules Before You Calculate It
- OTIF Calculation Example
- How to Measure On Time
- How to Measure In Full
- How to Handle Common OTIF Exceptions
- Why Data Coverage Matters
- How to Diagnose a Low OTIF
- How to Improve OTIF
- What Is a Good OTIF Percentage?
- Free OTIF Excel Tracker
- Frequently Asked Questions
- Methodology and References
What Is OTIF?
OTIF stands for On Time In Full. It is a supply-chain and order-fulfillment KPI used to determine whether a customer receives the complete order according to the agreed delivery timing.
OTIF combines two dimensions:
- On Time: Was the order delivered according to the agreed timing?
- In Full: Was the complete committed quantity delivered?
- OTIF: Did the same order satisfy both conditions?
| On Time | In Full | OTIF |
|---|---|---|
| Yes | Yes | Yes |
| Yes | No | No |
| No | Yes | No |
| No | No | No |
For example, suppose a customer orders five products and receives only four. Even if those four items arrive before the promised date, the order is not In Full. Therefore, it does not pass OTIF.
This combined view is useful because looking at speed or completeness separately can hide part of the customer experience.
OTIF Formula
For an order-level OTIF calculation, the formula is:
OTIF (%) = Orders that meet both On Time and In Full requirements ÷ Total eligible orders × 100
If 82 of 100 eligible orders meet both requirements:
OTIF = 82 ÷ 100 × 100 = 82%
The arithmetic is simple. The more important part is deciding which orders belong in the denominator and exactly what qualifies as On Time and In Full.
Do Not Average On Time and In Full
Suppose your operation reports:
- On Time = 90%
- In Full = 90%
Your OTIF is not automatically 90%.
The orders delivered on time may not be the same orders delivered in full. If only 82 orders out of 100 satisfied both conditions, the correct OTIF is 82%.
On Time vs. In Full vs. OTIF
| KPI | What It Measures | Typical Failure |
|---|---|---|
| On Time | Delivery timing | Late preparation, dispatch or transportation |
| In Full | Order completeness | Stockout, picking shortage or incorrect quantity |
| OTIF | Timing and completeness together | Failure of either requirement |
Looking at all three metrics together can help narrow the investigation.
- Low On Time / High In Full: inventory may be available, but preparation, dispatch or transportation is slow.
- High On Time / Low In Full: delivery speed may be acceptable, but inventory availability, picking or order accuracy is failing.
- Low On Time / Low In Full: the operation may have problems across several stages of fulfillment.
Define Your OTIF Rules Before You Calculate It
The idea behind OTIF is straightforward, but its operational definition can vary between companies, industries and customer agreements.
Before comparing periods, suppliers, locations or carriers, document the rules you will use consistently.
1. Choose the Unit of Analysis
This guide and the free Excel tracker use the order as the unit of analysis.
Each eligible order either passes or fails OTIF.
More complex B2B and distribution operations may instead measure performance by:
- order line;
- unit;
- case;
- shipment;
- delivery.
These approaches can be valid, but percentages calculated with different units should not be compared without explaining the measurement basis.
2. Define the Promised Delivery Date
The timing reference should reflect the commitment being evaluated.
Do not automatically substitute the ship date for the promised delivery date. An order may leave the warehouse quickly and still arrive after the date promised to the customer.
The basic Excel tracker uses this rule:
On Time = Yes when Complete Delivery Date ≤ Effective Promised Date
The effective promised date is the original promise unless a valid revised promise has been recorded according to your operating rules.
3. Decide Whether Early Deliveries Are Acceptable
The free InfoExperiencia tracker considers delivery on or before the effective promised date to be On Time.
However, some B2B, retail and distribution agreements use a delivery window. In those cases, an order may also fail because it arrives too early.
If your customer contract specifies an earliest and latest acceptable delivery time, use that contractual rule instead of the simplified method in this workbook.
4. Define the Reporting Period
The methodology used in this guide assigns an order to the reporting period based on the applicable promised date.
For example, when calculating September OTIF:
- an eligible order promised for September 15 belongs in the September measurement;
- an order created in August but promised for September can still belong in September;
- an open order promised for October does not belong in September yet;
- an order promised for September that remains overdue and undelivered stays visible as a September failure.
This prevents overdue orders from temporarily disappearing from the calculation simply because they have not been completed.
OTIF Calculation Example
Suppose 100 eligible orders became due during one week:
- 82 were complete and on time;
- 8 were complete but late;
- 5 arrived on time but incomplete;
- 5 were overdue and still open.
The OTIF calculation is:
OTIF = 82 ÷ 100 × 100 = 82%
The five overdue open orders remain in the denominator because their delivery promise has already been missed.
Removing them would increase the reported percentage without changing what customers actually experienced.
How to Measure On Time
On Time determines whether the complete order met the applicable delivery commitment.
For the basic methodology used by the Excel tracker:
On Time = Yes when Complete Delivery Date ≤ Effective Promised Date
Consider this example:
- Order date: September 1
- Promised delivery date: September 5
- Ship date: September 5
- Complete delivery date: September 7
The order was shipped on September 5, but the customer received the complete order after the promised date.
Result: On Time = No.
If orders regularly miss the promised date before they even leave the warehouse, measure where preparation time is being consumed. Our Time and Motion Study guide explains how to break work into activities, measure delays and identify unnecessary work.
How to Measure In Full
In Full determines whether the complete committed quantity was delivered within the required timing.
The free tracker uses a strict quantity rule:
In Full = Yes when Units Delivered On Time = Committed Units
Suppose an order contains 10 committed units:
- 8 units arrive before the promised date;
- 2 additional units arrive one day late.
The order eventually becomes complete, but it was not complete within the required time.
- In Full within the promise: No
- OTIF: No
OTIF measures whether the commitment was fulfilled as required, not whether the business eventually completed the order.
How to Handle Common OTIF Exceptions
Real fulfillment operations include cases that require more than a simple delivered/not-delivered rule. Define these situations before using OTIF for performance comparisons.
Overdue Open Orders
If the promised date has passed and the order remains open, the original commitment has already been missed.
Under the methodology used by this tracker, an eligible overdue open order remains visible as a failure instead of waiting indefinitely outside the calculation.
Partial Deliveries and Backorders
An order delivered in several shipments passes OTIF only if the complete committed quantity arrives within the applicable promise.
If part of the order becomes a backorder and arrives after the deadline, the order fails In Full and therefore fails OTIF.
Revised Promised Dates
A revised promise should not be used simply to make a late order appear compliant.
A valid reschedule should be documented according to the company’s rules and agreed before the original commitment is improperly overwritten.
The Excel tracker therefore keeps both the Original Promised Date and the Revised Promised Date.
Customer Cancellations
A legitimate customer cancellation made before a delivery failure may be excluded when that treatment is documented consistently.
A cancellation made after the delivery promise has already been missed should not erase the historical failure.
Company Cancellations
If the business cancels because inventory is unavailable or the order cannot be fulfilled, that event should not silently disappear from fulfillment analysis.
It represents an inability to meet the customer commitment and should remain visible in the operating data.
Returns
A later return does not automatically change the original OTIF result.
- If the correct complete order arrived on time and the customer later changed their mind, the original delivery may still have passed OTIF.
- If the customer received the wrong item or quantity, the order did not satisfy In Full.
- If the product arrived damaged, OTIF alone may not capture the quality failure. A broader perfect-order or damage-free-delivery measure may be needed.
Overdelivery and Substitution
Delivering more units than agreed does not automatically mean the order was fulfilled correctly.
The basic tracker requires exact equality between committed units and units delivered on time. If your contracts allow quantity tolerances or approved substitutions, those rules require a more advanced configuration.
Missing or Invalid Data
Do not silently remove orders that cannot be evaluated.
The audited Excel tracker marks incomplete, inconsistent or invalid records as Not Evaluable so they are not presented as valid OTIF results.
Why Data Coverage Matters Alongside OTIF
A high OTIF percentage is less useful when a large share of due orders cannot be evaluated because the underlying data is incomplete.
A supporting measure is:
Data Coverage (%) = Evaluable due orders ÷ Total orders due for evaluation × 100
Consider two operations:
| Operation | OTIF | Data Coverage |
|---|---|---|
| Business A | 94% | 99% |
| Business B | 96% | 55% |
Business B appears to have the higher OTIF, but almost half of the expected records cannot be evaluated reliably.
Before drawing a strong conclusion from the KPI, the business should first improve the quality and coverage of its fulfillment data.
How to Diagnose a Low OTIF
OTIF tells you that the customer commitment is failing. It does not automatically identify where the failure began.
| Performance Pattern | What to Investigate |
|---|---|
| On Time low / In Full high | Order release, preparation, capacity, dispatch or carrier delays |
| On Time high / In Full low | Inventory availability, picking accuracy or stock records |
| Both low | Broader fulfillment or supply-chain problems |
| OTIF highly variable | Demand peaks, capacity, suppliers, carriers or inconsistent processes |
Common causes include:
- inventory shortages;
- inaccurate inventory records;
- picking or packing errors;
- orders released too late;
- warehouse capacity constraints;
- late dispatch;
- carrier delays;
- supplier delays or shortages;
- incorrect delivery information;
- poor rescheduling discipline;
- missing or inconsistent data.
How to Improve OTIF
Improving OTIF usually requires working on the operating system behind the percentage rather than simply setting a higher target.
Improve the Customer Promise
Set delivery promises that reflect the actual operating conditions of the business, including:
- inventory availability;
- order-processing time;
- warehouse capacity;
- cutoff times;
- carrier transit times;
- delivery geography.
An aggressive delivery promise is not a stronger service level if the operation consistently fails to meet it.
Improve Inventory Availability and Accuracy
When In Full is the main problem, investigate stockouts, inventory-record differences, replenishment delays, picking shortages and units incorrectly shown as available for sale.
Control Orders Before They Become Late
Do not use OTIF only as a retrospective monthly score.
A practical operating routine should also identify:
- orders approaching their promised date;
- overdue open orders;
- incomplete orders;
- orders waiting for inventory;
- orders waiting for dispatch;
- recurring failure causes.
Separate Internal and External Causes
A carrier delay and a warehouse delay should not automatically be treated as the same problem.
Use a short and consistent list of failure causes so you can see whether problems are concentrated in inventory, preparation, transportation, customer information or another stage.
Review Supplier Performance When Relevant
If shortages or late replenishment are contributing to OTIF failures, review supplier performance instead of focusing only on warehouse execution. Our Supplier Evaluation guide explains how to compare delivery reliability, lead time, capacity, quality and other supplier risks.
Improve the Process, Not Just the Percentage
A KPI is useful when it leads to a decision. If recurring OTIF failures come from waiting, repeated work, poor flow or avoidable operational waste, use our Lean Manufacturing guide to investigate and improve the underlying process instead of treating the KPI itself as the problem.
What Is a Good OTIF Percentage?
There is no single OTIF percentage that is appropriate for every operation.
The appropriate target depends on factors such as:
- industry;
- contractual SLA;
- customer expectations;
- order complexity;
- distribution network;
- delivery window;
- geographic coverage;
- unit of analysis;
- contractual quantity tolerances.
A local business offering next-day delivery should not automatically be compared with a distributor managing large multi-line orders across a wide geographic network.
A more useful approach is to compare performance against your documented methodology, customer commitment, historical trend and relevant benchmarks that use comparable definitions.
Free OTIF Excel Tracker
The free InfoExperiencia workbook is designed for basic-to-intermediate order-level OTIF tracking.
It contains four sheets:
- Instructions: explains the methodology, editable fields, measurement rules, alerts and limitations.
- Glossary: defines the main OTIF terms and status values used throughout the workbook.
- OTIF Orders: records up to 300 orders and evaluates data validity, period eligibility, On Time, In Full and OTIF.
- Summary: reports On Time, In Full, OTIF, eligible orders, overdue open orders, data coverage and failure causes.
The tracker allows you to record information such as:
- Order ID;
- sales channel;
- original promised date;
- revised promised date;
- valid reschedule;
- order status;
- complete delivery date;
- committed units;
- units delivered on time;
- primary failure cause.
The workbook also checks whether each record contains enough consistent information to be evaluated. Invalid or incomplete records are marked as Not Evaluable instead of being presented as apparently valid OTIF results.
Template limitation: the workbook does not automatically model contractual delivery windows, business-day calendars, line-level OTIF, quantity tolerances, multiple partial-delivery events or advanced supplier/customer SLA rules. Use it as a practical learning and basic-control tool.
Frequently Asked Questions
What does OTIF mean?
OTIF means On Time In Full. It measures whether an order meets both the agreed delivery timing and the required quantity.
What is the OTIF formula?
For an order-level method, OTIF can be calculated as orders that satisfy both On Time and In Full requirements ÷ total eligible orders × 100. The eligibility and compliance rules should be documented before using the KPI.
Is OTIF the same as On-Time Delivery?
No. On-Time Delivery focuses on timing. OTIF requires the same order to satisfy both timing and completeness.
Can an early delivery fail OTIF?
Yes, when the customer or contract defines an acceptable delivery window with both an earliest and latest delivery time. The free InfoExperiencia tracker uses a simpler rule in which delivery on or before the effective promised date passes the On Time test.
Should overdue undelivered orders be included?
Under the methodology used in this guide, yes. Once an eligible order’s promised date falls inside the reporting period and the commitment has been missed, the overdue order remains visible in the calculation.
Should OTIF be measured by order or by order line?
Both approaches are used. This guide uses order-level OTIF because it is practical for smaller operations. More complex distribution environments may measure by line, case, unit, shipment or another unit. Always disclose the methodology when comparing results.
How often should OTIF be reviewed?
A small business can calculate OTIF weekly and consolidate monthly trends. During peak periods or improvement projects, at-risk and overdue orders may require more frequent operational review.
Methodology and References
This guide uses an order-level, promise-date-based OTIF methodology designed for practical small-business and ecommerce applications. OTIF definitions can vary across industries, contracts and supply chains, so the measurement basis should be documented before results are compared.
- ASCM: 8 KPIs for an Efficient Warehouse — warehouse and fulfillment performance measures, including OTIF.
- McKinsey & Company: Defining On-Time-In-Full in the Consumer Sector — differences in OTIF definitions, measurement units and delivery-date criteria.
- Mathematics: Research on distribution and logistics performance incorporating OTIF as a delivery-performance measure.
- Transportation Research: Supply-chain performance and resilience research incorporating On Time In Full among logistics performance measures.
- Performa: Media Ilmiah Teknik Industri: Research examining parts readiness and OTIF performance.
Explore more practical resources for improving fulfillment, inventory and operating processes in our Processes & Operations guides.
OTIF becomes useful when it leads to action. Measure the customer commitment consistently, separate timing failures from quantity failures, identify the underlying cause, and improve the process that produces the result.
Discover more from
Subscribe to get the latest posts sent to your email.
