Structuring a Keep-or-Drop Product-Line Problem with Complementary Effects

Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines:

Line Item Description	Strip	Plank	Parquet	Total
Sales revenue	$391,000	$211,000	$313,000	$915,000
Less: Variable expenses	235,000	125,000	260,000	620,000
Contribution margin	$156,000	$86,000	$53,000	$295,000
Less direct fixed expenses:
Machine rent	(4,000)	(16,000)	(52,000)	(72,000)
Supervision	(19,500)	(13,000)	(6,500)	(39,000)
Depreciation	(35,000)	(10,000)	(25,000)	(70,000)
Segment margin	$97,500	$47,000	$(30,500)	$114,000

Hickory's management is deciding whether to keep or drop the parquet product line. Hickory's parquet flooring product line has a contribution margin of $53,000 (sales of $313,000 less total variable costs of $260,000). All variable costs are relevant.

Relevant fixed costs associated with this line include 80% of parquet's machine rent and all of parquet's supervision salaries. In addition, assume that dropping the parquet product line would reduce sales of the strip line by 20% and sales of the plank line by 5%. All other information remains the same.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

Required:

1. If the parquet product line is dropped, what is the contribution margin for the strip line? fill in the blank

For the plank line?

2. Which alternative (keep or drop the parquet product line) is now more cost effective and by how much?

DropKeep