{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

412LP-ProdDist

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

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

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

View Full Document
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 400 0 6 1 0.5 \$D\$5 #units pA>W3 600 0 6.5 0.5 7.5 \$E\$5 #units pB>W1 700 0 6.5 2.5 6.5 \$F\$5 #units pB>W2 400 0 7 0.5 1 \$G\$5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}