Question

1. the overtime rate is 1.5 times the regular hourly rate.

a) explain how the amounts given in cells e2 to i2 were calculated.
b) fill down columns e to i, rows 2 to 6. what are the total weekly earnings for the others?
a b c d e f g h i
name hours worked regular hourly rate ($) regular hours regular earnings ($) overtime hours overtime rate ($) overtime earnings ($) total weekly earnings ($)
1
2 mike 45 7.50 44 330.00 1 11.25 11.25 341.25
3 isobel 45 9.50×1.5 44
4 denise 50 12.60 44
5 peter 48 8.50 44
6 sara 47 7.75 44

Explanation:

Step1: Calculate regular earnings

Regular earnings = Regular hourly rate × Regular hours. For example, for Mike in cell E2, it's $7.50\times44 = 330.00$.

Step2: Calculate overtime hours

Overtime hours = Total hours worked - Regular hours. For Mike, $45 - 44=1$.

Step3: Calculate overtime rate

Overtime rate = 1.5×Regular hourly rate. For Mike, $1.5\times7.50 = 11.25$.

Step4: Calculate overtime earnings

Overtime earnings = Overtime rate × Overtime hours. For Mike, $11.25\times1 = 11.25$.

Step5: Calculate total weekly earnings

Total weekly earnings = Regular earnings+Overtime earnings. For Mike, $330.00 + 11.25=341.25$.

Step6: For Isobel

Regular earnings: $9.50\times44 = 418.00$. Overtime hours: $45 - 44 = 1$. Overtime rate: $1.5\times9.50=14.25$. Overtime earnings: $14.25\times1 = 14.25$. Total weekly earnings: $418.00+14.25 = 432.25$.

Step7: For Denise

Regular earnings: $12.60\times44 = 554.40$. Overtime hours: $50 - 44 = 6$. Overtime rate: $1.5\times12.60 = 18.90$. Overtime earnings: $18.90\times6=113.40$. Total weekly earnings: $554.40 + 113.40=667.80$.

Step8: For Peter

Regular earnings: $8.50\times44 = 374.00$. Overtime hours: $48 - 44 = 4$. Overtime rate: $1.5\times8.50 = 12.75$. Overtime earnings: $12.75\times4 = 51.00$. Total weekly earnings: $374.00+51.00 = 425.00$.

Step9: For Sara

Regular earnings: $7.75\times44 = 341.00$. Overtime hours: $47 - 44 = 3$. Overtime rate: $1.5\times7.75 = 11.625$. Overtime earnings: $11.625\times3 = 34.875$. Total weekly earnings: $341.00+34.875 = 375.875$.

Answer:

Isobel: $432.25$
Denise: $667.80$
Peter: $425.00$
Sara: $375.875$