Ask a question from expert

Ask now

Analysing Information and Data for Problem Solving

14 Pages2704 Words398 Views
   

Added on  2020-10-22

About This Document

Analysing Information and Data for Problem Solving TABLE OF CONTENTS INTRODUCTION 1 TASK 11 Overview of wholesale stationers market in Germany 1 TASK 22 Using excel sheet, producing graph for reflecting annual spending on writing/drawing materials per capita 2 TASK 33 a. It is outcome of increment in raising domestic demand which had accomplished growth by 2.5% and international demand grew by 5.5% (Germany – A Potential Stationery Market, 2018).

Analysing Information and Data for Problem Solving

   Added on 2020-10-22

BookmarkShareRelated Documents
Analysing Information and Datafor Problem Solving
Analysing Information and Data for Problem Solving_1
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................1Overview of wholesale stationers market in Germany................................................................1TASK 2............................................................................................................................................2Using excel sheet, producing graph for reflecting annual spending on writing/drawingmaterials per capita......................................................................................................................2TASK 3............................................................................................................................................3a. Analysing Duque;s consecutive three year sales data of year 2015 to 2017...........................3b. Mixed pie chart of product item of 2016 and 2017 sales.........................................................4c. Extracting correlation coefficient of total sales and year with scatter diagram.......................4d. Forecasting sales of year 2018 and 2018.................................................................................5TASK 4............................................................................................................................................5a. Assessing pros and cons of business expansion in Germany and Belgium.............................5b. Application of International standards to activities of Duque.................................................6TASK 5............................................................................................................................................7a. Calculating monthly cost of 30 year repayment mortgages.....................................................7b. Re-calculating monthly cost with application of interest to loan at each month.....................8TASK 6............................................................................................................................................8TASK 7............................................................................................................................................9CONCLUSION................................................................................................................................9REFERENCES..............................................................................................................................11APPENDIX....................................................................................................................................12
Analysing Information and Data for Problem Solving_2
INTRODUCTIONThe Duque Paertiers Gros is business entity which directly deals with numerousstationery products and distributor in global market. It has built strong customer base from 50years as it includes wholesale trade with business in Northern France. This report will providediscussion about stationery market in Germany along with challenges and trends. Further thiswill show annual spending on writing and drawing material per capita in seven Europeancountries. In the similar aspect, it will articulate sales of three consecutive year 2015 to 2017along with correlation, mixed pie chart and scatter plot as well. This will reflect different prosand cons for business expansion in Belgium and Germany.TASK 1Overview of wholesale stationers market in GermanyThe current stationery industry of Germany is positioned in appropriate aspect and as perTrade association of Office Writing materials and Supply, its turnover is more than €14.8 billionin single year, which is equalising spending of individual which is higher than €182 yearly. Amajor proportion is belonged towards writing and drawing material which is €35.2 because ofthis Germany has ranked second as it has spent for stationery in European Union countries.There are numerous companies which had reflected positive attitude in this industry as fact isthat more than 70% stationery brand has raised sales in year 2015.In the similar aspect,Association of German Stationery brands, its aggregate of turnover has attained growth by 3.5%among year 2014 and 2015. It is outcome of increment in raising domestic demand which hadaccomplished growth by 2.5% and international demand grew by 5.5% (Germany – A PotentialStationery Market, 2018).By considering trends and potentials, Germany stationery brands has good reputationthrough world especially in Germany. It has attained positive image, stationery brands ofGermany with writing and general instruments had gained significant market shares which arenot in favour of private labels. On the contrary, industry comprises a broad product range withvarious developments along with challenges as well. In this aspect, paper and paper relatedproducts such as document folders are declining in continuous aspect as this category of productis suffering significantly because of digitalisation which is undertaken in private and work life(Darnton, 2016). However, this category of product has attained positive growth as well as officewriting and supplies instruments which grew about 5% in year 2015.1
Analysing Information and Data for Problem Solving_3
TASK 2Using excel sheet, producing graph for reflecting annual spending on writing/drawing materialsper capitaEuropean CountriesAnnual spendingSwitzerland35.5Germany35.2Austria35France28.3Slovenia20.4Italy18.6Hungary9.6SwitzerlandGermanyAustriaFranceSloveniaItalyHungary051015202530354035.535.23528.320.418.69.6Annual spendings in European countriesAnnual spendingInterpretation: The above graph is representing annual spending on writing/drawingmaterial per capita of year 2016. The Germany stationery market is considered as one of vitalsectors which is contributing highly to German economy. It could be clearly viewed thatSwitzerland is leading in this industry, where Germany has gained second position followed byAustria. Further France has gained fourth position in annual spendings for writing and drawingmaterials per capital.German stationery has accomplished huge demand as it is driven through high propensityfor consumption and to invest through private along with commercial customers. The mainreason for Germany with strong positioning and economic growth as 35.2 in year 2015 along2
Analysing Information and Data for Problem Solving_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Analysis : Duque consecutive sales data
|15
|2641
|97

Wholesale Stationery Market in Germany
|13
|2656
|242

Overview and Trends of Stationery Market in Germany
|13
|2546
|63

Sales of stationary products in Germany and Belgium
|13
|2746
|185

Duque Case Study | Assignment
|14
|2651
|28

DUQUE CASE STUDY.
|14
|2651
|43