Attachment_09_-_COMR_CDRL_Template_(COR).xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- N00421-19-R-0003
About this file
This sources sought notice is seeking capability statements from businesses for engineering services to support the integration of airborne capabilities onto manned and unmanned air platforms. Services include program management, research, design, parts procurement, installation, testing, training, and operational support. A single-award IDIQ contract with a five-year ordering period will be awarded on a competitive basis. The contract is anticipated to include both cost-reimbursable and firm-fixed price CLINs. Interested businesses must submit a capabilities statement by July 9th demonstrating relevant experience and technical skills, the ability to obtain necessary security clearances, and the capacity to perform the work outlined in the draft statement of work. The work will be performed at NAS Patuxent River (70%), Webster Field (15%), and Yuma Proving Grounds (15%). The NAICS code is 541330 and eligible businesses of all sizes are encouraged to respond.
DRAFT Attachment 09
View the file
Other files
Show all 50
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
| 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 |
CDRL# & Title TO Number
Roll Up
| Prime Contract No | ||||||
| Invoice Number | ||||||
| Invoice Date | ||||||
| PoP | ||||||
| Billing Period | ||||||
| Contract Summary | Base | Mod 1 | Mod 2 | Expended as of date of report | Burn Rate | |
| CLIN LABOR | Hours | |||||
| CLIN APPN 1 | Labor | |||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 | Burn Rate | |||||
| CLIN TRAVEL | ODC | |||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | Est Funding End Date | |||||
| CLIN APPN 3 | Weeks Remaining | |||||
| CLIN MATERIAL | Days Remaining | |||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | Est Ceiling End Date | |||||
| CLIN APPN 3 | Weeks Remaining | |||||
| Days Remaining | ||||||
| Contract Summary | Ceiling | Funding | Budgeted | Remaining | Expedend as of date of report | |
| CLIN LABOR | Bid Rate | |||||
| CLIN APPN 1 | Op Rate | |||||
| CLIN APPN 2 | Variance | |||||
| CLIN APPN 3 | Percentage | |||||
| CLIN TRAVEL | ||||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 | ||||||
| CLIN MATERIAL | ||||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 | ||||||
| TO Summary | TO base | TO mod 1 | TO mod 2 | Expended as of date of report | ||
| CLIN LABOR | ||||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 | ||||||
| CLIN TRAVEL | ||||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 | ||||||
| CLIN MATERIAL | ||||||
| CLIN APPN 1 | ||||||
| CLIN APPN 2 | ||||||
| CLIN APPN 3 |
TO Number
COR TDL Data Breakout
| Section 1 - Work Summary | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| CLIN 1 | PoP | LABOR | Travel | Material | Other ODC | ||||||||||||||||||||||||||||
| 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 | ||
| 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
Rate Analysis COR only file
| Section 1 - Work Summary | ||||||||||||||||||
| Prime Contract No | ||||||||||||||||||
| TO Number | ||||||||||||||||||
| Invoice Number | ||||||||||||||||||
| Invoice Date | ||||||||||||||||||
| PoP | ||||||||||||||||||
| Billing Period | ||||||||||||||||||
| Prime | ||||||||||||||||||
| Subs | ||||||||||||||||||
| CLIN 1 | PoP | Actual Rate | Bid Rate | |||||||||||||||
| Project Name | TDL # | Subtask # (If Applicable) | Employee Identifier | 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 | Current Burdendend Cost | Cummulative Burdened Cost | % variation | Justification for variation exceeding 10% |
| TDL1 | SME SPT LOE 12 mo | Any Name | Analyst, Senior | On-site | 1250 | 160 | 0 | 480 | 0 | 10 | $ 120.00 | 0 | $ 57,600.00 | $ 120.00 | $ 57,600.00 | $ - 0 | N/A | |
| Em 1 | LCAT 1 | |||||||||||||||||
| Em 2 | LCAT 1 | |||||||||||||||||
| Em 3 | LCAT 2 | |||||||||||||||||
| Em 4 | LCAT 3 | |||||||||||||||||
| Em 5 | LCAT 4 | |||||||||||||||||
| TDL 2 | ||||||||||||||||||
| Subtask 1 | Em 1 | LCAT 1 | ||||||||||||||||
| Em 2 | LCAT 1 | |||||||||||||||||
| Em 3 | LCAT 2 | |||||||||||||||||
| Em 4 | LCAT 3 | |||||||||||||||||
| Em 5 | LCAT 4 | |||||||||||||||||
| Subtask 2 | ||||||||||||||||||
| TDL 3 | ||||||||||||||||||
| Subtask 1 | ||||||||||||||||||
| Subtask 2 | ||||||||||||||||||
| Subtask 3 | ||||||||||||||||||
| Subtask 4 | ||||||||||||||||||
| Subtask 5 | ||||||||||||||||||
| Subtask 6 | ||||||||||||||||||
| Subtask 7 |
| Totals: | |||||
| CLIN 2 | PoP | ||||
| TDL1 | |||||
| Em 1 | LCAT 1 | ||||
| Em 2 | LCAT 1 | ||||
| Em 3 | LCAT 2 | ||||
| Em 4 | LCAT 3 | ||||
| Em 5 | LCAT 4 | ||||
| TDL 2 | |||||
| Subtask 1 | Em 1 | LCAT 1 | |||
| Em 2 | LCAT 1 | ||||
| Em 3 | LCAT 2 | ||||
| Em 4 | LCAT 3 | ||||
| Em 5 | LCAT 4 | ||||
| Subtask 2 | |||||
| TDL 3 | |||||
| Subtask 1 | |||||
| Subtask 2 | |||||
| Subtask 3 | |||||
| Subtask 4 | |||||
| Subtask 5 | |||||
| Subtask 6 | |||||
| Subtask 7 |
Totals:
Grand Total:
TO Number
Personnel Matrix COR only file
| Prime Contract No | ||||||||
| TO Number | ||||||||
| Invoice Number | ||||||||
| Invoice Date | ||||||||
| PoP | ||||||||
| Billing Period | ||||||||
| Employee | LCAT | On/Off site | Key/Non-Key | Clearance Level | Date Resume submitted | Date Resume Approved | Date Removed (if Applicable) | Name of Replacement |
| These fields are N/A when non-key | ||||||||
| Sub 1: | ||||||||
| Employee | LCAT | On/Off site | Key/Non-Key | Clearance Level | Date Resume submitted | Date Resume Approved | Date Removed (if Applicable) | Name of Replacement |
| Employee | LCAT | On/Off site | Key/Non-Key | |||||
| Sub 2: | ||||||||
| Employee | LCAT | On/Off site | Key/Non-Key | Clearance Level | Date Resume submitted | Date Resume Approved | Date Removed (if Applicable) | Name of Replacement |
TO Number
COR Spend plan per CLIN
| Prime Contract No |
| Invoice Number |
| Invoice Date |
| PoP |
| Billing Period |
| This will be a spend plan graph by CLIN |
| 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 |
| 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 |
CLIN 0001
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 Expenditures to Date 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 EAC 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 Estimate 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
CLIN 0002
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 Expenditures to Date 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 EAC 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 Estimate 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
COR ODC Roll Up Reporting
| 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 .