ATTACHMENT_3_PRICING_MATRIX.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- KC-135 Aero-I SATCOM Replacement Federal contract opportunity
- Solicitation number
- KC-135_Aero-I
About this file
This document contains a pricing matrix for the C/KC-135 Aero-I Satellite Communication replacement contract. The pricing matrix provides instructions for offerors to input proposed unit prices for labor, materials, and integration costs for installing Iridium satellite communications systems on 400 C/KC-135 aircraft from 2019 to 2024. Prices should be provided for touch labor, kits, over and above labor rates, and material overhead rates for the U.S. Air Force as well as optional sales to Turkey and France. Offerors must also provide rates for first article installations in year one and integration in years three through five. The total evaluated price will be automatically calculated based on the input unit prices. Responses to the pricing matrix are due by close of business on April 30, 2018.
Pricing Matrix
View the file
Other files for this federal contract opportunity
Show all 38
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
Calculation Methodology
| C/KC-135 AERO-I Satellite Communication (SATCOM) Replacement | ||
| CLIN | DESCRIPTION | CALCULATION METHODOLOGY |
| xx01 | Install - Touch Labor Only | Proposed unit price multiplied by quantity |
| xx02 | Contractor Field Team Travel | Not Evaluated (Cost Reimbursable) |
| xx05 | A Kit - Material Only | Proposed unit price multiplied by quantity |
| xx06 | B Kit - Material Only | Proposed unit price multiplied by quantity |
| xx07 | Data | Not Separately Priced |
| 0008 | First Article - Block 40 | Proposed unit price multiplied by quantity |
| 0009 | First Article - Block 45 | Proposed unit price multiplied by quantity |
| xx10 | Integration | Proposed unit price multiplied by quantity (provide one lot price) |
| xx03 | Over & Above Labor Rate | Proposed hourly labor rate multiplied by the estimated labor hours in Column C |
| xx04 | Over & Above Material Handling/Overhead Rate | Proposed material rate multiplied by the estimated material dollars in Column C |
TOTAL EVALUATED PRICE The TEP is calculated ast the sum of the following CLINS: xx01 (Years 2, 3, 4, and 5) xx05 (Years 2, 3, 4, and 5) xx06 (Years 2, 3, 4, and 5) 0008 (Year 1) 0009 (Year 1) xx03 (Years 2, 3, 4, and 5) xx04 (Years 2, 3, 4, and 5) xx10 (Years 3, 4, and 5)
&14ATTACHMENT 3
PRICING MATRIX
Instructions
| Source Selection Information - See FAR 2.101 and 3.104 | |
| C/KC-135 AERO-I Satellite Communications (SATCOM) Replacement | |
| Attachment 3 | |
| 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 3 - PRICING MATRIX |
| C/KC-135 AERO-I SATELLITE COMMUNICATIONS (SATCOM) REPLACEMENT |
| USE DATA BELOW TO PROVIDE QUOTE |
| PERIOD OF PERFORMANCE | PRICE |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD - YEAR 1 | $0.00 |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD - YEAR 2 | $0.00 |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD - YEAR 3 | $0.00 |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD - YEAR 4 | $0.00 |
| ESTIMATED TOTAL PRICE FOR ORDERING PERIOD - YEAR 5 | $0.00 |
| TOTAL EVALUATED PRICE (TEP) = (5 YEAR ORDERING PERIOD) | $0.00 |
| ORDERING PERIOD - YEAR 1 (ESTIMATED 6 DEC 2019 - 5 DEC 2020) | |||||
| CLIN | CLIN DESCRIPTION | ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0001 | Touch Labor for Aero-I Installation (USAF) | 0 | Each | $0.00 | |
| 0005 | A Kit - Material Only (USAF) | 0 | Each | $0.00 | |
| 0006 | B Kit - Material Only (USAF) | 0 | Each | $0.00 | |
| 0008 | First Article - Block 40 (USAF) | 1 | Each | $0.00 | |
| 0009 | First Article - Block 45 (USAF) | 1 | Each | $0.00 | |
| TOTAL EVALUATED PRICE (YEAR 1) | $0.00 |
| ORDERING PERIOD - YEAR 2 (ESTIMATED 6 DEC 2020 - 5 DEC 2021) | |||||
| CLIN | CLIN DESCRIPTION | ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0101 | Touch Labor for Aero-I Installation (USAF) | 27 | Each | $0.00 | |
| 0105 | A Kit - Material Only (USAF) | 55 | Each | $0.00 | |
| 0106 | B Kit - Material Only (USAF) | 61 | Each | $0.00 | |
| CLIN | OVER & ABOVE (LABOR) | ESTIMATED LABOR HOURS | RATE ($) | TOTAL PRICE | |
| 0103 | Over & Above Rate - Installation Labor (USAF) - (Based on 27 Installs) | 270 | $0.00 | ||
| CLIN | OVER & ABOVE (MATERIAL) | ESTIMATED MATERIAL DOLLARS | RATE (%) | TOTAL PRICE | |
| 0104 | Over & Above Rate - Installation Material Overhead Rate (USAF) - (Based on 27 A Kits) | $135,000 | $0.00 | ||
| TOTAL EVALUATED PRICE (YEAR 2) | $0.00 |
| ORDERING PERIOD - YEAR 3 (ESTIMATED 6 DEC 2021 - 5 DEC 2022) | |||||
| CLIN | CLIN DESCRIPTION | ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0201 | Touch Labor for Aero-I Installation (USAF) | 36 | Each | $0.00 | |
| 0205 | A Kit - Material Only (USAF) | 110 | Each | $0.00 | |
| 0206 | B Kit - Material Only (USAF) | 121 | Each | $0.00 | |
| 1201 | Touch Labor for Aero-I Installation (Optional FMS - Turkey) | 3 | Each | $0.00 | |
| 1205 | A Kit - Material Only (Optional FMS - Turkey) | 3 | Each | $0.00 | |
| 1206 | B Kit - Material Only (Optional FMS - Turkey) | 3 | Each | $0.00 | |
| 1210 | Integration (Optional FMS - Turkey) | 1 | Each | $0.00 | |
| 2201 | Touch Labor for Aero-I Installation (Optional FMS - France) | 1 | Each | $0.00 | |
| 2205 | A Kit - Material Only (Optional FMS - France) | 1 | Each | $0.00 | |
| 2206 | B Kit - Material Only (Optional FMS - France) | 2 | Each | $0.00 | |
| 2210 | Integration (Optional FMS - France) | 1 | Each | $0.00 | |
| CLIN | OVER & ABOVE (LABOR) | ESTIMATED LABOR HOURS | RATE ($) | TOTAL PRICE | |
| 0203 | Over & Above Rate - Installation Labor (USAF) - (Based on 36 Installs) | 360 | $0.00 | ||
| 1203 | Over & Above Rate - Installation Labor (Optional FMS - Turkey) - (Based on 3 Installs) | 30 | $0.00 | ||
| 2203 | Over & Above Rate - Installation Labor (Optional FMS - France) - (Based on 1 Install) | 10 | $0.00 | ||
| CLIN | OVER & ABOVE (MATERIAL) | ESTIMATED MATERIAL COSTS | RATE (%) | TOTAL PRICE | |
| 0204 | Over & Above Rate - Installation Material Handling/Overhead Rate (USAF) - (Based on 36 A Kits) | $180,000 | $0.00 | ||
| 1204 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - Turkey) - (Based on 3 A Kits) | $15,000 | $0.00 | ||
| 2204 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - France) - (Based on 1 A Kit) | $5,000 | $0.00 | ||
| TOTAL EVALUATED PRICE (YEAR 3) | $0.00 |
| ORDERING PERIOD - YEAR 4 (ESTIMATED 6 DEC 2022 - 5 DEC 2023) | |||||
| CLIN | CLIN DESCRIPTION | ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0301 | Touch Labor for Aero-I Installation (USAF) | 36 | Each | $0.00 | |
| 0305 | A Kit - Material Only (USAF) | 110 | Each | $0.00 | |
| 0306 | B Kit - Material Only (USAF) | 121 | Each | $0.00 | |
| 1301 | Touch Labor for Aero-I Installation (Optional FMS - Turkey) | 2 | Each | $0.00 | |
| 1305 | A Kit - Material Only (Optional FMS - Turkey) | 2 | Each | $0.00 | |
| 1306 | B Kit - Material Only (Optional FMS - Turkey) | 3 | Each | $0.00 | |
| 1310 | Integration (Optional FMS - Turkey) | 1 | Each | $0.00 | |
| 2301 | Touch Labor for Aero-I Installation (Optional FMS - France) | 1 | Each | $0.00 | |
| 2305 | A Kit - Material Only (Optional FMS - France) | 1 | Each | $0.00 | |
| 2306 | B Kit - Material Only (Optional FMS - France) | 1 | Each | $0.00 | |
| 2310 | Integration (Optional FMS - France) | 1 | Each | $0.00 | |
| CLIN | OVER & ABOVE (LABOR) | ESTIMATED LABOR HOURS | RATE ($) | TOTAL PRICE | |
| 0303 | Over & Above Rate - Installation Labor (USAF) - (Based on 36 Installs) | 360 | $0.00 | ||
| 1303 | Over & Above Rate - Installation Labor (Optional FMS - Turkey) - (Based on 2 Installs) | 20 | $0.00 | ||
| 2303 | Over & Above Rate - Installation Labor (Optional FMS - France) - (Based on 1 Install) | 10 | $0.00 | ||
| CLIN | OVER & ABOVE (MATERIAL) | ESTIMATED MATERIAL COSTS | RATE (%) | TOTAL PRICE | |
| 0304 | Over & Above Rate - Installation Material Handling/Overhead Rate (USAF) - (Based on 36 A Kits) | $180,000 | $0.00 | ||
| 1304 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - Turkey) - (Based on 2 A Kits) | $10,000 | $0.00 | ||
| 2304 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - France) - (Based on 1 A Kit) | $5,000 | $0.00 | ||
| TOTAL EVALUATED PRICE (YEAR 4) | $0.00 |
| ORDERING PERIOD - YEAR 5 (ESTIMATED 6 DEC 2023 - 5 DEC 2024) | |||||
| CLIN | CLIN DESCRIPTION | ESTIMATED QUANTITY | UNIT OF ISSUE | UNIT PRICE | TOTAL PRICE |
| 0401 | Touch Labor for Aero-I Installation (USAF) | 35 | Each | $0.00 | |
| 0405 | A Kit - Material Only (USAF) | 84 | Each | $0.00 | |
| 0406 | B Kit - Material Only (USAF) | 92 | Each | $0.00 | |
| 1401 | Touch Labor for Aero-I Installation (Optional FMS - Turkey) | 2 | Each | $0.00 | |
| 1405 | A Kit - Material Only (Optional FMS - Turkey) | 2 | Each | $0.00 | |
| 1406 | B Kit - Material Only (Optional FMS - Turkey) | 3 | Each | $0.00 | |
| 1410 | Integration (Optional FMS - Turkey) | 1 | Each | $0.00 | |
| 2401 | Touch Labor for Aero-I Installation (Optional FMS - France) | 1 | Each | $0.00 | |
| 2406 | A Kit - Material Only (Optional FMS - France) | 1 | Each | $0.00 | |
| 2206 | B Kit - Material Only (Optional FMS - France) | 1 | Each | $0.00 | |
| 2410 | Integration (Optional FMS - France) | 1 | Each | $0.00 | |
| CLIN | OVER & ABOVE (LABOR) | ESTIMATED LABOR HOURS | RATE ($) | TOTAL PRICE | |
| 0403 | Over & Above Rate - Installation Labor (USAF) - (Based on 35 Installs) | 350 | $0.00 | ||
| 1403 | Over & Above Rate - Installation Labor (Optional FMS - Turkey) - (Based on 2 Installs) | 20 | $0.00 | ||
| 2403 | Over & Above Rate - Installation Labor (Optional FMS - France) - (Based on 1 Install) | 10 | $0.00 | ||
| CLIN | OVER & ABOVE (MATERIAL) | ESTIMATED MATERIAL COSTS | RATE (%) | TOTAL PRICE | |
| 0404 | Over & Above Rate - Installation Material Handling/Overhead Rate (USAF) - (Based on 35 A Kits) | $175,000 | $0.00 | ||
| 1404 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - Turkey) - (Based on 2 A Kits) | $10,000 | $0.00 | ||
| 2404 | Over & Above Rate - Installation Material Handling/Overhead Rate (Optional FMS - France) - (Based on 1 A Kit) | $5,000 | $0.00 | ||
| TOTAL EVALUATED PRICE (YEAR 5) | $0.00 |
SOURCE SELECTION INFORMATION - SEE FAR 2.101 and FAR 3.104
SOURCE SELECTION INFORMATION - SEE FAR 2.101 and FAR 3.104
File details come from the government source that posted it. Updated .