The following is a breakdown of Sales by Channel. Sales Channel Online Retail Catalogue Sales $300,000 $150,000 $210,000 Variable Costs as a percent of sales 50% 40% 45% Traceable Fixed Costs 100,000 85.000 80.000 Common Fixed Costs $124,000 a. Create a segmented contribution margin statement using a computer spreadsheet. Segmented Contribution Margin Statement Segment (Sales Channel) Total Online Retail Catalogue Sales 660,000 300,000 Less: Variable Costs 304,500 150,000 Contribution Margin 355,500 150,000 Less: Traceable Fixed Costs 265,000 Segment Margin 90,500 50,000 5,000 35,500 Less: Common Fixed Costs 124,000 Operating Profit (33,500) b. What would happen to overall company profits if the Retail division were discontinued