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
Image of page 5
. e Without Integer Constraints, Assume NonNegative Slack 0 0 0 0 2.8139534884 8
Image of page 6
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
Image of page 7
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
Image of page 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
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '14
  • 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