Section L_Attach 1_Pricing Workbook_Final RFP 5 Feb 21.xlsx

XLSX spreadsheet 52 KB Posted Feb 5, 2021

Attached to: F-15EX Lots 2+ Propulsion Procurement Federal contract opportunity
Solicitation number: FA8626-21-R-0002
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

Written by GovTribe AI · Dec 27, 2023

This document provides pricing instructions and templates for an Air Force solicitation seeking propulsion systems for the F-15EX aircraft. Offerors must complete pricing workbooks detailing target costs, profit, and ceiling prices for firm-fixed-price and cost-plus-incentive-fee contract line items. Pricing is required for integration support, software, engines, kits, and transportation materials for engine lots two through nine from October 2023 through June 2031, totaling 461 engines. Templates include a technical evaluation plan, input cells for prices and quantities, and a variation in quantity matrix. Proposals are due by April 7, 2021 to the Air Force Materiel Command Lifecycle Management Center for the acquisition of a complete propulsion system integrated into the F-15EX weapon system.

View the file

Other files for this federal contract opportunity

Other files attached to F-15EX Lots 2+ Propulsion Procurement, newest first.
File	Type	Posted
Section L_Attach 1_Pricing Workbook_Final Amend 0001_25Mar21.xlsx	XLSX spreadsheet	Mar 26, 2021
FA8626-21-R-0002-0001_signed.pdf	PDF	Mar 26, 2021
Running Thread of General QandA to Final RFP FA8626-21-R-0002.pdf	PDF	Mar 19, 2021
RFP General Questions and Responses_18Feb21.pdf	PDF	Feb 18, 2021
FA8626-21-R-0002_Model Contract_Sections A-M_5Feb21.pdf	PDF	Feb 18, 2021
Section J_Attach 7_List of Commercial Computer Software_Final RFP 5 Feb 21.xlsx	XLSX spreadsheet	Feb 5, 2021
Section J_Exhibit A_CDRL (Production)_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section L_Attach 2_CEO Certification Letter Template_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 1_SOW_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 2_F-15EX Propulsion System Spec_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 3_DoD Digital Engineering Strategy_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 10_DD Form 1653_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section L_Instructions to Offerors_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 8_List of Digital Engineering Products_Final RFP 5 Feb 21.xlsx	XLSX spreadsheet	Feb 5, 2021
Section J_Attach 9_AFMC Form 158_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 11_Proposed GFP Table List_Final RFP 5 Feb 21.xlsx	XLSX spreadsheet	Feb 5, 2021
Cover Letter for RFP FA8626-21-R-0002_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Exhibit B_CDRL (Integration)_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section M_Evaluation Factors for Award_Final RFP 5 Feb 21.pdf	PDF	Feb 5, 2021
Section J_Attach 14_Draft Cost and Software Data Reporting Plan_Final RFP 5 Feb 21.XLS	XLS spreadsheet	Feb 5, 2021
FA8626-21-R-0002_Model Contract_Sections A-M_5Feb21.pdf	PDF	Feb 5, 2021

Show all 21

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

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

Tab A - Instructions

Pricing Workbook Instructions

1	Follow all instructions within this spreadsheet and Section L
2	All cells are locked except those shaded in Blue
3	Offeror shall not attempt to unlock any locked cells or modify any cells other than those shaded in blue
4	Any errors found in cells or in cell calculation should be immediately notified to Government PCO
5	Offerors are instructed to populate all cells that are shaded in blue consistent with Section L requirements
6	Information provided here shall be consistent with all aspects of the proposed offer and proposed contract documentation
7	Tab C - Input all blue shaded cells, Ceiling Price for FPIF CLINs and Total Price for FFP CLINs; Geometry is at top of page
8	Tab D will be placed on contract at time of award as Section J, Attachment 12
9	Tab D - Most Probable Quantity (MPQ) is as shown for each lot; The price for MPQ is the Green outlined box and is based on that lot's MPQ buy. Prices for SubCLINs 2000AA-2000AM will be calculated from the MPQ unit price for Lot 2
10	Tab D - All blue shaded boxes must be filled out or the spreadsheet will be considered incomplete

