Pricing_Matrix_.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- SPRWA1-26-R-0017
- Issued by
-
Defense Logistics Agency Aviation
About this file
This is a Pricing Matrix template for submission of pricing proposals related to the production of the 20mm Mechanical Housing (NSN 1005-01-190-9802), which is a transfer unit component for the M61A1 gun used in F-16 ammunition handling systems. The pricing matrix consists of multiple worksheets that offerors must complete in their entirety without inserting or deleting cells, columns, or rows.
The template requires offerors to submit pricing across five distinct CLINs: CLIN 0001 for First Article production with a required delivery of 180 days after receipt of order (quantity of 2 units), and CLIN 0002 for Production across a Basic period and four Ordering Periods, each with a required delivery of 365 calendar days after receipt of funded delivery order at a rate of 3 units per month. Supporting CLINs 0003AA through 0003AD address IUID Marking Plan, IUID Marking Activity, Qualification Test Plan & Procedures, and Test & Inspection Report, all priced on a non-standard pricing (NSP) basis. For CLIN 0002 Production, offerors must provide unit prices for quantity ranges of 1-200 units across each of the five periods, with an estimated total quantity of 574 units across all periods. The Total Evaluated Price (TEP) calculation will auto-populate based on offeror inputs and will be used for evaluation and award selection. Noncompliance with the pricing matrix instructions may result in proposal rejection.
View the file
Other files
Show all 13
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
PRICING MATRIX INSTRUCTIONS / NOTES BELOW
| 1 | The following worksheets are located in this Pricing Matrix Workbook: | |
| a. First Article - this worksheet must be completed in its entirety for each contract line item (CLIN). | ||
| b. Production - this worksheet must be completed in its entirety for each contract line item (CLIN). | ||
| c. Delivery Schedule (Production) - this worksheet must be completed in its entirety for each contract line item (CLIN). | ||
| d. Total Evaluated Price (TEP) - this worksheet is for evaluation purposes only. The contents of this worksheet will be auto-calculated based upon the offeror's proposal. | ||
| 2 | Each worksheet has specific instructions on how to properly complete the contents. Please note, only the gold filled color cells require offeror's input. | |
| 3 | The offeror will not insert and/or delete cells, columns, and/or rows contained within this workbook. | |
| 4 | Offerors are cautioned that any noncompliance with the instructions reflected in this Pricing Matrix Workbook may cause their proposal to be determined unacceptable, and therefore not eligible for award. | |
| 5 | The Total Evaluated Price (TEP) resulting from this Pricing Matrix workbook will be used for selection of the awardee(s) to receive basic contracts. The TEP is the summation of the total of each contract line | |
| Item / ordering period. The unit prices in the Pricing Matrix workbook incorporated into the basic contract will be used to determine awardee order quantities in contract ordering provisions. |
First Article
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 1 - First Article & Data
| CLIN | NSN | DESCRIPTION | QTY | UNIT PRICE / CLIN | TEP / CLIN a | REQUIRED DELIVERY | PROPOSED DELIVERY | ||
| 0001 | 1005-01-190-9802 | First Article (-9802) | 2 | 180 Days After Receipt of Order | Error 1 | Error 2 | |||
| 0003AA | ELIN (A001) | IUID Marking Plan | 1 | NSP | NSP | In accordance with DD1423 | |||
| 0003AB | ELIN (A002) | IUID Marking Activity | 1 | NSP | NSP | In accordance with DD1424 | |||
| 0003AC | ELIN (A003) | Qualification Test Plan & Procedures | 1 | NSP | NSP | In accordance with DD1423 | |||
| 0003AD | ELIN (A004) | Test & Inspection Report | 1 | NSP | NSP | In accordance with DD1423 |
Pricing Matrix Instructions - CLIN 0001 (First Article)
| 1 | The offeror must input a value within the gold filled color cell. If the offeror is required to bid First Article Production, the offeror must input a values in the "Unit Price" column as |
| whole dollars. If the offeror is not required to bid First Article Production, the offeror must input the text "No FA Required". |
2 The offeror will not insert and/or delete cells, columns, and/or rows within this worksheet.
| 3 | The offeror will receive an error message if the following condition(s) exist: | |
| Error 1: the offeror (1) did not enter the text “No FA Required” (if not required to bid First Articles); (2) did not enter a dollar value greater than zero (if required to | ||
| bid First Articles); or (3) left the gold filled color cell blank/empty. | ||
| Error 2: the offeror (1) did not enter the text “No FA Required” (if not required to bid First Articles); (2) did not enter proposed delivery schedule (if required to bid | ||
| . | First Articles); or (3) left the gold filled color cell blank/empty. |
Pricing Matrix Notes - CLIN 0001 (First Article)
a. The Qualification Test Plan & Procedures are for First Article Requirements only. All associated costs should be included in the First Article build costs.
b. The Test & Inspection Report are for First Article Requirements only. All associated costs should be included in the First Article build costs.
Production
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Pricing Matrix Instructions - Production
1 The offeror must input a numerical value, for each pricing period, in the "From" and "To" columns as well as input a dollar value in the corresponding "Unit Price" column for each gold filled color cell
2 The offeror must input the values in each "From" and "To" columns as whole numbers and must input the values in each "Unit Price" column as whole dollars.
3 The offeror will not insert and/or delete cells, columns, and/or rows within this worksheet.
| 4 | The offeror will receive an error message associated with each pricing period if the following condition(s) exist: | |
| Error 3: The summation of the "QTY" column, which is based upon the values entered in the "From" and "To" columns, does not equal the required range quantity associated with each | ||
| contract line item. |
Pricing Matrix Notes - Production
a. CLIN 0002 required min/max is as follows: Basic (1 - 200); Ordering Period I (1 - 200); Ordering Period II (1 - 200); Ordering Period III (1 - 200); and Ordering Period IV (1 - 200).
| b. | The Pricing Period TEP will be used for evaluation purposes only. The total evaluated price for each pricing period represents the sum of the pricing periods' extended price multiplied by a calculated factor that |
| represents the Government’s forecasted quantity associated with each ordering period in relation to the corresponding range quantity for each ordering period. |
c. The TEP will be used for evaluation purposes only. The total evaluated price is the summation of the total evaluated price for each contract line item / ordering period
| ** | The calculation for the TEP is not how pricing will be determined for Future Orders. For Future Orders, the unit price for the quantity to be purchased will be multiplied by the unit price stated for the range |
| containing that quantity. For example, when the unit price for units 11 - 15 is $200 each, the total price regarding an order quantity of 13 units would be $2,600 (13 units mulitplied by $200). (Note: These numbers are for example purposes | |
| only, and have no relation to the cost associated with this effort.) |
Table 2 - Production
CLIN 0002 TOTAL EVALUATED PRICE (TEP) c
| CLIN | NSN | DESCRIPTION | BASIC a | ORDERING PERIOD I a | ORDERING PERIOD II a | ORDERING PERIOD III a | ORDERING PERIOD IV a | ||||||||||||||||||||
| 0002 | 1005-01-190-9802 | Production (-9802) | FROM | TO | QTY | UNIT PRICE | EXTENDED PRICE | FROM | TO | QTY | UNIT PRICE | EXTENDED PRICE | FROM | TO | QTY | UNIT PRICE | EXTENDED PRICE | FROM | TO | QTY | UNIT PRICE | EXTENDED PRICE | FROM | TO | QTY | UNIT PRICE | EXTENDED PRICE |
0 $ - 0 0 $ - 0 0 $ - 0 0 $ - 0 0 $ - 0
BASIC TEP b ORDERING PERIOD I TEP b ORDERING PERIOD II TEP b ORDERING PERIOD III TEP b ORDERING PERIOD IV TEP b
Delivery Schedule (Production)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 5 - Delivery Schedule
| CLIN | NSN | DESCRIPTION | Requested Delivery | Proposed Delivery | |
| 0002 | 1005-01-190-9802 | Production (-9802) | 365 Calendar Days After Receipt of Funded Delivery Order | ||
| (Quantity of 3 each per month) | Error 4 |
Pricing Matrix Instructions - Delivery Schedule (Production)
1 The offeror must input a value within each gold filled color cell. .
2 The offeror will not insert and/or delete cells, columns, and/or rows within this worksheet.
| 3 | The offeror will receive an error message if the following condition(s) exist: | |
| . | Error 4: the offeror (1) did not enter a proposed delivery schedule and left the gold filled color cell blank/empty. |
Total Evaluated Price (TEP)
| CLIN | NSN | DESCRIPTION | MAX QTY | EVALUATED CLIN PRICE |
| 0001 | 1005-01-190-9802 | First Article | 2 | Error 5 |
| 0003AA | ELIN (A001) | IUID Marking Plan | 1 | Error 5 |
| 0003AB | ELIN (A002) | IUID Marking Activity | 1 | Error 5 |
| 0003AC | ELIN (A003) | Qualification Test Plan & Procedures | 1 | Error 5 |
| 0003AD | ELIN (A004) | Test & Inspection Report | 1 | Error 5 |
| Subtotal | Error 5 |
| CLIN | NSN | DESCRIPTION | EST QTY | EVALUATED CLIN PRICE | |
| 35 | 0002 | 1005-01-190-9802 | Production (-9802) | 574 | Error 5 |
| Subtotal | Error 5 |
TOTAL EVALUATED PRICE ERROR:#VALUE!
Pricing Matrix Notes - Total Evaluated Price (TEP)
| a. | The Total Evaluated Price (TEP) will be used for evaluation purposes only. The sum of the evaluated prices for each |
| contract line item (CLIN) represents the TEP. The calculation of the evaluated CLIN prices has been explained on each of | |
| the applicable worksheets in this workbook. |
b. The dollars amounts presented in this column stem from the First Article worksheet.
c. The dollar amounts presented in this column stem from the Production worksheet.
| d. | These estimated quantities are derived from the cumulative estimated quantities for each period regarding each contract |
| line item. |
| e | The offeror will receive an error message, specifically Error 5, if the offeror has not entered the required values within this |
| workbook necessary to auto-populate the "Evaluated CLIN Price". |
Raw Data
First Article Test Costs $ - 0
| NSN: | 1560-00-670-2059LG | ||||
| From | To | BEQ | % to Total | ||
| Basic | 1 | 200 | 174 | 0.2 | |
| OP I | 1 | 200 | 100 | 0.2 | |
| OP II | 1 | 200 | 100 | 0.2 | |
| OP III | 1 | 200 | 100 | 0.2 | |
| OP IV | 1 | 200 | 100 | 0.2 |
File details come from the government source that posted it. Updated .