B08 - ATTACH_0009-EPA Adjustment Worksheet.xlsx

23 KB Posted

Attached to
The Family of Hand Held Signals
Solicitation number
W519TC-23-R-0080
Issued by

About this file

Written by GovTribe AI ·

This is an EPA Adjustment Worksheet template used for pricing adjustments on a contract for hand-held illumination signals, specifically for magnesium powder and raw material costs. The worksheet provides a structured methodology for calculating and applying Economic Price Adjustment (EPA) clauses to contract line items (CLINs), with examples demonstrating how price fluctuations in raw materials trigger automatic contract price adjustments based on predetermined thresholds.

The worksheet applies to two primary CLINs: CLIN 0002 for cluster production (M125A1, M158, and M159 star clusters) and CLIN 0004 for parachute production (M126A1, M127A1, and M195 star parachutes), covering ordering periods 2 through 5. The pricing structure is tiered by magnesium powder purchase quantity (5,000-29,999 grams; 30,000-54,999 grams; 55,000-74,999 grams; and 75,000-100,000 grams), with unit prices and per-gram rates. The template includes examples demonstrating EPA calculations: increases exceeding 10% are capped at 10%, adjustments between 3% and 10% are permitted in full, decreases between -3% and -10% are allowed, and adjustments less than 3% in either direction are not applied. The worksheet also contains incomplete sections for steel and brass pricing adjustments, indicating applicability to additional raw materials. This document is part of solicitation W519TC-23-R-0080 for Family of Hand Held Signals, which is a five-year IDIQ contract with fixed pricing and EPA provisions, issued as a 100% total Women-Owned Small Business set-aside.

View the file

Other files

File Type Posted
W519TC23R0080-0002.pdf PDF
W519TC23R0080-0001.pdf PDF
B08 - ATTACH_0010_Performance Assessment Questionnaire.pdf PDF
B08 - ATTACH_0008_GFM_Instructions_Accountability SOW.pdf PDF
B08 - ATTACH_0004_OPSEC SOW.pdf PDF
W519TC23R0080.pdf PDF
B08 - Exhibit A_HHS_CDRLS.pdf PDF
B08 - ATTACH_0012_PA142 Sketch File.pdf PDF
B08 - ATTACH_0011_Production_Shipping Receipt Forecast Template HHS_JMC.xlsx XLSX spreadsheet
B08 - ATTACH_0005_OPSEC ACQUISITIONS PLAN.pdf PDF
B08 - ATTACH_0001_Hand Signals Pricing Matrix_final_locked.xlsx XLSX spreadsheet
B08 - ATTACH_0007_Listing_of_Government_Furnished_Material.pdf PDF
B08 - ATTACH_0003_COCO SECURITY STATEMENT OF WORK 2023.pdf PDF
B08 - ATTACH_0002_CDRL GUIDANCE.pdf PDF
B08 - ATTACH_0006_HAZARDOUS_WARNING_LABEL.pdf PDF
Show all 15

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 MAG POWDER

Attachment 0011 -- EPA Worksheet

CONTRACTOR:
DATE:
CLIN 0002: CLUSTER PRODCUTION
M125A1, M158, AND M159Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 4
HHS-ClusterHHS-ClusterHHS-ClusterHHS-Cluster
Magnesium PowderMagnesium PowderMagnesium PowderMagnesium Powder
Gms Per Unit
Price Per Gm5,000 - 29,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm30,000 - 54,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm55,000 - 74,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm75,000 - 100,000
Price $ per Signal$0.00$0.00$0.00$0.00
CLIN 0004 - PARACHUTE PRODUCTION
M126A1, M127A1, AND M195Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
HHS-ParachuteHHS-ParachuteHHS-ParachuteHHS-Parachute
Magnesium PowderMagnesium PowderMagnesium PowderMagnesium Powder
GmsPer Unit
Price Per Gm5,000 - 29,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm30,000 - 54,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm55,000 - 74,999
Price $ per Signal$0.00$0.00$0.00$0.00
Price Per Gm55,000 - 74,999
Price $ per Signal$0.00$0.00$0.00$0.00

EPA Adj. Worksheet Example

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

Delivery Order Quantity 10,000Delivery Order Quantity 10,000Delivery Order Quantity 10,000
Ordering Period Unit Price (5,000 - 29,999)$100.00* from Att 0001Ordering Period Unit Price (5,000 - 29,999)$100.00* from Att 0001Ordering Period Unit Price (5,000 - 29,999)$100.00* from Att 0001

Updated Proposed Updated Proposed Updated Proposed

