# Thread: Really need some help on this!

1. ## Really need some help on this!

Basically, i need some help with something I have been trying to figure out.

Lets say, some marketing people took to the streets trying to generate call leads for a window uvpc company, trying to sell windows and doors etc.

At the end of the day, 10000 leads were generated. The window company wants to convert these leads at 20% - so thats 2000 sales they are hoping for.

Now, there are 315 sales staff in the centre - some better than others. So they are distributed into groups. These are as follows:-

Group 1 - 80% conversion of that in group 3. (100 staff)
Group 2 - 90% conversion of that in group 3. (150 staff)
Group 3 - 20% conversion. (50 staff)
Group 4 - 110% conversion to that in group 3. (10 staff)
Group 5 - 110% conversion to that in group 3. (5 staff)

Now the windows company does not know how many lads each group of staff will receive, but they need to set the conversion rates phased on their grouping but still adding up to the original 2000 sales that are desired to be converted.

Any ideas how to tackle this?

2. Originally Posted by Dan84
Basically, i need some help with something I have been trying to figure out.

Lets say, some marketing people took to the streets trying to generate call leads for a window uvpc company, trying to sell windows and doors etc.

At the end of the day, 10000 leads were generated. The window company wants to convert these leads at 20% - so thats 2000 sales they are hoping for.

Now, there are 315 sales staff in the centre - some better than others. So they are distributed into groups. These are as follows:-

Group 1 - 80% conversion of that in group 3. (100 staff)
Group 2 - 90% conversion of that in group 3. (150 staff)
Group 3 - 20% conversion. (50 staff)
Group 4 - 110% conversion to that in group 3. (10 staff)
Group 5 - 110% conversion to that in group 3. (5 staff)
So the actual conversion rates are:

Group 1 - 16% conversion (100 staff)
Group 2 - 18% conversion (150 staff)
Group 3 - 20% conversion (50 staff)
Group 4 - 22% conversion (10 staff)
Group 5 - 22% conversion (5 staff)

Now the windows company does not know how many leads each group of staff will receive, but they need to set the conversion rates phased on their grouping but still adding up to the original 2000 sales that are desired to be converted.

Any ideas how to tackle this?
No idea what this last paragraph means.

RonL