ATTACHMENT 0002 - EPA WORKSHEET.xlsx

XLSX spreadsheet 84 KB Posted Dec 15, 2021

Attached to: FY22-26 40mm Systems Family of Ammunition
Solicitation number: W52P1J-22-R-0009
Issued by: Department of the Army Materiel Command Joint Munitions Command

About this file

Written by GovTribe AI · Dec 28, 2023

This solicitation requests proposals for the production of the 40mm Systems Family of Ammunition for fiscal years 2022 through 2026. The United States Army Contracting Command - Rock Island will award a firm fixed price contract to incumbent AMTEC Corporation on a sole source basis for the manufacturing, testing, and delivery of various 40mm cartridges, including practice, high explosive, and illumination rounds. Key cartridges are the M385A1, M430A1, M918, M433, M433E1, M781, and mixed belt consisting of M918 and M385A1 rounds. The contractor must use government furnished technical data and meet quality requirements. The base year estimated quantity is over 442,000 mixed belt rounds and over 506,000 M781 practice rounds. Proposals are due by the fourth quarter of fiscal year 2022 and award will also occur in the fourth quarter. The contractor must register in the System for Award Management and follow export control procedures to access the technical data package.

View the file

Other files

File	Type	Posted
ATTACHMENT 0009 - W52P1J-22-R-0009 OFFEROR QUESTIONS AND USG RESPONSES (16 FEB 2022).xlsx	XLSX spreadsheet	Feb 17, 2022
ATTACHMENT 0007 - TRANSPORTATION DATA (16 FEB 2022).xlsx	XLSX spreadsheet	Feb 17, 2022
W52P1J-22-R-0009_0003.pdf	PDF	Feb 17, 2022
W52P1J-22-R-0009_0002_signed.pdf	PDF	Feb 14, 2022
ATTACHMENT 0009 - W52P1J-22-R-0009 OFFEROR QUESTIONS AND USG RESPONSES.xlsx	XLSX spreadsheet	Feb 11, 2022
W52P1J-22-R-0009_0002.pdf	PDF	Feb 11, 2022
ATTACHMENT 0002 - EPA WORKSHEET (04 FEB 2022).xlsx	XLSX spreadsheet	Feb 11, 2022
ATTACHMENT 0001 - 40MM SYSTEMS PRICE MATRIX 14 JAN 2022.xlsx	XLSX spreadsheet	Jan 21, 2022
W52P1J-22-R-0009_0001.pdf	PDF	Jan 21, 2022
ATTACHMENT 0008 - COCO SECURITY SOW.pdf	PDF	Dec 15, 2021
ATTACHMENT 0005 - OPSEC PLAN - SAMPLE.pdf	PDF	Dec 15, 2021
ATTACHMENT 0007 - TRANSPORTATION DATA.xlsx	XLSX spreadsheet	Dec 15, 2021
ATTACHMENT 0001 - 40MM SYSTEMS PRICE MATRIX.xlsx	XLSX spreadsheet	Dec 15, 2021
ATTACHMENT 0003 - GUIDANCE ON DOCUMENTATION OF CDRLs.pdf	PDF	Dec 15, 2021
EXHIBIT A - CONTRACT DATA REQUIREMENTS LIST (CDRLS).pdf	PDF	Dec 15, 2021
W52P1J-22-R-0009.pdf	PDF	Dec 15, 2021
ATTACHMENT 0006 - ADC REQUIREMENTS.pdf	PDF	Dec 15, 2021

Show all 17

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.

Instructions

INSTRUCTIONS: Offeror shall provide material costs (metal prices) for the aluminum, steel, zinc, tungsten, and copper identified on the respective tabs of this Excel file. These costs, which must be substantiated by the offeror through its submission of supporting purchase orders, quotes, or invoices with its proposal, will serve as the baseline material cost (metal price) for each metal by cartridge. See example below.
		= Contractor Fill-In
