Supplier Scorecard Calculator
A supplier performance scorecard is a weighted 0–100 rating of a supplier across delivery, quality, cost, and service: each metric is normalized against a floor and a target, multiplied by its weight, and summed into one score and letter grade. This calculator scores up to three suppliers against the same weight profile, grades them A–F, shows which metric is dragging each score down, and ranks them best to worst.
Performance Inputs
On-Time Delivery
Receipt date vs. PO due date, from your ERP goods-receipt history.
Quality
Accepted quantity ÷ received quantity, from inspection or QMS records.
Fill Rate
Quantity shipped ÷ quantity ordered on the first attempt.
Cost Variance
Paid price vs. benchmark or should-cost. Negative means under benchmark.
Responsiveness
Average time to first substantive reply on an RFQ, expedite, or claim.
Compliance
Clean ASNs, certs, and invoices as a share of shipments, EDI or portal data.
Results
Quality is strong at 94.7 out of 100. On-Time Delivery is the main gap, giving up 7.7 of the 100 available points. Lifting on-time delivery from 94% to 95.71% (a 1.71-point move) would take this supplier to a B.
Contribution Breakdown
- On-Time Delivery17.3169.23 × 25%
- Quality23.6894.74 × 25%
- Fill Rate11.7978.57 × 15%
- Cost Variance8.7558.33 × 15%
- Responsiveness8.1881.82 × 10%
- Compliance7.0070.00 × 10%
Formula
Metric Score = clamp((Actual − Floor) ÷ (Target − Floor) × 100, 0, 100) · Weighted Score = Σ (Metric Score × Weight)Every metric is put on the same 0-to-100 scale before it is weighted, which is what makes a delivery percentage, a price variance, and a response time in hours addable at all. Each metric has a floor (the level that scores 0) and a target (the level that scores 100); performance between them scores linearly, and anything beyond either end is clamped, so one heroic metric cannot mask a failing one. Metrics where lower is better (cost variance and responsiveness) use the mirrored form, clamp((Floor − Actual) ÷ (Floor − Target) × 100, 0, 100), so a lower number earns a higher score. Each metric score is then multiplied by its weight and the six products are summed. Weights must total 100%: if they do not, the weighted total is not a 0-to-100 score at all, which is why this calculator refuses to grade an out-of-balance profile and offers a one-click Normalize instead. Quality can be entered as defect PPM rather than acceptance percentage, PPM converts with acceptance% = 100 − (PPM ÷ 10,000), and the converted value is shown under the input so the math is never hidden.
Variable Definitions
On-Time Delivery
Share of receipts that arrived on or before the PO due date. Pull it from ERP goods-receipt history: receipt date versus promised date on the PO line, across the scoring period. Default scale: 85% scores 0, 98% scores 100.
Quality (acceptance % or defect PPM)
Accepted quantity ÷ received quantity, from incoming inspection results or QMS non-conformance records. If your quality team reports defects in parts per million instead, switch the input to PPM and the calculator converts it. Default scale: 90% scores 0, 99.5% scores 100.
Fill Rate
Quantity shipped ÷ quantity ordered on the first attempt, at line or order level. Comes from PO line receipts against ordered quantity. Short-shipped lines are the ones that hurt. Default scale: 85% scores 0, 99% scores 100.
Cost Variance
Price paid versus your benchmark, should-cost model, or index, as a percentage. Sourced from PO price history against the contract or benchmark price. Lower is better: +10% scores 0, −2% (under benchmark) scores 100.
Responsiveness
Average hours to a first substantive reply on an RFQ, expedite request, or quality claim. Usually tracked in the sourcing or ticketing system rather than the ERP. Lower is better: 48 hours scores 0, 4 hours scores 100.
Compliance
Share of shipments with clean paperwork, accurate ASNs, certificates of conformance, and invoices that match the PO. Comes from EDI or supplier-portal exception logs. Default scale: 90% scores 0, 100% scores 100.
Floor
The performance level that earns zero points on a metric, typically the worst level you would still tolerate before the supplier is out. Editable per metric.
Target
The performance level that earns a full 100 points. Set it to what a genuinely good supplier in this category achieves, not to perfection, or every supplier scores badly. Editable per metric.
Weight
How much each metric matters to you, as a percentage. All six must total 100%. Weights are the real judgement call in a scorecard: a regulated part might weight quality at 40%, while a promotional item with a hard on-shelf date weights delivery highest.
Example Calculation
Scenario: scoring one incumbent supplier on the default scales and weights. Inputs: on-time delivery 94%, quality acceptance 99.0%, fill rate 96%, cost variance +3%, responsiveness 12 hours, compliance 97%. Metric scores (each normalized to 0-100), then weighted: On-time delivery (94 − 85) ÷ (98 − 85) × 100 = 69.23 × 0.25 = 17.31 Quality (99 − 90) ÷ (99.5 − 90) × 100 = 94.74 × 0.25 = 23.68 Fill rate (96 − 85) ÷ (99 − 85) × 100 = 78.57 × 0.15 = 11.79 Cost variance (10 − 3) ÷ (10 − (−2)) × 100 = 58.33 × 0.15 = 8.75 Responsiveness (48 − 12) ÷ (48 − 4) × 100 = 81.82 × 0.10 = 8.18 Compliance (97 − 90) ÷ (100 − 90) × 100 = 70.00 × 0.10 = 7.00 Weighted total = 76.71 → Grade C → Conditional, monitor The breakdown is the useful part. Quality is carrying this supplier, while on-time delivery gives up 7.7 of the 100 available points and cost variance another 6.3. Lifting on-time delivery from 94% to 95.7% on its own moves the total past 80 and the supplier from a C to a B.
How to Interpret Your Result
• 90–100 (A): Preferred / strategic. Award more volume, consider a longer-term agreement, and use this supplier as the benchmark for the category. • 80–89 (B): Approved. A solid performer. Share the scorecard, agree one improvement target, and re-score next period. • 70–79 (C): Conditional, monitor. Keep the business but add controls: tighter expediting, more safety stock, or a qualified second source. • 60–69 (D): Probation. Issue a corrective action plan with named owners and dates, and re-score in 30 to 60 days rather than waiting for the next quarter. • Below 60 (F): Exit or re-source. Start qualifying an alternative now; the cost of the buffer stock a failing supplier forces you to carry is usually larger than the cost of switching. • Read the contribution breakdown before the grade. Two suppliers can both score 78: one with a flat profile, one with excellent quality and failing delivery. Those need completely different conversations. • A score is only comparable within one weight profile. If you change the weights, re-score every supplier before ranking them.