#5 Linear Programming, exam 1, LP1

#5 Linear Programming, exam 1, LP1 - Microsoft Excel 12.0...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Book3]Sheet1 Report Created: 7/1/2009 4:28:23 AM Target Cell (Max) Cell Name Original Value Final Value $E$9 Obj. Function MAX 0 203.18 Adjustable Cells Cell Name Original Value Final Value $B$7 DV Values x1 0 10.91 $C$7 DV Values x2 0 3.18 $D$7 DV Values x3 0 0 Constraints Cell Name Cell Value Formula Status Slack $E$12 line 1 LHS 100 $E$12<=$G$12 Binding 0 $E$13 line 2 LHS 81.36 $E$13<=$G$13 Not Binding 38.64 $E$14 line 3 LHS 105 $E$14<=$G$14 Binding 0
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book3]Sheet1 Report Created: 7/1/2009 4:28:23 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$7 DV Values x1 10.91 0 16 2 1 $C$7 DV Values x2 3.18 0 9 11.57 1 $D$7 DV Values x3 0 -0.5 12 0.5 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$12 line 1 LHS 100 1.84 100 20
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

#5 Linear Programming, exam 1, LP1 - Microsoft Excel 12.0...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online