C-17_PSE_Solicitation_Template-FA8526-24-Q-0003-RevC.xlsx

XLSX spreadsheet 77 KB Posted Mar 21, 2024

Attached to: C-17 PSE - Test Set, Leak – Heat Exchanger, OBIGGS
Solicitation number: FA852624Q0003
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

About this file

Written by GovTribe AI · Mar 21, 2024

This document is a spreadsheet template for a firm-fixed price solicitation issued by the Department of the Air Force Materiel Command Lifecycle Management Center at Robins Air Force Base. The solicitation is for the procurement of four (4) test sets for the OBIGGS (Onboard Inert Gas Generating System) heat exchanger on the C-17 aircraft, which includes a first article and associated test plan and report. The government requires the ability to perform leak testing on the OBIGGS heat exchanger at the organizational and depot maintenance levels. The solicitation is set aside for 100% small business participation, and proposals are due by 5:00 PM EST on 22 April 2024. The contract will be awarded on a firm-fixed price basis, with deliveries FOB Destination within the continental United States.

View the file

Other files

File	Type	Posted
FA852624Q0003_______0003.pdf	PDF	Jul 15, 2024
FA852624Q0003_0002.pdf	PDF	Jun 11, 2024
FA852624Q0003_0001.pdf	PDF	May 22, 2024
CDRL_A003_IUID_Marking_Plan_EN_17G490139-1.pdf	PDF	Mar 21, 2024
MANDATORY_SHIPPING_DOCUMENTS.docx	DOCX document	Mar 21, 2024
NDA_RFQ_FA8526-24-Q-0003.pdf	PDF	Mar 21, 2024
CDRL_A002_Test_Inspection_17G490139-1.pdf	PDF	Mar 21, 2024
Transportation Form_1653.pdf	PDF	Mar 21, 2024
CDRL_A001_Test_Inspection_17G490139-1.pdf	PDF	Mar 21, 2024
FA852624Q0003.pdf	PDF	Mar 21, 2024
EDL_Rev1.pdf	PDF	Mar 21, 2024
Packaging Form_158.pdf	PDF	Mar 21, 2024

Show all 12

On GovTribe

Work with this file

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

Try for free Login

Text version

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

CONTRACTOR INSTRUCTIONS

Solicitation #-FA8526-XX-P-XXXX
Title-Peculiar Support Equipment XYZ
INSTRUCTIONAL GUIDANCE
Spreadsheet Worksheet Tab	Instructions for Specific SpreadSheet Worksheet Tab
	NOTE: "EXAMPLE-REPLACE W/ PROPOSAL DATA" IN RED
	Incorporate into Column A, rows 1-4 the information requested as it relates to your solicitation (information will flow into the other tabs)
	Incorporate into Columns A & B the correct Contract Line Items (CLINS) and descriptions of each as located in Schedule B of the solicitation
	Add in new lines if more CLINS are required than what is presented in this tab (follow the exact layout as provided)
Total Summary Tab by CLIN	Incorporate into Columns C-F Labeled "Proposed Sum of Hours by Labor Category/Material (Contractor Use) the applicable labor categories and rates utilized by CLIN (Replace Task Categories as necessary)
	Add in additional rows under the related CLIN for additional Task categories needed (ensure formulas are adhered to for calculation purposes)
	Incorporate the hours for each labor category identified by CLIN
	Incorporate your total dollars for Option CLINs (sample escalation provided)
	Ensure your data calculates correctly

	NOTE: "EXAMPLE-REPLACE W/ PROPOSAL DATA" IN RED
	Incorporate into Columns A & B the correct Contract Line Items (CLINS) and descriptions of each as located in Schedule B of the solicitation
	Add in new lines if more CLINS are required than what is presented in this tab (follow the exact layout as provided)
Task Summary by CLIN	Incorporate into Columns D-U Labeled "Proposed Sum of Hours by Task (Contractor Use) " the applicable tasks utilized by CLIN (Add To or Replace Labor Catagories as necessary)
	Add in additional rows under the related CLIN for additional tasks needed in Column C (ensure formulas are adhered to for calculation purposes)
	Incorporate the hours for each task identified by CLIN against the labor categories provided (i.e. PM/ENGINEERING/QUALITY)
	Ensure your data calculates correctly

	NOTE: "EXAMPLE-REPLACE W/ PROPOSAL DATA" IN RED
	Incorporate into Columns A & B the correct Contract Line Items (CLINS) and descriptions of each as located in Schedule B of the solicitation
	Add in new lines if more CLINS are required than what is presented in this tab (follow the exact layout as provided)
Materials Breakout Template	Incorporate into Columns C-H Labeled "Material" the applicable material utilized by CLIN (Replace material as necessary)
	Add in additional rows under the related CLIN for additional material as needed (ensure formulas are adhered to for calculation purposes)
	Incorporate the part number, unit of measure, unit price, and quantity
	Add in Shipping Costs as appropriate (Shipping Cost will be respresented as part of the sum of material pulled into the Summary Tab)
	Ensure your data calculates appropriately

Total Summary Tab by CLIN

Solicitation #-FA8526-XX-Q-XXXX

Quote # 1234 (Valid for 30 days)

Contractor-ABC Company

Date 2 May 2020

		PROPOSED-Sum of Hours by Labor Category/Material (CONTRACTOR USE)				Government Technical Review (For Official Use Only)
CLINS	Description	Task	Total Hours	Rates	Total	Total Hours	Rationale
BASIC PERIOD
0001	First Article/Production-FAT required
0001AA	First Article	Project Management			$ - 0
		Marerials Receiving and Handling			$ - 0
		Work Card / Traveler Development			$ - 0
		Task / Machine Setup			$ - 0
		Machine Operation			$ - 0
		Sheetmetal-Fabrication			$ - 0
		Welding			$ - 0
		Assembley			$ - 0
		In process inspections			$ - 0
		Test			$ - 0
		Paint Unit			$ - 0
		Packaging / Shipping			$ - 0
					$ - 0
					$ - 0
					$ - 0
		Total Hrs/Category:	0.00		$ - 0	0.00
		MATERIAL (SUM FROM MATERIAL TAB)			$ - 0
		CLIN 0001AA TOTAL			$ - 0
0001AB	Production Unit	Project Management			$ - 0
		Marerials Receiving and Handling			$ - 0
		Work Card / Traveler Development			$ - 0
		Task / Machine Setup			$ - 0
		Machine Operation			$ - 0
		Sheetmetal-Fabrication			$ - 0
		Welding			$ - 0
		Assembley			$ - 0
		In process inspections			$ - 0
		Test			$ - 0
		Paint Unit			$ - 0
		Packaging / Shipping			$ - 0
					$ - 0
					$ - 0
					$ - 0
		Total Hrs/Category:	0.00		$ - 0	0.00
		MATERIAL (SUM FROM MATERIAL TAB)			$ - 0
		CLIN 0001AB TOTAL			$ - 0
0002	DATA/CDRLs
0002AA	Test Plan	Program Management			$ - 0
		Engineering			$ - 0
		Engineering Support			$ - 0
		Total Hrs/Category:	0.00		$ - 0	0.00
0002AA	Test Report	Program Management			$ - 0
		Engineering			$ - 0
		Engineering Support			$ - 0
		Total Hrs/Category:	0.00		$ - 0	0.00
		BASIC PERIOD TOTAL
		Total Proposed Hours	0.00		0.00	0.00
		Total Proposed Labor Cost			$ - 0
		Total Proposed Material (From Material Tab)			$ - 0
		Total Price Basic Period			$ - 0
OPTION Years	Production
1001	Production				$ - 0
				escalation	1.035
		CLIN 1001 TOTAL			$ - 0
2001	Production				$ - 0
				escalation	1.035
		CLIN 2001 TOTAL			$ - 0
3001	Production				$ - 0
				escalation	1.035
		CLIN 3001 TOTAL			$ - 0

EXAMPLE

Replace W/ Proposal Data

Task Summary by CLIN

Solicitation #-FA8526-XX-Q-XXXX

Quote # 1234 (Valid for 30 days)

Contractor-ABC Company

Date 2 May 2020

		PROPOSED-Sum of Hours by Task (Contractor Use)	GOVERNMENT Technical Review (For Official Use Only)
CLINS	Description	Task

JACKSON, ROBERT A CIV USAF AFMC AFLCMC/WNKE:

