# Aerospace Supplier OTD and Quality Rating Calculator

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

## Short answer

Turns lots received, late lots and rejects into on-time delivery, lot acceptance, PPM and a single weighted supplier rating.

## Category

aerospace-defense

## Industry

Aerospace

## Audience

- Supplier quality
- Buyer
- Quality manager

## Tool

**Kind:** calculator

**Inputs:**

#### Lots received in period

**Key:** lots

**Type:** number

**Default:** 48

**Min:** 1

**Step:** 1

**Unit:** lots

#### Lots received late

**Key:** late_lots

**Type:** number

**Default:** 5

**Min:** 0

**Step:** 1

**Unit:** lots

**Help:** Measured against the confirmed due date on the purchase order.

#### Lots rejected or with an NCR

**Key:** rejected_lots

**Type:** number

**Default:** 3

**Min:** 0

**Step:** 1

**Unit:** lots

#### Pieces received

**Key:** pieces

**Type:** number

**Default:** 24000

**Min:** 1

**Step:** 100

**Unit:** pcs

#### Nonconforming pieces

**Key:** bad_pieces

**Type:** number

**Default:** 36

**Min:** 0

**Step:** 1

**Unit:** pcs

#### Weight on delivery

**Key:** delivery_weight

**Type:** slider

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

**Help:** The rest of the weight goes to quality.

**Outputs:**

#### On-time delivery

**Key:** otd

**Expr:** max(0, (lots - late_lots) / lots * 100)

**Format:** percent

#### Lot acceptance rate

**Key:** lot_acc

**Expr:** max(0, (lots - rejected_lots) / lots * 100)

**Format:** percent

#### Defective PPM

**Key:** ppm

**Expr:** bad_pieces / pieces * 1000000

**Format:** number

#### Weighted supplier rating

**Key:** rating

**Expr:** (delivery_weight * otd + (100 - delivery_weight) * lot_acc) / 100

**Format:** percent

**Primary:** true

**Description:** Weighted average of OTD and lot acceptance.

**Chart:**

#### Rating as late lots increase

**Type:** line

**X:** late_lots

**From:** 0

**To:** 24

**Steps:** 25

**Series:**

- rating
- otd

**Disclaimer:** Your approved supplier procedure sets the rating formula, thresholds and probation rules. This tool applies a simple weighted average.

## Content

**Intro:** AS9100 requires you to monitor external provider performance and feed it into supplier selection and re-evaluation. This calculator turns raw receipt data into the three numbers most aerospace scorecards use: on-time delivery, lot acceptance and PPM, plus one weighted rating.

**Sections:**

#### How to use it

**Body:** Enter lots received in the period, how many arrived late against the confirmed date and how many were rejected or raised an NCR. Add pieces received and nonconforming pieces for PPM. Set the delivery weight; 50% is a neutral start, and many primes weight quality higher. The chart sweeps late lots so you can see how fast the rating falls as delivery slips.

**Bullets:**

- Use confirmed due date, not original request date, if your procedure says so.
- Count each lot once, even when it has several defects.
- Review a rolling 12 months, not one quarter.

#### Reading the results

**Body:** OTD and lot acceptance are straightforward percentages. PPM shows scale: three rejected lots can hide 1,500 PPM or 50,000 PPM depending on lot size. A supplier at 90% OTD and 94% lot acceptance will rate about 92% at equal weights; most programs set a green band around 95% and above, a watch band, and a corrective action trigger.

#### ERP notes

**Body:** Receipt dates, promised dates and inspection results already exist in most ERPs: purchase order receipts, vendor performance reports and quality inspection lots. The usual problem is that the due date is overwritten when buyers reschedule, which flatters OTD. Keep the original and confirmed dates, and decide in the procedure which one drives the rating.

**Cta:** If your supplier ratings are built by hand in spreadsheets, we can help generate them straight from receipts and inspection data in your ERP.

**Faq:**

#### What is a good OTD for aerospace suppliers?

**Answer:** Many primes expect 95% or better on-time delivery and treat results below 85% to 90% as a corrective action trigger. Your customer flow-down and internal procedure define the exact bands.

#### Should I weight quality more than delivery?

**Answer:** Often yes. A late conforming part is recoverable, while an escaped nonconformance can ground an assembly or trigger a customer SCAR. Many scorecards use 60 to 70% for quality, but pick weights you can defend.

#### How is PPM calculated?

**Answer:** PPM is nonconforming pieces divided by pieces received, times one million. Always state the basis, such as received pieces or inspected pieces, so supplier and customer numbers can be compared.

#### Does AS9100 require a specific formula?

**Answer:** No. AS9100 requires you to define criteria and monitor provider performance. It does not prescribe a formula, so the weights and thresholds are yours to set, document and apply consistently.

## Search terms

supplier rating calculator, supplier on time delivery calculator, AS9100 supplier performance, supplier PPM calculator, supplier scorecard formula, approved supplier list rating, OTD and quality rating, supplier performance monitoring

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