Data Table Mike's Beach Hut sells three types of cold drinks: 1. Right - Cola in 12-oz. cans for $1.50 per can 2. Right- Cola in 20-oz. bottles for $2.00 per bottle 3. Pretty Pop in 20-oz. bottles for $2.45 per bottle Mike's Beach Hut pays its suppliers: 1. $0.05 per 12-oz. can of Right- Cola 2. $0.30 per 20-oz. botle of Right Cola 3. $0.60 per 20-oz. bottle of Pretty Pop Mike's Beach Hut's monthly fixed costs include: Hut rental Refrigerator rental Mike's salary Total fixed costs 355 70 1,850 $2,275 Print Done Each moming Mike White stocks the drink case at Mke's Beach Hut in Mytle Beach, South Carolna The drink case has 105 linear feet of refrigerated drink space. Each inear toot can hoid either six 12 aunce cans or three 20-ounce botties Cick the icon to view the information on the cold drinks.) Mike's Beach Hut can sell all the drinks stocked in the dspay case each moming Read the requiremonts Requirement 1. What is Mikes Beach Hut's constraining factor? What should Mke stock to maximice profits? The constraining factor is What should Mike stock to maximize protns Complete the product mix analysis to determine which product would maxmize Mike's profits Right-Cola Right-Cola Pretty Pop 12 ez Cans 20 o Bottles 20 . Bottles Sales price per uni Variatle cost per u Choose from any ist or enter any number in the input Selds and then conteue to the next question Each morning, Mke White stocks the drink case at Mke's Beach Hut in Myrte Beach South Carolina The drink case has 105 linear foet of rerigerated drink space. Each linear foot can hold either sx 12-ouncoe cans or tree 20-ounce bottles EE (Click the icon to view the information on the cold drirks.) Mke's Beach Hut can sel all the drinks stocked in the display case each morning Read the requiremenhs Right-Cola Right-Cola Pretty Pop 12 oz. Cans 20 oz. Bottles 20 oz. Bottles Saies price per unt Variable cost per unit Contribution margin per unit Unilts per Iinear foot of sholf space Contrbution margin per inear foot of shell space Decision: Stock Choose from any list or enter any number in the input felds and then continue to the next question Each momning, Mke White stocks the drink case at Mike's Beach Hut in Myrtle Beach, South Carolina. The drink case has 105 linear feet of refrierated drink space Each inear foot can hoid eitfher six 12-ounce or three 20-ounce boties (Click the icon to view the information on the cold drinks) Mikes Beach Hut can sell all the drinks stocked in the display case each moming Read the roquirements Requirement 2. Suppose Mike's Beach Hut reluses to devote more than 70 linear feet to any indvidual product Under this condition, how many linear feot of each drink shouild Mika's stock? How many units of each product wi be available lor sale each day? (Abbreviation used CM-cotribution margin ) Mike's Beach Hut should stock its shelves as tollows First stocklinear foet with the product hat has the Mper inear foo Next stockinear foet with te product that has the per ner food Hew many units of each product w be availabio Sale each day mod dotermined into CM per linear foot CM per linear fool- based on the product mixed determined in the preceding step? (For entries with a $O balance, make sure to enter "0' in the appropriate cell) Units for sale Right-Cola in 12 oz. cans Righ-Cola in 20 oz bottiles bottes Choose from any list or enter any number in the input feids and then continue to the next q How many units of each product will be available for sale each day based on the product mixed det Units for sale Right-Cola in 12 oz. cans: Right-Cola in 20 oz. bottles: Pretty Pop in 20 oz. bottles: cans bottles bottles Choose from any list or enter any number in the input fields and then continue to the next que