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

aruss1303

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

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?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Baby position during the 30th week of pregnancy Baby position during the 30th week of pregnancy
Baby's eyes are developed in 6th week of pregnancy Baby's eyes are developed in 6th week of pregnancy
Week by week fetus growth Week by week fetus growth
Embryonic Period - 12th week Embryonic Period - 12th week
Sonja is paid $42.50 per hour as a veterinarian. She is paid 1 times the regular rate for all ... Sonja is paid $42.50 per hour as a veterinarian. She is paid 1 times the regular rate for all ...
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: Secondary Active Transport

For a complete list of videos, visit our video library