Weighted supplier scorecard with segment presets
Score suppliers on delivery, quality, cost, service, compliance and ESG, with weights that change by segment, so a strategic supplier and a non-critical one are not judged on the same terms.
- Free Excel file, no sign-up
- Weights by segment
- Tier and next action per supplier
- Scoring guidance for evaluators
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 4 | Supplier | Segment | Weighted score | Tier | Lowest dimension |
| 5 | Brianza Plastics | Strategic | 3.75 | Good | Quality |
| 6 | Lumen Packaging | Leverage | 2.40 | Critical | Cost |
| 7 | Ostrava Polymer | Bottleneck | 3.10 | Improve | Delivery |
| 8 | Kestrel EMS | Strategic | 4.45 | Preferred | ESG |
What is inside
5 sheets, ready to use.
Yellow cells are yours to fill in. Grey cells calculate. Every sheet has a worked example so you can see the expected format.
Read me
Purpose, steps, colour legend and assumptions.
Scorecard
One supplier per row: scores from 1 to 5, weighted score, tier, next action and lowest dimension.
Summary
Suppliers per tier, average score per segment and per dimension.
Segment weights
Weights per segment with a 100% check, segment definitions and tier thresholds.
Scoring guidance
What 1, 3 and 5 mean for each dimension, so evaluators score the same way.
How to use it
Four steps from download to a decision.
No macros, no add-ins. It works in Excel, Google Sheets and LibreOffice.
01
Check the weights per segment. Each row must total 100%.
02
Enter one supplier per row with its segment and a score from 1 to 5 per dimension.
03
The weighted score, tier and next action are calculated.
04
Share the scoring guidance with evaluators before the first cycle.
Spreadsheet or platform
Start in Excel. Move when the volume or the stakes grow.
The template and the platform use the same structure, so nothing you set up here is wasted.
This spreadsheet is enough when
- You score fewer than 30 suppliers once or twice a year
- One person collects every score
- Scores do not need evidence or an audit trail
Move it into EvaluationsHub when you need to
- Collect scores from several stakeholders per supplier and combine them
- Pull delivery and quality KPIs from your ERP instead of typing them
- Trigger corrective actions with owners and due dates when a supplier drops a tier
- Share the scorecard with the supplier and track the trend over time
Questions
Before you download
How should scorecard weights differ by segment?
Strategic suppliers usually carry more weight on relationship, innovation and risk; for non-critical suppliers delivery, quality and price matter most. The point of segment weights is that both are judged fairly. How to build a weighted supplier scorecard →
Is the template really free?
Yes. The file downloads directly, with no form and no email address.
When should we move this out of Excel?
When several people rate the same suppliers, when suppliers need to see their results, or when actions get lost between file versions. That is usually the point where a shared platform pays back. Signs you have outgrown the spreadsheet → Running SAP, Coupa, Dynamics or Oracle? See the ERP layer →
Related templates
Next steps in the supplier lifecycle.
Templates that pick up where this one ends.
How to configure supplier performance management: the planner
Seven-step planner: segments, 22 KPIs, cadence, escalation, roles and rollout.
View template →
Supplier business review (QBR) pack
Agenda with timings, RAG scorecard, action log and decisions.
View template →
Supplier corrective action tracker (8D)
8D cases with targets by severity, containment check and supplier summary.
View template →
Run it live
Run this process with your suppliers, not just in a file.
Start a free sandbox and set it up yourself: send requests and surveys to real suppliers, collect answers and see scores in one place.
