Question

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 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		$84		$107
Direct fixed costs		$100,000		$425,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		240,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

Which product has the highest product margin?
A

Feedback

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			$

Feedback

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

Answer 1

1.

Kirchner glass products division

Segmented income statements of products A , B and C:

Particulars	Product A	Product B	Product C	Total
Sales	1,800,000 [12000 * 150]	1,740,000 [14500 * 120]	700,000 [10000 * 70]	4,240,000
less: variable cost	1,200,000 [12000 * 100]	1,218,000 [14500 * 84]	1,070,000 [10000 * 107]	3,488,000
contribution margin	600,000	522,000	(370,000)	752,000
less: direct fixed expenses	100,000	425,000	250,000	775,000
product margin	500,000	97,000	(620,000)	(23,000)
less common fixed expenses				200,000
operating income				(223,000)

A. The product A has the highest product margin which equals to $ 500,000

2.

The income statement when Dantrell decides to produce product A and product D

It is mentioned in the question that the quantity to be produced and sold of product D should same as the quantity produced and sold of any one of the product displaced. the maximum limit is 20,000 units.

As the quantity of product B is the highest which equals 14500 units , it is taken to be the units of product D produced and sold.

Segmented income statements of products A , B and C:

Particulars	Product A	Product D	Total
Sales	1,800,000 [12000 * 150]	1,160,000 [14500 * 80]	2,960,000
less: variable cost	1,200,000 [12000 * 100]	435,000 [14500 * 30]	1,635,000
contribution margin	600,000	725,000	1,325,000
less: direct fixed expenses	100,000	240,000	340,000
product margin	500,000	485,000	985,000
less common fixed expenses			200,000
operating income			785,000

By the above combination the operating income improves from a loss of $ 223,000 to a profit of $ 785,000 , therefore the improvement in profit is $ 1,00,8000

Calculation of improvement in profit

profits to cover loss of previous combination	$ 223,000
present profit	$ 785,000
Total improvement	$ 1,00,8000