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 146 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

ecabral0

  • Member
  • Posts: 310
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Malcolm X in a photo taken a week before his assassination. Malcolm X in a photo taken a week before his assassination.
Holy Week in Spain Holy Week in Spain
How to create a table of values displaying commission and earnings (Question 2) How to create a table of values displaying commission and earnings (Question 2)
Overallocation of Labor to Farming When Farmworkers Are Paid Their Average Product Overallocation of Labor to Farming When Farmworkers Are Paid Their Average Product
Seven-week embryo showing development of arm, forearm, and hand Seven-week embryo showing development of arm, forearm, and hand
Sexual Development begins in the Seventh week of Gestation Sexual Development begins in the Seventh week of Gestation
Video: Types of Transport - Uniport, Antiport and Symport (Glucose and Na+K+ Transporters)

For a complete list of videos, visit our video library