Attachment 10 - CDRL Report Sample.xlsx
XLSX spreadsheet 96 KB Posted
- Solicitation number
- N5005426R0004
About this file
This file is a Contract Data Requirements List (CDRL) Report Sample template for tracking costs and resource utilization on submarine-related task orders. The template provides standardized reporting formats for weekly and monthly submissions, including a Weekly Summary Report, Labor Detail Report, ODC (Other Direct Cost) Detail Report, Travel Detail Report, and a TCN (Technical Contract Number) Report designed for import into the STAARS system, which is noted as required specifically for submarine contracts.
The Weekly Summary Report tracks cumulative period-of-performance (POP) costs by labor category (straight time and overtime), other direct costs, travel, and surge costs, with separate tracking for multiple funding sources including Fleet and Reimbursable funding types identified by ACRN codes. The Labor Detail Report lists individual employees by name, labor category, current and cumulative overtime hours, and associated costs. The ODC Detail Report itemizes material costs, warehouse charges, and non-teaming partner expenses. The Travel Detail Report documents travel by company personnel, location, purpose, and cost. The TCN Report provides standardized data fields including fiscal year, contract number, delivery order, vendor, customer vessel information, labor hours (regular and overtime), and various cost categories for submarine-specific work. Sample data demonstrates tracking of work on submarine hulls (HELENA SSN 725 and NEWPORT NEWS SSN 750) with cost reporting by multiple contractors, indicating this template supports multi-contractor task order administration under Navy submarine maintenance and support operations.
View the file
Other files
Show all 21
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
Info
| Information About Reports | ||
| Report Name | Frequency | Description |
| Weekly Summary (Simple) | Weekly | High level status of all costs associated with in individual task order. This report will require different funding sources and CLINs to be tracked independently and as a combined total. This report should be cumulative for the POP. To be used on Contracts with only one funding type (Fleet or Reimbursible) |
| Weekly Summary | Weekly | High level status of all costs associated with in individual task order. This report will require different funding sources and CLINs to be tracked independently and as a combined total. This report should be cumulative for the POP. To be used on Contracts with multiple funding types (Fleet and Reimbursible) |
| Labor Detail | Weekly | List of each individual (by name) with time charged against the task order and shall include the labor category, hours, and cost. This report should be cumulative for the POP. |
| ODC Detail | Weekly | List of all ODC/material costs charged against the task order and shall include the date and basic information about each cost. This report should be cumulative for the POP. |
| Travel Detail | Weekly | List of all Travel costs charged against the task order and shall include the date and basic information about each cost. This report should be cumulative for the POP. |
| TCN Report | 10th of each month | Specific data format of individual TCNs designed for importing into the STAARS system. SUBMARINE CONTRACTS ONLY |
Weekly Summary Report (Simple)
| Weekly Summary Report | |||
| Task/Contract Name: | Report Date: | PM POC: | |
| Task/Contract #: | POP Start: | SME/TPOC: | |
| Contract/Schedule #: | POP End: |
| Overall Summary | |||||||||
| Hours | Labor | ODC | Travel | Surge | Total | ||||
| ST | OT | Total | Hours | Labor | |||||
| Ceiling | |||||||||
| Funding | |||||||||
| Expended | |||||||||
| Committed | |||||||||
| Remaining | |||||||||
| Weekly Burn | |||||||||
| Depletion Date |
| Section Summary(s) (if required) | |||||||||
| Hours | Labor | ODC | Travel | Surge | Total | ||||
| ST | OT | Total | Hours | Labor | |||||
| Ceiling | |||||||||
| Funding | |||||||||
| Expended | |||||||||
| Committed | |||||||||
| Remaining | |||||||||
| Weekly Burn | |||||||||
| Depletion Date |
Weekly Summary Report
| Weekly Summary Report | ||||||||||||
| Task/Contract Name: | Report Date: | PM POC: | ||||||||||
| Task/Contract #: | POP Start: | SME/TPOC: | ||||||||||
| Contract/Schedule #: | POP End: | |||||||||||
| Hours | Overall | |||||||||||
| Funding - ACRN | Ceiling | ST Expended | OT Expended | Total Expended | Surge Expended | Labor | ODC | Travel | Surge Labor | Total | ||
| Fleet - AA | Ceiling | |||||||||||
| Reimb. #1 - AB | Funding | |||||||||||
| Reimb. #2 - AC | Expended | |||||||||||
| Committed | ||||||||||||
| Remaining | ||||||||||||
| Fleet Total | Weekly Burn | |||||||||||
| Reimb Total | Depletion Date | |||||||||||
| TOTAL |
| Labor | Surge | |||||||||||||
| Funding - ACRN | Ceiling | Funded | Expended | Committed | Remaining | Weekly Burn | Projected Depletion | Ceiling | Funded | Expended | Committed | Remaining | Weekly Burn | Projected Depletion |
| Fleet - AA | ||||||||||||||
| Reimb. #1 - AB | ||||||||||||||
| Reimb. #2 - AC |
| Fleet Total |
| Reimb Total |
| TOTAL |
| ODC | Travel | |||||||||||||
| Funding - ACRN | Ceiling | Funded | Expended | Committed | Remaining | Weekly Burn | Projected Depletion | Ceiling | Funded | Expended | Committed | Remaining | Weekly Burn | Projected Depletion |
| Fleet - AA | ||||||||||||||
| Reimb. #1 - AB | ||||||||||||||
| Reimb. #2 - AC |
| Fleet Total |
| Reimb Total |
| TOTAL |
Labor Detail Report
| Labor Detail Report | ||||||||
| Task/Contract Name: | Report Date: | PM POC: | ||||||
| Task/Contract #: | POP Start: | SME/TPOC: | ||||||
| Contract/Schedule #: | POP End: | |||||||
| Name | Labor Category | Current OT Hours | Cumulative OT Hours | Current Cost | Cumulative Cost | Name | Start Date | Stop Date |
| Employee #1 | Technical Project Manager | $0.00 | Employee #1 | 1/1/19 | Current | |||
| Employee #2 | Eng Tech V | 10.0 | 32.0 | 2,000.0 | $10,000.00 | Employee #2 | 1/1/19 | 5/31/19 |
| Employee #3 | ILS Specialist | 2.0 | 8.0 | 1,000.0 | $4,000.00 | Employee #3 | 1/1/19 | Current |
| Employee #4 | Supply Technician | $0.00 | Employee #4 | 6/1/19 | Current | |||
| Employee #5 | Supply Technician | $0.00 | Employee #5 | 1/1/19 | Current |
Total 12.0 40.0 $14,000.00
ODC Detail Report
| ODC Detail Report | |||
| Task/Contract Name: | Report Date: | PM POC: | |
| Task/Contract #: | POP Start: | SME/TPOC: | |
| Contract/Schedule #: | POP End: |
| Date | Information | Cost |
| Non-Teaming Partner | $1,100.00 | |
| Warehouse Charges | $2,200.00 | |
| Material Item 1 | $3,300.00 | |
| Material Item 2 | $350.00 |
Total $6,950.00
Travel Detail Report
| Travel Detail Report | |||
| Task/Contract Name: | Report Date: | PM POC: | |
| Task/Contract #: | POP Start: | SME/TPOC: | |
| Contract/Schedule #: | POP End: |
| Start Date | End Date | Company | Personnel | Location | Purpose | Cost |
| Prime Cont | A. Smith | Groton, CT | SSN 123 CSA | |||
| Sub Cont A | B. Anderson | Pearl Harbor, HI | SSN 123 Troubleshooting | |||
| Sub Cont B | C. Johnson, D. Smith | Guam | SSN 456 Repairs |
Total $0.00
TCN Report
| FY | Contract | DeliveryOrder | Vendor | Customer | TCN | Seq | Code | RF | ReportDate | ReportPeriodDate | LaborRGHours | LaborOTHours | LaborCost | TravelCost | MaterialCost | ODCCost | TotalCost |
| 2016 | N50054-16-D-0000 | 8C00 | Company A | HELENA (SSN 725) (Hull) | FQB | 10 | 271 | F | 936 | 0 | 5000.01 | 0 | 0 | 0 | 5000.01 | ||
| 2016 | N50054-16-D-0000 | 8C00 | Company B | HELENA (SSN 725) (Hull) | FQB | 12 | 273 | F | 80 | 0 | 10000.02 | 0 | 0 | 0 | 10000.02 | ||
| 2016 | N50054-16-D-0000 | 8C00 | Company C | NEWPORT NEWS (SSN 750) (Hull) | FQC | 10 | 271 | F | 811.5 | 0 | 20000.03 | 0 | 0 | 0 | 20000.03 |
File details come from the government source that posted it. Updated .