FirstSource III - RFP_Attachment 3 Transactional Data Report.xlsx

Instructions

Every FirstSource III Contract Holder must submit this report by the due date and in accordance with the instructions below.

• Complete cells outlined in red. Cells outlined in black will automatically populate.

• Do not change the format of the template or the formulas within the template (e.g. do not change column headers or the order of columns)

• Save the file name in this format:

TDR [MONTH_YEAR] [CONTRACT NUMBER] [COMPANY NAME]

• Awards of any and all orders that were issued during this reporting period should be included, regardless of delivery or invoice status.

• Please read the data field notes and definitions for guidance.

70B04C19D00000023 XYZ Company 1/1/2021 - 1/31/2021

Award Vehicle The DHS designated name of the award vehicle. This field has been pre-populated in the template.

Contract Number (IDVPIID) This is the DHS issued contract number for the FSIII contract. This number can be found on the contract form, SF 1449, item no. 2. Choose the correct number from the drop down list.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, i.e. the contract number. Example: 70B04C19D00000023

Note: This number should be the same for this field for all line items. There are no spaces or dashes within the award number.

Socio-Economic Category This field should include the socio-economic track within which the company received a contract award. In a SF 1449, see item no. 10. In an OF 347, see item no. 11. This field will populate after choosing contract number.

Vendor Name This field should include the company name as reflected on your contract award document. The data in this field should be consistent throughout your data report. This field will populate after choosing contract number.

DUNS Data Universal Number System (DUNS) number. This field will populate after choosing contract number.

Order Number (Award PIID) This is the order number issued by the specific ordering Component. This should be a unique number and differs from the Contract Number. If a SF 1449 form is used, see item no. 4. If an OF347 is used, see item no. 3. Purchase card transactions should include the last four digits of the purchase card instead of an order number. Example: 70FA5019F00000118 Note: This number should be unique for every order. Every agency may have a slightly different numbering format. There are no spaces or dashes within the order number

NAICS Code The North American Industry Classification System (NAICS) code associated with the IDIQ contract award. This field will populate after choosing a contract number.

Purchase Card Transaction Indicate if a purchase card was used for this order. Either a purchase card OR a delivery/task order will be issued. Yes: Purchase Card used for payment No: Task or Delivery Order issued

Contract Type Pricing structure of order. A hybrid contract type is a combination of the other three contract types. In a SF 1449, see item no. 20. In an OF 347, see item no. 17b. Choose from drop down list. FFP: Firm Fixed Price LH: Labor Hour TM: Time-and-Material Hybrid

DHS Reverse Auction Marketplace Indicate if the DHS Reverse Auction Marketplace (www.TBD.com) is used to compete and/or award individual orders. Choose from drop down list. Yes: DHS Reverse Auction Marketplace Used No: Solicitation Received via Email

DHS Reverse Auction Marketplace Fee If DHS Reverse Auction Marketplace is used, indicate associated fee. Accounting format

Department The name of the Department who issued the order. This field has been pre-populated in the template. These contracts are authorized for use only by the Department of Homeland Security.

Component or Office Choose the name of the specific component or office of the issuing agency/ Department from the drop down list. For a SF1449, see item no. 9 or 15. For an OF 347, see item no. 5 or 10. CIS: U.S. Citizenship and Immigration Service CISA: Cybersecurity and Infrastructure Security Agency CBP: U.S. Customs and Border Protection HQ: DHS Headquarters, including Management Directorate, Ops, CWMD, I&A, and S&T FEMA: Federal Emergency Management Agency FLETC: Federal Law Enforcement Training Centers ICE: U.S. Immigration and Customs Enforcement TSA: Transportation Security Administration USCG: United States Coast Guard USSS: United States Secret Service

Date of Award Date the order is effective. For a SF1449, see item no. 3. For an OF347, see item no. 1. Purchase card orders should use the order date. Date Format: MM/DD/YYYY

Note: Please do not include the time

Start Date Period of Performance start date. For a SF1449, see item no. 20. For an OF347, see item 17b. Credit card orders should include order date, which in most cases, will be both the initial award date and the start date. Date Format: MM/DD/YYYY

Note: Please do not include the time

End Date Period of Performance end date. For a SF1449, see item no. 20. For an OF347, see item 17b. For Credit Card orders: if the End Date (government received date) is greater than the Start Date + 15 days, provide a tracking receipt that shows the Delivery date. Date Format: MM/DD/YYYY

Note: Please do not include the time

Award Amount The total award amount, inclusive of all option quantities and periods of performance. For a SF1449, see item no. 20. For an OF347, see item 17b. Base plus option line item dollar amounts. Do not enter CLIN dollar amounts in this column. Accounting format

