Attachment 0002 W15QKN-25-R-0040 - Price Matrix.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
120mm Mortar Shell Bodies Federal contract opportunity
Solicitation number
W15QKN-25-R-0040
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

Written by GovTribe AI ·

This is a Price Matrix Excel file for Solicitation W15QKN-25-R-0040 for 120mm Mortar Shell Bodies, prepared by the U.S. Army Contracting Command - New Jersey. The document details production pricing for multiple types of 120mm mortar shell bodies across five ordering periods, including High Explosive (HE), Full Range Practice Cartridge (FRPC), Smoke (SMK), and Illumination (Illum) variants. The pricing matrix uses a power curve methodology to calculate unit prices based on quantity, with different pricing tiers for various production volume ranges.

The pricing structure includes both Production CLINs (Contract Line Item Numbers) and FAT (First Article Test) CLINs for each ordering period. Each CLIN covers different quantities, with quantity ranges including 10,000 to 160,000 units for HE shells, 25,000 to 180,000 units for FRPC, 4,000 to 30,000 units for Smoke shells, and 2,500 to 20,000 units for Illumination shells. The matrix allows offerors to input unit prices and includes a formula for calculating prices across different production quantities, with provisions for potential government property usage that could impact pricing.

View the file

Other files for this federal contract opportunity

Other files attached to 120mm Mortar Shell Bodies, newest first.
File Type Posted
Attachment 0005 FCDDAC1350 Technical Data Request Questionnaire.pdf PDF
DRAFT W15QKN25R0040 DRAFT.pdf PDF
Attachment 0008 FORM 3002 Clearance of Technical Information.pdf PDF
Attachment 0004 Non-Disclosure Agreement 120mm Shell Bodies.pdf PDF
Attachment 0001 Contract Quality Requirements 10 April 2025.docx DOCX document
Attachment 0010 Past Performance Assessment Questionairre.docx DOCX document
Attachment 0009 - SF_LLL.pdf PDF
Attachment 0007 Certificate of Destruction.docx DOCX document
Attachment 0006 DD 2345 Militarily Cirtical Technical Data Agreement.pdf PDF

On GovTribe

Work with this file on GovTribe

  • 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.

Production CLINs

OFFEROR NAME:= Offeror Must Fill-In Cells, where applicable
Solicitation No. W15QKN-25-R-0040= Cells Include Formulas; Do Not Change
Price Matrix
Production CLINs

OFFEROR: ASSERT WHETHER YOUR OFFER IS / IS NOT PREDICATED UPON THE USE OF GOVERNMENT PROPERTY IN YOUR POSSESSION OR ONE OF YOUR SUBCONTRACTOR'S POSSESSION: (Select response from Drop Down Menu) See solicitation instruction on Use and Rental of Government Property and FAR 52.245-9 Use and Charges.

IF YOU RESPONDED "IS" PREDICATED ON USE OF GOVERNMENT PROPERTY, COMPLETE THE GOVERNMENT PROPERTY (COLUMN G) BELOW AND APPLICABLE COLUMNS AS DETAILED ON THE TABS OF THIS WORKBOOK

