Calculate a weighted average contribution margin

Assignment Help Case Study
Reference no: EM13882104

DEVELOPMENT OF THE CASE

The case assumes students will open a milkshake shack on the beach of a resort on the "big Island" of Hawaii. I have studied existing restaurants, read industry reports, and have done some research on expected minimum costs to be incurred in operating the business. A unique feature of my milkshakes is that I will serve them with flavored straws that match the flavor of the chosen milkshakes by customers. My research embeds the following assumptions:

Sales prices of milkshakes ($7.00 for small, and $10.00 for large)

Cost of materials needed to make milkshakes:
DIRECT MATERIAL INGREDIENTS
Small (8 oz. size)
Large (12 oz. size)
Whole Milk ($15 for a 5 gallon=640 oz.)
(need 2 oz. of milk)
(need 3 oz. of milk)
Cream ($20 for 1 gallon=128 oz.)
(need 2 oz. of cream)
(need 3 oz. of cream)
Sugar ($10 for a 15 lb. bag=30 cups)
(need ½ cup of sugar)
(need ¾ cup of sugar)
Premium Vanilla Ice Cream ($24 for 600 oz.)
(need 6 oz. of ice cream)
(need 9 oz. of ice cream)
Flavorings
.25 per shake
.40 per shake
Flavored specialty straws
.75 per straw
.75 per straw
Cups (500 8 oz. cups @ a cost of $200)

-------------------------------
Cups (500 12 oz. cups @ a cost of $250)
----------------------------

Fixed costs:

• Shack rental: $500 a month
• Cleaning and other miscellaneous supplies: $100 a month
• Equipment: Industrial Milk Shake Maker: $72 per machine x 10 machines=$720
• Equipment: Industrial Refrigerator/freezer: $480
• Countertops: $1,200
• Tables and benches for customers to sit outside: $108 per bench-set x 10=$1,080
• Annual insurance: $600 a year
• Sign: use your marketing knowledge to think of a good name= $100
• Advertising expenses: $5,000 a month
• Accounting and bookkeeping costs: $500 a month
• Owner's salary: $96,000 a year
• Dues and membership fees: $2,000 a year.
• Licenses and permit fees: $600 a year.
• Maintenance services: $400 a month.
• Office supplies: $300 a month.

Employees:
• Two part-time employees: each receiving a monthly salary of $800 (including benefits).

Total Start-up Costs = $20,247 for which students are assumed to take out a non-owner loan for the first months expenses and cost of long-term assets, which consist of the following amounts:

($500+$100+$720+$480+$1,200+$1,080+$50+$100+$5,000+$500+$8,000+$167+$50+$400+$300+1,600=$20,247).

A self-amortizing loan is assumed to be obtained from a bank for $20,247, and carries an annual interest rate of 6% payable over 2 years with monthly payments (each monthly payment consists of both principal and interest).

Other costs:

10% of gross sales must be given to resort where shack will be located on its premises.

Owner's capital will be used to cover direct materials' costs.

REQUIREMENTS OF THE FIRST PART OF THE CASE

In order to answer the questions below, you may make additional assumptions, and add/change fixed and variable costs (please clearly indicate all assumptions made).

• Using the above information, determine the number of milkshakes you will need to sell to break- even. In order to do this, you will need to:

• Set a sales price (please use the competitors' sales prices first of $10 for Large, and $7 (for small).

• Please clearly state which costs are fixed and which are variable. (Hint: keep all costs on a monthly basis throughout your analysis). Clearly indicate what the TOTAL fixed costs are on a monthly basis. Also, please clearly indicate variable cost PER UNIT for both the small and large sizes.

• You will also need to vary assumptions about depreciable lives for long-term assets.

• The Sales mix you will use is that of 60% Large, and 40% small. You are to present the solution based on that sales mix. Therefore, you will need to calculate a weighted average contribution margin [($10-variable cost per unit for large) * .60] + [($7- variable cost per unit for small) * .40]

• Finally, make a recommendation as to whether or not you should leave your job to open the milkshake shack?

Reference no: EM13882104

Questions Cloud

What circumstances can sellers recognize revenue over time? : what circumstances can sellers recognize revenue over time?
Risk-free rate-what is the required return on the market : Assume that the risk-free rate is 4.5% and that the market risk premium is 8%. What is the required rate of return on a stock with a beta of 0.8?  What is the required return on the market? What is the required rate of return on a stock with a beta o..
Describe three ways that bi changes raw data : Watch the video, "What is Business Intelligence?" and answer the following question: https://youtu.be/LFnewuBsYiY. Identify and describe three ways that BI changes raw data into comprehensive information
Toluene entering in the feed leaves in the liquid : A liquid containing 60 mol% toluene and 40 mol% benzene is continuously distilled in a single-equilibrium-stage unit at atmospheric pressure. What percent of benzene in the feed leaves in the vapor if 90% of the toluene entering in the feed leaves..
Calculate a weighted average contribution margin : Determine the number of milkshakes you will need to sell to break-even and calculate a weighted average contribution margin
Combined pentanes in the feed stream : The recovery of each main component in each product is to be 98%. For example, 98% of the propane in the feed stream is to appear in the propane-rich product, and 98% of the combined pentanes in the feed stream is to appear in the bottoms product ..
What is the required rate of return on AAs stock : AA Industries's stock has a beta of 1.7. The risk-free rate is 5%, and the expected return on the market is 11%. What is the required rate of return on AA's stock?
Which model would you choose for the engel expenditure curve : Which of these model(s) would you choose for the Engel expenditure curve and why?
Identify swap meet as primarily public sector undertaking : Identify the following as primarily public or private sector undertakings: eBay, farmer's market, state police department, car racing facility, travel agency, amusement park, gambling casino, swap meet, football stadium.

Reviews

Write a Review

Case Study Questions & Answers

  Case study on umuc haircuts

Introduce what is to come in your paper, and include the generic strategy for competitive advantage and the business process to be improved.

  What are the foundations of hasbros global success

What are the foundations of Hasbro's global success? What demographic changes and social issues might influence the future global market for toys and games?

  Why do all multinational automakers choose to use fdi

Why do all multinational automakers choose to use FDI to enter this market? What are the drawbacks of using other entry modes such as exporting and licensing?

  Case study - ideo and creativity

Describe the leadership, environment, and process factors specific to both individuals as well as teams that contribute to a creative climate.

  Write thee utility functions that describe nancys preference

The problem is a case study about Nancy who takes Fairy Tales and Philosophy courses from Prof. Grimm and Prof. Par respectively. As per the problem, three different utility functions have been described for Nancy's performance.

  What respects does original penguin represent

Why has it been important for Perry Ellis International to give freedom to a new venture team in order to relaunch Original Penguin - In what respects does Original Penguin represent a cultural change for Perry Ellis?

  What are the major issues in the liebeck case

What are the major issues in the Liebeck case and in the following incidents? Was the lawsuit "frivolous" as some people thought, or serious business?

  Discuss what characteristics of companies could influence

Discuss what characteristics of companies could influence their decision to innovate with the use of Womack's' technologies.

  What was logic underlying the chinese development strate

What was the logic underlying the Chinese development strategy? Why did reforms such as dual prices and the household responsibility system work in the agricultural sector but similar reforms did not work for state-owned firms?

  Case study-planning for growth

Case Study  Planning for Growth

  Case study - the juke by nissan

This is the Juke Case. It is an article from the Portland Press Herald in 2011. Your assignment is to read the article and answer a few questions. You will need to do some additional research beyond the article itself

  Analyze the case study

Analyze the Case Study, and develop the conclusions, recommendations, and implications in a one to one and half page APA formatted paper

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd