data analysis

20

Click here to load reader

Upload: anurag-tripathi

Post on 21-Jul-2016

36 views

Category:

Documents


0 download

DESCRIPTION

Research tools

TRANSCRIPT

Page 1: Data Analysis

DATA ANALYSIS

Q1) which type of business you have?

PBU Customers RespondentsDoctors 30%CA 14%Engineering firms 17%Consulting firms 3%Electronic shop 10%Interior Designer 12%Small offices 10%Institutions 4%Total 100%

INTERPRITATION

From above table, the highest percentage of PBU customers are doctors followed by CA(14%) Engineering firms (17%) consulting firms & electric shops are 3% & 10%. 10% customers are small offices and other 4% are related to institutions.

30%

14%17%

3%10%

12%

10% 4%

PBU Customers

DoctorsCAEngineering firmsConsulting firmsElectronic shopInterior DesignerSmall officesInstitutions

Page 2: Data Analysis

Q2) Do you have any cash and carry outlet membership card?

Yes 39%

No 61%

Total 100%

If Yes Which of Following,

Reliance cash and carry 0

Metro cash and carry 0

Booker India 60%

Other 40%

60%

40%

Other cash and carry outlet membership

Reliance cash and carry Metro cash and carryBooker India Other

INTERPRITITION:

During the study it was found that Reliance cash & carry and Metro cash & carry is known to the customers but two doesn’t consist any outlet in Pune city. Whereas Out 39% customer in survey who are having cash & carry outlet membership card were having 60% Booker India membership card and 40% other small cash & carry outlets.

Page 3: Data Analysis

Q3) which criteria do you consider while purchasing product?

Criteria RespondentsProfit Margin 40%Offer 35%Discount 15%Other 10%Total 100%

Profit Margin Offer Discount Other0%

5%

10%

15%

20%

25%

30%

35%

40%

40%

35%

15%

10%

Respondents

INTERPRITATION:

The analysis of the study it was found the 40% PBU customer prefer profit margin criteria, 35% PBU customer prefer offers, 15% PBU customer prefer discount and remaining 10% PBU customer prefer other criteria.

Page 4: Data Analysis

Q4) Sales promotion of other stores may change your preference?

Sales preference RespondentsYes 24%No 17%Not Sure 59%Total 100%

24%

17%59%

Sales Preference

Yes NoNot Sure

INTERPRITATION:

The analysis of the study was found that the sales promotion activities may change the preference of 24%. Whereas 17% customers says no and remaining 59% PBU customer were not not sure.

Page 5: Data Analysis

Q5) in a month how many times you visit Booker India?

Visits RespondentsOnce 20%Twice 15%Thrice 10%More than three 5%As per requirement 50%Total 100%

O n c e

Twi c

e

Th r i ce

Mo r e t

h a n th r e e

A s pe r r

e q u i rem

en t0%

10%

20%

30%

40%

50%

60%

20%15%

10%5%

50%

Visit of Booker Outlet

INTERPRITATION:

During the study it was found that almost 50 % customer category prefers to visit the store as per their requirement. And 20 % customer visit the Booker India outlet at least once in a month, following 15% PBU customer visit twice in a month, 10 % thrice and 5% PBU customer prefer to visit more than thrice

Page 6: Data Analysis

Q6) does the store availability timing 8AM to 8PM preferable to you?

Yes 75%No 25%Total 100%

Yes No0

10

20

30

40

50

60

70

80

Time are preferable or not

INTEPRITATION:

The analysis of the data was found that the timing of the Booker India outlet 8 AM to 8PM is preferable to 75% of customer category whereas 25% PBU customer doesn’t prefer the timing due to their working hours, business activates etc.

Page 7: Data Analysis

Q7) what type of segments you prefer to buy?

Segments RespondentsFood 40Non Food 13Confectionary 20Beverages 27Total 100

Food Non Food Confectionary Beverages0

5

10

15

20

25

30

35

40

45

Segment of prefernceSeries 1

GRAPH NO: 5

During the study it was found that 40%PBU customer prefer to the food department, 13%PBU customer prefer to the nonfood department, 20%PBU customer prefer to the confectionary department, 27%PBU customer prefer to the beverages department.

Page 8: Data Analysis

Q8) what comes to your preference when you think about Booker India Outlet?

Preference Area RespondentsDiscount 33Product Variety 14

Brand 14Quality 33Offers 6Total 100

33%

14%14%

33%

6%

Preference area

DiscountProduct VarietyBrandQualityOffers

INTERPRITATION:

The during the study it was found that 33%PBU customer a prefer to the discount, 14%PBU customer prefer to the product variety, 14%PBU customer a prefer to the brand, 33%PBU customer prefer to the quality, 6%PBU customer prefer to the offers.

Page 9: Data Analysis

Q9) is the location of store convenient to you?

Yes 43No 57Total 100

Yes43%

No57%

Convenient the location

Yes No

INTERPRITATION:

During the study it was found that location of Booker India which is Kondwa Pune is preferable to only 43% customers whereas 57% customer thinks the location is not convenient to them due nonresident of Kondwa area .

Page 10: Data Analysis

Q10) who influence you to buy your preferred product from Booker India?

Factors RespondentsFriends 17Neighbors 23Advisements 37Self-experience 10Any other 13Total 100

F r i end s

N e i ghbo r s

A dv i se m

e n t s

S e l f- e x pe r i e

n c e

A ny ot he r

05

10152025303540

1723

37

10 13

Factors

INTERPRIITATION:

