Copy of Bid Schedule_IWT_Amend2.xlsx
XLSX spreadsheet 33 KB Posted
- Solicitation number
- FA860126R0018
About this file
This is a pricing schedule template for a firm fixed price and requirements contract for industrial water test and treatment services at Wright-Patterson Air Force Base (WPAFB). Offerors must enter unit prices for nine contract line items (CLINs) across a base period, four option years, and a six-month extension, with pricing periods running from December 1, 2026 through May 31, 2032. The services include cooling tower and system maintenance (12 months annually, 6 months for extension), heating system services for general facilities and medical center operations, and five analytical services each performed annually: metallurgical analysis (5 occurrences), embrittlement analysis (1 occurrence), resin analysis (5 occurrences), steam purity analysis (5 occurrences), and studies (5 occurrences), with reduced quantities during the six-month extension period. CLINs identified with double asterisks denote requirements-based line items with no guaranteed minimum quantities; contractors will be paid only for actual quantities furnished. The spreadsheet automatically calculates yearly totals for each performance period and a summary tab provides the total proposed price across all contract periods. Offerors must populate only the yellow-shaded cells with unit prices; all line items must align with the Performance Work Statement, and pricing for the six-month extension must match Option Year 4 pricing.
View the file
Other files
Show all 14
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
| Attachment 2 - Pricing Schedule Instructions |
| FA8601-XX-X-XXXX: Insustrial Water Test & Treatment Services |
The offeror shall enter proposed prices for each Contract Line Item Number (CLIN), which corresponds to a service/task in the Performance Work Statement (PWS). The pricing schedule is broken out by performance period. There are tabs for the Base Period, Option Yr. 1, Option Yr. 2, Option Yr. 3, Option Yr. 4, and the 6-month extension which are indicated as such at the bottom of the spread sheet window. The 6-month extension pricing shall be the same as the Option Yr. 4 pricing.
The offeror shall enter the proposed price per unit into each CLIN for the respective performance period. All cells that the offeror shall populate are shaded in yellow.
YEARLY PRICE - The yearly price for each performance period is automatically totaled under the tab for the respective performance period.
SUMMARY TAB - The "Summary" tab automatically calculates the total proposed price for all performance periods.
Base Year
| Start Date - End Date (ex. 1 October 2014 - 30 September 2015) | |||||
| FOR OFFICIAL USE ONLY | |||||
| CUSTODIAL CONTRACT | |||||
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | UNIT PRICE | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2026 - 30 Nov 2027 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 0001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 0002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 0003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 0004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 0005 | Provide Services for Metallurgical Analysis | 5 | EACH | $ - 0 | |
| 0006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 0007 | Provide Services for Resin Analysis | 5 | EACH | $ - 0 | |
| 0008 | Provide Services for Steam purity Analysis | 5 | EACH | $ - 0 | |
| 0009 | Provide Services for Studies | 5 | EACH | $ - 0 | |
| TOTAL CLINs 0001 through 0009 | $ - 0 |
Option Yr. 1
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | UNIT PRICE | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2027 - 30 Nov 2028 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 1001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 1002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 1003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 1004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 1005 | Provide Services for Metallurgical Analysis | 5 | EACH | $ - 0 | |
| 1006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 1007 | Provide Services for Resin Analysis | 5 | EACH | $ - 0 | |
| 1008 | Provide Services for Steam purity Analysis | 5 | EACH | $ - 0 | |
| 1009 | Provide Services for Studies | 5 | EACH | $ - 0 | |
| TOTAL CLINs 1001 through 1009 | $ - 0 |
Option Yr. 2
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | UNIT PRICE | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2028 - 30 Nov 2029 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 2001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 2002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 2003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 2004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 2005 | Provide Services for Metallurgical Analysis | 5 | EACH | $ - 0 | |
| 2006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 2007 | Provide Services for Resin Analysis | 5 | EACH | $ - 0 | |
| 2008 | Provide Services for Steam purity Analysis | 5 | EACH | $ - 0 | |
| 2009 | Provide Services for Studies | 5 | EACH | $ - 0 | |
| TOTAL CLINs 2001 through 2009 | $ - 0 |
Option Yr. 3
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | PRICE PER SF | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2029 - 30 Nov 2030 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 3001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 3002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 3003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 3004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 3005 | Provide Services for Metallurgical Analysis | 5 | EACH | $ - 0 | |
| 3006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 3007 | Provide Services for Resin Analysis | 5 | EACH | $ - 0 | |
| 3008 | Provide Services for Steam purity Analysis | 5 | EACH | $ - 0 | |
| 3009 | Provide Services for Studies | 5 | EACH | $ - 0 | |
| TOTAL CLINs 3001 through 3009 | $ - 0 |
Option Yr. 4
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | PRICE PER SF | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2030 - 30 Nov 2031 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 4001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 4002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 4003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 4004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 4005 | Provide Services for Metallurgical Analysis | 5 | EACH | $ - 0 | |
| 4006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 4007 | Provide Services for Resin Analysis | 5 | EACH | $ - 0 | |
| 4008 | Provide Services for Steam purity Analysis | 5 | EACH | $ - 0 | |
| 4009 | Provide Services for Studies | 5 | EACH | $ - 0 | |
| TOTAL CLINs 4001 through 4012 | $ - 0 |
6 mo Ext
| Industrial Water Test & Treatment | |||||
| This excel spreadsheet has been set up to calculate total dollar values for each year. Only insert the UNIT PRICE for each line item . All line items shall be in accordance with the Performance Work Statement (PWS). This is a performance-based acquisition and the Contractor is responsible for ensuring the service is completed in accordance with the standard outlined in the PWS. This is a combination Firm Fixed Price and Requirements acquisition.CLINs identified with "**" are Requirements. The Requirements CLIN's designated are not guaranteed by the Government for any minimum amount of quantities. The Contractor will be paid based on actual quantities furnished. | |||||
| CLIN NO. | SUPPLIES/SERVICE | QTY | UNIT | UNIT PRICE | YEARLY PRICE |
| NON-PERSONAL SERVICES:Provide all supervision, personnel, equipment, transportation, material, and other items and services necessary to perform Industrial Water Test & Treatment at WPAFB for the period 01 Dec 2031 - 31 May 2032 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 5001 | Provide Services for Cooling Towers & System Service | 6 | MO | $ - 0 | |
| 5002 | Provide Services for Cooling Towers & System Service - Medical Center | 6 | MO | $ - 0 | |
| 5003 | Provide Services for Heating Systems | 6 | MO | $ - 0 | |
| 5004 | Provide Services for Heating Systems - Medical Center | 6 | MO | $ - 0 | |
| 5005 | Provide Services for Metallurgical Analysis | 3 | EACH | $ - 0 | |
| 5006 | Provide Services for Embrittlement Analysis | 1 | EACH | $ - 0 | |
| 5007 | Provide Services for Resin Analysis | 3 | EACH | $ - 0 | |
| 5008 | Provide Services for Steam purity Analysis | 3 | EACH | $ - 0 | |
| 5009 | Provide Services for Studies | 3 | EACH | $ - 0 | |
| TOTAL CLINs 5001 through 5012 | $ - 0 |
SUMMARY
| Industrial Water Test & Treatment | |
| Year | Price |
| Base Period | $0.00 |
| 01 Jan 2027 - 31 Dec 2027 |
| Option Yr. 1 | $0.00 |
| 01 Jan 2028 - 31 Dec 2028 |
| Option Yr. 2 | $0.00 |
| 01 Jan 2029 - 31 Dec 2029 |
| Option Yr. 3 | $0.00 |
| 01 Jan 2030 - 31 Dec 20230 |
| Option Yr. 4 | $0.00 |
| 01 Jan 2031 - 31 Dec 2031 |
| 6-Month Extension | $0.00 |
| 1 Jan 2032 - 30 Jun 2032 |
TOTAL CONTRACT PRICE $0.00
File details come from the government source that posted it. Updated .