(Table A) Data and trends in sales volume and value by month, by year and across the 3 years period,

  69 Orders

Data driven Decisions for Business 

Msc Management
Coursework Assessment Brief [CW3(S)]

Kindly share your Latest Assessment to the LIVE EXPERT to get the DISCOUNTED price

1. General Assessment Guidance
♦ Your summative assessment for this module is made up of this 2500 words submission which accounts for 100% of the marks

2. Assessment Brief

2.1. Assessment learning outcomes
This assessment is designed to gauge your understanding, skills and application of common data analysis techniques used in business and other organisations today. As such you need to demonstrate your attainment in these areas according to the four Module Learning Outcomes (LOs):

♦ LO1: Critically evaluate the evolving use of data in solving business problems, presenting logical arguments based on evidence
♦ LO2: Explore how data analytics can be used within a business context
♦ LO3: Critically appraise the presentation of data within a business environment
♦ LO4: Critically evaluate different business analytical techniques as part of planning a data analytics initiative.

2.2. Scenario
You have recently been employed by Olympic Sports Ltd. as a data analyst. Olympic Sports Ltd. is an UK-based manufacturer of sport products selling across the UK and abroad. The company offers its products under its brand Olympic. The brand includes sport clothes such as outerwear, t-shits, shirts, shorts, trousers and footwear for all kind of sports (e.g. Aerobics, Athletics, swimming, Basketball, Boxing, Climbing, Cricket and Cycling).

Olympic Sports Ltd. has grown successfully selling its brand across many of the high street retailers in the UK including John Lewis, H&M and M&S. The company has also expanded business in other countries in Europe, in particular in France and Germany where it uses leading local retailers to sell its products.

As Olympic Sports Ltd. expands, it continues to increase its data analytic roles within the organisation to strengthening its strategic decision-making capabilities. The recruitment strategy is to employ young professionals with strategic and data analytics skills willing to provide Olympic Sports Ltd. top management with strong evidence-based foundation for their business decisions. They like recruits to have a broad management experience combine with strong academic background. Your MSc Management degree at BPP University was a key element in their decision to recruit you.

As part of the induction process at Olympic Sports Ltd., you have joined the Finance Department as junior dada analyst. Your manager requested you to complete a number of tasks to ensure that you have a grounded knowledge and understanding of data analytics and its application in decision- making. This is your opportunity to demonstrate your capability and give your employer the confidence to let you run your own project in the future.

As part of your first duties, your manager asked you to join the team in charge of the development of next year Business Plan for the company. The team is analysing different options for growth, which include expanding in more countries abroad, new product development and diversification into new business areas. However, it makes sense to define the strategy based on these options onlyDDDB CW3(S) Page 5 of 18 if the current business model does not provide the expansion and growth opportunities expected by the top management. So, you have been given the responsibility to analyse Olympic Sports Ltd. current business performance.

Your job will be to analyse the performance of the business in the UK, France and Germany. Olympic Sports Ltd. has experienced strong competition in these countries from international sport brands such as Nike, Adidas, Puma, Fila and Reebok. So, the performance in these countries is a good indication of the current overall market position of the company.

2.3. Research objectives and tasks
The Finance Director, who is responsible for assessing the financial viability of the company to invest in the different growth scenarios, is interested in understanding the option of opening own branded shops, so that the company can sell its products directly to customers without going through distributors and local retailers. This strategy will also allow Olympic Sports Ltd. to strengthen its brand against competitors who have already branded shops such as Nike. For this purpose, he wants you to:

Question 1: Perform a sales value and volume analysis of the three countries to identify the best country to open the first branded shop.

As part of the analysis, the Creative Director wants to consider the re-development of the product portfolio. He wants to focus on improving current products in terms of quality and design, therefore enhancing the market position and competitiveness of the Olympic brand. However, since the budget for product development has been reduced in the last few years, the improvement efforts have to be concentrated only on few products, that is, the high-selling products. The current portfolio of sport products is made of the following product categories:

♦ Outerwear
♦ t-shirts
♦ shirts
♦ shorts
♦ trousers
♦ footwear

In this respect, he wants you to:

Question 2: Perform an analysis of the product offering to identify best performing sport products.

In addition to competing against global brands, Olympic Sports Ltd. has also experienced strong competition from retailer’s private brands. A private brand, also called a private-label brand, is a brand owned by a company and offered by that company alongside and competing with brands from other businesses/suppliers. Many high-street retailers have developed their own private brands as a way to improve their profitability at the expenses of their suppliers’ business. Olympic brand faces pressure from private labels which in many cases offer equivalent sport products at less price and have more shelves space at the retailers’ stores. One option Olympic Sports Ltd.’s management is  considering to balance this pressure is to become a manufacturer for private brands. By suppling sport products to private brands, the company could improve production (asset utilisation) achieving economies of scale which translate in lower cost of production for Olympic branded products, therefore allowing to keep profitability even under price promotions.

Taking a cautious approach to dealing with private brands where distribution partners are also competitors, in June 2022 the company run a trial in Germany where two outsource contracts were signed with leading retailers to produce their private brand sportwear products lines. The revenue of Germany is the combination of the sales from the Olympic brand and the income from the production of sport products for private brands. The Sales Director is keen to understand if this new strategy could be expanded to other countries. So, he wants you to address the question:

Question 3: Did the two contracts signed in Germany to produce sport products for private brands have a positive impact on the sales performance of the subsidiary?

The responses to the issues detailed above should be included in a summary MS Word report that you save and submit as a PDF format file.
Because this is your first project within Olympic Sports Ltd., the Finance Director has given you additional details regarding the structure and content that it is expected to see in your report. This is set out in Section 3 – Report Structure.

A set of data is available (see module dataset spreadsheet file). Since the data comes directly from the country offices, quality issues are present which will require your attention!
You have five tasks to complete for your summative report. The first three are exactly the same as for your formative report and you should update your answers to these tasks based both on feedback on your formative submission together with your own further learning across the module.

Task 1: Introduction and project plan (20 marks)
Summarise what you are going to present in the report and justify your plan for delivering the research project to the Financial Director. Ensure you also make clear reference of a data analytics project framework as part of your plan. Finally, specifically explain how data analytics can add value and drive business performance improvement for Olympic Sports Ltd.’s subsidiaries.

♦ State the purpose of report and describe the report structure and contents
♦ Present your overall project plan for delivering the project
♦ Ensure that your project plan explicitly refers to a data analytics project framework and explain how the selected framework can be used/applied to address the core three business questions assigned to you.
♦ Suggest a list of Key Performance Indicators (KPIs) for Olympic Sports Ltd.’s subsidiaries and explain how better data analytics enables improvements against these KPIs.

Task 2: Data preparation quality issues and remedies (10 marks)
Discuss first the generic issues that data analysts encounter in collecting, integrating and cleaning data. Second, discuss the specific quality issues with the project data that the Finance department has provided and how you propose to address those issues.

♦ List and explain generic data problems and how to identify them. What are the different options for resolving these generic issues?
♦ List all data problems you have identified in the Olympic Sports Ltd. dataset. Explain how you identified the problems (give examples of the issues) and how you propose to address/solve them.

Task 3: Data analysis and commentary (20 marks)
Using tables, set out and explain the results of your numeric data analysis, including summary of exploratory data and supporting commentary. Explain how your results provide an understanding of Olympic Sports Ltd.’s subsidiaries performance. This should include three tables setting out:
(Table A) Data and trends in sales volume and value by month, by year and across the 3 years period,
(Table B) Benchmark comparisons of sport products categories performance covering sales volume and value by quarter, by year and across the 3 years period, and
(Table C) Benchmark comparisons of sales volume and value between subsidiaries by quarter, by year and across the 3 years period.

Include summary exploratory data calculations for total sales value and volume. The analysis could include for example top and bottom performing sport product categories, ranges, averages, standard deviations; top and bottom performing time-periods, etc.
♦ Ensure your tables are professionally presented: headings, units, data formats. Highlight and annotate key data elements
♦ For each table include firstly an explanation of the table and its contents and then a bullet- point list of what you can see or infer from the analysis of the data.

Task 4: Data visualisation and commentary (20 marks)
Using data charting/graphics, develop visual presentations of the data together with bullet-points setting out the key findings and inferences from your analysis of the charts/plots. This should include three charts presenting:
(Chart A) Comparison of sales value trends across subsidiaries over time
(Chart B) Sport product categories performance comparisons between subsidiaries, and
(Chart C) Impact of the two contracts signed in Germany to produce sport products for private brands, and in comparison with the other two subsidiaries.

♦ Ensure you provide well-presented and labelled charts
♦ Use a combination of visualisation plots and techniques such as bar charts, stacked bar charts, trend charts, pie charts and tree map charts
♦ For each chart include firstly an explanation of the chart and its contents and then a bullet- point list of what you can see or infer from the data.

Task 5: Conclusions and recommendations (20 marks)
Based on your analysis and findings in Tasks 3 and 4 set-out your conclusions and recommendations. Ensure you address the three issues raised by the top management.

♦ What conclusions can be inferred regarding Olympic Sports Ltd.’s subsidiaries sales performance and operations? Remember to include the answers to the three issues/questions raised by Olympic Sports Ltd. top management.
♦ What are your business recommendations to Olympic Sports Ltd.’s CEO and top management?
♦ Include any suggestions related to data analytics and its better use within the organisation.
♦ Note that it is also acceptable to add to your data analytics recommendations, possible actions that Olympic Sports Ltd. might take, based not only on your findings but also on your wider knowledge of business and sport apparel market sector.

The quoted price covers up to 2500 words. For custom requirements Live Chat or Whatsapp Click Here


Email: care@academiasupport.co.uk

100% Plagiarism Free & Custom Written, Tailored to your instructions