Max 15 13y Subject To 20x 7y 80 15x 2 5y 2 2x 5y 12 X 20 Y 20 Consider The Linear Optimization Model Displayed 1 (36.19 KiB) Viewed 34 times
Max 15 13y Subject To 20x 7y 80 15x 2 5y 2 2x 5y 12 X 20 Y 20 Consider The Linear Optimization Model Displayed 2 (43.54 KiB) Viewed 34 times
Max 15% +13Y subject to 20x + 7Y < 80 15X - 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, Y). (Round to two decimal places.)
Y > 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: a) What are the optimal values of X and Y? Enter your answer as an ordered pair: (X, 7). (Round to two decimal places.) A/ b) What is the value of the objective function at the optimal solution? (Enter the exact answer.) A/ 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? AX
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!