How to level subcontractor bids (and why the low bid usually isn't)
Every estimator has lived this: five electrical bids land in the last 20 minutes before your bid is due, the spread is 12%, and the low number is from a sub who "didn't see" the trenching, excluded permits, and wrote "fire alarm per plans — see clarifications" in the fine print. If you carry that number, you've just bought the scope gap. Bid leveling is how you catch it. The free bid leveling template above turns that scramble into a repeatable process: list the scope, flag what each bidder included, plug the holes, and rank the leveled totals.
What is bid leveling?
Bid leveling (also called scope leveling, bid analysis, or building a leveled bid tab) is the process of putting competing subcontractor or supplier bids on an equal-scope basis before you compare price. GCs level sub bids to pick who to carry in their own number and who to award. Subcontractors level supplier and lower-tier bids — gear, fixtures, fire alarm, insulation, controls — the same way.
The core idea is simple: you can't compare prices until you compare scope. A bid that excludes $40,000 of work isn't $40,000 cheaper — it's the same price with a $40,000 problem attached.
The bid leveling process, step by step
- Build the scope list before bids arrive. Break the package into items a bidder can include or exclude: equipment, rough-in, trim, testing, temp power, trenching, permits, pads, closeout docs. Pull them from your spec sections and your own takeoff. The template ships with twelve example electrical scope items you can overwrite for mechanical, plumbing, concrete, steel, or any trade.
- Set a plug value for each item. This is your number for that scope — from your estimate, budget, or a historical unit cost. It's what you'll add to a bid that leaves the item out.
- Read every bid letter line by line. Mark each scope item Included, Excluded, or Clarify for each bidder. Exclusions hide in qualifications, "by others" notes, and the last paragraph of the proposal.
- Enter base bids as submitted. Don't adjust the number yourself — the sheet adds the leveling adjustments so there's an audit trail.
- Carry alternates consistently. Only carry alternates you intend to accept, and carry them for every bidder.
- Close the clarifications. Call or email each bidder on every Clarify item. Once they answer, flip it to Included or Excluded so the leveled total is real.
- Rank and award. The sheet ranks leveled totals, shows how far each bidder is over the low leveled bid, and compares to your budget. Then weigh the non-price factors — bond, addenda, schedule, lead times — before you award.
How the leveling math works in this template
| Row | What it does |
|---|---|
| Level Adj $ (per scope item) | =plug if Excluded, plug × Clarify Carry % if Clarify, otherwise 0. |
| Adjustments to level | Sum of that bidder's adjustments — the cost of the scope they left out. |
| Leveled total | Base bid + adjustments + alternates carried. |
| Rank | RANK of the leveled total, 1 = lowest. |
| Over low leveled bid | Dollar gap between each bidder and the low leveled bid. |
| Over / (under) budget | Leveled total minus your budget or engineer's estimate. |
| Low leveled bid callout | Names the low leveled bidder next to the low as-submitted bidder so you can see when leveling changes the winner. |
In the example data, Bidder 2 is low as submitted at $798,500 — but excluded trenching and permits and left fire alarm unclear. After leveling, Bidder 2 is the highest at $896,500, and Bidder 3 is low at $837,000. That swing is typical, and it's exactly why you level.
Common scope gaps to check on every bid
- Temporary power and lighting — often "by GC" in one bid and included in the next.
- Excavation, trenching, and backfill — especially site feeders and underground.
- Concrete housekeeping pads and equipment supports.
- Permits, inspection fees, and utility company charges.
- Low-voltage, fire alarm, and controls — frequently subbed out and qualified.
- Testing, startup, commissioning support, as-builts, and O&M manuals.
- Hoisting, lifts, and equipment rental.
- Overtime, phasing, and after-hours work.
- Bonds — a bid without a bond isn't comparable to one with it on a bonded job.
- Addenda — confirm every bidder acknowledged the latest addendum.
Comparing supplier quotes line by line
The second tab handles the material side: list the line items and quantities once, enter each vendor's unit price, and the sheet extends every line, finds the lowest price per line, and flags which vendor has it. It then ranks vendors on total delivered — material subtotal plus freight and other charges like cut, reel, or fuel fees. A "best line-by-line" total shows what you'd pay if you cherry-picked; if it's well below the low vendor's total, ask that vendor to match the outlier lines instead of splitting the order.
Always record quote valid-until dates. Copper wire, switchgear, and transformer pricing can move weekly, and a quote that expires before award is a number you can't hold.
From leveled bid to budget
Once you've awarded, the leveled number becomes a subcontract or PO — and that's where spreadsheets start to break. The sub's number needs to land in your job budget by cost code, change orders need to trace back to the original scope, and invoices need to be checked against what was bought. Field PM keeps subcontracts, purchase orders, vendor invoices, change orders, and job cost in one place, so the scope you leveled is the scope you track. Start a free 30-day trial — no credit card required.
Related free templates and calculators
- Estimate Recap & Bid Proposal template — roll leveled sub numbers into your own bid with overhead, profit, and bond
- Markup vs. margin calculator — set your markup on sub costs without confusing it with margin
- Schedule of Values template — break the awarded contract into billable lines
- Change Order template — price scope that falls outside the leveled bid
- Browse all free construction templates
