Incorporating Location Information Management LIM into Your Data Management Strategy

1
Incorporating Location Information Management
(LIM) into Your Data Management Strategy

• Greg Cooper Dean Foods
• VP Sales Operations

2
Agenda

• What is LIM?
• Why LIM matters?
• Dean Foods uses of LIM
• Results of LIM
• How do you know if you need LIM?
• Questions Answers

3
What is LIM?

• Location information that utilizes content and
  data along with a complete set of structured
  attributes with cross-location relationships to
  describe a location.

4
Why LIM Matters

• Location information is an important asset to any
  organization
• Provides strategic value to
• Marketing
• Sales
• Finance
• Planning
• Customer Service

5
Dean Foods - Background

• 2 companies
• Dean Suiza
• 2 corporate reporting systems
• 120 dairies with 60 customer masters
• 250,000 disparately maintained ship-to locations
• Vision to bring it all together!

6
LIM Solutions

• There are various potential LIM solution partners
  
• TDLinx was the best fit for Dean Foods

7
TDLinx

• Retail on-premise channel database
• TDLinx coding structure
• TDLinx hierarchy structures
• RetailSync process
• TDLinx client network

8
Customer Master Data Cleansing Integration

• Standardized naming conventions
• Standardized channel definitions
• Key account validation, cleansing and assignment
• De-duplication

9
Enhanced Reporting Functionality and Accuracy

• Better key account reporting the way customers
  want to see their business
• Channel market coverage analysis
• Higher confidence in customer rankings
• Future plans

10
Customer Master Data Cleansing Integration
Standardized Naming Conventions
11
Customer Master Data Cleansing Integration
Standardized Naming Conventions
12
Customer Master Data Cleansing Integration
Standardized Channel Definitions
13
Customer Master Data Cleansing Integration
Standardized Channel Definitions
14
Customer Master Data Cleansing Integration Key
Account Validation
15
Customer Master Data Cleansing Integration Key
Account Cleansing
16
Customer Master Data Cleansing Integration Key
Account Cleansing
17
Customer Master Data Cleansing Integration Key
Account Gaps
18
Customer Master Data Cleansing Integration Key
Account Assignment
Dean Other
19
Customer Master Data Cleansing Integration
De-Duplication
12 Different customer IDs 3 Different addresses
9 Unique ship-to-names 3 Different key accounts
All with year-to-date activity
20
Benefits of Enhanced Reporting Functionality and
Accuracy

• Ability to report against retail customers self
  defined hierarchy structure
• Ability to determine channel and market ACV
  coverage
• Across both DSD and warehouse distribution
• Identify voids in distribution
• Higher confidence in customer rankings
• Internal reporting
• Financial disclosures

21
TDLinx Hierarchy Ahold
Framework for Aligning Warehouse Shipments,
Including Indirects, with Store-Level Activity
and the Customer Defined Owner Hierarchy
22
Deans Disparate Customer Records - Ahold
RetailSync Integrates Our Disparate Customer
Records Into a Standardized and Maintained
Hierarchy Structure
23
Complete Visibility to Ahold Hierarchy
24
Future Plans

• Better plan, execute and evaluate new product
  speed to market by prioritizing distribution with
  customer ACV
• Integrate Spectra with internal customer data and
  make accessible to the field
• Global customer master

25
Results of LIM

• Standardized location information for multiple
  users and processes
• Better collaboration internally and externally
• Better distribution of product
• Core component to drive value in
• Product launches
• Channel coverage and penetration
• General retail execution
• Improved reporting capabilities

26
How do you know if you need LIM?

• Strategic efforts for data management, data
  integration and supply chain focus are planned
• Location information changes regularly
• Need one source of the truth for location data
  that is flexible enough to address multiple
  systems, applications and users
• Require location information content and
  management beyond your firewall

27
Thank You