On-Time In-Full (OTIF) Delivery Analytics for Distribution Leaders

By James Smith on October 23, 2026

otif-delivery-analytics-distribution-leaders

Most distributors can tell you what share of deliveries arrived on time. Fewer can say what share arrived on time and complete at the same moment, which is what large customers now measure. One late truck or one short pallet can fail a whole order. OTIF analytics shows where those failures start and which fixes recover the most. Teams building this view can ask iFactory AI how delivery promise data is connected.

Analytics Guide

On-Time In-Full (OTIF) Delivery Analytics for Distribution Leaders

Define OTIF once, compare promised with actual on every order, then trace each miss to its cause. iFactory AI brings promise, shipment and delivery data into one scorecard.

98%
OTIF target Walmart raised from 70% in its 2020 supplier policy, as reported by Logistics Viewpoints
3%
of the cost of goods that suppliers missing that target could be fined, under the same reported policy
100%
of what was ordered must arrive for the delivery to count as in full, and early arrivals do not count as on time

OTIF Definition: Two Tests, One Result

An order passes OTIF only when it passes both tests together. It must arrive inside the agreed window, and it must arrive with every ordered item in the ordered quantity. Fail either test and the whole order fails.


In full
Not in full
On time
OTIF passCounts as a perfect delivery
On time, shortFails the in-full test
Not on time
Complete, late or earlyFails the on-time test
Late and shortFails both tests
Test 1

On time

Arrival falls inside the promised date and time window. Under strict rules, arriving early also fails.

Test 2

In full

Every ordered line arrives in the ordered quantity, with no shortfall and no unrequested excess.

Result

OTIF rate

Orders passing both tests divided by orders measured. Always state the unit, whether order, line or case.

Three choices decide the number. Agree the window width, the quantity tolerance and the counting unit with each customer in writing. Two teams using different choices will report different OTIF rates for the same week.

A shared definition prevents arguments about the number. Walk through an OTIF definition on sample orders in a short session.

Promised Versus Actual: Compare Every Order

OTIF is only as good as the promise it is measured against. Store the promised date, window and quantity at order time, then compare them with the delivered time and quantity once the order is closed.

OrderPromised WindowArrivedOrderedDeliveredResult
A10108:00 to 10:0009:12120120OTIF pass
A10210:00 to 12:0012:408080Late
A10308:00 to 10:0009:306054Short
A10413:00 to 15:0012:10200200Early, fails on time
A10513:00 to 15:0015:354540Late and short

Five sample orders give one pass, which is a 20% OTIF rate, even though three of the five were on time or in full. This is why OTIF reads lower than either test alone.

1,000 orders measured in the sample month
1,000
On time: 920 orders, 92.0%
920
In full: 940 orders, 94.0%
940
On time and in full: 868 orders, 86.8%
868
A network can look strong on both tests and still miss a customer target. All month figures here are illustrative. Ask support how promised and actual data are matched for each order.

See Where Your Orders Fail Today

Book a 30-minute session and iFactory AI will show how promise, shipment and delivery records combine into an OTIF scorecard on realistic data.

Customer View: One Average Hides the Problem Accounts

The same 1,000 orders look very different by customer. The bars below show OTIF by account for the sample month. The weighted result is the same 86.8%, yet two accounts sit far below the rest.

Customer A, 300 orders

95%
Customer B, 250 orders

88%
Customer C, 200 orders

82%
Customer D, 150 orders

80%
Customer E, 100 orders

79%

Compare with the target

Each customer may have its own target and penalty. Show the gap to target, not only the rate.

Check window strictness

A customer with a narrow window will always score lower than one with a day-long window on the same operation.

Weigh by value

Rank accounts by revenue and penalty risk as well as by order count, so effort follows money.

Lowest score is not always highest priority. Explore a customer OTIF scorecard on sample data with the iFactory AI team.

SKU View: Find the Lines That Come Up Short

Short deliveries cluster in a few product groups. Rolling line-level fill rate up by product family shows where stock, picking or packaging is the issue.

