TAS B D Question 3: Sales Mix Analysis (11 maks) Karen's Klothes, a clothing wholesaler, sells hoodies for women and girls. The following budgeted information has been provided for the month of May: Total fixed costs are $ 80.000 Women's Girls' Budgeted Sales Mix Selling price Variable Costs Contribution Margin 60% 80 28 40% 30 8 Required: Calculate the following: + 1. What is the weighted average contribution margin? (1 mark) 2. Calculate the breakeven point for the company as a whole. How many of each product line must be sold at the breakeven point? (3 marks) Women's Girls Total Breakeven Point 01 02 03 03 dataset 04 05 06 + Undo Font Chow M Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organizations admin lows you to use several bedoe. You get to Privacy Settings. These optional coud-backed services are provided to you under the Microsoft Services Agreement. La more fx Question 3: Sales Mix Analysis (11 marks) A1 B D 19 3. Assume the company plans on selling 2,500 hoodies. At the budgeted sales mix, what is 20 the budgeted total contribution margin? (2 marks) 21 22 Part B: Analysis of Actual Sales Data: 23 Management has gathered the sales data for the past month on the tab "Q3 dataset". Create a pivot table to summarize the total women's hoodies sold and girls' hoodies sold during the month. Place the pivot table in cell E24 on this worksheet. (3 marks) 24 25 Women's Girls' 26 What is the actual sales mix %? 27 How does the actual sales mix compare to the budgeted sales mix? What is the impact on income of having a 28 different sales mix than budgeted? (2 marks) 20 A Cover Sheet Q1 Q2 Q3 Q3 dataset 04 05 06 + III Workbook Statistics Calculation Mode: Automatic - Arial lis Merge Center S Paste BIU 2.0 Font O and Thanks for using Office we've made some updates to the privacy settings to give you more control your organizations admin ako Pra Settings. These storal dood backed services are provided to you under the Microsoft Services Agreement QUESTION 3 DATASET C D H G 1 E B Total Sales Day 32 62 43 38 50 35 32 62 Plet QUESTION 3 DATASET 1 Product 2 Sale Date Girls 3 Women's Customer Month 1 5 10 11 23 S 21 2 51 21 6 3 S 40 23 22 7 4 5 17 37 6 8 5 5 26 12 26 9 6 5 15 20 30 10 7 5 23 4 31 11 8 5 18 27 12 9 5 11 29 33 13 10 5 22 7 14 11 5 15 0 15 12 5 6 1 16 13 5 22 38 12 17 14 5 20 21 6 15 5 8 12 40 19 16 5 22 27 50 20 17 S 1 15 34 21 18 5 4 33 3 22 5 19 12 26 23 20 5 21 21 17 24 21 5 30 34 SO 25 22 5 10 38 11 36 15 ORNABENRANTAAR: 13 52 77 49 36 38 38 84 49 Cover Sheet Q1 Q2 Q3 Q3 dataset 04 05 06 + Coto Mode Wood Ma esc 23 BO Q F2 F3 FA 95 @ # 1 2 % 2 3 $ 4 5 tab Q W E R T
