L-5 NOC II Cost Plus Template.xlsx

Title Page Neutral Buoyancy Laboratory (NBL) Operations Contract II (NOC II)

Solicitation #

80JSC023R0007

Attachment L-5 NOC II Cost Price Template

Instructions and ToC

Offeror Name:

Yr 1 GFY2025 Base Contract Yr 2 GFY2026 Option 1, Yr 3 GFY2027 Option 2, Yrs 4 GFY2028 Option 2, Yrs 5 GFY2029 Option 3, Yrs 6 GFY2030 Option 3, Yrs 7 GFY2031 Option 4, Yr 8 GFY2032 Option 5, Yr 9 GFY2033 Option to Extend

GFY2034

9. The Offeror will be responsible for submitting a complete, comprehensive, and mathematically accurate file submission to the Government in the same format.

10. For its proposal preparation, the Prime offeror shall collect and be held accountable for all proposed unburdened base labor rate(s), for itself and all team members (i.e. major(s) and minor(s) SubK) for all applicable proposed labor classifications. As such, the Prime offeror shall coordinate and require the submission of the Government's requested data, from each Team member. No Team Member shall claim this data to be proprietary to the Prime offeror. This information will be utilized by the Government in its Cost Realism analysis.

11. Reserved

12. Reserved

The "Requirements Sections" column header is highlighted blue in each of the detailed data spreadsheet tabs "Labor Cost Details", "SubK Cost Details", and "Non-Labor Resources" that will have a drop down list of WBS sections. This will allow the Offerors to select the applicable WBS sections that applies to Prime Contractor and Subcontract labor and non-labor resource.

The following is an outline of supporting spreadsheet tabs of the core contract:

(1) Proposed Labor Hours and Cost supporting spreadsheet tabs: "Proposed Prime Labor Rates", and "Labor Cost Details",

(2) Subcontractor Cost supporting spreadsheet tabs: "SubK Cost Details"

(3) Non-Labor Resource Cost supporting spreadsheet tabs: "Non-Labor Resources"

(4) Indirect Cost (e.g. Fringe, OH, G&A etc.) supporting spreadsheet tabs: "Indirect Rates and Factors", "Fringe Rate Build-up", "Overhead Rate Build-up", "G&A Build-up", and "Additional Rate Build-up".

If applicable: The Offeror has the ability to add "Additional Indirect Rates (1-4)" in the green highlighted areas and make any adjustments to the excel formulas to capture the new added indirect rates to comply with their accounting and disclosure practices. If "Additional Rates 1 thru 4" are added to this spreadsheet tab, then the same indirect rates shall be reflected in the tab "Indirect Rates Summary Table" and "Additional Rate Build-up" with explanations for any adjustments included in the Offeror's cost narrative.

In general, indirect cost accounts for this contract fall into the broad categories: Fringe, Overhead, and G&A listed in "Indirect Rates and Factors". However, if needed to be consistent with their accounting system and disclosed practices the indirect structure could be tailored to the Offeror's company and how it operates. The Offeror will have the ability to adjust the indirect cost structure and calculation in the spreadsheet tabs "Indirect Rates and Factors" for their company's proposal. Nonetheless, in the absence of a Forward Pricing Rate Agreement (FPRA) or Forward Pricing Rate Recommendation (FPRR), the Prime Contractor and each known Major Subcontractor shall create and populate the applicable indirect rate build-up spreadsheet tab "Additional Rate Build-up" for each new indirect rates added to the contract and then provide the details and basis of estimate for the new indirect rate in the Offeror's cost narrative submittal.

* Hyperlinks are provided for convenience. The green highlighted tabs require inputs from the prime offeror (if applicable major SubK).

Within this tab, the proposed IDIQ Fully Burdened Labor Rate (FBLR) listed standard labor classification will be multiplied by the Government-provided Government Resource Estimate (GRE) that represents hours to create the Labor dollars (based on GREs) to the Government in tabs "WBS 7.0 IDIQ (CPAF)", and "WBS 7.0 IDIQ (FFP)". The FBLRs in the IDIQ Proposed Rates tab are linked to the core contract

Within this tab, the proposed IDIQ Non-Labor Resources applied indirect percentage will be required for the excel formula to be multiplied by the Government Resource Estimate (GRE) to create the Non-Labor Indirect dollars (based on GRE) to the Government in tabs "WBS 7.0 IDIQ (CPAF)", and "WBS 7.0 IDIQ (FFP)".

Within this tab, the proposed IDIQ Profit/Fee percentage will be required for the excel formula to be multiplied by the subtotal to create the profit dollars to the Government in tabs "WBS 7.0 IDIQ (CPAF)", and "WBS 7.0 IDIQ (FFP)".

Offerors shall not change the GRE values in the "WBS 7.0 IDIQ CPAF" and "WBS 7.0 IDIQ FFP" tabs. GREs are for evaluation purposes only and do not represent a limit or guarantee of future work nor do they represent an obligation, commitment, or amount to be ordered by the Government. Because of the uncertainties involved, there will be no stated minimum or maximum quantities for each CLIN specified in the IDIQ price list, and no future adjustment to the resulting price list, increase or decrease, will be made as a result of ordering above or below the GREs.

The proposed IDIQ rates (FBLR, Indirect Applied to Nonlabor, & Profit) will become part of the model contract. Reference RFP:

B.8 FIRM FIXED PRICE ORDER ESTIMATING (Applicable only to FFP IDIQ) B.9 COST REIMBURSEMENT ORDER ESTIMATING (Applicable only to Cost- Reimbursable IDIQ)

Note for IDIQ CPAF: Fully Burdened Labor Rates developed in the NOC II CPAF/CPFF core contract "Proposed Prime Labor Rates" tab shall be consistent with the Fully Burdened Labor Rates developed in the cost type IDIQ tabs "WBS 7.0 IDIQ (CPAF)" and "IDIQ Proposed Rates". Specifically the Fully Burdened Labor Rates that include Proposed Base Labor Rate Unburdened, Fringe, Overhead, Additional Indirect Rate (if applicable) and G&A. This note does not apply to the cost type IDIQ for Non-Labor Resources applied indirect percentage or IDIQ Fee percentage.

Note for IDIQ FFP: Proposed Unburdened Base Labor Rate developed in the NOC II CPAF/CPFF core contract "Proposed Prime Labor Rates" tab shall be consistent with the Proposed Unburdened Base Labor Rate developed in the Firm Fixed Price IDIQ tabs "WBS 7.0 IDIQ (FFP)" and "IDIQ Proposed Rates". However, if the IDIQ FFP Fully Burdened Labor Rates are not consistent with the NOC II CPAF/CPFF core contract "Proposed Labor Rates" tab then the offeror shall provide explanation in the cost narrative and provide supporting details of the new Indirect rates (e.g. Fringe, OH, G&A etc.).

Note: A "Blended" labor rate, as referenced herein, describes the potential of co-mingling the Prime offeror and subcontractor team member(s) labor rates based on workload allocation and or concurrent participation in a common SOW. If blended base labor rates are not utilized in the offerors proposal, then the prime base labor rates would be used as the offerors proposed base labor rates.

Within this tab, offeror will need to populate the proposed labor escalation in the green highlighted cells (=M5:U5) for GFY 2024 through GFY 2029.

Within this tab, offeror will need to populate each Standard Labor Classification (SLC) detail data (see list below) for all applicable green highlighted cells (=E10:BF40) and calculations for each GFY.

