Order Fill Rate Analyzer
Analyze warehouse fulfillment performance from order line data: compute unit fill rate, line fill rate, order fill rate, and backorder recovery with explicit gross vs. net denominators.
Open toolOn-Time In-Full (OTIF / DIFOT) Calculator & Root-Cause Analyzer
Audit supply-chain delivery compliance from actual order rows: compute exact On-Time (`OT%`), In-Full (`IF%`), combined `OTIF%` (`DIFOT`), unit-level fill rate, SLA gap, and a root-cause breakdown (`Late Only`, `Short Only`, `Both Late & Short`).
Free to useNo sign-upRuns in your browser
Enter your details
Enter the inputs, then select Calculate OTIF & Failure Breakdown.
Your result
Enter your details
Result will appear here
How the On-Time In-Full (OTIF) Calculator Audits Shipments
Each order row is evaluated against two binary gates: the schedule gate (did it arrive within the allowed date window?) and the quantity gate (were 100% of ordered units delivered?).
OTIF% = (Count of orders where OnTime == true AND InFull == true) / Total_Orders * 100; SLA Gap = OTIF% - Target_SLA%.
To analyze line-level warehouse wave fulfillment and backorder recovery, pair this tool with our Order Fill Rate Analyzer (/tools/order-fill-rate-analyzer).
OTIF (DIFOT) Supply Chain Metrics & Default 5-Order Audit Table
Standard supply-chain definitions and exact outputs for the default 5-order shipment log (`1,000` ordered units).
| Supply Chain KPI | Exact Formula | Default 5-Order Log Output | Operational Meaning |
|---|---|---|---|
| On-Time Delivery (`OT%`) | `(# Orders with Actual <= Promised + Grace) / N` | `80.00%` (`4 / 5` orders on time) | `ORD-103` arrived 2 days late (`Oct 10` vs `Oct 08`) |
| In-Full Delivery (`IF%`) | `(# Orders with Delivered >= Ordered) / N` | `80.00%` (`4 / 5` orders complete) | `ORD-104` shipped short (`180 / 200` units) |
| True Combined `OTIF%` (`DIFOT`) | `(# Orders BOTH On-Time AND In-Full) / N` | `60.00%` (`3 / 5` orders OTIF) | Only `ORD-101`, `ORD-102`, `ORD-105` met both gates |
| Unit-Level Fill Rate | `sum(min(Delivered, Ordered)) / sum(Ordered)` | `98.00%` (`980 / 1,000` units) | Total physical units fulfilled across all orders |
How to Audit OTIF Performance in 3 Steps
Paste your ERP or WMS shipment export to pinpoint why OTIF misses SLA targets.
Paste order rows with promised date, actual date, and quantities
Enter one order per line as 'order_id, promised_date, actual_date, ordered_qty, delivered_qty' using YYYY-MM-DD dates.
Set your grace-day tolerance, early-arrival rule, and target SLA %
Choose whether early arrivals count as On-Time (standard B2B) or must land on the exact promised date (strict big-box MABD), and enter your SLA threshold.
Review OT%, IF%, OTIF%, and the order-by-order root-cause log
Inspect the failure breakdown separating carrier/dispatch delays (Late Only) from inventory shortages (Short Only) and export the audit report.
Worked OTIF & Retail Compliance Examples
See how disjoint failures and early-arrival rules impact OTIF scores.
Baseline example
Free On-Time In-Full (OTIF / DIFOT) supply chain calculator. Audit order-level and unit-level OT%, IF%, OTIF%, SLA compliance, and failure root causes in your browser.
Comparison scenario
OTIF% = (Count of orders where OnTime == true AND InFull == true) / Total_Orders * 100; SLA Gap = OTIF% - Target_SLA%.
Boundary check before exporting
To analyze line-level warehouse wave fulfillment and backorder recovery, pair this tool with our Order Fill Rate Analyzer (/tools/order-fill-rate-analyzer).
How to Interpret OT%, IF%, and the Failure Matrix
Compare Order-Level OTIF% against Unit-Level Fill Rate to diagnose systemic vs. isolated misses.
When Unit-Level Fill Rate is high (e.g., 98.0%) but Order-Level In-Full % is low (e.g., 75.0%), small 1-to-2 unit stockouts on fast-moving SKUs are spoiling otherwise complete shipments.
When On-Time % lags In-Full %, warehouse inventory is healthy but order cutoff times, pick-pack cycle time (/tools/cycle-time-analyzer), or carrier transit lead times need adjustment.
Data Formatting Rules & Related Supply-Chain Tools
Keep these measurement standards consistent across monthly scorecards.
1. Promised Date Anchor: Always benchmark OTIF against the original customer-confirmed delivery date rather than a rescheduled carrier ETA.
2. Over-Shipments: If delivered_qty exceeds ordered_qty, unit fill is capped at 100% of ordered demand so over-shipping one order cannot mask a shortage on another.
Cycle Time Analyzer (Bottleneck, Takt Time & Little's Law WIP)
Calculate bottleneck cycle time, Takt time margin, hourly and shift throughput, line balance efficiency, flow efficiency, and Little's Law WIP from workstation times.
Open tool
Changeover Time Analyzer (SMED Calculator)
Analyze manufacturing changeover and setup times using SMED (Single-Minute Exchange of Die). Break down internal vs. external steps, parallel savings, and downtime reduction %.
Open toolMore free tools to try
Choose another tool for your next calculation, conversion, or text task.
Capacity Planning Calculator
Calculate team productive capacity, utilization percentage, and FTE surplus or deficit from headcount, workdays, PTO, and focus factor.
Open tool
Commission Calculator
Calculate flat or 2-tier accelerated sales commission, effective commission rate, total base + variable payout, and net revenue.
Open tool
Dynamic Time Warping (DTW) Calculator
Calculate Dynamic Time Warping (DTW) distance and optimal alignment path between two time series in your browser. Supports absolute, squared, and root-squared costs plus Sakoe-Chiba window band.
Open tool
Integrated Rate Law Calculator
Determine reaction order (0th, 1st, or 2nd) from time-concentration data by linearizing [A], ln[A], and 1/[A] vs. time t, comparing R² and RMSE, and calculating rate constant k and half-life.
Open toolFrequently Asked Questions About On-Time In-Full (OTIF)
Answers about using On-Time In-Full (OTIF / DIFOT) Calculator & Root-Cause Analyzer and understanding its results.
Why is true OTIF not always equal to On-Time % multiplied by In-Full %?
Multiplying aggregate On-Time % by In-Full % assumes timing failures and quantity shortages occur independently across orders. True OTIF counts the exact intersection: the percentage of orders where the same order arrived both on time AND with 100% of ordered units.
What is the difference between Order Fill Rate and OTIF (DIFOT)?
Order Fill Rate (/tools/order-fill-rate-analyzer) measures warehouse inventory availability (whether ordered units ship on the first wave without backorders). OTIF (Delivery In Full, On Time) adds carrier transit performance by checking whether the shipment actually arrived at the customer's dock by the promised date.
Why do big-box retailers reject early deliveries in strict MABD windows?
Retail distribution centers schedule dock doors and cross-dock labor around a Must-Arrive-By-Date (MABD). Arriving days early consumes staging floor space, so strict retail OTIF policies only count deliveries arriving on the exact MABD window.
How do I reduce OTIF chargebacks quickly?
Separate your missed orders into the three failure buckets reported by this calculator: Late-Only (carrier transit or dispatch delay), Short-Only (safety stock or picking stockout), and Both Late & Short.
Try your own values
Choose another tool for your next calculation, conversion, or text task.