Question: The following sensitivity report is obtained from solving a linear program with three decision variables representing the number of units produced of three products, X,

The following sensitivity report is obtained from

The following sensitivity report is obtained from solving a linear program with three decision variables representing the number of units produced of three products, X, Y, and Z. Production of the three products requires resources, A, B, and C. The objective is to find the best product mix among X, Y, and Z (the optimal solution) so as to maximize the total profit (the optimal objective function value). The following two tables are obtained from Excel sensitivity analysis. The three rows in the first table "Variable Cells" correspond to the three products, X, Y, and Z respectively, and the three rows in the second table "Constraints" correspond to the three resources, A, B, and C respectively. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$9 X 3.5 7 2 0.666666667 $C$9 Y 0 -0.5 4 0.5 1E+30 $D$9 Z 5.5 0 3 2 0.666666667 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$5 16 2 16 11 7 $E$6 14.5 0 24 1E+30 9.5 $E$7 18 0.5 18 7.6 7.333333333 Answer the following eight questions based on the sensitivity report. (1) How many units of product X should be produced under the current optimal solution? (2) What is the improvement increase) of the total profit if the unit profit (obj coefficient) of product Z is increased by 2? (3) At which unit profit level, the company would start producing Y? D (4) Which constraint(s) (each constraint corresponds to a resource) are binding (active) based on the current optimal solution? (Select all that apply. You need to either check or un-check each box. Do not leave a "?" mark on any choice) ? Resource A constraint ? Resource B constraint ? Resource C constraint

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!