Graphical Analysis for Sales and Divertissement Data

The presentation focuses on analyzing sales and divertissement data using graphical analysis. It includes line graphs for advertising and sales figures, pie and bar charts for net income generated by five branches, scatter plots for sales and advertising cost, and trend lines for forecasting sales figures. The findings reflect that the sales of the organization have increased year by year, and the company is managing income and expenses effectively. The presentation concludes with recommendations for investing in increasing future sales, expanding the business, and adopting different strategies for increasing sales revenue.

BUSINESS
DECISION
MAKING
Task 3

Introduction and Background
■ Organization wants to analyze its sales and divertissement data using
the graphical analysis.
■ It also focuses on the forecasting of the future trend of the company
by using different graphs and charts.
■ This analysis will help in future and expansion decision making of the
organization.

Graphical analysis : Line graph
for advertising and sales figure
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
Line graph for sales and advertising cost
Advertising Cost £'000s Sales £'000s

Pie and bar chart for net income generated
by five branches and scatter graph for
sales
240
180160
140
130
Net Income Generated by 5 Branches of the
company in 2015 in £000s
London Manchester Edinburgh Cardiff Liverpool

Cont…
London
Manchester
Edinburgh
Cardiff
Liverpool
0 50 100 150 200 250 300
240
180
160
140
130
Net Income Generated by 5 Branches of the
company in 2015 in £000s
Series1

Scatter plot for sales and
advertisement cost of the
organization
2000 2002 2004 2006 2008 2010 2012 2014 2016
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
Scatter plot on sales and advertising cost
Advertising Cost £'000s Sales £'000s

Trend line for forecasting sales
figure for years 2015 – 2017
2000 2002 2004 2006 2008 2010 2012 2014 2016
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
f(x) = 245.626373626374 x − 490653.428571429
R² = 0.978228060018697
Trend line for sales and advertising cost
Sales £'000s Linear (Sales £'000s)

Findings
■Findings of the analysis has reflected that sales of the
organization has increased year by year.
■High investment in advertisement and marketing of
the clots at different locations of the company.
■High sales helps in managing the cost of advertising
and marketing of the organization.
■Company is managing income and expenses in
effective manner.

Conclusion and
Recommendations
■ Conclusion of the findings has shown that sales performance of
the company is very strong.
■ Organization can invest its income in increasing the future sales
of the company.
■ Along with this, company should expand its business by
developing new branches at different locations.
■ But, at the time of expansion organization should focus on
reducing the marketing and advertising cost.
■ Organization should adopt different strategies for increasing the
sales revenue of the firm by generating more profitability in
future.

References
■ Akpolat, H. and Pitinanondha, T., 2009. A Framework for Systematic Management of Operational Risks. Asian
Journal on Quality. 10(2). pp.1 – 17.
■ Andersen, S. E., Dysvik, A. and Vaagaasar, L. A., 2009. Organizational rationality and project management.
International Journal of Managing Projects in Business. 2(4). pp.479 – 498.
■ Arnicans, G. 2013. Information Processing Tools and Environments. [report] Raina Blvd: University of Latvia,
pp. 1-2.
■ Banerjee, B., 2006. Cost Accounting: Theory and Practice. PHI Learning Pvt. Ltd.
■Beynon-Davies, P., 2009. Business Information Systems. Palgrave Macmillan.