Ok I Have a bonus stucture,
It goes on (12) 4 week cycles and and sales have to increase over the period
to hit
loest level of bonus.
Ok to make it real easy, lets so
Cola colb colc cold cole
colf colg
Period / low produciton / bonus /mid produciton /bonus /High production / b
1 100 $10 bonus, 100 <5000 $20 bonus 1000
$30 b
2 200
3


and lets say that sheet 2 A1= the period # and b2= the sales $
Pelase advsie