- #1
Semidevilz
- 5
- 0
I feel this is an easy arithmetic, but I can’t figure out how to get it to work out.
Let’s say I have an overall metric of sales data that can be broken down by 5 sales reps.
In 2016, each rep makes a certain number of phone calls and their success rate is # of sales divided by # of calls. I'm able to determine my overall 2016 performance by summing each reps sales and dividing by the total number of calls for a total success rate. so for example:
rep1: sales: 5; calls 10; success .50
rep2: sales: 3; calls 20; success .15
rep3 : sales: 2; calls 10; success .20
rep4: sales: 1; calls 10; success .10
rep5: sales: 8; calls 80; success .1
total: sales 19; calls 130; success .146
In 2017, the same 5 reps performance are available
rep1: sales: 5; calls 100; success .05
rep2: sales: 10; calls 20; success .5
rep3 : sales: 2; calls 10; success .20
rep4: sales: 1; calls 100; success .01
rep5: sales: 80; calls 2000; success .4
total: sales 98; calls 2230; success 4.3%
my goal is that I want to start at 14.6%(initial success) and mathematically determine how much each rep contributed to my final success of 4.3%.
Ideally, 14.6% + or minus rep1...rep2...rep3...rep4...rep5 = 4.3%. how do I do this calculation? I've tried a couple methods with weighting and such but I still can't get it to tie out.
Let’s say I have an overall metric of sales data that can be broken down by 5 sales reps.
In 2016, each rep makes a certain number of phone calls and their success rate is # of sales divided by # of calls. I'm able to determine my overall 2016 performance by summing each reps sales and dividing by the total number of calls for a total success rate. so for example:
rep1: sales: 5; calls 10; success .50
rep2: sales: 3; calls 20; success .15
rep3 : sales: 2; calls 10; success .20
rep4: sales: 1; calls 10; success .10
rep5: sales: 8; calls 80; success .1
total: sales 19; calls 130; success .146
In 2017, the same 5 reps performance are available
rep1: sales: 5; calls 100; success .05
rep2: sales: 10; calls 20; success .5
rep3 : sales: 2; calls 10; success .20
rep4: sales: 1; calls 100; success .01
rep5: sales: 80; calls 2000; success .4
total: sales 98; calls 2230; success 4.3%
my goal is that I want to start at 14.6%(initial success) and mathematically determine how much each rep contributed to my final success of 4.3%.
Ideally, 14.6% + or minus rep1...rep2...rep3...rep4...rep5 = 4.3%. how do I do this calculation? I've tried a couple methods with weighting and such but I still can't get it to tie out.
Last edited: