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:
- Sealant and caulking at control joints or window perimeters
- Scaffolding and shoring (owner-furnished vs. sub-furnished)
- Cleaning of finished masonry
- Grout and reinforcing inside CMU cells
- Allowances (a lump sum held for an uncertain item) versus a firm price
- Alternate unit prices submitted in addition to the base bid
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:
- Schedule capability – Can the sub mobilize on your start date? Do they have adequate crews?
- Bonding – Does the bid include a payment and performance bond, or is one available? A sub who cannot bond shifts financial risk to the owner.
- References and past performance – Have they successfully completed similar masonry scope? Calls to references are a standard due-diligence step.
- Financial stability – Prequalification documents, when available, provide credit and work-in-hand information.
- Risk items – An unusually low bid may signal a scope misunderstanding; an allowance for an uncertain item carries budget risk.
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:
- Scaffolding must meet OSHA scaffold standards. If a bid excludes scaffolding, confirm the GC's plan meets regulatory requirements before accepting that exclusion.
- Silica dust from cutting masonry is a serious respiratory hazard regulated by OSHA. Compliant subs should price wet-cutting methods or engineering controls; a suspiciously low bid may be cutting corners on dust control.
- PPE requirements—hard hats, safety glasses, gloves, high-visibility vests—should be reflected in the sub's general conditions, not omitted to lower price.
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?
- Calculate the sealant cost: 620 LF × $2.10/LF = $1,302.00
- 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?
- 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?
- Start with the raw bid: $145,200
- Add the sealant scope gap: $145,200 + $1,302 = $146,502
- 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?
- Identify the lowest adjusted bid: Sub C at $142,702
- Identify the next-lowest adjusted bid: Sub B at $147,700
- Calculate the price difference: $147,700 − $142,702 = $4,998
- 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.
- 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.
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.