Solving Linear Programming with Excel Solver Step by step Solution with Explanation

Your question:

A linear programming model is given as follows:

maximize Z50x₁+80x2+64x3+80x4

(x1+x2)/(x1+x2+x3+x4)≥0.60

(a) Solve the problem by using excel solver.

Solving Linear Programming with Excel Solver Answers and Explanation

Solving the Linear Programming Model with Excel Solver

(a) Solving with Excel Solver

5. Choose "Max" because we want to maximize the objective function.

6. Add each constraint by clicking "Add" and entering the following information:

7. • Set "By Changing Variable Cells" to the range containing x1 and x2 (e.g., B2:C2).

   • Choose ">=" for the restriction.

Using Excel Solver again, perform sensitivity analysis:

1. Right-click on the answer cell for any variable (e.g., optimal value of x1) and select "Change Objective Coefficient."

1. Right-click on the constraint right-hand side value cell (e.g., 600 for the first constraint) and select "Change Constraint Right Side."

2. Increase or decrease the value (e.g., to 650 or 550).

(e) Effect of Decreasing the Coefficient of x1

Change the coefficient of x1 in the objective function from 80 to 50 and rerun Solver. The optimal value of x1 will likely decrease, and the values of other variables might adjust to maintain the maximized objective function value.