Appendix A - CDRL Workforce and Workload Template.xlsx

28 KB Posted

Attached to
Dry Dock and Workforce Capabilities - Shipyards
Solicitation number
70Z02324RFIDOCK0001
Issued by

About this file

Written by GovTribe AI ·

This Excel template is for shipyards to provide dry dock and workforce capabilities information to the US Coast Guard. The template requires shipyards to provide manpower projections and availability timelines for government dry dock availabilities from July 2024 through September 2025 where they serve as either the prime or subcontractor. Ship names, availability types, start and end dates, and monthly estimates of actual and forecasted costs, work completed, and work scheduled are to be included. Additional sections request projections for non-government commercial workloads as well as maximum monthly workforce capacities by trade for the period. The template appears to be an appendix to an RFI from the US Coast Guard seeking dry dock and workforce capabilities information from shipyards to inform future planning efforts. No specific products or services are solicited in the document.

View the file

Other files

File Type Posted
RFI for Posting to SAM_Amendment 0001.pdf PDF
RFI for Posting to SAM.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Prime KTR GOV Avail Totals This worksheet shall be completed with manpower requirements to execute GOV availabilities for which the company is the Prime contractor. This includes prime, subcontractor, temporary labor requirements.

DRY DOCK GOV AVAIL TOTALS BY PROJECTFY 2024FY 2025
Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25
Project X
(Ship Name)Project X
(Avail Type)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours
Contract Start Date:Monthly BCWP Hours
Contract Completion Date:Monthly BCWS Hours
Project Y
(Ship Name)Project Y
(Avail Type)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours
Contract Start Date:Monthly BCWP Hours
Contract Completion Date:Monthly BCWS Hours
Project Z
(Ship Name)Project Z
(Avail Type)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours
Contract Start Date:Monthly BCWP Hours
Contract Completion Date:Monthly BCWS Hours

Sub KTR GOV Avail Totals This worksheet shall be completed to specify manpower provided by the company as a subKTR to other GOV availabilities.

GOV AVAIL TOTALS BY PROJECTFY 2024FY 2025
Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25
Project 1
(Ship Name)Project 1
(Avail Type)Project 1
(Prime KTR)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours
Project 2
(Ship Name)Project 2
(Avail Type)Project 2
(Prime KTR)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours
Project 3
(Ship Name)Project 3
(Avail Type)Project 3
(Prime KTR)Actual/Forecast Start Date:Monthly ACWP Hours
Actual/Forecast Completion Date:Monthly ETC Hours

Non-GOV Workload

OTHER WORK TOTALS BY CATEGORYFY 2024FY 2025
Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25
Commercial WorkTotal Planned Work Hours

Trade Totals

TOTAL TRADE INFORMATIONFY 2024FY 2025
Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25
Trade 1Planned Work (Hours)
Maximum Capacity (Hours)
Trade 2Planned Work (Hours)
Maximum Capacity (Hours)
Trade 3Planned Work (Hours)
Maximum Capacity (Hours)
Other Support Functions1Planned Work (Hours)
Maximum Capacity (Hours)
Note 1: Other Support Functions includes direct charge trades such as project management, contracts, QA, scheduling, etc.

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