Monkey Banana developed a 3-year spreadsheet (below) for a new banana-butter product to be introduced in 2021. Manufacturing said that Unit Variable Costs ($/Ton) will be decreasing, per a linear equation, as they learn to make the product. With Unit Variable Costs ($/Ton) = 5000.05*Cumulative Sales (Tons). Meanwhile, the Market Research Department estimated that Market Share will depend on Advertising Costs according to: Market Share = 0.25+0.00001*Advertising Costs ($). Marketing used the spreadsheet below the help set Advertising Costs from 2021 to 2023

a. What formula was put in cell B16 to do a Fill Right to compute Market Shares as Advertising Costs increase to 2023?

B16: =

b. What formula was put in cell B21 to do a Fill Right to compute decreasing Unit Variable Costs as a function of increasing Cumulative Sales from 2021 to 2023?

B21: =

c. What Excel formula was put into cell E25 to compute the 3-Year Total Profits?

E25: =

d. Marketing wants to use Goal Seek to see what Price will generate $800,000 of 3-Year Total Profits. What should be put in the following entries of the Goal Seek window to the right?

Set cell:

To value:

By changing cell:

1 PARAMETERS 2 Market (Tons/year) 2,000 Market Share(%) - a + b Advertising Costs(S) a= 0.25 b= 0.00001 Unit Variable Costs($/Ton) - a + b Cumulative Sales(Tons) b= -0.05 $200,000 10 Fixed Cost (S/year) Price (S/Ton) $1.000 2021 | $10,000 2022 $15.000 2023 $20,000 12 VARIABLE 15 Advertising Costs($) 15 RESULTS 16 Market Share ) 17 Sales (Tons Market Share Market Size 18 Cumulative Sales(Tons) 10 Revenues (5) 20 Fixed Cost (5) 21 Unit Variable Costs (S/Ton) 22 Variable Costs (5) 23 Advertising Costs(s 24 Total Costs(S) 25 Pros) 2021 2022 20233year Total 40.0% 45.0% 2.400 1500 2400 $700,000 $800,000 $900.000 $2,400,000 $200,000 $200,000 $200,000 $600,000 5465 5425 5380 $325,500 $340,000 $342.000 $1,002500 $10.000 $15.000 $20,000 $45,000 $535.500 $555.000 $582 000 $1.652.500 $164,500 $245,000 $330.00015747,500 Goal Seek Set cell: To yalue: By changing cell: OK Cancel