P7 COR Only Excel Template.xlsx
XLSX spreadsheet 38 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 solicitation and a COR only Excel template. The solicitation seeks Contractor Support Services personnel to provide engineering, technical, administrative, and program management support for the Support Equipment Test & Evaluation Branch at Naval Air Warfare Center Aircraft Division in Patuxent River, Maryland. Services include systems engineering, testing, analysis, development integration, modification and repair of aviation support equipment. The requirement is for a non-performance based, cost-plus-fixed-fee, single award IDIQ contract over five years. The NAICS code is 541330. The COR only Excel template appears to be for tracking contract funding, expenditures, labor hours, travel costs and other financial details at the task level on a monthly basis. It includes tabs for labor breakdown and material/travel tracking.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 0001.pdf | ||
| P9 Wage Determination.pdf | ||
| Conformed Amendment 0001.pdf | ||
| A006.docx | DOCX document | |
| P3 PPIF.pdf | ||
| P6 Personnel Resource Matrix.xlsx | XLSX spreadsheet | |
| P6 Personnel Resource Matrix.xlsx | XLSX spreadsheet | |
| A003.doc | DOC document | |
| A004.doc | DOC document | |
| P1 Cost.xls | XLS spreadsheet | |
| P3 PPIF.pdf | ||
| J5 Data_Item_Transmittal_Acceptance_Rejection_Form.docx | DOCX document | |
| A001.doc | DOC document | |
| P2 Fully Burdened.xlsx | XLSX spreadsheet | |
| P8 COR and Customer Excel Template.xlsx | XLSX spreadsheet | |
| J4 DD254.pdf | ||
| A006.docx | DOCX document | |
| P5 CPAQ Instructions.docx | DOCX 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 |
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 customer/TPOC & COR march 2020 | |
| Contractor's Name | |
| Contractror's Address | |
| Title of Report | |
| CDRL # | |
| Date of Report | |
| Period Covered by Report | |
| Contract number | |
| Name if issuing Government Agency | |
| Program/System Nomenclature | |
| Security Classification or other appropriate markings |
CDRL# & Title TO Number
TDL 1 Breakout One tab per TDL
| TDL CDRL attachment customer/TPOC & COR march 2020 |
| 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
Sheet1
TDL 2 Breakout
| TDL CDRL attachment customer/TPOC & COR march 2020 | ||||||||||||||||||||||||||||||
| 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 .