Excel template
Supplier Quality Bundle
Supplier Scorecard + Supplier Selection & Capability: choose suppliers with facts, then rate them monthly A / B / C
Two Excel templates for the whole supplier lifecycle: a monthly supplier scorecard with PPM, on-time delivery, complaints and 8D speed, A / B / C classes, ranking and dashboard, and a supplier selection matrix with weighted criteria, capacity and Run@Rate, Cpk of key characteristics, supply risk and a sourcing decision. Example and blank files, no macros.
- Supplier Scorecard: 6 KPIs (PPM, OTD, complaints, D3, D8, quality cost) with limits, weights and A / B / C classes
- One printable page per supplier, ranking and dashboard for any period
- 3,000-row receipts log and 2,000-row SCAR / 8D complaint log for 100 suppliers
- Supplier Selection: up to 8 candidates, 16 weighted criteria, knock-outs and a recommendation
- Capacity and Run@Rate, Cpk of up to 20 key characteristics and a weighted supply risk
- Example and blank file for both templates
Secure checkout by Polar. Digital download: at checkout you agree to immediate delivery and waive the 14-day withdrawal right, so downloads are not refunded. Support: info@qmbench.com.
Free alternativeTry the free online tool firstThe free Supplier Scorecard on QM Bench runs in your browser with a PDF report. The template is for a file you keep, edit and fill with your own data.Open the free toolWhat is inside
- 1
Scorecard: Dashboard
Class counts, overall PPM, on-time delivery, complaints, open 8Ds, average D3 / D8 days and 4 charts.
- 2
Scorecard: Scorecard
One page per supplier: class, score, 6 KPIs vs limits, 12 months, PPM and OTD charts.
- 3
Scorecard: Ranking
All suppliers ranked by score for the chosen period.
- 4
Scorecard: Setup and logs
KPI limits, weights and classes, 100 suppliers, 3,000 receipt rows and a 2,000-row SCAR / 8D log.
- 5
Selection: Decision
Side-by-side comparison, knock-outs, Approve / with conditions / Reject / Incomplete and sign-off.
- 6
Selection: Project and Scoring
Part, volume, required Cpk, SOP, quotes, certificates, 3-year cost and 16 weighted criteria.
- 7
Selection: Capacity
Free vs required capacity with peak factor and safety margin, utilization and Run@Rate.
- 8
Selection: Capability and Risk
Cpk of up to 20 SC / CC characteristics per candidate and a weighted supply risk level.
Try the template in your browser
A simplified copy of the monthly scorecard: PPM, on-time delivery, complaints and 8D response turn into one score and an A / B / C class.
DemoIllustrative preview with example data, not the template itself. The Excel file has more rows, tabs, charts and checks.
| Supplier | Parts received | Parts rejected | On time % | Complaints | 8D response (days) | PPM | Score | Class |
|---|---|---|---|---|---|---|---|---|
| 1,292 | 77 | B | ||||||
| 150 | 100 | A | ||||||
| 1,323 | 48 | C |
| PPM target | |
| On-time target % | |
| 8D response target (days) |
The bundle has 100 suppliers, receipt and SCAR / 8D logs, editable KPI limits and weights, a one-page scorecard per supplier, ranking and a dashboard, plus the supplier selection matrix.
One page per supplier, every month
The scorecard turns receipts, deliveries and complaints into 6 KPIs, a score and a class, with 12 months side by side, ready to print or send to the supplier.
Decide sourcing with facts
Weighted criteria, knock-outs, capacity, capability and risk lead to a ranked recommendation the sourcing board can sign.
Can they really make your volume?
Capacity compares free capacity with the required rate including peak and safety margin, and records the Run@Rate result.
Cpk and supply risk per candidate
Key characteristics need the required Cpk (1.33, or 1.67 for SC / CC), and 9 risk factors roll up into one risk level.
Who it is for
- Supplier quality engineers and supplier quality managers
- Purchasing and sourcing teams
- Quality managers preparing for IATF 16949 or ISO 9001 clause 8.4 audits
Not included
- An ERP connection (data is entered or pasted)
- Macros, VBA or add-ins
- Identical charts in Google Sheets (data entry works, some charts differ)
Details
- Format
- Microsoft Excel .xlsx, 4 files (2 templates, example + blank)
- Works in
- Excel 2010 or newer, Microsoft 365, Excel for Mac, LibreOffice Calc
- Macros
- None
- Capacity
- 100 suppliers, 3,000 receipt rows, 2,000 complaints; 8 candidates, 20 characteristics
- Sample data
- 24 suppliers, 10 months, 130 complaints; 5 sourcing candidates
- Standard
- IATF 16949 / ISO 9001 clause 8.4
- Delivery
- Instant download after payment
Frequently asked questions
›How do I set up the KPIs, weights and selection criteria?
Read the guides: Supplier scorecard: KPIs, weights and A / B / C classes (qmbench.com/supplier-quality/supplier-scorecard-kpis-weights-classes/) and Supplier selection matrix: weighted criteria and knock-outs (qmbench.com/supplier-quality/supplier-selection-matrix-weighted-criteria/). The defaults in the bundle follow them.
›Where do I buy it?
Here on QM Bench with the Buy button: secure card checkout by Polar with a receipt, and the four Excel files arrive by e-mail right after payment.
›Is there a free alternative?
Yes. The free supplier scorecard and supplier assessment tools on QM Bench rate suppliers in your browser with a PDF. The bundle adds the logs, monthly classes, ranking, dashboard and the full selection workflow in files you keep.
›Can I get a refund?
No. It is a digital download: at checkout you agree to immediate delivery and waive the 14-day right of withdrawal, and the file stays with you. If something does not work as described, write to info@qmbench.com and you will get help or a corrected file.
Get the Supplier Quality Bundle
Instant download by e-mail after payment. Paste your measurements and read the verdict.
Buy now · €36.99Or try the free online tool first →