Business Data Analysis - PDF

Added on - Jan 2021

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 14 pages
BUSINESS DATA ANALYSIS
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................1Overview of stationery market in Germany................................................................................1TASK 2............................................................................................................................................2TASK 3............................................................................................................................................2a. Sales Assessment.....................................................................................................................2b. Mixed pie chart of 2016 and 2017..........................................................................................3c. Correlation coefficient of Total sales and year.......................................................................3d. Forecasting sales of 2018 and 2019........................................................................................4TASK 4............................................................................................................................................4a. Business expansion in Belgium and Germany with its Pros and Cons...................................4b. List of International standards must be complied by Duque...................................................5TASK 5............................................................................................................................................6a. Calculating monthly cost with 30 year repayment mortgages................................................6b. Recalculation with assumption of monthly cost with interest rate application.......................6TASK 6............................................................................................................................................6a. Calculating mean value of order.............................................................................................6TASK 7............................................................................................................................................7a. Methods for increasing consumer survey rate.........................................................................7b. Descriptive statistics...............................................................................................................8CONCLUSION................................................................................................................................8REFERENCES..............................................................................................................................10APPENDICES...............................................................................................................................11Appendix 1................................................................................................................................11
INTRODUCTIONBusiness data analysis considers activities which helps managers for undertakingstrategic decisions , attaining major objectives and to solve complex issues through gathering,reporting and for analysing important information as per requirements of managers. The presentreport will discuss about Duque Papertiers gross with stationery business and will reflectoverview on stationery market. This report will discuss about annual spending of writing anddrawing materials per capita with product category of total sales of year 2015, 2016 and 2017along with methods for raising consumer survey responsive rate.TASK 1Overview of stationery market in GermanyIn the present scenario, there is development of stationery industry with reference tomultiple products and services which helps in adjusting innovative consumer preferences andhabits with increment in market vitality and special issues arose in the present trend. Thisindustry is well positioned as it has turnover which is more than €14.8 billion per year as it isequal to individual's yearly spending which is more than €182 on annual aspect. It has beentraced that Germany had spent €35.2 on drawing and writing materials as it is at second positionin European countries. The organization's positive attitude with context of stationery industry isunderpinned with more than 70% of German stationery brand have increment is sales withcontext of year 2015. As per association of German Stationery brands its total turnover hadattained growth of 3.5% within year 2014 and 2015. In this aspect, its outcome with reference todomestic demand has accomplished growth with 2.5% and international demand with 5%.These stationery brands of Germany has the best reputation throughout world as with itspositive image they have significant market shares of writing and drawing materials against theprivate labels. Consequently, industry comprises products with broad range along with differentdevelopment along with challenges. The paper and its products such as document folders havecontinued for getting turnover in declining aspect as this category of product is suffering becauseof increment in digitisation which has been undertaken in private and work life. Conversely, thepaper products, brands of categories of other product had attained positive rate of growth likeoffice and writing instruments has attained growth with 5% in year 2015 as this trend is expectedwith continuation in year 2016 (MGCC perspectives,2018).1
TASK 2CountryYearly spending €Germany35.2France28.3Switzerland35.5Italy18.6Hungary9.6Poland8.5Austria35Interpretation:The above graph is showing annual spending of writing and drawingmaterials of European countries where Switzerland is leading and Germany is at second positionwith 35.2 followed by Austria and Poland is at last with 8.5. Further, it has been stated thatwriting and drawing materials in Germany had gained significant market share among theseEuropean Union countries.TASK 3a. Sales Assessment(Table attached in appendix)The sales of year 2015, 2016 and 2017 have been traced with its major categories such asprinter cartridges, general office supplies, low cost printers and many more. It has been observedthat printer cartridges are raising by 4% in 2016 but in 2017 decreased with 15.38% and this wassimilarly articulated in general office supplies as 8% in 2016 and decreased with 14.81%.2
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access