Business Decision Making Report: Surrey School Expansion Project

This report analyzes the business decision-making process for Excellent School Education Plc's expansion into Surrey. It begins with a plan for collecting primary and secondary data, including survey methodologies and sampling methods, and designs a questionnaire for parents. The report then presents the collected data in various forms, including frequency distributions, descriptive statistics (mean, median, mode, standard deviation), bar charts, pie charts, and scatter diagrams. It calculates average marks, measures of dispersion, and a line of best fit. The report also explores investment appraisal methods, project planning (Gantt and network diagrams), and calculates Net Present Value (NPV) and Internal Rate of Return (IRR) to assess the project's financial viability. The conclusion summarizes the key findings and recommendations for the proposed expansion.

BUSINESS
DECISION MAKING

Table of Contents
INTRODUCTION...........................................................................................................................1
SECTION 1......................................................................................................................................1
1.1 Creation of plan to collect primary and secondary data........................................................1
1.2 Strength and Weakness of the survey methodology as well as Sampling methods...............1
1.3 design of data to collect the data from parents .....................................................................4
SECTION 2 .....................................................................................................................................5
2.1 Present the data in a more comprehensible form...................................................................5
2.2 & 2.3 Average marks & Measures of Dispersion .................................................................6
2.4 Prepare a report interpreting and explaining..........................................................................6
SECTION 3......................................................................................................................................7
3.1 Presentation of data through bar chart and pie chart..............................................................7
3.2 Presentation of data through scatter diagram.........................................................................9
3.3 Calculation of average weight of children and line of best fit.............................................10
Section 4.........................................................................................................................................11
4.1 Methods of Investment appraisal with their respective advantages & disadvantages.........11
4.2 Project plan for the given scenario.......................................................................................12
4.3 Net present value (NPV) & internal rate of return (IRR) of the proposed project .............14
CONCLUSION..............................................................................................................................15
REFERENCES..............................................................................................................................16

Table of Figures
Figure 1Pie Chart.............................................................................................................................8
Figure 2Scatter diagram...................................................................................................................9
Figure 3Line diagram.....................................................................................................................11
Figure 4: Gantt chart......................................................................................................................13
Figure 5: Network diagram ...........................................................................................................14

Index of tables
Table 1: Frequency distribution of Marks.......................................................................................5
Table 2: Descriptive statistics..........................................................................................................6
Table 3: Number of Houses.............................................................................................................7
Table 4Number of bedrooms...........................................................................................................8
Table 5Age and weight of children..................................................................................................9
Table 6: List of activities...............................................................................................................12
Table 7: Initial investment & cost of capital..................................................................................14
Table 8: Net cash flows (Amount in £’s).......................................................................................14
Table 9: Internal rate of return ......................................................................................................14
Table 10: Net present value (Amount in £’s).................................................................................15

INTRODUCTION
In order to expand the business operations in the new location as well as enhancing the
operational performances of the business there is need to make the adequate decision making
which in turn helps the organisation in following the path which gives the fruitful returns as well
as make the adequate changes in the operational functions of the firm. However, in context with
launching the business at new location there is need to make the survey or research over such
place as well as analyse the requirements of citizens who belongs to such locality. Hence, in the
present assessment there will be analysis for Excellent school education Plc which are currently
working in the North London as well as facilitating the educational services to Affluent
background students. Hence, the school is planning to make operations in new location at Surrey.
The report contains various measurements and the surveys over individuals ate such locations
such as Questionnaire and calculations based on data sets.
SECTION 1
1.1 Creation of plan to collect primary and secondary data
Primary data: Primary data is when first hand data is collected through survey. It is the
original data and hence is collected to serve a special purpose (Pettigrew, 2014). In this case,
data is collected for the purpose of making assessment that whether opening a new branch of
school in Surrey will prove to be beneficial for the development of school or not. Hence, data
will be collected through parents of children to assess that what requirements do they need in a
new school that is not owned by the schools currently present in that area.
Secondary data: It is the data that has already been collected by someone and can be
used by the researcher as a base to conduct further research on it. Th data can be census,
information that has been collected by government departments, record of the organization, etc.
In the given scenario, collection of secondary research will be required by the researcher
(García-Peñalvo and Conde, 2014). The data regarding number of school presently functioning
in Surrey. Further, basic amenities provided by these schools and number of school going
children can be assessed through the secondary data of research (DuToit Steyn and Stumpf,
2012).
1.2 Strength and Weakness of the survey methodology as well as Sampling methods
A) Survey methodology:
1

In consideration with making the adequate surveys at various locations the Excellent
school education plc need to analyse the various survey methods in which they could become to
have the adequate data which in turn helps the business in making the adequate decision making
(Sekaran and Bougie, 2016). However, the below listed table will help school in analysing the
strength and weaknesses of various survey methodology.
Survey methods Strength Weaknesses
Questionnaires  It helps in asking the
individual to present their
views and thoughts related
with the business expansion
as well as promoting the
brand (Drucker, 2017).
 It helps in making surveys
over market, location or
individual which in turn
beneficial in gaining the
ideas or fetching such
informations relevant
 It will be hard or
complex in making
the adequate
decisions.
 There will be
complexity in making
the appropriate
budgets (Johnston,
2017).
Interviews  Questions were prepared by
the professionals of school
and that will be presented to
respondents with direct
interaction.
 Obstacles in making
contact to the target
respondents.
 Long process and took
