Estimate Tracking

Tracking your progress

As an estimator there are typically more bids going than there is time to chase them all.  It’s critical to develop a strategy for winning and that all starts with making the initial decision on whether to pursue a lead.

Some firms  use a Go / no-go decision tree arrangement to allow for estimator level discretion on bid opportunities.  These can also take the shape of graded appraisals which generally output an integer value correlated to the odds of winning.

Other firms won’t use any sort of culling – it’s just whatever “the boss” dumps into your inbox.

No matter what your situation is, it’s critical that you accept that your firm will be excellent at some things, OK at others, and generally terrible at the rest.  It damages a lot of egos to point this out but it’s true nonetheless.

Estimate Tracking

Cheer up buckaroo, thing’s get better from here.


It’s been my experience that many firms are broadly optimistic in lieu of accurately assessing their performance.  These firms also tend to relentlessly chase the same kinds of work when they’re in a rut, often going so far as to double or triple the amount they’re bidding to snag more work in a slump.

I would say this is like digging for water in a desert.  The land may all look roughly the same but some areas will have water and others will not.  Your survival depends on finding the water with the least amount of digging.

The goal of an estimator should be to bid less and win more.   This is much easier when the economy is with you.  However whatever works during a recession will still work in prosperity.

If you are serious about improving your odds,  you’ve got to actually know the odds.  Everything you bid adds to your repository of knowledge about your performance in your market.  Making that information work for you is what this is all about.

Bid tracking

To that end, you’re going to need to keep track of what you’re doing.  I’m consistently impressed at how often I meet estimators who are very detailed and studious about preparing proposals but they don’t have any precise data on how their efforts stack up in the bidding environment.

Much like building practices for efficient take offs – it’s important to start by asking yourself what you need to get out of the effort to track this data.  For starters, you’ll need to know what you’re doing right.  It’s a success when you’re winning profitable work with a minimum of wasted effort.  That’s not enough on its own because you’ve also got to keep your company busy.

To do that, you’ll need to know where your profitable work is coming from.  That means knowing which clients are bringing profitable work through the door.  It also means knowing what your company is good at in terms of value and scope.

Good bid tracking will generate a concise record to use as a feedback loop.  Knowing your odds of success on each opportunity will help pick the likely winners and losers.

To be truly useful bid tracking should also reveal what you’re doing wrong.  Like everything in estimating, it’s important to reach a balance point in terms of tracking enough data to be useful but not cumbersome.  There’s little utility in overanalyzing a loss.  Depending on traditions in your market it may be very difficult to get bid results from your clients.  Even then, it can be difficult to get any assurance of accuracy in terms of what you are being told.  In my experience if you win, you won’t receive any bid results to know by how much (or little) you secured your victory.

Estimate Tracking

You only get half the story.

The tracking system is a way to be accountable for your actions as an estimator.  If properly done it can serve as a means to show higher-ups the outcome of their actions as well.  I encourage you to track not only past bids, but current bids on the same spreadsheet.  This provides a single file that’s constantly updated.

I typically lock a header row that displays annual summaries for all tracked data points so that it’s obvious at a glance how things are going.  Many companies have separate people who are making decisions on marketing, what to bid and who’s going to bid some project.  Putting the entire pre-construction process on a single file helps to keep their individual goals in line with the bigger picture.

Each of these parties are looking for feedback that’s concise, impartial, accurate, and timely.  Giving them access to your records removes unnecessary obstacles and increases the odds that you’ll be successful.  Companies with cloistered and secretive departments rarely perform to their potential.  Be advised that some managers will take any opportunity to push accounting duties onto other departments.  Don’t allow yourself to become the appeals court for interdepartmental conflict.

Getting specific

I will have an estimate template posted in the future. It has several features you can choose to customize your output.  The template will automatically summarize the bid data into four arrays; Client, Region,  Project description, and Common link.  The “Common link” would be used for situations where projects are connected via a commonality like an Architect, Engineer, Association, or Group that would otherwise go un-noticed.  Be sure to correlate this terminology with marketing so that they can see how their leads are developing. For simplicity’s sake I will hereafter refer to all tracking in terms of the client array.

Each array get’s tracked in two dimensions; counts and values.  The “Counts” dimension is tracking entirely based on the number of bids.  The “Values” dimension is tracking based on dollar values of the bids.

