RFQATTACH.SPE4AK18Q0013.0001.XLSX

XLSX spreadsheet 50 KB Posted Dec 4, 2017

Attached to: PARTS KIT, SEAL REPL Federal contract opportunity
Solicitation number: SPE4AK18Q0013
Issued by: Defense Logistics Agency Aviation

View the file

Other files for this federal contract opportunity

Other files attached to PARTS KIT, SEAL REPL, newest first.
File	Type	Posted
RFQATTACH.SPE4AK18Q0013.0002.XLSX	XLSX spreadsheet	Dec 4, 2017
RFQATTACH.SPE4AK18Q0013.0000.XLSX	XLSX spreadsheet	Dec 4, 2017
RFQATTACH.SPE4AK18Q0013.0003.XLSX	XLSX spreadsheet	Dec 4, 2017
RFQATTACH.SPE4AK18Q0013.0004.DOC	DOC document	Dec 4, 2017
SPE4AK18Q0013.PDF	PDF	Dec 4, 2017

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.

J-3 Pricing Sheet Solicitation Number: Kit NSN: 1650014089001 0 0 0 0 0 0 Contractor Fill In Provide Pricing for the sum of Spot Buy quantities for parts listed more than once. DLA Buy Price per Component (aka MAUC) Sum of Spot Buy DLA Buy Price per Kit Tracy McEntee-Hamrick: WHEN PRODUCING THE DELIVERALBE:

Delete column AO: DLA Buy Price per Component and delete column AP: Sum of Spot Buy DLA Buy Price per Kit, in addition to all other deliverable steps.	This column must remain
	SPE4AK-18-Q-0013						Kit Clin:	0001	0002		0003	0004	0005	0006	0007	Items to Tan
							Kit Qty:	200	0		0	0	0	0	0
							Kit NSN:	0	0		0	0	0	0	0
							Kit Clin:	0008	0009		0010	0011	0012	0013	0014
							Kit Qty:	0	0		0	0	0	0	0
	Kit CLIN	Comp CLIN	Component NSN	ICP	AMC	AMSC	Nomenclature	Primary CAGE	Part Number	SUP (UI)	UPA (UM)

DSCR: This is the quantity of this part to be included in each kit UI UM Conv Factor DSCR: This is the quantity included in the unit of issue: HD =100, Each = 1, etc.

CSI FSI

DSCR: CSI= Critical Safety Item FSI = Flight Safety Indicator A "Y" means that this part is coded as either CSI or FSI and DLA has sufficient stock on hand A "YP" means this part is coded as either CSI or FSI and DLA does not have enough stock on hand or due in to meet the requirement A "N" means this is not a CSI or FSI part FAT DSCR: FAT = First Article Test is required for this part

Tracy McEntee-Hamrick: WHEN PRODUCING THE DELIVERALBE:

Delete column AO: DLA Buy Price per Component and delete column AP: Sum of Spot Buy DLA Buy Price per Kit, in addition to all other deliverable steps.	DLA Total Component Kit Price (UM)	Total Qty per Kit CLIN Qty (UM)	Spot Buy for Proposal (UM)	Revised DLA Kit Unit Price (UM)	Unit Cost (UM)	Total Spot Buy Price	Days Until Avaliable (Days ARO)	Mfg's CAGE Code	Dealer's CAGE Code	Tooling Cost
CLIN 9925	CLIN 1 LEAD TIME	CLIN 2 LEAD TIME	CLIN 3 LEAD TIME	CLIN 4 LEAD TIME	CLIN 5 LEAD TIME	CLIN 6 LEAD TIME	CLIN 7 LEAD TIME	CLIN 8 LEAD TIME	CLIN 9 LEAD TIME	CLIN 10 LEAD TIME	CLIN 11 LEAD TIME	CLIN 12 LEAD TIME	CLIN 13 LEAD TIME	CLIN 14 LEAD TIME
	0001	0001	2805011403809	SMS	3	B	RING,PISTON	81873	41003608-331	$23.38	1	EA	EA	1	N	N	$23.38	200	200	$0.00	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$23.38	$23.38
	0001	0002	5310001671279	SMS	1	G	NUT,PLAIN,CASTELLATED,HEXAGON	80205	AN310C3	$111.47	1	HD	EA	100	N	N	$1.11	200	0	$1.11	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$111.47	$0.00
	0001	0003	5310002632862	SMS	1	G	NUT,SELF-LOCKING,HEXAGON	80205	MS21045C3	$64.72	1	HD	EA	100	N	N	$0.65	200	0	$0.65	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$64.72	$0.00
	0001	0004	5310011312948	SMS	3	L	WASHER,KEY	81873	41003566	$49.95	1	EA	EA	1	N	N	$49.95	200	0	$49.95	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$49.95	$0.00
	0001	0005	5310011361766	SMS	3	L	WASHER,KEY	81873	41003562	$32.20	1	EA	EA	1	N	N	$32.20	200	0	$32.20	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$32.20	$0.00	Potential Problem
	0001	0006	5330000273590	SMS	1	G	RETAINER,PACKING	03950	MS28774-010	$1.71	8	EA	EA	1	N	N	$13.68	1,600	0	$13.68	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$1.71	$0.00
	0001	0007	5330000612359	SMS	1	G	RETAINER,PACKING	96906	MS27595-143	$2.31	4	EA	EA	1	N	N	$9.24	800	800	$0.00	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$2.31	$9.24
	0001	0008	5330003955288	SMS	1	C	PACKING ASSEMBLY	94697	082-59990-011MS	$13.88	1	EA	EA	1	N	N	$13.88	200	200	$0.00	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$13.88	$13.88
	0001	0009	5330003955300	SMS	1	C	PACKING ASSEMBLY	76301	ST7M254-015E2	$5.21	5	EA	EA	1	N	N	$26.05	1,000	0	$26.05	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$5.21	$0.00
	0001	0010	5330005805055	SMS	1	G	RETAINER,PACKING	96906	MS28774-014	$0.22	4	EA	EA	1	N	N	$0.88	800	0	$0.88	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.22	$0.00
	0001	0011	5330005821551	SMS	1	G	RETAINER,PACKING	96906	MS28774-009	$18.53	2	PG	EA	50	N	N	$0.74	400	400	$0.00	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$18.53	$0.74
	0001	0012	5330005822111	SMS	1	G	RETAINER,PACKING	96906	MS28774-116	$8.73	8	PG	EA	25	N	N	$2.79	1,600	0	$2.79	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$8.73	$0.00
	0001	0013	5330008220991	SMS	1	G	RETAINER,PACKING	81343	MS28774-124	$0.61	2	EA	EA	1	N	N	$1.22	400	0	$1.22	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.61	$0.00
	0001	0014	5330008357712	SMS	1	G	RETAINER,PACKING	96906	MS28774-117	$0.27	2	EA	EA	1	N	N	$0.54	400	0	$0.54	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.27	$0.00
	0001	0015	5330010367154	SMS	1	G	RETAINER,PACKING	96906	MS27595-014	$0.55	8	EA	EA	1	Y	N	$4.40	1,600	0	$4.40	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.55	$0.00
	0001	0016	5330010663936	SMS	1	G	RETAINER,PACKING	96906	MS27595-216	$0.47	2	EA	EA	1	N	N	$0.94	400	0	$0.94	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.47	$0.00
	0001	0017	5330011256907	SMS	3	B	RING,WIPER	81873	41003612-216	$21.98	1	EA	EA	1	N	N	$21.98	200	0	$21.98	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$21.98	$0.00
	0001	0018	5330011312980	SMS	1	G	RETAINER,PACKING	96906	MS27595-116	$0.44	2	EA	EA	1	N	N	$0.88	400	0	$0.88	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.44	$0.00	Potential Problem
	0001	0019	5330011403761	SMS	1	C	RETAINER,PACKING	81873	41003609-116	$7.08	1	EA	EA	1	N	N	$7.08	200	0	$7.08	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$7.08	$0.00
	0001	0020	5330011403762	SMS	1	C	RETAINER,PACKING	81873	41003611-216	$13.44	1	EA	EA	1	N	N	$13.44	200	0	$13.44	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$13.44	$0.00
	0001	0021	5330012213043	SMS	1	C	PACKING ASSEMBLY	5F573	7114MS160-5708	$25.81	1	EA	EA	1	N	N	$25.81	200	0	$25.81	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$25.81	$0.00
	0001	0022	5330012213044	SMS	1	C	PACKING ASSEMBLY	76301	ST7M254-217E2	$29.77	1	AY	AY	1	N	N	$29.77	200	0	$29.77	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$29.77	$0.00	Potential Problem
	0001	0023	5331010431419	SMS	1	T	O-RING	81343	M83461/1-016	$0.20	2	EA	EA	1	N	N	$0.40	400	0	$0.40	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.20	$0.00
	0001	0024	5331010460629	SMS	1	T	O-RING	81343	M83461/1-014	$0.16	6	EA	EA	1	N	N	$0.96	1,200	1,200	$0.00	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.16	$0.96
	0001	0025	5331010463300	SMS	1	T	O-RING	81343	M83461/1-012	$0.16	6	EA	EA	1	N	N	$0.96	1,200	0	$0.96	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.16	$0.00
	0001	0026	5331010470435	SMS	1	T	O-RING	81343	M83461/1-011	$0.18	2	EA	EA	1	Y	N	$0.36	400	0	$0.36	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.18	$0.00
	0001	0027	5331010885363	SMS	1	T	O-RING	81343	M83461/1-010	$0.23	4	EA	EA	1	Y	N	$0.92	800	0	$0.92	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.23	$0.00
	0001	0028	5331010886873	SMS	1	T	O-RING	81343	M83461/1-009	$0.13	1	EA	EA	1	N	N	$0.13	200	0	$0.13	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.13	$0.00
	0001	0029	5331011019486	SMS	1	T	O-RING	81349	M83461/1-008	$0.29	1	EA	EA	1	N	N	$0.29	200	0	$0.29	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.29	$0.00
	0001	0030	5331011074950	SMS	1	G	O-RING	81343	M83461/1-020	$0.19	2	EA	EA	1	N	N	$0.38	400	0	$0.38	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.19	$0.00
	0001	0031	5331011074956	SMS	1	T	O-RING	81343	M83461/1-006	$0.14	1	EA	EA	1	N	N	$0.14	200	0	$0.14	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.14	$0.00
	0001	0032	5331011074956	SMS	1	T	O-RING	81343	M83461/1-006	$0.14	1	EA	EA	1	N	N	$0.14	200	0	$0.14	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.14	$0.00
	0001	0033	5331011101412	SMS	1	T	O-RING	81343	M83461/1-116	$0.15	4	EA	EA	1	N	N	$0.60	800	0	$0.60	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.15	$0.00
	0001	0034	5331011101412	SMS	1	T	O-RING	81343	M83461/1-116	$0.15	4	EA	EA	1	N	N	$0.60	800	0	$0.60	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.15	$0.00
	0001	0035	5331011233297	SMS	1	T	O-RING	81343	M83461/1-117	$0.19	1	EA	EA	1	N	N	$0.19	200	0	$0.19	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.19	$0.00
	0001	0036	5331011283956	SMS	1	T	O-RING	81343	M83461/1-143	$0.39	2	EA	EA	1	N	N	$0.78	400	0	$0.78	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.39	$0.00
	0001	0037	5331011284873	SMS	1	T	O-RING	81343	M83461/1-216	$0.30	2	EA	EA	1	N	N	$0.60	400	0	$0.60	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.30	$0.00
	0001	0038	5331011311896	SMS	1	T	O-RING	81343	M83461/1-124	$0.30	1	EA	EA	1	N	N	$0.30	200	0	$0.30	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$0.30	$0.00	Potential Problem
	0001	0039	5331011424249	SMS	3	C	O-RING	81873	82005506-036	$4.87	3	EA	EA	1	N	N	$14.61	600	0	$14.61	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$4.87	$0.00
	0001	0040	5342006520429	SMS	1	G	LOCK,ROD END	80205	NAS559-5	$5.11	1	EA	EA	1	N	N	$5.11	200	0	$5.11	$0.00	$0.00	$0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	$5.11	$0.00

