Purchase Solution

Mgmt Accounting: Bourbon coffee target profit, sales mix

Not what you're looking for?

Ask Custom Question

Please see attached file.

Bourbon coffee is one of the most popular Arabica coffees sold in the world. It was first produced on the French island of Ã?le Bourbon and was later taken by the French to Africa and Latin America. The president wants to introduce a new premium line of Bourbon coffee beans and has sourced premium green beans from small producers in the mountainous regions of Brazil. He feels they can charge more for these coffees and has met with the company's roastmaster and the marketing manager who together have planned three specialty coffees in their new Bourbon Premium line:
â?¢ Bourbon Aperitif: A French-roast-level coffee with a deep, intense, smoky-sweet flavour. Best enjoyed after an evening dinner.
â?¢ Bourbon Aperitif â?" Decaf: The decaffeinated version of the Bourbon Aperitif. For those who have to work the next day.
â?¢ Bourbon Full City: A medium-roast coffee with a slightly sweet taste.
The roastmaster, along with the production manager and the controller, has developed the following budget for this new product line:
Selling price per kilo Variable cost per kilo Sales mix
Bourbon Aperitif $9.95 6.67 2
Bourbon Aperitif - Decaf $12.82 9.74 1
Bourbon - Full City $7.74 5.03 3
Fixed costs allocated to this product line are $145,000 per year.

Required
a. Based on the predicted selling price, variable costs and sales mix, how many kilos of each type of coffee should be sold in order for the company to achieve $200,000 of income on sales from this product line?
b. The marketing manager noted that the demand for decaffeinated coffee will grow as baby boomers continue to enjoy the taste of coffee but want to reduce their intake of caffeine. He believes the actual sales mix will be 1:2:3. At this sales mix, how many more kilos of coffee will they have to sell in order to achieve the same level of income as in part (a)?
c. Provide a reason for the difference between the results from parts (a) and (b)

Attachments
Purchase this Solution
Solution Summary

Your tutorial is in Excel (attached). Click in cells to see computations.

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • CVP Analysis

    PROBLEM 6-23 Break-even and Target Profit Analysis (LO5, LO6) Mugs and More sells a large variety of coffee mugs.

  • Managerial Accounting Projections

    This is so because the higher the sales, the higher these expenses will be 3. Below summarizes the information provided in the case a. Initial investment of $25,000 b. Target sales level for a target profit of $50,000 4.

  • Formulate a Linear Program for Blend Mix at Bluegrass Distillery

    22016 Formulate a Linear Program for Blend Mix at Bluegrass Distillery The Bluegrass Distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey.

  • Old Tennessee Distillers

    Formulate a linear programming model that can be used to determine the optimal product mix that yields the maximize total weekly contribution to profit while meeting the individual product and weekly production blending requirements. b.

  • Linear Programming model

    Liquor On Hand (ounces) Bourbon 52 Brandy 38 Vodka 64 Dry Vermouth 24 Sweet Vermouth 36 Bob decided to mix four drinks for the party: Chaunceys, Sweet Italians, Bourbon on the Rocks, and Russian Martinis.

  • Mugs and More and Jean Leeman & Co. of Texas

    126708 BREAK-EVEN AND TARGET PROFIT ANALYSIS (LO5, LO6) Mugs and More sells a large variety of coffee mugs.

  • coffee shop bookstore

    Reducing marketing expenses of coffee house: Increasing sales per coffee house: Increasing the number of customers per employee in the coffee house; Internal Process Perspective: Reducing response time in serving coffee: Increasing space utilization

  • Linear programming

    The distillery company's cost per gallon is $2 for rye and $1 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits.

  • profit maximizing output level

    (Note: Meat enters the bourbon cost function as a fixed cost) g) What is the profit maximizing output level of meat? h) What now are the total profit from producing meat and bourbon?

View More Related Solutions