Duque Papetiers Gros: Analysis of Market, Sales, and Expansion

This report analyzes the business of Duque Papetiers Gros, a company focused on wholesale trade, with a specific focus on the stationery market in Germany. The report delves into the market overview, including the competitive landscape and spending per capita on writing/drawing materials. It examines Duque's financial performance from 2015 to 2017, providing insights into sales trends and potential growth areas. The report evaluates the feasibility of expanding into the German market, considering international standards and associated costs. It includes an assessment of the mean value of orders and customer satisfaction levels. The report concludes with recommendations for the company's strategic direction, supported by data analysis and financial projections. The report also includes an analysis of the costs associated with a new building. The report uses various statistical methods to analyze the data and provide insights into the business's performance and potential for expansion. The report provides valuable insights into the stationery market in Germany and provides recommendations for future business strategies for Duque Papetiers Gros.

Report for Duque Papetiers Gros
Date:

Report for Duque Papetiers Gros 2018
Table of Contents
1.Introduction................................................................................................................................3
2.Analysis of Issues for Duque Papetiers Gros.............................................................................4
2.1 An Overview of the Wholesale Stationers Market in Germany.........................................4
2.2 Annual Spending on Writing/Drawing Materials per Capita.............................................5
2.3 Analysis of Duque’s last three financial years of sales data (2015-2017).........................6
2.4 Feasibility of Expanding to Germany & International Standards......................................7
2.5 Costs of a New Building....................................................................................................9
2.6 Mean Value of Orders......................................................................................................10
2.7 Customer Satisfaction......................................................................................................11
3.Conclusions..............................................................................................................................12
4.References................................................................................................................................13
5.Appendices...............................................................................................................................14
2

Report for Duque Papetiers Gros 2018
1. Introduction
In today's business world every organisation has to analyse data set so as to achieve
success in market. Owner of the business should use different statistical tools to analyse data of
its business. Process of evaluation of data is very significant approach for any business
organisation and it helps in making decisions for achieving its organisational goals. This report
is on a company named Duque Papetiers Gros which is having its business in Northern France.
The company lays more emphasis on wholesale trade rather than selling its product through
retail market. This business organisation offers different products that are printer, furniture,
general office items and furniture for general purpose. This report consist trends that are
prevailing in whole sale market in Germany. It also reflects the light on drawing material per
capita. At last how a graphical presentation helps in summarising data set is analysed.
3

Report for Duque Papetiers Gros 2018
2. Analysis of Issues for Duque Papetiers Gros
2.1 An Overview of the Wholesale Stationers Market in Germany
Germany is the leader in the global business of stationary market. Because of this
Various companies in Germany have entered into the stationary market of Germany (Bock,
2012). These companies incudes Stablio international GMBH, Leuchtturn Albenverlag, Ecu
line etc. they are providing best quality of product in the market at a economical price range.
As the above graph depicts that from 2005 there has been significant increase in the
number of supplies in office and stationery. Since 2009 and then to 2013 there has been a
decline in the upward trend that was followed previously. Focus of suppliers then turned into
offering innovative products to the customers. It will help the suppliers to meet customers
expectation level and work in a way that will make them achieve pre set goals of business
organisation. As Germany's market is increasing day by day the market growth and the sales
revenue increased during this period by 3.5%. After the entry of big retailers they have made
certain changes which have significant impact on this industry. These retailers are offering high
quality of products. The believe of them is that they should use labelled product and should
label their products in the market so that easy recognition can be done of their products. The
changing trend of making the product available through online helped them to increase their
turnover and expanding their market base. Hence Donald Duque should use online tools so as
to increase their sales revenue and would help them diversify the operations to different parts
of world.
4

