Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 5: Sensitivity Analysis (25 Points) The following linear programming problem has been solved by Excel's Solver. Use the output to answer the questions. Consider

image text in transcribed
QUESTION 5: Sensitivity Analysis (25 Points) The following linear programming problem has been solved by Excel's Solver. Use the output to answer the questions. Consider the following linear program MAX 3x1 +4n IL 11+30 312 21+x258 Variate Cells Final Reduced Objective Allowable Name Value Cost Coefficient incase XI 24 0 3 5 3.2 0 4 5 Mewable Decrease 1.67 2.5 ns3 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R. Side Increase Decrease 3 12 1 12 12 3 2 3 1 8 1 3 24 0 3 1E 30 0.6 11, 2220 a What is the optimal solution including the optimal value of the objective function? b. Suppose the profit oax is increased to $7. Is the above solution still optimal? If simultaneously the profit on it was raised to $55 and the profit oax) was reduced to $3, would the current solution still semain optimal? c

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

DeFi And The Future Of Finance

Authors: Campbell R. Harvey, Ashwin Ramachandran, Joey Santoro, Vitalik Buterin, Fred Ehrsam

1st Edition

ISBN: 1119836018, 978-1119836018

More Books

Students also viewed these Finance questions