PO Maintenance Request Form - Excel

Document Sample
PO Maintenance Request Form - Excel Powered By Docstoc
					                                                                                                                                                                                                          2/11/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 New PO
    SCA/IA          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
                          As Listed On The
  VENDOR            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
Method Must Be      Payment Method
WT (Wire            Must Be WT (Wire
Transfer). LC       Transfer). Letter of
must have           Credit (LC) requests must
approval of H-E-    have PRIOR approval of H-
B Global            E-B Global Sourcing for
Sourcing.           GM/Seasonal/Drugstore.




                                                                                                                                                       1 of 13
                                                                                                                                                                                                                                              2/11/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 New PO
   SCA/IA     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
                    As Listed On The
  VENDOR      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 #
  VENDOR      (As Liste 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    Factory
   Quote      Address          (New Quote
  Required    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
                                                                        Down Box To
                  (Use Drop Down Box To           15 MAGGIE             Select Name
  VENDOR          Select 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
                        As Listed On The
  VENDOR          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?                                                                                  Master
                   (Use Drop Down Box To                                                                         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
                  Why It                                                                                         Master Case                                                                                        Item Cancelled-                    Overweight
                  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
        PIA       Pre-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
                                                                          Down Box To
                    (Use Drop Down Box To           15 MAGGIE             Select Name
   VENDOR           Select 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
                          As Listed On The
   VENDOR           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?                                                                     Master
                     (Use Drop Down Box To                                                            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
                    Why It                                                                            Master Case                                                                         Item Cancelled-                    Overweight
                    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
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.

                    HEB Assigned
                    Factory #
   VENDOR           (As Liste 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          Factory
   Quote            Address         (New Quote
  Required          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
                                                                    Down Box To
              (Use Drop Down Box To           15 MAGGIE             Select Name
  VENDOR      Select 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
                    As Listed On The
  VENDOR      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?                                                                     Master
               (Use Drop Down Box To                                                            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
              Why It                                                                            Master Case                                                                         Item Cancelled-                    Overweight
              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:
Workgroup
Assignment:                                        Start Here
              Vendor Data
  VENDOR      Entered by Whom                 Type Your Name Here

                                                                      <<Use Drop
              SCA/IA # & Name
              As Listed On The PO
                                                                      Down Box To
              (Use Drop Down Box To           15 MAGGIE               Select Name
  VENDOR      Select 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
                    As Listed On The
  VENDOR      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?                                                                             Master
               (Use Drop Down Box To                                                                    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
              Why It                                                                                    Master Case                                                                                    Item Cancelled-                              Overweight
              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 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.
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
  VENDOR          Select 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
                        As Listed On The
  VENDOR          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)
                                                                                                                                                  Country Of                                                All Factory      Permanent     Factory Info
                                                                                                                                                  Origin                                    Payment         Info Was         Factory       Inaccurate
                                                                                                                                                  Inaccurate                                Method*         Blank On Item    Change        When PO
                                                                                        HTS Code Was                             Carton Marking   On Item       Office Code                 Inaccurate      When PO          (Requires     Was Issued
                                                                                        Blank On Item                            Color Band       When PO       Was Blank                   When PO         Was Issued       Updated       (Requires
                                                                                        When PO Was          Item Color          Wording Was      Was Issued-   On Item        Office Code  Was Issued      (Requires        Quote         Updated
                                                                                        Issued - HEB         Changed at          Blank When PO    HEB           When PO        Was Blank On *Must be WT     Updated          Sheet         Quote Sheet
                                                                                        ACTION: Review       Vendor's            Was Issued -     ACTION:       Was Issued -   Item When    (Wire           Quote Sheet      From          From
                                                                                        HTS w/CK             Request - HEB       HEB ACTION:      Update         HEB           PO Was       Transfer). LC   From Vendor      Vendor        Vendor
                  Why It                          Description                           Logistics First      ACTION:             Add Carton       Existing      ACTION:        Issued - HEB must have       Showing All      Showing       Showing All
                  Changed?                        Change Due to                         Then Add             Remove Old          Marking Color    Country Of    Add Office     ACTION: Add approval of H-   Factory Info)-   All Factory   Factory Info)
                  (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS        Color Add New       Band Wording     Origin On     Code To        Office Code  E-B Global      HEB              Info) - HEB   - HEB
  VENDOR          Select Reason From List)        Change             Purchase Order     Code To Item.        Color To Item.      To Item.         Item          Item.          To Item.     Sourcing.       ACTION: Add      ACTION:       ACTION:
   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
        PIA       NEW Description with Pail
                  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                                          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
   VENDOR           Select 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
                          As Listed On The
   VENDOR           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)
                                                                                                                                              Country Of                                                All Factory      Permanent     Factory Info
                                                                                                                                              Origin                                    Payment         Info Was         Factory       Inaccurate
                                                                                                                                              Inaccurate                                Method*         Blank On Item    Change        When PO
                                                                                          HTS Code Was                       Carton Marking   On Item       Office Code                 Inaccurate      When PO          (Requires     Was Issued
                                                                                          Blank On Item                      Color Band       When PO       Was Blank                   When PO         Was Issued       Updated       (Requires
                                                                                          When PO Was       Item Color       Wording Was      Was Issued-   On Item        Office Code  Was Issued      (Requires        Quote         Updated
                                                                                          Issued - HEB      Changed at       Blank When PO    HEB           When PO        Was Blank On *Must be WT     Updated          Sheet         Quote Sheet
                                                                                          ACTION: Review    Vendor's         Was Issued -     ACTION:       Was Issued -   Item When    (Wire           Quote Sheet      From          From
                                                                                          HTS w/CK          Request - HEB    HEB ACTION:      Update         HEB           PO Was       Transfer). LC   From Vendor      Vendor        Vendor
                    Why It                          Description                           Logistics First   ACTION:          Add Carton       Existing      ACTION:        Issued - HEB must have       Showing All      Showing       Showing All
                    Changed?                        Change Due to                         Then Add          Remove Old       Marking Color    Country Of    Add Office     ACTION: Add approval of H-   Factory Info)-   All Factory   Factory Info)
                    (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS     Color Add New    Band Wording     Origin On     Code To        Office Code  E-B Global      HEB              Info) - HEB   - HEB
   VENDOR           Select Reason From List)        Change             Purchase Order     Code To Item.     Color To Item.   To Item.         Item          Item.          To Item.     Sourcing.       ACTION: Add      ACTION:       ACTION:
    SCA/IA          OLD Ship Date
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.                                                                                                                                               WT

                    HEB Assigned
                    Factory #
   VENDOR           (As Liste 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
                                                                                                                                                                                                        HONG             KANGER        P&D
  PIA- New                                                                                                                                                                                              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                     LING
  PIA- New          Factory                                                                                                                                                                             VILLAGE,   NO. 551,            GANG
   Quote            Address         (New Quote                                                                                                                                                          HENG GANG DONGCHA              INDUSTRIA
  Required          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
  VENDOR      Select 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
                    As Listed On The
  VENDOR      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)
                                                                                                                                             Country Of                                                All Factory      Permanent     Factory Info
                                                                                                                                             Origin                                    Payment         Info Was         Factory       Inaccurate
                                                                                                                                             Inaccurate                                Method*         Blank On Item    Change        When PO
                                                                                    HTS Code Was                            Carton Marking   On Item       Office Code                 Inaccurate      When PO          (Requires     Was Issued
                                                                                    Blank On Item                           Color Band       When PO       Was Blank                   When PO         Was Issued       Updated       (Requires
                                                                                    When PO Was            Item Color       Wording Was      Was Issued-   On Item        Office Code  Was Issued      (Requires        Quote         Updated
                                                                                    Issued - HEB           Changed at       Blank When PO    HEB           When PO        Was Blank On *Must be WT     Updated          Sheet         Quote Sheet
                                                                                    ACTION: Review         Vendor's         Was Issued -     ACTION:       Was Issued -   Item When    (Wire           Quote Sheet      From          From
                                                                                    HTS w/CK               Request - HEB    HEB ACTION:      Update         HEB           PO Was       Transfer). LC   From Vendor      Vendor        Vendor
              Why It                          Description                           Logistics First        ACTION:          Add Carton       Existing      ACTION:        Issued - HEB must have       Showing All      Showing       Showing All
              Changed?                        Change Due to                         Then Add               Remove Old       Marking Color    Country Of    Add Office     ACTION: Add approval of H-   Factory Info)-   All Factory   Factory Info)
              (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS          Color Add New    Band Wording     Origin On     Code To        Office Code  E-B Global      HEB              Info) - HEB   - HEB
  VENDOR      Select Reason From List)        Change             Purchase Order     Code To Item.          Color To Item.   To Item.         Item          Item.          To Item.     Sourcing.       ACTION: Add      ACTION:       ACTION:
   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
                                                                                    The Vendor
              VENDOR                                                                would comment
              Comments                                                              here if they need
   VENDOR     Dated: 5/30/09                                                        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:
Workgroup
Assignment:

              Vendor Data
  VENDOR      Entered by Whom

              SCA/IA # & Name
              As Listed On The PO
              (Use Drop Down Box To
  VENDOR      Select 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
                    As Listed On The
  VENDOR      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)
                                                                                                                                        Country Of                                                All Factory      Permanent     Factory Info
                                                                                                                                        Origin                                    Payment         Info Was         Factory       Inaccurate
                                                                                                                                        Inaccurate                                Method*         Blank On Item    Change        When PO
                                                                                    HTS Code Was                       Carton Marking   On Item       Office Code                 Inaccurate      When PO          (Requires     Was Issued
                                                                                    Blank On Item                      Color Band       When PO       Was Blank                   When PO         Was Issued       Updated       (Requires
                                                                                    When PO Was       Item Color       Wording Was      Was Issued-   On Item        Office Code  Was Issued      (Requires        Quote         Updated
                                                                                    Issued - HEB      Changed at       Blank When PO    HEB           When PO        Was Blank On *Must be WT     Updated          Sheet         Quote Sheet
                                                                                    ACTION: Review    Vendor's         Was Issued -     ACTION:       Was Issued -   Item When    (Wire           Quote Sheet      From          From
                                                                                    HTS w/CK          Request - HEB    HEB ACTION:      Update         HEB           PO Was       Transfer). LC   From Vendor      Vendor        Vendor
              Why It                          Description                           Logistics First   ACTION:          Add Carton       Existing      ACTION:        Issued - HEB must have       Showing All      Showing       Showing All
              Changed?                        Change Due to                         Then Add          Remove Old       Marking Color    Country Of    Add Office     ACTION: Add approval of H-   Factory Info)-   All Factory   Factory Info)
              (Use Drop Down Box To           Item Specification Pre-Price Not On   Validated HTS     Color Add New    Band Wording     Origin On     Code To        Office Code  E-B Global      HEB              Info) - HEB   - HEB
  VENDOR      Select Reason From List)        Change             Purchase Order     Code To Item.     Color To Item.   To Item.         Item          Item.          To Item.     Sourcing.       ACTION: Add      ACTION:       ACTION:
   SCA/IA     OLD Ship Date


  VENDOR               GREEN


  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 #
1f909316-5912-4e1e-bb13-98abef616fda.xls                                                                                                                                                             2/11/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