Question

note: please make sure to properly format your answers. all dollar figures in the answers need to include the dollar sign and any amount over 1,000 should include the comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.06).
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 find the total overtime pay in cell g2.

e. write the formula to compute the total weekly pay in cell h2.

Explanation:

Step1: Regular Gross Pay

Regular gross pay is calculated as regular hours multiplied by hourly rate. So for cell D2, the formula is \(=\text{B2}*\text{C2}\).

Step2: Overtime Hours

Overtime hours are hours worked minus regular hours. So for cell E2, the formula is \(=\text{A2}-\text{B2}\).

Step3: Time - and - a - half Overtime Rate

Time - and - a - half overtime rate is 1.5 times the hourly rate. So for cell F2, the formula is \(=1.5*\text{C2}\).

Step4: Total Overtime Pay

Total overtime pay is overtime hours multiplied by time - and - a - half overtime rate. So for cell G2, the formula is \(=\text{E2}*\text{F2}\).

Step5: Total Weekly Pay

Total weekly pay is regular gross pay plus total overtime pay. So for cell H2, the formula is \(=\text{D2}+\text{G2}\).

Answer:

a. \(=\text{B2}*\text{C2}\)
b. \(=\text{A2}-\text{B2}\)
c. \(=1.5*\text{C2}\)
d. \(=\text{E2}*\text{F2}\)
e. \(=\text{D2}+\text{G2}\)