InClassCase3 - ParketSisters

InClassCase3 - ParketSisters - OSCM 230 Spring 2011...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: OSCM 230 Spring 2011 Management Science Linear Programming Case Study: Parket Sisters Click to edit Master subtitle style 02/15/2011 Professor Dong, Washington University in St. Louis, MO 02/15/2011 1 Linear Programming Case Study: Professor Dong, Washington University in St. Louis, MO OSCM 230 Spring 2011 Management Science Linear Programming Case Study: Parket Sisters 02/15/2011 Professor Dong, Washington University in St. Louis, MO Professor Dong, Washington University in St. Louis, MO 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 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....
View Full Document

This note was uploaded on 05/15/2011 for the course OSCM 230 taught by Professor Dong during the Spring '08 term at Washington University in St. Louis.

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