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

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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