Supplier Score Calculator
Evaluate suppliers with weighted performance metrics
Supplier Information
Performance Scores (1 = Poor, 10 = Excellent)
Metric Weights
Adjust weights to fit your business priorities. Weights are normalized automatically.
How to Use This Tool
Follow these steps to generate a weighted supplier score:
- Enter the supplier’s name and the product category they provide (optional).
- Select a score from 1 to 10 for each performance metric: 1 represents poor performance, 10 represents excellent performance.
- Adjust the weight for each metric to reflect your business priorities (e.g., if pricing is more important to your business, increase the pricing weight). Weights are normalized, so they do not need to sum to 100.
- Click the Calculate Supplier Score button to view the results.
- Use the Copy Results to Clipboard button to save the report for your records or share it with your team.
- Click Reset Form to clear all inputs and start over with a new supplier.
Formula and Logic
The supplier score is calculated using a weighted average of all 5 performance metrics:
Weighted Score = ( (Score₁ × Weight₁) + (Score₂ × Weight₂) + ... + (Scoreₙ × Weightₙ) ) / Total Weight
Each metric score is a whole number from 1 to 10. Weights are positive numbers set by the user, and total weight is the sum of all individual weights. The final score is rounded to one decimal place for readability.
The rating (Excellent, Good, Fair, Poor) is assigned based on the overall weighted score:
- 8.0 – 10.0: Excellent
- 6.0 – 7.9: Good
- 4.0 – 5.9: Fair
- 0 – 3.9: Poor
Practical Notes
Adjust metric weights to align with your business’s sourcing priorities. For example:
- E-commerce sellers with thin margins may assign higher weight to Pricing Competitiveness.
- Businesses selling perishable goods should prioritize Delivery Reliability and Quality Assurance weights.
- Companies working with custom or complex products may increase Communication Responsiveness and After-Sales Support weights.
Typical industry benchmarks for supplier scores vary by sector, but a score above 7 is generally considered acceptable for long-term partnerships. Scores below 5 indicate significant performance gaps that require renegotiation or supplier replacement.
Always verify metric scores with real-world data: use past invoice pricing for pricing scores, defect rates for quality scores, and on-time delivery records for delivery scores.
Why This Tool Is Useful
Small business owners and procurement teams often rely on gut instinct when choosing suppliers, which can lead to costly mistakes. This tool standardizes the supplier evaluation process, ensuring all vendors are assessed against the same consistent criteria.
It eliminates bias by requiring quantitative scores for each metric, and the adjustable weights let you tailor the evaluation to your specific business needs. The detailed breakdown helps you identify exactly which areas a supplier is underperforming in, so you can address issues directly or compare multiple suppliers side by side.
Frequently Asked Questions
What if I don’t have data for all metrics?
If you are evaluating a new supplier with no performance history, use their proposal or sample data to assign preliminary scores. Follow up with updated scores once you have 3–6 months of real transaction data.
Can I use this tool to compare multiple suppliers?
Yes. Run the calculation separately for each supplier, copy the results, and compile them into a single spreadsheet to compare overall scores and individual metric performance side by side.
Do weights need to sum to 100?
No. The tool normalizes all weights, so you can enter any positive values. For example, if you set Pricing to 50 and Quality to 50, the total weight is 100, and each contributes 50% of the score. If you set Pricing to 10 and Quality to 20, Pricing contributes 33% and Quality contributes 67%.
Additional Guidance
Re-evaluate supplier scores every 6–12 months to account for changes in performance, pricing, or your business priorities. Keep a record of past scores to track supplier performance trends over time.
When negotiating with suppliers, share their score breakdown to highlight specific areas for improvement. Many suppliers will adjust pricing or processes to improve their score and retain your business.
For high-volume or mission-critical suppliers, consider adding additional custom metrics (e.g., sustainability certifications, minimum order quantities) by adjusting the weight of existing metrics to account for these factors.