Expanding Business in Germany and Belgium: Retail Market Analysis

This assignment involves analyzing the potential of expanding business operations for Donald Duque into the retail markets of Germany and Belgium. Key aspects include evaluating product and service proficiency using polling data, addressing human resource needs, and making strategic decisions based on compiled information.

Analysing Data

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Presenting the brief overview of wholesale stationery market in Germany...............................1
TASK 2............................................................................................................................................3
Assessing annual per capital spending on writing and drawing material:..................................3
TASK 3............................................................................................................................................4
a). Evaluation of total sales:........................................................................................................4
b). Pie chart.................................................................................................................................5
C). Correlation co-efficient via Scatter plot:...............................................................................6
D). Estimating sales trends for the period between 2018 and 2019............................................7
TASK 4............................................................................................................................................7
a). Pros and Cons evaluation.......................................................................................................7
b). Elaborating international standards with which cited company requires to comply with:....7
TASK 5............................................................................................................................................8
a). Computing monthly cost of 30 year repayment mortgage:....................................................8
b. Re-calculating monthly cost assuming that the interest is applied to the loan every month...8
TASK 6............................................................................................................................................9
TASK 7..........................................................................................................................................10
a). Advice for improvement:.....................................................................................................10
b). Descriptive statistics............................................................................................................12
TASK 8..........................................................................................................................................13
Recommendation.......................................................................................................................13
CONCLUSION..............................................................................................................................13
REFERENCES..............................................................................................................................15
APPENDIX....................................................................................................................................16

INTRODUCTION
Analysing of data is the most crucial tool for analysing the business statistically and
financially. However, this can be said that for gaining competitive advantages in an effective
manner. In this report, various tools are used for analysing the data which would help out to
assess the future trends and henceforth assist in effective decision making (Silverman, 2015).
This report is totally relied upon the Donald Duque which is small scale company and situated at
Northern France. Donald Duque specially deals in wholesale trade instead of selling stationery
products directly to the public. goods which are offering by these business units, covers: printer,
general office supplies, Furniture for commercial purpose, drawing materials etc. Under this
report, trends of wholesale stationery market in Germany. This is likewise spending on drawing
material per capita. Report likewise renders in which graphical presentation assist in
summarising data set.
TASK 1
Presenting the brief overview of wholesale stationery market in Germany
Wholesale stationery market in Germany is in the peak position all around the globe.
Henceforth, now there is a strong need to have various organisations in Germany that renders
clients with quality products. Some of them are: Staedtler, Stadbilo, Lamy etc.
The above mentioned graph reflects in 2002, efficient reduction evaluated during number
of office supplies and stationery retailer. There are vast wholesalers in 2002 as 7973 wholesalers
1

are indulging there which was gradually decreased as the year passed on. While after 10 years or
in 2012, number of wholesalers in Germany market decreased and come to 6047 and in 2015,
this was come to 5200 during 2015. Thus, during these period, offices accounted for 5200 only
which was lower as compared to earlier time-frame. In addition to this, focus is likewise laid
down by the suppliers on introducing contributing innovative stationery items or services to the
consumers which could satiate their expectation level in an effective manner. Apart from this, by
growing demand of the suppliers in global market,growth in the sales revenue emerged by 3.5%
effectively (Uemura and et.al., 2016). In addition to this, effective changes were required to be
evaluated in these industry after entering of specialist retailers. In addition to this, these retailers
are providing premium or high quality goods using their own labels. In addition to this, these
kinds of retailers are offering premium or more quality goods using their own labels which
would ultimately affect the profitability in a positive manner. They believe that labelled goods
enables easy identifying the same. Apart from this, stationery market in Germany, having the
online marketing of products which shows that 24 hours availability. Henceforth, by forming
online presence Donald Duque could gain success (Wimmer and et. al., 2013).
2

TASK 2
Assessing annual per capital spending on writing and drawing material:
By convening research, this is rightly evaluated that out of the total customer spending,
€35.2 linked up to drawing and writing material. Out of the European countries like Austria,
Belgium, Bulgaria, Cyprus, Denmark etc. Germany has positively secured 2nd position in the
stationery market (Song and et.al., 2016). While on the other hand, France attained fourth
position. Thus, product collection or variety controlled by the supermarket which has formed
effectively contribution for achieving leading position. In addition to this, with motive to emerge
awareness among the consumers and affects their buying decision emphasis which have made by
the suppliers on rendering advertisements on newspapers, electronic magazines (MGCC
Perspective - German Chamber of Commerce and Industry, 2016).
In addition to this, an effective in change in the market which has determined after
introducing digitization. Online is the products or services renders that renders huge kind of
convenience to the consumers. Henceforth, this is one of the crucial tool which now customers
buying goods through online instead physical store (De Muth, 2014). Apart from that, more
growth has been found via online manner instead of set up of online store. Henceforth, there is a
3

