Data Analysis for Decision Making in Germany

This assignment analyzes the stationary industry in Germany, focusing on Donald Duque's products and their quality. A questionnaire is used to collect information about respondents' preferences, which helps understand issues related to business and actual viewpoints. The results contribute to growing activities and support expanding in Germany and Belgium.

Report for Duque Papetiers
Gros

Table of Contents
INTRODUCTION...........................................................................................................................1
1.1 Overview of the wholesale stationary market in Germany ..................................................1
TASK 2............................................................................................................................................2
2.1 Annual expenses which are incurred on writing and drawing as per capita.........................2
TASK 3............................................................................................................................................3
3 Evaluation of the sales figure of Duque's of last three years...................................................3
(a). Total sales.............................................................................................................................3
(b) Mixed pie chart......................................................................................................................4
(c) Presentation of correlation cost-efficient by formulation of scatter graph............................4
(d) Forecast about sales...............................................................................................................4
TASK 4 ...........................................................................................................................................5
(a) Evaluation of pros and cons...................................................................................................5
(b) International standards which are required to comply by Donald Duque.............................5
TASK 5............................................................................................................................................6
(a) Computation of monthly cost about repayment of mortgage of 30 year...............................6
(b) Re-calculation of monthly cost after application of interest on loan at every month............6
TASK 6............................................................................................................................................7
TASK 7............................................................................................................................................7
(a) Recommendations for improvement......................................................................................7
(b) Descriptive statistics..............................................................................................................9
TASK 8..........................................................................................................................................11
Summary of report....................................................................................................................11
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12
Appendix........................................................................................................................................13

INTRODUCTION
Data analysis is important concept which helps in development of small business. It
provides aid in better decision making. It also contributes in assessment of the issues which are
present in business and identification of the current trends which results in attainment of
sustainability in their operations. Donald Duque has small stationary business in Northern
France. They does not sell their products directly to their end customers. They build their
customer base with the help of wholesale trade with other businesses in Northern France over 50
years (Benth and et. al., 2014).
In the present report explain about, summary information, product and customer
information. Also, Recommendations which helps in expansion and financial information.
TASK 1
1.1 Overview of the wholesale stationary market in Germany
Overview
The current position of stationary industry is well positioned. According to HBS, The
turnover of whole industry is observed as more than €14.8 billion per year. It is also observed
that €35.2 is only spent on writing and drawing materials. The growth of the industry is
understand from the positive attitude of companies that they received increased sales in 2015.
The total growth in stationary industry in 2014 and 2015 is grew by 3.5%. The demand of
stationary items is grew by 2.5%.
Trends and potentials
There are many big brands in Germany which have good reputation in domestic and
international market. The major trendy products are general and writing instruments which helps
the companies to attain significant share in market. There is huge growth opportunities are
identified in paper and paper related products. There is significant growth opportunities in other
products like supplies and writing instruments. Both are growing with the rate of 5% in 2015.
Contribution of stationary market in economy
Stationary market of German is one of the important sector which has great contribution
in economic growth. There is vast change is noticed in turnover of the stationary retail market.
From three major Germany pharmacy, two has taken stationary business in their assortment and
continuously provides their function to expand the range of stationary products. The different
1

products range includes postal and parcel services, newspapers, magazines, sale of concert
tickets and articles. E-commerce also playing an important role in expansion stationary industry.
It is one of the revolutionary method which bring innovation in business operations. Such online
market holds more than 17% of market share. The major two reasons which helps in attraction of
the large number of customers to use online mode which are high range of products and 24 hour
accessibility (Cameron and Trivedi, 2013).
TASK 2
2.1 Annual expenses which are incurred on writing and drawing as per capita
Country
Per capita
(€)
Switzerland 35.5
Germany 35.2
Austria 35
France 28.3
Italy 18.6
Spain 8.9
Poland 8.5
2

Writing and drawing materials has largest contribution in total turnover in stationary
industry. It is observed that, around €35.2 is spent on both these items. Such products are sold in
many EU countries like Austria, Bulgaria, Cyprus, Denmark and Belgium. From their different
business functions France attained fourth position. There is huge contribution of hypermarkets
and supermarkets regarding maintenance of diversified products of stationary. They plays an
huge role in stationary industry to gain leading position and become one of the largest
contributor in an economy. The main aim of such markets is application of effective approaches
which helps in influencing the behaviour of customers and creation of awareness through
advertisements in newspapers and magazines etc.
Digitalization and mode of E-commerce has huge contribution in development of
stationary market in Germany. The positive contribution of this mode is 24 hours availability and
various type of products. It is observed that mail orders and online shopping holds more than
17% of of market share at present (Öberg and et. al., 2011).
TASK 3
3 Evaluation of the sales figure of Duque's of last three years
(a). Total sales
Refer appendix 1
From the above information, It is observed that growth is attained by company in their
sales from their diversified business activities. In 2015, total sales is 165000 from sale of
diversified activities like printer cartridges, General office supplies, low cost printers, office
furnitures etc. which is increased up to 182000 in 2016. After significant increase in the sales of
office furniture and writing/Drawing materials, there is decrease in total amount of sales in 2019
is 178000. The revenue of organisation is increased by 10.30% in 2016 from the sale of different
stationary items. But in 2017, such growth scenario is changed. It is observed that there is
decrease in sales revenue by 2.20%. The main reason for such declining trend in sales revenue is
low demand for printer and general office supplies.
3

(b) Mixed pie chart
It is observed from the above pie chart that, the printers has least contribution to generate
the revenue in 2016 and 2017. On other hand, cartridges have shows 2% of growth in sales
figure in 2017 as comparison to 2016. The sales figure of the paper based products is constant
(Peck and Devore, 2011).
(c) Presentation of correlation cost-efficient by formulation of scatter graph
Year Total sales (in €)
2015 165,000.00
2016 182,000.00
2017 178,000.00
Correlation coefficient 0.73
Correlation coefficient is important method which helps in understanding about the
relationship between two variables. In this present report, it is calculated to show the relation
between the years and sales figures. As per the norms the results are called good if the answer
comes between 0.25 to 0.75. So, in current scenario correlation coefficient is calculated as 0.73.
it means that sales increase positively.
(d) Forecast about sales
Year Sales
4

2018 €6500x + €162000
= €6500 (4) + €162000
= €188000
2019 €6500x + €162000
= €6500 (5) + €162000
= €194500
TASK 4
(a) Evaluation of pros and cons
Pros Score/10 Cons Score/10
Increasing customer
base 9 Extravagant staff turnover 5
Economies of scale 8 Impact on quality 8
Skilled or proficient
personnel 7 Intensive capital need 7
Relocation
possibilities 6 Loss of functional control 6
Total Pros 30 Total Cons 26
Net outcome= Total score of pros – cons
= 30 – 26
= 4
It has bee concluded from the above information that Donald Duque is need to focus on
growth plans. Through such expansion large number of benefits are attained by the organisation
in different terms. Expansion of operations in Germany and Belgium is proved as highly
beneficial in the regard of sales and revenue. It helps in attainment of large market share and
profit margin (Chambers, 2018).
(b) International standards which are required to comply by Donald Duque
There are many internal standards are provided by council which is need to follow by the
organisations while expand their operations internationally. So, it brings an obligation upon the
5

Donald Duque is to comply such global standards which are related to their business operations.
Such global standards are mentioned below:
 ISO 14000 management of family-environmental: As per this standard, organisation is
need to conduct activities is such manner that it does not effect environment from their
operations. It is important for Donald Duque because it deals in stationary items and
paper products (Würzburg, Labandeira and Linares, 2013).
 ISO 45001 Occupational health an safety: This standard provides the rules regarding
safety of workers at workplace. It brings an obligation upon Donald Duque is application
of safety measures ensures the safety of workers.
 ISO 31000 Management of risk: There are many risks which are directly or indirectly
associated with business. As per this standard, Donald Duque is required to apply
different strategies which helps in controlling risks.
Further, Data protection act is important which is followed by Donald duque regrading
confidentiality of their important information. Another important standard which helps in
maintenance of quality. It helps in providence of good quality stationary products (Ghilani,
2017).
TASK 5
(a) Computation of monthly cost about repayment of mortgage of 30 year
Particulars Figures
Time 30 years
Loan payment = Total loan
amount / Discounting factor =
= € 21215.85
Monthly repayment € 21215.85 / 12
= €1767.98
(b) Re-calculation of monthly cost after application of interest on loan at every month
Particulars Figures
Time period (n) 30 years * 12 months (each year) = 360 times
Interest rate per month (R ) 10% / 12 = 0.00833
6

