Attachment L-01B USDV Fixed Price Template Amendment 5.xlsx

XLSX spreadsheet 4 MB Posted

Attached to
United States Deorbit Vehicle
Solicitation number
80JSC023R0003
Issued by

About this file

This document is a template for a firm fixed price proposal submission in response to solicitation number 80JSC023R0003 for the United States Deorbit Vehicle program.

The template requires offerors to provide pricing details for the core contract and indefinite delivery indefinite quantity contract line items to be awarded as a single-award firm fixed price contract by the National Aeronautics and Space Administration Johnson Space Center. Pricing is required for the design, development, test and evaluation; production, assembly, integration and test; critical spares option; dwell; launch vehicle integration and sustaining; and special tasks and studies contract line items across multiple government fiscal years. Offerors must complete spreadsheets detailing direct labor hours, labor rates, subcontractor costs, non-labor resources, indirect costs, and profit by contract line item and year. Supporting documentation in cost narratives is also required. The period of performance spans June 2024 through September 2035.

View the file

Other files

File Type Posted
80JSC023R0003 RFP Question and Answer Part IV.pdf PDF
80JSC023R0003 RFP Amendment 7.pdf PDF
Attachment_L-03_Technical_Resources_Template_Amendment 6.xlsx XLSX spreadsheet
Attachment J-40 Deliverable Items List_Amendment 6.xlsx XLSX spreadsheet
80JSC023R003 USDV RFP Model Contract Attachment J-01 - Data Requirements Deliverable.docx DOCX document
80JSC023R0003 USDV RFP Amendment 6.pdf PDF
80JSC023R0003 USDV RFP Model Contract Amendment 6.docx DOCX document
Attachment L-01C Minor Subcontractor Template Amendment 6.xlsx XLSX spreadsheet
80JSC023R0003 RFP Amendment 4 Questions and Answers.pdf PDF
80JSC023R0003 Model Contract Amendment 5.docx DOCX document
Attachment L-01D USDV Hybrid Cost Price Template (CLIN 1 and 2 CPIF) Amendment 5.xlsx XLSX spreadsheet
Attachment L-01A USDV Hybrid Cost Price Template Amendment 5.xlsx XLSX spreadsheet
80JSC023R0003 Amendment 5.pdf PDF
Attachment L-01C Minor Subcontractor Template Amendment 5.xlsx XLSX spreadsheet
80JSC023R0003 USDV RFP Amendment 4.pdf PDF
BG-23-205 USDV RFP Amendment 4 Cover Letter .pdf PDF
Attachment L-01A USDV Hybrid Cost Price Template Amendment 4.xlsx XLSX spreadsheet
BG-23-205 Enclosure 2 USDV RFP Question Template.xlsx XLSX spreadsheet
Attachment L-01C Minor Subcontractor Template Amendment 4.xlsx XLSX spreadsheet
Attachment L-01B USDV Fixed Price Template Amendment 4.xlsx XLSX spreadsheet
80JSC023R0003 Model Contract Amendment 4.docx DOCX document
Attachment L-01D USDV Hybrid Cost Price Template (CLIN 1 and 2 CPIF) Amendment 4.xlsx XLSX spreadsheet
80JSC023R0003 Amendment 3.pdf PDF
Attachment L-03 Technical Resources Template Revised Amendment 3.xlsx XLSX spreadsheet
Final RFP Question and Answer Part II.pdf PDF
80JSC023R003 Amendment 2.pdf PDF
80JSC023R0003 USDV Model Contract Amendment 2.docx DOCX document
Final RFP Questions and Answers.pdf PDF
Pre Proposal Conference Question and Answers.pdf PDF
Attachment L-01A USDV Hybrid Cost Price Template Amendment 1.xlsx XLSX spreadsheet
80JSC023R0003 Amendment 1.pdf PDF
Attachment L-01B USDV Fixed Price Template Amendment 1.xlsx XLSX spreadsheet
80JSC023R0003 USDV PreProposal Conference (Pricing) Presented.pdf PDF
80JSC023R0003 USDV PreProposal Conference Presented Presented.pdf PDF
80JSC023R0003 USDV PreProposal Conference.pdf PDF
80JSC023R0003 USDV PreProposal Conference (Pricing).pdf PDF
Attachment J-40 Deliverable Items List.xlsx XLSX spreadsheet
Attachment L-03 Technical Resources Template.xlsx XLSX spreadsheet
SF33-22.pdf PDF
Attachment L-01C Minor Subcontractor Template.xlsx XLSX spreadsheet
Attachment L-01A USDV Hybrid Cost and Price Template.xlsx XLSX spreadsheet
USDV Final RFP Technical Library File Mapping.pdf PDF
Attachment L-07 Past Performance Matrix.xlsx XLSX spreadsheet
Attachment J-38 DD Form 254 Department of Defense Contract Security Classification Specification.pdf PDF
Attachment L-01B USDV Fixed Price Template.xlsx XLSX spreadsheet
Attachment L-09 Pre-award Survey of Prospective Contractor Accounting System Checklist.pdf PDF
80JSC023R0003 USDV Model Contract.docx DOCX document
Attachment L-10 Prime and Subcontractor Identification and SOW Division of Work Listing.xlsx XLSX spreadsheet
BG-23-118 USDV Final RFP Cover Letter .pdf PDF
80JSC023R0003 USDV RFP.pdf PDF
Show all 50

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

Title Page

UNITED STATES DEORBIT VEHICLE

(USDV)

Single-Award, Hybrid Firm Fixed Price Contract

# 80JSC023R0003

Attachment L-01B USDV Fixed Price Template (Amend 4 Revised)

Instructions and ToC

Offeror Name:

General InstructionsUSDV FFP Contract Period of Performance by GFY
GFY 2024
(Year 1)GFY 2025
(Year 2)GFY 2026
(Year 3)GFY 2027
(Year 4)GFY 2028
(Year 5)GFY 2029
(Year 6)GFY 2030
(Year 7)GFY 2031
(Year 8)GFY 2031

Option Period (Year 9) GFY 2032 Option Period (Year 9) GFY 2033 Option Period (Year 10) GFY 2034 Option Period (Year 11) GFY 2035 Option Period (Year 12)

1. The USDV Single-Award, Firm Fixed Price (FFP) contract total evaluated cost and price includes: CLIN 1 - Design, Development, Test and Evaluation through Critical Design Review (DDT&E Thru CDR) FFP, CLIN 2 - Production, Assembly, Integration, and Test (PAI&T) FFP, CLIN 2A - Critical Spares (Separately Priced Line Item) FFP. The USDV Single-Award, FFP contract also includes FFP Indefinite Delivery / Indefinite Quantity (IDIQ)s: CLIN 3 - Dwell FFP IDIQ, CLIN 4 - Launch Vehicle (LV) Integration and Sustaining FFP IDIQ, CLIN 4 PrePriced TO (1) FFP, CLIN 5A - Special Task & Studies FFP IDIQ, and CLIN 5B Pre-Priced Evaluation of NASA Requirements FFP IDIQ. Then finally, the FFP Government Task Agreements and Government Provided. The CLIN 4 PrePriced DO (2) FFP is specifically referenced to RFP Attachment L-04B.

6/25/2410/1/2410/1/2510/1/2610/1/2710/1/2810/1/2910/1/304/1/3110/1/3110/1/3210/1/3310/1/34
9/30/249/30/259/30/269/30/279/30/289/30/299/30/303/31/319/30/319/30/329/30/339/30/349/30/35
2.The USDV Single-Award, (FFP) contract period of performance: 06/25/2024 through 09/30/2035. The table to the right illustrates each government fiscal year (GFY) core contracts and option periods for the contract period of performance. Reference RFP (80JSC023R0003), F2. COMPLETION OF WORK, F.3 FAR 52.211-9 DESIRED AND REQUIRED TIME OF DELIVERY (JUN 1997), and F.7 OPTION TO EXTEND.31212121212126612121212
Reference:
3.Offerors are advised to review the narrative provided in the RFP, L.26 COST AND PRICE FACTOR - VOLUME I.F.2 COMPLETION OF WORK
4.The Offeror (e.g. Prime Contractors) and Major Subcontractors (If applicable) are required to complete and submit: (a) Attachment L-01B USDV Fixed Price Template.F.3 FAR 52.211-9 DESIRED AND REQUIRED TIME OF DELIVERY (JUN 1997)
F.7 OPTION TO EXTEND
5.Major Subcontractor(s), as used in this provision, is a team member and/or subcontractor that has a subcontract with a total proposed period value (GFY2024-2031) threshold greater than $50 million or proposing contract required major critical element. A major subcontractor will perform a percentage of the contract allocated workload in offerors fully integrated Attachment L-01B tabs “SubK Cost Details (CLIN 1) ”, “SubK Cost Details (CLIN 2) ”, and “SubK Cost Details (CLIN 2A) ”. Per RFP, L.26.1(c)(3), Major Critical element as used in this provision is defined as the following major propulsion components: thrusters, valves, regulators, and tanks. Major Subcontractors are required to complete and submit: (a) Attachment L-01A USDV Hybrid Cost Price Template, Attachment L-01B USDV Fixed Price Template, or (c) Attachment L-01D USDV Hybrid Cost Price Templates (CLIN 1 and 2 CPIF). Major Subcontractors may submit their files directly to the Government (Reference: RFP, L.18 ELECTRONIC SUBMISSION OF PROPOSALS) if information is deemed proprietary and not shared with the Prime.
6.Offerors shall fill in all applicable green highlighted cells in the Attachment L-01B USDV Fixed Price Template.
7.It is offeror's responsibility to ensure all formulas in this USDV Fixed Price Template comply with their accounting/estimating processes and/or disclosure statement.
8.The offeror is able to adjust formulas or add rows in the USDV Fixed Price Template to reflect the offerors accounting and disclosure practices. However the offeror shall not change the existing excel table organization or design within each spreadsheet tabs. If needed, the offeror is able to add proposal support data spreadsheet tabs to this document.

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

10. Reference RFP, L.26.1, the Prime offeror Attachment L-01B USDV Fixed Price Template shall represent a fully integrated cost and price strategy to include all subcontractors. The Major Subcontractor completes and submits one of their own USDV Templates from attachments L-01A, L-01B, or L-01D. The Minor Subcontractor to complete a separate Excel spreadsheet “Attachment L-01C USDV Minor Subcontractor Template” that will be required by all minor subcontractor(s) performing a percentage of the contract allocated workload.

11. Reserved

12. Reserved

Template Preparation Instructions by Spreadsheet TabsName#Table of Contents *
1.Instructions and ToCInstructions and ToC1.Instructions and ToC
To assist the offeror in completing the USDV Fixed Price Template, the Government has provided general instructions and then specific template preparation instructions for each applicable spreadsheet tab listed in the Table of Contents to the right. Each green highlighted tab listed in the Table of Contents, requires inputs from the prime offeror (if applicable major Subcontractor). To further assist the Offerors in understanding the excel formulas used (or drop-down list) in each spreadsheet tabs there may be a Red Triangle in the top right corner of column titles that indicates a Gov't provided note is in the cell. The offeror will need to fill-in the offerors name in the green highlighted cell (=C2) above for it to populate in the spreadsheet "CLIN 1 Labor Cost Details" tab (Cell C10), "CLIN 2 Labor Cost Details" tab (Cell C10), and "CLIN 2A Labor Cost Details" tab (Cell C10).Requirements Structure2.Requirements Structure
Total Cost & Price Summary3.Total Cost & Price Summary
CLIN 1 (SOW 3.0) FFP4.CLIN 1 (SOW 3.0) FFP
CLIN 2 (SOW 4.0) FFP5.CLIN 2 (SOW 4.0) FFP
CLIN 2A OPTION FFP6.CLIN 2A OPTION FFP
CLIN 3 (SOW 5.0) IDIQ7.CLIN 3 (SOW 5.0) IDIQ
CLIN 4 (SOW 6.0) IDIQ8.CLIN 4 (SOW 6.0) IDIQ
2.Requirements StructureCLIN 4 PrePriced TO (1)9.CLIN 4 PrePriced TO (1)
This spreadsheet tab provides an outline of the FFP Contract Line Item Number (CLIN) structure by Statement of Work (SOW) requirements. The tables on the tab are for informational purposes to visually illustrate how the Contract Line Item Number (CLIN) structure are summarizing the USDV FFP core contract requirements that are a roll up of the applicable SOW requirements sections. For example: SOW sections 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.10 would be added together to complete CLIN 1, (SOW Section 3.0). The USDV Fixed Price Template does not require FFP IDIQ CLIN 3, CLIN 4 , and CLIN 5 to be broken out to SOW sections (SOW Sections 5.0, 6.0 and 7.0). The offeror shall refer to the Attachment USDV Statement of Work for the specific details of each of the SOW requirements (RFP, SECTION C - DESCRIPTION/SPECIFICATIONS/STATEMENT OF WORK).

The "Requirements Sections" column header is available in each of the detailed data spreadsheet tabs "...Labor Cost Details", "SubK Cost Details...", and "Non-Labor Resources..." that will have a list of SOW sections for CLINs 1, 2, and 2A. This will allow the offerors to select the applicable SOW sections that applies to Prime contractor and Subcontract labor and non-labor resource. The core contract applied SOW 2.0 - Overall General Requirements are also listed for pricing purposes in the detailed tabs for CLIN 1 and 2.

CLIN 4 PrePriced DO (2)10.CLIN 4 PrePriced DO (2)
CLIN 5A (SOW 7.1) IDIQ11.CLIN 5A (SOW 7.1) IDIQ
CLIN 5B (SOW 7.2) IDIQ12.CLIN 5B (SOW 7.2) IDIQ
Government Task Agreement13.Government Task Agreement
Government Provided14.Government Provided
Prime Labor Rates (CLIN 1)15.Prime Labor Rates (CLIN 1)
Prime Labor Rates (CLIN 2)16.Prime Labor Rates (CLIN 2)
Prime Labor Rates (CLIN 2A)17.Prime Labor Rates (CLIN 2A)
Summary Labor Cost (CLIN 1)18.Summary Labor Cost (CLIN 1)
Summary Labor Cost (CLIN 2)19.Summary Labor Cost (CLIN 2)
Summary Labor Cost (CLIN 2A)20.Summary Labor Cost (CLIN 2A)
CLIN 1 Labor Cost Details21.CLIN 1 Labor Cost Details
3.Total Cost & Price SummaryCLIN 2 Labor Cost Details22.CLIN 2 Labor Cost Details
This spreadsheet tab summarizes the total evaluated cost and price data into two tables "CLIN Summary" and "Total Evaluated Cost and Price (Segregation by Core Contract and IDIQ)" for the performance period by Government Fiscal Year (GFY) for the USDV Single-Award, FFP core contract with IDIQs (Dwell, LV Integration/Sustaining, & Special Task/Studies). No offeror input is required for this worksheet tab unless excel formulas are changed to reflect the offerors accounting/estimating processes and/or disclosure statement. Both of the tables "CLIN Summary" and "Total Evaluated Cost and Price (Segregation by Core Contract and IDIQ)" are to visually represent the total evaluated price in two different ways. The CLIN Summary table breaks down the USDV Core Contract and IDIQs total evaluated price by the following spreadsheet tabs "CLIN 1 (SOW 3.0) FFP", "CLIN 2 (SOW 4.0) FFP", "CLIN 2 OPTION FFP", "CLIN 3 (SOW 5) IDIQ", "CLIN 4 (SOW 6) IDIQ", "CLIN 4 PrePriced TO (1)", "CLIN 4 PrePriced DO (2)", "CLIN 5A (SOW 7.1) IDIQ", "CLIN 5B (SOW 7.2) IDIQ", "Government Task Agreements", and "Government Provided". Then, the Cost Element Summary table breaks down the USDV FFP contract and IDIQs total evaluated price by each Element of Cost to include Direct Labor Hours, Labor Dollars, Non-Labor Resources, Indirect Cost, Profit, IDIQ's (Dwell, LV Integration/Sustaining, & Special Task/Studies), Government Task Agreements, and Government Provided (furnished property, facilities, & equipment). This tab contains references (columns Q), that are linked to each of the USDV contract Summary tabs for the convenience of each offeror completing the USDV Fixed Price Template. Gray shaded cells in this tab should reference back to RFP, F.2 COMPLETION OF WORK and F.3 FAR 52.211-9 DESIRED AND REQUIRED TIME OF DELIVERY (JUN 1997).
Note: The CLIN 4 PrePriced DO (2) FFP price is collected, but not included in the total evaluated price.CLIN 2A Labor Cost Details23.CLIN 2A Labor Cost Details
Summary SubK Cost (CLIN 1)24.Summary SubK Cost (CLIN 1)
Summary SubK Cost (CLIN 2)25.Summary SubK Cost (CLIN 2)
Summary SubK Cost (CLIN 2A)26.Summary SubK Cost (CLIN 2A)
SubK Cost Details (CLIN 1)27.SubK Cost Details (CLIN 1)
SubK Cost Details (CLIN 2)28.SubK Cost Details (CLIN 2)
SubK Cost Details (CLIN 2A)29.SubK Cost Details (CLIN 2A)
Non-Labor Resources (CLIN 1)30.Non-Labor Resources (CLIN 1)
Non-Labor Resources (CLIN 2)31.Non-Labor Resources (CLIN 2)
Non-Labor Resources (CLIN 2A)32.Non-Labor Resources (CLIN 2A)
Indirect Rates Summary Table33.Indirect Rates Summary Table
* Hyperlinks are provided for convenience. The green highlighted tabs require inputs from the prime offeror (if applicable major SubK).
4.CLIN 1 (SOW 3.0) FFP
This spreadsheet tab is a summary and used to develop the total FFP CLIN 1 (SOW 3.0) Design, Development, Test and Evaluation through Critical Design Review (DDT&E Thru CDR) with applied SOW 2.0 - Overall General Requirements cost that is included within the USDV Single-Award, FFP core contract (GFY 2024 - 2031). This summary tab should be auto filled (using excel formulas) pulling information from each of the supporting cost element tabs which calculates each element of cost to be included in the total evaluated price. However, within this spreadsheet tab "CLIN 1 (SOW 3.0) FFP" the offeror would need to input indirect cost (e.g. Fringe, OH, G&A etc.) formulas (cells =F28:P30) to reflect the offeror accounting and disclosed practices for the spreadsheet to calculate the offerors applicable indirect cost for CLIN 1 FFP contract price. This tab contains references (columns S and T), that are linked to each of the elements of cost supporting detailed data for the convenience of each offeror completing the USDV Fixed Price Template.

