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
Image of page 3
Allowable Decrease 0.1774193548 0.1065217391 0.1153846154 1.00000E+030 Allowable Decrease 0.0248962656 1.6739130435 0.5806451613 1.2307692308
Image of page 4
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
Image of page 5
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
Image of page 6
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
Image of page 7
le
Image of page 8

You've reached the end of your free preview.

Want to read all 8 pages?

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes