Percentage of total formula taking into account volume

**msource** · 10-12-2009, 09:42 AM

I'm working on success data for a team of sales people, it's a fairly straightfoward calculation:

Column 1: Name of salesman
Column 2: Number of successful sales
Column 3: Number of unsuccessful sales
Column 4: Total number of sales calls

Success rate equals to the successes over the total (=column2/column4).

What we've noticed is that we have people who have made many sales calls in a month with just a few successes, they sport a low success rate. Another employee got a total of 2 sales calls, 1 was successful which gives 50% rate. In reality the first employee was more successful as he got more business in.

I'm looking for a formula that can combine the success rate with the volume of business every employee is attracting to the company. Any ideas?

**zbor** · 10-12-2009, 09:45 AM

You can add weighting factor... But you'll also need some inputs or table to compare with... Best way is to upload example with more input options.

**msource** · 10-12-2009, 09:53 AM

Thx for the quick reply zbor, I've attached an example

**zbor** · 10-12-2009, 09:58 AM

I could imagine that.

However, I still see no difference between someone who made 1/2, 20/40 or 100/200 success. They are all 50% and you said last one is better.

Now you need to define how to categorize them: why is 100/200 better than 1/2 and is 3/6 same as 4/8.. Something like that...

Also, is 100/200 (0,5) better then 3/5 (0,6) or worse?