ALUMINUM:		This cell identifies the metal content for the given cartridge by pound. The component breakout for this material weight can be found on the tab for the cited cartridge (in this example, the M430A1). This cell is linked to the cartridge tab, and pulls the total weight from there (refer to formula in cell B7). The Government has provided the component breakout weights, which shall not be changed by offeror.
	Baseline for Options 1-5:
Aluminum lbs per M430A1:	0.78190
Proposed Aluminum Unit Price per Pound (include surcharge)	$ 2.00
Proposed Aluminum EPA Baseline Price per M430A1	$ 1.56
		Offeror shall enter its per-pound material cost in this cell for the cited metal, reflecting price paid by or quoted to offeror for the metal. Cells for the per-pound price entries are highlighted blue.
		This cell calculates the baseline per-cartridge material cost (metal price) for the given cartridge and metal by multiplying the per-pound price by the weight per cartridge (refer to formula in cell B9).

Aluminum

ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT

ALUMINUM:
	Baseline for Options 1-5:
Aluminum lbs per M430A1 (both Metal and Wood Pallet):	0.78190
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M430A1	$ - 0

Aluminum lbs per M433:	0.52540
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M433	$ - 0

Aluminum lbs per M583A1:	0.41800
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M583A1	$ - 0

Aluminum lbs per M918:	0.58974
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M918	$ - 0
Aluminum lbs per Mixed Belt:	0.69863
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per Mixed Belt	$ - 0
Aluminum lbs per M385A1:	0.93821
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M385A1	$ - 0
Aluminum lbs per M992:	0.41800
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M992	$ - 0
Aluminum lbs per M585:	0.41800
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M585	$ - 0
Aluminum lbs per M661:	0.41800
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M661	$ - 0

Aluminum lbs per M662:	0.41800
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M662	$ - 0

Aluminum lbs per M433E1:	0.35300
Proposed Aluminum Unit Price per Pound (include surcharge)
Proposed Aluminum EPA Baseline Price per M433E1	$ - 0

Steel

ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT

STEEL:
	Baseline for Options 1-5:
Steel lbs per M430A1 (Metal Pallet):	0.91545
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M430A1	$ - 0

Steel lbs per M430A1 (Wood Pallet):	0.84179
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M430A1	$ - 0

Steel lbs per M433:	0.14150
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M433	$ - 0

Steel lbs per M583A1:	0.26136
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M583A1	$ - 0

Steel lbs per M918:	1.18062
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M918	$ - 0

Steel lbs per Mixed Belt:	0.98525
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per Mixed Belt	$ - 0

Steel lbs per M385A1:	0.55545
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M385A1	$ - 0

Steel lbs per M992:	0.26136
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M992	$ - 0

Steel lbs per M585:	0.26136
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M585	$ - 0

Steel lbs per M661:	0.26136
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M661	$ - 0

Steel lbs per M662:	0.26136
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M662	$ - 0

Steel lbs per M433E1:	0.61479
Proposed Steel Unit Price per Pound (include surcharge)
Proposed Steel EPA Baseline Price per M433E1	$ - 0

Zinc

ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT

ZINC:
	Baseline for Options 1-5:
Zinc lbs per M781:	0.38220
Proposed Zinc Unit Price per Pound (include surcharge)
Proposed Zinc EPA Baseline Price per M781	$ - 0

Tungsten

ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT

TUNGSTEN:
	Baseline for Options 1-5:
Tungsten lbs per M433E1:	0.20000
Proposed Tungsten Unit Price per Pound (include surcharge)
Proposed Tungsten EPA Baseline Price per M433E1	$ - 0

Copper

ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT
COPPER:
	Baseline for Options 1-5:
