Reference no: EM13941028

Scenario

A restaurant chain planned to open its second restaurant in London. To ensure this is a viable move, the shareholders are keen to understand the market. Therefore you are asked to carry out a planned data collection and data analysis to help the board of directors in understanding the customer preferences. Report on Data Collection and Analysis, In this report;

• Create a plan for primary and secondary data collection with presenting the survey methodology & sampling frame used
• Design a questionnaire to collect data and provide a justification for its design
• Collect data and summarise the collected data using representative values
• Analyse the collected data using measures of dispersion. You must be able to use the analysis to inform and support decision making.
• Carry out suitable calculations to draw useful and realistic conclusions and provide valid recommendations your calculations must include quartile, percentiles and the correlation coefficient. Explain how these calculations helped you to draw useful conclusions.
• To achieve M1, have effective judgements and approach in using  variety of sources for the collection of data and range of techniques to analyse data effectively
• To achieve D1, justify conclusions through synthesis of ideas and propose realistic improvements for the collection of data and range of techniques to analyse data effectively
• To achieve D2, properly manage activities in using  variety of sources for the collection of data and range of techniques to analyse data effectively

Prepare a Business Presentation and a formal Business Report to disseminate information effectivelywhich include;

• the findings which should be used to draw valid conclusions (You must use spreadsheet software for all calculations and incorporate graphs and charts to clearly effectively present the findings)
• trend lines in graphs to assist in forecasting for specified business information. For example, this may include people's eating behaviours overtime and preferences against seasonal changes.
• a plan for the project identifying the Critical Success Factors and the Critical path to implement a business process and the recommendations you are suggesting from your findings. For example, a business process to serve customers
• different financial tools such as discounted cash flow and IRR functions to evaluate the financial viability if the proposed recommendations
• To achieve M2, apply and justify learning methods/techniques, synthesise and process complex information to produce information in appropriate formats in decision making and in using  software-generated information
• To achieve M3, you need to use range of methods of presentation, have accurate technical language and appropriate communication toproduce information in appropriate formats in decision making and in using software-generated information.
• To achieve D3, incorporate your previous knowledge to produce information in appropriate formats in decision making and in using software-generated information.