question archive Maxwell Manufacturing: Introduction The following four questions refer to the following information
Maxwell Manufacturing: Introduction The following four questions refer to the following information
Subject:MathPrice: Bought3
Maxwell Manufacturing: Introduction
The following four questions refer to the following information. You may recognize this problem from Homework 2.
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements 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 |
The profit for either model is $1,000 per lot.
Use Excel's Solver and run a sensitivity report to answer the following questions.
Maxwell Manufacturing: Part 1
Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called?
Maxwell Manufacturing: Part 2
What is the shadow price (dual price) for the plastic constraint and how would you interpret it?
Maxwell Manufacturing: Part 3
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?
Maxwell Manufacturing: Part 4
Upload a screenshot of the sensitivity report that you used for answering the previous three questions.
