Analysis : Duque consecutive sales data

Summative Assessment

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Overview of the wholesale market of Germany.........................................................................1
TASK 2............................................................................................................................................2
Using excel sheet, producing graph for reflecting annual spending on writing and drawing
materials......................................................................................................................................2
TASK 3............................................................................................................................................3
a. Analysis Duque consecutive sales data in 2015 to 2017.........................................................3
b. Mixed pie chart of product item of 2016 and 2017 sales........................................................4
c. Extracting correlation coefficient of total sales and year with scatter diagram......................4
d. Forecasting sales of year 2018 and 2019................................................................................5
TASK 4............................................................................................................................................5
a. Pros and cons of business expansion in Germany and Belgium.............................................5
b. Applications of international standards to activities of Duque...............................................6
TASK 5............................................................................................................................................7
a. Calculating monthly cost for 30 year repayment mortgages...................................................7
b. Re-calculating monthly cost with application of interest to loan at each month....................8
TASK 6............................................................................................................................................9
TASK 7............................................................................................................................................9
TASK 8..........................................................................................................................................10
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................12
APPENDIX....................................................................................................................................13

INTRODUCTION
In order to develop more effective results, summative assessment consider important role
to deal with stationery products. In the global areas, strong customer base has been created by
Duque Papetiers Gros. It is directly deals with several activities and tasks that develop in
wholesale trade with business in Northern France. Report also provide discussion regarding
stationery market in Germany with challenges and trends. It also shows annual spending with
writing and drawing material per capita in different nations (Deonovic, Yudelson and Maris,
2018). With this regard, report shows sales of three consecutive year from 2015 to 2017 along
with correlation. Furthermore, it also contains mixed pie charts and scatter plot. Therefore, it
reflects with several advantages and disadvantages to expand business in different nations.
TASK 1
Overview of the wholesale market of Germany
Current stationery market in Germany which is positioned in appropriate aspect in Trade
association office. With this regard, writing material and supply also consider as per turnover
with more than €14.8 billion in a particular year. It is equalising spending of individual that is
higher than amount of €182 yearly. In this regard, major portion is belonged with drawing and
writing material that is around €35.2 and Germany also ranked at second level with spent for
stationery in EU nations. There are different companies that reflected with positive attitude in the
industry as fact that more than 70% stationery brand raised sales in 2015 year. With similar
aspect, association of German Stationery brands. Aggregate of turnover has attained growth by
3.5% among year 2014 and 2015. Hence, it is results of increment to increase domestic
requirement that will be accomplished with more growth from 2.5% to 5.5%.
In addition to this, with the latest trends and potentials, stationery in Germany also
develop brand and good reputation. It will assist to ascertained positive image in the market.
Stationery brands of Germany with writing and general instruments had gained that increases
significant market shares which is not favour of private labels. On the contrary, industry also
comprises with broad range of products and services. Hence, positive image can be successfully
gained with several development along with challenges (Deonovic, Yudelson and Maris, 2018).
Furthermore, paper and paper related products consider in document folders that are declining in
continuous aspect in this category of products which create significant digitalisation. It is
1

undertaken in private and work life whereas this category of product attained with positive
growth to grew successful results. In this category, products attained with positive growth and
supplies improvement which can be grew about 5% in year 2015.
TASK 2
Using excel sheet, producing graph for reflecting annual spending on writing and drawing
materials
Interpretation: In the present graph, it can be stated that annual spending represent with
drawing material on the basis of per capita in 2016. In the Germany, stationery market is
2

considered as the important sector that highly contributing in the market. Therefore, it can be
viewed that in Switzerland industry successfully leading to develop more desired level of results.
Moreover, Germany is also gained second position followed by Austria. In the France, forth
position gained in annual spending for writing and drawing material as per capita. German
stationery accomplish huge demand that driven with propensity for consumption and invest with
private and commercial customers. Main reason to take strong positioning is economic growth
35.2 in year 2015.
TASK 3
a. Analysis Duque consecutive sales data in 2015 to 2017
See Appendix for table
Interpretation: In the global market, operations of the chosen business consider on three
year basis. Hence, it explaining role of business entity which includes different factors to set
objectives. Printer cartridges with increment in sales by 4% in each year. However, it also creates
negative effect in 2017 by 15.38% because of general office supplies with essential and huge line
to understand more profit. Low cost of printers accomplish growth 20% in year 2016 so that
break even point has gained where no profit and no loss situation take place. Sales of office
furniture increases as low cost printers in 2017 that is rose by 8%. Cost of shredders constant
develop in year after primary sales that is important for Duque practice in order to consider
complexities.
In addition to this, sales of paper is based on concerned aspect that includes writing and
drawing material is around 20% and 6.67% in 2016 and 2017. Concerned aspect included in
evaluation that increases total sales by 10.30%.
3

