Report: Analyzing Information and Data for Duque Stationery Expansion

This report provides a comprehensive analysis of the stationery market, focusing on the potential expansion of the Duque family stationery organization into the German market. The report begins with an overview of the German stationery market, its trends, and its economic climate, followed by an analysis of annual spending on writing and drawing materials per capita. The core of the report evaluates Duque's financial performance over the past three years, including sales data, chart representations, coefficient and correlation calculations, and sales predictions. A pros and cons table assesses the feasibility of expansion into Germany and Belgium. The report also includes cost calculations for a new building and an analysis of data from a customer report. The conclusion summarizes the key findings and insights gained from the data analysis, providing a basis for informed decision-making regarding the expansion strategy.

ANALYSING
INFORMATION AND
DATA FOR PROBLEM
SOLVING

TABLE OF CONTENTS
Table of Contents.............................................................................................................................2
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Overviews of stationery market in Germany..........................................................................1
TASK 2............................................................................................................................................2
Annual spending on writing/drawings material per capita.....................................................2
TASK 3............................................................................................................................................4
Evaluation of Duque financial period of sales from last three year.......................................4
(a): Data indicating the sales generated during the year.........................................................4
(b) Mix-pie chart.....................................................................................................................5
C): Computation of coefficient and correlation......................................................................6
(d): Predication of total sales during the period of 2018-2019...............................................8
TASK 4............................................................................................................................................9
Completion of pros and cons table.........................................................................................9
TASK 5..........................................................................................................................................10
Calculation of certain cost for new building........................................................................10
(a): Calculation of monthly cost for 30 year........................................................................10
(b): Re-calculation of using loan interest amount................................................................10
TASK 6..........................................................................................................................................11
Analysis of data....................................................................................................................11
TASK 7..........................................................................................................................................11
Respond to customer report..................................................................................................11
TASK 8..........................................................................................................................................12
Summary...............................................................................................................................12
CONCLUSION..............................................................................................................................12
REFERENCES..............................................................................................................................13

INTRODUCTION
Data analysis is considering as one of the effective inspecting, transforming and data
modelling with the motive to discover valuable data information and supporting effective
decision making. It has been so many facets and method that are encompassing diverse tool
under a wide range of norms and regulations. Donald Duque owns a wide family stationery
organisation in Northern France. On the basis of their business growth and position, they are
planning to expand their operating in other market of Germany. This project is all about
collecting specific information about stationary business and per capita of Writing and drawing
material. Interpretation of all concern data by preparing certain charts and diagram which will
assist them to attain maximum outcomes in near future time. The overall data analysis is based
on getting necessary opportunity to increase profitability position of the company at the same
period of time (Bardach and Patashnik, 2015).
TASK 1
Overviews of stationery market in Germany
Germany is considered as one of the largest economy which is highly innovative and has
positive base as compare to other nations. In maximum-selling industry for their competitiveness
and international networking is the primary range of the company. it has been determining that
Germany is investing about 80 billion euros yearly in research and development. During the
review time period the growth of writing instrument and stationery in Germany used to continue
to make decrease with maximum categories which is likely to record a weak performance during
the forecasting period of time. This is being consider as amidst aspects as a favourable economic
climate, high levels of consumer level and plenty of individual are searching for best alternatives
means of making certain kind of investment (Charnes and et. al., 2013). Writing instruments and
stationery in Germany reports can offers a well effective comprehensive regulation to overall
size and shape of their writing and other stationery products at a national level.
This seems to provide latest retail sales information which allows company to determine
appropriate sectors which used to drive future growth for an individual. Nowadays, it has been
examining that most of the effective companies are operating towards situation and other
variation. It seems to be effective availability of resources that can be useful in coming period of
time as sustainability of Duque. Retailers required to operate with best possible objects that are
related with stationery in adoption of their business to keep their operations for longer period of
1

time as per the changing environments. It has been considered that present data associated with
overall market size and ability and overall turnover that are generated during the time are analyse
in effective manner. There are various three major trends those are required to be implemented
that are making certain kind of implication seen over the stationery market. There are various
trends such as:
 It has been seen that reduction in demand for back to school products would be
traditionally related with the main business.
 Standard items that are easy to make display and sell pen, pads and found in certain shops
such as drug stores.
 The third important trend is being digitalisation of classroom with certain teachers those
are moving towards latest technology like tablets and make away from paper products.
Overall sales position:
According to the MGCC report, it has been found that overall earning collected from the
sale of stationary products is about 3.5% in initial stage of an accounting period. Few of them are
consider as primary ways those are associated with adoption to support local as well as
international location. A total revenue generated during the period of taken as 14.8 billion per
annum from total sales of stationary products. Through the use of investments that are made in
manufacturing of production items produce during the time (Kaisler and et. al., 2013).
TASK 2
Annual spending on writing/drawings material per capita
Stationery is the combination of various group of wide range of material which will be
consists of various paper and officer supplies, greeting cards, pencil and other similar products.
These are considering as important portion of human consumptions. This seems to be
international stationery products that is serrated on the basis of various products and distribution
modes. It has been related with international market for use of stationery products which is
divided into printing supplies and marking devices and stencil paper. Printing supplies are sub-
divided into ink & toners, inked ribbons and carbon as well as other aspects. Paper based
stationery products are segregated into printing/writing and copying paper, organiser and
notebooks and exercise books and other aspects. Writing and marketing aspects consists of
various products those are related with use of students and other people. This has been attributed
to their varied utilisation of multiple sectors as well as other school supplies.
2

