China Import Purchase Order - Excel

Document Sample
China Import Purchase Order - Excel Powered By Docstoc
					                                                                                                                                                                                                          12/13/2010
H-E-B Import PO Maintenance Tracking Spreadsheet - IMPORT VENDOR (Non-L&F)                                                  Version 1.2 (Includes10+2 Data)
See "INSTRUCTIONS FOR USING THIS SPREADSHEET" located at the bottom of this template.
Note: All Updated Factory Information Requires A New Quote Be Submitted At The Same Time PO Maintenance Is Requested.

Workgroup
Assignment:                                         START HERE
                    Vendor Data
  VENDOR            Entered by Whom
                                                                    <<Use Drop
                    SCA/IA # & Name
                    As Listed On The PO             USE DROP DOWN   Down Box To
                    (Use Drop Down Box To           BOX TO SELECT   Select Name
  VENDOR            Select Name From The List)      FROM LIST       From List


                    Vendor Name
  VENDOR            As Listed On The PO


                    HEB Vendor #
                    (Note: HEB Internal Vendor
                    # is not transmitted via EDI.
                    The HEB SCA/IA will fill out
    SCA/IA          this field)

                    Date of Change
  VENDOR            Request
                    PO # - List the six
                    digits after the "x".
                    (Example: 15x860609 =
  VENDOR            860609)

                    NEW PO #
                    (The HEB SCA/IA Will
                    Provide This Number
                    back to the VENDOR if a
    SCA/IA          New PO was created)
                                                                    USE DROP      USE DROP      USE DROP      USE DROP      USE DROP       USE DROP                           USE DROP      USE DROP
                    Whse #
                    (Use Drop Down Box To
                                                    USE DROP DOWN   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO    DOWN BOX TO        USE DROP DOWN   DOWN BOX TO   DOWN BOX TO
                    Select Whse # From The          BOX TO SELECT   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM    SELECT FROM        BOX TO SELECT   SELECT FROM   SELECT FROM
  VENDOR            List)                           FROM LIST       LIST          LIST          LIST          LIST          LIST           LIST               FROM LIST       LIST          LIST
                    EXISTING H-E-B
                    ITEM CODE
  VENDOR            As Listed On The PO

                    NEW H-E-B ITEM
                    CODE (The HEB SCA/IA Will
                    Provide New Item Code Back To
    SCA/IA          Vendor If Needed)




                                                                    USE DROP      USE DROP      USE DROP      USE DROP      USE DROP       USE DROP                           USE DROP      USE DROP
                    What Changed?                   USE DROP DOWN   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO    DOWN BOX TO        USE DROP DOWN   DOWN BOX TO   DOWN BOX TO
                    (Use Drop Down Box To           BOX TO SELECT   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM    SELECT FROM        BOX TO SELECT   SELECT FROM   SELECT FROM
  VENDOR            Select Issue From List)         FROM LIST       LIST          LIST          LIST          LIST          LIST           LIST               FROM LIST       LIST          LIST




                    Why It                                          USE DROP      USE DROP      USE DROP      USE DROP      USE DROP       USE DROP                           USE DROP      USE DROP
                    Changed?                        USE DROP DOWN   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO   DOWN BOX TO    DOWN BOX TO        USE DROP DOWN   DOWN BOX TO   DOWN BOX TO
                    (Use Drop Down Box To           BOX TO SELECT   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM   SELECT FROM    SELECT FROM        BOX TO SELECT   SELECT FROM   SELECT FROM
  VENDOR            Select Reason From List)        FROM LIST       LIST          LIST          LIST          LIST          LIST           LIST               FROM LIST       LIST          LIST
    SCA/IA          OLD Ship Date
    SCA/IA          NEW Ship Date
    SCA/IA          OLD PORT
    SCA/IA          NEW PORT
                    OLD Container
    SCA/IA          Size
                    NEW Container
    SCA/IA          Size
    SCA/IA          OLD Order Qty
   SCA/IA           NEW Order Qty
 PIA To Get
   Buyer
   Signoff          NEW FOB COST
 PIA To Get
   Buyer            NEW MASTER
   Signoff          PACK
 PIA To Get
   Buyer            NEW INNER
   Signoff          PACK


        PIA         NEW Description
                    OLD UPC (Include
        PIA         Pre-Digit and Check Digit)
                    NEW UPC (Include
        PIA         Pre-Digit and Check Digit)




        PIA         NEW VPC (Mfg #)
        PIA         NEW Length
        PIA         NEW Width
        PIA         NEW Height
        PIA         OLD Cube
        PIA         NEW Cube
        PIA         NEW Weight
        PIA         PREPRICE
PIA - Must have
  CK Logistics'
 Review Before
   Changing         HTS Code

        PIA         Item Color
                    Carton Marking
                    Color Band
                    WORDING
                    (Example: Halloween
        PIA         Deco)


                    Country of
        PIA         Origin
        PIA         Sourcing Code
        PIA         Office Code

PIA - Payment       Payment Method
Method Must Be      Must Be WT (Wire
WT (Wire            Transfer). Letter of
Transfer). LC       Credit (LC) requests must
must have           have PRIOR approval of H-
approval of H-E-B   E-B Global Sourcing for
Global Sourcing.    GM/Seasonal/Drugstore.




                                                                                                                                                       1 of 13
                                                                                                                                                                                                                                                 12/13/2010
H-E-B Import PO Maintenance Tracking Spreadsheet - IMPORT VENDOR (Non-L&F)                                                                     Version 1.2 (Includes10+2 Data)
See "INSTRUCTIONS FOR USING THIS SPREADSHEET" located at the bottom of this template.
Note: All Updated Factory Information Requires A New Quote Be Submitted At The Same Time PO Maintenance Is Requested.

Workgroup
Assignment:                                   START HERE
              Vendor Data
  VENDOR      Entered by Whom
                                                                      <<Use Drop
              SCA/IA # & Name
              As Listed On The PO             USE DROP DOWN           Down Box To
              (Use Drop Down Box To           BOX TO SELECT           Select Name
  VENDOR      Select Name From The List)      FROM LIST               From List


              Vendor Name
  VENDOR      As Listed On The PO


              HEB Vendor #
              (Note: HEB Internal Vendor
              # is not transmitted via EDI.
              The HEB SCA/IA will fill out
   SCA/IA     this field)

              Date of Change
  VENDOR      Request
              PO # - List the six
              digits after the "x".
              (Example: 15x860609 =
  VENDOR      860609)

              NEW PO #
              (The HEB SCA/IA Will
              Provide This Number
              back to the VENDOR if a
   SCA/IA     New PO was created)
                                                                      USE DROP      USE DROP           USE DROP            USE DROP            USE DROP            USE DROP                                    USE DROP            USE DROP
              Whse #
              (Use Drop Down Box To
                                              USE DROP DOWN           DOWN BOX TO   DOWN BOX TO        DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         USE DROP DOWN           DOWN BOX TO         DOWN BOX TO
              Select Whse # From The          BOX TO SELECT           SELECT FROM   SELECT FROM        SELECT FROM         SELECT FROM         SELECT FROM         SELECT FROM         BOX TO SELECT           SELECT FROM         SELECT FROM
  VENDOR      List)                           FROM LIST               LIST          LIST               LIST                LIST                LIST                LIST                FROM LIST               LIST                LIST
              EXISTING H-E-B
              ITEM CODE
  VENDOR      As Listed On The PO

              NEW H-E-B ITEM
              CODE (The HEB SCA/IA Will
              Provide New Item Code Back To
   SCA/IA     Vendor If Needed)




                                                                      USE DROP      USE DROP           USE DROP            USE DROP            USE DROP            USE DROP                                    USE DROP            USE DROP
              What Changed?                   USE DROP DOWN           DOWN BOX TO   DOWN BOX TO        DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         USE DROP DOWN           DOWN BOX TO         DOWN BOX TO
              (Use Drop Down Box To           BOX TO SELECT           SELECT FROM   SELECT FROM        SELECT FROM         SELECT FROM         SELECT FROM         SELECT FROM         BOX TO SELECT           SELECT FROM         SELECT FROM
  VENDOR      Select Issue From List)         FROM LIST               LIST          LIST               LIST                LIST                LIST                LIST                FROM LIST               LIST                LIST




              Why It                                                  USE DROP      USE DROP           USE DROP            USE DROP            USE DROP            USE DROP                                    USE DROP            USE DROP
              Changed?                        USE DROP DOWN           DOWN BOX TO   DOWN BOX TO        DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         DOWN BOX TO         USE DROP DOWN           DOWN BOX TO         DOWN BOX TO
              (Use Drop Down Box To           BOX TO SELECT           SELECT FROM   SELECT FROM        SELECT FROM         SELECT FROM         SELECT FROM         SELECT FROM         BOX TO SELECT           SELECT FROM         SELECT FROM
  VENDOR      Select Reason From List)        FROM LIST               LIST          LIST               LIST                LIST                LIST                LIST                FROM LIST               LIST                LIST

              HEB Assigned Factory
              #           (As Liste
  VENDOR      on PO)
              OLD Eqos Quote
              Number (Required For
  VENDOR      Factory Updates)


              NEW Eqos Quote
              Number (Required For
  VENDOR      Factory Updates)




  PIA- New
   Quote      Factory Name
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Address
  Required    (New Quote Required)




  PIA- New
   Quote      Factory City            (New
  Required    Quote Required)




  PIA- New
   Quote      Factory County
  Required    (New Quote Required)




  PIA- New    Factory
   Quote      Province/State
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Country
  Required    (New Quote Required)




  PIA- New    Factory Postal
   Quote      Code/Zip Code
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Phone
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Fax
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Contact
  Required    (New Quote Required)




  PIA- New
   Quote      Factory E-mail
  Required    (New Quote Required)

              VENDOR
              Comments
  VENDOR      Dated: 5/30/09

              HEB Comments
   SCA/IA     Dated: 5/31/09
              VENDOR
              Comments
  VENDOR      Dated:




              HEB Comments
   SCA/IA     Dated:
              Color Key:                                                            INSTRUCTIONS FOR USING THIS SPREADSHEET:

                                              = VENDOR to Use
                                              Drop Down Box For
  VENDOR               GREEN                  This Field                            1. Only List ONE VENDOR PER SPREADSHEET (It is OK to list multiple POs from same vendor on the same spreadsheet.)

                                              = VENDOR                              2. The Vendor is to e-mail this spreadsheet to appropriate SCA/IA and Buyer. (Do NOT copy the PIA. The SCA/IA will consult with the
  VENDOR                 BLUE                 REQUIRED FIELDS                       PIA when necessary.)
                                              = SCA/IA to Update
   SCA/IA                 RED                 after Buyer Approves                  3. The Vendor must use drop down boxes where available (green cells) to keep data consistent.

                                                                                    4. If multiple issues exist for one PO, the Vendor must list the same PO again in a separate column to the right of the first issue. Each
                                              = PIA to Update after                 issue must be listed in a separate column with the exception of Factory Information . Factory Information can be listed all in the
     PIA               YELLOW                 Buyer Approves                        same column to save space/columns on the spreadsheet.

                                                                                    5. The SCA/IA will review the requests with the Buyer and respond to the Vendor by placing comments at the bottom cells of the
                                                                                    spreadsheet and e-mailing it back to the Vendor, PIA and Sande Jaksha. SCA/IA will note when issue is CLOSED.
                                                                                    6. The SCA/IA turnaround time for resolving all issues = 48 hours from the time the e-mail is received from the Vendor (some issues
                                                                                    require overnight system processing to occur before PO can be re-issued.)
                                                                                    7. If an issue is not resolved after 48 hours from the issue being e-mailed, the Vendor is to then highlight the column for the issue in RED
                                                                                    on the template and re-send to the SCA/IA and Buyer for immediate response.




                                                                                                                                                                                  2 of 13
