Attch. 33 O&M Services Price Workbook (blank template).xls
XLS spreadsheet 98 KB Posted
- Solicitation number
- 191BWC26R0009
About this file
This is a blank pricing workbook template for Operation and Maintenance (O&M) Services for the Southbay Integrated Wastewater Treatment Plant (SBIWTP). The template is designed to capture annual costs across a base year (April 1, 2027 – March 31, 2028) and four option years through March 31, 2032, with 2% annual increases applied to each option year. Offerors must provide cost estimates for two facility capacity scenarios: 25 MGD (million gallons per day) and an additional 10 MGD configuration.
The pricing structure requires itemized costs across labor, material, and equipment categories, including direct labor/salaries, fringe benefits, vehicle/fleet expenses, office supplies, and chemicals (ferric chloride, sodium hypochlorite, sodium hydroxide, lime, anionic polymer, cationic polymer, sulfuric acid, and water softener salt). Additional line items include laboratory services, repairs and maintenance, sediment removal, capital expenditure repairs, asset management software, SCADA systems, permits and licenses, subcontract costs, insurance and bonds, overhead allocation, 8% taxes, and profit margin. The template also includes a reference chemical list with dosing information and approximate annual consumption rates for a 35 MGD facility to assist offerors in developing realistic cost estimates. Supporting documentation sections require personnel salary breakdowns and repairs/maintenance cost justifications, though these are noted as non-scoring informational elements.
View the file
Other files
Show all 37
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
Summary
| OFFEROR: | ||
| Date: | ||
| SCOPE OF WORK: Operation and Maintenance Services for SBIWTP | ||
| SUMMARY OF ANNUAL COSTS | ||
| Period | Dates | Cost |
| Base Year | April 1, 2027- March 31, 2028 | $0.00 |
| 1st Option Year | April 1, 2028- March 31, 2029 | $0.00 |
| 2nd Option Year | April 1, 2029- March 31, 2030 | $0.00 |
| 3rd Option Year | April 1, 2030- March 31, 2031 | $0.00 |
| 4th Option Year | April 1, 2031- March 31, 2032 | $0.00 |
| Total | $0.00 |
25MGD Cost Estimate
| Sunday, December 31, 1899 | ||||||||||
| SCOPE OF WORK: Operation and Maintenance Services for SBIWTP | ||||||||||
| Base Period April 1, 2027 through March 31, 2028 | ||||||||||
| ITEM | DESCRIPTION | QTY | UNIT | LABOR | MATERIAL | EQUIPMENT | TOTAL | |||
| unit $ | Total | unit $ | Total | unit $ | Total | |||||
| 1 | Direct Labor/ Salaries | |||||||||
| 2 | Fringe Benefits | |||||||||
| 3 | Vehicle/Fleet Expenses | |||||||||
| Fuel | ||||||||||
| 4 | Office Supplies | |||||||||
| 5 | Chemicals | |||||||||
| Ferric Chloride | 0.0 | tons | 609.34 | |||||||
| Sodium Hypochloride | 0.0 | gal | 1.12 | |||||||
| Sodium Hydroxide | 0.0 | tons | 700.00 | |||||||
| Lime | 0.0 | tons | 208.00 | |||||||
| Anionic Polymer | 0.0 | lbs | 2.80 | |||||||
| Cationic Polymer | 0.0 | lbs | 2.05 | |||||||
| Sulfuric Acid | 0.0 | gal | 4.73 | |||||||
| Water Softener Salt | 0.0 | tons | 400.00 | |||||||
| 6 | Laboratory Services | |||||||||
| 7 | Repairs and Maintenance | |||||||||
| 8 | Canyon Collectors/Sediment Removal/Trash removal | |||||||||
| 9 | Capital Expenditure Repairs | |||||||||
| 10 | Asset Management Software | 0.00 | 0.00 | |||||||
| 11 | SCADA | 0.00 | ||||||||
| 12 | Permits, Licenses | 0.00 | 0.00 | |||||||
| Sub Total | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| 13 | Sub Contract Costs | |||||||||
| Insurance and Bonds | ||||||||||
| Sub Total | ||||||||||
| Overhead % | 0.00 | |||||||||
| Taxes @ 8% | 0.00 | |||||||||
| Sub Total | 0.00 | |||||||||
| Profit % | 0.00 | |||||||||
| Grand Total | ||||||||||
| 1ST YEAR OPTION 2% increase | $0.00 | 2029 | ||||||||
| 2ND YEAR OPTION 2% increase | $0.00 | 2030 | ||||||||
| 3RD YEAR OPTION 2% increase | $0.00 | 2031 | ||||||||
| 4TH YEAR OPTION 2% increase | $0.00 | 2032 |
Add'l 10MGD Cost Estimate
| Sunday, December 31, 1899 | ||||||||||
| SCOPE OF WORK: Operation and Maintenance Services for SBIWTP | ||||||||||
| Base Period April 1, 2027 through March 31, 2028 | ||||||||||
| ITEM | DESCRIPTION | QTY | UNIT | LABOR | MATERIAL | EQUIPMENT | TOTAL | |||
| unit $ | Total | unit $ | Total | unit $ | Total | |||||
| 1 | Direct Labor/ Salaries | |||||||||
| 2 | Fringe Benefits | |||||||||
| 3 | Vehicle/Fleet Expenses | |||||||||
| Fuel | ||||||||||
| 4 | Office Supplies | |||||||||
| 5 | Chemicals | |||||||||
| Ferric Chloride | 0.0 | tons | 609.34 | |||||||
| Sodium Hypochloride | 0.0 | gal | 1.12 | |||||||
| Sodium Hydroxide | 0.0 | tons | 700.00 | |||||||
| Lime | 0.0 | tons | 208.00 | |||||||
| Anionic Polymer | 0.0 | lbs | 2.80 | |||||||
| Cationic Polymer | 0.0 | lbs | 2.05 | |||||||
| Sulfuric Acid | 0.0 | gal | 4.73 | |||||||
| Water Softener Salt | 0.0 | tons | 400.00 | |||||||
| 6 | Laboratory Services | |||||||||
| 7 | Repairs and Maintenance | |||||||||
| 8 | Canyon Collectors/Sediment Removal/Trash removal | |||||||||
| 9 | Capital Expenditure Repairs | |||||||||
| 10 | Asset Management Software | 0.00 | 0.00 | |||||||
| 11 | SCADA | 0.00 | ||||||||
| 12 | Permits, Licenses | 0.00 | 0.00 | |||||||
| Sub Total | 0.00 | 0.00 | 0.00 | 0.00 | ||||||
| 13 | Sub Contract Costs | |||||||||
| Insurance and Bonds | ||||||||||
| Sub Total | ||||||||||
| Overhead % | 0.00 | |||||||||
| Taxes @ 8% | 0.00 | |||||||||
| Sub Total | 0.00 | |||||||||
| Profit % | 0.00 | |||||||||
| Grand Total | ||||||||||
| 1ST YEAR OPTION 2% increase | $0.00 | 2029 | ||||||||
| 2ND YEAR OPTION 2% increase | $0.00 | 2030 | ||||||||
| 3RD YEAR OPTION 2% increase | $0.00 | 2031 | ||||||||
| 4TH YEAR OPTION 2% increase | $0.00 | 2032 |
Salaries, Personnel breakdown
| Sunday, December 31, 1899 | |
| Instructions: Provide a breakdown of Personnel and Salaries. This does not count against or affect the vendor's ratings. |
Repairs & Maint. breakdown
| Sunday, December 31, 1899 | |
| Instructions: Provide a Repairs and Maintenance Avg cost, to the best of your knowledge. This does not count against or affect the vendor's ratings. |
REF. Chemicals List Breakdown
| REFERENCE | ||
| Annual Chemical Expenses~ 35MGD | ||
| Location, Chemical | Dose | Approximate Consumption per year |
| H2S Control, Ferric Chloride | 9.5 mg/l | 204,588 gal |
| CEPT, Ferric Chloride | *14.9 mg/l | 329,088 gal |
| CEPT, Anionic Polymer | *0.20 mg/l | 7,248 |
| Belt Press, Cationic Polymer | 12.67 lbs/ton | 888,468 gal |
| Belt Press, Lime | 0.0 lbs/ton | 0.0 tons |
| Odor Control, Sodium Hypochlorite | >575 mv | 196,272 gal |
| Odor Control, Sodium Hydroxide | >9.0 pH | 13,932 gal |
| Odor Control, Sulfuric Acid | <4.0 pH | 960 gal |
| Reclaim Water Chlorine | 0.0 mg/l | 0 gal |
REF. Labs. Sampling svcs.
| REFERENCE |
| See Attachment 23 |
File details come from the government source that posted it. Updated .