Pay item pricing table
100-6001
$4.20
432-6008
$84.20
432-6008 · $84.20
Mobilization
Won bid priced $38,000 under the market floor for the district.
Letting 2024-0412 · CSJ 0912-31
40% below floor
Competitor comparison
Bidder A
$91.10
You
$84.20
You: $84.20
Margin left on wins
Won
$2.14M
2nd place
$2.36M
10% margin gap
From scattered DOT bid data to a ranked pricing table, in minutes.
Pulls and cleans your bid item list and DOT bid tabulation data, builds a competitor pricing comparison by pay item, and flags the margin left on past wins, in minutes instead of the hours it takes to build it by hand.
Problems in preparing DOT Bids
Data collection
Historical and competitor bid data collection wastes hours a Lead Estimator can't afford
Historical estimates and production data sit in Excel sheets or project systems without explanation. Competitor bid data is public on DOT websites but difficult to gather. Lead Estimators spend hours assembling this data for each bid, which may include 100+ pay items — time that should go to strategy and judgment, not spreadsheet cleanup.
Sources to reconcile per bid
DOT letting portal
Manual export
Historical estimate files
Scattered Excel
Competitor bid history
Public, unformatted
100+ pay items · hours of manual reconciliation
3 sources, no cross-reference
Bid tabulation — raw public export
432-6008 · Riprap, Conc B
6 bidders
No price-floor analysis · no district comparison
Raw record only — every bidder, every unit price, no analytical layer
No analytical layer
Raw public data
Bid tabulations are public data, but turning them into pricing intelligence is manual and time-consuming
After each letting, the DOT releases a complete record of every bidder, every pay item, every unit price — public, current, free, and raw. No pay-item-level comparison, no competitor price floors by district or project type, no signal on where a rival goes aggressive versus where they hold margin. Lead Estimators who want that intelligence build it by hand, project by project, or bid without it.
Curse of winning
The curse of winning
The curse of winning is when a contractor leaves margin on the table on a project they actually won.
On won projects, the gap between your winning price and what second place was prepared to pay is margin that didn't need to be left behind. Mobilization priced 40% below the market floor on a project nobody else came close to winning. Pay items bid below every competitor on a letting that wasn't competitive. These patterns repeat across bids and years — visible in public data, invisible to the estimating team until the letting history is analyzed at the pay-item level.
Won bid vs. second place
Your winning price
$2.14M
2nd place price
$2.36M
10% margin left on the table
Clarement Solution for DOT Bid Intelligence
01
Bid tabulation data pulled and cleaned automatically for your next bid
Scans DOT portals for upcoming projects, cross-checks the official letting list, and pulls the bid item list and historical bid tabulation database — cleaning both messy exports and checking the bidders list along the way. What used to be six separate logins and hours of column deletion happens on its own, every time a new bid is identified.
Pulling and cleaning bid data
Bid item list
Bid tabulation DB
6 sources cleaned · bidders list checked
01
Bid tabulation data pulled and cleaned automatically for your next bid
Scans DOT portals for upcoming projects, cross-checks the official letting list, and pulls the bid item list and historical bid tabulation database — cleaning both messy exports and checking the bidders list along the way. What used to be six separate logins and hours of column deletion happens on its own, every time a new bid is identified.
Pulling and cleaning bid data
Bid item list
Bid tabulation DB
6 sources cleaned · bidders list checked
02
Your competitor bid pricing comparison table, built and cross-referenced
Competitor pricing from the last several comparable bids is matched line item by line item and laid out in the same color-coded table you'd build by hand — cross-referenced against your own historical costs, so it's ready to work from, not ready to clean up.
Competitor pricing comparison — 432-6008
Bidder A
$91.10
Bidder B
$88.40
Your historical cost
$84.20
Cross-referenced against your historical costs
03
A pricing-ready table, plus the margin you're leaving on won bids
Pricing strategy, item concentration, and the final review stay exactly where they belong — with you. What changes is what lands on your desk first: a ready-to-price table, and a flag on any pay item where past won bids show a consistent, recoverable gap to second place.
Ready-to-price table + margin flags
Mobilization · 40% below floor
HIGH
432-6008 · priced under all bidders
MEDIUM
100-6001 · in line with market
LOW
10% recoverable margin flagged on past wins
Pull
Compare
Flag
Built for Lead Estimators, VP Operations, and Owners
Lead Estimators
Right now, you're the one pulling the bid item list, cleaning up exports, building the competitor table by hand. On a 100+ item bid, that eats hours before you've even made a pricing call. Some months it's the reason a bid gets forfeited — there's just no time left. Hand that data over clean, and the time goes back into strategy, every letting.
Pay item 432-6008
READY
Competitor range $84.20–$91.10, cross-referenced against historical cost.
Hours back
Per bid, returned to pricing strategy
VP - Operations
When each location runs its own analysis by hand, quality depends on who's doing it. The margin left on the table across your wins stays hidden until someone actually checks. A shared, structured view fixes that — it flags specific items, like mobilization priced under the market floor, and shows the pattern across your whole territory, not just the last bid.
Territory-wide pattern
District 3 — Mobilization
−32%
District 7 — Mobilization
−41%
One shared view
Consistent quality across every location
Owners
The real question isn't how one bid got priced. It's whether you're winning the right projects at the right margin, year after year. The bid tab data already has that answer — it just needs to be analyzed across every won project. Turn "we're leaving money on the table" into an actual number, and margin capture becomes a go/no-go input, not something you find out about in a financial review.
Won projects · trailing 3 yrs
10% GAP
Aggregate margin left on the table: $4.8M
A real number
Margin capture becomes a go/no-go input
FAQs for DOT Bid Preparation and Intelligence
What is DOT bid intelligence software?
It's software that pulls and cleans bid item lists and bid tabulation data straight from state DOT portals, then builds a pay-item-level competitor pricing comparison. Instead of turning public, raw bid data into a spreadsheet chore, you get a table that's ready to use.
How much time does it take to manually prepare data for a DOT bid?
On a bid with 100+ pay items, pulling the bid item list, cleaning the tabulation export, and building a competitor comparison table by hand takes hours. That's time you could be spending on pricing and strategy instead.
Where can I find public bid tabulation data for DOT projects?
State DOTs publish a full bid tabulation record after every letting. Every bidder, every pay item, every unit price. It's public and free, but it's raw. There's no pay-item comparison or price floor analysis built in. You have to build that yourself.
How do I find competitor price floors by district or project type?
You match a competitor's pricing across their last several comparable bids, item by item, then look for the range and pattern by district or project type. It's a manual, project-by-project job unless it's automated for you.
Why do contractors leave margin on the table even on won bids?
Sometimes a bid wins by more than it needed to. Maybe mobilization got priced well below the market floor, or a pay item came in under every competitor on a letting that wasn't even close. These gaps sit right there in public bid tab data, but nobody sees them until someone actually digs into the letting history at the pay-item level.
What is the "curse of winning" in construction bidding?
It's the gap between what you won a project for and what second place was actually willing to pay. That gap is margin you didn't need to leave behind. It shows up again and again across bids and years, but only if you're looking at pay-item-level data on your wins.
How is this different from HCSS's bid database?
HCSS gives you access to raw, aggregated bid tab data. It doesn't do the analysis part — comparing competitors item by item, spotting price floors, flagging margin gaps on wins. That layer still has to be built by hand on top of what HCSS gives you.
Can bid intelligence be used across multiple locations or a whole company?
Yes. Instead of each location doing its own manual analysis and getting inconsistent results, you get one shared view. It flags patterns like mobilization consistently priced under the market floor, across your whole territory, not just one bid.
Does this replace a Lead Estimator's pricing judgment?
No. It hands you a clean, ready-to-price comparison table and flags recoverable margin on past wins. You still decide the pricing strategy, where to concentrate items, and the final call on the bid.
Is Bid Intelligence free to use?
Yes, it's available as a free tool right now.
Use it for your next bid
Before you price your next letting, run it through Clarement Bid Intelligence. You'll get a clean bid item list, a competitor comparison table by pay item, and a flag on any margin you left on the table from past wins — all in minutes, not hours. Try the free tool and see what it finds on a bid you already know inside and out.
Try the free tool