Page 230 -

210 CHAPTER 4 LINEAR PROGRAMMING APPLICATIONS

Step 8. When the Solver Results dialog box appears:
Select Keep Solver Solution
Select Sensitivity in the Reports box
Click OK

The Solver Parameters dialogue box is shown in Figure 4.14. The optimal solution
is shown in Figure 4.13; the accompanying sensitivity report is shown in Figure 4.15.

Figure 4.14 Solver Parameters Dialogue Box for the Hewlitt Corporation Problem

Figure 4.15 Excel’s Sensitivity Report for the Hewlitt Corporation Problem

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.