Attachment 1 - FirstSource II Monthly Report Format.pdf

Component Supply/ Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S Mfg

Sku Manufacturer Initial Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per item Delta

Qty Discount Amount

Total DO Value

(including options)

Change to Total

DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount

Total Number of Orders

CIS $0.00

CBP $0.00

DHS/HQ $0.00

FEMA $0.00

FLETC $0.00

ICE $0.00

TSA $0.00

USCG $0.00

USSS $0.00

US-VISIT $0.00

Total Amount Obligated

Total Discount Amount

This component includes the following: DHS/DNDO, DHS/HQ, DHS/IA, DHS/IP, DHS/OCHO, DHS/OCIO, DHS/OCPO, DHS/OPO, DHS/RMTO, DHS/S&T

Contractor Number: HSHQDC-07-D-000??

Reporting Period: m/d/yyyy - m/d/yyyy Contractor: Company Name

SUMMARY

Monthly Obligation by Component

CIS $0.00

CBP $0.00

DHS/HQ $0.00

FEMA $0.00

FLETC $0.00

ICE $0.00

TSA $0.00

USCG $0.00

USSS $0.00

US-VISIT $0.00

Total Discount Amount

This component includes the following: DHS/DNDO, DHS/HQ, DHS/IA, DHS/IP, DHS/OCHO, DHS/OCIO, DHS/OCPO, DHS/OPO, DHS/RMTO, DHS/S&T

SUMMARY

Monthly Obligation by Component

Total Amount Obligated

Total Number of Orders

Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

N/A Email Subject line for each report

MSMR/DO Copies/Problem Resolution/EPEAT for reporting period, Contractor's FirstSource Contract number, company name and reporting month and year.

N/A

Contract Number, Order No., Modification of Contract/Order No. 2 3 10A

N/A Contracting Officers signature Signature of Government Contracting Officer 31a 22 16b

N/A Contractor created

Invoices

1) only an official contractor invoice will be accepted for an order (not an email)

2) must include the FirstSource contract number (HSHQDC-07-D-000??)

3) the date ordered/date created, an end date, a CC#, Ref# or PO# that is linked to the DO Number on the MSMR

4) a dollar total of all items ordered needs to be on the invoice

5) the number of line items on the invoice must match the number of items reported on the MSMR

6) End date needs to appear on the invoice.

Instructions for the FirstSource II Monthly Spend Management Report (MSMR) Preparation

Remarks

Three separate emails should be sent on a monthly basis. Then every quarter, a fourth email should be sent. All reports need to arrive by the 15th of a month.

Reports are processed, by the government, on a first come first received basis. The reports are:

MSMR Mar 2011, HSHQDC-07-D-000??, company name DO Copies Mar 2011, HSHQDC-07-D-000??, company name Prob Resol Mar 2011, HSHQDC-07-D-000??, company name

EPEAT Mar 2011, HSHQDC-07-D-000??, company name

An award that has a "P" or an "F" (rather than a "J") in the Contract Number/Order No. should not be reported in the MSMR.

Ex: HSHQDC-10-P-99999 is not an acceptable FirstSource award. In advance of a report that has an F or a P send an email to firstsourcereporting@hq.dhs.gov, to the FirstSource CO and the COTR with a copy of the award or the award number . We will work with the CO to get the number corrected.

Each award/invoice must have a unique number. If the same person takes multiple orders from the same component on the same day there must be a unique identifier for each order.

A future year-end number embedded in the award number cannot be reported in a prior fiscal year. Example: HSHQDC-12-J-00001 was sent to you in September 2011.

This award cannot be reported in September 2011 you will have to wait until October

2012.

Only awards that have been signed by the government Contracting Officer will be accepted. Unsigned awards will not be accepted.

Instructions for the FirstSource II Monthly Spend Management Report (MSMR) Preparation

Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

N/A DO copies Naming convention

N/A Cumulative row

This is the row where the total amounts for the Total DO Value (including options), Total Obligated Amount, Current Modification Obligated Amount and Aggregate Amount (if used) is stored

N/A Summary

Monthly Spend by Agency (old name) is now Monthly Obligated by Component (new heading name change) Total Spend Amount (old name) is now Total Obligated Amount (new name)

N/A DO Copies

Remarks

Information reported at the bottom of the MSMR Monthly Obligated by Component (new heading name change)

