Attachment L-01A USDV Hybrid Cost and Price Template.xlsx

XLSX spreadsheet 3 MB Posted

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

About this file

This document template is for a United States Deorbit Vehicle (USDV) Hybrid Cost Plus Incentive Fee and Firm Fixed Price contract opportunity with the National Aeronautics and Space Administration Johnson Space Center. The contract includes a Cost Plus Incentive Fee line item for design, development, test and evaluation through critical design review. Firm Fixed Price line items cover production, assembly, integration and testing. Additional Firm Fixed Price line items consist of indefinite delivery/indefinite quantity contracts for dwell, launch vehicle integration and sustaining, and special tasks and studies. The template provides instructions and pricing tables to develop total evaluated cost by government fiscal year for the hybrid contract and its line items running from 2024 to 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-01B USDV Fixed Price Template Amendment 5.xlsx XLSX spreadsheet
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
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 Cost Plus Incentive Fee (CPIF) And Firm Fixed Price Contract

# 80JSC023R0003

Attachment L-01A USDV Basic Cost Price Template

Instructions and ToC

Offeror Name:

General InstructionsUSDV Hybrid CPIF/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, Hybrid Cost Plus Incentive Fee (CPIF)/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) CPIF, CLIN 2 - Production, Assembly, Integration, and Test (PAI&T) FFP, CLIN 2A - Critical Spares (Separately Priced Line Item) FFP. The USDV Single-Award, Hybrid 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 4 PrePriced DO (2) 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.

4/18/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, Hybrid (CPIF/FFP) contract period of performance: 04/18/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-8 TIME OF DELIVERY (JUN 1997), and F.7 OPTION TO EXTEND.51212121212126612121212
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-01A USDV Hybrid Cost Price TemplateF.3 FAR 52.211-8 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-01A “SubK Cost Details (CLIN 1) ” tab. 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 or Attachment L-01B USDV Hybrid Fixed Price Template. 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-01A USDV Hybrid Cost Price Template
7.It is offeror's responsibility to ensure all formulas in this USDV Hybrid Cost 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 Hybrid Cost 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-01A USDV Hybrid Cost Price Template shall represent a fully integrated cost and price strategy to include all subcontractors. The Major Subcontractor completes and submits their own Attachment L-01A USDV Hybrid Cost Price Template. 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. For its proposal preparation for CLIN 1, 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) Subcontractors 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.

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 Hybrid Cost 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) .Requirements Structure2.Requirements Structure
Total Cost & Price Summary3.Total Cost & Price Summary
CLIN 1 (SOW 3.0) CPIF4.CLIN 1 (SOW 3.0) CPIF
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 Hybrid CPIF/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 CLIN 1 (SOW section 3.0) and CLIN 2 (SOW section 4.0) are summarizing the USDV hybrid core contract requirements that are a roll up of the applicable SOW requirements sections. For example: SOW sections 3.1, 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 Cost 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 "CLIN 1 Labor Cost Details", "SubK Cost Details (CLIN 1)", and "Non-Labor Resources (CLIN 1)" that will have a list of SOW sections for CLINs 1 (3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.10). 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 (2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 2.12, 2.13, 2.14, & 2.15) are also listed for pricing purposes in the detailed tabs "CLIN 1 Labor Cost Details", "SubK Cost Details (CLIN 1)", and "Non-Labor Resources (CLIN 1)".

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)
Summary Labor Cost (CLIN 1)16.Summary Labor Cost (CLIN 1)
Summary SOW 2.0 Labor Cost17.Summary SOW 2.0 Labor Cost
CLIN 1 Labor Cost Details18.CLIN 1 Labor Cost Details
Summary SubK Cost (CLIN 1)19.Summary SubK Cost (CLIN 1)
Summary SOW 2.0 SubK Cost20.Summary SOW 2.0 SubK Cost
3.Total Cost & Price SummarySubK Cost Details (CLIN 1)21.SubK Cost Details (CLIN 1)
This spreadsheet tab summarizes the total evaluated cost and price data into two tables "CLIN Summary" and "Total Evaluated Cost and Price (Segregation by CLIN 1 CPIF and FFP)" for the performance period by Government Fiscal Year (GFY) for the USDV Single-Award, Hybrid (CPIF/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 CPIF and FFP)" 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 (CPIF Core)", "CLIN 2 (FFP Core)", "CLIN 2 OPTION", "CLIN 3 (IDIQ)", "CLIN 4 (IDIQ)", "CLIN 5 (IDIQ)", "Government Task Agreements", and "Government Provided". Then, the Cost Element Summary table breaks down the USDV Hybrid core contract and IDIQs total evaluated price by each Element of Cost to include Direct Labor Hours, Labor Dollars, Non-Labor Resources, Indirect Cost, Incentive Fee, 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 Hybrid contract Summary tabs for the convenience of each offeror completing the USDV Hybrid Cost Price Template. Gray shaded cells in this tab should reference back to RFP, F.2 COMPLETION OF WORK and F.3 FAR 52.211-8 TIME OF DELIVERY (JUN 1997).Non-Labor Resources (CLIN 1)22.Non-Labor Resources (CLIN 1)
Indirect Rates Summary Table23.Indirect Rates Summary Table
CPIF Grapher (CLIN 1)24.CPIF Grapher (CLIN 1)
Fringe Rate Build-up (CLIN 1)25.Fringe Rate Build-up (CLIN 1)
Overhead Rate Build-up (CLIN 1)26.Overhead Rate Build-up (CLIN 1)
G&A Build-up (CLIN 1)27.G&A Build-up (CLIN 1)
Additional Rate Build-up(CLIN1)28.Additional Rate Build-up(CLIN1)
Business Information & POCs29.Business Information & POCs
* 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) CPIF
This spreadsheet tab is a summary and used to develop the total CPIF 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, Hybrid 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) CPIF" 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 CPIF 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 Hybrid Cost Price Template.

