Parket Sisters - Microsoft Excel 11.0 Answer Report...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 2/11/2008 5:32:00 PM Target Cell (Max) Cell Name Original Value Final Value $E$5 Per Unit Profit Total Profit 13 2766.67 Adjustable Cells Cell Name Original Value Final Value $B$3 BP 0 700 $C$3 MP 1 0 $D$3 FP 2 133.33 Constraints Cell Name Cell Value Formula Status Slack $E$8 Plastic Total Profit 1000 $E$8<=$G$8 Binding 0 $E$9 Chrome Total Profit 866.67 $E$9<=$G$9 Not Binding 333.33 $E$10 Stainless Steel Total Profit 2000 $E$10<=$G$10 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 11.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 2/11/2008 5:32:00 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$3 BP 700 0 3 2 $C$3 MP 0 -1.38 3 1.38 $D$3 FP 133.33 0 5 1.75 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $E$8 Plastic Total Profit 1000 1.17 1000 200 $E$9 Chrome Total Profit 866.67 0 1200 1.00E+030 $E$10 Stainless Steel Total Profit 2000 0.8 2000 555.56
Background image of page 2
Allowable Decrease 0.78 1.00E+030 2 Allowable Decrease 466.67 333.33 333.33
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Parket Sisters - Microsoft Excel 11.0 Answer Report...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online