412LP-ProdDist - MicrosoftExcel11.6AnswerReport

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

View Full Document Right Arrow Icon
Microsoft Excel 11.6 Answer Report Worksheet: [ProdDist.xls]ProdAlgebra Report Created: 9/7/2010 11:51:10 AM Target Cell (Min) Cell Name Original Value Final Value $H$8 Minimize  Costs 0 13650 Adjustable Cells Cell Name Original Value Final Value $B$5 #units pA>W1 0 0 $C$5 #units pA>W2 0 400 $D$5 #units pA>W3 0 600 $E$5 #units pB>W1 0 700 $F$5 #units pB>W2 0 400 $G$5 #units pB>W3 0 0 Constraints Cell Name Cell Value Formula Status Slack $H$11 W1 demand Actual 700 $H$11>=$J$11 Binding 0 $H$15 pB capacity Actual 1100 $H$15<=$J$15 Not Binding 100 $H$13 W3 demand Actual 600 $H$13>=$J$13 Binding 0 $H$14 pA capacity Actual 1000 $H$14<=$J$14 Binding 0 $H$12 W2 demand Actual 800 $H$12>=$J$12 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.6 Sensitivity Report Worksheet: [ProdDist.xls]ProdAlgebra Report Created: 9/7/2010 11:51:10 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 #units pA>W1 0 2.5 8 1.0E+030 2.5 $C$5 #units pA>W2
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.

This note was uploaded on 10/19/2011 for the course DS 412 taught by Professor Eng during the Spring '07 term at S.F. State.

Page1 / 6

412LP-ProdDist - MicrosoftExcel11.6AnswerReport

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