What-If+Analysis

= **What-If Analysis ** = 

Maximize the number of quality cupcakes produced with the minimum number of baker hours using Solver.
media type="youtube" key="ZyehZAbj9Iw" height="315" width="560" align="center"

=Solver Help=



=
__**What-If Analysis **__ is the process of changing variables to observe how changes affect calculated results. You can experiment with different variables or assumptions to see the changed results. =====

=

 * TIP **–To help explain the concept, give the students some examples that have meaning to them. For example, a spreadsheet with their college expenses and income and then some scenarios like tuition increase of 7% or loss of scholarship.=====

** TIP ** –To create the data table

 * ===== Locate the data table to the right or below the dataset, leaving one blank row or column. Create a title like One-Variable Data Table; Calculated results for each annual percentage rate. =====
 * ===== Type the first value in the starting cell, click the Home tab, click Fill in the editing group, and then select Series =====
 * ===== In the Series dialog box, click rows or columns, and then enter the value increment and the ending value in the Stop value. Click OK. =====

=

 * Two-variable data table ** –Data analysis tool that provides results based on changing two variables. Use an array to do this by placing one variable’s substitution value at the top row and the other variable’s substitution values as the first column. =====

** TIP ** –To use Goal Seek

 * ===== Click What-If Analysis in the Data Tools group on the Data tab =====
 * ===== Select Goal Seek =====
 * ===== Enter the cell reference for the cell to be optimized in the Set cell box (must be a formula) =====
 * ===== Enter the result to achieve in the To value box =====
 * ===== Enter the cell reference that contains the variable to adjust in the By Changing cell box =====

=

 * TIP – ** Scenarios are placed on the worksheet that was active when you created the scenario. Different scenarios can be created for each worksheet in a workbook. The Scenario Manager dialog box displays only those scenarios created on the active worksheet. =====

** TIP **–To define constraints

 * =====Click Solver in the Analysis group, and then click Add=====
 * =====Click the appropriate cell, select the appropriate operator arrow, and then type the value in constraint box=====
 * =====Continue adding constraints by clicking Add and completing the constraint=====
 * =====At the last one, click OK=====

** TIP **–Once Solver finds a solution, a Solver Results box appears

 * =====Click Keep Solver Solution to keep the changed objective and variable values or Restore Original Values to return the original values in the worksheet=====
 * =====Select Answer in the reports area, and then click OK. The solver report appears on a new worksheet with the optimal solution.=====