1 / 24

Data Accuracy Task Force Update

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@conair.com brad.papietro@wegmans.com.

vilmos
Télécharger la présentation

Data Accuracy Task Force Update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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@conair.combrad.papietro@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. GS1 US Begins Audit Of GDSN Data April 2005 2nd Wave of Wegmans Grocery Audits November, 2005 Total Accuracy Rate: 52% Wegmans conduct re-measure of strategic suppliers Grocery W/H Items February, 2005 Total Accuracy Rate: 36% Total Items: 1237 Wegmans Measures rest of Grocery W/H Items April-June, 2005 Total Accuracy Rate: 32% GDSN Forms Tolerance Team May 2005 GCI Forms Data Quality Steering Committee May 2005 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% • Weights:plus 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)

  18. Tolerance for Consumer Trade Item (e.g., Shelf Unit)

  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

More Related