Total Parts Cost with All GFM (UM):	$308.09
Revised Total GFM Cost (UM) - CFM:	$259.89

PRICE PER KIT CLIN 0001		0001	0002	0003	0004	0005	0006	0007
259.8855	Price of Component Parts available from DLA:	$51,977.10	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

	PARTS PLUS 41.5% CCR			0	Spot Buy Price per Kit CLIN:	$0.00		$0.00		$0.00		$0.00	$0.00	$0.00	$0.00
	ERROR:#VALUE!
				0	Tooling Cost (CLIN 9925)
per Kit CLIN:		$0.00	$0.00	$0.00		$0.00	$0.00		$0.00		$0.00

Pricing Sheet Submitted by: (Enter Company Name Below) 0 Total Packing/Labeling Materials Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

	0	Total Service Fee per Kit CLIN:	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		Click Here for Service Fee Pricing
	TOTAL AY FEE PER KIT	Total CLIN Kit Price:	$51,977.10	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Date:	0
		Kit Unit Price (includes GFM costs):	$259.89	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Longest Estd Kit Delivery After Receipt of Order	TOTAL CONTRACT PRICE	Kit Unit Contract Price (minus GFM and Tooling costs):	$0.00	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	0
0 Days		Longest Component Lead Time	0 Days	0 Days	0 Days	0 Days	0 Days	0 Days	0 Days

Estimated Kit Delivery Days After Receipt of Order 0 0 0 0 0 0 0

	0008	0009	0010	0011	0012	0013	0014
Price of Component Parts available from DLA:	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Spot Buy Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

				Tooling Cost (CLIN 9925)
per Kit CLIN:	$0.00	$0.00	$0.00		$0.00	$0.00	$0.00	$0.00

Total Packing/Labeling Materials Price per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total Service Fee per Kit CLIN: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Total CLIN Kit Price: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Kit Unit Price (includes GFM costs): ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Kit Unit Contract Price (minus GFM and Tooling costs): ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Longest Component Lead Time 0 Days 0 Days 0 Days 0 Days 0 Days 0 Days 0 Days

Estimated Kit Delivery Days After Receipt of Order 0 0 0 0 0 0 0

&A KIT NSN &F

Service Fee Pricing Sheet

SERVICE FEE PRICING SHEET

Solicitation Number:			SPE4AK-18-Q-0013
KIT NSN	KIT QTY	KIT CLIN	DIRECT LABOR	OVER HEAD	G&A	PROFIT	TOTALS

			Enter dollar amounts for the total kit quantity
1650014089001	200	1		$0.00
0	0	2		$0.00
0	0	3		$0.00
0	0	4		$0.00
0	0	5		$0.00
0	0	6		$0.00
0	0	7		$0.00
0	0	8		$0.00
0	0	9		$0.00
0	0	10		$0.00
0	0	11		$0.00
0	0	12		$0.00
0	0	13		$0.00
0	0	14		$0.00

Return to J-3 Pricing Sheet
	Pricing Sheet Submitted by:

&A 01-26-17 KIT NSN

File details come from the government source that posted it.