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
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.
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
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
Column F: Also, enter contact details at the organization which established the LTA
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
Your name YOURNAME
Name of your Organization YOURAGENCY Please read the instructions contained in the sheet '1. Instructi
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
Page 2 of 13
Page 3 of 13
ed in the sheet '1. Instructions'!
ADDRESS (PHONE &
LTA NO. STATUS
EMAILS) & CONTACT
Page 4 of 13
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
* 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.
Electronic hardware and
32130000 component parts and
81110000 Computer services
Computer Equipment and
Office machines and their
supplies and accessories
Printing and publishing
25100000 Motor Vehicles
Laboratory supplies and
Laboratory and scientific
55100000 Printed Media
80120000 Legal Services
80130000 Real Estate Services
80140000 Marketing and distribution
Storage and Mail Services
Food Beverage and
56000000 Furniture and Furnishings
Building and Facility
72100000 maintenance and repair
72150000 construction and
14110000 Paper products
Fuels and Fuel additives
15000000 and lubricants and
anti corrosive materials
Security surveillance and
Camping and outdoor
49120000 equipment and
70170000 development and
Education and Training
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
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
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
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.