PSE_Solicitation_Template-RevB.xlsx

XLSX spreadsheet 78 KB Posted May 19, 2022

Attached to: C-17 Cable Assembly, Special Purpose, Electrical Federal contract opportunity
Solicitation number: FA852622Q0019
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Robins Air Force Base

View the file

Other files for this federal contract opportunity

Other files attached to C-17 Cable Assembly, Special Purpose, Electrical, newest first.
File	Type	Posted
Packaging_Form.pdf	PDF	May 19, 2022
FA8526-22-Q-0019 - 19May22.pdf	PDF	May 19, 2022
CDRL_A003_IUID_Marking_Plan_17G550555.pdf	PDF	May 19, 2022
CDRL_A001_A002_17G550555.pdf	PDF	May 19, 2022
Transportaton_Form_30245.pdf	PDF	May 19, 2022
Transportation_Form_30251.pdf	PDF	May 19, 2022
EDL_Rev6.pdf	PDF	May 19, 2022
Use_and_Non-Disclosure_Agreement.docx	DOCX document	May 19, 2022
Mandatory_Shipping_Documents.docx	DOCX document	May 19, 2022

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.

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 May 19, 2022.