Total Obligated Amount (new name)

A cumulative row is not required for:

Base Awards that have no option periods and one clin

Modifications that have just one clin and no option periods are included Credit card orders that have only one item do not require a cumulative row

A cumulative row is required:

for each award that has multiple clins if there is a base year with option periods in either a base award or modification

Cumulative rows should not have any extraneous data in any of the cells. Do not place leading spaces in the first position of any of the rows.

DO Copy naming convention requires that the DO Number and Modification Number be the same on the MSMR, the award and on the DO copy. Modification numbers must be included in the DO Copy name. Base awards and modifications must be submitted as separate DO copies. DO copy names should not have dashes.

Example of DO copy naming conventions:

HSHQDC11J99999 (base Award)

HSHQDC11J99999-P00001 (modification - the dash is because a slash is an unacceptable character)

CC#-CDC-06082011 (credit card )

Copies of awards must be named exactly as they appear in the report. Credit card purchases should have a 'CC' in the front. DOs should not have dashes in the name.

Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

N/A Resubmitted MSMR MSMRs that are resubmitted due to errors

When submitting revised MSMRs increment the naming convention.

Original submission: MSMR Mar 2011 first resubmission: MSMR 4-2011 HSHQDC-11-J-000?? Contractor name v1 or rev

1. Remember to add the contractor name

ex. MSMR 4-2011 HSHQDC-11-J-000?? Contractor name Rev 3

Remarks

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

N/A Report Heading

Each report should have the following headings on three separate lines.

Contractor Number:

Contractor Name:

Reporting Period:

Example:

Contractor Number:

HSHQDC-07-D-000??

Contractor: Company Name Reporting Period:

m/d/yyyy - m/d/yyyy

A Component Indicate the Component acronym for each Delivery Order 9 or 15 5 or 10 6

Acceptable acronyms: CIS, CBP, DHS/DNDO, DHS/HQ, DHS/IA, DHS/IP, DHS/OCHO, DHS/OCIO, DHS/OCPO, DHS/OPO, DHS/RMTO, DHS/S&T, FEMA, FLETC, ICE, TSA, USCG, USSS, US-VISIT

Required for the cumulative row of a base award.

Required for the cumulative row of a modification.

B Supplier/Service

Description 20 17b 14

Short form of description preferred Required for the cumulative row of a base award.

Not required for the cumulative row of a modification.

C DO Number and

Modification Number DO and mod number or CC (credit card) number 4 3

FirstSource Credit Card

Number

DO number should not have any dashes (example:

HSBP1011J00000/P00002)

CC number can have dashes.

CC-

This information is required for the cumulative row and should contain only the DO number and Modification number if and no other information DO Numbers that have a "P" or an "F" are not valid

FirstSource award numbers.

Required for the cumulative row of a base award.

Required for the cumulative row of a modification.

E DO Type

Pricing Structure of order (Firm Fixed Price, Labor Hour, Time and Materials). 20 17b 14 FFP, LH, T&M

To record more than one DO Type, enter multiple cumulative lines

Required for the cumulative row of a base award.

Not required for the cumulative row of a modification.

F Solicitation Method Enter method that the solicitation was received (FB, EM, PC, etc.)

How the order was received Not required for the cumulative row of a base award.

Not required for the cumulative row of a modification.

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

G P/S Indicate if this is a Product or Service

Each clin will have its own P or S. The cumulative line P/S cell will be the clin with the largest dollar amount.

Not required for the cumulative row of a base award.

Not required for the cumulative row of a modification.

H Mfg. SKU Enter OEM part number

Item Description and specifications

Required for the individual clin lines.

Not required for the cumulative row of a base award.

Not required for the cumulative row of a modification.

J Initial Award Date

Indicate the initial date the delivery order was signed or the award date as indicated on the base award 31c or 3 1 16c or 3

Date the Order was placed

M/D/YYYY

no leading zeros

For Base awards, the priority to determine this date is

1) CO signature date, or

2) Date of Order or Effective Date.

For Modifications: Do not enter the modification award date in this cell. If the DO indicates that the Initial Award Date is being changed enter the new Initial Award Date.

Credit card orders, should include order date which, in most instances, will be both the Initial Award Date and Start Date

Required for the cumulative row of a base award.

