DRAFT ITO ATTACHMENT - 4.1 Pricing Matrix.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- ABDR TRAILERS
- Solicitation number
- FA8100-25-Q-B001
About this file
This is a pricing matrix template spreadsheet for Aircraft Battle Damage Repair (ABDR) Trailers. The template covers a 10-year period from 2025-2035, split into a base ordering period (Years 1-5) and five option ordering periods (Years 6-10). The base period requires 224 ABDR trailers plus one First Article unit, while each option year requires 45 trailers, for a total of 449 trailers. The pricing structure includes CLIN 0001 for First Article, CLIN 0002 (and subsequent option year CLINs) for the trailers, and CLIN 0003 for data (not separately priced).
The template requires offerors to input unit prices in U.S. dollars rounded to two decimal places in highlighted cells, with automatic calculation of extended prices and total evaluated price (TEP). The TEP calculation includes all CLINs across the full 10-year period. The document is marked as source selection information and includes basic instructions for completion but contains no actual pricing data.
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
Calculation Methodology
| Aircraft Battle Damage Repair (ABDR) Trailers | ||
| CLIN | DESCRIPTION | CALCULATION METHODOLOGY |
| 0001 | First Article | Proposed unit price multiplied by quantity |
| X002 | ABDR Trailers | Proposed unit price mulitplied by quantity |
| 0003 | Data | Not Separately Priced |
TOTAL EVALUATED PRICE The TEP is calculated as the sum of the following CLINS: 0001 (Year 1) X002 (Years 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) 0003 (Year 1)
Instructions
| Source Selection Information - See FAR 2.101 and 3.104 | |
| Aircraft Battle Damage Repair (ABDR) Trailers | |
| ITO ATTACHMENT - 4.1 Pricing Matrix | |
| Instructions to complete this Pricing Matrix: |
| 1 | Offerors are to input the proposed unit prices on this TEP Worksheet, Column E, in ALL yellow highlighted cells |
| 2 | All amounts shall be proposed in U.S. Dollars |
| 3 | Rounding: All dollar amounts shall be rounded to two decimal places |
| 4 | The extended price will be automatically calculated by multiplying the proposed unit price by the estimated quantity |
| 5 | A subtotal price will be automatically calculated at the bottom of each year |
| 6 | The Total Evaluated Price (TEP) will automatically calculate at the top of the TEP worksheet |
SOURCE SELECTION INFORMATION - See FAR 2.101 and FAR 3.104
SOURCE SELECTION INFORMATION - See FAR 2.101 and FAR 3.104
TEP
| ATTACHMENT 4.1 - Pricing Matrix | ||
| Aircraft Battle Damage Repair (ABDR) Trailers | ||
| USE DATA BELOW TO PROVIDE QUOTE | ||
| PERIOD OF PERFORMANCE | PRICE | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 1 - YEARS 1 THRU 5 | $0.00 | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 2 - YEAR 6 | $0.00 | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 3 - YEAR 7 | $0.00 | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 4 - YEAR 8 | $0.00 | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 5 - YEAR 9 | $0.00 | |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD 6 - YEAR 10 | $0.00 | |
| TOTAL EVALUATED PRICE (TEP) = (10 YEAR ORDERING PERIOD) | $0.00 |
| BASE ORDERING PERIOD - YEARS 1 THRU 5 (ESTIMATED 2025 - 2030) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0001 | First Article | 1 | Each | $0.00 | |
| 0002 | ABDR Trailers | 224 | Each | $0.00 | |
| 0003 | Data | 1 | Lot | NSP | $0.00 |
| TOTAL EVALUATED PRICE (YEARS 1 THRU 5) | $0.00 |
| OPTION ORDERING PERIOD 1 - YEAR 6 (ESTIMATED 2030 - 2031) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 1002 | ABDR Trailers | 45 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 6) | $0.00 |
| OPTION ORDERING PERIOD 2 - YEAR 7 (ESTIMATED 2031 - 2032) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 2002 | ABDR Trailers | 45 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 7) | $0.00 |
| OPTION ORDERING PERIOD 3 - YEAR 8 (ESTIMATED 2032 - 2033) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 3002 | ABDR Trailers | 45 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 8) | $0.00 |
| OPTION ORDERING PERIOD 4 - YEAR 9 (ESTIMATED 2033 - 2034) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 4002 | ABDR Trailers | 45 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 9) | $0.00 |
| OPTION ORDERING PERIOD 5 - YEAR 10 (ESTIMATED 2034 - 2035) | |||||
| CLIN | CLIN DESCRIPTION | BEST ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 5002 | ABDR Trailers | 45 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 9) | $0.00 |
File details come from the government source that posted it. Updated .