AMENDMENT_0004_Attachment_13C_-_Kirtland_TEP_Matrix.xlsx
XLSX spreadsheet 49 KB Posted
- Solicitation number
- FA6800-19-R-A002
About this file
This document package includes an Excel pricing matrix template and instructions for a federal contract solicitation. The solicitation seeks rotary aircraft maintenance services for multiple Air Force bases, including Kirtland AFB. Services include organizational and intermediate level maintenance, inspections, modifications and fleet management for UH-1N, HH-60, MH-139 and CV-22 aircraft. The pricing matrix requires offerors to provide fixed unit prices for firm-fixed-price contract line items and transfer cost reimbursement rates from an attached table for cost-plus-fixed-fee line items covering the base year and four option years. The solicitation was previously numbered FA6800-18-R-0005 and has been renumbered to FA6800-19-R-A002. Multiple awards are anticipated across two pools, with up to five contractors to be selected in each of the small business set-aside and full and open competition pools.
Attachment 13C
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 | ||
| Worksheet Title/Period of Performance | ||
| Information/Instructions | ||
| Offeror Must Complete Cell | ||
| Automatically Calculated | ||
| Offeror Must Transfer Data from "Summary" tab of Attachment 13C "Kirtland CPFF Rate Tables" | ||
| CLIN | Definition | CLIN Type |
| X001 | UH-1N Aircraft Maintenance | FFP |
| X002 | HH-60 Aircraft Maintenance | FFP |
| X003 | MH-139 Aircraft Maintenance | CPFF |
| X009 | E-Tools Management | FFP |
| X012 | UH-1N Aircrew Services/FCF | FFP |
| X013 | HH-60 Aircrew Services/FCF | FFP |
| X014 | CV-22 Aircrew Services/FCF | FFP |
| X015 | MH-139 Aircrew Services/FCF | CPFF |
| X018 | Mobilization | FFP |
| X019 | Post-Award Orientation Conference | FFP |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
This workbook is to be completed by Offerors competing for the Full and Open Basic Award/Kirtland AFB Task Order. This workbook will be utilized to establish a CLIN price for all FFP CLINs. The CLIN price for both CPFF CLINs X003 and X015 shall then be transferred from the “Summary” tab of Attachment 13B, “Kirtland CPFF Rate Tables” to the ”Option 1” through “Option 4” tabs. A comprehensive TEP for the Kirtland AFB TO inclusive of all FFP and CPFF CLINs will then be established on the “TEP Summary” tab.
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 this tab, located in cells H1 to I6, 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 TEP for FFP and CPFF CLINs 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 awarded basic contracts 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 applicable orange-colored cells shall be completed by the Offeror, requiring the Offeror’s proposed cost/price data for each respective CLIN throughout the Matrix workbook. The Offeror shall only complete orange-colored and yellow-colored cells as all other cells have been locked to prevent adjustment. Tampering with this 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 H8-J18 of this tab for reference, outlining: a list of all CLINs applicable to the Kirtland 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-cells 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. Once the MH-139 CPFF CLIN X003 and X015 totals are transferred into the applicable Option tabs on Attachment 13C from the “Summary” tab on Attachment 13B as discussed in detail below, the total price by CLIN and TEP will automatically calculate on the “TEP Summary” tab. CR CLINs are included in the Kirtland Task Order, and the values of the CR CLINs are subject to a Not to Exceed (NTE) ceiling established by the Government. Therefore, they are not included in the Kirtland TEP Matrix for evaluation. All dollar amounts in the proposal shall be rounded to the nearest dollar, except for CPFF labor rates presented on Attachment 13B, which shall be rounded to the hundredths place (two decimal places).
Tab by Tab Instructions:
TEP Summary: The Offeror shall first input their company’s name in row 3. Cells D10-D19 will automatically populate once the remaining tabs have been completed by the Offeror to provide the total price by CLIN. Cell D20 will automatically populate, showing the Offeror's TEP for the Kirtland 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 unit price 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 Kirtland Rotary Maintenance Task Order from 01 September 2020 through 30 September 2020 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 Kirtland Rotary Aircraft Task Order throughout FY 2021 from 01 October 2020 through 30 September 2021. 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 base year and enter the price within the applicable orange-colored cells in column F. The CLIN price covering the entire twelve (12) month period will automatically populate in the applicable green-colored cells 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 G11.
Option 1, Option 2, Option 3, and Option 4: The “Option Year” tabs shall be utilized to provide a price for all direct/indirect costs and profit associated with the Offeror’s performance of the Kirtland Rotary Aircraft Task Order for each twelve (12) month Option period respectively from 01 October 2021 through 30 September 2025 (FYs 2022 through 2025). 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 orange-colored cells in column F. The CLIN price covering the entire Option period will automatically populate in the applicable green-colored cells in column G by multiplying the unit price by the month quantity provided. CPFF fully burdened ceiling rates shall be identified separately by labor category within Attachment 13B, “CPFF Rate Tables” in accordance with the directions provided on the “Instructions” tab for CPFF CLINs “X003 – MH-139 Aircraft Maintenance” and “X015 – MH-139 Aircrew Services/FCF”. Once the Offeror inputs the applicable CPFF labor rates and distributes the Government calculated labor hours with any Teaming Partner(s) (if applicable), the totals by FY for both CLIN X003 and X015 are then automatically calculated as highlighted in yellow in rows 10 and 20 of the “Summary” tab on Attachment 13B. The Offeror shall then manually transfer the total prices by FY from cells B through E 10 and B through E 20 of the “Summary” tab of Attachment 13B, to the respective cells as highlighted in yellow on the “Option” tabs in Attachment 13C. The total option prices/costs for all FFP and CPFF CLINs within each Option Year will automatically be tallied within cell G13 of the respective tab in Attachment 13C.
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 Kirtland Rotary Aircraft Task Order if the Contracting Officer exercises the six (6)-Month Extension period. The proposed 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 price proposed within Option 4. The Total Extension Price of all CLINs for the extension period will automatically be tallied within cell G13.
TEP Summary
| TOTAL EVALUATED PRICE (TEP) PROPOSAL SUMMARY SHEET | |||
| Offeror Name: | |||
| CLIN | Definition | CLIN Type | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | $ - 0 |
| X002 | HH-60 Aircraft Maintenance | FFP | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | $ - 0 |
| X009 | E-Tools Management | FFP | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | $ - 0 |
| X018 | Mobilization | FFP | $ - 0 |
| X019 | Post-Award Orientation Conference | FFP | $ 2,000 |
| TOTAL EVALUATED PRICE | $ 2,000 | ||
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Post-Award
| POST AWARD ORIENTATION CONFERENCE | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X019 | Post-Award Orientation Conference | FFP | Each | 1 | $ 2,000 | $ 2,000 |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Mobilization
| MOBILIZATION PERIOD | ||||||
| 01 September 2020 - 30 September 2020 | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X018 | Mobilization | FFP | Month | 1 | $ - 0 | |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Base Year
| BASE YEAR | ||||||
| FY 2021 (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 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| TOTAL BASE PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Option 1
| OPTION YEAR 1 | ||||||
| FY 2022 (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 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell B10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | ||||||
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F12 from cell B20 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell B10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | |
| TOTAL OPTION 1 PRICE | $ - 0 |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Option 2
| OPTION YEAR 2 | ||||||
| FY 2023 (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 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell C10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | ||||||
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F12 from cell C20 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell C10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | |
| TOTAL OPTION 2 PRICE | $ - 0 |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Option 3
| OPTION YEAR 3 | ||||||
| FY 2024 (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 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell D10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | ||||||
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F12 from cell D20 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell D10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | |
| TOTAL OPTION 3 PRICE | $ - 0 |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
Option 4
| OPTION YEAR 4 | ||||||
| FY 2025 (01 October 2024 - 30 September 2025) | ||||||
| CLIN | Definition | CLIN Type | Unit of Issue | Qty | Unit Price | CLIN Price |
| X001 | UH-1N Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 12 | $ - 0 | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell E10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | ||||||
| X009 | E-Tools Management | FFP | Month | 12 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 12 | $ - 0 | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | Year | 1 | $ - 0 |
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F12 from cell E20 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF: ORVEK, JARED CIV USAF AFICA HQ AFICA/KPF:
Offeror must manually transfer price to cell F07 from cell E10 on the "Summary" tab of Attachment 13B, "Kirtland CPFF Rate Tables".
| $ - 0 | |
| TOTAL OPTION 4 PRICE | $ - 0 |
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
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 |
| X002 | HH-60 Aircraft Maintenance | FFP | Month | 6 | $ - 0 | $ - 0 |
| X003 | MH-139 Aircraft Maintenance | CPFF | Year | 0.5 | $ - 0 | $ - 0 |
| X009 | E-Tools Management | FFP | Month | 6 | $ - 0 | $ - 0 |
| X012 | UH-1N Aircrew Services/FCF | FFP | Month | 6 | $ - 0 | $ - 0 |
| X013 | HH-60 Aircrew Services/FCF | FFP | Month | 6 | $ - 0 | $ - 0 |
| X014 | CV-22 Aircrew Services/FCF | FFP | Month | 6 | $ - 0 | $ - 0 |
| X015 | MH-139 Aircrew Services/FCF | CPFF | Year | 0.5 | $ - 0 | $ - 0 |
| TOTAL EXTENSION PRICE | $ - 0 | |||||
| Proposals must be presented in rounded whole dollars. |
&"Times New Roman,Regular"&12FULL AND OPEN COMPETITION FOR ROTARY MAINTENANCE SERVICES
KIRTLAND AFB
Offeror May Add Information to Footer if Inclined
File details come from the government source that posted it. Updated .