Analysing Information and Data for Problem Solving : Assignment

ANALYSING
INFORMATION AND DATA
FOR PROBLEM SOLVING

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Overview of stationer market (wholesale) in Germany.........................................................1
TASK 2............................................................................................................................................2
2.a Framing graph for reflecting annual spending..................................................................2
TASK 3............................................................................................................................................3
3.a Analysing information in tabular format..........................................................................3
3.b Mixed pie chart of sales of year 2016 and 2017...............................................................3
3.c Extracting correlation coefficient.....................................................................................5
3.d Predicting sales for year 2018 and 2019...........................................................................6
TASK 4............................................................................................................................................7
4.a Completing the table with its pros and cons.....................................................................7
4.b Listing international standards for activities of Duque....................................................8
TASK 5............................................................................................................................................8
5.a Monthly cost of mortgage repayment...............................................................................8
5.b Recalculating monthly cost with applied interest to loan.................................................8
TASK 6............................................................................................................................................9
6.a Calculating mean value of order.......................................................................................9
TASK 7..........................................................................................................................................10
7.a Advice related to Donald's firm performance.................................................................10
7.b Suggestions with respect to cause for concern...............................................................11
TASK 8..........................................................................................................................................11
Conclusion............................................................................................................................11
REFERENCES..............................................................................................................................12

INTRODUCTION
Data analysis is referred as process for purpose of effective decision making in any
business. The present report will discuss about various techniques which leads to analyse
organizational data used for problem solving and decision making. In this report, it will provide
overview of wholesale stationery market and analyse information of Duque Paerties Gros with
suggestions for purpose of expanding business activities.
TASK 1
Overview of stationer market (wholesale) in Germany
Germany is replicated as highly influential economies of world due to high GDP which
gave an outcome of high consumer market. The GDP of this economy has huge contribution with
context of wholesale stationery market. In this aspect, it has very impactful case because of
which market's productivity is reduced in numerous school age children. The current stationery
is positioned in appropriate aspect. As per trade association for writing and office supply
materials, its total turnover was €14.8 billion whereas every individual spending was equalised
and more than €182 on yearly aspect as it has been decreased by 30% over past 10 years.
Further, €35.2 was spent on drawing and writing material where Germany has ranked second
among European union (Germany – A Potential Stationery Market, 2018). The organization's
positive attitude in stationery industry has underpinned fact higher than 70% of its major
stationery brands of Germany has increment in sales in year 2015.
As per association of German stationery brands, its total turnover of stationery industry of
Germany had attained growth by 3.5% from 2014 to 2015. It is replicated as outcome of raising
domestic demand with growth of 2.5% along with international demand by 5%. However, there
are four factors which had impacted stationery industry such as specialist, convenience, stationer
and lifestyle. First factor as specialist which could be for writing instruments where model is
very easy for end user linked with this. Second is convenience, shops have huge range but not at
deep like stationery, tobacco and books as this is considered very unattractive to members but
they are performing in appropriate aspect due to huge frequency. Other factor stationer, there is
wide range of items of stationery with expertise in areas and last is lifestyle, which forms steps
by just selling to provide skills and advice to customers (Darnton, 2016.). Henceforth, with
trends in stationery market, turnover has been analysed which had faced increment through 3.5%
1

which has enhanced international economic environment. Thus, trends has been observes in past
few years where demand has raised at declining rate.
TASK 2
2.a Framing graph for reflecting annual spending
(Source: Malaysian-German Chamber of Commerce and Industry, 2016)
Interpretation: The above graph is formed with application of data of Malaysian-German
Chamber of Commerce and Industry as this information reflects data with context of annual
spending through customers of multiple countries. It has been clearly viewed that Switzerland
has the highest earning amount with reference to GDP through stationery industry with huge
consumer spending. In the similar aspect, Germany has second highest rank with 35.2 through
consumer spending on unit of stationery on yearly basis due to high population. In this context,
France is at third position, then Italy, Hungary, Poland and Czech Republic is lowest (Fang and
et.al., 2015). The main reasons behind these variations due to uneven population distribution
along with high number of population are students in Switzerland and Germany.
2