Question: Consider Problem # 2 of Homework 2 . Produce a sensitivity report using the excel solver. 1 . Answer questions 2 - 4 to 2
Consider Problem # of Homework Produce a sensitivity report using the excel solver.
Answer questions to making the best possible use of the sensitivity report. Explain your
answers clearly.
Based on the sensitivity report, what are the ranges for the available crushing time, sifting time, and
drying time such that the marginal profit of an additional unit of resource keeps the same as the cost
you would like to pay as indicated in question
Based on the sensitivity report, what are the price ranges for the coarse stones and fine stones in
which you will not change your current optimal schedule?
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