Report for Duque Papetiers Gros 2018
2.2 Annual Spending on Writing/Drawing Materials per Capita
As analysed from the research it has been evaluated that customer’s spendings on
writing/drawing materials is €35.2. Germany secures 2nd position in the world for trading in
stationary products and France scores 4th position. The other European market involves
Austria, Bulgaria. Belgium,Cyprus, Denmark etc. The product collection and varieties of
product that are offered by the the market has helped them to attain this position. Also the aim
to create awareness between the consumers have helped them to influence the purchasing
decisions of customers (Bottomley, and et. al., 2016). Different approaches to advertisement
have also been taken into consideration that involves advertisement in newspapers, magazines
and television so as to promote the product and the brand.
The trend of e-commerce and digitalisation in the market has made significant influence
and a considerable shift towards the approach of product selling. If the products are offered
online they may help consumers in having high level of convenience. This is the main reason
that makes the mind of consumers to buy the product online rather than going to retail shops.
The e-commerce business has evolved by 17% approximately in these years. Because of this
retailers has made their mind to go through the process of online trading. As the current trend
in the market depicts that it will grow their business and will grow in the near future. The
negative trends that are in the market has been assessed and it shows that 11.7% of the
decreased trend. It is hampering the demand for drawing/writing materials.
5

Report for Duque Papetiers Gros 2018
2.3 Analysis of Duque’s last three financial years of sales data (2015-2017)
REFER APPENDIX 1 FOR BELOW ANALYSIS
To determine total sales of the company all the items that are included in the product
portfolio should be added. Also to analyse the suitability of turnover or trend scrutiny of
current year the data of previous year has also been taken (FernáNdez and et. al., 2013). The
total sales of the company for the years 2015, 2016 and 2017 accounted for €165,000,
€182,000, €178,000 accordingly. The sales figure of the company has increased to 12.3% in
the year 2016 as compared to decrease in the year 2.2%. This decrease in the sales of company
has been arrived because of decrease in demand of printer and general office supplies. So to
maximise the turnover and the profits of the company policies has to be created by the owners
of Duque Papetiers for both printers and office materials.
MIXED PIE CHART OF TURNOVER OF THE PREVIOUS 3 YEARS.
Sales figure of Daque Peptiers
printer cartridges general office supplies low-cost printers
office furniture shredders paper-based supplies
writing/drawing materials
CORRELATION OF CO-EFFICIENT THROUGH SCATTER PLOT
Years Turnover
2015 165,000.00
2016 182,000.00
2017 178,000.00
Correlation of co-efficient 0.73
6

Report for Duque Papetiers Gros 2018
Correlation is the best tool that helps in making effective data analysis. It co relates the
data of previous year with the data of current year and helps in knowing the variance. The
result of co-relation analysis helps in knowing the relationship between the sales and the profit
of the company for the year (Knoblauch and Schnettler, 2012). The best range of co relation
coefficient is .25 to .75. It is considered as best suited for the company. Analysing and
reviewing the outcome will help in expanding the business and will also influence its
operations.
ESTIMATED SALES FOR THE YEAR 2018 AND 2019 ACCORDING TO THE
PREVIOUS TRENDS
Year Sales
2018 € 65,00(x) + € 162,000
= € 65,00 (4) + € 162,000
= € 188,000
2019 € 65,00(x) + € 162,000
= € 65,00 (5) + € 162,000
= € 194,500
2.4 Feasibility of Expanding to Germany & International Standards
German market is the best market for operating the business of stationery. As this
market has the ability to provide a good turnover and increase the profit for any company who
wants to expand its business. As the country has a good demand for stationery products which
are based on certain factors which influence it. As this being a economically backed up country
and the GDP level is at good rate. It will help people of country to adequately afford the
stationary products and services that company provides to them. As most of the German
retailers need that they should have a reliable supplier which has the established brand name in
the country so that they can achieve the targeted sales. If the company expands its business in
the country than it will help them in a positive way so that they will be able to earn maximum
profits. The German markets are looking for brand that can give them a steady supply of the
products that they in. so it will be a important market place for the company to expand its
business their and earn maximum profits there.
The company has to follow certain International standards for operating their business
in the country. So the international standards that affects the business of the Duque Papetiers
are:
 ISO standard 45001: this is the standard that deals in occupational health and safety of
the workers working with the organisation. So it is the core responsibility of the
7

Report for Duque Papetiers Gros 2018
company to make proper arrangements regarding the health and safety of their
employees.
 ISO standard 14000: it is the standard that defines family environment management. So
the company has the responsibility to perform activity that will help in managing their
CSR and will operate their business according Eco friendly manner (Lisovski and
Hahn, 2012).
 ISO standard 31000: This standard deals in managing risk. An organisation should use
the risk management strategies so that if any risk occurs than this will help to tackle that
risk
 Also Duque Papetiers should comply with the standards that helps in maintaining the
