Pay percentages

Question

I pay my 3 employees 50% of all jobs I get and keep 50% myself.

Of their 50%, employee A gets 44.12%, employee B gets 29.41% and employee C gets 26.47%.

So if a job is worth $10,000, I get $5000, employee A gets $2206, employee B gets $1470.50 and employee C gets $1323.50.

If the employees worked for a certain amount of days for that money, (eg 5, so their pay / 5 to get a per day pay), how would I work out how much to deduct from 1 employees pay if they took a day off and reallocate that money to the other employees based on their share?

Ill be looking to use this in a spreadsheet so any help is greatly appreciated.

Answer 1

Whichever employee has taken time off you would take the percentage value they normally recieve and subtract it from 100.

Then for each of the other 2 employees take their percentage 'cut' and divide it by the previously calculated value and then multiply it by 100. This will give you their new percentage cut in relation to the other employee.

Finallly pay out the total value of the job in the new percentage ratios to the working employees, depending on how many days one employee takes off.

Hopefully this helps.

EDIT For example, on a job that costs 10000, worker A takes 2 days off. So for these 2 days the payment percentage between the other 2 employees is :

• Worker B: $0.5*10000*\frac{2}{daystofinishjob}*\frac{29.41}{100-44.12}$

• Worker C : $0.5*10000*\frac{2}{daystofinishjob}\frac{26.47}{100-44.12}$

Answer 2

Each worker should be paid $\frac{d_ip_i}{d_1p_1+d_2p_2+d_3p_3}$, where $d_i$ is the number of says worker $i$ actually worked and $p_i$ is the original percentage allocated to worker $i$ if they all work the same number of days.