Template

Supplier Quality & Performance Scorecard Template

A practical, ready-to-use supplier scorecard with clear metric definitions, scoring formulas, weighting guidance, sample calculations, a quarterly review agenda, and recommended escalation thresholds to drive measurable supplier improvement.

Purpose

This scorecard helps procurement, quality, and operations teams measure supplier delivery, quality, lead-time stability, and responsiveness consistently, turn measurements into a single actionable supplier score, and run short, focused quarterly review conversations that produce clear improvement actions.

How to use this template

Collect each metric for the reporting period, enter the numeric values, convert each metric to a 0–100 score using the formulas below, apply your chosen weights, and calculate a weighted average supplier score. Use the score and metric-level flags to prioritize improvement plans, corrective actions, or escalation.

Core metrics (recommended)

Metric Definition Unit / Frequency Typical Target Calculation / Notes Example
On-time delivery (OTD) Percent of deliveries received on or before agreed delivery date. % / monthly or quarterly ≥ 95% OTD% = (On-time deliveries / Total deliveries) × 100. Score = min(100, (OTD% ÷ Target%) × 100) OTD 92% → Score = (92 ÷ 95) × 100 = 96.8 → capped at 96.8
PPM defects (or returns) Parts per million defective or returned to supplier. PPM / monthly or quarterly < 500 PPM (industry-dependent) Lower is better. Score = min(100, (TargetPPM ÷ ActualPPM) × 100). If Actual≤Target, score=100. Target 500PPM, Actual 750PPM → Score = (500 ÷ 750) × 100 = 66.7
Lead-time variability Measure of spread in lead time (use Std Dev or Coefficient of Variation CV = SD / Mean). CV (no unit) / quarterly CV ≤ 0.10 (10%) typical for stable suppliers Lower is better. Convert into a 0–100 score: Score = max(0, min(100, (TargetCV ÷ ActualCV) × 100)). Target CV 0.10, Actual CV 0.20 → Score = (0.10 ÷ 0.20) × 100 = 50
Responsiveness Average days to acknowledge and respond to order or issue inquiries. Days / monthly or quarterly ≤ 2 business days Lower is better. Score = min(100, (TargetDays ÷ ActualDays) × 100). Target 2 days, Actual 4 days → Score = (2 ÷ 4) × 100 = 50
Corrective Action (CAPA) closure time Average elapsed days from CAPA opening to verified closure. Days / quarterly ≤ 30 days Lower is better. Score = min(100, (TargetDays ÷ ActualDays) × 100). Target 30 days, Actual 45 days → Score = (30 ÷ 45) × 100 = 66.7

Scoring and overall supplier score

1) Convert each metric to a 0–100 score using the formulas above. 2) Apply metric weights (weights should sum to 100). 3) Overall Supplier Score = Σ(metric_score × weight%).

Suggested default weights (adapt to your business): OTD 30%, PPM 30%, Lead-time variability 15%, Responsiveness 15%, CAPA closure 10%.

Recommended banding and escalation

  • 90–100 = Green (Meets or exceeds expectations)
  • 80–89 = Yellow (Acceptable but monitor / improvement plan)
  • < 80 = Red (Requires corrective action / escalation)

Suggested escalation rules:

  1. Single quarter score < 80 → require supplier CAPA within 30 days.
  2. Two consecutive quarters < 80 → supplier improvement plan with agreed milestones and quarterly progress reviews; procurement to consider risk mitigation.
  3. Any quarter score < 70 OR PPM > 2× target → immediate procurement escalation; consider alternative sourcing if improvement is not rapid and verifiable.

Quarterly review slide / meeting template

Keep reviews short (30–60 minutes). Share a one-page slide with key data and a 5-item agenda:

  1. Opening: confirm participants, objectives, and previous action status (5 min)
  2. Scorecard snapshot: overall score, trend vs prior quarters, and metric highlights (10 min)
  3. Root-cause summary for any Red/Yellow metric and CAPA status (10 min)
  4. Agreed actions: owner, due date, success criteria (10 min)
  5. Escalation notes and next meeting date (5 min)

Slide layout suggestion: top-left overall score and trend chart; top-right table of metric scores and targets; bottom: three prioritized actions with owners/dates.

Action item template (use in meeting)

Action | Owner | Due Date | Success Criteria | Status

Sample calculation (illustrative)

Inputs (quarter): OTD 92%, PPM 750, Lead-time CV 0.20, Responsiveness 4 days, CAPA 45 days. Using targets and weights above:

  • OTD score = (92 ÷ 95) × 100 = 96.8 → weighted = 96.8 × 30% = 29.04
  • PPM score = (500 ÷ 750) × 100 = 66.7 → weighted = 66.7 × 30% = 20.01
  • Lead-time score = (0.10 ÷ 0.20) × 100 = 50 → weighted = 50 × 15% = 7.5
  • Responsiveness score = (2 ÷ 4) × 100 = 50 → weighted = 50 × 15% = 7.5
  • CAPA score = (30 ÷ 45) × 100 = 66.7 → weighted = 66.7 × 10% = 6.67
  • Overall score = 29.04 + 20.01 + 7.5 + 7.5 + 6.67 = 70.72 → Red band

Tailoring notes

• Adjust targets and weights to match your product risk and business priorities (e.g., safety-critical parts should weight quality higher).
• Add cost-to-serve or expedited shipment cost metrics when supplier cost/lead-time trade-offs matter.
• Define data sources and owner (ERP receipts, ASN, quality inspection records). Ensure a single source of truth for each metric.

Operationalizing and next steps

  1. Agree on metrics, targets, and weights with procurement, quality, and operations stakeholders.
  2. Assign a data owner and cadence (monthly collection, quarterly review recommended).
  3. Populate the scorecard for the recent quarter and run an initial review with the supplier using the agenda above.
  4. Track actions in a shared tracker and revisit at the next review until sustained improvements are seen.

Where this fits

Use this template in supplier performance reviews and to prioritize supplier improvement plans. It is suitable to include as the quarterly slide set for Deck 1114 or any supplier governance pack.

Image suggestion

Search phrase: supplier scorecard

Discuss Ask the Librarian

Discussion

Comments and conversation will live here.