Activity costs Sales visits to customers 23,400 Fuel and standard delivery costs 9,480 Urgent order costs 7,500 9,000 Order change costs (colour) Order change costs (shape) 7,500 Required: (a) Each of the five customers generated the same gross profit of 18,500 for Metallia Plc in April 2020. Using the information provided, prepare a customer profitability analysis for the five customers individually. (9 marks) (b) Discuss the results of the customer profitability analysis and provide clear recommendations to the management of Metallia Plc on how they can use this analysis to increase the profits earned from their least profitable customer. (maximum word count 220 words) (11 marks) Metallia Plc manufactures and supplies biscuit tins to customers that go on to fill them with biscuits for supply to the retail sector. Metallia Plc has five customers and it suspects that some of its customers are not as profitable as they had once thought due to the increasing demands and late changes to orders that the customers are making. For example, an increasing number of requests are being made for changes to the original order in terms of the colour and shape of the tins ordered. Information relating to the five customers for the month of April 2020 is as follows: Customer E Total BCD 25 33 Number of sales visits 35 7 20 120 Number of standard deliveries 3 5 6 4 20 N Kilometres (Km) travelled per standard delivery 50 50 30 30 55 32 25 192 Number of urgent deliveries 3 2 0 3 10 N Number of order changes (colour) 5 3 8 6 8 30 Number of order changes (shape) 6 2 2 6 4 20