# Bid tabulation and leveling template

Excel workbook with live formulas: https://os.construction/templates/bid-tabulation-template.xlsx

**Bid package:** ______________________  
**Bid date:** ______________________  
**Estimator:** ______________________  
**Budget for package:** ______________________  

## Bid tab (sample lines)

| Scope item | Estimate / budget | Plug used | Bidder 1 price | Bidder 2 price | Bidder 3 price | Bidder 1 leveled | Bidder 2 leveled | Bidder 3 leveled |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Storefront system, level 1 lobby | $410,000 | $396,500 | $404,000 | $396,500 | $425,500 | $404,000 | $396,500 | $425,500 |
| Curtain wall, east elevation | $690,000 | $671,000 | $702,000 | $709,000 | $671,000 | $702,000 | $709,000 | $671,000 |
| Fire-rated glazing, stairs 1 and 2 | $145,000 | $139,500 | $152,000 |   | $139,500 | $152,000 | $139,500 | $139,500 |
| Interior glass partitions, level 2 | $220,000 | $214,000 | $214,000 | $238,000 | $231,000 | $214,000 | $238,000 | $231,000 |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |

## How to use it

1. Break the package into the scope lines you want every bidder to price, from your bid form or scope sheet, with your estimate for each.
2. Enter each bidder’s price per line and mark the scope Included, Excluded or Qualified from their proposal, exclusions and clarifications.
3. Check the plug for each excluded line. By default it is the lowest price another bidder included; type an override when you have a takeoff or quote that is better.
4. Compare the leveled totals and ranks, then the non-price rows: addenda acknowledged, bonding, prequalification, lead time and qualifications.
5. Write how you leveled into your recommendation and carry the leveled scope into the subcontract, so the gap you priced doesn’t come back as a change order.

Template by os.construction: https://os.construction/resources/templates/bid-tabulation. Sample rows are illustrative; your contract and specifications govern.
