Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions