Question: Your answers are saved automatically. Question Completion Status: QUESTION 1 Refer to the following sensitivity report. Cell $$14 $C$14 SD$14 SE514 Name Activity 1 Activity

Your answers are saved automatically. Question
Your answers are saved automatically. Question
Your answers are saved automatically. Question
Your answers are saved automatically. Question Completion Status: QUESTION 1 Refer to the following sensitivity report. Cell $$14 $C$14 SD$14 SE514 Name Activity 1 Activity 2 Activity Activity 4 Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 2 0 20 30 275 0 10 24 1E30 3 0 30 55 7 0 -7 40 7 15-30 Final Shadow Constraint Allowable Allowable Cell Name Value Price RH Side Increase Decrease $G$10 Resource A 30 6 245 121 TE-30 SGS8 Resource B 50 10 1310 770 5959 Resource 40 30 520 1445 192.5 What is the optimal objective function value for this problem? 605 A. $130 B. $240 C. 590 D. $330 QUESTION 2 represents the relationship between profit and the amount of resources (such as time, labo mi QUESTION 4 Refer to the following sensitivity report. Cell $B$14 $C$14 SD$14 SE$14 Name Activity 1 Activity 2 Activity 3 Activity 4 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2 0 20 30 27.5 0 -24 10 24 1E+30 3 0 30 55 0 -7 40 7 1E+30 A Cell SGS10 SG$8 SG$9 Name Resource A Resource B Resource C Final Value 30 50 Shadow Price 6 10 30 Constraint Allowable Allowable RH. Side Increase Decrease 245 121 1E+30 1310 770 605 520 1445 192.5 40 If the coefficient for Activity 2 in the objective function changes to $30, then the objective function value A. will rise by $30 B. will remain unchanged C. will decrease by $30 D. will increase by $330 QUESTIONS Refer to the following sensitivity report. Cell $B$14 SC$14 $D$14 $E$14 Name Activity 1 Activity 2 Activity 3 Activity 4 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2 0 20 30 27.5 0 -24 10 24 1E+30 3 0 30 55 7 0 -7 40 7 1E+30 Cell SG510 SGS8 $G$9 Name Resource A Resource B Resource C Final Value 30 50 40 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 6 245 121 1E+30 10 1310 770 605 30 520 1445 192.5 If resource C rises by 1 units, then total profit will A. will rise by $30 B. will remain unchanged C. will decrease by $30 D. will increase by $300

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!