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

Ds unlimited has the following transactions during august. august 6 purchases 58 handheld game devices on account from gamegirl, inc., for $140 each, terms 2/10, n/60. august 7 pays $340 to sure shipping for freight charges associated with the august 6 purchase. august 10 returns to gamegirl three game devices that were defective. august 14 pays the full amount due to gamegirl. august 23 sells 38 game devices purchased on august 6 for $160 each to customers on account. the total cost of the 38 game devices sold is $5,448.51. required: record the transactions of ds unlimited, assuming the company uses a perpetual inventory system. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. round your answers to 2 decimal places.)

Answers: 2

Answer

Business, 22.06.2019 10:30

How are interest rates calculated by financial institutions? financial institutions generally calculate interest as (1) interest or (.

Answers: 1

Answer

Business, 22.06.2019 12:30

Sales at a fast-food restaurant average $6,000 per day. the restaurant decided to introduce an advertising campaign to increase daily sales. to determine the effectiveness of the advertising campaign, a sample of 49 days of sales were taken. they found that the average daily sales were $6,300 per day. from past history, the restaurant knew that its population standard deviation is about $1,000. if the level of significance is 0.01, have sales increased as a result of the advertising campaign? multiple choicea)fail to reject the null hypothesis.b)reject the null hypothesis and conclude the mean is higher than $6,000 per day.c)reject the null hypothesis and conclude the mean is lower than $6,000 per day.d)reject the null hypothesis and conclude that the mean is equal to $6,000 per day.expert answer

Answers: 3

Answer

Business, 22.06.2019 17:40

Slimwood corporation made sales of $ 725 million during 2018. of this amount, slimwood collected cash for $ 670 million. the company's cost of goods sold was $ 300 million, and all other expenses for the year totaled $ 400 million. also during 2018, slimwood paid $ 420 million for its inventory and $ 285 million for everything else. beginning cash was $ 110 million. carter's top management is interviewing you for a job and they ask two questions: (a) how much was carter's net income for 2018? (b) how much was carter's cash balance at the end of 2016? you will get the job only if you answer both questions correctly.

Answers: 1

Answer

You know the right answer?

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

Questions