Adding Percentages
 

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


--
Homer J
------------------------------------------------------------------------
Homer J's Profile: http://www.excelforum.com/member.php...o&userid=26166
View this thread: http://www.excelforum.com/showthread...hreadid=394865