Bid Levelling: How to Compare Supplier & Subcontractor Quotes

Estimators call it bid levelling. Procurement calls it a bid tabulation or quote comparison. Whether you're levelling subcontractor quotes for a trade package against a construction BOQ, components against a manufacturing BOM, or bulk goods on a trade purchase order, the job is identical: turn a stack of inconsistent tender returns into one fair, defensible award. Here's the method estimators, contract administrators and procurement teams use — and the traps that quietly cost you margin.

Step 1 — Level the line items onto one scope

Bidders 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, level each bidder's lines onto a single master scope so every row means the same thing across all of them — that is what makes the comparison apples-for-apples.

• Construction: use the client-supplied BOQ or pricing schedule as the master scope; level each subcontractor's items to the BOQ description, one trade package at a time (earthworks, joinery, electrical).
• 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 rates, quantities, units, currency and tax

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

• Units & quantities: convert to one master unit (e.g. metres vs linear-metres) and one master quantity per row, so unit rates are genuinely comparable.
• 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 levelled breakdown

Lay out one column pair per bidder (unit rate and line total), with the master item, unit and quantity on the left. Where a bidder has priced a lump sum against a group of items, show it as a lump sum on the section row rather than spreading invented rates. 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 bidder's own total if their quantity differs from yours. Keep the breakdown auditable: anyone reopening it months later should be able to recompute every figure from the rates and quantities on the sheet.

Step 4 — Capture inclusions and exclusions

This is the step that decides whether the award holds. The cheapest quote is rarely the cheapest outcome — it is usually the one that excluded the most. For every bidder, record explicitly what is included and what is excluded, then the commercial factors around it:

• 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 / exclusions — items not priced are hidden cost. A bidder missing 10% of the package isn't 10% cheaper; you will buy that scope later at a variation rate, straight out of your margin.
• 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 award 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 (an expiring offer, an unpriced item, a currency exposure). That paragraph is what gets sign-off from the delivery team — and what protects you and your margin if the award is ever questioned.

Skip the manual levelling — generate it from your quotes

Want the whole structure above — master scope items, per-bidder rate/total columns, section subtotals, exclusions flagged, tax and savings rows, and a weighted-scoring block — without building it by hand? That's exactly the two-sheet Excel breakdown NazmIQ (nazmiq.com) produces automatically from your uploaded tender returns. Create a free account and level your first package in minutes.

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

Frequently asked questions