Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started