Read the Semester Case Study and answer the question below. Julie I||.r'1.|"elk, Head of Finance calls you into her ofce and says: I have just been talking to Ben maa; Sales and Marketing Director, about the 5 Pencil. In the rst few months after the launch sales volumes were a little lower than budgeted. As a result of this, three months ago two things happened: rstly, Ben authorised a special promotional price for the SPencil on our website for sales direct to the public and secondly, he tasked his sales teams to secure new retail customers and gave them authority to offer small discount and extended credit terms to any new retail customers. Ben has asked me to look in detail at the impact of his actions three months ago on our actual prot compared to budget and the recoverability of our retail customer receivables. I have so far created a schedule which shows sales variances for the 5 Pencil for the last three months as well as the aged receivables information for the 5- Pencil customer. I would like you to prepare commentary to go with this schedule which explains: 1] Explain what the sales price, mix and quantity variances mean and the reasons for their occurrence. Please also comment on whether you think that Ben's two actions have been successful, with reference to each of the customer groups. [52 marks] {CLUE E: 3} 4. During the three-month period there was a change in the profile of S-Pencil customers as shown in the aged receivables comparison below. AGED RECEIVABLES COMPARISON: S-PENCIL CUSTOMERS 3 months ago Type of customer Number of customers Total amountdue Due within payment terms Up to 30 days overdue Over 60 days overdue Large bien 711 612 small retailers 367 320 42 Now Type of customer Number of customers Total amountdue Que within payment terms | Up to 30 days overdue Over 60 days overdue Large Retailers 498 108 59 small retailers 100 697 510 97 90 Notes: Standard credit terms for credit customers is 30 days. The three large retailer customers are the same customers. Required Write the briefing paper requested by Julie Welk.2) Analyse how the profile of aged receivables has changed over the last three months, reasons for these changes and the potential implication of these changes. Please also include two measures that we could take to manage these implications. [48 marks] (CLO2 & 3) Julie Welk then hands you her schedule. SALES VARIANCES FOR THE S-PENCIL FOR THE LAST THREE MONTHS Variance Large retailers | Small retailers |Website Total GS GS GS GS Sales price 0 135,000 A 84,000 A 219,000 A Sales mix 256,500 A 247 438 F 143,437 F 134 375 F Sales quantity 121,500 F 76,313 F 47,812 F 245,625 F Notes: 1. A = adverse, F= favourable. 2. These variances are for our sales to large retailers, small retailers and directly to consumers through our website. 3. The sales mix and quantity variances are calculated using the individual units method and budgeted gross profit. The budgeted gross profits are as follows: Variance Large retailers |Small retailers |Website GS GS GS Budgeted gross profit 6.75 9.25 12.75