If the date is not being changed with a modification the date is not required on the cumulative row.

I Manufacturer 14

Description and

Not required for the cumulative row of a base award.

Not required for the cumulative row of a modification.Enter the Manufacturer's name 20 17b

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

K Start Date Beginning date for the Period of Performance for the order.

1) 20

2) 21C

3) 3 17b 14 Date of Order

M/D/YYYY

no leading zeros

Represents the award Start Date. Usually this date is the same date as the Initial Award Date, unless stated somewhere else in the DO copy. This date may be changed by a modification. If the modification is to the base award start date enter the new date. If the modification is to an option period that falls within the existing PoP Start Date do not enter the date.

Credit card orders, should include order date which, in most instances, will be both the Initial Award Date and Start Date

Required for the cumulative row on the base award.

If the date is not being changed with a modification the date is not required.

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

L End Date

Ending Period of Performance or Delivery Order Date or Start Date + 15 days 12 or 20 15 or 17b 14

Invoice End Date or

Delivery Receipt date or

Start Date/Order

Date + 15 days

M/D/YYYY

no leading zeros

Represents the award End Date which may include option periods. All awards, including CC orders, need to have an

End Date.

The End Date may be changed by a modification provided the information is contained in the body of the description.

Do not enter the modification CO signature date or the Effective date in the End Date field.

For DO awards: To determine an End Date find the PoP.

If a PoP doesn't exist find the Delivery date on the DO copy.

If neither of these exist add 15 days to the Start Date.

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.

Required for the cumulative row on the base award.

If the date is not being changed with a modification the date is not required on the cumulative row.

M Commercial Price Commercial list or Catalog Price Accounting dollar sign Not required on the cumulative line of the base award.

Not required on the cumulative line of a modification

N DHS Contract Price Unit Price 23 17e 14e

Item Description and specifications Accounting dollar sign

Not required on the cumulative line of the base award.

Not required on the cumulative line of a modification

O Per Item Delta Difference between Commerical price and DHS price. Accounting dollar sign

Not required on the cumulative line of the base award.

Not required on the cumulative line of a modification

P QTY 22 17d 14c

Item Description and specifications

Not required on the cumulative line of the base award.

Not required on the cumulative line of a modification.

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

Q Discount Amount

Is the difference between the Commerical Price and the DHS Contract Price times the Quantity Accounting dollar sign

The total Discount Amount, for all clins, will be entered in the Summary portion of the report at the bottom of the page.

Not required on the cumulative line of the base award.

Not required on the cumulative line of a modification.

R Total DO Value

(including options)

Base + (plus) options dollar amounts. Do not enter clin dollar amounts in this column. 20 17b 14 Accounting dollar sign

Base award - for the base year and each option period there should be a separate line on the report. The base year and all option periods should equal the DO copy total award amount (usually found on the last page of the award). The Total DO Value (including options) should be placed in the cumulative line.

If there is only a base year, entering a value in the cumulative row is dependent upon the Total Amount Obligated. If there is only one clin no cumulative line is needed. If there are multiple clins, the Total DO Value (including options) needs to be added to the cumulative row.

No clin values are entered in this column only the base year amount and the option period amounts.

Required for the cumulative row of a base award.

Required if a modification changes the value.

S Change to Total DO

Value Change to the Total DO Value as a result of a modification 20 17b 14 Accounting dollar sign

This field will have a value only if there is a modification to the Total DO Value (including options). This value is included on the cumulative row. The Change to Total DO Value amount should be added to or subtracted from the previously reported Total DO Value.

No clin values are entered in this column.

If the Total DO Value (including options) is being changed with a modification it is required on the cumulative line.

Column Number Title Description

Box Location on

SF 1449

Box Location on

SF 347

Box Location on

SF 30

Invoice Form Format Remarks

T Total Amount Obligated

Base amount obligated and any subsequent obligations by modifications.

or Last modified Total Amount Obligated (plus) new modified amount obligated 20 or 26 17b 14 Accounting dollar sign

For base awards, each clin on the DO copy should be reported on its own row under this column. The total of all clins, for an award, should be entered into the cumulative row.

For modifications, no clin values are entered in this column.

Required on the cumulative row of the base award.

Do not enter any clin amounts, in this column, that are listed on a modification.

U Current Modification

