# Supplier Delivery Performance Calculator (OTD and OTIF)

> Source: https://netray.co/tools/supplier-delivery-performance-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate supplier on-time delivery (OTD), on-time in-full (OTIF), early and late percentages, and how many lines need to improve to hit your target.

## Category

supply-chain

## Audience

- Buyer
- Supplier quality
- Supply chain manager

## Tool

**Kind:** calculator

**Inputs:**

#### Order lines due in period

**Key:** lines_ordered

**Type:** number

**Default:** 200

**Min:** 0

**Step:** 1

**Unit:** lines

**Help:** Count the lines whose due date fell inside the period.

#### Lines received on time

**Key:** lines_on_time

**Type:** number

**Default:** 172

**Min:** 0

**Step:** 1

**Unit:** lines

**Help:** Received inside your accepted window, regardless of quantity.

#### Lines received early (outside window)

**Key:** lines_early

**Type:** number

**Default:** 8

**Min:** 0

**Step:** 1

**Unit:** lines

**Help:** Received earlier than your allowed early window.

#### Lines received late

**Key:** lines_late

**Type:** number

**Default:** 20

**Min:** 0

**Step:** 1

**Unit:** lines

**Help:** Received after the allowed window or still open past due.

#### Lines on time AND in full

**Key:** lines_otif

**Type:** number

**Default:** 158

**Min:** 0

**Step:** 1

**Unit:** lines

**Help:** Must be on time and within quantity tolerance. Cannot exceed lines on time.

#### Average days late on late lines

**Key:** avg_days_late

**Type:** number

**Default:** 6

**Min:** 0

**Step:** 0.5

**Unit:** days

#### Target OTD

**Key:** target

**Type:** slider

**Default:** 95

**Min:** 50

**Max:** 100

**Step:** 1

**Unit:** %

**Outputs:**

#### On-time delivery (OTD)

**Key:** otd

**Expr:** lines_on_time / lines_ordered * 100

**Format:** percent

**Primary:** true

**Description:** Lines received on time divided by lines due.

#### On-time in-full (OTIF)

**Key:** otif

**Expr:** min(lines_otif, lines_on_time) / lines_ordered * 100

**Format:** percent

**Primary:** true

**Description:** Stricter measure: on time and correct quantity.

#### Late rate

**Key:** late_pct

**Expr:** lines_late / lines_ordered * 100

**Format:** percent

#### Early rate

**Key:** early_pct

**Expr:** lines_early / lines_ordered * 100

**Format:** percent

#### Gap to target (points)

**Key:** gap

**Expr:** target - otd

**Format:** decimal

**Description:** Positive means below target.

#### Lines to recover to hit target

**Key:** fix_lines

**Expr:** ceil(max(0, target / 100 * lines_ordered - lines_on_time))

**Format:** integer

#### Average delay across all lines

**Key:** weighted_delay

**Expr:** lines_late * avg_days_late / lines_ordered

**Format:** decimal

**Description:** Days late spread over every line due.

**Chart:**

#### OTD vs lines received on time

**Type:** line

**X:** lines_on_time

**From:** 100

**To:** 200

**Steps:** 20

**Series:**

- otd

**Disclaimer:** Check that lines on time, early and late reconcile to lines due in your data. Definitions of the accepted window and in-full tolerance should match your supplier agreement.

## Content

**Intro:** On-time delivery is the number every buyer is asked for, and every company seems to calculate it differently. This calculator uses the line-level method, shows OTD alongside the stricter OTIF, and tells you how many lines need to be recovered to reach your target.

**Sections:**

#### How to use the calculator

**Body:** Pull a report of purchase order lines whose due date fell in the period, for example the month or quarter. Count lines received inside the window, early, late and those that were also complete. Enter them, set your target and read OTD, OTIF and the gap. The example shows 172 of 200 lines on time, which gives 86 percent OTD and an OTIF of 79 percent, against a 95 percent target.

#### The formulas

**Body:** OTD equals lines received on time divided by lines due, times 100. OTIF equals lines that were both on time and within quantity tolerance divided by lines due. Lines to recover equal target percent times lines due minus the lines already on time, rounded up. Weighting by value or quantity is possible, but line counts are the most common and the easiest to audit.

**Bullets:**

- Define the window, for example 3 days early to 0 days late
- Define in-full tolerance, for example plus or minus 5 percent
- Use due date or confirmed date, but state which one
- Count a partial delivery as not in full

#### Reading the result and common mistakes

**Body:** A supplier can have high OTD and low OTIF if it ships on time but short. Early deliveries are a problem too: they inflate inventory and may break your receiving rules, so track them separately. The biggest mistake is measuring against the supplier's confirmed date after it slipped, which hides the real lateness against the original need date. Also avoid mixing urgent expedited lines with normal lines without a note.

#### Where the data lives in your ERP

**Body:** Receipt dates and due dates come from purchase order schedule lines and goods receipts, for example the schedule line and goods receipt history in SAP, receipts in Oracle, and PO release and receiving in SyteLine, Epicor and Dynamics. Agree one standard report so buyers and suppliers see the same numbers, and feed it into your supplier scorecard.

**Cta:** If you want OTD and OTIF calculated automatically per supplier from your ERP receipts, Netray can build it on your data, with on-prem options.

**Faq:**

#### What is a good supplier on-time delivery rate?

**Answer:** Many manufacturers target 95 percent or higher, with critical suppliers closer to 98 percent. The right target depends on lead times, buffers and how costly a late line is, so set it with your suppliers and measure consistently.

#### What is the difference between OTD and OTIF?

**Answer:** OTD measures only timing. OTIF requires the delivery to be on time and complete, within the quantity tolerance. OTIF is always equal to or lower than OTD, and highlights suppliers that ship on time but short.

#### Should I measure by lines, orders or value?

**Answer:** Lines are most common and easy to verify. Order level is stricter because one late line fails the order. Value weighting emphasizes big items. Whichever you pick, keep it consistent and document it in your supplier agreement.

#### How do I treat early deliveries?

**Answer:** Define an accepted window, such as no more than a few days early. Deliveries outside it count as not on time or are tracked separately, because early shipments tie up cash and storage and can disrupt receiving.

## Search terms

supplier delivery performance calculator, supplier on time delivery calculator, OTIF calculator, on time in full calculator, vendor delivery performance formula, supplier OTD percentage, supplier delivery rating, how to calculate supplier on-time delivery

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json