Language:EN
Pages: 3
Words: 527
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
solving linear programming with excel solver answe

solving linear programming with excel solver answers and explanation

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

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

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

    • 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.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Tomas

PageId: DOCBC5D23C