Together with your friends you have decided to establish a small restaurant in Manchester; Create a plan for the collection of primary and secondary data that will be useful for the launch of your restaurant.

Business decision making
Paper, Order, or Assignment Requirements

Scenario:

Together with your friends you have decided to establish a small restaurant in Manchester because you believe that there is a big market for young people who want to dine out. You will need to find premises at a suitable location. You recognize that Manchester is a multicultural city and your restaurant will specialise in offering value for money meals using organic produce. Naturally before investing any money into the project, you have decided to collect data to find out if the restaurant will be successful or not. You are aware that the data collection must be done properly if any information that you extract from it is to be useful and reliable. Keeping this in mind, please answer the following questions:

Task 1

1.1 Create a plan for the collection of primary and secondary data that will be useful for the launch of your restaurant. Describe each of the stages that you will follow on your plan and justify the selection of methods of collecting data that you are going to use.

1.2 Explain, with justification, the sampling frame and survey methodology that will be most appropriate in your investigation. Which sampling techniques are most suited for this survey and why?

1.3 Design a questionnaire that you will use to collect primary data from UK customers using dichotomous, multiple choice and open ended questions.

This provides evidence for 1.1, 1.2, 1.3

Task 2:

The following are the sales and expenses figures for HMV for the past 18 years.

Year Sales Expenses £ Net Income £ Year Sales Expenses £ Net Income £
1995 15,000 20,000 2004 28,000 55,000
1996 20,000 25,000 2005 30,000 60,000
1997 24,000 30,000 2006 40,000 90,000
1998 20,000 40,000 2007 22,000 45,000
1999 18,000 35,000 2008 15,000 34,000
2000 25,000 50,000 2009 25,000 52,000
2001 20,000 45,000 2010 35,000 62,000
2002 30,000 65,000 2011 16,000 38,000
2003 24,000 45,000 2012 28,000 56,000

2.1 Use Excel software to calculate the mean, median and mode of the net income. You must copy and paste your spreadsheet onto the answer page.

2.2 Define mean, mode and median and explain the advantages and disadvantages of using each one of them. Analyse the results you calculated in 2.1 above and draw conclusions about the net income of HMV.

2.3 Use Excel to calculate the standard deviation of the net income of HMV. Explain how standard deviation is useful for HMV business purposes. Calculate the range about the mean within which approximately 95% of the net income values fall.

2.4 Use excel to calculate the correlation coefficient between sales expenses and net income.

Calculate the interquartile range and 80th percentile of the net income data.

Explain how HMV may use quartiles, percentiles and correlation coefficient to draw useful conclusions for the business.

This provides evidence for 2.1, 2.2, 2.3, 2.4

Task 3:

Scenario: The Managing Director of a company that packages olive oil imported from Italy to UK has hired you for the position of presentation and report writer. The managing director gives you the following types of data and asks you to make a report for the board of directors. Following is the different types of data sets the managing director has given you:

Television Advertising & Sales Figures from Year 1995 to 2010

Year Advertising £ Sales £ Year Advertising £ Sales £
1995 100 1200 2003 380 3200
1996 120 1400 2004 440 3750
1997 150 1500 2005 460 4460
1998 170 1800 2006 490 4820
1999 200 2200 2007 510 5000
2000 240 2300 2008 550 5670
2001 260 2400 2009 585 5900
2002 320 2780 2010 600 6300

3 (1) Produce a line graphs for advertising and sales figures from 1995 to 2010 and draw valid conclusions from the information derived.

3(ii) Produce pie charts and bar charts for the following net income generated by the five branches of the company and draw valid conclusions from the information derived.

Net Income Generated by the Five Branches of the Company in 2010

Branch Location

Net Income £

Birmingham Branch 2300
Coventry Branch 1400
Wolverhampton Branch 1000
Solihull Branch 1600
Stoke Branch 900

3 (iii) Produce histograms for hourly rate of different office employees of the company in 2012 using bin ranges 0-10,11-20,21-30,31-40,41-50,51-60,61-70 and 71-80 and draw valid conclusions from the information derived.

Hourly Rate of Different Rate of Office Employees

£ £ £ £

32 43 27 25

43 54 30 27

25 18 52 29

43 24 71 36

43 45 75 43

27 68 31 54

29 33 73 67

3.2 Produce a scatter graph of Sales figures using spread sheets and draw conclusions.

Create trend lines in the spread sheet graphs to assist in forecasting the business sales.

Obtain the linear equation of the line fitted in the scatter graph.

Explain the terms of the equation and use the linear equation to forecast sales for 24th month and 30thth month.

Use the Excel forecast- function to predict sales for the period Jan 2011 to June 2011.

3.3 Prepare a business presentation using suitable software to disseminate the information obtained in 3.1 and 3.2 effectively to the stakeholders in United Kingdom.

3.4 Produce a formal business report of the Olive Oil company discussing your findings.

This provides evidence for 3.1, 3.2, 3.3, 3.4

Task 4:

4.1 Explain the use of Management Information Systems in the operational, strategic and tactical functioning of an organisation. Give examples of software used at each level.

4.2 You are working with a team involved in completing a project to build a restaurant. The data for the construction project is as follows:

Activity Immediate
Predecessor

Time
(Days)

Foundation – 4
Framing Foundation 10
Plumbing Framing 9
Electrical Framing 6
Wall Board Plumbing/
Electrical

8
Siding Framing 16
Paint Interior Wall Board 5
Paint Exterior Siding 9
Fixtures Int Paint/
Ext Paint

6

4.2 Define project management and determine the critical path using network diagram. Explain the terms Early Start, Late Start, Early Finish, Late Finish, Slack, Dummy.

4.3 This project completed at a cost of £420,000.00. Your team has been given the following figures for cash inflows for the project and the company’s weighted average cost of capital is 12%.

Report on the financial viability of this project using NPV and IRR.

Year Cash inflows (£million)
2015 £55,000
2016 £60,000
2017 £72,000
2018 £86,000
2019 £92,000
2020 £120,000
2021 £150,000

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"