Formulate and use Excel Solver to generate a solution

to maximize profit: = 8x₁ + 5x₂

subject to x_{1 +} x₂ 10

x₁ 6

x₁ , x₂ 0

1. What is the optimal solution mix? What is the profit at that mix?
2. What is the Shadow Price for constraint 1? Over what range is this Shadow Price valid? In your Excel model change the right-hand constraint (10) by 1 (now 11) and solve the problem again. What is the profit now?
3. Change constraint 1's RHS (10) to 6. What happened? By how much did the profit decrease? Is that consistent with what the Shadow Price information? Why is it consistent with the Shadow Price?
4. Change constraint 1's right-hand side (10) to 5? What happened?

Linear Programming Results Problem 35 Solution RHS Dual Maximize Constraint 1 Constraint 2 Solution-> Ranging DO Problem 35 Solution Reduced Original Val Lower Bound Upper Bound 5 1 Infinity Variable Value 2 Dual Value Constraint Constraint 1 Constraint 2 Slack/Surplus Original Val Lower Bound Upper Bound Infinity