IND40 Celebrate Freedom from Deadlines Get UPTO 56% OFF & Jingle All the Way with Our Christmas Offer. Coupon Code: EXTRA25 Order Now

OFFER! Save 56% on Assignment Crafted by Human Writers

Search
Listening..

Ways To Expand Business Activities in Duque Papertiers Gros

University: University of East London

  • Unit No: 3
  • Level: Post Graduate/University
  • Pages: 14 / Words 3439
  • Paper Type: Assignment
  • Course Code: smb4102
  • Downloads: 1250

Question :

This assessment will cover following questions:

  • Provide Correlation coefficient is the statistical measure result between two variables that are linked together.
  • Present a chart which shows sales value between 2105 and 2017 and generate feasible sales value for the year 2015.

Answer :

Organization Selected : Duque Papertiers Gros

INTRODUCTION

Data and information are used and analysed for effective decision-making in an organisation. The main aim of this project report is to build an understanding about techniques which helps in analysing an organisational data which can further used for decision making and problem solving. In this project report, a case scenario is followed in which a management trainee analyses information of Duque Papertiers Gros and suggest them ways to expand their business activities. Information such as product data, customer data and financial data is analysed in this report to present reliable conclusions and recommendations using graphs and tables (Bertot, Jaeger and Hansen, 2012).

A+ Grades @Affordable Prices! We deliver all academic papers from dissertations & assignments to thesis, & case studies. 5000+ satisfied students, you could be next! Place Your Order Now! Order Now

TASK 1

Overview of the wholesale stationers market in Germany

Germany is considered as one of the most influential economies of the world. Main reason behind their success is their high GDP which is a result of high consumer market of this nation. Wholesale stationers market of this country contributes billions to GDP of this economy. The most impactful cause due to which productivity of this market decreases is the number of school age children. Current sales of stationary industry are approximately 15 billion annually which is reduced by 30% in past 10 years. The German wholesale stationary industry has decreased in past ten years due to which several market players has migrated their business towards other sectors. Total number of specialised retailers in this sector are 5000 approximately. There are four main factors related to market which affects stationary market. First factor is convenience, in this factor, many market players are involved in multiple practices such as selling stationary stuff along with tobacco which is considered as inappropriate. Second factor which affects stationary market is intense competition. According to this factor, there are various market players involved in due to which consumer share divides and few of the small players face problem of low profitability. Third factor is demand for these items and forth factor is number of school students (Fortier-Brochu, and et. al., 2012).

According to the trends in stationary market it has been analysed that turnover is raised by 3.5% which has enhanced international economic environment. Trends in this industry which has been seen in past few years is that demand has been increased but with a declining rate.

TASK 2

Producing graph for representing annual spending on stationary material

statistics

(Source: Malaysian-German Chamber of Commerce and Industry, 2016)

The above graph is developed using data of Malaysian-German Chamber of commerce and industry. This information states data for annual spending from the consumers of different countries. From the above graphical representation of annual spending it has been analysed that Switzerland is earning highest amount of GDP by stationary industry as they have highest consumer spending. German has second highest ranking with 35.20 pounds spend by consumers on stationary units annually. The reason behind this high spending can be high population of Germany. Third rank is allocated to France, next to Slovenia, Italy, Spain and last as Poland. Annual spending of Switzerland is larger than four times of Poland. There are two reasons for these variations which are uneven population distribution and high rate of students in Germany and Switzerland.

TASK 3

a) Tabular analysis of information

Product Item

2015 Sales (€)

2016 Sales (€)

2017 Sales (€)

Printer Cartridges

25,000

26,000

22,000

General Office Supplies

25,000

27,000

23,000

Low-Cost Printers

15,000

18,000

18,000

Office Furniture

25,000

25,000

27,000

Shredders

25,000

29,000

29,000

Paper-Based Supplies

25,000

27,000

27,000

Writing/Drawing Materials

25,000

30,000

32,000

Total Sales (€)

165,000

182,000

178,000

Above data represents total sales which is made by the company. In the year of 2016, this company has earned highest amount of sales revenue and writing/drawing materials are seen to be highest profitable.

b) Developing mixed pie chart representing sales of 2016 and 2017

2016 sales 1

Above pie chart represents that this organisation has maximum sales from writing and drawing materials and minimum sales from low cost printers. Other categories are classified as printer catridges, gneerla office supplies, office furniture and others.

2017sales

From the above pie chart, it has been analysed that maximum sales is attianed from writng and drawing based materials that is 32000. And lowest sales are acquired from low cost printers that is 18000.

c) Associated correlation coefficient and its interpretation

coefficient and its interpretation 1

A correlation coefficient is a statistical measure which states relation of one variable to another. Correlation variables are two types that is positively correlated variables and negatively correlated variables. In case of positive variables, values increase and decrease in tandem. In case of negative variables, if value of one variable increases it leads to declining value of another variable (Green and Salkind, 2016). From the above scatter diagram, it has been seen that there is a positive relationship between both the variables that is years and sales. Correlation coefficient is measured using MS Excel which is presented below:

Year

Sales

2015

165000

2016

182000

2017

178000

Correlation coefficient

