MPP1 - 78250 Holding Cost 600 Objective Function MIN 78850...

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

View Full Document Right Arrow Icon
± $G$15 MIN -9500 78850 $C$4 Q1 0 40 $D$4 Q2 0 40 $E$4 Q3 0 40 $F$4 Q4 0 25 $C$6 q1 0 5 $D$6 q2 0 20 $E$6 q3 0 20 $F$6 q4 0 0 $C$7 Total Quantity of First Quarter 45 $C$7>=30 15 $D$7 Total Quantity of Second Quarter 75 $D$7>=60 15 $E$7 Total Quantity of Third Quarter 75 $E$7>=75 0 $F$7 Total Quantity of Forth Quarter 25 $F$7>=25 0 $G$8 Total Quantity 190 $G$8=190 0 $C$4 Q1 40 $C$4<=40 0 $D$4 Q2 40 $D$4<=40 0 $E$4 Q3 40 $E$4<=40 0 $F$4 Q4 25 $F$4<=40 15 $C$6 q1 5 $C$6<=20 15 $D$6 q2 20 $D$6<=20 0 $E$6 q3 20 $E$6<=20 0 $F$6 q4 0 $F$6<=20 20 Microsoft Excel 11.0 ÈÇ ¹ ª* ÈÇ } ¹ * : [Book1]Sheet1 Ø B • ª* : 2008-04-04 11:17:35 ÈÇ ¹ ( )
Background image of page 1

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

View Full DocumentRight Arrow Icon
Multi-period Production Regular Q1 Q2 Q3 Q4 40 40 40 25 Over q1 q2 q3 q4 5 20 20 0 Total Quantity of each Quarter 45 75 75 25 Total Quantity 190 Needed 30 60 75 25 Production Cost
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 78250 Holding Cost 600 Objective Function MIN 78850 Constraints Q1 &lt;= 40 Q2 &lt;= 40 Q3 &lt;= 40 Q4 &lt;= 40 q1 &lt;= 20 q2 &lt;= 20 q3 &lt;= 20 q4 &lt;= 20 TQ1 &gt;= 30 TQ2 &gt;= 60 TQ3 &gt;= 75 TQ4 &gt;= 25 TQ = 190 Multi-period Produc Regular Q1 Q2 Q3 Q4 40 40 40 25 Over q1 q2 q3 q4 5 20 20 Total Quantity o 45 75 75 25 Total Quantity 190 Needed 30 60 75 25 Production Cost 78250 Holding Cost 600 Objective Function MIN 78850 Constraints Q1 &lt;= 40 Q2 &lt;= 40 Q3 &lt;= 40 Q4 &lt;= 40 q1 &lt;= 20 q2 &lt;= 20 q3 &lt;= 20 q4 &lt;= 20 TQ1 &gt;= 30 TQ2 &gt;= 60 TQ3 &gt;= 75 TQ4 &gt;= 25 TQ = 190...
View Full Document

This note was uploaded on 04/17/2008 for the course QBA 101 taught by Professor Gnay during the Spring '08 term at Seoul National.

Page1 / 3

MPP1 - 78250 Holding Cost 600 Objective Function MIN 78850...

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