Amount Obligated Represents the modified dollars at the clin level

20, 24 or 26 17i 12 or 14 Accounting dollar sign

This column is used when there are modifications that change the obligated amount. Individual clins will be reported in this column. The total of all clins will be placed in the cumulative row. The cumulative row amount may need to be reported in the Change to Total DO Value and then added to or subtracted from the Total DO Value (including options). This amount if entered into the

Aggregate Amount Obligated will help in the calculation of component totals.

Required for the cumulative row if a modification is changing the value of Total Amount Obligated. Individual clin amounts that a listed on a modification are entered here.

V

Aggregate Amount Obligated (optional column)

This value represents the total obligated amount for the current reporting period Accounting dollar sign

This optional column is not needed by DHS and does not need to be reported. However, if the Total Amount

Obligated (of the cumulative row) is placed in this column and the report is sorted by component the Summary totals at the bottom of the page will be easy to calculate.

Do not enter any clin amounts in this column, only total amounts.

Title Description Format Remarks

N/A Summary

The summary information that needs to be provided at the bottom of the MSMR includes:

Total Number of Orders Total Amount Obligated (old heading), Monthly Obligation by Component (New heading) Total Spend Amount (old name), Total Obligated Amount (new name)

Click on the tab Blank MSMR Template to view the way the complete report should look. Go to the

Summary Reporting tab to view just the Summary template.

Total Number of Orders - is a count of all (unique) credit card orders and DO awards. If there is a base award and a modification in the same month the count for that award is one (1).

Monthly Obligation by Component - This amount can be determined by sorting the report by component and then totaling using the Aggregate column. The component DHS can be represented as either DHS, DHS/HQ or DHS/OPO and includes the following: DHS/DNDO, DHS/HQ, DHS/IA, DHS/IP, DHS/OCHO, DHS/OCIO, DHS/OCPO, DHS/OPO, DHS/RMTO, DHS/S&T

Total Amount Obligated - is the cumulative amount for all component dollars. Those components that had no awards should have a zero entered in the dollar field.

All awards, including credit card orders, that have multiple clins must have a row that contains cumulative amounts. Base awards that have option periods need to have

The data that goes into the cumulative row should be associated with the clin that has the most money.

The following columns should not have values in the cumulative row: Solicitation Method, Mfg SKU, Manufacturer, Commerical Price, DHS Contract Price, Per Item Delta, Qty, and Discount Amount.

Base awards, credit card orders, and modifications that have only one clin do not require a cumulative row.

Awards whose Total DO Value (including options) is modified will not require a cumulative row if only the value is being increased either by adding a lump sum amount or because a single new clin has been added.

Base awards and modifications that occur in the same reporting period may need to have multiple cumulative rows. One for the base award, one for the modification and

Each award that has a shipping fee, recycle fee or a FedBid fee needs to be included as a separate line item with the associated award.

The Aggregate Amount Obligation column may be used to calculate the Total Obligated Amount, number of unique orders and total amount by Component all found at the bottom of the report in the Summary section.

FirstSource II Cumulative Row Requirements General Information a cumulative row. The cumulative row needs to be the header record, should appear at the top of each award and should be highlighted.

then a "master" cumulative row that includes the totals from both the base award and the modification. When there are multiple cumulative rows only the "master" Total Amount Obligated value will be placed in the Aggregate Amount Obligation column.

DHS/S&T, FEMA, FLETC, ICE, TSA, USCG, USSS, US-VISIT. Not required for modifications unless the component is being changed.

Mfg SKU - Not required

Manufacturer - Not required entered here.

Initial Award Date - Is required for the new award (not a modification). Award date of a modification is not entered here.

Change to Total Amount - The only time dollars are entered into this column is if there is a modification. Only the total modified amount is reported in the cumulative row.

This value is then added to the Total DO Value (including options).

DO Type - Represents the type of DO. Only one DO Type can be reported per cumulative row. For base awards, if you want to track separate DO Types, there would need to be separate cumulative rows defining each type. If you want to track only one DO Type, the DO Type of the clin with the most amount of money should be entered in the

P/S - Not required

Component - For base awards enter the appropriate acronym. CBP, CIS, DHS/CHCO, DHS/OCPO, DHS/DNDO, DHS/HQ, DHS/IA, DHS/IP, DHS/OCIO, DHS/OPO, DHS/R

Supply/Service Description - On a base award it should be the description of the clin with the most amount of money. Not required for a modification.

Column Requirements FirstSource II Cumulative Row Requirements cumulative row. Not required for modifications.

Start Date - Is required for a new award and represents the beginning PoP. If a modification changes the Start Date then the date is entered here.

End Date - Is required for a new award and represents the ending PoP. If a modification changes the End Date of the overall period of performance then the date is

Total Amount (including options) - Represents Base +/- Option period dollar amounts and may include modification amounts. This value is included on the cumulative row.

DHS Contract Price - Not Required

Per Item Delta - Not Required

Qty - Not Required

Discount Amount - Not Required

Commercial Price - Not Required

This amount is then added to the Total Amount Obligated.

Aggregate Amount - Represents either the Total Amount Obligated (for a base award) or the Current Modification Amount Obligated for the current reporting period.

If the Current Modification Amount Obligated is a negative amount this value must still be included in the Summary Totals at the bottom of the report.

reports amount obligated.

Current Modified Amount Obligated - Represents modified dollar amounts at the clin level. The individual clin amounts are totaled and entered into the cumulative row.

FirstSource II Cumulative Row Requirements Column Requirements Total Amount Obligated - For a base awards it represents the total of all obligated clins. For modifications it represents the prior total amount obligated plus the current

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

DHS/S&T Training HSHQDC11J00000 FFP FB S 123-456 Microsoft 4/28/2011 4/30/2011 4/29/2012 59,209.47$ ######### ######## 1 6,528.13$ 52,681.34$ 52,681.34$ 52,681.34$ Single line item - no cumulative row required

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

CBP Software HSBP1011J99999 FFP 4/28/2011 4/30/2011 4/29/2012 309,885.35$ 309,885.35$ 309,885.35$ Cumulative Row CBP Monitors HSBP1011J99999 FFP EM P E202X HP 4/28/2011 4/30/2011 4/29/2012 134.87$ 132.17$ 2.70$ 374 1,009.80$ 49,431.58$ CBP Toner HSBP1011J99999 FFP EM S P208A HP 4/28/2011 4/30/2011 4/29/2012 250.13$ 230.24$ 19.89$ 98 1,949.22$ 22,563.52$

CBP Software HSBP1011J99999 FFP EM S 9923-11352M HP 4/28/2011 4/30/2011 4/29/2012 5,000.00$ 3,171.87$ ######## 75 ########## 237,890.25$

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

DHS/OPO Maintenance HSHSDC1011J88888 FFP 4/28/2011 4/30/2011 4/29/2014 757,206.15$ 49,431.58$ 49,431.58$

Cumulative Row - Note that the Start Date and End Date cover the complete Period of Performance (PoP).

The dollars in the Total DO Value (including options) in the cumulative row need to match the amount indicate on the last page of the base award.

DHS/OPO Monitors HSHSDC1011J88888 FFP FB P A007/L Acer 4/28/2012 4/30/2011 4/29/2012 134.87$ 132.17$ 2.70$ 374 1,009.80$ 49,431.58$ 49,431.58$ Base period + option periods support the cumulative Total DO Value (including options)

DHS/OPO Maintenance HSHSDC1011J88888 FFP FB S P208A HP 4/28/2013 4/30/2012 4/29/2013 454,874.94$ DHS/OPO Maintenance HSHSDC1011J88888 FFP FB S 9923-11352M HP 4/28/2014 4/30/2013 4/29/2014 252,899.63$

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

CBP Training HSBP1011J77777 FFP 4/28/2011 4/30/2011 4/29/2014 607,262.68$ 310,138.11$ 310,138.11$ Cumulative row - Note that the Start Date and End Date cover the complete Period of Performance (PoP)

CBP Monitors HSBP1011J77777 FFP FB P A007/L Cisco 4/28/2011 4/30/2011 4/29/2012 134.87$ 132.17$ 2.70$ 374 1,009.80$ 310,138.11$ 49,488.11$ CBP Maintenance HSBP1011J77777 FFP FB S P208A Cisco 4/28/2011 4/30/2011 4/29/2012 250.13$ 230.24$ 19.89$ 98 1,949.22$ 22,750.00$ CBP Training HSBP1011J77777 FFP FB S 400300110 Cisco 4/28/2011 4/30/2011 4/29/2012 5,000.00$ 3,171.87$ ######## 75 ########## 237,900.00$ CBP Maintenance HSBP1011J77777 FFP FB S CON-SNT-SMS-1000 Cisco 4/28/2011 4/30/2012 4/29/2013 252,899.63$ CBP Maintenance HSBP1011J77777 FFP FB S 9923-11352M Cisco 4/28/2011 4/30/2013 4/29/2014 44,224.94$

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

