Consider the following linear program Max 12A + 9B s.t 5A + 15B <= 25 10A + 6B <= 26 

a) Use Excel solver the find the optimal solution and generate the sensitivity report. What is the optimal solution? Use the Sensitivity report to answer the following questions: 

b) Assume that the objective function coefficient for A changes from 12 to 16. Does the optimal solution change? Why? 

c) Assume that the objective function coefficient for A remains 12, but the objective function coefficient for B changes from 9 to 12. Does the optimal solution change? Why? 

d) Based on the shadow price and the right-hand-side range information in Sensitivity report, what conclusion can you draw about the effect of changes to the right-hand side of the constraint 1.

Answer rating: 100% (QA)

a The optimal solution is A 2 and B 1 A B Sum 2 1 33 Constraints 25 26 sensitivity report for this M... View the full answer