# Aerospace Supplier On-Time Delivery and Quality Rating Calculator

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

## Short answer

Compute on-time delivery, lot acceptance rate, defective PPM and a weighted supplier rating from your receiving data.

## Category

quality

## Industry

Aerospace

## Audience

- Supplier quality
- Purchasing
- Quality manager

## Tool

**Kind:** calculator

**Inputs:**

#### Lots received

**Key:** lots

**Type:** number

**Default:** 60

**Min:** 0

**Step:** 1

**Unit:** lots

#### Lots received on time

**Key:** on_time

**Type:** number

**Default:** 54

**Min:** 0

**Step:** 1

**Unit:** lots

**Help:** Received on or before the promise date within your allowed window

#### Lots accepted

**Key:** accepted

**Type:** number

**Default:** 57

**Min:** 0

**Step:** 1

**Unit:** lots

#### Units received

**Key:** units

**Type:** number

**Default:** 24000

**Min:** 0

**Step:** 100

**Unit:** units

#### Defective units found

**Key:** defects

**Type:** number

**Default:** 36

**Min:** 0

**Step:** 1

**Unit:** units

#### Weight on delivery

**Key:** w_otd

**Type:** slider

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

**Help:** Quality weight is the remainder

#### Open SCARs

**Key:** scars

**Type:** number

**Default:** 1

**Min:** 0

**Step:** 1

**Unit:** SCARs

**Outputs:**

#### On-time delivery

**Key:** otd

**Expr:** if(gt(lots,0), on_time / lots * 100, 0)

**Format:** percent

#### Lot acceptance rate

**Key:** lot_acc

**Expr:** if(gt(lots,0), accepted / lots * 100, 0)

**Format:** percent

#### Defective PPM

**Key:** ppm

**Expr:** if(gt(units,0), defects / units * 1000000, 0)

**Format:** integer

**Description:** Defective parts per million received

#### SCAR penalty points

**Key:** penalty

**Expr:** min(scars * 5, 20)

**Format:** integer

**Description:** Five points per open SCAR, capped at 20

#### Composite rating

**Key:** composite

**Expr:** max(0, (w_otd / 100) * otd + (1 - w_otd / 100) * lot_acc - penalty)

**Format:** percent

**Primary:** true

**Description:** Weighted delivery and acceptance score less SCAR penalty

**Chart:**

#### Composite rating vs delivery weight

**Type:** line

**X:** w_otd

**From:** 0

**To:** 100

**Steps:** 21

**Series:**

- composite

**Disclaimer:** Weights and penalties are an example model. Set your own targets and rating bands in your supplier management procedure.

## Content

**Intro:** AS9100 expects you to evaluate external providers on their ability to supply conforming product on time. This calculator turns raw receiving counts into on-time delivery, lot acceptance, PPM and a single weighted rating.

**Sections:**

#### How to use the calculator

**Body:** Pull a rolling period, usually twelve months, from your receiving and purchasing data. Enter lots received, how many were on time, how many were accepted, the units received and the defective units found. Adjust the weight between delivery and quality to match your priorities and enter any open SCARs. The composite rating shows the result as a percent.

**Bullets:**

- Use the same period for all suppliers
- Count lots, not purchase order lines, consistently
- Set an on-time window and keep it fixed
- Review the chart to see sensitivity to weighting

#### The formulas

**Body:** On-time delivery is lots on time divided by lots received. Lot acceptance is lots accepted divided by lots received. PPM is defective units divided by units received times one million. The composite is the weighted average of delivery and acceptance, less five points for each open SCAR up to a cap. If you receive nothing, the result returns zero rather than an error.

#### Reading the result

**Body:** Compare the composite to bands in your procedure, for example preferred, conditional and probation. The example inputs give about 90 percent on time and 95 percent accepted, with a small SCAR penalty. PPM is useful when lots are large, because acceptance by lot can hide a low defect rate within accepted lots.

#### Common mistakes

**Body:** Mixing definitions across suppliers makes comparison meaningless. Counting a late receipt that the buyer agreed to move as late hurts good suppliers, while ignoring early deliveries can hide inventory problems. Combine the rating with qualitative inputs such as responsiveness and audit results before changing a supplier's status.

**Cta:** If your receiving data is in the ERP, Netray can help calculate supplier ratings automatically each month and write them back to the vendor record.

**Faq:**

#### What is a good on-time delivery target?

**Answer:** Many aerospace customers expect 95 percent or better, but the right target depends on your contract and the part. Use your customer flow-downs and internal objectives.

#### How is PPM calculated?

**Answer:** Divide defective units by units received and multiply by one million. For example, 36 defective units out of 24,000 gives 1,500 PPM.

#### Should early deliveries count as on time?

**Answer:** Define it in your procedure. Many companies allow a small early window and treat anything outside it as a miss, since early receipts tie up space and cash.

#### Can I change the weights?

**Answer:** Yes. The slider sets the delivery weight and quality takes the remainder. Pick weights that match your risk, then keep them stable so trends are comparable.

## Search terms

supplier on time delivery calculator, supplier quality rating formula, supplier PPM calculator, AS9100 supplier performance, OTD OQD calculator, weighted supplier scorecard

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