Using the example Solve for the problem with the steps

solve pls

Read the requirements. Requirement 1. What is the constraining factor at Joel's Beach Hut? What should Joel stock to maximize profits? What is the maximum contri The constraining factor is Joel's should stock the drink with the contribution margin. Complete the product mix analysis to determine which product would maximize Joel's profits. Data table The beverage stand sells three types of cold drinks: 1. Grand - Cola in 12-oz. cans for $1.60 per can 2. Organic - Ade in 20 -oz. plastic bottles for $1.65 per bottle 3. Orange Soda in 20 -oz. glass bottles for $2.30 per bottle Joel's Beach Hut pays its suppliers the following: 1. $0.25 per 12-oz. can of grand - cola 2. $0.40 per 20 oz. bottle of organic - ade 3. $0.80 per 20 oz. bottle of orange soda Joel's Beach Hut's monthly fixed expenses include the following: 1. What is the constraining factor at Joel's Beach Hut? What should Joel stock to maximize profits? What is the maximum contribution margin he could generate from refrigerated drinks each day? 2. To provide variety to customers, suppose Joel refuses to devote more than 60 linear feet and no less than 5 linear feet to any individual product. Under this condition, how many linear feet of each drink should be stocked? How many units of each product will be available for sale each day? 3. Assuming the product mix calculated in Requirement 2, what contribution margin will be generated from refrigerated drinks each day? Each morning, Mike Imery stocks the drink case at Mike's Beach Hut in Grand Isle, Louisiana. Mike's Beach Hut has 120 linear feet of refrigerated display space for cold drinks. Each linear foot can hold either six 12-ounce cans or three 20 -ounce plastic or glass bottles. (Click the icon to view the information on the cold drinks.) The beverage stand can sell all drinks stocked in the display case each morning. Read the requirements. To maximize profits, Mike's should devote all its shelf space to the product that produces the highest contribution margin per linear foot. Review the product mix analysis you completed above to determine which drink Mike's should devote all of its shelf space to. Now calculate the maximum contribution margin that Mike could generate each day from refrigerated drinks. From the product mix analysis above, we can see that the grand - cola 12-oz. cans produces the highest contribution margin per linear foot of shelf space. Calculate the daily contribution margin that Mike would generate if he devoted all of his shelf space to grand - cola 12-oz. cans. (Round your calculation to the nearest whole dollar.) g Requirement 2. To provide variety to customers, suppose Mike refuses to devote more than 70 linear feet and no less than 20 linear feet to any individual product. Under this condition, how many linear feet of each drink should be stocked? How many units of each product will be available for sale each day? Each morning, Mike Imery stocks the drink case at Mike's Beach Hut in Grand Isle, Louisiana. Mike's Beach Hut has 120 linear feet of refrigerated display space for cold drinks. Each linear foot can hold either six 12-ounce cans or three 20 -ounce plastic or glass bottles. (Click the icon to view the information on the cold drinks.) The beverage stand can sell all drinks stocked in the display case each morning. Read the Requirement 2. To provide variety to customers, suppose Mike refuses to devote more than 70 linear feet and no less than 20 linear feet to any individual product. Under this condition, how many linear feet of each drink should be stocked? How many units of each product will be available for sale each day? Mike's should stock its shelves so that the highest contribution margin uses the maximum linear feet to be devoted. The lowest contribution margin should receive the lowest amount of linear feet, and the remaining linear feet should be devoted to the product that has the middle contribution margin of the three products. This allows the highest contribution margin the greatest amount of space to be allowed to be available for sale each day. Go ahead and select the product with the highest contribution margin that should have the maximum constraint that Mike will devote, which is in this case, 70 linear feet. Then, select the next two individual products and linear feet Each morning, Mike Imery stocks the drink case at Mike's Beach Hut in Grand Isle, Louisiana. Mike's Beach Hut has 120 linear feet of refrigerated display space for col Irinks. Each linear foot can hold either six 12-ounce cans or three 20-ounce plastic or glass bottles. (Click the icon to view the information on the cold drinks.) he beverage stand can sell all drinks stocked in the display case each morning. Read the requirements. jock tne remanng IInear . with proauct naving the Livl: LU UL. nutlies Ui nest-cula Jow calculate the units available for sale. The linear feet and units per linear foot that you determined in the preceding step have been entered for you. Requirement 3. Assuming the product mix calculated in Requirement 2, what contribution margin will be generated from refrigerated drinks each day? Jalculate the contribution margin that Mike will generate each day assuming the product mix you determined in Requirement 2 . (Round your calculations to the nearest vhole dollar.)