quality of the product manufactured.
8

Report for Duque Papetiers Gros 2018
2.5 Costs of a New Building
Computing a monthly cost of 30-year repayment mortgage
Particulars Figures
Time 30 years
Loan reimbursement = Total loan amount € 21,215.85
Monthly reimbursement € 21,215.85 / 12
= € 1,767.98
Calculating monthly cost assuming that the interest is applied to the loan every month
Particulars Figures
Time period (n) 30 years * 12 months (annually) = 360
Interest rate per month (R) 10% / 12 = 0.00833
Monthly reimbursement € 21,215.85 / 360*12
= € 1,767.98
Monthly cost that company has to face for the expansion and construction of the
building would amount to approx. 1750 euros. If the company mortgages the building and use
it efficiently to cope up with this cost and earns the profit over and above this cost then it
would be helpful for the company to raise money through this. It is beneficial to the company
in a way that cost that is applied for the construction of the building is very high and would
lead to use of high resources (Lyons and Coyle, 2016). It is the best cost for the companies
who deals in stationery. The monthly basis cost works best for the company as well as the
owner of mortgage. It enables the company to work efficiently with the available resources that
are available to the company. The aspect that monthly payment is more efficient that yearly
payment would enable them to use the available resources correctly. Hence the calculation of
the cost of the building through application of mortgages can be more effective as compared to
other payment techniques.
9

Report for Duque Papetiers Gros 2018
2.6 Mean Value of Orders
No variation in the expected mean value and the order value average.
Particulars outcomes
Mean of the entire population 240
Sample Average 230
Standard deviation 43
Z score = (Mean of the entire population –
sample average) / standard deviation
(240 – 230) / 43
= 10 / 43
= 0.23
it is assessed that the mean value of the company is .23. the standard limit of mean
deviation is accounted for .5. As it is greater this forecast a positive outcome. The application
of the method helps the company provides them the estimate of the expected figures. The
calculation helps Donald Duque to establish the future plans so as to achieve the overall
organisation objectives (Merelli and et. al., 2014). This figure would help the company to
create a better future sales figure. As the company would be able to create a huge number of
orders that will enable them to expand their turnover.
10

Report for Duque Papetiers Gros 2018
2.7 Customer Satisfaction
To make the profits and to increase the demand of their products by satisfying the
customer Donald Duque conducts surveys every year. So for seeking feedback about the
products from the customers the company sends questionnaires. They uses various forms of
sending the questionnaire (Silverman, 2016). Which includes e-mails, and pamphlets. However
the customer response to the emails are relatively low that is around 5%. it has been analysed
that the customers are not sending the questionnaire filled fully. So the company to increase the
responsive rate of the feedback should use different techniques. By providing them the
incentives and giving them the reasons that will help in making the product best suited to the
customers will help them to increase the response rate for the questionnaire.
Particulars CUST. SERV. QUAL. P&S SALES STAFF PRICE VALUE
Mean 3.5 3.15 3.45 1.95
Standard Error 0.17 0.08 0.18 0.11
Median 4 3 4 2
Mode 4 3 4 2
Standard
Deviation
0.76 0.37 0.83 0.51
Evaluation: it has been concluded from the above table that customer service and the
quality p&s is good and up to mark for the company. It is given that mean of the price value is
1.95 and the standard deviation is .51 which is fair and not good. It can be depicted that mental
representation of customer does not vary significantly in accordance with ratings given. On the
basis of outcomes it is evaluated that Donald Duque lays emphasis more on the controlling
cost. This will help the company to provide consumers with best products at a economical price
and will help them to raise the satisfaction level.
11

Report for Duque Papetiers Gros 2018
3. Conclusions
It has been concluded from the report that by doing the activities the company has made a
positive brand image. The sales of the company should of the last 3 years helps the
company to know its future direction. It is essential for the company to involve several
factors that will help in creating future goals. As a total of 20 questionnaire returned from
consumers (Taguchi, 2012). These questionnaire helped the company to know the position
of its brand in the market. Expansion of the company depends on different factors which
requires the understanding of the fact that limited options are their so as to develop
strategies of expansion. As in the case Duque Papetiers should use these tools so that they
are able to expand their business and achieve the target of increase in sales.
12