- Proposed Blended ST Base Labor Rate Unburdened (Prime & SubK's)

- Overtime Base Labor Rate Unburdened Hourly (Blended)

- Double Time Base Labor Rate Unburdened Hourly (Blended)

- ST Fully Burdened Labor Rate + Profit/Fee (Blended)

- Overtime FBLR + Profit/Fee (Blended)

- Double Time FBLR + Profit/Fee (Blended)

If needed, the offeror is able to add rows and add excel formulas to be consistent with their accounting and disclosure practices.

Within this tab, Offeror will need to populate the proposed labor escalation in the green highlighted cells for GFY 2025 through GFY 2033.

Within this tab, offeror will need to populate each Offeror's Labor Classification for all applicable green highlighted cells (=D10:D40)

- Offeror's Labor Classification (Titles Needed for Linked Tabs)

Within this tab, offeror will need to populate each Standard Labor Classification (SLC) detail data (see list below) for all applicable green highlighted cells (=E10:CZ40) and provided offerors calculations for each GFY. Basic formulas are provided for convenance, however, the offeror has the ability to change and input their own cost formulas to reflect the offeror accounting and disclosed practices for the spreadsheet to calculate the IDIQ price list.

- GFY 2024 Straight Time (ST) Base Labor Rate Unburdened

- Prime ST Base Direct Labor Rate Unburdened Hourly

- Overtime Base Labor Rate Unburdened Hourly

- Double Time Base Labor Rate Unburdened Hourly

- Fringe Added to Labor Rate

- Overhead Added to Labor Rate

- Additional Indirect Rate (if applicable)

- G&A Added to Labor Rate

- Fee Added to Labor Rate

- ST Fully Burdened Labor Rate thru Fee

- Overtime FBLR thru Fee

- Double Time FBLR thru Fee

If needed, the Offeror is able to add rows and adjust the excel formula to be consistent with their accounting and disclosure practices. The Offeror shall provide the narrative details of the proposed labor rates in the offerors cost narrative submittal to allow the Government to perform an adequate evaluation.

Note: Proposed Unburdened Base Labor Rate developed in the NOC II CPAF/CPFF core contract "Proposed Prime Labor Rates" tab shall be consistent throughout the whole total evaluated cost/price to include Phase-In, Core Contract, and IDIQ.

Note: All cost type contract Fully Burdened Labor Rates shall be consistent with the NOC II CPAF/CPFF core contract "Proposed Labor Rates" tab throughout the total evaluated cost/price (i.e. Phase-In, Core Contract, and IDIQ). However, if the cost type contract Fully Burdened Labor Rates are not consistent the Firm Fixed Price (Phase-In, IDIQ FFP) contract then the offeror shall provide explanation in the cost narrative and then provide supporting details of the new Indirect rates (e.g. Fringe, OH, G&A etc.)

Within this tab, the standard labor classifications (SLC) are pre-populated by each of the SOW requirements only for convenience of the Offerors completing the green highlighted cells in the template. However, the Offeror can adjust, knowing that the Offeror would need to select both of the SLC and WBS number for the information to pull in to the tabs: WBS Summary

Within this tab the "Requirements Sections" column header is highlighted blue and will have a drop down list of WBS sections for CLINs. This will allow the Offerors to select the applicable WBS sections that applies to offerors Prime Contractor labor.

Within this tab, Offeror will need to populate the proposed productive labor hour factor (PLHF) in the green highlighted cells for the excel formulas to auto calculate the work year equivalent (WYE) by dividing the GFY straight time labor hours by the GFY PLHF.

Within this tab, the Offeror will need to provide labor cost requested information (labor type, labor location).

If needed, the Offeror is able to add rows and adjust the excel formula to be consistent with their accounting and disclosure practices. The Offeror shall provide cost narrative submittal for the proposed labor cost to allow the Government to perform an adequate evaluation.

Within this tab, Offeror will need to populate the summarized list of the Subcontractors table information (SubK: name, contract type, contract size, and major/minor) in the green highlighted cells within this tab to auto populate the drop down list in this SubK tab. The offeror will also needed to provide the subcontractors labor classifications.

Within this tab, the standard labor classifications (SLC) are pre-populated by each of the WBS requirements only for convenience of the Offerors completing the green highlighted cells in the template. However, the Offeror can adjust, knowing that the Offeror would need to select both of the SLC and WBS number for the information to pull in to the tabs: WBS Summary tabs.

Within this tab, the "Requirements Sections" column header is highlighted blue and will have a drop down list of WBS sections for the contract. This will allow the Offerors to select the applicable WBS sections that applies to subcontract labor and non-labor resource.

Within this tab, offeror will need to populate the offerors proposed productive labor hour factor (PLHF) in the green highlighted cells for the excel formulas to auto calculate the work year equivalate (WYE) by dividing the GFY straight time labor hours by the GFY PLHF.

Within this tab, the offeror will need to provide SubK labor cost requested information (labor type, labor location, % of allocated work load)

If needed, the Offeror is able to add rows and adjust the excel formula to be consistent with their accounting and disclosure practices. The Offeror shall provide cost narrative submittal for the proposed SubK cost to allow the Government to perform an adequate evaluation.

Within this tab, the non-labor resources are pre-populated (column C) by each of the SOW requirements only for convenience of the Offerors completing the template.

Within this tab, the "Requirements Sections" column header is highlighted blue and will have a drop down list of WBS sections for the contract and all the applicable SOW requirements. This will allow the Offerors to select the applicable WBS sections that applies to non-labor resource.

If needed, the Offeror is able to add rows and adjust the excel formula to be consistent with their accounting and disclosure practices. The Offeror shall provide cost narrative submittal for the proposed non-labor cost to allow the Government to perform an adequate evaluation.

WBS Requirements Structure

CLIN Summary Neutral Buoyancy Laboratory (NBL) Operations Contract II (NOC II)

Yr 1 GFY2025 Base Contract Yr 2 GFY2026 Option 1, Yr 3 GFY2027 Option 2, Yrs 4 GFY2028 Option 2, Yrs 5 GFY2029 Option 3, Yrs 6 GFY2030 Option 3, Yrs 7 GFY2031 Option 4, Yr 8 GFY2032 Option 5, Yr 9

WBS Summary

Yr 1 GFY2025 Base Contract Yr 2 GFY2026 Option 1, Yr 3 GFY2027 Option 2, Yrs 4 GFY2028 Option 2, Yrs 5 GFY2029 Option 3, Yrs 6 GFY2030 Option 3, Yrs 7 GFY2031 Option 4, Yr 8 GFY2032 Option 5, Yr 9

Yr 1 CY2025 Base Contract Yr 2 CY2026 Option 1, Yr 3 CY2027 Option 2, Yrs 4 CY2028 Option 2, Yrs 5 CY2029 Option 3, Yrs 6 CY2030 Option 3, Yrs 7 CY2031 Option 4, Yr 8 CY2032 Option 5, Yr 9

IDIQs (CPAF, CPFF, and FFP) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 IDIQ $ - 0 $ - 0

../../1.%20Draft%20RFP%20(DRFP)/PAB%20Review/Attachments/Sections%20L%26M/L-5%20NOC%20II%20Cost%20Plus%20Template.xlsx Phase In

Labor Category Phase In (60 Days)

GFY 2024

Fee % 0.0% $ - 0

Total Price $ - 0

WBS 1.0

Neutral Buoyancy Laboratory (NBL) Operations Contract II (NOC II)