Ch2.1 - Allowable Cell Name Value Cost Coefficient Increase...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 7/6/2001 3:18:46 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Profit Total 0 6280 Adjustable Cells Cell Name Original Value Final Value $C$4 Produce Diagonal 0 560 $D$4 Produce Box 0 920 Constraints Cell Name Cell Value Formula Status Slack $E$7 Paper Total 10000 $E$7<=$G$7 Binding 0 $E$8 Wood Total 12000 $E$8<=$G$8 Binding 0 $E$9 Boxes Total 1480 $E$9<=$G$9 Not Binding 20
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 9.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 7/6/2001 3:18:46 PM Adjustable Cells Final Reduced Objective Allowable
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Produce Diagonal 560 3 3.67 0.5 $D$4 Produce Box 920 5 1 2.75 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Paper Total 10000 0.1 10000 200 2800 $E$8 Wood Total 12000 0.44 12000 500 5750 $E$9 Boxes Total 1480 1500 1.00E+030 20 KITE 'N STRING Diagonal Box Produce 560 920 Total Profit 3 5 6280 Paper 8 6 10000 &lt;= 10000 Wood 5 10 12000 &lt;= 12000 Boxes 1 1 1480 &lt;= 1500...
View Full Document

This note was uploaded on 10/15/2009 for the course MGT mgt taught by Professor Tannous during the Spring '09 term at University of Houston - Downtown.

Page1 / 3

Ch2.1 - Allowable Cell Name Value Cost Coefficient Increase...

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