Grams Per Unit6363Grams Per Unit6363Grams Per Unit6363
Price Per Gm$ 0.98$ 0.79Price Per Gm$ 0.91$ 0.79Price Per Gm$ 0.70$ 0.79
* Current Price* From Mag Powder tab* Current Price* From Mag Powder tab* Current Price* From Mag Powder tab

Total $ Per Gm $ 0.98 $ 0.79 Total $ Per Lb $ 0.91 $ 0.79 Total $ Per Gm $ 0.70 $ 0.79

Price $ Per Signal $ 61.74 $ 49.77 Price $ Per Signal $ 57.33 $ 49.77 Price $ Per Signal $ 44.10 $ 49.77

Updated amount:$ 61.74Updated amount:$ 57.33Updated amount:$ 44.10
Less Original Contract Amount:$ 49.77Less Original Contract Amount:$ 49.77Less Original Contract Amount:$ 49.77
Unit Price Increase or Decrease$ 11.97Unit Price Increase or Decrease$ 7.56Unit Price Increase or Decrease$ (5.67)
Ordering Period Unit Price$100.00Ordering Period Unit Price$100.00Ordering Period Unit Price$100.00
Adjusted Unit Price based on Mag Powder Increase/Decrease$ 111.97$ 107.56Adjusted Price based on Mag Powder Increase/Decrease$ 94.33
Adjusted Price based on Mag Powder Increase/Decrease
Unit Price Percentage Increase/Decrease:11.97%Unit Price Percentage Increase/Decrease:7.56%Unit Price Percentage Increase/Decrease:-5.67%
Percent is Greater than or equal to 3%YesPercent is Greater than or equal to 3%YesPercent is Greater than or equal to -3%Yes
Percent is Less than or Equal to 10%NoPercent is Less than or Equal to 10%YesPercent is Less than or Equal to -10%Yes
Order QuantityUnit PriceExtendedOrder QuantityUnit PriceExtendedOrder QuantityUnit PriceExtended
10,000$ 111.97$ 1,119,700.0010,000$ 107.56$ 1,075,600.0010,000$ 94.33$ 943,300.00
10,000$ 100.00$ 1,000,000.0010,000$ 100.00$ 1,000,000.0010,000$ 100.00$ 1,000,000.00
Total Price Adjustment$ 119,700.00Total Price Adjustment$ 75,600.00Total Price Adjustment$ (56,700.00)
Allowed Increase
IAW H0005 the increase would be limited to a 10% increaseSee Below$ 100,044.00IAW H0005 the price adjustment can be made for the Total Price Adjustment amount since it is greater than 3% but does not exceed 10%IAW H0005 the price adjustment would result in a price decrease of $75,690.00

EXAMPLE (10%)

Delivery Order Quantity 10,000
Ordering Period Unit Price (5,000 - 29,999)$100.00* from Att 0001

Updated Proposed

Grams Per Unit6363
Price Per Gm$ 0.949$ 0.79
* Current Price* From Mag Powder tab

Total $ Per Gm $ 0.95 $ 0.79

Price $ Per Signal $ 59.77 $ 49.77

Updated amount:$ 59.77
Less Original Contract Amount:$ 49.77
Unit Price Increase or Decrease$ 10.00
Ordering Period Unit Price$100.00
Adjusted Unit Price based on Mag Powder Increase/Decrease$ 110.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$ 110.00$ 1,100,044.00
10,000$ 100.00$ 1,000,000.00
Total Price Adjustment$ 100,044.00

EPA Adjustment Worksheet

PRICE EVALUATION SHEET
W519TC-23-R-0012PGU/M1 Solicitation
Offeror:0
Cage Code:0
EPA PRICING WORKSHEET FOR STEELEPA PRICING WORKSHEET FOR Brass
UpdatedProposedUpdatedProposed
Lbs Per UnitLbs Per Unit
Price Per LbPrice Per Lb

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

Price $ Per XXX$ - 0$ - 0Price $ Per XXX$ - 0$ - 0
Updated amount:$ - 0Updated amount:$ - 0
Less Original Contract Amount:$ - 0Less Original Contract Amount:$ - 0
Total Increase/(Decrease) Per cartridge:$ - 0Total Increase/(Decrease) Per cartridge:$ - 0
Add:Add:
BYO Cost Per cartridge:$ - 0BYO Cost Per cartridge:$ - 0
Revised Cost Per cartridge:$ - 0Revised Cost Per cartridge:$ - 0
Revised Cost Per cartridge:$ - 0Revised Cost Per cartridge:$ - 0
Less BYO Base Cost Per cartridge:$ - 0Less BYO Base Cost Per cartridge:$ - 0
Increase in cartridges$ - 0Increase in cartridges$ - 0
Increase in cartridges$ - 0Increase in cartridges$ - 0
Divide by BYO Base Cost Per cartridge$ - 0Divide 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 .