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 17:30
Apublic library wants to place 4 magazines and 9 books on each display shelf. the expression 4s+9s represents the total number of items that will be displayed on s shelves. simplify the expression
Answers: 2
question
Mathematics, 21.06.2019 18:00
Adj has a total of 1075 dance and rock songs on her system. the dance selection is 4 times the size of the rock selection. write a system of equations to represent the situation.
Answers: 1
question
Mathematics, 21.06.2019 18:30
Do some research and find a city that has experienced population growth. determine its population on january 1st of a certain year. write an exponential function to represent the city’s population, y, based on the number of years that pass, x after a period of exponential growth. describe the variables and numbers that you used in your equation.
Answers: 3
question
Mathematics, 21.06.2019 19:00
The length of a rectangular piece of land is 92 yards more than three times its width. the perimeter is 760 yards. find its dimensions.
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
Physics, 12.11.2019 03:31
question
Social Studies, 12.11.2019 03:31
Questions on the website: 13722367