Attachment4PricingMatrix.xlsx
XLSX spreadsheet 79 KB Posted
- Attached to
- Power Supply Solutions Virtual Industry Day Federal contract opportunity
- Solicitation number
- SPRWA1-19-R-0007
About this file
This document contains pricing instructions and matrices for a federal contract soliciting proposals for the design, development, and production of power supplies for military aircraft. Offerors must submit pricing for several contract line items (CLINs) involving different national stock numbers (NSNs) for power supplies. Pricing is required for first article units as well as production quantities across multiple pricing periods. Instructions provide details on completing the pricing worksheets, including required unit pricing for different quantity ranges or flat rates depending on the CLIN. The total evaluated price will be calculated automatically based on offerors' submitted pricing and will be used for evaluation purposes. The related opportunity notice announces a virtual industry day where interested vendors can review a draft RFP and submit any questions by a specified deadline. Questions will be compiled and answered collectively in a government response posted publicly.
View the file
Other files for this federal contract opportunity
Show all 27
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. 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 | Pricing Period II represents 13 calendar months after receipt of basic award through 24 calendar months. The estimated pricing period quantity is 25. |
6 Pricing Period III represents 25 calendar months after receipt of basic award through 36 calendar months. The estimated pricing period quantity is 10.
7 Pricing Period IV represents 37 calendar months after receipt of basic award through 48 calendar months. The estimated pricing period quantity is 10.
8 Pricing Period V represents 49 calendar months after receipt of basic award through 60 calendar months. The estimated pricing period quantity is 100.
9 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.
10 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 - No Quantity Range
| CLIN | NSN | DESCRIPTION | QTY | UNIT PRICE / CLIN | TEP / CLIN a | |
| 0003AA | 6130-01-269-3624 | Production (-3624) | 2 | Error 1 | ||
| 0003AB | 6130-01-183-3927 | Production (-3927) | 2 | Error 1 | ||
| 0003AC | 6130-01-664-5626 | Production (-5626) | 2 | Error 1 |
Pricing Matrix Instructions - CLIN 0003 (No Quantity Range)
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 0003 (No Quantity Range)
f. 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 0003AA (No Quantity Range) worksheet.
2 The offeror must input the values in each "From" and "To" columns as whole numbers and 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 contract maximum quantity of 25. | ||
| 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 100.
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 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 contract maximum 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 False
| 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 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 contract maximum 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 1 - No Quantity Range
| CLIN | NSN | DESCRIPTION | CONTRACT MAX 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 maximum contract quantity the Government will purchase under this effort; however, the Government reserves the right to exceed the estimated quantity for each pricing period, which is discussed in further detail below, as long as the total quantity purchased does not exceed the maximum contract quantity.
| 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.
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 | Error 5 | |
| 0002AC | 6130-01-664-5626 | First Article | 2 | |||
| 600 | 0003AC | 6130-01-664-5626 | Production (-5626) | 600 | False |
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 Unit 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 .