Task # Points Task Description 1 / 15 Use the scenario manager to input each of the four decision sets depicted in the pictur Price, Advertising, and Rebates for QuickStove Combination Kits Decisions to be Made Price Rebate Advertising Budget $30.00 $Advertising Budget $10,000.00 $0.00 $20,000.00 Advertising, Rebate, and Profitability $1.20 $1.00 5080 $0.00 Rebate $0.00 $1. what is not clear about the question? Show transcribed image text View comments (1) Expert Answer An expert answer will be posted here Questions viewed by other students Q: 1. Use the scenario manager to input each of the four following decision sets depicted in the picture near cell B16. Make sure the scenario name is the 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... A: See answer Q: Create a one-way data table using the values in cells B32:B43 and 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...