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 121 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
Excellent

31809pancho

  • Member
  • Posts: 317
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

The joint commission 2011 The joint commission 2011
Malcolm X in a photo taken a week before his assassination. Malcolm X in a photo taken a week before his assassination.
Men and women work the same number of hours a week, but men spend more time on paid work, and women ... Men and women work the same number of hours a week, but men spend more time on paid work, and women ...
Holy Week in Spain Holy Week in Spain
Embryonic Period - 8th week Embryonic Period - 8th week
Video: Dendrite Animation

For a complete list of videos, visit our video library