Question: Given the following sensitivity table to maximize the profit. Variable Cells Cell Name $B$4 Economy $C$4 Standard $D$4 Deluxe Final Reduced Objective Allowable Allowable Value

Given the following sensitivity table to maximize

Given the following sensitivity table to maximize the profit. Variable Cells Cell Name $B$4 Economy $C$4 Standard $D$4 Deluxe Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 80 0 63 12 15.5 120 0 95 31 8 0 -24 135 24 1E+30 Constraints Cell $E$7 $E$8 Name C1 C2 C3 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 31 200 80 40 320 32 320 80 120 2080 0 2400 1E+30 320 $E$9 (a) What is the optimal solution of Economy, Standard and Deluxe models? (b) What is the total profit? (C) Identify the range of optimality for objective function coefficient of Standard model. (d) If the profit for Standard model were increased to $110 per unit, would the optimal solution change? (e) Identify the upper and lower limit of range for the RHS of C1. (f) What is the shadow price of Ci? (g) If the RHS of Cl is increased to 250, what will be the change to the total profit

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!