Production Scheduling Finished

Production Scheduling Finished - $D$16 On hand after...

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

View Full Document Right Arrow Icon
Sensitivity of month 1 production to demands in months 5 (along side) and 6 (along top) $B$12 100 200 300 100 50 50 50 200 50 50 50 300 50 50 50 A B C D E F 45 46 47 48 49
Background image of page 1

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

View Full DocumentRight Arrow Icon
Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Units produced 50 0 16.3175 1.00E+030 0.5750 $C$12 Units produced 200 0 15.7425 0.5750 0.4775 $D$12 Units produced 300 -0.4775 15.2650 0.4775 1.00E+030 $E$12 Units produced 300 -1.0125 14.7300 1.0125 1.00E+030 $F$12 Units produced 250 0 14.1400 1.6025 0.5425 $G$12 Units produced 100 0 13.5975 0.5425 13.5975 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 On hand after production <= 100 0.575 100 100 50 $C$16 On hand after production <= 200 0 150 50 1.00E+030
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $D$16 On hand after production &lt;= 350 300 50 1.00E+030 $E$16 On hand after production &lt;= 350 1.6 350 50 50 $F$16 On hand after production &lt;= 250 0.5 250 50 200 $G$16 On hand after production &lt;= 100 13.6 100 100 100 $B$20 Ending inventory &gt;= 100 1.00E+030 100 $C$20 Ending inventory &gt;= 50 100 1.00E+030 50 $D$20 Ending inventory &gt;= 50 100 1.00E+030 50 $E$20 Ending inventory &gt;= 100 1.00E+030 100 $F$20 Ending inventory &gt;= 100 1.00E+030 100 $G$20 Ending inventory &gt;= 100 1.00E+030 100 A B C D E F G H 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
View Full Document

Page1 / 2

Production Scheduling Finished - $D$16 On hand after...

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

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