rise of entire stationery business which has been seen almost 17% hike in the overall industry. In
Germany, retailers also requires to have concentration on strengthening or improving their
market share (Ghilani, 2017).
By relying upon industrial trend, this could likewise be depicted that it would enhance in the near
future. Decreasing trends has also evaluated in the number of pupils by 11.9% which helps in
turn places adverse affect on the desire for writing and drawing material.
TASK 3
a). Evaluation of total sales:
Refer appendix 1
For assessing the figure of total sales, revenue of entire products from entire products
covers in item portfolio which have been added. In addition to this, for reflecting desirable sales
view or trend comparison of available year has likewise been done along with last year
(Shevlyakov and Smirnov, 2016). During 2015 2016 and 2017, this can be said that total sales
has been calculated by sum up of all the items which have been sold by the cited company. Total
sales of the Donald Duque is calculated: €165000, €182000 & €178000 significantly. By
evaluating the sales revenue of the organization enhanced by 10.30% and 2,20% respectively. By
identifying the total sales by the product over the last 3 years, the research elaborated that
organisation produces optimum sales from supply of writing and drawing material and shredders.
Although, low cost printer elaborated least sales value of €51,000.
4

b). Pie chart
By evaluating the above mentioned pie chart, this could effectively been said that the
Donald Duque is having low cost printers which can contributed to least percentage in 2016 and
2017. on the other hand, this can rightly be said that printer cartridges accounted for 16% at the
time 2016 which ultimately enhanced to 18% from the total sales.
C). Correlation co-efficient via Scatter plot:
Year Total sales (in €)
2015 165,000.00
2016 182,000.00
2017 178,000.00
Correlation coefficient 0.73
5

2014.5 2015 2015.5 2016 2016.5 2017 2017.5
155000
160000
165000
170000
175000
180000
185000
Total sales (in €)
Scatter diagram plots two main diverse values in accordance with two axes and pattern
demonstrated by the points reflected correlation between both of the variables (Klein, 2017). By
checking to the graph according to the year enhanced, total sales demonstrated increasing trends
which could indicates that year and sales performance which predate positive links. The value of
the correlation coefficient between both of the variable are identified to +0.73 which reflects that
over the period, sales enhanced by 73% as of increasing domestic and overseas demand for the
stationery products.
D). Estimating sales trends for the period between 2018 and 2019
Year Sales
2018 €6500x + €162000
= €6500 (4) + €162000
= €188000
2019
€6500x + €162000
= €6500 (5) + €162000
= €194500
TASK 4
a). Pros and Cons evaluation
6

Pros Score/10 Cons Score/10
Customer base
improvements 9 Excessive staff turnover 5
Economies of scale 8 Consequence on quality 8
expert personnel 7 Progressive capital demand 7
Relocation possibility 6 Non-achievement of
operational control 6
Total Pros 30 Total Cons 26
Net results or outcome: Total score of pros – cons
= 30 – 26
= 4
By presenting crucial outcome, this can be said that Donald Duque concentrates on the
expansion strategy. Henceforth, this is highly predicted that strategy which are specifically
concerned to the expansion of business operations in Germany and Belgium that could gain high
benefits. This mostly assist in improving customer base and therefore, profits and sales in an
effective manner.
b). Elaborating international standards with which cited company requires to comply with:
For emerging a more efficient performance of a company, managers of the cited company
requires to implement international standards (De Muth, 2014). They are various parts of
standards that can be connected with organization for providing secure data. There are so many
standards via which European firms are able to comply with their organization's activities. There
are so many standards via which providing secure data. There are so many standards via which
various organization are able to comply during execution of business activities and functions.
Henceforth, global standards are linked with operations of Donald Duque are mentioned below: ISO 14000 family-environmental management: On relying upon this standard, firms has
the responsibility to form an adequate planning in an ecological way. ISO 45001 Occupational health and safety: By relying on these standard, this is the
whole responsibility of cited organization to form an efficient planning which are related
to the health and safety of the personnel during workplace (International Organization for
Standardization, 2015).
 ISO 31000 risk management: For attainment of business targets, risk management
practices and strategies requires to be adopted by Donald Duque.
7

In addition to this, referred organization is required to have with the Data Protection Act
and according to the same confidentiality related to the information requirements are controlled.
Apart from that, cited organization required to adhere the set quality standards at the time
of forming manufacturing and offering stationery products to the consumers.
TASK 5
a). Computing monthly cost of 30 year repayment mortgage:
Particulars Figures
Time 30 years
Loan payment = Total loan
amount / Discounting factor =
= € 21215.85
Monthly repayment € 21215.85 / 12
= €1767.98
b. Re-calculating monthly cost assuming that the interest is applied to the loan every month
Particulars Figures
Time period (n) 30 years * 12 months (each year) = 360 times
Interest rate per month (R ) 10% / 12 = 0.00833
Monthly repayment
8

