#8 LP Sensitivity Analysis exam 1, SA.xlsx.xls

#8 LP Sensitivity Analysis exam 1, SA.xlsx.xls - Microsoft...

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: [Book5]Sheet1 Report Created: 7/1/2009 4:41:08 AM Target Cell (Max) Cell Name Original Value Final Value $D$9 Obj. Function MAX 0 4040 Adjustable Cells Cell Name Original Value Final Value $B$7 DV Values T 0 320 $C$7 DV Values C 0 360 Constraints Cell Name Cell Value Formula Status Slack $D$12 Carpentry Hrs LHS 2400 $D$12<=$F$12 Binding 0 $D$13 Painting Hrs LHS 1000 $D$13<=$F$13 Binding 0 $D$14 Max # chairs LHS 360 $D$14<=$F$14 Not Binding 90 $D$15 Min # tables LHS 320 $D$15>=$F$15 Not Binding 220
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: [Book5]Sheet1 Report Created: 7/1/2009 4:41:08 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$7 DV Values T 320 0 7 3 3.25 $C$7 DV Values C 360 0 5 4.33 1.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$12 Carpentry Hrs LHS 2400
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.

Page1 / 4

#8 LP Sensitivity Analysis exam 1, SA.xlsx.xls - Microsoft...

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