Return to The Show Page
It don't take a lot for
some rudimentary info to give you a barometer.
I'm attaching a worksheet I just developed for this for Groopsters.
It's simple, self calculating and close to idiot proof :-) If you can
count that's all you do. It takes less than a minute to enter info as
you go each day. Enter in the customer name and quoted amount. If they
buy then enter the amount bought. (ALWAYS enter the quoted amount too
even if they buy from the start!). Every sold amount should have
whatever was quoted in the quote amount column. If there is a name then
the only blank field allowed is the sold field if you didn't sell them.
Follow this rule and your percentages will always be dead on accurate as
long as you enter the right customer counts. At the end of the week
count how many customers quoted and enter that on the line provided then
count how many actually bought and enter that on the other line. The
sheet will tell you your closure ratio in percent form AND average per
customer dollar amount.
It's real basic and simple. It can help for those who want some info
but don't want to spend hours figuring out how to figure it out and
keeping up with it. You can print it out and save it weekly and see how
your going. Or create a folder in your computer called closure ratios,
then just "save as" in that folder with a different date for the week
for the file name such as "Week of 03-21-04" and save them that way.
This one has some info in it as an example. I've locked the cells you
shouldn't use so you can't mess up the programming in it.
Name, dollar amount per name and customer sold/quoted count are the only
fields requiring info. All else is on autopilot.
Sincerely,
John Polgar
To download John's Sales Closure
Ratio form, right click and save as:
Sales Closure Ratio Excel Document
