Duque Report

This report analyzes the wholesale stationery market in Germany, focusing on Duque Pertiers Gros, a stationery business in Northern France. It examines sales trends, annual spending, and the feasibility of expanding into Germany and Belgium. The report also explores international standards relevant to the business and methods for improving consumer survey response rates. Desklib provides past papers and solved assignments for students.

DUQUE REPORT

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
2.1 Overview of wholesale stationery market in Germany..........................................................1
2.2 Annual Spending on drawing and writing materials per capita.............................................2
2.3 Analysing sales of last three consecutive years of 2015 to 2017...........................................3
Mixed Pie chart............................................................................................................................3
Correlation coefficient of year and total sales.............................................................................3
Predicting sales of 2018 and 2019...............................................................................................4
a. Sales of 2018 when x is 4.........................................................................................................4
b. Sales of 2019 when x is 5........................................................................................................4
2.4 Specifying feasibility for expansion in Germany and International standards......................4
Cons and pros of business expansion in Belgium and Germany.................................................4
International standards.................................................................................................................5
2.5 Representing cost of new building.........................................................................................7
Recalculating monthly cost with use of interest loan at every month.........................................7
2.6 Mean value of particular order...............................................................................................7
2.7 Specifying level of consumer satisfaction and method for improving response of consumer
survey rate....................................................................................................................................8
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10
APPENDIX....................................................................................................................................11

INTRODUCTION
The Duque Pertiers Gros is stationery business in Northern France whose owner is Donal
Duque. The main objective of his business is built popular customer base which is more than 50
years ago as he does not sell its product to direct consumers. The present report would be
providing brief of overview of Wholesale stationery market in Germany and appropriate analysis
of sales of each item of year 2015 to 2017 with reference to mixed pie chart and scatter plot as
well. This report will be giving graphical analysis of annual spending of 7 European countries
and it will be assessing merits and disadvantages of business expansion in Belgium and Germany
and forecast sales of year 2018 and 2019. Furthermore, it will be specifying international
standards which should be complied by Donald Duque and methods for improving consumer
responsive rate.
2.1 Overview of wholesale stationery market in Germany
The stationery industry is well positioned in Germany. As per trade association for
writing and drawing materials has total turnover which is more than €14.8 billion per year and in
which spending of every individual is equal as €182 annually. Here €35.2 is spent on these
writing and drawing material of Germany as it is second leading position with context of
spending for stationery among various European union countries. The consumers had shown
positive attitude towards companies which comprises in stationery industry as it is more than
70% of brands had increment in sales in year 2015. The association of German stationery brands
has presence of total turnover of this specific industry had attained growth about 3.5% among
year 2014 and 2015. This outcome had been undertaken with increment in domestic and
international demand by 2.5% and 5% respectively (Germany – A Potential Stationery Market,
2016).
In the similar aspect, it trends and potentials are in different forms as German stationery
brands had gained best brand image through world. With context to writing and general
instruments had grabbed significant market share which are against various private labels.
Consequently, this industry is also having various issues especially in paper and paper related
products as they are declining due to introduction of digitisation in work and private place as
well. Simultaneously, these document folders and office supplies and instruments of writing are
growing with 5% in year 2015.
1

2.2 Annual Spending on drawing and writing materials per capita
European Countries Annual spending
Switzerland 35.5
Austria 35
Slovenia 20.4
Hungary 9.6
Germany 35.2
France 28.3
Italy 18.6
Switzerland
Germany
Austria
France
Slovenia
Italy
Hungary
0 5 10 15 20 25 30 35 40
35.5
35.2
35
28.3
20.4
18.6
9.6
Annual spendings in European countries
Annual spending
Interpretation: The above graph is showing annual spending of writing and drawing
materials in these European countries. It has been observed that Switzerland is leading in these
countries as 35.5 where Germany is giving itself cut throat competition by 35.2. Germany
comprises very important sector in the present economy. After Germany, Austria and France are
contributing for annual spendings for drawing and writing materials per capital.
The demand of Germany has been accomplished which is directly driven for propensity
of consumption for purpose of investing in private and commercial customers. In the similar
aspect, Germany has attained economic growth and positioned itself by 35.2 in 2015 with 17%
2

