Supplier Scorecard Calculator
Roll up quality, delivery, cost, and service performance into one weighted supplier score.
Supplier Scorecard Template — free, works offline, formulas included.
What Is a Supplier Scorecard? (And Why Should You Care?)
A supplier scorecard rolls up several dimensions of supplier performance — quality, delivery reliability, cost, and service — into one weighted score, instead of judging a supplier on whichever single factor happens to be top of mind at the time.
Left unstructured, supplier evaluation tends to drift toward whatever's most visible in the moment: a recent price increase, a recent late shipment, a recent quality complaint. A scorecard forces a more balanced view and, just as importantly, makes the comparison consistent over time and across different suppliers — the same weighting applied the same way, quarter after quarter, instead of an ad hoc judgment call each time.
How Does It Work?
Each dimension gets scored 0-100, then multiplied by a weight reflecting how much that dimension matters for this particular purchase category. The four weights need to sum to 100%. A safety-critical component might weight quality heavily; a commodity item with plenty of alternate suppliers might weight cost more heavily instead — the weights are where the real strategic judgment lives.
Real-World Example
Quality: 95% · On-time: 98% ·Cost: 85% · Service: 90%
Weights: 30% / 30% / 25% / 15%
Score = 28.5 + 29.4 + 21.25 + 13.5 = 92.65 / 100 (Excellent)
This supplier scores in the excellent range across all weighted dimensions.
Now apply a different weighting to the same raw scores — a procurement team that cares more about cost than quality for this category, say sourcing a commodity component with several interchangeable suppliers: 20% quality, 15% on-time, 40% cost, 25% service, evaluated on the same underlying scores of 90/85/95/80:
Different weights on similar raw scores produce a meaningfully different final number — which is exactly the point. The score isn't just measuring the supplier; it's measuring the supplier against what actually matters for that specific sourcing decision.
Key Assumptions & Limitations: When Does This Work?
This assumes each dimension's underlying score is itself trustworthy — a quality score based on a handful of shipments or a cost score based on quoted price rather than TCO will produce a misleadingly precise-looking final number built on soft inputs. Garbage in, garbage out applies here just as much as anywhere else.
It also assumes the four dimensions and their weights genuinely capture what matters for this sourcing decision — a category with a factor this model doesn't include (say, geopolitical risk or sustainability compliance) needs that factor added explicitly, not folded awkwardly into one of the existing four.
5 Ways People Get Supplier Scorecards Wrong
Over-weighting cost by default. It's tempting to let price dominate the score, but that's exactly the mistake TCO exists to prevent — a cheap, unreliable supplier can cost more overall than a pricier, dependable one.
Using the same weights for every category.Safety-critical parts and commodity items don't deserve the same weighting scheme — adjust weights by category, not once for the entire supplier base.
Scoring quality or service on gut feel. The underlying dimension scores should come from actual data — defect rates, on-time percentages, response times — not a rough impression from the last conversation with the account rep.
Running the scorecard once and never updating it.Supplier performance drifts. A score from a year ago may not reflect a supplier that's since improved or declined.
Treating the final number as the whole story. A single blended score can hide that a supplier is excellent on three dimensions and genuinely weak on one critical one — look at the component scores, not just the total.
Industry Benchmarks & Context
A score above roughly 90 is generally considered excellent, 80-90 good, 70-80 acceptable but worth a conversation, and below 70 usually triggers a formal supplier improvement plan or a search for alternatives. Weighting conventions vary by category, but quality and delivery reliability commonly carry the heaviest weight (25-35% each) for critical components, while commodity items often shift more weight toward cost.
Next Steps & Related Tools
Once you have a supplier score:
- Base the on-time score on real data — Lead Time Analysis gives you an actual delivery reliability figure instead of a guess.
- Base the cost score on TCO, not just quoted price.
- Revisit quarterly — supplier performance changes, and the scorecard should track that change, not just capture one moment in time.
Learn More
Books:
- Purchasing and Supply Chain Management by Robert Monczka, Robert Handfield, Larry Giunipero, and James Patterson
Standards & curricula:
- ISM (Institute for Supply Management) CPSM certification curriculum
General references for further study, not endorsements — verify course availability and content directly with the provider.
Interview Preparation
Questions like these come up in supply chain and operations interviews — here's how to answer them.
What does a supplier scorecard measure, and what problem does it solve?
It rolls up quality, on-time delivery, cost, and service into one weighted score. It solves the problem of supplier evaluation drifting toward whatever's most visible in the moment — a recent late shipment or price hike — instead of a consistent, balanced view over time.
How would you explain the weighting scheme to someone new to procurement?
Each of the four dimensions gets scored 0-100, then multiplied by a weight that reflects how much it matters for that purchase — the four weights need to add up to 100%. A safety-critical part might weight quality heavily; a commodity item with easy substitutes might weight cost more.
Why can the same raw scores produce very different final results?
Because the weights change what matters — in the worked example, shifting from a quality-and-delivery-heavy weighting to a cost-heavy one changes the final score from 92.65 to 88.75 on similar underlying performance, since the weighting reflects the sourcing decision, not just the supplier.
When would a supplier scorecard not be the right tool?
When the underlying dimension scores themselves aren't trustworthy — a quality score from a handful of shipments or a cost score based on quoted price instead of TCO produces a precise-looking number built on soft inputs. It also falls short if a factor like geopolitical risk or sustainability compliance matters and isn't one of the four dimensions.
Frequently Asked Questions
- What weights should I use for quality, on-time, cost, and service?
- It depends on the category — critical components commonly weight quality and delivery reliability heaviest (25-35% each), while commodity items with easy substitutes often shift more weight toward cost. Adjust by category rather than using one scheme for every supplier.
- What's considered a good supplier score?
- Above roughly 90 is generally excellent, 80-90 good, 70-80 acceptable but worth a conversation, and below 70 usually triggers a formal improvement plan or a search for alternatives.
- How should I score the cost dimension?
- Base it on Total Cost of Ownership rather than quoted price alone — over-weighting or mis-scoring cost based on the sticker price is one of the most common ways scorecards favor the wrong supplier.
- How often should I update a supplier's scorecard?
- Quarterly is a common cadence — supplier performance drifts, and a score from a year ago may not reflect a supplier that's since improved or declined.