plan for the collection of primary and secondary data for a given business

In this assignment discuss about type of data, a methodology of gathering data from various sources, arranging them according to a system to get useful information which leads to take better decisions. Analysing data and information is very important to take efficient and effective business decisions. This will help the management to understand the industry status, can be a value addition tool and introduce new processors, rules and regulation to increase quality, quantity and productivity. Organisations use technology to arrange data and to get information according to their requirement (Yu & Chen, 2011). According to the scenario is about Halford group a product, service and expertise provider of motor, bicycle, and great getaway that means a transportation facilitator according to customers’ requirement. Halford has more than 402 superstores, 34 compact stores, 31 metro compact stores and 261 auto centres across in the United Kingdom and in the Republic of Ireland. They have introduced a Bike hut as a showcase to promote their bike brands. Where they want to increase their customer satisfaction level and need to clarify the feedback of the market about their products (Asoff, 2009).

Create a plan for the collection of primary and secondary data for a given business

Data are statistics, details, verses, photographs, charts, images and etc. There are two types of data, such as quantitative data and qualitative data (Austin, et al., 2007). Quantitative data means where data gathered from surveys, questionnaires, trials and etc. these data are much in number format. Qualitative data’s are that has recorded in detail. It is very important to collect both types of data to get a great output. Primary data can be collected by interviews, research, or by observations. But for the given scenario it is important to gather customer feedback therefore interviews are important. The Even Halfords Group can use their site, e-commerce link as a resource to collect data by adding a short questionnaire. Secondary data are records which exist currently. Plan to collect primary data and secondary data for the given situation are, quick questionnaires, informal interviews, telephone surveys, observing the customers, analyse the previous company details, use the web site to get feedback from customers and etc (Barker, 2010).

Source: http://analyticalconsulting.info/services/

1.2   Present the survey methodology and sampling frame used

Survey methodology is a tool that uses to gather data from a specific segment. In this scenario it is important to gather information mainly from cyclists about their requirements, their liking and dis-likings value additions, knowledge about the product, ideas to improve the invention and etc (Bryman & Bell, 2008). The survey question list can be made out of closed questions and open questions. Surveys can be conducted mainly in two ways that is interviews and questionnaires. This is also can be done by qualitative assessment or as a quantitative design methodology. On the other hand there are two sampling types, as probability and non probability sampling. Probability and non probability sampling has different techniques of sampling (Curran, et al., 2011). For example probability sampling has simple random sampling method, cluster sampling, stratified sampling method and systematic sampling method. Where non probability sampling has snowball sample method, quota sampling and judgmental sample method. In this case it is appropriate to use questionnaires containing both open ended and close ended questions. And non probability sampling technique can be use as the sampling frame (Craig, 2010).

Source: Author

1.3   Design a questionnaire for a given business problem

Dear Valued Customer,

We Halfords group as the leader in cycles retailing market always looking forward to give more that our client expects. We have introduced “Bikehut Stores” where you can easily reach and access premium bike brands. To enhance more customer oriented service we would like to ask few questions.

Many thanks in advance for your precious time taken to fill the below questionnaire

Looking forward to provide better service in future

Best regards,

——————–

Manager,

Halfords Group

Name: – …………………………

Address: -………………………….

Age:-…………………………..

Gender: Male £ Female £

Are you happy to deal with Halfords: Yes £ No £

If your answer is no please specify: – ………………………………………………………

Are you aware of the new store chain called “Bikehut”: Yes £ No £

Do you think the price of this product is reasonable: Yes £ No £

If your answer is no, please state why? …………………………………….

Do you recommend our products to another person: Yes £ No £

Your ideas are very important to us to provide an extravagantly personalised service and products to you. Please comment:

……………………………………………………………………………………………

Please use the envelope attached to send your valued ideas.

2.1   Relate information for decision making by summarising data using representative values

Total Response is = 225

Product use age according to the gender

Male – 150 Female – 75

Happy to deal with Halfords

Yes: (217)

No: (8)

Awareness of the “Bikehut” stores

Yes: (185)

No: (40)

Overall quality of the product

1 (4)

2 (23)

3 (68)

4 (120)

5 (10)

Overall satisfaction of the product

1 (2)

2 (32)

3 (89)

4 (79)

5 (23)

Service in the Bikehut

1 (0)

2 (93)

3 (102)

4 (23)

5 (7)

After sales services

1 (3)

2 (42)

3 (88)

4 (80)

5 (12)

Compared to other suppliers our product and services

1 (0)

2 (17)

3 (107)

4 (75)

5 (26)

Price is reasonable

Yes (157)

No (68)

Product recommendations

Yes (210)

No (15)

(1-Unsatisfied, 2-Good, 3-Very Good, 4-Satisfied, 5-Exceed expectation)

2.2   Analyse the results draw valid conclusions in a business context.

Total Response is = 225

Product use age according to the gender

Male 150, Female 75

Male 66.67%

Female 33.33%

Happy to deal with Halfords

Yes (217) 96.44%

No (8) 3.56%

Awareness of the “Bikehut” stores

Yes (185) 82.22%

No (40) 17.78%

Overall quality of the product

1 (4) 1.78%

2 (23) 10.22%

3 (68) 30.22%

4 (120) 53.33%

5 (10) 4.44%

Overall satisfaction of the product

1 (2) 0.89%

2 (32) 14.22%

3 (89) 39.56%

4 (79) 35.11%

5 (23) 10.22%

Service in the Bikehut

1 (0) 0%

2 (93) 41.33%

3 (102) 45.33%

4 (23) 10.22%

5 (7) 3.11%

After sales services

1 (3) 1.33%

2 (42) 18.67%

3 (88) 39.11%

4 (80) 35.56%

5 (12) 5.33%

Compared to other suppliers our product and services

1(0) 0%

2 (17) 7.56%

3 (107) 47.56%

4 (75) 33.33%

5 (26) 11.56%

Price is reasonable

Yes (157) 69.78%

No (68) 30.22%

Product recommendations

Yes (210) 93.33%

No (15) 6.67%

The customer base is at 66.67% of males and 33.33% female. The company should look forward to encourage more females to use the product. When advertising focus to touch famine market too.

96.44% customers are happy to deal with the establishment, 82.22% customer base is aware of the new store chain. 98% of customers are satisfied about the product quality, where 99% are overall satisfied about the product. 100% customers are happy about the service provided at “Bikehut”. 97% of customers are delighted about after sales services. 70% of clients say that the product price is reasonable. 93.33% of customers will help to bring business by recommending the product to others. This is a free advertising for the company. When considering the overall information the company is performing well. Customers are satisfied with the establishment and as well as the product and the service (Daniel & Ward, 2009).

2.3   Analyse data using measures of dispersion into inform a given business scenario.

Measures of dispersion means when scattering data how the statistics are comparable individually (Dubois & Gadde, 2007), there are three ways to measure dispersion, namely as the range, the semi interquartile range (SIR) and variance / standard deviation. In range dispersion uses the lowest value and the highest value in the given data set and the difference is taken as ranges (Thorpe & Lowe, 2006).

1

2

3

4

5

Overall quality of the product

4          1.78%

23        10.22%

68        30.22%

120      53.33%

10        4.44%

Overall satisfaction of the product

2          0.89%

32        14.22%

89        39.56%

79        35.11%

23        10.22%

Service in the Bikehut

0          0.00%

93        41.33%

102      45.33%

23        10.22%

7          3.11%

After sales services

3          1.33%

42        18.67%

88        39.11%

80        35.56%

12        5.33%

Compared to other suppliers our product and services

0          0.00%

17        7.56%

107      47.56%

75        33.33%

26        11.56%

Question

Highest Value

Lowest Value

The Range

Overall quality of the product

Highest Value 120

Lowest Value  4         

The Range       116

Overall satisfaction of the product

Highest Value 89

Lowest Value  2

The Range       87

Service in the Bikehut

Highest Value 102

Lowest Value  0

The Range       102

After sales services

Highest Value 88

Lowest Value  3

The Range       85

Compared to other suppliers our product and services

Highest Value 107

Lowest Value  0

The Range       107

Semi interquartile range (SIR) = (Q3-Q1) /2

Overall quality of the product

Q3                   68

Q1                   4

Q3-Q1             64

(Q3-Q1)/2       32

Overall satisfaction of the product

Q3                   89

Q1                   2

Q3-Q1             87

(Q3-Q1)/2       43.5

Service in the Bikehut

Q3                   102

Q1                   0

Q3-Q1             102

(Q3-Q1)/2       51

After sales services

Q3                   88

Q1                   3

Q3-Q1             85

(Q3-Q1)/2       42.5

Compared to other suppliers our product and services

Q3                   107

Q1                   0

Q3-Q1             107

(Q3-Q1)/2       53.5

Standard Deviation

Overall quality of the product

4

23

68

120

10

Std. Div:         49

Overall satisfaction of the product

2

32

89

79

23

Std. Div:         37

Service in the Bikehut

0

93

102

23

7

Std. Div:         49

After sales services

3

42

88

80

12

Std. Div:         39

Compared to other suppliers our product and services

0

17

107

75

26

Std. Div:         44

2.4   Explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context.

Quartile use to separate data in two quarters. Percentiles are where the observed data are similar or larger than the percentile figure. The correlation coefficient is the tool that uses to interpret the linear relationship between two variables (Fensel & Bussler, 2011).

1

2

3

4

5

Overall quality of the product

4

23

68

120

10

Overall satisfaction of the product

2

32

89

79

23

Service in the Bikehut

0

93

102

23

7

After sales services

3

42

88

80

12

Compared to other suppliers our product and services

0

17

107

75

26

QUARTILE

0

1

2

3

4

4

10

23

68

120

2

23

32

79

89

0

7

23

93

102

3

12

42

80

88

0

17

26

75

107

Correlation coefficient

Overall quality of the product

4

23

68

120

10

Overall satisfaction of the product

2

32

89

79

23

87%

Service in the Bikehut

0

93

102

23

7

After sales services

3

42

88

80

12

62%

Overall quality of the product

4

23

68

120

10

Compared to other suppliers our product and services

0

17

107

75

26

78%

3.1   Produce graphs using spread-sheets and draw valid conclusions based on the information derived

Main customer sector can be identified from the above chart.

This graph will indicate the satisfaction level of customers.

This graph shows the correlations of the overall product and quality satisfaction.

3.2   Create trend lines in spread-sheet graphs to assist in forecasting for specified business information

The customers are highly satisfied about the overall quality of the product but it is important to improve product satisfaction and after sales services (Kuhn, 2004).

Quartile forecast.

Almost every purchaser likes to deal with the company.

More than 50% of the clients agree that the product price is reasonable. Therefore no need to do price change

Has to advertise more about “Bikehut” for customer awareness

3.4   Produce a formal business report

Subject: The customer satisfaction and “Bikehut” awareness survey

To: The Management

From: The Market Research Team

Date: 12th March 2014

This is about the awareness and a satisfaction survey about our products and services. In addition to that verify the new outlet chain status. As per the management request our team conducted a questionnaire survey and interview to collect the required data (Rapoza, 2011). We have got 225 feedback forms from customers.

According to the collected data after sampling and analysing them, we recognise that the males are using our product greater than the females. Overall the customers are happy to deal with our establishment. 185 customers out of 225 were aware about the “Bikehut” store. 70% of clients are pleased with our product prices. As per the information our products quality and services satisfies customers where the company has built a very good reputation. Therefore we have a 93% of word of mouth promotion via the satisfied customers. Conferring as per the data gathered the organisation performs incredibly well than the industry competitors.

We recommend that the after sales service should improve.

Most of the feedback has rated very well, but the organisational goal should be to give an extravagantly personalised service to get more rates on exceeding expectation.

The customer service manager is responsible to introduce customer oriented training (Curran, et al., 2011).

