Excel 2010 Bible

Chapter 36: Performing Spreadsheet What-If Analysis 759 For simple cases of scenario management, a standard Scenario Summary rep ...

...

761 CHAPTER Analyzing Data Using Goal Seeking and Solver IN THIS CHAPTER What-if analysis — in reverse Single-cell goal seeking ...

Part V: Analyzing Data with Excel 762 Single-Cell Goal Seeking Single-cell goal seeking is a rather simple concept. Excel determ ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 763 l (^) Enter 20% in cell C5 (the down payment percent) l Enter 360 i ...

Part V: Analyzing Data with Excel 764 l (^) Adjust the Maximum iterations setting on the Formulas tab of the Excel Options dialo ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 765 Appropriate problems for Solver Problems that are appropriate for S ...

Part V: Analyzing Data with Excel 766 FIGURE 37.3 Use Solver to determine the number of units to maximize the total profit. You ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 767 FIGURE 37.4 The Solver Parameters dialog box. In this example, the ...

Part V: Analyzing Data with Excel 768 To set the first constraint (that the total production capacity is 300 units), enter B6 a ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 769 At this point, you have the following options: l Keep the solution ...

Part V: Analyzing Data with Excel 770 Caution When you close the Solver Results dialog box (by clicking either OK or Cancel) the ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 771 This list describes Solver’s options: l Constraint Precision: Speci ...

Part V: Analyzing Data with Excel 772 Figure 37.9 shows a workbook set up to solve this problem. This workbook has three named c ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 773 Note This problem doesn’t have a target cell because it’s not tryin ...

Part V: Analyzing Data with Excel 774 FIGURE 37.11 This worksheet determines the least expensive way to ship products from wareh ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 775 Cell G24 is the bottom line, the total shipping costs for all order ...

Part V: Analyzing Data with Excel 776 The total shipping cost is $55,515, and all the constraints are met. Notice that shipments ...

Chapter 37: Analyzing Data Using Goal Seeking and Solver 777 FIGURE 37.13 Using Solver to maximize profit when resources are lim ...

Part V: Analyzing Data with Excel 778 Optimizing an investment portfolio This example demonstrates how to use Solver to help max ...