Australia
Data Management ‌.or, how to manage that big hairy beast called Master Data
Session agenda Australia
•
What is Data Management
•
How good is your Data Management and Master Data?
•
The impact of poor data in the supply chain
•
The technical solution
•
Success Criteria for good Data Management
•
Final Thoughts
•
Close / Questions
26 © 2008 GS1
What is Data Management? Australia
• Definitions of Data management on the Web: • •
Data management comprises all the disciplines related to managing data as a valuable resource. en.wikipedia.org/wiki/Data_management Controlling, protecting, and facilitating access to data in order to provide information consumers with timely access to the data they need. The functions provided by a database management system. www.information-management.com/glossary/d.html
• Definitions of product data management on the Web: •
Product data management (PDM) is the business function often within product lifecycle management that is responsible for the creation, management and publication of product data. en.wikipedia.org/wiki/Product_data_management
27 © 2008 GS1
Australia
How good is your Data Management and Master Data?
• Have you ever thought about how poor master management and data can impact your business? • Poor Master Data has a direct link with the following: • • • • • • • • •
Excessive amounts of claims Payments held up Constant queries on customer orders Product returns Lost sales Lack of stock control Order reconciliation taking too long Sales staff spending too much time doing paperwork Master data control is spread around the business 28
© 2008 GS1
Australia
•
The impact of poor data in the UK Grocery Sector – UK Study findings in the Grocery sector
Data Crunch report – Prepared by GS1 UK – Oct 2009 29
© 2008 GS1
UK findings (cont) Australia
•
Data Crunch report – Prepared by GS1 UK – Oct 2009 30
© 2008 GS1
UK findings (cont) Australia
•
Data Crunch report – Prepared by GS1 UK – Oct 2009
31 © 2008 GS1
Australia
What is Poor Data costing the UK Grocery Sector?
•Excerpt from the UK Data Crunch Report Executive Summary: • We calculate that over the next five years UK retailers and suppliers will experience over £700 million profit erosion and £300 million in lost sales. These are conservative estimates based on the combination of process inefficiencies, duplications and workarounds across the retailer and supplier’s supply chains, together with administrative shrinkage and shelf stockouts that inaccurate data causes. 32 © 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level
Tax: GST (yes/no), Rate (Aus or NZ) Physical: Product Dimensions, Weights (Net and Gross) Dates: Effective, Start Availability, End Availability, First Order, etc
Marketing: Brand, Subbrand, Variant, Description –long, short
Pricing: (trading partner specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
33 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level
Tax: GST (yes/no), Rate (Aus or NZ) Physical: Product Dimensions, Weights (Net and Gross) Dates: Effective, Start Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
34 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Tax: GST (yes/no), Rate (Aus or NZ) Physical: Product Dimensions, Weights (Net and Gross) Dates: Effective, Start Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
35 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Transport Tax: GST (yes/no), Rate (Aus or NZ)
Physical: Product Dimensions, Weights (Net and Gross) Dates: Effective, Start Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
36 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Transport Tax: GST (yes/no), Rate (Aus or NZ)
Physical: Product Dimensions, Weights (Net and Gross)
Planning, Dates: Effective, Start Forecasting Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
37 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Transport Tax: GST (yes/no), Rate (Aus or NZ)
Physical: Product Dimensions, Weights (Net and Gross)
Planning, Dates: Effective, Start Forecasting Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner Costing specific) National, State, Direct to Store, DC etc, Effective Date, End Date Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
38 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Transport Tax: GST (yes/no), Rate (Aus or NZ)
Physical: Product Dimensions, Weights (Net and Gross)
Planning, Dates: Effective, Start Forecasting Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner Costing specific) National, State, Direct to Store, DC etc, Effective Date, End Date
Purchasing Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
39 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code
All depts
Transport
Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Tax: GST (yes/no), Rate (Aus or NZ) Physical: Product Dimensions, Weights (Net and Gross)
Planning, Dates: Effective, Start Forecasting Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner Costing specific) National, State, Direct to Store, DC etc, Effective Date, End Date
Purchasing Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
40 Š 2008 GS1
Who uses your data? Australia
Environmental & Dangerous Goods Warehouse,
GTIN, GLN, GPC code
All depts
Transport
Functional: Orderable, Despatch or Invoice, Hierarchy Level Purchasing
Tax: GST (yes/no), Rate (Aus or NZ) Physical: Product Dimensions, Warehouse Weights (Net and Gross)
Planning, Dates: Effective, Start Forecasting Availability, End Availability, First Order, etc
Marketing: Brand, SubMarketing brand, Variant, Description –long, short
Pricing: (trading partner Costing specific) National, State, Direct to Store, DC etc, Effective Date, End Date
Purchasing Logistics: Order Multiples, Min Order qty, Pallet Details, etc
Warranty: Description, Duration, Type (km or month)
41 Š 2008 GS1
Australia
Supplier
Impact of Poor data and processes within the Supply Chain
Buyer
42 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
Fax/ Mail/File transfer
Supplier
1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Buyer
Incorrect Item #s Prices Desc Qty
43 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
3. Purchase Order Fax/ Mail/File transfer
Supplier
1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Buyer
Incorrect Item #s Prices Desc Qty
44 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer
Supplier
1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Buyer
Incorrect Item #s Prices Desc Qty
45 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer
Supplier
1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Buyer
Incorrect Item #s Prices Desc Qty
46 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice
47 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice 7. Goods Delivered + Invoice
48 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice 7. Goods Delivered + Invoice 8. Query Delivery Errors / Claim for credit
49 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice 7. Goods Delivered + Invoice 8. Query Delivery Errors / Claim for credit 9. Return Incorrect Goods
50 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain
5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice 7. Goods Delivered + Invoice 8. Query Delivery Errors / Claim for credit 9. Return Incorrect Goods 10. Adjusted Delivery 51 Š 2008 GS1
Australia
Impact of Poor data and processes within the Supply Chain 11. Delayed Settlement 5. Adjusted Purchase Order 4. Query Order Errors 3. Purchase Order Fax/ Mail/File transfer 1. Product Info sent
2. Product Info entered
Errors in transposition
Errors in Translation Errors in Delivery / Transmission
Supplier
Buyer
Incorrect Item #s Prices Desc Qty
6. Despatch Advice 7. Goods Delivered + Invoice 8. Query Delivery Errors / Claim for credit 9. Return Incorrect Goods 10. Adjusted Delivery 52 Š 2008 GS1
Impact on Supply Chain with improved processes and data Australia
Supplier
53 Š 2008 GS1
Impact on Supply Chain with improved processes and data Australia
1. Populates
Vendor GS1net Catalogue
Supplier
54 Š 2008 GS1
Impact on Supply Chain with improved processes and data Australia
1. Populates
Vendor GS1net Catalogue
2. Auto Updates
Supplier Buyer
55 Š 2008 GS1
Impact on Supply Chain with improved processes and data Australia
3. Purchase Order – Accurate & error free
1. Populates
Vendor GS1net Catalogue
2. Auto Updates
Supplier Buyer
56 Š 2008 GS1
Impact on Supply Chain with improved processes and data Australia
3. Purchase Order – Accurate & error free
1. Populates
Vendor GS1net Catalogue
2. Auto Updates
Supplier Buyer
4. Dispatch Advice / ASN – SSCC link to PO & GTINs
57 © 2008 GS1
Impact on Supply Chain with improved processes and data Australia
3. Purchase Order – Accurate & error free
1. Populates
Vendor GS1net Catalogue
2. Auto Updates
Supplier Buyer
4. Dispatch Advice / ASN – SSCC link to PO & GTINs
5. Physical Goods Flow – Marked with SSCC 58 © 2008 GS1
Impact on Supply Chain with improved processes and data Australia
6. Remittance Advice & Settlement
3. Purchase Order – Accurate & error free
1. Populates
Vendor GS1net Catalogue
2. Auto Updates
Supplier Buyer
4. Dispatch Advice / ASN – SSCC link to PO & GTINs
5. Physical Goods Flow – Marked with SSCC 59 © 2008 GS1
Supply Chains today Australia
If data and processes are so bad, how is it that we do get products ordered, delivered and then paid? Well, we throw people at the problem. We put them in accounts payable, receivable, customer service. We create new roles in Sales, Marketing, IT. We reward people for constant fire-fighting, and pride ourselves on our ability to adapt to change and our flexibility. Not only that, we employ people to update and manage your data as well.
60 Š 2008 GS1
The technical solution – GS1net Australia
• To assist organisations in sharing their product information with their trading partners, GS1 developed a solution called GS1net based on a set of rules and built on the GS1 Standards • GS1net is the data synchronisation solution for Australia and New Zealand • GS1net lets you enter, validate, store and maintain all your product, pricing and other related trade information in a single location • You can then easily share this global standards-based information with the trading partners you work with, across all industry sectors, and even globally.
61 © 2008 GS1
What is Data Synchronisation? Australia
•The continuous and automated exchange of standardised item master data within and between organisations
62 Š 2008 GS1
GS1net - Overview Australia
Data Uploads
Vendor B
Data Uploads
Vendor C
Data Uploads
Vendor D
Data Uploads
GS1net Data Validation
Vendor A
Global Registry
GS1net Data Pool
Auto Updates
Trading Partner A
Auto Updates
Trading Partner B
Auto Updates
Trading Partner C
GS1net local Registry Search & Download
Search & Download
63 Š 2008 GS1
GS1net Status as at 15th Aug 2010 Australia
• 1441 companies currently participating – 56 Buyers – 19 Search & Download – 1366 Suppliers / Manufacturers
• 340K+ Supplier Maintained GTINs • 1106 Suppliers have loaded data in GS1net • ~850 Suppliers are GS1net Ready ™ • ~500 Suppliers are GS1net Live ™
65 © 2008 GS1
GS1net in the Community Australia
• Grocery • • • •
Coles – 477 Suppliers Metcash – 179 Suppliers Woolworths – beginning early 2011 Foodstuffs (NZ) - 45
• Hardware • • • •
Mitre 10 NZ – 42 Suppliers Mitre 10 – Building M2M interface John Danks & Son – 2 suppliers ITM (NZ) – 2
• Health – 92 Suppliers • Office Products – Pilot completed • Consumer Electronics – Pilot planned early 2011 70 © 2008 GS1
Australia
The key to successful Data Synchronisation?
• Identify and appoint a Champion in your organisation to drive your data synchronisation project today and into the future • Clearly defined your business processes for managing your master data • Have the disciplines in place to follow the defined business process • Understanding the uses and impacts that data can have on your trading relationships
71 © 2008 GS1
Where to from here? Australia
• • • • •
•
Gain some internal support and appoint a champion Review your existing data management processes Get involved, learn about what you’re getting your business involved in Talk to others who have implemented data synchronisation Work out how much having quality data synchronised with your trading partners is worth to you Implement a Data Quality programme, not a Data Sync project
72 © 2008 GS1
Final Thoughts Australia
GS1net has gained the support of the Hardware GS1 Action Group, however don’t just focus on the tool, you need to review how you manage your data to ensure you maintain a sustainable process 73 Š 2008 GS1
Final Thoughts Australia
Data Management and Synchronisation challenges current paradigms regarding data ownership 74 Š 2008 GS1
And Finally…………. Australia
…..get that hairy beast to work for you!
75 © 2008 GS1
Questions?
Contact Details John Szabo Industry Manager GS1 Australia Unit 100/45 Gilby Road Mt Waverley VIC 3149 T + 61 3 9550 3483 M 0419 338 842 W www.gs1au.org john.szabo@gs1au.org