Hello Dear Mathmaticians,
I've run into a problem with calculating wages for workers.
4 workers are paid a different percentage from a total weekly amount earned on commission. Every worker worked a different set of hours during the week and must be paid based on work hours.
Here is an example:
Total amount earned was £3000
Worker A is paid a set percentage of 33% of the total amount but has only worked 16 hours
Worker B is paid is also paid 33% of the total amount but he worked 40 hours
Worker C is paid a set percentage of 15% of the total amount and has worked a total of 20 hours
Worker D is paid a set percentage of 19% of the total amount and has worked a total of 17 hours
So far the math I'm doing was leaves me with fluctuating discrepancies based on worker hours and it doesn't come to the total of 100%, here's the formula I've come up with:
(4Δzy / x ) where 4 is for the number of workers, Δ is the total amount earned, z is set percentage for the worker y is the number of hours worked by the worker and x is the total number of hours worked by all workers.
Could anyone point me in the right direction please? or at least tell me if this is solvable.
Many thanks in advance.
To calculate the hourly wage for a given worker you'll want to use the following formula: $$ \frac{Tp}{h} $$ where $T$ is the total amount earned, $p$ is the percent paid to that worker and $h$ is the number of hours worked by that person.
$Tp$ gives the total amount earned by the worker, and dividing by $h$ gives us how much they made on average each hour.