In cell e7, create a formula that calculates the salary for sarah, one of the servers at the good breeze hotel. her salary is calculated by multiplying the number of regular hours worked (cell b7) by her hourly rate (cell d7), and then adding to that the number of overtime hours worked (cell c7) multiplied by her hourly rate (cell d7) times 1.5. (hint: sarah is paid 50% more than-or 1.5 times-her regular hourly rate when she works overtime.)

Question

Clay Villa

Mathematics

23 March, 07:55

In cell e7, create a formula that calculates the salary for sarah, one of the servers at the good breeze hotel. her salary is calculated by multiplying the number of regular hours worked (cell b7) by her hourly rate (cell d7), and then adding to that the number of overtime hours worked (cell c7) multiplied by her hourly rate (cell d7) times 1.5. (hint: sarah is paid 50% more than-or 1.5 times-her regular hourly rate when she works overtime.)

+3

Answers (1)

Know the Answer?

Amir Lowe · Answer 1

Given that number of "Hours worked" is entered into cell B7.

Given that "Hourly rate" is entered into cell D7.

Given that "Overtime hours" is entered into cell C7.

And the salary is calculated into cell E7.

Now we need to write formula for salary which needs to be entered into cell E7.

Salary = [Hours worked]*[Hourly rate] + [Overtime hours]*[Hourly rate]*[1.5]

[E7] = [B7]*[D7] + [C7]*[D7]*[1.5]

Hence final answer that you need to type in cell E7 is "=B7*D7+C7*D7*1.5".