Skip to content

How to Use the Sales Target Calculator

Ready to find out more?

Please click on the button to access the calculator. And please take a few minutes to read through these notes to get the best out of the calculator.

Step 1
 
 

The first step is to enter your annual sales target and the average value of your deals.

Step-1-SalesPipelineCalculator

If your deal value varies greatly, I’d recommend taking a good guess. I suggest picking slightly lower to underestimate your average deal value for this exercise.

The calculator will then calculate the number of deals you must close each year to hit your sales target.

You will also notice a box to enter the number of working days in a year. Take 365 days a year and deduct weekends, national holidays and your holiday allowance, leaving you 220 working days a year. You can adjust this figure to suit your situation. As an example, you may only work four days a week.

Step 2
 
 

Scroll down to access Step 2. 

Step-2-SalesPipelineCalculator

Enter the percentage of proposals you send that result in a deal in the first box. If you close 1 in 5 opportunities, enter 20 into the first box. In the next box, enter the number of face-to-face or online meetings that result in you sending a proposal.

It is very important at this stage to let you know that your sales process may differ from the one shown. What is essential is to note that every sales process has key bases or milestones that form the structure of every sales process. Replace the key stages with your own sales process.

The final stage is the number of phone calls you need to make to schedule an appointment. Enter this number into the last yellow box.

STEP 3

 

There’s nothing to do on this tab except make notes. One estimation is that 73% of salespeople don’t hit their sales target because they don’t have a plan within their control.

Results-SalesPipelineCalculator
Results2-SalesPipelineCalculator

The results section gives you a simple sales plan within your control. At the beginning of the week, you now know how many sales phone calls you need to make this week. Add prospecting to your sales process if you don’t have enough prospects to call.

Prospecting and phone calls are activity goals as you decide how many you will make each day, week and month. But meetings and proposals are stage goals, as you cannot control how many occur. What is essential, though, is the ratios you established in step 2. If you don’t have enough meetings, you’ll need to increase the number of phone calls.

If that happens, return to the calculator, change the percentage of phone calls to meetings, and reset the numbers. You should list the number of calls you must make each day and then tick them off as you make the phone calls.

What If
 
 

Now let’s have some fun.

update-SalesPipelineCalculator

Now that we know your sales ratios, we can play with the numbers and see what small changes your activities will make. As a first example, increase your average deal size by 10%. e.g. if your average deal size is £7,500, enter £8,250 into the yellow box. The performance percentage should now show 10%.

In the improvement percentage, you should see an increase in performance and a reduction in daily phone calls. So, if you improve your proposals with optional extras or add-ons, you should see an increase in average deal size.

Next, let’s assume that you close 1 in 5 proposals. Let’s take that you can reduce this by 1. Enter this into the box to see the impact. Once again, you should see a performance improvement.

Finally, let’s assume that you maintain your work level and keep the previous performance improvements. In the sales target box, enter a 30% increase in sales. So, multiply your sales target by 1.3 and enter this number into the box. Hopefully, you see that the number of daily phone calls stays roughly the same as the current figure, but now you have a 30% increase in sales.

To conclude

Having these numbers in front of you gives you a better idea of the work it will take to achieve your sales target. If you’re not a particularly good salesperson or lack experience, you will have to work harder at the beginning of the sales process, make more phone calls, and do more prospecting to hit your numbers. You’ll need the self-discipline to make those phone calls, and with help and guidance from your management teams and colleagues, you can improve the ratios as you go.