Comprehensive Analysis of Duque Papetiers' Data and Expansion Strategy

This report provides a comprehensive analysis of Duque Papetiers, a family-owned wholesale stationery business. It examines the company's sales data from 2015 to 2017, analyzes the German stationery market, and assesses the feasibility of expanding into Germany. The report includes an overview of the wholesale stationery market in Germany, annual spending on writing/drawing materials, and a detailed analysis of Duque's financial performance. It also evaluates the pros and cons of expansion, defines relevant international standards, and calculates the costs of a new building. Furthermore, the report assesses customer satisfaction and provides recommendations for enhancing customer responsiveness. The analysis uses statistical methods such as correlation coefficients and trend estimations to support its findings. The report concludes with key insights and recommendations for Duque Papetiers' future business strategies.

Analysing Data

Contents
Introduction.............................................................................................................................................1
Analysis of Issues for Duque Papetiers Gros.............................................................................................2
2.1 An Overview of the Wholesale Stationers Market in Germany..........................................................2
2.2 Annual Spending on Writing/Drawing Materials per Capita...............................................................3
2.3 Analysis of Duque’s last three financial years of sales data (2015-2017)...........................................5
Mixed pie chart:...................................................................................................................................5
Correlation co-efficient via scatter plot:...............................................................................................5
Estimating sales trend for the period of 2018 and 2019:.....................................................................6
2.4 Feasibility of Expanding to Germany & International Standards........................................................7
a). Pros and Cons assessment...............................................................................................................7
b). Defining international standards with which Donald Duque needs to comply:..............................7
2.5 Costs of a New Building......................................................................................................................9
a). Computing a monthly cost of 30-year repayment mortgage...........................................................9
b). Re-calculating monthly cost assuming that the interest is applied to the loan every month..........9
2.6 Mean Value of Orders......................................................................................................................10
2.7 Customer Satisfaction.......................................................................................................................11
a). Stating ways that can be used for enhancing customer responsive rate:......................................11
b). Evaluating data set collected from a survey..................................................................................11
Recommendation...............................................................................................................................12
Conclusion..............................................................................................................................................13
References..............................................................................................................................................14
Appendices.............................................................................................................................................15

Introduction
Donald Duque is a small sized family stationery business company which have their
business Germany is the development country which have strong economy situated in Northern
France. Although, he does not require to assess the significance and practical criticality of the
organisation data analysis in order to form a most effective decision (Stewart, 2016). This is
rightly said that Donald Duque is engaged in wholesale trading and form a strong customer
base in the past fifty years. Companies have diverse products which have cartridges of printers,
office furniture’s, low price printers, shredders, diverse kind of furniture, low price, paper
based suppliers and drawing related material. The current research which totally focus at
assessing its sales for last 3 year years to form strong decisions. In addition to this, future
business about its expansion would be assessed which would be assessed via “pros and cons”
tools and survey emerged that which be assessed via basic statistical methods for purpose in an
efficient decision.
1

Analysis of Issues for Duque Papetiers Gros
2.1 An Overview of the Wholesale Stationers Market in Germany
Stationery market in Germany is at the peak from various centuries and various things
are really operated in an effective manner (Uemura, O. and et.al., 2016). It is highly as of new
items emerged to customised customer habits, desires and choices along with emerged vitality
and superior issues which has elevated in this industry. Association for Office Supply
&Writing Material stated that industry had exceeded its annual revenue over 14.8 Billion by
enhancing individual spending above €182 per year. Out of these, €35.2 expenses on writing &
drawing material, as an outcome, various European market achieved on 2nd position after the
Switzerland. Germany Stationery Brands Association reported that emergence domestic
demand by the residents and demand from abroad during the growth rate at 2.5% and 5%
demonstrating sound growth of 3.5% during 2014-2015 (MGCC Perspective - German
Chamber of Commerce and Industry, 2016). 2200 wholesale organisations are existing
working in the German Stationery market which offers office supplies, paper, writing tools,
with high of them which have a net income below €500,000. B2B intermediaries which serves
commercial consumers directly. M&A strategies of the organisation is the perfect tool which
can be used by the specialist retailers who offer labelled and standardized quality products.
Immense growth which formed a strong brand image with have crucial market share.
Although, during the same time, this is struggling along with diverse challenges such like
paper & its regards to product sales which is forecasted to regular its existing path of lowering
sales revenue. This is occurred due to the digitalization of work, due to which, office supplies
and writing instrument experienced at a growth rate @ 5% per annum. HBS forecasted the
trend to be constantly in future.
2

2.2 Annual Spending on Writing/Drawing Materials 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
By assessing the graph, it is visualizing that Germany have the second largest market fr
the stationery after Switzerland with per capita spending of €35.2 on writing and drawing
material. In addition to this, various supermarkets which are located throughout the Europe
have a diverse stationery items (Shevlyakov and Smirnov, 2016). They are required to target
highly mass-market consumers instead of professional or premium good demanding people
such as expert retailers who diversify their product portfolio covers postal services, magazines,
newspapers, concert tickets, articles and diverse which are not easily available at the time
traditional stores.
Digitalization had introduced crucial changes which ultimately assist the organisation to
optimise the sales in an effective manner. By using online tools, cited organisation improves
the sales of their product in an effective manner. In addition to this, ascending employment rate
also enhanced consumption rate. The company also uses various tools which are used for
contributing for the economy. In addition to this, the main constraints which are faced by the
stationery distributors is vague global economic conditions which ultimately helps the Donald
Duque to cope up with the market fluctuations and emerging the demand by enhancing goods
quality and introducing innovation.
3

