RFP Attachment 0002 - EPA Content Factors and EPA Calculation Worksheet.xlsx

26 KB Posted

Attached to
Draft Request for Proposal (RFP) for 5. 56mm, 7. 62mm, and Caliber . 50 Ammunition Production - NOTE: This is a Draft RFP ONLY (See Description Section)
Solicitation number
W519TC-25-R-0034
Issued by

About this file

Written by GovTribe AI ·

This Excel document is an EPA (Economic Price Adjustment) Copper Content and Calculation Worksheet for RFP W519TC-25-R-0034, which covers ammunition production. The file details 17 Contract Line Item Numbers (CLINs) with specific DODIC codes, each representing different delivery order quantities ranging from 2-5 pounds per unit, with a consistent copper baseline price of $4.64 per pound. The worksheet includes a calculation method for adjusting copper pricing, with provisions that any price change must exceed 1% but not exceed 10% for unit prices.

The associated federal contract opportunity is a Draft Request for Proposal seeking a Small Caliber Second Source supplier to produce 5.56mm, 7.62mm, and .50 caliber ammunition. The procurement is a restricted competition limited to the United States, its outlying areas, or Canada, with the supplier required to be geographically separated from the Lake City Army Ammunition Plant. The draft RFP is currently in a comment and feedback phase, with industry comments due by July 18, 2025, and the final RFP anticipated for release in August 2025 by the Department of the Army Materiel Command Contracting Command at Rock Island Arsenal.

View the file

Other files

File Type Posted
RFP Attachment 0019 - Draft RFP Comment-Question and Answer Template.xlsx XLSX spreadsheet
RFP Attachment 0003 - Sensitive Arms Ammunition Explosive Classifications and SOW.pdf PDF
RFP Exhibit A - Small Caliber Second Source CDRLs.pdf PDF
RFP Attachment 0004 - OPSEC Plan Sample.pdf PDF
RFP Attachment 0014 - SAM.gov Vendor Information Guide.pptx PPTX presentation
RFP Attachment 0007 - Production Delivery GFM Reporting SOW.pdf PDF
RFP Attachment 0016 - Past Performance Contract References.xlsx XLSX spreadsheet
RFP Attachment 0019 - Draft RFP Comment-Question and Answer Template.xlsx XLSX spreadsheet
RFP Attachment 0005 - Ammunition Data Card Component Listing.pdf PDF
RFP Attachment 0018 - Supply Chain Mapping Data Template.xlsx XLSX spreadsheet
RFP Attachment 0001 - Small Caliber Second Source Price Matrix.xlsx XLSX spreadsheet
RFP Attachment 0008 - Contract Delivery Schedule Template.xlsx XLSX spreadsheet
RFP Attachment 0015 - Small Business Participation Commitment Document .pdf PDF
RFP Attachment 0011 - 7.62mm Program Receiving and Weekly Reports.xlsx XLSX spreadsheet
RFP Attachment 0009 - Receiving and Weekly Report Instructions.xlsx XLSX spreadsheet
RFP Attachment 0012 - Caliber 50 Program Receiving and Weekly Reports.xlsx XLSX spreadsheet
RFP Attachment 0013 - CDRL Guidance.pdf PDF
RFP Attachment 0006 - NATO Production Test SOW.pdf PDF
W519TC-25-R-0034 DRAFT RFP.pdf PDF
RFP Attachment 0010 - 5.56mm Program Receiving and Weekly Reports.xlsx XLSX spreadsheet
RFP Attachment 0017 - Commercial Reference Past Performance Questionnaire.docx DOCX document
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 Copper Content and Baseline

RFP W519TC-25-R-0034
Attachment 0002 - EPA Copper Content Factors and EPA Calculation Worksheet
May 19, 2025

CONTRACTOR:

CLIN x001 DODIC A059
DELIVERY ORDERS 2-5
Lbs Per Unit0.012099
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0561
CLIN x002 DODIC A062
DELIVERY ORDERS 2-5
Lbs Per Unit0.012099
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0561
CLIN x003 DODIC A080
DELIVERY ORDERS 2-5
Lbs Per Unit0.009800
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0455
CLIN x004 DODIC AB56
DELIVERY ORDERS 2-5
Lbs Per Unit0.015394
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0714
CLIN x005 DODIC AB57
DELIVERY ORDERS 2-5
Lbs Per Unit0.015394
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0714
CLIN x006 DODIC AB77
DELIVERY ORDERS 2-5
Lbs Per Unit0.015394
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0714
CLIN x007 DODIC A131
DELIVERY ORDERS 2-5
Lbs Per Unit0.020762
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0963
CLIN x008 DODIC A151
DELIVERY ORDERS 2-5
Lbs Per Unit0.025252
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.1172
CLIN x009 DODIC A143
DELIVERY ORDERS 2-5
Lbs Per Unit0.019401
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.0900
CLIN x010 DODIC AB79
DELIVERY ORDERS 2-5
Lbs Per Unit0.030531
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ per round$ 0.1417
CLIN x011 DODIC AB86
DELIVERY ORDERS 2-5
Lbs Per Unit0.031262
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.1451
CLIN x012 DODIC AB82
DELIVERY ORDERS 2-5
Lbs Per Unit0.030531
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.1417
CLIN x013 DODIC A552
DELIVERY ORDERS 2-5
Lbs Per Unit0.116110
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.5388
CLIN x014 DODIC A555
DELIVERY ORDERS 2-5
Lbs Per Unit0.116110
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.5388
CLIN x015 DODIC A557
DELIVERY ORDERS 2-5
Lbs Per Unit0.116148
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.5389
CLIN x016 DODIC A576
DELIVERY ORDERS 2-5
Lbs Per Unit0.116148
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.5389
CLIN x017 DODIC A598
DELIVERY ORDERS 2-5
Lbs Per Unit0.086217
Total $ Per Lb (Copper Baseline)$ 4.6400
Copper Price $ Per Round (Baseline)$ 0.4000

EPA Calculation Worksheet

EPA PRICING WORKSHEET FOR COPPER - RFP ATTACHMENT 0002
CONTRACTOR:

EXAMPLE: A059 COPPER UPDATED BASELINE

Lbs Per Unit0.0120990.012099
Price Per Lb$ 5.2500$ 4.6400
Price $ Per Round$ 0.0635$ 0.0561
Updated Amount:$ 0.0635
Less Original Contract Amount:$ (0.0561)
Total Increase/(Decrease) per round for Copper:$ 0.0074
Add:
Matrix price per round:$ 0.5000
Adjusted Cost per round for Copper:$ 0.5074
Unit Price Change % Copper:1.476%
* There shall be no adjustment for any change in CLIN unit price(s) for Copper which would not result in a
net change of one percent (1%) or more of the CLIN unit price as provided in the Small Caliber Second Source Price Matrix (Attachment 0001).
** The increase for Copper for any Ordering Period 2-4 CLIN unit price
shall not exceed ten percent (10%) of the firm-fixed CLIN unit price provided in the Small Caliber Second Source Price Matrix (Attachment 0001).
*** There is no percentage limitation on the amount of decreases that may be made through this Copper EPA application.

File details come from the government source that posted it. Updated .