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

This report analyzes the financial data of Duque Papetiers Gros, a French stationery company, to assess the feasibility of expanding its business to Germany. The report examines the German stationery market, Duque's sales performance, and the potential costs and benefits of expansion. It also includes a customer satisfaction survey to identify areas for improvement.

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

Planning and Management is
supported extensively by the
people
8 Lack of proper appraisal system 4
People are largely abided by law 9 Lack of confidence when it
comes to start-ups 6
Total Pros 39 Total Cons 23
Average Pros 7.8 Average Cons 4.6
From the above created table, it is evident that the value of pros is way higher than that of cons.
This makes the idea of expanding one’s business to Germany feasible. Although the market is
not much prosperous, but one can still make an attempt to expand the business in Germany
(Malaysia, 2018). The country remains one of the top economies of Europe. Also, it is one of the
World’s top exporters (Visser, 2017). The working natures of the people residing in Germany are
enhanced as proper planning and management is always supported by the employees of an
organization (Bryson, 2018).
2.4 Costs of a New Building
In the following table, the monthly cost of a 30-year repayment mortgage of £200,000, where
interest is applied to the loan outstanding at the beginning of each year and the mortgage rate is
10% per annum is provided:
Years Amount
Rate of
interest
Interest
payment
Total amount
paid
Monthly
payment
1 200000 10% 20000 26667 2222
2 193333.3 10% 19333 26000 2167
3 186666.7 10% 18667 25333 2111
4 180000 10% 18000 24667 2056
5 173333.3 10% 17333 24000 2000
9

6 166666.7 10% 16667 23333 1944
7 160000 10% 16000 22667 1889
8 153333.3 10% 15333 22000 1833
9 146666.7 10% 14667 21333 1778
10 140000 10% 14000 20667 1722
11 133333.3 10% 13333 20000 1667
12 126666.7 10% 12667 19333 1611
13 120000 10% 12000 18667 1556
14 113333.3 10% 11333 18000 1500
15 106666.7 10% 10667 17333 1444
16 100000 10% 10000 16667 1389
17 93333.33 10% 9333 16000 1333
18 86666.67 10% 8667 15333 1278
19 80000 10% 8000 14667 1222
20 73333.33 10% 7333 14000 1167
21 66666.67 10% 6667 13333 1111
22 60000 10% 6000 12667 1056
23 53333.33 10% 5333 12000 1000
24 46666.67 10% 4667 11333 944
25 40000 10% 4000 10667 889
26 33333.33 10% 3333 10000 833
10

27 26666.67 10% 2667 9333 778
28 20000 10% 2000 8667 722
29 13333.33 10% 1333 8000 667
30 6666.667 10% 667 7333 611
The remaining amount left is € 6666.667
Now, in the upcoming tables, the monthly cost assuming that the interest is to be applied to the
loan every month is calculated:
Year 1
1 200000
555.55
6 10%
20555.
6
2 199444
555.55
6 10% 20500
3 198889
555.55
6 10%
20444.
4
4 198333
555.55
6 10%
20388.
9
5 197778
555.55
6 10%
20333.
3
6 197222
555.55
6 10%
20277.
8
7 196667
555.55
6 10%
20222.
2
8 196111
555.55
6 10%
20166.
7
9 195556
555.55
6 10%
20111.
1
10 195000
555.55
6 10%
20055.
6
11 194444
555.55
6 10% 20000
12 193889
555.55
6 10%
19944.
4
11

Year 2
1 193889 538.58 10%
19927.
5
2 193350 538.58 10%
19873.
6
3 192812 538.58 10%
19819.
8
4 192273 538.58 10%
19765.
9
5 191735 538.58 10% 19712
6 191196 538.58 10%
19658.
2
7 190657 538.58 10%
19604.
3
8 190119 538.58 10%
19550.
5
9 189580 538.58 10%
19496.
6
10 189042 538.58 10%
19442.
7
11 188503 538.58 10%
19388.
9
12 187965 538.58 10% 19335
Year 3
1 142162
394.89
3 10% 14611
2 141767
522.12
4 10%
14698.
8
3 141245
522.12
4 10%
14646.
6
4 140722
522.12
4 10%
14594.
4
5 140200
522.12
4 10%
14542.
2
6 139678
522.12
4 10%
14489.
9
7 139156
522.12
4 10%
14437.
7
8 138634
522.12
4 10%
14385.
5
9 138112
522.12
4 10%
14333.
3
10 137590 522.12 10% 14281.
12

4 1
11 137068
522.12
4 10%
14228.
9
12 136545
522.12
4 10%
14176.
7
Year 4
1 136545
379.29
3 10%
14033.
8
2 136166
379.29
3 10%
13995.
9
3 135787
379.29
3 10% 13958
4 135408
379.29
3 10% 13920
5 135028
379.29
3 10%
13882.
1
6 134649
379.29
3 10%
13844.
2
7 134270
379.29
3 10%
13806.
3
8 133890
379.29
3 10%
13768.
3
9 133511
379.29
3 10%
13730.
4
10 133132
379.29
3 10%
13692.
5
11 132753
379.29
3 10%
13654.
5
12 132373
379.29
3 10%
13616.
6
Year 5
1 132373
367.70
3 10% 13605
2 132006
367.70
3 10%
13568.
3
3 131638
367.70
3 10%
13531.
5
4 131270
367.70
3 10%
13494.
7
5 130902
367.70
3 10%
13457.
9
13

6 130535
367.70
3 10%
13421.
2
7 130167
367.70
3 10%
13384.
4
8 129799
367.70
3 10%
13347.
6
9 129432
367.70
3 10%
13310.
9
10 129064
367.70
3 10%
13274.
1
11 128696
367.70
3 10%
13237.
3
12 128328
367.70
3 10%
13200.
6
Year 6
1 128328
356.46
8 10%
13189.
3
2 127972
356.46
8 10%
13153.
7
3 127616
356.46
8 10% 13118
4 127259
356.46
8 10%
13082.
4
5 126903
356.46
8 10%
13046.
7
6 126546
356.46
8 10%
13011.
1
7 126190
356.46
8 10%
12975.
4
8 125833
356.46
8 10%
12939.
8
9 125477
356.46
8 10%
12904.
1
10 125120
356.46
8 10%
12868.
5
11 124764
356.46
8 10%
12832.
8
12 124407
356.46
8 10%
12797.
2
Year 7
1 124407 345.57 10% 12786.
14

6 3
2 124062
345.57
6 10%
12751.
8
3 123716
345.57
6 10%
12717.
2
4 123371
345.57
6 10%
12682.
6
5 123025
345.57
6 10%
12648.
1
6 122679
345.57
6 10%
12613.
5
7 122334
345.57
6 10% 12579
8 121988
345.57
6 10%
12544.
4
9 121643
345.57
6 10%
12509.
8
10 121297
345.57
6 10%
12475.
3
11 120952
345.57
6 10%
12440.
7
12 120606
345.57
6 10%
12406.
2
Year 8
1 120606
335.01
7 10%
12395.
6
2 120271
335.01
7 10%
12362.
1
3 119936
335.01
7 10%
12328.
6
4 119601
335.01
7 10%
12295.
1
5 119266
335.01
7 10%
12261.
6
6 118931
335.01
7 10%
12228.
1
7 118596
335.01
7 10%
12194.
6
8 118261
335.01
7 10%
12161.
1
9 117926
335.01
7 10%
12127.
6
10 117591 335.01 10% 12094.
15

7 1
11 117256
335.01
7 10%
12060.
6
12 116921
335.01
7 10%
12027.
1
Year 9
1 116921 324.78 10%
12016.
9
2 116596 324.78 10%
11984.
4
3 116271 324.78 10%
11951.
9
4 115946 324.78 10%
11919.
4
5 115622 324.78 10%
11886.
9
6 115297 324.78 10%
11854.
5
7 114972 324.78 10% 11822
8 114647 324.78 10%
11789.
5
9 114323 324.78 10% 11757
10 113998 324.78 10%
11724.
6
11 113673 324.78 10%
11692.
1
12 113348 324.78 10%
11659.
6
Year
10
1 113348
314.85
6 10%
11649.
7
2 113033
314.85
6 10%
11618.
2
3 112719
314.85
6 10%
11586.
7
4 112404
314.85
6 10%
11555.
2
5 112089
314.85
6 10%
11523.
7
6 111774 314.85 10% 11492.
16

