CDRL_A001.pdf

FA8056-17-R-0001

Exhibit A

Appendix B

Supplier Name:

Quarterly 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)

QUARTERLY DATA REPORTING MATRIX INSTRUCTIONS: The contractor is to fill out the Quarterly Data Report ing Matrix in accordance with the instructions at Appendix B (Exhibit A) for each required reporting line item (i.e., column).

The contractor 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.

Quarterly Data Reporting Matrix

10/21/2016

Appendix B

QUARTERLY REPORTING REQUIREMENTS INSTRUCTIONS: The 771st Enterprise

Sourcing Squadron (ESS) requires all of its selected contractors to fill out the Quarterly Data

Report in accordance with the definitions written below for each reporting requirement. The contractor 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 A – Quarterly Data Reporting Matrix.

The matrix shall be reported back 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 field (i.e., columns) 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 columns shall be provided in United States (US) currency. 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 to.

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 Block10a of a Standard Form 30.

6.0 ORDER DATE. (Required Field)

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

7.0 SHIP DATE. (Required Field)

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

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. (Optional 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. (Optional 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. (Optional 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. (Optional 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. (Optional 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. (Optional 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.