Lee Key example

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

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

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

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

View Full Document
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
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
Ask a homework question - tutors are online