{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# week04 - WELCOME EF 105 Spring 2006 Topics 1.USING SOLVER 2...

This preview shows pages 1–11. Sign up to view the full content.

WELCOME WELCOME EF 105                Spring 2006

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
1.USING SOLVER 2. MAKING Templates 3. Links 4. Scenarios Working with Revised Annual Forecast.xls Topics
1. USING SOLVER (Pages EX4-6 – EX4-9) a) Concept 1: Solver  is a tool that is used to  perform what-if analysis to determine the effect of  changing values in two or more cells, called  adjustable  cells, on the  target cell . 1) Solver works backward from the result using a  formula to find the numbers. 2) Solver can produce three types of reports:  Answer, Sensitivity, and Limits.  Display the Fourth Quarter Sheet b) Choose: T ools/ S olver to open the Solver  Parameters dialog box.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

c) The Solver Parameters dialog box lets you  specify the three parameters necessary to complete  the command: 1) The Set Target Cell text box lets you enter the  cell reference of the cell containing the formula you  want to solve. 2) The Equal To options let you set the target cell  for: The highest possible value (Max), The lowest possible value (Min), An amount equal to a specified value in the  Value of text box.  - Select: V alue of. - Type: Your goal (e.g., .13).

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

Note: If the dialog box is in the way, use the mouse pointer to drag it to another area. 3) The By Changing Cells text box lets you  specify the cells that need to be adjusted to meet the  goal. In this example, the cells will consist of the  salary values located in cells B15:D15. d) Click: S olve   to recalculate the formula in the  target cell so you can see the values required to  meet your goal. 1) The calculated values (\$23,604) are displayed  in the worksheet cells, and the Solver Results dialog  box is displayed.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2) You can select either of two options: Select: K eep Solver Solution to retain the  recalculated values. Select: Restore  O riginal Values to replace  the calculated results with the original values. 3) The Solver Results dialog box also lets you  create a report of the Solver solution. To create a  report of the answer and exit the Solver Results  dialog box: Select: R eports/Answer.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}