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 Metro 220 Brunet SuperC Clini Plus 58 185 Metro Inc Food Drug Basics Basics 116 78 A&P* 159 * A&P, Dominion, The Barn Markets, Loeb, Ultra Food & Drug Presented by:
Metro Inc major grocery DC’s Toronto Quebec Montreal Metro Inc City Ottawa 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 Manual entry Supplier Product Excel file extraction Metro ERP Merge & Excel file SAP upload Approx 1000 new product/month Presented by:
New product rollout process A&P CP/Banners activiies Warehouses management ECCnet Metro ERP Registry SAP Business Intelligence Retail Planogram systems Presented by:
Impact of inaccurate data Toronto DC Metro ERP Manual SAP entry Case measurement Case weigh in Etc Retail 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 Presented by:
Recommend
More recommend