The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and

Question:

The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate.
The following spreadsheet can be used to compute total weekly

a. Write the formula to compute the regular gross pay in cell D2.
b. Write the formula to compute the overtime hours in cell E2.
c. Write the formula to compute the time and a half overtime hourly rate in cell F2.
d. Write the formula to find the total overtime pay in cell G2.
e. Write the formula to compute the total weekly pay in cell H2.
f. Use your spreadsheet to fill in the missing entries?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: