Consider the following problem Min 6 x 1 9 x 2 ($ cost) s t x 1 2 x 2 8 10 x 1 7 5 x 2 30 x 2 2 x 1 , x 2 0 Use Excel Solver to solve the problem and generate the Sensitivity Report You need to submit your Excel worksheet for the assignment What is the optimal solution of X1 What is the optimal solution of X2 What is the value of the objective function What is the range of optimality of the coefficient of X1 Suppose the unit cost of x 1 is decreased to $3 Is the current solution still optimal What is the value of the objective function when this unit cost is decreased to $3 What is the range of optimality of the coefficient of X2 How much can the unit cost of x 2 be decreased without concern for the optimal solution changing What is the range of feasibility of RHS of constraint 2 What is the range of feasibility of RHS of constraint 3 What is the range of feasibility of RHS of constraint 1 If RHS of constraint 1 decreases from 8 to 7, what is the impact on the value of the objective function If simultaneously the cost of x 1 was reduced to $4 and the cost of x 2 was reduced to $6, would the current solution remain optimal Please answer all the above questions and submit the Excel spreadsheet containing your solver solution and sensitivity report remain optimal Please answer all the above questions and submit the Excel spreadsheet containing your solver solution and sensitivity report

The Answer is in the image, click to view ...

Question: Consider the following problem: Min 6 x 1 + 9 x 2 ($ cost) s.t. x 1 + 2 x 2 < 8 10 x

Consider the following problem:

Min 6x₁ + 9x₂ ($ cost)

s.t. x₁ + 2x₂ < 8

10x₁ + 7.5x₂ > 30

x₂ > 2

x₁, x₂ > 0

Use Excel Solver to solve the problem and generate the Sensitivity Report. You need to submit your Excel worksheet for the assignment.
What is the optimal solution of X1? What is the optimal solution of X2? What is the value of the objective function?
What is the range of optimality of the coefficient of X1? Suppose the unit cost of x₁ is decreased to $3. Is the current solution still optimal? What is the value of the objective function when this unit cost is decreased to $3?
What is the range of optimality of the coefficient of X2? How much can the unit cost of x₂ be decreased without concern for the optimal solution changing?
What is the range of feasibility of RHS of constraint 2? What is the range of feasibility of RHS of constraint 3?
What is the range of feasibility of RHS of constraint 1? If RHS of constraint 1 decreases from 8 to 7, what is the impact on the value of the objective function?
If simultaneously the cost of x₁ was reduced to $4 and the cost of x₂ was reduced to $6, would the current solution remain optimal?

Please answer all the above questions and submit the Excel spreadsheet containing your solver solution and sensitivity report.

remain optimal? Please answer all the above questions and submit the Excel spreadsheet containing your solver solution and sensitivity report.

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock