Analysis of Data and Information for Duque Papertiers Gros Report

This report presents a comprehensive analysis of data and information related to Duque Papertiers Gros, a wholesale stationer. It begins with an overview of the German wholesale stationers market, discussing market trends, key factors, and recent developments, including the impact of declining school-age populations. The report then analyzes financial data, presenting graphs, charts, and tables to illustrate sales figures, spending patterns, and correlations between variables. This includes a tabular analysis of sales data, mixed pie charts representing sales by product category, and the calculation of correlation coefficients. Forecasting total sales for future years is also performed. Furthermore, the report evaluates the potential for business expansion, comparing pros and cons of entering new markets, and identifies international standards relevant to Duque's activities. The analysis includes calculations of mortgage repayments, monthly expenses, and order mean values, offering recommendations for improving performance and addressing concerns. The report concludes with a summary of findings and recommendations for strategic decision-making, including suggestions for advertising campaigns.

Analysing Information
and
Data for Problem Solving

INTRODUCTION
Information and Data are vital aspects in organisation and mainly used for improvement
in decision making activities. Analysis of data and information helps to develop a framework for
decision making. The major objective of this project report is to develop an understanding of
ways and methods which assist in deep analysis of organisational data in way that it can be used
for making signifiant decisions and to address any problem. This report describes a case scenario
related to analysis of information in the context of Duque Papertiers Gros. This report also
exhibits significant Information like data or information related to products and customers and
critical analysis of financial data to provide a realistic conclusion and major recommendations
along with various table and graphs (Bertot, Jaeger and Hansen, 2012).
TASK 1
Overview of the wholesale stationers market in Germany:
Germany is the extremely powerful economy among various countries' economies in
world because of country's GDP rate. Consumer Market is main factor in success of their GDP
and main market in consumer market group is Wholesale stationers. Because Wholesale
Stationers covers a large part in overall GDP. Reduction in numbers of school children is most
influential factor in Wholesale Stationers market. In previous ten years revenue of this industry
is fall by approx 30% which is amounting approx 15 billion per annum. Due to heavy migration
towards other sectors in Germany the this industry's share and size has decreased during past ten
years and presently this sector has approx 5000 functional retailers. Following are the major
factors that have direct or indirect impact on stationary market are as follows:
1. Convenience: It combines various business entities which are engaged in numerous
business exercises like Tobacco is sold with stationary stuff which is inappropriate.
2. Second is cut-throat competition affecting stationary market. Large numbers of market
players are engaged in this industry which leads to reduction in price of product and
profit margin.
3. Third and most significant factor is considered as demand of stationary products or items.
4. Forth and last key factor is aggregate number or overall school or educational institute's
students (Fortier-Brochu, and et. al., 2012).

Recent trends in stationary market describes that turnover is increased by approx 3.5%
that leads to enhancement in global economic environment and also trends related to demand
stationary product showing increasing trend along with continuous decreasing rate.
TASK 2
Producing graph for representing annual spending on stationary material:
(Source: Malaysian-German Chamber of Commerce and Industry, 2016)
In above presented or displayed graph is formulated applying Malaysian-German
Chamber of commerce and industry's information. Information from graph displays yearly or
annually amount of spending of customers of various countries. From above graph represents
that the country Switzerland has acquired maximum part or amount of overall GDP by way of
stationary product sector due to their maximised spending power of customers whereas the
country Germany gained next to first rank by their consumer spending of 35.20 pounds and this
rank is achieved by Germany because of high population. Third place is occupied by France,
then the country Slovenia, next by Italy, further next by Spain and last by the country Poland. Per
year consumer's spending power in the Switzerland is higher than approx four times of annual
spending of Poland. Two main causes of such differences or variations, first one is unequal

allocation or distribution of population distribution while second is large number of academic
students in the Switzerland and Germany.
TASK 3
a) Tabular analysis of information:
Above data exhibits aggregate sales of company from all products. Company has earned
highest revenue in 2016 and writing/drawing materials are providing highest sales among all its
products.

b) Developing mixed pie chart representing sales of 2016 and 2017 :
The displayed or presented pie chart exhibits that Revenue from Writing and Drawing
materials or products is highest whereas Revenue from sales of low cost printers is lowest among
all other categories. Such other categories includes product revenue from furniture of office ,
general office supplies, printer cartridges and others.
As per displayed pie chart it has been evaluated that largest revenue amounting 32000 is
belongs to sales of products related to writing and drawing. On other hand lowest revenue
amounting 18000 is belongs to sale of low cost printers.

c) Associated correlation coefficient and its interpretation:
The correlation coefficient refers to a statistical analysis tool that assist in analysis of
relationship between various variables. Variables may be correlated with each other may be in
positively or negatively. In case of positively correlated variables values changes whether
increase or decrease in systematic line-up manner whereas negatively correlated variables
changes in value took place inversely (Green and Salkind, 2016). By analysing this diagram, this
is clear that a positive relationship exists among variables i.e. Years and Sales. Correlation
coefficients are computed through MS Excel as shown below:
Year Sales
2015 165000
2016 182000
2017 178000
2018 198000
2019 201600
Correlation coefficient 0.98
As per above summery table describing correlation coefficient, correlation between sales
and year is 0.98 which extremely near to 1 which indicates that there is a positive liaison among
variables.

