Refer to the following sensitivity report. Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Activity 1 2 0 20 30 27.5 $C$14 Activity 2 0 -24 10 24 1E+30 $D$14 Activity 3 3 0 30 55 7 $E$14 Activity 4 0 -7 40 7 1E+30 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$10 Resource A 30 6 245 121 1E+30 $G$8 Resource B 50 10 1310 770 605 $G$9 Resource C 40 30 520 1445 192.5 If resource C rises by 1 unit, then total profit will ____________: A. will rise by $30 B. will remain unchanged C. will decrease by $30 D. will increase by $300
Added by Philip A.
Step 1
From the sensitivity report, we can see that the shadow price of Resource C is $30. Now, if Resource C rises by 1 unit, the total profit will change by the shadow price multiplied by the change in the resource. In this case, the change in the resource is 1 unit, Show more…
Show all steps
Close
Your feedback will help us improve your experience
Natalie Belcher and 51 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
The following sensitivity report is for the questions below. Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 0 425 500 1E+30 425 $C$6 Activity 2 27.5 0 300 500 300 $D$6 Activity 3 0 250 400 1E+30 250 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side Allowable Increase Allowable Decrease $E$2 Benefit A 110 0 60 50 1E+30 $E$3 Benefit B 110 75 110 1E+30 46 $E$4 Benefit C 137.5 0 80 57.5 1E+30 1) What is the optimal objective function value for this problem? 2) If the coefficient for Activity 2 in the objective function changes to $400, will the optimal solution change? Will the objective function value change? If it does, what is the new value? 3) If the right-hand side of Resource B changes to 80, then how will the objective function value change? 4) If the objective coefficients of Activity 2 and Activity 3 are both decreased by $100, will the optimal solution change? Why? How would that affect the optimal objective function value?
Adi S.
6) Answer the following questions using the sensitivity report shown below (10 min) a) Report the optimal solution and the objective function. What is the optimal value of the objective function? (6 marks) b) Report the slack/surplus values associated with each constraint and determine what constraints are binding and which one(s) are non-binding. (6 marks) c) Report the feasibility ranges for the resources. (4 marks)
Madhur L.
Based on the sensitivity report provided, which one constraint is not binding (also called not tight or not strict)? Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease FramingHrs FramingHrs 22 - 24 1E+100 2 StuffingHrs StuffingHrs 24 160 24 12 6 StitchingHrs StitchingHrs 24 120 24 1.6 8 Shadow Price Stitching Stuffing Framing
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
Watch the video solution with this free unlock.
EMAIL
PASSWORD