Scenario :
Delicious Ltd (A2D Ltd) is a restaurant chain in South East London. They have 20 restaurants, 600 employees and specialise in both African and European dishes.
The economic recovery has encouraged more outside eating and the company has decided to open new outlets. They wish to know the size of the potential market in West London where they intend to open a new state of the art restaurant.
You have been selected as Consultant to the Board of Directors of A2D Ltd to advice on this market development plan. You are required to:
Task 1: Data Collection Techniques
Create a plan for A2D Ltd for the collection of primary and secondary data for the proposed market research (AC 1.1).
Present the survey methodology and sampling frame A2D Ltd will use for the research.Design an appropriate questionnaire using both open and closed ended questions A2D Ltd will use for data collection
To achieve M1, you need to demonstrate effective approach in selecting data sources and data collection methods for the proposed market research for A2D Ltd.
To achieve D2, demonstrate effective plan for managing and organizing the activities involved in the proposed market study and research.
Data Analysis.
A2D Ltd has provided you with the yearly total sales and advertising expenditure (£'000) in 20 of its South Eastern restaurants
Year Advertising expenditure (£'000) Food Sales (£'000)
2007 25 120
2008 28 150
2009 30 170
2010 26 190
2011 27 210
2012 25 230
2013 22 200
2.1 Create information to aid decision making for A2D Ltd by summarising data using the mean, mode and median
2.2 Analyse the results obtained above to draw valid business conclusions for A2D Ltd.
2.3 Analyse the data using measures of dispersion- the range, inter-quartile range and standard deviation to inform the stakeholders the current business scenario of
2.4 Explain how quartiles, percentiles and the correlation coefficient from the above data are used to draw business conclusions for A2D Ltd
To achieve D1, justify your business conclusions through synthesis of ideas that are creative and original.
Task 3: Data Presentation and Forecasting
You have been asked by the Board of A2D Ltd to forecast future sales and advertising expenditure for their next Annual Board Meeting.
3.1 Using Excel spreadsheet, produce your information on pie charts, bar graphs, line graphs, as appropriate and draw valid businessconclusions to aid the proposed market development plan of A2D Ltd
3.2 Produce scatter graphs and trend lines of the data above to forecast sales and expenditure for 2015
3.3 Prepare a business presentation using suitable software and techniques todisseminate information effectively
3.4 Compiling information from tasks 3.1 to 3.3, present your findings to the Board of A2D Ltd in a formal business report
To achieve M3, you need to use a range of methods of presentation with the use of technical language correctly.
Task 4: Software-generated information for decision making
Task 4.1: Management Information System
Explain how A2D Ltd manages inventory and customer orders using appropriate information processing tools.
Task 4.2: Project Management
Use the information below to construct a network diagram and determine the critical path.
Paula, the managing director, has taken on the responsibility for organising an annual conference for the local society of restaurant owners. Remembering the project management techniques she came across when studying for her professional qualification, Paula has decided that critical path analysis may be helpful in planning the conference.
As a start, Paula has drawn up a list below of the activities she must complete in preparation for the conference, she has identified the dependency between the different activities and the time she thinks each will take.
Activity Dependency Time (Days)
Determine Conference theme - A - 3
Research Alternative Venues - B - 6
Identify and book guest speakers - C A 4
Book Venues - D B 2
Print conference papers- E C, D 8
Print and send out invitations - F D 4
Confirm final arrangements with
venue and deliver documents - G E,F 2
Task 4.3 Financial Tools
Paula has also recognised the need for a new computer system to manage inventory and track customer orders. She carried out some research into two new systems and put together the financial information shown in table 3.
Computer system Capital cost(£'000) 2015 2016 2017 2018 2019 2020
System A 24,000 6,000 6,000 6,000 6,000 6,000 6,000
System B 37,000 8,000 8,000 9,000 9,000 6,000 6,000
Use financial tools PBP, ARR and NPV to decide which investment option is financially viable for the company (AC: 4.3).
To achieve M2, correctly apply project management and financial decision making tools and provide proper justification for your decisions.