B08-Attachment 0002-EPA Worksheet_2023-11-28.xlsx

XLSX spreadsheet 28 KB Posted Dec 4, 2023

Attached to: Load, Assemble and Pack of 105mm Projectile Gun Unit Cartridges and M1 High Explosive Cartridge
Solicitation number: W519TC23R0012
Issued by: Department of the Army Materiel Command Contracting Command Rock Island Arsenal

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains an EPA pricing worksheet template for a solicitation to load, assemble and pack 105mm projectile gun cartridges and M1 high explosive cartridges. The solicitation seeks pricing for various cartridge components including steel, brass, empty cartridge bodies and primers over multiple ordering periods. Offerors are to provide their proposed pricing per pound for each component, which will then be used to calculate not-to-exceed prices per cartridge. The worksheet includes examples demonstrating how proposed price increases or decreases would be evaluated per the terms of the solicitation to ensure they do not exceed 10% of current pricing. The Department of the Army Materiel Command Contracting Command Rock Island Arsenal is listed as the contracting agency.

View the file

Other files

File	Type	Posted
W519TC23R0012 Amendment 0004.pdf	PDF	Feb 2, 2024
W519TC23R0012 Amendment 0003.pdf	PDF	Dec 22, 2023
Exhibit F M28A2 Percussion Primer CDRL.pdf	PDF	Dec 21, 2023
W519TC23R0012 Amendment 0002.pdf	PDF	Dec 21, 2023
W519TC23R0012 Amendment 0001.pdf	PDF	Dec 7, 2023
Exhibit F M28B2 Percussion Primer CDRL.pdf	PDF	Dec 4, 2023
Attachment 0009 - Hazardous Material Warning Label.pdf	PDF	Dec 4, 2023
Attachment 0001 Price Matrix 20231127.xlsx	XLSX spreadsheet	Dec 4, 2023
Attachment 0003 Guidance CDRL.pdf	PDF	Dec 4, 2023
Exhibit D - M1 HE CDRL.pdf	PDF	Dec 4, 2023
Attachment 0004-OPSEC Plan Sample.pdf	PDF	Dec 4, 2023
Exhibit E M1 Metal Parts CDRL.pdf	PDF	Dec 4, 2023
Exhibit G PA-71-A Fiber Container CDRL.pdf	PDF	Dec 4, 2023
W519TC23R0012.pdf	PDF	Dec 4, 2023
Exhibit B - PGU-44B CDRL.pdf	PDF	Dec 4, 2023
Exhibit A - PGU-43B CDRL.pdf	PDF	Dec 4, 2023
Exhibit C - PGU-45B CDRL.pdf	PDF	Dec 4, 2023
Attachment 0006-COCO_SECURITY_SOW.pdf	PDF	Dec 4, 2023
Attachment 0005 Small Business Participation Plan PGU 43B-44B-45B M1.pdf	PDF	Dec 4, 2023
Attachment-0007- Past Performance Questionnaire.pdf	PDF	Dec 4, 2023
Attachment 0008 - GFP 20231101.pdf	PDF	Dec 4, 2023

Show all 21

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.

EPA Steel and Brass Attachment 0002 -- EPA Worksheet

CONTRACTOR:

DATE:

CLIN 0001: 105MM PGU-43/B Training Cartridge
NSN: 1315-01-472-1854 or 1315-01-676-2842, P/N: 9926070	Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer
	Brass	Brass	Brass	Brass	Brass	Brass	Brass	Brass
Lbs Per Unit	5	0.2728	5	0.2728	5	0.2728	5	0.2728

Price Per Lb	1,000 - 15,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	15,001 - 30,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	30,001 - 45,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002 - 105MM PGU-44/B HE Cartridge (New Manufacture)

NSN: 1315-01-515-9269 or 1315-01-676-2874, P/N: 9926071

Ordering Period 2

Ordering Period 3

Ordering Period 4

Ordering Period 5

Empty M1 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty M1 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty M1 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty M1 Body

CYU1/B Cartridge Case

M28A2 Primer

Steel

Brass

Steel

Brass

Steel

Brass

Steel

Brass

Lbs Per Unit

26.1

0.2728

26.1

0.2728

26.1

0.2728

26.1

0.2728

Price Per Lb	1,000 - 15,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	15,001 - 30,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	30,001 - 45,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003 - 105MM PGU-44/B HE Cartridge (Refurbished)
NSN: 1315-01-515-9269 or 1315-01-676-2874, P/N: 9926071	Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer	CYU1/B Cartridge Case	M28A2 Primer
	Brass	Brass	Brass	Brass	Brass	Brass	Brass	Brass
Lbs Per Unit	5	0.2728	5	0.2728	5	0.2728	5	0.2728

Price Per Lb	1,000 - 15,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	15,001 - 30,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	30,001 - 45,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0004 - 105MM PGU-45/B HF Cartridge (New Manufacture)

NSN: 1315-01-514-8595 or 1315-01-676-2162, P/N: 9926072

Ordering Period 2

Ordering Period 3

Ordering Period 4

Ordering Period 5

Empty PGU-45 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty PGU-45 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty PGU-45 Body

CYU1/B Cartridge Case

M28A2 Primer

Empty PGU-45 Body

CYU1/B Cartridge Case

M28A2 Primer

Steel

Brass

Steel

Brass

Steel

Brass

Steel

Brass

Lbs Per Unit

26.1

0.2728

26.1

0.2728

26.1

0.2728

26.1

0.2728

Price Per Lb	1,000 - 15,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	15,001 - 30,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	30,001 - 45,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0005 - M1 HE Cartridge New Manufacture) NSN: 1315-00-028-4857 or 1315-01-672-8532, P/N: 13023619
	Ordering Period 2		Ordering Period 3		Ordering Period 4		Ordering Period 5
	Empty M1 Body	M14 Cartridge Case	Empty M1 Body	M14 Cartridge Case	Empty M1 Body	M14 Cartridge Case	Empty M1 Body	M14 Cartridge Case
	Steel	Brass	Steel	Brass	Steel	Brass	Steel	Brass
Lbs Per Unit	26.1	5	26.1	5	26.1	5	26.1	5

Price Per Lb	5,000 - 15,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	15,001 - 30,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	30,001 - 45,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	45,001 - 70,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	70,001 - 95,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Price Per Lb	95,001 - 120,000
Price $ per cartridge		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0006 - M1 Metal Parts Assembly	Ordering Period 2	Ordering Period 3	Ordering Period 4	Ordering Period 5
NSN: 1315-00-077-2148, P/N: 10535876
	Empty M1 Body	Empty M1 Body	Empty M1 Body	Empty M1 Body
	Steel	Steel	Steel	Steel
Lbs Per Unit	25.8	25.8	25.8	25.8

Price Per Lb	1 - 500
Price $ per assembly		$0.00	$0.00	$0.00	$0.00

Price Per Lb	501 - 2,000
Price $ per assembly		$0.00	$0.00	$0.00	$0.00

Total $ Per Lb	2,000 - 5,000
Price $ per assembly		$0.00	$0.00	$0.00	$0.00

EPA Adj. Worksheet Example

* The examples use Steel as specified in H002 but also could be applied to Brass in H003 using Brass prices from the EPA Worksheet

EXAMPLE (Exceeds 10%) EXAMPLE (Exceeds 3% Less than 10%) EXAMPLE (Decrease of more than 3%)

Delivery Order Quantity 10,000			Delivery Order Quantity 10,000			Delivery Order Quantity 10,000
Ordering Period Unit Price (1,000 - 15,000)	$250.00	* from Att 0001	Ordering Period Unit Price (1,000 - 15,000)	$250.00	* from Att 0001	Ordering Period Unit Price (1,000 - 15,000)	$250.00	* from Att 0001

Updated Proposed Updated Proposed Updated Proposed

Lbs Per Unit	26.1	26.1	Lbs Per Unit	26.1	26.1	Lbs Per Unit	26.1	26.1
Price Per Lb	$ 1.80	$ 0.79	Price Per Lb	$ 1.25	$ 0.79	Price Per Lb	$ 0.50	$ 0.79
	* Current Price	* From EPA Steel and Brass tab		* Current Price	* From EPA Steel and Brass tab		* Current Price	* From EPA Steel and Brass tab

Total $ Per Lb $ 1.80 $ 0.79 Total $ Per Lb $ 1.25 $ 0.79 Total $ Per Lb $ 0.50 $ 0.79

Price $ Per Cartridge $ 46.98 $ 20.62 Price $ Per Cartridge $ 32.63 $ 20.62 Price $ Per Cartridge $ 13.05 $ 20.62

Updated amount:	$ 46.98	Updated amount:	$ 32.63	Updated amount:	$ 13.05
Less Original Contract Amount:	$ 20.62	Less Original Contract Amount:	$ 20.62	Less Original Contract Amount:	$ 20.62
Unit Price Increase or Decrease	$ 26.36	Unit Price Increase or Decrease	$ 12.01	Unit Price Increase or Decrease	$ (7.57)

Ordering Period Unit Price	$250.00	Ordering Period Unit Price	$250.00	Ordering Period Unit Price	$250.00
Adjusted Unit Price based on Steel Increase/Decrease	$ 276.36	Adjusted Price based on Steel Increase/Decrease	$ 262.01	Adjusted Price based on Steel Increase/Decrease	$ 242.43

Unit Price Percentage Increase/Decrease: 10.54% Unit Price Percentage Increase/Decrease: 4.80% Unit Price Percentage Increase/Decrease: -3.03%

Percent is Greater than or equal to 3%	Yes	Percent is Greater than or equal to 3%	Yes	Percent is Greater than or equal to -3%	Yes
Percent is Less than or Equal to 10%	No	Percent is Less than or Equal to 10%	Yes	Percent is Less than or Equal to -10%	Yes

Order Quantity	Unit Price	Extended	Order Quantity	Unit Price	Extended	Order Quantity	Unit Price	Extended
10,000	$ 276.36	$ 2,763,610.00	10,000	$ 262.01	$ 2,620,060.00	10,000	$ 242.43	$ 2,424,310.00
10,000	$ 250.00	$ 2,500,000.00	10,000	$ 250.00	$ 2,500,000.00	10,000	$ 250.00	$ 2,500,000.00
Total Price Adjustment		$ 263,610.00		Total Price Adjustment	$ 120,060.00		Total Price Adjustment	$ (75,690.00)

		Allowed Increase
IAW H002 the increase would be limited to a 10% increase	See Below	$ 250,038.00	IAW H002 the price adjustment can be made for the Total Price Adjustment amount since it is greater than 3% but does not exceed 10%	IAW H002 the price adjustment would result in a price decrease of $75,690.00

EXAMPLE (10%)

Delivery Order Quantity 10,000
Ordering Period Unit Price (1,000 - 15,000)	$250.00	* from Att 0001

Updated Proposed

Lbs Per Unit	26.1	26.1
Price Per Lb	$ 1.748	$ 0.79
	* Current Price	* From EPA Steel and Brass tab

Total $ Per Lb $ 1.75 $ 0.79

Price $ Per Cartridge $ 45.62 $ 20.62

Updated amount:	$ 45.62
Less Original Contract Amount:	$ 20.62
Unit Price Increase or Decrease	$ 25.00

Ordering Period Unit Price	$250.00
Adjusted Unit Price based on Steel Increase/Decrease	$ 275.00

Unit Price Percentage Increase/Decrease: 10.00%

Percent is Greater than or equal to 3%	Yes
Percent is Less than or Equal to 10%	No

10,000	$ 275.00	$ 2,750,038.00
10,000	$ 250.00	$ 2,500,000.00
Total Price Adjustment		$ 250,038.00

EPA Adjustment Worksheet

PRICE EVALUATION SHEET
W519TC-23-R-0012	PGU/M1 Solicitation

Offeror:	0
Cage Code:	0

EPA PRICING WORKSHEET FOR STEEL			EPA PRICING WORKSHEET FOR Brass
	Updated	Proposed		Updated	Proposed

Lbs Per Unit	Lbs Per Unit
Price Per Lb	Price Per Lb

Total $ Per Lb $ - 0 $ - 0 Total $ Per Lb $ - 0 $ - 0

	Price $ Per XXX	$ - 0	$ - 0		Price $ Per XXX	$ - 0	$ - 0
Updated amount:	$ - 0			Updated amount:	$ - 0
Less Original Contract Amount:	$ - 0			Less Original Contract Amount:	$ - 0
Total Increase/(Decrease) Per cartridge:	$ - 0			Total Increase/(Decrease) Per cartridge:	$ - 0
Add:				Add:
BYO Cost Per cartridge:	$ - 0			BYO Cost Per cartridge:	$ - 0
Revised Cost Per cartridge:	$ - 0			Revised Cost Per cartridge:	$ - 0

Revised Cost Per cartridge:	$ - 0	Revised Cost Per cartridge:	$ - 0
Less BYO Base Cost Per cartridge:	$ - 0	Less BYO Base Cost Per cartridge:	$ - 0
Increase in cartridges	$ - 0	Increase in cartridges	$ - 0
Increase in cartridges	$ - 0	Increase in cartridges	$ - 0
Divide by BYO Base Cost Per cartridge	$ - 0	Divide by BYO Base Cost Per cartridge	$ - 0

Percentage Increase/Decrease:	ERROR:#DIV/0!	Percentage Increase/Decrease:	ERROR:#DIV/0!
Percent is Less than 10%	ERROR:#DIV/0!	Percent is Less than 10%	ERROR:#DIV/0!

File details come from the government source that posted it. Updated Dec 4, 2023.