Copper lbs per M430A1 (both Metal and Wood Pallet):	0.03307
Proposed Copper Unit Price per Pound (include surcharge)
Proposed Copper EPA Baseline Price per M430A1	$ - 0
Copper lbs per M918:	0.03307
Proposed Copper Unit Price per Pound (include surcharge)
Proposed Copper EPA Baseline Price per M918	$ - 0
Copper lbs per M385A1:	0.03307
Proposed Copper Unit Price per Pound (include surcharge)
Proposed Copper EPA Baseline Price per M385A1	$ - 0

M430A1 (Metal Pallet) M430A1 (Metal Pallet)

	Component	Part #	Material	Weight (lbs)	Weight (g)
Aluminum Components	Cartridge Case, 40mm, M169	8886329	Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221	0.21700	98.42946
	Base Plug	8886332	Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211	0.04860	22.04457
	Bottom Plate	9287890	Aluminum Alloy, Rod, Alloy No. 7075, Temper T6, Per Spec ASTM B211	0.02830	12.83665
	Centerplate	12944723	Al Aly, Sheet, 6061-T0 Per ASTM B209	0.02300	10.43262
	Ogive	12944735	Aluminum Alloy, Rod, 6061-T0 Per ASTM B211, ALTERNATE MATERIAL: Aluminum Alloy, Rod 6061-T0 Per ASTM B221	0.46500	210.92028
			Total Aluminum Weight	0.78190	354.66358

Steel Components	Body	9287855	Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized	0.36000	163.29312
	Link	11691395	Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684	0.02866	12.99999
	Metal Pallet	-	Steel	0.07366	33.41194
	PA120 Ammo Can	-	Steel	0.45313	205.53404
			Total Steel Weight	0.91545	415.23909

Copper Component	Copper	8886402	Copper, Tubing, Seamless, Annealed, SPEC ASTM B75	0.03307	15.00000
			Total Copper Weight	0.03307	15.00000

M430A1 (Wood Pallet) M430A1 (Wood Pallet)

	Component	Part #	Material	Weight (lbs)	Weight (g)
Aluminum Components	Cartridge Case, 40mm, M169	8886329	Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221	0.21700	98.42946
	Base Plug	8886332	Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211	0.04860	22.04457
	Bottom Plate	9287890	Aluminum Alloy, Rod, Alloy No. 7075, Temper T6, Per Spec ASTM B211	0.02830	12.83665
	Centerplate	12944723	Al Aly, Sheet, 6061-T0 Per ASTM B209	0.02300	10.43262
	Ogive	12944735	Aluminum Alloy, Rod, 6061-T0 Per ASTM B211, ALTERNATE MATERIAL: Aluminum Alloy, Rod 6061-T0 Per ASTM B221	0.46500	210.92028
			Total Aluminum Weight	0.78190	354.66358

Steel Components	Body	9287855	Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized	0.36000	163.29312
	Link	11691395	Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684	0.02866	12.99999
	PA120 Ammo Can	-	Steel	0.45313	205.53404
			Total Steel Weight	0.84179	381.82715

Copper Component	Copper	8886402	Copper, Tubing, Seamless, Annealed, SPEC ASTM B75	0.03307	15.00000
			Total Copper Weight	0.03307	15.00000

M433 M433

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	Skirt	8886344	Tubing, Aluminum Alloy, 6061-T4. Die and Mandrel Extruded from Hollow Billet, Such as ASTM B210 or ASTM B241	0.19040	86.36392
	M118 Cartridge Case	8844610	ALUMINUM ALLOY, 6066 CHEMICAL COMPOSITION IN ACCORDANCE WITH TABLE 1 OF SPEC ASTM B221	0.19900	90.26481
	Ogive	8886350	Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209	0.02610	11.83875
	Centerplate	9266693	Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209	0.02300	10.43262
	Fuze Body	8886356	Aluminum Alloy, Rod, 6061-0, ASTM B211, B221 or B209	0.08690	39.41714
			Total Aluminum Weight	0.52540	238.31724

