Attachment4PricingMatrixv44.xlsx
XLSX spreadsheet 85 KB Posted
- Attached to
- Power Supply Solutions (PS2) Federal contract opportunity
- Solicitation number
- SPRWA1-19-R-0007
About this file
This document includes an attachment and solicitation related to a federal contract opportunity for power supply solutions. The attachment provides pricing matrix instructions for offerors to propose pricing on national stock numbers for power supplies ranging from low voltage to 20kVDC for military aircraft. Pricing should be proposed for first article units, production units in quantity ranges or without ranges, and a technical data package. The solicitation seeks proposals for a 10-year multiple award IDIQ contract worth an estimated $800 million to design, develop, and manufacture power supplies. The Air Force plans to award up to six contracts with two set aside for small businesses. Offerors should respond by the anticipated draft RFP date to provide input on the documentation for the virtual industry day.
Attachment 4 Pricing Matrix
View the file
Other files for this federal contract opportunity
Show all 36
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
Text version
Instructions
PRICING MATRIX INSTRUCTIONS / NOTES BELOW
| 1 | The following worksheets are located in this Pricing Matrix Workbook: | |
| a. CLIN 0002 (First Article) - this worksheet must be completed in its entirety for each contract line item (CLIN). | ||
| b. CLIN 0003AA (Quantity Range) - this worksheet must be completed if the offeror chooses to propose quantity ranges for CLIN 0003AA. | ||
| c. CLIN 0003AB (Quantity Range) - this worksheet must be completed if the offeror chooses to propose quantity ranges for CLIN 0003AB. | ||
| d. CLIN 0003AC (Quantity Range) - this worksheet must be completed if the offeror chooses to propose quantity ranges for CLIN 0003AB. | ||
| e. CLIN 0003 (No Quantity Range) - this worksheet must be completed for each CLIN in which the offeror chooses to not propose quantity ranges. | ||
| f. CLIN 0004 (TDP (-3624)) - this worksheet must be completed in its entirety for the Technical Data Package (TDP) CLIN regarding NSN 6130-01-269-3624. |
| g. 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 Delivery Schedule for each National Stock Number (NSN) is as follows: | |||
| First Article After Receipt of Order (ARO) | Production Units After Receipt of Order** | |||
| 6130-01-183-3927 | 18 Months | 6 Months (7 units then 13 units per month thereafter) | ||
| 6130-01-664-5626 | 18 Months | 6 Months (7 units then 13 units per month thereafter) | ||
| 6130-01-269-3624 | 20 Months | 12 Months (2 units then 2 units per month thereafter) | ||
| ** Production will not begin until the acceptance of the First Article and the receipt of the Order for production. | ||||
| 6 | CLIN 0004 will be a "one-time only" buy; CLIN 0004 will be authorized after approval of the corresponding First Article. |
7 The TEP will be used for evaluation purposes only. The total evaluated price is the summation of the total evaluated price for each pricing period.
CLIN 0002 (First Article)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 1 - First Article
| CLIN | NSN | DESCRIPTION | QTY | UNIT PRICE / CLIN | TEP / CLIN a | |
| 0002AA | 6130-01-269-3624 | First Article (-3624) | 2 | Error 1 | ||
| 0002AB | 6130-01-183-3927 | First Article (-3927) | 2 | Error 1 | ||
| 0002AC | 6130-01-664-5626 | First Article (-5626) | 2 | Error 1 |
Pricing Matrix Instructions - CLIN 0002 (First Article)
1 The offeror must input a unit price within each gold filled color cell.
2 The offeror 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 if the following condition(s) exist: | |
| Error 1: the offeror did not enter a dollar value greater than zero and/or left the gold filled color cell blank/empty. | ||
| . | Error 2: the offeror entered the text "No Bid" in a gold filled color cell. |
Pricing Matrix Notes - CLIN 0002 (First Article)
a. The Total Evaluated Price (TEP) / CLIN will be used for evaluation purposes only. The TEP / CLIN represents the offeror proposed unit price multiplied by the first article quantity.
CLIN 0003AA (Quantity Range)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 2 - Quantity Range (-3624)
CLIN 0003AA TOTAL EVALUATED PRICE (TEP) f
| CLIN | NSN | DESCRIPTION | PRICING PERIOD II a | PRICING PERIOD III b | PRICING PERIOD IV c | PRICING PERIOD V d | ||||||||||||||||
| 0003AA | 6130-01-269-3624 | Production (-3624) | 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
PRICING PERIOD II TEP e PRICING PERIOD III TEP e PRICING PERIOD IV TEP e PRICING PERIOD V TEP e
Pricing Matrix Instructions - CLIN 0003AA (Quantity Range)
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, unless the offorer chooses to not propose quantity ranges. If the offeror chooses to not propose quantity ranges, the offeror must leave all gold filled color cells blank/empty, and proceed to the CLIN 0003 (No Quantity Range) worksheet.
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 4: The summation of the "QTY" column, which is based upon the values entered in the "From" and "To" columns, does not equal the forecast quantity of 55. | ||
| Error 5: The offeror has entered unit pricing for a particular CLIN within this workbook and within the CLIN 0003 (No Quantity Range) workbook for the same CLIN. |
Pricing Matrix Notes - CLIN 0003AA (Quantity Range)
a. Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity is 25.
b. Pricing Period III represents 25 calendar months after receipt of basic award through 36 calendar months. The estimated pricing period quantity is 10.
c. Pricing Period IV represents 37 calendar months after receipt of basic award through 48 calendar months. The estimated pricing period quantity is 10.
d. Pricing Period V represents 49 calendar months after receipt of basic award through 60 calendar months. The estimated pricing period quantity is 10.
e. 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 25 percent.
f. The TEP will be used for evaluation purposes only. The total evaluated price is the summation of the total evaluated price for each pricing period.
CLIN 0003AB (Quantity Range)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 2 - Quantity Range (-3927)
CLIN 0003AB TOTAL EVALUATED PRICE (TEP) f
| CLIN | NSN | DESCRIPTION | PRICING PERIOD II a | PRICING PERIOD III b | PRICING PERIOD IV c | PRICING PERIOD V d | ||||||||||||||||
| 0003AB | 6130-01-183-3927 | Production (-3927) | 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
PRICING PERIOD II TEP e PRICING PERIOD III TEP e PRICING PERIOD IV TEP e PRICING PERIOD V TEP e
Pricing Matrix Instructions - CLIN 0003AB (Quantity Range)
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, unless the offorer chooses to not propose quantity ranges. If the offeror chooses to not propose quantity ranges, the offeror must leave all gold filled color cells blank/empty, and proceed to the CLIN 0003AA (No Quantity Range) worksheet.
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 4: The summation of the "QTY" column, which is based upon the values entered in the "From" and "To" columns, does not equal the forecast quantity of 600. | ||
| Error 5: The offeror has entered unit pricing for a particular CLIN within this workbook and within the CLIN 0003 (No Quantity Range) workbook for the same CLIN. |
Pricing Matrix Notes - CLIN 0003AB (Quantity Range)
a. Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity is 150.
b. Pricing Period III represents 25 calendar months after receipt of basic award through 36 calendar months. The estimated pricing period quantity is 150.
c. Pricing Period IV represents 37 calendar months after receipt of basic award through 48 calendar months. The estimated pricing period quantity is 150.
d. Pricing Period V represents 49 calendar months after receipt of basic award through 60 calendar months. The estimated pricing period quantity is 150.
e. 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 25 percent.
f. The TEP will be used for evaluation purposes only. The total evaluated price is the summation of the total evaluated price for each pricing period.
CLIN 0003AC (Quantity Range)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 2 - Quantity Range (-5626)
CLIN 0003AC TOTAL EVALUATED PRICE (TEP) f
| CLIN | NSN | DESCRIPTION | PRICING PERIOD II a | PRICING PERIOD III b | PRICING PERIOD IV c | PRICING PERIOD V d | ||||||||||||||||
| 0003AC | 6130-01-664-5626 | Production (-5626) | 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
PRICING PERIOD II TEP e PRICING PERIOD III TEP e PRICING PERIOD IV TEP e PRICING PERIOD V TEP e
Pricing Matrix Instructions - CLIN 0003AC (Quantity Range)
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, unless the offorer chooses to not propose quantity ranges. If the offeror chooses to not propose quantity ranges, the offeror must leave all gold filled color cells blank/empty, and proceed to the CLIN 0003AA (No Quantity Range) worksheet.
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 4: The summation of the "QTY" column, which is based upon the values entered in the "From" and "To" columns, does not equal the forecast quantity of 600. | ||
| Error 5: The offeror has entered unit pricing for a particular CLIN within this workbook and within the CLIN 0003 (No Quantity Range) workbook for the same CLIN. |
Pricing Matrix Notes - CLIN 0003AC (Quantity Range)
a. Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity is 150.
b. Pricing Period III represents 25 calendar months after receipt of basic award through 36 calendar months. The estimated pricing period quantity is 150.
c. Pricing Period IV represents 37 calendar months after receipt of basic award through 48 calendar months. The estimated pricing period quantity is 150.
d. Pricing Period V represents 49 calendar months after receipt of basic award through 60 calendar months. The estimated pricing period quantity is 150.
e. 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 25 percent.
f. The TEP will be used for evaluation purposes only. The total evaluated price is the summation of the total evaluated price for each pricing period.
CLIN 0003 (No Quantity Range)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 3 - No Quantity Range
| CLIN | NSN | DESCRIPTION | FORECAST QUANTITY a | PRICING PERIOD II UNIT PRICE b | PRICING PERIOD III UNIT PRICE c | PRICING PERIOD IV UNIT PRICE d | PRICING PERIOD V UNIT PRICE e | TOTAL EVALUATED PRICE / CLIN f |
| 0003AA | 6130-01-269-3624 | Production (-3624) | 55 | |||||
| 0003AB | 6130-01-183-3927 | Production (-3927) | 600 | |||||
| 0003AC | 6130-01-664-5626 | Production (-5626) | 600 |
Pricing Matrix Instructions - CLIN 0003 (No Quantity Range)
1 For each contract line item (CLIN), the offeror must input a unit price into each gold filled color cell, unless the offeror chooses to propose quantity ranges . If the offeror chooses to propose quantity ranges for a particular CLIN, the offeror must leave all corresponding gold filled color cells blank/empty, and proceed to the corresponding quantity range worksheet (e.g. CLIN 0003AA (Quantity Range), CLIN 0003AB (Quantity Range), CLIN 0003AC (Quantity Range) .
2 The offeror 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 if the following condition(s) exist: | |
| . | Error 3: The offeror has entered unit pricing for a particular CLIN within this workbook and within the 0003XX (Quantity Range) workbook for the same CLIN. |
Pricing Matrix Notes - CLIN 0003 (No Quantity Range)
a. The value reflects the forecast quantity the Government will purchase under this effort.
| b. | Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity for each CLIN is as follows: | |
| CLIN 0003AA: estimated quantity is 25 | ||
| CLIN 0003AB: estimated quantity is 150 | ||
| CLIN 0003AC: estimated quantity is 150 |
| c. | Pricing Period III represents 25 calendar months after receipt of basic award through 36 calendar months. The estimated pricing period quantity for each CLIN is as follows: | |
| CLIN 0003AA: estimated quantity is 10 | ||
| CLIN 0003AB: estimated quantity is 150 | ||
| CLIN 0003AC: estimated quantity is 150 |
d.
COOPER, KENNEDA T CIV USAF AFMC DLA/DLA: COOPER, KENNEDA T CIV USAF AFMC DLA/DLA:
| Should this reflect 27 calendar months? | Pricing Period IV represents 37 calendar months after receipt of basic award through 48 calendar months. The estimated pricing period quantity for each CLIN is as follows: | |
| CLIN 0003AA: estimated quantity is 10 | ||
| CLIN 0003AB: estimated quantity is 150 | ||
| CLIN 0003AC: estimated quantity is 150 |
| e. | Pricing Period V represents 48 calendar months after receipt of basic award through 60 calendar months. The estimated pricing period quantity for each CLIN is as follows: | |
| CLIN 0003AA: estimated quantity is 10 | ||
| CLIN 0003AB: estimated quantity is 150 | ||
| CLIN 0003AC: estimated quantity is 150 |
f. The Total Evaluated Price / CLIN will be used for evaluation purposes only. The Total Evaluated Price / CLIN represents a simple average of the offer proposed unit price for each pricing period multiplied by the corresponding contract maximum quantity.
CLIN 0004 (TDP) (-3624)
SEE PRICING MATRIX INSTRUCTIONS / NOTES BELOW
Table 4 - TDP (-3624)
| CLIN | NSN | DESCRIPTION | QTY | UNIT PRICE / CLIN | TEP / CLIN a | |
| 0004 | 6130-01-269-3624 | TDP (-3624) | 1 | Error 1 |
Pricing Matrix Instructions - CLIN 0004 (TDP (-3624))
1 The offeror must input a unit price within the gold filled color cell.
2 The offeror must input the values in the "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 if the following condition(s) exist: | |
| Error 1: the offeror did not enter a dollar value greater than zero and/or left the gold filled color cell blank/empty. | ||
| . | Error 2: the offeror entered the text "No Bid" in a gold filled color cell. |
Pricing Matrix Notes - CLIN 0004 (TDP (-3624))
a. The Total Evaluated Price (TEP) / CLIN will be used for evaluation purposes only. The TEP / CLIN represents the offeror proposed unit price multiplied by the TDP (-3624) quantity.
Total Evaluated Price (TEP)
| CLIN | NSN | DESCRIPTION | MAX QTY | EVALUATED CLIN PRICE | |
| 0002AA | 6130-01-269-3624 | First Article | 2 | ||
| 55 | 0003AA | 6130-01-269-3624 | Production (-3624) | 55 | |
| 0002AB | 6130-01-183-3927 | First Article | 2 | ||
| 600 | 0003AB | 6130-01-183-3927 | Production (-3927) | 600 | |
| 0002AC | 6130-01-664-5626 | First Article | 2 | ||
| 600 | 0003AC | 6130-01-664-5626 | Production (-5626) | 600 | |
| 0004 | 6130-01-269-3624 | TDP (-3624) | 1 |
TOTAL EVALUATED PRICE Error 5
| Pricing Matrix Notes - Total Evaluated Price (TEP) |
| 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. |
The offeror will received 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". Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity is 25.
File details come from the government source that posted it. Updated .