P8 COR and Customer Excel Template.xlsx
XLSX spreadsheet 70 KB Posted
- Attached to
- Support Equipment Test & Evaluation Contractor Support Services Federal contract opportunity
- Solicitation number
- N00421-20-R-0121
About this file
This document contains a federal contract opportunity and related COR and customer Excel template. The federal contract opportunity is a solicitation seeking Contractor Support Services personnel to provide engineering, technical, administrative, and program management support for the Support Equipment Test & Evaluation Branch of the Naval Air Warfare Center Aircraft Division. Key details include that the solicitation number is N00421-20-R-0121, it is a full and open competition, the product service code is H217, the NAICS code is 541330, proposals are due by the date specified in the RFP, the resulting contract will be a non-performance based cost-plus-fixed-fee indefinite delivery/indefinite quantity single award contract with a 5 year ordering period, work will be performed primarily at specified Navy bases, and the incumbent is Eagle Systems, Inc. under contract N00178-14-D-7700-M801.
The related Excel template appears to be a COR reporting template containing multiple tabs for tracking contract details such as funding, labor hours and costs, travel and other direct costs, and a spend plan by CLIN. It includes fields for budgeted versus actual data as well as outstanding commitments and variance explanations.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| P9 Wage Determination.pdf | ||
| Amendment 0001.pdf | ||
| Conformed Amendment 0001.pdf | ||
| A006.docx | DOCX document | |
| P3 PPIF.pdf | ||
| P6 Personnel Resource Matrix.xlsx | XLSX spreadsheet | |
| A004.doc | DOC document | |
| P1 Cost.xls | XLS spreadsheet | |
| P3 PPIF.pdf | ||
| P7 COR Only Excel Template.xlsx | XLSX spreadsheet | |
| P6 Personnel Resource Matrix.xlsx | XLSX spreadsheet | |
| A003.doc | DOC document | |
| A002.doc | DOC document | |
| N00421-20-R-0121_RFP.docx | DOCX document | |
| J1 Org_Conflict_of_Interest.docx | DOCX document | |
| J3 CSP_SAC.docx | DOCX document | |
| P4 CPAQ.pdf | ||
| A005.doc | DOC document | |
| J5 Data_Item_Transmittal_Acceptance_Rejection_Form.docx | DOCX document | |
| A001.doc | DOC document | |
| P2 Fully Burdened.xlsx | XLSX spreadsheet | |
| J4 DD254.pdf | ||
| A006.docx | DOCX document | |
| P5 CPAQ Instructions.docx | DOCX document |
Show all 24
On GovTribe
Work with this file on GovTribe
- 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 March 2020
| Contractor's Name | |
| Contractror's Address | |
| Title of Report | |
| CDRL # | |
| Date of Report | |
| Period Covered by Report | |
| Contract number | |
| Name if issueing Government Agency | |
| Program/System Nomenclature | |
| Security Classification or other appropriate markings | |
| instructions: | |
| there are a min. of 8 tabs to this attachment that need completed |
CDRL# & Title TO Number
IDIQ Basic Roll Up TDL CDRL attachment March 2020
| Prime Contract No | Burn Rate | ||
| Invoice Number | Hours | ||
| Invoice Date | Labor $ | ||
| PoP | Bid Rate | ||
| Billing Period | Op Rate | ||
| Variance | |||
| Contract Summary | Base | Mod 2 | Percentage |
| 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 |
CDRL# & Title TO Number
Action items noted:
1) Move Ceiling up column F onto Contract Summary level
2) Remove TO Lines 21-33
3) Add funding to Contract Summary Table
4) Remove rows 13-16 from ODC burn area
5) Review format for ODC Burn vs ODC Ceiling
6) Move TO summary to "COR TDL Data Breakout" tab and incorporate efficiencies in data
Decisions:
Roll up tab will occur in each workbook for each TO
COR TO Data Breakout
| TDL CDRL attachment March 2020 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 Recieved $ | 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 | Cummulative Reg Hrs | Cummulative UT/TTA Hrs | Total Cummulative Hrs | EAC | Projected date for 75% notification (Based on expenditure to-date) | Current Travel | Cummulative Travel | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Material | Cummulative Material | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Other ODC | Cummulative Other ODC | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | |||||
| CLIN 1 | PoP | This row is for TDL Cummulative for the CLIN | This row is for TDL Cummulative for the CLIN | ||||||||||||||||||||||||||||||
| Project Name | TDL # | Subtask # (If Applicable) | Description | Date Issued | Estimated Amount $ | Estimated HRS | Funding Recieved $ | 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 | Cummulative Reg Hrs | Cummulative UT/TTA Hrs | Total Cummulative Hrs | EAC | Projected date for 75% notification (Based on expenditure to-date) | Current Travel | Cummulative Travel | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Material | Cummulative Material | Outstanding Commitments | Projected date for 75% notification (Based on expenditure to-date) | Current Other ODC | Cummulative 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 Cummulative Reg Hrs) | Labor planned for upcomming trip | (Expenditures to date + outstanding commitments) | (current Reg Hrs + Current UT/TTA Hrs) | (current Cummulative Reg Hrs + Current Cummulative 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 Cummulative 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
TO Number
Action items noted:
1) Rename tab as this is TO not TDL
2) Remove TO summary from Roll up tab and incorporate with the TDL CLIN data tab with efficiencies
Decisions noted:
1) Each TO has its own file.
2) Subcontractor Data should be included with the information below in the appropriate fileds.
Rate Analysis COR only file
| TDL CDRL attachment March 2020 | |||||||||||
| Prime Contract No | |||||||||||
| TO Number | |||||||||||
| Invoice Number | |||||||||||
| Invoice Date | |||||||||||
| PoP | |||||||||||
| 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 Cummulative Hrs Billed Current UT/TTA Hrs Cummulative UT/TTA Hrs Current Burdened Cost Priod Period Adjustment $ Cumulative Burdnended Cost Projected Total Costs B-1 Approved Rate King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:
Need a new title?
King, Evelyn S CIV AD, 4.11D Staff: King, Evelyn S CIV AD, 4.11D Staff:
Columns I-L only required when "Key" Cummulative 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 avilable 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% |
TO Number
Action items noted:
1) Combine this Tab with the Personnel Matrix COR Only file tab
2) Create a roll up at the employee & LCAT level (see new tabs)
3) Create a tripwire trigger field (see employee tab) Decisions noted:
1) Employee identifiers are OK to be used
Rate Analysis by employee ID
| TDL CDRL attachment March 2020 | |||||||||||||||||||||
| Prime Contract No | |||||||||||||||||||||
| TO Number | |||||||||||||||||||||
| Invoice Number | |||||||||||||||||||||
| Invoice Date | |||||||||||||||||||||
| PoP | |||||||||||||||||||||
| 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 | Cummulative Hrs Billed | Current UT/TTA Hrs | Cummulative UT/TTA Hrs | Current Burdened Cost | Priod Period Adjustment $ | Cumulative Burdnended Cost | Projected Total Costs | B-1 Approved Rate | Cummulative 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%
TO Number
Action items noted:
1) Create a roll up at the employee level
2) Create a tripwire trigger field Decisions noted:
1) Employee identifiers are OK to be used
Rate Analysis by LCAT
| TDL CDRL attachment March 2020 | |||||||||||||||||||||
| Prime Contract No | |||||||||||||||||||||
| TO Number | |||||||||||||||||||||
| Invoice Number | |||||||||||||||||||||
| Invoice Date | |||||||||||||||||||||
| PoP | |||||||||||||||||||||
| 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 | Cummulative Hrs Billed | Current UT/TTA Hrs | Cummulative UT/TTA Hrs | Current Burdened Cost | Priod Period Adjustment $ | Cumulative Burdnended Cost | Projected Total Costs | B-1 Approved Rate | Cummulative 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% |
TO Number
Action items noted:
1) Create a roll up at the LCAT level Decisions noted:
1) Employee identifiers are OK to be used
COR Spend plan per CLIN
| TDL CDRL attachment March 2020 |
| Prime Contract No |
| Invoice Number |
| Invoice Date |
| PoP |
| 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 |
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 March 2020 |
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP |
| 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 |
Cummulative 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 | Governement approver | Government approval date |
| Cummulative Total: | |
| 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 .