Lee Key example

Lee Key example - w1 120 2 1 2 $J$18 w2 4 2 1.00E+030 4...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Lee Key example.xls]Sheet1 Target Cell (Min) Cell Name Original Value Final Value $C$20 Minimize cost x1 0 49840 Adjustable Cells Cell Name Original Value Final Value $C$18 x1 0 670 $D$18 x2 0 680 $E$18 x3 0 200 $F$18 y1 0 0 $G$18 y2 0 0 $H$18 y3 0 0 $I$18 w1 0 120 $J$18 w2 0 0 Constraints Cell Name Cell Value Formula Status Slack $C$23 x1 670 $C$23<=$E$23 Not Binding 10 $C$24 x1 680 $C$24<=$E$24 Binding 0 $C$25 x1 200 $C$25<=$E$25 Not Binding 480 $C$26 x1 0 $C$26<=$E$26 Not Binding 50 $C$27 x1 0 $C$27<=$E$27 Not Binding 50 $C$28 x1 0 $C$28<=$E$28 Not Binding 50 $C$29 x1 550 $C$29=$E$29 Not Binding 0 $C$30 x1 800 $C$30=$E$30 Not Binding 0 $C$31 x1 200 $C$31=$E$31 Not Binding 0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 9.0 Sensitivity Report Worksheet: [Lee Key example.xls]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$18 x1 670 0 32 1 2 $D$18 x2 680 0 32 2 1.00E+030 $E$18 x3 200 0 32 3 1.00E+030 $F$18 y1 0 3 35 1.00E+030 3 $G$18 y2 0 1 35 1.00E+030 1 $H$18 y3 0 3 35 1.00E+030 3 $I$18
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: w1 120 2 1 2 $J$18 w2 4 2 1.00E+030 4 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$23 x1 670 680 1.00E+030 10 $C$24 x1 680-2 680 120 10 $C$25 x1 200 680 1.00E+030 480 $C$26 x1 50 1.00E+030 50 $C$27 x1 50 1.00E+030 50 $C$28 x1 50 1.00E+030 50 $C$29 x1 550 32 550 10 670 $C$30 x1 800 34 800 10 120 $C$31 x1 200 32 200 480 200 Le Key Waterbeds production x1 x2 x3 y1 y2 y3 w1 w2 RHS 1 680 1 680 1 680 1 50 1 50 1 50 1 1-1 550 1 1 1-1 800 Model 1 1 1 200 obj.coeff. 32 32 32 35 35 35 2 2 Decision variables No beds produced x1 x2 x3 y1 y2 y3 w1 w2 670 680 200 120 Minimize cost 49840 constraints 670 <= 680 680 <= 680 200 <= 680 0 <= 50 0 <= 50 0 <= 50 550 = 550 800 = 800 200 = 200...
View Full Document

This note was uploaded on 11/18/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Page1 / 3

Lee Key example - w1 120 2 1 2 $J$18 w2 4 2 1.00E+030 4...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online