as GDP. The mitigation rate of Germany has adverse effects with various reliable estimation
because of unavailability.
2.3 Analysing sales of last three consecutive years of 2015 to 2017
(Table in appendix)
The Duque's operation in international market of year 2015 to 2017 has essential function
with appropriate explanation of organization. In the present scenario, it has various factors which
are used for setting various objectives. It had been observed that sales of printer cartridges raise
with 4% but in 2017 it had shown negative effect of 15.38%. The main reason behind this was
stated as general office supplies with proper understanding of margin in these two years but at
last it was getting losses. Consequently, low cost printers were increasing by 20% in 2016 but in
2017 it was complacent.
The office furniture's sales had faced increment in 2017 from 8% as shredders cost was
stable in years as after, initial sales Duque practice has faced different complexities.
Furthermore, there was raise in paper based supplies by 8% in 2016 and no change in next year.
The important concern is about writing and drawing material is 20% in 2016 and very small
proportion as 6.67% in 2017. Hence, it could be stated that evolution in 2016 had gained
increment in sales by 10.30% and in 2016 it was -2.20%.
Mixed Pie chart
3

Correlation coefficient of year and total sales
Year 2015 2016 2017
Total Sales 165000 182000 178000
Correlation Coefficient: 0.73
Interpretation: The above graph is showing correlation coefficient among total sales and
year. It has specified range of low, moderate and high correlation as in this its outcome is as 0.73
which comes in second range of 0.25 to 0.75. Thus, it is said as moderate which could be
interpreted that both sales and year would be moving with positive aspect for better future.
Predicting sales of 2018 and 2019
a. Sales of 2018 when x is 4
6500x + 162000
6500*4 + 16200 = 188000
b. Sales of 2019 when x is 5
6500x + 162000
6500*5 + 16200 = 194500
2.4 Specifying feasibility for expansion in Germany and International standards
Cons and pros of business expansion in Belgium and Germany
4

Business Expansion (Belgium and Germany)
Pros Score (out of 10) Cons Score (out of 10)
Economies of scale 8
Outcome on quality or
degrading 6
Reallocating
possibilities 9
Inadequacy in
operational control 7
Encouraging customer
base 8
Huge employee
turnover 7
Talented and
knowledgeable
personnel 9 Want of high capital 7
Total Pros 34 Total Cons 27
Average Pros 8.5 Average Cons 6.75
Outcome for expansion: Sum of pros- Sum of cons
= 34 – 27
= 7
Interpretation: The above tabular presentation is specifying score of advantages and
disadvantages for business expansion in Belgium and Germany. While evaluating its score, it
advantages are on basis of economies of scale, reallocating possibilities, qualified personnel and
to encourage customer base with aggregate of 34 out of 40. On the contrary, it has reflected
different disadvantages with its score which are degrading quality, inadequate operational
control, high employee turnover and with want of huge capital as well with sum of 27 out of 40.
Further, its net outcome with combination of pros and cons as 7 which is positive as it is
indicator for supporting this business expansion in Belgium and Germany.
5

International standards
In the present era, there is presence of various standards which are necessarily to be
implied in European countries with context of its roles and activities. The international standards
which are directly associated with Duque's operation are stated below:
International standards Description
ISO 900 Quality
Management
This standard is giving various other aspects on basis of
managing quality which also includes best ISO standards. It gives
proper guidance for organization with context of en-surety about
products and services in consistent aspect for attaining various
other need of customer as it is improved.
ISO 14000 family-
Environmental management
In this standard, it has described different tools for companies to
manage it via different responsibility of environment. It is giving
emphasis on system of environment for accomplishing various
approach of auditing, communication, labelling and to analyse the
life cycle. Further, it will be focussing on challenges related to
environment such as climate change (International Organization
for Standardization, 2018).
ISO 31000 Risk
Management
It would be providing help to business entity for purpose of
raising likelihood for accomplishing its objectives and
determining opportunities along with various threats. In the
similar aspect, its resources will be effectively allocated with
application of managing risk.
ISO 26000 Social
responsibility
This specific standard will be giving guidelines about business
and companies for operating in socially responsible method. In
simple words, it could be replicated as transparent and ethical
with huge contribution to safety and health of society.
ISO 45001 Occupational
health and safety
This standard was developed with need of business entity which
will be reducing burden for giving framework for improving
employee safety and workplace risk is decreased and creates
6

