Read the case carefully, then answer question 16-21. (22 points)
Susan Frank is the operations manager of Mauritius Arc Manufacturing Inc. She has developed a linear programming model to help her determine the product mix on one of the three production lines for Mauritius Arc Manufacturing Inc, where x1, x2 and x3 represent production line (product) 1, 2, and 3 respectively.
Maximize Z = 15 x1+ 20 x2 + 14 x3 (profit)Subject to:
5 x1 + 6 x2 + 4 x3 ≤ 210 (LABOR Constraint)10 x1 + 8 x2 + 5 x3 ≤ 200 (SPACE Constraint)4 x1+ 2 x2+ 5 x3 ≤ 170 (BUDGET Constraint)x1, x2, x3 ≥ 0
The spreadsheet solution and sensitivity report are shown in the following two tables.
Question 16 (2 points) ListenReadSpeaker webReader: ListenFocus
(a) How much of each product should be produced each day in order to achieve the maximum profit and also calculate the value of Z.
Question 16 options:ParagraphLato (Recommended)19px (Default)Question 17 (3 points) ListenReadSpeaker webReader: Listen
(b) Calculate the slack or surplus in each constraint.
Question 17 options:ParagraphLato (Recommended)19px (Default)Question 18 (3 points) ListenReadSpeaker webReader: Listen
(c) What is the range of optimality for the objective function coefficients of product 1, product 2, and product 3 ?
Question 18 options:ParagraphLato (Recommended)19px (Default)Question 19 (3 points) ListenReadSpeaker webReader: Listen
(d) Identify the range of feasibility for the right-hand side values for each of the constraint.
Question 19 options:ParagraphLato (Recommended)19px (Default)Question 20 (5 points) ListenReadSpeaker webReader: Listen
(e) Given a choice between more space and more budget allocation, which one should management select and why. Explain as done in class.
Question 20 options:ParagraphLato (Recommended)19px (Default)Question 21 (6 points) ListenReadSpeaker webReader: Listen
(f) Calculate R1, R2 and R3 in Table 1
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
TO BE RE-WRITTEN FROM THE SCRATCH
GET SOLUTION FOR THIS ASSIGNMENT
TO BE RE-WRITTEN FROM THE SCRATCH
- Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
- Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
- Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
- Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
- Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
- Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals barriers Susan Frank is the operations manager of Mauritius Arc Manufacturing Inc