data analysis
DESCRIPTION
Research toolsTRANSCRIPT
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
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.
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.
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.
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
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.