Attachment 5- Quarterly Contractor Data Report Template.xlsx

Instructions

Every BCD Contract Holder must submit this report by the due date and in accordance with the instructions below. Transactional data should be submitted by the prime contractor of an order only.

• 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:

BCD-company name-contract number-TDR "Quarter Start Date"_"Quarter End Date" EXAMPLE: BCD-AB Company-XX8342- TDR 10012024_12312024

Submission Instructions: Email the completed data report to:

•BCD_Reporting@hq.dhs.gov

Reporting Period: Quarter Start Date to Quarter End Date The data report shall include all transactions within this specified reporting period.

Considerations Please take note of the following considerations:

• Transactions from any and all orders that were executed during this reporting period should be included, regardless of delivery or invoice status. During the last TDR, some reports only included items that have been delivered or paid. This is incorrect.

• Please read the data field notes and definitions. There should only be one entry for baseline price per unit that is based either on your ceiling price or commercial or GSA price.

Contract Number (IDVPIID) This is the DHS issued contract number for your BCD contract. This number can be found on the contract form, SF 1449, item no. 2.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, ie. 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.

Order Number (Award PIID) This is the order number issued by the ordering agency for each transaction. This differs from the Contract Number. If an SF 1449 form is used for the order, the order number can be found in item no. 4. If an OF347 is used, the order number can be found in item no. 3. 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

Modification Number (if applicable) Indicate the modification number for the order if applicable.

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. Note: Please do not use abbreviations or acronymns unless that is reflected in your company name on your contract award document.

UEI Unique Entity Identifier (ID). UEI is an is a 12-character alphanumeric ID assigned to an entity by SAM.gov.

Note: Please do not use abbreviations or acronymns.

If an agency not listed is granted ordering authority for a specific order, please list the full name of the agency.

Component or Office This field should reflect the name of the component or office of the issuing agency/ Department.

Example: U.S. Customs & Border Protection

Note: Please do not use abbreviations or acronymns. Every DHS transaction should have an associated component. If the component/office is unknown for other authorized agencies, leave the field blank.

Order Date / Date of Award Date the order is effective. For a SF1449, see item no. 3. For an OF347, see item no. 1. Date Format: MM/DD/YYYY

Note: Please do not include the time

Delivery Date Date when this item was delivered. Date Format: MM/DD/YYYY

Note: Please do not include the time

Baseline Price Per Unit (Contract Ceiling Price) Include the contract ceiling price per unit if available. If this price is available, this is the baseline price to be used. Skip the field for column K. DO NOT include data in both column J and column K. There should only be one baseline price used.

Baseline Price Per Unit (GSA or Commercial List Price) If a contract ceiling price is not available, include the GSA price per unit of measure or the commercial List price if a GSA price is not available DO NOT include data in both column J and column K. There should only be one baseline price used.

Award Price Per Unit The price awarded per unit for the specific order This price should not exceed the baseline price. If so, an explanation is needed.

Quantity of Item Sold The total number of units. Input in general numerical form (e.g. 10, 100, 10,000)

Unit of Measure Unit of measure that represents how the quantity of item sold is counted (e.g. each, lot, hour, year, pound, etc). Units should be spelled out, not abbreviated. For example, input "each' not "ea"

Description of Deliverable Description of item or service purchased This is a free text field. Include CLIN information Please input data without use of abbreviations.

SKU/ Part Number The part number or SKU number associated with the particular item.

Manufacturer Name The name of the manufacturer of the item Please input data completely; no abbreviations.

BCD Quarterly Data Rprt BCD 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: BCD-company name-contract number-TDR 1 Quarter Start Date to Quarter End Date *Reporting Period: Quarter Start Date to Quarter End Date

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

Pennel, Amanda:

Do not edit the formulas in the BLUE cells (N5, O5, or P5) $0.00 $0.00 $0.00 Pennel, Amanda:

Do not edit the formulas in the BLUE cells (T5 or U5). ERROR:#DIV/0!

Award Vehicle Contract Number (IDVPIID) Pennel, Amanda: Defintion:

This is the DHS issued contract number for your TacCom II contract, Technical Category 1. This number can be found on the contract form, SF 1449, item no. 2.

IDVPIID is a term used in the Federal Procurement Data System. It refers to the Indefinite Delivery Vehicle Procurement Instrument Identifier, ie. the contract number.

Example: 70B04C19D00000023 Note: This number should be the same for this field for all line items. Order Number (Award PIID) Pennel, Amanda: Definition:

This is the order number issued by the ordering agency for your TacCom II contract, Technical Category 1. This should be a unique number and differs from the Contract Number. If an SF 1449 form is used for the order, the order number can be found in item no. 4. If an OF347 is used, the order number can be found in item no. 3.

Example: 70FA5019F00000118 Note: This number should be unique for every order. Every agency may have a slightly different numbering format. Modification Number (if applicable) Pennel, Amanda: Definition:

Indicate the modification number for the order if applicable. 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 acronymns unless that is reflected in your company name on your contract award document. UEI Pennel, Amanda: Defintion:

Unique Entity Identifier (ID). UEI is an is a 12-character alphanumeric ID assigned to an entity by SAM.gov. Federal Department or Agency Pennel, Amanda: Definition:

This field should reflect the name of the agency who issued the order. Refer to instructions for the exact input for every authorized agency name.

Note: Please do not use abbreviations or acronymns.

If an agency not listed is granted ordering authority for a specific order, please list the full name of the agency.

Component or Office Pennel, Amanda: Definition:

This field should reflect the name of the component or office of the issuing agency/ Department.

Note: Please do not use abbreviations or acronymns. Every DHS transaction should have an associated component. If the component/office is unknown for other authorized agencies, leave the field blank. Order Date/ Date of Award 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

Note: Please do not include the time Delivery Date Pennel, Amanda: Definition:

Date when this item was delivered

Date Format: MM/DD/YYYY

Note: Please do not include the time Baseline Price Per Unit (Contract Ceiling Price) Pennel, Amanda: Definition:

Include the contract ceiling price per unit if available. If this price is available, this is the baseline price to be used. Skip the field for column K. Baseline Price Per Unit (GSA or Commercial List Price) Pennel, Amanda: Definition:

If a contract ceiling price is not available, include the GSA price per unit of measure or the commercial List price if a GSA price is not available Pennel, Amanda:

Do not edit the formulas in the BLUE cells (N5, O5, or P5) Award Price Per Unit ~ Should not be greater than the baseline ~ Pennel, Amanda: Definition:

The price awarded per unit for the specific order Quantity of Item Sold Pennel, Amanda: Definition:

The total number of units. Unit of Measure Pennel, Amanda: Definition:

Unit of measure that represents how the quantity of item sold is counted (e.g. each, lot, hour, year, pound, etc).

Units should be spelled out, not abbreviated. For example, input "each' not "ea" Total Awarded Price ~ Should not be greater than the total baseline ~ Pennel, Amanda: Definition:

The award price per unit (column L) multiplied by the quantity of item sold (column M). Total Baseline Price Pennel, Amanda: Definition:

The baseline price per unit (either column J or column K) multipled by the quantity of item sold (column M). Description of Deliverable Pennel, Amanda: Definition:

Description of item or service purchased

This is a free text field. Include CLIN Information. Please input data without use of abbreviations.

Pennel, Amanda:

Do not edit the formulas in the BLUE cells (T5 or U5). SKU/Part Number Pennel, Amanda: Definition:

The part number or SKU number associated with the particular item. Manufacturer Name Pennel, Amanda: Definition:

The name of the manufacturer of the item

Please input data completely; no abbreviations. Saving Achieved (Baseline - Award) Pennel, Amanda: