Assignment - Business Decision Making

Task 1

A manufacturing company employing 12,500 has decided to invest in recreational and leisure facilities for its employees. In order to provide the appropriate facilities it wishes to consult the employees on what facilities should be provided.

(a) Construct a questionnaire which gathers information on what recreational and leisure activities employees presently engage in and what other facilities would they wish to have available.

(b) Show clearly how you would sample the employees, distribute and collect the questionnaire.

(c) What secondary information sources would be useful in comparing the results of the internal survey?

Task 2

A company fleet car manager has gathered the following data about the weekly mileage of 120 salespersons in one week.

(b) Using a spreadsheet produce a histogram of the above data.

(c) Construct a grouped frequency curve and show the interquartile range.

(d) What does the interquartile range tell you about the use of company car.

(e) How does the interquartile range relate to percentiles?

Task 3

(a) In your role within the organization you receive and disseminate data/information. Produce a short business report (1,000 – 1,200 words) showing how you receive this data/information and how you integrate into the organisation’s management information system (MIS), manual or automated. Use charts, diagrams and narrative to show how and what data is captured, how it is transformed into information, stored and retrieved and how it is used for decision making.

(b) Produce a short set of presentation slides, using PowerPoint or similar software package, summarising your business report, which could be used as an aide memoire to a verbal presentation of the business report.

If you use any information printed off the system e.g. screen captures, ensure it is not commercially sensitive.

(c) The following data shows the number of vehicles per population and the number of road deaths per population.

(ii) Either calculate the correlation coefficient manually or produce it on the scatter diagram. Comment whether there is a link between
road deaths and the number of vehicles on the road. Would you expect this to be true? Provide reasons for your answer.

(iii) Create a trend line on the diagram and show what a country with 25 vehicles per 100 population might expect in the number of road
deaths per 100,000 population.

Task 4

After a number of years in operation the recreation and leisure centre constructed in Task 1 requires extension and the management committee have decided an extension is needed to provide extra facilities and to cope with increasing demand for existing facilities. A project plan has been produced and is shown below.

(b) Determine the critical path.

(c) If approved the project is forecast to cost £500,000. Expected cash flows generated from the new facilities are given below.

(i) Payback

(ii) Discounted payback