The situation. A growing Dallas-area commercial subcontractor, with a seven-person estimating team and nine-figure bid volume, had big questions about growth. What is really in the pipeline? Where are we winning, and with whom? Is the estimating team built for where we are going? A department leader had spent months using AI to build a bid tracker, and AI delivered exactly what it was asked for. But the questions leadership needed answered were financial ones, and nobody had asked them. The tool produced activity. It did not produce answers.
What we did. Knowing the questions, we framed a CFO-led solution in under two hours. We started from the answers leadership needed (true pipeline, win rates, estimator capacity, where the work comes from) and worked back to what the data had to deliver. The first result was a pipeline number people could trust: reported bid volume came down about 10% once revised bids stopped counting twice. Leadership then set the rules for how bids are counted and aged, every number was tied out to the dollar, and intake, ownership and estimator training were rebuilt over the following weeks so the process runs on rules.
Where it led. One agreed pipeline number for the board and the bank, and a fair view of estimator workload. The same lens then showed the staffing forecast running well above actual crew headcount: crew capacity, not the bid list, is the real limit on growth. Accounting data now flows nightly into leadership dashboards, with reconciliation checks before any number is published.