Constraint coefficients 0 0 7 12 0 0 0 18 0 1 1 0 0 0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 X3A 6 X3C 7 X4B 8 X4C 9 X5B 10 X5C 12 X6B 0.5 0 13 X7A 14 X7C 15 X8A 16 X8B 17 X9B 18 X9C 19 20 X10A X10C 1 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 22 13 19 6 17 13 8 9 15 0 22 0 0 0 0 0 0 1 0 0 0 0 13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 19 0 0 0 0 0 0 1 0 0 0 6 0 0 0 0 0 0 0 0 0 1 0 0 0 17 0 0 0 0 0 0 0 0 1 0 0 0 13 0 0 0 0 0 0 0 0 0 1 0 0 0 8 0 0 0 0 0 0 0 0 1 0 9 0 0 0 0 0 0 0 0 0 0 0 1 0 0 15 0 0 0 0 0 0 0 0 0 1 Sensitivity Analysis for Worksheet LP_13 Variable Analysis Num. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Name Value Status XAI1 100 Basic XAI2 150 Basic XAII1 75 Basic XAII2 0 Lower XAIII1 0 Lower XAIII2 0 Lower XBI1 0 Lower XBI2 0 Lower XBII1 125 Basic XBII2 20 Basic XBIII1 75 Basic XBIII2 150 Basic IA1 0 Lower IB1 0 Lower IA2 0 Lower IB2 0 Lower Objective Value: 4,375 Reduced Objective Range Range Cost Coefficient Lower Limit Upper Limit 0 3 1 --0 4 1 --0 6 5 8 -3 1 --4 -3 -2 --1 -6 3 --9 -5 1 --6 -2 3 --5 0 9 7 10 0 5 3 10 0 4 3 6 0 10 5 ---2 -1 --1 -5 -1 --4 -5 -1 --4 -6 -1 --5 Constraint Analysis Num. Name Value Status Capacity A period 1 Upper 1 175 Capacity A period 2 Upper 2 150 Capacity B period 1 Upper 3 200 Capacity B period 2 Upper 4 170 Demand I period 1 Upper 5 100 Demand I period 2 Upper 6 150 Demand II period 1 Upper 7 200 Demand II period 20 Basic 8 2 Demand III period75 Basic 9 1 Demand III period 2 Upper 10 150 Inventory A period 1 Basic 11 0 Inventory B period 1 Basic 12 0 Shadow Price 1 4 4 5 2 0 5 0 0 5 0 0 Constraint Range Range Limit Lower Limit Upper Limit 175 100 250 150 0 150 200 125 275 170 150 450 100 25 175 150 150 --200 125 275 300 20 --150 75 --150 0 170 50 0 --50 0 --- Name: LP_13 Type: LP1 Goal: Max Profit: 4375 Linear Model TRUE FALSE TRUE FALSE FALSE 100 100 0 60 Change Solver: Jensen LP/IP Type: Linear Sens.: Yes Side: No Ph. 1 Iter. 0 Total Iter. 7 Comp. Time 00:01 Status Optimal Solve Variables Name: Values: Lower Bounds: Vary Change Relation Linear Obj. Coef.: Constraints Num. Name 1 Capacity A period 1 2 Capacity A period 2 3 Capacity B period 1 4 Capacity B period 2 5 Demand I period 1 6 Demand I period 2 7 Demand II period 1 8 Demand II period 2 9 Demand III period 1 10 Demand III period 2 11 Inventory A period 1 12 Inventory B period 1 Value 175 150 200 170 100 150 200 20 75 150 0 0 Rel. <= <= <= <= <= <= <= <= <= <= <= <= RHS 175 150 200 170 100 150 200 300 150 150 50 50 1 2 3 4 5 6 7 8 9 10 11 12 XAI1 XAI2 XAII1 XAII2 XAIII1 XAIII2 XBI1 XBI2 XBII1 XBII2 XBIII1 XBIII2 100 150 75 0 0 0 0 0 125 20 75 150 0 0 0 0 0 0 0 0 0 0 0 0 3 4 6 Linear Constraint Coefficients 1 0 1 0 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 IA1 14 IB1 15 IA2 16 IB2 0 0 0 0 0 0 0 0 1 -2 3 1 3 9 5 4 10 -1 -1 -1 -1 0 1 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 Name: LP_1 Type: LP1 Goal: Max Profit: 4375 Linear Model TRUE FALSE TRUE FALSE FALSE 100 100 0 60 Change Solver: Jensen LP/IP Type: Linear Sens.: No Side: No Ph. 1 Iter. 10 Total Iter. 17 Comp. Time 00:00 Status Optimal Solve Variables Name: Values: Lower Bounds: Upper Bounds: Vary Change Relation Linear Obj. Coef.: Constraints Num. 1 2 3 4 5 6 7 8 9 10 Name PA1 PA2 PB1 PB2 S11 S12 S21 S22 S31 S32 Value 0 0 0 0 0 0 0 0 0 0 Rel. = = = = = = = = = = RHS 0 0 0 0 0 0 0 0 0 0 1 S11 100 0 100 2 S12 150 0 150 3 S21 200 0 200 4 S22 20 0 300 5 S31 75 0 150 6 S32 150 0 150 7 PA1 175 0 175 8 PA2 150 0 150 9 PB1 200 0 200 15 18 20 17 14 21 -8 -10 -7 -8 -4 -4 -6 -6 -8 -8 -7 -7 -4 -4 -3 -3 -1 -1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 -1 0 0 0 -1 0 0 0 0 0 0 -1 0 0 0 -1 0 0 0 0 -1 0 0 0 0 0 -1 0 0 0 0 -1 0 0 0 0 0 -1 0 0 -1 0 0 0 0 0 0 0 -1 0 0 -1 0 0 0 0 0 0 0 -1 0 0 -1 0 -1 0 0 0 0 0 0 0 0 -1 0 -1 0 0 0 0 0 0 -1 0 0 0 -1 0 0 0 0 0 0 -1 0 0 0 -1 0 0 0 0 -1 0 0 0 0 0 -1 0 0 0 0 -1 0 0 0 0 0 -1 -1 0 0 0 0 0 0 0 0 0 0 0 -1 0 0 0 0 0 0 0 Linear Constraint Coefficients 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 PB2 XA11 XA12 XA21 XA22 XA31 XA32 XB11 XB12 XB21 XB22 XB31 XB32 HA1 HB1 170 100 150 75 0 0 0 0 0 125 20 75 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 170 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 50 50...
View Full Document

This document was uploaded on 10/02/2013.

Ask a homework question - tutors are online