# I NEED THE SOLUTION IN 20-25 MINUTES 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

I NEED THE SOLUTION IN 20-25 MINUTES

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.

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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.

(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.

(b) Calculate the slack or surplus in each constraint.

(c) What is the range of optimality for the objective function coefficients of product 1, product 2, and product 3 ?