you will need appropriate software (e.g., Microsoft Excel, Tableau, Power BI) to create these visualizations and conduct the analysis. Make sure to include a comprehensive report with explanations, insights, and the appendices showing any calculations and workings.

Dudley Ltd is a toy company based in the UK for which the demand is influenced by changes in technology. Therefore, the company continually reviews the product life cycles to survive in the competitive environment that it operates. The production manager has designed the manufacturing facilities in such a way that it is able to produce all products on the same equipment and use the same multi-skilled work force. Management estimate that the annual production capacity of the company is equivalent to a turnover value of \\( \\mathbf{1 3 0} \\mathbf{m} \\). The turnover figures (actual and forecast) are shown below for each of products: Toy A, Toy B and Toy C from the beginning of the life cycle of each product up to 2023, which are the only products for which Dudley Ltd has sales (actual or forecast) for the years 2017 to 2022 . There are no other plans to introduce other product lines at this stage. Sales Revenue (fmillion) - actual (A) or forecast (F) Sales Volume in Units ('000) - actual (A) or forecast (F) Other relevant actual and forecasted information relating to the products for the years 2017-2025 are as follows: 1. Profit-volume ratios for each product are expected to be: Toy A \(70; Toy B \(75 and Toy C \(60. 2. The company's general fixed costs per year are \\( 3.75 \\mathrm{~m} \\), which are equally distributed to each toy. In addition, product specific fixed costs are estimated as follows: Current Retail Price for Similar Equivalent Product in the UK Toy Market (f) Annual Demands of Toys in UK* (million units) - actual (A) or forecast (F) Note: The annual demand refers to all toy manufacturers in the UK