Using a fresh new Excel file:

Step 1. Click the DATA tab in the Ribbon

Step 2. Click What-If Analysis in the Data Tools group, and select Goal Seek

Step 3. When the Goal Seek dialog box appears:

Enter B17 in the Set Cell: box

Enter 0 in the To Value: box

Enter B11 in the By Changing Cell: box

Click OK

Step 4. When the Goal Seek Status dialog box appears, click OK

Scenario Manager is an Excel tool that quantifies the impact of changing multiple inputs (a setting of these multiple inputs is called a scenario) on one or more outputs of interest.

Scenario Manager extends the data table concept to cases when you are interested in changing more than two inputs and want to quantify the changes these inputs have on one or more outputs of interest.

PROBLEM 4: Using Scenario Manager (Please open Excel file: Middletown.xIsx) Step 1. Click the DATA tab in the Ribbon Step 2. Click What-If Analysis in the Data Tools group, and select Scenario Manager ... Step 3. When Scenario Manager dialogue box appears, click ADD ... button in Scenario Manager dialog box Step 4. When the Add Scenario dialog box appears, type Partly Cloudy in the Scenario Name box, and, type $6:$B$S$11 in the Changing Cells box, then, click OK Step 5. When the Scenario Values dialogue box appears, type 3000 in the \$\$B'6 box, and, type 1600 in the \$B\$ 7 box, and, type 15 in the $$8 box, and, type 45 in the $$9 box, and, type 33000 in the $11 box, then, click OK Step 6. When the Scenario Manager dialogue box re-appears, repeat steps 3 to 5 for each scenario shown in above Table (Rain and Sunny) Step 7. When all scenarios have been entered and the Scenario Manager dialogue box re-appears, click Summary ... Step 8. When the Scenario Summary dialogue box appears, select Scenario Summary, and, type B25 in the Results Cells box (B25 is the cell location for Profit formula in Spreadsheet), then, click OK NOTE: The Scenario Summary report appears on a separate worksheet From your Excel file with the above steps completed, what is the Daily Profit for Middletown Amusement Park when the weather SUNNY? (Enter your response here)