better and safer working condition over world.
ISO 50001 energy
management
It supports each sector organizations with application of energy in
efficient aspect via development of proper energy management
system. It gives framework for developing policy to fix targets
and objectives for accomplishing its policies. In the similar
aspect, it will be measuring the outcome as review about every
policy.
Data Protection act Duque will be complying with this act as requirement for proper
maintenance about privacy and confidentiality.
2.5 Representing cost of new building
Recalculating monthly cost with use of interest loan at every month
7

2.6 Mean value of particular order
H0 – Null hypothesis: There is no significance variation in expected and actual average value of
order.
H1 – Alternative hypothesis: There is significance variation in expected and actual average
value of order.
Parameters Outcome
Average of population 240
Sample Average 230
(SD) Standard deviation 43
Z Score assessment
[ (Average of population – Sample Average) / (SD)standard deviation ]
(240 – 23)/43 = 10/43
= 0.23
Interpretation: The above table is performing Z score assessment for extracting mean
value of specific orders with aim of choosing appropriate hypothesis. The outcome has been
fully assessed on basis of P value. The main objective of acceptive hypothesis is with p value in
numerical format. In case if p value is higher than 0.05 then there will be acceptance of null
hypothesis and lower than 0.05 then acceptance of alternative hypothesis. In this assessment of Z
score, its result is 0.23 which is clearly viewed that greater than 0.05 then acceptance of null
hypothesis. Further, it could be justified that there is presence of difference in expected and
actual average value of mean and in simple words, both order moves in similar direction (Wang
and et.al., 2017).
2.7 Specifying level of consumer satisfaction and method for improving response of consumer
survey rate
The consumer responsive rate would be improved with various methods such as
evaluating feedback on regular aspect within 24 hours after delivery. There must be application
of various channel such as text messages, email surveys and it should be short because long
surveys bore the respondents and reduces responsive rate as well. In the similar aspect, it should
not be associated with incentive because it will give vague outcome. Further, the target audience
must be motivated and in questions of survey must include attractive designs and graphics which
8

will be creating excitement for questionnaire. There should be reminder but only one as
responsive rate will be boost with it.
The main aspect for survey is that respondents must be thanked for time and motivated
for completing the survey. In the same series, they should be informed with objective of that
survey with its use and how it will be implied in practical. Moreover, survey must be customised
for raising response rate along with various human dimensions, invitation for response as well
(Techniques for improving survey response rates, 2018).
Descriptive statistics of questionnaires
Interpretation: The above outcome has been articulated with 20 questionnaires with
context of primary data as it average of customer service is 1.95 exhibited from customer views.
In the similar aspect, its standard deviation is 0.51 which signifies less risk movement with level
of consumer perception without showing average participants.
CONCLUSION
From the above report it had been concluded that Germany has various opportunities in
this stationery market especially in writing and drawing materials. It has shown that Switzerland
and Germany are facing cut throat competition in annual spending among European countries.
Further, stationery suppliers will be giving major importance for diversification with quality of
product along with range as well. It had been articulated that Duque would be attaining success
with appropriate consideration of outcome with its desired level and exploration of business
operation in various countries such as Belgium and Germany would be highly beneficial. It could
be summarised that Duque will be laying special emphasis on various and unique pricing policy
which helps in attaining competitive edge and margin for purpose of influencing consumer's
decision making.
9

REFERENCES
Books and Journals
Riley, V., 2018. Operator reliance on automation: Theory and data. In Automation and human
performance (pp. 39-56). Routledge.
Wang, Z. and et.al., 2017. Voltage fault diagnosis and prognosis of battery systems based on
entropy and Z-score for electric vehicles. Applied energy. 196. pp.289-302.
ONLINE
Germany – A Potential Stationery Market. 2016. [Online]. Available through:
<http://www.malaysia.ahk.de/fileadmin/ahk_malaysia/Perspectives/MGC047-
Mar.Apr16_iPAD.pdf>.
International Organization for Standardization. 2018. [Online]. Available through:
<https://www.iso.org/home.html>.
Techniques for improving survey response rates. 2018. [Online]. Available through
<https://www.mtab.com/techniques-for-improving-survey-response-rates/>.
10

APPENDIX
11