too much managerial
time.
Online  It will be easy for the
professional in analysing
various blogs and articles
produces by analysts
(Jousilahti and et.al., 2016).
 High chances of
having irrelevant data
from unauthenticated
sources.
Door-to-door  Indirectly promoted the  It will be time
2

business in market as well
as build up the good
relationship with such
respondents.
consuming and
expensive.
B) Sampling methods:
These techniques help in identifying the requirements of the individual in such location
with the help of statistical data. Hence, such analysis will be beneficial for Excellent school
Education Plc in making the adequate decisions as well as having the authenticated results
(Scalzo, 2017). There are Four types of sampling methods which have the strength and weakness
as according to below listed table:
Sampling Strength Weaknesses
Stratified  Segment the large
population in the small
groups as per their
lactation and residency.
 Time consuming as
well as very complex
method to analyse the
requirements of the
individuals.
Simple Random  Data were gathered
from various sources
and then randomly
selected and then the
analysis were made
(3.5 Simple Random
Sampling and Other
Sampling Methods,
2017).
 The relevant or
adequate informations
will be left and not
specific sources were
selected.
Cluster  Implicated same as the
stratified sampling
techniques but are
 It will be more
complex than the
stratified technique
3

slightly different from
such techniques.
(Clarke and Cossette,
2016).
Systematic  Based on the computer
devices where
randomly respondents
were selected and
present the data.
 Based on the
redundancy and
accuracy of the
devices.
1.3 design of data to collect the data from parents
The data of the questionnaire will be collected from parents in order to make assessment that
whether they are satisfied with the conditions of present school or not. Further, what all facilities
do they expect that the school must own.
Questionnaire
Name: ______
Class in which child is studying: _______
Question 1: Are you satisfied with the services being delivered in the present school:
 Yes
 No
Question 2: What are the basic amenities that you see before admitting a child into a ew school?
 Infrastructure
 Knowledge brochure
 Quality of faculty
 Others
Question 3: Do you think location is an important aspect for schools?
 Yes
 No
Question 4: Do you want to change your child’s school to another one?
 Yes
 No
 May be
4

Question 5: How is the administration of the present school?
 Good
 Bad
 Requires improvement
Question 6: Are you satisfied with the qualification of current faculty in the school?
 Yes
 No
 Sometimes
Question 7: Do you think IT lab is important in the school?
 Yes
 No
Question 8: Do you think playing time is also important with studies?
 Yes
 No
 Sometimes
SECTION 2
2.1 Present the data in a more comprehensible form
Marks achieved by distinct set of students in one of the subjects in LBBA, a business
school is presented underneath with frequency distribution.
Table 1: Frequency distribution of Marks
Marks Count of No. of students
20-24 2
25-29 1
30-34 5
35-39 6
40-44 9
45-49 10
50-54 2
55-59 7
60-64 3
65-69 2
70-75 3
Grand Total 50
5

2.2 & 2.3 Average marks & Measures of Dispersion
The average marks indicated through mean, median & mode; and measures of dispersion
such as: standard deviation & sample variance is calculated through descriptive statistics. The
same is presented underneath in a tabular form (Santoso, Bahaweres and Alaydrus, 2016).
Table 2: Descriptive statistics
Marks
Mean 46.74
Standard Error 1.813286564
Median 45
Mode 48
Standard Deviation 12.82187226
Sample Variance 164.4004082
Kurtosis -0.293800677
Skewness 0.240238785
Range 55
Minimum 20
Maximum 75
Sum 2337
Count 50
2.4 Prepare a report interpreting and explaining
As per the descriptive table presented above; it is seen that the average marks obtained by
students into the given subject is 46.74 i.e. the mean value. Mean value helps in estimating
average for the given set of facts. Further, median determines middle value & mode gives an idea
of the most occurring value. Mean is considered to be the most reliable estimation for
determining average value. Moreover, standard deviation is estimated to be 12.82; which
indicates the chances of deviating average value. It is probable that students’ marks would vary
within in range of +/- 12.82. The students’ performance in this subject is mediocre in nature
since average value is 46.74. It is assumed that students have earned marks from maximum of
100. Further, the students’ performance can be compared between two or more subjects by
comparing the average value. Since, it is the measure of central tendency that provides an ideal
picture of all the data that is distributed among group of students. Also, the value of standard
deviation can be adjusted while making a comparison of students’ performance in two subjects.
It can be said that the measure of central tendencies provide a single value that shows
6

distribution of all the numerical information. Further, deviation helps in identifying the degree of
change that is expected to happen in next evidence.
SECTION 3
3.1 Presentation of data through bar chart and pie chart
Table 3: Number of Houses
Number of Houses
Green Street Church lane Eton Avenue
Number of Bedrooms
1 8 6 4
2 28 18 20
3 37 24 32
4 17 9 12
5 10 3 12
100 60 80
7

Figure 1: Bar Chart
Bar chart is a chart that helps in presenting categorical data with the rectangular bars in
the chart. The proportionality of the heights depends upon values being represented (Grbich,
2012). From the above graph, it can be represented that how many houses are present in Green
street, church lane and Eton Avenue with 1, 2, 3 and so on bedrooms. The data has been
presented in well defined manner and a reader can very well distinguish the data through the
graph.
Table 4Number of bedrooms
Number of Bedrooms Number of houses
1 19
2 68
3 96
4 42
5 30
Figure 1Pie Chart
8