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 131 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
Great answer, keep it coming :)

JaynaD87

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

« previous next »
 

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Holy Week in Spain Holy Week in Spain
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 ...
Northern blot of the G14 subunit in the salivary glands of a 1-week-old and a 4- to 6-week-old rat. ... Northern blot of the G14 subunit in the salivary glands of a 1-week-old and a 4- to 6-week-old rat. ...
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)
Seven-week embryo showing development of arm, forearm, and hand Seven-week embryo showing development of arm, forearm, and hand
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.
Video: Exercise and cardiac output & Definition of stroke volume

For a complete list of videos, visit our video library