Calculate the cost of a custom cello

Assignment Help Case Study
Reference no: EM131086730

Holly Manufacturing Case Study

Holly Manufacturing Company produces two cello models. One is a standard acoustic cello that sells for $600 and is constructed from medium-grade materials. The other model is a custom-made amplified cello with pearl inlays and a body constructed from special woods.

The custom cello sells for $900. Both cellos require 10 hours of direct labor to produce, but the custom cello is manufactured by more experienced workers who are paid at a higher rate.

Most of Holly's sales come from the standard cello, but sales of the custom model have been growing. Following is the company's sales, production, and cost information for last year:

Cello

 

Standard

Custom

Sales and production volume in units

 

 

900

100

Unit Selling Price

 

$600.00

$900.00

Unit costs:

 

 

 

  Direct materials

 

$150.00

$375.00

  Direct labor

 

$180.00

$240.00

  Manufacturing overhead*

 

$135.00

$135.00

    Total unit costs

                                     

$465.00

$750.00

Unit Gross Profit

 

$135.00

$150.00

 

 

 

 

Direct Labor Hours

 

10.00

10.00

Direct Labor Rate Per Hour

 

$18.00

$24.00

 

 

 

 

*  Manufacturing overhead costs:

 

 

 

       Building depreciation

$ 40,000

 

 

       Maintenance

   15,000

 

 

       Purchasing

   20,000

 

 

       Inspection

   12,000

 

 

       Indirect materials

   15,000

 

 

       Supervision

   30,000

 

 

       Supplies

   3,000

 

 

    Total manufacturing overhead costs

$135,000

 

 

Selling and Administrative expenses:

Commission to sales person                                3 % of Sales Revenue

Advertising, CEO salary, etc.                                $ 30,000  per year.

* These manufacturing overhead costs are company-wide,  fixed in nature: they do not vary with the volume of manufacturing activity.

The company allocates overhead costs using the traditional method. Its activity base is direct labor hours. The predetermined overhead rate, based on 10,000 direct labor hours, is $13.50 ($135,000 ÷ 10,000 direct labor hours).

Johann Brahms, president of Holly, is concerned that the traditional cost-allocation system the company is using may not be generating accurate information and that the selling price of the custom cello may not be covering its true cost.

President Brahms has hired your consulting team to help him understand cost allocation and provide more accurate information and advice. Here are some questions to guide your work.

A. The cost-allocation system Holly has been using allocates 90% of overhead costs to the standard cello because 90% of direct labor hours were spent on the standard model.     

How much overhead was allocated to each of the two models last year?

Discuss why this might not be an accurate way to assign overhead costs to products.

B. How would the use of more than one cost pool improve Holly's cost allocation?

C. Holly's controller developed the following data for use in activity-based costing:

     Manufacturing

 

 

Standard

Custom

Overhead Cost

Amount

      Cost Driver

Cello

Cello

Building depreciation

$40,000

      Square footage

3,000

1,000

Maintenance

$15,000

      Direct labor hours

9,000

1,000

Purchasing

$20,000

      # of purchase orders

1,500

500

Inspection

$12,000

      # of inspections

400

600

Indirect materials

$15,000

      # of units manufactured

900

100

Supervision

$30,000

      # of inspections

400

600

Supplies

$3,000

      # of units manufactured

900

100

Total

$135,000

 

 

 

D. Use activity-based costing to allocate the costs of overhead per unit and in total to each model of cello. Show all supporting calculations. It is appropriate to use an excel document to do your computations in Excel

E. Calculate the cost of a custom cello using activity-based costing.

F. Why is the cost different from the cost calculated using the traditional allocation method?

G. At the current selling price, is the company covering its true cost of production? Briefly explain

H. What price could Holly Manufacturing set that would give about the same profit margin (% ) as the standard cello?  Show all calculations.

I. What should Holly Manufacturing do if the quantity of custom cellos sold at the new price falls to 50 per year?

J. What should Holly Manufacturing do about the situation if market conditions are such that the price of the custom cello cannot exceed $900?

K. At a selling price of $600 for the standard cello and $1,000 for the custom cello, and assuming the same product mix, what is the breakeven unit volume for each cello (remember it is difficult to sell a fraction of a cello, so round-up.  You need to consider the product mix when selling 2 products). Please show President Brahms a contribution Income Statement reflecting the sales at breakeven.

Write a brief report to President Brahms explaining your conclusions and the benefits of your suggestions. What are the lessons learned from this case that can help him understand cost allocation.

Reference no: EM131086730

Questions Cloud

Estimated the loss of production and the likely loss profit : Production at a factory had to stop for a week due to labour strike. The owner estimated the loss of production and the likely loss of profit arising out of the situation.
What is a potential drawback of this kind of media : How do you plan to integrate these new skills into your future school and work experiences? Give an example of a situation where a presentation would help you communicate information to others.
Hypothetical demand schedule for tammy fay : Consider the following hypothetical demand schedule for "Tammy Fay" brand Mascara: Qd  = 600 - 16? × P Where Qd represents quantity demanded in pounds and P is the price in dollars.
An investigation processing the scene collecting evidence : The scope of the investigation has been established, and you know that company polices clearly state the expectations for acceptable use and privacy. Management agrees that you should analyze the computers and surrounding work spaces for two emplo..
Calculate the cost of a custom cello : Use activity-based costing to allocate the costs of overhead per unit and in total to each model of cello. Show all supporting calculations. It is appropriate to use an excel document to do your computations in Excel. Calculate the cost of a custo..
The strengths and weaknesses of each company : 1.       Analyze the performance for each firm. Your analysis should be as thorough as possible given the data and your assumptions.
Business for expansion or new ventures : There are two types of capital that can be discussed, financial and investment. Investment capital would include such things as equipment and machinery that allows for production of goods and services. We will focus on the financial part for this ..
Impact on the organizations budget : Average length of stay and its impact on the organizations budget - Outline to the discussion area so that other students are able to review your plan.
Message evaluation techniques-online evaluation : Evaluation of any process is the analysis of ongoing activity to determine the effectiveness and efficiency. The Integrated Marketing communication (IMC) can be evaluated through:

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