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: Strip Plank Parquet Total Sales revenue 5411,000 $192,000 $320,000 $923,000 Less: Variable expenses 210,000 110,000 235,000 555,000 Contribution margin $ 201,000 $82,000 $85,000 $368,000 Less direct fixed expenses: : Machine rent (5,000) (20.000) (86,000) (111,000) Supervision (19,500) (13,000) (6,500) (39,000) Depreciation (28,000) (8,000) (20,000) (56,000 Segment margin $148,500 $41,000 $(27,500) $162,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 $85,000 (sales of $320,000 less total variable costs of $235,000). All variable costs are relevant. Relevant fixed costs associated with this line include 70% 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 10% and sales of the plank line by 10%. 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. 1. If the parquet product line is dropped, what is the contribution margin for the strip line? For the plank line? $ 73,800 2. Which alternative (keep or drop the parquet product line) is now more cost effective and by how much? Keep by Feedback Check My Work 1. Look at contribution margin and adjust for dropping product line. 2. Set up four columns. First column lists the income statement information starting with contribution margin. Second and third columns are for alternatives, keep or drop, and list all amounts. Fourth column is the differential amount to keep