Маx 45X + 35Y subject to -2X + 5Y > 20 22X – 15Y > -45 | 5X + 2Y 0 Y 2 0 Consider the linear optimization model displayed above. 1. Set-up the model in an Excel spreadsheet. 2. Use the Solver add-in...

16 see pictures to solve


Extracted text: Маx 45X + 35Y subject to -2X + 5Y > 20 22X – 15Y > -45 | 5X + 2Y < 55="" x=""> 0 Y 2 0 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:


Extracted text: After solving the problem and generating the Solver reports, answer the following questions: a) What is the optimal value of X? (Round to two decimal places.) b) What is the optimal value of Y? (Round to two decimal places.) A/ c) What is the value of the objective function at the optimal solution? (Enter the exact answer.) d) Suppose the right-hand side (RHS) of the third constraint could be increased by 10. How much will the objective function improve? (Round your answer to the nearest whole number.) A/ e) How many of the constraints are binding?