Business Data Analysis Report for Duque Papetiers Gros (France)

This report provides a comprehensive business analysis of Duque Papetiers Gros, a small family-owned stationary business in Northern France. The analysis begins with an overview of the wholesale stationers market in Germany, followed by an examination of annual spending on writing and drawing ...Read More

Duque Papetiers Gros

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
An Overview of the Wholesale Stationers Market in Germany..................................................1
TASK 2............................................................................................................................................2
Annual spending on writing/drawing materials per capita in precisely seven European
countries in 2015..........................................................................................................................2
TASK 3............................................................................................................................................2
a. Sales assessment......................................................................................................................2
b. Presenting data set through pie graph......................................................................................3
c. Computation of correlation and graphical presentation of data set.........................................3
d. Making forecast for the sales of 2018 and 2019......................................................................4
TASK 4............................................................................................................................................4
a. Pros and cons of expansion......................................................................................................4
b) International standard..............................................................................................................5
TASK 5............................................................................................................................................6
a. Assessing monthly cost of 30 year repayment mortgage.........................................................6
b. Determining monthly repayment amount................................................................................6
TASK 6............................................................................................................................................7
Hypothesis testing at 5% significance level................................................................................7
TASK 7............................................................................................................................................7
a. Presenting ways to improve survey response..........................................................................7
b. Analysing data set gathered through survey............................................................................8
TASK 8............................................................................................................................................9
Summarizing findings..................................................................................................................9
REFERENCES..............................................................................................................................11
APPENDIX....................................................................................................................................12

INTRODUCTION
The stationary market within Germany is very large as compared to any country of world
as this will be providing world-class stationary items throughout all nations. In the same was
Duque Papetiers Gros is a small family stationary into the Northern France but owner is knowing
nothing about importance of business data analysis. As it is very much essential to keep all track
of books of accounts so that they could be making better decision making process. The current
report will be based on Duque Papetiers Gros with reviewing the wholesale stationers market
into Germany, annual spending on stationary materials will be briefly explained and then few
international standards will be applied upon this.
TASK 1
An Overview of the Wholesale Stationers Market in Germany
Stationary items are very much helpful which will allow all to write a draw with the help
of various items and things including like that of paper and other paper related products. The
biggest market of stationary includes that of Germany which is also largest producer and seller
the industry includes €14.8 billion. This includes that there is highest share of drawing materials
will be spent into Germany only which is about €35.2 which is based on individual person only
and higher than any other European country. This increasing trend will be because of positive
attitude of all companies of Germany which is having about 70% of total global brands into
country only (Baker, 2017). All these major global brands will be having or experiencing
increased into their sales in the year 2015. In between the year 2014-2015 the total turnover of
branded stationery increased to about 3.5% with this increase of domestic demand to 2.5% and
international demand to 5%.
There will also be showing all potential trends and development within the market all
over Germany which is mainly due to positive image of German stationery in both writing and
general instruments. All the private firms or brands gained significantly important or wider
strength into market as it is having very good image into market against the private labels. There
will also be having wider range of products available and which would be having different
developments and challenges. The products includes like that of paper, paper related like that of
document folders that could be continued in having declining path of turnover and product would
be suffering.
1

TASK 2
Annual spending on writing/drawing materials per capita in precisely seven European countries
in 2015
The annual sale of seven of the EU nations indicate that Czech Republic is having the
lowest among all of them which is about 7.6 only while that of Croatia is 7.9 based on per capita
or per person as well. It could also be said that that Germany is having one of the highest among
all which is 35.2 per capita and that of France is 28.3. While in terms of money highest earning
among all the nations is that of Switzerland that is €35, Spain is that of 8.9 then towards last that
of Poland is only 8.5 as included by per capita.
Figure 1: Annual spending on writing/drawing materials per capita
TASK 3
a. Sales assessment
(Mentioned in appendix 1)
As per the sales assessment it could be concluded that there is decreased into sales in
2017 as compared to that of 2016. As the sales in 2016 are 10.3% while in 2017 it decreased to -
2.2% which is very much low. The sales of each items are decreasing in year 2017 like that of
printers, general office suppliers while only that of writing materials sales are increasing from
2015 to 2016 to 2017.
2

