The XYZ company received a large order for widgets. As a result Mary had to work 6.5 hours of overtime. Mark worked 5 hours of overtime and Martin worked 8. They all worked a normal 40 hour week in addition. Mary earns $5.50 and hour, Mark $4.75 and Martin $6.00. Because the order was very profitable, they all earned extra overtime pay of $2.10 an hour. Thus Mary got $7.60, Mark got $6.85, and Martin got $8.10 an hour for overtime. What is the XYZ payroll for the week? This problem requires a straight forward extension of the wage formula wage = rate X time It is not uncommon to have to modify one of the formulas slightly. In this case, wages are asked for, but two different hours and rates are required. Thus the extended wage equation is: rate X time + over rate X over time = wage.

Click to see the XYZ payroll table, the program, or the results.
Look at compound column names like "over time." Go to the sales tax or a multiple step. problem.