How much overhead was allocated to each of the two models

Assignment Help Finance Basics
Reference no: EM131018972

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 50per 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: EM131018972

Questions Cloud

State the domain and range of the given function : Write this equation in function notation. State the domain and range of this function. Graph this function for pendulums up to 20m in length.
Because of this fasb is considering allowing : The readings for this week talk about restatements and touch on a topic called "dark periods". This is the time it takes a company to restate their financial statements after determining that a material misstatement has occurred either through error ..
Find the information to analyze expected changes : Would you, as the CFO, finance your projects as soon as possible if cost of capital was expected to drop
Destination for the trip : Your PM7010 Group has been awarded a service contract by a local travel agent to plan an eight-day/seven-night trip for a group party of 50 people. The destination for the trip could be one of the following:
How much overhead was allocated to each of the two models : 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.
What is the amount anne will pay : Anne, Mary, Susie, and Rochelle go out to dinner and together spend $68.00 on the meal. They agree that they will split the tab for the meal evenly and that they will pay the waiter a 20% tip. What is the amount Anne will pay
Project for advertising and public relations : Your individual Final Project for Advertising and Public Relations is intended to showcase the analytical and creative public relations skills you've learned in MAR342. This project can be an exhibit in your senior portfolio presented to prospecti..
Give compound annual growth rates for key categories : Give compound annual growth rates for key categories (such as revenue, but you must decide which others will contribute to your understanding of the company )
One drawback for application that polypyrrole very fragile : Calculate the current generated in a 10-mm-long, 10.0 × 10-6-m-diameter polypyrrole filament that is subjected to a electric field gradient of 12 V. Assume that the conductivity of oxidized polypyrrole is (b) One drawback for this application is ..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Computation of expected future return of the debt

ABC Corporation will earn $60 if it does well. The debtholders are promised payments of $35 if the firm does well. If corporation does poorly, expected earnings will be $30 and the repayment will be $20 because of dead weight cost of bankruptcy.

  Describe the type of business you have created

The product or service, and general staffing plan. Provide a rationale for your plan.

  Determine the progressives cost of equity and corporate

progressive home health care inc. is a for-profit provider of home health care services in the pacific northwest. at

  Financial analysis

Use Microsoft Excel to chart the historical prices (like the one below) based on the monthly data.

  Elsee inc has net sales of 13 million and 75 percent of

elsee inc. has net sales of 13 million and 75 percent of these are credit sales. its cost of goods sold is 65 percent

  Disucss the financial strategy

Disucss and explain the financial strategy that your selected organization has created to manage your selected contemporary issue.

  Funding the retirement

How large fund will you need when you retire in 20 years to give the 30-year, $20,000 retirement annuity? What effect would increase in the rate you can earn both throughout and prior to retirement have on the values found in parts a and b? Discuss..

  Set up the amortization schedule for a 5-year 1 million 9

set up the amortization schedule for a 5-year 1 million 9 percent bullet loan. how is the principal repaid in this

  Your neighbor goes to the post office once a month and

your neighbor goes to the post office once a month and picks up two checks one for 13400 and one for 4400. the larger

  Explain conceptual differences between seasonal, cyclical

Why should a banker attend to the impacts of each of these components rather than simply looking at the total of loans and deposits?

  The modern language division earned 16 million on net

the modern language division earned 1.6 million on net assets of 20 million. the cost of capital is 11.5 percent.

  Determine the balance in investment

Determine the balance in Gale's investment in subsidiary account at the end of 2009?

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