Start with the linear programming problem

Maximize profit 5A + 4C

With constraints

C&D 12A + 6C 20400

S 9A + 15C 21600

I&P 6A + 6C 12000

A, C 0 (Excel will handle the non-negativity constraints for you if you keep the box Make Unconstrained Variables Non-Negative checked.)

a-use Solver in Excel to find the solution to the problem and include both the Answer and Sensitivity Reports and attach with your answers to additional questions.

b- what is the optimal amount of A and C and what profit results?

c-on the sensitivity report what is the allowable increase for the number 5 as the coefficient on A in the profit function? Re-run the Solver where you make the coefficient on A incorporate the full allowable increase. Include the Answer report. What are the amounts for A and C and profit with this new run? What does this new result mean in the context of the original best point for A and C?

d-on the original sensitivity report what is the allowable increase on the RHS of the C&D constraint? Re-run the Solver (make the coefficient of A have the original value of 5) where you increase the RHS by the full allowable increase. Include the Answer report. What are the amounts for A and C and profit with this new run? What does this new result mean in the context of the original best point for A and C? How is the original shadow price incorporated into this new result?