NEMA Board of Governors

Document Sample
NEMA Board of Governors Powered By Docstoc
					NEMA Board of Governors



                   Report
       November 13, 2004




               1
       IDEA Products & Services
        Industry Data Warehouse
IDW         Central Database to synchronize Product, Pricing
            and Packaging data between trading partners
            Attributed data being developed to support
            electronic catalogs, spec sheets
IDX2    Industry Data Exchange 2
            Private Network for the exchange of business
            documents, primarily EDI but XML, Flat File, other
            formats can be passed between trading partners
IRD     Industry Retail Database
            Certified “data pool” to provide data to the Retail
            channel via UCCnet (US) & ECCnet (CDN)
        Data Audit & Certification
DAC         Data quality review and “grading” based on IDW
            standards/distributor reqmts … data quality is key


                          2
                 Overview – 2004 To Date
   2004 remains positive for IDEA
       IDX2 - highly successful product
        – Over 220 customers, traffic volume up 11% per month
       IDW - 145 Mfr’s provide 80% of the 1.7 million records
          78 of 145 are NEMA members
       IRD – 22 NEMA manufacturers participating
          Profitable business model
       DAC – 109 of 145 manufacturers participating
   Financially… strongest position in 3 years
       2004 – will be solidly profitable
   IDW – Primary focus
       IDW remains highest priority
       IDW Improvement Plan
        – Data Sourcing – get all Mfr’s to provide data
        – Data Quality – 100% participation in DAC by close of 2004
        – Design and implement IDW2 by Jan 2005
                                       3
                                  IDX2
   Market analysis underway
       Channel Marketing Group                                                IDX2 MONTHLY TRAFFIC 2003 & 2004


    Assess market/viability of doubling                             4000000
                                                                    3500000




                                                  Kilo Characters
                                                                    3000000
                                                                    2500000                                      Sterling (Offnet)

    business                                                        2000000
                                                                    1500000
                                                                                                                 Onnet
                                                                                                                 Total
                                                                    1000000


      – Analysis indicates strong potential
                                                                     500000
                                                                          0




                                                                                 ry




                                                                                 ne
                                                                         Ja 3

                                                                        Fe ry



                                                                                 ch




                                                                                                     Au y
                                                                                  ril




                                                                                                            r
                                                                                                    pt st
                                                                                ay




                                                                                                         be
                                                                                                          l
                                                                                0




                                                                                                        Ju
                                                                             Ap
                                                                              ua
                                                                               a




                                                                                                       gu
                                                                             Ju
                                                                              ar
                                                                              c-




                                                                             M
                                                                            nu




                                                                                                      em
                                                                           M
                                                                           br
                                                                          De
    Take Advantage of IDX2 strengths




                                                                                                  Se
      – Features and functions
      – Reliability only 50 hours total outage in 3 years
      – Rates and Charges – 30-90% lower then other services
      – Over 60 interconnects/paths with other services
 Working with service providers to improve biz models
       Improve service to meet new user requirements
       Lower IDEA costs and customer rates
       Ensure IDX2 continues to be most reliable and cost effective
       service
                                     4
                IDW – Primary Focus
   IDW Improvement Plan
      Data Sourcing
       – End dependence on i2 Trade Service data for ~250
         manufacturers
      Improve Manufacturer Data Quality
       – Complete Certification for In-Process manufacturers (45)
       – Get balance of manufacturers (39) to participate in DAC
      Move IDW to next level = IDW2
       – More functionality and flexibility for users
       – Will result in successful and profitable venture
   NAED and NEMA matching Funds
      Support IDW Improvement Plan
       – Cover investment in s/w & h/w
       – Cover new IDEA staff and support for 1 year
                                 5
         NEMA Matching NAED Fund Program
NAED Contribution/Pledge
                  $250,000
                             250,000
NEMA Matching Funds
Company                      200,000
Cooper Industries                                      NAED
Alcan Cable                  150,000
Eaton Electric                                         NEMA Member
Ferraz Shawmut                                         Co.
                             100,000
GE C&I                                                 Received
Hoffman Enclosures
Hubbell                       50,000
Legrand NA
Lutron                            0
OSRAM Sylvania                                NEMA NAED Funds
Panduit
Robroy
Rockwell                     1.   NEMA invoice Manufacturers
Schneider Electric
Southwire                    2.   NAED and NEMA provide funds to IDEA as
Thomas & Betts
                                  requirements dictate
Tyco Electrical
Total $250,000                     a. Implementation of IDW2 s/w and h/w
Thanks!                            b. Database upgrade and certification
                                   c. Additional IDEA Staff cost 1 year
IDEA BOD Companies


                                          6
Increase Manufacturer IDW Participation
                              Need balance of data direct from Mfr’s, i2 supplies today

      US Mfr Direct
        1,164,198                   IDW Manufacturer DATA SOURCING Plan

                      i2       1.    Target Manufacturers in i2 TSC first (250).
                   336,886
                               2.    Target Distributor vendors not in IDW.
                               3.    Send letter to each manufacturer.
CDN Direct                     4.    Follow up 1 on 1 contact.
  185,061
                               5.    Get NAED and IDEA distributors to
  305 UCC = 1,145,742 SKUs           contact their suppliers.
  (Mfr Direct)

  296 UCC = 336,886 SKUs
  (i2 TSC Supplied)
                               All NEMA electrical product manufacturers provide
                                                     data to IDW
 120 CND UCC = 185,061 SKUs
 (CND Mfr Direct)

 UCC = Uniform Code Council



                                    7
      IMPROVING DATA QUALITY
   Data must be IN SYNC between manufacturers
    and distributors partner for:
      Master Record
      Into Stock Pricing
      SPA Pricing
   Issues with Manufacturer Product Data
      Completeness of data
      Accuracy of data                                  Other/UOM

      Timeliness of data                 Invalid
                                                           17%                  Incorrect
                                                                                 Pricing
                                       Description                                 37%

   Most Common problems                   11%


                                            Incorrect
       Poor descriptions                       UPC
                                               10%
                                                                    Incorrect
                                                                    Catalog #

       Dealer 3 equal to distributor cost                              25%



       Missing categories
       Timeliness of data

                                8
      IMPROVING DATA QUALITY
   Results of Data Out of SYNC
      Lost Revenue
      Wrong Discounts to Customers
      Wrong PO prices
      Invoice Deductions
      Missed SPA Items
      Wrong SPA Claims
   Solution
      Manufacturers:
       –   Data Quality must become higher priority
       –   Must include sales/marketing input
       –   Get feedback from data user
       –   Must obtain Data Audit Certification


                                  9
             IMPROVING DATA QUALITY
   Data Audit Certification Program Initiated Nov 2003
       Objective – get all direct IDW manufacturers to complete audit.
       Rates 23 data fields/values; provides report to manufacturer.
       Facilitates data synchronization between trading partners



      100%
      90%
      80%
      70%
                                                                                          Oct
      60%                                     Not Participating
                                                                    Total Direct Brands         146
                                              In DAC Process
      50%                                                           Certified Data               64
                                              Certified Data
      40%                                     Total Direct Brands
                                                                    In DAC Process               45
      30%                                                           Not Participating            37
      20%
      10%
       0%
             June   July   Aug   Sept   Oct




                                                    10
             NEMA BOG Company IDW & DAC Status
Company/Division                    IDEASubscriber   Data in IDW   Source             DAC     Remarks
ABB Inc.                            yes              no            none               no     sells thru some wholesale distibutors
Acuity Lighting Group               yes              yes           direct             yes    In DAC process; not all Acuity brands in IDW
Advance Transformer Company         yes              yes           direct             yes    Certified
Bedford Materials Co., Inc.         no               no            none               no
Connector Manufacturing Company     no               no            none               no
Cooper Industries, Inc.             yes              yes           direct             yes    All Certified Except Crouse Hinds.      Tools, Power Tools not in IDW
Eaton Corporation                   yes              yes           direct             yes    In DAC process
Emerson                             no               yes           i2 Trade Service   no     data in market via i2 TSC
GE Consumer & Industrial            yes              yes           direct             yes    In DAC process
General Cable                       yes              yes           direct             yes    Certified
Genlyte Thomas Group LLC            yes              yes           direct             yes*   *CapriOmega and Daybrite Certified       others in process
Hoffman Enclosures Inc.             yes              yes           direct             yes*    In DAC Process
Hubbell Incorporated                yes              yes           direct             yes    Certified
Hypertherm Inc.                     no               no            none               no
ILSCO Corporation                   yes              yes           direct             yes    Certified
Legrand North America               yes              yes           direct             yes    Certified
Leviton Manufacturing Co., Inc.     yes              yes           direct             yes    Certified
Lincoln Electric                    no               no            none               no     sells thru some wholesale distibutors
Lutron Electronics Company, Inc.    yes              yes           direct             yes    Certified
Nexans Canada Inc.                  no               no            unknown            no     sells thru some wholesale distibutors
OSRAM SYLVANIA                      yes              yes           direct             yes    Certified
Phelps Dodge Corporation            no               no            none               no     sells thru some wholesale distibutors
Radix Wire Company                  no               no            unknown            no     sells thru some wholesale distibutors
Rayovac Corporation                 no               yes           i2 Trade Service   no     data in market via i2 TSC
Regal-Beloit Corporation            no               yes           i2 Trade Service   no     data in market via i2 TSC
Rockwell Automation                 yes              yes           direct             yes    In DAC Process
S & C Electric Company              no               no            none               no     sells thru some wholesale distibutors
Siemens Energy & Automation, Inc.   yes              yes           direct             yes    In DAC Process
Southwire Company                   yes              yes           direct             yes    Certified
Square D Company/Schneider Elec.    yes              yes           direct             yes    Certified

Bold - IDEA customer
                                                                           11
                    IDW to IDW2 Program
   IDW2
       Full featured web interface
       Ease-of-use
       Mapping and transformation
       Push or Pull data option
       Serve all sectors
        – OEM, Reps, Distributors, Suppliers, Retail
       Core, Extended and Enriched Attributes
        – Catalog, Images, Tech Data
       Reporting and summaries
                                                                                                                       Customers
   Schedule
                                                                    Manufacturer            Messages
       Design and Develop                                             Profiles
                                                                              1                        4


        – Oct-Dec 04
        – Dec 04 - Jan 05 Test                                  Data       Data
                                                                                       Data Import
                                                                                                           End User
                                                                                                            Profiles
                                            D a t a In p u t
                                                                                        Tracking                       2
        – Jan–Mar 05 Migration                                 Mapping   Validation
                                                 X M L
                                                  E D I                                 Data Pool
                                             F la t F ile
                                              O t h e r ...

                                                                                   3

   Results
                                                                                       IDW2/IRD             Data                 D a ta



       Lower cost, more flexible                                                        Data Pool          Mapping
                                                                                                                                O u tp u t
                                                                                                                                 X M L
                                                                                                                                  E D I
                                                                                                                               F la t F ile
                                                                                                                               O th e r ...

                                                                                                                           5
       Serve all markets
                                       12
                   Role in Global Marketplace

  •IDEA IDW2/IRD is source data
  pool certified and powered by
  UCCnet to serve retail market.
  • Same IDW2 source serves all
  other mfg channels enabling
  mfgs to put data in one
  location to meet all needs



Distributors,
OEMs.
Suppliers,                  UCCNet
Reps




                IDEA                            Retail


           IDW2/IRD

                                     13
                            Summary
   Continued progress since last NEMA BOG meeting
   IDEA organization strongest position in many years
   IDW improvement plan in gear
   Need your Commitment & Active Involvement in IDW
       Get data in IDW if you sell electrical products to or through :
        – Wholesalers
        – Other suppliers
        – Reps
        – OEMS
       Participate in DAC

   Benefits:
       Lower operating costs for Manufacturers and Distributors
       Reduction in Errors, Improved Customer Relations
       Ease, Speed & Reliability of Business-to-Business transactions

                                   14
Learn More and Contact Information




         1300 North 17th Street, Suite 1847
              Rosslyn, Virginia 22209
                   (703) 841-3247
              www.idea-inc.org

            is a joint        and       enterprise




                                                     Next
                         15