DHS/S&T HSHQDC11J00000/P00001 3/31/2012 $0

No cumulative row required.

This example changes the PoP End Date.

See example 1 - Base Award with One Clin and No Option Periods for original End Date.

Need to add a Comments column to the end of the report indicating that this was an administrative mod.

5 - Modification of Period of Performance (PoP) End Date with no dollar change

Clins support the Total Amount Obligated and Total DO Value (including options) Note that the Start Date and End Date are the same

Options periods + Base period support the cumulative Total DO Value (including options).

Clins support the Total Amount Obligated and Total DO Value (including options)

Options periods + Base period support the cumulative Total DO Value (including options).

Various Examples for Reporting FirstSource II Awards

1 - Base Award with One Clin and No Option Periods

2 - Base Award with Multiple Clins and No Option Periods

3 - Base Award with Multiple Option Periods and One Clin

4 - Base Award with Multiple Option Periods and Multiple Clins

Various Examples for Reporting FirstSource II Awards

Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

CBP HSBP1011J99999/P00001 320,684.90$ 10,799.55$ 10,799.55$

No cumulative row required.

This example assumes a change to only the Total Amount Obligated. One clin was added. PoP was not changed. The Current Modification Amount Obligated is added to the prior Total Amount Obligated to arrive at the 'current' Total Amount Obligated.

See example 2 - Base Award with Multiple Clins and No Option Periods

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Amount Obligated

Aggregrate Amount Comments

CBP HSBP1011J77777/P00001 316,253.63$ 6,115.52$ 6,115.52$

This example assumes a change to only Total Amount Obligated with multiple clins against the base year.

PoP was not changed See example 4 - Base Award with Multiple Option Periods and Multiple Clins

CBP Flash Drives and Su HSBP1011J77777/P00001 FFP EM P NYV1900ADMAG McAfee $196.37 $167.72 $28.65 32 $916.69 5,367.04$ CBP Flash Drives and Su HSBP1011J77777/P00001 FFP EM S WSGCKE-AA-LG McAfee $14.80 $12.64 $2.16 8 $17.27 101.12$ CBP Flash Drives and Su HSBP1011J77777/P00001 FFP EM S 1180-0039 McAfee $23.69 $20.23 $3.46 32 $110.57 647.36$

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

DHS/S&T HSHQDC11J00000/P00001 50,453.80$ ($2,227.54) $0

No cumulative row required.

This example assumes a change to Total DO Value only. PoP was not changed See 1 - Base Award with One Clin and No Option Periods

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

CBP HSBP1011J00000/P00001 464,481.74$ ########## 464,481.74$ 154,596.39$ 154,596.39$

Cumulative row required.

This example assumes a modification to both Total DO Value and Total Amount Obligated. PoP was not changed. Current Modification Amount Obligated gets added to the previous Total Amount Obligated to arrive at the 'current' Total Amount Obligated.

See example 2 - Base Award with Multiple Clins and No Option Periods

CBP HSBP1011J00000/P00001 P 20,093.70$

CBP HSBP1011J00000/P00001 P 73,501.47$

CBP HSBP1011J00000/P00001 P 61,001.22$

6 - Modification Submitted After Base Award was Submitted (at least one month apart but could be years apart) impacting only Total Amount Obligated with one clin

9 - Modification Created After Base Award was Submitted (at least one month apart but could be years apart) impacting both Total DO Value and Total Amount Obligated with multiple clins

10 - Base Award and One Modifications Submitted in the Same Month

7 - Modification Submitted After Base Award was Submitted (at least one month apart but could be years apart) impacting only Total Amount Obligated with multiple clins

8 - Modification Submitted After Base Award was Submitted (at least one month apart but could be years apart) impacting only Total DO Value

Supporting rows

Supporting rows

Various Examples for Reporting FirstSource II Awards

Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

ICE Sever Rack and part HSCETE11J55555/P00001 FFP 4/20/2011 4/20/2011 5/20/2011 $11,250.02 ($1,922.18) $11,250.02 ($1,922.18) $11,250.02 Cumulative row for whole award ICE Sever Rack and part HSCETE11J55555 FFP 4/20/2011 4/20/2011 5/20/2011 13,172.20$ 13,172.20$ Cumulative row for the base award ICE BLACKBOX RACK HSCETE11J55555 FFP PT P 4/20/2011 4/20/2011 5/20/2011 10,079.60$ 9,212.40$ 867.20$ 1 867.20$ 9,212.40$ ICE BLACKBOX RACK HSCETE11J55555 FFP PT P 4/20/2011 4/20/2011 5/20/2011 76.64$ 61.31$ 15.33$ 20 306.60$ 1,226.20$ ICE MON LCD 19-INCH HSCETE11J55555 FFP PT P 4/20/2011 4/20/2011 5/20/2011 $ 621.22 $ 455.60 $ 166.02 6 $ 996.12 2,733.60$ ICE Server Rack and par HSCETE11J55555/P00001 FFP $11,250.04 ($1,922.18) $11,250.04 ($1,922.18) Cumulative row for the modification ICE Elite Data Cabinet HSCETE11J55555/P00001 FFP PT P 1,259.95$ 901.55$ 358.40$ 8 2,867.20$ ($2,000.00) ($2,000.00) ICE 19" LCD Monitor HSCETE11J55555/P00001 FFP PT P 239.00$ 229.41$ 9.59$ 2 19.18$ $77.82 $77.82

Component Supply/Service Description

DO Number and Modification Number

DO

Type

Solicitation Method P/S MFG

SKU

Manufac-turer Award Date

Start Date

End Date

Commercial Price

DHS

Contract

Price

Per Item Delta Qty Discount

Amount

Total DO Value

(including options)

Change to Total DO

Value

Total Amount

Obligated

Current Modification

Amount Obligated

Aggregrate Amount Comments

FEMA Monitors HSFEEM09J3333/P00003 FFP 4/28/2011 4/30/2011 10/31/2012 $ 161,906.74 -2026.78 $ 54,275.54 $ 2,319.00 $ 54,275.54 Cumulative row for base and all modifications FEMA Monitors HSFEEM09J3333 FFP 4/28/2011 4/30/2011 4/29/2012 $ 162,439.52 $ 51,956.54 Cumulative row for base FEMA Monitors HSFEEM09J3333 FFP EM P E202X Quest 4/28/2011 4/30/2011 4/29/2012 134.87$ 132.17$ 2.70$ 198 1,009.80$ 26,169.66$ FEMA Toner HSFEEM09J3333 FFP EM S P208A Quest 4/28/2011 4/30/2011 4/29/2012 250.13$ 230.24$ 19.89$ 212 1,949.22$ 25,786.88$

FEMA HSFEEM09J3333/P00001

Modification 1 Admin mod - change gov't COTR. No dollar change.

FEMA HSFEEM09J3333/P00002 $ 162,439.52 53,450.54$ 1,494.00$ Cumulative row for modification 2 FEMA E-Port Plus Replica HSFEEM09J3333/P00002 FFP EM P 460-222 DELL 177.38$ 157.30$ 21.24$ 4 84.96$ 709.52$ Supporting rows for modification 2 Inc Total Amount FEMA Weather x Am/FM HSFEEM09J3333/P00002 FFP EM P 14151-04 DELL 108.06$ 98.06$ 10.02$ 8 80.16$ 784.48$ Oblligated and change PoP End Date

FEMA HSFEEM09J3333/P00002 10/31/2012

FEMA HSFEEM09J3333/P00003 161,906.74$ -2026.78 54,275.54$ 825.00$ Cumulative row for modification 3 FEMA HSFEEM09J3333/P00003 -2026.78 Supporting rows for modification 3 Reduce Total DO FEMA Restocking fee HSFEEM09J3333/P00003 FFP EM S Restocking Fee Quest 825.00$ Value and increase Total Amount Obligated

Supporting rows for the modification

Supporting rows for base

11 - Multiple Modifications Submitted in the Same Month Base was previously submitted

Supporting rows for the modification