Question: please explain the steps . im confused on how to start Max 11X +16Y subject to 8x +5Y 2 30 3X +2Y 2 25 5X

Max 11X +16Y subject to 8x +5Y 2 30 3X +2Y 2 25 5X +2Y s 148 x 20 Consider the linear optimization model displayed above. 1. Set-up the model in an Excel spreadsheet. 2. Use the Solver add-in to solve for the optimal solution. 3. Generate the answer and sensitivity reports from Solver. After solving the problem and generating the Solver reports, answer the following questions: a) What is the optimal value of x? b) What is the optimal value of y? c) What is the value of the objective function at the optimal solution? d) How many of the constraints are binding? 3. Generate the answer and sensitivity reports from Solver. After solving the problem and generating the Solver reports, answer the following questions a) What is the optimal value of x? b) What is the optimal value of y? c) What is the value of the objective function at the optimal solution? d) How many of the constraints are binding? e) Consider increasing the coefficient of X in the objective function. What is the largest value the coefficient of X can take without changing t optimal solution? f) Suppose the right-hand side (RHS) of the third constraint could be increased to 150. How much will the objective function increase in value g) From the "Sensitivity Report," what is the allowable increase for the RHS value of the first constraint
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
