management accounting
2. White and Co Ltd has a target to grow its net income before tax by 20% per year. It has several products in regular demand which generate the following performance each year: 000 Sales revenue 6,000 Variable costs 1,200 Attributable fixed costs 500 Attributable advertising 600 White and Co Ltd also introduces more exciting products regularly with short lifecycles. The forecasts for the two products currently in production are: 2019 2020 2021 2022 2023 2024 2025 000 000 000 000 000 000 000 Manitron Sales 600 400 150 Variable costs 150 100 90 Attributable fixed costs 20 20 20 200 Advertising 100 50 20 Peritron Sales 750 1,500 2,500 2,000 1000 400 Variable costs 75 500 1,000 1,000 700 300 Attributable fixed costs 30 30 30 30 30 30 300 Advertising 150 150 150 200 200 20 The company's common fixed costs are 1,600,000 in 2019 and are expected to increase by 2% per year. Peritron's first year of trading was 2019 and it is expected to cease trading in 2024. A new product, the Deritron, has been developed and tested and is due to be launched in 2020. Attributable Development costs for Deritron of 2,000,000 were incurred in the years up to 2018. These were included in research and development expenses and were written off by including them in common fixed costs in the years in which they were incurred. Deritron has the following expenditure forecasts: Pre-product launch expenditure for Deritron of 200,000 will be incurred in 2019. It is expected that Deritron will not trade in 2026 and there will be disposal expenses of 350,000 in that year. Deritron's forecast attributable fixed costs and advertising costs per year are shown below: Deritron Attributable fixed costs Advertising 2020 2021 2022 2023 000 000 000 000 40 40 40 40 800 200 100 100 2024 000 40 150 2025 000 40 150 Question continues on next page (Continued) White and Co Ltd wish to know what the net income before tax would be in the years 2019 to 2025, * Deritron's sales in 2020 will be 2,000,000 and for each year of trading thereafter, its trading will follow the ratios of sales growth and variable costs as a percentage of sales seen in Peritron's forecasts. Required a) Calculate the sales and variable costs for Deritron and produce a long-term budget for the years 2019 to 2025 for the company as a whole. (10 marks) 2. White and Co Ltd has a target to grow its net income before tax by 20% per year. It has several products in regular demand which generate the following performance each year: 000 Sales revenue 6,000 Variable costs 1,200 Attributable fixed costs 500 Attributable advertising 600 White and Co Ltd also introduces more exciting products regularly with short lifecycles. The forecasts for the two products currently in production are: 2019 2020 2021 2022 2023 2024 2025 000 000 000 000 000 000 000 Manitron Sales 600 400 150 Variable costs 150 100 90 Attributable fixed costs 20 20 20 200 Advertising 100 50 20 Peritron Sales 750 1,500 2,500 2,000 1000 400 Variable costs 75 500 1,000 1,000 700 300 Attributable fixed costs 30 30 30 30 30 30 300 Advertising 150 150 150 200 200 20 The company's common fixed costs are 1,600,000 in 2019 and are expected to increase by 2% per year. Peritron's first year of trading was 2019 and it is expected to cease trading in 2024. A new product, the Deritron, has been developed and tested and is due to be launched in 2020. Attributable Development costs for Deritron of 2,000,000 were incurred in the years up to 2018. These were included in research and development expenses and were written off by including them in common fixed costs in the years in which they were incurred. Deritron has the following expenditure forecasts: Pre-product launch expenditure for Deritron of 200,000 will be incurred in 2019. It is expected that Deritron will not trade in 2026 and there will be disposal expenses of 350,000 in that year. Deritron's forecast attributable fixed costs and advertising costs per year are shown below: Deritron Attributable fixed costs Advertising 2020 2021 2022 2023 000 000 000 000 40 40 40 40 800 200 100 100 2024 000 40 150 2025 000 40 150 Question continues on next page (Continued) White and Co Ltd wish to know what the net income before tax would be in the years 2019 to 2025, * Deritron's sales in 2020 will be 2,000,000 and for each year of trading thereafter, its trading will follow the ratios of sales growth and variable costs as a percentage of sales seen in Peritron's forecasts. Required a) Calculate the sales and variable costs for Deritron and produce a long-term budget for the years 2019 to 2025 for the company as a whole. (10 marks)
