{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

°° ° ± ° ° \$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 ÈÇ ¹ ( ° )

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

View Full Document
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
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 <= 40 Q2 <= 40 Q3 <= 40 Q4 <= 40 q1 <= 20 q2 <= 20 q3 <= 20 q4 <= 20 TQ1 >= 30 TQ2 >= 60 TQ3 >= 75 TQ4 >= 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 <= 40 Q2 <= 40 Q3 <= 40 Q4 <= 40 q1 <= 20 q2 <= 20 q3 <= 20 q4 <= 20 TQ1 >= 30 TQ2 >= 60 TQ3 >= 75 TQ4 >= 25 TQ = 190...
View Full Document

{[ snackBarMessage ]}

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
Ask a homework question - tutors are online