Question

Use the scenario manager to input each of the four decision sets depicted in range a. the names of each decision set are given in cells use the decision set name as the scenario name in each of the four scenarios. the grader requires the scenario names be spell correctly. b. you must type the data into scenario manager, because excel does not allow you

Question: 2.1) Use The Scenario Manager To Input Each Of The Four Decision Sets Depicted In Range A. The Names Of Each Decision Set Are Given In Cells Use The Decision Set Name As The Scenario Name In Each Of The Four Scenarios. The Grader Requires The Scenario Names Be Spell Correctly. B. You Must Type The Data Into Scenario Manager, Because Excel Does Not Allow You
2.1) Use the Scenario Manager to input each of the four decision sets depicted in range a. The names of each decision set are given in cells Use the decision set name as the Scenario Name in each of the four scenarios. The grader requires the Scenario Names be spell correctly. b. 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. c. Create the şummary of the scenarios on a new worksheet. d. Do not renäme the scenario summary sheet generated by the scenario manager. The grader uses the default sheet name during the grading process. If you need to re-create the scenario summary, delete the original scenario summary sheet before creating another scenario summary. 4.1 Use the Goal Seek tool to determine the price that will generate demand of 2,625,000 tablets. a. Make sure that the supplier contract (cell (4) is $75,000,000 and the advertising budget (cell (C5) is $35,000,000 (you may need to manually change these values). b. Goal Seek does not store your entries. For grading purposes, you will identify the "Set cell", "To value", and "By changing cell" elements of your analysis by answering multiple choice questions. Supplier Contract and Profitability Price, Advertising, and Profitability - as.onenos

Answer 1

The Scenario Manager in Excel allows the input of different sets of decision data to compare outcomes. To do this, one should use the What-If Analysis tool and create scenarios with specific names and values without changing the default summary sheet name.

Step-by-step explanation:

In Microsoft Excel, the Scenario Manager is a tool used to create and save different groups of input values that affect a particular outcome, which can be compared side by side. To input decision sets into the Scenario Manager, follow these steps:

1. Select the cell or cells that will change between the scenarios.
2. Go to the Data tab and then to What-If Analysis, and select Scenario Manager from the dropdown menu.
3. In the Scenario Manager dialog box, click Add to create a new scenario.
4. Enter the name of the decision set, adhering to correct spelling as required by the grader.
5. Type in the values for the scenario according to the information provided in range A.
6. Repeat the process for each decision set.
7. Once all scenarios are entered, you can generate a summary report on a new worksheet by clicking the Summary button within the Scenario Manager.
8. Do not rename the summary sheet; leave it with the default name that Excel provides.

To use the Goal Seek tool for finding the price that will generate a specific tablet demand:

1. Ensure that the supplier contract and advertising budget cells have the correct values entered.
2. Go to the Data tab, select What-If Analysis, and then Goal Seek.
3. Set up the Goal Seek parameters by specifying the 'Set cell' to the cell containing the demand formula, the 'To value' to 2,625,000, and the 'By changing cell' to the cell containing the price.
4. Once the setup is complete, click OK to run Goal Seek and watch for Excel to find the required price.