Following is the Sensitivity Report of an Excel Solver Optimization problem. 1a) Revenue maximization. What is the
Question:
Following is the Sensitivity Report of an Excel Solver Optimization problem.
1a) Revenue maximization. What is the impact of increasing the quantity of silk by 10 units?
a. It will increase the objective function.
b. It will change the optimal mix.
c. There will be no impact.
d. It will change both the optimal mix and the value of the objective function.
e. none of the options listed are correct.
1b) Based on the Report, I would be willing to pay $1 for an extra unit of Cotton?
a. True (yes)
b. False (no)
1c) What is the impact of increasing the quantity of labor by 100 units?
a. Increasing labor by 100 units will add $600 to the value of the objective function.
b. Increasing labor by 100 units will have no impact.
c. Increasing labor by 100 units will change the value of the objective function only.
d. Increasing labor by 100 units will change the optimal mix only.
e. none of the options listed are correct.
1d) Price of a shirt is $12, the price of pants is $13 and the price of a jacket is $19. What is the impact of decreasing the price of a jacket by $5?
a. It will impact the optimal mix but not the value of the objective function.
b. It will impact both the optimal mix and the objective function
c. It will decrease the value of the objective function, keeping the optimal mix unchanged.
d. I will have no impact.
e. none of the options listed are correct.
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier