coca-cola enterprises: using data transparency to improve your bottom line

©2013 Software AG. All rights reserved. ©2013 Software AG. All rights reserved.

John C. Wilson, Associate Director I.T Development Jared Austin, Associate Director I.T Development Oct 2013

Using Data Transparency to Improve Your Bottom Line

©2013 Software AG. All rights reserved. For internal use only

2 |


3 |

OUR HISTORY

THE COKE SYSTEM & CCE I.T.

ENABLING OPPORTUNITIES

TECHNICAL OVERVIEW

LEARNINGS

Coca-Cola Enterprises


4 |

1970s to early

1980s

Atlanta pharmacist Dr. John Pemberton creates Coca-Cola syrup for sale in fountain drinks

The Coca-Cola contour bottle enters the market

Hundreds of independent Coca-Cola franchise bottlers operate in the U.S. Consolidation gets under way in the early 1980s to make the system more effective

1886 1916

CCE: Our Proud History


5 |

2010 1986 1996 2006

The Coca-Cola Company merges some of its bottling operations with the John T. Lupton franchises and BCI Holding Corp’s bottling holdings – forming Coca-Cola Enterprises Inc., a publicly traded company on the New York Stock Exchange.

CCE buys the Coca-Cola bottling operations in Belgium and France.

CCE celebrates its 20th birthday and John Brock joins the company as President and CEO.

CCE sells its operations in North America to The Coca-Cola Company and acquires the Coca-Cola bottling businesses in Norway and Sweden.

Coca-Cola Enterprises is Born…


6 |

Coca-Cola Enterprises is the leading Western European marketer, distributor and producer of non-alcoholic beverages. It is one of the world’s largest independent Coca-Cola bottlers.

► 40+ Brands ► $8.1 billion revenue ► 12 Billion bottles

and cans per year ► 170 million

consumers

Who We Are & What We Do


7 |

Country HQ Manufacturing Sites

Brussels

Antwerp Chaudfontaine Ghent

Paris

Clamart Dunkirk Grigny Toulouse Marseille

Uxbridge

Colwall East Kilbride Edmonton Milton Keynes Morpeth Sidcup Wakefield

Rotterdam Dongen

Oslo Oslo Stockholm Stockholm

Norway

Sweden

Great Britain

France Belgium

The Netherlands

17 manufacturing facilities 13,000 employees


Presenter

Presentation Notes

CCE is the sole licensed operator for products of The Coca-Cola Company in Norway, Sweden, Great Britain, The Netherlands, Belgium and France.


8 |

PRODUCE SELL, SERVICE & MERCHANDISE

DIRECT & INDIRECT DELIVERY



9 |

STILL DRINKS

SPORTS AND ENERGY DRINKS WATERS

SPARKLING SOFT DRINKS

Some of Our Key Brands


10 |

THE FRANCHISOR

► Brand and Concentrate Owner ► Product Innovation ► Consumer Market Strategy

THE FRANCHISEE

► Production and Distribution in specific territory

► Category Development ► Sales and Customer Marketing

The Coke System


11 |

VALUES Accountable Customer focused Team driven

Foster a competitive advantage to our Business through market differentiating capabilities, high quality

infrastructure, and leveraging innovative technologies

Executional excellence every day

Provide excellent

IT services and solutions

at the right investment

Maintain a

robust, reliable, and

secure technology

infrastructure

Enable world class capabilities in the business through robust transactional

systems

Lead IT

innovation and emerging

technologies

Enable the Business through IT services & products

VISION: IT is the valued provider of differentiating services, solutions, and

technology enabling Coca-Cola Enterprises to Win everyday.

Provide innovative

thought leadership

PARTNER INNOVATE STEWARD ENABLE

Our Vision & Operating Framework


12 | 12

Our Vision & Operating Framework


13 |

Ena

blin

g th

e C

CE

Way

Foun

datio

nal -

----

-----

------

-----

------

----D

iffer

entia

ting

FOUNDATION Stable Infrastructure Support Services SOX Controls and Secure Environment

EXECUTION EXCELLENCE EVERYDAY

Supply Chain RGM HR Finance Collaboration

Master Data As-Is / To-Be Process Business Process Standardization and Harmonization

Gen

esys

Customer Sales & Service

DIGITAL CAPABILITIES Mobility Social & Assets

Digital Payments Shopper Insights

INFORMATION TRANSPARENCY Business-to-Business Social

Integration

ENABLING WORLD CLASS CAPABILITES Sales Execution Excellence Revenue Growth Management

IT Architecture


14 |

IT Architecture

IT Architecture


15 |

‣ Data Center in New York USA ‣ Help Desk in South Africa ‣ Support in Mumbai, Bangalore, Noida,

Hyderabad, and Chennai India

Locally based across our European territories:

Norway, Sweden, Great Britain, The Netherlands,

France, and Belgium

Headquartered in Atlanta with specialized development in Kentucky

Headquartered in Atlanta and locally based across our European territories

IT Leadership & Governance IT Deployment

IT Development IT Operations

Global CCE IT Organization


16 |

OUR HISTORY



TECHNICAL OVERVIEW

LEARNINGS



17 |

Integration: Never Ending Upwards Growth


18 |

… when it’s simple.

Past Physical Maps / TV and Radio Traffic Reporting

Present Built-in GPS with Integrated Traffic / Crowd Sourced Traffic Data

Integration is Adopted Faster…


19 |

….more commonplace

Past On/off Switch + Spousal Argument Lever

Present (Nest) Wi-Fi Enabled + Remote Control + Energy Efficient + Learning Capabilities

Machine to Machine Integration…


20 |

Past Example of Innovation & Integration

10/14/2013 20


21 |

10/14/2013 21

Just Look at Those Features!

ONLY $3.99!!!!!


22 |

The Past Can be a Good Source of Inspiration

10/14/2013 22


23 |

10/14/2013 23

On Sale Now!


24 |

So… what can CCE Integrate? And Why?

Presenter

Presentation Notes

Kevin Flowers attended a Asset Protection team update meeting a few years ago and came away with some very interesting information… Their #1 challenge was the recovery of nearly 6000 coolers that are lost per year! Maybe IT can help..


25 |

Remember This Guy?

Presenter

Presentation Notes



26 |

10% of Vend/Cooler Equipment Lost


27 |

Where Did My Equipment Go???


28 |

$10,000,000 per YEAR


29 |

Cooler Fleet Install Base

0

50000

100000

150000

200000

250000

300000

350000

400000

450000

500000

Coolers Vendors Post Mix

Overall Install Base (across Europe)

115,299 52,761

TOTAL INSTALL BASE 580,623

412,563

Presenter

Presentation Notes



30 |

0

500

1000

1500

2000

2500

Cool

ers

Vend

ors

Post

mix

Cool

ers

Vend

ors

Post

mix

Cool

ers

Vend

ors

Post

mix

GB France Benelux

2347

191

911

871

26

46

1761

216

118

Lost

Lost Equipment by BU by Equipment Type Period = 12 months

Equipment Losses By Country

Presenter

Presentation Notes



31 |

What Can We Look For If We Integrate?


32 |

Internal Temperature

Ambient Temperature

Reduce Cost & Ensure the Consumer Enjoyment factor

- How can we prove that our coolers operate within a limited band of ambient temperature?

- How can we ensure that our consumers always have the opportunity to consume a cold product?

Presenter

Presentation Notes

Lots of times we will get calls from our customers saying our beverages are not chilled to optimal temperature. What if we had a device in our cooler that could predict when this condition will happen and dispatch a technician before it is too late? And why would we care about ambient temperature? Our coolers are manufactured to allow for a wide range of ambient temperature. If we can show that our machines only operate within a limited band of ambient temperature, the cost of manufacturing these half a million coolers will go down.


33 |

Equipment Repair & Maintenance Costs Are High

Estimated $65 per visit

Presenter

Presentation Notes

Even though we’ve got outstanding equipment, every now and then it still breaks down. Wouldn’t it be nice to know if the machine was having some kind of issue?


34 |

Aeronix can design, develop, customize, and miniaturize tactical communications products to meet your specific needs.


35 |

Introducing the Smart Cooler!

*Prototype

Presenter

Presentation Notes

This is the Smart cooler prototype. Production runs of the Smart Cooler will most likely be an epoxy coated circuit board that will be installed during the manufacturing process and/or installed during a retrofit process.


36 |

Introducing the Smart Cooler! The cooler telemetry device is a low cost solution that is placed inside of the cooler and will send data about the cooler to CCE through a cellular network.

Data Collected Cooler temperature Ambient temperature Current load of the compressor Compressor runtime GPS coordinates Machine tilt or movement EMS device telemetry Door openings Power state Battery state

Presenter

Presentation Notes

Here you see some of the data we collect from our units in the field. Currently we’re still in the prototype phase and we have 12 units deployed in the field.


37 |

Smart Cooler Savings

At $65 per visit, saving one service call can pay for the Smart Cooler device

$210K per year could be saved by just replacing filters when needed

Presenter

Presentation Notes

Even though we’ve got outstanding equipment, every now and then it still breaks down. Wouldn’t it be nice to know if the machine was having some kind of issue?


38 |

Proof of Concept – Smart Cooler

Equipment retrofitted in the US 20 coolers included in test

18 Distributed in France and Great Britain 1 in CCE office 1 in Aeronix

6 month time frame deployed in the field Data streams sent back to CCE for Analytics


39 |

OUR HISTORY



TECHNICAL OVERVIEW

LEARNINGS



40 |

500+ Interfaces

5,000,000 Monthly Transactions

