InClassCase3 - Parketsister - Parket Sisters Ballpoint pens...

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

View Full Document Right Arrow Icon
Parket Sisters Decision Variables: 700 0 133.33 Profit Objective Function 3.0 3.0 5.0 2766.67 Constraints: LHS Type RHS units Plastic 1.2 1.7 1.2 1000 <= 1000 ounce Chrome 0.8 0 2.3 866.67 <= 1200 ounce Stainless Steel 2.0 3.0 4.5 2000 <= 2000 ounce Ballpoint pens (X1) Mechanical pencils (X2) Fountai n pens (X3)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Parket Sisters Decision Variables: 500 0 333.33 Profit Extra cost Profit Objective Function 3.0 3.0 5.0 3166.67 300 2866.67 Constraints: LHS Type RHS units Plastic 1.2 1.7 1.2 1000 <= 1000 ounce Chrome 0.8 0 2.3 1166.67 <= 1200 ounce Stainless Steel 2.0 3.0 4.5 2500 <= 2500 ounce Ballpoint pens (X1) Mechanical pencils (X2) Fountain pens (X3)
Background image of page 2
500 0.6 0.12 additional amount of plastic extra unit cost spreadout unit plastic cost
Background image of page 3

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

View Full DocumentRight Arrow Icon
Microsoft Excel 11.0 Sensitivity Report Worksheet: [Parketsister.xls]ParketSister(Q6,v1) Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 500 0 3 2 0.78 $D$4 0 -1.38 3 1.38 1.00E+030 $E$4 333.33 0 5 1.75 2 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$9 Plastic LHS 1000 1.17 1000 500 100 $F$10 Chrome LHS 1166.67 0 1200 1.00E+030 33.33 $F$11 Stainless Steel LHS 2500 0.8 2500 55.56 833.33 Ballpoint pens (X1) Mechanical pencils (X2) Fountain pens (X3)
Background image of page 4
Parket Sisters Decision Variables: 500 0 333.33 500 Profit Objective Function 2.8 2.6 4.5 2866.67 Constraints: LHS Type RHS units Plastic 1.2 1.7 1.2 1000 <= 1000 ounce Chrome 0.8 0 2.3 1166.67 <= 1200 ounce Stainless Steel 2.0 3.0 4.5 2500 <= 2500 ounce Ballpoint pens (X1) Mechanical pencils (X2) Fountain pens (X3) additional amount of plastic
Background image of page 5

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

View Full DocumentRight Arrow Icon
0.6 0.12 extra unit cost spreadout unit plastic cost
Background image of page 6
Microsoft Excel 10.0 Sensitivity Report Worksheet: [Parketsister.xls]ParketSister(Q6,v2) Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 500 0 2.76 1.7 0.78 $D$4 0 -1.38 2.64 1.38 1.00E+030 $E$4 333.33
Background image of page 7

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

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

Page1 / 21

InClassCase3 - Parketsister - Parket Sisters Ballpoint pens...

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

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