Analyzing Information and Data for Problem Solving: A Case Study of Duque Papetiers Gros

Analyzing Information and Data for
Problem Solving
1

Table of Contents
1.0 Introduction...........................................................................................................................3
2 Analysis of Issues for Duque Papetiers Gros...............................................................................4
2.0 An Overview of the Wholesale Stationers Market in Germany...........................................4
2.1 Annual Spending on Writing/Drawing Materials per Capita....................................................4
2.2 Analysis of Duque’s last three financial years of sales data (2015-2017).................................6
2.3 Feasibility of Expanding to Germany & International Standards.............................................8
2.4 Costs of a New Building............................................................................................................9
2.5 Mean Value of Orders.............................................................................................................23
2.6 Customer Satisfaction:.............................................................................................................23
3.0 Conclusion..........................................................................................................................29
Reference.......................................................................................................................................29
2

1.0 Introduction
Duque Papetiers Gros is a French company owned by a person named Donald Duque. The
company runs its business in the stationery sector. The owner of Duque Papetiors considers it to
be a small family business. The European organization is currently operating only in the
Northern France area. Although it is a small business, the company has been into the industry for
more than fifty years today. It directly does not deal with customers. It is a B2B company that
has products base ranging from Printer Cartridges to General office supplies. In this report, the
aim is to look for prospects of expanding the business of the company out of France.
3

2 Analysis of Issues for Duque Papetiers Gros
2.0 An Overview of the Wholesale Stationers Market in Germany
At present, the German stationery business is well set and progressing. A total of €14.8 billion
was the figure of turnover for the market, according to the facts provided by the Trade
Association for Office Supply and Writing Materials (HBS).When it comes to the European
Union, the nation is second when measured according to money spent for stationery purposes.
The same association came up with another statistics (Büchs, 2017). It claimed that an amount of
€35.2 billion is usually spent only on materials related to writing and drawing. 2015 saw
organizations related to stationery business having a healthy amount of increase in sales. Also, it
has been seen that during 2014-2015, the stationery industry as a whole witnessed a big growth
of 3.5%. It is not very difficult to analyze the reason for this growth though. An industry grows
when the demand for the products or services it delivers increase (2017). In Germany, recent
times have witnessed a steady increase in the demand for stationery products from both the
native market as well as the foreign market (Strange, 2015). The rise in the demands of the
native market was 2.5% while the demands from the foreign market witnessed an increase of 5%
(Freund, 2016). This statistics have been provided by the Association of German Stationery
Brands (Verband der PBS-Markenindustrie). In a nation which has almost 2,200 wholesale
companies and 5,000 retail companies, the scope of development is always possible (Richards,
2017). However the low birth rate and ever reducing pupil rates, the path of development of the
stationery industry is not as easy as it should be. (Gilpin, 2016)
2.1 Annual Spending on Writing/Drawing Materials per Capita
Country Annual Spending ( in €)
Germany 35.2
Austria 35
France 28.3
Italy 18.6
Spain 8.9
4

Slovenia 20.4
Poland 8.5
Germany
Austria
France
Italy
Spain
Slovenia
Poland
0
5
10
15
20
25
30
35
40
35.2 35 28.3
18.6
8.9
20.4
8.5
Annual Spending ( in €)
Annual Spending ( in €)
Figure 1: Annual Spending of European Countries on Writing/Drawing Materials Per
Capita
(Source: The Economist, 2018)
From the chart, it is evident that per capita, it is Germany which spends the most when it comes
to the Stationery Industry. However, like it is mentioned in the previous paragraph, due to
several problems such as the Birth rate reduction, decreased rate of pupils and also the ever
fluctuating prices of Crude oil, whether or not Germany will be able to keep its first position
intact is a big question today. And for the same reason, it becomes a big chance for the French to
establish themselves as the leader of the stationery market in the European Market. Currently,
France stands way behind Germany (first) and Austria (second) when measured in terms of
Annual Spending. The various problems in Germany such as the poor GDP rate and also the
hugely low employment rate shall act as a booming prospect for France. The nation can take a
stride forward if the stationery industries based in France boost up their investment and
undertake the necessary actions to venture into the international markets.
5

2.2 Analysis of Duque’s last three financial years of sales data (2015-2017)
Product item 2015
Sales
(€)
2016
Sales
(€)
2017
Sales
(€)
Total Sales
(€)
Printer Cartridges 25000 26000 22000 73000
general office
supplies
25000 27000 23000 75000
low-cost printers 15000 18000 18000 51000
office furniture 25000 25000 27000 77000
shredders 25000 29000 29000 83000
paper-based
supplies
25000 27000 27000 79000
writing/drawing
materials
25000 30000 32000 87000
Figure 2: Analysis of Duque’s last three Financial years sales data)
(Source: Created by Author)
From the above given figure, it can be seen that Duque Papetiers has experienced highest sales
figures in the last there years with the aid of shredders. The report also states that when it comes
to low-cost printers, the sales figures are the lowest.
6

26000
27000
18000
2500029000
27000
30000
1
2
3
4
5
6
7
Figure 3: 2016 Sales chart
(Source: Created by the Author)
In the Pie-chart given above, the Sales figures of the various products of Duque are provided.
22000
23000
18000
2700029000
27000
32000
1
2
3
4
5
6
7
Figure 4: 2017 Sales Chart
(Source: Created by the Author)
7

In the figure given above, the Sales figure of 2017 is given.
0 2 4 6 8 10 12
0
2
4
6
8
10
12
Series1
Linear (Series1)
Axis Title
Axis Title
Figure 5: Scatter Diagram of Total Sales and Years
(Source: Created by Author)
According to the above created Scatter Diagram, it is evident that the Sales rate has been highly
stagnant and hasn’t moved up a lot. Rather, on some products, the sales figures have also
showcased a downfall.
2.3 Feasibility of Expanding to Germany & International Standards
Should I expand my business to Belgium & Germany?
Pros Score/10 Cons Score/10
One of Europe’s top economies 8 Lack of Professionalism 3
One of World’s top exporters 6 Emotional outbursts are very
common 5
People are largely analytical and
deep thinkers 8
Employees do not like much
governance when it comes to
work
5
8