EXAMPLE REQUESTS- HOW TO CORRECTLY FILL OUT THE SPREADSHEET
See below for different types of requests and the correct way to fill out the spreadsheet.
                  H-E-B Import PO Maintenance Tracking Spreadsheet - IMPORT VENDOR (Non-L&F) - Example Template                           Version 1.2 (Includes10+2 Data)

                  See "INSTRUCTIONS FOR USING THIS SPREADSHEET" located at the bottom of this template.
                  Note: All Updated Factory Information Requires A New Quote Be Submitted At The Same Time PO Maintenance Is Requested.

Workgroup
Assignment:                                            Start Here
                  Vendor Data
  VENDOR          Entered by Whom                 Type Your Name Here

                                                                        <<Use Drop
                  SCA/IA # & Name
                  As Listed On The PO (Use
                                                                        Down Box To
                  Drop Down Box To Select         15 MAGGIE             Select Name
  VENDOR          Name From The List)             HALBARDIER            From List

                                                  Type The Vendor's
                  Vendor Name                     Name Here As Listed
  VENDOR          As Listed On The PO             On The PO

                  HEB Vendor #
                  (Note: HEB Internal Vendor
                  # is not transmitted via EDI.
                  The HEB SCA/IA will fill out
   SCA/IA         this field)                     06825
                  Date of Change
  VENDOR          Request                         05/09/09              05/09/09            05/09/09             05/09/09                 05/09/09              05/09/09         05/09/09        05/09/09            05/09/09         05/09/09         05/09/09         05/09/09
                  PO # - List the six
                  digits after the "x".
                  (Example: 15x860609 =
  VENDOR          860609)                         708343                708343              708343               880834                   880834                708348           708348          708348              744387           744381           708352           708448

                  NEW PO #
                  (The HEB SCA/IA Will
                  Provide This Number
                  back to the VENDOR if a
   SCA/IA         New PO was created)

                  Whse #
                  (Use Drop Down Box To
                  Select Whse # From The
  VENDOR          List)                           44                    44                  44                   44                       44                    57               57              57                  57               57               57               57
                  EXISTING H-E-B
                  ITEM CODE
  VENDOR          As Listed On The PO             889225                123456              21601                151876                   151876                235886           235886          235886              254522           255672           21162            255123

                  NEW H-E-B ITEM
                  CODE (The HEB SCA/IA Will
                  Provide New Item Code Back To
   SCA/IA         Vendor If Needed)




                  What Changed?
                  (Use Drop Down Box To                                                                          Master Dimension Inner Dimension
  VENDOR          Select Issue From List)         Ship Date             Case UPC            Item UPC             Change           Change                        VPC (Mfg Code)   Master Pack     Port                Item Cancelled   Container Size   Order Quantity   FOB Cost




                                                                                                                                                                                                                                                       Order Quantity
                                                                                                                                                                                                                                                       Change-PO
                                                                                                                 Master Case                                                                                        Item Cancelled-                    Overweight
                  Why It Changed? Ship Date Change-Item Case UPC                            Item UPC             Dimensions               Inner Dimensions VPC (Mfg Code)                                           Item No Longer    Container Size   (Weighs Out      FOB Cost
                  (Use Drop Down Box To    Not Manufactured On Changed Per                  Changed Per          Changed Per              Changed Per      Changed Per           Pack Changed    Port Change-Due To Being             Changed Per      Before Cubing    Changed Due To
  VENDOR          Select Reason From List) Time                Vendor                       Vendor               Vendor                   Vendor           Vendor                Per BDM Request Factory Change     Manufactured      Vendor           Out)             Materials Change
   SCA/IA         OLD Ship Date                   5/9/09
   SCA/IA         NEW Ship Date                   5/10/09
   SCA/IA         OLD PORT                                                                                                                                                                       Shanghai
   SCA/IA         NEW PORT                                                                                                                                                                       Ningbo
                  OLD Container
   SCA/IA         Size                                                                                                                                                                                                                FCL40
                  NEW Container
   SCA/IA         Size                                                                                                                                                                                                                FCL45HQ
   SCA/IA         OLD Order Qty                                                                                                                                                                                                                        238
   SCA/IA         NEW Order Qty                                                                                                                                                                                                                        500
 PIA To Get
