Question 2 8 Points Max 15x 13 Subject To 20x Y S80 15 2 5y 2 2x 5y 12 X 20 Y 20 Consider The Linear Opti 1 (38.36 KiB) Viewed 26 times
Question 2 8 Points Max 15x 13 Subject To 20x Y S80 15 2 5y 2 2x 5y 12 X 20 Y 20 Consider The Linear Opti 2 (48.48 KiB) Viewed 26 times
Question 2 (8 points) Max 15X + 13 subject to 20X + Y S80 15% - 2.5Y > 2 2x + 5Y > 12 X 20 Y 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 are the optimal values of X and Y? Enter your answer as an ordered pair: (X, YlRound to two decimal places
Y 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 are the optimal values of X and Y? Enter your answer as an ordered pair: (X, Y). (Round to two decimal places.) b) What is the value of the objective function at the optimal solution? (Enter the exact answer.) c) Suppose the right-hand side (RHS) of the first constraint could be increased by 10. How much will the objective function improve? A/ d) How many of the constraints are binding?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!