INTRODUCTION
Data analysis involves gathering valuable information, data, records, and detailed reports for an in-depth study of project plans. It includes business analysis and evaluation based on effective research methodologies and techniques. This process encompasses transforming, modeling, inspecting, and evaluating data to support systems (William Glover and Prawitt, 2016). Various evaluation methods are used in analyzing business data and information. This report examines the data and information of Donald Duque, who owns a small family stationery business in Northern France, focusing on how business analysis impacts the potential for business expansion.
2. Analysis of Issues for Duque Papetiers Gros
2.1 An overview of the wholesale stationers market in Germany
Donald Duque operates a small family stationary business in France. Owners of the organisation wants to analyse the data of own admission, subject to expand their existing business at next level.Donald wants to analyse the relevant information related to expanding the business scale at next level.
As per the report published in the office Times in Germany the stationery retailers in Germany got reduced due to lack of demand of stationery products in the past. There is an ageing population with few academies and schools reduced the demand of stationery products in Germany. There are three major trends are followed in Germany regarding stationery sales in Germany such as ageing population, first is less schools and education centres and schools products are used in main business. It is seen that use of advancements and technologies in education also reduced the sales and demand of stationery products. Digitalisation of class rooms and smart classes enhanced the education level to visual academics which is also one of the main reason of decreasing trend and demand of stationery products (Shagoury and Power, 2012).
But apart form it, Germany's current stationery market position is in very well position. Over all turnover of stationery industry was recorded as â¬14.8 billion per year and net investment over the stationery market was recorded as â¬182 annually. Approx â¬35.2 billion was recorded as spent on writing and drawing. Germany is one of the creative and inventive city and stationery brands have good and reputed image in Germany. There is a vast opportunity of develop the business in Germany for Donald to exampled its existing business (Silverman, 2016).
2.2 Annual spending on writing drawing material per capita
As per the MGCC report it is seen that the annual spending on writing material per capita in Germany was recorded as â¬35.2 Billion and â¬8.9 billion for Spain in 2016. there is an increasing change seen in respect of turnover of stationery products and numbers. It is seen that the market share was covered by large super markets and hyper markets. E commerce and social marketing also enhanced the business of stationery in organisational context very widely. Demand of German stationery products are high and driven by a strong proclivity to utilised as investment purpose. Private commercials and super markets are also increasing day by day subject to enhance the scope of stationary market (Ãberg and et. al., 2011). Stationery market highly affected by economy of Germany. Stationery market has high growth rate of 1.7% in 2015 due to bright outlooks in the labour market. Approx 43 million employed people was seen far beyond 50%. as per statistical analysis it is seen that Germany is the second largest annual spending for writing and drawing materials per capita in the world and Czech Republic is lowest annual spending country in writing and drawing material per capita in the world (International Organization for Standardization.2018).
There is an graphical presentation done below in terms of business expansion plan of Donald Doque small business enterprise. Fountain pen, ballpoints pen, Rollerball pen, technical pen and mechanical pencils and pencils are the main products which are being sold in German stationery market.
Countries |
Annual spending (â¬) in billion |
Germany |
35.5 |
Austria |
35 |
France |
28.3 |
Spain |
8.9 |
Poland |
8.5 |
Croatia |
7.9 |
Slovakia |
9.8 |
2.3 Evaluation of Duque's last three financial year of sales data (2015-2017)
There is an analysis of sales records of Donald Duque for evaluating the business expansion plan in Germany. There is a data of three years given below
- a) Table showing total sales and turnover for three years
Product item |
2015 Sales (â¬) |
2016 Sales (â¬) |
2017 Sales (â¬) |
Printer cartridges |
25000 |
26000 |
22000 |
General office supplies |
25000 |
27000 |
23000 |
low-cost printers |
15000 |
18000 |
18000 |
Office furniture |
25000 |
25000 |
27000 |
Shredders |
25000 |
29000 |
29000 |
Paper-based supplies |
25000 |
27000 |
27000 |
Writing/drawing materials |
25000 |
30000 |
32000 |
Total sales |
165000 |
182000 |
178000 |
For the year 2015-2016
Product item |
2015 Sales (â¬) |
2016 Sales (â¬) |
Printer cartridges |
25000 |
26000 |
General office supplies |
25000 |
27000 |
low-cost printers |
15000 |
18000 |
Office furniture |
25000 |
25000 |
Shredders |
25000 |
29000 |
Paper-based supplies |
25000 |
27000 |
Writing/drawing materials |
25000 |
30000 |
Coefficient correlation |
0.9008852329 |
For the year 2016-2017
Product item |
2016 Sales (â¬) |
2017 Sales (â¬) |
Printer cartridges |
26000 |
22000 |
General office supplies |
27000 |
23000 |
low-cost printers |
18000 |
18000 |
Office furniture |
25000 |
27000 |
Shredders |
29000 |
29000 |
Paper-based supplies |
27000 |
27000 |
Writing/drawing materials |
30000 |
32000 |
Coefficient correlation |
0.8475103987 |
As per above analysis it is seen that the organisation the coefficient correlation was counted as 0.9008852329 for the year 2015 and 2016 and the coefficient correlation for the year 2016 and 2017 was recorded as 0.8475103987. It shows that the sales records of Donald Douque get positive results in terms of sales of stationery products for three years such as â¬165000 for year 2015, â¬182000 for the year 2016 and â¬178000 for the year 2017. sales for the year 2017 get decreased compare to 2016.
- e) Forecasted sales for the year 2018 and 2019
As per analysis of existing sales records it is seen that the annual increasing sales of Donald Doque is increasing by 2% every year. On the basis of above assumption the forecasted sales records are defined as follows;
Product items |
2018 Sales (â¬) |
2019 Sales (â¬) |
Printer cartridges |
22440 |
23000 |
General office supplies |
23460 |
24000 |
low-cost printers |
18360 |
18870 |
Office furniture |
27540 |
28090 |
Shredders |
29580 |
30171 |
Paper-based supplies |
27540 |
28090 |
Writing/drawing materials |
32640 |
33292 |
Total sales |
181560 |
185513 |
2.4 Feasibility of expanding to Germany and international standards
Should I expand my business to Belgium & Germany? |
||||
Pros |
Score/10 |
Cons |
Score/10 |
|
Ability of team work and management subject to stress level and work |
8 |
Challenges to align the task force and team members in single format |
-7 |
|
Independence and dependency, adaptability upon available resources and tools |
9 |
Communication challenges and interaction level with members |
-6 |
|
Innovative ideas and perspective related to plans and projects |
8 |
Stages at which performance can be evaluated |
-4 |
|
Distraction levels and bifurcation while processing the task and projects |
6 |
Task completion levels and analytical challenges to support the system |
-6 |
|
Ability to tackle challenges regarding business expansion plans and projects |
10 |
Practical knowledge and experience subject to challenging situations |
-4 |
|
Circumstances to grow and develop the scope of business in subsiding year |
8 |
Management and operations controlling challenges |
-9 |
|
Total Pros |
41 |
Total Cons |
-36 |
|
Average Pros |
8.2 |
Average Cons |
-6.17 |
Total net outcomes generated from Pros and cons methods = Total pros- Total Cons
= 41 - 36
= 5
As per above Pros and cons analysis positive results are found in terms of expanding the stationery business in Germany.
2.5 Costs of a new building
- a) Evaluation of monthly cost of 30 years 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 evaluation of loan assuming the interest applied 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 |
2.6 Mean value of orders
ISO 45001: As indicated by this specific standard which is fundamentally related with word related well-being and security direction. Such sorts of standard are should have been trailed by each business association to keep up appropriate security measure while working any sort of work (Polkowski, 2013).
ISO 14000: As per this specific universal standard which is connected with the group of standard those are related with the natural organization that exist in an association. This will limit their tasks or negative impacts that are connected with condition. These are chiefly appropriate laws, control and other condition related statements (Taguchi, 2012).
ISO 31000: according to this specific standard tenets and direction which are connected with chance administration (Peck and Devore, 2011). Every one of those hazard influencing business association can have certain sort of outcomes in connection of monetary execution and general execution of an association. Be that as it may, overseeing hazard in more compelling way can help Donald Duque to perform well in any indeterminate sort of circumstances (Worldwide Association for Institutionalization, 2018).
ISO 26000: This is essentially related with serving social duty and different obligations which is one of the essential goals at universal association. This happens to be taken as a powerful factors which are liable to keep up and keep up social duties among each division (Bock, 2012).
Related sample:
Top6129 Innovation and its Importance to Firm
2.7 Customer satisfaction
Business report In setting to make utilization of suitable systems for their new business which is connected with stationary business in Germany. By doing as such they can acquire most extreme advantages at singular level or association perspective. While there are different sorts of hazard those are related with every one of those angles those are viably useful amid the extension of business. The essential explanation for each one of those development which is enhancing their aggregate deals esteem and sum those are connected with add up to number of results amid the time. Aside from this, present market position of the organization can be break down in more powerful way. With a specific end goal to make an incentive to section into new market keeping in mind the end goal to make certain new open doors that would help with expanding general benefit for the organization. So as to influence important development in business they to need to keep legitimate examination of new market section modes those are useful for expanding productivity for the extension of their business amid the time. |
H0 ( Null Hypothesis): There is significance difference in total population in a particular research.
H1 (Alternative Hypothesis): There is no any significance difference in data collected from the sample size.
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 |
There are various criteria which will be required to be fulfil behind selection of right option by using hypothesis analysis.
P> 0.05: Null hypothesis signified or true.
P< 0.05: Null Alternative would turn out or true.
As per above hypothesis analysis it is resulted that the mean of the complete population was given 240 and the average sample was given as 230 by statistical analysis the standard deviation was calculated as 43.
Get Best Management Assignment Writing Service UK from Instant Assignment help.
CONCLUSION
It has been concluded from the above project report that the company Donald duque which deals in the business of stationary products wants to expand their business in Germany, for which purpose this report has used statistical methods for analysing the annual spendings on the stationary products in the Germany and France for the year 2015, so that they can take decision regarding the expansion. For getting a better understanding of the wholesale market of the European countries, Duque's sales data has been analysed for the previous years and the interpretation has been done with help of pie charts which represents the sales of 2016 and 2017. the scattered diagrams are also created of the sales data of the company and the coefficient correlation has also been calculated for the interpretation of the sales data of two years. And finally the scatter diagram was used for the forecasting the total sales of the company for years 2018 and 2019. are you facing trouble with HND Assignment help? Contact our experts.
REFERENCES
- William Jr, M., Glover, S. and Prawitt, D., 2016. Auditing and assurance services: A systematic approach. McGraw-Hill Education.
- Shagoury, R. and Power, B. M., 2012. Living the questions: A guide for teacher-researchers. Stenhouse Publishers.
- Polkowski, L. ed., 2013. Rough sets in knowledge discovery 2: applications, case studies and software systems(Vol. 19). Physica.
- Peck, R. and Devore, J. L., 2011. Statistics: The exploration & analysis of data. Cengage Learning.
- Taguchi, H. L., 2012. A diffractive and Deleuzian approach to analysing interview data. Feminist Theory.13(3). pp.265-281.
- Silverman, D. ed., 2016. Qualitative research. Sage.
- Ãberg, M. and et. al., 2011. Worldwide burden of disease from exposure to second-hand smoke: a retrospective analysis of data from 192 countries. The Lancet. 377(9760). pp.139-146.
- Masoud, N. and Hardaker, G., 2012. The impact of financial development on economic growth: Empirical analysis of emerging market countries. Studiesin Economics and Finance.29(3), pp.148-173.
- Bryman, A. and Cramer, D., 2012. Quantitative data analysis with IBM SPSS 17, 18 & 19: A guide for social scientists. Routledge.
- Bock, C., 2012. Analysing and interpreting DNA methylation data. Nature Reviews Genetics. 13(10). p.705.
- Allison, P. D., 2014. Event history and survival analysis: Regression for longitudinal event data (Vol. 46). SAGE publications.