Please modify this section to correspond with the Labor Task that are applicable with the requirement.

The tasks on the template are only examples and should be modified.	# Hours PM	# Hours Engineering	# Hours Engineering Tech	# Hours Quality Inspector	# Hours Welder-I	# Hours Welder-II	# Hours Welder-III	# Hours Machinist-I	# Hours Machinist-II	# Hours Machinist-III	# Hours Fabricator-I	# Hours Fabricator-II	# Hours Fabricator-III	# Hours Assembler-I	# Hours Assembler-II	# Hours Assembler-III	# Hours Test	# Hours Packaging & Shipping	Total Hours		# Hours PM	# Hours Engineering	# Hours Engineering Tech	# Hours Quality Inspector	# Hours Welder-I	# Hours Welder-II	# Hours Welder-III	# Hours Machinist-I	# Hours Machinist-II	# Hours Machinist-III	# Hours Fabricator-I	# Hours Fabricator-II	# Hours Fabricator-III	# Hours Assembler-I	# Hours Assembler-II	# Hours Assembler-III	# Hours Test	# Hours Packaging & Shipping	Total Hours	Rationale
	BASIC PERIOD
	0001	First Article/Production-FAT required
	0001AA	First Article	Project Management																			0																				0
			Marerials Receiving and Handling																			0																				0
			Work Card / Traveler Development																			0																				0
			Task / Machine Setup																			0																				0
			Machine Operation																			0																				0
			Sheetmetal-Fabrication																			0																				0
			Welding																			0																				0
			Assembley																			0																				0
			In process inspections																			0																				0
			Test																			0																				0
			Paint Unit																			0																				0
			Packaging / Shipping																			0																				0
																						0																				0
																						0																				0
																						0																				0
			Total Hrs/Category:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

0001AB	Production Unit	Project Management
		Marerials Receiving and Handling
		Work Card / Traveler Development
		Task / Machine Setup
		Machine Operation
		Sheetmetal-Fabrication
		Welding
		Assembley
		In process inspections
		Test
		Paint Unit
		Packaging / Shipping



		Total Hrs/Category:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

0002	DATA/CDRLs
0002AA	Test Plan	Program Management																			0																			0
		Engineering																			0																			0
		Engineering Tech																			0																			0
		Total Hrs/Category:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

0002AA	Test Report	Program Management
		Engineering
		Engineering Tech
		Total Hrs/Category:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Total Proposed Hours: 0 Total Objective Hours: 0

OPTION Years	Production
1001	Production	Learning curve Hr Calculator
		FA Starting Point		Learning Curve
		Prod1		95%
2001	Production	Prod2		90%
		Prod3		85%
		Avg Prod	ERROR:#DIV/0!
3001	Production

EXAMPLE

Replace W/ Proposal Data

Materials Breakout Template

Solicitation #-FA8526-XX-Q-XXXX

Quote # 1234 (Valid for 30 days)

Contractor-ABC Company

Date 2 May 2020

Materials

Technical Review

Part Number

Description/Type

Unit of Measure

Minimum Order Quantity

STEVENSON, JULIAN B NH-03 USAF AFMC AFLCMC/WLE: Only list the MOQ if it is greater that what is required for manufactureing. For Example: If you only need 4 of an item, but the distributer won't sell you less than 10. Then you list 10 as the MOQ. Otherwise, do not list an MOQ.

Unit Cost

FA Quantity (CLIN 0001AA)

Production Quantity (CLIN 0001AB)

Total Quantity

FA Material Cost (CLIN 0001AA)

Production Material Cost (CLIN 0001AB)

Total Extended Price

Comments

Requirement per End Item

Total Required Quantity

Adjusted Total Extended Cost

Rationale

STEVENSON, JULIAN B NH-03 USAF AFMC AFLCMC/WLE: Only list the MOQ if it is greater that what is required for manufactureing. For Example: If you only need 4 of an item, but the distributer won't sell you less than 10. Then you list 10 as the MOQ. Otherwise, do not list an MOQ.	0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00
					0	$0.00	$0.00	$0.00

Total Proposed Material Cost : $0.00 $0.00 $0.00 Total Adjusted Material Cost: 0.0

EXAMPLE

Replace W/ Proposal Data

File details come from the government source that posted it. Updated Mar 21, 2024.