Example
PROPOSED FFP PRODUCTION UNIT PRICES
(excluding rental value of Gov't property, if any)Curve Data used to Calculate Unit Prices for Quantities between Specified Quantities;
Power Curve Formula: Y=Ax^bCurved Pricing Calculator
ExampleCLINDescriptionQuantityABC Unit PriceCurve Formula Applies toABC CartridgeQuantityUnit PriceTotal Price
Slope (b)T-1 (A)Formula
XXXXABC Cartridge2,000$15,000.002,0003,999-0.09954$31,964.03Y = 31964.03 x ^-0.09952,900$14,455.38$41,920,590
4,000$14,000.004,0005,999-0.18277$63,750.92Y = 63750.92 x ^-0.1828
6,000$13,000.00
PROPOSED FFP PRODUCTION UNIT PRICES
Curve Data used to Calculate Unit Prices for Quantities between Specified Quantities;
Power Curve Formula: Y=Ax^bProduction Unit Prices - Other Than Price Points - For Future Delivery Orders
Ordering PeriodCLINDescriptionQuantityProposed Unit PricePer Unit Rental Value of Government PropertyCurve Formula Applies toUnit Price CurvesQuantityUnit PriceTotal Delivery Order Amount
Slope (b)T-1 (A)Formula
Ordering Period 11003120mm HE10,00010,00039,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
40,00040,00079,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
80,00080,000159,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
160,000ERROR:#VALUE!ERROR:#VALUE!
1004120mm FRPC25,00025,00049,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000179,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
180,000ERROR:#VALUE!ERROR:#VALUE!
1005120mm SMK4,0004,0007,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
8,0008,00015,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
16,00016,00029,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
30,000ERROR:#VALUE!ERROR:#VALUE!
1006120mm Illum2,5002,5004,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
5,0005,0009,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
10,00010,00019,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
20,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 22003120mm HE10,00010,00039,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
40,00040,00079,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
80,00080,000159,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
160,000ERROR:#VALUE!ERROR:#VALUE!
2004120mm FRPC25,00025,00049,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000179,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
180,000ERROR:#VALUE!ERROR:#VALUE!
2005120mm SMK4,0004,0007,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
8,0008,00015,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
16,00016,00029,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
30,000ERROR:#VALUE!ERROR:#VALUE!
2006120mm Illum2,5002,5004,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
5,0005,0009,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
10,00010,00019,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
20,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 33003120mm HE10,00010,00039,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
40,00040,00079,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
80,00080,000159,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
160,000ERROR:#VALUE!ERROR:#VALUE!
3004120mm FRPC25,00025,00049,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000179,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
180,000ERROR:#VALUE!ERROR:#VALUE!
3005120mm SMK4,0004,0007,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
8,0008,00015,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
16,00016,00029,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
30,000ERROR:#VALUE!ERROR:#VALUE!
3006120mm Illum2,5002,5004,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
5,0005,0009,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
10,00010,00019,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
20,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 44003120mm HE10,00010,00039,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
40,00040,00079,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
80,00080,000159,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
160,000ERROR:#VALUE!ERROR:#VALUE!
4004120mm FRPC25,00025,00049,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000179,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
180,000ERROR:#VALUE!ERROR:#VALUE!
4005120mm SMK4,0004,0007,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
8,0008,00015,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
16,00016,00029,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
30,000ERROR:#VALUE!ERROR:#VALUE!
4005120mm Illum2,5002,5004,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
5,0005,0009,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
10,00010,00019,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
20,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 55003120mm HE10,00010,00039,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
40,00040,00079,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
80,00080,000159,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
160,000ERROR:#VALUE!ERROR:#VALUE!
5004120mm FRPC25,00025,00049,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000179,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
180,000ERROR:#VALUE!ERROR:#VALUE!
5005120mm SMK4,0004,0007,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
8,0008,00015,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
16,00016,00029,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
30,000ERROR:#VALUE!ERROR:#VALUE!
5006120mm Illum2,5002,5004,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
5,0005,0009,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
10,00010,00019,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
20,000ERROR:#VALUE!ERROR:#VALUE!

FORMULA DESCRIPTION AND EXAMPLE

* Using a best fit power curve methodology, the general formula used in the pricing matrix is: Y=Ax^b

* Y = Unit Price to be calculated;

A = T-1: the theoretical unit price for the first unit (quantity of 1) based upon the associated curve formula;

x = Quantity to be ordered;

b = Slope for the applicable quantity curve between two specified quantities

* Using the example below, for 2,900 items being ordered, the formula is: Unit price = $31,964.03*2,900^-.0995

* The calculated unit price for 2,900 items is: $14,455.38

FAT CLINS

OFFEROR NAME:0= Offeror Must Fill-In Cells, where applicable
Solicitation No. W15QKN-25-R-0040= Cells Include Formulas; Do Not Change
Price Matrix
FAT CLINs

IF YOU RESPONDED "IS" PREDICATED ON USE OF GOVERNMENT PROPERTY ON THE PRODUCTION CLINS TAB OF THIS WORKBOOK, COMPLETE THE GOVERNMENT PROPERTY COLUMN G LISTED BELOW

Ordering Period CLIN Description Quantity Proposed Unit Price Per Unit Rental Value of Government Property

Ordering Period 11001Initial FAT1 Lot
1002Subsequent FAT1 Lot
Ordering Period 22001Initial FAT1 Lot
2002Subsequent FAT1 Lot
Ordering Period 33001Initial FAT1 Lot
3002Subsequent FAT1 Lot
Ordering Period 44001Initial FAT1 Lot
4002Subsequent FAT1 Lot
Ordering Period 55001Initial FAT1 Lot
5002Subsequent FAT1 Lot

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