Case Study Project: Duque Papetiers - Business Expansion Analysis

This case study examines Donald Duque's stationery business, focusing on data analysis and strategic decision-making for expansion. It analyzes the wholesale stationery market in Germany, including market size and per capita spending. The study presents sales data for the past three years, with a focus on product performance and forecasting. It also evaluates expansion plans to Belgium and Germany using a pros and cons analysis. Additionally, the case includes calculations for a 30-year mortgage and discusses relevant international standards (ISO). The analysis covers various aspects of the business, including product sales, market trends, and financial considerations to inform future business decisions for Duque Papetiers.

CASE STUDY PROJECT
DUQUE PAPETIERS GROS

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
1.1: Overview of wholesale stationary market in Germany...................................................1
TASK 2............................................................................................................................................2
2.1: Annual expenses incur over material of writing and drawing as per capita ...................2
TASK 3............................................................................................................................................3
3: Analysis of various sales data of Duque's for past three financial year ............................3
TASK 4............................................................................................................................................1
TASK 5............................................................................................................................................3
a) Calculation of monthly cost of 30 year repayment mortgage of €200000.........................3
TASK 6............................................................................................................................................3
TASK 7............................................................................................................................................4
a) Ways that are used for reviewing customer response rate.................................................4
b) Descriptive statistics (mean, standard deviation)..............................................................4
TASK 8............................................................................................................................................4
Conclusion .............................................................................................................................4
REFERENCES................................................................................................................................6

INTRODUCTION
Donald Duque is an essential small size home stationery business operations which is
located in Northern France. As mentioned under the case that Donald does not having knowledge
about business data analysis. In order to overcome all those effect they have decided to make use
of decisions in effective manner. They are associated with wholesale trading and formulate a
positive customers base in past 50years. There product portfolios has been divided into cartridges
of printer, office assets suppliers, low cost printers, furniture as well as drawing or other
associated materials. However, future decision making is related with all those problems and
conclusion techniques and make appropriate solution that is analyse by using statistical tools of
measurement.
TASK 1
1.1: Overview of wholesale stationary market in Germany
It has been seen that every business organisation needs to make use of data in effective
manner so that positive results can be generated in more quick and easy time. Stationary market
is growing at more faster rate because of maximum attention of people toward generating more
effective outcomes for the company. Germany's is being known for present stationary industry
which is well positioned. The turnover of entire sector is more than £14.8 billion per year which
is equal to every individual those are spending in more than £182 annually. Germany is
considered as second in term of spending maximum of their spending over stationary in countries
like European unions.
The positive attitude of an organisation in the stationery sector which is underpinned by
the facts that is more than 70% of Germany major stationary brands which is having more
experienced enhancement in total sales in 2015. The German brands have more positive goodwill
in local and international level. Because of positive image, various brands in common and
writing instrument in specific manner to gain important market share against private labels.
Henceforth, this business includes certain specific broad range of products with various
formulating and challenges that are affecting the business growth and performance of an
organization. According to mentioned case, it has been analyse that a total of 2200 wholesale
companies are recently working Germany market which is ready to offer office supplies, paper
and other essential aspects. Some other B2B business intermediaries are serving as commercial
customers more directly.
1

TASK 2
2.1: Annual expenses incur over material of writing and drawing as per capita
Country Per capita (€)
Switzerland 35.5
Germany 35.2
Austria 35
France 28.3
Italy 18.6
Spain 8.9
Poland 8.5
On the basis of above bar graphs,it has been analyse that Germany is taken as second
largest market which is dealing in stationery after Switzerland in terms of per capita income of
€35.2. this amount is entirely spend over writing and drawing materials. Along with this, by the
aim of creating awareness among various customers to make influence about their buying
decisions. Although from this, companies is needed to be primary objectives of creating
maximum awareness among various countries in order to influence their purchasing decision.
This particular stationary products is being sold out into different nations that are provided into
the bar chart. From this, it has been determine that hypermarkets and supermarkets would be
more primary responsivle for contributing more to an economy in order to maintain diversified
product portfolios. This should play a dominent role in gaining wide position and would become
2

one of the biggest contribution to the nation. The primary role of those market is to maintain
valuable application to deal with effective approaches which assist in examine behaviour of
various customers those are using products of the company. The motive of every researchers is
to be planning according to make suitable application to face with effective techniques that will
be essential to determine perception of customers. With the introduction of digital technology
and forumation of e-commerce has providing wide share of market in terms of stationary in
Germany. The positive exchange of this mode is about 24 hours availablity in relation with
various types of products.
TASK 3
3: Analysis of various sales data of Duque's for past three financial year
a): Total sales
Products 2015 sales 2016 Sales 2017 sales Total sales
Printer cartridges 25000 26000 22000 73000
General office supplies 25000 27000 23000 75000
Low cost printers 15000 18000 18000 51000
Office furniture 25000 25000 27000 77000
Shredders 25000 29000 29000 83000
Paper based supplies 25000 27000 27000 79000
Writing/ Drawing
materials 25000 30000 32000 87000
Total sales 165000 182000 178000
According to the above information, it has been found that the last year sales of various
products those are being sell by the company are having certain variations. The total sales in
2015 is maximum because they are selling products at similar costs. This changes are increase in
2016 because of variations in prices of their products. They are generating total product of
182000. In 2017, the sales volume has come down to 178000 due to slight medication in cost
price of printer and office furniture. The overall estimation provide crucial information that
drawing material and writing are main sources which is sold out more easily.
B): Pie-chart
c): Scatter diagram to determine correlation coefficient
Year Total sales (in €)
3

2015 165000
2016 182000
2017 178000
Correlation coefficient 0.73
It is an essential chart which is indicating total values to two variables those are being
plotted along with two axes. The graphs is showing strong positive correlation among their to
make clearly visible upward trends from left to right. It is one of the most simplest techniques to
present effective analyse among two different variables. The total sales and year is major parts
which is being present through using scatter diagram. From the below mentioned charts, it has
been seen that there is continuous increase in total sales that reveal maximum increase overall
trend that would indicate by using current performance in a year. The value of correlation
indicate sale increase with 73% because of domestic as well a international demand of stationary
products.
2014.5 2015 2015.5 2016 2016.5 2017 2017.5
155000
160000
165000
170000
175000
180000
185000
165000
182000
178000
Scatter diagram
Total sales (in €)
d): Forecasting total sales
4

In order to determine overall sales of the company. For this purpose upcoming sales
forecasting is needed to be done to examine current and historical year results. To control their
losses it is vital to make estimation for the future.
Year Sales
2018
€6500x + €162000
= €6500 (4) + €162000
= €188000
2019
€6500x + €162000
= €6500 (5) + €162000
= €194500
1 2
2017.4
2017.6
2017.8
2018
2018.2
2018.4
2018.6
2018.8
2019
2019.2
2018
2019f(x) = x + 2017
Trend line
Year
Linear (Year)
Sales
From the above trend line equation, it has been said that there is specific amount of
growth in their total sales in 2018 and 2019.
5

TASK 4
Analysation of expatiation plans for Donald Duque's operations are carried out in
northern france.
Should I expand my
business to Belgium
& Germany?
Pros Score/10 Cons Score/10
Team members are eligible to work
together and feel stressless while at
work 8
Difficulty level in staff
members subject to
building productive,
creative relationship with
other staff members
-9
Independence, flexibility, and
dependency on supporting
resources 7
Budget for equipments
which is maintained by
employees while working
at home
-6
Creative and lien thinking in nature
of employees and staff members 6 Level of tracking the
performance of
employees -5
Level of distraction while working
in the organisation 5 Level of completion of
task with in given
deadline and time limit
-4
Skills like communication,
presentation and regular
interruption 6 Interaction program by
face to face interaction -6
Possibilities of engagement and
growth in near future 5 Level of control in respect
of operation and
management -7
Total Pros 37 Total Cons -21
Average Pros 6.17 Average Cons 3.5
Net result form Pros and cons method = Total of pros – Total of cons
= 37 – 21
= 6
as per above analysis it is seen that the pros and cons methods gives positive results in respect of
Donald Duque regarding exploring the scope of business in Germany and Belgium. There are
some certain aspects need to rectify in order to attain more appropriate and positive outcomes
such as eligibility of creative and innovative thinking. There is also one essential aspect need to
control which is building productive and creative relationship with other staff members.