b. Mixed pie chart of product item of 2016 and 2017 sales
c. Extracting correlation coefficient of total sales and year with scatter diagram
Annual sales in year
 165000 in 2015
 182000 in 2016
 178000 in 2017
Correlation and coefficient is 0.73
4

Interpretation: From the present analysis, it can be stated that correlation is replicated as
effective tool that assists to determine relationship in two variables. Outcomes from the analysis
replicated as 0.73 that moderate relationship level in year and sales. Range of correlation
specified as it is 0.25 to 0.75 which is moderate. As a result, it shown moderate level of
outcomes. Moreover, it can be summarised that sales with alter positive ways for positive results.
d. Forecasting sales of year 2018 and 2019
TASK 4
a. Pros and cons of business expansion in Germany and Belgium
Expansion of business to Belgium and Germany
Pros Score from 10 Cons Score from 10
Economies of scale 8 Impact on quality and
degrading
7
Reallocation
possibilities
8 Deficiency in
operational control
6
Strong customer base
improvement
9 Huge turnover of
employees
8
Qualified and talented 8 Need of high capital 5
5

personnel
Total pros 33 Total cons 26
Average pros 8.25 Average cons 6.5
Net outcomes: Total pros – Total cons
= 33-26
=7
Interpretation: In the above table, it can be shown that there are several advantages and
disadvantages can be successfully implemented in Germany and Belgium. Advantages can be
framed as economies of scale so that improvement in customer base, reallocation of possibilities
and recruit qualified and talented personnel whose score are aggregated as 33 with average of
8.25. On the other hand, there are certain cons as well as quality that degraded, lack in
operational control, requirement of huge capital and employee turnover with sum of score as 26.
From the analysis, outcomes also develop 7 which gives positive recommendation for expansion
in Belgium and Germany that is more beneficial for the enterprise.
b. Applications of international standards to activities of Duque
In the present scenario, there are several standards exists that are mandatory and
compiled in European countries for the organisation expansion. There are different functions and
activities successfully develop so that international standards can be linked in following manner:
 ISO 9001 Quality management: This standard frame consider different aspect of quality
management that comprises best known standards of ISO. It gives different tools and
guidance for the organisation wants that ensure with services and products to accomplish
requirement with improved. Improved services also helpful to ensure about different
accomplishment requirement of the consumer to know about products and services
(Gauns-Dessai and Kamat, 2018).
 ISO 14000 family environmental management: It gives different practical tool in
business entities with each type to managing various environment responsibilities. It lays
special focus on environmental system to attain desired results with audit approaches,
6

labelling, analysis life cycle, etc. In same series, environmental challenges can be
successfully identified as per climate change (Brown, Ross and Walsh, 2015).
 ISO 26000 Social Responsibilities: It provides guidance on operations in the business
entities so that it is socially responsible and signifies to act in ethical and transparent
method. In health and welfare, it is highly contributed to maintain relationship in society.
 ISO 31000 Risk management: Enterprises which impacting through risks consider
numerous consequences in context of professional reputation and economic performance
as well. Therefore, risk management is also effectively helping the organisation for
performance. As result, risk management assist to perform best in the environment.
 ISO 45001 Occupational health and safety: There are different requirements that assist
to decrease burden with framework of improving employee safety to decrease risk in
workplace (Quellmalz and Silberglitt, 2017). Hence, creating better and safe working
condition throughout world.
 Furthermore, Duque has requirement for complying with data protection act and need of
maintaining confidentiality in context of proper maintenance.
TASK 5
a. Calculating monthly cost for 30 year repayment mortgages
7

