Alain Jolicoeur Senior Director of Application Systems METRO Inc. - - PowerPoint PPT Presentation

Presented by:

Alain Jolicoeur Senior Director of Application Systems METRO Inc.

Presented by:

Metro Inc*

553 food stores 263 drugstores 65,000 employees in Ontario and Quebec

* From the 2007 Annual Report

Presented by:

Stores per banner

SuperC 58 Food Basics 116 A&P* 159 Drug Basics 78 Brunet Clini Plus 185 Metro 220 Metro Inc

* A&P, Dominion, The Barn Markets, Loeb, Ultra Food & Drug

Presented by:

Metro Inc major grocery DC’s

Montreal Ottawa Quebec City Toronto Metro Inc

Presented by:

ECCnet registry

• ECCnet registry represents a strategic tool for Metro
• To take advantage of the registry

– All grocery products must be available in the ECCnet registry – 100% data accuracy is mandatory – Product data available in a timely manner – Data loaded in the registry should follow the industry standards

Presented by:

What did the audit reveal

• Missing products in the registry and products that have not

been deleted within Metro’s master files

• Data integrity is not at 100%
• Static SAP data elements feed from ECCnet

– Improvement on Case GTINs data accuracy is required – Item GTINs data accuracy additional effort is required – Action plan must be established

• Need for additional analysis for Metro and their trading

partners on data discrepancies

Presented by:

New product listing process

ECCnet Registry ProLYNC Product extraction Merge & upload Excel file Metro ERP SAP Supplier Excel file Manual entry

Approx 1000 new product/month

Presented by:

New product rollout process

Metro ERP SAP Planogram Retail systems Business Intelligence Warehouses management CP/Banners activiies

A&P

ECCnet Registry

Presented by:

Metro ERP SAP Manual entry

Case measurement Case weigh in Etc

Toronto DC Retail

Impact of inaccurate data

Presented by:

Key Learnings

• The importance of one source of truth
• Accurate data facilitates flow through information between

applications

• Information must be available in the ECCnet registry in a timely

manner

• Need to change perception of accuracy level of data to improve

confidence and utilization

• Garbage in garbage out out out…
• Metro’s trading partners should make sure their single point of

contact for ECCnet registry is up‐to‐date

• Analysis of root cause issues for bad data is required by Metro

Presented by:

ECCnet registry Added value

• Improve listing process (simplify and speed‐up)
• Reduction of manual data entry (error reduction)
• Eccnet registry represent the foundation of product data

integrity

• Information format in the registry is based on industry

standards

Presented by:

Next steps

• Action plan based on the analysis of the industry data audit.

Will be shared with trading partners and will address root cause of bad data.

• Introduction of ECCnet registry for our subsidiaries
• Cross functional strategy and roadmap for Metro’s next

generation of ECCnet: Item Centre

• Working with our vendors to resolve issues and implement

best business practices

• Active participation in the ECCnet registry evolution