Attachment_9_-_CDRL_A002.pdf

FA8056-17-R-0001

Exhibit A

Appendix B

10/21/2016

Supplier Name:

Annual Reporting Period:

Ordering Office

DODAAC

Ship From

CAGE Code Contract Number Order Date Ship Date

Product Receipt Date Payment Type PSC/FSC Appropriation CLIN CLIN Description

Quantity Ordered Sales Price

Total Price of

Purchase

GSA Price w/ volume Discounts Savings

Total Percentage

Savings Comments (1.0) (2.0) Name City State Zip Code Name City State Zip Code (5.0) (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) (19.0) (20.0)

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

$0.00 $0.00 #DIV/0!

Ship From Location (3.0) Ship To Location (4.0)

ANNUAL DATA REPORTING MATRIX INSTRUCTIONS: The contractor is to fill out the AnnualData Report ing Matrix in accordance with the instructions at Appendix B (Exhibit A) for each required reporting line item (i.e., column). The supplier shall report the data collected throughout the Government fiscal year (FY):

- Reporting Period 1 thru 4: Due NLT the 15th of the month proceeding.

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.

** See Appendix B (Exhibit A002), Quarterly Reporting Requirements Definitions for more details on how to complete this matrix.

Annual Data Reporting Matrix

Exhibit B

Appendix B ANNUAL REPORTING REQUIREMENTS INSTRUCTIONS: The 771 Enterprise Sourcing Squadron (ESS) requires that all of its awarded contractors complete the Annual Program Review 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. Fiscal Year (FY) beginning October 1 ending 30 September, deliverable 15 October

The report shall be completed in the attached Appendix A - Annual 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 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/ .

3.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.

4.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.

5.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.

6.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.

7.0 SHIP DATE. (Required Field)

Appendix B 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.

8.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.

9.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).

10.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/

11.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.

12.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.

13.0 CONTRACT LINE ITEM (CLIN)/SubCLIN DESCRIPTION. (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.

14.0 QUANTITY ORDERED. (Required Field)

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

15.0 CONTRACT 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 and must take into account any further discount off the GSA Price with all volume discounts.

16.0 TOTAL PRICE OF PURCHASE. (Required Field)

Appendix B 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 contract price (15.0) times the Quantity ordered (14.0) to determine the total price of all individual items (12.0/13.0) purchased.

17.0 GSA PRICE w/ VOLUME DISCOUNTS. (Required Field)

If contractor holds a GSA schedule, the GSA Price shall be reported relative to field 9.0. Price will be listed per individual item, in US Dollar currency only and must take into account any volume discounts offered off the GSA Schedule. This field will be left blank if the contractor does not hold a GSA schedule.

18.0 SAVINGS. (Required Field)

Savings is a locked summary field and it automatically calculated using a formula. Savings is calculated by subtracting the Sales Price (15.0) from GSA Price w/Volume Discounts (17.0)

19.0 TOTAL PERCENTAGE SAVINGS. (Required Field)

Savings is a locked summary field and it automatically calculated using a formula. Total Percent Savings is calculated by dividing Savings (18.0) by the sum of (GSA Price w/Volume Discounts times the Quantity ordered (14.0))

20.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.

CDRL A002 - APP B instructions

Text2: 12/19/2016