The file's text, extracted by GovTribe without its formatting.
Production CLINs
| OFFEROR NAME: | = Offeror Must Fill-In Cells | FORMULA DESCRIPTION AND EXAMPLE | |
| Solicitation No. W15QKN-22-R-0027 | = Cells Include Formulas; Do Not Change | * Using a best fit power curve methodology, the general formula used in the pricing matrix is: | Y=Ax^b |
| Pricing Matrix, Attachment 0001 | | * 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 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) | | |
| * Using the example data and quantities below, for 3,000 common parts being ordered, the formula is: | Unit price = $283.07*3,000^-0.0177 |
| * The calculated unit price for 3,000 common items is: | $245.69 |
| * The same methodology is applied to the specific quantities for the Unique M734A1 and M783 Fuze individually. | |
| IF YOU RESPONDED "IS" PREDICATED ON USE OF GOVERNMENT PROPERTY, COMPLETE THIS TAB, and "Prod Gov Property", "INERT Fuzes Govt Prop" and Cutaway Govt Prop" TABs IN THIS WORKBOOK | | |
| | 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^b | | | | | | | | | | | | Curved Pricing Calculator | | | | | | | | | | | | | | | | |
| | Example | CLIN | Description | Quantity | M734A1/M783 Common | M734A1 Unique | M783 | | | | | | | | | | | | | | | | | | | | |
| Unique | Curve Applies to | | M734A1/M783 Common Curves | | | M734A1 Unique Curves | | | M783 Unique Curves | | | | Quantity | | | Unit Prices | | | Total for Combination Quantities | | | | | | | | | |
| | | | | | $ Unit Price | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula | Common (X) | M734A1 Unique (X) | M783 Unique (X) | Common | M734A1 Unique | M783 Unique | M734A1 | M783 | TOTAL |
| | | 0001/0002 | M734A1 / M783 Fuze | 1,000 | $250.51 | $100.68 | $25.50 | 1,000 | 9,999 | -$0.0177 | $283.07 | Y = 283.07 x ^-0.0177 | -$0.0101 | $107.94 | Y = 107.94 x ^-0.0101 | -$0.0309 | $31.56 | Y = 31.56 x ^-0.0309 | 3,000 | 1,500 | 1,500 | $245.69 | $100.27 | $25.18 | $518,935.93 | $406,306.06 | $925,241.99 |
| | | | | 10,000 | $240.51 | $98.37 | $23.75 | 10,000 | 24,999 | -$0.0482 | $375.06 | Y = 375.06 x ^-0.0482 | -$0.0255 | $124.39 | Y = 124.39 x ^-0.0255 | -$0.1224 | $73.34 | Y = 73.34 x ^-0.1224 | 12,000 | 6,000 | 6,000 | $238.40 | $98.88 | $24.13 | $2,023,690.11 | $1,575,188.40 | $3,598,878.51 |
| | | | | 25,000 | $230.11 | $96.10 | $21.23 | 25,000 | 49,999 | -$0.1893 | $1,565.24 | Y = 1565.24 x ^-0.1893 | -$0.1453 | $418.74 | Y = 418.74 x ^-0.1453 | -$0.1571 | $104.17 | Y = 104.17 x ^-0.1571 | 24,500 | 18,000 | 6,500 | $230.33 | $96.91 | $24.07 | $5,890,358.22 | $1,653,615.55 | $7,543,973.78 |
| | | | | 50,000 | $201.81 | $86.89 | $19.04 | | | | | | | | | | | | | | | | | | | | |
| 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^b
| | CLIN | Description | Quantity | M734A1/M783 Common | M734A1 Unique | M783 Unique | Curve Applies to | | M734A1/M783 Common Curves | | | M734A1 Unique Curves | | | M783 Unique Curves | | |
| | | | | $ Unit Price | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 0005 / 0006 | | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 399,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
EXAMPLE
EXAMPLE
Production Govt Property
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Production CLINS Govt Property | | |
| This worksheet shall only be completed if the Offeror's proposal "IS" predicated on the use of Government property already in its possession. |
| Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable. |
| Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT, Inert Fuzes and Cutaways MUST be provided on the applicable tab. |
| Values are only needed for the referenced quantities. The curves from the production CLINs are used to calculate the other quantities. |
PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY Curve Data used to Calculate Per Unit Rental Value for Quantities between Specified Quantities;
Power Curve Formula: Y=Ax^b
| | CLIN | Description | Quantity | M734A1/M783 Common | M734A1 Unique | M783 Unique | Curve Applies to | | M734A1/M783 Common Curve Variables | | | M734A1 Unique Curve Variables | | | M783 Unique Curve Variables | | |
| | | | | $ Unit Price | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 0005 / 0006 | | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1,000 | | | 1,000 | 9,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 10,000 | | | | 10,000 | 24,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 25,000 | | | | 25,000 | 49,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50,000 | | | | 50,000 | 99,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 100,000 | | | | 100,000 | 199,999 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 200,000 | | | | 200,000 | 500,000 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 400,000 | | | | | | | | | | | | | | |
FAT CLINs
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Initial/Subsequent FAT CLINs | | |
PROPOSED FFP FAT PRICES (excluding rental value of Gov't property, if any)
| M734A1 & M783 FAT Prices | | | | | | | Evaluated Price | | |
| DESCRIPTION | Quantity | CLIN | | | | | AVERAGE PRICE | EVALUATED QTY | EVALUATED AMOUNT |
| | 0001 / OP1 | 1001 / OP2 | 2001 / OP3 | 3001 / OP4 | 4001 / OP5 | M734A1 | | |
| M734A1 Initial FAT | 1 Lot | | | | | | ERROR:#DIV/0! | 1 | ERROR:#DIV/0! |
| | 0002 / OP1 | 1002 / OP2 | 2002 / OP3 | 3002 / OP4 | 4002 / OP5 | | | |
| M734A1 Subsequent FAT | 1 Lot | | | | | | ERROR:#DIV/0! | 1 | ERROR:#DIV/0! |
| | | | | | | Total M734A1 FAT | | ERROR:#DIV/0! |
| | 0003 / OP1 | 1003 / OP2 | 2003 / OP3 | 3003 / OP4 | 4003 / OP5 | M783 | | |
| M783 Initial FAT | 1 Lot | | | | | | ERROR:#DIV/0! | 1 | ERROR:#DIV/0! |
| | 0004 / OP1 | 1004/ OP2 | 2004/ OP3 | 3004/ OP4 | 4004 / OP5 | | | |
| M783 Subsequent FAT | 1 Lot | | | | | | ERROR:#DIV/0! | 1 | ERROR:#DIV/0! |
| | | | | | | Total M783 FAT | | ERROR:#DIV/0! |
| | | | | | | EVALUATED PRICE- FAT | | ERROR:#DIV/0! |
FAT Govt Property
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Government Property Per Unit Rental Value for FAT CLINs | | |
| This worksheet shall only be completed if the Offeror's proposal IS predicated on the use of Government property already in its possession. |
| Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable. |
| Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT, Inert Fuzes and Cutaways MUST be provided on the applicable tab. |
PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY
| M734A1 & M783 FAT Prices | | | | | | |
| DESCRIPTION | Quantity | CLIN | | | | |
| | 0001 / OP1 | 1001 / OP2 | 2001 / OP3 | 3001 / OP4 | 4001 / OP5 |
| M734A1 Initial FAT | 1 Lot | | | | | |
| | 0002 / OP1 | 1002 / OP2 | 2002 / OP3 | 3002 / OP4 | 4002 / OP5 |
| M734A1 Subsequent FAT | 1 Lot | | | | | |
| | 0003 / OP1 | 1003 / OP2 | 2003 / OP3 | 3003 / OP4 | 4003 / OP5 |
| M783 Initial FAT | 1 Lot | | | | | |
| | 0004 / OP1 | 1004/ OP2 | 2004/ OP3 | 3004/ OP4 | 4004 / OP5 |
| M783 Subsequent FAT | 1 Lot | | | | | |
Inert Fuzes
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Inert Fuze CLINs | | |
PROPOSED FFP INERT FUZES UNIT PRICES (excl. 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^b
| OP | CLIN | Description | Quantity | M734A1 | M783 | Curve Applies to | | M734A1 Curves | | | M783 Curves | | |
| | | | | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 1007 / 1008 | | | | | | | | | | | | |
| M734A1 / M783 Inert Fuze | 1 | | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50 | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
Inert Fuzes Govt Property
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Government Property Per Unit Rental Value for Inert Fuze CLINs | | |
| This worksheet shall only be completed if the Offeror's proposal IS predicated on the use of Government property already in its possession. |
| Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable. |
| Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT, Inert Fuzes and Cutaways MUST be provided on the applicable tab. |
| Values are only needed for the referenced quantities. The curves from the Inert Fuzes CLINs are used to calculate the other quantites. |
PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY Curve Data used to Calculate Per Unit Rental Value for Quantities between Specified Quantities;
| OP | CLIN | Description | Quantity | M734A1 | M783 | Curve Applies to | | M734A1 Curves | | | M783 Curves | | |
| | | | | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 1007 / 1008 | | | | | | | | | | | | |
| M734A1 / M783 Inert Fuze | 1 | | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50 | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
Cutaway CLINs
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Cutaway Fuze CLINs | | |
PROPOSED FFP CUTAWAY UNIT PRICES (excluding rental value of Gov't property, if any) Curve Data used to Calculate Unit Prices for Quantities between Specified Quantities;
| OP | CLIN | Description | Quantity | M734A1 | M783 | Curve Applies to | | M734A1 Curves | | | M783 Curves | | |
| | | | | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 1007 / 1008 | | | | | | | | | | | | |
| M734A1 / M783 Inert Fuze | 1 | | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50 | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
Cutaway Govt Property
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| Solicitation No. W15QKN-22-R-0027 | | = Cells Include Formulas; Do Not Change |
| Pricing Matrix, Attachment 0001 | | |
| Government Property Per Unit Rental Value for Cutaway Fuze CLINs | | |
| This worksheet shall only be completed if the Offeror's proposal IS predicated on the use of Government property already in its possession. |
| Offerors shall input only the PER UNIT RENTAL VALUE on this tab, if applicable. |
| Should rental value be shown below for the Production CLINs, the equivalent rental value applicable to FAT, Inert Fuzes and Cutaways MUST be provided on the applicable tab. |
PER UNIT RENTAL VALUE OF GOVERNMENT PROPERTY Curve Data used to Calculate Per Unit Rental Value for Quantities between Specified Quantities;
| OP | CLIN | Description | Quantity | M734A1 | M783 | Curve Applies to | | M734A1 Curves | | | M783 Curves | | |
| | | | | $ Unit Price | $ Unit Price | | | Slope (b) | T-1 (A) | Formula | Slope (b) | T-1 (A) | Formula |
| Ordering Period 1 | 1007 / 1008 | | | | | | | | | | | | |
| M734A1 / M783 Inert Fuze | 1 | | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | | 50 | | | | | | | | | | |
| Ordering Period 2 | 1005 / 1006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 3 | 2005 / 2006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 4 | 3005 / 3006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |
| Ordering Period 5 | 4005 / 4006 | | | | | | | | | | | |
| M734A1 / M783 Fuze | 1 | | 1 | 24 | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | | | |
| | | 25 | | | 25 | & up | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! | ERROR:#NUM! |
| | | 50 | | | | | | | | | | |