Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Task \# Points Task Description Use the scenario manager to input each of the four decision sets depicted in the picture near cell B16. Make sure the scenario name is the name given in the image. You must type the data into scenario manager, because Excel does not allow you to use a cell reference to enter data into a Scenario. Create the summary of the scenarios. Enter the name of the most profitable scenario in cell D22 using the dropdown box in the cell. Create a goal seek analysis to determine what the price should be to generate demand of 2,625,000 tablets given that the supplier contract is $75,000,000 and the advertising budget is $35,000,000 (you may need to change these values). Complete the analysis using the Goal Seek tool. As Goal Seek does not store your entries; enter the "Set cell", "To value", and "By changing cell" elements of your analysis in cells C25, C26, C27, respectively, for grading purposes. Enter the resulting price in cell C29. Create a one-way data table using the values in cells B32:B43 after referencing total profit (calculated in cell F12) to determine the supplier contract amount that leads to the most profit given that price is $290 and advertising budget is $35,000,000. Enter this contract amount in cell C45. Notice the "Supplier Contract and Profitability" chart updates with the values in the data table to visually demonstrate the relationship between supplier contract amounts and profitability. Create a two-way data table after referencing total profit (calculated in cell F12) and using the values in cells B49:B69 (Price) and C48:E48 (Advertising Budget) to analyze the relationships among advertising budget, price, and profitability. Make sure you highlight cells B48:E69 before going to the Data Table tool. 4 15 Complete the "Price, Advertising, and Profitability" chart to include series for advertising budgets $50,000,000 and $75,000,000 on your data table (notice that the series for $25,000,000 is already on the chart). Enter the advertising budget amount from your analysis that will produce the most profit E71. Enter the price that will product the most profit in cell E72