Analysing Information and Data

The evaluation of the study helps in detecting the level of prospect, which can be detected from the stationary industry in Europe. The analysis is based on different level of sales that is being obtained by company during the fiscal years of 2015, 2016, and 2017.

Running head: ANALYSING INFORMATION AND DATA
Analysing Information and Data
Name of the Student:
Name of the University:
Authors Note:

ANALYSING INFORMATION AND DATA 2
Table of Contents
Introduction:...............................................................................................................................3
Task 1: Providing an insight on the Wholesale stationers market in Germany by analysing the
trends in the area........................................................................................................................3
Task 2: Providing excel for the annual spending that has been conducted by the European
countries.....................................................................................................................................4
Task 3:........................................................................................................................................5
a) Providing excel spread sheet, where total sales on each year is calculated:..........................5
b) Providing mixed pie chart where the sales have been represented in 2016 and 2017:..........5
c) Providing Scatter diagram of the total sales:.........................................................................6
d) Using the scatter diagram to forecast the total sales for 2018 and 2019:..............................7
Task 4:........................................................................................................................................8
a) Completing the table:.............................................................................................................8
b) Identifying the overall ISO standards applied by Duque’s Activities:..................................9
Task 5:......................................................................................................................................10
a) Calculating the Monthly cost of a 30-year repayment mortgage of 200,000:.....................10
b) Re-calculating the Monthly cost of a 30-year repayment mortgage of 200,000 with APR:10
Task 6: Providing evidence by analysing different statistical evaluations..............................11
Task 7:......................................................................................................................................12
a) Providing advice that can improve the current situation of the questionnaire:....................12
b) Obtaining the descriptive statistics such as mean and standard deviation for the four
variables:..................................................................................................................................12
Task 8: Conclusion...................................................................................................................13
Reference and Bibliography:....................................................................................................14
Appendices:..............................................................................................................................17

ANALYSING INFORMATION AND DATA 3
Introduction:
The evaluation of the study helps in detecting the level of prospect, which can be
detected from the stationary industry in Europe. The analysis is based on different level of
sales that is being obtained by company during the fiscal years of 2015, 2016, and 2017. The
sales of the overall company have been segregated into pie chart for detecting the relevant
information, while identifying the trend of sales. Furthermore, the valuation has been
conducted for analysing the relevant information regarding the mortgage cost for loan. The
questionnaire conditions have been evaluated for improving the level of response from the
customers.
Task 1: Providing an insight on the Wholesale stationers market in Germany by
analysing the trends in the area
The analysis of MGCC report has provided an insight on the wholesale stationer
industry in Germany, which can eventually help in detecting the possible profits that can be
generated from investments. The turnover witnessed during the fiscal year of 2015 in annual
spending conducted for writing and drawing measure are at the level of 148 billion. This
indicates the possible market for the Stationary industry, as demand for the products have
been spurring by 2.5% in 2015. Furthermore, the German Stationary companies are
considered to be one of the leading brands in the world. Hence, the stationary industry in
Germany has been evaluated by one of the strongest, which can allow the organisation to
increase their sales and generate high level of income over the period. The demand for
stationary in Germany has been rising adequately and providing the organisation to achieving
the highest level of growth. The online presence of the stationary industry has allowed the
organisation to flourish in Germany, which allowed them to maximise the level of output and

ANALYSING INFORMATION AND DATA 4
create long lasting customer demand. Hence, organisation operating in Germany could raise
the level of income from operations (Vogel 2014).
The market trend of Stationary companies is positive in Germany, as the demand for
writing and drawing instruments in rising. This increment in the demand highlights the
possible up trend for the stationary industry, which can be used by the organisation to
increase their espouser in the market and generate high level of income. Beauchaine, Ben-
David and Sela (2017) indicated that companies use the information of industry for analysing
the trend and possible income, which can be generated from the market.
Task 2: Providing excel for the annual spending that has been conducted by the
European countries
Value
£35.50 £35.20 £35.00
£28.30
£20.40 £18.60
£9.80
Annual Spending on Writi ng/Drawings
Switzerland Germany Austria France Slovenia Italy Slovakia
The above figure consists of 7 biggest spenders on writing and drawings during the
fiscal year of 2015, as reported in MGCC. Germany is considered to be the second highest
spender among the seven countries, while France is listed as fourth. The high level of
expenditure that is being conducted by countries can be used by the companies for analysing
the investment options. Hence, the organisation could eventually increase the level of

ANALYSING INFORMATION AND DATA 5
operations in Germany, as high spending capability of drawings and writing component is
high.
Task 3:
a) Providing excel spread sheet, where total sales on each year is calculated:
Product item 2015 2016 2017
Printer cartridges $ 25,000.0
$
26,000.0 $ 22,000.0
General office supplies $ 25,000.0
$
27,000.0 $ 23,000.0
Low-cost printers $ 15,000.0
$
18,000.0 $ 18,000.0
Office furniture $ 25,000.0
$
25,000.0 $ 27,000.0
Shredders $ 25,000.0
$
29,000.0 $ 29,000.0
Paper-based supplies $ 25,000.0
$
27,000.0 $ 27,000.0
Writing/drawing materials $ 25,000.0
$
30,000.0 $ 32,000.0
Total Sales $ 165,000.0
$
182,000.0 $ 178,000.0
The above table represents the overall total sales that has been achieved by the
company over the period of 2015m 2016and 2017. The total sales has been calculated by
using the SUM() function in excel.

ANALYSING INFORMATION AND DATA 6
b) Providing mixed pie chart where the sales have been represented in 2016 and 2017:
printer cartridges
14%
general office supplies
15%
low-cost printers
10%
office furniture
14%
shredders
16%
paper-based supplies
15%
writing/drawing
materials
16%
2016 Sales (€)
printer cartridges
12%
general office supplies
13%
low-cost printers
10%
office furniture
15%
shredders
16%
paper-based supplies
15%
writing/drawing
materials
18%
2017 Sales (€)
The above graphs represent the overall composition of sales that has been achieved by
the company during the fiscal year of 2016 and 2017. The representation of the sales in pie
chart formats directly help in detecting the percentage growth in sales component of the
company.

ANALYSING INFORMATION AND DATA 7
c) Providing Scatter diagram of the total sales:
2014.5 2015 2015.5 2016 2016.5 2017 2017.5
$155,000.0
$160,000.0
$165,000.0
$170,000.0
$175,000.0
$180,000.0
$185,000.0
f(x) = 6500 x − 12929000
R² = 0.534810126582278
Total Sales
Total Sales Linear (Total Sales)
The above graph represents the overall trend of the sales conducted by the company
during the fiscal year of 2015, 2016 and 2017. The representation indicated that R2 is at the
level of 0.5348.
d) Using the scatter diagram to forecast the total sales for 2018 and 2019:
2014.5 2015 2015.5 2016 2016.5 2017 2017.5
155,000
160,000
165,000
170,000
175,000
180,000
185,000
f(x) = 6500 x − 12929000
R² = 0.534810126582278
Total Sales
Total Sales Linear (Total Sales)

ANALYSING INFORMATION AND DATA 8
Particulars 2018 2019
x (A) 6,500.00 6,500.00
Year (B) 2018 2019
Intercept (C) (12,929,000.00) (12,929,000.00)
Total sales (Forecasted) (D=C+A*B) 188,000.00 194,500.00
The above table and graph directly present the trend line, where adequate forecasting
is conducted for 2018 and 2019. This forecasting has mainly helped in detecting that
$188,000 sales will be achieved by 2018, while $194,500 will be obtained by 2019. The
equation used in the above figure helps in forecasting the sales that can be achieved by the
company. This might eventually help the company in anticipating the future sales and income
that can be generated over the period of time (Ho and Cheng 2016).
Task 4:
a) Completing the table:
Should I Expand My Business to Belgium & Germany
Pros Score/10 Cons Score/10
The expansion plan of Germany
is an opportunity for the
organisation, as it raises the level
of income, which can be
obtained in future.
9 The major limitation that can be
faced by the organisation is the
language barrier, which might
negatively affect their operational
capabilities.
5
Germany has a high demand for
stationary items, which increases
the presence of adequate
workforce that can be used by
9 The geographical location is also
considered problematic for the
company, as set-up cost and other
expenses might increase rapidly
4

ANALYSING INFORMATION AND DATA 9
the company to support their
options in the country.
The expansion in Germany
would directly raise the level of
exposures of the company,
which will eventually generate
high level of income from
operations.
8 There is a possibility of high
international competition that can
be faced by the organisation in
Germany, as big brands are present
there.
3
The organisation can adequately
diversify their operations in
Germany with the expansion
process, as the country has high
level of demand for stationary
products.
6 The foreign exchange can also
negatively affect the revenue
conditions of the company, as
alternation in exchange rate might
increase risk and reduce
conversion amount of the
organisation
4
The increment in operational
capability and expansion in other
countries would eventually raise
goodwill of the company.
8 The continuous demand for the
innovation and diversification
cannot be met by the organisation,
which will relatively takeover the
operations in future
5
The acquisition of adequate
finance needed for commencing
the project can be collected
easily by the company, as
Germany is one the largest
7 The initial capital required for
starting the business can be
difficult for the organisation, as it
might negatively affect their
operational capability in future.
3

ANALYSING INFORMATION AND DATA 10
markets for stationary products
Total Pros 47 Total Cons 24
Average Pros 7.83 Average Cons 4
b) Identifying the overall ISO standards applied by Duque’s Activities:
There are specific ISO standards that need to be followed by Duque, while conducting
their activities. The ISO 9000 (Quality Management), ISO 14000 (Environment
Management), and ISO 31000 (Risk Management) standards is relevantly affecting the
activities of Duque.
Task 5:
a) Calculating the Monthly cost of a 30-year repayment mortgage of 200,000:
A〖( 1+r )〗^n - 12 * x * [(〖( 1+r )〗^(n )-1 )/(( 1+r )-1)] = 0
Where, A = Amount of Mortgage
r = Annual rate of interest expressed in decimal
n = Repayment term in years
x = Monthly repayment
200,000 〖( 1+0.10 )〗^30 - 12 * x * [(〖( 1+0.10 )〗^(30)-1 )/(( 1+0.10 ) -1)] = 0
200,000 〖( 1.10 )〗^30 - 12 * x * [(〖( 1.10 )〗^(25 )-1 )/(( 1.10 ) -1)] = 0
200,000 (17.44940227) - 12 * x * [(16.44940227)/(0.10)] = 0
3,489,880.45 - 12 * x * 164.494 = 0
3,489,880.45 - 1973.92872 x = 0
3,489,880.45 = 1973.92872 x

ANALYSING INFORMATION AND DATA 11
(3,489,880.45)/(1973.92872) = x
x = 1768
b) Re-calculating the Monthly cost of a 30-year repayment mortgage of 200,000 with
APR:
Particulars Value
Rate 10%
Fees to pay 5,000
APR 10.30%
A〖( 1+r )〗^n - 12 * x * [(〖( 1+r )〗^(n )-1 )/(( 1+r )-1)] = 0
Where, A = Amount of Mortgage
r = Annual rate of interest expressed in decimal
n = Repayment term in years
x = Monthly repayment
200,000 〖( 1+0.1030)〗^30 - 12 * x * [(〖( 1+0.1030 )〗^(30)-1 )/(( 1+0.1030 ) -1)] =
0
200,000 〖( 1.1030)〗^30 - 12 * x * [(〖( 1.1030)〗^(25 )-1 )/(( 1.1030) -1)] = 0
200,000 (18.9525) - 12 * x * [(17.9525)/(0.1030)] = 0
3,790,503.90 - 12 * x * 174.238 = 0
3,790,503.90 - 2090.865532 x = 0
3,790,503.90 = 2090.865532 x
(3,790,503.90)/(2090.865532) = x

