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.

Answers: 2

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 19:30, nyceastcoast

Explain how you can find the missing fraction in 3 4/5 / (blank) 2 5/7. then find the missing fraction.

Answers: 2

continue

Mathematics, 21.06.2019 20:00, martinezjulio1976

Use the elimination method to solve the systems of equations. choose the correct ordered pair. 7x+4y=39

Answers: 1

continue

Mathematics, 21.06.2019 23:50, dbag1162

The federal reserve controls certain interest rates in the united states. investors often try to speculate as to whether the federal reserve will raise or lower rates and by how much. suppose a company conducts extensive interviews with financial analysts, and as a result, predicts that "thefed" will increase rates by an average of 0.25 percentage points every six months for the forseeable future. which type of equation could be used to model the predicted interest rates over the next several years, assuming no other significant changes? a) a linear equation b) a quadratic equation c) a polynomial equation d) an exponential equation

Answers: 3

continue

Mathematics, 22.06.2019 02:50, harodkdc7910

Is (root2 -2)^2 rational or irrational. show the steps and answer fast

Answers: 2

continue

You know the right answer?

The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and...