Question 2.(20 points) A beverage cans manufacturer makes 3 types of soft drink cansneededforthebeverageproducerstofillsoftdrinksofthreedifferentvolumes.Themaximumavailability of the machines' time allotted per day is 90 hours and the supply of metal islimited to 120 kg per day. The following table provides the details of the input needed tomanufactureonebatchofcans.

Cans

	Large	Medium	Small	Maximum
Metal(kg)/batch	9	6	5	120
Machines'Time(hr)/batch	4.4	4.2	4	90
Profit/batch	$50	$45	$42

The manufacturer is interested in maximizing the total profit per day. The sensitivity reportprovided below was generated using the Excel Solver to determine the optimal solution tothisproblem.Usingthesensitivityreport,answerthefollowingquestions:

6 Variable Cells Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 SA$1 0 -0.4 50 0.4 1E+30 10 SB$1 10 O 45 5.4 0.085714286 11 SC$1 12 0 42 0.105263158 4.5 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 SD$3 120 1.2 120 8.571428571 7.5 17 $D$4 90 9 90 6 6