It is the human resource manager’s duty to implement appreciation programme and reward the employees as a motivation factor (Asoff, 2009). Production has to innovated appropriate cycle designs for females. Advertising team should attract feminine market and promote “Bikehut” stores as well as Halfords products

4.1   Use appropriate information processing tools

Information processing tools are the processors and tangible and non tangible equipment that use to arrange data, such as database, servers, computers, transmitters, ATMs’ as well as Software, methodologies, internet, networks, websites and etc (Austin, et al., 2007). By using the correct methods and equipment the organisation can be benefited. The output will be accurate to take effective and efficient decisions. In an organisation, budgets, project plans, cash flow statements, investment appraisals are used as information tools (Yu & Chen, 2011).

Source: Author

Prepare a project plan for an activity and determine the critical path

4.3   Use financial tools for decision making.

To evaluate a project in the main financial tool which use as a decision making technique is calculated net present value (NPV) and internal rate of return (IRR). Organisation invests in projects expecting an upright return in long time span. By using NPV the management can decide the surplus or the shortage of the cash flow (Bryman & Bell, 2008). IRR calculation mainly considers about the discount rate only. The discount rate may change over the time period. Therefore the IRR rate will also change accordingly. Using the internal rate of return is not rational to evaluate a project (Barker, 2010).

Discount Rate

12%

Period              Sum

0                      (50,000.00)

1                      12,000.00

2                      15,000.00

3                      15,000.00

4                      18,000.00

5                      10,000.00

NPV                462.49

IRR                 12.371%

4.4   Explain the results of NPV and IRR

Since this has a positive NPV, it is worth to invest in this project. It will recover the initial investment and can earn a better return. Net present value is the difference that occurs when evaluating the project market value and its cost. In addition to the NPV the internal rate of return (IRR) is 12.37%. When the internal rate of return is higher than the discount percentage then it will indicate a continuation of the project. Though investors calculate net present value and internal rate of return, they mainly consider on the net present value (Craig, 2010).

5.     References and Bibliography

Asoff, M. (2009) Rich Web Applications -The Business Benefits of Web-enabled Application Development, 3rd ed. London: McGraw Hills

Austin, D., Barbir, A. & Garg, S. (2007) “Web services architecture requirements.” [Accessed on 18 May 2014] <available at: http://www.w3.org/TR/2002/WD-wsa-reqs-20020429&gt;

Barker, A. (2010) Paradigms, 7th ed. New York: Harper Collins

Bryman, A. & Bell, E. (2008) Business Research Methods, 7th ed. Oxford: University Press

Craig, M. (2010) “Changing paradigms: managed learning environments and Web 2.0.” Campus-Wide Information Systems, 11(32), pp: 17-77

Curran, K., Murray, M. & Christian, M. (2011) “Taking the information to the public through Library 2.0” Library Hi Tech, 17(33), pp: 151-267

Daniel, E. & Ward, M. (2009) “Exploring the role of third parties in inter-organizational Web service adoption” The Journal of Enterprise Information Management, 13(45), pp: 10-67

Dubois, A. & Gadde, L. (2007) “Systematic combining: an adductive approach to case research,” Journal of Business Research, 12(35), pp: 113-178

Fensel, D. & Bussler, C. (2011) “The Web service modelling framework.” Electronic Commerce Research and Applications, 15(26), pp: 113-187

Kuhn, T. S. (2004) The Structure of Scientific Revolutions, 6th ed. Chicago: Chicago University Press

Rapoza, J. (2011) “IT Planners: 5 Steps to Next Generation Web Applications.” eWeek, 27(45), pp: 145-178

Thorpe, R. & Lowe, A. (2006) Management Research: an Introduction, 9th ed. London: Sage Publications

Yu, S. & Chen, R. (2011) “Web Services: XML-based system integrated techniques.” The Electronic Library, 27(66), pp: 198-278

Published by MALI

Writer is post-graduated in Computer science, Business Administration, Marketing and Innovation. He has 10 years of business academic research writing experience.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: