subject
Mathematics, 01.09.2020 23:01 rappidzbn6356

The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate. A B C D E F G H1 Hours worked Regular hours Hourly rates Regular gross pay Overtimes hour Time and a hall overtime rate Total Overtime pay Total gross pay2 42 40 10.5 3 44 40 9 4 45 40 14 Required: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 62. e. Write the formula to compute the total weekly pay in cell H2. f. Use your spreadsheet to fill in the missing entries.

ansver
Answers: 2

Another question on Mathematics

question
Mathematics, 21.06.2019 16:40
What is the perimeter of trapezoid jklm? + units 2 + + units 9 + units 9 + + units
Answers: 2
question
Mathematics, 21.06.2019 20:50
An automobile assembly line operation has a scheduled mean completion time, μ, of 12 minutes. the standard deviation of completion times is 1.6 minutes. it is claimed that, under new management, the mean completion time has decreased. to test this claim, a random sample of 33 completion times under new management was taken. the sample had a mean of 11.2 minutes. assume that the population is normally distributed. can we support, at the 0.05 level of significance, the claim that the mean completion time has decreased under new management? assume that the standard deviation of completion times has not changed.
Answers: 3
question
Mathematics, 21.06.2019 22:00
You buy 4 items that cost 2.69 14.45 8.05 13.95 what is the estimated total round to the nearest dollar
Answers: 1
question
Mathematics, 21.06.2019 23:30
Solve for x and select the correct answer
Answers: 1
You know the right answer?
The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and...
Questions
question
Chemistry, 08.05.2020 10:57
question
Mathematics, 08.05.2020 10:57
question
Mathematics, 08.05.2020 10:57
question
Social Studies, 08.05.2020 10:57
Questions on the website: 13722367