Appendix_D_-_CDRLS-17_Aug2017.pdf

All Data Item Descriptions (DIDs) are available to the public on ASSIST Quick Search at http://quicksearch.dla.mil/

EXHIBIT A

Contract Data Requirements List

17 Aug 2017

1230967748C Highlight

1230967748C Highlight

CDRL List

CDRL # Title of Data Item Description Subtitle

A001 Status Report (Daily) Aircraft

(Monthly) Aircraft

A002 Management Plan

Phase‐In

Site Activation / Site Closure

Transition

A003 Inventory/Utilization Data Report

Phase‐In Inventory

Navy/Marine Corp Semi‐Annual Inventory

Army and AF Annual Inventory

Phase‐Out Inventory

A004 Status Report Subscription Services

A005 Data Accession List Receipt of Data

A006 Contractor’s Personnel Roster Key Personnel Contact List

A007 Conference Agenda Agenda

A008 Conference Minutes Minutes

A009 Presentation Material

A010 Technical Report – Study / Services 10‐Year Maintenance Plan

A011 Integrated Production Schedule (IPS)

Report Depot Status Report

A012 Contract Funds Status Report Monthly Report

A013 Quality Deficiency Report Deficiency Report (DR)

A014 Notification of Critical Non‐ Conformance Report

Foreign Object Damage (FOD) or Missing Tool Report

A015 Program Management Plan

Program Management Plan

(Sub Section) Quality Management

(Sub Section) Contractor Risk Management Plan

(Sub Section) Hazmat

A016 Accident / Incident Report

A017 Hazardous Materials Management Plan

A018 Diminishing Manufacturing Sources and Material Shortages (DMSMS) Health Analysis Report and Parts Obsolescence

CDRL # Title of Data Item Description Subtitle

A019 Commercial Drawings/Models and Associated Lists

Modifications

A020 Teardown Deficiency Report

A021 Contractor Manpower Reporting Application eCMRA (online Application annual report)

A022 Status Report Support Equipment and Test Equipment Maintenance Schedule (Quarterly)

A023 Logbooks and Records, Aircraft and

Aeronautical Equipment

Official Aircraft Records (With A/C)

Depot Reports (CDRL Deliverable)

Support Equipment Requirements ‐

Weight and Balance analysis and/or Weight and Balance Reports.

Engine overhaul reports

A024 Risk Management Status Report Quarterly Risk Tracking Report

A025 Status Report Transition

A026 Status Report Loose Equipment Inventory Report

A027 Consumable Parts Bondroom/Inventory and Parts Usage Report Exchange Parts Reporting

A028 Physical Inventories Report Chief Financial Officer (CFO) Report

A029 Status Report Production Manufacture Approval (PMA) Parts Tracking

Changes 17 Aug 2017 Change – Corrected DID address in footer on first three pages.

‐ Corrected attachment to CDRL A004 ‐ Updated A028 and its attachment based on new AF Directions.

‐ Updated A025 changed GFE to all Government owned Items.

‐ Updated pages 1‐3 related to above changes.

1230967748C Highlight

1230967748C Highlight

CDRL A004, Attachment 1 ‐ C‐20 and C‐37 Subscriptions with Applicable Aircraft Date: 14 Aug 2017

SUBSCRIPTION SUBSCRIPTION DETAILS VENDOR SERVICE

AIRCRAFT

MODEL Sub QTY

USAF GV 9 521/70400 542/70401 571/90402 590/90404 620/10028 624/10029 663/10030 645/10076 652/10065

G550 3 5152/60500 5247/80525 5297/10550

ARMY GIV 1 1162/10108

GV 2 566/71944 670/21863

G550 1 5034/41778

NAVY GV 1 657/166375

ARMY GIV 1 1162/10108

Navy GIV 4 1187/165093 1199/165151 1201/165152 1189/165094

NZ Nav Database NZ Navigational Database ‐ Renewal

YA5‐WORLD3 V3.01Web ‐ Jeppesen USAF GV 9 521/70400 542/70401 571/90402 590/90404 620/10028 624/10029 663/10030 645/10076 652/10065

Network Classic: Airshow Network/Airshow 4000

Clsc Pack ‐Airshow USAF GV 9 521/70400 542/70401 571/90402 590/90404 620/10028 624/10029 663/10030 645/10076 652/10065

Network Newsource 7: Airshow 4000 Seven News

Sources G550 3 5152/60500 5247/80525 5297/10550

Network Classic: Airshow Network/Airshow 4000

Clsc Pack ‐Airshow ARMY GIV 1 1162/10108

Network Classic/Network Newsource 7 Pack/

4000 Seven News Sources GV 2 566/71944 670/21863

Network Newsource 7: Airshow 4000 Seven News

Sources

G550 1 5034/41778

ARMY GIV 1 1162/10108

NAVY GIV 4 1187/165093 1199/165151 1201/165152 1189/165094

USMC GIV 1 1200/165153

ARMY GIV 1 1162/10108

NAVY GIV 4 1187/165093 1199/165151 1201/165152 1189/165094

GV 1 657/166375

G550 4 5041/166376 5087/166377 5098/166378 *5544/166379

USMC GIV 1 1200/615153

Complete worldwide services plus all military bases database ‐ Renewal USAF G550 3 5152/60500 5247/80525 5297/10550

ARMY GV 2 566/71944 670/21863

G550 1 5034/41778

USMC GIV 1 1200/165153

USAF GV 9 521/70400 542/70401 571/90402 590/90404 620/10028 624/10029 663/10030 645/10076 652/10065

G550 3 5152/60500 5247/80525 5297/10550

ARMY GV 2 566/71944 670/21863

G550 1 5034/41778

ARMY GV 2 566/71944 670/21863

G550 1 5034/41778

GDC PWW Subscription and Monthly Service GIV 1 1162/10108

Honeywell Global Data Center

Applicable Serial Numbers / Tail Numbers

Meggit

Rockwell Collins

Rolls Royce

Honeywell

Tybee JetAFMatic

Rolls Royce Aeromanager

AIRSHOW

Honeywell Nav Database

Meggit Wheels & Brakes Manuals

Integrated Navigation Data Service (INDS) Jeppesen Sanderson Complete worldwide services plus all military bases database ‐ Renewal ‐ plus domestic shipping

AFIS Subscription & Usage Honeywell

Note: *5544 will be on the CLN list starting in the Option year for 2020. Page 1 of 2 12

CDRL A004, Attachment 1 ‐ C‐20 and C‐37 Subscriptions with Applicable Aircraft Date: 14 Aug 2017

SUBSCRIPTION SUBSCRIPTION DETAILS VENDOR SERVICE

AIRCRAFT

MODEL Sub QTY Applicable Serial Numbers / Tail Numbers

ARMY

TV Basic 3 566/71944 670/21863 5034/41778

TV Basic ‐AR 3 566/71944 670/21863 5034/41778

TV Content EU 3 566/71944 670/21863 5034/41778

TV Content ME 3 566/71944 670/21863 5034/41778

TV Content US 3 566/71944 670/21863 5034/41778

TV Content US ‐ AR 3 566/71944 670/21863 5034/41778

TV Europe 3 566/71944 670/21863 5034/41778

TV MEAST 3 566/71944 670/21863 5034/41778

TV PRSPORTS 3 566/71944 670/21863 5034/41778

TV PRSPORTS‐AR 3 566/71944 670/21863 5034/41778

TV CONTENT ME‐AR 3 566/71944 670/21863 5034/41778

TV CONTENT EU‐AR 3 566/71944 670/21863 5034/41778

Computerized Mainteance Program USAF GV 9 521/70400 542/70401 571/90402 590/90404 620/10028 624/10029 663/10030 645/10076 652/10065

G550 3 5152/60500 5247/80525 5297/10550

ARMY GIV 1 1162/10108

GV 2 566/71944 670/21863

G550 1 5034/41778

NAVY GIV 4 1187/165093 1199/165151 1201/165152 1189/165094

GV 1 657/166375

G550 4 5041/166376 5087/166377 5098/166378 *5544/166379

USMC GIV 1 1200/165153

Sirius XM WX Pro ARMY GV 2 566/71944 670/21863

Sirius XM WX (Basic) G550 1 5034/41778 Sirius XM RadioSirius XM Radio

Direct TV

Gulfstream CMP.NET

Note: *5544 will be on the CLN list starting in the Option year for 2020. Page 2 of 2 13

CONTRACT DATA REQUIREMENTS LIST Form Approved

(1 Data Item} 0MB No. 0704-0188

The public reporting burden for this collection of information is estimated to average 110 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing the burden, to the Department of Defense, Executive Services Directorate (0704-0188}. Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid 0MB control number. Please do not return your form to the above organization. Send completed form to the Government Issuing Contracting Officer for the Contract/PR No. listed in Block E.

A. CONTRACT LINE ITEM NO. 8. EXHIBIT C. CATEGORY:

A TOP

TM -- OTHER

D. SYSTEM/ITEM

I

E. CONTRACT/PR NO. F. CONTRACTOR

C-20 & C-37

1. DATA ITEM NO. 2. TITLE OF DATA ITEM 3. SUBTITLE

A025 Status Report Transition

4. AUTHORITY (Data Acquisition Document No.}

5. CONTRACT REFERENCE 6. REQUIRING OFFICE

DI-MGMT-80368A See paragraph 6 AFLCMC/WLV

7. DD 250 REQ 9. DIST STATEMENT 10. FREQUENCY 12. DATE OF FIRST SUBMISSION 14. DISTRIBUTION

REQUIRED

AsReq See Blk 16 No b. COPIES

8. APP CODE 11. AS OF DATE 13. DATE OF SUBSEQUENT a. ADDRESSEE Final SUBMISSION Draft

Reg Repro

16. REMARKS See CDRL Distribution I. Block 4: the DID is tailored as follows: Master List

a. Paragraph 2.1 g of the DID. The report shall be marked with "For Official Use Only (FOUO)" and shall be made available to the Government on the program website for the duration of the Transition and for a period of time after the Transition to be determined by the PCO.

b. Paragraph 3.2. The Contractor shall thoroughly document the status of any GFE which was not inventoried during the Phase Out Joint Inventory. The Contractor shall issue interim and final reports on the status of the Transition until all Government Owned/ Furnished items (GFP, GFM, GFE) are returned to the Government or until a resolution has been reached.

2. Block 5. This Status Report will cover any of the tasks in section 6 of the PWS which is accomplished during the Transition interval.

3. Blocks IO through 13, will be determined by the PCO and negotiated with the contractor prior to the beginning of the transition interval.

4. This DID will not be priced at this time. It will only be priced when the PCO determines that a transition is required or will likely be required.

5. Government approved electronic file format is acceptable for the delivery.

6. All data products generated by this CDRL are to be marked "For Official Use Only (FOUO)" and are not be marked as proprietary.

15. TOTAL 0 0 0

G. PREPARED BY H. DATE I. APPROVED BY J. DATE

Sonia Teet Joseph Adamski TEET.SONIA.D.1230967748 Digitally tignedby TEET.SONIA.D.123096n4ff 17 Aug 2017 ADAMSKI.JOSEPH.M. I 0575 �f�t.�12':==.,�',!��:!,SAF, 17 Aug 2017

Date: 2017.08.1716;37:21 -05'00'

DD FORM 1423-1, FEB 2001

J7J6R �A.\lSKUOSEPKM��31m68

PREVIOUS EDITION MAY BE USED. Page�}� of�l� Pages Adobe Professional 8.0

17. PRICE GROUP

18. ESTIMATED

TOTAL PRICE

1230967748C Highlight

1230967748C Highlight

CONTRACT DAT A REQUIREMENTS LIST Form Approved ( 1 Data Item) 0MB No. 0704-0188

The public reporting burden for this collection of information is estimated to average 110 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information, Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing the burden, to the Department of Defense, Executive Services Directorate {0704-0188}. Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid 0MB control number. Please do not return your form to the above organization. Send completed form to the Government Issuing Contracting Officer for the Contract/PR No. listed in Block E.

A. CONTRACT LINE ITEM NO. B. EXHIBIT C. CATEGORY:

A TOP --- TM -- OTHER

D. SYSTEM/ITEM IE. CONTRACT/PR NO. F. CONTRACTOR

C-20 & C-37

1. DATA ITEM NO. 2. TITLE OF DATA ITEM 3. SUBTITLE

A028 Physical Inventory Report Chief Financial Officer (CFO) Report

4. AUTHORITY /Data Acquisition Document No./ 15. CONTRACT REFERENCE 6. REQUIRING OFFICE

DI-MGMT-80259/T FAR Clause 52.245-1 and PWS 4.10 AFLCMC/WLV

7. DD 250 REQ 9. DIST STATEMENT 10.FREQUENCY 12. DATE OF FIRST SUBMISSION 14. DISTRIBUTION

See Block 16

REQUIRED

Quarterly BLK 16 b, COPIES

8. APP CODE 11. AS OF DATE 13. DATE OF SUBSEQUENT a. ADDRESSEE Final D SUBMISSION Draft NA BLK 16 BLK 16 Reg Repro

16. REMARKS

I. Block 7: Property delivered and accepted for the Government when a form DD 250 is required by the Procuring Contract Officer (PCO).

2. Block 11: Date the CFO Report was prepared.

3. Block 12: Three (3) calendar days after end of first quarter, does not include phase in.

4. Block 13: Three (3) calendar days after end of each subsequent quarter

5. Block 14:

a. Submit reports in the attached CFO Template format.

b. Submit individual reports for each of the Service and each platform, except for the USCGC-37s.

c. The contractor shall post the reports on the program website maintained by the Contractor for this contract. The report will be in a recent version of Microsoft Office Excel which is compatible with the excel used by the Government Program Offices.

d. Data products generated by this CDRL, are to be marked "For Official Use

Only (FOUO)" and are not to be marked as proprietary.

The CFO Report is required until the Program Implements electronic transactional reporting or direct input to the Defense Property Accountability System (DP AS)

SEE CORL ATTACHMENT 1

15. TOTAL 0 0 0

G. PREPARED BY H.DATE I. APPROVED BY J.DATE

Sonia Teet Joseph Adamski TEET .SONIA.D.1230967748 Digitally signed by TEET.SONIAD.1230%77,18 17 Aug2017 ADAMSKI.JOSEPH.M. l 0575 it~~t~=~:E~h~\:.~~1J(.'::uSAr, 17 Aug 2017 lh.tc-20l7.08.l7l4;S9;l6·01'00' 37368 .,..~ADAMS~!OSE!>liM 1057S373cf;

DD FORM 1423-1, FEB 2001 '

PREVIOUS EDITION MAY BE USED. Page 1 of 1 Pages

Adobe Professional 8.0

17. PRICE GROUP

18. ESTIMATED

TOTAL PRICE

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

CDRL A028: Attachment 1 CFO Report Template Page 1 of 4

TAB 1

Header:

Name of Program and DoDAAC: In cell following the colon, enter the Service that the report is for USAF, US ARMY, or US Navy, then enter the platform (C-20 or C-37).

Column A : Insert your prior quarter $ ending balance.

Column B : Insert your prior quarter quantity ending balance.

Column C: Insert your current quarter $ beginning balance.

(Please Note: Ending balance from Prior quarter and Beginning balance from Current quarter MUST Equal) Column D: Insert the dollar $ Value of new acquisitions.

Column E: Insert the dollar $ Value of customer returns.

Column F: Insert the dollar $ Value of shipments/issues.

Column G:

Column H: Insert the dollar $ Value of disposals.

Column I: Insert all condition code changes made by the C-ICP for assets located in the warehouse.

Column J: Insert $ value of All Price Changes for the Quarter

Please Note: Record ONLY the Change in $Dollar value Column K: Insert the $ dollar value for gain in physical inventory for the current quarter.

Column L: Insert the $ dollar value for losses in physical inventory for current quarter.

Column M: Insert current quarter quantity ending balance Column N: Formula calculates the total $ value of (C, D, E, F, G, H, J, K, and L) of current quarter ending balances.

Column P: Insert the dollar $ Value of the assets with the condition codes listed.

Column Q: Insert the dollar $ Value of the assets with the condition codes listed.

Column R: Insert the dollar $ Value of the assets with the condition codes listed.

Column S: Insert the dollar $ Value of all assets remaining.

Column T: Formula calculates the total $ value of (P, Q , R, and S) of the current quarter ending balances.

TAB 2

Submit all transactions that make up the information in columns (D, E, F, G, H, I, J, K, L) of Tab 1

TAB 3

Submit all details supporting the total in Column T of Tab 1 identified by Condition Codes Please Note: Columns N and T of Tab 1 SHOULD Equal; If not, please explain why in Rows 7 to 17 text box.

Column T is a summary by condition code of Columns P through S

Summary

USAF CFO REPORT - Instructions on how to Complete Report

TRANSACTION DETAIL

ENDING BALANCE LIST OF ASSETS BY CONDITION CODE

Insert the dollar $ Value of in-transits. Only use this field if you have the capability to capture spares that have shipped but not yet received at destination. Until the receipt acknowledgement is received, in-transits must be included as part of ending inventory. If you do not have the capability, skip this column.

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

1230967748C Highlight

CDRL A028, Attachment 1, TAB 1 Summary CFO Report Template Page 2 of 4

A B C D E F G H I J K L M N O P Q R S T (AF, Army or Navy ) - (C-20 or C-37)

Select Prior Quarter Select Prior Quarter Select Current Quarter Select Current Quarte Select Current Quarter

Ending Balance Prior Quarter

$ Value

Ending Balance Prior Quarter

Quantity

Beginning Balance Current Quarter

$ Value

New Acquisitions (Delivered) - D4S

$ Value

Customer Returns - D6x

$ Value

Shipments/Issue - D7x

$ Value

In-Transits

$ Value

Disposals - D7J

$ Value

Condition Code Changes - D8C/D9C

$ Value

Price Change - DBx/DCx

$ Value

Physical Inventory Adjustments - Gains -

D8x $ Value

Physical Inventory Adjustments - Losses -

D9x $ Value

Ending Balance

Quantity

Ending Balance (Total of Columns:

C, D, E, F, G, H, J, K, L) $ Value

Serviceable Condition Codes (A,B,C,D)

$Value

Assets in Condition Codes: E,J K,L,Q

$Value

Unserviceable Condition Codes

(F,G,M,R) $ Value

Assets in All other Condition

Codes $Value

Total Dollar Value (Total of Column P, Q, R and S)

$ Value

$0.00 $0.00

Justification Required if Columns N and T do not match:

SPARE PARTSName of Program and DoDAAC:

CDRL A028, Attachment 1: Tab 2 Transaction Detail CFO Report Template Page 3 of 4

A B C D E F G H I J K

Transaction Code Code Description Program NSN Part Number Nomenclature Unit of Issue Qty Condition Code Unit Cost Extended Cost

Transaction Details

CDRL A028, Attachment 1: Tab 3 Ending Balance CFO Report Template Page 4 of 4

A B C D E F G H I

Program NSN Part Number Nomenclature Unit of Issue Qty Condition Code Unit Cost Extended Cost

Ending Balance List of Assets by Condition Code