SEM I Business Decision Making 3.1: Graphical Presentation Report

This report analyzes the business decision-making process of Blackfriars Restaurant, focusing on customer behavior and sales trends. The report uses graphical presentations to illustrate customer visit frequency, factors influencing restaurant choice (quality, price, and services), and customer satisfaction levels. Trend line charts are used to analyze sales data over time, showing a continuous increase in sales, indicating potential success for a second restaurant branch. The analysis includes interpretations of the data and suggests strategies to increase demand, such as attractive discount offers and quality services. The report also mentions the use of Excel functions like RAND and NORMDIST for business growth analysis and provides a list of relevant references.

SEM I-BUSINESS DECISION
MAKING

3.1 Graphical presentation
How frequently do you visit restaurants?
 Once in month-20
 2-3 times-10
 4-5 times-15
 More than 5 times-5

Once in month 2-3 times 4-5 times More than 5 times
0
5
10
15
20
25
20
10
15
5
Column C

Interpretation:
From the graphical presentation it can be said that 20 respondents visit
restaurant once in a month. 10 answerer visit 2-3 times in a month whereas 15
people said that they visit restaurants 4 to 5 times in a month. 5 respondents
answered that they go more than 5 times in a restaurant. So it can be
interpreted that maximum people go once in a month so Blackfriars Restaurant
needs to increase demand so that people frequently visit the place. This can
only possible by giving them attractive discount offers and quality services.

About which factor do you think first before going to any restaurant?
Quality -15
Price-15
Services--10
Other-10

15
15
10
10
Quality
Price
Services-
Other

Interpretation:
From the above graph it can be said that quality and price are two major factors that influence the
mind of guests. 15 respondents have answered that before coming to any restaurant they look
for prices and quality of food of the place. 10 respondent have said that services are
components which they look first. So it can be interpreted that people get influenced by prices
and quality. If Blackfriars Restaurant keeps lower price of its dishes then more public will
take interest and quality services will help the cited firm in making them loyal towards the
brand. By this way second restaurant will start earning profit soon (What is IRR and How
Does it Work?, 2017).

What rank would you give to services of Blackfriars Restaurant ?
Good-25
Average-5
Very good-8
Excellent-12

Row 1 Row 2 Row 3 Row 4
0
2
4
6
8
10
12
Column 1
Column 3
Good
Average
Very good
Excellent
0 5 10 15 20 25 30
25
5
8
12
Column D

Interpretation:
From the above presentation it can be said that 25 respondents have ranked
the Blackfriars Restaurant good. 12 respondents have ranked it excellent.
8 answerer have said that it is very good but 5 have answered that it is
average. Thus, it can be interpreted that maximum customers of the
restaurant are satisfied with the services (Barquet and et.al, 2013). If cited
firm run its second branch in a same manner then there is high possibility
to get high profit.

3.2 Trend line chart
1 2 3 4 5 6
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
50000
11000
17000
25000
30000
37000
45000
Years
Sales

Interpretation
Trends show that sales of Blackfriars Restaurant is continuously increasing.
From the trend line it can be assumed that in future also cited firm can get
high profit so there is high possibility of success of the second restaurant of
the Blackfriars Restaurant. With the help of excel and functions such as
RAND and NORMDIST can be beneficial for analysing the business
growth of the organization (DesJardins and McCall, 2014).