Question: Instructions: This is the model for the problem attached on the right side. The sensitivity report for this model is on the next worksheet. Based

Instructions: This is the model for the problem attached on the right side. The sensitivity report for this
model is on the next worksheet. Based on this model and the sensitivity report, answer the questions on
worksheet "Problem 3-Questions".
Problem 3: Sensitivity Analysis Exercise - Sensitivity Report
Problem 3: Sensitivity questions
1. What is the current optimal solution and the objective function value?
2. What is the objective function coefficient of decision variable 1(operation days of mill 1)?
3. What is the sensitivity range for the objective function coefficient of decision variable 1(operation days of mill 1)?
4. If the operation cost of mill 1 increases from \(\$ 6000\) to \(\$ 7500\), will the optimal solution change? And why?
5. What is the objective function coefficient of decision variable 2(operation days of mill 2)?
6. What is the sensitivity range for the objective function coefficient of decision variable 2(operation days of mill 2)?
7. If the operation cost of mill 2 decreases from \(\$ 7000\) to \(\$ 6500\), will the optimal solution change? And why?
8. Which constrains are binding?
9. If we can decrease the demand of high-grade aluminum by 2 tons at the cost of \(\$ 1000/\) ton, is it worth doing this? And why?
10. If the demand of medium-grade aluminum increases by 4 tons, what is the new total cost? And why?
11. If we can purchase 2 tons of medium-grade aluminum from our competitors at \(\$ 2000/\) ton to satisfy part of the demand, instead of making it in our mills (in other words, we can decrease the demand by 2 tons at the price of \(\$ 2000/\) ton), is it worth doing this? And why?
12. If the customer needs additional 5 tons of low-grade aluminum and is willing to pay \(\$ 1000/\) ton, do we want to accept this offer? And why?
13. If the customer needs additional 20 tons of low-grade aluminum and is willing to pay \(\$ 1000/\) ton, do we want to accept this offer? And why?
Instructions: This is the model for the problem

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!