Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with this assignment. 2.3. Its-search objectives and tasks The Corporate Strategy Manager, who is leading me 3-Year Strategic Plan project, is interested
Please help me with this assignment.
2.3. Its-search objectives and tasks The Corporate Strategy Manager, who is leading me 3-Year Strategic Plan project, is interested in understanding the options available for a local expansion strategy, including increase the size of the shops. For this purpose, he wants you to: Issue 1: Perform a sales value and volume arulysls ofthe three coffee shopsto identify the best shop to Invest In expanding its floor area. As part of the analysis, the Procurement Manager wants to improve the profitability by reducing the total cost of ingredients used to produce le menu for the shops. The current menu is made of the following product groups: I: Cakes, II Coffee, In Cold drinks, II Hot drinlts, '- Pastry and II Sandwiches. In order to reduce me cost, the Procurement Manager wa me to simplify the menu by removing like products with me worst sales performance. Therefore, he wants you to: Issue 1: Perform an analysis of the product offeri ngto identify those products with the worst sales performance which are the candidates to he removed from the shops" menu. CUTS wanted to explore whether the option of home delivery adds value to its business. In April 2022, the company decided to partner with Deliveroo, a food delivery company, to start a trial project in i1: Blackpool's shop, so the company could talte advantage of the "home-working" trend originated as result of the {20le pandemic affected the UK. Now, We Sales Director is keen to understand if this new delivery option could be expanded to other shops in the chain. So, he wants you to address the question: lssue 3: Did the home delivery service offered in thlrpoof hove opositive impact on the soles perform-lance of the shop? Task 1: Introduction and project plan :10 marks] Summarise what you are going to present in the report andjustify your plan for delivering the research project to the corporate Strategy Manager. Ensure you also clearly reference a data analytics frameworlr as part of your plan. Finally, specifically explain ho'IlIIlI data analytics can add .value and drive improved business performance for 6013's coffee shops. Guidelines: In State the purpose of report and de scribe the report structure and contents In Present your overall project plan for delivering the project I: Ensure that your project plan explicitly refers to a data analytics framework and explain how the selected framework can he used to addresses the core business questions assigned to you. I: Present CDTS's coffee shops Key Performance Indicators {KPlsj and hDW improved analytics enah Ies improvements again st these KPls. Task 2: Data preparation quality Issues and remedies :10 marks: Discuss Jfirst the generic issues that data analysts encounter in collecting, integrating and cleaning data. Second. discuss the specific issues with the project data that the Corporate Strategy team has provided to you and how you propose to address those issues. Guidelines: In List and explain generic data problems and how to identify them. 1ll'llhat are the different options for resolving these generic issues? II List all the data problems you have identified with the CUTS data set. Explain how you identied the problems and how you propose to address them. Task 3: Data a na lysis and commentary IID marks-I Using tahles, set out and explain the results of your numeric data analysis, including summary of exploratory data and supporting commentary. Explain howl:I your resulls inform understanding of 5313's shops performance. This should include three tahles setting out: {Table A] Sales volume and value lay month, by year and across the 3 years period, [Table Ejl Benchmark comparisons of product groups performance covering sales volume and value lay guarter, by year and across the 3 years period, andStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started