The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate. с
D
F
G
H
Hours
Worked
Hourly
Regular
Gross Pay
Overtime
Hours
Tima-and-a-
Hall Overtime
Rate
1
Total Overtime
Pay
Total Gross
Pay
2
3
Regular
Hours
40
40
40
Rate
16.00
19.00
15.30
45
a. Write the formula to compute the regular gross pay in cell D2.
b. Write the formula to compute the Fertime 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.