d) Forecasting total sales for 2018 and 2019:
Above presented figures related to sales revenue in scatter diagram provides an
estimation for 2018 and 2019. As per this graph it is analyzed that there is upward trend in sales
revenue of company because of sales is increased from one year to other year in positive manner.
Above forecast is conducted while considering increasing sales in year 2018-19.
TASK 4
a) Completing the table:
Should I expand my business to Belgium & Germany?
Pros Score/10 Cons Score/10
E-commerce 10 Salaries 8
Opportunities 7 Administrative cost 7
Euro currency 7 Nationalism 6
Economy 7 Language 8
Market activity 10 Subcontractor could be
competitor 3
Reduced inflation
expectation 6 Inflexibility 5
Activities related to Logistic 10 Considerable risk market 9

entry
Total 57 Total 46
Average Pros 8.14 Average Cons 6.57
Presented summary table is framed by applying pros and cons approach that describes all
positive or favourable aspects in form of marks are displayed at left side column of the Table and
negative or unfavourable prospects are displayed at right side column of such Table (Harrell,
2015). Through analysis of this table it is determined that factors which leads to requirement of
expansion in business are logistics activity, e commerce, euro currency and so on in Duque
Papetiers Gros. It is determined that average rating from all pros is 8.14. This average is
discovered from total marks of pros that is 57. On contrary, total marks for cons is determined as
46 through which an mean or average of six is established. Hence, the mean of pros is greater
than mean of cons which is 6.57 and six it means that respective company is require to put
efforts towards expansion of its operations and activities outside the country also.
b) List of few international standards that may apply to Duque’s activities:
As per European Union, it is mandatory to provide a healthy, safe as well as reliable
environment to the employees of organisation. Thus, there are five shortlisted standards which
needs to be considered by Duque Papetiers Gros and they are described below:
ISO
14001:2015
It refer to an international standard which is basically for environment
protection, state that any function or major activity which has impact on
surroundings or environment must be controlled (ISO,2018).
ISO
30401
State that corporates must organise their various human resources efficiently.
Any unethical behaviours of employees have negative impacts on working of
organisation (ISO,2018).
ISO
14298:2013
Refers to the systematic set related to various measures of security printing
that require to be achieved or accomplished by all business corporates engaged
printing or stationary business (ISO,2018).

ISO
9001 : 2015
Specifies a managed set of various corporates that should achieve
predetermined measures of quality guided globally. It concerns mainly about
quality related issues of a company (ISO,2018).
ISO
64221:2010
This internationally accepted global standards refers that each and all files and
important papers either in printed form or written form must be filed or
reported to regulatory bodies or authorities of government needs to checked
properly and twice as well as verification should be made by top managerial
personnels of corporate entities (ISO,2018).
TASK 5
a) Calculating monthly cost of mortgage repayment
According to above presented analysis of mortgage payment in very 30 days, it is clear that
client pays interest at the rate of 10% on its mortgage on monthly basis (Jin and et. al., 2015). It's
a type of debt fund under which an individual only concerned about amount of interest required
to be paid in equal interval. Additionally, to compute monthly loan payments of loan obtained by
Duque papetiers Gros, MS Excel along with specific formula of PMT is applied. Though this
formula a fixed amount i.e. 1755.14 of monthly payment of pound 1755.14 is analysed.
b) Calculation of monthly expense by applying assumption that interest charged monthly:

TASK 6
Mean values of order
As per respective case of Donald, An evaluation is made that the Donalds assume that company
is going to gain monthly interval mean figure of 240 orders. Although such presumption is seems

to be reliable but is leading to wrong and inappropriate value of mean (Landauer and et. al.,
2013). as per analysis a effective hypothesis is created which is explained below:
This hypothesis is used to determine order of mean as described below:
Significant level of SD is 5%, 43 is determined as significance value. Aggregate no. is 50 of
these samples. According to the mentioned data and information, formula of SD error is
ascertained.
For obtaining accurate answer, figure of SE would be 6 by rounding it off. Therefore, using
interval acceptance it can be determined as:
= (μ -2SE; μ +2SE) => [240-(2*6)] [240+(2*6)] => Acceptance interval is [228]; [252]
Taking assumption then calculating for different variables, it can be determined that value of
mean of given sample shall be 240 pounds. Additionally, 95% of aggregate random sample
varies between the fixed and equal interval. This concludes that assumptions taken by Donald are
appropriate.
TASK 7
a) Providing advice about how performance of Donald’s firm can be improved
As per the respective scenario, it has been evaluated that the Dec. month is not
appropriate time period to circulate questionnaires among the clients to take feedback because
only on an average of 6% of questionnaires effectively considered by employees. Thus, to
achieve effective outcome for a business entity or organisation, method of brainstorming is
widely used. Thus, organisation changes period or time interval of year to obtain employee
feedback forms and tries to accomplish the following questionnaire.