Question: Cell Name Value Cost Coefficient Increase Decrease $B$10 Activity 1 3 0 3 1 2.333 $B$10 Activity 2 4. 0 2 7 0.5 Constraints Final

Cell Name Value Cost Coefficient Increase

Cell Name Value Cost Coefficient Increase Decrease $B$10 Activity 1 3 0 3 1 2.333 $B$10 Activity 2 4. 0 2 7 0.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$5 Resource 1 Used 3 4 ? ? $D$6 Resource 15 2 Used 0.2 15 15 5 $D$7 Resource 10 3 Used 1.4 10 1.667 5 a) What if the unit profit for Activity 1 changed from $3 to $2? b) What if, in addition to the change in part a), the unit profit for Activity 2 increases by $3? c) What if the amount of Resource 2 was changed from 15 to 20? d) What if the amount of Resource 3 was decreased to 7 and Resource 2 was increased to 24? e) What are the missing values for Shadow Price, Allowable Increase, and Allowable Decrease for Resource 1

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!