Prepare a Segmented Income Statement
Not what you're looking for?
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 $300 540 220
Variable costs per unit
Direct material 120 270 70
Direct labor 90 60 60
Variable overhead 40 85 25
Variable selling and admin. exp. 10 13 9
Fixed costs
Fixed manufacturing overhead 250,000
Fixed selling and administrative 100,000
Production runs (not $) 100 75 25
Number of sales reps (not $) 30 20 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. Need comments 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 $1,080,000 $1,320,000 $2,400,000
Variable costs:
Direct material 540,000 420,000 960,000.
Purchase this Solution
Solution Summary
The income is prepared in an attached Excel sheet where you can highlight the cells to view the formulae.
Solution Preview
ANSWER
SEGMENT INCOME STATEMENT
A B Total
sales-a 1080000 1320000 2400000
less:
variable costs
direct materials 540000 420000 960000
direct labor 120000 360000 480000
variable overhead 170000 150000 320000
variable selling and admn expenses 26000 54000 80000
totalvariablecosts ...
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
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.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.