After solving the problem and generating the Solver reports, answer the following questions: a) What is the optimal value of X? (Round to two decimal places.) b) What is the optimal value of Y? (Round to two decimal places.) c) What is the value of the objective function at the optimal solution? (Enter the exact answer.)

Elementary Linear Algebra (MindTap Course List)
8th Edition
ISBN:9781305658004
Author:Ron Larson
Publisher:Ron Larson
Chapter7: Eigenvalues And Eigenvectors
Section7.4: Applications Of Eigenvalues And Eigenvectors
Problem 69E: Use your schools library, the Internet, or some other reference source to find the real-life...
icon
Related questions
Question
16 see pictures to solve
Маx
45X + 35Y
subject to
-2X + 5Y > 20
22X – 15Y > -45
|
5X + 2Y < 55
X > 0
Y 2 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:
Transcribed Image Text:Маx 45X + 35Y subject to -2X + 5Y > 20 22X – 15Y > -45 | 5X + 2Y < 55 X > 0 Y 2 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:
After solving the problem and generating the Solver reports, answer the following
questions:
a) What is the optimal value of X? (Round to two decimal places.)
b) What is the optimal value of Y? (Round to two decimal places.)
A/
c) What is the value of the objective function at the optimal solution? (Enter the
exact answer.)
d) Suppose the right-hand side (RHS) of the third constraint could be increased by
10. How much will the objective function improve? (Round your answer to the
nearest whole number.)
A/
e) How many of the constraints are binding?
Transcribed Image Text:After solving the problem and generating the Solver reports, answer the following questions: a) What is the optimal value of X? (Round to two decimal places.) b) What is the optimal value of Y? (Round to two decimal places.) A/ c) What is the value of the objective function at the optimal solution? (Enter the exact answer.) d) Suppose the right-hand side (RHS) of the third constraint could be increased by 10. How much will the objective function improve? (Round your answer to the nearest whole number.) A/ e) How many of the constraints are binding?
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Basics (types, similarity, etc)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Elementary Linear Algebra (MindTap Course List)
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill