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 128 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
Thanks for the timely response, appreciate it

rachel

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

« previous next »
 

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

five week embryo five week embryo
Tooth enamel is laid down in daily increments, with darker bands accumulating about once a week. Tooth enamel is laid down in daily increments, with darker bands accumulating about once a week.
Outcome of myocardial infarction. Forty percent of 1-week survivors have late complications ... Outcome of myocardial infarction. Forty percent of 1-week survivors have late complications ...
Baby position during the 30th week of pregnancy Baby position during the 30th week of pregnancy
Jia's Fashions recently paid a $2 annual dividend. The company is projecting that its ... Jia's Fashions recently paid a $2 annual dividend. The company is projecting that its ...
Video: System organization - PPM system types (Somatic, Autonomic & Enteric) and Reflex arc types

For a complete list of videos, visit our video library