Product GroupLine Fill RateTypical Shortfall CauseFirst Check
Ambient staples98.1%Occasional count errorsCycle count accuracy
Chilled lines94.3%Shelf-life rejects at pickStock age at allocation
Promotional items89.6%Demand above forecastPromotion forecast and buffer
Bulky and heavy92.8%Vehicle space limitsLoad planning rules
New listings86.2%Supplier lead time slipsInbound receipts and safety stock
Order fill

Whole orders complete

The strict view. One missing line fails the order. This is what OTIF penalties usually use.

Line fill

Lines delivered in full

A diagnostic view. It shows which products fail, even when most of the order arrived.

Use order fill to report and line fill to diagnose. Ask support how product-level shortfalls are tracked in the dashboard.

Root Causes: Trace Each Miss to Its Source

In the sample month, 132 of 1,000 orders failed. Of these, 72 were only late, 52 were only short and 8 were both. Giving every failure one primary cause turns that pile into a ranked list.

Stock-out at pick time: 34 orders
34
Route or driver delay: 27 orders
27
Late loading at the dock: 22 orders
22
Picking or packing error: 18 orders
18
Customer site closed or window changed: 14 orders
14
Vehicle breakdown: 9 orders
9
Order or slot data error: 8 orders
8

Supply-side causes

Stock-outs, picking errors and supplier delays: 52 orders in the sample, driving most in-full failures.

Transport-side causes

Loading, routes and vehicles: 58 orders, driving most on-time failures.

Outside causes

Customer closures, window changes and data errors: 22 orders. Many can be reduced with better confirmation.

One primary cause per failure keeps the ranking honest. See root-cause ranking on a live OTIF board in a working session.

Improvement Actions: Rank by Orders Recovered

Each order recovered adds 0.1 points to a 1,000-order OTIF rate. Convert every action into orders recovered and the cheapest wins are easy to spot.

ActionCause AddressedOrders RecoveredOTIF GainEffort
Halve stock-outs with safety-stock rulesStock-out at pick171.7 pointsMedium
Stagger loading slots by routeLate loading111.1 pointsLow
Re-sequence routes with tight windows firstRoute or driver delay101.0 pointMedium
Pick verification by scanPicking error90.9 pointsMedium
Confirm delivery windows the day beforeCustomer site closed70.7 pointsLow
Clean slot and order data at entryData error60.6 pointsLow

Together these recover about 60 orders, lifting the sample month from 86.8% to roughly 92.8%. The gains overlap a little, so measure again after each change rather than adding the figures blindly.

Start with the low-effort actions and measure the gain. Ask support how action results are tracked against the OTIF rate.

A Weekly OTIF Review That Drives Action

A scorecard changes nothing unless someone acts on it. Keep the weekly review short and tied to named owners.

Step 1
Show the OTIF rate, the two tests and the gap to target for each major customer.
Step 2
Open the three largest causes and the orders behind them, with dates and routes.
Step 3
Agree one or two actions, each with an owner, a date and an expected gain in orders.
Step 4
Check last week's actions. Keep what worked, retire what did not, and record the result.
Keep the review to thirty minutes with the numbers on one screen. See a weekly OTIF review pack on sample data during a demo.

Measurement Pitfalls That Distort OTIF

Most disputes about OTIF are really disputes about measurement. Fix these early and the number is trusted.

1
MistakeUsing ship date as delivery date
FixMeasure against the actual arrival time at the customer.
2
MistakeChanging the promise afterwards
FixLock the original promise and log any agreed change separately.
3
MistakeMixing order, line and case counts
FixPick one unit per customer and say so on every report.
4
MistakeIgnoring customer-caused misses
FixTag them with a reason and show them beside controllable causes.
5
MistakeCounting early as on time
FixFollow each customer's written rule on early arrivals.
6
MistakeWaiting for monthly data
FixReport daily so misses are fixed while the cause is fresh.
Most of these are fixed with clear rules, not new tools. Review your OTIF rules against a sample scorecard with the iFactory AI team.

Data You Need for an OTIF Scorecard

