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

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

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

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

View Full Document
Microsoft Excel 9.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 7/6/2001 3:18:46 PM Adjustable Cells Final Reduced Objective Allowable
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
Ask a homework question - tutors are online