Answer Happy

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