0.731307136

From the above ascertainment of correlation coefficient it has been seen that correlation between years and sales revenue of this company is 0.7313 which is close to 1. So it can be said that these variables have positive relationship between each other.

d) Forecasting total sales for 2018 and 2019

Forecasting total sales for 2018 1

From the sales revenue of years 2015, 2016 and 2017, predictions for 2018 and 2019 are done. From the above graph, it has been observed that sales revenue of this company is showing increasing trend due to which sales are increasing every passing year. This forecast is done by considering that increase in sales between year 2014 and 2015 will be followed by precceding years.

TASK 4

a) Completing the table

Should I expand my business to Belgium & Germany?

Pros

Score/10

Cons

Score/10

Logistic activity

10

Considerable risk market entry

9

Euro currency

8

Nationalism

5

Market activity

10

Subcontractor could be competitor

3

Economy

8

Language

7

Opportunities

8

Administrative cost

6

Reduced inflation expectation

7

Inflexibility

5

E-commerce

10

Salaries

7

Total Pros

61

Total Cons

42

Average Pros

8.71

Average Cons

6

The above table is completed using method of pros and cons in which all the positive aspects are provided marks and presented at the left side of the table. All the negative aspects are recorded and presented at the right side of the table (Harrell, 2015). From the above table it has been ascertained that aspects due to which Duque Papetiers Gros. Should expand their business are their logistics activity, euro currency, e commerce and more. It has been seen that average rating from all the pros is determined as 8.71. This average is ascertained from the total marks of pros as 61. In the case of cons, total marks as cons are determined as 42 from which average of 6 is ascertained. Average of pros is more than average of cons that is 8.71 and 6 which states that this company should make efforts to expand their business operations outside Germany.

b) List of few international standards that may apply to Duque’s activities

According to European Union, it is compulsory to provide a safe and reliable environment to all the organisational employees. There are five standards shortlisted which has to be considered and met by Duque Papetiers Gros and they are mentioned below (ISO, 2018):

ISO 9001 : 2015

States that a business organisation must fulfil all the quality measures provided internationally. This standard has a main focus on quality of an organisation (ISO,2018).

ISO 14298:2013

specifies a set of security printing measures which must be fulfilled by all the organisations involved in business of printing or stationary (ISO,2018).

ISO 30401

Defines that a company should manage their human resources effectively. As any misconduct performed by employees will directly affect company (ISO,2018).

ISO 6422-1:2010

This international standards states that every document printed or written which is compiled to governmental authorities must be double checked and verified by top level management or owner of the business organisation (ISO,2018).

ISO14001:2015

This is an international standard for environment protection which states that business organisations must not conduct any operation or activity which can harm environment (ISO,2018).

TASK 5

a) Calculating monthly cost of

 Mortage Repayment

From the above determination of monthly payment of mortgage, it has been ascertained that client has taken interest only mortgage (Jin and et. al., 2015). It is a kind of loan which in which person only asks for interest value to be paid every month. In order to calculate monthly payments of loan taken by Duque papetiers Gros, MS Excel is used and formula of PMT is used. From applying this formula, monthly payment of 1755.14 pounds is ascertained.

b) Re-calculating monthly cost assuming that interest is applied to the loan every month

calcalculation 2

cal3

Converting APR into percentage form -

cal4

Using the value of APR, monthly payments are determined below:

A *cac - 12 * X *cacc = 0

Where, A = Amount of Mortgage

r = Annual rate of interest expressed in decimal

n = Repayment term in years

X = Monthly repayment

200000*(1+0.10427)30 - 12*x*[((1+0.10427)30 -1)/(( 1+0.10427)-1)]=0

200000*1.1042730- 12*x*[((1.1042730- 1)/1.10427-1)]=0

200000*19.6000966066-12*x(18.6000966066/0.10427)

3,920,019.32132 -12*x*178.3839705246=0

3,920,019.32132 – 2,140.6076462952x=0

3,920,019.32132=2,140.6076462952x

X= 3,920,019.32132/2,140.6076462952 => X=1,831.2647477012=>

Monthly payments of €1,831.26

From the above calculation, it has been ascertained that if Donald uses the concept of APR, monthly payment will be high that is 1831.26 pounds.

You can also check services: Assignment writer

TASK 6

Mean values of order

From the given scenario of Donald, it has been ascertained that Donalds believes that his company will receive monthly mean value of orders as 240. This assumption is considered as reliable but he thinks that this assumption is providing incorrect mean value (Landauer and et. al., 2013). A hypothesis is developed which is mentioned below:

B1 – µ = 240

B2 - µ ≠ 240

µ = mean value of orders

Information which is used to ascertain mean order is presented below:

Standard deviation significance level is 5%, standard deviation significance value is 43 and number of samples is 50. From the above data, formula of standard error can be applied and ascertained.

ca

In order to gain an absolute answer, standard error will be rounded and will be equal to 6. Along with this interval acceptance which is considered is:

= (µ -2SE; µ +2SE) => [240-(2*6)] [240+(2*6)] => Acceptance interval is [228];[252]

