Gut feeling is not a vendor evaluation strategy. If you're choosing between suppliers based on who calls you back fastest or who gave you the best quote last year, you're leaving money and reliability on the table. A vendor scorecard in Excel gives you an objective, repeatable way to evaluate and compare suppliers.
The 5 Criteria That Matter Most
| Criteria | Weight | What to Measure |
|---|---|---|
| On-Time Delivery | 30% | % of orders delivered on or before promised date |
| Product Quality | 25% | Defect rate, return rate, inspection pass rate |
| Price Competitiveness | 20% | Price vs market rate, willingness to negotiate |
| Communication | 15% | Response time, proactive updates, issue resolution |
| Compliance & Docs | 10% | Correct invoices, certifications, documentation |
Weights should add up to 100%. Adjust based on what matters most to your business.
Step 1 — Set Up the Scoring Sheet
Create columns: Criteria | Weight | Vendor A Score | Vendor B Score | Vendor C Score | Best Vendor
Step 2 — Score Each Vendor 1-5
| Score | Meaning |
|---|---|
| 5 | Excellent — exceeds expectations consistently |
| 4 | Good — meets expectations with minor issues |
| 3 | Acceptable — meets basic requirements |
| 2 | Poor — frequent issues requiring management |
| 1 | Unacceptable — significant ongoing problems |
Step 3 — Calculate Weighted Scores
For each vendor, multiply each score by its weight and sum the results:
Step 4 — Identify the Best Vendor per Criteria
Step 5 — Add a Recommendation Logic
How to Use the Scorecard in Negotiations
Share the scorecard criteria with vendors upfront. Most suppliers perform better when they know exactly what they're being measured on. Use the scores as leverage in price negotiations — a vendor scoring 4.5 has earned better rates than one scoring 2.5.
FAQ
📋 Get the Pre-Built Vendor Scorecard Template
Free download — no sign-up required.
⬇ Download Free Template