es Mailings Review View ABCD AaBbccdc AaBbCcDdE Heading 2 Mustard developed a 3-year spreadsheet for a new mustard to be introduced in 2021, Manufacturing estimates Unit Variable Costs (S/Ton) will be decreasing per a linear equation, as they learn to make the product With Unit Variable Costs (S/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.2540.00001" Advertising Costs ($). Marketing used the spreadsheet below to help set Advertising Costs from 2021 to 2023. 2 PARAMETERS 3 Marketonlar Market Share e b Advertising Costs() 2.000 COCO nt Variable Contact/Ton) - 9 + b Cumulative Sa 5200000 $1,000 $10.00 15. 0 0 2021 2022 2023 14 Advertising.com 2022 2023 116 RESULTS year Total Market shares USLON Markthare 700 19 Cumulative is on 70015002400 FRovers 700,000 SHOOOOO O 000 $2,400,000 ooo FFC 00200000,000 $600.000 Unit Variable Coss on) 5465425153801 Variable Costs (5) $325,500 140,000 2000 5 5 00 SIO 5.000 SCOO .00020000145.000 0 TS001152415000 15001 547,500 0 a. What formula was put in cell B17 to do a Fill Right to compute Market Shares to 2023? B17: innost F b. What formula was put in cell B22 to do a Fill Right to compute decreasing Unit Variable Costs as a function of increasing Cumulative Sales from 2021 to 2023? 322 c. What Excel formula was put into cell E26 to compute the 3-Year Total Profits? | E26: d. Marketing wants to use Goal Seck to see what Price will generate $850,000 of 3-Year Total Profits. What should be put in entries of the Goal Seck window? Set cell: To value By changing cell: Focus