The following is an outline of supporting spreadsheet tabs of the Cost Plus Incentive Fee 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", "Summary SOW 2.0 Labor Cost", "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.) supporting spreadsheet tabs: "Indirect Rates Summary Table", "CPIF Grapher (CLIN 1)", "Fringe Rate Build-up (CLIN 1)", "Overhead Rate Build-up (CLIN 1)", "G&A Build-up (CLIN 1)", Additional Rate Build-up (CLIN 1), and "Business Information & POCs"

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 CPIF 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) CPIF" and "Indirect Rates Summary Table" for their company 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 (CLIN 1)" for each new indirect rates added to the CLIN 1 CPIF contract and then provide the details and basis of estimate for the new indirect rate in the offerors cost narrative submittal.

5.CLIN 2 (SOW 4.0) FFP
This spreadsheet tab is used to develop the total FFP CLIN 2 (SOW 4.0) PAI&T price that is included with the USDV Single-Award, Hybrid core contract. The spreadsheet tab contains a table that the offeror is to summarize the CLIN 2 (SOW 4.0) and all 2nd Level SOWs (4.1, 4.2, 4.3, 4.4, & 4.5) for each GFY to create the CLIN 2 (SOW 4.0) proposed firm fixed price. The offerors shall fill in all applicable green highlighted cells (=F7:K44) 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 CLIN 2 (SOW 4.0) price to be included in the total evaluated price in "Total Cost & Price Summary" tab.

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

6.CLIN 2A OPTION FFP
This spreadsheet tab is used to develop the total FFP CLIN 2A Pre-Priced OPTION - Critical Spares (Separately Priced Line Item) Procurement price that is included with the USDV Single-Award, Hybrid core contract. The spreadsheet tab contains a table that the offeror is to summarize the CLIN 2A for each GFY to create the CLIN 2A proposed firm fixed price. The offerors shall fill in all applicable green highlighted cells (=D7:I11) 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 CLIN 2A 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. 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, Hybrid 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, Hybrid ( 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. 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 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 delivery 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 delivery order.

Reference: RFP, ATTACHMENT L-04B CLIN 4 – LAUNCH VEHICLE INTEGRATION AND SUSTAINING – LONG LEAD PARTS FLEXIBILITY REPRESENTIVE DELIVERY ORDER (RDO)

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, Hybrid. 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, Hybrid 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, Hybrid 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 fee) 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 fee). 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 fee for each standard labor classification that is proposed for each year of the USDV Single-Award, Hybrid core contract (CLIN 1) (GFY 2024-2031). The unburdened direct labor rate and FBLR plus fee 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)

- 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 add excel formulas to be consistent with their accounting and disclosure practices.

16.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 (SOW 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9 & 3.10) CPIF core contract by GFY. Then All CLIN 1 detailed cost will be summarized in "CLIN 1 (SOW 3.0) CPIF" tab. The applicable prime offeror indirects and fee will be added in the unburdened labor cost in the summarized "CLIN 1 (SOW 3.0) CPIF" tab.
17.Summary SOW 2.0 Labor Cost
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 (SOW 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 2.12, 2.13, 2.14, & 2.15) CPIF core contract by GFY. Then All CLIN 1 detailed cost will be summarized in "CLIN 1 (SOW 3.0) CPIF" tab. The applicable prime offeror indirects and fee will be added in the unburdened labor cost in the summarized "CLIN 1 (SOW 3.0) CPIF" tab.
18.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 (SOW 3.0, 3.1, 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.1, 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.

19.Summary SubK Cost (CLIN 1)
This spreadsheet tab should be auto filled (using formulas) pulling information from the supporting detailed Subcontractor cost data from tab "CLIN 1 SubK Cost Details". This tab summarizes the Subcontractors cost for CLIN 1 (SOW 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.10) CPIF core contract by GFY. However, if needed the offeror has the ability to add additional proposed cost "Any Proposed SubK Cost Not Covered" in the green highlighted cells (=F19:K19), which will be in addition to the subcontractors cost in tab "SubK Cost Details (CLIN 1)". Then All CLIN 1 detailed cost will be summarized in "CLIN 1 (SOW 3.0) CPIF" tab. The applicable prime offeror fee will be added to the SubK cost in the summary tab "CLIN 1 (SOW 3.0) CPIF".
20.Summary SOW 2.0 SubK Cost
This spreadsheet tab should be auto filled (using formulas) pulling information from the supporting detailed Subcontractor cost data from tab "CLIN 1 SubK Cost Details". This tab summarizes the Subcontractors cost for CLIN 1 (SOW 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 2.12, 2.13, 2.14, & 2.15) CPIF core contract by GFY. However, if needed the offeror has the ability to add additional proposed cost "Any Proposed SubK Cost Not Covered" in the green highlighted cells (=F19:K19), which will be in addition to the subcontractors cost in tab "SubK Cost Details (CLIN 1)". Then All CLIN 1 detailed cost will be summarized in "CLIN 1 (SOW 3.0) CPIF" tab. The applicable prime offeror fee will be added to the Subcontractor cost in the summary tab "CLIN 1 (SOW 3.0) CPIF".
21.SubK Cost Details (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 (=C22:ER846) in the table for the excel formulas to calculate the total proposed subcontractors cost. This tab calculates the Subcontractors Fully Burdened Cost (with Non-labor & Prime applied cost) by multiplying the proposed Subcontractor fully burdened labor rates by the SubK Labor hours for each GFY and 2nd level SOW (SOW 3.0, 3.1, 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, then adds the proposed All Applicable Subcontractors Indirects thru Fee/Profit, Subcontractors Non-labor Resources Cost, and Prime Additional Cost (if applied). The supporting detailed information within this tab will be pulled into "Summary SubK Cost (CLIN 1)" tab.

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 (E8:H17) within this tab to auto populate the drop down list in this Subcontractor tab (column C).

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 SubK Cost (CLIN 1)". Note: SLC's are required to be populated for excel "IF" formulas to summarize data.

Within this tab, the "Requirements Sections" column header has a drop down list of SOW sections for CLINs 1 (3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, & 3.9) and all the applicable requirements for SOW 2.0. This will allow the offerors to select the applicable SOW sections that applies to subcontract labor and non-labor resource. 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 offerors proposed productive labor hour Factor (PLHF) in the green highlighted cells (=M10:R10) 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 (e.g. for GFY 24: labor type (Column F), labor worksite location (Column G), and % of allocated work load (Column J))

Within this tab, All subcontractors (If applicable) will need to populate the proposed hours (green highlighted) for each GFY, (e.g. GFY24 Columns Z, AA, and AB).

Within this tab, offeror will need to populate each Subcontractors Standard Labor Classification (SLC) detail data (see list below) for all applicable green highlighted cells.

*Straight Time Hours, Overtime Hours, Double-time, and Total Hours *Straight Time (ST) Base Labor Rate Unburdened, Overtime Base Labor Rate Unburdened Hourly, & Double Time Base Labor Rate Unburdened Hourly *All Applicable SubK Indirects thru Fee/Profit, ST Fully Burdened Labor Rate, Overtime FBLR, & Double Time FBLR *SubK Nonlabor Resources Cost and Prime Additional Cost (if applied)

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.

22.Non-Labor Resources (CLIN 1)
This spreadsheet tab is required from the Prime offeror and Major subcontractors (If applicable). This tab is used to identify and summarize all proposed unburdened non-labor resources (e.g. Material, Equipment, ODC, and Travel). The offeror would need to input Non-Labor Resources indirect cost (e.g. G&A etc.) and fee formulas in tab "CLIN 1 (SOW 3.0) CPIF" to reflect the offeror accounting and disclosed practices related to the summarized Non-Labor Resources cost. The offerors shall fill in all applicable green highlighted cells (=E28:J327) in the table. The narrative details of the non-labor resources shall be provided in the offerors Cost Narrative submittal. The CLIN 1 CPIF contract material cost in this tab shall be consistent with the provided Bill of Material. If necessary, Offeror may add additional non-labor requirement starting on cell D128

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

Within this tab, the "Requirements Sections" column D list the SOW sections for CLINs 1 (3.1, 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 price the applicable SOW 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.

Reference: RFP, L.26.2(c)(2)(vii), (viii), & (x) in the Cost Volume Instructions for "Consolidated Bill of Material" (CBoM) needed for the USDV Single-Award, Hybrid (CPIF/FFP) contract. The CBoM individual material quantities and price shall be summarized and proposed to each core contract CLINs (CLIN 1, CLIN 2, CLIN 2A OPTION) and IDIQ CLIN’s (CLIN 3, and CLIN 4) and follow the contract requirement SOW sections (Reference USDV Statement of Work). The offerors CBoM that relates to the CPIF CLIN 1, shall be consistent with the summarized Material in spreadsheet tab "Non-Labor Resources (CLIN 1)". The CBOM summarized individual material quantities and price, shall include the full list of all the materials, components, and parts by names with a provided estimation descriptions in the Cost Narrative submittal to allow the Government to perform an adequate evaluation. The CBOM shall be specific, detailed, and complete to clearly and fully demonstrate the offeror’s understanding of the Mission Suitability subfactor requirements.

23.Indirect Rates Summary Table
Indirect Rates Table: Offerors are to fill in all of the green highlighted tabs as needed. The Offeror shall fill in the Rates and Factors Summary table with their respective indirect rates. The Prime Contractor shall identify the Fringe Benefits (Labor Burden) rate; Overhead rate; G&A rate; and Incentive Fee by offeror Fiscal Year and Government Fiscal Year for the complete USDV Hybrid core contract performance period. The Government has provided additional (other rates) inputs for those who require modified rate structure to ensure they are capturing all their proposed cost in a manner consistent with their accounting/disclosed practices. If the offeror does include an additional rate, the offeror shall include the basis for the rate development and sufficient information in the cost narrative submittal to allow the Government to perform an adequate evaluation. Offeror is responsible for the mathematical accuracy and inclusion of Additional Indirect Rate 1-4 (if applicable) in this excel USDV Hybrid Cost Price Template.
24.CPIF Grapher (CLIN 1)
Incentive Fee (CPIF) Calculation and Graph: This tab requires the offeror to inputs its GFY for Maximum (refer to FAR 52.216-10), Target, and Minimum Incentive Fee percentages in "Indirect Rates Summary Table" tab for the CPIF excel formulas to auto populate based on the average incentive fee percentages of GFYs 2024-2029. No offeror input is required for this worksheet tab unless excel formulas are changed to reflect the offerors accounting system and disclosure practices. Additionally, this tab develops a CPIF graphical chart which illustrates the Range of Incentive Effectiveness (RIE) which is numerically provided in Cell C13. Offerors are to observe the instructions provided below the graph to properly set the X & Y Axis values based on offeror proposed costs and fee. Note: The "CPIF Grapher (CLIN 1)" table is used to calculate a positions on one graph. This provides for a quick visual depiction of how the CPIF arrangements looks.

Do not alter the formulas in the gray-shaded cells. Upon entering the required data, the model will use the government provided share ratios to calculate: the min fee, the max fee, the target fee, and a graph of the CPIF position.

25.Fringe Rate Build-up (CLIN 1)
In absence of a Forward Pricing Rate Agreement (FPRA) or Forward Pricing Rate Recommendation (FPRR), the prime contractor and each known Major subcontractor will populate this tab to show the indirect rate build-up for their company, then provide the narrative details of the indirect pool/base in the offerors Cost Narrative submittal. Offeror, add/delete rows as needed; all columns are required, if no FPRA or FPRR is in place. If unaudited Provisional Billing Rates are submitted to support Indirect rates the offeror would still need to complete this spreadsheet tab.
26.Overhead Rate Build-up (CLIN 1)
In absence of a Forward Pricing Rate Agreement (FPRA) or Forward Pricing Rate Recommendation (FPRR), the prime contractor and each known Major subcontractor will populate this tab to show the indirect rate build-up for their company, then provide the narrative details of the indirect pool/base in the offerors Cost Narrative submittal. Offeror, add/delete rows as needed; all columns are required, if no FPRA or FPRR is in place. If unaudited Provisional Billing Rates are submitted to support Indirect rates the offeror would still need to complete this spreadsheet tab.
27.G&A Build-up (CLIN 1)
In absence of a FPRA or FPRR, the prime contractor and each known Major subcontractor will populate this tab to show the indirect rate build-up for their company, then provide the narrative details of the indirect pool/base in the offerors Cost Narrative submittal. Offeror, add/delete rows as needed; all columns are required, if no FPRA or PFRR is in place. If unaudited Provisional Billing Rates are submitted to support Indirect rates the offeror would still need to complete this spreadsheet tab.
28.Additional Rate Build-up(CLIN1)
In absence of a FPRA and FPRR, the prime contractor and each known Major subcontractor will populate this tab to show the indirect rate build-up for their company, then provide the narrative details of the indirect pool/base in the offerors Cost Narrative submittal. Offeror, add/delete rows as needed; all columns are required, if no FPRA or FPRR is in place. If unaudited Provisional Billing Rates are submitted to support Indirect rates the offeror would still need to complete this spreadsheet tab.
29.Business Information & POCs
This spreadsheet tab is required from the Prime Offeror and Major subcontractors (If applicable). The offerors shall fill in all applicable green highlighted cells.

Reference RFP, L.26 and Attachment L-09 - Pre-Award Survey of Prospective Contractor Accounting System Checklist

Requirements Structure

USDV Hybrid CPIF/FFP Contract Line Item Number (CLIN) Structure by Statement of Work (SOW) Requirements.
Instructions and ToC
CLIN and SOW TitlesCLIN
SectionsContract TypeSOW Sections2nd Level (Lvl) SOW SectionsSOW SectionsSOW

Description

IntroductionAll CLINsAll Type1.01.1, 1.2, 1.3, & 1.41.0Introduction
Overall General RequirementsAll CLINsAll Type2.02.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 2.12, 2.13, 2.14, & 2.151.1Overview and Objectives
Design, Development, Test and Evaluation (DDT&E) Through Critical Design Review (CDR)CLIN 1CPIF (Core)3.03.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, & 3.101.2Scope
Production, Assembly, Integration and Test (PAI&T)CLIN 2FFP (Core)4.04.1, 4.2, 4.3, 4.4, & 4.51.3SOW Organization And Structure
Core Contract Pre-Priced Option ACLIN 2 Option AFFP (Core)Reference RFP I.81.4Technical Direction

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 .