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

Other questions on the subject: Business

Business, 22.06.2019 16:40, yoooo9313

An electronics store is running a promotion where for every video game purchased, the customer receives a coupon upon checkout to purchase a second game at a 50% discount. the coupons expire in one year. the store normally recognized a gross profit margin of 40% of the selling price on video games. how would the store account for a purchase using the discount coupon?

Answers: 3

continue

Business, 23.06.2019 00:50, Bunnybear3384

On january 1 of the current year, jimmy's sandwich company reported owner's capital totaling $128,000. during the current year, total revenues were $106,000 while total expenses were $95,500. also, during the current year jimmy withdrew $30,000 from the company. no other changes in equity occurred during the year. if, on december 31 of the current year, total assets are $206,000, the change in owner's capital during the year was:

Answers: 3

continue

Business, 23.06.2019 02:10, Thejollyhellhound20

Make or buy eastside company incurs a total cost of $120,000 in producing 10,000 units of a component needed in the assembly of its major product. the component can be purchased from an outside supplier for $11 per unit. a related cost study indicates that the total cost of the component includes fixed costs equal to 50% of the variable costs involved. a. should eastside buy the component if it cannot otherwise use the released capacity? present your answer in the form of differential analysis. use negative sign represent a net disadvantage answer; otherwise do not use negative signs with your answers. cost from outside supplier $answer variable costs avoided by purchasing answer net advantage (disadvantage) to purchase alternative $answer b. what would be your answer to requirement (a) if the released capacity could be used in a project that would generate $50,000 of contribution margin? use negative sign represent a net disadvantage answer; otherwise do not use negative signs with your answers.

Answers: 2

continue

Business, 23.06.2019 09:40, thomisonariel9800

Max wants to open a basic checking account at his local bank. he needs to bring his and , along with a $50 deposit, to open the account.

Answers: 3

continue

You know the right answer?

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