A001b_Appendix_B_Quarterly_Report_Definitions_-_FINAL_-_18_Apr_2013.pdf

A001b Appendix B - Reporting Requirements Definitions for Law Enforcement Equipment

REPORTING REQUIREMENTS INSTRUCTIONS: The USAF Force Protection Commodity Council requires all of its selected suppliers to fill out the quarterly report in accordance with the definitions written below for each reporting requirement. The supplier shall report the data collected throughout the government fiscal year (FY) as follows:

1. Reporting Period 1 beginning 1 October ending 31 December; deliverable due 15 January

2. Reporting Period 2 beginning 1 January ending 31 March; deliverable due 15 April

3. Reporting Period 3 beginning 1 April ending 30 June; deliverable due 15 July

4. Reporting Period 4 beginning 1 July and ending 30 September; deliverable due 15

October

The report shall be completed in the attached Information Requirements Quarter Report Matrix.

The matrix shall be reported back to the Enterprise Sourcing Group, electronically to lawenforcementequipm@wpafb.af.mil, as an editable file in Microsoft Excel 2007 or later. Data fields shall be filled out thoroughly for each line item. Data fields cannot be populated with “same as above”. In addition, all cost columns should be provided in United States (US) currency. Manufacturers have a contractual obligation to provide this data.

1.0 ORDERING OFFICE DODAAC

The supplier shall report the ordering location Department of Defense Activity Address Code (DODAAC) of the installation/base/organization placing the order. The DODAAC is a six character 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 6 of the SF 30 or Block 9 of the SF 1449 Contract.

2.0 SHIP FROM CAGE CODE

The location of the supplier facility where the product was shipped from will be reported by CAGE Code. This code can be obtained from the System for Award Management (SAM) web site at www.sam.gov .

3.0 SHIP FROM LOCATION

The ship from location shall be reported as the facility name, city, state and Zip code of the supplier ship from location.

4.0 SHIP TO LOCATION

The ship to location shall be reported as the name, city, state and Zip code of the final Air Force location the product(s) were delivered to.

mailto:lawenforcementequipm@wpafb.af.mil http://www.bpn.gov/ccr/

5.0 CONTRACT NUMBER

The contract number shall be reported as the contract number taken directly from the Block 10a of a Standard Form 30 or Block 2 of a Standard Form 1449.

6.0 ORDER DATE

The order date shall be reported as the date the contract (SF 30 or SF 1449) was signed. It will be reported in the following format, DD-MMM-YYYY.

7.0 SHIP DATE

The ship date shall be reported as the date the product was shipped from the supplier ship from location. It will be reported in the following format, DD-MMM-YYYY.

8.0 PRODUCT RECEIPT DATE

The product receipt date will be the day product is received at the ship to location specified in field 4.0.

9.0 PAYMENT TYPE

Payment type shall be reported 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).

10.0 CLIN

This block will be used to identify the specific Contract Line Item Number (CLIN) of the product/service being acquired. Acceptable inputs are the Contract Line Item Number (CLIN) specified in the supplier contract.

11.0 CLIN DESCRIPTION

This block will be used to identify the description of the specific product/service acquired and referenced by the Contract Line Item Number (CLIN) specified in field 10.0.

12.0 QUANTITY ORDERED

Quantity ordered shall be reported as the specific quantity of product/service being acquired for the given CLIN specified in field 10.0.

13.0 CONTRACT PRICE

Contract Price shall be reported relative to the product/service acquired and referenced by the Contract Line Item Number (CLIN) specified in field 10.0. Price will be listed per individual item, in US Dollar currency only and must reflect contracted price.

14.0 PRICE OF PURCHASE

Price of purchase is a locked summary field and is automatically calculated using a formula.

Price of purchase is calculated by multiplying the Contract Price (13.0) x Quantity Ordered (12.0) to determine a total price of all the individual line items (10.0) purchased for the reference

15.0 COMMENTS

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