Steel Components	Boattail cup	9276546	Steel, strip, Aluminum killed, 1009, Deep draw quality, Spec QQ-S-698.	0.12500	56.69900
	Retaining ring	8886340	Steel, strip, High Carbon, Cold rolled, Spring Quality, Spec ASTM A684	0.01650	7.48427
			Total Steel Weight	0.14150	64.18327

M583A1 M583A1

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	M195 Cartridge Case	9207989	Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221	0.18500	83.91452
	Body	9243900	Aluminum Alloy, 6061, Temper 0, ASTM B221	0.23300	105.68694
			Total Aluminum Weight	0.41800	189.60146

Steel Component	M2A2 Ammo Can	-	Steel	0.26136	118.55253
			Total Steel Weight	0.26136	118.55253

M781 M781

	Component	Part #	Material	Weight (lb)	Weight (g)
Zinc Component	Body, 40mm, Practice Round	9310344	Zinc Alloy, Type Ag40A OR AC41A, in accordance with ASTM B86	0.38220	173.36286
			Total Zinc Weight	0.38220	173.36286

M918 M918

	Component	Part Number	Material	Weight (lbs)	Weight (g)
Aluminum Components	Cartridge Case, 40mm, M169	8886329	Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221	0.18289	82.958801656
	Base Plug	8886332	Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211	0.02504	11.357036496
	Body Insert	9399382	Aluminum Rod Alloy, 6061-T6 or Alloy 7075-T6 Per Spec ASTM-B211	0.254060	115.23958352
	Firing Pin Plate	9399393	Aluminum Alloy Sheet, 6061-T6 Per Spec ASTM-B209	0.013649	6.1909734576
	Top Plate	8886359	Aluminum Alloy, Sheet, 7075, Temper T6 per ASTM B209	0.009621	4.3641674979
	Detonator Cup	8798332	Aluminum Alloy, 1100, Temper 0, ASTM B209	0.000051	0.0229972345
	Closing Disc	8798333	Aluminum Foil, QQ-A-1876	0.000005	0.0023586907
	Ogive, M918TP	9399394	Aluminum Alloy 6061, Temper 0 Per Spec ASTM B211. Alternate Material: Aluminum Alloy 6061, Temper 0 Per Spec ASTM B221.	0.104419	47.3636889289
			Total Aluminum Weight	0.58974	267.49961

Steel Components	Body	9299396	Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized	0.623000	282.58782
	Detent Spring	8886362	Wire, Steel, Corrosion-Resisting, QQ-W-423	0.00006	0.02823
	Verge Arbor	8886367	Steel, Corrosion Resistant, Round, Type 303, ASTM A-581	0.00016	0.07067
	Pinion	8886369	Wire, Steel, Corrosion Resisting, Class 416	0.00015	0.06969
	Rotor Shaft	9219876	Steel, Bar, Corrosion Resisting, Class 416	0.00037	0.16697
	Setback Pin	12999562	Steel Cold Drawn, Grade 1213 or 12L14 per ASTM A108	0.000683	0.30958
	Firing Pin	9399392	Stainless Steel, Type 416 Round, Annealed and Cold Drawn Wire Per ASTM A581 or ASTM A582	0.000755	0.34260
	Link	11691395	Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684	0.02866	12.99999
	PA120 Ammo Can	-	Steel	0.45313	205.53388
	Metal Pallet	-	Steel	0.07366	33.41191
			Total Steel Weight	1.18062	535.52133

Copper Component	Copper	8886402	Copper, Tubing, Seamless, Annealed, SPEC ASTM B75	0.03307	15.00000
			Total Copper Weight	0.03307	15.00000

Mixed Belt Mixed Belt (22:10 ratio M918 to M385A1)

		per ctg	per belt		Total Aluminum Weight (g)	Total Aluminum Weight (lbs)
Aluminum Components	M918	267.49961	22	5884.99136	316.8950438661	0.6986331516
	M385A1	425.565003912	10	4255.65004
		Total	32	10140.64140

		per ctg	per belt		Total Steel Weight (g)	Total Steel Weight (lbs)
