24 - 80 20 PNF FDM CMBFX LHS RHS 1 1 1 100000 <=...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [24.xls]Sheet1 Report Created: 2/8/2008 2:09:22 PM Target Cell (Max) Cell Name Original Value Final Value $E$8 objective LHS 15000000 15000000 Adjustable Cells Cell Name Original Value Final Value $B$9 initial sol Gigahaul 7.19 10 $C$9 initial sol Megahaul 13.75 10 $D$9 initial sol Picohaul 9.06 10 Constraints Cell Name Cell Value Formula Status Slack $E$4 LHS 30 $E$4<=$G$4 Binding 0 $E$5 LHS 1500000 $E$5<=$G$5 Binding 0 $E$6 LHS 130000 $E$6<=$G$6 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
Gigahaul Megahaul Picohaul LHS RHS 1 1 1 30 <= 30 60000 50000 40000 1500000 <= 1500000 6000 5000 2000 130000 <= 130000 objective 500000 500000 500000 15000000 initial sol 10 10 10
Background image of page 2
Vanilla Mocha Strawberry LHS RHS 2 1 1 180 <= 200 1 1 2 120 <= 120 2 2 2 200 <= 200 objective 3 2 4 320 initial sol
Background image of page 3

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

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

Unformatted text preview: 80 20 PNF FDM CMBFX LHS RHS 1 1 1 100000 &lt;= 100000 1 1-1 0.00 &lt;= 9-1-1 0.00 &lt;= objective 0.07 0.05 0.04 4700 initial sol 10000 40000 50000 Microsoft Excel 11.0 Answer Report Worksheet: [30.xls]Sheet1 Report Created: 2/8/2008 2:19:35 PM Target Cell (Max) Cell Name riginal ValuFinal Value $E$8 objective LH 35 260000 Adjustable Cells Cell Name riginal ValuFinal Value $B$9 initial sol R 1 12000 $C$9 initial sol R 1 6000 $D$9 initial sol C 1 2000 Constraints Cell Name Cell Value Formula Status Slack $E$4 LHS 0 $E$4&lt;=$G$Binding $E$5 LHS 20000 $E$5&lt;=$G$Binding $E$6 LHS 2000 $E$6&gt;=$G$Binding...
View Full Document

Page1 / 4

24 - 80 20 PNF FDM CMBFX LHS RHS 1 1 1 100000 &amp;amp;lt;=...

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