TASK 6
H0 (Null hypothesis): Under this, there is no significant difference in the mean
value of expected and actual average order value.
H1 (alternative hypothesis): There is a significant difference in the mean value of
expected and actual average order value.
Particulars Outcome
Mean of the entire population 240
Average of sample 230
Standard deviation 43
Z score assessment [ (Mean of the entire
population – sample average) / standard
deviation ]
(240 – 230 ) / 43
= 10 / 43
= 0.23
Criteria’s for selection and rejection of hypothesis
P > 0.05: Null hypothesis accepted or true
P < 0.05: Alternative hypothesis proved or true
By rendering evaluation, this can be render that p value of Z score 0.23 accounts for 0.59
significantly. These kinds of emergence reflects that p value is more than the standard limit like
as 0.05. Thus, this can be said that the total account is forecasted to assess entire positive
responds. By way of this emergence, this can be assessed that there is a strong differences and in
that situation, null hypothesis is totally accepted.
TASK 7
a). Advice for improvement:
In accordance with the below mentioned questionnaire, company's management could
form separate decisions regarding to the expansion of organization progressive. In addition to
this, 20 respondents were incorporated from market and underneath questionnaire which is
provided to them for evaluating an efficient decision making.
9

10

11

b). Descriptive statistics
Refer in appendix 2
Statistics
VAR00002 VAR00003 VAR00004 VAR00005
N Valid 21 21 21 21
Missing 0 0 0 0
 Customer service 
  Freq
uenc
y
 Per
ce
nt
 Valid
Percent
 Cumulativ
e Percent
 V
a
l
i
d
 2  3  14.
3  14.3  14.3
 3  4  19.
0  19.0  33.3
 4  13  61.
9  61.9  95.2
 CUST_
SERV  1  4.8  4.8  100.0
 Total  21  10
0.0  100.0

Quality P&S
Frequency Percent Valid Percent Cumulative
Percent
Valid
3 17 81.0 81.0 81.0
4 3 14.3 14.3 95.2
QUAL_P&S 1 4.8 4.8 100.0
Total 21 100.0 100.0
12

Sales staff
Frequency Percent Valid Percent Cumulative
Percent
Valid
2 4 19.0 19.0 19.0
3 3 14.3 14.3 33.3
4 13 61.9 61.9 95.2
SALES_STAFF 1 4.8 4.8 100.0
Total 21 100.0 100.0
Price value
Frequency Percent Valid Percent Cumulative
Percent
Valid
1 3 14.3 14.3 14.3
2 15 71.4 71.4 85.7
3 2 9.5 9.5 95.2
PRICE_VALUE 1 4.8 4.8 100.0
Total 21 100.0 100.0
TASK 8
Recommendation
By application of diverse “advantages and drawbacks”, Donald Duque can improve their
organization in Germany and Belgium. While on the other hand this can be said that the
expansion strategy of the cited company comprises diverse kinds of advantages and drawbacks.
As far are concerned, As advantages are concerned, organization can extend their deals and
benefits because of entering in the new market (Green and Salkind, 2016). Under this report, the
poll is utilized which exhibits items and administration proficiency to their purchasers which are
solid one. This division would not have issues identified with the HR and solid rating which
address by depending need.
13

CONCLUSION
From previously mentioned report, this could be appropriately watched that Donald Duque is
growing their business in Germany and Belgium. As, the organization is proposing to receive
activities in the retail section. For that different information are broke down in a compelling way
with the goal that they could settle on choices viably and effectively.
14

REFERENCES
Books and Journals:
De Muth, J.E., 2014. Basic statistics and pharmaceutical statistical applications. CRC Press.
Klein, P.A., 2017. Analyzing Modern Business Cycles: Essays Honoring: Essays Honoring.
Routledge.
Shevlyakov, G. and Smirnov, P., 2016. Robust estimation of the correlation coefficient: an
attempt of survey. Austrian Journal of Statistics. 40(1&2). pp.147-156.
Song, X. and et.al., 2016. An innovative block partition and equivalence method of the wave
scatter diagram for offshore structural fatigue assessment. Applied Ocean Research. 60.
pp.12-28.
Uemura, O. and et.al., 2016. Mean and standard deviation of reference glomerular filtration rate
values in Japanese children. Clinical and experimental nephrology. 20(2). p.317.'
Silverman, D., 2015. Interpreting qualitative data. Sage.
Wimmer, J and et. al., 2013. Analysing environmental acoustic data through collaboration and
automation. Future Generation Computer Systems, 29(2), pp.560-568.
De Muth, J.E., 2014. Basic statistics and pharmaceutical statistical applications. CRC Press.
Ghilani, C. D., 2017. Adjustment computations: spatial data analysis. John Wiley & Sons.
Green, S.B. and Salkind, N.J., 2016. Using SPSS for Windows and Macintosh, Books a la Carte.
Pearson.
Online
International Organization for Standardization. 2015. [Online]. Available through: <
https://www.iso.org/home.html>.
MGCC Perspective - German Chamber of Commerce and Industry. 2016. [PDF]. Available
through: <http://www.malaysia.ahk.de/fileadmin/ahk_malaysia/Perspectives/MGC047-
Mar.Apr16_iPAD.pdf>.
15

APPENDIX
16

17

18