b. Presenting data set through pie graph
Figure 2: pie graph
c. Computation of correlation and graphical presentation of data set
Correlation co-efficient may be served as a statistical measure which assists in
determining relationship takes place between two or more variables. The below depicted table
shows that moderate level of relation exist between years and sales. On the basis of such aspect
total sales level will be inclined moderately over the years.
Year Total sales (in €)
2015 165,000.00
2016 182,000.00
2017 178,000.00
Correlation between year and total sales 0.73
3

d. Making forecast for the sales of 2018 and 2019
As per the scatter diagram:
Equation: €6500 x + €162000
For the Year 2018:
€6500 x + €162000
= €6500 (4) + €162000
= €188000
For the Year 2019:
€6500 x + €162000
= €6500 (5) + €162000
= €194500
TASK 4
a. Pros and cons of expansion
Pros Score/10 Cons Score/10
Customer base increase 6 Influence of government 10
Profits increased 8 Huge cost 9
Increase in turnover 9 Lack of effective workforce 6
Developing competitive
advantages 6 Impact of other language
and culture 5
4

Total Pros 29 Total Cons 30
Average Pros 7.25 Average Cons 7.5
As from the table it could be concluded that there are more number of cons which is more
disadvantage for company expanding into Germany and Belgium which is 30 as this means that
company should not be expanding into these countries. Due to more number of lack of workforce
and intervention of other countries government.
b) International standard
The International Organisation for standardisation ISO is that body which is composed of
many representatives from all type of standard organisation that was founded on 1947. This
organisation is promoting industrial and commercial standard working for about 162 nations of
world (de Prato and Paul Simon, 2014). There are number of standards which need to be
considered at time of conducting business and operations of firm while they are internationally
doing their operations. The main reason will be that of protecting end users for products and
services into way of ensuring that certified products conform to minimum standards set on
international level.
ISO will be creating document that provided requirements and guidelines or
characteristic that would be using consistently in ensuring that all services and products that are
fitting for the purpose. There are 22436 published international standards that are buying for
member of ISO standards. The most important type of standards that need to be complied with
the European companies and that would be impacting the activities of Duque that is as follows:
ISO 14001 Environmental management-
This is that international standard provides practical tool that is organisation for the
managing of their international environmental responsibilities as well. This standard family is
providing the support of standards in way of focusing on the specified approach like that of life
cycle, communication, audits and labelling (ISO 14000 family - Environmental management,
2018). There will be development of technical committee so that management of the operating
system could be easily taken over.
ISO 3166 Country codes-
International standard for the country code in way of subdivision as well as this will be
defined to as international code for telling on the name for companies. The code will be not
5

including any type of error with the use of name of company into any nation while depending
upon the language that is used with having domain name of companies. There will be specified
machines which are having passports, code for the person and where they are belonging to so
that they could be easily sending and receiving money.
ISO 26000 Social responsibility-
This is very much important type of standard that all companies international or on
national level need to be followed. As there is no organisation that is operating into vacuum this
means that they need to look forward for the relationship between that of society and
environment as well (Martinez, 2004). So this standard is looking for transparent and ethical in
contribution with health and welfare of society or community as well.
TASK 5
a. Assessing monthly cost of 30 year repayment mortgage
Assumption: Interest rate is applied annually
Time period: 30 years
Loan payment: Total loan amount / discounting factor
=
= € 21215.85
Monthly repayment: Loan payment amount / 12
€ 21215.85 / 12
= €1767.98
b. Determining monthly repayment amount
Assumption: Interest rate is applied monthly
Given that:
Time period (n): 30 years
Number of payments: 30* 12 months (each year) = 360 times
Interest rate: 12% per annum
Interest rate per month: 10% / 12 = 0.00833
Monthly repayment
6

TASK 6
Hypothesis testing at 5% significance level
H0 (Null hypothesis): There is no significant difference in the mean order value of expected and
actual figures.
H1 (alternative hypothesis): There is a significant difference in the mean order value of expected
and actual figures.
Average (entire population) = 240
Average of Sample: 230
Standard deviation (SD): 43
Z score: (240 – 230 ) / 43
= 10 / 43
= 0.23
By applying statistical tools on data set it has found that null hypothesis is true as
compared to the alternative. Moreover, Z score implies for .23 respectively which in turn higher
than standard value such as 0.05. Referring such result it can be stated that both actual and
expected order values are same to the significant level. Hence, statistically firm’s estimation
regarding order value is appropriate significantly.
TASK 7
a. Presenting ways to improve survey response
On the basis of given scenario, Duque is facing issues in getting responses from the
respondents. Moreover, majority of the respondent approximately 95% are not filling
questionnaire properly. Due to this, manager of Duque is facing problems in assessing needs,
wants and expectations of target market. Hence, there are several strategies which can be
undertaken by Duque’s manager for improving survey’s response.
 By developing short and specific questionnaire Duque can generate positive survey