The following is an outline of supporting spreadsheet tabs of the Firm Fixed Price core contract CLIN 1 (SOW 3.0) with applied SOW 2.0 - Overall General Requirements:

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

(2) Subcontractor Cost supporting spreadsheet tabs: "Summary SubK Cost (CLIN 1)", "SubK Cost Details (CLIN 1)"

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

(4) Indirect Cost (e.g. Fringe, OH, G&A etc.) spreadsheet tabs: "Indirect Rates Summary Table".

If applicable: The offeror has the ability to add "Additional Indirect Rates (1-4)" in the green highlighted areas (cells =F31:P34) 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(CLIN1)" with explanations for any adjustments included in the offeror cost narrative.

In general, indirect cost accounts for this CLIN 1 FFP contract fall into the broad categories: Fringe, Overhead, and G&A listed in "Indirect Rates Summary Table" tab (column B). However, if needed to be consistent with their accounting system and disclosed practices the indirect structure could be tailored to the offerors company and how it operates. The Offeror will have the ability to adjust the indirect cost structure and calculation in the spreadsheet tabs "CLIN 1 (SOW 3.0) FFP" and "Indirect Rates Summary Table" for their company proposal. Nonetheless, the prime contractor and each known Major subcontractor shall provide the basis of estimate for the indirect rates in the offerors price narrative submittal.

Reference RFP, B.1 CLIN 1 DESIGN, DEVELOPMENT, TEST AND EVALUATION (DDT&E) THROUGH CRITICAL DESIGN REVIEW (CDR) (CORE)

5.CLIN 2 (SOW 4.0) FFP
This spreadsheet tab is a summary and used to develop the total FFP CLIN 2 (SOW 2.0 & 4.0) Production, Assembly, Integration, and Test with applied SOW 2.0 - Overall General Requirements cost that is included within the USDV Single-Award, FFP core contract (GFY 2024 - 2031). This summary tab should be auto filled (using excel formulas) pulling information from each of the supporting cost element tabs which calculates each element of cost to be included in the total evaluated price. However, within this spreadsheet tab "CLIN 2 (SOW 4.0) FFP" the offeror would need to input indirect cost (e.g. Fringe, OH, G&A etc.) formulas (cells =F28:P30) to reflect the offeror accounting and disclosed practices for the spreadsheet to calculate the offerors applicable indirect cost for CLIN 2 FFP contract price. This tab contains references (columns S and T), that are linked to each of the elements of cost supporting detailed data for the convenience of each offeror completing the USDV Fixed Price Template.

The following is an outline of supporting spreadsheet tabs of the Firm Fixed Price core contract CLIN 2 (SOW 4.0) with applied SOW 2.0 - Overall General Requirements:

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

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

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

(4) Indirect Cost (e.g. Fringe, OH, G&A etc.) spreadsheet tabs: "Indirect Rates Summary Table".

If applicable: The offeror has the ability to add "Additional Indirect Rates (1-4)" in the green highlighted areas (cells =F31:P34) 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 cost narrative.

In general, indirect cost accounts for this CLIN 2 FFP contract fall into the broad categories: Fringe, Overhead, and G&A listed in "Indirect Rates Summary Table" tab (column B). However, if needed to be consistent with their accounting system and disclosed practices the indirect structure could be tailored to the offerors company and how it operates. The Offeror will have the ability to adjust the indirect cost structure and calculation in the spreadsheet tabs "CLIN 2 (SOW 4.0) FFP" and "Indirect Rates Summary Table" for their company proposal. Nonetheless, the prime contractor and each known Major subcontractor shall provide the basis of estimate for the indirect rates in the offerors price narrative submittal.

Reference RFP, B.4 - CLIN 2 PRODUCTION, ASSEMBLY, INTEGRATION AND TEST (CORE)

6.CLIN 2A OPTION FFP
This spreadsheet tab is a summary and used to develop the total FFP CLIN 2A OPTION - Critical Spares (Separately Priced Line Item) with applied SOW 2.0 - Overall General Requirements cost that is included within the USDV Single-Award, core contract (GFY 2024 - 2031). This summary tab should be auto filled (using excel formulas) pulling information from each of the supporting cost element tabs which calculates each element of cost to be included in the total evaluated price. However, within this spreadsheet tab "CLIN 2A OPTION FFP" the offeror would need to input indirect cost (e.g. Fringe, OH, G&A etc.) formulas (cells =F28:P30) to reflect the offeror accounting and disclosed practices for the spreadsheet to calculate the offerors applicable indirect cost for CLIN 2A FFP contract price. This tab contains references (columns S and T), that are linked to each of the elements of cost supporting detailed data for the convenience of each offeror completing the USDV Fixed Price Template.

The following is an outline of supporting spreadsheet tabs of the Firm Fixed Price core contract CLIN 2A OPTION FFP with applied SOW 2.0 - Overall General Requirements:

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

(2) Subcontractor Cost supporting spreadsheet tabs: "Summary SubK Cost (CLIN 2A)", "SubK Cost Details (CLIN 2A)"

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

(4) Indirect Cost (e.g. Fringe, OH, G&A etc.) spreadsheet tabs: "Indirect Rates Summary Table".

If applicable: The offeror has the ability to add "Additional Indirect Rates (1-4)" in the green highlighted areas (cells =F31:P34) 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 cost narrative.

In general, indirect cost accounts for this CLIN 2 FFP contract fall into the broad categories: Fringe, Overhead, and G&A listed in "Indirect Rates Summary Table" tab (column B). However, if needed to be consistent with their accounting system and disclosed practices the indirect structure could be tailored to the offerors company and how it operates. The Offeror will have the ability to adjust the indirect cost structure and calculation in the spreadsheet tabs "CLIN 2 (SOW 4.0) FFP" and "Indirect Rates Summary Table" for their company proposal. Nonetheless, the prime contractor and each known Major subcontractor shall provide the basis of estimate for the indirect rates in the offerors price narrative submittal.

Reference RFP I.8: 52.217-7 OPTION FOR INCREASED QUANTITY - SEPARATELY PRICED LINE ITEM.(CLIN 2A Critical spares). (MAR 1989)

7.CLIN 3 (SOW 5.0) IDIQ
This spreadsheet tab is used to develop the total FFP IDIQ - CLIN 3 (SOW 5.0) Dwell price that is include with the USDV Single-Award, FFP contract . The spreadsheet tab contains a table that the offeror is to summarize the CLIN 3 (SOW 5.0) Dwell for each GFY to create the CLIN 3 (SOW 5.0) Dwell proposed IDIQ firm fixed price. The offerors shall fill in all applicable green highlighted cells (=C9:K12) for each of the fully burdened Dwelling Price Per GFY Quarter (Qtr.) year and add the profit rate for the formulas in spreadsheet tab to calculates the CLIN 3 (SOW 5.0) price to be included in the total evaluated price in "Total Cost & Price Summary" tab. If needed, the Offeror is able to add rows and adjust the excel formulas.

Within this tab, the proposed "Dwelling Price Per Qtr." GFY (Fully Burdened thru Profit) price will be multiplied by the 4 quarters of a year to create the CLIN 3 (SOW 5.0) dollars by GFY. Then the Government provided the calculation (cell=L15) to calculate a 2- year average based on the Government’s provided formula which Averages GFYs 2028 through 2034, and then multiplies that average by 2 years that will be included in the total evaluated price.

The total IDIQ price is for evaluation purposes only and does 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.

Reference RFP, B.5 - CLIN 3 DWELL (IDIQ). The CLIN 3 proposed Dwelling Price Per Qtr. and proposed price will become part of the model contract.

8.CLIN 4 (SOW 6.0) IDIQ
This spreadsheet tab is used to develop the total FFP IDIQ - CLIN 4 (SOW 6.0) Launch Vehicle (LV) Integration and Sustaining price that is within the USDV Single-Award, FFP Contract (and option periods). The spreadsheet tab contains a table that the offeror is to summarize the CLIN 4 (SOW 6.0) for each Government Fiscal Year to create the CLIN 4 (SOW 6.0) proposed IDIQ firm fixed price. The offerors shall fill in all applicable green highlighted cells (=C9:O19) for each of the standard labor classifications fully burdened labor rates (FBLR) through profit and the Non-Labor Resources maximum percentage of indirects and profit applied to non-labor cost for the formulas in spreadsheet tab to calculates the CLIN 4 (SOW 6.0) price to be included in the total evaluated price in "Total Cost & Price Summary" tab. If needed, the offeror is able to add rows and adjust the excel formulas.

Within this tab, the proposed IDIQ Fully Burdened Labor Rate (FBLR) thru profit listed standard labor classification will be multiplied by the Government-provided best-estimated quantities (BEQs) that represents hours to create the CLIN 4 Labor dollars to the Government.

Within this tab, the proposed IDIQ Non-Labor Resources applied indirects and profit percentage will be required for the excel formula to be multiplied by the Government Resource Estimate (GRE) to create the Non-Labor Indirect dollars to the Government.

Within this tab, the proposed IDIQ Profit percentage is for informational purposes only to visually illustrate the profit rate and will not be separately utilized to calculate profit dollars in this tab.

Offerors shall not change the BEQ or GRE values in the CLIN 4 (SOW 6.0) IDIQ tab. BEQs and 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 BEQs or GREs.

Reference RFP, B.6 - CLIN 4 LAUNCH VEHICLE (LV) INTEGRATION AND SUSTAINING (IDIQ). The CLIN 4 proposed rates will become part of the model contract.

9.CLIN 4 PrePriced TO (1)
This spreadsheet tab is used to develop the total FFP Pre-Priced Task Order based on the CLIN 4 IDIQ pricing elements. The spreadsheet tab contains two tables. The first table is linked to "CLIN 4 (SOW 6.0) IDIQ" tab for convenience in calculating Pre-Priced Task Order based on the CLIN 4 IDIQ pricing elements. The second table is for the offeror to summarize the Pre-Priced Task Order based on SOW 2.0, 6.0 and the 2nd Level SOWs (6.1, 6.2, 6.3) for each GFY. The offerors shall fill in all applicable green highlighted cells (=F25:M45) for each of the pricing elements (Direct Labor Hours, Labor Dollars, Non-Labor Resources, Indirect Cost, & Profit) for the formulas in spreadsheet tab to calculates the FFP Pre-Priced Task Order (CLIN 4) price to be included in the total evaluated price in "Total Cost & Price Summary" tab. If needed, the offeror is able to add rows to adjust the excel formulas.

The total pre-priced task order price is for evaluation purposes only and does 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 pre-priced task order.

Reference: RFP, ATTACHMENT L-04A CLIN 4 – LAUNCH VEHICLE INTEGRATION AND SUSTAINING REPRESENTIVE TASK ORDER (RTO)

10.CLIN 4 PrePriced DO (2)
This spreadsheet tab is used to develop the total FFP Long Lead Parts - Pre-Priced Representative Delivery Order based on the CLIN 4 IDIQ pricing elements. The spreadsheet tab contains two tables. The first table is linked to "CLIN 4 (SOW 6.0) IDIQ" tab for convenience in calculating Pre-Priced Task Order based on the CLIN 4 IDIQ pricing elements. The second table is for the offeror to summarize the Pre-Priced Delivery Order based on SOW 2.0, 6.0 and the 2nd Level SOWs (6.4) for each GFY as specifically stated in RFP Attachment L-04B. The offerors shall fill in all applicable green highlighted cells (=F25:M35) for each of the pricing elements (Direct Labor Hours, Labor Dollars, Non-Labor Resources, Indirect Cost, & Profit) for the formulas in spreadsheet tab to calculates the FFP Pre-Priced Task Order (CLIN 4) price. If needed, the offeror is able to add rows to adjust the excel formulas.

The total pre-priced delivery order price does 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 pre-priced delivery order.

Reference: RFP, ATTACHMENT L-04B CLIN 4 – LAUNCH VEHICLE INTEGRATION AND SUSTAINING – LONG LEAD PARTS REPRESENTIVE DELIVERY ORDER (RDO). Note: This CLIN4 Delivery Order is for the USDV contractor to perform all required tasks to procure and accept the necessary long lead parts for CLIN2 Milestone C2-1 Long Lead Parts that gives the NASA the ability to delay the authorization to proceed (ATP) of CLIN 2 by 365 calendar days without impacting the USDV delivery schedule.

11.CLIN 5A (SOW 7.1) IDIQ
This spreadsheet tab is used to develop the total FFP IDIQ - CLIN 5A (SOW 7.1) Special Tasks and Studies "Sub-CLIN 5A Special Studies" price that is within the USDV Single-Award, FFP Contract. The spreadsheet tab contains a table that the offeror is to summarize the CLIN 5A (SOW 7.1) for each Government Fiscal Year to create the CLIN 5A (SOW 7.1) proposed IDIQ firm fixed price. The offeror shall price all years of the IDIQ contract from 2024 to 2035 and be based on the dates within each GFY the services are to be delivered when the sub-CLIN is ordered. The offerors shall fill in all applicable green highlighted cells (=C10:O19) for each of the proposed Composite Labor Rates (% technical/% administrative) fully burdened labor rates (FBLR) thru Profit and the Non-Labor Resources maximum percentage of indirects and profit applied to non-labor cost for the spreadsheet tab to calculates the CLIN 5A (SOW 7.1) price (by BEQ or GRE) to be included in the total evaluated price in "Total Cost & Price Summary" tab. The proposed Composite Labor Rates (FBLR)thru profit and Non-Labor Resources % of indirects and profit applied to non-labor cost will be utilized in future procurement FFP task orders for this contract. If needed, the offeror is able to add rows and adjust the excel formula.

Within this tab, the offerors proposed IDIQ Fully Burdened Labor Rate (FBLR) thru profit listed Composite Labor Rates (and all option periods) will be multiplied by the Government-provided best-estimated quantities (BEQs) hours to create the CLIN 5A (SOW 7.1) Price (based on BEQs) to the Government. The four categories of composite hourly priced rates shall be filled in to reflect the composite labor mix for the Special Task Assignments as defined in CLIN 5A (SOW 7.1), Special Tasks and Studies, "Sub-CLIN 5A Special Studies". The four categories allow for a different mix of technical and administrative support to complete tasks under this sub-CLIN. Categories include a mix of (a) 90% technical / 10% administrative; (b) 50% technical / 50% administrative; and (c) 10% technical / 90% administrative; and (d) 25% technical /75% administrative.

Within this tab, the offerors proposed IDIQ Non-Labor Resources applied indirects and profit percentage (and all option periods) will be required for the excel formula to be multiplied by the Government Resource Estimate (GRE) to create the Non-Labor Price (based on GRE) to the Government.

Within this tab, the proposed IDIQ Profit percentage is for informational purposes only to visually illustrate the profit rate and will not be separately utilized to calculate profit dollars in this tab.

Offerors shall not change the BEQ or GRE values in the CLIN 5A (SOW 7.1) IDIQ tab. BEQs and 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 BEQs or GREs.

Reference RFP, B.7 - CLIN 5 SPECIAL TASKS AND STUDIES (IDIQ). The CLIN 5 proposed rates will become part of the model contract.

12.CLIN 5B (SOW 7.2) IDIQ
This spreadsheet tab is used to develop the total FFP IDIQ - CLIN 5B (SOW 7.2) Pre-Priced Evaluation of NASA Requirements based on the Level 1 (90/10) COMPOSITE LABOR RATES pricing elements in "Sub-CLIN 5A" tab. The spreadsheet tab contains two tables. The first table is linked to "CLIN 5A (SOW 5.2) IDIQ" tab for convenience in calculating Pre-Priced Evaluation of NASA Mission Requirements pricing. The second table is for the offeror to propose the CLIN 5B (SOW 7.2) Tier (I, II, III, IV, V) Unit Pricing Elements based on buckets of hours for each Government Fiscal Year to create the CLIN 5B (SOW 7.2) proposed IDIQ firm fixed price. The offeror shall price all years of the IDIQ contract from 2024 to 2035 by fill in all applicable green highlighted cells (=C21:O25) for each of the proposed Tier (I, II, III, IV, V) Unit Pricing Elements to calculates the CLIN 5B (SOW 7.2) price (by bucket of hours) to be included in the total evaluated price in "Total Cost & Price Summary" tab.

Within this tab, Sub- CLIN 5A Special Tasks and Studies ($/HR) Level 1 (90/10) COMPOSITE LABOR RATES (% TECHNICAL/ % ADMINISTRATIVE) fully burdened labor rates (FBLR) through profit are to be used for each of the calculated Tier (I, II, III, IV, V) Unit Pricing Elements by GFY amounts in the table.