11 Tab E - Input blue shaded cells for total price for each CLIN in Column E

12 Tab F - Input blue shaded cells for unit price for each CLIN in Column E

Tab B - TEP Calculation

DO NOT INPUT INTO ANY CELLS IN THIS TAB!!
CLIN	CLIN Description	Contract Type	Included in TEP	Quantity	Unit Price	Total Price
1000	Integration & Certification Support (Option)	FPIF	Yes, Proposed Ceiling Price	1	$0	$0
1001	Noncommercial Computer Software and Tech Data Integration/Certification (Option)	NSP	No	1
1002	Commercial Computer Software Integration & Certification (Option)	FFP	Yes, Proposed FFP	1	$0	$0
1003	Provide/Install Engines for F-15EX Integration Aircraft (Option)	FFP	Yes, Proposed FFP	2	$0	$0
1004	Engine Group A Kits for F-15EX Integration Aircraft (Option)	FFP	Yes, Proposed FFP	2	$0	$0
2000AA	Lot 2 Install Engines 31 Oct 23	FFP	Yes, Proposed FFP	2	$0	$0
2000AB	Lot 2 Install Engines 30 Nov 23	FFP	Yes, Proposed FFP	2	$0	$0
2000AC	Lot 2 Install Engines 31 Dec 23	FFP	Yes, Proposed FFP	2	$0	$0
2000AD	Lot 2 Spare Engine 31 Dec 23	FFP	Yes, Proposed FFP	1	$0	$0
2000AE	Lot 2 Install Engines 31 Jan 24	FFP	Yes, Proposed FFP	2	$0	$0
2000AF	Lot 2 Install Engines 29 Feb 24	FFP	Yes, Proposed FFP	2	$0	$0
2000AG	Lot 2 Spare Engines 29 Feb 24	FFP	Yes, Proposed FFP	2	$0	$0
2000AH	Lot 2 Install Engines 31 Mar 24	FFP	Yes, Proposed FFP	2	$0	$0
2000AJ	Lot 2 Spare Engines 31 Mar 24	FFP	Yes, Proposed FFP	2	$0	$0
2000AK	Lot 2 Install Engines 30 Apr 24	FFP	Yes, Proposed FFP	4	$0	$0
2000AL	Lot 2 Install Engines 31 May 24	FFP	Yes, Proposed FFP	4	$0	$0
2000AM	Lot 2 Install Engines 30 Jun 24	FFP	Yes, Proposed FFP	4	$0	$0
2001	Lot 2 Noncommercial Computer Software and Tech Data	NSP	No	1
2002	Lot 2 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
2003	Digital Engineering Products	FFP	NTE (Unpriced Option)	1		N/A
2004AA	Auxiliary Transportation Materiel for Spare Engines 31 Dec 23	FFP	Yes, Proposed FFP	1	$0	$0
2004AB	Auxiliary Transportation Materiel for Spare Engines 29 Feb 24	FFP	Yes, Proposed FFP	2	$0	$0
2004AC	Auxiliary Transportation Materiel for Spare Engines 31 Mar 24	FFP	Yes, Proposed FFP	2	$0	$0
3000	Lot 3 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	29	$0	$0
3001	Lot 3 Noncommercial Computer Software and Tech Data	NSP	No	1
3002	Lot 3 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
3003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	5	$0	$0
4000	Lot 4 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	34	$0	$0
4001	Lot 4 Noncommercial Computer Software and Tech Data	NSP	No	1
4002	Lot 4 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
4003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	6	$0	$0
5000	Lot 5 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	46	$0	$0
5001	Lot 5 Noncommercial Computer Software and Tech Data	NSP	No	1
5002	Lot 5 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
5003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	8	$0	$0
6000	Lot 6 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	46	$0	$0
6001	Lot 6 Noncommercial Computer Software and Tech Data	NSP	No	1
6002	Lot 6 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
6003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	8	$0	$0
7000	Lot 7 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	58	$0	$0
7001	Lot 7 Noncommercial Computer Software and Tech Data	NSP	No	1
7002	Lot 7 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
7003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	10	$0	$0
8000	Lot 8 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	58	$0	$0
8001	Lot 8 Noncommercial Computer Software and Tech Data	NSP	No	1
8002	Lot 8 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
8003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	10	$0	$0
9000	Lot 9 Engines	FFP	Yes, Proposed FFP for Most Probable Qty	29	$0	$0
9001	Lot 9 Noncommercial Computer Software and Tech Data	NSP	No	1
9002	Lot 9 Commercial Computer Software	FFP	Yes, Proposed FFP	1	$0	$0
9003	Auxiliary Transportation Materiel for Spare Engines	FFP	Yes, Proposed FFP for Most Probable Qty	5	$0	$0

