Attachment_7_-_CDRL_A001_-_FES_PPE_Services_Quarterly_Data_Reporting2.pdf

BLK 16 A N/A - Admin./Management Data

FA8056-17-R-0006

A001 Status Report Fire Emergency Services Personal Protective Equipment (FES PPE)

DI-MGMT-803368A BLK 16 771 ESS/EGA

XX

N/A BLK 16

Quarterly

BLK 16

BLK 16

BLK 16

771 ESS/EGA 1 1

0 1 1

See https://assist.daps.dla.mil/quicksearch for the body of Data Item Description, DI-MGMT-803368A (the DID), however, DI-MGMT-803368A is hereby tailored to require the specific Exhibit A format. Replace section 3.2 Body of Report with Exhibit A, Appendix A, "Quarterly Data Reporting Requirements". All data fields in columns 1.0-10.0 and 13.0-18.0 shall be filled in and all other columns are optional if they apply, see Appendix B, "Quarterly Reporting Requirements Instructions," for guidance.

BLK A: 0001, 0002, 0003, 0004, 0005, 0006

BLK 5: Contract Attachment X FES PPE Services Performance Work Statement (PWS), Section X, Reporting Requirements, X. Summary Reports, XX. Quarterly Data Reporting BLK 11: Report Data compiled as of the end of each government fiscal quarter BLK 12: The first submission will be due not later than the first calendar date in Block 13 which occurs first after contract award BLK 13: Subsequent status reports shall be due not later than the 15th day in the month following the end of each fiscal year quarter (JAN 15, APR 15, JUL 15, AND OCT 15) of each fiscal year throughout the life of the contract.

James D. Edington 1 1

Adobe Professional 8.0

Supplier Name:

Quarterly Reporting Period:

Ordering Office

DODAAC

Ship to

DODAAC

Ship From

CAGE Code Contract Number

(no dashes) Order Date Ship Date Product Receipt

Date Contract Vehicle PSC/FSC* Approopriation* CLIN Description of Services Total Units Unit Price Extended Price Comments

(1.0) (2.0) (3.0) Name City State Zip Code Name City State Zip Code (6.0) (7.0) (8.0) (9.0) (10.0) (11.0) (12.0) (13.0) (14.0) (15.0) (16.0) (17.0) (18.0) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Appendix A

Ship From Location (4.0) Ship To Location (5.0)

REPORTING REQUIREMENTS INSTRUCTIONS: The Supplier is to fill out the Quarterly Reporting Matrix in accordance with the instructions at Appendix B (Exhibit A) for each reporting item (i.e., column). The supplier shall report the data collected throughout the Government fiscal year (FY):

1. FY Quarter 1 beginning 1 October ending 31 December, deliverable due 15 January

2. FY Quarter 2 beginning 1 January ending 31 March, deliverable due 15 April

3. FY Quarter 3 beginning 1 April ending 30 June, deliverable 15 July

4. FY Quarter 4 beginning 1 July ending 30 September, deliverable 15 October

The report shall be completed in the above Quarterly Data Reporting Matrix. The Matrix shall be reported back to the 771 ESS/EGA as an editable file in Microsoft Excel (i.e., file format .xls or .xlsx) . Data fields shall be filled out thoroughly for each required reporting line item. Data fields cannot be populated with “same as above”. In addition, all cost columns should be provided in United States (US) currency. Contractors have a contractual obligation to provide this data.

* Shall be populated by the Government.

Quarterly Data Reporting Matrix

Exhibit A

Appendix B

QUARTERLY REPORTING REQUIREMENTS INSTRUCTIONS: The 771 Enterprise Sourcing Squadron (ESS) requires that all of its awarded contractors complete the Quarterly Data Report in accordance with the definitions written below for each reporting requirement.

The contractors shall report the data collected throughout the Government Fiscal Year (FY):

1. FY Quarter 1 beginning 1 October ending 31 December deliverable due 15 January

2. FY Quarter 2 beginning 1 January ending 31 March deliverable 15 April

3. FY Quarter 3 beginning 1 April ending 30 June deliverable 15 July

4. FY Quarter 4 beginning 1 July ending 30 September deliverable 15 October

The report shall be completed in the attached Appendix B - Quarterly Data Reporting Matrix. The Matrix shall be submitted to the 771st ESS/EGA, electronically to ESG.PPE@us.af.mil, as an editable file in Microsoft Excel (file format .xls or .xlsx). Required reporting data fields, 1.0 – 9.0 and 12.0 – 16.0 shall be completed for each line item. These required line items shall be filled out thoroughly in accordance with this instruction document. In addition, all cost column information shall be provided in United States (US) currency, with the accumulated values from the preceding fiscal year. Contractors have a contractual obligation to provide this data.

1.0 ORDERING OFFICE DODAAC. (Required Field)

The contractor shall report the ordering location DODAAC of the installation/base/organization placing the order. The Department of Defense Activity Address Code (DoDAAC) is a six position code that uniquely identifies a unit, activity, or organization that has the authority to requisition and/or receive material. This information can be found in Block 9 of the SF 1449 or Block 6 of the SF 30.

2.0 SHIP TO DODAAC. (Required Field)

The Department of Defense Activity Address Code (DoDAAC) is a six position code that uniquely identifies a unit, activity, or organization that has the authority to requisition and/or receive material. The supplier shall report the shipping location DoDAAC of the installation/base/organization placing the order. This information can be found in Block 15 of the SF 1449.

3.0 SHIP FROM CAGE CODE. (Required Field)

The contractor shall report the location of the manufacturer’s facility where the completed product was shipped from will be reported by CAGE Code. This code can be obtained from the Central Contractor Registration web site at https://www.sam.gov/ .

4.0 SHIP FROM LOCATION. (Required Field)

The contractor shall report the delivery from location including the name, city and state of the location from which the product(s) were delivered.

5.0 SHIP TO LOCATION. (Required Field)

The contractor shall report the ship to location including the name, city and state of the final Air Force location the product(s) were delivered.

6.0 CONTRACT NUMBER. (Required Field)

The contractor shall report the Contract Number as taken directly from Block 2 of a Standard Form 1449 or Block 10a of a Standard Form 30.

mailto:ESG.PPE@us.af.mil https://www.sam.gov/

Appendix B

7.0 ORDER DATE. (Required Field)

The contractor shall report order date as the date the order is received from DoD EMALL. I t will be reported in the following format, DD-MM-YYYY.

8.0 SHIP DATE. (Required Field)

The contractor shall report the ship date as the date the supply item was physically shipped to the customer. It will be reported in the following format, DD-MM-YYYY.

9.0 PRODUCT RECIEPT DATE. (Required Field)

The contractor shall report the Product Receipt Date as the date the supply item was physically received by the customer. It will be reported in the following format, DD-MM-YYYY.

10.0 PAYMENT TYPE. (Required Field)

The contractor shall report the Payment type as the method of payment used to purchase the product(s) (e.g. Government Purchase Card (GPC), Defense Finance and Accounting Service (DFAS), etc.). If the invoice is unpaid at the time of reporting, report it as Unpaid, with the anticipated method (i.e. UNPAID – DFAS).

11.0 PSC/FSC. (Required Field)

The contractor shall report the Product Service Code/Federal Supply Code. These codes are used to group products into logical families for supply management purposes. This code can be found at http://support.outreachsystems.com/resources/tables/pscs/

12.0 APPROPRIATION. (Required Field)

Procurement appropriations are used to finance non-construction-related investment items. The appropriations will be identified in the Long Line of Accounting (LOA) when items are procured.

13.0 CONTRACT LINE ITEM (CLIN)/SubCLIN. (Required Field)

CLIN/SubCLIN shall be the alpha numeric assigned to the supply item as described in Section B of the SF1449.

14.0 DESCRIPTION OF SERVICES. (Required Field) CLIN/SubCLIN description shall be the description assigned to a supply item as described in Section B of the SF1449. This block will be used to identify the specific item being acquired. Acceptable inputs are: the specific Sub Contract Line Item Number (SubCLIN), “Add Radio Pocket.” SubCLIN will be taken directly from the contract for each unique product ordered on the contract. Reporting of SubCLIN items will be at the typical level and should not include individual part numbers in order to limit the quantity of data reported.

15.0 TOTAL UNITS. (Required Field)

The contractor shall report the Quantity ordered as the number of units ordered under each CLIN/SubCLIN

16.0 UNIT PRICE. (Required Field)

Contract Price shall be reported relative to field 9.0. Price will be listed per individual item, in US Dollar currency only.

http://support.outreachsystems.com/resources/tables/pscs/

Appendix B

17.0 EXTENDED PRICE. (Required Field)

Total price of purchase is a locked summary field and it automatically calculated using a formula. Total price of purchase is calculated by multiplying the unit price (16.0) times the total units (15.0) to determine the total price of all individual items (13.0/14.0) purchased.

18.0 COMMENTS. (Required Field)

Comments shall be a short description of any miscellaneous charges listed in (9.0). Please provide as specific information as possible within the limitations of the cell.