6 3
7 111459
314.85
6 10%
11460.
8
8 111144
314.85
6 10%
11429.
3
9 110829
314.85
6 10%
11397.
8
10 110515
314.85
6 10%
11366.
3
11 110200
314.85
6 10%
11334.
8
12 109885
314.85
6 10%
11303.
3
Year
11
1 146642 407.34 10%
15071.
6
2 146235 407.34 10%
15030.
8
3 145828 407.34 10%
14990.
1
4 145420 407.34 10%
14949.
4
5 145013 407.34 10%
14908.
6
6 144606 407.34 10%
14867.
9
7 144198 407.34 10%
14827.
2
8 143791 407.34 10%
14786.
4
9 143384 407.34 10%
14745.
7
10 142976 407.34 10% 14705
11 142569 407.34 10%
14664.
2
12 142162 407.34 10%
14623.
5
Year
12
1 142162 394.89 10% 14611
17

3
2 141767
394.89
3 10%
14571.
6
3 141372
394.89
3 10%
14532.
1
4 140977
394.89
3 10%
14492.
6
5 140582
394.89
3 10%
14453.
1
6 140187
394.89
3 10%
14413.
6
7 139792
394.89
3 10%
14374.
1
8 139397
394.89
3 10%
14334.
6
9 139002
394.89
3 10%
14295.
1
10 138608
394.89
3 10%
14255.
6
11 138213
394.89
3 10%
14216.
2
12 137818
394.89
3 10%
14176.
7
Year
13
1 137818
382.82
7 10%
14164.
6
2 137435
382.82
7 10%
14126.
3
3 137052
382.82
7 10% 14088
4 136669
382.82
7 10%
14049.
8
5 136286
382.82
7 10%
14011.
5
6 135904
382.82
7 10%
13973.
2
7 135521
382.82
7 10%
13934.
9
8 135138
382.82
7 10%
13896.
6
18

9 134755
382.82
7 10%
13858.
3
10 134372
382.82
7 10%
13820.
1
11 133989
382.82
7 10%
13781.
8
12 133607
382.82
7 10%
13743.
5
Year
14
1 133607 371.13 10%
13731.
8
2 133236 371.13 10%
13694.
7
3 132864 371.13 10%
13657.
6
4 132493 371.13 10%
13620.
5
5 132122 371.13 10%
13583.
3
6 131751 371.13 10%
13546.
2
7 131380 371.13 10%
13509.
1
8 131009 371.13 10% 13472
9 130638 371.13 10%
13434.
9
10 130266 371.13 10%
13397.
8
11 129895 371.13 10%
13360.
7
12 129524 371.13 10%
13323.
6
Year
15
1 129524
359.78
9 10%
13312.
2
2 129164
359.78
9 10%
13276.
2
3 128805
359.78
9 10%
13240.
3
19

4 128445
359.78
9 10%
13204.
3
5 128085
359.78
9 10%
13168.
3
6 127725
359.78
9 10%
13132.
3
7 127365
359.78
9 10%
13096.
3
8 127006
359.78
9 10%
13060.
4
9 126646
359.78
9 10%
13024.
4
10 126286
359.78
9 10%
12988.
4
11 125926
359.78
9 10%
12952.
4
12 125567
359.78
9 10%
12916.
4
Year
16
1 125567
348.79
6 10%
12905.
4
2 125218
348.79
6 10%
12870.
6
3 124869
348.79
6 10%
12835.
7
4 124520
348.79
6 10%
12800.
8
5 124171
348.79
6 10%
12765.
9
6 123823
348.79
6 10%
12731.
1
7 123474
348.79
6 10%
12696.
2
8 123125
348.79
6 10%
12661.
3
9 122776
348.79
6 10%
12626.
4
10 122427
348.79
6 10%
12591.
5
11 122079
348.79
6 10%
12556.
7
12 121730 348.79 10% 12521.
20

6 8
Year
17
1 121730
338.13
8 10%
12511.
1
2 121392
338.13
8 10%
12477.
3
3 121053
338.13
8 10%
12443.
5
4 120715
338.13
8 10%
12409.
7
5 120377
338.13
8 10%
12375.
9
6 120039
338.13
8 10% 12342
7 119701
338.13
8 10%
12308.
2
8 119363
338.13
8 10%
12274.
4
9 119025
338.13
8 10%
12240.
6
10 118687
338.13
8 10%
12206.
8
11 118348
338.13
8 10% 12173
12 118010
338.13
8 10%
12139.
2
Year
18
1 118010
327.80
6 10%
12128.
8
2 117682
327.80
6 10%
12096.
1
3 117355
327.80
6 10%
12063.
3
4 117027
327.80
6 10%
12030.
5
5 116699
327.80
6 10%
11997.
7
6 116371
327.80
6 10%
11964.
9
21

