Skip to article

How to Compare Suppliers Using Total Cost, Not Just Unit Price

A worked one-order comparison with stated assumptions, a break-even point and a decision checklist. Every figure is hypothetical.

A lower unit price can be the right choice. It can also hide higher freight, inspection or correction costs. The useful question is not whether the cheapest supplier is always wrong, but whether the quotations deliver the same usable outcome under comparable assumptions.

CIPS describes total cost of ownership as an end-to-end estimate that goes beyond the price paid to the supplier to include acquisition, usage and end-of-life costs. CIPS reference The example below applies that thinking to a single order. It is a deliberately limited comparison, not a complete lifecycle valuation.

Step 1: compare the same requirement

Write the requirement before comparing quotations. Specify the product, usable quantity, quality criteria, delivery location, required date and unit of measure. Confirm what each quotation includes and what happens when goods do not meet the requirement.

Separate documented facts from estimates. Use quoted freight where available; do not silently treat an unknown charge as zero. Check whether taxes are recoverable and whether different delivery terms shift costs or responsibilities. Obtain relevant professional advice for contractual or tax treatment rather than guessing it into the spreadsheet.

Step 2: build a transparent cost model

Assume a company needs 1,000 usable units. Both suppliers will ship 1,000 units. For this illustration, all defects can be fully reworked before use, with no scrapped units, no supplier reimbursement and no overlap between inspection and rework costs.

The expected defect rates are invented teaching assumptions, not supplier performance data. All values use the same currency, USD, and time horizon. Recoverable taxes, financing, disposal and disruption costs are excluded unless added explicitly.

InputSupplier ASupplier B
Order quantity1,0001,000
Unit price$10.00$10.40
Product subtotal$10,000$10,400
Freight for this order$300$100
Inspection cost$120$80
Assumed defective share3%1%
Expected units needing rework3010
Rework cost per affected unit$6$6
Expected rework cost$180$60
Comparable order cost$10,600$10,640
Expected cost per usable unit$10.60$10.64

Calculate expected rework as quantity × defect rate × rework cost per affected unit. Then add product cost, freight, inspection and rework once each. For Supplier A: $10,000 + $300 + $120 + $180 = $10,600. For Supplier B: $10,400 + $100 + $80 + $60 = $10,640.

Supplier A remains $40 cheaper under these assumptions. There is no reason to force the conclusion that a higher quote must be better. The comparison is useful because it shows how small the remaining difference is and which assumptions control it.

Step 3: test what would change the decision

Let c be the rework cost per affected unit, with both defect-rate assumptions unchanged:

  • Supplier A: $10,420 + 30c.
  • Supplier B: $10,580 + 10c.

The costs are equal when 20c = $160, or c = $8. At that value both totals are $10,660. Above $8, Supplier B has the lower modeled cost; below $8, Supplier A does.

This threshold is more useful than saying one supplier is universally better. It tells the buyer to investigate whether $6 is a credible rework estimate. If it came from an outdated process, the decision may be fragile.

As a separate scenario, suppose Supplier A needs a one-off $150 expedited shipment to meet the required date and Supplier B does not. Keep the baseline $6 rework assumption. A then costs $10,750 versus B's $10,640, making B $110 cheaper in that scenario. Do not present the expediting charge as inevitable or probability-weighted without evidence.

Step 4: keep lead time and risk visible

A supplier can win the spreadsheet and still fail the requirement. Record promised lead time, delivery reliability, capacity, quality evidence and recovery options alongside cost.

If one supplier cannot meet a non-negotiable date or specification, do not hide that failure inside a small score penalty. Treat minimum requirements as gates. Compare costs among acceptable options, then discuss the remaining trade-offs.

Where the probability and impact of disruption are unknown, use scenarios and decision thresholds rather than a precise-looking expected-loss figure. For example: “If a delay triggers more than $40 of additional cost, A's baseline advantage disappears.” This is a threshold, not a prediction that a delay will occur. Our article on supplier performance metrics covers the evidence you can gather about reliability.

Step 5: check for double counting

Common mistakes include adding freight that is already included in the quote, counting replacement value as a loss when it will be reimbursed, or charging rework labor twice through separate overhead and hourly estimates.