Steel Components	M918	535.52133	22	11781.46926	446.9039698284	0.98525343
	M385A1	251.9457777935	10	2519.45778
		Total	32	14300.92703

M385A1 M385A1

	Component	Part Number	Material	Weight (lbs)	Weight (g)
Aluminum Components	Cartridge Case, 40mm, M169	8886329	Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221	0.18289	82.958801656
	Base Plug	8886332	Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211	0.02504	11.357036496
	Body	8866715	Aluminum Alloy Bar, 2024, T351 ASTM B211	0.73028	331.24917
			Total Aluminum Weight	0.93821	425.56500

Steel Components	Link	11691395	Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684	0.02866	12.9999920792
	PA120 Ammo Can	-	Steel	0.45313	205.53388
	Metal Pallet	-	Steel	0.07366	33.41191
			Total Steel Weight	0.55545	251.94578

Copper Component	Copper	8886402	Copper, Tubing, Seamless, Annealed, SPEC ASTM B75	0.03307	15.00000
			Total Copper Weight	0.03307	15.00000

M992 M992

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	M195 Cartridge Case	9207989	Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221	0.18500	83.91452
	Body	9243900	Aluminum Alloy, 6061, Temper 0, ASTM B221	0.23300	105.68694
			Total Aluminum Weight	0.41800	189.60146

Steel Component	M2A2 Ammo Can	-	Steel	0.26136	118.55244
			Total Steel Weight	0.26136	118.55244

M585 M585

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	M195 Cartridge Case	9207989	Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221	0.18500	83.91452
	Body	9243900	Aluminum Alloy, 6061, Temper 0, ASTM B221	0.23300	105.68694
			Total Aluminum Weight	0.41800	189.60146

Steel Component	M2A2 Ammo Can	-	Steel	0.26136	118.55244
			Total Steel Weight	0.26136	118.55244

M661 M661

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	M195 Cartridge Case	9207989	Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221	0.18500	83.91452
	Body	9243900	Aluminum Alloy, 6061, Temper 0, ASTM B221	0.23300	105.68694
			Total Aluminum Weight	0.41800	189.60146

Steel Component	M2A2 Ammo Can	-	Steel	0.26136	118.55244
			Total Steel Weight	0.26136	118.55244

M662 M662

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	M195 Cartridge Case	9207989	Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221	0.18500	83.91452
	Body	9243900	Aluminum Alloy, 6061, Temper 0, ASTM B221	0.23300	105.68694
			Total Aluminum Weight	0.41800	189.60146

Steel Component	M2A2 Ammo Can	-	Steel	0.26136	118.55244
			Total Steel Weight	0.26136	118.55244

M433E1 M433E1

	Component	Part #	Material	Weight (lb)	Weight (g)
Aluminum Components	Cartridge Case	13061668	ALUMINUM ALLOY, 6066 CHEMICAL COMPOSITION IN ACCORDANCE WITH TABLE 1 OF SPEC ASTM B221	0.21700	98.42946
	Ogive	8886350	Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209	0.02610	11.83875
	Centerplate	9266693	Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209	0.02300	10.43262
	Fuze Body	13061660	Aluminum Alloy, Rod, 6061-0, ASTM B211, B221 or B209	0.08690	39.41714
			Total Aluminum Weight	0.35300	160.11798

Steel Components	Pusher Liner	13061666	AISI 316/316L per AMS 5648, AMS 5653, ASTM A276	0.35343	160.31265
	M2A2 Ammo Can	-	Steel	0.26136	118.55244
			Total Steel Weight	0.61479	278.86508
Tungsten Component	Pellet	13061665	Tungsten-Nickel-Iron Alloy, Approx Mass: 2 grains, Approx Density: 18.5g/cc	0.20000	90.71839
			Total Tungsten Alloy Weight	0.20000	90.71839

File details come from the government source that posted it. Updated Dec 15, 2021.