Printing supplies is based on witness the fastest growth rate because of the forecasted
duration which would owing to enhance demand for printing supplies by consumer for personnel
use in household people. As per the annual report mentioned under the MGCC report, it has been
determining that a total turnover of 35.2 billion is being generated in year 2016. This will be
taken into account that growth in stationary products and number which has been enhancing in
each year. This has been analysing that total market share collected into account through using
wide range of super market and other hyper places are utmost valuable ways to perform their
tasks in effective and efficient manner. The range of stationary product or markets is growing at
faster rate from last couple of years (Munson and et. al., 2014). This has been analysing that
German stationary market for Donald Duque is one of the effective company which is increasing
their business at faster rate. As per the data mentioned in MGCC report, the Switzerland is
recorded as 35.5 billion, Germany is being recorded with total of 35.2 billion. Italy is noted as
18.6 billion and so on. There are certain favourable aspects that come across in respect for
further expanding of business in terms of stationary position.
Nations Yearly spending (€)
in billion
Croatia 7.9
Poland 8.5
Germany 35.2
Italy 18.6
Hungary 9.6
Switzerland 35.5
Austria 35
3

From the above chart, it has been seen that total annual spending is collected from
Switzerland, Germany and Austria. It means that position of these nation is must more effective
as compare to other nations for stationary market.
TASK 3
Evaluation of Duque financial period of sales from last three year
(a): Data indicating the sales generated during the year
4

(b) Mix-pie chart
5

C): Computation of coefficient and correlation
6

According to the above presented scattered charts, it has been showing certain financial
information of company by increasing the every year companies position. There is health
correlations among sales volume in 2015 and 2016 respectively with sufficient outcomes of
0.90088 and 0.847. The results collected in the year 2015 to 2016 is very much near and
providing better growth and sustainability for the company. It has been simply reliable and
valuable measure which will be related with the value of r that can be used by the account
managers to boost the company and provide direction of direct relationship between the two set
of data variables. It is plotted by using a scatter diagrame in respect to examine the relations
among each another.
7

(d): Predication of total sales during the period of 2018-2019
As per the all data analysis, it has been seen that financial position of the company is must
effective to reach a certain level of decision. The base for making plan for coming year is taken
from 2017 reports of sales generated by the company (Taylor and et. al., 2014). This has been
targeted to increase overall sales with mainly 2 % on a yearly sale in each yearly. In order to
determine the predicated sale in next period are mentioned underneath:
2018 Sales
(€) 2019 Sales (€)
22440 23000
23460 24000
18360 18870
27540 28090
29580 30171
27540 28090
32640 33292
According to the above mentioned trend line which is showing estimated sales which is
increasing in each year. The generated outcomes are gather from all products those are being
sold during the period of time. It means that their postiive sign is increasing in coming time
which is positive indication for the company in long run.
8

TASK 4
Completion of pros and cons table
This has been noticed that all the mentioned case situation as per the mentioned as per the
Duque which is usually carried in their operations in Norther France. It has been related with
boarder sense that Germany is consider as one of the best sources for operating their activities in
effective manner (Anyan, 2013). This used to deal with every crucial aspect that are decided to
make appropriate research through asking questions from different people in Germany and
Belgium.
Should I expand my business to Belgium & Germany?
Pros Score/10 Cons Score/10
Ability to make capitalised on the
economics of scale 8
Little bit of creative thinking and
inappropriate delivery time 6
Highly qualified team members 7
Budgets that are made for the
purpose of maintain employee
motivation 5
Flexible and dependency on proper
utilisation of resources 8
Tracking ability of employee
performance 4
Effective communication skills and
ability 8
Face to face interaction about
various programs and polices 5
Best enough in handling any kind of
pressure and help in attaining better
growth in near time. 7
Controlling of operations
capability 6
Total Pros 38 Total Cons 26
Average Pros 9.5 Average Cons 5.2
ISO standards: There are various types of international standard which are helpful for
fulfilling specific information that are followed to every company before making any further
expansion of any new business. Some of them are discussed underneath:
ISO 45001: It is having international standard that used to specifies essential needs for an
effective environmental management system. It used to provide a complete framework which
will be managed by an organization. It used to establish eco-friendly needs that are beneficial for
the company for long term process.
ISO 14000: This particular standard is used to provide practical tools and techniques
those are used by the company for all looking to manage their environmental roles and
responsibility (ISO 14000, 2018). It is having negative affect on environment that cause adverse
implication on air, water and other aspects.
9