I cannot get the answer that you show.

Assuming 3 groups (to test) of 2 people, 2 people and 6 people in a
total staff of 10, and assuming total plan sales of 20

The first portion "stretched plan number of sales*team size as a
percentage of total staff" would show 4 and 4, and 12 for the larger
group.
The second portion "1+weighting applied to that team, which is also a
percentage" would equate to 1.12 for a 12% increase.

4 * 1.12 = 4.48 (twice) and 6 * 1.12 = 13.44

4.48 + 4.48 + 13.44 = 22.4, the same figure as the original figure of
20 times 1.12

Hope you can spot your error from that.




Homer J Wrote:
Hi,
I got a problem with a planning tool I've built to show how many extra
sales are needed each month by my teams to hit a target and then an
overachieveing target.

I've also applied a weighting to each team to allow for experience. My
problem occurs when I then try to add the overachieveing target (eg.
12%) and then apply the weighting to each team, 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 total
staff)*(1+weighting applied to that team, which is also a percentage)

Please help!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395256