Purchase Solution

Allocation of Fixed Costs: Herrestad Company

Not what you're looking for?

Ask Custom Question

Herrestad Company does produce and sell two products and the details below will be used to prepare a segmented income statement (showing the income for each product and the total) for the company. Use ABC to allocate all fixed costs to the two products.

Background information
Total Prod A Prod B
Beginning inventory 0
Units produced 10,000 2,500 7,500
Units sold 8,000 2,000 6,000

Selling price per unit $250 460 180
Variable costs per unit
Direct material 100 280 40
Direct labor 50 50 50
Variable overhead 30 45 25
Variable selling and admin. exp. 10 13 9

Fixed costs
Fixed manufacturing overhead 200,000
Fixed selling and administrative 100,000

Production runs (not $) 100 65 35
Number of sales reps (not $) 25 15 10
Here are the first few lines of the segmented income statement to help you get started. Complete the statement in good format and make sure you allocate the fixed costs to the two products. When done, comment on the information and the relative profitability of the two products.

Herrestad Company
Segmented Income Statement
For the period ending Dec. 31, 2011
A B Total
Sales $920,000
$1,080,000 $2,000,000
Variable costs:
Direct material 560,000 240,000 800,000

Attachments
Purchase this Solution

Solution Summary

--------------------------------------------------
Your discussion is 588 words including three tables to support the discussion. The computations are in excel (click in cells to see calculations) with some coaching notes on allocating fixed costs. Remember this is to give you ideas to start your own paper and not to be used as a "turn in ready" project. Academic Experts are expressly forbidden to write student papers.

Solution Preview

See attached for proper formatting:

Discussion:

The Herrestad Company has a classic problem: two product that use fixed overhead disproportionately. That is, according to the data given, in Table A below, product A uses more production runs and more sales reps than product B. And there are far fewer units of Product A, meaning that each unit requires a great deal of overhead resources to support. Granted, the sales price of Product A is high and therefore one might think that they are charging enough to carry all this extra overhead attention. But profitability analysis indicates otherwise.

Table A
Use of fixed overhead resources by product line

Total Prod A Prod B
Production runs (not $) 100.00 65.00 35.00
Number of sales reps (not $) 25.00 15.00 10.00

Profitability will be reviewed in two parts, first we will analyze the contribution margin, and then product line profitability overall, including fixed costs. Contribution margin is the sales price less the variable costs, that is, the costs that go up with each extra ...

Solution provided by:
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
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.