Buyer Signoff NEW FOB COST                                                                                                                                                                                                                                              1.27

 PIA To Get NEW MASTER
Buyer Signoff PACK                                                                                                                                                               24

 PIA To Get NEW INNER
Buyer Signoff PACK


        PIA       NEW Description
                  OLD UPC (Include Pre-
        PIA       Digit and Check Digit)                                1-12345-11111-1 1-12345-11123-1
                  NEW UPC (Include
        PIA       Pre-Digit and Check Digit)                            1-12345-11122-2 1-12345-11124-6




        PIA       NEW VPC (Mfg #)                                                                                                                               A-00889
        PIA       NEW Length                                                                                     18.7                     12.5
        PIA       NEW Width                                                                                      17.7                     11.2
        PIA       NEW Height                                                                                     16.3                     10.1
        PIA       OLD Cube                                                                                       2.750                    2.800
        PIA       NEW Cube                                                                                       3.122                    2.750

        PIA       NEW Weight                                                                                     19.80                    16.10

        PIA       PREPRICE
PIA - Must have
 CK Logistics'
 Review Before
   Changing       HTS Code

     PIA          Item Color

                  Carton Marking
                  Color Band
                  WORDING
     PIA          (Example: Halloween Deco)


                  Country of
     PIA          Origin
     PIA          Sourcing Code
     PIA          Office Code
Workgroup
Assignment:                                              Start Here
                    Vendor Data
   VENDOR           Entered by Whom                 Type Your Name Here

                                                                          <<Use Drop
                    SCA/IA # & Name
                    As Listed On The PO (Use
                                                                          Down Box To
                    Drop Down Box To Select         15 MAGGIE             Select Name
   VENDOR           Name From The List)             HALBARDIER            From List

                                                    Type The Vendor's
                    Vendor Name                     Name Here As Listed
   VENDOR           As Listed On The PO             On The PO

                    HEB Vendor #
                    (Note: HEB Internal Vendor
                    # is not transmitted via EDI.
                    The HEB SCA/IA will fill out
    SCA/IA          this field)                     06825
                    Date of Change
   VENDOR           Request                         05/09/09              05/09/09      05/09/09      05/09/09         05/09/09          05/09/09         05/09/09        05/09/09            05/09/09         05/09/09         05/09/09         05/09/09
                    PO # - List the six
                    digits after the "x".
                    (Example: 15x860609 =
   VENDOR           860609)                         708343                708343        708343        880834           880834            708348           708348          708348              744387           744381           708352           708448

                    NEW PO #
                    (The HEB SCA/IA Will
                    Provide This Number
                    back to the VENDOR if a
    SCA/IA          New PO was created)

                    Whse #
                    (Use Drop Down Box To
                    Select Whse # From The
   VENDOR           List)                           44                    44            44            44               44                57               57              57                  57               57               57               57
                    EXISTING H-E-B
                    ITEM CODE
   VENDOR           As Listed On The PO             889225                123456        21601         151876           151876            235886           235886          235886              254522           255672           21162            255123

                    NEW H-E-B ITEM
                    CODE (The HEB SCA/IA Will
                    Provide New Item Code Back To
    SCA/IA          Vendor If Needed)




                    What Changed?
                    (Use Drop Down Box To                                                             Master Dimension Inner Dimension
   VENDOR           Select Issue From List)         Ship Date             Case UPC      Item UPC      Change           Change            VPC (Mfg Code)   Master Pack     Port                Item Cancelled   Container Size   Order Quantity   FOB Cost




                                                                                                                                                                                                                                Order Quantity
                                                                                                                                                                                                                                Change-PO
                                                                                                      Master Case                                                                            Item Cancelled-                    Overweight
                    Why It Changed? Ship Date Change-Item Case UPC                      Item UPC      Dimensions       Inner Dimensions VPC (Mfg Code)                                       Item No Longer    Container Size   (Weighs Out      FOB Cost
                    (Use Drop Down Box To           Not Manufactured On   Changed Per   Changed Per   Changed Per      Changed Per      Changed Per       Pack Changed    Port Change-Due To Being             Changed Per      Before Cubing    Changed Due To
   VENDOR           Select Reason From List)        Time                  Vendor        Vendor        Vendor           Vendor           Vendor            Per BDM Request Factory Change     Manufactured      Vendor           Out)             Materials Change


PIA - Payment       Payment Method
Method Must Be      Must Be WT (Wire
WT (Wire            Transfer). Letter of Credit
Transfer). LC       (LC) requests must have
must have           PRIOR approval of H-E-B
approval of H-E-B   Global Sourcing for
Global Sourcing.    GM/Seasonal/Drugstore.

                    HEB Assigned Factory
                    #           (As Liste
   VENDOR           on PO)
                    OLD Eqos Quote
                    Number (Required For
   VENDOR           Factory Updates)


                    NEW Eqos Quote
                    Number (Required For
   VENDOR           Factory Updates)




   PIA- New
    Quote           Factory Name
   Required         (New Quote Required)




   PIA- New
    Quote           Factory Address
   Required         (New Quote Required)




   PIA- New
    Quote           Factory City            (New
   Required         Quote Required)




   PIA- New
    Quote           Factory County
   Required         (New Quote Required)




   PIA- New         Factory
    Quote           Province/State
   Required         (New Quote Required)




   PIA- New
    Quote           Factory Country
   Required         (New Quote Required)
Workgroup
Assignment:                                        Start Here
              Vendor Data
  VENDOR      Entered by Whom                 Type Your Name Here

                                                                    <<Use Drop
              SCA/IA # & Name
              As Listed On The PO (Use
                                                                    Down Box To
              Drop Down Box To Select         15 MAGGIE             Select Name
  VENDOR      Name From The List)             HALBARDIER            From List

                                              Type The Vendor's
              Vendor Name                     Name Here As Listed
  VENDOR      As Listed On The PO             On The PO

              HEB Vendor #
              (Note: HEB Internal Vendor
              # is not transmitted via EDI.
              The HEB SCA/IA will fill out
   SCA/IA     this field)                     06825
              Date of Change
  VENDOR      Request                         05/09/09              05/09/09      05/09/09         05/09/09          05/09/09         05/09/09          05/09/09         05/09/09             05/09/09         05/09/09         05/09/09         05/09/09
              PO # - List the six
              digits after the "x".
              (Example: 15x860609 =
  VENDOR      860609)                         708343                708343        708343           880834            880834           708348            708348           708348               744387           744381           708352           708448

              NEW PO #
              (The HEB SCA/IA Will
              Provide This Number
              back to the VENDOR if a
   SCA/IA     New PO was created)

              Whse #
              (Use Drop Down Box To
              Select Whse # From The
  VENDOR      List)                           44                    44            44               44                44               57                57               57                   57               57               57               57
              EXISTING H-E-B
              ITEM CODE
  VENDOR      As Listed On The PO             889225                123456        21601            151876            151876           235886            235886           235886               254522           255672           21162            255123

              NEW H-E-B ITEM
              CODE (The HEB SCA/IA Will
              Provide New Item Code Back To
   SCA/IA     Vendor If Needed)




              What Changed?
              (Use Drop Down Box To                                                                Master Dimension Inner Dimension
  VENDOR      Select Issue From List)         Ship Date             Case UPC      Item UPC         Change           Change            VPC (Mfg Code)    Master Pack      Port                 Item Cancelled   Container Size   Order Quantity   FOB Cost




                                                                                                                                                                                                                                Order Quantity
                                                                                                                                                                                                                                Change-PO
                                                                                                   Master Case                                                                             Item Cancelled-                      Overweight
              Why It Changed? Ship Date Change-Item Case UPC                      Item UPC         Dimensions        Inner Dimensions VPC (Mfg Code)                                       Item No Longer      Container Size   (Weighs Out      FOB Cost
              (Use Drop Down Box To           Not Manufactured On   Changed Per   Changed Per      Changed Per       Changed Per      Changed Per       Pack Changed    Port Change-Due To Being               Changed Per      Before Cubing    Changed Due To
  VENDOR      Select Reason From List)        Time                  Vendor        Vendor           Vendor            Vendor           Vendor            Per BDM Request Factory Change     Manufactured        Vendor           Out)             Materials Change




  PIA- New    Factory Postal
   Quote      Code/Zip Code
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Phone
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Fax
  Required    (New Quote Required)




  PIA- New
   Quote      Factory Contact
  Required    (New Quote Required)




  PIA- New
   Quote      Factory E-mail
  Required    (New Quote Required)

              VENDOR
              Comments
   VENDOR     Dated: 5/30/09

              HEB Comments
   SCA/IA     Dated: 5/31/09
              VENDOR
              Comments
   VENDOR     Dated:




              HEB Comments
   SCA/IA     Dated:
              Color Key:                                                          INSTRUCTIONS FOR USING THIS SPREADSHEET:

                                              = VENDOR to Use
                                              Drop Down Box For
  VENDOR               GREEN                  This Field                          1. Only List ONE VENDOR PER SPREADSHEET (It is OK to list multiple POs from same vendor on the same spreadsheet.)
