Duque Papetiers Gros: Expanding into the German Stationary Market

DUQUE ASSIGNMENT

TABLE OF CONTENTS
1. Introduction..............................................................................................................................................1
2. Analysis of Issues for Duque Papetiers Gros..........................................................................................1
2.1 An Overview of the Wholesale Stationers Market in Germany........................................................1
2.2 Annual Spending on Writing/Drawing Materials per Capita............................................................2
2.3Analysis of Duque’s last three financial years of sales data (2015-2017)..........................................3
2.4 Feasibility of Expanding to Germany & International Standards.....................................................5
2.5 Costs of a New Building....................................................................................................................7
2.6 Mean Value of Orders.......................................................................................................................8
2.7 Customer Satisfaction........................................................................................................................8
Conclusion...................................................................................................................................................9
REFERENCES..........................................................................................................................................10
APPENDIX................................................................................................................................................11
For question 2.3.....................................................................................................................................11
For question 2.6.....................................................................................................................................11

LIST OF FIGURES
Figure 1: Annual spending for writing and drawing material.....................................................................3
Figure 2: last three financial years of sales data..........................................................................................3
Figure 3: Mix pie chart for financial year 2016 and 2017...........................................................................4
Figure 4: Scatter diagram for three years....................................................................................................4
Figure 5: Formula used in Excel..................................................................................................................7
Figure 6: Total sales...................................................................................................................................10
Figure 7: Formula used to total the values.................................................................................................10

LIST OF TABLES
Table 1: Pros and cons.................................................................................................................................5
Table 2: Parameters for CUMIPMT function..............................................................................................7