Question: 1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine

1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine Excursion Objective Allowable Coefficient Increase 1500 1560 5000 1660 17000W 1E+30 Allowable Decrease 1E+30 1E+30 3458.3333 12 24.24 a) What happens to the value of the excursion variable if we can increase the profit for this variable? What if the profit is increased to 50? [5 Marks) b) Interpret the reduced cost of 12 for the Bar variable. [5 Marks] c) Write the objective function for this problem. [5 Marks] d) What is the value of the objective function and variables? [5 Marks) 1. Here's the sensitivity report for the decision variables. Answer the following questions. Cell Name Final Value Reduce Cost 12 $B$2 $C$2 $D$2 Bar Cuisine Excursion Objective Allowable Coefficient Increase 1500 1560 5000 1660 17000W 1E+30 Allowable Decrease 1E+30 1E+30 3458.3333 12 24.24 a) What happens to the value of the excursion variable if we can increase the profit for this variable? What if the profit is increased to 50? [5 Marks) b) Interpret the reduced cost of 12 for the Bar variable. [5 Marks] c) Write the objective function for this problem. [5 Marks] d) What is the value of the objective function and variables? [5 Marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
