70B06C22Q00000232 Attachment A - Statement of Work.pdf

Statement of Work (SOW)

Office of Trade, Operations Directorate/Planning Accountability and Evaluation Division

World Import-Export Trade Statistics

BACKGROUND INFORMATION

The U.S. Customs and Border Protection (CBP) Office of Trade (OT), Operations

Directorate/Planning, Accountability and Evaluation Division is responsible for data analysis and reporting for Trade policy and programs within CBP. OT determines the Trade Priority Areas in which enforcement resources are directed and oversees targeting activities in these areas. To assist in these targeting activities OT has a requirement to have online access to world trade import and export statistics. All work covered by the SOW shall be unclassified.

SCOPE

Within OT, the Operations Directorate/Analytic Services Branch requires web-based access to foreign trade data to support its work to report the imports/exports of many countries worldwide.

This includes, but is not limited to, Congressional inquiries; the creation of Country Profiles for use by the Commissioner and CBP executives; and requests from other entities within CBP. It is critical that the Operations Directorate/Planning, Accountability and Evaluation Division have access to the most timely, accurate foreign trade data available to meet these requirements. The system shall provide a means for viewing the world’s merchandise and trade statistics and allow users to view world trade flows for products based on the latest import and export data from official customs agency or national statistics sources. The Operations Directorate/Analytic

Services Branch conducts complex analysis on economy-wide trade matters requiring the ability to access and download large volumes of trade data. To meet the complex nature of the analytical work conducted by the Operations Directorate/Analytic Services, the trade database shall have the capability to group countries and products. These sources must consist of more than 100 countries/regions, including all the countries in the European Union (EU).

REQUIREMENTS:

The Contractor shall provide access to a web-based system with a user-friendly interface that shall provide:

a. Access to all available reporting countries, all data updates, and all Harmonized Tariff

Schedule1 (HTS) codes without restriction for an unlimited number of CBP Users with a self-registration process for new users;

b. Trade data sourced from national statistical offices of trading countries. To the extent such national sources are not available, data sourced from other reliable third parties” or similar.

1 HTS is the primary resource for determining tariff (customs duties) classifications for goods imported into the

United States

c. Capability to process unique special type queries for accessing instant reports;

d. Pre-established trade bloc groupings (e.g. European Union (EU), Economic Community of West African States (ECOWAS), etc.);

e. Ability to mix and match country groups and individual countries in one (1) query;

f. Authorization to release data generated from system reports to the any third party;

g. At maximum four (4) in-person trainings per calendar year and unlimited online training for CBP personnel as requested (see Training section of this SOW for additional requirements/details);

h. Unlimited programming assistance to extract data for reporting requirements, to include creating customized reports and customized commodity and country groupings as requested;

i. Continuous updates and revisions to the trade database and statistics based on the latest available sources and data, including new data sources and countries, at no additional cost;

j. Unlimited technical assistance in the event of a disruption of service or problems in accessing the data; and

k. The following specific functions based on user defined queries, including by country and group of countries:

1. Harmonized Tariff Schedule (HTS) codes and chapters, commodity descriptions, and custom product groupings; time series and time period by month, quarter, bi-annual or annual (including calendar and fiscal years) with the ability to define the range of months for the year;

2. Dynamic chart/graph/map/other visualization presentation of data output. Ability to download selected data and reports as Microsoft Excel files and other available file types;

3 Provide import/export summary statistics and data reports of a country or group of countries on a global scale, including top trading partners and top commodities in terms based on value and quantity;

4. Provide import/export summary data reports of specified HTS codes, commodity types, and custom product groupings on a global scale, including top import/export countries based on value and quantity;

5. Provide summary data reports of the global trade flow of a commodity or group of commodities, by different time periods and time series, country summary statistics, and HTS chapter;

6. Provide a data report of the global trade flow of a country or group of countries;

7. Provide data for the analysis of the trade origins or destinations for a specific country and determine shares and positioning;

8. Provide data for the analysis of new market entrants and spotting emerging trends;

9. Provide data for the comparison of value, quantity, and unit price for both imports and exports among countries;

10. Provide value, quantity, unit price data reports for both imports and exports.by (HTS) code or custom product groupings;

11. Provide data for the analysis of trade origin or destinations of specific states/provinces/ports/districts between countries and determine shares and positioning;

12. Ability to view commodities and their respective total values at four, six, eight or most detailed digits levels of the HTS codes;

13. Ability to sort data by country, HTS code, value, market share or percent change over time; and

14. Ability to save report requests for future use and maintain the privacy of all requests unless specifically shared by user.

TRAINING

Training will be provided as requested either virtual or on site at CBP facility in Washington, DC. Each CBP facility has its own requirements for visitors which the contractors would be required to adhere when onsite. The Government shall provide at least 14 calendar days’ notice before any in-person training event. For in-person training requests, training materials shall be provided by contractor. Travel for in-person training will not be reimbursed directly; all travel costs will be built into cost paid by Government for training.