Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 . Please answer the following questions ( please have your answers in this sheet ) based on the sensitivity analysis sheet from Solver. -
Please answer the following questions please have your answers in this sheet based on the sensitivity analysis sheet from Solver.
Tips: On the spreadsheet, Highlight the cells of coefficients, go to Tab Home group of "Cells", click button of "format", select "Format cells", then "number", then "fraction" up to two digits.
What is the optimal solution? Must indicate the cells on the Spreadsheet where you find the answer.
How much are the ranges of optimality for the coefficients of X and XMust indicate the Cells you referred to on the spreadsheet
how much is the dual value for each constraint? Must indicate the Cells you referred to on the spreadsheet
Which constraints are binding? Why? must indicate what cells on the spreadsheet you used
Will the optimal solution change if the coefficient of X in the objective function was changed to Why?
Will the optimal solution change if the coefficient of X in the objective function was changed to Why?
If the RHS of # constraint changed to how much will the objective function output be increased? Which cell you referred to on the spreadsheet?
If the RHS of # constraint changed to how much will the objective function output be increased? Which cell you referred to on the spreadsheet?
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