Ice milk scenario. A company supplies chocolate, vanilla, and banana ice milk to retail outlets. Currently, the company is short of supplies, with only 200 gallons of milk, 150 pounds of sugar, and 60 gallons of cream available. Each gallon of chocolate ice milk requires .45 gallons of milk, .50 pounds of sugar, and .10 gallons of cream. Each gallon of vanilla ice milk requires .50 gallons of milk, 40 pounds of sugar, and . 15 gallons of cream. Each gallon of banana ice milk requires .40 gallons of milk, .40 pounds of sugar, and .20 gallons of cream. The company realizes a profit of $1.00 per gallon of chocolate ice milk, $.90 per gallon of vanilla ice milk, and $.95 per gallon of banana ice milk. The company wants to decide how many gallons of each variety of ice milk to make to maximize its profit. B C D E F G H 3 results after using Excel's SOLVER tool 6 Constraints LHS RHS Slack/Surplus 7 limited milk 180 200 20 8 limited sugar 150 150 0 9 |limited cream 60 60 10 11 # gal Chocolate ice milk 0 optimal 12 # gal Vanilla ice milk 300 solution 13 # gal Banana ice milk 75 14 Profit 341.25 optimal value of objective function 15 16 17 Microsoft Excel 10.0 Sensitivity Report 18 19 Adjustable Cells 20 Final Reduced Objective Allowable Allowable 21 Cell Name Value Cost Coefficient Increase Decrease 22 $B$11 #gal Chocolate ice 0 -0.04 1.00 0.04 1E+30 23 $B$12 # gal Vanilla ice milk 300 o 0.90 0.05 0.01 24 $B$13 # gal Banana ice mil 75 0.95 0.02 0.05 25 26 Constraints 27 Final Shadow Constraint Allowable Allowable 28 Cell Name Value Price R.H. Side Increase Decrease 29 $B$7 limited milk 180 200 1E+30 20 30 $B$8 limited sugar 150 1.88 150 10 30 31 $B$9 limited cream 60 60 15 3.75 What are the binding constraints