Workgroup
Assignment:                                        Start Here
              Vendor Data
  VENDOR      Entered by Whom                 Type Your Name Here

                                                                      <<Use Drop
              SCA/IA # & Name
              As Listed On The PO (Use
                                                                      Down Box To
              Drop Down Box To Select         15 MAGGIE               Select Name
  VENDOR      Name From The List)             HALBARDIER              From List

                                              Type The Vendor's
              Vendor Name                     Name Here As Listed
  VENDOR      As Listed On The PO             On The PO

              HEB Vendor #
              (Note: HEB Internal Vendor
              # is not transmitted via EDI.
              The HEB SCA/IA will fill out
   SCA/IA     this field)                     06825
              Date of Change
  VENDOR      Request                         05/09/09                05/09/09      05/09/09            05/09/09            05/09/09            05/09/09            05/09/09            05/09/09                05/09/09              05/09/09         05/09/09         05/09/09
              PO # - List the six
              digits after the "x".
              (Example: 15x860609 =
  VENDOR      860609)                         708343                  708343        708343              880834              880834              708348              708348              708348                  744387                744381           708352           708448

              NEW PO #
              (The HEB SCA/IA Will
              Provide This Number
              back to the VENDOR if a
   SCA/IA     New PO was created)

              Whse #
              (Use Drop Down Box To
              Select Whse # From The
  VENDOR      List)                           44                      44            44                  44                  44                  57                  57                  57                      57                    57               57               57
              EXISTING H-E-B
              ITEM CODE
  VENDOR      As Listed On The PO             889225                  123456        21601               151876              151876              235886              235886              235886                  254522                255672           21162            255123

              NEW H-E-B ITEM
              CODE (The HEB SCA/IA Will
              Provide New Item Code Back To
   SCA/IA     Vendor If Needed)




              What Changed?
              (Use Drop Down Box To                                                                     Master Dimension Inner Dimension
  VENDOR      Select Issue From List)         Ship Date               Case UPC      Item UPC            Change           Change                 VPC (Mfg Code)      Master Pack         Port                    Item Cancelled        Container Size   Order Quantity   FOB Cost




                                                                                                                                                                                                                                                       Order Quantity
                                                                                                                                                                                                                                                       Change-PO
                                                                                                        Master Case                                                                                    Item Cancelled-                                 Overweight
              Why It Changed? Ship Date Change-Item Case UPC                        Item UPC            Dimensions          Inner Dimensions VPC (Mfg Code)                                            Item No Longer                 Container Size   (Weighs Out      FOB Cost
              (Use Drop Down Box To           Not Manufactured On     Changed Per   Changed Per         Changed Per         Changed Per      Changed Per            Pack Changed    Port Change-Due To Being                          Changed Per      Before Cubing    Changed Due To
  VENDOR      Select Reason From List)        Time                    Vendor        Vendor              Vendor              Vendor           Vendor                 Per BDM Request Factory Change     Manufactured                   Vendor           Out)             Materials Change

                                              = VENDOR                              2. The Vendor is to e-mail this spreadsheet to appropriate SCA/IA and Buyer. (Do NOT copy the PIA. The SCA/IA will consult with the
  VENDOR                 BLUE                 REQUIRED FIELDS                       PIA when necessary.)
                                              = SCA/IA to Update
   SCA/IA                 RED                 after Buyer Approves                  3. The Vendor must use drop down boxes where available (green cells) to keep data consistent.

                                                                                    4. If multiple issues exist for one PO, the Vendor must list the same PO again in a separate column to the right of the first issue. Each issue
                                              = PIA to Update after                 must be listed in a separate column with the exception of Factory Information . Factory Information can be listed all in the same
     PIA              YELLOW                  Buyer Approves                        column to save space/columns on the spreadsheet.

                                                                                    5. The SCA/IA will review the requests with the Buyer and respond to the Vendor by placing comments at the bottom cells of the
                                                                                    spreadsheet and e-mailing it back to the Vendor, PIA and Sande Jaksha. SCA/IA will note when issue is CLOSED.
                                                                                    6. The SCA/IA turnaround time for resolving all issues = 48 hours from the time the e-mail is received from the Vendor (some issues require
                                                                                    overnight system processing to occur before PO can be re-issued.)
                                                                                    7. If an issue is not resolved after 48 hours from the issue being e-mailed, the Vendor is to then highlight the column for the issue in RED
                                                                                    on the template and re-send to the SCA/IA and Buyer for immediate response.
EXAMPLE REQUESTS- HOW TO CORRECTLY FILL OUT THE SPREADSHEET
See below for different types of requests and the correct way to fill out the spreadsheet.
                  H-E-B Import PO Maintenance Tracking Spreadsheet - IMPORT VENDOR (Non-L&F) - Example Template

                  See "INSTRUCTIONS FOR USING THIS SPREADSHEET" located at the bottom of this template.
                  Note: All Updated Factory Information Requires A New Quote Be Submitted At The Same Time PO Maintenance Is Requested.

Workgroup
Assignment:

                  Vendor Data
  VENDOR          Entered by Whom

                  SCA/IA # & Name
                  As Listed On The PO (Use
                  Drop Down Box To Select
  VENDOR          Name From The List)



                  Vendor Name
  VENDOR          As Listed On The PO


                  HEB Vendor #
                  (Note: HEB Internal Vendor
                  # is not transmitted via EDI.
                  The HEB SCA/IA will fill out
   SCA/IA         this field)

                  Date of Change
  VENDOR          Request                         05/09/09            05/09/09          05/19/09             05/19/09            05/19/09         05/19/09        05/19/09       05/19/09      05/19/09       05/19/09           05/19/09      05/19/09
                  PO # - List the six
                  digits after the "x".
                  (Example: 15x860609 =
  VENDOR          860609)                         708462              708254            860609               687221              687221           687221          689224         689224        546688         668284             554556        459822

                  NEW PO #
                  (The HEB SCA/IA Will
                  Provide This Number
                  back to the VENDOR if a
   SCA/IA         New PO was created)

                  Whse #
                  (Use Drop Down Box To
                  Select Whse # From The
  VENDOR          List)                           57                  57                57                   44                  44               44              57             57            44             57                 44            57
                  EXISTING H-E-B
                  ITEM CODE
  VENDOR          As Listed On The PO             786225              165552            62198                55812               55812            55812           118999         118999        118999         855987             288898        126668

                  NEW H-E-B ITEM
                  CODE (The HEB SCA/IA Will
                  Provide New Item Code Back To
   SCA/IA         Vendor If Needed)


                                                                                                                                                                                                              FACTORY            FACTORY
                                                                                                                                                                                                              INFORMATIO         INFORMAT      FACTORY
                                                                                                                                                                                                              N (All New         ION (All      INFORMATI
                                                                                                                                                                                                              FACTORY            New Info      ON (All New
                                                                                                                                                                                                              Info For An        Can Be        Info Can Be
                  What Changed?                                                                                                  Carton Marking                                                               Item Can Be        Listed In     Listed In
                  (Use Drop Down Box To                                                                                          Color Band       Country of      Sourcing                     Payment        Listed In This     This One      This One
  VENDOR          Select Issue From List)         Description         Pre-Price         HTS Code             Item Color          Wording          Origin          Code           Office Code   Method         Column)            Column)       Column)
                                                                                                                                                                                                              All Factory Info   Permanent     Factory Info
                                                                                                                                                  Country Of                                   Payment        Was Blank On       Factory       Inaccurate
                                                                                                                                                  Origin                                       Method*        Item When          Change        When PO
                                                                                        HTS Code Was                             Carton Marking   Inaccurate On   Office Code                  Inaccurate     PO Was             (Requires     Was Issued
                                                                                        Blank On Item                            Color Band       Item When       Was Blank                    When PO        Issued             Updated       (Requires
                                                                                        When PO Was          Item Color          Wording Was      PO Was          On Item                      Was Issued     (Requires          Quote         Updated
                                                                                        Issued - HEB         Changed at          Blank When PO    Issued- HEB     When PO        Office Code   *Must be WT    Updated            Sheet From    Quote Sheet
                                                                                        ACTION: Review       Vendor's            Was Issued -     ACTION:         Was Issued -   Was Blank On (Wire           Quote Sheet        Vendor        From Vendor
                                                                                        HTS w/CK             Request - HEB       HEB ACTION:      Update          HEB            Item When PO Transfer). LC   From Vendor        Showing All   Showing All
                                                  Description                           Logistics First      ACTION:             Add Carton       Existing        ACTION:        Was Issued - must have       Showing All        Factory       Factory Info) -
                  Why It Changed? Change Due to                                         Then Add             Remove Old          Marking Color    Country Of      Add Office     HEB ACTION: approval of H-   Factory Info)-     Info) - HEB   HEB
                  (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS        Color Add New       Band Wording     Origin On       Code To        Add Office    E-B Global     HEB ACTION:        ACTION:       ACTION:
  VENDOR          Select Reason From List)        Change             Purchase Order     Code To Item.        Color To Item.      To Item.         Item            Item.          Code To Item. Sourcing.      Add Factory        Remove        Update
   SCA/IA         OLD Ship Date
   SCA/IA         NEW Ship Date
   SCA/IA         OLD PORT
   SCA/IA         NEW PORT
                  OLD Container
   SCA/IA         Size
                  NEW Container
   SCA/IA         Size
   SCA/IA         OLD Order Qty
   SCA/IA         NEW Order Qty
 PIA To Get
Buyer Signoff NEW FOB COST

 PIA To Get NEW MASTER
Buyer Signoff PACK

 PIA To Get NEW INNER
Buyer Signoff PACK

                                                  Easter Bunny with
        PIA       NEW Description Pail
                  OLD UPC (Include Pre-
        PIA       Digit and Check Digit)
                  NEW UPC (Include
        PIA       Pre-Digit and Check Digit)




        PIA       NEW VPC (Mfg #)
        PIA       NEW Length
        PIA       NEW Width
        PIA       NEW Height
        PIA       OLD Cube
        PIA       NEW Cube
        PIA       NEW Weight
        PIA       PREPRICE                                            2.99
PIA - Must have
 CK Logistics'
 Review Before
   Changing       HTS Code                                                              9505906000

     PIA          Item Color                                                                                 Blue

                  Carton Marking
                  Color Band
                  WORDING                                                                                                        HALLOWEEN
     PIA          (Example: Halloween Deco)                                                                                      DECO

                  Country of
     PIA          Origin                                                                                                                          VIETNAM
     PIA          Sourcing Code                                                                                                                                   LF

     PIA          Office Code                                                                                                                                                    007
Workgroup
Assignment:

                    Vendor Data
   VENDOR           Entered by Whom

                    SCA/IA # & Name
                    As Listed On The PO (Use
                    Drop Down Box To Select
   VENDOR           Name From The List)



                    Vendor Name
   VENDOR           As Listed On The PO


                    HEB Vendor #
                    (Note: HEB Internal Vendor
                    # is not transmitted via EDI.
                    The HEB SCA/IA will fill out
    SCA/IA          this field)

                    Date of Change
   VENDOR           Request                         05/09/09          05/09/09            05/19/09          05/19/09         05/19/09         05/19/09        05/19/09       05/19/09      05/19/09       05/19/09           05/19/09      05/19/09
                    PO # - List the six
                    digits after the "x".
                    (Example: 15x860609 =
   VENDOR           860609)                         708462            708254              860609            687221           687221           687221          689224         689224        546688         668284             554556        459822

                    NEW PO #
                    (The HEB SCA/IA Will
                    Provide This Number
                    back to the VENDOR if a
    SCA/IA          New PO was created)

                    Whse #
                    (Use Drop Down Box To
                    Select Whse # From The
   VENDOR           List)                           57                57                  57                44               44               44              57             57            44             57                 44            57
                    EXISTING H-E-B
                    ITEM CODE
   VENDOR           As Listed On The PO             786225            165552              62198             55812            55812            55812           118999         118999        118999         855987             288898        126668

                    NEW H-E-B ITEM
                    CODE (The HEB SCA/IA Will
                    Provide New Item Code Back To
    SCA/IA          Vendor If Needed)


                                                                                                                                                                                                          FACTORY            FACTORY
                                                                                                                                                                                                          INFORMATIO         INFORMAT      FACTORY
                                                                                                                                                                                                          N (All New         ION (All      INFORMATI
                                                                                                                                                                                                          FACTORY            New Info      ON (All New
                                                                                                                                                                                                          Info For An        Can Be        Info Can Be
                    What Changed?                                                                                            Carton Marking                                                               Item Can Be        Listed In     Listed In
                    (Use Drop Down Box To                                                                                    Color Band       Country of      Sourcing                     Payment        Listed In This     This One      This One
   VENDOR           Select Issue From List)         Description       Pre-Price           HTS Code          Item Color       Wording          Origin          Code           Office Code   Method         Column)            Column)       Column)
                                                                                                                                                                                                          All Factory Info   Permanent     Factory Info
                                                                                                                                              Country Of                                   Payment        Was Blank On       Factory       Inaccurate
                                                                                                                                              Origin                                       Method*        Item When          Change        When PO
                                                                                          HTS Code Was                       Carton Marking   Inaccurate On   Office Code                  Inaccurate     PO Was             (Requires     Was Issued
                                                                                          Blank On Item                      Color Band       Item When       Was Blank                    When PO        Issued             Updated       (Requires
                                                                                          When PO Was       Item Color       Wording Was      PO Was          On Item                      Was Issued     (Requires          Quote         Updated
                                                                                          Issued - HEB      Changed at       Blank When PO    Issued- HEB     When PO        Office Code   *Must be WT    Updated            Sheet From    Quote Sheet
                                                                                          ACTION: Review    Vendor's         Was Issued -     ACTION:         Was Issued -   Was Blank On (Wire           Quote Sheet        Vendor        From Vendor
                                                                                          HTS w/CK          Request - HEB    HEB ACTION:      Update          HEB            Item When PO Transfer). LC   From Vendor        Showing All   Showing All
                                                    Description                           Logistics First   ACTION:          Add Carton       Existing        ACTION:        Was Issued - must have       Showing All        Factory       Factory Info) -
                    Why It Changed? Change Due to                                         Then Add          Remove Old       Marking Color    Country Of      Add Office     HEB ACTION: approval of H-   Factory Info)-     Info) - HEB   HEB
                    (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS     Color Add New    Band Wording     Origin On       Code To        Add Office    E-B Global     HEB ACTION:        ACTION:       ACTION:
   VENDOR           Select Reason From List)        Change             Purchase Order     Code To Item.     Color To Item.   To Item.         Item            Item.          Code To Item. Sourcing.      Add Factory        Remove        Update
    SCA/IA          OLD Ship Date
PIA - Payment       Payment Method
Method Must Be      Must Be WT (Wire
WT (Wire            Transfer). Letter of Credit
Transfer). LC       (LC) requests must have
must have           PRIOR approval of H-E-B
approval of H-E-B   Global Sourcing for
Global Sourcing.    GM/Seasonal/Drugstore.                                                                                                                                                 WT

                    HEB Assigned Factory
                    #           (As Liste
   VENDOR           on PO)                                                                                                                                                                                146                160           250
                    OLD Eqos Quote
                    Number (Required For                                                                                                                                                                  OLD #:             OLD #:        OLD #:
   VENDOR           Factory Updates)                                                                                                                                                                      178772             172722        176821

                    NEW Eqos Quote
                    Number (Required For                                                                                                                                                                              NEW #:               NEW #:
   VENDOR           Factory Updates)                                                                                                                                                                      NEW: 185888 189296               189296



                                                                                                                                                                                                                     NINGBO
                                                                                                                                                                                                                     KANGER P&D
   PIA- New                                                                                                                                                                                               HONG KONG GREENNE PLASTIC
    Quote           Factory Name                                                                                                                                                                          DIBAO TOYS SS     MANUFACT
   Required         (New Quote Required)                                                                                                                                                                  CO LTD     CONSUM URING


                                                                                                                                                                                                          7-8 LIAN
                                                                                                                                                                                                          TANG WEI
                                                                                                                                                                                                          INDSTRL
                                                                                                                                                                                                          AREA HE AO
   PIA- New                                                                                                                                                                                               VILLAGE,   NO. 551, LING GANG
    Quote           Factory Address                                                                                                                                                                       HENG GANG DONGCHA INDUSTRIA
   Required         (New Quote Required)                                                                                                                                                                  TOWN       NG ROAD L PARK




   PIA- New
    Quote           Factory City            (New                                                                                                                                                          GUANGZHO                         GUJING
   Required         Quote Required)                                                                                                                                                                       U                  NINGBO        TOWN




   PIA- New
    Quote           Factory County
   Required         (New Quote Required)




   PIA- New         Factory
    Quote           Province/State                                                                                                                                                                        GUANGDON                    GUANGDO
   Required         (New Quote Required)                                                                                                                                                                  G                  ZHEJIANG NG




   PIA- New
    Quote           Factory Country
   Required         (New Quote Required)                                                                                                                                                                  CHINA              CHINA         CHINA
Workgroup
Assignment:

              Vendor Data
  VENDOR      Entered by Whom

              SCA/IA # & Name
              As Listed On The PO (Use
              Drop Down Box To Select
  VENDOR      Name From The List)



              Vendor Name
  VENDOR      As Listed On The PO


              HEB Vendor #
              (Note: HEB Internal Vendor
              # is not transmitted via EDI.
              The HEB SCA/IA will fill out
   SCA/IA     this field)

              Date of Change
  VENDOR      Request                         05/09/09          05/09/09            05/19/09               05/19/09         05/19/09         05/19/09        05/19/09       05/19/09      05/19/09       05/19/09           05/19/09      05/19/09
              PO # - List the six
              digits after the "x".
              (Example: 15x860609 =
  VENDOR      860609)                         708462            708254              860609                 687221           687221           687221          689224         689224        546688         668284             554556        459822

              NEW PO #
              (The HEB SCA/IA Will
              Provide This Number
              back to the VENDOR if a
   SCA/IA     New PO was created)

              Whse #
              (Use Drop Down Box To
              Select Whse # From The
  VENDOR      List)                           57                57                  57                     44               44               44              57             57            44             57                 44            57
              EXISTING H-E-B
              ITEM CODE
  VENDOR      As Listed On The PO             786225            165552              62198                  55812            55812            55812           118999         118999        118999         855987             288898        126668

              NEW H-E-B ITEM
              CODE (The HEB SCA/IA Will
              Provide New Item Code Back To
   SCA/IA     Vendor If Needed)


                                                                                                                                                                                                         FACTORY            FACTORY
                                                                                                                                                                                                         INFORMATIO         INFORMAT      FACTORY
                                                                                                                                                                                                         N (All New         ION (All      INFORMATI
                                                                                                                                                                                                         FACTORY            New Info      ON (All New
                                                                                                                                                                                                         Info For An        Can Be        Info Can Be
              What Changed?                                                                                                 Carton Marking                                                               Item Can Be        Listed In     Listed In
              (Use Drop Down Box To                                                                                         Color Band       Country of      Sourcing                     Payment        Listed In This     This One      This One
  VENDOR      Select Issue From List)         Description       Pre-Price           HTS Code               Item Color       Wording          Origin          Code           Office Code   Method         Column)            Column)       Column)
                                                                                                                                                                                                         All Factory Info   Permanent     Factory Info
                                                                                                                                             Country Of                                   Payment        Was Blank On       Factory       Inaccurate
                                                                                                                                             Origin                                       Method*        Item When          Change        When PO
                                                                                    HTS Code Was                            Carton Marking   Inaccurate On   Office Code                  Inaccurate     PO Was             (Requires     Was Issued
                                                                                    Blank On Item                           Color Band       Item When       Was Blank                    When PO        Issued             Updated       (Requires
                                                                                    When PO Was            Item Color       Wording Was      PO Was          On Item                      Was Issued     (Requires          Quote         Updated
                                                                                    Issued - HEB           Changed at       Blank When PO    Issued- HEB     When PO        Office Code   *Must be WT    Updated            Sheet From    Quote Sheet
                                                                                    ACTION: Review         Vendor's         Was Issued -     ACTION:         Was Issued -   Was Blank On (Wire           Quote Sheet        Vendor        From Vendor
                                                                                    HTS w/CK               Request - HEB    HEB ACTION:      Update          HEB            Item When PO Transfer). LC   From Vendor        Showing All   Showing All
                                              Description                           Logistics First        ACTION:          Add Carton       Existing        ACTION:        Was Issued - must have       Showing All        Factory       Factory Info) -
              Why It Changed? Change Due to                                         Then Add               Remove Old       Marking Color    Country Of      Add Office     HEB ACTION: approval of H-   Factory Info)-     Info) - HEB   HEB
              (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS          Color Add New    Band Wording     Origin On       Code To        Add Office    E-B Global     HEB ACTION:        ACTION:       ACTION:
  VENDOR      Select Reason From List)        Change             Purchase Order     Code To Item.          Color To Item.   To Item.         Item            Item.          Code To Item. Sourcing.      Add Factory        Remove        Update
   SCA/IA     OLD Ship Date




  PIA- New    Factory Postal
   Quote      Code/Zip Code
  Required    (New Quote Required)                                                                                                                                                                       518020             315000        518020




  PIA- New
   Quote      Factory Phone
  Required    (New Quote Required)                                                                                                                                                                       ########### ######### ##########




  PIA- New
   Quote      Factory Fax
  Required    (New Quote Required)                                                                                                                                                                       ########### ######### ##########




  PIA- New
   Quote      Factory Contact                                                                                                                                                                            STANLEY            MARK
  Required    (New Quote Required)                                                                                                                                                                       WU                 DELSON        DENNIS NG




                                                                                                                                                                                                                           PD
  PIA- New                                                                                                                                                                                                         MEDELSO PLASTIC
   Quote      Factory E-mail                                                                                                                                                                             STANLEYWU N@AOL.C @21CN.NE
  Required    (New Quote Required)                                                                                                                                                                       @NLHK.COM OM      T
              VENDOR                                                                The Vendor would
              Comments                                                              comment here if
   VENDOR     Dated: 5/30/09                                                        they need to.
                                                                                    The SCA/IA
                                                                                    would comment
              HEB Comments                                                          here and/or
   SCA/IA     Dated: 5/31/09                                                        indicate if issue is

              VENDOR
              Comments
   VENDOR     Dated:




              HEB Comments
   SCA/IA     Dated:
              Color Key:



  VENDOR               GREEN
