Comparing supplier quotes: the apples-to-apples worksheet

The lowest quote is rarely the lowest cost. The $6.40 yoga mat and the $7.30 yoga mat — illustrative numbers, and the same ones worked below — almost never stay $0.90 apart once tooling, freight terms, duties, and payment timing are loaded onto each one, and the quote that looks cheapest is usually the one with the most costs parked outside it, on rows the supplier never wrote. The worksheet in this article forces every quote onto the same lines and produces one number per supplier: landed cost per unit. The worked example below flips a ranking, which is exactly what it's designed to do before you wire money, not after.

One boundary: getting quotes in the first place — who to send the RFQ to, how many bidders, how to word the ask — is its own process, covered in the RFQ guide. Quotes that arrive through a manufacturer's rep score on the same worksheet — the rep's commission simply becomes one more row to normalize. This article picks up where that one ends: three quotes have landed in your inbox, and they don't line up.

What a quote contains, and what it leaves out

A typical factory quote answers six questions and dodges six more. It states the unit price, the currency, an Incoterm (who pays for which leg of the journey), a minimum order quantity, a production lead time, and payment terms. What it usually leaves out is where your real cost lives:

• Tooling. Plates, molds, and die-cut fixtures for your custom artwork — quoted separately, or "included" without a stated amortization.
• Freight from their floor to your 3PL. The Incoterm decides whose invoice this lands on, not whether it exists.
• Duty and import fees, which depend on the product classification, not on anything in the quote.
• The cost of the payment structure itself — a 50% deposit ties up cash weeks before goods exist; net terms don't.
• Packaging, labels, and compliance marks if they're not explicitly in scope.
• Validity. Quotes expire — 30 days is common — and comparing an expired quote to a fresh one is comparing two different markets.

The worksheet's job is to make every one of those omissions into a row.

The apples-to-apples worksheet

Copy this table into your spreadsheet and fill one column per quote. The numbers below are illustrative, for a 6mm TPE yoga mat with custom print, MAT-YG6-PU, from three suppliers:

At quote level, B looks like the winner at $6.40. At landed level, C — the "expensive" one — is. Here's the arithmetic, line by line, for the two rows that did the flipping.

The arithmetic, line by line

Tooling amortization. Supplier A's plate costs $1,850 (illustrative). Spread over 10,000 units — the volume you realistically expect to buy over a year or two — that's $1,850 ÷ 10,000 = $0.19 per unit. Be clear-eyed about the denominator: spread over just the first 500-unit order, the same plate is $1,850 ÷ 500 = $3.70 per unit, and the quote comparison inverts completely. Amortize over the volume you'll actually buy, not the volume you hope to.

Freight normalization. A quoted FOB Ningbo, so freight is yours: an illustrative $0.62/unit by sea. B quoted EXW, which excludes loading and export clearance too, so B's freight line is worse — $0.78 (illustrative). C quoted DDP, freight genuinely included. To compare fairly, every column must carry the same journey; when in doubt, restate everything as "cost of goods delivered to my 3PL" — the Incoterms 2020 definitions from the International Chamber of Commerce are the standard reference for who owes which leg (accessed November 2026).

Duty. Duty applies to the customs value, which follows the Incoterm basis — for A and B that's roughly the ex-works/FOB price. At an illustrative 6.5% rate: A pays 6.90 × 0.065 ≈ $0.45; B pays 6.40 × 0.065 ≈ $0.42; C's DDP price already contains it. Look your product's actual rate up in the USITC Harmonized Tariff Schedule before relying on any number here (accessed November 2026).

Summing A: 6.90 + 0.19 + 0.62 + 0.45 = $8.16 landed. B: 6.40 + 0.78 + 0.42 = $7.60. C: $7.30 as quoted. The $0.50 unit-price gap between A and B was hiding a $0.56 landed gap in the other direction, and C's "expensive" quote was the cheapest order all along.

Normalizing the rows that hide costs

Three rules keep the worksheet truthful:

• One journey, stated the same way in every column. If a supplier won't quote delivered-to-3PL, quote the freight leg yourself with a forwarder and put your own number in their column. A blank row is an unpriced risk, not a saving.
• One denominator per amortized cost. Tooling, plate setup, and artwork fees all divide by expected total volume across orders, and every supplier's column uses the same horizon.
• Classify before you trust a duty number. Suppliers routinely guess duty rates. The HTS lookup takes minutes and settles it; the classification is yours, not theirs.

