SUBMIT Homework 1 - Part II - see the instructions above and below
Eva Chan 
JuiceModified.xlsxIKEA
| IKEA CHAIR PROBLEM | |||||||
| Decision Variables | IVOR | BROR | Total Profit | ||||
| Values | 10 | 10 | 250 | ||||
| Objective Function Coefficients | 10 | 15 | |||||
| Constraints | Coefficients | LHS | RHS | ||||
| Demand | 1 | 1 | 20 | <= | 20 | ||
| Labor | 5 | 10 | 150 | <= | 150 | ||
| Raw Mat'l | 10 | 6 | 160 | <= | 180 |
Sensitivity Report IKEA
| Microsoft Excel 10.0 Sensitivity Report | |||||||
| Worksheet: [LP Examples.xls]IKEA | |||||||
| Report Created: 10/7/2003 10:26:39 AM | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $C$5 | Values IVOR | 10 | 0 | 10 | 5 | 2.5 | |
| $D$5 | Values BROR | 10 | 0 | 15 | 5 | 5 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $E$11 | Demand LHS | 20 | 5 | 20 | 1.4285714286 | 5 | |
| $E$12 | Labor LHS | 150 | 1 | 150 | 50 | 25 | |
| $E$13 | Raw Mat'l LHS | 160 | 0 | 180 | 1E+30 | 20 |
PRODUCT MIX PROBLEM
| DECISION VARIABLES | ||||||||
| OJ | GJ | PJ | AIO | Total Profit | ||||
| Price per gallon | $ 3.00 | $ 2.70 | $ 2.40 | $ 3.30 | $ 1,230.00 | |||
| Cost per gallon | $ 2.00 | $ 1.60 | $ 1.40 | $ 1.72 | ||||
| Profit per gallon | $ 1.00 | $ 1.10 | $ 1.00 | $ 1.58 | ||||
| Number of containers | 133.3333333333 | 233.3333333333 | 0 | 533.3333333333 | ||||
| CONSTRAINTS | LHS | RHS | ||||||
| OJ availability | 1 | 0 | 0 | 0.50 | 400 | <= | 400 | |
| GJ availability | 0 | 1 | 0 | 0.13 | 300 | <= | 300 | |
| PJ availability | 0 | 0 | 1 | 0.38 | 200 | <= | 200 | |
| GJ percentage | -0.3 | 0.7 | -0.3 | -0.30 | -36.6666666667 | <= | 0 | |
| OJ/PJ ratio | 5 | 0 | -7 | 0 | 666.6666666667 | >= | 0 |
