EDI Metrics

1
EDI Metrics Mid Atlantic Electronic Commerce
Users Group December 6, 2006 Presentation will
be made available through our website http//www.
neecom.org/index.php?pagephilly_group Presented
By Mary Lopez EDI Coordinator
2
ICG Commerce at a Glance

• We do all of procurement and procurement is all
  we do
• Founded in 1992 as Purchasing Group Inc. renamed
  as ICG Commerce in November 1999
• Privately held company, headquartered in King of
  Prussia, PA
• Offices in the U.S., U.K., and Germany
• Over 80 active customers
• 125 sourcing category experts worldwide
• Sourcing expertise in more than 300 categories
• Actively managing over 5B in spend across a wide
  range of categories
• Most experienced procurement outsourcing
  provider, with dozens of long-term outsourcing
  customers

3
Our B2B Exchange
ICG COMMERCE Transaction HUB
4
Our B2B Exchange
ICG COMMERCE Transaction HUB
Customer
5
Our B2B Exchange
EDI
ICG COMMERCE Transaction HUB
XML
Customer
Flat File
6
Our B2B Exchange
EDI
ICG COMMERCE Transaction HUB
XML
Supplier
Customer
Flat File
7
Our B2B Exchange
EDI
EDI
XML
ICG COMMERCE Transaction HUB
Portal
XML
Supplier
Customer
CDD
Flat File
Fax
8
ICG Commerce transaction model
Transaction Model
Customer
ICGC
Supplier
Order Processing User places order through
RealPurchase/ERP System ICG Commerce facilitates
transmission of the order to the supplier
1
2
1
2
RealPurchase or client ERP System
3
4
Order Management Supplier provides
acknowledgement ICGC provides order status to
user Supplier ships product
3
4
5
5
Invoicing and Payment Supplier sends
invoice Compare invoice to PO for
reporting Invoice sent to customer Payment Direct
to Supplier
6
7
6
8
7
8
Customer Financials
9
9
9
Under The Covers
ICG COMMERCE Transaction HUB XML
10
Under The Covers
ICG COMMERCE Transaction HUB XML
11
Under The Covers
ICG COMMERCE Transaction HUB XML
12
Under The Covers
ICG COMMERCE Transaction HUB XML
13
Under The Covers
ICG COMMERCE Transaction HUB XML
14
Under The Covers
ICG COMMERCE Transaction HUB XML
15
Under The Covers
ICG COMMERCE Transaction HUB XML
Where is my order?
16
Under The Covers
Why do you need more money in the budget?
ICG COMMERCE Transaction HUB XML
Where is my order?
17
Under The Covers
Why do you need more money in the budget?
ICG COMMERCE Transaction HUB XML
Where is my order?
What is our cost per transaction?
18
Under The Covers
Why do you need more money in the budget?
How long does it take for my order to get there?
ICG COMMERCE Transaction HUB XML
Where is my order?
What is our cost per transaction?
19
Under The Covers
Why do you need more money in the budget?
How long does it take for my order to get there?
ICG COMMERCE Transaction HUB XML
Where is my order?
How many new partners did you add this year?
What is our cost per transaction?
20
Under The Covers
Why do you need more money in the budget?
How long does it take for my order to get there?
ICG COMMERCE Transaction HUB XML
Where is my order?
How many new partners did you add this year?
What, exactly, are you doing?
What is our cost per transaction?
21
Under The Covers
Why do you need more money in the budget?
What, exactly, are you doing?
How long does it take for my order to get there?
ICG COMMERCE Transaction HUB XML
Where is my order?
How many new partners did you add this year?
What, exactly, are you doing?
What is our cost per transaction?
22
Under The Covers
Why do you need more money in the budget?
What, exactly, are you doing?
How long does it take for my order to get there?
ICG COMMERCE Transaction HUB XML
Where is my order?
How many new partners did you add this year?
What, exactly, are you doing?
What, exactly, are you doing?
What is our cost per transaction?
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
Collect
27
Collect

• Who
• Partners
• suppliers
• customers
• What
• Document type
• Delivery status (failed or rejected items)
• When
• Timestamp
• Sent
• Received
• Acknowledged

• Where
• Connectivity Method
• Why
• Document Special Circumstances
• Van Outages
• Company Holidays
• Personnel changes key to eCommerce performance
• Technology-based changes, upgrades, downtime for
  partners, vendors, and yourself
• Business shifts
• Large new account
• New business model

28
Collect
29
Measure
30
Measure

• Current State
• FAs returned
• FAs returned in time expected
• All inbound data received
• Timeliness of document processing/delivery
• Turnaround time for response documents other than
  FA

31
Measure

• History
• Examine what, if any, historical data is
  available for collection
• If accessible, use to build comparisons
• This month vs. Last month
• Quarterly Totals
• Annual Totals
• This year vs. Last year
• If not accessible, start archiving your data
  collections now to build out for future reporting

32
Measure

• Future
• Establish new collection and archiving procedures
  to facilitate enhancements to your metrics in the
  future

33
Chart
34
Chart

• Tools
• Access
• Excel
• Existing reports

35
Chart

• What to Report?
• Counts / Percentages / Comparisons
• Number of Partners
• Number of Transactions
• Types of Transactions
• Exceptions
• Speed
• Rate of Return
• Service Level Agreements

36
Chart

• Verification
• Build charts for yourself and VERIFY the results
• Key to credibility of your metrics
• Design
• Look and feel
• Color Palette
• Logo
• Font
• Template

37
Presenting your metrics
38
Examples
39
Examples
40
Examples
41
Examples
42
Examples
43
Sell It
44
Sell It
Bulletin Board
45
Sell It
Bulletin Board
Company Newsletter
46
Sell It
Bulletin Board
Company Newsletter
Internal Meetings
47
Sell It
Bulletin Board
Company Newsletter
Annual Performance Review
Internal Meetings
48
Knowledge is Power

• Ability to quickly answer questions
• Know the pulse of your production environment
• Prevent issues
• Contain issues rapidly
• Optimize your resources
• Increase visibility for your program and yourself
  within your company
• Plan for the future with greater accuracy
• Identify and celebrate your successes

49
(No Transcript)
50
Presentation will be made available through our
website http//www.neecom.org/index.php?pagephil
ly_group