Question
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. Fliptop Model Tiptop Model Available Plastic
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.
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 solver and run a sensitivity report to answer the following questions
Question
1. Over which range can the objective function coefficient for Fliptop models change without affecting the original optimal solution, what is this range called
2. what is the shadow price (dual price) for the plastic constrain and How much would you interpret it?
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?
4. Please provide a screenshot of the sensitivity report that you used for answering three previous questions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started