Each dimension calculates the following :Bids, Wins, Hit rate, % of annual bids, and % of annual wins.

Subcontractors can face a situation where they are low bidder to their client (the GC) however the client doesn’t win.  I track this as “Low” since it’s not accurate to call it a loss or a win.  If your  client can’t win with your low bid – they’re squandering your efforts.

The most important data points so far are the hit rates.  The higher the ratio of wins to bids – the more likely you are to win future projects with that client.

If you ask five industry experts what is an acceptable hit rate, you’ll likely get five different answers.  I think this is more a factor of average bid value than anything else.  Companies with wildly varying project values are more likely to expect a lower hit rate.  Companies with very consistent project values will tend to expect a higher hit rate.  Overall market conditions carry great weight – as does the experience of your team.  Anyone who was successful during a recession on the hard bid market will have valuable insight.

Thus far all the tracking and calculations have gone on without consideration for the cost of bidding.  Hit rates alone are insufficient to reveal the actual business relationship you have with this client.

I like to calculate the Return On Investment (ROI) of the clients.  This is the profit of the awarded work divided by the cost of bidding to that client.  After all, you’re bidding to make money so it’s important to show how your efforts generate that income.

I should mention again that just like hit rate, you must to calculate the ROI in both the counts and values dimensions.  In the case of bid counts, I take the annual estimating costs divided by the number of bids per annum – times the bid count for that client.  For the lone estimator, that cost is the estimator’s total annual compensation + reimbursements for company expenses like parking fees for job walks and the like.  In most cases this information is confidential so I would advocate hiding and locking the cells holding your estimators compensation. I don’t expect accounting to track hours on each bid but feel free to use that information if your firm does.

So what does it all mean?

A ROI of 1 means you are breaking even on the cost of bidding to that client.  A ROI less than one means you are losing money by bidding to them even if you won some work.  The higher the ROI, the better investment that client is to your firm.

The average of  the Value and Count ROI’s gives a better perspective on  each client.  Some companies will have a negative ROI for bid count but a positive ROI for bid value.  This can signify a client with many projects that are too small for your firm to win but still has a few larger jobs that your firm wins and completes profitably.    A positive average ROI indicates that they’re still worth your time to bid to however you might consider declining the smaller stuff to make better use of your time.

It’s also possible to have the opposite situation where you’re winning the smaller work profitably but you’re spending too much time chasing bigger jobs you can’t win with that client.  Ambition is admirable but without traction, you won’t climb that mountain.  It’s wiser to build on profitable wins than to let pride lead you to losses.

Sad to say, I have encountered situations where ownership was very wrong about which clients were good investments. A client with a negative ROI over a long span of time is draining resources.  A “Sunk cost fallacy” where some process is costing more money than would be logical to continue.  The person spending the money continues their course thinking that they’ve already sunk so much money into the effort, they can’t turn back now.  Losing bids is NOT AN INVESTMENT!

IEstimate Tracking

Archie lost a lot of bids too, now he’s free to focus on his other interests.


In my experience the best way to break this cycle is to demonstrate the difference between a positive ROI and a negative ROI company.  The money spent on the negative ROI firms represents potential marketing efforts to work with new and better clientele.

The output of the bid tracking should be able to illustrate where you’re finding success in descending order.   As new opportunities come through the door – compare them to the “ideal” project.  A project that is well aligned with previous failures has a low probability of being worthwhile.  In a tight market, it’s often difficult to find “ideal” jobs.  In that case, make a concerted effort to find substantially different opportunities to widen your field of view.

If you’re no more certain of losing than winning, it may be worth a shot.  If you’re certain of a loss you should not bid.    Familiarity with lost causes is endemic in our industry so worry less about upsetting a client that never awards jobs to you and focus more on where else you can go.

If you’re having serious trouble landing work, it may be time to appraise where things are going wrong.   Targeting a market involves a hefty amount of hard-won knowledge.  What are the companies that are winning doing differently than you?  How can you land this work profitably?  If you find a way to cut the percentage of previous losses while retaining profitability you should be on the right track assuming a fair bid.

A few warnings

