1 / 79

L INEAR PROGRAMMING SENSITIVITY ANALYSIS

L INEAR PROGRAMMING SENSITIVITY ANALYSIS. Learning Objectives. Learn sensitivity concepts Understand, using graphs, impact of changes in objective function coefficients, right-hand-side values, and constraint coefficients on optimal solution of a linear programming problem.

gella
Download Presentation

L INEAR PROGRAMMING SENSITIVITY ANALYSIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LINEAR PROGRAMMING SENSITIVITY ANALYSIS

  2. Learning Objectives • Learn sensitivity concepts • Understand, using graphs, impact of changes in objective function coefficients, right-hand-side values, and constraint coefficients on optimal solution of a linear programming problem. • Generate answer and sensitivity reports using Excel's Solver. • Interpret all parameters of reports for maximization and minimization problems. • Analyze impact of simultaneous changes in input data values using 100% rule. • Analyze the impact of addition of new variable using pricing-out strategy.

  3. Introduction (1 of 2) • Optimal solutions to LP problems have been examined under deterministic assumptions. • Conditions in most real world situations are dynamic and changing. • After an optimal solution to a problem is found, input data values are varied to assess optimal solution sensitivity. • This process is also referred to as sensitivity analysis or post-optimality analysis.

  4. Introduction (2 of 2) • Sensitivity analysis determines the effect on optimal solutions of changes in parameter values of the objective function and constraint equations • Changes may be reactions to anticipated uncertainties in the parameters or the new or changed information concerning the model

  5. The Role of Sensitivity Analysis of the Optimal Solution • Is the optimal solution sensitive to changes in input parameters? • Possible reasons for asking this question: • Parameter values used were only best estimates. • Dynamic environment may cause changes. • “What-if” analysis may provide economical and operational information.

  6. 1. Sensitivity Analysis of Objective Function Coefficients.

  7. Ranges of Optimality The value of the objective function will change if the coefficient multiplies a variable whose value is nonzero. The optimal solution will remain unchanged as long as: • an objective function coefficient lies within its range of optimality • there are no changes in any other input parameters.

  8. The optimality range for an objective coefficient is the range of values over which the current optimal solution point will remain optimal

  9. For two variable LP problems the optimality ranges of objective function coefficients can be found by setting the slope of the objective function equal to the slopes of each of the binding constraints

  10. Sensitivity Analysis Using GraphsExample 1: Galaxy Industries (1 of 5) Max 8X1 + 5X2 (Weekly profit) subject to 2X1 + 1X2 < = 1200 (Plastic) 3X1 + 4X2 < = 2400 (Production Time) X1 + X2 < = 800 (Total production) X1 - X2 < = 450 (Mix) Xj> = 0, j = 1,2 (Nonnegativity)

  11. Sensitivity Analysis Using Graphs Example 1:(2 of 5) Profit = $ 000 Recall the feasible Region We now demonstrate the search for an optimal solution X2 1200 Start at some arbitrary profit, say profit = $2,000... Then increase the profit, if possible... ...and continue until it becomes infeasible Profit =$5040 4, 2, 3, 800 600 X1 400 600 800

  12. Sensitivity Analysis Using GraphsExample 1 (3 of 5) MODEL SOLUTION Space Rays = 480 dozens Zappers = 240 dozens Profit = $5040 • This solution utilizes all the plastic and all the production hours. • Total production is only 720 (not 800). • Space Rays production exceeds Zapper by only 240 dozens (not 450).

  13. Sensitivity Analysis Using GraphsExample 1 (4 of 5) X2 1200 The effects of changes in an objective function coefficient on the optimal solution 800 Max 8x1 + 5x2 600 Max 4x1 + 5x2 Max 3.75x1 + 5x2 Max 2x1 + 5x2 X1 400 600 800

  14. Range of optimality Sensitivity Analysis Using GraphsExample 1 (5 of 5) X2 1200 Max8x1 + 5x2 10 Max 10 x1 + 5x2 Max 3.75 x1 + 5x2 3.75 800 600 Max8x1 + 5x2 Max 3.75x1 + 5x2 X1 400 600 800 The effects of changes in an objective function coefficients on the optimal solution

  15. Sensitivity Analysis Using Graphs Example 2: Beaver Creek Pottery (1 of 4) Maximize Z = $40x1 + $50x2 subject to: 1x1 + 2x2  40 4x2 + 3x2  120 x1, x2  0

  16. Sensitivity Analysis Using Graphs Example 2 (2 of 4) Maximize Z = $100x1 + $50x2 subject to: 1x1 + 2x2  40 4x2 + 3x2  120 x1, x2  0

  17. Sensitivity Analysis Using Graphs Example 2 (3 of 4) Maximize Z = $40x1 + $100x2 subject to: 1x1 + 2x2  40 4x2 + 3x2  120 x1, x2  0

  18. Sensitivity Analysis Using Graphs (Objective Function CoefficientSensitivity Range for c1 and c2 ) Example 2 (4 of 4) objective function Z = $40x1 + $50x2 sensitivity range for: x1: 25  c1 66.67 x2: 30  c2 80

  19. Objective Function Coefficient Ranges Excel “Solver” Results Screen (1 of 3)

  20. Objective Function Coefficient Ranges Beaver Creek Example Sensitivity Report (2 of 3)

  21. Objective Function Coefficient Ranges QM for Windows Sensitivity Range Screen Beaver Creek Example (3 of 3)

  22. Sensitivity Analysis Using GraphsExample 3: High Note Sound Company(HNSC) (1 of 4) • HNSC Manufactures quality CD players and stereo receivers. • Each product requires skilled craftsmanship. • LP problem formulation: Objective: maximize profit = $50C + $120R subject to 2C + 4R 80 (Hours of electricians' time available) 3C + R  60 (Hours of audio technicians' time available) C, R 0 (Non-negativity constraints) Where: C = number of CD players to make. R = number of receivers to make.

  23. Sensitivity Analysis Using GraphsExample 3(2 of 4)

  24. Sensitivity Analysis Using Graphs Example 3 (3 of 4) Impact of price change of Receivers If unit profit per stereo receiver (R) increased from $120 to $150, is corner point a still the optimal solution? YES ! But Profit is$3,000 = 0 ($50) + 20 ($150)

  25. Sensitivity Analysis Using GraphsExample 3 (4 of4) Impact of price change of Receivers If receiver’s profit coefficient changed from $120 to $80, slope of isoprofit line changes causing corner point (b) to become optimal. But Profit is $1,760 = 16 ($50) + 12 ($80).

  26. Objective Function Coefficient Sensitivity Range (for a Cost Minimization Model) Minimize Z = $6x1 + $3x2 subject to: 2x1 + 4x2 16 4x1 + 3x2 24 x1, x2 0 sensitivity ranges: 4  c1 0  c2 4.5

  27. Multiple changes • The range of optimality is valid only when a single objective function coefficients changes. • When more than one variable changes we turn to the 100% rule.

  28. The 100% Rule 1. For each increase (decrease) in an objective function coefficient, calculate (and express as a percentage) the ratio of the change in the coefficient to the maximum possible increase (decrease) as determined by the limits of the range of optimality. 2. Sum all these percent changes. If the total is less than 100 percent, the optimal solution will not change. If this total is greater than or equal to 100%, the optimal solution may change.

  29. Reduced Costs The reduced cost for a variable at its lower bound (usually zero) yields: • The amount the profit coefficient must change before the variable can take on a value above its lower bound. • The amount the optimal profit will change per unit increase in the variable from its lower bound.

  30. 2. Sensitivity Analysis of Right Hand Side Values

  31. Changes in Right-Hand-Side Values of Constraints The sensitivity range for a RHS value is the range of values over which the quantity (RHS) values can change without changing the solution variable mix, including slack variables.

  32. Sensitivity Analysis of Right-Hand SideValues • Any change in the right hand side of a binding constraint will change the optimal solution. • Any change in the right-hand side of a nonbinding constraint that is less than its slack or surplus, will cause no change in the optimal solution.

  33. Changes in Constraint Quantity (RHS) Values Increasing the Labor Constraint (1 of 3) Example 1: Beaver Creek Maximize Z = $40x1 + $50x2 subject to: 1x1 + 2x2  40 4x2 + 3x2  120 x1, x2  0

  34. Changes in Constraint Quantity (RHS) Values Sensitivity Range for Labor Constraint (2 of 3) Example 1: Beaver Creek Sensitivity range for: 30  q1 80 hr

  35. Changes in Constraint Quantity (RHS) Values Sensitivity Range for Clay Constraint (3 of 3) Example 1: Beaver Creek Sensitivity range for: 60  q2 160 lb

  36. Constraint Quantity (RHS) ValueRanges by Computer Excel Sensitivity Range for Constraints (1 of 2) Example 1: Beaver Creek

  37. Constraint Quantity (RHS) Value Ranges by Computer QM for Windows Sensitivity Range (2 of 2) Example 1: Beaver Creek

  38. Sensitivity Analysis of Right-Hand SideValues & Shadow Prices In sensitivity analysis of right-hand sides of constraints we are interested in the following questions: • Keeping all other factors the same, how much would the optimal value of the objective function (for example, the profit) change if the right-hand side of a constraint is changed by one unit? • For how many additional or fewer units this per unit change will be valid?

  39. Changes in Right-hand-side (RHS) & Shadow Prices RHS of Binding Constraint - • If RHS of non-redundant constraint changes, size of feasible region changes. • If size of region increases, optimal objective function improves. • If size of region decreases, optimal objective function worsens. • Relationship expressed as Shadow Price. • Shadow Price is change in optimal objective function value for one unit increase in RHS.

  40. Shadow Prices (Dual Values) • Defined as the marginal value of one additional unit of resource. • The sensitivity range for a constraint quantity value is also the range over which the shadow price is valid.

  41. Range of Feasibility • The set of right - hand side values for which same set of constraints determines the optimal point. • Within the range of feasibility, shadow prices remain constant; however, the optimal solution will change.

  42. Excel Sensitivity Report for Shadow Prices (1 of 2) Example 1:Beaver Creek Pottery Maximize Z = $40x1 + $50x2 subject to: x1 + 2x2 40 hr of labor 4x1 + 3x2 120 lb of clay x1, x2 0

  43. Solution Screen (2 of 2) Example 1: Beaver Creek Pottery

  44. Example 2: High Note Sound Company Problem (1 of 12) • HNSC Manufactures quality CD players and stereo receivers. • Each product requires skilled craftsmanship. • LP problem formulation: Objective: maximize profit = $50C + $120R subject to 2C + 4R 80 (Hours of electricians' time available) 3C + R  60 (Hours of audio technicians' time available) C, R 0 (Non-negativity constraints) Where: C = number of CD players to make. R = number of receivers to make.

  45. Sensitivity Analysis of Right-hand-side (RHS) ValuesExample 2: High Note Sound Company (2 of 12) May change the feasible region size. May change or move corner points.

  46. Increase in Electricians’ Available TimeExample2: High Note Sound Company (3 of 12) • As available electricians’ time increases, corner points a and b will move closer to one other. • Further increases in available electricians’ time may make this constraint redundant.

  47. Decrease in Electricians’ Available TimeExample 2: High Note Sound Company (4 of 12) • As available electricians’ time decreases, corner points b and c move closer to one another from their current locations. • Corner points b and c will no longer be feasible, and intersection of electricians’ time constraint with horizontal (C) axis will become a new feasible corner point.

  48. Sensitivity Analysis Using SolverExample 2: High Note Sound Company(5 of 12)

  49. Solver Report Example 2: High Note Sound Company (6 of 12)

  50. Answer Report Example 2: High Note Sound Company (7 of 12)

More Related