Variable Cells Final Reduced Objective Allowable Cell Name Value Cost

# Variable cells final reduced objective allowable cell

This preview shows page 3 - 8 out of 8 pages.

Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase \$C\$16 X1 0.0994475138 0 0.75 0.1875 \$D\$16 X2 0.2127071823 0 0.9 1.00000E+030 \$E\$16 X3 0.0883977901 0 0.8 0.1166666667 \$F\$16 X4 0.0994475138 0 0.7 0.0924369748 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase \$C\$23 A Amount Used (LHS) 0.5 0.2635359116 0.5 0.0989010989 \$C\$24 C Amount Used (LHS) 6 0.0135359116 6 0.7619047619 \$C\$25 B Amount Used (LHS) 5 0.0303867403 5 0.3025210084 \$C\$26 D Amount Used (LHS) 5 0.0082872928 5 2.25
Allowable Decrease 0.1774193548 0.1065217391 0.1153846154 1.00000E+030 Allowable Decrease 0.0248962656 1.6739130435 0.5806451613 1.2307692308
Microsoft Excel 14.4 Limits Report Worksheet: [Workbook18]Sheet1 Report Created: 4/21/2015 11:50:27 AM Objective Cell Name Value \$C\$19 Objective Function (Min) X1 0.41 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result \$C\$16 X1 0.10 0.10 0.41 0.10 0.41 \$D\$16 X2 0.21 0.21 0.41 0.21 0.41 \$E\$16 X3 0.09 0.09 0.41 0.09 0.41 \$F\$16 X4 0.10 0.10 0.41 0.10 0.41
Material X1 X2 X3 X4 A 1 1 1 1 C 9 16 8 10 B 12 10 10 8 D 0 14 15 7 E 0 0 0 0 E 0 0 0 0 Obj. Func. Coefficient 0.75 0.9 0.8 0.7 Decision Variables ( Set values equal to 1) Tons Produced X1 X2 X3 X4 0.10 0.21 0.09 0.10 Objective Function 0.41 Constraints Amount Used (LHS) A 0.50 0.5 C 6.00 >= 6 B 5.00 >= 5 D 5.00 >= 5 E - <= 0 E - <= 0 XE 1.00 <= 0 YA 1.00 <= 0 YB 1.00 <= 0 YC 1.00 <= 0 YD 1.00 <= 0 YE 1.00 <= 0
Material Requirements P2 P3 YB YC YD YE mount Availabl 0 0 0 0 0 0 0.5 0 0 0 0 0 0 6 0 0 0 0 0 0 5 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 P2 P3 YB YC YD YE 1.00 1.00 1.00 1.00 1.00 1.00
le

#### You've reached the end of your free preview.

Want to read all 8 pages?

• Fall '14
• objective function, Report Created, LHS)