Business Decision Making: Sales Data Graphical Analysis Report

This report presents a graphical analysis of sales and advertising data to inform business decisions. It uses line graphs to illustrate advertising costs and sales figures over time, pie and bar charts to compare net income generated by different branches, and scatter plots to examine the relationship between sales and advertising costs. Trend lines are employed to forecast future sales figures for the years 2015-2017. The analysis reveals a consistent increase in sales, significant investment in advertising and marketing, and effective cost management. The conclusion emphasizes the company's strong sales performance and suggests reinvesting income to further increase sales, expanding business operations while controlling marketing and advertising costs, and adopting strategies to enhance future profitability. References to academic sources are also included to support the analysis and recommendations.

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.