Originally Posted by
Homer J
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!
Bookmarks