4

2.3 Analysis of Duque’s last three financial years of sales data
(2015-2017)
Refer appendix 1
For determining value of the total sales, sales of products captured in goods portfolio
that have been introduced. Here, sales trends are forecasted in an effective manner. During
2015,2016 and 2017, total sales are forecasted to be the €165000, €182000 & €178000 in a
crucial manner. This also has been assessed which sales revenue of the organisation which is
improved by 10.30% during 2016. On the other hand, sales value of Donald Duque is reduced
to (-2.20%) which demonstrates the reducing trends. This is rightly said that the sales revenue
is maximised and margin of profits needs to be formed for the unit needs to be done.
Mixed pie chart:
Assessment of pie chart, this is rightly said that Donald Duque low cost printers contributed
least percentage during 2016 and 2017. On the hand, printer cartridges accounted for 16%
during 2016 that would rise to 18% from the total sales.
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 €)
Correlation Coefficient is the tool which is implemented by the cited company which assess
link between two variables and years (Piekkari, Welch and Welch, 2014). This could be said
that coefficient correlation which is assumed to be elaborated as an efficient statistical tools
which could be used for identified link between two variables. Emergence of variables like as
year and sales. Henceforth, as range of .25 to .75 which are to be known as the moderate. For
evaluating the crucial, this could be crucially which are connected to the year.
Estimating sales trend for the period of 2018 and 2019:
Year Sales
2018 €6500x + €162000
= €6500 (4) + €162000
= €188000
2019 €6500x + €162000
= €6500 (5) + €162000
= €194500
6

2.4 Feasibility of Expanding to Germany & International Standards
a). Pros and Cons assessment
Pros Score/10 Cons Score/10
Client base improvements 9 Excessive staff turnover 5
Economies of scale in an
cost-efficient manner 8 Effect on quality 8
skillful personnel 7 Progressive capital demand 7
Relocation prospect 6 Non-achievement of
operational control 6
Total Pros 30 Total Cons 26
Pros refers to the advantages which have scored cons by (39-35)=4 point. Henceforth, net
results: total score of pros- cons= 30-26=4.
By initiating the key outcome, which is recommended that Donald Duque totally focus on the
expansion strategies. Addition to this, this is totally forecasted that the strategy regarding to the
expanding of business in Germany and Belgium that will enhance higher benefits (Ghilani,
2017). This helps in Germany and Belgium that will enhance to have higher benefits. This
ultimately helps the business for enhancing customer based and henceforth, profits and sales
that are highly effectively.
b). Defining international standards with which Donald Duque needs to comply:
For emerging effective efficient adequately organisation, managers are needed to implement
international standards. They are diverse types of standards that are associated with
organisation for rendering protective data. There are so many kinds of the standards which
have been layout via which European companies are going to comply for their organisation
activities. Further, these standards are linked with cited company are elaborated below:
ISO 14000 family-environmental management is a family of standards which are connected
to environmental management which currently to assist the firms in order to lower the side
effects, Such as- cause adverse changes to air, water, or land. This comply the applicable laws,
regulations and other environmentally oriented needs.
ISO 45001 Occupational health and safety: This is the main norm which is related to the
health and safety related norms (Holcomb, 2016). The main aim of the firm to assist the
organisations which would limit the workplace related risks and form a batter safety, and
effective working conditions all around the globe. This standard was formed by the committee
of the occupational health and safety specialists which limit this burden by rendering
framework in order to enhance employee safety throughout the planet.
7

ISO 31000 Risk Management: This is the family of standards which are related to the risk
management which are codified by the International organisation for standardization. The main
aim of ISO 31000:2009 is to renders principles and guidelines on the risk management. ISO
31000 requires to renders a universally approved paradigm for the practitioners and
organisations employing risk management processes to changes the myriad of current
standards, tools paradigms which differentiate between the industries, contents and regions.
Donald Duque is required to comply the Data Protection Act and according to the same
confidentiality requires to be mentioned.
Apart from that, Donald Duque requires adhere the quality standards at the time of production
and offering stationery goods to the consumers.
8

2.5 Costs of a New Building
a). Computing a 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
9

2.6 Mean Value of Orders
H0 (Null hypothesis): 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 assessing, this has been found that p value of Z score 0.23 which accounts for .59
significantly. This result shows that p esteem is more than as far as possible prefer 0.05. From
this time forward, by rising into record such viewpoint it can be expressed that invalid theory is
acknowledged and in the meantime other one rejected. Based on p esteem decided, it can be
involved that no measurable huge distinction happens between the mean estimations of
expected and genuine normal request esteem (De Muth, 2014). At the end of the day, one
might say that estimations of genuine and expected requests are moving comparative way.
10