🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Construction Management / Estimating › Procurement in Construction Management › Lesson 6
BUS-CONS57-05 · Lesson 6 · 15.5 clock hours · lab

Bid Leveling and Best-Value Analysis

Objective. Students will complete a bid-leveling spreadsheet for five competing masonry subcontractor bids, adjust for scope differences, and select the best-value bidder with a written award recommendation.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

What Is Bid Leveling?

When you invite multiple subcontractors to bid on the same scope of work, you rarely receive bids that are truly identical. One bidder may exclude a line item, another may include an allowance you did not ask for, and a third may price a task differently than the rest. Bid leveling (also called bid normalization) is the process of adjusting each bid so that every one covers exactly the same scope before you compare prices. Without leveling, you risk awarding a contract to a bidder whose low number is low only because they left something out—a mistake that creates costly change orders later.

Why Scope Differences Happen

Subcontractors read bid documents differently. A masonry sub may assume the general contractor will furnish scaffolding, while another prices it themselves. One may read the specification and include sealant at control joints; another may consider sealant a separate trade. These are not errors of bad faith—they reflect genuine ambiguity or different trade customs. Your job as an estimator or project manager is to find every discrepancy and put a dollar value on each one.

Common sources of scope differences in masonry bids include:

Building the Bid-Leveling Spreadsheet

A bid-leveling spreadsheet, often called a bid tab, lists every subcontractor across the top and every scope item down the left column. The steps below describe the standard workflow.

Step 1 – Enter raw bid totals. Record each subcontractor's base bid exactly as submitted.

Step 2 – List all scope items. Read every bid carefully and list every line item or exclusion you find in any bid. If Sub A mentions scaffolding and no one else does, scaffolding becomes a row for everyone.

Step 3 – Color-code discrepancies. Mark each cell where a bidder's scope differs from the project baseline. A common convention: yellow for an item the bidder excluded, green for an item they added beyond baseline scope. This visual layer lets reviewers spot problems immediately.

Step 4 – Apply dollar adjustments. For each discrepancy, assign an adjustment using a reliable source—your project's own unit-price reference sheet, a published cost database, or a quantity takeoff. Add the cost to a bidder who excluded an item; subtract the cost from a bidder who included something extra. The goal is an adjusted (leveled) total that represents what each sub would cost if they all bid the identical scope.

Step 5 – Verify arithmetic. Every addition and subtraction must be double-checked. A sign error—adding when you should subtract—can flip your recommendation. In practice, a second reviewer or the instructor independently verifies the math.

Best-Value Analysis: Beyond the Lowest Number

The best-value approach considers price alongside non-price factors. Price is usually weighted most heavily, but the following factors matter and must be addressed in your award recommendation:

Weigh these factors explicitly. If the lowest leveled bid comes from a sub with no bond available and poor references, the second-lowest leveled bid from a well-qualified sub may be the best value.

Writing the Award Recommendation Memo

The recommendation memo is the formal deliverable that goes to the project owner or senior management. Keep it to one page. Include:

1. A summary leveled bid tab showing raw bids, adjustments, and adjusted totals

2. The name of the recommended subcontractor and their adjusted price

3. A brief explanation of each significant adjustment

4. A discussion of non-price risk items for the recommended sub and any concerns about other bidders

5. Your conclusion and recommended action

Write in plain language. Decision-makers who are not estimators must be able to follow your reasoning.

Safety Considerations

Bid leveling is an office task, but the scope items you are pricing involve real field hazards. When evaluating masonry bids, confirm that subcontractor pricing reflects compliant safety practices:

An award recommendation that ignores safety compliance exposes the project owner and general contractor to regulatory liability and workers to harm.

Key terms9

Bid LevelingThe process of adjusting competing subcontractor bids to a common, identical scope so that prices can be compared on an apples-to-apples basis.
Bid TabA spreadsheet that lists all bidders across the top and all scope line items down the side, showing raw bids, adjustments, and adjusted totals in one view.
Scope GapAn item included in the project baseline scope that a bidder omitted from their proposal, requiring a positive dollar adjustment to normalize the bid.
AllowanceA lump-sum amount included in a bid for an item whose final cost is uncertain; it is a placeholder that will be reconciled to actual cost later.
Alternate Unit PriceA price per unit of measure (e.g., per square foot of brick) submitted alongside a base bid, used to price changes in quantity during the project.
Best-Value AnalysisAn evaluation method that weighs price together with non-price factors such as schedule capability, bonding, and past performance to select the most advantageous bid.
Normalization AdjustmentA specific dollar amount added to or subtracted from a raw bid to account for a scope discrepancy, derived from unit-price reference data or a quantity takeoff.
PrequalificationA screening process in which a subcontractor provides financial, safety, and experience information before being allowed to submit a bid, reducing award risk.
Payment and Performance BondA surety instrument that guarantees a subcontractor will complete the work and pay their suppliers and laborers; its availability is a key risk factor in bid evaluation.

