Attachment 5 - Qtrly CDRL Reporting Tool Template.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- FA8051-25-Q-0001
About this file
This file is a Contract Data Requirements List (CDRL) quarterly reporting template in Excel format used for tracking contract order details and spend data. The spreadsheet contains multiple tabs for tracking current open orders, quarterly reports, annual reports, and contract spend data specifically for contract FA8051-25-Q-0001.
The template includes fields for tracking delivery order numbers, CLINs, descriptions, quantities, unit prices, extended prices, order dates, required delivery dates, shipping dates, ordering organizations, payment types, and comments. It also contains formulas to calculate total spending by fiscal year quarters from FY24 through FY28, with automatic summation of total contract dollars spent and remaining ceiling amounts. The file includes an SQL query that appears to be used for pulling historical order data from a database system.
View the file
Other files
Show all 13
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
KTR Current Open Orders QUARTER ORDERED BASIC_CONTRACT_NUMBER DELIVERY_ORDER or GPC Order CLIN CLIN_DESCRIPTION QTY PURCHASED UNIT_PRICE EXTENDED_PRICE ORDER_DATE Contract RDD Revised RDD SHIP_DATE ORDERING_ORGANIZATION STATE PAYMENT_TYPE COMMENTS
KTR Qtrly (i.e 25Q2) Rpt REPORTING_QUARTER BASIC_CONTRACT_NUMBER DELIVERY_ORDER or GPC Order CLIN CLIN_DESCRIPTION QTY PURCHASED UNIT_PRICE EXTENDED_PRICE ORDER_DATE Contract RDD Revised RDD SHIP_DATE ORDERING_ORGANIZATION STATE PAYMENT_TYPE COMMENTS
KTR Annual Rpt to Date ANNUAL REPORTING BASIC_CONTRACT_NUMBER DELIVERY_ORDER or GPC Order CLIN CLIN_DESCRIPTION QTY PURCHASED UNIT_PRICE EXTENDED_PRICE ORDER_DATE Contract RDD Revised RDD SHIP_DATE ORDERING_ORGANIZATION STATE PAYMENT_TYPE COMMENTS
KTR Contract Spend Data
| FA8051-25-Q-0001 | ||
| ANNUNAL REPORTING | $$ Expended | COMMENTS |
| FY24Q1 | |
| FY24Q2 | |
| FY24Q3 | |
| FY24Q4 | |
| FY24 Total | $ - 0 |
| FY25Q1 | |
| FY25Q2 | |
| FY25Q3 | |
| FY25Q4 | |
| FY25 Total | $ - 0 |
| FY26Q1 | |
| FY26Q2 | |
| FY26Q3 | |
| FY26Q4 | |
| FY26 Total | $ - 0 |
| FY27Q1 | |
| FY27Q2 | |
| FY27Q3 | |
| FY27Q4 | |
| FY27 Total | $ - 0 |
| FY28Q1 | |
| FY28Q2 | |
| FY28Q3 | |
| FY28Q4 | |
| FY28 Total | $ - 0 |
| TOTAL $$ to date | $ - 0 |
Total Contract $$ Amount $ - 0
Remaining Ceiling $ - 0
SQL
SELECT
'FY23Q2' REPORTING_QUARTER
, 'ADS, INC.' CONTRACTOR
, nmr.ORDER_NUMBER CONTRACTOR_ORDER_NUMBER , olc.DLA_CONTRACT_NUMBER BASIC_CONTRACT_NUMBER , nmr.CUSTOMER_PO_NUMBER DELIVERY_ORDER , nmr.LINE_NUMBER CLIN , nmr.ITEM_DESCRIPTION CLIN_DESCRIPTION , nmr.ORDERED_QUANTITY QTY_PURCHASED , nmr.SO_UNIT_SELLING_PRICE UNIT_PRICE , nmr.SO_LINE_TOTAL_VALUE EXTENDED_PRICE , nmr.DATE_ORDERED ORDER_DATE , TO_DATE(olc.CONTRACT_REQUIRED_DATE, 'MM/DD/YYYY') RDD , nmr.ACTUAL_SHIPMENT_DATE SHIP_DATE , nmr.CUSTOMER ORDERING_ORGANIZATION , nmr.PAYMENT_TYPE_CODE PAYMENT_TYPE FROM XXADS_DW.XXADS_NET_MARGIN_REPORT_DW nmr LEFT JOIN XXADS_DW.XXADS_OE_ORDER_LIFE_CYCLE_MV olc ON nmr.OE_HEADER_ID = olc.HEADER_ID AND nmr.OE_LINE_ID = olc.LINE_ID WHERE nmr.SALES_CHANNEL IN
('AF FES PPE FA805122D0003',
'AF FES PPE FA8056-17-D-0001',
'AF FES PPE FA8056-17-D-0002',
'AF FES PPE FA8056-17-D-0005',
'AF FES FFH FA805122D0004')
AND nmr.ORDER_TYPE = 'Standard Sales Order' AND UPPER(nmr.LINE_STATUS) NOT LIKE '%CANCEL%' AND nmr.ORDER_STATUS IN ('Booked','Entered','Closed') ORDER BY nmr.ORDER_NUMBER, nmr.LINE_NUMBER
File details come from the government source that posted it. Updated .