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 follo questions: a) What is the optimal value of X ? (Round to three decimal places.) b) What is the optimal value of Y ? (Round to three decimal places.) A c) What is the value of the objective function at the optimal solution? (Enter t exact solution.) d) Suppose the right-hand side (RHS) of the third constraint were increased by How much will the objective function increase? (Give the exact answer.) e) How many of the constraints are binding? Subject to 5X+4Y73X5Y82X+Y6X0Y0 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 ? (Round to three decimal places.) 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 follo questions: a) What is the optimal value of X ? (Round to three decimal places.) b) What is the optimal value of Y ? (Round to three decimal places.) A c) What is the value of the objective function at the optimal solution? (Enter t exact solution.) d) Suppose the right-hand side (RHS) of the third constraint were increased by How much will the objective function increase? (Give the exact answer.) e) How many of the constraints are binding? Subject to 5X+4Y73X5Y82X+Y6X0Y0 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 ? (Round to three decimal places.)