Internal standard which are required to implement by Donald Duque
there are some list of standards can applied by Donald Duque for effective management
and performing better at international level.
ISO 14001 Environmental management: this standard is prepared for family of
standards which provides practical tools for organisations and companies. This standards is made
to manage environmental responsibilities. This standard helps organisation in order to maintain
environment friendly nature inside and outside the organisation.
ISO 50001 Energy management: this standard helps to organise and manage the energy
level in well managed order. It also assist management actions and functions in order to proper
utilisation of resources.
ISO 3166 Country codes: Decoding and recognising of international codes is one of the
main objective of this standard. These codes are used to refer countries and sub departments.
This standard helps organisations to avoid complexities and problems subject to resolving issues
and conflicts occurs during decoding countries codes.
ISO 45001 Occupational health and safety: this standard helps to analyse the health and
safety management system for managing system. It helps to reduce the burden and provides a
framework to enhance employee safety and reducing risk. Provide safe work environment is one
of the prime objective of this standard.
ISO 26000 Social responsibility: fulfilling social responsibilities and duties is one of the
main objective of international organisation which deals in various countries. This is considered
as critical factor subject to maintain and operate social relationship.
ISO 13485 Medical devices: this standard contains quality management and services
subject to managing and operating medical functions and operations. Requirement for regulatory
purpose it become essential to apply quality management system for specific medical devices
industry.
ISO 31000 Risk management: this ISO helps to analyse the associated risk with
economic performance and professional honour. This helps to estimate safety and societal results
by assessing risk.
ISO 37001 Anti-briefly management systems: this helps to remove the aspects of bribery
and fraud events and transactions. This standard prevent unethical and unprofessional actions. It
helps to reduce the possibilities remain associated with bribery risk.
2

TASK 5
There is a practical scenario given below subject to expand international operations. It is
asked for negotiating mortgage at €220,000 which might be closer to €200,000.
a) Calculation of monthly cost of 30 year repayment mortgage of €200000
Particulars Figures
Time 30 years
Loan payment = Total loan amount /
Discounting factor =
= € 21215.85
Monthly repayment € 21215.85 / 12
= €1767.98
b) Re calculation of monthly cost if 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
TASK 6
Analysing reviews of customers by methods received by his firm is about €240.
accountants office decides a strategy of randomly selecting a sample of 50 accounts and find out
a simple mean of €230 and standard deviation of Analysing reviews of customers by methods
received by his firm is about €240. accountants office decides a strategy of randomly selecting a
sample of 50 accounts and find out a simple mean of €230 and standard sample of 43.
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
3

H0 (Null Hypothesis): as per this, there is no significant difference in the man value of
expected and actual average order value.
H1 (Alternative hypothesis): there is a significant difference between mean value of
expected and actual average order value.
It is measured as:
P > 0.05: Null hypothesis accepted or true
P < 0.05: Alternative hypothesis proved or true
(Where P denotes the results)
as per above analysis there P is computed as 0.23 for score which is more then 0.05 so
null hypothesis is accepted in this scenario. There is a significant difference between mean value
and actual order value.
TASK 7
a) Ways that are used for reviewing customer response rate
There is a survey organised by Donald Duque to analyse the review of customers. To get
feedbacks and reviews questionnaire sent to customers via e-mail. Respondents rate was 5%.
Donald Duque can enhance survey responsive rates. With the help of these ways.
b) Descriptive statistics (mean, standard deviation)
Particulars CUST_SERV QUAL_P&S SALES_STAFF PRICE_VALUE
Mean 3.5 3.15 3.45 1.95
Standard Error 0.17 0.08 0.18 0.11
Median 4 3 4 2
Mode 4 3 4 2
Standard Deviation 0.76 0.37 0.83 0.51
Interpretation:As per primary data evaluation following results come across such as
found respondents rate subject to customer service support and quality management. Favourable
results come across statistical analysis. Mean value of the element pertaining to price expressed
for 1.95 which shows favourable condition. Standard deviation is accounted for .51 which is in
optimum manner.
TASK 8
Conclusion
From the above project report, it has been concluded that that Germany has being
develop as strong position in stationary market. This happens to be more crucial to determine
4

current market position of the time. Although, it can be inferred that German stationery suppliers
are determine as maximum on diversified business and product quality. The entire report is sum
up with proper evaluation of wide number of people those are spending their level of income on
purchasing writing and drawing stationary material. However, it has been articulated the
company can attain their overall growth as well as positive outcome by influencing business
operations in various parts of the nations. It has been examine form the overall calculation of
various information that can laid down the entire focus on employing overall competent pricing
policy that used to run in order to attain better outcomes in near future.
5