Workgroup
Assignment:

              Vendor Data
  VENDOR      Entered by Whom

              SCA/IA # & Name
              As Listed On The PO (Use
              Drop Down Box To Select
  VENDOR      Name From The List)



              Vendor Name
  VENDOR      As Listed On The PO


              HEB Vendor #
              (Note: HEB Internal Vendor
              # is not transmitted via EDI.
              The HEB SCA/IA will fill out
   SCA/IA     this field)

              Date of Change
  VENDOR      Request                         05/09/09          05/09/09            05/19/09          05/19/09         05/19/09         05/19/09        05/19/09       05/19/09      05/19/09       05/19/09           05/19/09      05/19/09
              PO # - List the six
              digits after the "x".
              (Example: 15x860609 =
  VENDOR      860609)                         708462            708254              860609            687221           687221           687221          689224         689224        546688         668284             554556        459822

              NEW PO #
              (The HEB SCA/IA Will
              Provide This Number
              back to the VENDOR if a
   SCA/IA     New PO was created)

              Whse #
              (Use Drop Down Box To
              Select Whse # From The
  VENDOR      List)                           57                57                  57                44               44               44              57             57            44             57                 44            57
              EXISTING H-E-B
              ITEM CODE
  VENDOR      As Listed On The PO             786225            165552              62198             55812            55812            55812           118999         118999        118999         855987             288898        126668

              NEW H-E-B ITEM
              CODE (The HEB SCA/IA Will
              Provide New Item Code Back To
   SCA/IA     Vendor If Needed)


                                                                                                                                                                                                    FACTORY            FACTORY
                                                                                                                                                                                                    INFORMATIO         INFORMAT      FACTORY
                                                                                                                                                                                                    N (All New         ION (All      INFORMATI
                                                                                                                                                                                                    FACTORY            New Info      ON (All New
                                                                                                                                                                                                    Info For An        Can Be        Info Can Be
              What Changed?                                                                                            Carton Marking                                                               Item Can Be        Listed In     Listed In
              (Use Drop Down Box To                                                                                    Color Band       Country of      Sourcing                     Payment        Listed In This     This One      This One
  VENDOR      Select Issue From List)         Description       Pre-Price           HTS Code          Item Color       Wording          Origin          Code           Office Code   Method         Column)            Column)       Column)
                                                                                                                                                                                                    All Factory Info   Permanent     Factory Info
                                                                                                                                        Country Of                                   Payment        Was Blank On       Factory       Inaccurate
                                                                                                                                        Origin                                       Method*        Item When          Change        When PO
                                                                                    HTS Code Was                       Carton Marking   Inaccurate On   Office Code                  Inaccurate     PO Was             (Requires     Was Issued
                                                                                    Blank On Item                      Color Band       Item When       Was Blank                    When PO        Issued             Updated       (Requires
                                                                                    When PO Was       Item Color       Wording Was      PO Was          On Item                      Was Issued     (Requires          Quote         Updated
                                                                                    Issued - HEB      Changed at       Blank When PO    Issued- HEB     When PO        Office Code   *Must be WT    Updated            Sheet From    Quote Sheet
                                                                                    ACTION: Review    Vendor's         Was Issued -     ACTION:         Was Issued -   Was Blank On (Wire           Quote Sheet        Vendor        From Vendor
                                                                                    HTS w/CK          Request - HEB    HEB ACTION:      Update          HEB            Item When PO Transfer). LC   From Vendor        Showing All   Showing All
                                              Description                           Logistics First   ACTION:          Add Carton       Existing        ACTION:        Was Issued - must have       Showing All        Factory       Factory Info) -
              Why It Changed? Change Due to                                         Then Add          Remove Old       Marking Color    Country Of      Add Office     HEB ACTION: approval of H-   Factory Info)-     Info) - HEB   HEB
              (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS     Color Add New    Band Wording     Origin On       Code To        Add Office    E-B Global     HEB ACTION:        ACTION:       ACTION:
  VENDOR      Select Reason From List)        Change             Purchase Order     Code To Item.     Color To Item.   To Item.         Item            Item.          Code To Item. Sourcing.      Add Factory        Remove        Update
   SCA/IA     OLD Ship Date

  VENDOR                 BLUE

   SCA/IA                 RED



     PIA              YELLOW
H-E-B Import PO Maintenance Tracking Spreadsheet - IMPORT VENDOR (Non-L&F) - Request Form Instructions
Version: 1.2 (Includes10+2 Data)
Posted: 5/27/09
Note: All Updated Factory Information Requires A New Quote Be Submitted At The Same Time PO Maintenance Is Requested.

            INSTRUCTIONS FOR USING THIS SPREADSHEET:
            1. Only List ONE VENDOR PER SPREADSHEET (It is OK to list multiple POs from
            same vendor on the same spreadsheet.)

            2. The Vendor is to e-mail this spreadsheet to appropriate SCA/IA and Buyer. (Do NOT
            copy the PIA. The SCA/IA will consult with the PIA when necessary.)
            3. The Vendor must use drop down boxes where available (green cells) to keep data
            consistent.

            4. If multiple issues exist for one PO, the Vendor must list the same PO again in a
            separate column to the right of the first issue. Each issue must be listed in a separate
            column with the exception of Factory Information . Factory Information can be listed
            all in the same column to save space/columns on the spreadsheet.


            5. The SCA/IA will review the requests with the Buyer and respond to the Vendor by
            placing comments at the bottom cells of the spreadsheet and e-mailing it back to the
            Vendor, PIA and Sande Jaksha. SCA/IA will note when issue is CLOSED.
            6. The SCA/IA turnaround time for resolving all issues = 48 hours from the time the e-
            mail is received from the Vendor (some issues require overnight system processing to
            occur before PO can be re-issued.)
            7. If an issue is not resolved after 48 hours from the issue being e-mailed, the Vendor is
            to then highlight the column for the issue in RED on the template and re-send to the
            SCA/IA and Buyer for immediate response.



            Color Key:
 VENDOR      GREEN     = VENDOR Must Use Drop Down Box For This Field
 VENDOR       BLUE     = VENDOR REQUIRED FIELDS
  SCA/IA      RED      = SCA/IA to Update after Buyer Approves
   PIA      YELLOW     = PIA to Update after Buyer Approves
Warehouse                                          Facility #
HEB Low Velocity Warehouse                         (17)
5914 Distribution Drive
San Antonio, TX 78218

Seasonal Warehouse                                 (21)
4700 N. Pan Am Expressway
San Antonio, TX 78218

San Antonio Combo Retail Support Center            (23)
5103 Rittiman Road
San Antonio, TX 78218

San Antonio Frozen Retail Support Center           (25)
4700 N. Pan Am Expressway
San Antonio, TX 78218

San Antonio Perishables Support Center             (26)
4700 N. Pan Am Expressway
San Antonio, TX 78218

San Antonio Grocery Retail Support Center          (27)
4700 N. Pan Am Expressway
San Antonio, TX 78218

San Antonio Pharmacy Support Center                (28)
6520 Fratt Road
San Antonio, TX 78218

San Antonio Produce Retail Support Center          (29)
5103 Rittiman Road
San Antonio, TX 78218

San Antonio/Mexico Retail Support Center           (30)
4300 Industry Park
San Antonio, TX 78218

Corpus Christi Grocery Support Center              (37)
Highway 44 & McBride Lane
Corpus Christi, TX 78408

San Marcos HHB Retail Support Center               (44)
2301 Hunter Road
San Marcos, TX 78666

Corpus Christi Seasonal Frozen                     (51)

San Antonio Seasonal Frozen                        (52)

San Antonio Combo Seasonal Support Center          (53)
4300 Industry Park
San Antonio, TX 78218

HEB Seasonal Retail Support Center                 (57)
4300 Industry Park
San Antonio, TX 78218

Houston Seasonal Retail Support Center             (70)
4625 Windfern
Houston, TX 77080

Houston Combo Retail Support Center                (73)
4625 Windfern
Houston, TX 77080

Houston Frozen Food Retail Support Center          (75)
4625 Windfern
Houston, TX 77080
Houston Perishables Retail Support Center          (76)
4625 Windfern
Houston, TX 77080
Houston Grocery Retail Support Center              (77)
4625 Windfern
Houston, TX 77080

Houston Produce Retail Support Center              (79)
4625 Windfern
Houston, TX 77080

