BUSINESS DECISION MAKING TABLE OF CONTENTS

BUSINESS DECISION
MAKING

TABLE OF CONTENTS
INTRODUCTION................................................................................................................................3
TASK 1.................................................................................................................................................3
Background..................................................................................................................................3
Rationale......................................................................................................................................3
Objectives of the research............................................................................................................3
Methodology................................................................................................................................4
Data Analysis...............................................................................................................................4
Time Frame..................................................................................................................................4
Budget section.............................................................................................................................5
Questionnaire...............................................................................................................................5
TASK 2.................................................................................................................................................7
2.1 & 2.2 Mean, Mode and Median.............................................................................................7
2.3 Range and Standard Deviation..............................................................................................8
2.4 25th Percentile (Lower 25th Percentile (Lower Quartile) and 75th Percentile (Upper
Quartile) and use of Percentile....................................................................................................9
TASK 3...............................................................................................................................................11
3.1 & 4.1 Produce line graph.....................................................................................................11
Scatter Plot on Advertising costs and sales...............................................................................13
3.2 & 4.1 Trend Lines................................................................................................................14
3.4 Formal Business Report.......................................................................................................14
TASK 4...............................................................................................................................................16
4.2 Prepare a network diagram for activities using Microsoft Project......................................16
Calculate Project Duration.........................................................................................................16
Clearly mark the Critical Path...................................................................................................16
Prepare a Gantt chart and state the benefits of using it as a Project Management Tool............17
TASK 4 B...........................................................................................................................................17
4.3 Calculation of Net present value and Internal rate of return...............................................17
Recommendations......................................................................................................................20
CONCLUSION..................................................................................................................................20
REFERENCES...................................................................................................................................21

INTRODUCTION
In the current business environment, decision making play crucial role in establishing the
operations of business as well as ensuring long term sustainability. In general, business decision
making refers to the process of selecting best among the alternatives (Hedgebeth, 2007). In the
present report, researcher focuses on evaluating different scenarios and accordingly makes
decisions for the suitable results and outcomes. Further, it includes range of statistical tools and
techniques by the means of which different requirement will be satisfied. Along with this,
graphical presentation has been indulged to present the collected data in effective and efficient
manner. Lastly, with the help of investment appraisal techniques decision will be made regarding
selection of suitable and reliable investment proposals.
TASK 1
Background
According to the given case study, Government of UK is planning to start a Crossrail
Project with the aim of enhancing the local transport within London. The main purpose of this
project is provide travelling facilities to 1.5 million people so that it can generate key
employment, leisure and other business activities. Furthermore, it will enhance the journey times
across London to easing congestion and offering better and affordable connections (Badenhorst-
Weiss and et.al, 2008). Along with this, through the help of this project, Government of UK will
change the way of people travel around the capital.
Rationale
The main purpose of conducting this project is to enhance the level of travelling for the
local people and the visitors. Along with this, to minimize the road traffic so that level of
pollution can be managed and controlled. Furthermore, researcher focuses on evaluating the
benefits of Crossrail project for the local community. Therefore, researcher through the help of
this study will investigate different aspects about the project and provide detailed information to
the government officials.
Objectives of the research
The main objective of this study is to determine the benefits of Cross Rail project for the
local community of London. Along with this, to estimate budget and time frame for carrying out
the whole project. The three main objective of research are as follows.
 To identify the benefits that this project will give to general public.
3

 To identify whether this project will contribute to growth of economy of London.
 To identify that this whether this project will help in controlling congestion on railway
station.
Methodology
According to the present given scenario, researcher is focusing on using both primary and
secondary information to collect data regarding Crossrail project and accordingly build
understanding regarding benefits of the project to local community. Furthermore purposive
sampling technique has been selected because managers associated with the Crossrail project are
required to generate wide range of information. Sample size of will be 30 senior managers.
Firstly, through the means of qualitative techniques researcher will be able to enhance the
understanding regarding the perception of local people towards the project (Day, 2005). Along
with this, using quantitative techniques will assist in collecting numerical data for the benefits to
the people. In primary section, people of London will be provided questionnaire and accordingly
reliable and valuable information will be collected.
Data Analysis
In the present study, investigator will use thematic as well as statistical approaches to
analyse the collected information. However, thematic analysis will assist in evaluating the
subjective or qualitative information generated through the means of different sources (4
Decision Making Methods, 2011). On the other hand, statistical approach will assist in
interpreting the numerical information so that benefits of Crossrail projects for local community
of London can be identified effectively.
Time Frame
Activities/ duration in
week
2 4 6 8 10 12 14 16
Analysing the contextual
Defining realistic
objectives
Methodology
Collecting qualitative and
quantitative data
Data Analysis
4

Estimating budgets
Presenting whole project
Budget section
Following is the budget section for carrying out the research on Crossrail Project.
However, overall amount is estimated at £1200 which is further bifurcated in the following
segments:
Expenses Amount
Research collection from secondary
data
£300
Research collection from Primary data £500
Stationary costs £200
Fuel Cost £120
Miscellaneous expenditure £80
Total £1200
Questionnaire
In order to collect data, researcher focuses on using survey methodology in which
questionnaire will be distributed to local people of community:
Name:
Ques1: Gender
 Male
 Female
Ques2: Age:
 16-20 years
 21-25 years
 26-30 years
 31-35 years
 36-40 years
 41-45 years
 >46 years
Ques3: Are you aware about the “Crossrail” project of the government of UK?
5

 Yes
 No
Ques4: According to you what are the major benefits of the cited project of the
UK Government?
 Enhancing travel experience
 Improved connectivity
 New experience of travelling around the capital
 Easy Overcrowding
Ques5: Do you think, Crossrail project have increased the employment
opportunities?
 Yes
 No
Ques6: Please tick as appropriate, Crossrail project will ensure future economic
growth in the London?
 Strongly Agree
 Agree
 Neutral
 Disagree
 Strongly Disagree
Ques7: Are you interested in using the services offered by Crossrail Project?
 Yes
 No
Ques8: Do you believed that, Crossrail project will improve the rail transportation
and cut journey time across city?
 Yes
 No
6