Data Accuracy Task Force Update

1
Data Accuracy Task Force Update

• October 23, 2006
• Scott Brown Brad Papietro
• Customer Compliance GDS Manager
  e-Commerce Manager
• Conair Corp. Wegmans Food Markets,
  Inc.
• 609-426-1300 585-429-3127
• Scott_brown_at_conair.com
  brad.papietro_at_wegmans.com

2
Who We Are

3
What We Believe

• That Data Accuracy is Foundational and without
  it, e-commerce will only enable the rapid,
  seamless transfer of bad data and the mutual
  pollution of our systems (we will move bad data
  faster)

4
What We Believe

• Good quality data is foundational to
  collaborative commerce and global data
  synchronization. Good quality data means that all
  master data is complete, consistent, accurate,
  time-stamped and industry standards-based. By
  improving the quality of data, trading partners
  reduce costs, improve productivity and accelerate
  speed to market. Read these downloadable
  publications
• Synchronization The Next Generation of Business
  Partnering
• Data Quality Framework including the Data Quality
  Protocol
• An Enterprise Data Quality Framework
  incorporates
• An internal governance process (top down)
• A data quality management system to help improve
  the quality of data as published in the network.
• An assessment procedure to validate the existence
  and effectiveness of key data management business
  processes.
• An inspection procedure to physically validate
  product attributes.

5
Our Business Case

• To develop a standards-based set of tolerances
  which will be used within the network to ensure a
  level of data accuracy and to allow business
  users streamlined processes.
• The Data Quality Steering Committee will use our
  findings as part of the Data Quality Framework

6
Our Journey
7
Data Accuracy in GDSN 2004 Timeline
Wegmans hires 3rd Party Auditor to conduct
2 additional pilots May, 2004 Total Accuracy
Rate 33
Industry conducts Audit August, 2004 Total
Accuracy Rate 11 Total Items 244
1/1/04
12/31/04
GDSN Team alerts industry of findings at GSMP
Meeting October, 2004
GDSN Forms Data Accuracy Team for conducting
Industry Pilot June, 2004
Wegmans conducts Internal Audits
while Validating GDSN Values March, 2004 Total
Accuracy Rate 0
1
8
Data Accuracy in GDSN 2005 Timeline
Industry Call to Action (FMI, GMA, etc) March
2005
1/1/05
12/31/05
2
9
Data Accuracy in GDSN 2006 Timeline
GDSN Tolerance Team Conducts Discovery Pilot with
3 Retailers and 10 Suppliers January 2006
Industry Approves Standard by a vote of 26-0
Tolerance Team Agrees on Recommendation for
Industry
1/1/06
Today
Pilot is Completed. Results on upcoming slides.
Wegmans Grocery W/H Suppliers at 46 Accuracy
10
The Discovery Pilot Principles

• The 80-20 Rule
• Share our learnings
• Incorporate environmental issues
• Agree to improve the quality of the data for the
  long term!
• We are learning and therefore perfection is
  unattainable! This is Version 1.0!

11
Results Case Dimension Variances
12
Results Case Weight Variances
13
Results Each Dimension Variances
14
Why is the Data Inaccurate?

• Package Measurement Rules
• GTIN Allocation Rules
• Measuring Devices
• Multiple versions

15
Industry Approved Tolerances

• Case Level (for Packaging Types Evaluated)
• Dimensions plus or minus 4
• Weightsplus or minus 4
• Consumer Unit (for Packaging Types Evaluated)
• 0.25 inches for hard and medium packaging types

16
Physical products identified by the same
GTIN have inherent variability in gross weights
and linear dimensions due to manufacturing
processes, handling methods, environment and
other factors. Tolerances are defined as
allowable variations between the STATED
(synchronized) and MEASURED (actual) gross
weights and linear dimensions of a
GTIN.Acceptable tolerances are defined in the
tables below (Tolerances for Non Consumer Trade
items and Consumer Trade items have been
separated into distinct tables)Notes Refer
to the Best Practice Guidelines for Implementing
Tolerances for more information regarding data
accuracy guidelines and implementation of
tolerances. Soft paper products in flexible
packaging at the consumer and case level are
excluded from the above packaging types. Frozen
categories are excluded from the above packaging
types. The proposed Data Accuracy tolerances
are not intended to replace parameters within the
GTIN Allocation Rules, which identify when a new
GTIN must be assigned. The dimensions and
weight tolerances apply only to fixed measure
products.  Tolerances are not practical for
variable measure products (e.g., variable weight
products, etc.)
General EAN.UCC Specification Amendment6.8.1.5
(Effective Date August 31, 2006)
17
Tolerances for Non-Consumer Trade Items (e.g.,
Case Unit)
Outer Package Type Inner Package Type Description Examples Dimension Tolerance (/-)
Corrugated Case Cardboard or pressboard box Full enclosed corrugated case containing cartons or boxes Cereal, Games, Puzzles, Mac Cheese, Facial Tissue, Dog Treats, Does not include Card items Length, Width, Height, Gross Weight 4.0
Corrugated Case Metal Cans or Glass jars/bottles Full enclosed corrugated case containing cans or glass jars Vegetables, Fruit, Aerosol, Cat Dog Food, Steak Sauce, and Condiments Length, Width, Height, Gross Weight 4.0
Corrugated Case Rigid Plastic Containers Full enclosed corrugated case containing rigid plastic containers Shampoo, Laundry Detergent, Clam Shells, Baby Wipes, Salad Dressing, Water, Mayo, Ketchup, Beverages, Soups, Beans, Dog Treats, Dish Detergent, Cleaning Products Length, Width, Height, Gross Weight 4.0
Plastic Overwrap Metal Cans or Glass jars/bottles Tray or non-tray product with plastic overwrap containing cans, or glass jars Water, Salad Dressing, Mayo, Ketchup, Beverages, Soups, Beans, Dish Detergent, and Cleaning Products Length, Width, Height, Gross Weight 4.0
Plastic Overwrap Rigid Plastic Containers Tray or non-tray product with plastic overwrap containing rigid plastic containers Vegetables, Fruit, Aerosol, Cat Dog Food Length, Width, Height, Gross Weight 4.0
18
 
Tolerance for Consumer Trade Item (e.g., Shelf
Unit)
Package Type Description Examples Dimension Tolerance (/-)
Carton Full carton or cardboard box Cereal, Games, Puzzles, Mac Cheese, Facial Tissue, Dog Treats Depth, Width, Height 0.25 in (7mm)
Can or Glass Can or Glass container, completely rigid Vegetables, Fruit, Aerosol, Cat Dog Food, Steak Sauce, Condiments, Coffee Depth, Width, Height 0.25 in (7mm)
Plastic Container Rigid bottle or plastic container, no flexibility Water, Salad Dressing, Mayo, Ketchup, Beverages, Soups, Beans, Detergent, Clam Shells, Baby Wipes, Cleaning Products Depth, Width, Height 0.25 in (7mm)
19
Our Success Story!
20
Celebrating Our Success

• Global Tolerances Created for Key Packaging Types
• Case Level Dimensions Weights /- 4
• Consumer Unit Dimensions .25 in/7mm
• Raising Awareness
• GS1 Training DVD, Web Seminars, and
• Standards Clarification Exposure
• GMA FMI Training Communication
• Stuff like this!
• Together with the Data Quality Steering Committee
  we are closing in on the root causes.
• Good People Working Towards a Common Goal Can
  Accomplish Anything They Set Out to Do!

21
Examples of the Business Benefits!

• Improving the Bottom Line
• Logistical information is improving. In one case
  to the tune of 3.7M USD per year.
• Enhancing Processes
• Standards Education are instilling discipline
  in organization
• Trusting the data will eliminate redundant manual
  processes
• Tolerances will help Manufacturers work towards
  one version of the truth
• It all adds up to.Improving Customer Service

22
A picture tells 1000 words!
23
A picture tells 1000 words!
24
Questions