{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

LAB problem - Blending problem

# LAB problem - Blending problem - 0.8 0.1166666667...

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

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

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

View Full Document
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 0 0.8 0.1166666667 0.1153846154
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online