Final Exam #2

# Final Exam #2 - Microsoft Excel 12.0 Answer Report...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Final Exam #2.xlsx]Sheet1 Report Created: 7/23/2009 11:14:24 AM Target Cell (Max) Cell Name Original Value Final Value \$F\$8 Obj. Function MAX 0 0.42 Adjustable Cells Cell Name Original Value Final Value \$B\$6 DV Values x1 0 0.25 \$C\$6 DV Values x2 0 0.17 \$D\$6 DV Values x3 0 0 \$E\$6 DV Values x4 0 0 Constraints Cell Name Cell Value Formula Status Slack \$F\$11 line 1 LHS 0.75 \$F\$11<=\$H\$11 Not Binding 0.25 \$F\$12 line 2 LHS 1 \$F\$12<=\$H\$12 Binding 0 \$F\$13 line 3 LHS 1 \$F\$13<=\$H\$13 Binding 0 \$F\$14 line 4 LHS 1 \$F\$14<=\$H\$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: [Final Exam #2.xlsx]Sheet1 Report Created: 7/23/2009 11:14:24 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$6 DV Values x1 0.25 0 1 1.00E+030 0 \$C\$6 DV Values x2 0.17 0 1 1.00E+030 0 \$D\$6 DV Values x3 0 0 1 0 1.00E+030 \$E\$6 DV Values x4 0 -0.67 1 0.67 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price
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

Final Exam #2 - Microsoft Excel 12.0 Answer Report...

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

View Full Document
Ask a homework question - tutors are online