Score and Rank Factories Before You Award the PO
Most supplier decisions get made on price and gut feel, then regretted six months later when the cheap quote ships three weeks late. A weighted scorecard forces you to say up front how much each factor is actually worth to you.
This Excel matrix compares four suppliers across eight criteria. You set the weights, score each supplier from 1 to 5, and the weighted score, ranking, and recommendation calculate themselves. Every criterion has a written definition of what a 5 and a 1 look like, so two people scoring the same factory land in the same place.
What is in the supplier evaluation matrix
| Field | What goes in it |
|---|---|
| Criterion | Eight pre-filled factors covering price, quality, delivery, and risk. |
| Weight | How much each criterion matters. A live check flags anything that does not total 100%. |
| Supplier A–D | Score each from 1 to 5. Entry is validated to that range. |
| What a 5 / 1 looks like | Written anchors so scoring stays consistent between people. |
| Weighted scoreauto | Weights applied to scores, out of 5. |
| Rank and recommendationauto | Ordering plus a preferred / acceptable / do not proceed call. |
Mistakes this template is designed to prevent
Weighting price too heavily
Price is the easiest number to compare, so it quietly dominates. A supplier that is 5% cheaper and habitually three weeks late usually costs more than it saves once you price the stockouts.
Scoring on impression rather than evidence
Ask for defect data, on-time records, and current certificates before you fill this in. A score you cannot point at a source for is a guess with a number attached.
Treating a 0.1 gap as a decision
Two suppliers within about 0.3 of each other are effectively tied. Break that tie on something the matrix does not capture, such as responsiveness, capacity headroom, or your read of the relationship.
Supplier Evaluation Matrix FAQ
Related reading
- Supplier evaluation matrix for importers. The criteria and a worked 8.15 vs 7.00 vs 7.90 table
- True product cost, factory to warehouse. Why the cheapest quote is often not the cheapest supplier
More free templates
Purchase Order Template
Standardised PO with automatic line totals, HS code fields, Incoterms, and payment terms.
Packing List Template
Shipping packing list that calculates carton counts, CBM, and air chargeable weight from the sizes you enter.
Commercial Invoice Template
Customs-ready invoice with per-line HS codes, country of origin, Incoterms, and a declaration block.
Inventory Tracking Template
Per-SKU stock sheet that calculates safety stock, reorder point, days of cover, and reorder alerts.
Dropshipping Profit & Loss Template
Month-by-month P&L that turns orders, product cost, ad spend, and fees into net profit and margin automatically.
The template is free. Keeping fifty of them in sync is the problem.
A spreadsheet works until there are eleven versions of it and nobody knows which one the supplier filled in. SupplyAutomate keeps purchase orders, supplier documents, shipments, and landed costs in one workspace that updates as the order moves.