Att 10 TDL CDRL attachment COR only.xlsx

XLSX spreadsheet 66 KB Posted

Attached to
NAWCAD (WOLF) Ship and Air Integrated Warfare Division Small Unmanned Aircraft Systems (SUAS) Reusable Architecture (SRA)
Solicitation number
N0042126R1006
Issued by

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

File Type Posted
N0042126R1006_RFO_Rev04.pdf PDF
Att C3 Fixed T and M Price Narrative 26-R-1006_SRA.docx DOCX document
Q4.xlsx XLSX spreadsheet
Q3.xlsx XLSX spreadsheet
N0042126R1006_RFO_Rev03.pdf PDF
Att L2 Government Labor Hours 26-R-1006 (SRA)_Rev01.xlsx XLSX spreadsheet
Att C1 - Cost Reimbursable Workbook_Rev 02.xlsx XLSX spreadsheet
N0042126R1006_RFO_Rev02.pdf PDF
Q2.xlsx XLSX spreadsheet
Att 20_CSWF Qualification Matrix.xlsx XLSX spreadsheet
Q1.xlsx XLSX spreadsheet
Att C1 - Cost Reimbursable Workbook_Rev 01.xlsx XLSX spreadsheet
Att M1 Section M_rev01.pdf PDF
Attachment T1 Key Personnel_rev01.docx DOCX document
N0042126R1006_RFO_Rev01.pdf PDF
Exhibit A CDRLs_rev01.pdf PDF
Att C2 Cost Reimbursable Narrative 26-R-1006 (SRA) Rev 01.docx DOCX document
Att L1 Section L (1) Rev01.docx DOCX document
Attachment T2 Sample Task_rev01.docx DOCX document
Att 02 Contract Surveillance Plan.pdf PDF
Att 06 DD254.pdf PDF
Att 09 TDL CDRL attachment COR_TPOC.xlsx XLSX spreadsheet
Att C2 Cost Reimbursable Narrative 26-R-1006 (SRA).docx DOCX document
Att L2 Government Labor Hours 26-R-3000 (SRA).xlsx XLSX spreadsheet
N0042126R1006_RFO Final.pdf PDF
Exhibit A CDRLs.pdf PDF
Att 05 List of Approved Subcontractors.pdf PDF
Att 07 COR Designation Letter.pdf PDF
Att 08 List of Approved Key Personnel.pdf PDF
Att L1 Section L.pdf PDF
Att 01 Statement of Work.pdf PDF
Att 03 Data Item Transmittal Acceptance Rejection Form.pdf PDF
Att 04 OCI List.pdf PDF
Att C1 Cost Reimbursable Workbook.xlsx XLSX spreadsheet
Attachment P1 Key Personnel.docx DOCX document
Attachment T1 Sample Tasks.pdf PDF
Att M1 Section M.pdf PDF
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 PageIDIQ Basic Roll UpCOR TO Data BreakoutRate Analysis COR only fileCOR Spend Plan per CLIN*COR ODC Roll Up Reporting
TitleDefinitionTitleDefinitionTitleDefinitionTitleDefinitionTitleDefinitionTitleDefinition
Contractor's NameEnter the name of the contractorPrime Contract NoEnter Prime Contract NumberPrime Contract NoEnter the Prime Contract NumberPrime Contract NoEnter the Prime Contract NumberPrime Contract NoEnter the Prime Contract NumberPrime Contract NoEnter the Prime Contract Number
Contractor's AddressEnter the address of the contractorInvoice NumberEnter the Contractor Invoice NumberTO NumberEnter the Task Order NumberTO NumberEnter the Task Order NumberTO NumberEnter the Task Order (TO) NumberTO NumberEnter the Task Order (TO) Number
Title of ReportEnter the Title of Report ( Contracting Officer’s Representative (COR) Management Report for Technical Direction Letters (TDLs))Invoice DateEnter the date the Invoice is generatedInvoice NumberEnter the Contractor Invoice NumberInvoice NumberEnter the Contractor Invoice NumberInvoice NumberEnter the Contractor Invoice NumberInvoice NumberEnter the Contractor Invoice Number
CDRL #Enter the CDRL number (Pull from awarded CDRLs)PoP StartEnter the Contract/IDIQ Period of Performance Start dateInvoice DateEnter the date the Invoice is generatedInvoice DateEnter the date the Invoice is generatedInvoice DateEnter the date the Invoice is generatedInvoice DateEnter the date the Invoice is generated
Date of ReportEnter the date the report is being generatedPoP EndEnter the Contract/IDIQ Period of Performance End datePoP StartEnter the TO/Option Period of Performance Start datePoP StartEnter the TO/Option Period of Performance Start datePoP StartEnter the TO/Option Period of Performance Start datePoP StartEnter the TO/Option Period of Performance Start date
Period Covered by ReportEnter the dates this report covers (start date through end date)Billing PeriodEnter the Billing Period (Start Date through End Date)PoP EndEnter the TO/Option Period of Performance End datePoP EndEnter the TO/Option Period of Performance End datePoP EndEnter the TO/Option Period of Performance End datePoP EndEnter the TO/Option Period of Performance End date
Contract NumberEnter the contract numberTO periodEnter the current Option Year the Contract/TO is in (i.e. Base, OPT I, OPT II)Billing PeriodEnter the Billing Period (Start Date through End Date)Billing PeriodEnter the Billing Period (Start Date through End Date)Billing PeriodEnter the Billing Period (Start Date through End Date)
Task Order NumberEnter the task order numberContract Summary - Update this section with each MOD that adjusts the ceilingBilling PeriodEnter the Billing Period (Start Date through End Date)PrimeEnter the Prime Contractors NameDollars (Each CLIN should have it's own Graph)Material PurchasesItem NameEnter the name of the material that was purchased during the reporting period
Name of issuing Government AgencyProvide the name of the Government Agency (NAWCAD WOLF XXXX Division)CLIN LABOR HRSEnter the Total Contract/IDIQ CLIN Labor HrsAwarded Ceiling HrsEnter the Awarded Ceiling Hours for Labor by CLIN (Travel and Material should be N/A)SubsEnter the names of any SubcontractorsFUNDEDEnter in the Funded dollar amount for each CLIN and escalate the funding across the TO/Option PoP as appropriateCLINEnter the CLIN the material was purchased under
Program/System NomenclatureEnter the name of the ContractCLIN LABOR DollarsEnter the Total Contract/IDIQ CLIN Labor CeilingAwarded Ceiling $Enter the Awarded Ceiling Amounts for Labor, Travel, and Material by CLINCLINEnter the CLINCOSTSEnter 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.SubCLINEnter the SubCLIN the material was purchased under
Security Classification or other appropriate markingsEnter the security classification or other appropriate markings (i.e. CUI, Proprietary)CLIN TRAVELEnter the Total Contract/IDIQ CLIN Travel CeilingCost IncurredEnter the total Cumulative Expenditures to-date for Labor, Travel, and Material by CLINProjectEnter the Technical Direction Letter TitlePROJECTED TOTALEnter 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/SubtaskEnter the Task Order/Technical Direction Letter/Subtask (if applicable)
CLIN MATERIALEnter the Total Contract/IDIQ CLIN Material CeilingOutstanding CommitmentsEnter any Outstanding Commitments for Labor, Travel, and Material by CLINTDL #Enter the Technical Direction Letter NumberCEILINGEnter the total CLIN ceiling for the TO/Option PoPPO#Enter the Purchase Order Number for the material
Cost Incurred w/commitmentsEnter the total Cost Incurred plus Outstanding Commitments for Labor, Travel, and Material by CLINPersonnel DataSubtask # (If Applicable)Enter the Subtask number (If Applicable)Hours (Each CLIN should have it's own Graph)DescriptionEnter a high level description of the Material purchased
Burn RateHoursEnter the Total Contract/IDIQ HoursUnfunded CeilingEnter Unfunded Ceiling for Labor, Travel, and Material by CLIN (Total Ceiling value - Total Funding value)Employee IdentifierEnter the Employee's Contractor Identification NumberBudgetedEnter in the budgeted hours for each month of the TO/Option PoP as appropriateInvoice NumberEnter the Invoice Number the Material was purchased under
Labor $Enter the Total Contract/IDIQ Labor CeilingBalance (funded - Exp)Enter the remaining funding balance (Total Funding - Cost Incurred w/commitments) for Labor, Travel, and Material by CLINLCATEnter the Labor Categories applicable to the TDL (Note: Rows can be added as needed)BilledEnter 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.PurposeEnter the reason for the Material purchase (this should include the specific project supported)
Bid RateEnter the Overall Contract/IDIQ Bid Rate% Ceiling Expended HrsEnter the percentage of Ceiling Expended for Hours by CLINOn/Off siteEnter if the LCAT is working On-site or Off-sitePROJECTEDEnter the estimated total projected hours for each month of the TO/Option PoP (This will not get updated to reflect actual hours each month)VendorEnter the Vendor the material was purchased from
Op RateEnter the Overall Contract/IDIQ Operating Rate% Ceiling Expended $Enter the percentage of Ceiling Expended for Labor, Travel, and Material by CLINKey/Non-KeyEnter if the LCAT is Key or Non-KeyCEILINGEnter the total CLIN hours for the TO/Option PoPQuantityEnter the Quantity purchased
VarianceEnter the Difference between the Bid Rate vs the Operating Rate% Ceiling Expended $ w/commitmentsEnter the percentage of Ceiling Expended w/commitments for Labor, Travel, and Material by CLINDate Resume submittedEnter the date the Key Personnel Resume was submitted to the PCO for review**Each CLIN will have it's own GraphUnit PriceEnter the Unit Price for the Material
PercentageEnter the Variance between the Bid Rate vs the Operating Rate as a percentage% Funding ExpendedEnter the percentage of Funding Expended for Labor, Travel, and Material by CLINDate Resume ApprovedEnter the date the PCO provided concurrence and approval of the Key Personnel Resume*Estimated CostEnter the Estimated Cost for the Material
EACEnter 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 neededEnter the Project funding needed for Labor, Travel, and Material by CLIN for the TO/Option PoPName of ReplacementEnter the Name of the Key Personnel Replacing the Key Personnel who was removed*Actual CostEnter the Actual Cost for the Material
Task Order Summary - This section is broken out by MODBudgeted HrsEnter the Estimated TDL HoursCumulative Total Actual Cost)Enter the Sum of the Actual Cost
TitleDefinitionCurrent Hrs BilledEnter 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 1Enter the Total Hours by CLIN per the latest MODPrior Period Adjustment HrsEnter any hours that are adjustments from prior periodsGov Approver if required by ContractWho from the Government approved the material purchase, if under approval thresholds, who was the material purchased for.
CLIN LABOR Dollars APPN 1Enter the Total Labor Ceiling by CLIN per the latest MODCumulative Hrs BilledEnter the Cumulative Hours billed for the TO/Option PoP (Current Hrs Billed + Prior Period Adjustment Hrs.)DispositionWhat 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 2Enter the Total Hours by CLIN per latest the MODCurrent UT/TTA HrsEnter in current Uncompensated Time/Total Time Accounting hours for the reporting periodTravelTravelerEnter the Traveler's name
CLIN LABOR Dollars APPN 2Enter the Total Labor Ceiling by CLIN per the latest MODCumulative UT/TTA HrsEnter in current Uncompensated Time/Total Time Accounting hours for the TO PoPCLINEnter the CLIN the Travel was conducted under
CLIN LABOR HRS APPN 3Enter the Total Hours by CLIN per the latest MODActual RateCurrent Burdened CostEnter the Current Burdened Cost for the reporting periodSubCLINEnter the SubCLIN the Travel was conducted under
CLIN LABOR Dollars APPN 3Enter the Total Labor Ceiling by CLIN per the latest MODPrior Period Adjustment $Enter any adjustments from prior periodsTO/TDL/SubtaskEnter the Contract/Task Order/Technical Direction Letter/Subtask (if applicable)
CLIN Travel Dollars APPN 1Enter the Total Travel Ceiling by CLIN per the latest MODCumulative Burdened CostEnter the Cumulative Burdened Cost for the TO/Option PoPDestinationEnter the Traveler's destination
CLIN Travel Dollars APPN 2Enter the Total Travel Ceiling by CLIN per the latest MODProjected Total CostsEnter the Projected Total Costs for the Actual Rate at the end of the TO PoPPurposeEnter the reason for the travel
CLIN Travel Dollars APPN 3Enter the Total Travel Ceiling by CLIN per the latest MODBid RateB-1 Approved RateEnter the B-1 Approved Rate from Section B of the Contract/TODate of TravelEnter the date the travel commenced
CLIN Material Dollars APPN 1Enter the Total Material Ceiling by CLIN per the latest MODCumulative Burdened CostEnter 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 2Enter the Total Material Ceiling by CLIN per the latest MODProjected Total CostsEnter the Projected Total Costs for the Bid Rate at the end of the TO/Option PoPEstimated CostEnter the estimated cost for the trip
CLIN Material Dollars APPN 3Enter the Total Material Ceiling by CLIN per the latest MODVariation% variationEnter the Percentage Difference between the Actual Rate vs. the Bid RateCumulative Total (Estimated Cost)Enter the Sum of the Estimated Cost
FundingEnter the Total Funding amount by CLIN per the latest MODJustification for variationEnter a justification for any variation of actual-to-bid rate averages greater than 10%Actual CostEnter the actual Cost for the trip
Expended as of date of reportEnter the Cumulative To-Date Expenditures w/Commitments for each CLINCumulative Total (Actual Cost)Enter the Sum of the Actual Cost
CLIN BreakoutCLIN 1* Only Required when KeyVariance (between estimated and actual costs)Enter the Difference in the cost (Actual Cost - Estimated Cost)
Project NameEnter the Technical Direction Letter TitleJustificationEnter the Justification for the travel (this should include the specific project supported)
TDL #Enter the Technical Direction Letter NumberGovernment approverEnter the Government Approver
Subtask # (If Applicable)Enter the Subtask number (If Applicable)Government approval dateEnter the date the Government provided Approval
DescriptionEnter a high level description of the TDL
Date IssuedEnter the Date TDL was signed by the KO
LaborEstimated Amount $Enter the Estimated TDL Value (numbers)
Estimated HRSEnter the Estimated TDL Hours
Funding Received $Enter the Funding Received per the latest MOD (dollar amount)
Funded HrsEnter the Funded Hours per the latest MOD
Current ExpendituresEnter the Expenditures for the current reporting period (dollar amount)
Funding BalanceEnter the funding balance (Funding Received - Cost Incurred To-Date)
Funded HRS BalEnter the funding hours balance (Funded Hours - Total Current Hours)
Outstanding CommitmentsEnter any outstanding labor commitments (i.e. subcontractor costs)
Cost Incurred To-Date (Total)Enter total Cumulative Expenditures to-date to include commitments
Current Reg HrsEnter the Current Regular Hours expended for the reporting period
Current UT/TTA HrsEnter in current Uncompensated Time/Total Time Accounting hours for the reporting period
Total Current HrsEnter the Total Current Expended Hours for the reporting period (Current Reg Hrs. + Current UT/TTA Hrs.)
Cumulative Reg HrsEnter the Cumulative Reg Hours Expended for the TO/Option PoP
Cumulative UT/TTA HrsEnter the Cumulative Uncompensated Time/Total Time Accounting Hours Expended for the TO/Option PoP
Total Cumulative HrsEnter the Cumulative Hours Expended for the TO/Option PoP (Cumulative Reg Hours + Cumulative UT/TTA Hrs.)
EACEnter 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
TravelCurrent TravelEnter the current travel cost for the reporting period
Cumulative TravelEnter the total cumulative travel cost for the TO/Option PoP
Outstanding CommitmentsEnter 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
MaterialCurrent MaterialEnter the current material cost for the reporting period
Cumulative MaterialEnter the cumulative material cost for the TO/Option PoP
Outstanding CommitmentsEnter 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 ODCCurrent Other ODCEnter the current cost for any other ODCs for the reporting period (i.e. field services)
Cumulative Other ODCEnter the cumulative cost for any other ODCs for the TO/Option PoP (i.e. field services)
Outstanding CommitmentsEnter 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 NoBurn Rate
Invoice NumberHours
Invoice DateLabor $
PoP StartBid Rate
PoP EndOp Rate
Billing PeriodVariance
BaseMod 2Percentage
Contract Summary
CLIN LABOR HRS34503450
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 HrsAwarded Ceiling $Cost IncurredOutstanding CommitmentsCost Incurred w/commitmentsUnfunded CeilingBalance (funded - Exp)% Ceiling Expended Hrs% Ceiling Expended $% Ceiling Expended $ w/commitments% Funding ExpendedEACProjected funding needed
Prime Contract NoLabor
TO NumberTravel
Invoice NumberMaterial
Invoice DateTotal:
PoP Start*Rows can be added for additional CLINs as needed
PoP End
TO periodBase, OPT I, OPT II
Billing Period
Prime
Subs
TO SummaryTO baseTO mod 2TO mod 5FundingExpended as of date of report
CLIN LABOR HRS APPN 1115012251475575287.5
CLIN LABOR Dollars APPN 1$ 138,000.00$ 147,000.00$ 177,000.00$ 69,000.0034500
CLIN LABOR HRS APPN 2172517251725575287.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 3575500250575287.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
LABORTravelMaterialOther ODC
Estimated Amount $Estimated HRSFunding Received $Funded HrsCurrent ExpendituresFunding BalanceFunded HRS BalOutstanding CommitmentsCost Incurred To-Date (Total)Current Reg HrsCurrent UT/TTA HrsTotal Current HrsCumulative Reg HrsCumulative UT/TTA HrsTotal Cumulative HrsEACProjected date for 75% notification (Based on expenditure to-date)Current TravelCumulative TravelOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current MaterialCumulative MaterialOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current Other ODCCumulative Other ODCOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)
CLIN 1This row is for TDL Cumulative for the CLIN
Project NameTDL #Subtask # (If Applicable)DescriptionDate IssuedEstimated Amount $Estimated HRSFunding Received $Funded HrsCurrent ExpendituresFunding BalanceFunded HRS BalOutstanding CommitmentsCost Incurred To-Date (Total)Current Reg HrsCurrent UT/TTA HrsTotal Current HrsCumulative Reg HrsCumulative UT/TTA HrsTotal Cumulative HrsEACProjected date for 75% notification (Based on expenditure to-date)Current TravelCumulative TravelOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current MaterialCumulative MaterialOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)Current Other ODCCumulative Other ODCOutstanding CommitmentsProjected date for 75% notification (Based on expenditure to-date)
TDL1SME SPT LOE 12 mo1-Oct-20$ 150,000.001250.00$ 75,000.00625$ 37,500.00$ 37,500.00145$ 3,600.00$ 41,100.00160016048010490$ 1,248.0025-Mar-2100135025-Apr-2100025-May-2100025-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 currentIncludes currentIncludes 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 2PoPThis 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 DataActual RateBid RateVariation
CLINProjectTDL #Subtask # (If Applicable)Employee IdentifierLCATOn/Off siteKey/Non-KeyDate Resume submittedDate Resume ApprovedDate Removed (if Applicable)Name of ReplacementBudgeted HrsCurrent Hrs BilledPrior Period Adjustment HrsCumulative Hrs BilledCurrent UT/TTA HrsCumulative UT/TTA HrsCurrent Burdened CostPrior Period Adjustment $Cumulative Burdened CostProjected Total CostsB-1 Approved RateCumulative Burdened CostProjected Total Costs% variationJustification for variation
1SME SPT LOE 12 moTDL111005218Analyst, SeniorOn-SiteKey1/1/151/1/15N/AN/A12501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%N/A
TDL1 Total12501600480010$ 120.000$ 57,600.00$ 150,000.00$ 120.00$ 57,600.00$ 150,000.000%
1System "X" InstallationTDL211003562PM, SeniorOff-siteKey1/1/151/1/15N/AN/A452203200$ 145.000$ 4,640.00$ 6,525.00$ 145.00$ 4,640.00$ 6,525.000%N/A
1System "X" InstallationTDL211005218Analyst, SeniorOn-SiteKey10/1/1610/5/16N/AN/A824004000$ 120.000$ 4,800.00$ 9,840.00$ 120.00$ 4,800.00$ 9,840.000%N/A
1System "X" InstallationTDL211005874Analyst, JuniorOn-SiteNon-KeyN/AN/AN/AN/A157100012500$ 120.000$ 15,000.00$ 18,840.00$ 120.00$ 15,000.00$ 18,840.000%N/A
1System "X" InstallationTDL211005489Engineer, SeniorOn-SiteNon-KeyN/AN/AN/AN/A452022500225700$ 125.000$ 282,125.00$ 565,000.00$ 125.00$ 282,125.00$ 565,000.000%N/A
1System "X" InstallationTDL211005987Engineer, JuniorOn-SiteNon-KeyN/AN/AN/AN/A457522500357500$ 75.000$ 268,125.00$ 343,125.00$ 95.00$ 339,625.00$ 434,625.0021%project required specific certification, COR approved 10/1/2015
1System "X" InstallationTDL221005289Systems Analyst, JourneymanOn-SiteNon-KeyN/AN/AN/AN/A1920874090000$ 95.000$ 85,500.00$ 182,400.00$ 100.00$ 90,000.00$ 192,000.005%N/A
1System "X" InstallationTDL221002659Systems Analyst, SeniorOff-siteNon-KeyN/AN/AN/AN/A1920874090000$ 105.000$ 94,500.00$ 201,600.00$ 120.00$ 108,000.00$ 230,400.0013%Project required specific systems experience, personnel not available a rate bid
TDL2 Total13219641007829000$ 754,690.00$ 1,327,330.00$ 844,190.00$ 1,457,230.0039%$ 1,457,230.006%
*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
DollarsMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 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
HoursMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12
Budgeted384038403840384038403840384038405760576057605760
Billed450850920105015001750225025502950350045005760
PROJECTED384038403840384038403840576057605760576057605760
CEILING750075007500750075007500750075007500750075007500
*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 NameCLINSubCLINTO/TDL/SubtaskPO#DescriptionInvoice NumberPurposeVendorQuantityUnit PriceEstimated CostActual CostVariance (between estimated and actual costs)Gov Approver if required by ContractDisposition

Cumulative Total:

Travel
TravelerCLINSubCLINTO/TDL/SubtaskDestinationPurposeDate of TravelLength (days)Estimated CostActual CostVariance (between estimated and actual costs)JustificationGovernment approverGovernment 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 .