How to Compare Supplier Quotations: A Step-by-Step Guide

Whether you're evaluating electrical panels against a construction BOQ, components against a manufacturing BOM, or bulk goods on a trade purchase order, the job is the same: turn a stack of inconsistent supplier quotes into one fair, defensible decision. Here's the method procurement teams use — and the traps to avoid.

Step 1 — Standardise the line items

Suppliers describe the same thing differently: "60×60 LED Panel", "LED Panel 600×600", and "Recessed panel 60/60" are one item. Before any numbers matter, map each supplier's lines onto a single master list so every row means the same thing across all vendors.

• Construction: use the BOQ as the master list; align each vendor's items to the BOQ description.
• Manufacturing: use the BOM / RFQ part numbers as the anchor.
• Trade: use SKU or product spec (grade, size, packaging).

Group the rows into sections (e.g. "Main boards", "Cabling", "Accessories") so the sheet reads logically and subtotals mean something.

Step 2 — Normalise units, quantity, currency and tax

This is where comparisons quietly go wrong. Before totals can be compared, put everything on the same basis:

• Units & quantity: convert to one master unit (e.g. metres vs linear-metres) and one master quantity per row.
• Currency: choose one reporting currency and convert every foreign quote at a fixed exchange rate — and record the rate and date on the sheet. A quote in a high-denomination currency looks enormous until converted.
• Tax: decide whether you're comparing ex-VAT or VAT-inclusive, and treat every vendor the same way. Mixing the two flatters whoever quoted ex-tax.

Step 3 — Build the comparison sheet

Lay out one column pair per vendor (unit rate and line total), with the master item, unit and quantity on the left. Then add the summary rows that turn raw prices into a decision:

Every total should be calculated as unit rate × master quantity — never copied from the vendor's own total if their quantity differs from yours.

Step 4 — Look beyond price

The cheapest quote is rarely the best deal. Capture the factors that decide real value, per vendor:

• Delivery / lead time — a 3-month vendor may beat a 7-month one even at a higher price.
• Payment terms — advance %, credit, milestones.
• Scope completeness — items not quoted are hidden cost; a "cheap" vendor missing 10% of the scope isn't cheap.
• Quality / brand / certification — tier-1 OEM vs unbranded.
• Risk — offer validity, FX exposure, single-source dependence.

Step 5 — Rank objectively with weighted scoring

Turn those factors into a defensible ranking. Assign weights that reflect your priorities and score each vendor 0–100 on each criterion:

The weighted total gives you a rank — and a clear, documented reason the winner won. Change the weights (e.g. weight delivery higher on an urgent project) and the ranking updates transparently. Price is a 60% input, not the whole story.

Step 6 — Document the recommendation

Finish with a short, plain-English recommendation: who you're recommending, why (price standing + weighted score + delivery), and the one caveat to confirm before award (e.g. an expiring offer or an unconverted-currency risk). That paragraph is what gets sign-off — and what protects you if the decision is ever questioned.

Skip the manual sheet — generate it from your quotes

Want the whole structure above — master items, per-vendor unit/total columns, section subtotals, tax and savings rows, and a weighted-scoring block — without building it by hand? That's exactly the two-sheet Excel workbook Nazmiq (nazmiq.com) produces automatically from your uploaded quotes. Create a free account and export your first comparison in minutes.

Start free at nazmiq.com →  3 comparisons every month, no credit card.

Frequently asked questions