ANALYSING INFORMATION AND DATA 12
x = 1813
Task 6: Providing evidence by analysing different statistical evaluations
Particulars Value
Ho € 240.00
H1 € 240.00
Sample standard deviation € 43.00
Sample size 50
Standard Error 6.08
Acceptance interval Low 227.84
Acceptance interval High 252.16
The acceptance interval is mainly at the levels of 227.84 to 252.16, where the sample
mean is mainly calculated at the levels of 230. The sample mean falls under the acceptance
internal level, where 95% randomly sampled mean is accepted. Therefore, the evidence is
supported by the 5% significance level.
Task 7:
a) Providing advice that can improve the current situation of the questionnaire:
The questions listed in the Feedback summary is relevantly adequate, as it comprises
only quantitation question with options. However, with the adoption of lucrative offers the
organisation can motivate the customers to fill in the questioner. This improvements in the
offers can allow the organisation to gather the required level of information, which is needed
for making relevant decisions. The organisation could target the regular customers for
gathering the adequate level of information about their services make alternation to improve
the customer satisfaction level. Thus, targeting the regular customer and providing discount

ANALYSING INFORMATION AND DATA 13
couples could motivate the customers to fill in the questionnaire required by the company
(Ho and Cheng 2016).
b) Obtaining the descriptive statistics such as mean and standard deviation for the four
variables:
ID CUST_SERV QUAL_P&S SALES_STAFF PRICE_VALUE
1 3 3 3 3
2 3 3 3 2
3 4 4 4 2
4 4 3 4 1
5 2 3 2 2
6 4 4 4 2
7 4 3 4 2
8 4 3 4 2
9 2 3 2 2
10 4 3 4 1
11 4 3 4 2
12 4 3 4 2
13 4 3 4 2
14 4 3 4 1
15 2 3 2 2
16 4 3 4 2
17 4 4 4 2
18 3 3 3 3
19 4 3 4 2
20 3 3 2 2
Mean 3.50 3.15 3.45 1.95
Standard 0.76 0.37 0.83 0.51
The above table presents the overall mean and standard deviation for the four
variables used in the questionnaire. This evaluation indicates that for variable staff the
standard deviation is relevantly high, which indicates that viewpoint of the customers and
organisation is not same on the services. In addition, the calculation indicate product quality
mean is high, which indicates that the organisation provides high quality products. Therefore,

ANALYSING INFORMATION AND DATA 14
improvements in the operations and service needs to be conducted by the company for raising
the level of customer service (Post and Byron 2015).
Task 8: Conclusion
The assessment aims in evaluating the overall expansion plans for the organization,
which aims to open their activities in Germany. The stationary market of Germany is
evaluated by finding both the pros and con for the investment, where pros are higher than the
cons. Moreover, the valuation of mortgage payment is also conducted for determining the
level of improvements that needs to be conducted by the investment. Furthermore, the
questionnaire condition indicates that improvement in the overall service quality would
ensure high customer satisfaction, which the product quality is considered to be relevantly
high. Thus, expansion in Germany could be conducted by Duque Organization for raising
their operational capability and generating high level of income.

ANALYSING INFORMATION AND DATA 15
Reference and Bibliography:
Beauchaine, T.P., Ben-David, I. and Sela, A., 2017. Attention-deficit/hyperactivity disorder,
delay discounting, and risky financial behaviors: A preliminary analysis of self-report
data. PloS one, 12(5), p.e0176933.
Chapuis, C., Bedouch, P., Detavernier, M., Durand, M., Francony, G., Lavagne, P., Foroni,
L., Albaladejo, P., Allenet, B. and Payen, J.F., 2015. Automated drug dispensing systems in
the intensive care unit: a financial analysis. Critical Care, 19(1), p.318.
Chu, P.L., Vanderghem, C., MacLean, H.L. and Saville, B.A., 2017. Financial analysis and
risk assessment of hydroprocessed renewable jet fuel production from camelina, carinata and
used cooking oil. Applied energy, 198, pp.401-409.
Conti, J., Holtberg, P., Diefenderfer, J., LaRose, A., Turnure, J.T. and Westfall, L.,
2016. International energy outlook 2016 with projections to 2040 (No. DOE/EIA-0484
(2016)). USDOE Energy Information Administration (EIA), Washington, DC (United
States). Office of Energy Analysis.
Cucchiella, F., D’Adamo, I. and Gastaldi, M., 2015. Financial analysis for investment and
policy decisions in the renewable energy sector. Clean Technologies and Environmental
Policy, 17(4), pp.887-904.
Dewachter, H., Iania, L., Lyrio, M. and de Sola Perea, M., 2015. A macro-financial analysis
of the euro area sovereign bond market. Journal of Banking & Finance, 50, pp.308-325.
Grant, R.M., 2016. Contemporary strategy analysis: Text and cases edition. John Wiley &
Sons.

