4. the overtime rate is 1.5 times the regular hourly rate.\na) explain how the amounts given in cells e2 to…

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

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

Answer

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$