Each morning, Ned Ivery stocks the drink case at Ned's Beach Hut in Myrtle Beach, South Carolina. The drink case has 95 linear feet of refrigerated drink space. Each linear foot can hold either six 12-ounce cans or three 20-ounce bottles. (Click the icon to view the information on the cold drinks.) Ned's Beach Hut can sell all the drinks stocked in the display case each morning Read the requirements. Data Table Requirement 1. What is Ned's Beach Hut's constraining factor? What should Ned stock to maximize profits? Ned's Beach Hut sels three types of cold drinks: . Grand-Cola in 12-oz. cans for $1.35 per can 2. Grand-Cola in 20-oz. bottles for $1.85 per bottle 3. Pretty Pop in 20-0z bottles for $2.30 per bottle The constraining factor is What should Ned stock to maximize profits? Ned's Beach Hut pays its suppliers: Complete the product mix analysis to determine which product would maximize Ned's profits 1. $0.25 per 12-oz. can of Grand-Cola 2. $0.40 per 20-oz bottle of Grand-Cola 3. $0.60 per 20-oz. bottle of Pretty Pop Grand-Cola Grand-ColaPretty Pop 12 oz. Cans20 oz. Bottles 20 oz. Bottles Ned's Beach Hut's monthly fixed costs include: Sales price per unit Variable cost per unit Contribution margin per unit Units per linear loot of shelf space Contribution margin per linear foot of shelf space Decision: Stock Hut rental efrigerator rental Ned's salary Total fxed costs 355 65 1,750 2,170 Print Done Requirement 2. Suppose Ned's Beach Hut refuses to devote more than 55 linear feet to any individual product. Under this condtion, how many linear feet of each drink should Ned's stock? How many units of each product will be avalable for sale each day? (Abbreviation used: CM contribution margin.) Ned's Beach Hut should stock its shelves as follows First stocklinear feet with the product that has theCM per linear foot Next stock inoar foet with the product that has the 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 $O balance, make sure to enter "O in the appropriate cell.) Units for sale Grand-Cola in 12 oz. cans Grand-Cola in 20 oz. bottles: Pretty Pop in 20 oz. bottlies: bottles bottles