#5 Linear Programming, exam 1, LP1

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

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

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

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

View Full Document
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/22/2010 for the course BUSI 508 taught by Professor Thomas during the Summer '10 term at Columbia College.

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
Ask a homework question - tutors are online