1 2 Question-Segment Analysis (16 marks) Harmark has three product lines in its retail stores: Kites, Wind Socks and Flags Results of the fourth quarter are presented E 3 Kites Wind Socks Flags 4557 Units Sold 2,000 1,500 1,200 6 Selling price per unit $ 18.00 $ 25.00 $ 14.00 Total Variable Costs $ 20,000 $ 21,500 $10,000 Fixed Costs-Advertising campaigns that focus on ONE product $ 3,100 $ 3,500 $ 2,600 8 line only 10 66 Allocated common fixed costs (salaries of sales staff that sell all product lines) $ 5,000 $ 5,000 $ 5,000 Allocated common costs will be incurred regardless of which product lines are offered. 11 12 Required part A: Prepare a segmented income statement in proper format: (11 marks) 13 Harmark Segmented Income Statement For the quarter ended December 31st 14 15 Sales 16 Variable Costs 17 Contribution Margin 18 Common Fixed Costs 19 222 20 21 Kites Wind Socks Flags Total Final Exam Q1 Q2 03 Q4 Q5 Q6 Formulas + Calculation Mode: Automatic Workbook Statistics