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

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

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

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

Students Have Also Explored These Related Accounting Questions!