Discounts per Order The total discounts for the order. This is the difference between the commercial price and the DHS order price for the entire order. This should be the aggregate of the discounts for each line item. Accounting format

Commercial Unit Price Commercial list or catalog price. Accounting format

DHS Order Unit Price The price awarded per unit for the specific order. In a SF 1449, see item no. 23. In an OF 347, see item no. 17e. This price should not exceed the commercial price. If so, an explanation is needed.

Unit of Measure Choose the unit of measure from the drop down list. Each Hour Lot Month

Total Unit Price The DHS Order Price per unit multiplied by the quantity of item sold. This value is automatically calculated.

Supply/Service Description Description of the specific item or service provided.

Only list items for which funds have been obligated in the award document. Unexercised options should be not be reported. Options will be reported as modifications when they are exercised in the month that the modification occurs, which may be weeks or years after original award. This is a free text field.

Item Example: "Laptop Computer" Services Example: "IT Project Manager"

NOTE: Specific line item data should be reported in this field. If an order is structured in such a way that multiple services or products are consolidated or bundled into one CLIN for the order, the contractor should list those services/products individually as separate supplies or services in this report, to the extent practicable.

Example:

Delivery Order:

CLIN 0001 Server

TDR Format:

Row 1: Server Chassis Row 2: Network License Row 3: Power Supply

Manufacturer Enter the Manufacturer's name. Example: HP

Manufacturer Sku Enter OEM part number. Each different OEM should be listed in a separate row. Example: W2020A

Modification Number (if applicable) Indicate the modification number for the order, if applicable. Modifications should be recorded when additional quantities or services are funded in the reporting period. Example: P00001

Commodity Category The definitions of commodities are provided in contract section C.3. Choose the appropriate commodity category from the drop down list. Small Form Factor Device Static Device Domain Device Virtual Desktop Infrastructure (VDI) Peripheral Device Software Value Added Reseller (VAR)

Per Item Discount Difference between the Commercial Price and the DHS Order Price This value is automatically calculated.

Extended Item Discount The Per Item Discount multiplied by the Quantity of Item Sold This value is automatically calculated.

Total Obligation Amount The funding obligated by all components during the reporting period. This value is automatically calculated.

Monthly Discount Amount The total value of discounts received in all orders awarded during the reporting period. This value is automatically calculated.

Total Number of Orders The total number of orders awarded during the reporting period. This value is automatically calculated.

Discounts to Date on Contract The total value of discounts received in all orders since the initial contract award. Accounting format

FSIII Order Information FirstSourceIII Transactional Data Report

Data Element Descriptions *Refer to the instructions for each of the data elements in the report template. If you have questions on any data element, please contact the solution manager. Please do not make assumptions on completing any data element or field.

*Formatting Requirements:

• Provide this report in .xls or .csv format

• Do not change the format of the template (e.g. do not change column headers or the order of columns)

• Save the file name in this format: MSMR [DATE] [CONTRACT NUMBER] [COMPANY NAME] *Reporting Period: TBD

* Do not change any formulas for any column highlighted in red without obtaining prior approval from FSIII Category Manager at DHS SSO

Award Vehicle Contract Number (IDVPIID) Socio- Economic Category Vendor Name Pennel, Amanda: Definition:

This field should include the company name as reflected on your contract award document. The data in this field should be consistent throughout your data report.

Note: Please do not use abbreviations or acronyms unless that is reflected in your company name on your contract award document. DUNS Pennel, Amanda: Definition:

Enter the official DUNS number.

Pennel, Amanda: Definition:

This field should reflect the name of the agency who issued the order.

This field has been pre-populated in the template. These contracts are authorized for use only by the Department of Homeland Security. Component Order/Award Date Pennel, Amanda: Definition:

Date the order is effective. For a SF1449, see item no. 3. For an OF347, see item no. 1.

Date Format: MM/DD/YYYY

[Contract Number] [Contractor Name] [Reporting Period]

FSIII Products and Services Award Vehicle Contract Number (IDVPIID) Order Number (Award PIID) Vendor Name Department Quantity of Units Sold Commercial Unit Price DHS Order Unit Price Unit of Measure Total Unit Price Supply/Service Description Award Date Manufacturer DUNS Manufacturer Sku Socio- Economic Category Modification Number (if applicable) Pennel, Amanda: Definition:

Indicate the modification number for the order if applicable. NAICS Code Commodity Category Component Per Item Discount Extended Item Discount Total Baseline Price Pennel, Amanda: Definition:

The baseline price per unit (column L) multiplied by the quantity of item sold (column N). Savings Achieved (Baseline - Award) Pennel, Amanda:

Summary

Vendor Information