Attachment 0006 - EPA Pricing Worksheet for Copper.xlsx

XLSX spreadsheet 15 KB Posted May 15, 2020

Attached to: Pre-Solicitation Notice for Second Source Supplier to Produce 5. 56mm, 7. 62mm, and Caliber . 50 Ammunition
Solicitation number: W52P1J20R0046
Issued by: Department of the Army Materiel Command Joint Munitions Command

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a pricing worksheet for copper components included in ammunition procured under solicitation number W52P1J20R0046. The pricing worksheet provides the pounds per unit, total price per pound of copper at $2.3525, and derived price per round for 18 contract line items (CLINs) identified by DODIC codes. The CLINs cover option year pricing periods 1 through 4 for various calibers of ammunition, including 5.56mm, 7.62mm, and .50 caliber. An example calculation is shown for adjusting the baseline price per pound of copper and deriving a revised total price per round, with the requirement that any unit price change must be greater than 1% but less than 10% of the cartridge price. The related pre-solicitation notice seeks a second source supplier to produce the indicated calibers of small arms ammunition, with the supplier required to be geographically separated from the Lake City Army Ammunition Plant.

View the file

Other files

File	Type	Posted
Questions and Answers for Draft RFP W52P1J-20-R-0046.pdf	PDF	Jun 16, 2020
Attachment 0009 - Receiving and Weekly Report Instructions.xlsx	XLSX spreadsheet	May 15, 2020
Attachment 0004 - Sensitive Arms Ammunition and Explosives Classifications.pdf	PDF	May 15, 2020
Attachment 0001 - CDRL Guidance.pdf	PDF	May 15, 2020
Attachment 0007 - Contract Production Delivery Report SOW.pdf	PDF	May 15, 2020
Attachment 0013 - Small Business Participation.pdf	PDF	May 15, 2020
Attachment 0011 - 7.62mm Program Receiving and Weekly Reports.XLSX	XLSX spreadsheet	May 15, 2020
Attachment 0014 - Contractor Vendor Guide - Contract Opportunities - beta.sam.gov.pptx	PPTX presentation	May 15, 2020
Exhibit A - Small Caliber Second Source CDRLs.pdf	PDF	May 15, 2020
Attachment 0008 - Contract Delivery Schedule.xlsx	XLSX spreadsheet	May 15, 2020
Attachment 0003 - NATO SOW.pdf	PDF	May 15, 2020
DRAFT RFP W52P1J-20-R-0046 Small Calilber Second Source.pdf	PDF	May 15, 2020
Attachment 0012 - Caliber 50 Program Receiving and Weekly Reports.xlsx	XLSX spreadsheet	May 15, 2020
Attachment 0002 - OPSEC Plan Sample.pdf	PDF	May 15, 2020
Attachment 0005 - Price Matrix.xlsx	XLSX spreadsheet	May 15, 2020
Attachment 0010 - 5.56mm Program Receiving and Weekly Reports.xlsx	XLSX spreadsheet	May 15, 2020

Show all 16

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.

Attachment 0006 Proposal

Solicitation W52P1J-20-R-0046

Attachment 0006 - EPA Pricing Worksheet For Copper

CONTRACTOR:

CLIN x001 DODIC A059
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.012099
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0285

CLIN x002 DODIC A062
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.012099
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0285

CLIN x003 DODIC A080
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.009800
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0231

CLIN x004 DODIC AB56
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.015394
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0362

CLIN x005 DODIC AB57
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.015394
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0362

CLIN x006 DODIC AB58
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.015394
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0362

CLIN x007 DODIC AB77
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.015394
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0362

CLIN x008 DODIC A131
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.020762
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0488

CLIN x009 DODIC A143
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.019401
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0456

CLIN x010 DODIC AB79
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.030531
Total $ Per Lb (Copper Baseline)	$ 2.3525
Price $ per round	$ 0.0718

CLIN x011 DODIC AB86
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.031262
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0735

CLIN x012 DODIC AB82
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.030531
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.0718

CLIN x013 DODIC A555
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.116110
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2731

CLIN x014 DODIC A555 (Lead Free)
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.116110
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2731

CLIN x015 DODIC A557
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.116148
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2732

CLIN x016 DODIC A557 (Lead Free)
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.116148
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2732

CLIN x017 DODIC A576
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.116148
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2732

CLIN x018 DODIC A598
	OPTION YEAR PRICING PERIODS 1-4
Lbs Per Unit	0.086217
Total $ Per Lb (Copper Baseline)	$ 2.3525
Copper Price $ Per Round (Baseline)	$ 0.2028

EPA Calculation Example

EPA PRICING WORKSHEET FOR COPPER - ATTACHMENT 0006

CONTRACTOR:

EXAMPLE: A059 UPDATED BASELINE

Lbs Per Unit	0.012099		0.012099
Price Per Lb	$ 2.7000		$ 2.3525
Price $ Per Round	$ 0.0327		$ 0.0285
Updated Amount:	$ 0.0327
Less Original Contract Amount (proposed):	(0.0285)
Total Increase/(Decrease) per round:	$ 0.0042
Add:
Matrix price per round:	$ 0.2500
Revised Cost per round:	$ 0.2542	Does not include Freight Costs

Unit Price Change %: 2% Must be greater than 1 % of cartridge price. No greater than 10% of cartridge price.

File details come from the government source that posted it. Updated May 15, 2020.