OTIF Compliance Fine Exposure Calculator
OTIF is the headline metric on most retailer and OEM supplier scorecards, and it is stricter than on-time or fill rate alone. This calculator multiplies the two rates, compares the result to your customer target and shows the fines at stake.
Your numbers
Share of orders delivered inside the customer delivery window.
Share of orders delivered with every line at the full ordered quantity.
Many retail and OEM compliance programs fine a percentage of the invoice value.
Your results
Fine programs differ by customer. Check the supplier agreement for the measurement window, grace periods and caps.
Annual fine exposure vs on-time rate
Sweeps On-time rate from 80 to 100, holding your other inputs fixed.
Automate OTIF reporting from your ERP
Optional review of how to calculate OTIF straight from order and shipment tables.
Optional. The tool and every export work without this. No spam.
How to use it
Enter monthly shipped orders, your on-time and in-full percentages and the customer target. Add the average invoice value and the fine percentage from the compliance manual. The primary results are your estimated OTIF score and annual fine exposure. Drag the on-time slider to see how much each point of improvement is worth, or read the chart for the whole range between 80 and 100 percent.
The formula behind it
OTIF is the share of orders that are both on time and in full. When the two failures are independent, OTIF equals on-time rate times in-full rate. Fines are then failed orders times invoice value times the fine percentage. Some programs fine only the orders that miss, others fine every order in a period that misses the target, so adjust the fine percentage to match your contract.
- 93 percent on time and 96 percent in full gives about 89.3 percent OTIF
- Failed orders are orders times one minus OTIF
- Fines usually apply per order or per case, not per line
Common mistakes
The most common error is reporting the average of the two rates instead of the product. Another is measuring on the ship date rather than the customer receipt date, which hides carrier delays. Count a delivery as in full only when every line meets the ordered quantity inside the allowed tolerance, and agree the delivery window definition with the customer before you trust the number. Pull the order lines from your ERP rather than a spreadsheet to avoid sampling bias.
Frequently Asked Questions
Is OTIF the same as fill rate?
No. Fill rate measures quantity shipped against quantity ordered, usually by line or unit. OTIF is order level and requires the delivery to be on time and complete, so it is always equal to or lower than the fill rate.
Why multiply the two rates?
If lateness and shortages are independent, the chance an order passes both tests is the product of the two chances. It is a conservative estimate when failures overlap.
What is a typical OTIF target?
Retail programs often set targets between 90 and 98 percent, while industrial OEMs vary widely. Always use the figure in your own supplier agreement.
Should I include partial shipments?
Yes if the customer measures the original promise date. A partial shipment that completes later counts as not in full on the first delivery and often as late for the balance.
If OTIF is hard to measure because on-time and in-full flags sit in different ERP tables, Netray can build a read-only view over your order and shipment data so the score updates daily.
Related Tools
Late Delivery Liquidated Damages Exposure Calculator
Work out what a liquidated damages clause actually pays when a supplier ships late, and how far it falls short of your real cost of delay.
ERP OperationsOrder Entry Error Cost Calculator
Calculates the monthly and annual cost of order entry errors and the savings from reducing the error rate.
ERP OperationsCSR Order Desk Staffing Calculator
Converts daily orders, lines and customer contacts into the number of customer service reps required after shrinkage and occupancy.
ERP OperationsCustomer Order Exception Aging Log Worksheet
An editable log of problem orders that totals days late, order value and estimated penalty exposure.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator