Docstoc

A.12.1_Template_Simple_LTA_Overview_v2

Document Sample
A.12.1_Template_Simple_LTA_Overview_v2 Powered By Docstoc
					                                9ac2625b-ea15-43d1-aa88-3b6dc53080bd.xlsx



Instructions
Having a list of locally available LTAs will support you in identifying potential savings when cooperating
with other UN organizations. This list is a necessary prerequisite for the work shop.
Please use the next sheet for collecting the data. You can adapt this template and add or delete
columns as you see fit. This document contains the most important information and this data should be
fairly straightforward to gather. A good example of how this template can be used in practice has been
shared by the Tanzania country team. Please find this example under 'Tools and Templates' at
http://www.ungm.org/Harmonization/harmonizationGuidelines.aspx.
Additional information can also be found in the Guidelines, Annex A.11
The table has 12 columns. The first five are required and it is necessary that you provide this
information. Additionally you can attach more information for each LTA captured in the following seven
columns. Although this is optional, we recommend gathering as much information as possible, as it will
later help you to establish an LTA data base.

Required
Column A: A running number starting from 1
Column B: The good or service covered by the LTA; for example "Travel Management Services" or
"Fire Extinguisher"; Please mention the category here
Column C: Provide a short description of the good or service with the most relevant information for
other organizations which would like to use this LTA. This could include certain specifications or relevant
product details, shipment and delivery information, restrictions or instructions about the use of the LTA
etc.
Column D: The name of the supplier
Column E: If you piggy-back on another organization's LTA, please enter here the name of that
organization
Column F: Also, enter contact details at the organization which established the LTA

Extended Information
Column G: If available, include the UNSPSC Code(s) or UNSSC Code(s). Please also see workbook
sheet number 3: "UNSPSC Categories".
Column H: The date when the contract was/will be established
Column I: The date when the contract was/will be expired
Column J: Contact information of the supplier
Column K: The identifier used at your organization for the LTA
Column L: The current Status of the LTA, e.g. "DUE FOR RENEWAL", "RENEWED", "AWAITING
SUPPLIER REPLY", "EXPIRED", "NEW" etc.




                                                Page 1 of 13
                                                                     9ac2625b-ea15-43d1-aa88-3b6dc53080bd.xlsx




Your name                   YOURNAME
Name of your Organization   YOURAGENCY                                                                     Please read the instructions contained in the sheet '1. Instructi
Location:                   YOURLOCATION


                                                   Required information                                                                                   Extended information

                                                                                  ESTABLISHED BY     CONTACT AT UN
          PRODUCT / GOOD     DESCRIPTION OF GOOD / SERVICE                                                               UNSPSC Code(s) (or ESTABLISHED   EXPIRY
 NO.                                                                SUPPLIER        (NAME OF UN    ORGANIZATION: NAME,
            (CATEGORY)                 (DETAILS)                                                                          UNSSC Code(s))       DATE        DATE
                                                                                   ORGANIZATION)      PHONE, EMAIL
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36




                                                                                    Page 2 of 13
     9ac2625b-ea15-43d1-aa88-3b6dc53080bd.xlsx




37
38
39
40
41
42
43
44
45
46
47




                    Page 3 of 13
                                                   9ac2625b-ea15-43d1-aa88-3b6dc53080bd.xlsx




ed in the sheet '1. Instructions'!

 tended information
            SUPPLIER CONTACT
            ADDRESS (PHONE &
                                LTA NO.   STATUS
            EMAILS) & CONTACT
                PERSONS




                                                                  Page 4 of 13
9ac2625b-ea15-43d1-aa88-3b6dc53080bd.xlsx




               Page 5 of 13
What is this table?
This table provides a sample of procurement categories using the UNSPSC naming hierarchy. In completing the Template work
either:
* choose categories from this list or,
* where these are not suitable to properly describe your significant procurement categories, use the UNSPSC
(http://www.unspsc.org/default.aspx) to identify suitable category numbers and names.


        UNSPSC
                                    Category
    Category Number



         43230000                   Software



                             Electronic hardware and
         32130000             component parts and
                                   accessories




         81110000              Computer services




                            Computer Equipment and
         43210000
                                 Accessories




                            Office machines and their
         44100000
                            supplies and accessories




                             Printing and publishing
         45100000
                                    equipment




         25100000                Motor Vehicles
            Laboratory supplies and
41120000
                    fixtures




           Laboratory and scientific
41100000
                 equipment




55100000         Printed Media




80120000        Legal Services




              Human resources
80110000
                 services




            Management Advisory
80100000
                 services




80130000     Real Estate Services




80140000   Marketing and distribution




              Transportation and
78000000
           Storage and Mail Services
           Professional engineering
81100000
                   services




             Food Beverage and
50000000
              Tobacco Products




56000000   Furniture and Furnishings



            Building and Facility
72100000   maintenance and repair
                  services

              Residental building
72110000
             construction services


            Nonresidental building
72120000
            construction services


              Heavy construction
72140000
                  services


             Specialized trade
72150000      construction and
            maintenance services



14110000        Paper products


           Fuels and Fuel additives
15000000     and lubricants and
           anti corrosive materials


           Security surveillance and
46170000
                   detection
           Camping and outdoor
49120000     equipment and
              accessories

             Water resources
70170000     development and
                oversight



           Education and Training
86000000
                  Services
 categories using the UNSPSC naming hierarchy. In completing the Template worksheet please


scribe your significant procurement categories, use the UNSPSC
 fy suitable category numbers and names.


            Included in this category as per UNSPSC
            Helpdesk or call center software, Procurement software, Human resources
             software, Project management software, Office suite software, Enterprise resource
            planning ERP software, Accounting software, Financial analysis software, Data
            base management system software, Program testing software, Object or
            component oriented development software, Enterprise application integration
            software, and etc.
            Integrated circuit lids, Heavy layer copper bare printed circuit board, Assembled
            flexible printed circuit board, Integrated circuit packages,
             Discrete component mounts, Ceramic for printed circuit board PCB substrates,
            Bare flexible printed circuit board, and etc.
            Mainframe software applications design, Personal computer PC application
            design, Operating system programming services, ERP or database applications
            programming services, Programming for Java, Programming for HTML, Internet or
            intranet server application development services, Database design, Local area
            network communications design, Mainframe administration services, Computer or
            network or internet security, Telecommunications planning services, and etc.

            Desktop computers, Computer servers, Notebook computers, Personal
            computers, Mainframe console or dumb terminals, Mainframe computers, Docking
            stations, Computer switch boxes, Computer accessory kits, Bluetooth universal
            serial bus USB adapter, Notebook computer expansion dock, Scanners,
            Keyboards, Camera based vision systems for automated data collection, Data
            acquisition system, Compact disc or digital versatile disc
            CD/DVD cleaner, and etc.

            Photocopiers, Printer or facsimile toner, Ink cartridges, Kit for printer, Print heads,
            Multifunction machines, Digital senders, Laser fax machine, Faxswitch machines,
            Paper cutting machines or accessories, Paper shredding machines or accessories,
            Weather facsimile or radiofax, Duplexer trays, Office machine trays or feeders,
            Stapler units, Copy counters, Infrared adapters, Hole punching units, Facsimile
            handsets, Printer stands, Printer cabinets, Cash registers, Pocket calculator,
            Accounting machines, Mail sealing machines, Self-inking stamp, and etc.

            Heliographic printers, Core printer, Pad printer, Printing plate press, Printing
            presses, Offset printing presses, Inkjet printer for commercial printing
            applications, Perforating machines, Ultraviolet UV rotary printer, Printing
            assemblers, Offset darkroom equipment, Printing collators or decollators, Book
            cutting machines, Book gathering machines, Paper drilling machines, Banding
            machines, and etc.
            Minibuses, Busses, Automobiles or cars, Station wagons, Minivans or vans,
            Limousines, Sports car, Dump trucks, Delivery trucks, Water trucks, Cargo trucks,
            Concrete transport truck, Fire or rescue trucks, Police vehicles, Motorcycles,
            Scooters, Quads, Ladder lift truck, Oil tank truck, Water sprinkling truck, and etc.
Laboratory diluters, Nuclear magnetic resonance NMR
tubes, Manual single channel air displacement pipetters, Electronic multichannel
pipetters, Dropping pipettes, pipette bulbs, Bottle top dispensers, Centrifuge tubes,
Multipurpose or general test tubes, Viscometer tube, Laboratory watch glasses,
Laboratory funnels, Laboratory ampoules, Laboratory glass tube, Laboratory
spatulas, Glass crucibles, Microbiology inoculation loops or needles, Microscope
lens paper, Laboratory scissors, Laboratory spoon, and etc.

Stomachers, Laboratory sprayers, Homogenizers, Liquid measuring cans,
Laboratory blenders or emulsifiers, Laboratory mills, Pestle or mortars, Fluxmeters,
Electroscopes, Magnetometers, X ray generators, Ion source, Laboratory X ray
equipment controller, Slide warmers, Infrared dryers, Entomological trays, Insect
test kits, Entomological pinning equipment, X ray diffraction equipment,
Crystallizers, Tissue processors, Plasma storage freezers, Laboratory washing
machines, and etc.
Directories, Catalogs, Newspapers, Magazines, Comic books, Leisure reading
books, Educational or vocational textbooks, Reference books, Periodicals,
Encyclopedias, Dictionaries, Law book, Code book, Instruction sheets or booklets,
Technical diagrams or drawings, Promotional material or annual reports, and etc.

Legal Research Services,Contract law services, Juvenile justice law services,
Bankruptcy law services, Real estate law, Taxation law, Government antitrust or
regulations law services, Property law services, Employment law services, and etc.

Management development,Staff recruiting services, Compensation or benefits
planning, Labor or union relations, Personnel relocation, Temporary warehouse
staff, Job evaluation service, Human resources productivity audits, Temporary
information technology systems or database administrators, Permanent marketing
staff needs, Temporary Travel Staffing, Permanent drivers, Permanent legal
staffing needs, Permanent information technology software developers,

Professional procurement services, Project administration or planning, New
business start up consultation services, Corporate mergers consultation
services, Corporate objectives or policy development, Information technology
consultation services, Government affairs and community
relations consultation service, Supply chain analysis or re engineering
services, and etc.
Residential rental, Commercial or industrial facility rental, Land leases, Real estate
brokers or agents, Sale of commercial building, Sale of residential land, Title
reconveyance services, Property management, Real estate appraisal services,
Real estate listing services, and etc.
Marketing analysis, Incentive program management service, Commodity price
forecasting, Recognition program management service, Preparation of commodity
market surveys, Internet based market research, Consumer based research or
clinics or focus groups, Market research one on one interviews, Public relation
services, In dealership strategic initiatives training, Demo or rental or used vehicle,
Point of sale materials not including printed materials,and etc.

Domestic air cargo transport, International air cargo transport, Boxcar
transport services, Livestock rail transport, Vehicle transport services,
International barge transport services, Vehicle carrier services, Air to
ocean transportation, Water transportation, Subway transportation, Customs
 bonded storage services, Self storage or mini storage services, Freight
forwarder services, Vessel docking services, Vehicle inspection service,
Transportation storage service, Heavy truck maintenance and repair, and etc.
Well engineering, Technical drawing, Structural engineering, Dam engineering,
Architectural engineering, Highway engineering, Machine tool design, Energy or
utility consulting service, Mechanical drawing, Electrical engineering services,
Electronic circuit design, General office equipment maintenance, Printing
equipment maintenance, Laboratory equipment maintenance, Production
engineering for oil or gas, and etc.
Beef, minimally processed without additions, Chicken, Veal, Pork, Shelled
 nuts or seeds, Mixed species meat, minimally processed without additions, Egg
products and substitutes from birds other than chickens, Fresh milk or butter
products, Whey, Powdered milk, Fresh herbs, Cooking sauce, Chocolate or
chocolate substitute candy, Artificial sweetening agents, Crackers, Prepared
desserts, Frozen cookie dough, Frozen prepared potatoes or rice or pasta or
stuffing, Blackcurrant juice, Apple juice, Grape juice, Cigarettes or cigars, Chewing
tobacco, Snuff, and etc.
Chairs, Sofas, Tablets, Lockers, Arm chair, Shoe racks, Furniture sets, Potty seats,
Panel assemblies or sections, Bassinets or cradles, Casegood or non modular
managerial office packages, Casegood or non modular executive
office packages, Storage for panel systems, Freestanding storage, Freestanding
tables, Desking systems related parts and
accessories, Benches, Booster seats, Footboard seating fixture, and etc.
Building maintenance services, Elevator maintenance services,Offsite construction
services,Landscaping services,Pest control services,Parking lot or road sweeping
services and etc.
Single family home new construction services, On site mobile home repair services,
New cooperative construction services, New hotel or motel construction services,
General residential construction contractor service and etc.

Grain elevator construction and remodeling service, Truck and automobile
assembly plant constructionand remodeling service, Commercial and office building
renovation and repair service, Greenhouse construction service, School building
construction service
Highway and road new construction service, Bridge construction and repair service,
Gas main construction service, Oil and gas pipeline construction service, Dam
construction service, Waterway construction service, Timber removal service, and
etc.
Heating system maintenance and repair service, HVAC mechanical construction
service, Switchgear and related devices installation service, Metal building front
installation service, Elevator front installation service, Domestic or commercial
appliance installation service, Safe or vault installation service, and etc.

Printer or copier paper, Writing paper, Graph paper, Paper pads or notebooks,
Paper pulp, Computer printout paper, Stationery, Ledger paper, Tracing paper,
Carbonless paper, Telex rolls, Digital paper, Stamp paper, Library book or
borrowings cards, Banner paper, Toilet seat covers, Paper towels, Vouchers, and
etc.
Kerosene, Diesel fuel, Aviation fuel, Coal, Ethanol, Crude oil, Coke, Peat, Biodiesel,
Cutting oil, Engine oil, Brake oil, Turbine oil, Enriched uranium, Depleted uranium,
Silicone grease, Nuclear fuel rod, and etc.
Padlocks, Cable locks, Keys, Safes, Security bars, Number locks, Door guards,
Security chains or accessories, Locking cam, Safety horns, Sirens, Door chimes,
Alarm systems, X ray baggage inspection system, Surveillance video or audio
recorders, Wireless signaler system for hearing impaired, Night vision equipment,
Security facsimile transmission equipment, and etc.
Mosquito nets, Sleeping pads, Tents, Ice chests, Pneumatic mattresses, and etc.


Water quality management, Water quality assessment services, Water testing
services, Floodplain management, Water well maintenance or
management services, Land drainage services, Pipelines maintenance or
management services, Dam maintenance or management services, Canal
maintenance or management services, and etc.
Scientific vocational training services, Agriculture and forestry and other
natural resources training services, Non scientific vocational training
services, Distance learning services, Educational exchange, Adult education,
Elementary and secondary schools, Professional schools, Military education,
Educational technology, and etc.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:9/6/2012
language:English
pages:13