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 14:50, breexj

Polygon mnopq is dilated by a scale factor of 0.8 with the origin as the center of dilation, resulting in the image m′n′o′p′q′. the coordinates of point m are (2, 4), and the coordinates of point n are (3, 5). the slope of is .

Answers: 2

continue

Mathematics, 21.06.2019 18:00, aleilyg2005

List the sides of δrst in in ascending order (shortest to longest) if: m∠r =x+28°, m∠s = 2x+16°, and m∠t = x+12°

Answers: 1

continue

Mathematics, 21.06.2019 19:00, munozgiselle

If (x-2) 2= 49, then x could be a. -9 b. -7 c.- 2 d. 5 e.9

Answers: 2

continue

Mathematics, 21.06.2019 22:20, ashtonviceoxd21i

Which strategy is used by public health to reduce the incidence of food poisoning?

Answers: 1

continue

Do you know the correct answer?

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

Questions in other subjects:

History, 30.12.2019 13:31

What was the result of reconstruction on the five civilized tribes...

English, 30.12.2019 13:31

Staples says, “i chose, perhaps unconsciously, to remain shadow- timid, but a survivor” (par. 7). what are the usual connotations of the word survivor? is “timid” one of them? ho...

Spanish, 30.12.2019 13:31

What might you be able to buy at a meracallio?...

English, 30.12.2019 13:31

Look at the blank with the number (11) in the passage. which of these answers correctly completes the sentence? a) by b) in -c) of d) to...

Mathematics, 30.12.2019 13:31

What does x equal and how do i find x?...

English, 30.12.2019 13:31

Which letter of the english alphabet flies, sings, and stings?...

English, 30.12.2019 13:31

What is the best term for logical fallacy?...

Mathematics, 30.12.2019 13:31

If 4 less than a number is less than 4 and greater than -3, find the number....

Biology, 30.12.2019 13:31

This nutrient is needed for proper growth and development and functions to repair and replace body cells....

Mathematics, 30.12.2019 13:31

Acontainer is filled with 64l of orange juice, then 12l of juice is removed and the container is topped up with lemon juice. the juice is thoroughly mixed before 12l of the mixture...

Other tasks in the category: Mathematics More task