Question

In: Accounting

Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...

Segmented Income Statements, Adding and Dropping Product Lines

Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows:

Sales $4,590,000
Less: Variable expenses 3,953,450
Contribution margin $636,550
Less: Direct fixed expenses 675,000
Divisional margin $(38,450)
Less: Common fixed expenses (allocated) 200,000
Divisional profit (loss) $(238,450)

Upon arriving at the division, Dantrell requested the following data on the division’s three products:

Product A Product B Product C
Sales (units) 12,000 14,500 10,000
Unit selling price $150 $120 $70
Unit variable cost $100 $83 $107
Direct fixed costs $100,000 $430,000 $250,000

He also gathered data on a proposed new product (Product D). If this product is added, it would displace one of the current products; the quantity that could be produced and sold would equal the quantity sold of the product it displaces, although demand limits the maximum quantity that could be sold to 20,000 units. Because of specialized production equipment, it is not possible for the new product to displace part of the production of a second product. The information on Product D is as follows:

Unit selling price $80
Unit variable cost 30
Direct fixed costs 230,000

Required:

1. Prepare segmented income statements for Products A, B, and C.

Kirchner Glass Products Division
Segmented Income Statement
Products
A B C Total
Sales $ $ $ $
Less: Variable expenses
Contribution margin $ $ $ $
Less: Direct fixed expenses
Product margin $ $ $ $
Less: Common fixed expenses
Operating income (loss) $

Feedback

Do not forget common fixed costs are added at the Division level.

Which product has the highest product margin?

Feedback

Look at profit margin for each product.

2. Assume that Dantrell decides to produce products A and D for the coming year. Prepare the segmented income statements for these two products.

Kirchner Glass Products Division
Segmented Income Statement
Products
A D Total
Sales $ $ $
Less: Variable expenses
Contribution margin $ $ $
Less: Direct fixed expenses
Product margin $ $ $
Less: Common fixed expenses
Operating income $

By how much will profits improve given the combination assumed above? Enter your answer in dollars.
$

Solutions

Expert Solution

Answer :-

Required 1:-

Particular A B C total
Sales in Units 12,000 14,500 10000
Sales (Sales in Unit ×Unit selling price of each product ) $1,800,000 $1,740,000 $700,000 $4,240,000
Less :-Variable cost (Sales in Unit × Unit variable cost) 1,200,000 1,203,500 1,070,000 3,473,500
Contribute margin $600,000 $536,500 $(370,000) $766,500
Less :-Direct fixed costs 100,000 430,000 250,000 780,000
Product margin 500,000

106,500

(620,000) (13,500)
Less :-common fixed expenses 200,000
Operating profit (loss)

($213,500)

Product A has highest Profit Margin

Required 2 :-

Since Product C has negative profit margin so we would replace it with Product D. It produces same quantity as Product C ie 10000 units.

A D total
Sales in Unit 12,000 10,000 22,000

Sales (Sales in Units × Selling price of each product)

$1,800,000 $800,000 $2,600,000
Less :-variable cost (Sales in Unit × Unit variable Costs) 1,200,000 300,000 1,500,000
Contribution margin $600,000 $500,000 $1,100,000
Less:- direct fixed costs 100,000 230,000 330,000
Product margin $500,000 $270,000 $770,000
Less :-common fixed expenses (given) 200,000
Operating profit (loss) $570,000

Profits improve given the combination assumed above are 1

Profit improve = $570,000 - (-$213,500)

Profit improved by $783,500


Related Solutions

Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
egmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
egmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
egmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of...
egmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable expenses 3,953,450 Contribution margin $636,550 Less: Direct...
Please provide the correct answer and explanation Segmented Income Statements, Adding and Dropping Product Lines Dantrell...
Please provide the correct answer and explanation Segmented Income Statements, Adding and Dropping Product Lines Dantrell Palmer has just been appointed manager of Kirchner Glass Products Division. He has two years to make the division profitable. If the division is still showing a loss after two years, it will be eliminated, and Dantrell will be reassigned as an assistant divisional manager in another division. The divisional income statement for the most recent year is as follows: Sales $4,590,000 Less: Variable...
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of...
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of each product line and the company are as follows: SCRIPT, INC. Product Line and Company Income Statements For Month of September Pens Pencils Total Sales $25,000 $30,000 $55,000 Less variable expenses (10,000) (12,000) (22,000) Contribution margin 15,000 18,000 33,000 Less direct fixed expenses (10,000) (9,000) (19,000) Product margin $5,000 $9,000 $14,000 Less common fixed expenses (6,000) Net income $8,000 Pens and pencils are sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT