Boosting 4G Productivity in Guwahati
Boosting 4G Productivity in Guwahati
Kunal Singh
Roll No - 61
December 2018
DECLARATION
This report has been prepared by me and has not been submitted in part or full to any
authority for award of any degree/diploma.
Declaration I
Certificate I II
Certificate II III
List of figures IV
List of tables V
Acknowledgement VI
BIBLIOGRAPHY 29
LIST OF FIGURES
Figure No. Particulars Page No.
15
4.7
TYPE OF RELATION WITH SUPERIOR, CO-WORKER
AND SUBORDINATES
16
4.8
WHETHER DG COUNTER IS TO BE PROVIDED IN
THE DG OUTLETS
17
4.9
WHETHER AIRTEL BANNERS/POSTERS OUTSIDE
THE DG OUTLET WILL HELP TO INCREASE
4G GROSS PRODUCTIVITY
18
4.10 WHETHER CANOPY INFRONT OF THE DG OUTLET 19
IS TO BE PROVIDED
LIST OF TABLES
Figure No. Particulars Page No.
4.1 WORKING AS DEVICE GURU 10
15
4.7
TYPE OF RELATION WITH SUPERIOR, CO-WORKER
AND SUBORDINATES
16
4.8
WHETHER DG COUNTER IS TO BE PROVIDED IN
THE DG OUTLETS
17
4.9
WHETHER AIRTEL BANNERS/POSTERS OUTSIDE
THE DG OUTLET WILL HELP TO INCREASE
4G GROSS PRODUCTIVITY
18
4.10
WHETHER CANOPY INFRONT OF THE DG OUTLET
IS TO BE PROVIDED
19
4.11 SUFFICIENT TRAINING OF DG & RATING AIRTEL 20
AS A COMPANY
ACKNOWLEDGEMENT
The quest for knowledge never ends. So continuing my journey of knowledge in the
Centre for Management Studies, Dibrugarh University, I had been assigned to do my
project on “How to increase 4G GROSS to 3 productivity from DG Outlets in Guwahati”,
to enhance my knowledge and learning.
First of all I would like to express my profound gratitude to Dr. Ajanta Borgohain
Rajkonwar, Chairperson of Centre for Management Studies and Mr. Monuj Tamuli,
Training and Placement Officer, Dibrugarh University for giving me chance and facility
to undertake the training.
I would also like to thank my academic guide Dr. Pratim Barua, Associate Professor,
Centre for Management Studies, Dibrugarh University. I am extremely grateful to him
for his invaluable guidance, support and encouragement.
Kunal Singh
MBA (FT), 3rd Semester
Dibrugarh University
EXECUTIVE SUMMARY
PROJECT TITLE :
A detail study on “How to increase 4G GROSS to 3 productivity from DG Outlets in
Guwahati”
ACADEMIC GUIDE :
Dr. Pratim Barua, Associate Professor, Centre for Management Studies, Dibrugarh
University
ORGANIZATIONAL GUIDE :
RESEARCH METHODOLOGY :
The methodology used to analyse the project is mainly based on Personal Market
Analysis and survey method and this survey was conducted through questionnaire and
it also include personal interview with the respondents.
GUWAHATI
INTRODUCTION
1.1 Bharti Airtel Limited at a glance
Chairman – Sunil Mittal
In 1992, he successfully bid for one of the four mobile phone network licences
auctioned in India. One of the conditions for the Delhi cellular license was that the
bidder have some experience as a telecom operator. So, Mittal clinched a deal with
the French telecom group Vivendi. He was one of the first Indian entrepreneurs to
identify the mobile telecom business as a major growth area. His plans were finally
approved by the Government in 1994 and he launched services in Delhi in 1995, when
Bharti Cellular Limited (BCL) was formed to offer cellular services under the brand
name AirTel. Within a few years Bharti became the first telecom company to cross the
2 million mobile subscriber mark. Bharti also brought down the STD/ISD cellular rates
in India under brand name 'Indiaone'.
1.3 Meaning of 4G GROSS
1.Assam
2.Arunachalpradesh
3.Meghalaya
4.Manipur
5.Mizoram
6.Nagaland
7.Tripura
DG TL : Nayan Das
Pintu Dey
Anowar Ali
David
NESA
ZSM(18)
TSM(108)
DISTRIBUTOR(475)
FSE(1565 Approx.)
RETAILER(73,000 Approx.)
CHAPTER-2
OBJECTIVES
OBJECTIVES OF THE STUDY :
3. To identify the relation of DG’s with their superior, co-worker and subordinates.
RESEARCH
METHODOLOGY
3.1 RESEARCH DESIGN :
The methodology used to analyse the project is mainly based on Personal Market
Analysis and survey method and this survey was conducted through questionnaire and
it also include personal interview with the respondents.
Convenience Sampling
Percentage analysis has been used as statistical tools for the analysis.
Graphical representation tools i.e. Pie chart and Line Chart have been used for the
presentation of data analysis.
DATA
CHAPTER-4
ANALYSIS
Table No. 4.1
The study was conducted to find out that how long the promoters have been working
as DG.
Graphical representation of the above data can be seen in the following figure
45%
45%
40%
35%
35%
30%
25%
20%
20%
15%
10%
5%
0%
1 month or below Between 1-6 months More than 6 months
Figure 4.1
Analysis and Interpretation :From the above table and diagram it is observed that
maximum of the Device Guru’s are working from more than 6 months (i.e. 45%) in
AIRTEL and very few joined recently (i.e.20%). So it can be said that they are happy
with the organization’s rewards and recognition given to them and also the facilities
provided to them.
Table No. 4.2
The study was conducted to find out the number of customers a DG attend on daily
basis
Factors Number of respondent Percentage(%)
Below 10 0 0
10-20 14 70
21-30 6 30
More than 30 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
Sales
0%
0%
30%
Below 10
Between 10-30
Between 30-60
70%
More than 60
Figure 4.2
Analysis and Interpretation: From the above table and diagram it is observed
that maximum number of customers attended by DG are between 10-30 (i.e.70%) and
few attended between 30-60 (i.e.30%). Therefore it can be said that the outlets where
the DG’s are placed have an opportunity to increase Airtel 4G GROSS because they
can approach maximum number of the customers who walked in the outlet.
Table No. 4.3
The study was conducted to find out the number of handsets sold in the outlets of DG.
Factors Number of handsets sold Percentage(%) (approx.)
daily(20 Outlets)
Below 5K 37 22
5K-10K 55 33
10K-20K 57 34
Above 20K 18 11
TOTAL 167 100
Graphical representation of the above data can be seen in the following figure
34%
33%
35%
30%
25% 22%
20%
15%
11%
10%
5%
0%
Below 5K 5K-10K 10K-20K Above 20K
Figure 4.3
Analysis and Interpretation: From the above table and diagram it is observed
that maximum range of handsets are sold between 5K-10K (i.e 33%) and 10K-20K (i.e.
34%). Hence Airtel should try to give free sim with some extra benefit with these
handsets (such as cashback,etc.) so as to increase 4G GROSS.
Table No. 4.4
The study was conducted to find out how many times does the DG received incentives.
Factors Number of Respondents Percentage(%)
1-5 times 15 75
6-10 times 4 20
11-15 times 0 0
More than 15 times 1 5
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
0%
5%
20%
1-5 times
6-10 times
11-15 times
75%
More than 15 times
Figure 4.4
Analysis and Interpretation :From the above table and diagram it has been observed
that maximum of the DG got 1-5 times incentives only (i.e. 75%). Therefore an extra
training should be given to all the DG where they should be motivated to work for
incentives rather than basic pay which will help to increase 4G GROSS Productivity for
Airtel. Also a rating or gifts can be given to the DG as per their incentive earning which
may motivate other DG’s to work more enthusiastically.
Table No. 4.5
The study was conducted to find out that how is the 4G Network of Airtel as compared
to its competitors.
Factors Number of Respondent Percentage(%)
5 2 10
4 11 55
3 7 35
2 0 0
1 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
60% 55%
50%
40% 35%
30%
20%
10%
10%
0% 0%
0%
5 4 3 2 1
Figure 4.5
Interpretation : From the above table and diagram it has been observed that
maximum number of DG has rated Airtel 4G Network as 4 (i.e.55%) and 3 (i.e.35%).
There are various issues related to network as found in my survey in some areas of
Guwahati. It should be solved as early as possible so that it doesn’t effect in the 4G
GROSS Productivity.
Table No. 4.6
The study was conducted to find out how many customer enquire about Airtel 4G
while buying a new handset.
Factors Number of respondents Percentage(%)
Below 10 17 85
10-30 3 15
31-60 0 0
More then 60 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
0% 0%
15%
Below 10
10 to 30
31 to 60
85% More than 60
Figure 4.6
Analysis and Interpretation : From the above table and diagram it has been observed
that maximum number of customer enquire about Airtel 4G while buying a new
Handset is very low i.e below 10. So banners/posters should be displayed outside
every DG Outlet for customer awareness.
Table No. 4.7
The study was conducted to find out the type of relationship the DG have with their
superior, co-workers and subordinates.
Factors Number of respondent Percentage(%)
Very Good 7 35
Good 13 65
Average 0 0
Poor 0 0
Very Poor 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
70% 65%
60%
50%
40% 35%
30%
20%
10%
0% 0% 0%
0%
Very Good Good Average Poor Very Poor
Figure 4.7
Analysis and Interpretation: From the above table and diagram it is observed
that maximum responded very good (i.e.35%) and good (i.e.65%) when they were
asked about the type of relation they are having with their superior, co-workers and
subordinates. Hence it can be said that the DG are getting full support from them.
Table No. 4.8
The study was conducted to find out if a DG Counter is provided in the outlet, it will
help to increase 4G GROSS productivity.
Factors Number of respondents Percentage(%)
Strongly agree 7 35
Agree 13 65
Neutral 0 0
Disagree 0 0
Strongly disagree 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
0%
0%
0%
35%
Strongly Agree
Agree
65% Neutral
Disagree
Strongly Disagree
Figure 4.8
Analysis and Interpretation : From the above table and diagram it has been observed
that maximum responded towards agree (i.e.65%) and few responded towards
strongly agree (i.e.35%). Hence it can be said that a DG Counter should be provided
to the DG in the outlet which will definitely help in increasing 4G GROSS Productivity.
Table No. 4.9
The study was conducted to find out whether Airtel banners/posters outside the
outlet will help to increase 4G GROSS productivity.
Factors Number of respondents Percentage(%)
Strongly agree 16 80
Agree 4 20
Neutral 0 0
Disagree 0 0
Strongly disagree 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
80%
80%
70%
60%
50%
40%
30%
20%
20%
10%
0% 0% 0%
0%
Strongly Agree Agree Neutral Disagree Strongly Disagree
Figure 4.9
Analysis and Interpretation : From the above table and diagram it has been observed
that maximum responded towards strongly agree(i.e.80%). Therefore in every DG
Outlets banners/posters should be displayed outside the outlet which will boost the
4G GROSS Productivity.
Table No. 4.10
The study was conducted to find out whether Canopy infront of the DG outlet will help
to increase 4G GROSS productivity.
Factors Number of respondents Percentage(%)
Strongly agree 6 30
Agree 14 70
Neutral 0 0
Disagree 0 0
Strongly disagree 0 0
TOTAL 20 100
Graphical representation of the above data can be seen in the following figure
0%
0% 0%
30%
Strongly Agree
Agree
Neutral
70%
Disagree
Strongly Disagree
Figure 4.10
Analysis and Interpretation : From the above table and diagram it has been
observed that maximum responded towards Agree(i.e.70%) and few responded
towards Strongly Agree (i.e.30%). So canopy once in a week should be given outside
the outlet which will help in increasing productivity of Airtel 4G GROSS.
Table No. 4.11
The study was conducted to find out that Proper training are given to the DG or not
and also the rating of Airtel as a company by the DG.
5-30%
6. Rating Airtel as a company (5 being 4-70%
Best and 1 being Poor) 3-0%
2-0%
1-0%
ANALYSIS AND INTERPRETATION :From the above table it has been observed that
the DG are well trained as they have answered all the questions correctly. The rating
of Airtel as a company is also good because maximum DG have given the rating as 4
(i.e. 70%) and 5 (i.e. 30%).
CHAPTER-5
FINDINGS AND
RECOMMENDATIONS
FINDINGS
1.The study shows that the relation between the DG(Promoters) and with their
superior, co-workers and subordinates is Good.
5.It was found that if any problem occurs to the DG, it is immediately solved by the TL.
6.It is found that if a DG counter in the outlet, Airtel banners/posters outside the outlet
and canopy infront of the outlet is provided, it will help to increase the 4G GROSS
Productivity in the outlet.
RECOMMENDATIONS
1.A medical camp should be arranged in every 6months for all the DG Outlets
members.
3.A free sim with unlimited calls/data should be provided to the owner of the DG Outlets
which will lead toward of mouth promotion as well as help in increasing 4G GROSS in
his outlet
4.An Aadhaar sim activation machine should be provided to the DG of the outlets.
9.Free gifts should be distributed to the DG Outlets and also to the DG.
CHAPTER-6
DG OUTLETS
&
ACTIVITY DONE
NAME OF THE OUTLETS ADDRESS DEVICE GURU(DG)
1.Connecting People Last Gate Biraj Borah
CHAPTER-7
CONCLUSION
CONCLUSION
The project has given a good opportunity to understand about the 4G GROSS concept
and also how to work practically. Results revealed that there is a potential scope in 4G
GROSS.
From the analysis it is found that thereis a scope of further improvement of the 4G
GROSS Productivity. The promoters are satisfied with the working condition of the
outlet.The PROMOTER APP also have few problems which should be resolved as
early as possible.
At last, from the study it is concluded that 4G GROSS Productivity will definitely be
increased if recommendations are implemented and promoters are well-trained and
are satisfied with the organization for the rewards and recognition provided to them.
APPENDIX-I
QUESTIONNAIRE
Dear Respondent, I am a student of MBA 3rd SEMESTER from Dibrugarh University. As
a part of my course, I am required to conduct a survey. The Name/Topic of my project
is “How to increase 4G GROSS to 3 productivity from DG Outlets in Guwahati”. Please
participate in the survey by answering below questions. Basic Information :
iii)Location ____________________________________________
_____________________________________________________________________
Yes No
Yes No
9.How you rank Airtel as a company out of 5 Point Scale where 5 being the best and 1
being the poor?
5 4 3 2 1
10.How do you rate the network of Airtel 4G against its competitors? Kindly rate on a
5 Point Scale where 5 being the Best and 1 being the Poor.
5 4 3 2 1
Yes No
12.How many customers enquire about Airtel 4G While buying a new Handset?
14.Do you think, if a DG counter is provided in the outlet, it will help to increase the
4G GROSS Productivity in the outlet?
15.Do you think AIRTEL Banner/Posters outside the outlet help to increase the 4G
GROSS Productivity in the outlet?
16.Do you think Canopy infront of the DG Outlet help to increase the 4G GROSS
Productivity in the outlet?
_________________________________________________________________
BIBLIOGRAPHY
BOOK
Kothari, C. R., & Garg, G. (2016). Research Methodology : Methods and Techniques. New
Delhi: New Age International Publishers.
WEBSITES