6/10/2013
64: How To Do Business With
Wegmans
Kathy Welch, Wegmans Food Markets
Agenda
Who We Are
Why Data Synchronization?
Master Data Accuracy and Completeness
Best Practices
Trading Partner Score Carding
EDI
Our Expectations
2
© GS1 US 2012
1
6/10/2013
$6.5B Retailer Founded in 1916
Headquartered In Rochester, NY
81 Stores With 44,000+ Employees
‘Fortune 100 Best Companies To Work For’
3
© GS1 US 2012
Self-Distributing Chain with DC’s in Rochester, NY, and Hazleton & Pottsville, PA
4
© GS1 US 2012
2
6/10/2013
5
© GS1 US 2012
Information Driven Supply Network
Leveraging Information is Mission Critical
6
© GS1 US 2012
3
6/10/2013
Why Data Sync?
 Quality Data Sync allows us to connect our business information.
 Strategic
St t i sharing
h i off data
d t with
ith partners
t
will
ill enable
bl b
business
i
growth
th
– We all speak the same language
– Our people collectively agree on goals & measures
– The information we share is timely, useful and accurate
 Benefits of Data Sync are foundational – improved standards,
accuracy, completeness
 High quality, synchronized information is foundational to mission
critical processes and cost saving initiatives, eliminating non-value
added work
 Increasing time to collaborate on value-added processes
7
© GS1 US 2012
What We Have Learned
 Consumer gains in service level and consistent low prices
 Optimization of warehouse space and truck loads
 Opportunity to expand the boundaries between supply chain
partners.
 Fewer invoice disputes
 Speed to shelf with new items
 Reduced labor costs to resolve shelf tag and scan errors.
 Early case studies found benefits of data sync for both retailers
and suppliers equaling $1M for every $1 Billion in sales (US$)
8
© GS1 US 2012
4
6/10/2013
So What if the Data isn’t Accurate?
22ft long bag of rice
That’s
a big
bag of
rice!!
7ft tall bottle
of shampoo
53lb candy bar
It’s easy to spot a 7ft bottle of shampoo, but
What Don’t We Know???
9
Using the Data …
© GS1 US 2012
Transportation
Planning
Shelf Planning
Warehouse
Operations
Wegmans Master
Data
Wegmans.com
Consumers
Invoicing
Procurement
GDSN is the most efficient way to
get complete and accurate data!
10
© GS1 US 2012
5
6/10/2013
Complete & Accurate Data
Best Practices
 Principled Adherence to GS1 Standards in all areas of internal item
development process
 Strict Accountability and Validation Mechanisms for all data owners within your
organization
 Single Master Data Management accountable for gathering item attributes
from data owners – ensures validation – “one source of the truth”
 Perform physical audits on finished goods to ensure accuracy is maintained,
and publish updates throughout the life of the product
product.
 Internal resources should be trained or commit to using a certified third party
 Provide complete and accurate item data on all levels of the hierarchy
 GDSN publications to Wegmans require all mandatory attributes plus Pallet
Ti and Tier, EANUCC Codes, and Coupon Family Code.
11
© GS1 US 2012
Complete & Accurate Data
Best Practices
 Synchronizing quality item data involves good business practices and a
company wide understanding of industry standards (people, processes and
technology)
 R&D,
R&D Package Engineering
Engineering, Data Sync
Sync, IT and Sales
 Establish a protocol for your data that follows the GS1 Package
Measurement Rules
 Align your business practices with the GTIN Allocation Rules, especially
Net Content and Case Pack changes.
 At Wegmans, New Item Fact Sheets should be complete and accurate –
GTINs p
published p
prior to the sales call,, and presented
p
at New Item Intro
 Collaborate with your sales team on GTIN readiness/item intro
 Provide the resources for your sales team to know if new items have been
successfully published.
12
© GS1 US 2012
6
6/10/2013
Data Sync Contacts
[email protected]
((Master Data, Manager)
g )
[email protected]
(Master Data, Specialist)
[email protected]
(Master Data, Specialist)
[email protected]
(EDI Specialist)
13
14
© GS1 US 2012
© GS1 US 2012
7
6/10/2013
Wegmans’ Data Accuracy Initiative
Utilizing a third-party auditing team, we perform physical audits of our
suppliers’ products in our inventory to determine the accuracy of our
shared supply chain data (primarily item dimensions, case cube and
weight, Net Content and Case Pack).
Apply the GS1 Global Standards in both package measurement rules
and tolerances in score carding our strategic partners.
Provide reporting and education for our suppliers toward the goal of
improved processes and technology that contribute to data quality.
Data Accuracy is a strategic trading partner KPI, as well as an internal
metric.
15
© GS1 US 2012
Accuracy Audit Details Report
All Audited Items Details Report
Grocery Warehouse Audit
KRAFT FOODS
43000004296
Retail UPC:
Item #: 360673
Highest Level GTIN:
Item
Net
Content
UO M
Wegmans
8
OZ
T otal
Retail
U it
12
Audited
8
OZ
12
43000004210
Retail UPC:
H eight
Width
Depth
P ack
T ype
P ack
T ype
H eight
Width
Depth
2.925
11.325
13.225
0
0
2.7
4.25
2.75
0
8.26
2.7
11.3
13.1
Def ault Case
Def ault InnerPack
2.68
4.24
2.75
Def ault Unit
Highest Level GTIN:
UO M
9.2
OZ
T otal
Retail
U it
12
Audited
9.2
OZ
12
43000004289
20043000004214
UO M
9.6
OZ
T otal
Retail
Units
12
Audited
9.6
OZ
12
P ack
T ype
Last Audit Date: 11/27/2009
GFIC VANILLA BEAN LATTE
Inner P ack
Unit
H eight
Width
Depth
P ack
T ype
P ack
T ype
H eight
Width
Depth
2.925
11.325
13.225
0
0
2.7
4.25
2.75
0
9
2.72
11
12.69
Def ault Case
Def ault InnerPack
2.73
4.25
2.74
Def ault Unit
Highest Level GTIN:
H eight
20043000004283
Case
Net
Content
Depth
9.15
Item #: 360675
Wegmans
Width
Weight
Item
16
H eight
Case
Net
Content
Unit
8.325
Item #: 360674
Wegmans
Last Audit Date: 11/27/2009
GFIC MOCHA LATTE
Inner P ack
Weight
Item
Retail UPC:
20043000004290
Case
Width
Depth
P ack
T ype
Last Audit Date: 11/27/2009
GFIC VANILLA CAR SW LATTE
Inner P ack
Unit
Weight
H eight
Width
Depth
P ack
T ype
P ack
T ype
H eight
Width
Depth
9.329
2.688
11
12.75
0
0
2.7
4.25
2.75
0
9.36
2.7
11.2
13
Def ault Case
Def ault InnerPack
2.7
4.23
2.74
Def ault Unit
H eight
Width
Depth
P ack
T ype
© GS1 US 2012
8
6/10/2013
17
© GS1 US 2012
EDI at Wegmans
 Mandatory for any Grocery, Dairy, Frozen, GM, HBC vendor
 Specific EDI transactions based on replenishment type:
 DSD
 Warehouse
 VMI
 Quick Response
 Contact merchandising representative to start process
 Testing/ compliance done on free on line tool through GXS
 After testing is complete, verify that you have good data!
18
© GS1 US 2012
9
6/10/2013
Our Expectations
 Complete and accurate New Item Fact Sheets
 Engage
g g in Data Sync
y relationship
p with Wegmans,
g
, and p
provide
accurate, timely and continuous data via GDSN
 Understand and publish item dimensions and weights using the
GS1 Package Measurement Rules as your guide.
 Ensure EDI Compliance
 Understand the performance of your items and their contribution
to the category
 Manage inventory in compliance with Wegmans’
Wegmans supply chain
initiatives
 Product ready and available for on time delivery
 Manage any changes to Net Content and Case Pack Changes in
accordance with GTIN Allocation Rules.
19
© GS1 US 2012
Wegmans.com/For Our Suppliers
for our suppliers
20
© GS1 US 2012
10
6/10/2013
Wegmans.com/For Our Suppliers
21
© GS1 US 2012
Wegmans’ Contacts:
[email protected]
(Master Data
Data, Manager)
[email protected] – HBC & General Merchandise
(Master Data, Specialist)
[email protected] – Grocery, Dairy, Frozen
(Master Data, Specialist)
[email protected] – EDI Specific
(EDI Specialist)
22
© GS1 US 2012
11
6/10/2013
Thank You!
Questions?
23
© GS1 US 2012
12