C-17_PSE_Solicitation_Template-FA8526-XX-P-XXXX-FINAL.xlsx

XLSX spreadsheet 59 KB Posted Apr 2, 2021

Attached to: Tensiometer, Cable - Life Raft Retractor Federal contract opportunity
Solicitation number: FA8526-21-Q-0023
Issued by: Department of the Air Force

View the file

Other files for this federal contract opportunity

Other files attached to Tensiometer, Cable - Life Raft Retractor, newest first.
File	Type	Posted
FA852621Q0023_______0001.pdf	PDF	May 4, 2021
Attachments.pdf	PDF	Apr 2, 2021
FA8526-21-Q-0023_RFQ.pdf	PDF	Apr 2, 2021
Use_and_Non-Disclosure_Agreement.docx	DOCX document	Apr 2, 2021

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 Labor Categories as necessary)
	Add in additional rows under the related CLIN for additional labor categories needed (ensure formulas are adhered to for calculation purposes)
	Incorporate the hours for each labor category identified by CLIN
	Incorporate your total sum of material dollars proposed by CLIN from the Material Tab
	Incorporate your total dollars for Option CLINs (sample escalation provided)
	Ensure your data calculates appropriately

	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 C-F Labeled "Proposed Sum of Hours by Task (Contractor Use) " the applicable tasks utilized by CLIN (Replace tasks as necessary)
	Add in additional rows under the related CLIN for additional tasks needed (ensure formulas are adhered to for calculation purposes)
	Incorporate the hours for each task identified by CLIN against the categories provided (i.e. PM/LE/QUALITY)
	Ensure your data calculates appropriately

	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-P-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	Program Management	40.00	$ 30.00	$ 1,200.00	40.00
		Engineering	20.00	$ 45.00	$ 900.00	20.00
		Engineering Support	12.00	$ 35.00	$ 420.00	12.00
		Materials Management/Production Control	30.00	$ 23.00	$ 690.00	30.00
		Quality Assurance	16.00	$ 32.00	$ 512.00	16.00
		Shipping/Receiving	6.00	$ 30.00	$ 180.00	6.00
		Fixturing/Tooling	20.00	$ 22.00	$ 440.00	20.00

		Total Hrs/Category:	144.00		$ 4,342.00	144.00
		MATERIAL (SUM FROM MATERIAL TAB)			$ 11,872.82
		CLIN 0001AA TOTAL			$ 16,214.82
0001AB	Production Unit	Program / Setup	161.34	$ 30.00	$ 4,840.20	161.34
		Sheet Metal Shop	52.19	$ 45.00	$ 2,348.55	52.19
		Waterjet/Speciality Machine	96.51	$ 35.00	$ 3,377.85	96.51
		Machine Shop	89.18	$ 23.00	$ 2,051.14	89.18
		Welding Shop	120.00	$ 32.00	$ 3,840.00	120.00
		Material Prep - Corrosion Ctrl	8.00	$ 30.00	$ 240.00	8.00
		Paint Shop		$ - 0	$ - 0	0.00
		Assembly Shop	63.00	$ 32.00	$ 2,016.00	63.00
		Material Control			$ - 0	0.00
		Packing/Crating
		Total Hrs/Category:	590.22		$ 18,713.74	590.22
		MATERIAL (SUM FROM MATERIAL TAB)			$ 1,206.32
		CLIN 0001ABTOTAL			$ 19,920.06
0002	DATA/CDRLs
0002AA	Test Plan	Program Management	15.00	$ 30.00	$ 450.00	15.00
		Engineering	5.00	$ 45.00	$ 225.00	5.00
		Engineering Support	16.00	$ 35.00	$ 560.00	16.00
		Total Hrs/Category:	36.00		$ 1,235.00	36.00
0002AA	Test Report	Program Management	15.00	$ 30.00	$ 450.00	15.00
		Engineering	5.00	$ 45.00	$ 225.00	5.00
		Engineering Support	10.00	$ 35.00	$ 350.00	10.00
		Total Hrs/Category:	30.00		$ 1,025.00	30.00
		BASIC PERIOD TOTAL
		Total Proposed Hours	800.22		800.22	800.22
		Total Proposed Labor			$ 25,315.74
		Total Proposed Material			$ 13,079.14
		Total Price Basic Period			$ 38,394.88
OPTION Years	Production
1001	Production				$ 19,920.06
				escalation	1.035
		CLIN 1001 TOTAL			$ 20,617.26
2001	Production				$ 20,617.26
				escalation	1.035
		CLIN 2001 TOTAL			$ 21,338.87
