Forum Discussion
excel to help divide company profit into tiers with caps
Riny_van_Eekelen thanks for your reply, i think the excel you provided is great.
i was using the example as a simplistic scenario where 1 person 'lived' in each tier - in reality though there would be X amount of people per tier and this would be changing monthly.
for e.g. 40 people in tier 6 (500Cap), 15 in tier 5, 8 in tier 4, 4 in tier 3, 7 in tier 2 and 1 in tier 1.
Can you create the same excel with a possibility to change the no of people in these tiers as the organisation changes and yet the distribution to be allocated fairly as you very well depicted. thank you
sarap987 Perhaps you can explain a bit more with a manual calculation example. Let's say we have 80,000 to distribute, How much would every individual in each level receive? Use the same number of people in each group as mentioned in one of your earlier responses (40, 15, 8, 4, 2 and 1).
