Att 09 Draft TDL CDRL Att COR Only.xlsx
XLSX spreadsheet 69 KB Posted
- Solicitation number
- N0042124R0016
About this file
This document is a draft Request for Proposals (RFP) for the Naval Air Warfare Center Aircraft Division (NAWCAD) Webster Outlying Field (WOLF) Ship & Air Integrated Warfare (SAIW) Division Lifetime Support Engineering (LSE) N00421-24-R-0016 procurement. The requirement is for engineering and technical services to support the production, Lifetime Support Engineering, and In-Service Engineering for Radio Communication System (RCS) and Command, Control, Communications, Computers, Combat Systems, Intelligence, Surveillance, and Reconnaissance (C5ISR) systems aboard U.S. Navy surface combatants and at associated shore sites. 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 solicitation by April 4, 2024. This is a follow-on procurement for N00421-20-D-0004.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit A - Draft CDRLs.docx | DOCX document | |
| Att T2 - Workforce.docx | DOCX document | |
| Att 10 Small Business Subcontracting Plan.pdf | ||
| Att 07 Wage Determinations.pdf | ||
| N00421-24-R-0016.pdf | ||
| Att 06 OCI List.pdf | ||
| Att S1 - SBPCD.docx | DOCX document | |
| Att 04 List of Authorized Key Personnel.pdf | ||
| Att 11 COR Designation Letter.pdf | ||
| Att 08 TDL CDRL Att COR customer_TPOC.xlsx | XLSX spreadsheet | |
| Att C2 - Cost Price Narrative.docx | DOCX document | |
| Att 03 Data Item Transmittal Form.pdf | ||
| Att C1 - Cost Workbook.xlsx | XLSX spreadsheet | |
| Att 05 List of Approved Subcontractors.pdf | ||
| Att 02 CSP.pdf | ||
| Att 01 Draft DD254.pdf |
Show all 16
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
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 |
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 .