In January 2004, I left a good marketing job with a major
electronics manufacturer to start a remodeling company in San
Jose, Calif. When we opened our doors in January 2005, I had
three employees. Four years later, we’ve grown to 19
employees and are doing $3 million in business —
everything from two-hour handyman jobs to large remodels that
last several weeks and sell for more than $100,000.
I credit much of the growth to our staff, who do high-quality
work and take great care of customers. It also helped that, as
part of the Case Remodeling franchise, we hit the ground
running, with proven systems for sales, operations, production,
and customer service.
But even companies with good systems can get into trouble if
they don’t manage their growth. To avoid that fate, I
created a “dashboard” — a set of fundamental
numbers that shows me the monthly trends in our sales and
production pipeline: leads, close rates, job profits, and
customer satisfaction.
I pull reports from a couple of sources — QuickBooks, for
example, and our in-house customer-management program. But it
doesn’t matter what software you use or even if you log
in the information by hand. The point is to track your numbers
— I look at them a few times each week — and record
them on the dashboard (see spreadsheet). The monthly totals
show me where the business is going and where we need to
adjust. Because I keep a close eye on these trends, I seldom
have to make reactive decisions under stress. And in the long
run, I make better decisions for my company.
This spreadsheet shows a sample dashboard for a
hypothetical company projecting around $100,000 per month in
business. It covers a six-month period and includes all of the
categories the author uses.
The items we include vary slightly from year to year; some of
them — leads, for example — are raw numbers, while
others are percentages or dollar figures. In this article,
I’ll go through the items one by one, explaining why I
track them and how I use the information in my business
decisions.
Marketing and Sales
This section of the dashboard tells me how successful we are at
converting different types of leads, and whether we need to
refocus our lead-generating efforts.
Total leads. This is a tally of how
many leads we are getting from all sources: repeat customers,
referrals, direct mail, print advertising, the Internet, and so
on. At the beginning of each year, we set monthly lead targets.
The dashboard tells me if we’re meeting them and how
we’re doing compared with the same month last year. If
the dashboard shows that we’re missing a target, I meet
with the sales staff to figure out why.
Repeat/referral/networking leads.
Repeats and referrals made up 33 percent of our leads last
year. We decided we wanted to grow that number to 44 percent
this year, so we started attending more networking meetings and
stepped up our marketing to past clients. The effort has paid
off: By late summer we were getting 45 percent of our leads
from repeat customers and referrals. Although the number of
leads has dropped since the bad economic news in September, the
percentage of leads we’re getting from repeats and
referrals hasn’t changed much.
Total sales. This is a dollar figure
that tells me whether we’re hitting our monthly sales
targets and how we’re doing compared with the same month
a year ago. If we’re not hitting our targets, my
salespeople and I revisit all leads that didn’t close.
Sometimes it’s just a bad economy, while other times we
might find that a salesperson is in a slump. The worst case is
that we determine that a salesperson is in the wrong job.
(We’ve let four salespeople go in four years.)
Other times we find that a lead source has lost its
effectiveness. In the past, for instance, we received leads
from matching services like ServiceMagic — as well from
the Yellow Pages — but since most of those prospects were
price shoppers, we decided to switch our focus to sources that
bring higher-quality leads. That’s why we now put more
attention on referrals and networking.
New-territory sales. Each year we try
to expand into a new city or town that fits our target
demographics. The dashboard tracks the dollar volume of
business we are doing in that area.
Currently we’re trying to expand our business in Los
Altos, and we were on target before the bad economic news in
September. That tells us that our efforts have been paying off,
so we will continue those efforts regardless of the economic
news.
We’re not always that successful. Last year’s
target was Saratoga. It’s a promising market with lots of
home equity, but halfway through the year the dashboard alerted
me that sales weren’t what we had hoped for. When we
looked deeper we found that Saratoga had a lot of
“older” money. In many cases, homes are valued in
the million-dollar range but were bought decades ago for
$30,000, and the owners are reluctant to spend, say, $60,000 on
a new kitchen. So we decided to narrow our marketing in this
city to people who recently purchased. As a result, we’ve
seen an increase in sales in that area.
Three-month rolling contract close
rate. This is a percentage that measures our
sales team’s effectiveness. (I look at a three-month
period because our more complex jobs can take three months for
the salesperson to close.) We target a close rate of 30 percent
for remodeling leads and 85 percent for handyman leads. We
measure our progress according to its variation from the actual
target.
A low number can be a sign of other resource issues. At one
point, for example, we discovered that one of our sales
consultants had been getting drawn into the design aspects of
bigger projects, leaving him less time to take new leads
— which dried up his sales pipeline. I decided to hire an
associate project designer to work with clients on drawings and
selections so that our salespeople could keep their pipelines
full.
Production
The production numbers gauge our efficiency and effectiveness
on the job, and include profit and quality.
Gross company profit. This is the
gross profit percentage for the entire company. We aim for a GP
of 45 percent; how close we are to that is a good sign of our
estimating accuracy and our production efficiency. If we fall
short, we examine all of our projects. The problem could be a
one-time glitch, like a framing error that required extra
materials to fix. Or it could be that one crew lacks a certain
skill set.
In one case, the problem was a good carpenter whose jobs were
dragging on longer than necessary. When we met with him, he
admitted that while he started jobs with lots of energy, he
eventually got tired of the long duration. We switched him to
small time-and-materials jobs, and he has excelled. He loves
being able to start and finish a job in one day. As a bonus, he
has an outgoing personality and is great at building rapport
with clients, making him a terrific ambassador for our
company.
Job quality. This section compares
the hours we spend on warranty work with the monthly limit
we’ve set — eight hours at our current work
volume.
If warranty hours exceed the limit, we investigate. Maybe some
of our guys need training in a particular area. Or maybe
there’s a problem with one of our subcontractors. The
numbers tell us when we need to devote time at our weekly
production meetings to identifying and solving those
problems.
Sales and project management. Here, I
look at how many contract jobs we’ve sold and the
associated gross profits on those jobs. (The reason these
numbers are in the production section of the dashboard is that
they’re driven by our salespeople and our production team
working together.)
I also track closed and sold jobs priced over $10,000 and the
percentage of those jobs that are meeting our gross profit
targets. I do that because large jobs generate the greatest
share of our revenue and have the biggest impact on our
profits. Next year I plan to change that number to $20,000, as
our average job size has increased. Even if business is slower
than projected, I’m predicting that the average job size
won’t change much, and therefore plan to stick with the
new number.
Customer Satisfaction
Because we depend on referrals and repeat customers, we use a
rating system to gauge customer satisfaction.
Every six months, American Ratings Corp. surveys our clients. A
90 percent satisfaction rating earns us a “diamond”
certification rating — and since we get lots of quality
leads from this program we do everything possible to keep that
rating. If clients report problems, I ask the rating company if
I can talk with the clients who complained so that we can
quickly identify and correct the issues.
Other Numbers
I also have a separate dashboard on the local economy that
includes property values, materials costs, construction
employment, and general employment. These numbers help me make
projections. For instance, falling home prices will reduce the
equity people have in their homes, leading me to revise my
sales forecasts.
I anticipate changing market conditions by making three
forecasts each year: the one we expect to follow, a more
optimistic one for a better-than-expected market, and a
pessimistic one in the event the economy goes south. The third
scenario cuts expenses in a way that doesn’t undermine
our ability to be successful in the future. Unlike some
builders, I don’t cut back on marketing in a slow
economy, which I believe is one reason we’re doing well
in this market.
Jim Kabel owns Case Handyman and
Remodeling of San Jose, Calif.