COCA COLA Company Report
COCA COLA Company Report
COCA COLA Company Report
ON
Relevance of data usage with front line sales team and it’s impact
BY
ANKIT SHARMA
SULTANPUR
i
ACKNOWLEDGEMENT
This project has been a great learning experience for me & I would like to express my sincere
gratitude to all the people who guide me through the project and without the valuable guidance
and suggestions of these people this project would not have been completely successful. I took
the opportunity to do my internship in a COCA COLA company (AMRIT BOTTELER’S PLANT).
I owe enormous intellectual debt towards my Mentor, HR manager for their continuous support
and cooperation throughout my project without which the present work would not have been
possible.
I also want to give special thank to MR.DINESH SIR, MR.ARCHIT TIWARI SIR & RIYA MAAM
For permitting me to do the summer training, sharing valuable experience and suggestions
regarding preparation of project report.
I would like to thank all the respondents whom I interacted during my project & all the
employees for their cooperation without this I may not able to complete it successfully.
TABLE OF CONTENTS
ii
SN Contents Pg No
Acknowledgement 1
Introduction 1
Roles 39-58
Conclusion 59-60
iii
The Coca-Cola Company profile
INTRODUCTION:-
The Coca-Cola Company (NYSE: KO) is a total beverage company, offering over 500 brands in more than
200 countries and territories.
In addition to the company’s Coca-Cola brands, our portfolio includes some of the world’s most
valuable beverage brands, such as AdeS soy-based beverages, Ayataka green tea, Dasani
waters, Del Valle juices and nectars, Fanta, Georgia coffee, Gold Peak teas and coffees, Honest
Tea, innocent smoothies and juices, Minute Maid juices, PowerAde sports drinks, Simply juices,
smart water, Sprite, vitamin water and ZICO coconut water. We’re constantly transforming our
portfolio, from reducing sugar in our drinks to bringing innovative new products to market.
We’re also working to reduce our environmental impact by replenishing water and promoting
recycling. With our bottling partners, we employ more than 700,000 people, helping bring
economic opportunity to local communities worldwide.
About Coca-Cola India:-
Coca-Cola India is one of the country’s leading beverage companies, offering a range of healthy, safe,
high quality, refreshing beverage options to consumers.
Ever since its re-entry in 1993, the Company has gone on to establish an unmatched portfolio of
beverages, refreshing consumers with its leading beverage brands like Coca-Cola, Coca-Cola Zero, Diet
Coke, Thums Up, Fanta, Fanta Green Mango, Limca, Sprite, Sprite Zero, VIO Flavored Milk, Maaza,
Minute Maid range of juices, Georgia and Georgia Gold range of hot and cold tea and coffee options,
Kinley and Bonaqua packaged drinking water, Kinley Club Soda and BURN energy drink.
4
The Company along with its bottling partners, through a strong network of over 2.6 million retail outlets,
touches the lives of millions of consumers. Its brands are some of the most preferred and most sold
beverages in the country.
The Coca-Cola system in India has already invested $2 billion till 2011, since its re-entry into India.
The company will be investing another $5 billion till the year 2020. The Coca-Cola system in India
directly employs over 25,000 people including those on contract.
The system has created indirect employment for more than 1, 50,000 people in related industries
through its vast procurement, supply and distribution system. We strive to ensure that our work
environment is safe and inclusive and that there are plentiful opportunities for our people in India and
across the world.
5
With an enduring commitment to building sustainable communities, our Company is focused on
initiatives that reduce our environmental footprint, support active, healthy living, create a safe, inclusive
work environment for our associates, and contribute to the development of the communities where we
operate.
Some of the Company’s flagship community development programmes include the “Support My
School” programme, the “Parivartan” retailer training programmers, women empowerment as a part of
the global 5BY20 campaign etc.
6
TCCC re-entered the Indian market post the economic liberalization of 1991 and established Coca-
Cola India Private Limited (CCIPL) as its wholly-owned subsidiary in 1992. The entities that comprise
the Coca-Cola System in India are:
Coca-Cola India Pvt Ltd is a wholly-owned subsidiary of The Coca-Cola which manufactures and sells
concentrate and beverage bases and powdered beverage mixes.
Coca-Cola India Private Limited sells concentrate and beverage bases to authorized bottlers. These
authorized bottlers independently develop local markets and distribute beverages to grocers, small
retailers, supermarkets, restaurants and numerous other businesses. In turn, these customers make our
beverages available to consumers across India.
7
8
PRODUCTS LIST OF COCA - COLA
Coca-Cola THUMS UP
LIMCA Maaza
9
Minute Maid Apple Zico
10
Minute Maid Nimbu Fresh Minute Maid Pulpy Santra
11
VIO MINUTE MADE SMOOTHE
12
MINUTE MAID NUTRIFORCE APPLE COCA COLA LIGHT
13
SPRITE MINUTE MAID GRITTY GUAVA
15
RAM
APPLE SPARKLE
17
BRIEF HISTORY OF COCA-COLA
Brief company history
Coca-Cola history began in 1886 when the curiosity of an Atlanta pharmacist, Dr. John S.
Pemberton, led him to create a distinctive tasting soft drink that could be sold at soda
fountains.
He created a flavored syrup, took it to his neighborhood pharmacy, where it was mixed with
carbonated water and deemed “excellent” by those who sampled it. Dr. Pemberton’s partner
and bookkeeper, Frank M. Robinson, is credited with naming the beverage “Coca-Cola” as well
as designing the trademarked, distinct script, still used today.
Did you know? The first servings of Coca-Cola were sold for 5 cents
per glass. During the first year, sales averaged a modest nine servings
per day in Atlanta. Today, daily servings of Coca-Cola beverages are
estimated at 1.9 billion globally.
Prior to his death in 1888, just two years after creating what was to become the world’s #1-
selling sparkling beverage, Dr. Pemberton sold portions of his business to various parties, with
18
the majority of the interest sold to Atlanta businessman, Asa G. Candler. Under Mr. Candler’s
leadership, distribution of Coca-Cola expanded to soda fountains beyond Atlanta. In 1894,
impressed by the growing demand for Coca Cola and the desire to make the beverage portable,
Joseph Biedenharn installed bottling machinery in the rear of his Mississippi soda fountain,
becoming the first to put Coca-Cola in bottles.
Large scale bottling was made possible just five years later, when in 1899, three enterprising
businessmen in Chattanooga, Tennessee secured exclusive rights to bottle and sell Coca-Cola.
The three entrepreneurs purchased the bottling rights from Asa Candler for just $1. Benjamin
Thomas, Joseph Whitehead and John Lupton developed what became the Coca-Cola worldwide
bottling system.
Among the biggest challenges for early bottlers, were imitations of the beverage by competitors
coupled with a lack of packaging consistency among the 1,000 bottling plants at the time. The
bottlers agreed that a distinctive beverage needed a standard and distinctive bottle, and in
1916, the bottlers approved the unique contour bottle.
The new Coca-Cola bottle was so distinctive it could be recognized in the dark and it effectively
set the brand apart from competition. The contoured Coca-Cola bottle was trademarked in
1977. Over the years, the Coca-Cola bottle has been inspiration for artists across the globe — a
sampling of which can be viewed at World of Coca-Cola in Atlanta.
The first marketing efforts in Coca-Cola history were executed through coupons promoting free
samples of the beverage. Considered an innovative tactic back in 1887, couponing was followed
by newspaper advertising and the distribution of promotional items bearing the Coca-Cola
script to participating pharmacies.
19
Fast forward to the 1970s when Coca-Cola’s advertising started to reflect a brand connected
with fun, friends and good times. Many fondly remember the 1971 Hilltop Singers performing
“I’d Like to Buy the World a Coke”, or the 1979 “Have a Coke and a Smile” commercial featuring
a young fan giving Pittsburgh Steeler, “Mean Joe Greene”, a refreshing bottle of Coca-Cola.
You can enjoy these and many more advertising campaigns from around the world in
the Perfect Pauses Theater at World of Coca-Cola.
The 1980s featured such memorable slogans as “Coke is It!”, “Catch the Wave” and “Can’t Beat
the Feeling”.
In 1993, Coca-Cola experimented with computer animation, and the popular “Always Coca-
Cola” campaign was launched in a series of ads featuring animated polar bears. Each animated
ad in the “Always Coca-Cola” series took 12 weeks to produce from beginning to end.
The bears were, and still are, a huge hit with consumers because of their embodiment of
characteristics like innocence, mischief and fun. A favorite feature at World of Coca-Cola is the
ability to have your photo taken with the beloved 7′ tall Coca-Cola Polar Bear.
20
In 2009, the “Open Happiness” campaign was unveiled globally. The central message of “Open
Happiness” is an invitation to billions around the world to pause, refresh with a Coca-Cola, and
continue to enjoy one of life’s simple pleasures. The “Open Happiness” message was seen in
stores, on billboards, in TV spots and printed advertising along with digital and music
components — including a single featuring Janelle Monae covering the 1980 song, “Are You
Getting Enough Happiness?” The happiness theme continued with “Open the Games.
Open Happiness” featured during the 2010 Winter Olympic Games in Vancouver, followed by a
2010 social media extension, “Expedition 206” — an initiative whereby three happiness
ambassadors travel to 206 countries in 365 days with one mission: determining what makes
people happy. The inspirational year-long journey is being recorded and communicated via blog
posts, tweets, videos and pictures.
Experts have long believed in the connection between happiness and wellness, and Coca-Cola is
proud to have played a part in happy occasions around the globe. In Atlanta, check out
the Coca-Cola Theater at World of Coca-Cola and see the magic that goes into every
bottle of Coca-Cola.
INTRODUCTION OF AMRIT
BOTTLERS:-
In 1982 Mr. L.D. Ladhani was given a challenging and fully diversified job of manufacturing soft drinks
viz: Thumsup, Limca, Gold Spot and Bislery Club Soda etc. as a franchisee of “PARLE EXPORT PRIVATE
LIMITED”.
He brought the production with a short span of time and achieved the highest growth in India in 1985.
The franchisee co. is named as `Amrit Bottlers Private Limited’. Subsequently `PARLE’ brand was taken
over by the `COCA COLA’ and Mr. Ladhani converted the mechanized plant into fully automatic and
computerized plant and now is having a largest production capacity and highest sale in Eastern U.P. for
the last several years.
21
They have a `COLD STORAGE’ named as `Laxmi Cold Storage and Allied Industries’ adjacent to the `Amrit
Bottlers Private Limited’, Faizabad now the same has become one of the largest capacity to preserve to
potatoes and fruits in Eastern U.P.
The enterprising factor which can be termed as back bone of the Mr. Ladhani’s success is the joint
efforts of the management, which brought all the ventures to highest level of production and
profitability within a record time.
Mr. Ladhani is being assisted by qualified and experienced personnel of technical, management, finance
and marketing and by his four sons named as Mr. Rakesh Ladhani, Mr. Naresh Ladhani and Mr. Rajesh
Ladhani, Mr. Roshan Ladhani, M.B.A. from U.K., who are technically and professionally qualified and are
well experienced & who are the key persons of various projects.
Website
http://www.amritbottlers.com
Headquarters
Factsheet
Basic Information
Exporter
Supplier
Total Number of
51 to 100 People
Employees
22
Year of Establishment 1984
Statutory Profile
Our vision serves as the framework for our road map and guides every aspect of our business by
describing what we need to accomplish in order to continue achieving sustainable, quality growth.
Be a great place to work where people are inspired to be the best they can be
Bring to the world a portfolio of quality beverage brands that anticipate and satisfy clients desires and
needs
Nurture a winning network of customers and suppliers, together we create mutual, enduring value
23
AMRIT BOTTLERS VALUES:-
We are data-based and intellectually honest in advocating proposals, including, recognizing risks
We accept personal accountability to meet our business needs, improve our systems and help others
improve their effectiveness
24
Coca Cola
Thumbs Up
Limca
Fanta
Sprite
Diet Coke
Kinley Soda
Kinley Water
Maaza
Our quality range of products is highly demanded in the market. Some of the reasons for which, we
have become a preferred choice of our customers are as follow :
Advanced infrastructure
Hardworking professionals
25
DIRECTORS:-
ACHIVEMENTS:-
26
24 HUB NAMES:-
6- Gopalganj 18-Deoria
7- Khalilabad 19-Fatehpur
8- Pratapgarh 20-Siddharthnagar
9- Padrauna 21-faizabad
10-Karvi 22-Amethi
11-Basti 23-Rudhauli
12-Nausar 24-Maharajgan
27
COCA-COLA:-
The coca cola company is the world’s leading manufacturer, distributor. Of non-alcoholic
beverages concentrates and syrups, with world headquarters in Atlanta, Georgia.
Since company is expected to expand its services to serve 16 million customers daily with
variety of products like Coca-Cola classic, Diet Coke, Cherry Coca Cola etc. Thus, Coca Cola has
to produce more products to achieve its objective of serving its customer.
It is difficult task for Coca Cola to achieve its objective in this competitive environment with
existing system. So a cost effective and efficient management system is very critical for Coca
Cola to ensure smooth running of its business.
Coca Cola management system is expected to improve the operating efficiency of Coca Cola
and enhance customer satisfaction with better services. The aim specified by the Coca Cola
need to be fulfilled by the improved system in the organization.
The M.I.S (Management information system) controls the all over market and sales reporting of
Coca-Cola. They control the total supply, delivery, orders, issues and report of frontline team of
24 districts.
28
RELEVANCE OF DATA USAGE WITH FRONT LINE
SALES TEAM AND ITS IMPACT :-
The frontline sales team carries M.D (Market Developer). As we know Market Development is a
growth strategy that identifies and develop new market segments for current products.
Our company developers interact with the distributors, shopkeepers, and few time they
interact and manage our customers too. Here a question arises that who controls and manage
them? According to which data they work ? on which basis their performances are rated? How
they know the consumption details of market?
All the system is controlled by M.I.S team,they co-ordinate all the M.D’s of the company which
are working in 24 districts.
They provide them the targets of the company according to which they have to work. Each M.D
have its different area for marketing and distribution. They also take care of the VGs and deep
freezer of the shops.
There are different type of datas given to M.ds for their daily help by which they can easily be
able to take orders and know the exact status of orders been holding in the particular market.
29
Objective of M.I.S:-
* M.I.S gives them their daily reporting data helps them to clear their doubts.
* They tell them about the targets of the company in the particular districts.
* M.T.D (Month till date) sale and Y.T.D (Year till date) sale of every district is maintained by the
M.I.S system.
* It improves the works of the developers by doing their technical work easily.
* Daily presence of M.D is also recorded by the M.I.S system. Their area, outlets, orders and
issues are also recorded in the same.
* M.I.S system helps in increasing the sales of the company as per the recorded data of the
markets. They also notices the competitors of their product in the market which helps the
company to stable their product in the particular market.
* Co-ordination from the Frontline sales team is necessary . just because of it the company
knows the exact situation of the market that how their product is been performing in the
market .
30
* Frontline sales team just have to work on their targets which is given by company and to sale
our product by convencing the shopkeepers in a polite and calm way which also attracts the
mind of the shopkeepers.
* The overall coordination helps the sales and marketing team to increase their sale and to
improve the condition of the markets where there is low sales level of the company.
* Hence both M.I.S team and sales team works in a combination to complete the objective of
the company.
IMPLEMENTATION:-
Various information regarding manufacturing and its operation has been collected using the
information tools, Excel as TPS (Transaction Processing System). This data are recorded
using TPS and the output of TPS is further used in Decision Support System (DSS). For
example, doing “what if analysis”.
Excel has been used as information system tool for recording the primary data about sales,
inventory, purchase, and doing “what if analysis” for decision purpose.
What–if analysis is used by the middle management to take several decisions for
unstructured decisions. It is a tool used by DSS. Here what if analysis is done regarding
financial position of train ticketing system by goal seeking.
31
Whenever to create a formula or function in Excel, put various parts together to calculate a
result. Goal Seek works in the opposite way: It lets you start with the desired result, and it
calculates the input value that will give you that result. This is the example to show how to
use Goal Seek.
1. Select the cell whose value you wish to change. Whenever you use Goal Seek, you'll
need to select a cell that already contains a formula or function.
2. From the Data tab, click the What-If Analysis command and then select Goal Seek from
the drop-down menu.
5. The dialog box will tell you if Goal Seek was able to find a solution. Click OK.
Here are the information related inventry and purchase and sales data that are recorded in
excel. Now we will use what if analysis and goal seek for dealing with different scenarios.
32
33
34
Scenario 1: due to the change in different political and economic crisis there occurs inflation in
country. Let us see what happens to the revenue when high inflation and moderate inflation
occurs.
Scenario 2: the management team has decided that the revenue from must rise to fifty
thousand by the next year. Now using goal seek find what changes occur with the quantity of
Kinley that must be sold
35
Scenario 3: if the management team has decided that the sales of coca-cola need to be brought
up to get revenue of twenty-one thousand. Let’s see how many coca-cola need to ne sold in
order to come within targeted revenue.
36
Co-ordination with sales team of Coca-Cola:-
As there are employees in market which are doing their work too. So to co-ordinate them we
worked with M.I.S team.
There is a daily process to co-ordinate with them to know their market status, how they are
working, their timing in the market, what orders they are getting and how the supply is going
on.
M.I.S team also works on the issues which are going on in the market and transfers it directly to
the A.S.M or R.S.M of the company and even after it problem is arriving company directly
resolves it in a easy manner.
37
1- Attendance:-
It plays an important role in the coordination . it helps to notices all the frontline employees to
whether they are present in the market or not. Date wise day wise and month wise attendance
sheet is prepared for all the sales team working in the market.
Here in the table P stands for presence of the candidate in the market.
A for Absent.
HL for half leave in this situation may be the candidate is busy somewhere and unable to attend
the market for half day.
38
39
2-Follow up of Frontline sales team:-
Day by day reporting of frontline sales team is very important because it helps us to know the
timing of arrival, how much outlets they are covering and what issues they are getting in the
market?
In followup they also defines the condition of the market that how the market is going on which
product is more dominant in the market, which product is the competitor of ours product in the
market everything gets cleared in the follow up.
Every outlets have their own orders, stocks, and limit to purchase the products and our sales
team know it very well so as per the orders they visit the outlets more and more.
40
41
3- Orders as per outlets:-
The main work for the frontline sales team is to generate the orders on every outlet.
As per the outlets location the orders also differs because location play an important role. We
take an example of a shop which is located near School.
what should be the orders of that outlet ? Almost all order should beplaced there but the most
demanded will be 250ml drinks, tetra packs and 600ml .
Orders are also generated on our frontline sales team interaction with the shopkeepers.
Here total sales and orders of the every product is been denoted.
42
43
CONCLUSION:-
I learned and acquired the skills of the corporate life by attending a daily training in the
company.
During the study of Coca-Cola production system, the present system used by the company was
seen and studied.
It was found with the problem and system analysis is done by bringing solution to it is a new
computerized information system with the help of processes like system design, system
implementation, testing, conversion, production maintenance etc. It will solve the problem of
inventory, production process, sales etc.
MIS department is responsible for the generation of reports for each department i.e. for
production department about the situation of empty and syrup, report of manufactured stock
for the sales coordinator. And these reports are also submitted to the TGM and to the Accounts
Manager. On the basis of these reports Management make decisions about the production,
sales and different matters. This department is also responsible for the development of
computer programs for all departments.
With the implementation of the new system the company will be able to obtain its objectives
and helps to remain active in competitive market. Manifesto for Growth has set the strategic
road map, and the engagement of the people has given us a solid start.
44
BIBLIOGRAPHY:-
8- Wikipedia
45
REFERENCE:-
1. http://www.mhhe.com/busness/mis/obrien
2. http://www.mysolveit.com
3. http://www.ala.org/ala/mgrps/divs/llama.index.cfm
4. http://www.mfgsys.co.in
46