Attachment 6_ Pricing Matrix.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Engine Water Wash Services
- Solicitation number
- FA862626RB001
About this file
This is a Pricing Matrix template for jet engine water wash services that offerors must complete and submit as part of their proposal response. The matrix requires offerors to input proposed unit prices for engine water wash services across five geographic regions (West, Central, Midwest, Southeast, and Northeast) and for various jet engine types, including the F108-CF-100/201 (KC-135R/T), TF33-P-103 (B-52H), F139-PW-100 (KC-46A), TF33-P-100A (E-3B/G), and F138-GE-100 (C-5M), plus on-site cancellation fees. The pricing structure covers a one-year base period and four one-year option periods, with a six-month option period also included. Unit prices must be rounded to the nearest whole dollar and entered only in yellow-highlighted cells across specified rows.
The matrix automatically calculates extended prices by multiplying proposed unit prices by estimated quantities provided for each line item and contract line item number (CLIN). The estimated annual quantities vary by region and engine type, ranging from single-digit quantities in some regions to over 80 washes annually for certain engine types. A separate line item (SLIN X006) addresses data and reports for all regions with non-specified pricing (NSP). The total evaluated price (TEP) automatically calculates at the bottom of the spreadsheet, providing a comprehensive pricing proposal across the entire contract period from the base year through all option years, with the six-month option priced at the same rate as Option Year 4.
View the file
Other files
Show 40 more
50 files 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
PRICING MATRIX
FOR
JET ENGINE WATER WASH SERVICES
ATTACHMENT 7
| Instructions to complete this Pricing Matrix: | |
| 1 | Offerors are to input the proposed unit prices into the Pricing Matrix spreadsheet in all YELLOW highlighted cells (Rows 7, 8, 9, 10, 13, 14, 15, 16, 17, 20, 21, 24, 25, 26, 27, 28, 31, 32, 33 and 34). |
| 2 | Rounding: All unit prices shall be rounded to the nearest whole dollar. |
| 3 | The extended price will be automatically calculated by multiplying the proposed unit price by the best estimated quantity. |
| 4 | Extended totals will be automatically calculated at the bottom of each year. |
| 5 | The Total Evaluated Price (TEP) will automatically calculate at the bottom of the pricing matrix. |
Pricing Matrix Pricing Matrix
| Unit Price | |||||||
| Year | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | 6 Month Option | |
| X= | 0 | 1 | 2 | 3 | 4 | Priced at Option Year 4 |
(X=5)
IAW FAR 52.232-8
| CLIN | X001 | West Region | 0001 | 1001 | 2001 | 3001 | 4001 | 5001 |
| SLIN | X001AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AB | TF33-P-103 (B-52H) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL WEST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X002 | Central Region | 0002 | 1002 | 2002 | 3002 | 4002 | 5002 |
| SLIN | X002AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AD | TF33- P-100A (E-3B/G) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AF | Test Cell (F108-CF-100) | $ - 0 | $ - 0 | ||||
| SLIN | X002AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL CENTRAL REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X003 | Midwest Region | 0003 | 1003 | 2003 | 3003 | 4003 | 5003 |
| SLIN | X003AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X003AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL MIDWEST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X004 | Southeast Region | 0004 | 1004 | 2004 | 3004 | 4004 | 5004 |
| SLIN | X004AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AB | TF33-P-103 (B-52H) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AE | F138-GE-100 (C-5M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SOUTHEAST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X005 | Northeast Region | 0005 | 1005 | 2005 | 3005 | 4005 | 5005 |
| SLIN | X005AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AE | F138-GE-100 (C-5M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL NORTHEAST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| SLIN | X006 | Data and Reports (ALL REGIONS) | NSP | NSP | NSP | NSP | NSP | NSP |
| *Per Occurrence | ||||||||
| Estimated Quantities | ||||||||
| CLIN | X001 | West Region | 0001 | 1001 | 2001 | 3001 | 4001 | 5001 |
| SLIN | X001AA | F108-CF-100/201 (KC-135R/T) | 76 | 76 | 76 | 76 | 76 | 38 |
| SLIN | X001AB | TF33-P-103 (B-52H) | 24 | 16 | 16 | 16 | 24 | 12 |
| SLIN | X001AC | F139-PW-100 (KC-46A) | 26 | 26 | 26 | 26 | 26 | 13 |
| SLIN | X001AG | On-Site Cancellation of Scheduled Washes* | 1 | 1 | 1 | 1 | 1 | 1 |
| TOTAL WEST REGION | ||||||||
| CLIN | X002 | Central Region | 0002 | 1002 | 2002 | 3002 | 4002 | 5002 |
| SLIN | X002AA | F108-CF-100/201 (KC-135R/T) | 68 | 68 | 68 | 68 | 68 | 34 |
| SLIN | X002AC | F139-PW-100 (KC-46A) | 44 | 44 | 44 | 44 | 44 | 22 |
| SLIN | X002AD | TF33- P-100A (E-3B/G) | 32 | 32 | 32 | 32 | 32 | 16 |
| SLIN | X002AF | Test Cell (F108-CF-100) | 20 | 10 | ||||
| SLIN | X002AG | On-Site Cancellation of Scheduled Washes* | 1 | 1 | 1 | 1 | 1 | 1 |
| TOTAL CENTRAL REGION | ||||||||
| CLIN | X003 | Midwest Region | 0003 | 1003 | 2003 | 3003 | 4003 | 5003 |
| SLIN | X003AA | F108-CF-100/201 (KC-135R/T) | 72 | 72 | 72 | 72 | 72 | 36 |
| SLIN | X003AG | On-Site Cancellation of Scheduled Washes* | 1 | 1 | 1 | 1 | 1 | 1 |
| TOTAL MIDWEST REGION | ||||||||
| CLIN | X004 | Southeast Region | 0004 | 1004 | 2004 | 3004 | 4004 | 5004 |
| SLIN | X004AA | F108-CF-100/201 (KC-135R/T) | 36 | 36 | 36 | 36 | 36 | 18 |
| SLIN | X004AB | TF33-P-103 (B-52H) | 80 | 80 | 80 | 80 | 80 | 40 |
| SLIN | X004AC | F139-PW-100 (KC-46A) | 20 | 20 | 20 | 20 | 20 | 10 |
| SLIN | X004AE | F138-GE-100 (C-5M) | 16 | 16 | 16 | 16 | 16 | 8 |
| SLIN | X004AG | On-Site Cancellation of Scheduled Washes* | 1 | 1 | 1 | 1 | 1 | 1 |
| TOTAL SOUTHEAST REGION | ||||||||
| CLIN | X005 | Northeast Region | 0005 | 1005 | 2005 | 3005 | 4005 | 5005 |
| SLIN | X005AA | F108-CF-100/201 (KC-135R/T) | 48 | 48 | 48 | 48 | 48 | 24 |
| SLIN | X005AC | F139-PW-100 (KC-46A) | 72 | 72 | 72 | 72 | 72 | 36 |
| SLIN | X005AE | F138-GE-100 (C-5M) | 52 | 52 | 52 | 52 | 52 | 52 |
| SLIN | X005AG | On-Site Cancellation of Scheduled Washes* | 1 | 1 | 1 | 1 | 1 | 1 |
| TOTAL NORTHEAST REGION | ||||||||
| SLIN | X006 | Data and Reports (ALL REGIONS) | NSP | NSP | NSP | NSP | NSP | NSP |
| *Per Occurrence | ||||||||
| Extended Totals | ||||||||
| CLIN | X001 | West Region | 0001 | 1001 | 2001 | 3001 | 4001 | 5001 |
| SLIN | X001AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AB | TF33-P-103 (B-52H) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X001AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL WEST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X002 | Central Region | 0002 | 1002 | 2002 | 3002 | 4002 | 5002 |
| SLIN | X002AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AD | TF33- P-100A (E-3B/G) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X002AF | Test Cell (F108-CF-100) | $ - 0 | $ - 0 | ||||
| SLIN | X002AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL CENTRAL REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X003 | Midwest Region | 0003 | 1003 | 2003 | 3003 | 4003 | 5003 |
| SLIN | X003AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X003AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL MIDWEST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X004 | Southeast Region | 0004 | 1004 | 2004 | 3004 | 4004 | 5004 |
| SLIN | X004AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AB | TF33-P-103 (B-52H) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AE | F138-GE-100 (C-5M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X004AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SOUTHEAST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| CLIN | X005 | Northeast Region | 0005 | 1005 | 2005 | 3005 | 4005 | 5005 |
| SLIN | X005AA | F108-CF-100/201 (KC-135R/T) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AC | F139-PW-100 (KC-46A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AE | F138-GE-100 (C-5M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SLIN | X005AG | On-Site Cancellation of Scheduled Washes* | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL NORTHEAST REGION | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| SLIN | X006 | Data and Reports (ALL REGIONS) | NSP | NSP | NSP | NSP | NSP | NSP |
| EXTENDED TOTALS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| *Per Occurrence |
File details come from the government source that posted it. Updated .