PLEASE HELP ME NO 3 AND NO 5...

BAC3674 T2 2020/2021: Group Assignment 2 (due on 10/2/2021) Question 1 Waratah Ltd manufactures electronic devices, including PDAs, MP3 and MP4 players, for home and business use. Three years ago, it implemented an activity-based costing system. Both the management accountants and the manufacturing managers are very pleased with the results, as they now have accurate product costing information that they can use for a variety of decisions. However, the ABC system focuses only on product design and manufacturing costs. The activity based costs of Waratah's major products are as follows: Activity PDA Basic PDA+ PDA/Phone Designing $ 100 $ 110 $ 125 Purchasing 150 95 130 Assembling 890 1200 1400 Finishing 260 250 250 Total activity cost $1400 $1655 $1905 In July, Hannah Allen, the assistant accountant, noticed that over the last six months the spending in both the Customer Support Department and the Sales Department had been steadily increasing. The previous month's costs had been 20 per cent above budget! The customer support supervisor , Bill Dominico, is able to explain exactly why this is happening. He has had to employ new staff , there is more overtime being worked, and some of the service calls have been outsourced to a third-party maintenance company. But all this was necessary, as he explains: If a customer has a problem, we have to fix it! And if we have spent more than our budget. then that is just too bad. It is important to keep customers happy. Why, only the other day the managing director was teling us how important our customers are and how customer satisfaction is critical to the company's success. Hannah asks Bil if she can have access to the records of his department for the past three months (June quarter). She intends to analyse the service calls to see exactly where the extra Note: Total activity cost is per unit. money is being spent. She also plans to analyse the selling expenses that have occurred during June quarter. The analysis reveals the following data: The cost of selling and customer support activities, and selling price for each product, are as follows: PDA Basic PDA+ PDA/Phone Activities: Selling $39000 $33750 $9000 Customer support 78300 123750 20200 Selling price per unit $ 2000 $ 2600 $2800 The company's customers can be analysed into three main groups: educational institutions, business and home entertainment. The sales to these groups during the June quarter are detailed below: Customer groups PDA Basic PDA+ PDA/Phone Educational institutions 150 40 5 Business 30 30 Home entertainment 130 Total sales 300 150 20 80 5 40 The costs of customer support and selling activities for each customer group are as follows: Educational Business Home entertainment Selling expenses $28000 $25 750 $28000 Customer support 86000 49 750 86500 Note: the total sales for Customer groups during June quarters is in units. 3 Would you recommend dropping the loss-making products or customers? Explain your answer. 4 Use your spreadsheet to answer the following questions: (a) If the selling price of the PDA Basic decreased to $1600, and customer support for the PDA- reduced to $80 000, which product would be the most profitable? (b) If sales of the PDA/Phone to business customers increased to 40 and the selling price of the PDA/Phone increased to $3200, which customer group would be the most profitable? 5 Explain the types of performance measures that could be introduced by Waratah to assist in understanding and managing their customers. BAC3674 T2 2020/2021: Group Assignment 2 (due on 10/2/2021) Question 1 Waratah Ltd manufactures electronic devices, including PDAs, MP3 and MP4 players, for home and business use. Three years ago, it implemented an activity-based costing system. Both the management accountants and the manufacturing managers are very pleased with the results, as they now have accurate product costing information that they can use for a variety of decisions. However, the ABC system focuses only on product design and manufacturing costs. The activity based costs of Waratah's major products are as follows: Activity PDA Basic PDA+ PDA/Phone Designing $ 100 $ 110 $ 125 Purchasing 150 95 130 Assembling 890 1200 1400 Finishing 260 250 250 Total activity cost $1400 $1655 $1905 In July, Hannah Allen, the assistant accountant, noticed that over the last six months the spending in both the Customer Support Department and the Sales Department had been steadily increasing. The previous month's costs had been 20 per cent above budget! The customer support supervisor , Bill Dominico, is able to explain exactly why this is happening. He has had to employ new staff , there is more overtime being worked, and some of the service calls have been outsourced to a third-party maintenance company. But all this was necessary, as he explains: If a customer has a problem, we have to fix it! And if we have spent more than our budget. then that is just too bad. It is important to keep customers happy. Why, only the other day the managing director was teling us how important our customers are and how customer satisfaction is critical to the company's success. Hannah asks Bil if she can have access to the records of his department for the past three months (June quarter). She intends to analyse the service calls to see exactly where the extra Note: Total activity cost is per unit. money is being spent. She also plans to analyse the selling expenses that have occurred during June quarter. The analysis reveals the following data: The cost of selling and customer support activities, and selling price for each product, are as follows: PDA Basic PDA+ PDA/Phone Activities: Selling $39000 $33750 $9000 Customer support 78300 123750 20200 Selling price per unit $ 2000 $ 2600 $2800 The company's customers can be analysed into three main groups: educational institutions, business and home entertainment. The sales to these groups during the June quarter are detailed below: Customer groups PDA Basic PDA+ PDA/Phone Educational institutions 150 40 5 Business 30 30 Home entertainment 130 Total sales 300 150 20 80 5 40 The costs of customer support and selling activities for each customer group are as follows: Educational Business Home entertainment Selling expenses $28000 $25 750 $28000 Customer support 86000 49 750 86500 Note: the total sales for Customer groups during June quarters is in units. 3 Would you recommend dropping the loss-making products or customers? Explain your answer. 4 Use your spreadsheet to answer the following questions: (a) If the selling price of the PDA Basic decreased to $1600, and customer support for the PDA- reduced to $80 000, which product would be the most profitable? (b) If sales of the PDA/Phone to business customers increased to 40 and the selling price of the PDA/Phone increased to $3200, which customer group would be the most profitable? 5 Explain the types of performance measures that could be introduced by Waratah to assist in understanding and managing their customers