b. Re-calculating monthly cost with application of interest to loan at each month
TASK 6
Null hypothesis H0 There is no significant difference with actual mean value with
expected average order value.
Alternative hypothesis H1 There is significant difference in actual mean value with
expected average order value.
Interpretation: In this regard, representing Z score that consider assessment of mean
value order as objective for selecting hypothesis that demonstrate P value. Main criteria in
8

numeric method with value of P. If P value is more than 0.5 then null hypothesis that accepted
and less than 0.05 alternative hypothesis will be accepted. While Z score also valued, that
extracted as 0.23 that is higher than 0.05 so that null hypothesis easily accepted. Hence, it could
be interpreted as actual and also order to move in different direction.
TASK 7
In the organisation, customer responsive to improve performance in context of numerous
methods such as consideration of feedback on immediate aspect after delivering goods and
services within 24 hours. With this consideration, appropriate channels also picked with test
messages or email surveys. Responses rates also decreases so that survey conducted for long
consideration with high time that laid emphasis without incentive. Target audience must be
motivated with attractive design and graphics concise question as well. Reminder surveys must
be send which can boost response as reminder only. After conducting survey, consumers should
thanked and motivated for time and survey completion. Similarly, survey should be directly
personalised for increment response rate with numerous human dimensions. With the help of
customization and invitation for responses, survey also undertaken in positive development.
Descriptive statistics
Interpretation: In order to consider descriptive statistic is the best outcomes of 20
questionnaires as evaluation of primary data. Mean of customer service can report is 1.95 which
is directly exhibiting customer view. It standard deviation that is extracted as 0.51 which shows
less movement of risk so consumer perception level so that it is not present with average
participants. In this statistical evaluation, Duque has provided suggestion for cost control and
affordable product's price for raising satisfaction level.
9

TASK 8
In order to summarised overall tasks, it can be stated that stationery business
continuously develop in Belgium and Germany successfully. As a result, pros and cons also
determined that helps to identify expansion reasons in the new areas. With the help of these
perspectives, it can be stated that positive outcomes can be successfully develop in the selection
of hypothesis. On the basis of mean and data, it can be stated that appropriate suggestions can be
successfully made increasing level satisfaction. Target audience also develop with cost control
and affordable price to increase appropriate functioning.
CONCLUSION
From the above study it can be stated that stationery market to increase year to give huge
contribution in the industry. With drawing and writing material, industry will able to get high
competition within the market that contain several suppliers to show effectiveness and
importance with appropriate diversification. Furthermore, it can be concluded that product
quality also successfully develop that has been shown in Duque to attain success with
consideration of positive level of outcomes. It is the best perspective for the chosen enterprise to
expand their operations in new areas. From the analysis, it can be stated that expansion in
Belgium is more beneficial because the chosen business can easily focus on the different pricing
to ensure specific margin that influence decision-making of customers.
10

REFERENCES
Books and Journals
Quellmalz, E.S. and Silberglitt, M.D., 2017. Affordances of Science Simulations for Formative
and Summative Assessment. Technology Enhanced Innovative Assessment:
Development, Modeling, and Scoring From an Interdisciplinary Perspective. p.71.
Brown, C., Ross, S. and Walsh, K., 2015. Money makes the (medical assessment) world go
round: The cost of components of a summative final year Objective Structured Clinical
Examination (OSCE). Medical teacher. 37(7). pp.653-659.
Gauns-Dessai, K. and Kamat, V.V., 2018. Security analysis of conventional/electronic
summative assessments.
Deonovic, B., Yudelson, M. and Maris, G., 2018. Assessment meets Learning: On the relation
between Item Response Theory and Bayesian Knowledge Tracing. arXiv preprint
arXiv:1803.05926.
Keane, L. and Griffin, C., 2016. Testing the limits of self-assessment: A critical examination of
the developmental trajectories of self-assessment processes. Irish Teachers’ Journal.
p.37.
Joshi, M.K., Singh, T. and Badyal, D.K., 2017. Acceptability and feasibility of mini-clinical
evaluation exercise as a formative assessment tool for workplace-based assessment for
surgical postgraduate students. Journal of postgraduate medicine. 63(2). p.100.
Deonovic, B., Yudelson, M. and Maris, G., 2018. Learning meets assessment. Behaviormetrika.
pp.1-18.
11

APPENDIX
12