Estimate tracking is a long-term tool that becomes more useful with an extensive data set.  Be very conservative about drawing any conclusions on short-term data.  Missing bid results reduces the reliability of the dataset as well.

The tracking needs to amortize the cost of the estimators wages over the year to keep from skewing early results.  This brings up a significant series of inter-related factors.

The more frequently you bid, the lower your individual investment per project bid. This is diversifying your estimating investment IF you’re bidding to a variety of clients.  It’s not uncommon to find that a few clients represent the bulk of your wasted time so be wary of that happening.

The less frequently you bid, the less data you have to work on and the less secure you can be of your conclusions.  Unless you’re consistently winning, it’s time to pick up the pace.  Whenever possible you should seek out the “next big thing” to define where your target markets exist.  It’s very common for companies to restrict their bid lists when times are good.  When times get tough, (and they will) these companies are forced to play catch up.

The less commonality between your bids, the less cohesive your data will be.  Companies with no criteria for what they’re looking for suffer this condition.  Data driven by wild speculation tends to be very inconsistent and unreliable.  Strike a balance by making a plan to target specific leads over a pre-determined amount of time.  Don’t be afraid to move on if things don’t pan out.  Be aware that invitations with little to no barrier to entry bring different competition than more restricted opportunities.

So to apply this to estimating – it’s very important that you see the connection between bidding less and winning more.  The cost and effort to produce a bid can be considerable.  Losing a bid means you’ve got to pay for that effort out of your wins.

Aim at what you can hit – hit what you’re aiming at, and don’t forget to keep score!

If you’re looking at a huge variety of work – there’s very little historical precedent to be had for identifying good versus bad opportunities.  Luck isn’t a business plan.  You need to know what you’re good at and why.  To that end, opportunities that are similar to successful past projects should  jump out as good choices.

Regular client, doesn’t mean they’re good clients…

Next should be repeat clients that are good clients.  Devotion to a customer who’s never been profitable is rampant in this industry.  Dysfunctional working relationships like these generally have key words to watch for “it keeps us  busy”, or “we make up for lost profit in volume”.   If the work isn’t profitable to start with, doing more only digs a hole.  Every project is a risk and reward proposition.  Until the job is done and paid, everything is risk.  Whatever’s left is the reward.  Keeping people busy by taking on risk for no profit is ignoring how often projects aren’t profitable.  It would be less risk to pay them to sit at home.

It’s really critical that you know if the work you bid  was profitable on its own.   Lots of times companies don’t bother to track the change orders separately from the original contract scope.  This leads to distortions in perception.  A job with a hefty change order might appear more profitable than it really was.  The opposite is possible as well.  I’ve encountered folks who chase clients because they had really profitable change orders.  The truth is, they didn’t actually profit on the main work and fortune may not smile on them twice.

Estimate Tracking

Sure, rub it in why don’t you?

So chase work that’s similar to profitable stuff you’ve done and give special focus to good clients – that’s pretty obvious stuff.


I’ve heard folks get wound up about how “there’s only three companies bidding this project”.  Are those companies market equals or is someone an obvious outlier?

I’ve won jobs against twenty competitors and lost jobs against only one.  I’ve seen enough chest thumping nonsense.  So if you don’t have a unique strategy to beat someone who’s consistently outbidding you, you’re just lining up another loss.  There can be profound differences between companies that dramatically affect how they price work.

If you’re not chasing work that lands within your company’s key efficiency you’re forced into a bad decision.  Work that’s too small for your firm won’t be profitable at market prices.  Work that’s too big for you will expose your firm to greater risk.  Adequately covering that risk tends to exceed market prices.

For example, let’s say you’re chasing a project that would require hiring people to adequately staff the project.  You would need to bid with your future overhead as well as the additional labor.  Depending on the labor market, that could be a hugely variable issue.  A larger firm with existing staff goes into that bid knowing their overhead figures are firm.  Subcontractors routinely get pinched by shortages of qualified tradesman.  Low supply and high demand pushes the wage rates up.  It’s a bad situation for those firms.

All of that being said – the entrepreneurial nature is to chase bigger and better work.  People go broke on “big jobs” they won, not jobs they lost.  Humble and profitable is far superior to big and broke. It is important to ensure that there’s enough work that it’s just a little uncomfortable for Project Management to keep up.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: