Att 10 TDL CDRL attachment COR only.xlsx
XLSX spreadsheet 66 KB Posted
- Solicitation number
- N0042126R1006
About this file
This is a Contracting Officer's Representative (COR) management template and reporting tool for Technical Direction Letters (TDLs) on a federal contract. The spreadsheet serves as a CDRL (Contract Data Requirements List) attachment designed to track and report contract performance, costs, and resource utilization across multiple task orders and contract line items (CLINs). The template includes a minimum of six tabs that allow CORs to monitor labor hours, travel expenses, material purchases, and other direct costs (ODCs) against budgeted and funded amounts. Key tracking elements include awarded ceiling amounts for labor, travel, and materials by CLIN; cost incurred and outstanding commitments; burn rate analysis; personnel data with labor categories and rates; and monthly spend plans showing budgeted versus actual costs and hours. The template calculates variance between bid rates and operating rates, tracks percentage of ceiling expended, provides estimates at completion (EAC), and projects dates when 75% of funding will be exhausted for proactive management.
The template is designed specifically for the NAWCAD (WOLF) Ship and Air Integrated Warfare Division Small Unmanned Aircraft Systems (SUAS) Reusable Architecture (SRA) contract (Solicitation N0042126R1006) under the Naval Air Systems Command. It captures contractor information, prime contract numbers, task order details, invoice data, period of performance dates, and provides detailed financial breakdowns by CLIN and TDL. The Rate Analysis tab enables tracking of individual employee identifiers, labor categories, on/off-site status, key versus non-key personnel designations, with approval dates for resume submissions. The COR ODC Roll Up Reporting section documents material purchases, travel, and field services with vendor information, estimated versus actual costs, variance analysis, and government approval documentation. All data shown is sample data only, and the template allows for additional rows to accommodate multiple CLINs, TDLs, subtasks, and personnel as needed.
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
Definitions
| Title Page | IDIQ Basic Roll Up | COR TO Data Breakout | Rate Analysis COR only file | COR Spend Plan per CLIN* | COR ODC Roll Up Reporting | ||||||||||
| Title | Definition | Title | Definition | Title | Definition | Title | Definition | Title | Definition | Title | Definition | ||||
| Contractor's Name | Enter the name of the contractor | Prime Contract No | Enter Prime Contract Number | Prime Contract No | Enter the Prime Contract Number | Prime Contract No | Enter the Prime Contract Number | Prime Contract No | Enter the Prime Contract Number | Prime Contract No | Enter the Prime Contract Number | ||||
| Contractor's Address | Enter the address of the contractor | Invoice Number | Enter the Contractor Invoice Number | TO Number | Enter the Task Order Number | TO Number | Enter the Task Order Number | TO Number | Enter the Task Order (TO) Number | TO Number | Enter the Task Order (TO) Number | ||||
| Title of Report | Enter the Title of Report ( Contracting Officer’s Representative (COR) Management Report for Technical Direction Letters (TDLs)) | Invoice Date | Enter the date the Invoice is generated | Invoice Number | Enter the Contractor Invoice Number | Invoice Number | Enter the Contractor Invoice Number | Invoice Number | Enter the Contractor Invoice Number | Invoice Number | Enter the Contractor Invoice Number | ||||
| CDRL # | Enter the CDRL number (Pull from awarded CDRLs) | PoP Start | Enter the Contract/IDIQ Period of Performance Start date | Invoice Date | Enter the date the Invoice is generated | Invoice Date | Enter the date the Invoice is generated | Invoice Date | Enter the date the Invoice is generated | Invoice Date | Enter the date the Invoice is generated | ||||
| Date of Report | Enter the date the report is being generated | PoP End | Enter the Contract/IDIQ Period of Performance End date | PoP Start | Enter the TO/Option Period of Performance Start date | PoP Start | Enter the TO/Option Period of Performance Start date | PoP Start | Enter the TO/Option Period of Performance Start date | PoP Start | Enter the TO/Option Period of Performance Start date | ||||
| Period Covered by Report | Enter the dates this report covers (start date through end date) | Billing Period | Enter the Billing Period (Start Date through End Date) | PoP End | Enter the TO/Option Period of Performance End date | PoP End | Enter the TO/Option Period of Performance End date | PoP End | Enter the TO/Option Period of Performance End date | PoP End | Enter the TO/Option Period of Performance End date | ||||
| Contract Number | Enter the contract number | TO period | Enter the current Option Year the Contract/TO is in (i.e. Base, OPT I, OPT II) | Billing Period | Enter the Billing Period (Start Date through End Date) | Billing Period | Enter the Billing Period (Start Date through End Date) | Billing Period | Enter the Billing Period (Start Date through End Date) | ||||||
| Task Order Number | Enter the task order number | Contract Summary - Update this section with each MOD that adjusts the ceiling | Billing Period | Enter the Billing Period (Start Date through End Date) | Prime | Enter the Prime Contractors Name | Dollars (Each CLIN should have it's own Graph) | Material Purchases | Item Name | Enter the name of the material that was purchased during the reporting period | |||||
| Name of issuing Government Agency | Provide the name of the Government Agency (NAWCAD WOLF XXXX Division) | CLIN LABOR HRS | Enter the Total Contract/IDIQ CLIN Labor Hrs | Awarded Ceiling Hrs | Enter the Awarded Ceiling Hours for Labor by CLIN (Travel and Material should be N/A) | Subs | Enter the names of any Subcontractors | FUNDED | Enter in the Funded dollar amount for each CLIN and escalate the funding across the TO/Option PoP as appropriate | CLIN | Enter the CLIN the material was purchased under | ||||
| Program/System Nomenclature | Enter the name of the Contract | CLIN LABOR Dollars | Enter the Total Contract/IDIQ CLIN Labor Ceiling | Awarded Ceiling $ | Enter the Awarded Ceiling Amounts for Labor, Travel, and Material by CLIN | CLIN | Enter the CLIN | COSTS | Enter in the anticipated Cost for each month of the TO/Option PoP. As each month completes, update the anticipated cost to be the actual cost. | SubCLIN | Enter the SubCLIN the material was purchased under | ||||
| Security Classification or other appropriate markings | Enter the security classification or other appropriate markings (i.e. CUI, Proprietary) | CLIN TRAVEL | Enter the Total Contract/IDIQ CLIN Travel Ceiling | Cost Incurred | Enter the total Cumulative Expenditures to-date for Labor, Travel, and Material by CLIN | Project | Enter the Technical Direction Letter Title | PROJECTED TOTAL | Enter the estimated total projected cost for each month of the TO/Option PoP (This will not get updated to reflect actual cost each month) | TO/TDL/Subtask | Enter the Task Order/Technical Direction Letter/Subtask (if applicable) | ||||
| CLIN MATERIAL | Enter the Total Contract/IDIQ CLIN Material Ceiling | Outstanding Commitments | Enter any Outstanding Commitments for Labor, Travel, and Material by CLIN | TDL # | Enter the Technical Direction Letter Number | CEILING | Enter the total CLIN ceiling for the TO/Option PoP | PO# | Enter the Purchase Order Number for the material | ||||||
| Cost Incurred w/commitments | Enter the total Cost Incurred plus Outstanding Commitments for Labor, Travel, and Material by CLIN | Personnel Data | Subtask # (If Applicable) | Enter the Subtask number (If Applicable) | Hours (Each CLIN should have it's own Graph) | Description | Enter a high level description of the Material purchased | ||||||||
| Burn Rate | Hours | Enter the Total Contract/IDIQ Hours | Unfunded Ceiling | Enter Unfunded Ceiling for Labor, Travel, and Material by CLIN (Total Ceiling value - Total Funding value) | Employee Identifier | Enter the Employee's Contractor Identification Number | Budgeted | Enter in the budgeted hours for each month of the TO/Option PoP as appropriate | Invoice Number | Enter the Invoice Number the Material was purchased under | |||||
| Labor $ | Enter the Total Contract/IDIQ Labor Ceiling | Balance (funded - Exp) | Enter the remaining funding balance (Total Funding - Cost Incurred w/commitments) for Labor, Travel, and Material by CLIN | LCAT | Enter the Labor Categories applicable to the TDL (Note: Rows can be added as needed) | Billed | Enter in the anticipated hours for each month of the TO/Option PoP. As each month completes, update the anticipated hours to be the actual hours. | Purpose | Enter the reason for the Material purchase (this should include the specific project supported) | ||||||
| Bid Rate | Enter the Overall Contract/IDIQ Bid Rate | % Ceiling Expended Hrs | Enter the percentage of Ceiling Expended for Hours by CLIN | On/Off site | Enter if the LCAT is working On-site or Off-site | PROJECTED | Enter the estimated total projected hours for each month of the TO/Option PoP (This will not get updated to reflect actual hours each month) | Vendor | Enter the Vendor the material was purchased from | ||||||
| Op Rate | Enter the Overall Contract/IDIQ Operating Rate | % Ceiling Expended $ | Enter the percentage of Ceiling Expended for Labor, Travel, and Material by CLIN | Key/Non-Key | Enter if the LCAT is Key or Non-Key | CEILING | Enter the total CLIN hours for the TO/Option PoP | Quantity | Enter the Quantity purchased | ||||||
| Variance | Enter the Difference between the Bid Rate vs the Operating Rate | % Ceiling Expended $ w/commitments | Enter the percentage of Ceiling Expended w/commitments for Labor, Travel, and Material by CLIN | Date Resume submitted | Enter the date the Key Personnel Resume was submitted to the PCO for review* | *Each CLIN will have it's own Graph | Unit Price | Enter the Unit Price for the Material | |||||||
| Percentage | Enter the Variance between the Bid Rate vs the Operating Rate as a percentage | % Funding Expended | Enter the percentage of Funding Expended for Labor, Travel, and Material by CLIN | Date Resume Approved | Enter the date the PCO provided concurrence and approval of the Key Personnel Resume* | Estimated Cost | Enter the Estimated Cost for the Material | ||||||||
| EAC | Enter the Estimate at Completion for Labor, Travel, and Material by CLIN (What will the total CLIN cost be at the end of the TO/Option PoP) | Date Removed (if Applicable) | Enter the date the Key Personnel was removed as Key, if applicable* | Cumulative Total (Estimated Cost) | Enter the Sum of the Estimated Cost | ||||||||||
| Projected funding needed | Enter the Project funding needed for Labor, Travel, and Material by CLIN for the TO/Option PoP | Name of Replacement | Enter the Name of the Key Personnel Replacing the Key Personnel who was removed* | Actual Cost | Enter the Actual Cost for the Material | ||||||||||
| Task Order Summary - This section is broken out by MOD | Budgeted Hrs | Enter the Estimated TDL Hours | Cumulative Total Actual Cost) | Enter the Sum of the Actual Cost | |||||||||||
| Title | Definition | Current Hrs Billed | Enter the Total Current Hours billed for the reporting period (Current Reg Hrs. + Current UT/TTA Hrs.) | Variance (between estimated and actual costs) | Enter the Difference in the cost (Actual Cost - Estimated Cost) | ||||||||||
| CLIN LABOR HRS APPN 1 | Enter the Total Hours by CLIN per the latest MOD | Prior Period Adjustment Hrs | Enter any hours that are adjustments from prior periods | Gov Approver if required by Contract | Who from the Government approved the material purchase, if under approval thresholds, who was the material purchased for. | ||||||||||
| CLIN LABOR Dollars APPN 1 | Enter the Total Labor Ceiling by CLIN per the latest MOD | Cumulative Hrs Billed | Enter the Cumulative Hours billed for the TO/Option PoP (Current Hrs Billed + Prior Period Adjustment Hrs.) | 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) | ||||||||||
| CLIN LABOR HRS APPN 2 | Enter the Total Hours by CLIN per latest the MOD | Current UT/TTA Hrs | Enter in current Uncompensated Time/Total Time Accounting hours for the reporting period | Travel | Traveler | Enter the Traveler's name | |||||||||
| CLIN LABOR Dollars APPN 2 | Enter the Total Labor Ceiling by CLIN per the latest MOD | Cumulative UT/TTA Hrs | Enter in current Uncompensated Time/Total Time Accounting hours for the TO PoP | CLIN | Enter the CLIN the Travel was conducted under | ||||||||||
| CLIN LABOR HRS APPN 3 | Enter the Total Hours by CLIN per the latest MOD | Actual Rate | Current Burdened Cost | Enter the Current Burdened Cost for the reporting period | SubCLIN | Enter the SubCLIN the Travel was conducted under | |||||||||
| CLIN LABOR Dollars APPN 3 | Enter the Total Labor Ceiling by CLIN per the latest MOD | Prior Period Adjustment $ | Enter any adjustments from prior periods | TO/TDL/Subtask | Enter the Contract/Task Order/Technical Direction Letter/Subtask (if applicable) | ||||||||||
| CLIN Travel Dollars APPN 1 | Enter the Total Travel Ceiling by CLIN per the latest MOD | Cumulative Burdened Cost | Enter the Cumulative Burdened Cost for the TO/Option PoP | Destination | Enter the Traveler's destination | ||||||||||
| CLIN Travel Dollars APPN 2 | Enter the Total Travel Ceiling by CLIN per the latest MOD | Projected Total Costs | Enter the Projected Total Costs for the Actual Rate at the end of the TO PoP | Purpose | Enter the reason for the travel | ||||||||||
| CLIN Travel Dollars APPN 3 | Enter the Total Travel Ceiling by CLIN per the latest MOD | Bid Rate | B-1 Approved Rate | Enter the B-1 Approved Rate from Section B of the Contract/TO | Date of Travel | Enter the date the travel commenced | |||||||||
| CLIN Material Dollars APPN 1 | Enter the Total Material Ceiling by CLIN per the latest MOD | Cumulative Burdened Cost | Enter the Cumulative Burdened Cost based on the B-1 Rate for the TO/Option PoP (Cumulative Hrs Billed * B-1 Approved Rate) | Length (days) | Enter the total number of days for the trip | ||||||||||
| CLIN Material Dollars APPN 2 | Enter the Total Material Ceiling by CLIN per the latest MOD | Projected Total Costs | Enter the Projected Total Costs for the Bid Rate at the end of the TO/Option PoP | Estimated Cost | Enter the estimated cost for the trip | ||||||||||
| CLIN Material Dollars APPN 3 | Enter the Total Material Ceiling by CLIN per the latest MOD | Variation | % variation | Enter the Percentage Difference between the Actual Rate vs. the Bid Rate | Cumulative Total (Estimated Cost) | Enter the Sum of the Estimated Cost | |||||||||
| Funding | Enter the Total Funding amount by CLIN per the latest MOD | Justification for variation | Enter a justification for any variation of actual-to-bid rate averages greater than 10% | Actual Cost | Enter the actual Cost for the trip | ||||||||||
| Expended as of date of report | Enter the Cumulative To-Date Expenditures w/Commitments for each CLIN | Cumulative Total (Actual Cost) | Enter the Sum of the Actual Cost | ||||||||||||
| CLIN Breakout | CLIN 1 | * Only Required when Key | Variance (between estimated and actual costs) | Enter the Difference in the cost (Actual Cost - Estimated Cost) | |||||||||||
| Project Name | Enter the Technical Direction Letter Title | Justification | Enter the Justification for the travel (this should include the specific project supported) | ||||||||||||
| TDL # | Enter the Technical Direction Letter Number | Government approver | Enter the Government Approver | ||||||||||||
| Subtask # (If Applicable) | Enter the Subtask number (If Applicable) | Government approval date | Enter the date the Government provided Approval | ||||||||||||
| Description | Enter a high level description of the TDL | ||||||||||||||
| 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 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 Labor 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 | ||||||||||||||
| Projected date for 75% notification (Based on expenditure to-date) | Enter the date when 75% of the Travel funding will be exhausted | ||||||||||||||
| 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 | ||||||||||||||
| Projected date for 75% notification (Based on expenditure to-date) | Enter the date when 75% of the Material funding will be exhausted | ||||||||||||||
| 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) | ||||||||||||||
| Projected date for 75% notification (Based on expenditure to-date) | Enter the date when 75% of the ODC funding will be exhausted |
Title Page TDL CDRL attachment December 2024 COR only
| 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: | |
| There are a minimum of 6 tabs (including the title page) that are to be completed | |
| Data in all cells on all tabs is sample data only | |
| Rows can be added, do not change the columns |
CDRL# & Title TO Number
IDIQ Basic Roll Up TDL CDRL attachment December 2024 COR only
| Prime Contract No | Burn Rate | ||
| Invoice Number | Hours | ||
| Invoice Date | Labor $ | ||
| PoP Start | Bid Rate | ||
| PoP End | Op Rate | ||
| Billing Period | Variance | ||
| Base | Mod 2 | Percentage | |
| Contract Summary | |||
| CLIN LABOR HRS | 3450 | 3450 | |
| CLIN LABOR Dollars | $ 414,000.00 | $ 414,000.00 | |
| CLIN TRAVEL | $ 10,000.00 | $ 5,000.00 | |
| CLIN MATERIAL | $ 20,000.00 | $ 25,000.00 | |
| * Add rows as needed for additional CLINs |
TO Number
COR TO Data Breakout
| TDL CDRL attachment December 2024 COR only | ||||||||||||||||
| Awarded Ceiling Hrs | Awarded Ceiling $ | Cost Incurred | Outstanding Commitments | Cost Incurred w/commitments | Unfunded Ceiling | Balance (funded - Exp) | % Ceiling Expended Hrs | % Ceiling Expended $ | % Ceiling Expended $ w/commitments | % Funding Expended | EAC | Projected funding needed | ||||
| Prime Contract No | Labor | |||||||||||||||
| TO Number | Travel | |||||||||||||||
| Invoice Number | Material | |||||||||||||||
| Invoice Date | Total: | |||||||||||||||
| PoP Start | *Rows can be added for additional CLINs as needed | |||||||||||||||
| PoP End | ||||||||||||||||
| TO period | Base, OPT I, OPT II | |||||||||||||||
| Billing Period | ||||||||||||||||
| Prime | ||||||||||||||||
| Subs | ||||||||||||||||
| TO Summary | TO base | TO mod 2 | TO mod 5 | Funding | Expended as of date of report | |||||||||||
| CLIN LABOR HRS APPN 1 | 1150 | 1225 | 1475 | 575 | 287.5 | |||||||||||
| CLIN LABOR Dollars APPN 1 | $ 138,000.00 | $ 147,000.00 | $ 177,000.00 | $ 69,000.00 | 34500 | |||||||||||
| CLIN LABOR HRS APPN 2 | 1725 | 1725 | 1725 | 575 | 287.5 | |||||||||||
| CLIN LABOR Dollars APPN 2 | $ 207,000.00 | $ 207,000.00 | $ 207,000.00 | $ 69,000.00 | $ 34,500.00 | |||||||||||
| CLIN LABOR HRS APPN 3 | 575 | 500 | 250 | 575 | 287.5 | |||||||||||
| CLIN LABOR Dollars APPN 3 | $ 69,000.00 | $ 60,000.00 | $ 30,000.00 | $ 69,000.00 | $ 34,500.00 | |||||||||||
| CLIN Travel Dollars APPN 1 | $ 6,000.00 | $ 1,000.00 | $ 1,000.00 | $ 1,000.00 | $ 500.00 | |||||||||||
| CLIN Travel Dollars APPN 2 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 1,000.00 | $ - 0 | |||||||||||
| CLIN Travel Dollars APPN 3 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 1,000.00 | $ 500.00 | |||||||||||
| CLIN Material Dollars APPN 1 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 8,000.00 | |||||||||||
| CLIN Material Dollars APPN 2 | $ 5,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 6,000.00 | |||||||||||
| CLIN Material Dollars APPN 3 | $ 5,000.00 | $ 5,000.00 | $ 5,000.00 | $ 2,500.00 | $ 1,500.00 | |||||||||||
| *Rows can be added for additional CLINs as needed |
| LABOR | Travel | Material | Other ODC | ||||||||||||||||||||||||||||||
| 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 | Projected date for 75% notification (Based on expenditure to-date) | Current Material | Cumulative Material | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Other ODC | Cumulative Other ODC | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | |||||
| CLIN 1 | This row is for TDL Cumulative for the CLIN | ||||||||||||||||||||||||||||||||
| Project Name | TDL # | Subtask # (If Applicable) | Description | 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 | Projected date for 75% notification (Based on expenditure to-date) | Current Material | Cumulative Material | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Other ODC | Cumulative Other ODC | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) |
| TDL1 | SME SPT LOE 12 mo | 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 | 25-Apr-21 | 0 | 0 | 0 | 25-May-21 | 0 | 0 | 0 | 25-Sep-21 | ||
| TDL 2 | (Estimated Amt - Funded) | (Funded Hrs - Total Cumulative Reg Hrs) | Labor planned for upcoming trip | (Expenditures to date + outstanding commitments) | (current Reg Hrs + Current UT/TTA Hrs) | (current Cumulative Reg Hrs + Current Cumulative UT/TTA Hrs) | Includes current | Includes current | Includes current | ||||||||||||||||||||||||
| Subtask 1 | |||||||||||||||||||||||||||||||||
| Subtask 2 | |||||||||||||||||||||||||||||||||
| TDL 2 Total: | |||||||||||||||||||||||||||||||||
| TDL 3 | |||||||||||||||||||||||||||||||||
| Subtask 1 | |||||||||||||||||||||||||||||||||
| Subtask 2 | |||||||||||||||||||||||||||||||||
| Subtask 3 | |||||||||||||||||||||||||||||||||
| Subtask 4 | |||||||||||||||||||||||||||||||||
| Subtask 5 | |||||||||||||||||||||||||||||||||
| Subtask 6 | |||||||||||||||||||||||||||||||||
| Subtask 7 | |||||||||||||||||||||||||||||||||
| TDL 3 Total: |
| CLIN 2 | PoP | This row is for TDL Cumulative for the CLIN | |
| TDL1 | |||
| TDL 2 | |||
| Subtask 1 | |||
| Subtask 2 | |||
| Total: | |||
| TDL 3 | |||
| Subtask 1 | |||
| Subtask 2 | |||
| Subtask 3 | |||
| Subtask 4 | |||
| Subtask 5 | |||
| Subtask 6 | |||
| Subtask 7 | |||
| Total: |
TO Totals
| *Rows can be added for additional CLINs as needed |
| Data in all cells on all tabs is sample data |
TO Number
Rate Analysis COR only file
| TDL CDRL attachment December 2024 COR only | ||||||||||||||||||||||||||
| Prime Contract No | ||||||||||||||||||||||||||
| TO Number | ||||||||||||||||||||||||||
| Invoice Number | ||||||||||||||||||||||||||
| Invoice Date | ||||||||||||||||||||||||||
| PoP Start | ||||||||||||||||||||||||||
| PoP End | ||||||||||||||||||||||||||
| Billing Period | ||||||||||||||||||||||||||
| Prime | ||||||||||||||||||||||||||
| Subs | ||||||||||||||||||||||||||
| Personnel Data | Actual Rate | Bid Rate | Variation | |||||||||||||||||||||||
| CLIN | Project | TDL # | Subtask # (If Applicable) | Employee Identifier | LCAT | On/Off site | Key/Non-Key | Date Resume submitted | Date Resume Approved | Date Removed (if Applicable) | Name of Replacement | Budgeted Hrs | Current Hrs Billed | Prior Period Adjustment Hrs | Cumulative Hrs Billed | Current UT/TTA Hrs | Cumulative UT/TTA Hrs | Current Burdened Cost | Prior Period Adjustment $ | Cumulative Burdened Cost | Projected Total Costs | B-1 Approved Rate | Cumulative Burdened Cost | Projected Total Costs | % variation | Justification for variation |
| 1 | SME SPT LOE 12 mo | TDL1 | 1 | 1005218 | Analyst, Senior | On-Site | Key | 1/1/15 | 1/1/15 | N/A | N/A | 1250 | 160 | 0 | 480 | 0 | 10 | $ 120.00 | 0 | $ 57,600.00 | $ 150,000.00 | $ 120.00 | $ 57,600.00 | $ 150,000.00 | 0% | N/A |
| TDL1 Total | 1250 | 160 | 0 | 480 | 0 | 10 | $ 120.00 | 0 | $ 57,600.00 | $ 150,000.00 | $ 120.00 | $ 57,600.00 | $ 150,000.00 | 0% |
| 1 | System "X" Installation | TDL2 | 1 | 1003562 | PM, Senior | Off-site | Key | 1/1/15 | 1/1/15 | N/A | N/A | 45 | 22 | 0 | 32 | 0 | 0 | $ 145.00 | 0 | $ 4,640.00 | $ 6,525.00 | $ 145.00 | $ 4,640.00 | $ 6,525.00 | 0% | N/A |
| 1 | System "X" Installation | TDL2 | 1 | 1005218 | Analyst, Senior | On-Site | Key | 10/1/16 | 10/5/16 | N/A | N/A | 82 | 40 | 0 | 40 | 0 | 0 | $ 120.00 | 0 | $ 4,800.00 | $ 9,840.00 | $ 120.00 | $ 4,800.00 | $ 9,840.00 | 0% | N/A |
| 1 | System "X" Installation | TDL2 | 1 | 1005874 | Analyst, Junior | On-Site | Non-Key | N/A | N/A | N/A | N/A | 157 | 100 | 0 | 125 | 0 | 0 | $ 120.00 | 0 | $ 15,000.00 | $ 18,840.00 | $ 120.00 | $ 15,000.00 | $ 18,840.00 | 0% | N/A |
| 1 | System "X" Installation | TDL2 | 1 | 1005489 | Engineer, Senior | On-Site | Non-Key | N/A | N/A | N/A | N/A | 4520 | 2250 | 0 | 2257 | 0 | 0 | $ 125.00 | 0 | $ 282,125.00 | $ 565,000.00 | $ 125.00 | $ 282,125.00 | $ 565,000.00 | 0% | N/A |
| 1 | System "X" Installation | TDL2 | 1 | 1005987 | Engineer, Junior | On-Site | Non-Key | N/A | N/A | N/A | N/A | 4575 | 2250 | 0 | 3575 | 0 | 0 | $ 75.00 | 0 | $ 268,125.00 | $ 343,125.00 | $ 95.00 | $ 339,625.00 | $ 434,625.00 | 21% | project required specific certification, COR approved 10/1/2015 |
| 1 | System "X" Installation | TDL2 | 2 | 1005289 | Systems Analyst, Journeyman | On-Site | Non-Key | N/A | N/A | N/A | N/A | 1920 | 874 | 0 | 900 | 0 | 0 | $ 95.00 | 0 | $ 85,500.00 | $ 182,400.00 | $ 100.00 | $ 90,000.00 | $ 192,000.00 | 5% | N/A |
| 1 | System "X" Installation | TDL2 | 2 | 1002659 | Systems Analyst, Senior | Off-site | Non-Key | N/A | N/A | N/A | N/A | 1920 | 874 | 0 | 900 | 0 | 0 | $ 105.00 | 0 | $ 94,500.00 | $ 201,600.00 | $ 120.00 | $ 108,000.00 | $ 230,400.00 | 13% | Project required specific systems experience, personnel not available a rate bid |
| TDL2 Total | 13219 | 6410 | 0 | 7829 | 0 | 0 | 0 | $ 754,690.00 | $ 1,327,330.00 | $ 844,190.00 | $ 1,457,230.00 | 39% | $ 1,457,230.00 | 6% | ||||||||||||
| *Data in all cells on all tabs is sample data |
TO Number
COR Spend plan per CLIN
| TDL CDRL attachment December 2024 COR only |
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP Start |
| PoP End |
| Billing Period |
| *This will be a spend plan graph by CLIN |
| Dollars | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |
| 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 |
| COSTS | $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 |
| PROJECTED TOTAL | $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 |
| CEILING | $ 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 |
| Hours | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |
| Budgeted | 3840 | 3840 | 3840 | 3840 | 3840 | 3840 | 3840 | 3840 | 5760 | 5760 | 5760 | 5760 |
| Billed | 450 | 850 | 920 | 1050 | 1500 | 1750 | 2250 | 2550 | 2950 | 3500 | 4500 | 5760 |
| PROJECTED | 3840 | 3840 | 3840 | 3840 | 3840 | 3840 | 5760 | 5760 | 5760 | 5760 | 5760 | 5760 |
| CEILING | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 |
| *Data in all cells on all tabs is sample data |
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 COSTS 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 PROJECTED TOTAL 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 CEILING 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
Budgeted Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 3840 3840 3840 3840 3840 3840 3840 3840 5760 5760 5760 5760 Billed Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 450 850 920 1050 1500 1750 2250 2550 2950 3500 4500 5760 PROJECTED Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 3840 3840 3840 3840 3840 3840 5760 5760 5760 5760 5760 5760 CEILING Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500
COR ODC Roll Up Reporting
| TDL CDRL attachment December 2024 COR only |
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP Start |
| PoP End |
| Billing Period |
| Material Purchases | |||||||||||||||
| Item Name | CLIN | SubCLIN | TO/TDL/Subtask | PO# | 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 | CLIN | SubCLIN | TO/TDL/Subtask | 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: | |
| *Data in all cells on all tabs is sample data | |
| Field Services or other ODC fields to be added based on specific procurement requirement |
TO Number
File details come from the government source that posted it. Updated .