Assignment title - BUSINESS DECISION

LO1 Be able to use avariety of sources forthe collection of data,both primary and secondary   

1.1 create a plan for the collection of primary and secondary data for a given business problem

1.2 present the survey methodology and sampling frame used

1.3 design a questionnaire for a given business problem

LO2 Understand a range of techniques to analyse data effectively forbusiness purposes   

2.1 create information for decision making by summarising data using representative values

2.2 analyse the results to draw valid conclusions in a business context

2.3 analyse data using measures of dispersion to inform a given business scenario

2.4 explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context

LO3 Be able to produce information inappropriate formats for decision making in an organisational context   

3.1 produce graphs using spreadsheets and draw valid conclusions based on the information derived

3.2 create trend lines in spreadsheet graphs to assist in forecasting for specified business information

3.3 prepare a business presentation using suitable software and techniques to disseminate information effectively

3.4 produce a formal business report

LO4 Be able to usesoftware-generated information to make decisions in anorganisation   

4.1 use appropriate information processing tools

4.2 prepare a project plan for an activity and determine the critical path

4.3 Use financial tools for decision making.

Purpose of this assignment

For this assignment you need to produce a report. You are required to use variety of sources for the collection of data, have range of techniques to analyze the data, produce information in appropriate formats for decision making and use appropriate software-generated information.

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.

Task 1

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

Task 2

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 pathto 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 evaluatethe 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 to produce 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.