{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# 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 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 <= 10000 Wood 5 10 12000 <= 12000 Boxes 1 1 1480 <= 1500...
View Full Document

{[ snackBarMessage ]}

### 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