7 116043
327.80
6 10%
11932.
1
8 115716
327.80
6 10%
11899.
4
9 115388
327.80
6 10%
11866.
6
10 115060
327.80
6 10%
11833.
8
11 114732
327.80
6 10% 11801
12 114404
327.80
6 10%
11768.
2
Year
19
1 114404 317.79 10%
11758.
2
2 114087 317.79 10%
11726.
4
3 113769 317.79 10%
11694.
7
4 113451 317.79 10%
11662.
9
5 113133 317.79 10%
11631.
1
6 112815 317.79 10%
11599.
3
7 112498 317.79 10%
11567.
6
8 112180 317.79 10%
11535.
8
9 111862 317.79 10% 11504
10 111544 317.79 10%
11472.
2
11 111226 317.79 10%
11440.
4
12 110909 317.79 10%
11408.
7
Year
20
1 110909 308.08 10%
11398.
9
22

2 110601 308.08 10%
11368.
1
3 110293 308.08 10%
11337.
3
4 109984 308.08 10%
11306.
5
5 109676 308.08 10%
11275.
7
6 109368 308.08 10%
11244.
9
7 109060 308.08 10%
11214.
1
8 108752 308.08 10%
11183.
3
9 108444 308.08 10%
11152.
5
10 108136 308.08 10%
11121.
7
11 107828 308.08 10%
11090.
9
12 107520 308.08 10%
11060.
1
Year
21
1 107520
298.66
6 10%
11050.
6
2 107221
298.66
6 10%
11020.
8
3 106922
298.66
6 10%
10990.
9
4 106624
298.66
6 10% 10961
5 106325
298.66
6 10%
10931.
2
6 106026
298.66
6 10%
10901.
3
7 105728
298.66
6 10%
10871.
4
8 105429
298.66
6 10%
10841.
6
9 105130
298.66
6 10%
10811.
7
10 104832 298.66 10% 10781.
23

6 8
11 104533
298.66
6 10% 10752
12 104234
298.66
6 10%
10722.
1
Year
22
1 104234 289.54 10% 10713
2 103945 289.54 10% 10684
3 103655 289.54 10%
10655.
1
4 103366 289.54 10%
10626.
1
5 103076 289.54 10%
10597.
2
6 102787 289.54 10%
10568.
2
7 102497 289.54 10%
10539.
3
8 102208 289.54 10%
10510.
3
9 101918 289.54 10%
10481.
4
10 101629 289.54 10%
10452.
4
11 101339 289.54 10%
10423.
4
12 101050 289.54 10%
10394.
5
Year
23
1 101050
280.69
3 10%
10385.
6
2 100769
280.69
3 10%
10357.
6
3 100488
280.69
3 10%
10329.
5
4 100207
280.69
3 10%
10301.
4
24

5
99926.
8
280.69
3 10%
10273.
4
6
99646.
1
280.69
3 10%
10245.
3
7
99365.
4
280.69
3 10%
10217.
2
8
99084.
7
280.69
3 10%
10189.
2
9 98804
280.69
3 10%
10161.
1
10
98523.
3
280.69
3 10% 10133
11
98242.
6
280.69
3 10% 10105
12
97961.
9
280.69
3 10%
10076.
9
Year
24
1
97961.
9
272.11
6 10%
10068.
3
2
97689.
8
272.11
6 10%
10041.
1
3
97417.
7
272.11
6 10%
10013.
9
4
97145.
6
272.11
6 10%
9986.6
7
5
96873.
5
272.11
6 10%
9959.4
6
6
96601.
3
272.11
6 10%
9932.2
5
7
96329.
2
272.11
6 10%
9905.0
4
8
96057.
1
272.11
6 10%
9877.8
3
9 95785
272.11
6 10%
9850.6
2
10
95512.
9
272.11
6 10% 9823.4
11
95240.
8
272.11
6 10%
9796.1
9
12
94968.
6
272.11
6 10%
9768.9
8
25

