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 07:30

Jewelry manufacturers produce a range of products such as rings, necklaces, bracelets, and brooches. what fundamental economic question are they addressing by offering this range of items?

Answers: 3

Answer

Business, 22.06.2019 14:20

Anew 2-lane road is needed in a part of town that is growing. at some point the road will need 4 lanes to handle the anticipated traffic. if the city's optimistic estimate of growth is used, the expansion will be needed in 4 years and has a probability of happening of 40%. for the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years respectively. the probability of the pessimistic estimate happening is 20%. the expansion will cost $ 4.2 million and the interest rate is 8%. what is the expected pw the expansion will cost?

Answers: 1

Answer

Business, 22.06.2019 19:50

Aproduction line has three machines a, b, and c, with reliabilities of .96, .86, and .85, respectively. the machines are arranged so that if one breaks down, the others must shut down. engineers are weighing two alternative designs for increasing the line’s reliability. plan 1 involves adding an identical backup line, and plan 2 involves providing a backup for each machine. in either case, three machines (a, b, and c) would be used with reliabilities equal to the original three. a. compute overall system reliability under plan 1. (round your intermediate calculations and final answer to 4 decimal places.) reliability b. compute overall system reliability under plan 2. (round your intermediate calculations and final answer to 4 decimal places.) reliability c. which plan will provide the higher reliability? plan2plan1

Answers: 3

Answer

Business, 23.06.2019 00:40

Oliver queen buys 100 shares of stock in green arrow archery corporation, a publicly traded company with which he is not affiliated as a director, officer, or employee. he then sells his 100 shares to john diggle. the sec sues oliver because he didn't register the sale of stock to john. who wins? oliver, because the sale falls into the nonissuer exemption oliver, because the sale falls into the private placement exemption the sec, because the transaction is not exempt from registration the sec, because even exempt transactions must be registered with the sec

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