Week04 - WELCOME EF 105 Spring 2006 Topics 1.USING SOLVER 2 MAKING Templates 3 Links 4 Scenarios Working with Revised Annual Forecast 1 USING

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

View Full Document Right Arrow Icon
    WELCOME WELCOME EF 105                Spring 2006
Background image of page 1

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

View Full DocumentRight Arrow Icon
    1.USING SOLVER 2. MAKING Templates 3. Links 4. Scenarios Working with Revised Annual Forecast.xls Topics
Background image of page 2
    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.
Background image of page 3

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

View Full DocumentRight Arrow Icon
   
Background image of page 4
    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).
Background image of page 5

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

View Full DocumentRight Arrow Icon
   
Background image of page 6
    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.
Background image of page 7

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

View Full DocumentRight Arrow Icon
   
Background image of page 8
   
Background image of page 9

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

View Full DocumentRight Arrow Icon
  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. Click: .
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/13/2008 for the course EF 105 taught by Professor Jackson during the Spring '05 term at University of Tennessee.

Page1 / 43

Week04 - WELCOME EF 105 Spring 2006 Topics 1.USING SOLVER 2 MAKING Templates 3 Links 4 Scenarios Working with Revised Annual Forecast 1 USING

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online