By calculating and taking assumption for variables, it has been ascertained that mean value of sample will be 240 pounds. In addition to this 95% of the random sample lies within the interval and from which it can be concluded that Donald assumptions are relevant.

TASK 7

a) Providing advice about how performance of Donald’s firm can be improved

From the given case scenario, it has been ascertained that December is not considered as good period of time to send questionnaires to their clients for feedback. Average of 5% questionnaires are considered that will be expressed. In order to attain better solution for this organisation, brainstorming is a method which should be done. This organisation can change the period of the year for feedback forms and should also make efforts to complete this questionnaire (Menke, 2018).

b) Suggestions on cause for concern

ID

CUST_SERV

QUAL_P&S

SALES_STAFF

PRICE_VALUE

01

3

3

3

3

02

3

3

3

2

03

4

4

4

2

04

4

3

4

1

05

2

3

2

2

06

4

4

4

2

07

4

3

4

2

08

4

3

4

2

09

2

3

2

2

10

4

3

4

1

11

4

3

4

2

12

4

3

4

2

13

4

3

4

2

14

4

3

4

1

15

2

3

2

2

16

4

3

4

2

17

4

4

4

2

18

3

3

3

3

19

4

3

4

2

20

3

3

2

2

Key Data

Mean

Std. Deviation

CUST_SERV

3.5

0.76

QUAL_P&S

3.15

0.37

SALES_STAFF

3.45

0.83

PRICE_VALUE

1.95

0.51

From the above table, mean is calculated by using formula which is mentioned as follows,

Formula for Mean: =AVERAGE (B2:B22); =AVERAGE(C2:C22); =AVERAGE(D2:D22); =AVERAGE(D2:D22)

Formula for Standard Deviation: = STDEV.S(B2:B22); = STDEV.S (C2:C22); =STDEV.S (D2:D22); = STDEV.S (D2:D22)

From these ascertainment, it has been suggested that this company should advertise their product and invest their funds in advertising campaigns.

Experts Are Listening! Have doubts about academic writing? Clear all of them in a minute! Call the experts and get your answers immediately! Dial Now!Contact Us

Conclusion

From the project report it has been concluded that German industry is overall generating high revenues due to opportunities and positive market trends. Dynamic nature of German market can result into challenges for Duque papetiers Gros. By analysing company financial status it can be concluded that they should expand their activities outside Germany and for which they should invest their resources in advertising operations.

Read Also: Travel and tourism in business tui group

REFERENCES

  • Fortier-Brochu, É., and et. al., 2012. Insomnia and daytime cognitive performance: a meta-analysis. Sleep medicine reviews. 16(1). pp.83-94.
  • Green, S. B. and Salkind, N. J., 2016. Using SPSS for Windows and Macintosh, Books a la Carte. Pearson.
  • Harrell, F. E., 2015. Ordinal logistic regression. In Regression modeling strategies (pp. 311-325). Springer, Cham.
  • Jin, X., and et. al., 2015. Significance and challenges of big data research. Big Data Research. 2(2). pp.59-64.
  • Landauer, T. K., and et. al., 2013. Handbook of latent semantic analysis. Psychology Press. 
Download Full Sample
Often times, students feel unable to work on assignments and think, “Who will do my assignment?” By providing "Sample" on various subjects, we are trying to help them understand all the intricacies of writing. We have the most qualified and skilled assignment writers who can provide the best assignment writing services, essay writing services, dissertation writing services, and more at the most affordable rates. Place your order now for surprising discounts.
Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price
USD 7.13

    Delivered on-time or your money back

    100+ Qualified Writers

    For Best Business Assignment Help

    expert name
    837 - Completed Orders
    Dr. Joseph Parker View Profile Ph.D in Geography USA Hire Me
    expert name
    1351 - Completed Orders
    Ross Kingsley View Profile Ph.D in Pharmacology UK Hire Me
    expert name
    1564 - Completed Orders
    Joseph Anderson View Profile Ph.D. in accounting and finance France Hire Me
    expert name
    1233 - Completed Orders
    Anna James View Profile Ph.D. holder in Electrical Engineering UK Hire Me
    View All Writers
    FREE Tools

    To Make Your Work Original

    • tools Paraphrasing Tool

      Easy to Use Paraphrasing Tool to Simplify Complex Academic Writing

      Check Paraphrasing
    • tools Plagiarism Checker

      Check your work against plagiarism & get a free Plagiarism report!

      Check Plagiarism
    • tools Reference Generator

      Get citations & references in your document in the desired style!

      Generate References
    • tools Grammar Checker Tool

      Make your content free of errors in just a few clicks for free!

      Grammar Checker
    • tools Essay Typer

      Generate plagiarism-free essays as per your topic's requirement!

      Essay Typer
    • Dissertation Outline Generator

      Get Structured Outline by Professionals for Your Dissertation

      Check Dissertation
    • Thesis Statement Generator

      Create the perfect thesis statement in just few minutes!

      Generate Thesis
    • AI Essay Writer

      Get a well-researched and quality essay effortlessly in a few seconds.

      AI Essay Writer
    GAH whatsapp

    Limited Time Offer

    Exclusive Library Membership + FREE Wallet Balance