Apparel Search › Downloadable Templates › Free Supplier Scorecard Template (Excel)
Apparel Search Templates
Compare up to four factories on the criteria that matter to you, with your own weights.
Choosing a factory on price alone is risky. This free Excel scorecard lists twelve criteria, such as cost, sample quality, communication, lead time and flexibility. You give each a weight for how much it matters to you, then score each supplier from 1 to 5. The sheet calculates a weighted score, an average and a rank, and has a deal-breaker row for problems that should rule a supplier out. The criteria are editable, so you can add the things you care about.
The scores are your own judgment. Put the numbers side by side first with the Supplier Quote Comparison.
Type the names of up to four factories at the top of the columns.
Edit the criteria to suit your product, then give each a weight from 0 to 10. A weight of 10 means it is very important to you and 0 means ignore it. Setting the weights before you score helps you avoid favoring the factory you already like.
Use the same scale for everyone: 1 poor, 2 below expectations, 3 acceptable, 4 good, 5 excellent. Base each score on evidence, such as samples, references and replies. Leave a score blank if you have no information, and the sheet will not count that criterion for that supplier.
The weighted score is the percent of the best possible score, based on your weights and the criteria you scored. The average counts every criterion equally, and the rank puts the highest weighted score first.
If a supplier has a problem that should rule it out, such as an unresolved safety or compliance concern, type Yes in the deal-breaker row. It turns red. A deal-breaker should override any score.
Yes. It is free to use in your own business. Please do not sell or republish the file as your own.
It is the sum of weight x score for the criteria you scored, divided by 5 times the sum of the weights of those criteria. Criteria with no score are ignored.
No. It reflects your own judgment and weights, so use it to organize your thinking and not as proof of quality.
Yes. Retype the criteria names in column A. The formulas still work.