When defective units are scrapped rather than reworked, revise the model. Shipping 1,000 units with 3% unusable output is not equivalent to receiving 1,000 usable units. You may need replacement quantities, extra freight and a different denominator. The table above assumes every unit becomes usable after rework.

A comparison sheet you can copy

Cost or requirementSupplier valueEvidenceAssumption/uncertaintyOwner
Specification and usable quantity Approved requirement  
Quoted price and included charges Current quotation  
Freight and handling Quote or carrier estimate  
Inspection and rework Process data or stated scenario  
Required date and lead time Written delivery commitment  
Payment and reimbursement treatment Agreed terms  
Excluded lifecycle costs Explicit scope note  

Use one unit of measure, currency and time horizon. Keep the quote date and expiry visible. Document why the preferred supplier remains acceptable when an important assumption changes.

Compare your quotation assumptions

Use the free Excel comparison to change freight, inspection, rework and expediting costs. It includes this article's worked example and separate checks for deadline and specification requirements. Use matching quantities and one currency, and read the model's rework assumptions before entering your own offers.

Download supplier comparison (.xlsx) Microsoft Excel workbook, 5 KB. Free, with no sign-up.

How to use the comparison

Use the amber input cells on the Compare sheet to enter two offers for the same quantity, specification and currency. Fill in every cost input, including an explicit zero for a cost that does not apply. An empty cell does not mean zero: the result shows n.a. until the input is complete. Enter 3% or 0.03 for a three-percent defect rate, not 3.

The model assumes that all defective units become usable after rework. It excludes scrap, replacements, reimbursements and a full ownership lifecycle. “Expected rework units” can be fractional because it is a planning estimate. If your scenario involves scrap, redesign the usable-unit denominator before using the result.

The base inputs reproduce this article's example: Supplier A costs 10,600 and Supplier B costs 10,640. Setting Supplier A's expediting cost to 150 makes A 110 more expensive. Setting both rework costs to 8 gives equal totals of 10,660.

Deadline and specification start as Unverified. Replace them only after reviewing evidence, because a lower cost does not establish that a supplier is acceptable. Record quote references and the cost scope in the notes cells, and do not include the same charge in both the unit price and a separate cost row. Numeric inputs must be nonnegative, the quantity must be positive and the defect rate must be between zero and one.

We tested the workbook in desktop Microsoft Excel 2013 on Windows: both base totals, the expediting scenario, the break-even rework cost, a blank price, a zero quantity, an out-of-range defect rate, a negative cost and the requirement checks. We have not tested other Excel versions, Excel for the web, Mac, Google Sheets or LibreOffice. All values in the example are hypothetical.

Turn the comparison into a recommendation

A useful recommendation states the required outcome, base-case cost difference, largest uncertainty and condition that would change the choice. For this example: “A is $40 cheaper if all defects are reworkable at $6 each and neither supplier requires expediting. Verify actual rework cost and delivery feasibility before award.”

That conclusion is more defensible than choosing on unit price alone or copying a weighted score without explaining its weights.

Use the Excel guide to build the calculation. If you want to keep learning about purchasing, our supply chain reading guide includes a procurement title, and the procurement simulation game article explains what a sourcing simulation can teach. In the simulation, practice explaining why a supplier decision protects cost, service or cash. The illustrative numbers here are not the game's formulas or supplier data.

Frequently asked questions

Is this the same as landed cost?

Not exactly. A landed-cost calculation focuses on getting goods to a specified destination under a defined scope. A broader ownership analysis can include costs during use and end of life. Define your boundaries instead of assuming every organization uses the terms identically.

Should a supplier score include nonfinancial factors?

It can, but establish mandatory requirements first. Explain any weights and avoid letting a low price compensate for a requirement the supplier cannot satisfy.

Sources and limits

The cost figures in this article are invented teaching assumptions. They are not supplier quotations, supplier performance data or measured defect rates. The one external source supports the general description of total cost of ownership only.

Share this article

LinkedInXEmail

Spotted an error or an outdated fact? Suggest a correction — corrections are reviewed by the author.