OTIF Calculator

95 percent or higher is the standard target for top-tier suppliers in most retail categories. Below 90 percent typically signals a supplier relationship that needs active management. Below 85 percent, the cost of stockouts, expediting, and emergency replenishment becomes significant enough to warrant formal supplier escalation or dual-sourcing consideration.

Both views have value, but they answer different questions. Order-level OTIF is simpler to track and communicate. Line-level OTIF is stricter and usually a better leading indicator of underlying supplier process problems, since it catches partial short-ships that order-level measurement can mask. Track both if resources allow; if choosing one, line-level provides more diagnostic value.

Split every failure into "late but complete" versus "on-time but incomplete" versus "both late and incomplete." Each failure type points to a different root cause on the supplier's side (carrier/logistics issues versus warehouse/inventory issues versus systemic capacity problems), and a supplier scorecard conversation grounded in this breakdown is far more actionable than a single aggregate percentage.

Directly. A supplier's OTIF performance feeds the lead-time variability term in the safety stock formula; unreliable suppliers (low or volatile OTIF) require more safety stock to protect the same service level, which ties up more working capital. Improving supplier OTIF is one of the highest-leverage ways to reduce safety stock without accepting more stockout risk.

Trailing 90 days is a common standard for ongoing supplier scorecards, long enough to smooth single-incident noise but recent enough to reflect current performance. Trailing 12 months is more appropriate for annual sourcing and contract renewal decisions, since it captures seasonal patterns a 90-day window might miss.

Depends on the purpose. Simple order-count OTIF (as this calculator computes) is easiest to track and communicate broadly. Dollar-weighted OTIF gives more analytical weight to high-value orders, which is often more relevant for assessing actual business impact, since a failure on a $50,000 order matters more than a failure on a $500 order even though both count equally in a simple percentage.

This needs to be defined explicitly in the vendor agreement before measurement begins. Some retailers count an approved substitution as "in full" if quantity and category match; others count only exact-SKU fulfillment as in-full. Ambiguity here is a common source of disputes during supplier scorecard reviews, so the definition should be written into the contract, not inferred after the fact.

Two consecutive measurement periods below target (e.g., two consecutive months below 90 percent) is a common trigger for formal escalation. A single bad period is often noise; a sustained trend below target reflects a real operational problem worth addressing directly, potentially including dual-sourcing critical SKUs while the issue is resolved.