Three sets of records are enough to start. Gaps in any one of them show up quickly as orders that cannot be scored.

Promise data
Order number, customer, promised date and window, ordered lines and quantities.
Shipment data
Picked quantities, loading time, vehicle, route and planned stop sequence.
Delivery data
Arrival time, delivered quantities, refusals and proof of delivery.
Reason codes
A short fixed list for every miss, with one primary cause chosen.

Start with one customer and one depot. Scoring even a few hundred orders usually exposes missing timestamps and unclear reason codes, which are far cheaper to fix before a full roll-out.

Data quality is the quiet driver of a trusted number. Ask support which delivery records can be connected in your set-up.

What iFactory AI Adds to OTIF Reporting

iFactory AI is smart manufacturing and industrial software that brings operational records into one KPI view for operations teams.

Promise-to-delivery match
Every order is compared with its original promise automatically.
Drill-down
Open any rate down to the customer, product, route or order behind it.
Cause ranking
Reason codes roll into a ranked list of misses by orders affected.
Action tracking
Each improvement carries an owner, a date and the gain it delivered.
The data sources that connect depend on your set-up, so scope them early. Tour the OTIF dashboards on sample operations data with our team.

What a Miss Costs: Put Money Beside the Rate

Under the policy reported by Logistics Viewpoints, a supplier below target could be fined 3% of the cost of goods. Even where no fine exists, a failed order carries real cost. Adding it up shows what a point of OTIF is worth.

Cost of one failed order, illustrative
Average order cost of goods2,000
Penalty at 3% of cost of goods60
Redelivery of the missing or late part45
Customer service and admin time15
Cost per failed order120

At 120 per failed order, the 132 failures in the sample month cost 15,840. Each point of OTIF is 10 orders and therefore about 1,200. That figure turns an abstract percentage into a number finance understands.

Direct cost

Penalties, redelivery and extra handling. These appear in invoices and are easiest to count.

Indirect cost

Staff time, expedited freight and returns. They are spread across departments, so add them deliberately.

Relationship cost

Lower shelf space, smaller orders or lost listings. Hard to price, but often the largest effect over a year.

All amounts above are illustrative and should be replaced with your contract terms. Price your own OTIF misses on a sample dashboard with the iFactory AI team.

Setting Targets That Teams Can Act On

A single network target hides the work. Set targets by customer tier, then break each one into the two tests so teams see what they control.

Customer TierExample OTIF TargetWindow StyleReview Rhythm
Strategic accountsContract level, often 95% or higherNarrow, strict on earlyDaily and weekly
Core accountsClose to the network average plus a stepHalf-day windowsWeekly
Standard accountsSet from the last twelve weeksDay windowsMonthly
Stretch target

Set from capability

Use the best sustained four-week period as the stretch. It shows what the operation can already do.

Floor target

Set from the contract

Use the customer's written threshold. Any account below it needs a named recovery plan.

Targets work best when teams see progress every week. Ask support how tiered targets are shown on the scorecard.

Peaks, Promotions and New Listings

OTIF rarely falls evenly through the year. The weakest weeks usually follow a predictable pattern, so the scorecard should flag them in advance.

Promotion weeks
Demand above forecast causes stock-outs and shortfalls. Check promotional line fill before the event begins.
Seasonal peaks
Volume stretches routes and docks. Late departures and missed windows grow when capacity runs out.
New listings
Supplier lead times and first-order volumes are uncertain. Hold extra stock and watch line fill closely.
Weather and events
Closures and road delays push deliveries out of window. Tag these days so they do not hide trends.

Compare each of these periods with a normal week of the same size. If OTIF dips only in promotions, the fix lies in forecasting and stock. If it dips in every busy week, the fix lies in dock and route capacity.

A pattern seen twice is a plan waiting to be written. See peak-week OTIF patterns on sample data in a short working session.

Inbound OTIF: Your Suppliers Shape Your Score

Many in-full failures begin before the warehouse. When a supplier delivers late or short, the stock you promised to your customer is not there. Measuring inbound OTIF on the same rules links the two sides.

1
Supplier ships
Late or short inbound loads reduce available stock.
then
2
Warehouse receives
Stock reaches the shelf later than planned or in smaller amounts.
then
3
Order is picked
The pick falls short because the stock is missing.
then
4
Customer sees a miss
The delivery fails in full, and your score pays for it.

Score suppliers

Give each supplier an inbound OTIF rate and share it in regular reviews.

Link to stock-outs

Trace each stock-out back to its inbound delay. This shows how much is truly a supplier issue.

Adjust safety stock

Use supplier reliability to set buffers. Reliable suppliers need less, unreliable ones need more.

Inbound and outbound OTIF belong in the same review. Explore inbound and outbound OTIF together on a live board with our team.

Pallet and Pack Quality: The Quiet In-Full Risk

An order can leave complete and still arrive short. Damaged, crushed or mis-labelled cases may be refused at the dock, and the customer counts them as missing.

Damage on arrival
Record refused cases with a reason and photo, then trace them to the load or route.
Label and count errors
Wrong labels cause rejects. Check pallet labels against the order before loading.
Load stability
Poorly built pallets shift in transit. Review pallet patterns for the products that fail most.
Packaging fit
Weak outer packs damage easily. Share refusal data with packaging teams for redesign.
Packaging and quality teams can lift OTIF too. Ask support how refusals and damage are recorded against orders.

A 30-Day Plan to Launch OTIF Analytics

A month is enough to agree the rules and publish a first scorecard for one customer.

Week 1
Agree the definition, window, tolerance and counting unit with one customer, in writing.
Week 2
Gather promise, shipment and delivery records for the last three months and list data gaps.
Week 3
Score every order, tag each miss with a primary cause and rank the causes.
Week 4
Publish the scorecard, choose two actions with owners and start the weekly review.
Starting with one account keeps the work manageable. Book a call to scope your OTIF scorecard with iFactory AI.

Five Quick Questions Before You Report OTIF

Ask these before sharing any OTIF number with a customer or a board. Each one catches a common error.

Is the promise stored at order time?
If promises are rewritten later, every miss can be explained away and the rate becomes meaningless.
Does arrival time come from the customer site?
Depot departure times flatter the rate. Use the proof of delivery or driver arrival record.
Are partial deliveries handled by rule?
Decide whether a second shipment completes the order or still counts as a miss, and apply it to all accounts.
Does every miss have one cause?
Unassigned misses cannot be ranked. Aim for under five percent with no reason code.
Does the number match the customer's own?
Reconcile with their report each month. Differences usually point to window or counting rules.

Plain-Language Glossary

Shared words keep review meetings short. Agree these once and use them everywhere.

OTIF
The share of orders delivered both on time and in full.
Delivery window
The agreed range of time in which the delivery must arrive.
Order fill rate
The share of orders delivered with every line complete.
Line fill rate
The share of order lines delivered in full.
Primary cause
The single main reason an order failed, chosen from a fixed list.
Gap to target
The points between the actual OTIF rate and the customer target.

Frequently Asked Questions

What is a good OTIF rate?

It depends on the customer. Some large retailers have set targets as high as 98%, while many networks run well below that. Start from your contract targets and your own history.

How is OTIF different from on-time delivery?

On-time delivery checks only timing. OTIF also requires every item in the right quantity, so it is always equal to or lower than either test on its own.

Should we measure by order, line or case?

Follow each customer's contract. Ask support how counting units are set per account. Use line or case views for diagnosis even when orders are the reporting unit.

Which delivery windows count as on time?

Only the written window agreed with the customer. Some customers treat early arrival as a miss, so record each account's rule and apply it consistently.

Where should we start?

Pick one customer and one depot, score a month of orders, and rank the causes of the misses. Fix the biggest cause first, then measure again.

Turn Late and Short Orders Into a Plan

iFactory AI compares promised with actual on every order, ranks the causes of each miss and tracks the fixes that work. Book a walkthrough on your own delivery data.


Share This Story, Choose Your Platform!