How is supplier PPM calculated?

Divide quantity rejected by quantity received, then multiply by 1,000,000. If a supplier ships 25,000 parts and you reject 30, that is 30 divided by 25,000 times 1,000,000, or 1,200 PPM. Sum rejects and receipts across all lots in the period before dividing, so a large clean lot properly offsets a small bad one. Never average the per-lot PPM values directly, since that overweights small lots.

What supplier PPM target should I set in a scorecard?

Automotive and aerospace supply chains commonly require under 50 PPM, with critical safety parts pushed toward zero defects. General industrial suppliers often start at 5,000 to 10,000 PPM and improve toward 1,000. Set the threshold by part criticality: a fastener can tolerate more than a machined safety-critical component. Put the target in the scorecard so a supplier crossing it triggers an automatic corrective action request rather than a subjective judgment call.

Why use a rolling PPM average instead of per-lot PPM?

Per-lot PPM is volatile: a 500-part lot with 2 rejects reads 4,000 PPM, while the supplier's true annual rate might be 300. A rolling average, typically over 3 to 12 months of cumulative received and rejected quantities, smooths this noise and reflects real performance. Use per-lot PPM to flag an immediate containment issue, but use the rolling average for scorecard grades and supplier improvement decisions.

When should a supplier PPM result trigger a corrective action request?

Trigger a CAR when the rolling PPM exceeds your scorecard threshold, when a single lot shows a safety or fit-critical defect, or when the trend rises for three consecutive months. Attach the reason code and RMA number so the supplier receives the specific failure mode, lot, and quantity. A well-scoped 8D response should follow within 24 to 48 hours for containment and 30 days for permanent corrective action with verified effectiveness.

How do I handle a supplier that ships many small lots versus few large lots?

Always aggregate by summing total received and total rejected across all lots in the period, then compute one PPM. This weights each part equally regardless of lot size. A supplier sending 100 lots of 200 and one lot of 50,000 should not have the giant lot drowned out. If you average per-lot PPM instead, small lots dominate and a single 200-part reject can inflate the score tenfold unfairly.

What rejection reason codes should I track for Pareto analysis?

Use a short standardized list such as dimensional out of tolerance, surface or cosmetic, missing or wrong part, documentation or certification error, damage in transit, and functional failure. Keep it under about eight codes so data stays consistent across inspectors. Then Pareto the rejects: if dimensional accounts for 4,200 of 6,000 rejected parts, that one code is 70 percent of the problem and defines exactly what the corrective action request must address first.

Quality and Inspection

Supplier Quality PPM Spreadsheet Template

Track incoming quality by supplier, part number, and period using a PPM metric to support supplier scorecards and corrective action.

Overview

This template tracks incoming supplier quality by supplier, part number, and period using PPM for supplier quality engineers and purchasing teams. Guesswork fails here because one bad lot skews perception: a supplier who ships 49,900 good parts and rejects 100 is at 2,000 PPM, which sounds alarming until you see they shipped a million parts that year at 300 PPM. A spreadsheet with quantity received alongside rejects keeps every scorecard honest and every corrective action grounded in real volume.

You log each incoming inspection with supplier name, part number, quantity received, and quantity rejected. PPM computes per lot as rejects divided by received times 1,000,000, and a rolling average smooths lot-to-lot swings. A rejection reason code column feeds Pareto analysis, and the RMA log ties rejects to return authorizations. The monthly trend column shows whether a supplier is improving, and the summary table rolls everything into a scorecard-ready view you can drop into a review meeting.

In a real workflow, receiving inspection logs each lot as it arrives, PPM calculates on entry, and the rolling average updates automatically. When a supplier crosses your threshold, say 1,000 PPM, the reason code and RMA log give you the evidence for a corrective action request. Bring the summary table to the quarterly supplier review and track the trend to prove an improvement program is working. Pair it with the Supplier Quality PPM Calculator for a fast single-lot check at the receiving dock.

What this template includes

Supplier name and part number
Quantity received and quantity rejected
PPM calculation per lot and rolling average
Rejection reason code
Return material authorization log
Supplier PPM trend by month
Scorecard-ready summary table

Suggested use case

Use this to track incoming quality for a supplier scorecard, to prepare data for a corrective action request, or to manage a supplier improvement program.

How to use it

Log each incoming inspection result with supplier and part.
Enter quantity received and quantity rejected.
PPM calculates automatically.
Review the monthly trend to track supplier improvement.
Use the summary table in supplier review meetings.

Frequently Asked Questions

How is supplier PPM calculated?: Divide quantity rejected by quantity received, then multiply by 1,000,000. If a supplier ships 25,000 parts and you reject 30, that is 30 divided by 25,000 times 1,000,000, or 1,200 PPM. Sum rejects and receipts across all lots in the period before dividing, so a large clean lot properly offsets a small bad one. Never average the per-lot PPM values directly, since that overweights small lots.
What supplier PPM target should I set in a scorecard?: Automotive and aerospace supply chains commonly require under 50 PPM, with critical safety parts pushed toward zero defects. General industrial suppliers often start at 5,000 to 10,000 PPM and improve toward 1,000. Set the threshold by part criticality: a fastener can tolerate more than a machined safety-critical component. Put the target in the scorecard so a supplier crossing it triggers an automatic corrective action request rather than a subjective judgment call.
Why use a rolling PPM average instead of per-lot PPM?: Per-lot PPM is volatile: a 500-part lot with 2 rejects reads 4,000 PPM, while the supplier's true annual rate might be 300. A rolling average, typically over 3 to 12 months of cumulative received and rejected quantities, smooths this noise and reflects real performance. Use per-lot PPM to flag an immediate containment issue, but use the rolling average for scorecard grades and supplier improvement decisions.
When should a supplier PPM result trigger a corrective action request?: Trigger a CAR when the rolling PPM exceeds your scorecard threshold, when a single lot shows a safety or fit-critical defect, or when the trend rises for three consecutive months. Attach the reason code and RMA number so the supplier receives the specific failure mode, lot, and quantity. A well-scoped 8D response should follow within 24 to 48 hours for containment and 30 days for permanent corrective action with verified effectiveness.
How do I handle a supplier that ships many small lots versus few large lots?: Always aggregate by summing total received and total rejected across all lots in the period, then compute one PPM. This weights each part equally regardless of lot size. A supplier sending 100 lots of 200 and one lot of 50,000 should not have the giant lot drowned out. If you average per-lot PPM instead, small lots dominate and a single 200-part reject can inflate the score tenfold unfairly.
What rejection reason codes should I track for Pareto analysis?: Use a short standardized list such as dimensional out of tolerance, surface or cosmetic, missing or wrong part, documentation or certification error, damage in transit, and functional failure. Keep it under about eight codes so data stays consistent across inspectors. Then Pareto the rejects: if dimensional accounts for 4,200 of 6,000 rejected parts, that one code is 70 percent of the problem and defines exactly what the corrective action request must address first.