Supplier Scorecard Builder
Weight cost, quality, delivery, and risk, rank your suppliers, and see which to keep, renegotiate, or replace.
Example scenario—not a forecast or verified benchmark. Enable JavaScript to edit inputs, view charts, save locally and export your analysis.
Example inputs
- Suppliers
- [{"name":"Acme Components","spend":620000,"cost":4,"quality":4,"delivery":3,"risk":3},{"name":"Pacific Supply Co.","spend":410000,"cost":3,"quality":2,"delivery":2,"risk":2},{"name":"Midwest Metals","spend":280000,"cost":2,"quality":5,"delivery":5,"risk":4},{"name":"Overseas Partner Ltd.","spend":350000,"cost":5,"quality":3,"delivery":2,"risk":1},{"name":"Local Packaging","spend":90000,"cost":3,"quality":4,"delivery":4,"risk":4}]
- Weight: cost
- 30
- Weight: quality
- 30
- Weight: delivery
- 25
- Weight: risk
- 15
- Replace if score is below
- 50
- Renegotiate / improvement plan if below
- 65
Example results
$760K of $1.8M annual spend (43%) sits with suppliers you should renegotiate or replace; Midwest Metals leads at 74/100 and Pacific Supply Co. trails at 33/100.
- Spend with underperforming suppliers
- $760,000
- Spend-weighted supplier score
- 56/100
- Suppliers to replace
- 1
- Suppliers to renegotiate
- 1
- Total annual spend scored
- $1,750,000
- Largest supplier share of spend
- 35.4%
What stands out
Pacific Supply Co. scores 33/100 on $410K of spend
Weakest on quality. Below your replace threshold of 50; start qualifying an alternate source.
Overseas Partner Ltd.: renegotiate (51/100)
Weakest on risk. Tie $350K of annual spend to a written improvement plan with measurable targets.
35% of spend sits with Acme Components
Concentration this high means a single disruption hits most of your supply. Qualify a second source for critical items.
Midwest Metals is your best performer (74/100)
It holds only 16% of spend; consider shifting volume to it.
Next actions
- Issue an RFQ to 2-3 alternates for Pacific Supply Co. within 30 days.
- Share this scorecard with each underperformer, agree on 90-day targets (on-time %, defect rate, price), and re-score.
- Measure delivery and quality from your own receiving data, not supplier self-reports, and re-score quarterly.
- Reduce dependence on Acme Components below 30% of spend by qualifying a second source.
Model assumptions & limitations
- Weights (cost 30%, quality 30%, delivery 25%, risk 15%) are your inputs, normalized to 100%.
- 1-5 ratings are converted to 0-100 (1 = 0, 5 = 100) before weighting.
- Thresholds (replace < 50, renegotiate < 65) are adjustable rules of thumb.
- The ~30% single-supplier concentration flag is a rule of thumb, not a standard.