B08 - ATTACH_0007-EPA Adjustment Worksheet.xlsx

This is a pricing adjustment worksheet template for EPA (Environmental Price Adjustment) evaluations associated with M82 and M82A1 Percussion Primer production under CLIN 0002 of contract W519TC-23-R-0012. The worksheet provides separate pricing structures for both brass and steel primer cases across four ordering periods (Periods 2-5), with tiered volume brackets ranging from 55,000 to 1,255,000 units. Contractors are required to input pricing per ounce and per primer unit for each volume tier and ordering period, with the template currently populated with placeholder values of $0.00.

The adjustment worksheet calculates material cost changes by comparing updated brass and steel prices per pound against original contract amounts, then determines the resulting increase or decrease per cartridge and the corresponding percentage change. The worksheet includes logic to evaluate whether price adjustments fall within a 10% threshold tolerance. This is a blank template document designed for use by offerors responding to solicitation W519TC-25-R-0016, which seeks two IDIQ contracts for percussion primer production across five twelve-month ordering periods using fixed price with economic price adjustment (FPEA) evaluation criteria.