Calculating Incentives for different Position & number of working days

[fritz_os]

Hello,

Hope anyone could help me with the below problem.

I'm trying to distribute an amount based on a set % for each position but also needs to consider their working days number.

Amount to distribute : 100.000.000

[TABLE="class: grid, width: 650, align: left"]
<tbody>[TR]
[TD]Employe[/TD]
[TD]Position[/TD]
[TD]Position %[/TD]
[TD]Working days[/TD]
[TD]Distributed Amount[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Manager[/TD]
[TD]20%[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Manager[/TD]
[TD]20%[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Leader[/TD]
[TD]18%[/TD]
[TD]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Leader[/TD]
[TD]18%[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Team member[/TD]
[TD]12%[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]Team member[/TD]
[TD]12%[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]











If all the working days are the same I know I can just multiply the percentage of each position to the amount to be distributed. But how do I also take into account the working days so that the distributed amount is fair and the total will still be 100.000.000?

Any help would be appreciated.

Thank you.

 

[PatOBrien198]

Multiply by the % of days worked for each Employee: 30 / sum(all hours worked) for the EE A.
In general: (TotalDistribution) * (Position %) * (EE WorkingDays / Total WorkingDays)
For EE C: 100.000.000 * (.18) * (15 / sum(30 + 30 + 15 + 30 + 20 + 30))