Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Have The Question Typed Thanks (Excluding Graphs and Excel Screenshots etc..) Answer the following questions considering the sensitivity analysis report given below: 10 6
Please Have The Question Typed Thanks (Excluding Graphs and Excel Screenshots etc..)
Answer the following questions considering the sensitivity analysis report given below: 10 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E+30 10 $D$13 Variable 2 20 0 600 150 50 11 $E$13 Variable 3 0 500 300 33.33333333 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Constraint 3 Spent 0 0 5 1E+30 5 $F$8 Constraint 1 Spent 4000 3 4000 1000 1500 $F$9 Constraint 2 Spent 1000 5 1000 600 200 17 18 | 10 a. What is the optimal solution? (2 marks) b. What is the optimal objective function value? (3 marks) C. What is the allowable range for the objective function coefficient of Variable 1? (3 marks) d. What is the allowable range for the Right-hand side value of Constraint 1"? (3 marks) e. Does the optimal solution change if we change the objective function coefficient of "Variable 2" to 800? Why? (3 marks) f. Based on the available information, can we find out if the optimal solution changes when we change the objective function coefficients of "Variable 2" and "Variable 3 to 650 and 600 respectively? Why? (4 marks) g. Based on the available information, can we determine the optimal objective function value after the RHS of Constraint 3 changes to 10? Why? If yes, what is the optimal objective function value after this change? (3 marks) h. Based on the available information, can we determine the optimal objective function value when we change the RHS of "Constraint 1 and Constraint 2 to 4800 and 900 respectively? Why? If yes, what is the optimal objective function value after this change? (4 marks) Answer the following questions considering the sensitivity analysis report given below: 10 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E+30 10 $D$13 Variable 2 20 0 600 150 50 11 $E$13 Variable 3 0 500 300 33.33333333 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Constraint 3 Spent 0 0 5 1E+30 5 $F$8 Constraint 1 Spent 4000 3 4000 1000 1500 $F$9 Constraint 2 Spent 1000 5 1000 600 200 17 18 | 10 a. What is the optimal solution? (2 marks) b. What is the optimal objective function value? (3 marks) C. What is the allowable range for the objective function coefficient of Variable 1? (3 marks) d. What is the allowable range for the Right-hand side value of Constraint 1"? (3 marks) e. Does the optimal solution change if we change the objective function coefficient of "Variable 2" to 800? Why? (3 marks) f. Based on the available information, can we find out if the optimal solution changes when we change the objective function coefficients of "Variable 2" and "Variable 3 to 650 and 600 respectively? Why? (4 marks) g. Based on the available information, can we determine the optimal objective function value after the RHS of Constraint 3 changes to 10? Why? If yes, what is the optimal objective function value after this change? (3 marks) h. Based on the available information, can we determine the optimal objective function value when we change the RHS of "Constraint 1 and Constraint 2 to 4800 and 900 respectively? Why? If yes, what is the optimal objective function value after this change? (4 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