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

Employe	Position	Position %	Working days	Distributed Amount
A	Manager	20%	30
B	Manager	20%	30
C	Leader	18%	15
D	Leader	18%	30
E	Team member	12%	20
F	Team member	12%	30

<tbody>
</tbody>

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))