When two quotes still refuse to line up — different materials, different constructions, a "similar" spec — stop normalizing and treat them as different products. A cheaper quote for a thinner mat isn't a quote for this mat.

The rows that decide your reorders

Landed cost picks the winner on paper; three non-price rows decide whether the win survives a year of reordering:

• Lead time — quoted versus kept. Every quote above carries a production lead time, but the number that belongs in your reorder math is what that supplier actually delivers, measured from your own PO history. The quoted 18, 25, and 30 days above are marketing until proven; measuring supplier lead time from PO history is how you turn them into planning numbers. Behind a seasonal quote sits a production slot, and slots are bookable — the factory capacity booking guide works the reservation calendar.
• Payment structure and cash timing. C's net-30 means zero cash leaves until goods arrive; B's 50/50 means roughly $3,200 (illustrative, on a 1,000-unit order) tied up for the whole production cycle. A deposit isn't a price, but it's a real cost of the order — how deposit structures work, and how to protect the cash, is covered in the deposit structures guide.
• MOQ against demand. B's 1,000-unit minimum only makes sense if you sell 1,000 units in a reasonable window. At an illustrative 2.2 mats/day, that's 1,000 ÷ 2.2 ≈ 455 days of cover — more than a year of stock on one PO, for a product you haven't sold yet. C's 300-unit MOQ is 300 ÷ 2.2 ≈ 136 days, which is orderly. The cover arithmetic for sizing orders against demand is in the days-of-cover guide.
• The supplier-count row. One more line worth adding when the comparison includes an incumbent: what consolidating onto the winner does to your supplier count, for better and worse — the sprawl math and the transition risks are in the supplier consolidation guide.

Scoring without fooling yourself

When the decision is close, or several people need to agree on it, add a weighted score under the worksheet. Illustrative weights — set them from your own priorities before scoring, or the winner will be whoever you wanted:

The scores are 1–5, and the pattern in this illustrative table is the lesson: B, the quote that looked cheapest on day one, scores worst, because its price advantage was real but everything around it — MOQ, cash exposure, freight basis — was priced against you. C wins without being cheapest on any single line except landed cost, which is the only line that pays you.

Once the winner is chosen, the numbers transfer directly: landed cost per unit becomes your cost-per-item in store records, and Shopify's native profit reports read from exactly that field (Shopify Help Center, accessed November 2026). A quote comparison that ends with a clean cost figure keeps paying off long after the PO is placed.

Common questions

How do I compare quotes from suppliers with different Incoterms? Restate every quote as delivered cost to your 3PL: add freight, export, and duty legs to EXW/FOB quotes, and treat DDP as complete only after checking what it excludes. The Incoterms 2020 definitions decide who owes each leg (International Chamber of Commerce, accessed November 2026). Comparing unit prices across Incoterms compares different journeys — the cheapest-looking quote costs the most.

Should I just pick the lowest quote per unit? No — unit price ignores tooling, freight, duty, MOQ fit, payment timing, and the supplier's actual reliability. Price those rows into landed cost per unit and the ranking frequently flips: the worked example above has the $6.40 quote lose to $7.30 by a full dollar per unit landed. Pick on landed cost plus the reorder rows, not the invoice line.

How do I account for tooling costs in a quote comparison? Amortize them over the volume you realistically expect to buy across orders, and use the same horizon in every supplier's column. A $1,850 plate is $0.19 per unit over 10,000 units and $3.70 over the first 500 — the same tooling, a nineteenfold difference in per-unit cost, and the denominator you choose can flip the entire comparison.

What matters more: price, MOQ, or lead time? For a reorderable product, fit matters first: an unsellable MOQ and a lead time your reorder point can't absorb make any price irrelevant. Score landed cost as the largest weight, then lead-time reliability and MOQ against your demand, then payment terms. Quote-level lead times are unproven — measure actual lead time from PO history before trusting quoted numbers.

When should I reject all the quotes? When they don't line up on the same spec, when the spread between them is too small to fund tooling on any of them, or when every "included" hides a row nobody will state in writing. Rejecting is cheap; re-running the RFQ with a sharper spec beats discovering after delivery that two suppliers quoted different products.

Next step

Take your three most recent quotes and build the worksheet for them today — even half-filled, the blank rows show you what you don't know. Then, before awarding the order, check the winner's MOQ against how many days of cover you actually need, so the cheapest landed unit doesn't arrive attached to a year of unsellable stock.