H Problem 3: Sensitivity Analysis Exercise - Model rom This is the model for the problem attached on the right side. The sensitivity report for this model is on the next worksheetsed on this model and the sensitivity report answer the questions on 2 wheet Problem Destions United Aluminum Company of Cincinnati produces three grades high, medium, and low) of 4 Aluminum MAI Mill 2 Production Quantity Demand aluminum two mills. Each mills offerent production capacity in tons per day) for each 5 High 6 2 24 12 6 Medium 2 2 8 Low 4 MI 10 5 B Aluminum Grade 1 2 9 Cost per day 6000 7000 High . 2 Medium 2 2 10 Low 4 10 11 Operation days 12 Mill Mill 2 The company has come with a mancing firm to supply 12 tons of high-grade 13 0 56.000 per day topland 57,000 per day to operate mil 2. The company was to 15 Total cost 2.4000 18 A B B DE F Problem 3: Sensitivity Analysis Exercise - Sensitivity Report G H Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 5 $B$15 Mill 1 4 0 6000 1000 6000 7 $C$15 Mill 2 0 1000 7000 1E+30 1000 3 9 Constraints 10 Final Shadow Constraint Allowable Allowable 11 Cell Name Value Price R.H. Side Increase Decrease 12 $D$7 High Production Quantity 24 0 12 12 1E+30 13 $D$8 Medium Production Quantity 8 3000 8 1E+30 4 14 $D$9 Low Production Quantity 16 0 5 11 1E+30 15 16 17 18 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? 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? H Problem 3: Sensitivity Analysis Exercise - Model rom This is the model for the problem attached on the right side. The sensitivity report for this model is on the next worksheetsed on this model and the sensitivity report answer the questions on 2 wheet Problem Destions United Aluminum Company of Cincinnati produces three grades high, medium, and low) of 4 Aluminum MAI Mill 2 Production Quantity Demand aluminum two mills. Each mills offerent production capacity in tons per day) for each 5 High 6 2 24 12 6 Medium 2 2 8 Low 4 MI 10 5 B Aluminum Grade 1 2 9 Cost per day 6000 7000 High . 2 Medium 2 2 10 Low 4 10 11 Operation days 12 Mill Mill 2 The company has come with a mancing firm to supply 12 tons of high-grade 13 0 56.000 per day topland 57,000 per day to operate mil 2. The company was to 15 Total cost 2.4000 18 A B B DE F Problem 3: Sensitivity Analysis Exercise - Sensitivity Report G H Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 5 $B$15 Mill 1 4 0 6000 1000 6000 7 $C$15 Mill 2 0 1000 7000 1E+30 1000 3 9 Constraints 10 Final Shadow Constraint Allowable Allowable 11 Cell Name Value Price R.H. Side Increase Decrease 12 $D$7 High Production Quantity 24 0 12 12 1E+30 13 $D$8 Medium Production Quantity 8 3000 8 1E+30 4 14 $D$9 Low Production Quantity 16 0 5 11 1E+30 15 16 17 18 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? 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