Direct Store Delivery (DSD)
***999 will be filled with HEB Corporate Store #
3c422e9f-4f04-4cda-b183-b50136de9851.xls                                                                                                                                                                      12/13/2010
Drop Down Source Boxes

H-E-B Import PO Maintenance Tracking Spreadsheet - Import Vendors (Non-L&F)
What Changed?                     Reason for Change?                                                                                                SCA # / SCA Name        Whse # Leave Blank-Misc Vendors
Ship Date                         Ship Date Change-Vendor Did Not Book On Time                                                                      01 JAMES BEERE              57
Case UPC                          Ship Date Change-Item Not Manufactured On Time                                                                    02 PHILLIP MERVISH          44
Item UPC                          Ship Date Change-Order Available Earlier Than Scheduled                                                           03 JOHN POWELL              17
Master Dimension Change           Ship Date Change-Not enough Lead time                                                                             05 DAVE PHELAN              23
Inner Dimension Change            Ship Date Change-Weather Delay                                                                                    06 LIZ JAMES                25
VPC (Mfg Code)                    Ship Date Change-Production Problems                                                                              08 ELLEN MILLS              26
Inner Pack                        Ship Date Change-Vendor Did Not Receive PO                                                                        09 REBEKAH WHITE            27
Master Pack                       Order Quantity Change-PO Overweight (Weighs Out Before Cubing Out)                                                11 JEANNIE LOPEZ            29
Port                              Order Quantity Change-PO Cubes Out Before Weighing Out                                                            15 MAGGIE HALBARDIER        30
Item Cancelled                    Order Quantity Change-Not Per Vendor/BDM Agreement                                                                16 Marcela Mercadillo       22
Container Size                    Order Quantity Change-Did Not Meet MOQ                                                                            17 Russ Sunn                37
Order Quantity                    Case UPC Changed Per Vendor                                                                                       18 Pam Campbell             49
FOB Cost                          Item UPC Changed Per Vendor                                                                                       20 D.Marshall               72
Description                       VPC (Mfg Code) Changed Per Vendor                                                                                 21 J. HALLINAN              73
Pre-Price                         Master Dimensions Changed Per Vendor                                                                              22 James Gorzell            75
HTS Code                          Inner Dimensions Changed Per Vendor                                                                               24 Andrew Martin            76
Item Color                        Pack Changed Per BDM Request                                                                                      25 B. IRONS                 79
Carton Marking Color Band
Wording                           Pack Changed Per Vendor                                                                                           26 ANDREA MEGASON            77
                                                                                                                                                                            USE
                                                                                                                                                                            DROP
                                                                                                                                                                            DOWN
                                                                                                                                                                            BOX
Country of Origin                                                                                                                                                           TO
                                                                                                                                                                            SELEC
                                                                                                                                                                            T
                                                                                                                                                                            FROM
                                  Port Change-Due To Factory Change                                                                                 27 L. CRENSHAW          LIST
Sourcing Code                     Container Size Changed Per Vendor                                                                                 28 R. HOWELL
Office Code                       Item Cancelled-Item No Longer Being Manufactured                                                                  30 MARIE MOODY
Payment Method                    Item Cancelled-Vendor Temporarily Out Of Stock                                                                    31 Cheryl Gomez
FACTORY INFORMATION (All New
FACTORY Info For An Item Can Be
Listed In This Column)            Item Cancelled-Vendor Has Raw Material Issue                                                                      32 TERESA RAMOS
USE DROP DOWN BOX TO
SELECT FROM LIST                  Item Cancelled-Vendor Not Making Item ThisYear After All                                                          33 Karen Gallagher
                                  Item Cancelled - Failed Item Inspection                                                                           34 PAM EVINS
                                  Item Cancelled - Failed QA Testing                                                                                35 GLENN ORTHAUS
                                  FOB Cost Changed Due To Materials Change                                                                          36 Linda Bonner
                                  FOB Cost Changed Due To FCL Pricing vs CFS Pricing                                                                37 PATRICE O'NEAL
                                  FOB Cost On PO Does Not Match Quote Sheet                                                                         40 Jennifer Wyle
                                  Description Change Due to Item Specification Change                                                               41 Wanda Polasek
                                  Pre-Price Not On Purchase Order                                                                                   46 TINA WEST
                                  HTS Code Was Blank On Item When PO Was Issued - HEB ACTION: Review HTS w/CK Logistics First Then
                                  Add Validated HTS Code To Item.                                                                                   47 MARK BROWN
                                  HTS Code Inaccurate When PO Was Issued - HEB ACTION: Review HTS w/CK Logistics First Then Add
                                  Validated HTS Code To Item.                                                                                       48 JAMES BEERE
                                  Item Color Was Blank When PO Was Issued - HEB ACTION: Add Color To Item.                                          49 D. LOZANO
                                  Item Color Changed at Vendor's Request - HEB ACTION: Remove Old Color Add New Color To Item.                      53 LAYNE SEDATE
                                  Item Color Changed at Buyer's Request - HEB ACTION: Remove Old Color Add New Color To Item.                       54 JOHN HACHOLSKI
                                  Carton Marking Color Band Wording Was Blank When PO Was Issued - HEB ACTION: Add Carton
                                  Marking Color Band Wording To Item.                                                                               62 Belinda Hawkins
                                  Carton Marking Color Band Wording Changed - HEB ACTION: Revise Carton Marking Color Band Wording
                                  On Item.                                                                                                          64 John Griffin

                                  Country Of Origin Was Blank On Item When PO Was Issued- HEB ACTION: Add Country Of Origin To Item                 65 MIKE EARDLEY
                                  Country Of Origin Inaccurate On Item When PO Was Issued- HEB ACTION: Update Existing Country Of                                           Name Box =
                                  Origin On Item                                                                                                    69 Janet Moy            Whse



Name Box = What Changed           Sourcing Code Was Blank On Item When PO Was Issued - HEB ACTION: Add Sourcing Code To Item.                       81 K. STEVENS
                                  Sourcing Code Inaccurate When PO Was Issued - HEB ACTION: Update Existing Sourcing Code.                          84 KENNETH SUTHERLAND
                                  Office Code Was Blank On Item When PO Was Issued - HEB ACTION: Add Office Code To Item.                           86 Teralyn Martinez
                                  Office Code Inaccurate When PO Was Issued - HEB ACTION: Update Existing Office Code.                              87 VINCE WALKER
                                  Payment Method* Was Blank When PO Was Issued *Payment Method Must Be WT Wire transfer. LC must have approval
                                  of H-E-B Global Sourcing.                                                                                         88 Alice Wood
                                  Payment Method* Inaccurate When PO Was Issued *Payment Method Must Be WT (Wire Transfer). LC must have approval
                                  of H-E-B Global Sourcing.                                                                                         90 CINDY MANN
                                  All Factory Info Was Blank On Item When PO Was Issued (Requires Updated Quote Sheet From Vendor
                                  Showing All Factory Info) - HEB ACTION: Add Factory To Item.                                                      91 Judi Marshal
                                  Some Factory Info Missing When PO Was Issued (Requires Updated Quote Sheet From Vendor Showing
                                  All Factory Info) - HEB ACTION: Update Existing Factory Info.                                                     92 Cory Oliver
                                  Factory Info Inaccurate When PO Was Issued (Requires Updated Quote Sheet From Vendor Showing All
                                  Factory Info) - HEB ACTION: Update Existing Factory Info.                                                         93 Jaime Buentello
                                  Permanent Factory Change (Requires Updated Quote Sheet From Vendor Showing All Factory Info) -
                                  HEB ACTION: Remove Old Factory From Item, Add New Factory To Item.                                                95 STACY WHEATON
                                  Item Is Manufactured In >1Factory (Requires Updated Quote Sheet From Vendor Showing All Factory                   USE DROP DOWN BOX TO
                                  Info) - HEB ACTION: Add Additional Factory & Keep Existing Factory On The Item                                    SELECT FROM LIST
                                  USE DROP DOWN BOX TO SELECT FROM LIST

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:48
posted:12/13/2010
language:English
pages:13
Description: China Import Purchase Order document sample