#6 Linear Programming, exam 1, LP2

# #6 Linear Programming, exam 1, LP2 - Microsoft Excel 12.0...

This preview shows pages 1–3. Sign up to view the full content.

Microsoft Excel 12.0 Answer Report Worksheet: [Book4]Sheet1 Report Created: 7/1/2009 4:35:46 AM Target Cell (Max) Cell Name Original Value Final Value \$D\$9 Obj. Function MAX 0 5000 Adjustable Cells Cell Name Original Value Final Value \$B\$7 DV Values x1 0 10 \$C\$7 DV Values x2 0 0 Constraints Cell Name Cell Value Formula Status Slack \$D\$12 line 1 LHS 10 \$D\$12<=\$F\$12 Binding 0 \$D\$13 line 2 LHS 10 \$D\$13>=\$F\$13 Not Binding 3 \$D\$14 line 3 LHS 10 \$D\$14<=\$F\$14 Not Binding 2

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book4]Sheet1 Report Created: 7/1/2009 4:35:46 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$7 DV Values x1 10 0 500 1.00E+030 200 \$C\$7 DV Values x2 0 -200 300 200 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$D\$12 line 1 LHS 10 500 10 2 3 \$D\$13 line 2 LHS 10 0 7 3 1.00E+030 \$D\$14 line 3 LHS 10 0 12 1.00E+030 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

#6 Linear Programming, exam 1, LP2 - Microsoft Excel 12.0...

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

View Full Document
Ask a homework question - tutors are online