Detailed Analysis and Recommendations for Donald Duque Company

This report analyzes the business operations of Donald Duque, a wholesale stationery company, with a focus on the German market. It examines market trends, sales data, and financial performance, including calculations of total sales, per capita spending, and correlation coefficients. The report includes graphical representations like pie charts and scatter plots to illustrate data and estimate future sales trends. It evaluates the company's strengths and weaknesses, proposes recommendations for improvement, and addresses international standards for compliance. The analysis covers mortgage calculations, hypothesis testing, and provides advice for business expansion and strategic decision-making. The report concludes with a summary of findings and recommendations for the company's future growth and development.

Analysing Data

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Presenting the brief overview of wholesale stationery market in Germany...............................1
TASK 2............................................................................................................................................3
Assessing annual per capital spending on writing and drawing material:..................................3
TASK 3............................................................................................................................................4
a). Evaluation of total sales:........................................................................................................4
b). Pie chart.................................................................................................................................5
C). Correlation co-efficient via Scatter plot:...............................................................................6
D). Estimating sales trends for the period between 2018 and 2019............................................7
TASK 4............................................................................................................................................7
a). Pros and Cons evaluation.......................................................................................................7
b). Elaborating international standards with which cited company requires to comply with:....7
TASK 5............................................................................................................................................8
a). Computing monthly cost of 30 year repayment mortgage:....................................................8
b. Re-calculating monthly cost assuming that the interest is applied to the loan every month...8
TASK 6............................................................................................................................................9
TASK 7..........................................................................................................................................10
a). Advice for improvement:.....................................................................................................10
b). Descriptive statistics............................................................................................................12
TASK 8..........................................................................................................................................13
Recommendation.......................................................................................................................13
CONCLUSION..............................................................................................................................13
REFERENCES..............................................................................................................................15
APPENDIX....................................................................................................................................16

INTRODUCTION
Analysing of data is the most crucial tool for analysing the business statistically and
financially. However, this can be said that for gaining competitive advantages in an effective
manner. In this report, various tools are used for analysing the data which would help out to
assess the future trends and henceforth assist in effective decision making (Silverman, 2015).
This report is totally relied upon the Donald Duque which is small scale company and situated at
Northern France. Donald Duque specially deals in wholesale trade instead of selling stationery
products directly to the public. goods which are offering by these business units, covers: printer,
general office supplies, Furniture for commercial purpose, drawing materials etc. Under this
report, trends of wholesale stationery market in Germany. This is likewise spending on drawing
material per capita. Report likewise renders in which graphical presentation assist in
summarising data set.
TASK 1
Presenting the brief overview of wholesale stationery market in Germany
Wholesale stationery market in Germany is in the peak position all around the globe.
Henceforth, now there is a strong need to have various organisations in Germany that renders
clients with quality products. Some of them are: Staedtler, Stadbilo, Lamy etc.
The above mentioned graph reflects in 2002, efficient reduction evaluated during number
of office supplies and stationery retailer. There are vast wholesalers in 2002 as 7973 wholesalers
1

are indulging there which was gradually decreased as the year passed on. While after 10 years or
in 2012, number of wholesalers in Germany market decreased and come to 6047 and in 2015,
this was come to 5200 during 2015. Thus, during these period, offices accounted for 5200 only
which was lower as compared to earlier time-frame. In addition to this, focus is likewise laid
down by the suppliers on introducing contributing innovative stationery items or services to the
consumers which could satiate their expectation level in an effective manner. Apart from this, by
growing demand of the suppliers in global market,growth in the sales revenue emerged by 3.5%
effectively (Uemura and et.al., 2016). In addition to this, effective changes were required to be
evaluated in these industry after entering of specialist retailers. In addition to this, these retailers
are providing premium or high quality goods using their own labels. In addition to this, these
kinds of retailers are offering premium or more quality goods using their own labels which
would ultimately affect the profitability in a positive manner. They believe that labelled goods
enables easy identifying the same. Apart from this, stationery market in Germany, having the
online marketing of products which shows that 24 hours availability. Henceforth, by forming
online presence Donald Duque could gain success (Wimmer and et. al., 2013).
2

TASK 2
Assessing annual per capital spending on writing and drawing material:
By convening research, this is rightly evaluated that out of the total customer spending,
€35.2 linked up to drawing and writing material. Out of the European countries like Austria,
Belgium, Bulgaria, Cyprus, Denmark etc. Germany has positively secured 2nd position in the
stationery market (Song and et.al., 2016). While on the other hand, France attained fourth
position. Thus, product collection or variety controlled by the supermarket which has formed
effectively contribution for achieving leading position. In addition to this, with motive to emerge
awareness among the consumers and affects their buying decision emphasis which have made by
the suppliers on rendering advertisements on newspapers, electronic magazines (MGCC
Perspective - German Chamber of Commerce and Industry, 2016).
In addition to this, an effective in change in the market which has determined after
introducing digitization. Online is the products or services renders that renders huge kind of
convenience to the consumers. Henceforth, this is one of the crucial tool which now customers
buying goods through online instead physical store (De Muth, 2014). Apart from that, more
growth has been found via online manner instead of set up of online store. Henceforth, there is a
3

