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

  Prepare a detailed swot analysis

Describe the company, its products and/or services, and the length of time it has been in operation and prepare a detailed SWOT Analysis.

  Case study on the next database revolution

Write an essay of no less than five pages with double line spacing describing your observations based on the course contents of the materials that were covered of Erl's textbook. You can also cite one or more other references that you can find?

  Explain management for quality and performance excellence

Explain Management for quality and performance excellence. The quality methodologies or practices that the company uses or plans to use to align performance excellence with its business objectives.

  Case study of a criminal offender

Discuss the biological, developmental, and environmental factors that relate to the criminal behavior.

  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.

  Case study health rates as top social issue

People living in ACT were most concerned while Tasmanians were the least concerned about environmental problems.

  Case study on disaster recovery lessons

Case Study on Disaster Recovery Lessons

  Prepare time management skills

Poor time management skills often lead to additional stress in our daily lives. In The 7 Habits of Highly Effective People by Stephen R. Covey, it says that people spend time in one of four quadrants. Read and review Covey's quadrants: Five Simplif..

  Would a commercial banker be willing to lend money

Would a commercial banker be willing to lend money to the Abramses? How much? On what do you base your answer? How has this changed in the past five years

  Discuss the terms jit and mrp

With respect to the supply chain, discuss the terms JIT (Just-in-time) & MRP (Materials Requirements Planning) - How are they related to maintaining proper levels of inventory?

  Is it ethical to use subversive approaches to influence othe

Although O'Keefe did not violate any laws, he should be punished. His behavior was unethical. He lied about his identity to Ron Schiller and edited the video to present false impressions about NPR. His subversive actions also led to a negative vot..

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