LAB problem - Blending problem

LAB problem - Blending problem - 0.8 0.1166666667...

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: [Book1]Sheet1 Report Created: 2/13/06 6:37:43 PM Target Cell (Min) Cell Name Original Value Final Value $B$13 Optimal z 0 0.4063535912 Adjustable Cells Cell Name Original Value Final Value $C$12 Dec. var. x1 0 0.0994475138 $D$12 Dec. var. x2 0 0.2127071823 $E$12 Dec. var. x3 0 0.0883977901 $F$12 Dec. var. x4 0 0.0994475138 Constraints Cell Name Cell Value Formula Status Slack $C$16 Const 1 LHS 0.5 $C$16=$E$16 Binding 0 $C$17 Const 2 LHS 6 $C$17>=$E$17 Binding 0 $C$18 Const 3 LHS 5 $C$18>=$E$18 Binding 0 $C$19 Const 4 LHS 5 $C$19>=$E$19 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: [Book1]Sheet1 Report Created: 2/13/06 6:37:43 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$12 Dec. var. x1 0.0994475138 0 0.75 0.1875 0.1774193548 $D$12 Dec. var. x2 0.2127071823 0 0.9 1.0000E+030 0.1065217391 $E$12 Dec. var. x3 0.0883977901
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: 0.8 0.1166666667 0.1153846154 $F$12 Dec. var. x4 0.0994475138 0.7 0.0924369748 1.0000E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$16 Const 1 LHS 0.5 0.2635359116 0.5 0.0989010989 0.0248962656 $C$17 Const 2 LHS 6 0.0135359116 6 0.7619047619 1.6739130435 $C$18 Const 3 LHS 5 0.0303867403 5 0.3025210084 0.5806451613 $C$19 Const 4 LHS 5 0.0082872928 5 2.25 1.2307692308 Blending problem (Lab practice) DATA x1 x2 x3 x4 RHS Const 1 1 1 1 1 0.5 Const 2 9 16 8 10 6 Const 3 12 10 10 8 5 Const 4 14 15 7 5 Obj. funct. 0.75 0.9 0.8 0.7 MODEL x1 x2 x3 x4 Dec. var. 0.099448 0.212707 0.088398 0.099448 Optimal z 0.406354 Constraints LHS RHS Const 1 0.5 = 0.5 Const 2 6 >= 6 Const 3 5 >= 5 Const 4 5 >= 5...
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

LAB problem - Blending problem - 0.8 0.1166666667...

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