Year
25
1
94968.
6
263.80
2 10%
9760.6
7
2
94704.
8
263.80
2 10%
9734.2
9
3 94441
263.80
2 10%
9707.9
1
4
94177.
2
263.80
2 10%
9681.5
3
5
93913.
4
263.80
2 10%
9655.1
5
6
93649.
6
263.80
2 10%
9628.7
7
7
93385.
8
263.80
2 10%
9602.3
8
8 93122
263.80
2 10% 9576
9
92858.
2
263.80
2 10%
9549.6
2
10
92594.
4
263.80
2 10%
9523.2
4
11
92330.
6
263.80
2 10%
9496.8
6
12
92066.
8
263.80
2 10%
9470.4
8
Year
26
1
92066.
8
255.74
1 10%
9462.4
2
2
91811.
1
255.74
1 10%
9436.8
5
3
91555.
3
255.74
1 10%
9411.2
8
4
91299.
6
255.74
1 10% 9385.7
5
91043.
9
255.74
1 10%
9360.1
3
6
90788.
1
255.74
1 10%
9334.5
5
7
90532.
4
255.74
1 10%
9308.9
8
8 90276. 255.74 10% 9283.4
26

6 1
9
90020.
9
255.74
1 10%
9257.8
3
10
89765.
2
255.74
1 10%
9232.2
6
11
89509.
4
255.74
1 10%
9206.6
8
12
89253.
7
255.74
1 10%
9181.1
1
Year
27
1
89253.
7
247.92
7 10%
9173.2
9
2
89005.
7
247.92
7 10% 9148.5
3
88757.
8
247.92
7 10%
9123.7
1
4
88509.
9
247.92
7 10%
9098.9
2
5 88262
247.92
7 10%
9074.1
2
6 88014
247.92
7 10%
9049.3
3
7
87766.
1
247.92
7 10%
9024.5
4
8
87518.
2
247.92
7 10%
8999.7
5
9
87270.
3
247.92
7 10%
8974.9
5
10
87022.
3
247.92
7 10%
8950.1
6
11
86774.
4
247.92
7 10%
8925.3
7
12
86526.
5
247.92
7 10%
8900.5
7
Year
28
1
86526.
5 240.351 10% 8893
2
86286.
1 240.351 10% 8868.96
27

3
86045.
8 240.351 10% 8844.93
4
85805.
4 240.351 10% 8820.89
5
85565.
1 240.351 10% 8796.86
6
85324.
7 240.351 10% 8772.82
7
85084.
4 240.351 10% 8748.79
8 84844 240.351 10% 8724.75
9
84603.
7 240.351 10% 8700.72
10
84363.
3 240.351 10% 8676.68
11 84123 240.351 10% 8652.65
12
83882.
6 240.351 10% 8628.61
Year
30
1
81319.
5
225.88
8 10%
8357.8
4
2
81093.
6
225.88
8 10%
8335.2
5
3
80867.
8
225.88
8 10%
8312.6
6
28
Year
29
1
83882.
6 233.007 10% 8621.27
2
83649.
6 233.007 10% 8597.97
3
83416.
6 233.007 10% 8574.67
4
83183.
6 233.007 10% 8551.37
5
82950.
6 233.007 10% 8528.07
6
82717.
6 233.007 10% 8504.76
7
82484.
6 233.007 10% 8481.46
8
82251.
6 233.007 10% 8458.16
9
82018.
6 233.007 10% 8434.86
10
81785.
5 233.007 10% 8411.56
11
81552.
5 233.007 10% 8388.26
12
81319.
5 233.007 10% 8364.96

4
80641.
9
225.88
8 10%
8290.0
7
5 80416
225.88
8 10%
8267.4
9
6
80190.
1
225.88
8 10% 8244.9
7
79964.
2
225.88
8 10%
8222.3
1
8
79738.
3
225.88
8 10%
8199.7
2
9
79512.
4
225.88
8 10%
8177.1
3
10
79286.
5
225.88
8 10%
8154.5
4
11
79060.
7
225.88
8 10%
8131.9
5
12
78834.
8
225.88
8 10%
8109.3
6
2.5 Mean Value of Orders
According to the scenario provided, Donald has chosen 50 orders as sample. If we take this into
consideration, the mean value becomes €230. Also, the Standard Deviation comes to €43. Going
by this, one can say that the evidences and his belief do not match. Since he has chosen 50 orders
as sample, the evidences do not match. Since he has not chosen the rest 50 orders, there remain
high chances of errors in calculation. Adjacently, it can be said that since the level of
significance is 5%, there are chances that the mean value might reduce or get altered by 5% of
€230.
2.6 Customer Satisfaction:
Options Responses Reponses in percent Total respondents
1 (Highly dissatisfied) 0 0 20
2 (Dissatisfied) 3 15% 20
3 (Satisfied) 4 20% 20
4 (Highly Satisfied) 13 65% 20
29