rise of entire stationery business which has been seen almost 17% hike in the overall industry. In
Germany, retailers also requires to have concentration on strengthening or improving their
market share (Ghilani, 2017).
By relying upon industrial trend, this could likewise be depicted that it would enhance in the near
future. Decreasing trends has also evaluated in the number of pupils by 11.9% which helps in
turn places adverse affect on the desire for writing and drawing material.
TASK 3
a). Evaluation of total sales:
Refer appendix 1
For assessing the figure of total sales, revenue of entire products from entire products
covers in item portfolio which have been added. In addition to this, for reflecting desirable sales
view or trend comparison of available year has likewise been done along with last year
(Shevlyakov and Smirnov, 2016). During 2015 2016 and 2017, this can be said that total sales
has been calculated by sum up of all the items which have been sold by the cited company. Total
sales of the Donald Duque is calculated: €165000, €182000 & €178000 significantly. By
evaluating the sales revenue of the organization enhanced by 10.30% and 2,20% respectively. By
identifying the total sales by the product over the last 3 years, the research elaborated that
organisation produces optimum sales from supply of writing and drawing material and shredders.
Although, low cost printer elaborated least sales value of €51,000.
4

b). Pie chart
By evaluating the above mentioned pie chart, this could effectively been said that the
Donald Duque is having low cost printers which can contributed to least percentage in 2016 and
2017. on the other hand, this can rightly be said that printer cartridges accounted for 16% at the
time 2016 which ultimately enhanced to 18% from the total sales.
C). Correlation co-efficient via Scatter plot:
Year Total sales (in €)
2015 165,000.00
2016 182,000.00
2017 178,000.00
Correlation coefficient 0.73
5

2014.5 2015 2015.5 2016 2016.5 2017 2017.5
155000
160000
165000
170000
175000
180000
185000
Total sales (in €)
Scatter diagram plots two main diverse values in accordance with two axes and pattern
demonstrated by the points reflected correlation between both of the variables (Klein, 2017). By
checking to the graph according to the year enhanced, total sales demonstrated increasing trends
which could indicates that year and sales performance which predate positive links. The value of
the correlation coefficient between both of the variable are identified to +0.73 which reflects that
over the period, sales enhanced by 73% as of increasing domestic and overseas demand for the
stationery products.
D). Estimating sales trends for the period between 2018 and 2019
Year Sales
2018 €6500x + €162000
= €6500 (4) + €162000
= €188000
2019
€6500x + €162000
= €6500 (5) + €162000
= €194500
TASK 4
a). Pros and Cons evaluation
6

Pros Score/10 Cons Score/10
Customer base
improvements 9 Excessive staff turnover 5
Economies of scale 8 Consequence on quality 8
expert personnel 7 Progressive capital demand 7
Relocation possibility 6 Non-achievement of
operational control 6
Total Pros 30 Total Cons 26
Net results or outcome: Total score of pros – cons
= 30 – 26
= 4
By presenting crucial outcome, this can be said that Donald Duque concentrates on the
expansion strategy. Henceforth, this is highly predicted that strategy which are specifically
concerned to the expansion of business operations in Germany and Belgium that could gain high
benefits. This mostly assist in improving customer base and therefore, profits and sales in an
effective manner.
b). Elaborating international standards with which cited company requires to comply with:
For emerging a more efficient performance of a company, managers of the cited company
requires to implement international standards (De Muth, 2014). They are various parts of
standards that can be connected with organization for providing secure data. There are so many
standards via which European firms are able to comply with their organization's activities. There
are so many standards via which providing secure data. There are so many standards via which
various organization are able to comply during execution of business activities and functions.
Henceforth, global standards are linked with operations of Donald Duque are mentioned below: ISO 14000 family-environmental management: On relying upon this standard, firms has
the responsibility to form an adequate planning in an ecological way. ISO 45001 Occupational health and safety: By relying on these standard, this is the
whole responsibility of cited organization to form an efficient planning which are related
to the health and safety of the personnel during workplace (International Organization for
Standardization, 2015).
 ISO 31000 risk management: For attainment of business targets, risk management
practices and strategies requires to be adopted by Donald Duque.
7

In addition to this, referred organization is required to have with the Data Protection Act
and according to the same confidentiality related to the information requirements are controlled.
Apart from that, cited organization required to adhere the set quality standards at the time
of forming manufacturing and offering stationery products to the consumers.
TASK 5
a). Computing monthly cost of 30 year repayment mortgage:
Particulars Figures
Time 30 years
Loan payment = Total loan
amount / Discounting factor =
= € 21215.85
Monthly repayment € 21215.85 / 12
= €1767.98
b. Re-calculating monthly cost assuming that the interest is applied to the loan every month
Particulars Figures
Time period (n) 30 years * 12 months (each year) = 360 times
Interest rate per month (R ) 10% / 12 = 0.00833
Monthly repayment
8

TASK 6
H0 (Null hypothesis): Under this, there is no significant difference in the mean
value of expected and actual average order value.
H1 (alternative hypothesis): There is a significant difference in the mean value of
expected and actual average order value.
Particulars Outcome
Mean of the entire population 240
Average of sample 230
Standard deviation 43
Z score assessment [ (Mean of the entire
population – sample average) / standard
deviation ]
(240 – 230 ) / 43
= 10 / 43
= 0.23
Criteria’s for selection and rejection of hypothesis
P > 0.05: Null hypothesis accepted or true
P < 0.05: Alternative hypothesis proved or true
By rendering evaluation, this can be render that p value of Z score 0.23 accounts for 0.59
significantly. These kinds of emergence reflects that p value is more than the standard limit like
as 0.05. Thus, this can be said that the total account is forecasted to assess entire positive
responds. By way of this emergence, this can be assessed that there is a strong differences and in
that situation, null hypothesis is totally accepted.
TASK 7
a). Advice for improvement:
In accordance with the below mentioned questionnaire, company's management could
form separate decisions regarding to the expansion of organization progressive. In addition to
this, 20 respondents were incorporated from market and underneath questionnaire which is
provided to them for evaluating an efficient decision making.
9