Att 09 TDL CDRL attachment COR_TPOC.xlsx
XLSX spreadsheet 54 KB Posted
- Solicitation number
- N0042126R1006
About this file
This is a template for a Contracting Officer's Representative (COR) Management Report for Technical Direction Letters (TDLs), designed to track and report on task-level work, funding, labor, travel, materials, and other direct costs across multiple contract periods.
The template requires contractors to establish one tab per TDL and populate fields including prime contract number, task order number, invoice information, period of performance dates, billing periods, project name, CLIN, TDL number, and subtask identification. For each TDL, contractors must document labor categories with employee identifiers, estimated and funded amounts/hours, current and cumulative expenditures, funding balances, and hour balances. The template tracks travel costs, material purchases (including PO numbers, vendor information, quantities, unit prices, estimated versus actual costs, and government approvals), and other direct costs. Additionally, contractors must provide monthly funding and expenditure tracking across a 12-month period, including funded amounts, expenditures to date, estimate at completion (EAC), and estimates. The template mandates narrative sections addressing: progress against milestones with identification of key personnel and prime contractor value-added work; problem areas affecting technical, schedule, or cost elements with recommendations; schedule status; deliverable status with CDRL numbers and cumulative listings; plans for the next reporting period; and identification of new or proposed subcontractors with capability assessments. The sample data shows labor charges of $150,000 estimated ($75,000 funded) for a Senior Analyst position, with monthly funding ranging from $25,000 to $15,000,000 and cumulative expenditures reaching approximately $15.86 million by month 12.
View the file
Other files
Show all 37
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 .