Attachment_0011___Price_Matrix.xlsx

28 KB Posted

Attached to
M739A1 Point Detonating/Delay (PD/DLY) Fuze
Solicitation number
W15QKN25R0002
Issued by

About this file

Written by GovTribe AI ·

The file is a Price Matrix Excel spreadsheet for Solicitation No. W15QKN-25-R-0002, detailing pricing for the M739A1 Point Detonating/Delay (PD/DLY) Fuze. The document provides a complex pricing structure using a power curve formula (Y=Ax^b) for production unit prices across five ordering periods, with quantities ranging from 50,000 to 800,000 units. The pricing matrix includes First Article Test (FAT) CLINs and Production CLINs, allowing offerors to propose unit prices with options to account for government property usage.

The solicitation is for a fuze used in 105mm and 155mm artillery projectiles, primarily for training and tactical operations by the US Army, USMC, and SOCOM. The M739A1 PD/DLY Fuze features a one-piece solid aluminum body with a 2-inch threaded base, incorporating five modular subassemblies and an Impact Delay Module (IDM) that provides a 3-6 millisecond delay function. The fuze is anodized green for Explosive Ordnance Disposal (EOD) identification. The contract is managed by the Department of the Army Materiel Command Contracting Command at Picatinny Arsenal, with the pricing matrix designed to accommodate varying production quantities through a sophisticated pricing methodology.

View the file

Other files

File Type Posted
Attachment 0012 - Certificate of Destruction.docx DOCX document
W15QKN25R0002-0002.pdf PDF
Attachment_0008___NonDisclosure_NonUseAgreement__NDA_.docx DOCX document
W15QKN25R0002-0001.pdf PDF
Attachment_0008___NonDisclosure_NonUseAgreement__NDA_.docx DOCX document
Attachment_0008___NonDisclosure_NonUseAgreement__NDA_.docx DOCX document
W15QKN25R0002.pdf PDF
Exhibit_A___CDRLS_A001_to_A023_Signed_RFP.pdf PDF
Attachment_0007___SF_LLL_Disclosure_of_Lobbying_Activities.pdf PDF
Attachment_0004___Data_Item_Description_Index.docx DOCX document
Attachment_0013___Past_Performance_Letter_and_Questionnaire.docx DOCX document
Attachment_0005___HCSDS_Index__Multiple_HCSDS__M739A1_Fuze.docx DOCX document
Attachment_0003___Additional_Solicitation_Contract_Requirements.docx DOCX document
Attachment_0008___NonDisclosure_NonUseAgreement__NDA_.docx DOCX document
Attachment_0010___AMSTA_AR_Form_1350_TechDataReqQuestionnaire.docx DOCX document
Attachment_0012___Certificate_of_Destruction.docx DOCX document
Attachment_0001___Technical_Data_Package_Info_for_M739A1_PD_DLY_Fuze_RFP.docx DOCX document
Attachment_0009___DD_2345_Militarily_Critical_Technical_Data_Agreement_Form.pdf PDF
Attachment_0002___Contract_Quality_Addendum__M739A1_Fuze_.docx DOCX document
Attachment_0006___Form_3002_Clearance_of_Tech_Information.pdf PDF
Show all 20

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.

Production CLINs

OFFEROR NAME:= Offeror Must Fill-In Cells, where applicable
Solicitation No. W15QKN-25-R-0002= 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 Cartridge 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 11003M739A1 PD/DLY Fuze - Production50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000149,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
150,000150,000299,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
300,000300,000449,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
450,000450,000799,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
800,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 22003M739A1 PD/DLY Fuze - Production50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000149,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
150,000150,000299,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
300,000300,000449,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
450,000450,000799,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
800,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 33003M739A1 PD/DLY Fuze - Production50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000149,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
150,000150,000299,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
300,000300,000449,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
450,000450,000799,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
800,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 44003M739A1 PD/DLY Fuze - Production50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000149,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
150,000150,000299,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
300,000300,000449,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
450,000450,000799,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
800,000ERROR:#VALUE!ERROR:#VALUE!
Ordering Period 55003M739A1 PD/DLY Fuze - Production50,00050,00099,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
100,000100,000149,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
150,000150,000299,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
300,000300,000449,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
450,000450,000799,999ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#VALUE!ERROR:#VALUE!
800,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-0002= 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 11001M739A1 PD/DLY Fuze - First Article Test (FAT)1 Lot
1002M739A1 PD/DLY Fuze - Additional FAT1 Lot
Ordering Period 22001M739A1 PD/DLY Fuze - Additional FAT1 Lot
Ordering Period 33002M739A1 PD/DLY Fuze - Additional FAT1 Lot
Ordering Period 44001M739A1 PD/DLY Fuze - Additional FAT1 Lot
Ordering Period 55001M739A1 PD/DLY Fuze - Additional FAT1 Lot

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