Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
orado.edu/cours/62755/quiz201 uredno kdown does Imagine that Excel Solver has given you the following sensitivity analysis tables. Answer the following two questions according to these tables,
orado.edu/cours/62755/quiz201 uredno kdown does Imagine that Excel Solver has given you the following sensitivity analysis tables. Answer the following two questions according to these tables, Variable cells Final Allowable Cell Name Reduced Objective Cost Coefficient Allowable Decrease Value Increase $B$6 Activity 1 425 500 1E+30 425 27.5 0.0 $C$6 Activity 2 500 300 300 250 400 0 250 1E+30 $D$6 Activity 3 Constraints Constraints Cell Name Final Shadow Constraint Allowablo Allowable Value Price R.H. Side Increase Decrease $E$2 Benefit A 110 0 60 50 1E+30 $E$3 Benefit B 110 75 110 1E+30 46 137.5 $E$4 Benefit C 0 80 1E+30 57.5 If the coefficient of Activity 1 in the objective function changes to $10, then: the original solution remains optimal. o the problem must be resolved to find the optimal solution. O the shadow price is not valid. O the shadow price is valid. spis According to the tables in Question 6, what is the allowable range of the right-hand-side for Benefit A? O S RHS of A s 110 O 110 s RHS of As 1600 OOS RHS of A s 110 O S RHS of A S 60 77 orado.edu/cours/62755/quiz201 uredno kdown does Imagine that Excel Solver has given you the following sensitivity analysis tables. Answer the following two questions according to these tables, Variable cells Final Allowable Cell Name Reduced Objective Cost Coefficient Allowable Decrease Value Increase $B$6 Activity 1 425 500 1E+30 425 27.5 0.0 $C$6 Activity 2 500 300 300 250 400 0 250 1E+30 $D$6 Activity 3 Constraints Constraints Cell Name Final Shadow Constraint Allowablo Allowable Value Price R.H. Side Increase Decrease $E$2 Benefit A 110 0 60 50 1E+30 $E$3 Benefit B 110 75 110 1E+30 46 137.5 $E$4 Benefit C 0 80 1E+30 57.5 If the coefficient of Activity 1 in the objective function changes to $10, then: the original solution remains optimal. o the problem must be resolved to find the optimal solution. O the shadow price is not valid. O the shadow price is valid. spis According to the tables in Question 6, what is the allowable range of the right-hand-side for Benefit A? O S RHS of A s 110 O 110 s RHS of As 1600 OOS RHS of A s 110 O S RHS of A S 60 77
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e939860adb_504669e939803ff5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e93994bf04_504669e9398c0898.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e9399e7035_505669e9399876e7.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started