Report for Duque Papetiers Gros 2017: Analysis and Recommendations

Report for Duque Papetiers Gros 2017
Report for Duque Papetiers Gros
1

Report for Duque Papetiers Gros 2017
Table of Contents
1. Introduction............................................................................................................................3
Analysis of Issues for Duque Papetiers Gros.............................................................................4
2.1 An Overview of the Wholesale Stationers Market in Germany..........................................4
2.2 Annual Spending on Writing / Drawing Materials per Capita.............................................5
2.3 Analysis of Duque’s last three financial years of sales data (2015-2017)...........................6
(a) Using an EXCEL spreadsheet, adjust the above table by appending a Total Sales (€) row.
Include a table printout or screenshot as an appendix to your report. You must also show in
your appendix, the formulae behind your columns....................................................................6
(b) Using an appropriate mixed pie chart, represent the 2016 and 2017 sales (€) by product
item.............................................................................................................................................6
(c) By representing Total Sales (€) and Year in an appropriate scatter diagram, find the
associated correlation coefficient and write down your resulting interpretation.......................6
(d) Using the same scatter diagram, forecast the total sales for 2018 and 2019, assuming
continuing sales trends...............................................................................................................7
2.4 Feasibility of Expanding to Germany & International Standards........................................8
2.5 Costs of a New Building....................................................................................................10
2.6 Mean Value of Orders........................................................................................................11
2.7 Customer Satisfaction........................................................................................................12
Conclusion................................................................................................................................14
Reference list............................................................................................................................15
Appendix..................................................................................................................................16
2

Report for Duque Papetiers Gros 2017
1. Introduction
Duque Papetiers Gros is a small family owned stationery business owned by Donald Duque.
Located in the northern part of France, the business does not sell its goods and services
directly to customers. It sells its goods and services to various local schools, small offices and
shops. The product portfolio of the business comprises of cartridges, general office supplies,
low cost printers, drawing material, office furniture, writing material, paper based supplies
and shredders. The owner of this business is not aware about how to conduct business data
analysis and the manner in which it impacts small businesses. However, in order to enhance
the process of decision-making, Donald Duque requires conducting big data analysis. The
report has been prepared for providing knowledge about the understanding of the annual
spending of Duque Papetiers Gros’ writing and drawing material in Europe based on per
capita spending as well as the identification of the business’s potential areas for expanding its
operations from France to Germany and its neighbouring areas.
3

Report for Duque Papetiers Gros 2017
Analysis of Issues for Duque Papetiers Gros
2.1 An Overview of the Wholesale Stationers Market in Germany
The overview of the wholesale market of stationery prevailing in Germany shows that this
sector is growing at a rapid pace in Germany. The market selling whole stationery within
Germany is growing and spreading at a higher rate than the market in different countries. One
of the wholesale stationery businesses operating in Germany is the Duque Papetiers Gros.
The analysis of Germany’s wholesale market dealing with stationery products also shows that
the industry generates about 14.0 billion Euros annually (Isokane et al., 2017). The demand
of stationery goods is also high in Germany relative to the demand in other neighbouring
nations. Financial analysts have also analyzed the per capita spending of a person in Germany
for stationery goods. About 184 Euros are spent by every citizen of the country for stationery
goods (Krapp and Pannowitsch, 2017). There is an approximate of 130 wholesale businesses
in the country that is involved in manufacturing, buying and selling of goods and services in
the nation. The analysis also shows that there are about 5200 companies and offices that buy
stationery goods on wholesale.
The wholesale market of stationery goods is contributing remarkably to the economy of the
country. The revenue margins of the sector are also improving from one year to another. For
example, the sales revenue from this sector has improved by about 0.3 billion between 2015
and 2016 (Muller et al., 2017). In addition, the overview also shows that the sale of stationery
goods has also spread at a rapid rate. For example, Alibaba is an online site in Germany that
sells stationery goods over the internet even at wholesale margins. Thus, from the evaluation
and overview of Germany’s wholesale stationery market, it can be analyzed that the
wholesale stationers market in the country is performing quite well and any entrepreneur
willing to start up ventures in the market can start operations without any second thought.
4