This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Mr. Ortiz is paid a salary of 575 each week and 5 commission on sales over 10,000 less any returned ... (Read 145 times)

DyllonKazuo

  • Hero Member
  • *****
  • Posts: 565
on: Jun 24, 2018
Mr. Ortiz is paid a salary of 575 each week and 5 commission on sales over 10,000 less any returned merchandise. His sales information is located in a spreadsheet where salary is in Cell B2, commission rate expressed as a decimal is in Cell C2, returns are in Cell D2, and total weekly sales are in Cell E2. What formula should be in Cell F2 to calculate Mr. Ortiz's net weekly pay?

Question 2

A payroll register has the employees' names in Column A, Social Security numbers in Column B, hourly wages in Column C, regular hours in Column D, and overtime hours in Column E. If overtime is paid at time-and-a-half, what formula should be entered in Column F for regular pay, Column G for overtime pay, and Column H for gross pay? Use Row 1 in all formulas.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

isabelt_18

  • Sr. Member
  • ****
  • Posts: 342
Reply #1 on: Jun 24, 2018
Answer to Question 1

#REF!

Answer to Question 2

Column F: =C1D1
Column G: =1.5C1E1
Column H: =F1+G1


DyllonKazuo

  • Member
  • Posts: 565
Reply 2 on: Jun 24, 2018
YES! Correct, THANKS for helping me on my review

vickyvicksss

  • Member
  • Posts: 351
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Pregnant sow one week before delivering three pups Pregnant sow one week before delivering three pups
Chinese workers on a railway in the far West. “Without them,” Leland Stanford, president of the Cent Chinese workers on a railway in the far West. “Without them,” Leland Stanford, president of the Cent
Holy Week in Spain Holy Week in Spain
40th Week pregnancy period baby 40th Week pregnancy period baby
After 159 days,she paid a maturity value of $11,626, which included interest of $814. After 159 days,she paid a maturity value of $11,626, which included interest of $814.
An 8-week-old fetus An 8-week-old fetus
Video: Cardiac conductile cells

For a complete list of videos, visit our video library