During the study it was found that 17%PBU customers are influenced by the friends, 23%PBU customers are influenced by the neighbors, 37%PBU customers are influenced by the advisement, 10% PBU customers are influenced by the self experience and 13% PBU customers are influenced by the any other criteria.

Page 11: Data Analysis

Q11) if your preferred product is not available in Booker India? You will go to…?

Scale RespondentsFirst Choice D mart 40%Second Choice Big Bazaar 20%Third Choice Other 40%Total 100%

D mart Big Bazar Other0

5

10

15

20

25

30

35

40

Series 1

INTERPRITATION:

During the study it was found that preference of 40% customer will be D mart if product is not available in Booker store, 20% PBU prefers to go in Big Bazar and remaining 40% prefers to go other local shops.

Page 12: Data Analysis

Q12) for which range of products/brands you expect promotional offers?

(Please rank from scale 1 being high to 4 being lowest)

Product Rank 1 2 3 4

Total

Beverages 30 20 40 10 100Groceries 45 25 15 15 100Electronic items 30 30 20 20 100Food items 40 15 20 25 100

1 2 3 4 50

102030405060708090

100

BeveragesGroceries

Electronic itemsFood items

Products

Beverages Groceries Electronic items Food items

INTERPRITATION:

During the study it was found expected promotional offers to the customers groceries item is the high position and Food items are the lowest position, the beverages are the third position and the Electronic items are the second position in the preference of the customers.

Page 13: Data Analysis

Q13) Opinion for your preference in Booker store.

(Please rank from scale 1 being high to 6 being lowest)

Parameter Rank1 2 3 4 5 6

Total

Choice 20 20 10 20 20 10 100Price 26 14 15 15 15 15 100Discount 25 20 15 13 17 10 100Service 21 15 19 25 10 10 100Billing system 12 15 15 25 25 08 100Proper Parking facility 24 20 15 18 13 10 100

1 2 3 4 5 60

5

10

15

20

25

30

Preference/parameter

Choice Price DiscountService Billing system Proper Parking facility

INTERPRITATION:

During the study of it was found the preference of the opinion Booker India outlet is Proper parking facility are the high position second one is the service billing system are the third position the choice are the last position present.

Page 14: Data Analysis

Q14) what is the amount of shopping you generally make from Booker India?

Rs 0 to Rs 1000 60%Rs1000 to Rs 5000 25%Rs 5000 to Rs 10000 10%Rs 10000 and above 5%Total 100%

Rs 0 to Rs 100060%

Rs1000 to Rs 500025%

Rs 5000 to Rs 10000

10%

Rs 10000 and above5%

Budget of shopping

Rs 0 to Rs 1000Rs1000 to Rs 5000Rs 5000 to Rs 10000Rs 10000 and above

INTERPRIATION:

During the study it was found that 60% PBU customers are generally purchasing amount are the Rs0 to 1000, 25% PBU customer make purchase of Rs1000 to 5000,10% PBU customer make purchase of Rs5000 to 10000 and remaining 5% PBU customers make purchase above Rs 10000.

Page 15: Data Analysis

Q15) the existing shelf display in store is preferable to you?

Yes 80%No 20%Total 100%

Yes No

80

20

Existing shelf of store is preferable

Series 1

INTERPRITATION:

The analysis of the data shows that existing shelf display is preferable to 80 % customer where remaining 20 % customer thinks other ways of shelf displays will be preferable to them.

Page 16: Data Analysis

Q16) Rank the problem faced by you (if any) in following event

(Please rank from scale 1 being high to 7 being lowest)

Rank Problem faced/Parameters Respondents1 Inconvenient Location 252 Long queue for billing 203 Non cooperative attitude of sale

personnel18

4 No Home delivery 155 Improper space management 106 Poor after sales service 77 Unavailability of goods 5

Total 100

Inco

nven

ient

Loc

ation

Long

que

ue fo

r bill

ing

Non

coo

pera

tive

attitu

de o

f sal

e pe

rson

nel

No

Hom

e de

liver

y

Impr

oper

spa

ce m

anag

emen

t

Poor

afte

r sal

es s

ervi

ce

Una

vaila

bilit

y of

goo

ds

1 2 3 4 5 6 7

05

10152025

Problem Faced

INTERPRITATION:

During the study it was found that location of store is the major problem to the customer and unavailability of stock is the least problem faced by them.

Page 17: Data Analysis

Q17) Opinion for your satisfaction or Dissatisfaction about Booker India store?

Particular Highly satisfaction

Moderate satisfaction

Indifference Highly dissatisfied

Moderate dissatisfied

Total

Choice 25% 27% 11% 20% 17% 100%Price 25% 24% 15% 20% 11% 100%Discount 28% 20% 18% 20% 14% 100%Service 19% 18% 20% 31% 12% 100%Billing system

15% 10% 20% 25% 30% 100%

Highly sa

tisfacti

on

Moderate satisfa

ction

Indifference

Highly diss

atisfied

Moderate dissatisfi

ed0%5%

10%15%20%25%30%35%

25% 27%

11%

20%17%

25% 24%

15%20%

11%

28%

20% 18% 20%14%

19% 18% 20%

31%

12%15%

10%

20%25%

30%

customer are satisfied or not

Choice Price Discount Service Billing system

INTERPRITATION:

The analysis of the data for the PBU customers shows that the 28% customers are mostly satisfied in the discount factor, in the price the PBU customers is moderate satisfaction, the Billing system PBU customers is highly dissatisfied.