Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table: -Fliptop Model -Tiptop Model -Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 Use Excel's Solver and run a sensitivity report to answer the following questions: a. Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called? b. What is the shadow price (dual price) for the plastic constraint and how would you interpret it? c. 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?
Please answer the following in an organized way and showing steps.
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table:
|
-Fliptop Model |
-Tiptop Model |
-Available |
|
|
Plastic |
3 |
4 |
36 |
|
Ink Assembly |
5 |
4 |
40 |
|
Molding Time |
5 |
2 |
30 |
Use Excel's Solver and run a sensitivity report to answer the following questions:
a. Over which
b. What is the shadow price (dual price) for the plastic constraint and how would you interpret it?
c. 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?
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 6 images
