Question: [ 2 7 points, using the Model worksheet to create the Sensitivity Report worksheet, then answer questions on the Answers worksheet ] Run the Sensitivity
points, using the Model worksheet to create the Sensitivity Report worksheet, then answer questions on the Answers worksheet Run the Sensitivity Report for your optimal solution. Use this report to answer the following questions:
a If you could decrease the production and sales of any product, which product would it be How much would each pound decrease change the Objective Function? By how many pounds would you decrease production?
b If you could increase the production and sales of any product, which product would it be How much would each pound increase change the Objective Function? By how many pounds would you increase prioduction?
c If you could acquire more of any raw material, which one would you acquire, how much would you acquire, and what is the value of each additional unit of this raw material?
d If you could add more time to any of the machines, to which machine would you add time, how much time would you add, and what is the value of each additional unit of time on this machine?
e Management is considering raising the price of the Whole product by $ Will this change the current optimal solution?
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
