How the frameworks work with actual figures
These examples use illustrative numbers to show how scoring matrices, TCO calculations, and switch decisions work in practice. The numbers are constructed for clarity, not drawn from specific businesses.
Building a scoring matrix
A small retail business sources packaging materials from three suppliers. The owner has always ordered from Supplier A because it was the first one found. Here is how a scoring matrix changes the picture.
Scenario: A retail business spends roughly $18,000 per year on packaging materials across three categories. It currently buys from one supplier without having formally compared the others. The owner wants to know whether that supplier is the right choice or simply the familiar one.
Step 1: Choose your criteria and assign weights
The criteria should reflect what actually matters to your business. For this scenario, the owner identifies five criteria and assigns weights that sum to 100.
| Criterion | Weight | Reasoning |
|---|---|---|
| Unit price | 30 | Important but not the only factor |
| Lead time reliability | 25 | Late deliveries cause stockouts |
| Minimum order quantity | 20 | Cash flow is tight; large MOQs are a problem |
| Quality consistency | 15 | Returns are costly but infrequent |
| Payment terms | 10 | Useful but not critical at this spend level |
Step 2: Score each supplier on each criterion (1-5 scale)
Scores are based on documented experience, quotes received, and reference checks. A score of 5 is favorable; a score of 1 is unfavorable.
| Criterion | Weight | Supplier A | Supplier B | Supplier C |
|---|---|---|---|---|
| Unit price | 30 | 3 | 4 | 5 |
| Lead time reliability | 25 | 5 | 3 | 2 |
| Minimum order quantity | 20 | 4 | 2 | 3 |
| Quality consistency | 15 | 4 | 4 | 3 |
| Payment terms | 10 | 3 | 5 | 2 |
| Weighted Total | 390 | 330 | 315 |
Total cost of ownership calculation
Two suppliers quote different unit prices. Adding all cost categories to both quotes changes which one is actually cheaper.
Scenario: A small manufacturer buys a component it uses in production. Supplier X quotes $3.20 per unit. Supplier Y quotes $2.85 per unit. Annual usage is approximately 4,000 units. On unit price alone, Supplier Y appears to save roughly $1,400 per year. TCO analysis tells a different story.
Supplier X
$3.20 / unitSupplier Y
$2.85 / unitThese figures are illustrative. The categories and structure apply to real situations; the specific numbers would come from your own supplier data and operating history.
The switch vs. stay decision
Even when a new supplier looks better on TCO, switching has its own costs. This example shows how to put a number on the transition.
Scenario: A service business buys office and operational supplies from a single distributor. A new distributor offers meaningfully better pricing and faster delivery. The TCO analysis shows a potential annual saving. The question is whether that saving exceeds the cost of switching.
Switching costs to quantify
Credit applications, tax documentation, account setup time. Estimate the hours spent by whoever handles purchasing and multiply by their effective hourly cost to the business.
Every item you buy has a new SKU with the new supplier. Updating purchasing templates, approval workflows, and inventory records takes time. For a business with 40-60 regularly purchased items, this can be a full day's work.
The first several orders with a new supplier typically take longer to process. Staff are learning a new portal, new ordering process, and new contact points. Estimate a productivity reduction for the first 60-90 days.
Your current supplier may extend you credit during a tight month, hold stock for you, or process returns without friction because of relationship history. Assign a conservative annual value to these informal accommodations.
The decision framework
If the payback period is under 12 months and the saving is material, switching is likely worth the disruption. If payback extends beyond 24 months, the case for switching weakens considerably, especially if the relationship has other intangible value.
The framework does not make the decision for you. It makes the tradeoff visible so the decision is informed rather than intuitive.
Constructing the matrix in a spreadsheet
The scoring matrix requires no specialized software. Any spreadsheet application handles it. Here is the structure to build.
Column structure
Column A: criterion names. Column B: weights (numbers that sum to 100). Columns C through E (or more): one column per supplier. A final column for weighted totals, calculated automatically.
The weighting step
Assign weights before you know the scores. If you assign weights after seeing scores, you will unconsciously weight criteria that favor your preferred supplier. The weights should reflect your business priorities, not the outcome you want.
Scoring consistently
Use the same scale for all criteria (1-5 or 1-10). Define what each score means for each criterion before scoring. "5 for delivery reliability" should mean the same thing whether you are scoring Supplier A or Supplier C.
The weighted score formula
For each criterion row: multiply the raw score by the weight. Sum all weighted scores for each supplier. The formula in a spreadsheet is straightforward: =SUMPRODUCT(weights range, scores range) for each supplier column.
Interpreting the output
The total weighted score is a comparative number, not an absolute one. A supplier scoring 380 out of a possible 500 is not "good" in isolation; it is better or worse than the other suppliers in your matrix. Look at the gaps between scores, and look at which criteria drive the differences.