Mean Median Mode SD
3.5 4 4 0.760886
2 (Dissatisfied)
15%
3 (Satisfied)
20%4 (Highly Satisfied)
65%
Customer satisfaction
Quality of Product & Services:
Options Responses Reponses in percent Total respondents
1 (Highly dissatisfied) 0 0 20
2 (Dissatisfied) 0 0 20
3 (Satisfied) 17 85% 20
4 (Highly Satisfied) 3 15% 20
Mean Median Mode SD
3.15 3 3 0.366348
30

1st Qtr
59%2nd Qtr
23%
3rd Qtr
10% 4th Qtr
9%
Sales Staff:
Options Responses Reponses in percent Total respondents
1 (Highly dissatisfied) 0 0 20
2 (Dissatisfied) 4 20% 20
3 (Satisfied) 3 15% 20
4 (Highly Satisfied) 13 65% 20
Mean Median Mode SD
3.45 4 4 0.825578
31

1st Qtr
59%2nd Qtr
23%
3rd Qtr
10% 4th Qtr
9%
32

Price Value:
Options Responses Reponses in percent Total respondents
1 (Highly dissatisfied) 3 15% 20
2 (Dissatisfied) 15 75% 20
3 (Satisfied) 2 10% 20
4 (Highly Satisfied) 0 0 20
Mean Median Mode SD
1.95 2 2 0.510418
1st Qtr
59%
2nd Qtr
23%
3rd Qtr
10%
4th Qtr
9%
Customer Satisfaction:
In the Customer satisfaction area, 65% of the 20 customers are highly satisfied. With the
indication of the Mode Value, it gets clearer. Also, the Mean value (3.5) states that the average
response when it comes to Customer Satisfaction is between Satisfied to Highly Satisfied.
Quality of Products and Services:
33

Out of the 20customers, 85% of customers are satisfied with the Quality of Products and
Services. The Mode Value of 3 indicates just that.
Sales Staff:
When it comes to Sales Staff, the mean value of 3.45 states that the customers on an average are
satisfied to highly satisfied with the sales staff. The mode value is the proof of the fact.
Price Value:
When it comes to Price Value, most of the customers are dissatisfied with it. The percentages of
the customers who are dissatisfied with Price value constitute 75%.
34

3.0 Conclusion
Duque Papetiers Gros has been functioning in the Stationery industry for quite some now. In the
research conducted about the France based Stationery company, it has been found that it needs to
modify and improve each and every sector of its working principles in order to increase its
customer base. Also in the research conducted, the fact that the company has good scope of
expanding its business outside the French border has been found. According to the various charts
displayed above, the company needs to focus more on sectors like Price Value, increasing sales
and also enhance Customer Satisfaction. The owner if successfully re-shapes his small family
business according to the research conducted, has every scope of turning Duque into a successful
venture abroad.
Reference
Bryson, J.M., 2018. Strategic planning for public and nonprofit organizations: A guide to
strengthening and sustaining organizational achievement. John Wiley & Sons.
Büchs, M. and Koch, M., 2017. Capitalist Development and the Growth Paradigm.
In Postgrowth and Wellbeing (pp. 9-24). Palgrave Macmillan, Cham.
Freund, C., 2016. Rich People Poor Countries: The Rise of Emerging-Market Tycoons and their
Mega Firms. Peterson Institute for International Economics.
Gilpin, R., 2016. The political economy of international relations. Princeton University Press.
Malaysia, A. (2018). Home. [online] Malaysia.ahk.de. Available at:
http://www.malaysia.ahk.de/en/home/ [Accessed 21 Apr. 2018].
Richards, G., 2017. Warehouse management: a complete guide to improving efficiency and
minimizing costs in the modern warehouse. Kogan Page Publishers.
Ross, J.E., 2017. Total quality management: Text, cases, and readings. Routledge.
35

Strange, S., 2015. States and markets. Bloomsbury Publishing.
The Economist. (2018). What disruptive innovation means. [online] Available at:
https://www.economist.com/blogs/economist-explains/2015/01/economist-explains-15
[Accessed 18 Apr. 2018].
Visser, W., 2017. Sustainable frontiers: Unlocking change through business, leadership and
innovation. Routledge.
36