Each morning, Max McKnight stocks the drink case at Max's Beach Hut in Myrtle Beach, South Carolina, The drink case has 110 linear feet of refrigerated drink space, Each linear foot can hold either seven 12-ounce cans or three 20-ounce bottles view the information on the cold drinks.) EEB(Click the icon Data Table Max's Beach Hut can sell all the drinks stocked in the display case each morning. Read the requirements Max's Beach Hut sells three tvpes of cold drinks: Requirement 1. What Max's Beach Hut's constraining factor? What should Max stock to maximize profits? 1.Yummy Time in 12-oz. cans for $1.55 per can 2. Yummy Time in 20-oz. bottles for 1.85 per bottle The constraining factor is 3. Vitamin Plus in 20-oz. bottles for $2.20 per bottle Max's Beach Hut pays its suppliers: What should Max stock to maximize profits? 1. $0.45 per 12-oz. can of Yummy Time Complete the product mix analysis to determine which product would maximize Max's profits. 2. $0.60 per 20-oz. bottle of Yummy Time 3. S0.80 per 20-oz, bottle of Vitamin Plus Yummy Time Yummy Time Vitamin Plus Max's Beach Hut's monthly fixed costs include: 12 oz. Cans 20 oz. Bottles 20 oz. Bottles Hut rental 385 S Sales price per unit Refrigerator rental 60 Variable cost per unit 1 800 Max's salary Contribution margin per unit 2,245 Total fixed costs Units per linear foot of shelf space Contribution margin per linear foot of shelf space Print Done Decision: Stock Requirement 2. Suppose Max's Beach Hut refuses to devote more than 1 linear feet to any individual product. Under this condition, how many linear feet of each drink should Max's stock? How many units of each product will be available for sale each day? (Abbreviation used: CM contribution margin.) Max's Beach Hut should stock i shelves as follows: |linear feet with the product that has the CM per linear foot First stock |linear foet with the product that has the Next stock CM per linear foot How many units of each product will be available for sale each day based on the product mixed determined in the preceding step? (For entries with a $0 balance, make sure to enter "0" in the appropriate cell.) Units sale Yummy Time in 12 oz. cans: cans Yummy Time in 20 oz. bottles: bottles 0 oz. bottles: Vitamin Plus in bottles