Question: Consider Problem # 2 of Homework 2 . Produce a sensitivity report using the excel solver. 1 . Answer questions 2 - 4 to 2

Consider Problem #2 of Homework 2. Produce a sensitivity report using the excel solver.
1. Answer questions 2-4 to 2-6 making the best possible use of the sensitivity report. Explain your
answers clearly.
2. 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 1.?
3. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!