Objective Cell Max Cell Name Original Value Final Value C19 Objective Function

# Objective cell max cell name original value final

This preview shows page 5 - 10 out of 12 pages.

Objective Cell (Max) Cell Name Original Value Final Value \$C\$19 Objective Function (Min) X1 3,341.34 3,341.34 Variable Cells Cell Name Original Value Final Value Integer \$C\$16 X1 87.21 87.21 Contin \$D\$16 X2 65.12 65.12 Contin \$E\$16 X3 10.00 10.00 Contin \$F\$16 X4 3.19 3.19 Contin \$G\$16 X5 0.00 0.00 Contin Constraints Cell Name Cell Value Formula Status \$C\$23 A Amount Used (LHS) 100.00 \$C\$23<=\$E\$23 Binding \$C\$24 C Amount Used (LHS) 36.00 \$C\$24<=\$E\$24 Binding \$C\$25 B Amount Used (LHS) 50.00 \$C\$25<=\$E\$25 Binding \$C\$26 D Amount Used (LHS) 10.00 \$C\$26<=\$E\$26 Binding \$C\$27 E Amount Used (LHS) 3.19 \$C\$27<=\$E\$27 Not Binding \$C\$28 E Amount Used (LHS) - \$C\$28<=\$E\$28 Not Binding
. e Without Integer Constraints, Assume NonNegative Slack 0 0 0 0 2.8139534884 8
Microsoft Excel 14.4 Sensitivity Report Worksheet: [GBS Test Question #3.xlsx]Sheet1 Report Created: 4/21/2015 10:21:52 AM Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase \$C\$16 X1 87.209302326 0 30 6.75 \$D\$16 X2 65.11627907 0 15 2.7975 \$E\$16 X3 10 0 -18 1.00000E+030 \$F\$16 X4 3.1860465116 0 -22.5 22.5 \$G\$16 X5 0 -6.5058139535 -12 6.5058139535 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase \$C\$23 A Amount Used (LHS) 100 22.1511627907 100 11 \$C\$24 C Amount Used (LHS) 36 22.5 36 3.1860465116 \$C\$25 B Amount Used (LHS) 50 5.4941860465 50 12.736842105 \$C\$26 D Amount Used (LHS) 10 4.1511627907 10 11 \$C\$27 E Amount Used (LHS) 3.1860465116 0 6 1.00000E+030 \$C\$28 E Amount Used (LHS) 0 0 8 1.00000E+030
Allowable Decrease 3.57 2.3625 4.1511627907 16.227272727 1.00000E+030 Allowable Decrease 12.454545455 2.8139534884 14.421052632 10 2.8139534884 8
Microsoft Excel 14.4 Limits Report Worksheet: [GBS Test Question #3.xlsx]Sheet1 Report Created: 4/21/2015 10:21:57 AM Objective Cell Name Value \$C\$19 Objective Function (Min) X1 3,341.34 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result \$C\$16 X1 87.21 0.00 725.06 87.21 3,341.34 \$D\$16 X2 65.12 0.00 2,364.59 65.12 3,341.34 \$E\$16 X3 10.00 10.00 3,341.34 10.00 3,341.34

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

Want to read all 12 pages?

• Fall '14
• LHS)