It can be done, but how would the fixed bonus be allocated?

Would the bonus only get paid if the 2006 amount exceeded the budget
for that month or would you get a part bonus eg if 2006 was half way
between the 2005 figure and the budget would you get a 50% bonus.

It becomes a little more complicated reclaiming bonus from the previous
months as the relationship between bonus and sales is not linear. You
would have to provide a logic to deal with this

eg if the maximum bonus was 5 every month and you paid part bonuses


Budget 2005 2006 bonus paid reclaimed bonus
10 8 7 0 0
12 8 9 1.25 0
12 9 15 5 ?

in the first line the rate is 2.5 to every 1, in the second line 1.25
to 1 and in the 3rd line 1.66 to 1 how would you calculate the
reclaimed bonus? You could say the same as now eg

Total Budget =34 Total 2005=25 Total 2006=31 Total Bonus paid
=6.25

(31-25)/(34-25)*15 -6.25

but is this what you want? If so the logic is very similar to what has
already taken place, instead of multiplying by 3.14% you have to diivde
by budget-2005 and multiply by 45106/12

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=569657