Attachment 10 - CDRL Report Sample.xlsx

XLSX spreadsheet 96 KB Posted

Attached to
Submarine Peculiar Special and Support Equipment (PSSE) Support Services for the Mid-Atlantic Regional Maintenance Center
Solicitation number
N5005426R0004
Issued by

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 NameFrequencyDescription
Weekly Summary (Simple)WeeklyHigh 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 SummaryWeeklyHigh 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 DetailWeeklyList 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 DetailWeeklyList 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 DetailWeeklyList 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 Report10th of each monthSpecific 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
HoursLaborODCTravelSurgeTotal
STOTTotalHoursLabor
Ceiling
Funding
Expended
Committed
Remaining
Weekly Burn
Depletion Date
Section Summary(s) (if required)
HoursLaborODCTravelSurgeTotal
STOTTotalHoursLabor
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:
HoursOverall
Funding - ACRNCeilingST ExpendedOT ExpendedTotal ExpendedSurge ExpendedLaborODCTravelSurge LaborTotal
Fleet - AACeiling
Reimb. #1 - ABFunding
Reimb. #2 - ACExpended
Committed
Remaining
Fleet TotalWeekly Burn
Reimb TotalDepletion Date
TOTAL
LaborSurge
Funding - ACRNCeilingFundedExpendedCommittedRemainingWeekly BurnProjected DepletionCeilingFundedExpendedCommittedRemainingWeekly BurnProjected Depletion
Fleet - AA
Reimb. #1 - AB
Reimb. #2 - AC
Fleet Total
Reimb Total
TOTAL
ODCTravel
Funding - ACRNCeilingFundedExpendedCommittedRemainingWeekly BurnProjected DepletionCeilingFundedExpendedCommittedRemainingWeekly BurnProjected 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:
NameLabor CategoryCurrent OT HoursCumulative OT HoursCurrent CostCumulative CostNameStart DateStop Date
Employee #1Technical Project Manager$0.00Employee #11/1/19Current
Employee #2Eng Tech V10.032.02,000.0$10,000.00Employee #21/1/195/31/19
Employee #3ILS Specialist2.08.01,000.0$4,000.00Employee #31/1/19Current
Employee #4Supply Technician$0.00Employee #46/1/19Current
Employee #5Supply Technician$0.00Employee #51/1/19Current

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:
DateInformationCost
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 DateEnd DateCompanyPersonnelLocationPurposeCost
Prime ContA. SmithGroton, CTSSN 123 CSA
Sub Cont AB. AndersonPearl Harbor, HISSN 123 Troubleshooting
Sub Cont BC. Johnson, D. SmithGuamSSN 456 Repairs

Total $0.00

TCN Report

FYContractDeliveryOrderVendorCustomerTCNSeqCodeRFReportDateReportPeriodDateLaborRGHoursLaborOTHoursLaborCostTravelCostMaterialCostODCCostTotalCost
2016N50054-16-D-00008C00Company AHELENA (SSN 725) (Hull)FQB10271F93605000.010005000.01
2016N50054-16-D-00008C00Company BHELENA (SSN 725) (Hull)FQB12273F80010000.0200010000.02
2016N50054-16-D-00008C00Company CNEWPORT NEWS (SSN 750) (Hull)FQC10271F811.5020000.0300020000.03

File details come from the government source that posted it. Updated .