Bid clarification register
Track tender questions, responsible reviewers, response deadlines, and reply dates before bid submission.
2 tabs · 186 formulas
Templates
Templates for both sides of a competitive bid. Owners and engineers tabulate the bids they receive and see the spread and the low bidder at once; general contractors level subcontractor quotes for scope gaps, build up a bid price from direct cost with overhead and profit, price a unit price bid schedule with alternates, and score whether a bid is worth pursuing at all.
Markup and margin are kept apart throughout, because confusing the two is the most common pricing mistake in a bid.
Track tender questions, responsible reviewers, response deadlines, and reply dates before bid submission.
2 tabs · 186 formulas
Bids submitted, won and lost, hit rates, weighted pipeline and margins by month, sector, estimator and bid size.
5 tabs · 3,845 formulas
Build a bid price from direct cost with job and home office overhead, contingency, profit, bond and insurance.
3 tabs · 87 formulas
Unit prices, extended totals, unbalanced-line flags, responsiveness and ranking for competing contractor bids.
4 tabs · 819 formulas
Pass-or-fail gates, weighted scores, expected profit and a bid log with hit rates by sector.
4 tabs · 258 formulas
Build a change-order amount from labor hours, labor rate, materials, equipment, and an entered markup.
2 tabs · 246 formulas
Estimate time-related and fixed preliminary site costs from duration in weeks, weekly rates, mobilization, and removal fees.
2 tabs · 246 formulas
Compare equipment rental offers including charged days, daily rates, delivery, and collection fees.
2 tabs · 246 formulas
Estimate a loaded hourly labor rate from base pay, entered burden percentage, fixed hourly benefits, and productive hours.
2 tabs · 186 formulas
Calculate work earned to date, retainage withheld, and current net payment due across schedule-of-values line items.
2 tabs · 246 formulas
Level subcontractor bids for scope gaps: each excluded or qualified item adds its plug value to the base bid.
3 tabs · 168 formulas
Base bid by section, with allowances, contingency, add and deduct alternates and a total contract amount.
4 tabs · 148 formulas