The file's text, extracted by GovTribe without its formatting.
Instructions
| INSTRUCTIONS: Offeror shall provide material costs (metal prices) for the aluminum, steel, zinc, tungsten, and copper identified on the respective tabs of this Excel file. These costs, which must be substantiated by the offeror through its submission of supporting purchase orders, quotes, or invoices with its proposal, will serve as the baseline material cost (metal price) for each metal by cartridge. See example below. | | |
| | = Contractor Fill-In |
| ALUMINUM: | | This cell identifies the metal content for the given cartridge by pound. The component breakout for this material weight can be found on the tab for the cited cartridge (in this example, the M430A1). This cell is linked to the cartridge tab, and pulls the total weight from there (refer to formula in cell B7). The Government has provided the component breakout weights, which shall not be changed by offeror. |
| Baseline for Options 1-5: | |
| Aluminum lbs per M430A1: | 0.78190 | |
| Proposed Aluminum Unit Price per Pound (include surcharge) | $ 2.00 | |
| Proposed Aluminum EPA Baseline Price per M430A1 | $ 1.56 | |
| | Offeror shall enter its per-pound material cost in this cell for the cited metal, reflecting price paid by or quoted to offeror for the metal. Cells for the per-pound price entries are highlighted blue. |
| | This cell calculates the baseline per-cartridge material cost (metal price) for the given cartridge and metal by multiplying the per-pound price by the weight per cartridge (refer to formula in cell B9). |
Aluminum
ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT
| ALUMINUM: | |
| Baseline for Options 1-5: |
| Aluminum lbs per M430A1 (both Metal and Wood Pallet): | 0.78190 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M430A1 | $ - 0 |
| Aluminum lbs per M433: | 0.52540 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M433 | $ - 0 |
| Aluminum lbs per M583A1: | 0.41800 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M583A1 | $ - 0 |
| Aluminum lbs per M918: | 0.58974 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M918 | $ - 0 |
| Aluminum lbs per Mixed Belt: | 0.69863 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per Mixed Belt | $ - 0 |
| Aluminum lbs per M385A1: | 0.93821 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M385A1 | $ - 0 |
| Aluminum lbs per M992: | 0.41800 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M992 | $ - 0 |
| Aluminum lbs per M585: | 0.41800 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M585 | $ - 0 |
| Aluminum lbs per M661: | 0.41800 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M661 | $ - 0 |
| Aluminum lbs per M662: | 0.41800 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M662 | $ - 0 |
| Aluminum lbs per M433E1: | 0.35300 |
| Proposed Aluminum Unit Price per Pound (include surcharge) | |
| Proposed Aluminum EPA Baseline Price per M433E1 | $ - 0 |
Steel
ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT
| STEEL: | |
| Baseline for Options 1-5: |
| Steel lbs per M430A1 (Metal Pallet): | 0.91545 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M430A1 | $ - 0 |
| Steel lbs per M430A1 (Wood Pallet): | 0.84179 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M430A1 | $ - 0 |
| Steel lbs per M433: | 0.14150 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M433 | $ - 0 |
| Steel lbs per M583A1: | 0.26136 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M583A1 | $ - 0 |
| Steel lbs per M918: | 1.18062 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M918 | $ - 0 |
| Steel lbs per Mixed Belt: | 0.98525 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per Mixed Belt | $ - 0 |
| Steel lbs per M385A1: | 0.55545 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M385A1 | $ - 0 |
| Steel lbs per M992: | 0.26136 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M992 | $ - 0 |
| Steel lbs per M585: | 0.26136 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M585 | $ - 0 |
| Steel lbs per M661: | 0.26136 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M661 | $ - 0 |
| Steel lbs per M662: | 0.26136 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M662 | $ - 0 |
| Steel lbs per M433E1: | 0.61479 |
| Proposed Steel Unit Price per Pound (include surcharge) | |
| Proposed Steel EPA Baseline Price per M433E1 | $ - 0 |
Zinc
ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT
| ZINC: | |
| Baseline for Options 1-5: |
| Zinc lbs per M781: | 0.38220 |
| Proposed Zinc Unit Price per Pound (include surcharge) | |
| Proposed Zinc EPA Baseline Price per M781 | $ - 0 |
Tungsten
ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT
| TUNGSTEN: | |
| Baseline for Options 1-5: |
| Tungsten lbs per M433E1: | 0.20000 |
| Proposed Tungsten Unit Price per Pound (include surcharge) | |
| Proposed Tungsten EPA Baseline Price per M433E1 | $ - 0 |
Copper
| ATTACHMENT 0002 – ECONOMIC PRICE ADJUSTMENT | |
| COPPER: | |
| Baseline for Options 1-5: |
| Copper lbs per M430A1 (both Metal and Wood Pallet): | 0.08157 |
| Proposed Copper Unit Price per Pound (include surcharge) | |
| Proposed Copper EPA Baseline Price per M430A1 | $ - 0 |
| Copper lbs per M433: | 0.03086 |
| Proposed Copper Unit Price per Pound (include surcharge) | |
| Proposed Copper EPA Baseline Price per M433 | $ - 0 |
| Copper lbs per M918: | 0.03307 |
| Proposed Copper Unit Price per Pound (include surcharge) | |
| Proposed Copper EPA Baseline Price per M918 | $ - 0 |
| Copper lbs per M385A1: | 0.03307 |
| Proposed Copper Unit Price per Pound (include surcharge) | |
| Proposed Copper EPA Baseline Price per M385A1 | $ - 0 |
| Copper lbs per M433E1 | 0.02866 |
| Proposed Copper Unit Price per Pound (include surcharge) | |
| Proposed Copper EPA Baseline Price per M433E1 | $ - 0 |
M430A1 (Metal Pallet) M430A1 (Metal Pallet)
| Component | Part # | Material | Weight (lbs) | Weight (g) |
| Aluminum Components | Cartridge Case, 40mm, M169 | 8886329 | Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221 | 0.21700 | 98.42946 |
| Base Plug | 13063219 | Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211 | 0.04860 | 22.04457 |
| Bottom Plate | 9287890 | Aluminum Alloy, Rod, Alloy No. 7075, Temper T6, Per Spec ASTM B211 | 0.02830 | 12.83665 |
| Centerplate | 12944723 | Al Aly, Sheet, 6061-T0 Per ASTM B209 | 0.02300 | 10.43262 |
| Ogive | 12944735 | Aluminum Alloy, Rod, 6061-T0 Per ASTM B211, ALTERNATE MATERIAL: Aluminum Alloy, Rod 6061-T0 Per ASTM B221 | 0.46500 | 210.92028 |
| | | Total Aluminum Weight | 0.78190 | 354.66358 |
| Steel Components | Body | 9287855 | Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized | 0.36000 | 163.29312 |
| Link | 11691395 | Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684 | 0.02866 | 12.99999 |
| Metal Pallet | - | Steel | 0.07366 | 33.41194 |
| PA120 Ammo Can | - | Steel | 0.45313 | 205.53404 |
| | | Total Steel Weight | 0.91545 | 415.23909 |
| Copper Components | Copper Band | 8886402 | Copper, Tubing, Seamless, Annealed, SPEC ASTM B75 | 0.03307 | 15.00000 |
| Copper Liner | - | Dwg 12926813 | 0.04850 | 22.00000 |
| | | Total Copper Weight | 0.08157 | 37.00000 |
M430A1 (Wood Pallet) M430A1 (Wood Pallet)
| Component | Part # | Material | Weight (lbs) | Weight (g) |
| Aluminum Components | Cartridge Case, 40mm, M169 | 8886329 | Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221 | 0.21700 | 98.42946 |
| Base Plug | 13063219 | Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211 | 0.04860 | 22.04457 |
| Bottom Plate | 9287890 | Aluminum Alloy, Rod, Alloy No. 7075, Temper T6, Per Spec ASTM B211 | 0.02830 | 12.83665 |
| Centerplate | 12944723 | Al Aly, Sheet, 6061-T0 Per ASTM B209 | 0.02300 | 10.43262 |
| Ogive | 12944735 | Aluminum Alloy, Rod, 6061-T0 Per ASTM B211, ALTERNATE MATERIAL: Aluminum Alloy, Rod 6061-T0 Per ASTM B221 | 0.46500 | 210.92028 |
| | | Total Aluminum Weight | 0.78190 | 354.66358 |
| Steel Components | Body | 9287855 | Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized | 0.36000 | 163.29312 |
| Link | 11691395 | Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684 | 0.02866 | 12.99999 |
| PA120 Ammo Can | - | Steel | 0.45313 | 205.53404 |
| | | Total Steel Weight | 0.84179 | 381.82715 |
| Copper Components | Copper Band | 8886402 | Copper, Tubing, Seamless, Annealed, SPEC ASTM B75 | 0.03307 | 15.00000 |
| Copper Liner | - | Dwg 12926813 | 0.04850 | 22.00000 |
| | | Total Copper Weight | 0.08157 | 37.00000 |
M433 M433
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | Skirt | 8886344 | Tubing, Aluminum Alloy, 6061-T4. Die and Mandrel Extruded from Hollow Billet, Such as ASTM B210 or ASTM B241 | 0.19040 | 86.36392 |
| M118 Cartridge Case | 8844610 | ALUMINUM ALLOY, 6066 CHEMICAL COMPOSITION IN ACCORDANCE WITH TABLE 1 OF SPEC ASTM B221 | 0.19900 | 90.26481 |
| Ogive | 8886350 | Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209 | 0.02610 | 11.83875 |
| Centerplate | 9266693 | Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209 | 0.02300 | 10.43262 |
| Fuze Body | 8886356 | Aluminum Alloy, Rod, 6061-0, ASTM B211, B221 or B209 | 0.08690 | 39.41714 |
| | | Total Aluminum Weight | 0.52540 | 238.31724 |
| Steel Components | Boattail cup | 9276546 | Steel, strip, Aluminum killed, 1009, Deep draw quality, Spec QQ-S-698. | 0.12500 | 56.69900 |
| Retaining ring | 8886340 | Steel, strip, High Carbon, Cold rolled, Spring Quality, Spec ASTM A684 | 0.01650 | 7.48427 |
| | | Total Steel Weight | 0.14150 | 64.18327 |
| Copper Component | Copper Liner | - | Dwg 9276544 | 0.03086 | 14.00000 |
| | | Total Copper Weight | 0.03086 | 14.00000 |
M583A1 M583A1
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | M195 Cartridge Case | 9207989 | Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221 | 0.18500 | 83.91452 |
| Body | 9243900 | Aluminum Alloy, 6061, Temper 0, ASTM B221 | 0.23300 | 105.68694 |
| | | Total Aluminum Weight | 0.41800 | 189.60146 |
| Steel Component | M2A2 Ammo Can | - | Steel | 0.26136 | 118.55253 |
| | | Total Steel Weight | 0.26136 | 118.55253 |
M781 M781
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Zinc Component | Body, 40mm, Practice Round | 9310344 | Zinc Alloy, Type Ag40A OR AC41A, in accordance with ASTM B86 | 0.38220 | 173.36286 |
| | | Total Zinc Weight | 0.38220 | 173.36286 |
M918 M918
| Component | Part Number | Material | Weight (lbs) | Weight (g) |
| Aluminum Components | Cartridge Case, 40mm, M169 | 8886329 | Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221 | 0.18289 | 82.958801656 |
| Base Plug | 13063219 | Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211 | 0.02504 | 11.357036496 |
| Body Insert | 9399382 | Aluminum Rod Alloy, 6061-T6 or Alloy 7075-T6 Per Spec ASTM-B211 | 0.254060 | 115.23958352 |
| Firing Pin Plate | 9399393 | Aluminum Alloy Sheet, 6061-T6 Per Spec ASTM-B209 | 0.013649 | 6.1909734576 |
| Top Plate | 8886359 | Aluminum Alloy, Sheet, 7075, Temper T6 per ASTM B209 | 0.009621 | 4.3641674979 |
| Detonator Cup | 8798332 | Aluminum Alloy, 1100, Temper 0, ASTM B209 | 0.000051 | 0.0229972345 |
| Closing Disc | 8798333 | Aluminum Foil, QQ-A-1876 | 0.000005 | 0.0023586907 |
| Ogive, M918TP | 9399394 | Aluminum Alloy 6061, Temper 0 Per Spec ASTM B211. Alternate Material: Aluminum Alloy 6061, Temper 0 Per Spec ASTM B221. | 0.104419 | 47.3636889289 |
| | | Total Aluminum Weight | 0.58974 | 267.49961 |
| Steel Components | Body | 9299396 | Steel, Strip, Cold Rolled, Type 1009, Aluminum Killed, Spherodized | 0.623000 | 282.58782 |
| Detent Spring | 8886362 | Wire, Steel, Corrosion-Resisting, QQ-W-423 | 0.00006 | 0.02823 |
| Verge Arbor | 8886367 | Steel, Corrosion Resistant, Round, Type 303, ASTM A-581 | 0.00016 | 0.07067 |
| Pinion | 8886369 | Wire, Steel, Corrosion Resisting, Class 416 | 0.00015 | 0.06969 |
| Rotor Shaft | 9219876 | Steel, Bar, Corrosion Resisting, Class 416 | 0.00037 | 0.16697 |
| Setback Pin | 12999562 | Steel Cold Drawn, Grade 1213 or 12L14 per ASTM A108 | 0.000683 | 0.30958 |
| Firing Pin | 9399392 | Stainless Steel, Type 416 Round, Annealed and Cold Drawn Wire Per ASTM A581 or ASTM A582 | 0.000755 | 0.34260 |
| Link | 11691395 | Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684 | 0.02866 | 12.99999 |
| PA120 Ammo Can | - | Steel | 0.45313 | 205.53388 |
| Metal Pallet | - | Steel | 0.07366 | 33.41191 |
| | | Total Steel Weight | 1.18062 | 535.52133 |
| Copper Component | Copper | 8886402 | Copper, Tubing, Seamless, Annealed, SPEC ASTM B75 | 0.03307 | 15.00000 |
| | | Total Copper Weight | 0.03307 | 15.00000 |
Mixed Belt Mixed Belt (22:10 ratio M918 to M385A1)
| | per ctg | per belt | | Total Aluminum Weight (g) | Total Aluminum Weight (lbs) |
| Aluminum Components | M918 | 267.49961 | 22 | 5884.99136 | 316.8950438661 | 0.6986331516 |
| M385A1 | 425.565003912 | 10 | 4255.65004 | | |
| | Total | 32 | 10140.64140 | | |
| | per ctg | per belt | | Total Steel Weight (g) | Total Steel Weight (lbs) |
| Steel Components | M918 | 535.52133 | 22 | 11781.46926 | 446.9039698284 | 0.98525343 |
| M385A1 | 251.9457777935 | 10 | 2519.45778 | | |
| | Total | 32 | 14300.92703 | | |
M385A1 M385A1
| Component | Part Number | Material | Weight (lbs) | Weight (g) |
| Aluminum Components | Cartridge Case, 40mm, M169 | 8886329 | Aluminum Alloy 6066-T6, Chemical Comp, Table I, Tensile Properties Table 2 of SPEC. ASTM B221 | 0.18289 | 82.958801656 |
| Base Plug | 13063219 | Aluminum Alloy 7075-T6 per Spec ASTM B221. Alternate Material: Aluminum Alloy 7075-T6 Per Spec ASTM B211 | 0.02504 | 11.357036496 |
| Body | 8866715 | Aluminum Alloy Bar, 2024, T351 ASTM B211 | 0.73028 | 331.24917 |
| | | Total Aluminum Weight | 0.93821 | 425.56500 |
| Steel Components | Link | 11691395 | Steel, Carbon, Strip, Cold Rooled Soft, Untempered Spring Quality, Annealed, 1050, ASTM A684 | 0.02866 | 12.9999920792 |
| PA120 Ammo Can | - | Steel | 0.45313 | 205.53388 |
| Metal Pallet | - | Steel | 0.07366 | 33.41191 |
| | | Total Steel Weight | 0.55545 | 251.94578 |
| Copper Component | Copper | 8886402 | Copper, Tubing, Seamless, Annealed, SPEC ASTM B75 | 0.03307 | 15.00000 |
| | | Total Copper Weight | 0.03307 | 15.00000 |
M992 M992
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | M195 Cartridge Case | 9207989 | Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221 | 0.18500 | 83.91452 |
| Body | 9243900 | Aluminum Alloy, 6061, Temper 0, ASTM B221 | 0.23300 | 105.68694 |
| | | Total Aluminum Weight | 0.41800 | 189.60146 |
| Steel Component | M2A2 Ammo Can | - | Steel | 0.26136 | 118.55244 |
| | | Total Steel Weight | 0.26136 | 118.55244 |
M585 M585
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | M195 Cartridge Case | 9207989 | Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221 | 0.18500 | 83.91452 |
| Body | 9243900 | Aluminum Alloy, 6061, Temper 0, ASTM B221 | 0.23300 | 105.68694 |
| | | Total Aluminum Weight | 0.41800 | 189.60146 |
| Steel Component | M2A2 Ammo Can | - | Steel | 0.26136 | 118.55244 |
| | | Total Steel Weight | 0.26136 | 118.55244 |
M661 M661
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | M195 Cartridge Case | 9207989 | Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221 | 0.18500 | 83.91452 |
| Body | 9243900 | Aluminum Alloy, 6061, Temper 0, ASTM B221 | 0.23300 | 105.68694 |
| | | Total Aluminum Weight | 0.41800 | 189.60146 |
| Steel Component | M2A2 Ammo Can | - | Steel | 0.26136 | 118.55244 |
| | | Total Steel Weight | 0.26136 | 118.55244 |
M662 M662
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | M195 Cartridge Case | 9207989 | Aluminum Alloy, 6066 Chemical Composition IAW Table 1 of Spec ASTM B221 | 0.18500 | 83.91452 |
| Body | 9243900 | Aluminum Alloy, 6061, Temper 0, ASTM B221 | 0.23300 | 105.68694 |
| | | Total Aluminum Weight | 0.41800 | 189.60146 |
| Steel Component | M2A2 Ammo Can | - | Steel | 0.26136 | 118.55244 |
| | | Total Steel Weight | 0.26136 | 118.55244 |
M433E1 M433E1
| Component | Part # | Material | Weight (lb) | Weight (g) |
| Aluminum Components | Cartridge Case | 13061668 | ALUMINUM ALLOY, 6066 CHEMICAL COMPOSITION IN ACCORDANCE WITH TABLE 1 OF SPEC ASTM B221 | 0.21700 | 98.42946 |
| Ogive | 8886350 | Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209 | 0.02610 | 11.83875 |
| Centerplate | 9266693 | Aluminum Alloy, Sheet 6061, Temper 0, ASTM B209 | 0.02300 | 10.43262 |
| Fuze Body | 13061660 | Aluminum Alloy, Rod, 6061-0, ASTM B211, B221 or B209 | 0.08690 | 39.41714 |
| | | Total Aluminum Weight | 0.35300 | 160.11798 |
| Steel Components | Pusher Liner | 13061666 | AISI 316/316L per AMS 5648, AMS 5653, ASTM A276 | 0.35343 | 160.31265 |
| M2A2 Ammo Can | - | Steel | 0.26136 | 118.55244 |
| | | Total Steel Weight | 0.61479 | 278.86508 |
| Copper Component | Copper Liner | - | Dwg 13061662 | 0.02866 | 13.00000 |
| | | Total Copper Weight | 0.02866 | 13.00000 |
| Tungsten Component | Pellet | 13061665 | Tungsten-Nickel-Iron Alloy, Approx Mass: 2 grains, Approx Density: 18.5g/cc | 0.20000 | 90.71839 |
| | | Total Tungsten Alloy Weight | 0.20000 | 90.71839 |