{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

InClassCase3 - ParketSisters

# InClassCase3 - ParketSisters - OSCM 230 Spring 2011...

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

OSCM 230 Spring 2011 Management Science Linear Programming Case Study: Parket Sisters Click to edit Master subtitlestyle 02/15/2011 Professor Dong, Washington University in St. Louis, MO 1 1 Linear Programming Case Study:

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

View Full Document
OSCM 230 Spring 2011 Management Science Linear Programming Case Study: Parket Sisters 02/15/2011 Professor Dong, Washington University in St. Louis, MO 2 2 Problem Setup MAX:  3.0 X1 + 3.0 X2 + 5.0 X3 Subject to:   Plastic:              1.2 X1 + 1.7 X2 + 1.2 X3 �  1,000 Chrome:               0.8 X1 +    0 X2 + 2.3 X3 �  1,200 Stainless steel:     2.0 X1 +  3.0 X2 + 4.5 X3 � 2,000    X1 , X2 , X3  �  0 X1 = number of ballpoint pens X2 = number of mechanical pencils X3 = number of fountain pens Cell                 Formula F6   =SUMPRODUCT(C6:E6,C4:E4) F9 = SUMPRODUCT(C9:E9,\$C\$4:\$E\$4) Copy F9 to F10:F11
OSCM 230 Spring 2011 Management Science Linear Programming Case Study: Parket Sisters 02/15/2011 Professor Dong, Washington University in St. Louis, MO 3 3 Case Questions Weekly optimal mix? Weekly optimal net profit? Answer:    3.  Is the optimal solution unique? Answer:   4. What is the marginal value of one more unit of chrome?  Of  Ballpoint = 700, Mechanical = 0, Fountain =133.3 Profit = 2766.67  Check the  allowable increase  and  allowable decrease  of  adjustable     cells  in the sensitivity report.  If there exists an zero  in either allowable increase or allowable     decrease, then there are  multiple optimal solutions , otherwise, the  optimal solution is unique marginal value of Chrome=SPchrome=\$0 marginal value of Plastic=SPplastic=\$1.167

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 10

InClassCase3 - ParketSisters - OSCM 230 Spring 2011...

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

View Full Document
Ask a homework question - tutors are online