3001	Production				$ 21,338.87
				escalation	1.035
		CLIN 3001 TOTAL			$ 22,085.73

EXAMPLE

Replace W/ Proposal Data

Task Summary by CLIN

Solicitation #-FA8526-XX-P-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 LE	# Hours SDE	# Hours ASSY-3	# Hours MACH	# Hours QUALITY	Total Hours		# Hours PM	# Hours LE	# Hours SDE	# Hours ASSY-3	# Hours MACH	# Hours QUALITY	Total Hours	Rationale
	BASIC PERIOD
	0001	First Article/Production-FAT required
	0001AA	First Article	Manufacturing-Machining	2						2								0
			Manufacturing-Fabrication							0								0
			Manufacturing Instructions							0								0
			Project Management	5						5								0
			In process inspections							0		0	0	0	0	0	0	0
			Test Unit		7			12		19								0
			Assemble (per unit)							0								0
			Paint Unit							0								0
			Package for ship to customer							0								0
			Total Hrs/Category:	7	7	0	0	12	0	26		0	0	0	0	0	0	0

0001AB	Production Unit	Project management				0							0
		In process inspections	3			3							0
		Manufacturing-Machining				0							0
		Manufacturing-Fabrication				0							0
		Test Unit			6	6	0	0	0	0	0	0	0
		Assemble (per unit)				0
		Paint Unit				0
		Package for ship to customer		12		12

Total Hrs/Category: 3 12 6 0 0 0 21 0 0 0 0 0 0 0

0002	DATA/CDRLs
0002AA	Test Plan	Create work instructions							0							0
		Machining Proof Load Fixture	3						3							0
		First Article Test Plan (FATP)					2		2							0
		Total Hrs/Category:	3	0	0	0	2	0	5	0	0	0	0	0	0	0
0002AA	Test Report	Create work instructions							0							0
		Machining Proof Load Fixture			6				6							0
		First Article Test Report (FATR)	8						8							0
		Total Hrs/Category:	8	0	6	0	0	0	14	0	0	0	0	0	0	0

Total Proposed Hours: 66 Total Objective Hours: 0

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

Option Year II

Option Year III

EXAMPLE

Replace W/ Proposal Data

Materials Breakout Template

Solicitation #-FA8526-XX-P-XXXX

Quote # 1234 (Valid for 30 days)

Contractor-ABC Company

Date 2 May 2020

		Materials						Technical Review (For Official Use Only)
CLINS	Description	Part Number	Description/Type	Unit of Measure	Unit of Cost	Quantity	Extended Price	Quantity	Rationale
0001	First Article/Production-FAT required
0001AA	First Article		Insert, Foam, Top	EA	$ 540.24	1.00	$ 540.24
			Case, 29.75"x17.87"x18.49" (ID)	EA	$ 1,545.00	1.00	$ 1,546.00
			Insert, Foam, Bottom	EA	$ 523.08	1.00	$ 524.08
			Transducer Assy, Pressure	EA	$ - 0	1.00	$ - 0
			Plate, Ident	EA	$ 125.66	1.00	$ 125.66
			Bar Code Plate	EA	$ 125.66	1.00	$ 125.66
			Pressure Tranducer/Read Out (17G233286-1)	EA	$ 8,943.22	1.00	$ 8,943.22
			Nut, Locking, 4-40	EA	$ 0.12	8.00	$ 0.96
			Screw, Pan, #4-40x.625	EA	$ 0.25	8.00	$ 2.00
			SHIPPING COST				$ 65.00
			CLIN 0001AA MATERIAL TOTAL				$ 11,872.82
0001AB	Production Unit		Washer, Flat, #4	EA	$ 0.12	8.00	$ 0.96
			Cap, Pressure, Modified	EA	$ - 0	1.00	$ - 0
			Hose Assy, 20'	EA	$ 125.66	1.00	$ 125.66
			Pad	EA	$ 125.66	1.00	$ 125.66
			Tab	EA	$ 95.25	4.00	$ 381.00
			Spacer	EA	$ 63.18	4.00	$ 252.72
			Bolt Assy	EA	$ - 0	1.00	$ - 0
			Adapter	EA	$ 255.32	1.00	$ 255.32
			SHIPPING COST				$ 65.00
			CLIN 0001AB MATERIAL TOTAL				$ 1,206.32

0002	DATA/CDRLs
0002AA	Test Plan

0002AA Test Report

Total Proposed Qty: 44.00 26158.28 0 Total Objective Qty:

EXAMPLE

Replace W/ Proposal Data

File details come from the government source that posted it. Updated Apr 2, 2021.