Hello Excel guru's
Please help! I'm going mad trying to figure this out.....!
I'm trying to work out how to allocate bonuses per quarter out of a pool of money:
1) In Q1 x 2 individuals achieved their targets - although at different percentages.
So I need to pay out the pool money of $6828 in Q1 to the 2 individuals.
BUT the tricky part is that the person who achieved between 125-150% needs to get more than the person who achieved 110-120%
2) In Q2 x 3 individuals achieved their targets - at different percentages
So I need to pay out the pool money of $7063 in Q2 to the 3 individuals.
BUT the tricky part is that the person who achieved 150%+ needs to get more than the 2 people who achieved 110-120%
3) In Q3 x 3 individuals achieved their targets - at different percentages
So I need to pay out the pool money of $3922 in Q3 to the 3 individuals.
BUT the tricky part is that the person who achieved 150%+ needs to get more than the person who achieved 110-120% and who needs to get more than the person who achieved 100-110%
-- removed inline image ---
Please help! I'm going mad trying to figure this out.....!
I'm trying to work out how to allocate bonuses per quarter out of a pool of money:
1) In Q1 x 2 individuals achieved their targets - although at different percentages.
So I need to pay out the pool money of $6828 in Q1 to the 2 individuals.
BUT the tricky part is that the person who achieved between 125-150% needs to get more than the person who achieved 110-120%
2) In Q2 x 3 individuals achieved their targets - at different percentages
So I need to pay out the pool money of $7063 in Q2 to the 3 individuals.
BUT the tricky part is that the person who achieved 150%+ needs to get more than the 2 people who achieved 110-120%
3) In Q3 x 3 individuals achieved their targets - at different percentages
So I need to pay out the pool money of $3922 in Q3 to the 3 individuals.
BUT the tricky part is that the person who achieved 150%+ needs to get more than the person who achieved 110-120% and who needs to get more than the person who achieved 100-110%
-- removed inline image ---
Q1 | Q2 | Q3 |