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

LVPMS

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

« previous next »
 

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Wheat and Cotton Prices and Consumer Price Indexes, 1865–1896 Wheat and Cotton Prices and Consumer Price Indexes, 1865–1896
An example of a selection list used to identify symptoms. An example of a selection list used to identify symptoms.
The U.S. Department of Agriculture offers the SuperTracker tool to help you track, analyze, and plan ... The U.S. Department of Agriculture offers the SuperTracker tool to help you track, analyze, and plan ...
Oil supply and prices affect the economies of nations Oil supply and prices affect the economies of nations
Prices in Japan before and after Opening to Trade Prices in Japan before and after Opening to Trade
Excel hardware is introducing a new product on a new product line of capacity 800 units per ... Excel hardware is introducing a new product on a new product line of capacity 800 units per ...
Video: Action potentials - electrical characteristics and generation

For a complete list of videos, visit our video library