Potential future FFP task order will be executed for either 125 hours (Tier I), 250 hours, (Tier II), 500 hours (Tier III), 750 hours (Tier IV), or 1000 hours (Tier V). Sub- CLIN 0005A Special Tasks and Studies ($/HR) Level 1 (90/10) COMPOSITE LABOR RATES (% TECHNICAL/ % ADMINISTRATIVE) rates were used for each of the calculated amounts in the tables above. Nevertheless, the total IDIQ price is for evaluation purposes only and does 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.

13.Government Task Agreement
This spreadsheet tab is used to develop the total Government Task Agreement (GTA) by GFY price that is included in the USDV Single-Award, FFP contract. The spreadsheet tab contains a table that the offeror is to summarize the GTA by Government Fiscal Year to create the GTA proposed firm fixed price to the government. The offerors shall fill in all applicable green highlighted cells (=D7:I7) for pricing to be included in the total evaluated price in "Total Cost & Price Summary" tab. Reference RFP, Attachment L-08, GOVERNMENT TASK AGREEMENT INSTRUCTIONS
14.Government Provided
This spreadsheet tab is used to develop the total Government Provided (Government-Furnished Property, Facilities and Data/Information) by GFY price that is included in the USDV Single-Award, FFP core contract. The spreadsheet tab contains a table that the offeror is to summarize the Government Furnished Property, Government Provided Facilities, and Government Provided Data/Information by Government Fiscal Year to create the Government Provided proposed firm fixed price. The offerors shall fill in all applicable green highlighted cells (=C7:J9) for pricing to be included in the total evaluated price in "Total Cost & Price Summary" tab. Reference: RFP, L.15 NFS 1852.245-81 LIST OF AVAILABLE GOVERNMENT PROPERTY (JAN 2011) and RFP, G.5 NFS 1852.245-76 LIST OF GOVERNMENT PROPERTY FURNISHED PURSUANT TO FAR 52.245-1. (JAN 2011) and RFP, L.16 LIST OF AVAILABLE GOVERNMENT FACILITIES
15.Prime Labor Rates (CLIN 1)
This spreadsheet tab is required from the Prime offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:BR43) and calculations for each of the standard labor classifications unburdened direct labor rates through fully burdened labor rates (thru Profit) development that are escalated each contract year. Inputs are specific to the Prime offeror (and Major subcontractors if applicable) only and its unburdened direct labor rates through the fully burdened labor rates (thru Profit). This tab is intended to identify the offerors proposed unburdened base labor rate and all the applied indirect rates (e.g. Fringe, OH, G&A etc.) that will be calculated to create the escalated FBLR with Profit for each standard labor classification that is proposed for each year of the USDV Single-Award, FFP core contract (CLIN 1) (GFY 2024-2031). The unburdened direct labor rate and FBLR plus Profit that are populated in this tab will support the labor cost calculation in the spreadsheet tab "CLIN 1 Labor Cost Detail". The offeror shall provide the narrative details of the prime labor rates in the offerors Cost Narrative submittal to allow the Government to perform an adequate evaluation.

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

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

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:BR43) and calculations for each GFY.

- 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

- G&A Added to Labor Rate

- Additional Indirect Rate (if applicable)

- Profit Added to Labor Rate

- ST Fully Burdened Labor Rate thru Profit

- Overtime FBLR thru Profit

- Double Time FBLR thru Profit

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

16.Prime Labor Rates (CLIN 2)
This spreadsheet tab is required from the Prime offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:BR43) and calculations for each of the standard labor classifications unburdened direct labor rates through fully burdened labor rates (thru Profit) development that are escalated each contract year. Inputs are specific to the Prime offeror (and Major subcontractors if applicable) only and its unburdened direct labor rates through the fully burdened labor rates (thru Profit). This tab is intended to identify the offerors proposed unburdened base labor rate and all the applied indirect rates (e.g. Fringe, OH, G&A etc.) that will be calculated to create the escalated FBLR with Profit for each standard labor classification that is proposed for each year of the USDV Single-Award, FFP core contract (CLIN 2) (GFY 2024-2031). The unburdened direct labor rate and FBLR plus Profit that are populated in this tab will support the labor cost calculation in the spreadsheet tab "CLIN 2 Labor Cost Detail". The offeror shall provide the narrative details of the prime labor rates in the offerors Cost Narrative submittal to allow the Government to perform an adequate evaluation.

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

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

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:BR43) and calculations for each GFY.

- 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

- G&A Added to Labor Rate

- Additional Indirect Rate (if applicable)

- Profit Added to Labor Rate

- ST Fully Burdened Labor Rate thru Profit

- Overtime FBLR thru Profit

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

17.Prime Labor Rates (CLIN 2A)
This spreadsheet tab is required from the Prime offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:BR43) and calculations for each of the standard labor classifications unburdened direct labor rates through fully burdened labor rates (thru Profit) development that are escalated each contract year. Inputs are specific to the Prime offeror (and Major subcontractors if applicable) only and its unburdened direct labor rates through the fully burdened labor rates (thru Profit). This tab is intended to identify the offerors proposed unburdened base labor rate and all the applied indirect rates (e.g. Fringe, OH, G&A etc.) that will be calculated to create the escalated FBLR with Profit for each standard labor classification that is proposed for each year of the USDV Single-Award, FFP core contract (CLIN 2A) (GFY 2024-2031). The unburdened direct labor rate and FBLR plus Profit that are populated in this tab will support the labor cost calculation in the spreadsheet tab "CLIN 2A Labor Cost Detail". The offeror shall provide the narrative details of the prime labor rates in the offerors Cost Narrative submittal to allow the Government to perform an adequate evaluation.

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

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

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:BR43) and calculations for each GFY.

- 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

- G&A Added to Labor Rate

- Additional Indirect Rate (if applicable)

- Profit Added to Labor Rate

- ST Fully Burdened Labor Rate thru Profit

- Overtime FBLR thru Profit

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

18.Summary Labor Cost (CLIN 1)
This spreadsheet tab should be auto filled (using excel formulas) pulling information from the supporting detailed labor cost data from tab "CLIN 1 Labor Cost Details". This tab summarizes the proposed direct labor cost for CLIN 1 (SOWs 3.0, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9 & 3.10) FFP core contract by GFY. Then All CLIN 1 detailed cost will be summarized in "CLIN 1 (SOW 3.0) FFP" tab. The applicable prime offeror indirects and Profit will be added in the unburdened labor cost in the summarized "CLIN 1 (SOW 3.0) FFP" tab.
19.Summary Labor Cost (CLIN 2)
This spreadsheet tab should be auto filled (using excel formulas) pulling information from the supporting detailed labor cost data from tab "CLIN 2 Labor Cost Details". This tab summarizes the proposed direct labor cost for CLIN 2 (SOWs 4.1, 4.2, 4.3, 4.4, & 4.5) FFP core contract by GFY. Then All CLIN 2 detailed cost will be summarized in "CLIN 2 (SOW 4.0) FFP" tab. The applicable prime offeror indirects and Profit will be added in the unburdened labor cost in the summarized "CLIN 2 (SOW 4.0) FFP" tab.
20.Summary Labor Cost (CLIN 2A)
This spreadsheet tab should be auto filled (using excel formulas) pulling information from the supporting detailed labor cost data from tab "CLIN 2 Labor Cost Details". This tab summarizes the proposed direct labor cost for CLIN 2A (SOWs 4.1, 4.2, 4.3, 4.4, & 4.5) FFP core contract by GFY. Then All CLIN 2 detailed cost will be summarized in "CLIN 2 (SOW 4.0) FFP" tab. The applicable prime offeror indirects and Profit will be added in the unburdened labor cost in the summarized "CLIN 2 (SOW 4.0) FFP" tab.
21.CLIN 1 Labor Cost Details
This spreadsheet tab is required from the Prime Offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:DE859) in the table for the excel formulas to calculate the total proposed direct labor cost. This tab calculates the labor cost by pulling the labor rates from the "Prime Labor Rate (CLIN 1)" and multiplying them by the proposed hours (green highlighted) for each GFY by the 2nd level SOW (SOWs 3.0, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.10) and all the applicable requirements for SOW 2.0.

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 2nd level SOW number for the information to pull in to the tabs: "Summary Labor Cost (CLIN 1)" and "Summary SOW 2.0 Labor Cost". Note: SLC's are required to be populated for excel "IF" formulas to summarize data.

Within this tab the "Requirements Sections" column header list the SOW sections for CLINs 1 (3.0, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.10) and all the applicable requirements for SOW 2.0. This will allow the offerors to select the applicable SOW sections that applies to offerors Prime contractor labor. Note: SOW requirement sections are required to be populated for excel "IF" formulas to summarize data.

Within this tab, offeror will need to populate the proposed productive labor hour Factor (PLHF) in the green highlighted cells (=W5:AB5) 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 labor cost requested information (labor type in column F, and labor worksite location in column G).

Within this tab, the Prime Offeror and Major subcontractors (If applicable) will need to populate the proposed hours (green highlighted) for each GFY (e.g. GFY 24, Columns V, W, and X).

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.

22.CLIN 2 Labor Cost Details
This spreadsheet tab is required from the Prime Offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:DE859) in the table for the excel formulas to calculate the total proposed direct labor cost. This tab calculates the labor cost by pulling the labor rates from the "Prime Labor Rate (CLIN 2)" and multiplying them by the proposed hours (green highlighted) for each GFY by the 2nd level SOW (SOW 4.1, 4.2, 4.3, 4.4, & 4.5) and all the applicable requirements for SOW 2.0.

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 2nd level SOW number for the information to pull in to the tabs: "Summary Labor Cost (CLIN 2)". Note: SLC's are required to be populated for excel "IF" formulas to summarize data.

Within this tab the "Requirements Sections" column header list the SOW sections for CLINs 2 (SOW 4.1, 4.2, 4.3, 4.4, & 4.5) and all the applicable requirements for SOW 2.0. This will allow the offerors to select the applicable SOW sections that applies to offerors Prime contractor labor. Note: SOW requirement sections are required to be populated for excel "IF" formulas to summarize data.

Within this tab, offeror will need to populate the proposed productive labor hour Factor (PLHF) in the green highlighted cells (=W5:AB5) 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 labor cost requested information (labor type in column F, and labor worksite location in column G).

Within this tab, the Prime Offeror and Major subcontractors (If applicable) will need to populate the proposed hours (green highlighted) for each GFY (e.g. GFY 24, Columns V, W, and X).

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.

23.CLIN 2A Labor Cost Details
This spreadsheet tab is required from the Prime Offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells (=D10:DE859) in the table for the excel formulas to calculate the total proposed direct labor cost. This tab calculates the labor cost by pulling the labor rates from the "Prime Labor Rate (CLIN 2)" and multiplying them by the proposed hours (green highlighted) for each GFY by the 2nd level SOW (SOW 4.1, 4.2, 4.3, 4.4, & 4.5) and all the applicable requirements for SOW 2.0.

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 2nd level SOW number for the information to pull in to the tabs: "Summary Labor Cost (CLIN 2)". Note: SLC's are required to be populated for excel "IF" formulas to summarize data.

Within this tab the "Requirements Sections" column header list the SOW sections for CLINs 2 (SOW 4.1, 4.2, 4.3, 4.4, & 4.5) and all the applicable requirements for SOW 2.0. This will allow the offerors to select the applicable SOW sections that applies to offerors Prime contractor labor. Note: SOW requirement sections are required to be populated for excel "IF" formulas to summarize data.

Within this tab, offeror will need to populate the proposed productive labor hour Factor (PLHF) in the green highlighted cells (=W5:AB5) 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 labor cost requested information (labor type in column F, and labor worksite location in column G).

Within this tab, the Prime Offeror and Major subcontractors (If applicable) will need to populate the proposed hours (green highlighted) for each GFY (e.g. GFY 24, Columns V, W, and X).

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.

24.Summary SubK Cost (CLIN 1)

This is the start of the file's text. The full file is on GovTribe.

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