Attachment_13A_-_Fairchild_TEP_Matrix.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- FA6800-19-R-A002
About this file
This document contains a template for a Total Evaluated Price (TEP) proposal matrix for a small business competition for rotary aircraft maintenance services at Fairchild Air Force Base. The template requires offerors to provide pricing details for the base year plus four option years by completing unit prices and quantities for Firm-Fixed Price Contract Line Item Numbers for services including UH-1N aircraft maintenance, E-tools management, mobilization, and a post-award orientation conference. Additional tabs are included for an optional six-month extension period. Instructions are provided on using the template and populating pricing details by period of performance across multiple tabs. Formulas automatically calculate extended prices and totals. This TEP matrix template aims to standardize proposal formats to facilitate evaluation of pricing proposals for this small business set-aside rotary aircraft maintenance services requirement at Fairchild Air Force Base.
The related federal contract opportunity document provides additional context, with the solicitation seeking proposals for consolidated helicopter maintenance contracts across multiple Air Force bases. Services required include full spectrum aircraft maintenance, logistics support, and weapons operations. A combination of Firm-Fixed Price and Cost Reimbursement CLINs is contemplated under the Indefinite Delivery Indefinite Quantity contract vehicle. The NAICS code is 488190 and the small business size standard is $32.5 million. The solicitation targets multiple awards with up to five contractors each in the small business set-aside and full and open competition pools. The pre-proposal conference and initial task order competitions will cover requirements at Fairchild AFB and Kirtland AFB. The period of performance spans five base years and one optional extension period from October 2019 to September 2029.
Fairchild Total Evaluated Price Matrix
View the file
Other files
Show 40 more
Latest 50 of 70 listed here. See the rest on GovTribe.
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
| Key | ||
| Offeror Must Complete Cell | ||
| Automatically Calculated | ||
| Worksheet Title/Period of Performance | ||
| Information/Instructions | ||
| CLIN | Definition | CLIN Type |
| X001 | UH-1N Aircraft Maintenance | FFP |
| X009 | E-Tools Management | FFP |
| X017 | Mobilization | FFP |
| X018 | Post-Award Orientation Conference | FFP |
&"Times New Roman,Regular"&12SMALL BUSINESS COMPETITION FOR ROTARY MAINENANCE SERVICES
FAIRCHILD AFB
This workbook is to be completed by Offerors competing for the Small Business Basic Award/Fairchild AFB Task Order in order to establish a comprehensive TEP for evaluation. The workbook is broken into ten (10) distinct tabs including "Instructions", “TEP Summary”, "Post Award", “Mobilization”, “Base Year”, “Option 1”, “Option 2”, “Option 3”, “Option 4”, and “Extension” tabs. A color coded "Key" has been provided on the “Instructions” tab, cells G1 to H5, to assist with the layout of each tab. This “Instructions” tab provides a detailed overview explaining how the Matrix shall be completed by the Offeror. The “TEP Summary” tab automatically calculates an aggregated summary of the total price proposed by the Offeror for the Task Order as input throughout the Matrix. The “Post-Award” tab shall be utilized to account for the $2,000 Task Order award that will be granted to up to the top five (5) Offerors in accordance with the Limited Trade-Off evaluation parameters outlined in the solicitation. Each of the remaining seven (7) non-instructional tabs represent a distinct period of the Task Order as detailed in the blue-colored cells on the top of each tab. All seven (7) tabs contain a breakdown of the CLINs relevant to each event or period of the Task Order. Gray-colored cells are included solely for informative and directional purposes. Each green-colored cell contains a prepopulated formula that will be automatically completed, as the Matrix is populated by Offeror. All orange-colored cells must be completed by the Offeror, requiring the Offeror’s general information on the “TEP Summary” tab, as well as their anticipated pricing data for each respective CLIN throughout the Matrix workbook. The Offeror shall only complete orange-colored cells as all other cells have been locked to prevent adjustment. Tampering with Attachment 13A “Fairchild TEP Matrix” outside of what is instructed may result in the Offeror’s proposal being disqualified from further consideration.
The Offeror shall provide unit prices for each FFP CLIN as broken down by performance period within this workbook. A table has been provided in cells G7-K11 of the "Instructions" tab for reference, outlining: a list of all CLINs applicable to the Fairchild AFB TO that require pricing, the definition of each CLIN, and the CLIN type. The Offeror shall reference the CLIN requirements within the RFP to ensure the unit price provided for each FFP CLIN and the proposed TEP comprehensively include all of the Offeror's anticipated direct/indirect expenses and profit. Once the unit price has been entered into the applicable orange-cell for each FFP CLIN in accordance with the detailed guidance below, the "CLIN Price" for the period will automatically populate by multiplying the individual unit price by the total quantity of units identified. Cost CLINs are included in the Fairchild Task Order, and the values of the Cost CLINs are subject to a Not to Exceed (NTE) ceilings established by the Government. Therefore, they are not included in the Fairchild TEP Matrix for evaluation. All dollar amounts in the proposal shall be rounded to the nearest dollar.
Tab by Tab Instructions:
TEP Summary: The Offeror shall provide the requested information pertaining to their company in cells C3-D5. Cells D7-D10 will automatically populate once the remaining tabs have been completed by the Offeror to provide the total price by CLIN. Cell D11 will automatically populate, showing the Offeror's TEP for the Fairchild AFB Task Order.
Post Award: The Offeror shall not input any information on the “Post Award” tab. The Post-Award Orientation Conference tab shall be utilized to account for the $2,000 Task Order award that will be granted to up to the top five (5) Offerors awarded basic contracts in accordance with the Limited Trade-Off evaluation parameters outlined in the solicitation. This value is automatically included in cell F4 and carried forward to cell G4 to show the total CLIN price.
Mobilization: The “Mobilization” tab shall be utilized to provide a FFP for all direct/indirect costs and profit associated with the Offeror’s transition into performance of the Fairchild Rotary Maintenance Task Order from 01 September 2019 through 30 September 2019 as outlined in the RFP. The Offeror shall only include the one month unit price in Cell F5. The unit price is carried forward to cell G5 to show the total CLIN price.
Base Year: The “Base Year” tab shall be utilized to provide a FFP for all direct/indirect costs and profit associated with the Offeror’s performance of the FFP portion of the Fairchild AFB Rotary Maintenance Task Order from 01 October 2019 through 30 September 2020. The Offeror shall first reference the requirements of each separate CLIN within the RFP. The Offeror shall then determine the anticipated price for one month of work associated with each FFP CLIN applicable to the base year and enter the price within cells F5-F6. The CLIN price covering the entire (twelve) 12 month period will automatically populate in cells G5-G6 by multiplying the unit price by the (twelve) 12 month quantity provided. The total anticipated price for all FFP CLINs within the base year will automatically be tallied within cell G7.
Option 1, Option 2, Option 3, and Option 4: The “Option Year” tabs shall be utilized to provide a FFP for all direct/indirect costs and profit associated with the Offeror’s performance of the FFP portion of the Fairchild AFB Rotary Maintenance Task Order for each (twelve) 12 month Option period respectively from 01 October 2020 through 30 September 2024. The Offeror shall first reference the requirements of each separate CLIN within the RFP. The Offeror shall then determine the proposed price for one month of work associated with each FFP CLIN applicable to the Option years and enter the price within the applicable “Option” tab in cells F5-F6. The CLIN price covering the entire (twelve) 12 month period will automatically populate in cells G5-G6 by multiplying the unit price by the (twelve) 12 month quantity provided. The total anticipated price for all FFP CLINs within each option year will automatically be tallied within cell G7.
Extension: The “Extension” tab will automatically populate after the Option 4 tab is completed and therefore requires no input from the Offeror. This tab will be utilized to provide a price associated with the performance of the Fairchild AFB Rotary Maintenance Task Order if the Contracting Officer exercises the 6-Month Extension period. The anticipated price is automatically calculated and input into the “Extension” tab by CLIN, as the Option 4 tab is populated. Each CLIN’s “CLIN Price” is represented as one-half of the CLIN Price proposed within Option 4. The Total Extension Price of both CLINs for the extension period will automatically be tallied within cell G7.
TEP Summary
| TOTAL EVALUATED PRICE (TEP) PROPOSAL SUMMARY SHEET | |||
| Company (Cage Code): | |||
| Address: | |||
| City, State, Zip Code: | |||
| CLIN | Definition | CLIN Type | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | $ - 0 |
| X009 | E-Tools Management | FFP | $ - 0 |
| X017 | Mobilization | FFP | $ - 0 |
| X018 | Post-Award Orientation Conference | FFP | $ 2,000 |
| TOTAL EVALUATED PRICE | $ 2,000 | ||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Post-Award
| POST-AWARD ORIENTATION CONFERENCE | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X018 | Post-Award Orientation Conference | FFP | Each | 1 | $ 2,000 | $ 2,000 |
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Mobilization
| MOBILIZATION PERIOD | ||||||
| 01 September 2019 - 30 September 2019 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X017 | Mobilization | FFP | Month | 1 | $ - 0 | $ - 0 |
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Base Year
| BASE YEAR | ||||||
| 01 October 2019 - 30 September 2020 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL BASE PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Option 1
| OPTION YEAR 1 | ||||||
| 01 October 2020 - 30 September 2021 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL OPTION YEAR 1 PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Option 2
| OPTION YEAR 2 | ||||||
| 01 October 2021 - 30 September 2022 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL OPTION YEAR 2 PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Option 3
| OPTION YEAR 3 | ||||||
| 01 October 2022 - 30 September 2023 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL OPTION YEAR 3 PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Option 4
| OPTION YEAR 4 | ||||||
| 01 October 2023 - 30 September 2024 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL OPTION YEAR 4 PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
Extension
| EXTENSION PERIOD | ||||||
| 6 MONTHS | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 6 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 6 | $ - 0 | $ - 0 |
| TOTAL EXTENSION PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
FAIRCHILD AFB
File details come from the government source that posted it. Updated .