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

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

View Full Document Right Arrow Icon
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
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: [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
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online