Kitchen Design Limited: Sales and Revenue Analysis 2012-2015 Report

This report presents an analysis of Kitchen Design Limited's sales performance across four products—Victorian, Budget, Wetroom, and Sauna—from the financial years 2012 to 2015. The analysis utilizes primary and secondary data, displayed and interpreted through various graphical tools including pie charts, line graphs, bar graphs, and scatter graphs, along with trend lines. The Budget product consistently generates the highest sales and revenue, peaking in 2015. The Victorian product shows a steady increase in sales, while Wetroom and Sauna products exhibit declining trends, with Sauna experiencing the most significant decrease. The report concludes that the Budget and Minimalist products are most beneficial for the company, recommending that Kitchen Design Limited focus on strategies to enhance the efficiency of the Budget product and increase revenue. References to relevant academic literature are also included.

BUSINESS DECISION
MAKING
TASK 3.3

INTRODUCTION
 The present report is based on Kitchen Design Limited
company which going to do different four products and there
sales from financial year 2012 to 2015.
 In order to carry out analysis the company uses primary and
secondary data as well.
 The sales data are displayed and analysed with help of
graphical tools.

Data for Analysis
Year Product 2012 2013 2014 2015
Victorian £4M £4.5M £5M £5.3M
Budget £6M £6.3M £6.9M £7M
Wetroom £2.5M £2.3M £2.2M £2M
Sauna £3M £2.75M £2.5M £2M

TASK 3.1
Pie chart: Product Victorian, Budget, Wetroom and
Sauna
4
4.5
5
5.3
Victorian
2012
2013
2014
2015
6
6.3
6.9
7
Budget
6
6.3
6.9
7
Wetroom
2.5
2.3
2.2
2
Sauna

LINE GRAPH
Product Victorian and Budget
2012 2013 2014 2015
0
1
2
3
4
5
6
4
4.5
5 5.3
2012 2013 2014 2015
5.4
5.6
5.8
6
6.2
6.4
6.6
6.8
7
7.2
6
6.3
6.9
7

BAR GRAPH
Product Victorian and Budget
2012
2013
2014
2015
0 1 2 3 4 5 6
4
4.5
5
5.3
2012
2013
2014
2015
5.4 5.6 5.8 6 6.2 6.4 6.6 6.8 7 7.2
6
6.3
6.9
7

Product Wetroom and Sauna
2012
2013
2014
2015
0 0.5 1 1.5 2 2.5 3
2.5
2.3
2.2
2
2012
2013
2014
2015
0 0.5 1 1.5 2 2.5 3 3.5
3
2.75
2.5
2

INTERPRETATION
 Above mentioned all the graphs and charts such as line, bar
and pie shows sales and revenue of four products from the
financial year 2012 to 2015 which the Kitchen Design
limited wants to research.
 It can be analysed from the above graphs that second product
that is Budget able to generate the highest sales and revenue
in comparison to another three products.
 The higher revenue is in the FY year 2015 which is
generated by Budget that is worth of £7M.

TASK 3.2 SCATTER GRAPH
Product Victorian and Budget
2012 2013 2014 2015
0
1
2
3
4
5
6
4
4.5
5 5.3
2012 2013 2014 2015
5.4
5.6
5.8
6
6.2
6.4
6.6
6.8
7
7.2
6
6.3
6.9
7

Product Wetroom and Sauna
2012 2013 2014 2015
0
0.5
1
1.5
2
2.5
3
2.5
2.3 2.2
2
2012 2013 2014 2015
0
0.5
1
1.5
2
2.5
3
3.5
3
2.75
2.5
2

TREND LINE
Product Victorian and Budget
2012 2013 2014 2015
0
1
2
3
4
5
6
4
4.5
5 5.3
f(x) = 0.44x + 3.6
2012 2013 2014 2015
5.4
5.6
5.8
6
6.2
6.4
6.6
6.8
7
7.2
6
6.3
6.9
7f(x) = 0.36x + 5.65

Product Wetroom and Sauna
2012 2013 2014 2015
0
0.5
1
1.5
2
2.5
3
2.5
2.3 2.2
2
f(x) = -0.16x + 2.65
2012 2013 2014 2015
0
0.5
1
1.5
2
2.5
3
3.5
3
2.75
2.5
2
f(x) = -0.325x + 3.375

INTERPRETATION
 On the basis of above prepared trend line it can be
interpreted that product Victorian and Budget both have
increasing trend from the year 2012 to 2015.
 The difference is that product Budget has high growth rate
and sales increases with higher rate in comparison to product
Victorian.
 On the other side, Wetroom and Sauna products have
decreasing trend which are not beneficial for the firm. In the
Sauna product decreasing trend is at the higher rate compare
to another product that is Wetroom.

CONTD....
Criteria Product name Sales of year
2012 Sales of year
2015
Higher total sales Budget £6 £7
Lower total sales Wetroom £2.5 £2
Increasing trend Budget £6 £7
Decreasing trend Sauna £3 £2

Conclusion and Recommendations
 It can be concluded from the report that, product Minimalist
as well as Budget both are better for the company in order to
generate sales and revenue.
 In addition to this, it can be suggested to the management of
Kitchen Design Limited that it needs to make better
strategies for make more efficient to product Country and
increase revenue of product Minimalist.
 Further, product Budget is the most beneficial on the basis of
research hence management should purchase respective
product.

REFERENCES
Padilla-Garrido, N. and et.al., 2014. Multicriteria decision
making in health care using the analytic hierarchy process and
microsoft excel. Medical Decision Making. 34(7). pp.931-
935.
Teirlinck, P. and Spithoven, A., 2013. Formal R&D management
and strategic decision making in small firms in knowledge‐
intensive business services. R&D Management. 43(1). pp.37-
51.
Anderson, D. R. and et.al., 2016. Statistics for business &
economics. Nelson Education.