Attachment_09_-_COMR_CDRL_Template.xlsx
XLSX spreadsheet 31 KB Posted
- Solicitation number
- N00421-19-R-0003
About this file
This sources sought notice from the Department of the Navy seeks capability statements from businesses for an indefinite delivery indefinite quantity contract to provide irregular air platform engineering services in support of integrating airborne capabilities onto manned and unmanned platforms. Services include program management, research, design, installation, testing, training, and operational support. Responses are due by 12:00 pm Eastern on July 9, 2018 and shall demonstrate experience with efforts of similar size and scope, technical skills to perform tasks such as systems engineering and integration, and the ability to obtain a Top Secret facility clearance. The anticipated single-award contract would have a 5-year ordering period and utilize cost-plus-fixed-fee, firm-fixed-price, and cost reimbursable contract types. Work is expected to be performed 70% on-site at Naval Air Station Patuxent River, with remaining work at Webster Field and Yuma Proving Grounds.
Attachment 09 - COMR CDRL Template
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
TDL 1 Breakout One tab per TDL
| Prime Contract No |
| TO Number |
| Invoice Number |
| Invoice Date |
| PoP |
| Billing Period |
| LABOR | Travel | Material | Other ODC | |||||||||||||||||||||||||||||
| Project Name | TDL # | Subtask # (If Applicable) | Description | LCAT | Employee Identifier | 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 | Current Material | Cummulative Material | Outstanding Commitments | Current Other ODC | Cummulative Other ODC | Outstanding Commitments |
| TDL1 | SME SPT LOE 12 mo | Analyst, Senior | 50012345 | 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 | 0 | 0 | 0 | 0 | 0 | 0 |
| Material Purchases | |||||||||||||
| Item Name | Subtask (if applicable) | 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 | Subtask (if applicable) | 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
| 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 |
| Expenditures to Date | $ 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 |
| EAC | $ 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 |
| Estimate | $ 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 |
| a. Description of the progress made against milestones during the reporting period. Specifically address the value-added tasks performed by the prime contractor when work is performed by a subcontractor; clearly identify the key and non-key personnel performing the tasks described. |
b. Identification of problem areas affecting technical, scheduling or costs elements, with background and any recommendations for solutions beyond the scope of the contract. Specifically, address results, positive or negative, obtained related to previously-identified program areas, with conclusions and recommendations for solutions.
c. Whether the task is on schedule, ahead of schedule, or behind schedule. Discuss what steps are being or will be taken to complete all requirements on time if possible, or provide a proposed revised schedule based on best current estimates if behind schedule.
d. The status of all assigned deliverables, including title, CDRL number, due date, date delivered, Contractor point of contact and description or title of deliverable(s). The report for each contract period shall include a cumulative list of all deliverable items provided.
Plans and recommendations for activities @ TDL level during the next reporting period;
l. Identify any new subcontractors approved during the reporting period and any proposed subcontractors/consultants for the next reporting period. Their capability set and areas of expertise shall be thoroughly addressed.
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
Actions:
1) Add LCAT and Employee breakout
TDL 2 Breakout
| Prime Contract No | ||||||||||||||||||||||||||||||
| TO Number | ||||||||||||||||||||||||||||||
| Invoice Number | ||||||||||||||||||||||||||||||
| Invoice Date | ||||||||||||||||||||||||||||||
| PoP | ||||||||||||||||||||||||||||||
| Billing Period | ||||||||||||||||||||||||||||||
| 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 | Current Material | Cummulative Material | Outstanding Commitments | Current Other ODC | Cummulative Other ODC | Outstanding Commitments |
| TDL 2 | ||||||||||||||||||||||||||||||
| Subtask 1 | ||||||||||||||||||||||||||||||
| Subtask 2 | ||||||||||||||||||||||||||||||
| TDL 2 Total: |
| Material Purchases | |||||||||||||
| Item Name | Subtask (if applicable) | 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 | Subtask (if applicable) | 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
| 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 |
| Expenditures to Date | $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 |
| EAC | $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 |
| Estimate | $ 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 |
| a. Description of the progress made against milestones during the reporting period. Specifically address the value-added tasks performed by the prime contractor when work is performed by a subcontractor; clearly identify the key and non-key personnel performing the tasks described. |
b. Identification of problem areas affecting technical, scheduling or costs elements, with background and any recommendations for solutions beyond the scope of the contract. Specifically, address results, positive or negative, obtained related to previously-identified program areas, with conclusions and recommendations for solutions.
c. Whether the task is on schedule, ahead of schedule, or behind schedule. Discuss what steps are being or will be taken to complete all requirements on time if possible, or provide a proposed revised schedule based on best current estimates if behind schedule.
d. The status of all assigned deliverables, including title, CDRL number, due date, date delivered, Contractor point of contact and description or title of deliverable(s). The report for each contract period shall include a cumulative list of all deliverable items provided.
Plans and recommendations for activities @ TDL level during the next reporting period;
l. Identify any new subcontractors approved during the reporting period and any proposed subcontractors/consultants for the next reporting period. Their capability set and areas of expertise shall be thoroughly addressed.
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
File details come from the government source that posted it. Updated .