Analyzing Information and Data for Problem Solving

This report analyzes the potential for Duque Papetiers Gros to expand its business into Germany. It examines the German wholesale stationery market, including its size, growth, and key players. The report also analyzes the company's financial performance and customer satisfaction data to identify areas for improvement. Finally, it provides recommendations for increasing consumer response rates and complying with international standards.

Analyzing Information and Data
for Problem Solving

1. INTRODUCTION
For expansion of a enterprise first and for most requirement is to determined the
potential market place where expansion needs to done. This requires a hight level of analysis
which is carried out with significant tool and techniques. The financial analysis for an
organisation is carried to determine and evaluate performance of the business in a given period.
In the present report the information is penned for Duque Papetiers Gros who wants to grow
its commercial enterprise in Germany which is operating in Northern France. The overview of
German wholesale market is presented along with determination pros and cons to expand
business in Belgium and Germany. Advise is also presented for enhancements in getting reposes
from consumers.
1

2. ANALYSING PROBLEMS FACED BY DUQUE PAPETIERS GROS
2.1 wholesale stationers market in Germany- an overview
In the Germany the stationary industry is well positioned and is operation in good
conditions. The German stationary industry is also one of the sector which contributes to German
economy. The current sales revenue of this industry is determined as more than £14.8 billion
every year and out of this over £35.2 is spent on purchases writing and drawing material. The
companies in this industry have a positive attitude lead to the fact that more than 70% companies
have experiences a boost in sales for year 2015. The German stationary industry is being
experiencing a boost in the demand both domestic and international from past 2-3 years. The
stationary brands form German industry have a good reputation in the country as well as in the
world (Marsden and Shahtout, 2014. These have gained a significant portion in the market
against private brands. With this certain developments challenges also been faced buy the
industry such as for paper and paper related products as world is inclining towards digitization.
The wholesale market of Germany consists of 5500 specialist retailer and most of them
have a net turnover of less than €250000. According to facts presented by Trade Association for
Office Supply and Writing Materials (HBS) the stationary products of Germany are easily
recognized with their brand name and labels and their quality of product offered by German
Brands. The developments of trend in this industry is been experienced by people through
enhancement in creativity which leads to increase in the damned for products such as painting
and drawing materials. There is an above average growth of these articles which serves as a
system which crubs use of digital products. This can be stated for German Stationary industry
that the wholesaler are in lesser number as compared to number to retailers in the industry at
2200 and 5500 receptively. The reason behind reduction in number of wholesaler is merger with
other companies and operation on lower level.
1

2.2 Annual per capita spending on Writing/drawing materials
Interpretation:
From the above graph is can be clearly seen that Germany is on second number in the
world having per capita spending on writing and drawing material. The different from number
one country is just .03 from Switzerland having per capita spending of 35.5.
With this can be stated that the demand of German stationary products is increasing in the
domestic as well as international market. It comes in top player or influence of worlds
wholesales stationary industry. The market get erected buy the economic condition and
Germany was the best performer in year 2105 in economic market. Reason behind this being at
growth in GDP rate by 1.7%. The employment rate is more has 50% for German stationary
industry.
The second nation for which per capita investment in drawing and writing material is
compared is France. The nation where out target company is operating. This nation comes 4 in
this list one number after Germany (Koo and Li, 2016). In France the per capita spending is 28.3
as compared to Germany with 35.2.s the different is huge for France it will take time to reach the
level of Germany. The top player in this filed is Switzerland and the nation on third place is
Austria. With this it can be significantly stated that France is in developing position and gaining
comment over the market and Germany is in a position that can reach to number rank any time in
coming time. The ideas of expansion in Germany is good and can be proceeded with as position
of the company is on second and it can lead to top level in near future. The main problem that
1

has been identified for restricting the rapid growth of German industry is the low level of birth
rate in the nation.
1

2.3 Analysis of financial sales data of Dauque for last three years
1. Computation of total sales:
The calculation for total sales is direct as all the revenues for various sales products from
portfolio has been added for each year. The total sales 3 years is calculated as :
Year Total sales in €
2015 165000
2016 182000
2017 178000
This can be seen from the table that sales for years 2016 have increased by 23000 which
amount to 10.3% hike in sales from previous year i.e. 2015. in the next year, total sales fell
down by 4000 which amount to a 2.2% reduction in sales revenue from last year, 2016. this
reduction as due to lesser sales of two products print cartridges and general office supplier.2. Mixed pie chart:
1

3. Computation of associated correlation coefficient:
A coefficient correlation is a statistical tool which is used to establish a relation between
two variables from same category. The resultant of this calculation reflects the level of relation
between variable which in present case is years and amount of sales revenues (Kristoufek,
2014). The moderate level of correlation is considered when it falls with in rage of .25 to .75. for
the present case the correlation is moderate and this reflects the revenue generated from sales of
various stationary products for 3 years, 2015-2017.
4. Forecast of the total sales for 2018 and 2019:
1

2.4 Feasibility of expanding in Germany and international standards
A) determination of pros mad cons of expansion decision:
Expansion criteria of business to Belgium & Germany?
Pros Score/10 Cons Score/10
An expanded reach to
consumer worldwide 9 Effect on domestic sales 5
Enhances contribution to GDP
and national economy 9 Complacence with
international regulation 7
Increment in Innovation 7 Effect on Working capital
requirement 7
Boost in international brand
image 6 Need of excessive and skill
labor and staff 9
Total Pros 31 Total Cons 28
Interpretation:
The total outcome of pros and cons can be calculated as
31-28= 3
With this it can be articulated that expand the business in Germany can be good decision as with
the evaluation conducted in above table it is clearly seen that this will benefit the company.
B) List of the Internationale standard to be complied by the organisation:1. ISO\IEC 17025 testing and laboratories:
This is the stander that Duque Papetiers Gros must comply with in order to stats the fact
that no harmful ink or any other material is being used in manufacture of the all the products of
the company.2. ISO900 1 Quality management:
This is a standard which must be abide all organization irrespective of their size ans
scope of business. All the strategies, tools and techniques must be followed as when requires to
cope with a situation.3. ISO 31000 Risk management
For management of risk that evolves during internationals operation. These standers are
formed for each and every organisation operating in international markets and all must abide by
it. 4. SO 26000 Social responsibility
1

