Att 10 - TDL CDRL attachment COR_TPOC Dec 2024.xlsx
XLSX spreadsheet 71 KB Posted
- Solicitation number
- N0042126R3006
About this file
This file is a template for a Contracting Officer's Representative (COR) Management Report for Technical Direction Letters (TDLs), designed to track and report on contract performance, funding, and deliverables under a contract with the Naval Air Warfare Center Aircraft Division (NAWCAD) Webster Outlying Field (WOLF). The template is structured as an Excel workbook with multiple tabs, one for each individual TDL, containing standardized fields for contract identification, labor tracking, travel expenses, material purchases, and other direct costs (ODC).
The template requires contractors to document labor costs by category and employee identifier, tracking both estimated and actual expenditures, hours (regular and uncompensated time), funding balances, and estimates at completion (EAC). For each reporting period, contractors must complete six mandatory narrative sections: progress against milestones with identification of key personnel, problem areas and solutions, schedule status, deliverable status with CDRL tracking, plans for the next reporting period, and identification of new or proposed subcontractors with their capability sets. The template includes standardized tracking for material purchases (with purchase order numbers, vendors, quantities, unit prices, estimated versus actual costs, and disposition), travel expenses (with traveler information, destinations, dates, costs, and government approval documentation), and monthly funding and expenditure charts. The document is designed to be completed for each TDL within a contract, with sample data provided showing a 12-month period of performance with funding amounts ranging from $25,000 to $15,000,000 per month and corresponding expenditure tracking.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Att L1 - Section L.pdf | ||
| Draft Solicitation - N0042126R3006.pdf | ||
| Att 06 - List of Authorized Key Personnel.pdf | ||
| Att 09 - TDL CDRL attachment COR only Dec 2024.xlsx | XLSX spreadsheet | |
| Att M1 - Section M.pdf | ||
| Att 01 - SOW.pdf | ||
| Att 07 - COR Designation Letter.pdf | ||
| Att C2 - Cost Reimbursable Narrative.docx | DOCX document | |
| Att L2 - Labor Hours in Section L.xlsx | XLSX spreadsheet | |
| Att P1 - Key Personnel.docx | DOCX document | |
| Att 02 - CSP.pdf | ||
| Att 04 - CSWF Qualification Matrix.xlsx | XLSX spreadsheet | |
| Att 05 - Data Item Transmittal Form.pdf | ||
| Att 08 - OCI List.pdf | ||
| Att 11 - List of Approved Subcontractors.pdf | ||
| Att 12 Wage Determination.pdf | ||
| Att C1 - Cost Reimbursable Workbook - TES revised.xlsx | XLSX spreadsheet | |
| Att 03 - DD254 Security Classification Specification.pdf | ||
| Att C3 - Fixed Time and Material Price Narrative.docx | DOCX document | |
| Att T1 - Sample Tasks.docx | DOCX document |
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 .