Att 09 TDL CDRL Attachment COR Only.xlsx
XLSX spreadsheet 68 KB Posted
- Attached to
- DRAFT RFP: NAWCAD WOLF, N00421-25-R-0002, Air Platform Engineering & Integration (APE&I)
- Solicitation number
- N00421-25-R-0002
About this file
This document is a DRAFT Request for Proposal (RFP) for the Naval Air Warfare Center Aircraft Division (NAWCAD) Webster Outlying Field (WOLF) Air Platform Engineering & Integration (APE&I) N00421-25-R-0002 procurement. The requirement is for engineering and integration services for various airborne capabilities across manned and unmanned airborne platforms, including sensors, communications, weapons, and control technologies. The services include engineering, installation, integration, test, training, and operational support. The North American Industry Classification System (NAICS) code is 541330, Engineering Services, with a small business size standard of $47,000,000. The Government is requesting industry feedback on the DRAFT RFP by 1:00 PM on 02 October 2024. This is a follow-on procurement to contract N00421-21-D-0001. The final RFP will be a full and open competition.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Att 13 Draft RFP Questions and Responses.pdf | ||
| N00421-25-R-0002 APEI Draft RFP.docx | DOCX document | |
| Att 11 Small Business Subcontracting Plan.pdf | ||
| Exh A CDRLs.pdf | ||
| Att 12 Wage Determination 2015-4279 Rev 25 (22Jul2024).pdf | ||
| Att 10 TDL CDRL Attachment COR Customer TPOC.xlsx | XLSX spreadsheet | |
| Att 07 List of Approved Subcontractors.docx | DOCX document | |
| Att T2 Key Personnel.docx | DOCX document | |
| Att T1 Sample Tasks.docx | DOCX document | |
| Att 02 DD254.pdf | ||
| Att C3 Fixed Price TM Narrative.docx | DOCX document | |
| Att 03 Authorized Key Personnel.docx | DOCX document | |
| Att 05 COR Designation Letter.pdf | ||
| Att 08 Contract Surveillance Plan.pdf | ||
| Att 04 Data Item Transmittal.Acceptance.Rejection Form.pdf | ||
| Att S1 SBPCD.docx | DOCX document | |
| Att 01 Award Fee Determination Plan.docx | DOCX document | |
| Att C1 - Cost Reimbursable Workbook.xlsx | XLSX spreadsheet | |
| Att C2 Cost Reimbursable Narrative.docx | DOCX document | |
| Att C4 - Government Labor Hours.xlsx | XLSX spreadsheet | |
| Att 06 OCI List.pdf |
Show all 21
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 TDL CDRL attachment January 2024 COR only
| Contractor's Name | |
| Contractor's Address | |
| Title of Report | |
| CDRL # | |
| Date of Report | |
| Period Covered by Report | |
| Contract number | |
| Name of issuing Government Agency | |
| Program/System Nomenclature | |
| Security Classification or other appropriate markings | |
| Instructions: | |
| There are a minimum of 8 tabs to this attachment that need to be completed | |
| Data in all cells on all tabs is sample data -- ensure Contractor knows to delete data but not formulas prior to completing each tab |
CDRL# & Title TO Number
Draft
IDIQ Basic Roll Up TDL CDRL attachment January 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 | 3450 | 3450 | |
| CLIN LABOR HRS | $ 414,000.00 | $ 414,000.00 | |
| CLIN LABOR Dollars | $ 10,000.00 | $ 5,000.00 | |
| CLIN TRAVEL | $ 20,000.00 | $ 25,000.00 | |
| CLIN MATERIAL | |||
| Data in all cells on all tabs is sample data -- ensure Contractor knows to delete data but not formulas prior to completing each tab |
CDRL# & Title TO Number
COR TO Data Breakout
| TDL CDRL attachment January 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 | ||||||||||||||||
| 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 |
| LABOR | Travel | Material | Other ODC | ||||||||||||||||||||||||||||||
| Estimated Amount $ | Estimated HRS | Funding Received $ | Funded Hrs | Expenditures to Date | 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 | PoP | This row is for TDL Cumulative for the CLIN | 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 | Expenditures to Date | 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
Data in all cells on all tabs is sample data-- ensure Contractor knows to delete data but not formulas prior to completing each tab
TO Number
Rate Analysis COR only file
| TDL CDRL attachment January 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 |
King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:
Columns I-L only required when "Key" 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 King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:
Recommend on a per COR basis to determine if justification is required once exceeding a certain percentage
| 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 |
| 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 |
| 13219 | 6410 | 0 | 7829 | 0 | 0 | 0 | $ 754,690.00 | $ 1,327,330.00 | $ 844,190.00 | $ 1,457,230.00 | 39% |
Data in all cells on all tabs is sample data -- ensure Contractor knows to delete data but not formulas prior to completing each tab
TO Number
Rate Analysis by employee ID
| TDL CDRL attachment January 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 | ||||||||||||||||||
| Employee Identifier | CLIN | Project | TDL # | Subtask # (If Applicable) | LCAT | On/Off site | 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 |
| 1005218 | 1 | SME SPT LOE 12 mo | TDL1 | 1 | Analyst, Senior | 3 | 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 |
| 1005218 | 1 | System "X" Installation | TDL2 | 1 | Analyst, Senior | 3 | 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 |
| 1332 | 200 | 0 | 520 | 0 | 10 | 0 | $ 62,400.00 | $ 9,840.00 | $ 240.00 | $ 62,400.00 | $ 159,840.00 |
| 1003562 | 1 | System "X" Installation | TDL2 | 1 | PM, Senior | 4 | 45 | 22 | 0 | 32 | 0 | 0 | $ 155.00 | 0 | $ 4,960.00 | $ 6,975.00 | $ 145.00 | $ 4,640.00 | $ 6,525.00 | 7% | N/A |
| 1003562 | 1 | TDL3 | 1 | PM, Senior | 4 | 1920 | 1800 | 0 | 1850 | 0 | 0 | $ 155.00 | 0 | $ 286,750.00 | $ 297,600.00 | $ 145.00 | $ 268,250.00 | $ 278,400.00 | 7% | N/A | |
| 1965 | 1822 | 0 | 1882 | 0 | 0 | $ 291,710.00 |
King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:
For Cells in orange Create conditional formatting or other rule to show tripwire being exceeded.
| Note to COR, if labor tripwires are not approved as part of pre-award actions, then post-award actions are required once tripwire is exceeded | $ 304,575.00 | $ 290.00 | $ 272,890.00 | $ 284,925.00 | 14% |
| Data in all cells on all tabs is sample data -- ensure Contractor knows to delete data but not formulas prior to completing each tab |
TO Number
Rate Analysis by LCAT
| TDL CDRL attachment January 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 | ||||||||||||||||||
| LCAT | CLIN | Project | TDL # | Subtask # (If Applicable) | Employee Identifier | On/Off site | 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 |
| Analyst, Senior | 1 | SME SPT LOE 12 mo | TDL1 | 1 | 1005218 | 3 | 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 |
| Analyst, Senior | 1 | System "X" Installation | TDL2 | 1 | 1005689 | 3 | 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 |
| 1332 | 200 | 0 | 520 | 0 | 10 | 0 | $ 62,400.00 | $ 9,840.00 | $ 240.00 | $ 62,400.00 | $ 159,840.00 | 0% |
| PM, Senior | 1 | System "X" Installation | TDL2 | 1 | 1003562 | 4 | 45 | 22 | 0 | 32 | 0 | 0 | $ 155.00 | 0 | $ 4,960.00 | $ 6,975.00 | $ 145.00 | $ 4,640.00 | $ 6,525.00 | 7% | N/A |
| PM, Senior | 1 | Training | TDL3 | 1 | 1005974 | 4 | 1920 | 1800 | 0 | 1850 | 0 | 0 | $ 155.00 | 0 | $ 286,750.00 | $ 297,600.00 | $ 145.00 | $ 268,250.00 | $ 278,400.00 | 7% | N/A |
| 1965 | 1822 | 0 | 1882 | 0 | 0 | $ 291,710.00 | $ 304,575.00 | $ 290.00 | $ 272,890.00 | $ 284,925.00 | 14% |
Data in all cells on all tabs is sample data -- ensure Contractor knows to delete data but not formulas prior to completing each tab
TO Number
COR Spend plan per CLIN
| TDL CDRL attachment January 2024 COR only |
| Prime Contract No |
| 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 -- ensure Contractor knows to delete data but not formulas prior to completing each tab |
Action items noted:
1) Add hours graphic
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 January 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 -- ensure Contractor knows to delete data but not formulas prior to completing each tab | |
| 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 .