Final Draft Solicitation Ascend BPA Attachment 3 Prices Paid Transaction Report Data Elements.pdf

Attachment 3: Prices Paid Transaction Report Data Elements

1. Firm Fixed Price (FFP), Requirements Task Order (RTO), Labor Hour (LH)

1.1. Required Data Elements

The contractor's FFP, RTO, and LH invoices shall include the following minimum-required data elements as follows:

Data elements that have no value or are NA shall have a value of "NULL."

Table 1: Invoicing FFP, RTO, LH Required Data Elements

Data Element Format Examples / [Valid Values]

Notes

Eligible User Text Entity/agency name;

state, local, tribal, territorial entity name.

1. Identifies the full name of the eligible user (e.g., no abbreviations or acronyms).

Sub or Component Agency/Entity

Text Entity/agency name;

state, local, tribal, territorial entity name.

1. Identifies the full name of the sub- or component-eligible entity (e.g., no abbreviations or acronyms).

Customer POC email

Alphanumeric john.smith@123.com

Customer POC Telephone Number

Numerical (10 Numbers)

123-456-7890 1. Identifies an operational telephone number within the sovereignty of the US.

GSA UEI Alphanumeric (12 Characters)

A1B2C3D4E5F6 1. The authoritative identifier for entities (i.e., CSP, reseller) doing business with the federal government.

Table 1: Invoicing FFP, RTO, LH Required Data Elements

Data Element Format Examples / [Valid Values]

Notes

GSA MAS Contract Number

Alphanumeric (10 or 13 Characters)

GS-35F-XXXXX,

47QTCAXXXXXXX

BPA Award Number Alphanumeric (13 Characters)

47QTCAXXXXXXX 1. The administrative agency will provide the "BPA Award Number" to contractors.

TO Award Number Alphanumeric (13 Characters)

A1B2C3D4E5F6G 1. The eligible user will provide the "TO Number" to contractors.

BPA Pool and Sub- Pool Number

Text 1-1, 2-1 1. The first character identifies the "Pool" number.

2. The second character identifies the "Sub-Pool" number.

TO PoP Numerical 00, 01, 02, 03 1. "00" represents the base period.

2. "XX" represents an option period (e.g., 01, 99).

TO PoP Start Date YYYY MM DD 2022 01 01

TO PoP End Date YYYY MM DD 2022 12 31

TO CLIN Numerical, Alphanumeric

1001, 0001A, A001

TO Sub-CLIN Numerical, Alphanumeric

1001.01, 0001A-AA,

A001-01

1. Applicable to RTOs only.

TO CLIN / Sub- CLIN Type

Text [FFP, LH, OLM, RTO,T&M]

CSP Name Text Cloud Inc. 1. Identifies the full legal business name (i.e., no

Values]

Notes abbreviations or marketing names).

Cloud Service Name

Or

Cloud-Related IT Professional Service

Text General Compute, Large Server

Or

Cybersecurity, Forensics

1. Identifies the name of the "service" (e.g., CSO).

2. Identifies the labor category title.

CSP Universal Identifier

Cloud-Related IT Professional Service Code

Text, Numerical, Alphanumeric

ABCDEFGHI,

1234567890, A1B2C3D4E5F6

1. Identifies the CSPs' unique code (e.g., UPC) for each "service."

2. The "Universal Identifier" shall be the CSPs' identifier without alteration (e.g., modification).

3. The "Universal Identifier" shall be universal across the CSPs' commercial and public (e.g., government) customers.

4. The "Universal Identifier" for each "service" shall match the contractor’s GSA MAS catalog, Ascend BPA service catalog, and Ascend TO service catalogs.

5. The administrative agency will provide the "Cloud-Related IT Professional Service Codes."

Cloud Service Start Date

YYYY MM DD 2022 07 01 1. Identifies the date that the "service" began incurring costs (e.g., billable start date) within the invoice period.

Values]

Notes

Service Start Date

2. Identifies the date that the "Cloud-Related IT Professional Service" began incurring costs (e.g., billable start date) within the invoice period.

Cloud Service End Date

Service End Date

YYYY MM DD 2022 07 31 1. Identifies the date that the "service" stopped incurring costs (e.g., billable start date) within the invoice period.

2. Identifies the date that the "Cloud-Related IT Professional Service" stopped incurring costs (e.g., billable start date) within the invoice period.

BPA Catalog Cloud Service Price

BPA Catalog Cloud- Related IT Professional Service Price

Currency $5.4321 1. All currency values are to be denominated in US currency (i.e., US dollars).

And

2. Identifies the "service price" from the contractor’s BPA catalogs.

3. Identifies the price for the "service" out to four (4) decimal places (i.e., ten-thousandths).

4. Identifies the "Cloud-Related IT Professional Service Price" from the contractor’s BPA catalogs.

Values]

5. Identifies the price for the "Cloud-Related IT Professional Service" out to two (2) decimal places (i.e., hundredths).

TO Cloud Service Price Discount

TO Cloud-Related IT Professional Service Price Discount

Percentage 8.5%, 12% 1. If eligible users received price discounts from the contractor’s BPA service catalogs, the percentage discount shall be listed.

2. If the eligible user received individual and discrete prices, a value of "Null" shall be entered.

Price

Service Price

Currency $5.4321 1. All currency values are to be denominated in US currency

2. Identifies the "TO Cloud Service Price" after applying discounts from the contractor’s TO catalogs or definitized TO prices.

3. Identifies the price for the "TO Cloud Service Price" out to four (4) decimal places (i.e., ten-thousandths).

4. The "TO Cloud Service Price" must be equal to or less than the "BPA Service Price."

5. Identifies the "Cloud-Related IT Professional Service Price" based on discount from the contractor’s TO catalogs or definitized TO prices.

6. Identifies the price for the "Cloud-Related IT Professional

7. The "TO Cloud-Related IT Professional Service Price" must be equal to or less than the "BPA Cloud-Related IT Professional Service Price."

Unit of Measure Text Compute per Hour, Labor Hour, Subscription, Transaction

Quantity Numerical 1, 1.5, 25, 1,234

Total Price Currency $56.98 1. Identifies the "Total Price" in US currency (i.e., US dollars).

2. "Total Price" = "TO Cloud Service Price" x "Quantity"

3. Identifies the "Total Price" for "TO Cloud Service" out to

5. "Total Price" = "TO Cloud-Related IT Professional Service Price" x "Quantity"

6. Identifies the "Total Price" for "Cloud-Related IT Professional Service" out to two (2) decimal places (i.e., hundredths).

1.2. Optional Data Elements

The contractor’s FFP, RTO, and LH invoices may include the following optional data elements as follows:

Data elements that have no value or are NA shall have a value of "NULL".

Table 2: Invoicing FFP, LH Optional Data Elements

Data Element Format Examples / [Valid Values]

Notes

SKU Text, Numerical, Alphanumeric

ABCDEFGHI,

1234567890, A1B2C3D4E5F6

2. Order Level Materials (OLM), Time and Materials (T&M)

2.1. Required Data Elements

The contractor’s OLM and T&M invoices shall include the following minimum-required data elements as follows:

Data elements that have no value or are NA shall have a value of "NULL."

Table 3: Invoicing OLM, T&M Required Data Elements

Data Element Format Examples / [Valid Values]

Notes

Ceiling Price

Service Ceiling

Currency $5.4321 1. All currency values are to be denominated in US currency

2. Identifies the "service price" based on discounts from the

Table 3: Invoicing OLM, T&M Required Data Elements

Values]

Price contractor’s BPA catalogs or discrete TO prices.

3. Identifies the price for the "service" out to four (4) decimal places (i.e., ten-thousandths).

4. The "TO Service Ceiling Price" must be equal to or less than the "BPA Service Price."

5. Identifies the "Cloud-Related IT Professional Service Price" based on discount from contractor’s TO catalogs or negotiated discrete prices.

6. Identifies the price for the "Cloud-Related IT Professional

7. The "TO Cloud-Related IT Professional Service Ceiling Price" must be equal to or less than the "BPA Cloud-Related IT Professional Service Price."

Direct Costs1 Currency $6.75 1. All currency values are to be denominated in US currency

2. Identifies the summation of all allowable "Direct Costs" for the "Service" and "Cloud-Related IT Professional Service."

3. Identifies the "Direct Costs" for " Service" out to four (4)

1 FAR 16.601 Time-and-Materials (T&M) Contracts

Values] decimal places (i.e., ten-thousandths)

4. Identifies the "Direct Costs" for "Cloud-Related IT Professional Services" out to two (2) decimal places (i.e., hundredths).

Indirect Costs2 Currency $9.34 1. All currency values are to be denominated in US currency

2. Identifies the summation of all allowable "Indirect Costs" for the "Services" and "Cloud-Related IT Professional Service."

3. Identifies the "Indirect Costs" for "Services" out to four (4) decimal places (i.e., ten-thousandths).

4. Identifies the "Indirect Costs" for "Cloud-Related IT hundredths).

Fixed Handling Factor3

Currency $2.45 1. All currency values are to be denominated in US currency

2. Identifies the TO negotiated "Fixed Handling Factor" for the "Service" and "Cloud-Related IT Professional Service."

3. Identifies the "Fixed Handling Factor" for "Services" out to

2 FAR 16.601 Time-and-Materials (T&M) Contracts 3 FAR 16.601 Time-and-Materials (T&M) Contracts

4. Identifies the "Fixed Handling Factor" for "Cloud-Related IT hundredths).

Profit4 Currency $4.15 1. All currency values are to be denominated in US currency

2. Identifies the TO-negotiated "Profit" for the "Services" and "Cloud-Related IT Professional Service."

3. Identifies the "Profit" for "Cloud Service" out to four (4) decimal places (i.e., ten-thousandths).

4. Identifies the "Profit" for "Cloud-Related IT Professional Services" out to two (2) decimal places (i.e., hundredths).

Sub-Total Price Currency 1. All currency values are to be denominated in US currency (i.e., US dollars).

2. "Sub-Total Price" = "Direct Costs" + "Indirect Costs" + "Fixed Handling Factor" + "Profit."

3. Identifies the "Sub-Total Price" out to two (2) decimal places (i.e., hundredths).

Unit of Measure Text Labor Hour, Flight

Quantity Numerical 1, 1.5, 25, 1,234

4 FAR 16.601 Time-and-Materials (T&M) Contracts

Values]

Notes

Total Price Currency $56.98 1. All currency values are to be denominated in US currency

2. "Total Price" = ("Direct Costs" + "Indirect Costs" + "Fixed Handling Factor" + "Profit") x "Quantity."

3. Identifies the "Total Price" out to two (2) decimal places (i.e., hundredths).