LP project - Microsoft Excel 11.0 Answer Report Worksheet:...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Microsoft Excel 11.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 12/4/2007 9:54:10 AM Target Cell (Max) Cell Name Original Value Final Value $C$4 cost 28323500 Adjustable Cells Cell Name Original Value Final Value $C$21 C1 W1 $D$21 C1 W2 $E$21 C1 W3 138000 $F$21 C1 W4 146000 $G$21 C1 W5 $H$21 C1 W6 $I$21 C1 W7 $J$21 C1 W8 $K$21 C1 W9 $L$21 C1 W10 49000 $M$21 C1 W11 153000 $C$22 C2 W1 112000 $D$22 C2 W2 85000 $E$22 C2 W3 $F$22 C2 W4 $G$22 C2 W5 $H$22 C2 W6 $I$22 C2 W7 101000 $J$22 C2 W8 $K$22 C2 W9 34000 $L$22 C2 W10 $M$22 C2 W11 $C$23 C3 W1 $D$23 C3 W2 $E$23 C3 W3 $F$23 C3 W4 $G$23 C3 W5 77000 $H$23 C3 W6 89000 $I$23 C3 W7 $J$23 C3 W8 215000 $K$23 C3 W9 19000 $L$23 C3 W10 $M$23 C3 W11 Constraints Cell Name Cell Value Formula Status Slack $C$24 Demand W1 112000 $C$24=$C$18 Not Binding $D$24 Demand W2 85000 $D$24=$D$18 Not Binding $E$24 Demand W3 138000 $E$24=$E$18 Not Binding $F$24 Demand W4 146000 $F$24=$F$18 Not Binding $G$24 Demand W5 77000 $G$24=$G$18 Not Binding $H$24 Demand W6 89000 $H$24=$H$18 Not Binding $I$24 Demand W7 101000 $I$24=$I$18 Not Binding $J$24 Demand W8 215000 $J$24=$J$18 Not Binding $K$24 Demand W9 53000 $K$24=$K$18 Not Binding $L$24 Demand W10 49000 $L$24=$L$18 Not Binding $M$24 Demand W11 153000 $M$24=$M$18 Not Binding $N$21 C1 Center capacity 486000 $N$21<=$N$15 Not Binding 14000 $N$22 C2 Center capacity 332000 $N$22<=$N$16 Not Binding 418000 $N$23 C3 Center capacity 400000 $N$23<=$N$17 Binding Microsoft Excel 11.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 12/4/2007 9:54:10 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$21 C1 W1-7.5 5 7.5 1.00E+030 $D$21 C1 W2-6.5 11 6.5 1.00E+030 $E$21 C1 W3 138000 14.5 1.00E+030 6 $F$21 C1 W4 146000 22.5 1.00E+030 3.5 $G$21 C1 W5-2 5.5 2 1.00E+030 $H$21 C1 W6-7 15.5 7 1.00E+030 $I$21 C1 W7-11.5 21 11.5 1.00E+030 $J$21 C1 W8-4 30.5 4 1.00E+030 $K$21 C1 W9-3 18 3 1.00E+030 $L$21 C1 W10 49000 10.5 1.00E+030 8 $M$21 C1 W11 153000 22.5 1.00E+030 2 $C$22 C2 W1 112000 12.5 1.00E+030 7.5 $D$22 C2 W2 85000 17.5 1.00E+030 6.5 $E$22 C2 W3-6 8.5 6 1.00E+030 $F$22 C2 W4-3.5 19 3.5 1.00E+030 $G$22 C2 W5-3 4.5 3 1.00E+030 $H$22 C2 W6-14 8.5 14 1.00E+030 $I$22 C2 W7 101000 32.5 1.00E+030 11.5 $J$22 C2 W8-12 22.5 12 1.00E+030 $K$22 C2 W9 34000 21 4.5 2 $L$22 C2 W10-8 2.5 8 1.00E+030 $M$22 C2 W11-2 20.5 2 1.00E+030 $C$23 C3 W1-8 9 8 1.00E+030 $D$23 C3 W2-12.5 9.5 12.5 1.00E+030 $E$23 C3 W3-8 11 8 1.00E+030 $F$23 C3 W4-12.5 14.5 12.5 1.00E+030 $G$23 C3 W5 77000 12 1.00E+030 2 $H$23 C3 W6 89000 27 1.00E+030 7 $I$23 C3 W7-17.5-17....
View Full Document

Page1 / 18

LP project - Microsoft Excel 11.0 Answer Report Worksheet:...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online