ALDOCHANDRA Start a build

Underwriting worksheet — No. 10


Contractor bid analyzer

Enter a contractor's line items and the bid gets read back against regional trade averages — which lines are fair, which are padded, and what number to ask for instead.

Basis of estimate
Regional trade averages, planning grade
Leading measure
Total potential saving on flagged lines
Prepared by
Aldo Chandra, Philadelphia PA

Total potential saving

--

--

The amount priced above the regional average on the flagged line items. That is the money on the table before you sign, and everything below is the arithmetic behind it.

Supporting measureThis bid
Bid as quoted --
Regional average --
Over or under average --
Line items flagged-- --
01

Project basis

Region sets the cost table every line is measured against.

Line itemAssumption

Reference figure for scoping. Each line item carries its own quantity below.

02

Schedule of bid line items

Add or remove lines; every figure on this page restates immediately.

Line itemQuoted
03

Bid reconciliation

All figures rounded to the dollar.

ItemAmount
Bid as quoted--
Less regional average--
Over or under average--

Verdict

MeasureReading
Overall rating--
Variance vs average--
Lines flagged to negotiate--
Saving at 10% above average--
04

Line by line

Bid against average, per line, with the rating that follows.

05

Where the money sits

Share of the quoted bid by category.

06

Negotiation cheat sheet

Lines more than 15% above average, and the number to counter with.

Regional averages are planning benchmarks, not quotes. Real pricing moves with scope, access, permits, material grade, and how busy your trades are. Verify every number with local bids before you sign anything. This tool does not give tax, legal, or investment advice.

← All tools