results. In other words, by including relevant questions regarding product, price,
promotion etc Duque can enhance the interest level of respondents and thereby would
become able to improve survey response.
7

 Further, emphasis needs to be placed on taking prior consent from respondents. Through
this, Duque can create effectual image in the mind of respondents and thereby improves
response rate.
 Business can also resolve such concerned issue by providing respondents with gifts,
financial and non-monetary incentives (4 effective methods to improve survey response,
2018).
 Through sending notifications via e-mail business unit can infirm respondents about due
date and motive behind initiating survey.
Thus, by undertaking all the above depicted measures Duque’s can improve survey response
rate to a great extent and thereby become able to develop competent framework for the near
future.
b. Analysing data set gathered through survey
For the purpose of taking appropriate strategic decisions questions pertaining to customer
service, quality of product, sales staff as well as price & value has been asked to the respondents.
Hence, primary data gathered through survey is enumerated below:
Survey response
ID CUST_SERV QUAL_P&S SALES_STAFF PRICE_VALUE
1 3 3 3 3
2 3 3 3 2
3 4 4 4 2
4 4 3 4 1
5 2 3 2 2
6 4 4 4 2
7 4 3 4 2
8 4 3 4 2
9 2 3 2 2
10 4 3 4 1
11 4 3 4 2
12 4 3 4 2
13 4 3 4 2
14 4 3 4 1
15 2 3 2 2
16 4 3 4 2
8

17 4 4 4 2
18 3 3 3 3
19 4 3 4 2
20 3 3 2 2
Descriptive statistics
Customer
service QUAL_P&S
Sales team or
staff Price value
Mean 3.5 3.15 3.45 1.95
Median 4 3 4 2
Mode 4 3 4 2
Standard
Deviation 0.76 0.37 0.83 0.51
Minimum 2 3 2 1
Maximum 4 4 4 3
Descriptive statistics mentioned above clearly shows that average number of respondents
rated quality of services and sales staff as good. Further, pertaining to the variable customer
service, mean, mode and median is 4 respectively. It shows that, majority of respondents entailed
Duque provides its customers with excellent customer service. However, under the category of
price and value responses are 2. On the basis of this, it can be presented that customers are not
highly satisfied with the pricing strategies undertaken by Duque. Thus, for evolving satisfaction
among the customers Duque needs to make modifications in the existing pricing strategy. This in
turn helps firm in evolving satisfaction among the customers and contributes in success
attainment.
TASK 8
Summarizing findings
By summing up this report, it has been concluded that wholesale stationery market of
Germany is growing with the very high pace. Business entities are placing high level of emphasis
on offering quality products or services to the customers. Hence, by offering innovative products
and focusing on online mode wholesale stationers can gain competitive edge over others. It can
be summarized from the evaluation that strategy pertaining to expansion of business in Germany
will prove to be more profitable for Duque. It can be stated from the report that Duque needs to
comply with international laws and legislation while carry out operations globally.
9

REFERENCES
Books and Journals:
Baker, J., 2017. The Physical Marketplace. In The Business of Satirical Prints in Late-Georgian
England (pp. 125-148). Palgrave Macmillan, Cham.
de Prato, G. and Paul Simon, J., 2014. Public policies and government interventions in the book
publishing industry. Info, 16(2), pp.47-66.
Martinez, J.M., 2004. International Organisation for Standardisation, ISO (Vol. 80). IEC
JTC1/SC29/WG11, Coding of Moving Pictures and Audio, Palma de Mallorca.
Online:
4 effective methods to improve survey response. 2018. [Online]. Available through:
<https://blog.marketo.com/2017/01/4-effective-methods-to-increase-your-survey-
response-rates.html>.
ISO 14000 family - Environmental management. 2018. [Online]. Available through:
<https://www.iso.org/iso-14001-environmental-management.html>.
10

APPENDIX
11