Worked examples4

1. Sub A's raw masonry bid is $148,000. Their proposal explicitly excludes sealant at control joints. The unit-price reference sheet shows sealant at $2.10 per linear foot. The project takeoff shows 620 linear feet of control joints. What is Sub A's adjusted bid?
  1. Calculate the sealant cost: 620 LF × $2.10/LF = $1,302.00
  2. Because Sub A excluded this item, add the adjustment to their bid: $148,000 + $1,302 = $149,302
Answer: Sub A's adjusted bid is $149,302.
2. Sub B's raw bid is $151,500. Their proposal includes a $3,800 scaffolding allowance. The project baseline assigns scaffolding to the general contractor, so scaffolding is NOT part of the masonry subcontract scope. What is Sub B's adjusted bid?
  1. Because Sub B included something outside the baseline scope, subtract the extra amount: $151,500 − $3,800 = $147,700
Answer: Sub B's adjusted bid is $147,700.
3. Sub C's raw bid is $145,200. They excluded sealant (same as Sub A: +$1,302 adjustment) AND included the $3,800 scaffolding allowance (same as Sub B: −$3,800 adjustment). What is Sub C's adjusted bid?
  1. Start with the raw bid: $145,200
  2. Add the sealant scope gap: $145,200 + $1,302 = $146,502
  3. Subtract the scaffolding extra: $146,502 − $3,800 = $142,702
Answer: Sub C's adjusted bid is $142,702.
4. After leveling, the five adjusted bids are: Sub A $149,302 | Sub B $147,700 | Sub C $142,702 | Sub D $153,000 | Sub E $148,950. Sub C is the lowest, but their bid references only show two prior masonry projects, both smaller than $80,000, and they cannot provide a performance bond. Sub B is the next lowest and is fully bondable with strong references on comparable projects. Which bidder represents best value, and by how much does their adjusted price exceed the low bid?
  1. Identify the lowest adjusted bid: Sub C at $142,702
  2. Identify the next-lowest adjusted bid: Sub B at $147,700
  3. Calculate the price difference: $147,700 − $142,702 = $4,998
  4. Evaluate non-price factors: Sub C cannot bond and has no comparable project experience; both are significant risk items on a project of this size. Sub B is bondable and has proven references.
  5. Conclude: Sub B is the best-value award despite costing $4,998 more than Sub C's adjusted price, because the bonding and experience risks associated with Sub C outweigh the cost savings.
Answer: Sub B is the best-value selection. Their adjusted bid exceeds the low bid by $4,998, a premium justified by bonding availability and demonstrated experience on comparable projects.
In class: Receive five fictional masonry bids that deliberately include scope differences (one excludes sealant, one adds an allowance for scaffolding, one lists an alternate unit price); identify every line-item discrepancy using a color-coded comparison grid · Add or subtract dollar adjustments to normalize each bid to an apples-to-apples scope, using the project's own unit prices from the estimating course reference data as adjustment sources · Prepare a one-page best-value recommendation memo that presents the leveled bid tab, names the recommended subcontractor, and addresses any risk items (schedule, bonding, references) noted in the evaluation
Materials: Five fictional bid packages, blank bid-leveling spreadsheet (Excel), unit-price reference sheet from estimating course, award recommendation memo template
Check: Leveled bid tab with all adjustments arithmetic-verified by instructor; adjustments within ±3% of instructor key; recommendation memo present with reasoning tied to data; 80% accuracy to pass

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Cost Management / Estimating
1. A subcontractor's raw bid is $200,000. They excluded $4,500 worth of masonry cleaning that is in the project baseline scope. What is their adjusted bid?
Cost Management / Estimating
2. A subcontractor includes a $6,000 scaffolding allowance in their masonry bid. The project baseline assigns all scaffolding to the general contractor. How should the bid-leveling spreadsheet treat this allowance?
Project Controls / Documentation
3. Which of the following best describes the purpose of color-coding a bid-leveling spreadsheet?
Risk Management / Procurement
4. In a best-value analysis, the lowest adjusted bid comes from a subcontractor who cannot provide a performance bond. What is the primary risk of awarding to this sub?
Cost Management / Estimating
5. Sub D's raw bid is $160,000. After normalization, two adjustments are applied: −$2,000 (removed an out-of-scope item) and +$800 (added a missing scope item). What is Sub D's adjusted bid?
Cost Management / Estimating
6. An alternate unit price submitted by a masonry subcontractor is best described as:
Risk Management / Procurement
7. When evaluating masonry subcontractor bids, a suspiciously low price compared to all other bids most likely signals:
Safety and Health / OSHA Compliance
8. Which OSHA concern should be reflected in a masonry subcontractor's bid pricing to demonstrate regulatory compliance?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.