2 Blacks Industrial Ltd plans to grow its net income before tax by 20% per year. The company has several products in regular demand which generate the following performance each year: 000 Sales revenue 4,000 Variable costs 1,000 Attributable fixed costs Attributable advertising 400 500 2020 Blacks also introduces more exciting products regularly with short lifecycles. The forecasts for the two products currently in production are: 2019 2021 2022 2023 2024 2025 000 000 000 000 000 000 000 Galitron Sales 500 300 200 100 0 V costs 125 100 100 80 Attributable fixed costs 20 20 20 40 100 Advertising 100 85 60 20 Hexicon Sales V costs Attributable fixed costs Advertising 600 70 30 160 900 180 30 180 1,400 480 30 100 1,700 600 30 100 1,600 400 30 150 1400 400 30 150 800 500 30 40 The company's common fixed costs are 1,400,000 in 2019 and expected to increase by 2% per year A new product the "Janitron" has been developed and tested and is due to be launched in 2020. It has the following expenditure information: Attributable Development Costs for Janitron of 1.000.000 were incurred over several 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. Pre-product launch expenditure for Janitron of 200,000 will be incurred in 2019. It is expected that Janitron will not trade in 2026 and there will be disposal expenses of 350,000 in that year. Janitron's estimated costs per year are shown below: Janitron 2020 2021 2022 202 2024 2025 000 000 000 000 000 000 V costs as % sales 30% 40% 40% 50% 50% 50% Attributable fixed costs 40 40 40 40 40 40 Advertising 200 200 100 100 150 150 Question continues on next page 2. (Continued) Blacks Industrial Ltd are considering their future strategy in the light of the above forecasts and wish to know what sales of Janitron would be needed for the company to meet its target of 20% increase in net income before tax each year based on the previous year's net income before tax and starting from 2019. Required: a) Produce a complete long-term budget for the years 2019 to 2025 incorporating all the revenues and costs mentioned above and calculate the sales of Janitron which would be needed to meet the net income before tax requirement mentioned above, assuming that the other product forecasts are regarded as reliable. (12 marks) b) Comment on the sales figures you have calculated in (a) above and consider whether they are likely to match the marketing strategy for Janitron (assuming that the growth and decline patterns of previous products are typical). Discuss possible additional information which is needed to create a realistic long-term plan. (4 marks) c) Show the product life cycle budget for Janitron based on the estimated sales from part (a) and comment on the performance of the product. (4 marks) 2 Blacks Industrial Ltd plans to grow its net income before tax by 20% per year. The company has several products in regular demand which generate the following performance each year: 000 Sales revenue 4,000 Variable costs 1,000 Attributable fixed costs Attributable advertising 400 500 2020 Blacks also introduces more exciting products regularly with short lifecycles. The forecasts for the two products currently in production are: 2019 2021 2022 2023 2024 2025 000 000 000 000 000 000 000 Galitron Sales 500 300 200 100 0 V costs 125 100 100 80 Attributable fixed costs 20 20 20 40 100 Advertising 100 85 60 20 Hexicon Sales V costs Attributable fixed costs Advertising 600 70 30 160 900 180 30 180 1,400 480 30 100 1,700 600 30 100 1,600 400 30 150 1400 400 30 150 800 500 30 40 The company's common fixed costs are 1,400,000 in 2019 and expected to increase by 2% per year A new product the "Janitron" has been developed and tested and is due to be launched in 2020. It has the following expenditure information: Attributable Development Costs for Janitron of 1.000.000 were incurred over several 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. Pre-product launch expenditure for Janitron of 200,000 will be incurred in 2019. It is expected that Janitron will not trade in 2026 and there will be disposal expenses of 350,000 in that year. Janitron's estimated costs per year are shown below: Janitron 2020 2021 2022 202 2024 2025 000 000 000 000 000 000 V costs as % sales 30% 40% 40% 50% 50% 50% Attributable fixed costs 40 40 40 40 40 40 Advertising 200 200 100 100 150 150 Question continues on next page 2. (Continued) Blacks Industrial Ltd are considering their future strategy in the light of the above forecasts and wish to know what sales of Janitron would be needed for the company to meet its target of 20% increase in net income before tax each year based on the previous year's net income before tax and starting from 2019. Required: a) Produce a complete long-term budget for the years 2019 to 2025 incorporating all the revenues and costs mentioned above and calculate the sales of Janitron which would be needed to meet the net income before tax requirement mentioned above, assuming that the other product forecasts are regarded as reliable. (12 marks) b) Comment on the sales figures you have calculated in (a) above and consider whether they are likely to match the marketing strategy for Janitron (assuming that the growth and decline patterns of previous products are typical). Discuss possible additional information which is needed to create a realistic long-term plan. (4 marks) c) Show the product life cycle budget for Janitron based on the estimated sales from part (a) and comment on the performance of the product. (4 marks)