Monthly repayment
TASK 6
H0 (Null Hypothesis): This method shows that the mean value which is calculated from
expected and actual average order value has no difference.
H1 (Alternative hypothesis): As per this method the difference is obtained in mean value
which is calculated from expected and actual 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 which is need to fulfil behind the selection and rejection of hypothesis
P > 0.05: Null hypothesis accepted or true
P < 0.05: Alternative hypothesis proved or true
It has been observed from the above evaluation that, present value of Z score is attained
as 0.23. It provides that the result figure which is calculated is more than the standard limit of
0.05. So, it is considered as the situation of null hypotheses is created and it is rejected. The
present value which is calculated above shows that there is no difference in mean value from
expected and actual average order value. It means that both actual and expected value orders are
moves in similar direction (Schabenberger and Gotway, 2017).
TASK 7
(a) Recommendations for improvement
To ascertain the views and recommendations of respondents, questionnaire is prepared
which helps in collection of important information. On the basis of such information, new
7

strategies are applied which helps in improvement of their existing products and services. 20
respondents are selected from total population which helps in effective decision making.
8

(b) Descriptive statistics
Statistics
VAR0000
2
VAR0000
3
VAR0000
4
VAR00005
N Valid 21 21 21 21
Missing 0 0 0 0
Customer service
Frequency Percent Valid Percent Cumulative
Percent
Valid 2 3 14.3 14.3 14.3
3 4 19.0 19.0 33.3
9

4 13 61.9 61.9 95.2
CUST_SERV 1 4.8 4.8 100.0
Total 21 100.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
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_STA
FF 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_VAL
UE 1 4.8 4.8 100.0
Total 21 100.0 100.0
10

TASK 8
Summary of report
Through expansion of their business operations in Germany and Belgium large number of
benefits are gathered by Donald Duque. But some kind of risks are associated with such work of
expansion. The major reason behind the growth activities is improve their sales figure and large
number of profits. Through entrance in new market large number of opportunities are emerged
for expansion (Masoud and Hardaker, 2012). The results which are attained from questionnaire
reflects that the quality of their existing products is good but still they need to improve skills of
employees which helps to attain large number of sales. There are no issues are ascertained which
are related to human resource.
CONCLUSION
It has been concluded from the above report that, there is huge importance of data
analysis for decision making. Analysis helps in attainment of the results which contributes in
growing activities. Stationary industry has vital part in economy of Germany. The quality of
products which are provided by Donald Duque is good which helps them to improve their sales
and revenue. Questionnaire is prepared for collection of information about the preferences of
respondents. It helps to understand the issues which are related to their business and their actual
viewpoints. This will provide large support to Donald duque to expand in Germany and Belgium.
In this regard, they have to comply with global standards.
11

REFERENCES
Books and Journals
Benth, F. E. and et. al., 2014. Futures pricing in electricity markets based on stable CARMA spot
models. Energy Economics. 44. pp.392-406.
Cameron, A. C. and Trivedi, P.K., 2013.Regression analysis of count data(Vol. 53). Cambridge
university press.
Öberg, M. and et. al., 2011. Worldwide burden of disease from exposure to second-hand smoke:
a retrospective analysis of data from 192 countries. The Lancet. 377(9760). pp.139-146.
Peck, R. and Devore, J. L., 2011. Statistics: The exploration & analysis of data. Cengage
Learning.
Chambers, J. M., 2018. Graphical methods for data analysis. CRC Press.
Ghilani, C. D., 2017. Adjustment computations: spatial data analysis. John Wiley & Sons.
Schabenberger, O. and Gotway, C. A., 2017. Statistical methods for spatial data analysis. CRC
press.
Masoud, N. and Hardaker, G., 2012. The impact of financial development on economic growth:
Empirical analysis of emerging market countries. Studies in Economics and Finance.
29(3), pp.148-173.
Würzburg, D., Labandeira, X. and Linares, P., 2013. Renewable generation and electricity
prices: Taking stock and new evidence for Germany and Austria. Energy Economics.
40. pp.S159-S171.
Online
MGCC Perspective. 2016 [Online]. Available through:<
file:///C:/Users/user/AppData/Local/Temp/Rar$DIa1.106/MGCCReport20161518787080
.pdf>.
International Organization for Standardization. 2018. [Online]. Available through:
<https://www.iso.org/home.html>.
Germany – A Potential Stationery Market. 2018. [Online]. Available through:
<http://www.malaysia.ahk.de/fileadmin/ahk_malaysia/Perspectives/MGC047-
Mar.Apr16_iPAD.pdf>.
12

Appendix
13

14