Every organisation has a social responsibility oft the nation, community and society
where its operates (International Organization for Standardization, 2018) . Duque Papetiers
Gros must adherer to all the regulation stated in this standard in order to avoid legal consensuses.5. ISO 45001 Occupational health and safety:
For every nation there is a national health and safety act and in international business
operation have employee from all around the world this standard has been developed to ensure
health and safety of all the employees, workers and labor at workplace of Duque Papetiers Gros.
1

2.5 Commutation of cost incurred on new building
A) Calculation of monthly installments for repayment of loan over a period of 30 years:
Repayment time Loan payment Monthly installments
30 years Total of Loan amount
discounting factor
= € 21215.85
21215.85
12
= 1767.98
B) Calculation of monthly cost
Time
period
(n)
Interest rate
per month
(R )
Month wise payment
30
years
*12
month
= 360
10% /12
= .00833
1

2.6 Calculation of mean value of orders
H0 (Null hypothesis): There is statistical significant difference in the mean value of
actual average order value in terms expected.
H1 (alternative hypothesis): There is a statistical significant difference in the mean
value actual average order of in terms of expected.
Interpretation:
For authenticity of alternative hypothesis is that is must be equal or under 0.05. For the
above table the results came out to be .023 which is higher than 0.05 this can be stated that both
expected and actual order values are moving in same direction and this gives authenticity to null
hypothesis. There is no statistical important deviation in mean value of actual average order
value in terms of expected.
1

2.7 Determination of consumer satisfaction
A) Advise to increase the response from consumers:
The prime issue for not getting responses from majority of the consumers is that
questionnaires are sent in month of December that to through email. Most of the people in
present days do not check the advertisement or promotional mails, and at a large unsubscribe
such email subscription (40 Brilliant Ways To Increase Survey Response Rates, 2018).. Another
reason is that it s sent at last month of the year which is a month of holidays around the world. So
people do not check the mails and in case if saw it do not care to feel and send them back. For
the year a fall in 5% is in getting response from consumers. The company Duque Papetiers Gros
can enhance the rate of responses by sending questionnaire through different means or can attach
incentive for filling in the response.
B) Calculation of mean median, mode, standard deviation and error:
Interpretation:
From the table above it can be sDuque Papetiers Gros.interpreted that response of
consumers over supportive service was best with a highest mean vale. And with the lowest mean
of 1.95 the price values of products gets poor review from customers. For quality of the product
it was fair and fro sales staff responses were mixed but in positive manner. The standard
deviation is hight for sales staff as the responses for this were fluctuation and mixed. For price
value of money SD is also lowest at 0.51. with this can be stated that company needs to make its
product worth the price charged.
1

1

3. CONCLUSION
For the above report it can be summarized that stationary industry in Germany is in a
very good position and to expand its business in that direction can prove to be a boon for Duque
Papetiers Gros. This fact is stated from conduction of a detailed analysis of the industry in
Germany and evaluation of Pros and Cons for expansion decision in Belgium and Germany.
The spending in Germany on writing and drawing material is second highest in the world. Being
experiencing a fall in sales revenue for year 2017, the correlation comes out to be moderate, so
company need not to worry about this. Further it can be interpreted that the Company needs to
improvise the price vales for the products means consumer do not feel that what they are paying
is fully worth for the products purchased.
1

4. REFERENCES
Books and Journals
Marsden, A. and Shahtout, A., 2014. International Organization for Standardization. In Clinical
Laboratory Management, Second Edition (pp. 447-450). American Society of
Microbiology.
Kristoufek, L., 2014. Detrending moving-average cross-correlation coefficient: Measuring cross-
correlations between non-stationary series. Physica A: Statistical Mechanics and its
Applications. 406. pp.169-175.
Koo, T. K. and Li, M. Y., 2016. A guideline of selecting and reporting intraclass correlation
coefficients for reliability research. Journal of chiropractic medicine. 15(2). pp.155-163.
Online
International Organization for Standardization. 2018. [Online]. Available through
:<https://www.iso.org/iso-9001-quality-management.html>.
40 Brilliant Ways To Increase Survey Response Rates. 2018. [Online]. Available
through :<https://praiseworthy.co/blog/38-brilliant-ways-to-increase-survey-response-
rate/>.
1

5. Appendix
1