chap05.ppt.pptVIP

* Figure 5.20 The complete sensitivity report generated by the Excel Solver for the original Wyndor problem. * Figure 5.21 A graphical interpretation of the allowable range 6 ≤ RHS2 ≤ 18, for the right-hand side of Wyndor’s plant 2 constraint. * Figure 5.22 The revised Wyndor problem where column G has been changed by shifting one of the hours available in plant 3 to plant 2 and then re-solving. * Figure 5.23 By inserting a formula into cell G8 that keeps the total number of hours available in plant 2 and 3 equal to 30, this one-dimensional application of Solver Table shows the effect of shifting more and more of the hours available from plant 3 to plant 2. * * Slides 5.27–5.43 are based upon a lecture introducing sensitivity analysis for linear programming models to first-year MBA students at the University of Washington (as taught by one of the authors). The lecture is largely based upon a production problem using lego building blocks. This example is based upon an example introduced in an OR/MS Today article. To start the example, students are given a set of legos (8 small bricks and 9 large bricks)—one set per two students works pretty well. Tell them to set aside 3 of the large bricks to begin with (so they have a total of 6 to work with). These are their “raw materials”. They are then to produce tables and chairs out of these legos (see the diagram on the slide). These are their “products”. Each table generates $20 profit and each chair generates $15 profit. Their goal is to use their limited resources (the bricks) to make products (tables and chairs) so as to make as much profit as possible. The next slide contains some questions to be answered, one-by-one. The lego building blocks can be used to help answer the questions. * With 6 large bricks and 8 small bricks, with $20 profit per table and $15 profit per chair, the optimal solution is to build 2 tables and 2 chairs. Suppose they purchase the large bricks from an outside supplier, and this suppli