Subtotal $0

TEP $0

Tab C - Integration & Data

Integration & Mil Cert Phase						Profit on FPIF CLINs	10.00%
Offeror's Name:						Ceiling Price	120%	of Target Cost
						Overrun/Underrun Share Ratio	50/50
F-15EX Lots 2+ Propulsion Program (Enter $ rounded to the nearest dollar)
Contract Phase: Optional Integration											FPIF CLINs ONLY
CLIN Title	CLIN #	Contract Type				Target Price (FPIF) or Total Price (FFP) allocation by FY 21- 24				Total Price (Sum of FY21-24 amounts)	Target Cost	Target Profit	Target Price	Ceiling Price/Total Price (FFP CLINs
			Units	Unit Type	Price Input (Ceiling Price for FPIF CLINs or Total Price for FFP CLINs)	FY21	FY22	FY23	FY24					(Ceiling Price for FPIF CLINs is 120% of Target Cost; Ceiling for FFP CLINs is Total Price)
FPIF CLINS
Integration & Mil Certification	1000	FPIF	1	EA	0	0	0	0	0	0	0	0	0	0
Total FPIF (TY$)					0	0	0	0	0	0	0	0	0	0
FFP CLINs
Provide/ Install Engines for Integration AC	1003	FFP	2	EA	0	0	0	0	0	0	N/A	N/A	N/A	0
Commercial Computer Software Integration & Certification (Option)	1002	FFP	1	EA	0	0	0	0	0	0	N/A	N/A	N/A	0
Engine Group A for Integration AC	1004	FFP	2	EA	0	0	0	0	0	0	N/A	N/A	N/A	0
TOTAL FFP (TY$) PRICE					0	0	0	0	0	0	N/A	N/A	N/A	0
Total FPIF and FFP					0	0	0	0	0	0				0

Tab D - VIQ Matrix

VARIATION IN QUANTITY OPTION PRICING MATRIX FOR F-15EX ENGINES
Assume spares are 20% of the Most Probable Quantity (MPQ) of Production Engines (Example: Lot 2 engines are 24 production + 5 spares = 29 engines in MPQ)
Base Year 1
CLIN	TITLE	CONTRACT TYPE

2000 Engines for F-15EX Acrft Production Lot 2 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 58
			Most Probable Quantity:	29
			Most Probable Unit Price	$0
			Total Evaluated Price	$0

Option Year 1
CLIN	TITLE	CONTRACT TYPE

3000 Engines for F-15EX Acrft Production Lot 3 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 87

Most Probable Quantity:	29
Most Probable Unit Price	$0
Total Evaluated Price	$0

Option Year 2
CLIN	TITLE	CONTRACT TYPE

4000 Engines for F-15EX Acrft Production Lot 4 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 87	Most Probable Quantity:	34
			Most Probable Unit Price	$0
			Total Evaluated Price	$0

Option Year 3
CLIN	TITLE	CONTRACT TYPE

5000 Engines for F-15EX Acrft Production Lot 5 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 87

Most Probable Quantity:	46
Most Probable Unit Price	$0
Total Evaluated Price	$0

Option Year 4
CLIN	TITLE	CONTRACT TYPE

6000 Engines for F-15EX Acrft Production Lot 6 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 87

Most Probable Quantity:	46
Most Probable Unit Price	$0
Total Evaluated Price	$0

Option Year 5
CLIN	TITLE	CONTRACT TYPE

7000 Engines for F-15EX Acrft Production Lot 7 FFP

CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
1 to 20	21 to 40	41 to 87

Most Probable Quantity:	58
Most Probable Unit Price	$0
Total Evaluated Price	$0

Option Year 6
CLIN	TITLE	CONTRACT TYPE

8000 Engines for F-15EX Acrft Production Lot 8 FFP

PREVIOUS QUANTITY ORDERED	CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
	1 to 20	21 to 40	41 to 87

Most Probable Quantity:	58
Most Probable Unit Price	$0
Total Evaluated Price	$0

Option Year 7
CLIN	TITLE	CONTRACT TYPE

9000 Engines for F-15EX Acrft Production Lot 9 FFP

PREVIOUS QUANTITY ORDERED	CURRENT ORDER QUANTITY/ F-15EX Engines UNIT PRICE
	1 to 20	21 to 40	41 to 87

Most Probable Quantity:	29
Most Probable Unit Price	$0
Total Evaluated Price	$0

Acrft Lot	2	3	4	5	6	7	8	9
	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8
Summary	$0	$0	$0	$0	$0	$0	$0	$0
Target Qty	29	29	34	46	46	58	58	29
Production Engines	24	24	28	38	38	48	48	24
Spare Engines	5	5	6	8	8	10	10	5

Tab E - Comm SW & Dig Engr

Separately Priced Computer Software and Digital Engineering Products

Offeror's Name:

F-15EX Lots 2+ Propulsion Program
Contract Phase: Production
CLIN Title	CLIN #	Contract Type	Unit	Total Price

Lot 2 Commercial Computer Software	2002	FFP	1 EA	0
Digital Engineering Products	2003	FFP NTE (Unpriced Option)	1 EA	0
Lot 3 Commercial Computer Software	3002	FFP	1 EA	0
Lot 4 Commercial Computer Software	4002	FFP	1 EA	0
Lot 5 Commercial Computer Software	5002	FFP	1 EA	0
Lot 6 Commercial Computer Software	6002	FFP	1 EA	0
Lot 7 Commercial Computer Software	7002	FFP	1 EA	0
Lot 8 Commercial Computer Software	8002	FFP	1 EA	0
Lot 9 Commercial Computer Software	9002	FFP	1 EA	0
TOTAL PRICE				$0

Tab F - Aux Transport Mat'l

Auxiliary Transportation Materiel for Spare Engines

Offeror's Name:

F-15EX Lots 2+ Propulsion Program
Contract Phase: Production
CLIN Title	CLIN #	Contract Type	Quantity	Unit Price	Total Price

Lot 2 Auxiliary Transportation Materiel for Spare Engines 31 Dec 23	2004AA	FFP	1	$0	$0
Lot 2 Auxiliary Transportation Materiel for Spare Engines 29 Feb 24	2004AB	FFP	2	$0	$0
Lot 2 Auxiliary Transportation Materiel for Spare Engines 31 Mar 24	2004AC	FFP	2	$0	$0
Lot 3 Auxiliary Transportation Materiel for Spare Engines (Option)	3003	FFP	5	$0	$0
Lot 4 Auxiliary Transportation Materiel for Spare Engines (Option)	4003	FFP	6	$0	$0
Lot 5 Auxiliary Transportation Materiel for Spare Engines (Option)	5003	FFP	8	$0	$0
Lot 6 Auxiliary Transportation Materiel for Spare Engines (Option)	6003	FFP	8	$0	$0
Lot 7 Auxiliary Transportation Materiel for Spare Engines (Option)	7003	FFP	10	$0	$0
Lot 8 Auxiliary Transportation Materiel for Spare Engines (Option)	8003	FFP	10	$0	$0
Lot 9 Auxiliary Transportation Materiel for Spare Engines (Option)	9003	FFP	5	$0	$0
TOTAL PRICE				0	$0

File details come from the government source that posted it. Updated Feb 5, 2021.