400+ Integrated Apps/Partners

75% Annual Revenue from Electronic Orders

Enable over 500 Service Technicians Integration traffic

increasing around 40% per year

Current CCE Integration Stats


41 |

Sr. Developer Sr. Developer Developer Developer

webMethods IS

CCE Framework

EDI Standards

IDoc Integration

UNIX/AIX OS

Network/Comm

New Areas of Development Skillsets

SFDC Integration

API Development

SaaS Integration

Organization


42 |

• webMethods leverages 4 distinct server clusters to help balance load of transactions.

Gateway

Mapping

SAP

API Cluster API Cluster

The Gateway cluster is responsible for all document retrieval and processing. These servers also direct how documents get processed from start to finish.

The Mapping cluster is responsible for translation of documents into different formats depending on the interface.

The SAP cluster is responsible for IDoc traffic going to/from SAP leveraging ALE connections.

The API cluster is the only 3 node cluster responsible for handling all API/webService calls both inbound and outbound.

DB2 9.5 webMethods IS 7.1.3

DB2 9.7 webMethods IS 8.2

webMethods Landscape


43 |

Teams

API Management

Dataset - Telemeter Serial # - Geo Location - Tilt - Cooler Temp - Ambient Temp - Compressor Current - Sample Time/Date - Battery State - Power State

Cooler Services

Asset Protection

Alerts

Presentation (Web Interface)

- Web view reports - Historical data - Drill down on events - Real time mapping - Customer reports - Asset reports - Task Management

Cooler Telemetry

Data

Master Data - Outlet Data - Customer Data - Cooler Asset #

Device Management - Located at Aeronix - Firmware updates - Configuration DB - Mgmt web interface

2G Cellular Data

X Reference Table - Telemeter SN# Master Data COPY - Outlet data - Customer data - Cooler Asset# - Cooler tech data - Cooler Photos

Public Network (Internet)

Smart Cooler Prototype Data Flow


44 |

3G

https https https

Signed certificate decrypts traffic

Firewall

Inbound Load Balancer WAF

http

Enterprise Service Bus

https://api.cokecce.com

https://developer.cokecce.com

API Management Network Architecture

Presenter

Presentation Notes

So from an architecture perspective, we still follow our Enterprise Framework. The smart cooler device contacts the Aeronix servers via 2G cellular service. The Aeronix servers make a SOAP call, which we’ll be switching to a REST call for production, thru our API gateway at Mashery and into our Web Services cluster. From there a document is sent via Broker to our Gateway cluster. At that point a document is sent to TN that logs the initial SOAP call parameters. This document is passed over to our Mapping cluster which saves the values sent out to a master data table. It then does some calculations to determine if any alerts are needed due to excessive temperature or cooler has been unplugged or various other alert conditions. If an alert is needed then that document gets sent back to TN and the alert email is sent. At the bottom of the screen you can see MashZone which we’re using as our user interface and dashboarding tool.


45 |

Teams

API Management

Dataset - Telemeter Serial # - Geo Location - Tilt - Cooler Temp - Ambient Temp - Compressor Current - Sample Time/Date - Battery State - Power State

Cooler Services

Asset Protection

Alerts

Presentation (Web Interface)

- Web view reports - Historical data - Drill down on events - Real time mapping - Customer reports - Asset reports - Task Management

Cooler Telemetry

Data

Master Data - Outlet Data - Customer Data - Cooler Asset #

Device Management - Located at Aeronix - Firmware updates - Configuration DB - Mgmt web interface

2G Cellular Data

X Reference Table - Telemeter SN# Master Data COPY - Outlet data - Customer data - Cooler Asset# - Cooler tech data - Cooler Photos

Public Network (Internet)

Smart Cooler Prototype Data Flow


46 |

Coolers Online


47 |

Coolers Statistics


48 |

Coolers Statistics


49 |

OUR HISTORY



TECHNICAL OVERVIEW

LEARNINGS



50 |

What the Business Wants

Data Collected Cooler temperature Ambient temperature Current load of the compressor Compressor runtime GPS coordinates Machine tilt or movement EMS device telemetry Door openings Power state Battery state

Where are my coolers???

Presenter

Presentation Notes

Here you see some of the data we collect from our units in the field. Currently we’re still in the prototype phase and we have 12 units deployed in the field.


51 |

Fun Facts!

An empty cooler is not a broken cooler! Cell towers lie! Your equipment is not in the middle of Russia!


52 |

1 – 2 year deployment of 30k coolers

Thousands of coolers = big data analysis CEP? Optimize? Outsource solution?

RFP Currently Underway

What’s Next?


53 |

Thank You

coca-cola enterprises: using data transparency to improve your bottom line

Technology

drinkswaters2013 software

market2013 software

cocacola enterprises

internal use onlysell

internal use only12

internal use only2006

cocacola syrup

cocacola bottling operations