Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please explain the steps . im confused on how to start Max 11X +16Y subject to 8x +5Y 2 30 3X +2Y 2 25 5X
please explain the steps . im confused on how to start
Max 11X +16Y subject to 8x +5Y 2 30 3X +2Y 2 25 5X +2Y s 148 x 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 is the optimal value of x? b) What is the optimal value of y? c) What is the value of the objective function at the optimal solution? d) How many of the constraints are binding? 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? b) What is the optimal value of y? c) What is the value of the objective function at the optimal solution? d) How many of the constraints are binding? e) Consider increasing the coefficient of X in the objective function. What is the largest value the coefficient of X can take without changing t optimal solution? f) Suppose the right-hand side (RHS) of the third constraint could be increased to 150. How much will the objective function increase in value g) From the "Sensitivity Report," what is the allowable increase for the RHS value of the first constraint Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started