Bid Schedule_IWT.xlsx
XLSX spreadsheet 35 KB Posted
- Solicitation number
- FA860126R0018
About this file
This is a Bid Schedule pricing template for the Industrial Water Test & Treatment Services contract at Wright-Patterson Air Force Base. Offerors must enter unit prices for nine Contract Line Item Numbers (CLINs) across multiple performance periods: a base period (January 1 – December 31, 2027), four option years (2028–2031), and a six-month extension (January 1 – June 30, 2032). The pricing schedule is structured as a combination Firm Fixed Price and Requirements acquisition, with CLINs identified as Requirements not guaranteed minimum quantities and payment based on actual quantities furnished. Services include cooling tower and system service (12 months each for main facility and medical center), heating system service (12 months each for main facility and medical center), metallurgical analysis (15 each), embrittlement analysis (2 each), resin analysis (10 each), steam purity analysis (2 each), and studies (4 each). All pricing must align with the Performance Work Statement and cover all supervision, personnel, equipment, transportation, materials, and services necessary to perform the work. The spreadsheet automatically calculates yearly totals for each period and a summary tab that computes total proposed pricing across all performance periods. Six-month extension pricing 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 Jan 2027 - 31 Dec 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 | 15 | EACH | $ - 0 | |
| 0006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 0007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 0008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 0009 | Provide Services for Studies | 4 | 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 Jan 2028 - 31 Dec 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 | 15 | EACH | $ - 0 | |
| 1006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 1007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 1008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 1009 | Provide Services for Studies | 4 | 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 Jan 2029 - 31 Dec 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 | 15 | EACH | $ - 0 | |
| 2006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 2007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 2008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 2009 | Provide Services for Studies | 4 | 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 Jan 2030 - 31 Dec 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 | 15 | EACH | $ - 0 | |
| 3006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 3007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 3008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 3009 | Provide Services for Studies | 4 | 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 Jan 2031 - 31 Dec 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 | 15 | EACH | $ - 0 | |
| 4006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 4007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 4008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 4009 | Provide Services for Studies | 4 | 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 Jan 2032 - 30 Jun 2032 in accordance with the PWS. | DO NOT PRICE THIS LINE ITEM | ||||
| 5001 | Provide Services for Cooling Towers & System Service | 12 | MO | $ - 0 | |
| 5002 | Provide Services for Cooling Towers & System Service - Medical Center | 12 | MO | $ - 0 | |
| 5003 | Provide Services for Heating Systems | 12 | MO | $ - 0 | |
| 5004 | Provide Services for Heating Systems - Medical Center | 12 | MO | $ - 0 | |
| 5005 | Provide Services for Metallurgical Analysis | 15 | EACH | $ - 0 | |
| 5006 | Provide Services for Embrittlement Analysis | 2 | EACH | $ - 0 | |
| 5007 | Provide Services for Resin Analysis | 10 | EACH | $ - 0 | |
| 5008 | Provide Services for Steam purity Analysis | 2 | EACH | $ - 0 | |
| 5009 | Provide Services for Studies | 4 | 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 ERROR:#VALUE!
File details come from the government source that posted it. Updated .