Fliptop Model
Tiptop Model
Available
Plastic
3
4
36
Ink Assembly
5
40
Molding Time
2
30
The profit for either model is $1,000 per lot.
a) What is the linear programming model for this problem?
b) Using Microsoft Excel's Solver, find the optimal solution. How many Fliptop models and how many Tiptop models should be produced? What is the maximum profit?
c) Will there be excess capacity in any resource?
Use Excel's Solver and run a sensitivity report to answer the following questions.
d) Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called?
e) What is the shadow price (dual price) for the plastic constraint and how would you interpret it?
f) What is the shadow price (dual price) for the Molding Time constraint. Does the value make sense? Over which range is the shadow price valid? What is this range called?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here