Drop down options:

Requirement 1:

The constraining factor is- linear feet of shelf space, number of customers per day, number of Yummy Time cans, number of Yummy Time bottles, number of Best-Cola bottles

Decision: Stock- an equal number of each product, all 12 oz. cans of Yummy Time cans, all 20 oz. of Yummy Time bottles, Number of Best-Cola bottles

Requirement 2:

First stock- 0, 35, 65, 95 / highest, lowest, middle / all 12 oz. cans of Yummy Time cans, all 20 oz. of Yummy Time bottles, Number of Best-Cola bottles

Next stock- 0, 35, 65, 95 / highest, lowest, middle / all 12 oz. cans of Yummy Time cans, all 20 oz. of Yummy Time bottles, Number of Best-Cola bottles

Each morning, Mike Preston stocks the drink case at Mike'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 seven 12-ounce cans or three 20-ounce bottles. Click the icon to view the information on the cold drinks.) Mike's Beach Hut can sell all the drinks stocked in the display case each morning. 0 Data Table Mike's Beach Hut sells three types of cold drinks: 1. Yummy Time in 12-oz. cans for $1.40 per can 2. Yummy Time in 20-oz. bottles for $2.00 per bottle 3. Best-Cola in 20-oz. bottles for $2.45 per bottle Mike's Beach Hut pays its suppliers: 1. $0.25 per 12-oz. can of Yummy Time 2. $0.30 per 20-oz, bottle of Yummy Time 3. $0.60 per 20-oz. bottle of Best-Cola Mike's Beach Hut's monthly fixed costs include: Hut rental 350 Refrigerator rental 60 1,450 Mike's salary 1,860 Total fixed costs Requirement 1. What is Mike's Beach Hut's constraining factor? What should Mike stock to maximize profits? The constraining factor is What should Mike stock to maximize profits? Complete the product mix analysis to determine which product would maximize Mike's profits. Yummy Time 12 oz. Cans Yummy Time 20 oz. Bottles Best-Cola 20 oz. Bottles Sales price per unit Variable cost per unit Contribution margin per unit Units per linear foot of shelf space Contribution margin per linear foot of shelf space Decision: Stock Requirement 2. Suppose Mike's Beach Hut refuses to devote more than 65 linear feet to any individual product. Under this condition, how many linear feet of each drink should Mike's stock? How many units of each product will be available for sale each day? (Abbreviation used: CM = contribution margin.) Mike's Beach Hut should stock its shelves as follows: First stock L Next stock inear feet with the product that has the linear feet with the product that has the CM per linear foot - CM per linear foot - L L 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 "O" in the appropriate cell.) Yummy Time in 12 oz. cans: Yummy Time in 20 oz. bottles: Best-Cola in 20 oz. bottles: Units for sale cans | bottles bottles Choose from any list or enter any number in the input fields and then continue to the next