Business, 13.05.2021 19:20 famouzgal

BrushEm sells toothpaste and has to decide whether to raise prices starting in 2021. It evaluated how much Extra Revenue will be generated by the new price of $2.50($/tube) versus the current price of $2.00. Its Market Share (in units) decreases with a price increase per a linear model: Market Share = 1.0-0.1*Price. The expected 2020 Market Size for toothpaste is 100 million (M) tubes and is expected to grow 5.0M tubes per year. Below is the spreadsheet BrushEm used to estimate the Extra Revenue a. What Excel formulas were put into cells B14 and B19 to compute Market Shares with the Current and the New Price, respectively?
B14: = B19: =
b. What formula was put into cell C15 in order to do a Fill Right to calculate Sales with the Current Price from 2020 to 2023?
C15: =
c. What formula was put into cell C21 to do a Fill Right to calculate Revenue with the New Price from 2021 to 2023?
C21: =
d. What formula was put into cell C24 to compute the Extra Revenue in 2021 as the difference between Revenue with the New Price minus the Revenue with the Current Price?
C24: =

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 01:00

The law says your employer is responsible for providing you with a safe and healthy workplace. true or false?

Answers: 1

Answer

Business, 22.06.2019 01:30

Iam trying to get more members on my blog. how do i do this?

Answers: 3

Answer

Business, 22.06.2019 03:30

Nellie lumpkin, who suffered from dementia, was admitted to the picayune convalescent center, a nursing home. because of her mental condition, her daughter, beverly mcdaniel, signed the admissions agreement. it included a clause requiring the par- ties to submit any dispute to arbitration. after lumpkin left the center two years later, she filed a suit against picayune to recover damages for mistreatment and malpractice. [covenant health & rehabilitation of picayune, lp v. lumpkin, 23 so.2d 1092 (miss. app. 2009)] (see page 91.) 1. is it ethical for this dispute—involving negligent medical care, not a breach of a commercial contract—to be forced into arbitration? why or why not? discuss whether medical facilities should be able to impose arbitration when there is generally no bargaining over such terms.

Answers: 3

Answer

Business, 22.06.2019 07:30

Which of the following is an example of an unsought good? a. cameron purchases a new bike. b. jordan buys paper towels. c. taylor buys cupcakes from her favorite bakery. d. riley buys new windshield wipers for her car.

Answers: 3

Answer

You know the right answer?

BrushEm sells toothpaste and has to decide whether to raise prices starting in 2021. It evaluated ho...

Questions