Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
