Question

Data Table Mikes 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 Mikes 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 Mikes Beach Huts monthly fixed costs include: Hut rental Refrigerator rental Mikes salary Total fixed costs 355 70 1,850 $2,275 Print Done
Each moming Mike White stocks the drink case at Mkes 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.) Mikes Beach Hut can sell all the drinks stocked in the dspay case each moming Read the requiremonts Requirement 1. What is Mikes Beach Huts 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 Mikes 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 Mkes 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.) Mkes 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 Mikes 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 Mikes 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 Mikas stock? How many units of each product wi be available lor sale each day? (Abbreviation used CM-cotribution margin ) Mikes 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
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans : Mike's Beach Hut

Requirement 1

Constraining factor is Refrigerator's drink space which is limited to 105 linear feet

Each linear feet can store 6 12 -ounce can or 3 20- ounce bottle

Product mix analysis

Particulars Right- cola 12-ounce Can Right- cola 20-ounce Bottle

Pretty Pop 20-ounce Bottle

Sales price per unit

$ 1.50 $ 2.00 $ 2.45

Variable cost per unit

$ 0.05 $ 0.30 $ 0.60

Contribution margin per unit

$ 1.45 $ 1.70 $ 1.85

Unit per linear feet

$ 6.00 $ 3.00 $ 3.00

Contribution margin per linear feet

$ 8.70 $ 5.10 $ 5.55
Rank as per contribution per linear feet 1 3 2

As per the above analysis the contribution per linear feet of drink space in higher in Right - Cola 12- ounce can so it is to be stocked in the refrigerator to maximize the profit

Requirement 2) If there is Limit over allocation of refrigerator drinks space up to 70 linear feet

Then the product mix as follows

First stock Right - Cola 12- ounce can space allotted is 70 linear feet

Second stock Pretty Pop 20-ounce Bottle space allotted is 70 linear feet

Third Stock Right- cola 20-ounce Bottle space allotted is 10 linear feet

Unit of each product will be sold each day

Product Linear feet allotted Unit per Linear Feet Number of units

Right- cola 12-ounce Can

70 6 420 Cans

Right- cola 20-ounce Bottle

10 3 30 Bottles

Pretty Pop 20-ounce Bottle

70 3 210 Bottles
Add a comment
Know the answer?
Add Answer to:
Data Table Mike's Beach Hut sells three types of cold drinks: 1. Right - Cola in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please help, I am stuck with this problem. Each morning, Max White stocks the drink case at Max's Beach Hut in Myrtle B...

    Please help, I am stuck with this problem. Each morning, Max White 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. (Click the icon to view the information on the cold drinks.) Max's Beach Hut can sell all the drinks stocked in the display case each morning. Read the requirements Requirement 1....

  • Please Enlarge the attachments to view thank you Each​ morning, Ned Imery stocks the drink case...

    Please Enlarge the attachments to view thank you Each​ morning, Ned Imery stocks the drink case at Ned​'s Beach Hut in Victoria. Ned​'s Beach Hut has 42 linear metres of refrigerated display space for cold drinks. Each linear metre can hold either18 341-mL cans or 12 ​551-mL plastic or glass bottles. Each​ day, Ned​'s Beach Hut can sell all the drinks in the display case. i . X Data Table Ned's Beach Hut sells three types of cold drinks: 1....

  • Coca-cola in India case. 1. What aspects of US culture and of Indian culture may have...

    Coca-cola in India case. 1. What aspects of US culture and of Indian culture may have been causes of Coke's difficulties in India? 2. How might Coca-Cola have responded differently when this situation first occurred, especially in terms of responding to negative perceptions among Indians of Coke and other MNCs? 3. If Coca-Cola wants to obtain more of India’s soft drink market, what changes does it need to make? 4. How might companies like Coca-Cola and PepsiCo demonstrate their commitment...

  • Read about Cokes strategy in Africa in the article below and discuss the ethics of selling...

    Read about Cokes strategy in Africa in the article below and discuss the ethics of selling soft drinks to very poor people. Is this an issue that a company like Coke should consider? Africa: Coke's Last Frontier Sales are flat in developed countries. For Coke to keep growing, Africa is it By Duane Stanford Piles of trash are burning outside the Mamakamau Shop in Uthiru, a suburb of Nairobi, Kenya. Sewage trickles by in an open trench. Across the street,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT