How it works
Require a weight for every score column and a total weight of 100%. Scores are 0–100 with higher always better. Rank weighted sums descending.
Input definitions
- CSV: supplier,quality,delivery,cost score
- Plain text; maximum 200,000 characters.
- CSV: criterion,weight percent
- Plain text; maximum 200,000 characters.
A worked example
- CSV: supplier,quality,delivery,cost score
- supplier,quality,delivery,cost A,90,80,70 B,80,90,80
- CSV: criterion,weight percent
- criterion,weight quality,40 delivery,30 cost,30
Assumptions & limits
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Should raw purchase prices be entered in the cost column?
No. Convert each criterion to a consistent 0–100 higher-is-better score first. Otherwise weighting can reward expensive suppliers simply because their raw price is larger.
How does Weighted supplier scorecard work?
Require a weight for every score column and a total weight of 100%. Scores are 0–100 with higher always better. Rank weighted sums descending.
What are the limits of Weighted supplier scorecard?
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.