A supplier quote comparison template puts each vendor's offer on the same basis: the same item specification, quantity, currency and delivery requirement. Record the quoted price, add charges you will actually pay, and check how many usable units the order is expected to produce. Then compare delivery dates and payment commitments before choosing a supplier.
For a boutique first order, a supplier’s 12-unit case pack may force a change to a plan of five units per size-and-color variant. Recalculate the units and total cash commitment before comparing the final quotes. See the opening boutique inventory example for the assortment decision; the 500-unit quote comparison below is a separate fictional scenario.
The lowest unit price can lose once freight and quality losses are included. The lowest calculated cost can also lose if the shipment arrives after your selling window. This guide gives you a copyable comparison structure and a worked example for a small business buying packaging, materials or finished goods.
Put every quote on the same basis
If you need to track receipts and stock alongside quotes, read the inventory software without subscription guide. The boutique inventory spreadsheet guide shows how small retailers can record items by variant.
Before building the table, send suppliers one short purchasing brief. Include the item dimensions, material or grade, acceptable substitutions, units per pack, order quantity, delivery address and required arrival date. Attach the same drawing or sample reference to each request. A quote for a lighter box is not directly comparable with one for the box you actually specified.
Keep the quote number, version, date and expiry beside the supplier name. If a supplier revises freight in an email, save that message and update the comparison version. Otherwise, the price you approve may not be the price on the eventual purchase order.
Normalize units first. A $24 case of 12 items is $2 per item; a $22 case of 10 is $2.20 per item. Those conversions do not make the materials equivalent: confirm their specifications separately. For different currencies, record the conversion rate, date and any applicable conversion fee rather than mixing currency symbols in one total.
A supplier quote comparison template you can copy
Use one column per supplier for a single item. For a multi-item purchase, use a separate line per item and an additional order-level summary. Copy this structure into your working document or spreadsheet; it is an on-page template, not a downloadable software file.
| Field | What to enter | Question to resolve |
|---|---|---|
| Supplier and quote reference | Name, quote ID, date, expiry | Is this the latest valid offer? |
| Specification and unit | Item, grade, size, pack quantity | Are all offers for an equivalent item? |
| Quantity and unit price | Units ordered, price per unit | Does the price require a larger minimum order? |
| Goods subtotal | Quantity × unit price, less confirmed discounts | Are the discount conditions achievable? |
| Additional charges | Freight, handling and other applicable charges | Which charges are included, excluded or still unknown? |
| Usable quantity assumption | Expected accepted units and evidence | Is this a measured history or a planning assumption? |
| Timing | Dispatch date, transit, usable-receipt date | Does it meet the actual deadline? |
| Payment schedule | Deposit basis, balance, due dates | Can you fund each payment when it falls due? |
| Decision and conditions | Selected offer, reasons, outstanding confirmations | What must be confirmed before the PO is released? |
A structured comparison is also the approach used in Wrike's cost-comparison guide. Our example below adds a specific distinction that matters for physical goods: the amount paid for an order is different from the cost of each accepted unit.
Worked example: three quotes for 500 units
Assume a small shop is considering an order of 500 identical packaging units in USD. All three offers meet the material specification. Freight and handling are separately charged. The example contains no other charges; in a real comparison, add every applicable charge rather than assuming this simplified cost structure applies.
Reject percentages below are fictional planning assumptions, not supplier performance claims. No credit, replacement or recovery value is assumed for rejected units.
| Input or result | Supplier A | Supplier B | Supplier C |
|---|---|---|---|
| Ordered units | 500 | 500 | 500 |
| Quoted unit price | $2.00 | $2.12 | $2.25 |
| Goods subtotal | $1,000 | $1,060 | $1,125 |
| Freight | $180 | $90 | $40 |
| Handling | $20 | $20 | $10 |
| Total modeled order cost | $1,200 | $1,170 | $1,175 |
| Assumed rejected share | 5% | 2% | 1% |
| Expected accepted units | 475 | 490 | 495 |
| Cost per accepted unit | $2.53 | $2.39 | $2.37 |
| Usable receipt after order | 14 days | 10 days | 21 days |
The calculation is total modeled order cost ÷ expected accepted units. Supplier A is $1,200 ÷ 475 = approximately $2.5263 per accepted unit. Supplier B is $1,170 ÷ 490 = approximately $2.3878. Supplier C is $1,175 ÷ 495 = approximately $2.3737. Displayed currency values round to cents; the comparisons use the unrounded results.
Supplier A has the lowest quoted unit price but the highest modeled cost per accepted unit. Supplier B has the lowest total outlay. Supplier C has the lowest modeled cost per accepted unit, although its advantage over B is small and depends on the quality assumptions.
Apply the deadline before choosing a winner
If the shop needs its initial delivery within 14 days and can accept the modeled quantity shortfall, Supplier C fails the timing requirement. Supplier B is the lower-cost eligible option on these assumptions. That is a conditional decision, not an automatic recommendation for every purchase.
Use pass/fail checks for non-negotiable requirements. A weighted score should not allow a low price to compensate for a failed specification or missed event date. Compare softer preferences, such as response speed, only after the eligible offers are identified. Smartsheet's vendor-assessment guide provides a broader framework for considering supplier capability as well as cost.
To decide when to start the next purchase, use your reorder point and lead-time calculation. The comparison answers which offer fits; the reorder point helps answer when to act.
Keep deposits separate from the purchase cost
A deposit changes the timing of cash payments. It does not add a second purchase cost. If Supplier B requires 30% of its $1,060 goods subtotal upfront, the deposit is $318 and the goods balance is $742. Freight and handling add $110 under the stated example. Total payments remain $1,170, not $1,488.
Ask whether a quoted deposit percentage applies to goods alone or the entire invoice. Write down when freight is due and whether a discount depends on early payment. Do not assume that net terms or an offered discount are available until confirmed.
Handle unknowns without false precision
If freight is pending, mark the offer incomplete. If rejection history is unavailable, compare a no-reject case with a clearly labeled stress case rather than inventing a precise rate. Do not both reduce accepted quantity and add the full purchase value of those same rejected units again: the original order cost already includes paying for them. Add genuine extra inspection, disposal or replacement expenses separately when relevant.
This landed-purchase comparison is not a complete lifetime cost model. Equipment purchases may also involve installation, maintenance and operating costs. SpecLens's total-cost-of-ownership tool illustrates that broader scope. Choose a consistent time horizon before comparing those costs.
Keep the approved quote connected to the order
Before releasing the PO, carry the approved quote number and version, specification, tracking unit, ordered quantity, confirmed charges, delivery date and payment schedule into the order record. Assign a PO number and preserve the accepted terms beside it. Use the purchase order tracker and partial-delivery example to record accepted receipts, cancellations and the outstanding balance against that same order.
In the fictional Supplier B comparison, the quote covers 500 ordered units with a modeled total outlay of $1,170. The 490 expected accepted units are a planning assumption, not a receipt. Start the PO with 500 ordered and zero accepted; update accepted quantities only after inspection. Resolve any requirement for 500 usable units before approval.
Try the free Supplier Quote Comparison planner with sample offers, then read the VendorPulse setup and user guide if you need the broader local purchasing workflow.
Save a decision note: quantity, quote version, confirmed charges, selected supplier, reasons and remaining conditions. When the delivery arrives, compare actual freight, accepted units and receipt date with the assumptions. That creates evidence for the next buying decision.
If these records are spread across separate files, review VendorPulse OS for supplier quotes, landed costs and purchase orders. Its product page describes an offline browser app that connects purchasing records, partial deliveries, quality issues and supplier scorecards. It is a paid HTML application, not the free spreadsheet mentioned by some comparison-template sites. Check its preview against your workflow before buying.
Common questions
Do I always need three supplier quotes?
No universal number fits every purchase. Follow your own purchasing requirements and seek enough comparable offers to make an informed decision. Two complete offers can be more useful than three incompatible ones.
Can I build the comparison in Excel or Google Sheets?
Yes. Use consistent units, separate input and calculated fields, and protect formulas from accidental edits. Keep the source quotes alongside the working file.
Should I automatically choose the cheapest accepted-unit cost?
No. Confirm specification, usable quantity, timing, payment commitments and uncertainty first. A small modeled saving may disappear if the assumptions change.
Start with one real purchase and fill every unknown before issuing the order. Then use the completed comparison and receipt record as your baseline for the next quote.
Evaluate deliveries after purchase with the supplier scorecard worked example.
Separate this accepted-unit example from the free worksheet
The worked example above adjusts for expected accepted units. The free Supplier Quote Comparison worksheet calculates ordered quantity times unit price plus entered freight and fixed fees. It does not calculate a rejection rate or cost per accepted unit. Keep that extra quality calculation in your comparison record rather than assuming the worksheet reproduces every measure in this article.
After approval, put the agreed deposit and balance dates into the weekly cash planner. The quote's full cost remains one purchase; splitting its payment dates does not increase its value. Update physical stock only after the delivery and acceptance checks.