Report on Analysing Information and Data for Duque Papetiers Gros

This report analyzes data and information for Duque Papetiers Gros, a stationary company, to facilitate informed decision-making and address identified problems. The report includes an overview of the German stationary market, a graph representing annual expenditure on stationary material, and a tabular analysis of the company's sales data. It calculates a correlation coefficient, forecasts sales for future years, and presents a pros and cons analysis for business expansion. Furthermore, it covers international standards relevant to Duque's activities, mortgage calculations, and the statistical analysis of order mean values. Finally, the report offers recommendations for performance improvement and identifies causes for concern, drawing conclusions on overall revenue and business strategy.

Analysing Information and
Data for Problem Solving

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
Overview:.....................................................................................................................................3
TASK 2............................................................................................................................................4
Graph representing annual expenditure on stationary material:.................................................4
TASK 3............................................................................................................................................5
a) Tabular analysis of information:..............................................................................................5
b) Developing mixed pie chart representing sales of 2016 and 2017:.........................................6
c) Associated correlation coefficient and its interpretation:........................................................7
d) Forecasting total sales for 2018 and 2019:.............................................................................8
TASK 4............................................................................................................................................8
a) Pros and Cons:.........................................................................................................................8
TASK 5..........................................................................................................................................10
a) Calculation of monthly cost of mortgage repayment:...........................................................10
b) Re calculation of monthly cost assuming that interest is applied to the loan every month:..10
TASK 6..........................................................................................................................................11
Mean values of order.................................................................................................................11
TASK 7..........................................................................................................................................11
a) Providing advice about how performance of the firm can be improved:..............................11
b) Suggestions on cause for concern;.........................................................................................12
TASK 8..........................................................................................................................................13
Conclusion.................................................................................................................................13
REFERENCES..............................................................................................................................14

INTRODUCTION
In an organisation data and information is required to make an effective decision after the
proper analysis of the data and information provided. This project report focuses on
understanding and building techniques which is required by the organisation to analyse these
data and information to make necessary decisions and solving problems identified during data
analysis. In this report a management trainee followed a case of Duque Papertier Gros in which
he analysed the information and suggested some ways by which they can enter a new market and
expand their business. For analysis purpose informations related to its customer, products and
financial data are used to make this reports, graphs and tables are used for the recommendations
on their expansion and to present the conclusion.
TASK 1
Overview:
Germany is known for its economy it is the most influential economy compared to the
economies of the other countries. Reason which make Germany the most influential is their high
GDP which shows that the consumer market is high and favourable in this nation. As far as the
wholesale stationers market is concerned it contributes around billions to this nations GDP. Since
past 10 year the sales of this industry shows a decline of about 30% which is approx 15 billion.
The main reason behind the decline of this industry is the decrease in the number of children
going to school. There are approximately 5000 retailers who are specialised in this sector. In this
analysis the four main factors are seen which affected the stationary market. Factors are
convenience, market players of the industry are involved in selling tobacco along with the
stationary products which is not considered as the appropriate practice. The second factor
affecting is the competition, the competition in the stationary market is very intense as the
number of sellers are growing resulting in the problem of low profitability for the small players.
Demand for the product is the third factor which is affecting the market. The main and the fourth
factor is the decrease in the number of the school going students.
Analysis of the trends of this market has shown an increase of 3.5% in the turnover
resulting in the enhancement of the international economic environment. In the past few years
the demand in the market is increasing but with the declining rate.

TASK 2
Graph representing annual expenditure on stationary material:
(Source: Malaysian-German Chamber of Commerce and Industry, 2016)
The graph is produced by the data of Malaysian-German Chambers of Commerce and
Industry. The information represents the data of different consumers of different countries stating
their annual spending on stationary products. After the analysis of above graph it has been seen
that Switzerland has the highest contribution in GDP from its stationary industry as the number
of consumers spending on the stationary items are the highest among others. With €35.20 spent
annually by the consumers on the stationary items Germany takes the second place. The reason
for their high expenditure on the stationary can be the population of the country. France is
allocate to the third place after it, Slovenia, Italy, Spain and Poland has their positions
respectively. The difference between the annual spending of Germany and Poland is more than
four times. The main reason for these variations can be the uneven distribution of population and
the rate of school going students which is high in Switzerland and Germany.

TASK 3
a) Tabular analysis of information:
Above table shows the annual sales of the company of last three years, from the above
data it has been analysed that the company highest sales was in the year 2016 and the most
profitable product is the writing/drawing material.

b) Developing mixed pie chart representing sales of 2016 and 2017:
Above chart shows that the maximum sales during the year 2016 is achieved by from the
sales of drawing/writing material and the contribution of low cost printers in the total sales is
minimum. Other products are classified into different categories as general office supplies,
printer cartridges, and others.
Above pie chart, shows the same trend of the company in which the maximum
contribution is from the writing and drawing materials and lowest from the low cost printers.

c) Associated correlation coefficient and its interpretation:
A statistical measure which shows the relation between two variables is correlation
coefficient. There can be the two types of correlation, negative correlation and positive
correlation. In the case of negative correlation, the value of one variable will decrease if there is
an increase in the other variable. In this the variables are indirectly proportional to each other. In
the case of positive correlation, the value of one variable will increase if the value or another
variable is increasing. After the analysis of the above scatter diagram it can be stated that both
the year and sales shows a that they are positively correlated to each other. Correlation
coefficient is measured below using MS excel:
Year Sales
2015 170000
2016 189000
2017 181000
2018 188000
2019 194600
Correlation coefficient 0.8066925835
The above calculation of correlation coefficient states that the correlation coefficient
between the sales and the year of the company is 0.80, close to 1. which states the positive
relation between sales and revenue of the company.

d) Forecasting total sales for 2018 and 2019:
The above graph shows the predictions made by the company for the year 2018 and 2019.
These prediction has been made by seeing the rising trend in company which shows the
significant growth in the sales revenue, and also it has been considered that the sales between
year 2018-2019 will increase followed by the preceding years.
TASK 4
a) Pros and Cons:

The above table shows the pros and cons of the company which consider all the positive
and the negative aspects of the company. Left side shows all the positive aspects which can help
the organisation to expand its business and the right side shows all the negative aspects which is
to be taken care for their expansion. After analysing the above table it is stated that the company
Duque Papetiers Gros. Should go for the expansion of their business as their total pros are 61
giving the average of 8.71 due to their logistics activity, market activity, economy and more. As
far as cons are considered the above table indicates the total cons as 42 giving the average of 6.
The analysis shows that the company should consider for the expansion of their business as the
average cons are less than the average pro resulting in the opportunities to expand its operations
outside Germany.
b) List of international standards that apply to Duque’s activities
As per the EU (European Union), it is mandatory for the companies to provide a reliable
and a safe environment to all of its employee working in an organisation. The following five
standards which are to shortlisted are to be considered and met by Duque Papetiers Gros.
ISO 9001 : 2015 This standard states that all the quality measures must be fulfilled by the
organisation which are provided internationally. The main focus of this
standards is to control the quality(ISO,2018).
ISO 14298:2013 This standard states that all the organisation involved in the printing and
stationary business must follow a set of security printing measures(ISO,2018).
ISO 30401 This standard focus on the management of the human resources in an
organisation. According to this standard the company must effectively manage
their human resources, as any misconduct can affect the company
directly(ISO,2018).
ISO 6422-1:2010 According to this standard documents which are related to Governmental
authorities whether printed or written must be verified and double checked by
the top level authorities in the organisation(ISO,2018).
ISO 14001:2015 This standard is related to the protection of the environment. This states that the
company should not conduct activities and operations which can be harmful for
the environment(ISO,2018).

TASK 5
a) Calculation of monthly cost of mortgage repayment:
The above table determines the monthly payment of mortgage, from the above table it
has been established that the client has taken loan on mortgage. It is a type a loan in which only
the amount of interest is paid monthly to the person from which the loan is taken. To calculate
the amount which is to be paid every month by Duque Papetiers Gros the formula of PMT and
MS Excel is used. The monthly amount which is to be paid is €1755.14.

b) Re calculation of monthly cost assuming that interest is applied to the loan every month: