Att 08 TDL CDRL attachment COR_TPOC.xlsx
XLSX spreadsheet 59 KB Posted
- Attached to
- NAWCAD WOLF Aegis
- Solicitation number
- N00421-25-R-0004
About this file
This Excel document is a Technical Direction Letter (TDL) CDRL attachment template for a Contracting Officer's Representative (COR) management report. The template is designed for tracking and reporting contract performance across multiple technical direction letters, with detailed sections for labor, travel, material purchases, and other direct costs. Each TDL (Technical Direction Letter) includes comprehensive financial tracking, including funded amounts, expenditures, estimated at completion (EAC), and monthly funding breakdowns.
The template requires contractors to provide detailed reporting on six key areas: (a) progress against milestones, (b) problem area identification, (c) schedule status, (d) deliverable status, (e) upcoming activity plans, and (f) subcontractor information. The document is associated with a Naval Air Warfare Center Aircraft Division (NAWCAD) procurement for the Webster Outlying Field (WOLF) Ship & Air Integrated Warfare (SAIW) Division, specifically for an Aegis Radio Communication System (RCS) procurement. The template supports tracking of contract performance with granular financial and operational details across multiple technical direction letters.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N00421-25-R-0004 Draft RFP Final.pdf | ||
| Att 01 DD254.pdf | ||
| Att 03 Data Item Transmittal Form.docx | DOCX document | |
| Att C2 Cost Reimbursable Narrative.docx | DOCX document | |
| Att C4 Government Labor Hours.xlsx | XLSX spreadsheet | |
| Att T1 Sample Tasks.docx | DOCX document | |
| Exhibit A CDRLs.docx | DOCX document | |
| Att 04 COR Designation Letter.pdf | ||
| Att 06 List of Approved Subcontractors.pdf | ||
| Att 07 QASP_CSP.docx | DOCX document | |
| Att 10 Small Business Subcontracting Plan.pdf | ||
| Att T2 Key Personnel.docx | DOCX document | |
| Att 02 Authorized Key Personnel.pdf | ||
| Att 05 OCI List.docx | DOCX document | |
| Att 09 TDL CDRL attachment COR only.xlsx | XLSX spreadsheet | |
| Attachment C1 - Cost Reimbursable Workbook.xlsx | XLSX spreadsheet | |
| Att C3 Fixed Price TM Narrative.docx | DOCX document | |
| Att C5 Contract CLIN Structure.pdf | ||
| Att S1 SBPCD.docx | DOCX document | |
| Att 11 Wage Determinations.pdf |
Show all 20
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
Title Page Definition
| Title Page | |
| Title | Definition |
| Contractor's Name | Enter the name of the contractor |
| Contractor's Address | Enter the address of the contractor |
| Title of Report | Enter the Title of Report ( Contracting Officer’s Representative (COR) Management Report for Technical Direction Letters (TDLs)) |
| CDRL # | Enter the CDRL number (Pull from awarded CDRLs) |
| Date of Report | Enter the date the report is being generated |
| Period Covered by Report | Enter the dates this report covers (start date through end date) |
| Contract Number | Enter the contract number |
| Task Order Number | Enter the task order number |
| Name of issuing Government Agency | Provide the name of the Government Agency (NAWCAD WOLF XXXX Division) |
| Program/System Nomenclature | Enter the name of the Contract |
| Security Classification or other appropriate markings | Enter the security classification or other appropriate markings (i.e. CUI, Proprietary) |
Title Page
| TDL CDRL attachment COR/TPOC December 2024 | |
| Contractor's Name | |
| Contractor's Address | |
| Title of Report | |
| CDRL # | |
| Date of Report | |
| Period Covered by Report | |
| Contract Number | |
| Task Order Number | |
| Name of issuing Government Agency | |
| Program/System Nomenclature | |
| Security Classification or other appropriate markings | |
| Instructions: | |
| A tab should be added for each individual TDL | |
| Data in all cells on all tabs is sample data only | |
| Rows can be added, do not change the columns | |
| Ensure work accomplishments sections a - f are completed for each TDL |
CDRL# & Title TO Number
TDL Breakout Definition TDL 1 Breakout One tab per TDL - Definition
| Column Title | Definitions | |
| Prime Contract No | Enter the Prime Contract Number | |
| TO Number | Enter the Task Order (TO) Number | |
| Invoice Number | Enter the Contractor Invoice Number | |
| Invoice Date | Enter the date the Invoice is generated | |
| PoP Start | Enter the TO/Option Period of Performance Start date | |
| PoP End | Enter the TO/Option Period of Performance End date | |
| Billing Period | Enter the Billing Period (Start Date through End Date) | |
| Project Name | Enter the Technical Direction Letter Title | |
| CLIN | Enter the CLIN number | |
| TDL # | Enter the Technical Direction Letter Number | |
| Subtask # (If Applicable) | Enter the Subtask number (If Applicable) | |
| Description | Enter a high level description of the TDL | |
| LCAT | Enter the Labor Categories applicable to the TDL (Note: Rows can be added as needed) | |
| Employee Identifier | Enter the Employee's Contractor Identification Number | |
| Date Issued | Enter the Date TDL was signed by the KO | |
| LABOR | Estimated Amount $ | Enter the Estimated TDL Value (numbers) |
| Estimated HRS | Enter the Estimated TDL Hours | |
| Funding Received $ | Enter the Funding Received per the latest MOD (dollar amount) | |
| Funded Hrs | Enter the Funded Hours per the latest MOD | |
| Current Expenditures | Enter the Expenditures for the current reporting period (dollar amount) | |
| Funding Balance | Enter the funding balance (Funding Received - Cost Incurred To-Date) | |
| Funded HRS Bal | Enter the funding hours balance (Funded Hours - Total Current Hours) | |
| Outstanding Commitments | Enter any outstanding labor commitments (i.e. subcontractor costs) | |
| Cost Incurred To-Date (Total) | Enter total Cumulative Expenditures to-date to include outstanding labor commitments | |
| Current Reg Hrs | Enter the Current Regular Hours expended for the reporting period | |
| Current UT/TTA Hrs | Enter in current Uncompensated Time/Total Time Accounting hours for the reporting period | |
| Total Current Hrs | Enter the Total Current Expended Hours for the reporting period (Current Reg Hrs. + Current UT/TTA Hrs.) | |
| Cumulative Reg Hrs | Enter the Cumulative Reg Hours Expended for the TO/Option PoP | |
| Cumulative UT/TTA Hrs | Enter the Cumulative Uncompensated Time/Total Time Accounting Hours Expended for the TO/Option PoP | |
| Total Cumulative Hrs | Enter the Cumulative Hours Expended for the TO/Option PoP (Cumulative Reg Hours + Cumulative UT/TTA Hrs.) | |
| EAC | Enter the projected Estimate at Completion (What will the total cost be at the end of the TO/Option PoP) | |
| Projected date for 75% notification (Based on expenditure to-date) | Enter the date when 75% of the funding will be exhausted | |
| TRAVEL | Current Travel | Enter the current travel cost for the reporting period |
| Cumulative Travel | Enter the total cumulative travel cost for the TO/Option PoP | |
| Outstanding Commitments | Enter any outstanding travel commitments | |
| MATERIAL | Current Material | Enter the current material cost for the reporting period |
| Cumulative Material | Enter the cumulative material cost for the TO/Option PoP | |
| Outstanding Commitments | Enter any outstanding material commitments | |
| OTHER ODC | Current Other ODC | Enter the current cost for any other ODCs for the reporting period (i.e. field services) |
| Cumulative Other ODC | Enter the cumulative cost for any other ODCs for the TO/Option PoP (i.e. field services) | |
| Outstanding Commitments | Enter any other outstanding ODC commitments (i.e. field services) | |
| MATERIAL PURCHASES | PO# | Enter the Purchase Order Number for the material |
| Subtask (if applicable) | Enter the Subtask number if Material is specific to a Subtask on the TDL | |
| Description | Enter a high level description of the Material purchased | |
| Invoice Number | Enter the Invoice Number the Material was purchased under | |
| Purpose | Enter the reason for the Material purchase (this should include the specific project supported) | |
| Vendor | Enter the Vendor the material was purchased from | |
| Quantity | Enter the Quantity purchased | |
| Unit Price | Enter the Unit Price for the Material | |
| Estimated Cost | Enter the Estimated Cost for the Material | |
| Actual Cost | Enter the Actual Cost for the Material | |
| Variance (between estimated and actual costs) | Enter the Difference in the cost (Actual Cost - Estimated Cost) | |
| Gov Approver if required by Contract | Who from the Government approved the material purchase, if under approval thresholds, who was the material purchased for. | |
| Disposition | What is the disposition of the Material (i.e. has the material been transferred to the Government; is it still in the Contractor's possession) | |
| Cumulative Total: | Enter the Cumulative Total of Material purchased during the reporting period (should match the Current Material column) | |
| TRAVEL | Traveler | Enter the Traveler's name |
| Subtask (if applicable) | Enter the Subtask number if Travel is specific to a Subtask on the TDL | |
| Destination | Enter the Traveler's destination | |
| Purpose | Enter the reason for the travel | |
| Date of Travel | Enter the date the travel commenced | |
| Length (days) | Enter the total number of days for the trip | |
| Estimated Cost | Enter the estimated cost for the trip | |
| Actual Cost | Enter the actual Cost for the trip | |
| Variance (between estimated and actual costs) | Enter the Difference in the cost (Actual Cost - Estimated Cost) | |
| Justification | Enter the Justification for the travel (this should include the specific project supported) | |
| Government approver | Enter the Government Approver | |
| Government approval date | Enter the date the Government provided Approval | |
| Cumulative Total: | Enter the Cumulative Total of Travel during the reporting period (should match the Current Travel column) |
TDL 1 Breakout One tab per TDL
| TDL CDRL attachment COR/TPOC December 2024 |
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP Start |
| PoP End |
| Billing Period |
| LABOR | Travel | Material | Other ODC | ||||||||||||||||||||||||||||||
| Project Name | CLIN | TDL # | Subtask # (If Applicable) | Description | LCAT | Employee Identifier | Date Issued | Estimated Amount $ | Estimated HRS | Funding Received $ | Funded Hrs | Current Expenditures | Funding Balance | Funded HRS Bal | Outstanding Commitments | Cost Incurred To-Date (Total) | Current Reg Hrs | Current UT/TTA Hrs | Total Current Hrs | Cumulative Reg Hrs | Cumulative UT/TTA Hrs | Total Cumulative Hrs | EAC | Projected date for 75% notification (Based on expenditure to-date) | Current Travel | Cumulative Travel | Outstanding Commitments | Current Material | Cumulative Material | Outstanding Commitments | Current Other ODC | Cumulative Other ODC | Outstanding Commitments |
| TDL1 | SME SPT LOE 12 mo | Analyst, Senior | 50012345 | 1-Oct-20 | $ 150,000.00 | 1250.00 | $ 75,000.00 | 625 | $ 37,500.00 | $ 37,500.00 | 145 | $ 3,600.00 | $ 41,100.00 | 160 | 0 | 160 | 480 | 10 | 490 | $ 1,248.00 | 25-Mar-21 | 0 | 0 | 1350 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| *Add Rows as needed | |||||||||||||||||||||||||||||||||
| Material Purchases | |||||||||||||||||||||||||||||||||
| PO# | Subtask (if applicable) | Description | Invoice Number | Purpose | Vendor | Quantity | Unit Price | Estimated Cost | Actual Cost | Variance (between estimated and actual costs) | Gov Approver if required by Contract | Disposition |
Cumulative Total:
| Travel | |||||||||||
| Traveler | Subtask (if applicable) | Destination | Purpose | Date of Travel | Length (days) | Estimated Cost | Actual Cost | Variance (between estimated and actual costs) | Justification | Government approver | Government approval date |
Cumulative Total:
*Field Services or other ODC fields to be added based on specific procurement requirements
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | *Adjust Title and Columns/Rows as needed (i.e. Pop/Invoice # or title or add additional months if needed) | |
| FUNDED | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 120,000.00 | $ 350,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | *Total TDL Funding based on the data provided above |
| Expenditures to Date | $ 15,000.00 | $ 22,500.00 | $ 24,500.00 | $ 50,000.00 | $ 75,000.00 | $ 100,000.00 | $ 13,000,000.00 | $ 14,000,000.00 | $ 14,100,000.00 | $ 14,589,000.00 | $ 15,552,412.00 | $ 15,860,000.00 | *Total TDL Expenditures to date based on the data provided above |
| EAC | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | *Total TDL EAC based on the data provided above |
| Estimate | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | *Total TDL Estimate based on the data provided above |
a. Description of the progress made against milestones during the reporting period. Specifically address the value-added tasks performed by the prime contractor when work is performed by a subcontractor; clearly identify the key and non-key personnel performing the tasks described.
b. Identification of problem areas affecting technical, scheduling, or costs elements with background and any recommendations for solutions beyond the scope of the contract. Specifically, address results, positive or negative, obtained related to previously-identified program areas, with conclusions and recommendations for solutions.
c. Whether the task is on schedule, ahead of schedule, or behind schedule. Discuss what steps are being or will be taken to complete all requirements on time if possible, or provide a proposed revised schedule based on best current estimates if behind schedule.
d. The status of all assigned deliverables, including title, CDRL number, due date, date delivered, Contractor point of contact and description or title of deliverable(s). The report for each contract period shall include a cumulative list of all deliverable items provided.
e. Plans and recommendations for activities at TDL level during the next reporting period;
f. Identify any new subcontractors approved during the reporting period and any proposed subcontractors/consultants for the next reporting period. Their capability set and areas of expertise shall be thoroughly addressed.
FUNDED Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 25000 25000 25000 120000 350000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 Expenditures to Date Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000 22500 24500 50000 75000 100000 13000000 14000000 14100000 14589000 15552412 15860000 EAC Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 Estimate Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000
This section of the deliverable may be submitted in Microsoft Word or as a Separate PDF document.
TDL 2 Breakout
| TDL CDRL attachment COR/TPOC December 2024 |
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP Start |
| PoP End |
| Billing Period |
| LABOR | Travel | Material | Other ODC | ||||||||||||||||||||||||||||||
| Project Name | CLIN | TDL # | Subtask # (If Applicable) | Description | LCAT | Employee Identifier | Date Issued | Estimated Amount $ | Estimated HRS | Funding Received $ | Funded Hrs | Current Expenditures | Funding Balance | Funded HRS Bal | Outstanding Commitments | Cost Incurred To-Date (Total) | Current Reg Hrs | Current UT/TTA Hrs | Total Current Hrs | Cumulative Reg Hrs | Cumulative UT/TTA Hrs | Total Cumulative Hrs | EAC | Projected date for 75% notification (Based on expenditure to-date) | Current Travel | Cumulative Travel | Outstanding Commitments | Current Material | Cumulative Material | Outstanding Commitments | Current Other ODC | Cumulative Other ODC | Outstanding Commitments |
| TDL2 | System "X" Installation | Analyst, Senior | 50012345 | 1-Oct-20 | $ 150,000.00 | 1250.00 | $ 75,000.00 | 625 | $ 37,500.00 | $ 37,500.00 | 145 | $ 3,600.00 | $ 41,100.00 | 160 | 0 | 160 | 480 | 10 | 490 | $ 1,248.00 | 25-Mar-21 | 0 | 0 | 1350 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| *Add Rows as needed | |||||||||||||||||||||||||||||||||
| Material Purchases | |||||||||||||||||||||||||||||||||
| PO# | Subtask (if applicable) | Description | Invoice Number | Purpose | Vendor | Quantity | Unit Price | Estimated Cost | Actual Cost | Variance (between estimated and actual costs) | Gov Approver if required by Contract | Disposition |
Cumulative Total:
| Travel | |||||||||||
| Traveler | Subtask (if applicable) | Destination | Purpose | Date of Travel | Length (days) | Estimated Cost | Actual Cost | Variance (between estimated and actual costs) | Justification | Government approver | Government approval date |
Cumulative Total:
*Field Services or other ODC fields to be added based on specific procurement requirements
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | *Adjust Title and Columns/Rows as needed (i.e. Pop/Invoice # or title or add additional months if needed) | |
| FUNDED | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 120,000.00 | $ 350,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | *Total TDL Funding based on the data provided above |
| Expenditures to Date | $ 15,000.00 | $ 22,500.00 | $ 24,500.00 | $ 50,000.00 | $ 75,000.00 | $ 100,000.00 | $ 13,000,000.00 | $ 14,000,000.00 | $ 14,100,000.00 | $ 14,589,000.00 | $ 15,552,412.00 | $ 15,860,000.00 | *Total TDL Expenditures to date based on the data provided above |
| EAC | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | $ 15,860,000.00 | *Total TDL EAC based on the data provided above |
| Estimate | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | $ 15,000,000.00 | *Total TDL Estimate based on the data provided above |
a. Description of the progress made against milestones during the reporting period. Specifically address the value-added tasks performed by the prime contractor when work is performed by a subcontractor; clearly identify the key and non-key personnel performing the tasks described.
b. Identification of problem areas affecting technical, scheduling, or costs elements with background and any recommendations for solutions beyond the scope of the contract. Specifically, address results, positive or negative, obtained related to previously-identified program areas, with conclusions and recommendations for solutions.
c. Whether the task is on schedule, ahead of schedule, or behind schedule. Discuss what steps are being or will be taken to complete all requirements on time if possible, or provide a proposed revised schedule based on best current estimates if behind schedule.
d. The status of all assigned deliverables, including title, CDRL number, due date, date delivered, Contractor point of contact and description or title of deliverable(s). The report for each contract period shall include a cumulative list of all deliverable items provided.
e. Plans and recommendations for activities at TDL level during the next reporting period;
f. Identify any new subcontractors approved during the reporting period and any proposed subcontractors/consultants for the next reporting period. Their capability set and areas of expertise shall be thoroughly addressed.
FUNDED Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 25000 25000 25000 120000 350000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 Expenditures to Date Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000 22500 24500 50000 75000 100000 13000000 14000000 14100000 14589000 15552412 15860000 EAC Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 15860000 Estimate Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000 15000000
This section of the deliverable may be submitted in Microsoft Word or as a Separate PDF document.
Sheet1
File details come from the government source that posted it. Updated .