Decision software for grocery chains

OTIF (on time in full)

OTIF (On Time In Full) is the share of supplier order lines delivered both within the requested date window and with the full quantity ordered.

Unit: %Tracking frequency: Weekly; quarterly on the supplier scorecardHigher is better

Also calledOTIF rate, on time in full delivery, OTIF oranı

Formula

Lines delivered both on time and in full ÷ Total order lines × 100
On time
Goods receipt date falls within the written tolerance window around the requested date.
In full
The full quantity ordered arrived in one delivery at acceptable quality.
Total order lines
All purchase order lines due in the period.

Calculator

Enter your own figures and the result updates instantly. The defaults are the figures from the worked example below.

Result%79,2

Worked example

How to read it, and what good looks like

OTIF is the intersection of two conditions and on its own does not say where the problem is. A low on-time rate points to lead time; a low in-full rate points to the supplier's capacity or stock. If the product of the components comes out well below OTIF, both problems are hitting the same orders, which usually points to a specific product group or period.

There is no fixed right OTIF figure; the target is written into the supplier contract together with the date base and tolerance window. OTIF against the requested date shows whether the plan was delivered; OTIF against the confirmed date shows whether the supplier kept its word, and the gap between them shows whether it gave realistic dates in the first place. The real signal is the quarterly trend: falling OTIF inflates safety stock and drives stockouts.

Calculate OTIF weekly and share it quarterly on the supplier scorecard. In Mindpera, Mind Stock records goods receipts; Mind Ops calculates KPIs with defined formulas, routes any supplier over threshold to the responsible user's task list and follows the item until it is closed. Where order lines and goods receipts sit in different systems, installation matches them at line level.

Where it misleads

  • OTIF is measured against the confirmed or revised date; since the date is updated at every delay, the rate always comes out high.
  • Goods receipts are keyed days after the physical delivery; on-time lines look late and the measurement turns into an argument.
  • A partial delivery completed later is counted as in full; the fact that the first delivery was short is lost.
  • The tolerance window is not written down; buyer and supplier calculate two different OTIF figures from the same data.

Data you need

  • Purchase order lines: requested date, confirmed date, quantity
  • Goods receipts: actual delivery date, quantity received, quality check result
  • Written tolerance window by supply type

Mindpera products that calculate this KPI

Frequently asked questions

What is the difference between OTIF and fill rate?
Fill rate measures how much of the demand was met and ignores timing. OTIF requires the full quantity to arrive on time. A line that arrives complete but late does not lower fill rate, but it does lower OTIF. OTIF is used for supplier performance; fill rate for the store or customer side.
Is OTIF measured by order or by line?
For supplier performance, measure by line; only then can you see which item caused the problem. Order-level OTIF is stricter: a single short or late line takes the whole order out of OTIF. Use the order-level measure in service commitments to customers, and state in the contract which one applies.

Track OTIF (on time in full) on your own data

Mindpera runs this calculation every day by product, branch and category; a value that crosses its threshold lands on its owner as a task.