Blog · Procurement and supply chain · Procurement
Price comparison analysis puts supplier quotes on a common requirement and commercial basis. Compare order quantities, discounts, freight, and coverage exceptions before choosing an offer.
Price comparison analysis compares complete supplier offers for the same requirement, rather than ranking the unit prices printed on their quotes. Start with reviewed product equivalence, calculate what each offer requires you to buy, and include discounts and delivery charges on a consistent basis.
Write down the approved specification, receiving location, required quantity, delivery date, and acceptable substitutions before opening the quote comparison. State the currency and treatment of tax, installation, freight, and other charges. This gives the buyer a stable question to answer.
The federal price-analysis guidance distinguishes examining a proposed price from evaluating the supplier's separate cost elements and profit. The same distinction is useful here: the task is to compare offers, not reconstruct a supplier's manufacturing economics. For the separate method, see cost versus price analysis in procurement.
When quotes use different packs or units, complete the supplier unit-comparison method first. This article assumes equivalence and conversions have already been reviewed.
Use one row per supplier and requested item, retaining the quote number and version. Include requested quantity, quoted unit, approved reference unit, minimum order, order multiple, unit price, discount conditions, freight, other charges, expiration date, delivery commitment, and a coverage status.
Keep commercial conditions beside the figures. An early-payment discount is not unconditional savings. A freight estimate is not a confirmed delivered price. An expired offer needs supplier confirmation before it can support a current purchase decision.
Federal simplified-acquisition evaluation guidance favors competitive quotations where possible and explicitly addresses minimum quantities exceeding requirements. These are useful comparison disciplines for a private buyer; the federal procedure itself does not govern this example.
A Wisconsin distributor needs 1,000 identical replacement seals. The three offers below meet the reviewed specification and delivery requirement. All amounts are USD; tax is excluded consistently, discounts are unconditional, and no other charges apply. Prices are quoted per seal.
| Supplier | Required units | Minimum units | Order multiple | Unit price (USD) | Discount | Freight (USD) |
|---|---|---|---|---|---|---|
| Alder | 1,000 | 500 | 100 | 5.00 | 2.00% | 150 |
| Beacon | 1,000 | 1,200 | 100 | 4.60 | 0.00% | 100 |
| Cedar | 1,000 | 500 | 100 | 5.10 | 1.00% | 0 |
With these columns in A:G, calculate order quantity in H2:
=CEILING(MAX(B2,C2),D2)
Calculate gross merchandise in I2:
=H2*E2
Calculate discount dollars in J2:
=I2*F2
Calculate total outlay in K2:
=I2-J2+G2
Calculate excess units in L2:
=H2-B2
Calculate outlay per required unit in M2:
=K2/B2
Fill the formulas down for each supplier. The quantity formula assumes orders must be a whole multiple of the stated increment and at least the minimum. Confirm that interpretation against the quote; some suppliers define increments differently.
Comparable purchase outlay = Allowed order quantity × Unit price − Eligible discount + Included charges
| Supplier | Order units | Gross merchandise (USD) | Discount (USD) | Freight (USD) | Total outlay (USD) | Excess units | Outlay / required unit (USD) |
|---|---|---|---|---|---|---|---|
| Alder | 1,000 | 5,000 | 100 | 150 | 5,050 | 0 | 5.050 |
| Beacon | 1,200 | 5,520 | 0 | 100 | 5,620 | 200 | 5.620 |
| Cedar | 1,000 | 5,100 | 51 | 0 | 5,049 | 0 | 5.049 |
Cedar's outlay is $5,100 − $51 + $0 = $5,049. Alder's is $5,000 − $100 + $150 = $5,050. Cedar is lower by $1 under these exact assumptions. Beacon has the lowest quoted unit price but requires $5,620 of cash and leaves 200 units beyond the immediate requirement.
The last column deliberately divides by required units, not purchased units. It measures cash needed to satisfy this request. It does not claim the excess seals are worthless or establish inventory accounting cost. Display that ratio to three decimals here so rounding does not hide Cedar's narrow advantage; calculate with full precision.
Change only Cedar's freight from $0 to $50. Its total becomes $5,100 − $51 + $50 = $5,099, so Alder is now lower by $49. A small unresolved delivery charge matters more than the apparent precision of the initial ranking.
Do not invent a holding-cost rate to penalize Beacon. If finance has an approved inventory-carrying assumption, show that as a separate scenario with its own period and inputs. Keep the quoted purchase outlay intact so reviewers can distinguish supplier terms from internal estimates.
For historical evidence behind a negotiation, use purchase price analysis. After ordering, compare the invoice with the agreed terms through the contracted-price review.
For every offer, check that gross merchandise less discounts plus included charges equals the total. Independently compare that total with the supplier's quoted total and explain any difference. Confirm that every requested item has a price, reviewed unit conversion, and an explicit treatment of freight.
With a multi-item request, do not add only the lines a supplier happened to quote and call that a complete offer. Show covered and missing requirement lines. If a split award is permitted, calculate the freight and minimums for the actual split rather than reusing full-order assumptions.
Bring your supplier quote workbook and requirement list, or a Google Sheet with the same fields. Covirage maps the columns; its tools compute quote totals and check coverage, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for procurement teams for the purchasing context.
Show both, but use the complete required purchase to compare cash outlay. A low unit price can require excess inventory or exclude freight. Identify the demand quantity, actual order quantity, eligible discounts, and included charges before deciding which offer costs less.
A minimum order can force the buyer to purchase more than the immediate requirement. Calculate the allowed order quantity and display the excess separately. Do not assume excess units will be consumed or assign them a future value without an approved basis.
No. A missing line or unspecified freight charge is an unresolved cost, not a zero amount. Compare the covered scope separately, request the missing information, and keep the offer out of a complete-basket ranking until its coverage is clear.