H
Homer J
Hi,
I got a problem with a planning tool I've built to show how many extra
sales are needed each month to hit a target and then a stretching
target.
I have my business plan showing how many sales I need, then I have
worked out a stretched target for my plan. I created a table showing
all my teams, how many staff are in each & then applied a weighting to
each team to allow for experience.
I then split the plan between the teams. My problem occurs when I then
try to add the stretched target (eg. 12%) and then apply the weighting
to each team.
When I add up the total of all the teams to make sure it adds up to the
same amount I originally calculated for the stretched plan every result
is only 96.44% of what I expected it to be.
The sum I'm using to calculate each teams stretched target is
=sum(stretched plan number of sales*team size as a percentage of the
total staff)*(1+weighting applied to that team, which is also a
percentage)
Please help its driving me mad!
Thanks
I got a problem with a planning tool I've built to show how many extra
sales are needed each month to hit a target and then a stretching
target.
I have my business plan showing how many sales I need, then I have
worked out a stretched target for my plan. I created a table showing
all my teams, how many staff are in each & then applied a weighting to
each team to allow for experience.
I then split the plan between the teams. My problem occurs when I then
try to add the stretched target (eg. 12%) and then apply the weighting
to each team.
When I add up the total of all the teams to make sure it adds up to the
same amount I originally calculated for the stretched plan every result
is only 96.44% of what I expected it to be.
The sum I'm using to calculate each teams stretched target is
=sum(stretched plan number of sales*team size as a percentage of the
total staff)*(1+weighting applied to that team, which is also a
percentage)
Please help its driving me mad!
Thanks