This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how ... (Read 134 times)

BrownTown3

  • Hero Member
  • *****
  • Posts: 564
on: Jun 24, 2018
A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how different sales will affect the company's bottom line. One item in Cell B4 has a list price of 172.89. Varying rates for discount 1 and discount 2 can be entered into Cells B5 and B6. Which formula should be entered into Cell B7 to calculate the net-price equivalent?
 A) =B4B5B6
  B) =B4(1-B5)(1-B6)
  C) =1-(B5+B6)
  D) =(1-B5)(1-B6)

Question 2

Kermit and Chris bought a vacation package for 3,999. There is a 4.75 sales tax added to the package. What is the total cost?
 A) 4,188.95
  B) 4,118.15
  C) 3,817.66
  D) 3,813.05


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

meltdown117

  • Sr. Member
  • ****
  • Posts: 326
Reply #1 on: Jun 24, 2018
Answer to Question 1

D

Answer to Question 2

A


BrownTown3

  • Member
  • Posts: 564
Reply 2 on: Jun 24, 2018
Gracias!

parshano

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

« previous next »
 

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

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.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Rackstraw Downes, Presidio in the Sand Hills Looking East with ATV Tracks and Water Tower. Rackstraw Downes, Presidio in the Sand Hills Looking East with ATV Tracks and Water Tower.
Medical Office To Do List Medical Office To Do List
The official “Do Not Use” list as issued by The Joint Commission. The official “Do Not Use” list as issued by The Joint Commission.
Conversion List Conversion List
How to fully analyze the standard and factored form of a quadratic equation (Question 1) How to fully analyze the standard and factored form of a quadratic equation (Question 1)
The net price of an article is $79.84. What is the list price if a discount of 23% was allowed? The net price of an article is $79.84. What is the list price if a discount of 23% was allowed?
Video: Endocytosis -Types and Phagocytosis

For a complete list of videos, visit our video library