ANALYSING INFORMATION AND DATA 16
Gu, Z., Li, Z., Yang, Y.G. and Li, G., 2018. Friends in Need are Friends Indeed: An Analysis
of Social Ties between Financial Analysts and Mutual Fund Managers. The Accounting
Review.
Ho, J. and Cheng, W., 2016. Metaphors in financial analysis reports: How are emotions
expressed?. English for Specific Purposes, 43, pp.37-48.
Ho, J. and Cheng, W., 2016. Metaphors in financial analysis reports: How are emotions
expressed?. English for Specific Purposes, 43, pp.37-48.
Kou, G., Peng, Y. and Wang, G., 2014. Evaluation of clustering algorithms for financial risk
analysis using MCDM methods. Information Sciences, 275, pp.1-12.
Lang, M. and Stice-Lawrence, L., 2015. Textual analysis and international financial
reporting: Large sample evidence. Journal of Accounting and Economics, 60(2-3), pp.110-
135.
Lev, B., 2018. The deteriorating usefulness of financial report information and how to reverse
it. Accounting and Business Research, 48(5), pp.465-493.
Pierson, K., Hand, M.L. and Thompson, F., 2015. The government finance database: A
common resource for quantitative research in public financial analysis. PloS one, 10(6),
p.e0130119.
Post, C. and Byron, K., 2015. Women on boards and firm financial performance: A meta-
analysis. Academy of Management Journal, 58(5), pp.1546-1571.
Rai, A.T. and Evans, K., 2015. Hospital-based financial analysis of endovascular therapy and
intravenous thrombolysis for large vessel acute ischemic strokes: the ‘bottom line’. Journal
of neurointerventional surgery, 7(2), pp.150-156.

ANALYSING INFORMATION AND DATA 17
Rigamonti, L., Ferreira, S., Grosso, M. and Marques, R.C., 2015. Economic-financial
analysis of the Italian packaging waste management system from a local authority's
perspective. Journal of Cleaner Production, 87, pp.533-541.
Riley, E.B., Fieldston, E.S., Xanthopoulos, M.S., Beck, S.E., Menello, M.K., Matthews, E.
and Marcus, C.L., 2016. Financial analysis of an intensive pediatric continuous positive
airway pressure program. Sleep, 40(2), p.zsw051.
Sullivan, S.D., Mauskopf, J.A., Augustovski, F., Caro, J.J., Lee, K.M., Minchin, M.,
Orlewska, E., Penna, P., Barrios, J.M.R. and Shau, W.Y., 2014. Budget impact analysis—
principles of good practice: report of the ISPOR 2012 Budget Impact Analysis Good Practice
II Task Force. Value in health, 17(1), pp.5-14.
Vogel, H.L., 2014. Entertainment industry economics: A guide for financial analysis.
Cambridge University Press.

ANALYSING INFORMATION AND DATA 18
Appendices:
Appendix 1:
Product item 2015 2016 2017
printer cartridges 25000 26000 22000
general office supplies 25000 27000 23000
low-cost printers 15000 18000 18000
office furniture 25000 25000 27000
shredders 25000 29000 29000
paper-based supplies 25000 27000 27000
writing/drawing materials 25000 30000 32000
Total Sales =SUM(C5:C11) =SUM(D5:D11) =SUM(E5:E11)