The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate.
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 fi nd 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 fi ll in the missing entries.
