Constructelligence
Template · bidding

Construction bid template: base bid, alternates, unit prices and exclusions — free Excel

A bid is the price you put in front of an owner or general contractor — and the scope that price covers. Bids are lost on price, but more often they are lost because they cannot be compared: the alternates are buried, the allowances are missing, and the exclusions sit in a paragraph nobody reads. This template lays a bid out the way the person leveling it reads it: base bid items that add up to the number on the bid letter, alternates and unit prices on their own rows, and each exclusion against the item it qualifies.

Updated · 7 minute read

Key takeaways
  • Base bid items add up to the number on the bid letter.
  • Alternates, allowances and unit prices on their own rows.
  • Exclusions against the item they qualify.
  • Price from the estimate and your overhead, not from the market alone.

What a construction bid has to state

A filled-in example

Metro Interiors' drywall bid for Maple Street Medical Office:

ItemDescriptionTypeQtyUnit priceTotal
1Partitions incl. framing, Level 4Base bid14,200 SF$4.10$58,220
2Level 5 at lobby feature wallBase bid820 SF$6.25$5,125
3Blocking allowanceAllowance1 LS$6,500$6,500
4Framing above 10 ft, floor 2 corridorAdd alternate2,600 SF$3.40$8,840
5Additional board, per SFUnit price1 SF$3.95—

The base bid is items 1–3: $69,845. The alternate and unit price are priced but not in that number — a bid that rolls them in can't be compared with the others and usually gets a call, or gets dropped.

CalculatorBid price from cost

Pricing the bid

Bid = cost × (1 + overhead) × (1 + profit) × (1 + bond & insurance)

Start from the estimate, not from what you think the job will go for. Then check the result against your own break-even: the overhead recovery calculator shows the margin a bid has to carry to cover the office.

How to fill it in

  1. Enter base bid items first, matching the owner's bid form or the scope of work item numbers.
  2. Add alternates, allowances and unit prices on their own rows with the right Bid type.
  3. Filter Bid type = Base bid to check the total equals the price on your bid letter.
  4. Write exclusions and clarifications against the item they qualify, not only at the bottom.
  5. Export to PDF with your cover letter.
Checklist
Construction bid template in Excel, filled in with example rows — columns: Bid item, Description, Bid type, Quantity, Unit, Unit price, Total, Exclusions / clarifications
The construction bid template as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Construction bid template (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

Everything a bid has to state so it can be compared and accepted without a phone call: each bid item, whether it is base bid, an alternate, an allowance or a unit price, quantity, unit price and total — and the exclusions and clarifications that qualify it.

8 columns: 6 you fill in, 1 picked from drop-down lists, so every row uses the same values and 1 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 2 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
Bid itemTextItem number matching the bid form or the scope of work.
DescriptionTextWhat the line is, in words the other party will recognise.
Bid typeDrop-downBase bid items add up to the bid; alternates, allowances and unit prices are priced separately. Options: Base bid / Add alternate / Deduct alternate / Allowance / Unit price.
QuantityNumberEnter a number.
UnitTextUnit of measure (EA, LF, SF, CY, HR, LS).
Unit priceAmount ($)Price per unit; for lump-sum items use quantity 1 and unit LS.
TotalCalculatedCalculated: [Quantity] × [Unit price]
Exclusions / clarificationsTextWhat the price does not include, or assumes — the line that prevents disputes later.

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

What should be included in a construction bid?

The base bid broken into the items requested, any alternates, allowances and unit prices, the exclusions and clarifications, the schedule or duration assumed, how long the price is valid, and any bond or insurance included.

What is the difference between a base bid and an alternate?

The base bid is the price for the project as designed. Alternates are separately priced changes the owner may accept or reject — an add alternate increases the price, a deduct alternate reduces it.

How do contractors calculate a bid price?

From the estimated cost of the work, plus a share of company overhead, profit, and bond and insurance costs — then checked against market conditions and how much the company needs the work.

What is a unit price in a construction bid?

A rate per unit for work whose quantity is unknown at bid time, such as rock excavation per cubic yard. The owner pays the rate for the quantity actually performed.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.

More in Templates & forms

All templates & forms resources →