Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Will Seal, Carsten Rohde, Ray Garrison, Eric Noreen

6th Edition

9780077185534

Students also viewed these Finance questions