Pricing_Spreadsheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Boiler Maintenance and Repair
- Solicitation number
- 26-0107-ITB
- Issued by
- Pinellas County, Clewiston City, Florida
About this file
Summary of Boiler Maintenance & Repair Pricing Spreadsheet
This is a pricing spreadsheet for a boiler maintenance and repair contract with Pinellas County, Florida, covering preventative maintenance services across five county facilities. The contract encompasses boiler maintenance at three primary locations: the Detention Campus (DET) at 14400 49th Street North in Clearwater with multiple boiler systems across various divisions; the Mid-County (MID) facilities including the Gulf Coast Museum of Art, Animal Services, Medical Examiner, and Vet Tech facility in Largo; and Utilities facilities including Logan Lab Building B in Largo. The scope requires monthly site visits, quarterly preventative maintenance inspections, annual preventative maintenance inspections, and all associated reporting requirements including written reports and monthly logs. The contract specifies that additional repairs, equipment, or parts discovered during routine inspections require separate invoicing and prior county approval. The contract term is five years, with pricing to be submitted by bidders for annual and five-year term totals across all facility groups and service categories.
The pricing spreadsheet establishes that bidders must provide unit prices for yearly and quarterly maintenance visits across all boiler systems, with quantities specified for each service type. Service calls are categorized by regular hourly rates (7:00 A.M. to 3:30 P.M.) and after-hours rates (including evenings, weekends, and holidays), with an estimated 500 annual service hours budgeted for each rate category. Replacement parts are to be compensated at list price minus a contractor-submitted discount percentage, with an estimated annual parts spend of $50,000 and five-year total of $250,000. The spreadsheet indicates an estimated annual contract total of $50,000 with a five-year term total of $250,000 based on parts only, plus an unspecified 10 percent contingency valued at $25,000 for a total contract not-to-exceed of $275,000 over the five-year term. All maintenance cost pricing must be all-encompassing to cover the preventative maintenance program requirements without additional charges to the county.
View the file
Other files
Show all 19
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
Boiler Maintenance & Repair
| Boiler Maintenance & Repair |
| Cost for Preventative Maintenance (PM) Services must be all-encompassing, to include the following: Monthly site visits; Quarterly PM, Annual PM, and all reporting requirements (i.e. written reports and monthly logs). |
| Note: All other repairs, equipment or parts not associated with the requirements for the Preventative Maintenance (PM) Program, discovered during routine inspections will require separate invoicing and prior Pinellas County approval before any of the work is conducted by the vendor for that service. |
Note: one quarterly maintenance will be performed during the annual inspection
| Line | CPM Locations | Description | Date of Last Performed Service | Quantity | Unit Price | QTY | Annual Cost | 5 years |
| GROUP A - DET | ||||||||
| 1 | DET - 14400 49th St N, Clearwater - Central Division | Patterson-Kelly AK20-98-8969 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 2 | DET - 14400 49th St N, Clearwater - Central Division | Patterson-Kelly AK20-98-8969 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 3 | DET - 14400 49th St N, Clearwater - Central Division | Rite Hot Water 26589 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 4 | DET - 14400 49th St N, Clearwater - Central Division | Rite Hot Water 26589 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 5 | DET - 14400 49th St N, Clearwater - Central Division | Rite Hot Water 26588 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 6 | DET - 14400 49th St N, Clearwater - Central Division | Rite Hot Water 26588 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 7 | DET - 14400 49th St N, Clearwater - Max Security Kitchen | Aldrich, LP Steam 99E-7739 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 8 | DET - 14400 49th St N, Clearwater - Max Security Kitchen | Aldrich, LP Steam 99E-7739 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 9 | DET - 14400 49th St N, Clearwater - Max Security Kitchen | Aldrich, LP Steam 98E-7394 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 10 | DET - 14400 49th St N, Clearwater - Max Security Kitchen | Aldrich, LP Steam 98E-7394 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 11 | DET - 14400 49th St N, Clearwater - Phase 1 | Patterson- Kelley AA46-88-0529 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 12 | DET - 14400 49th St N, Clearwater - Phase 1 | Patterson- Kelley AA46-88-0529 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 13 | DET - 14400 49th St N, Clearwater - Phase 2 | Patterson-Kelley AR39-05-28654 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 14 | DET - 14400 49th St N, Clearwater - Phase 2 | Patterson-Kelley AR39-05-28654 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 15 | DET - 14400 49th St N, Clearwater - Healthcare | Patterson-Kelley AR36-05-28553 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 16 | DET - 14400 49th St N, Clearwater - Healthcare | Patterson-Kelley AR36-05-28553 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 17 | DET - 14400 49th St N, Clearwater - Healthcare | Patterson- Kelley AR36-05-28555 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 18 | DET - 14400 49th St N, Clearwater - Healthcare | Patterson-Kelley AR36-05-28555 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 19 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Bryan 101290 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 20 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Bryan 101290 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 21 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Bryan 101297 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 22 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Bryan 101297 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 23 | DET - 14400 49th St N, Clearwater - South Division | Lochinvar 1921114934879 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 24 | DET - 14400 49th St N, Clearwater - South Division | Lochinvar 1921114934879 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 25 | DET - 14400 49th St N, Clearwater - South Division | Lochinvar 1921114934880 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 26 | DET - 14400 49th St N, Clearwater - South Division | Lochinvar 1921114934880 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 27 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 1719106085715, Mod# SNA501-125 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 28 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 1719106085715, Mod# SNA501-125 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 29 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 1719106085716, Mod# SNA501-125 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 30 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 1719106085715, Mod# SNA501-125 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| 31 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 171916085717, Mod# SNA501-125 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 | |
| 32 | DET - 14400 49th St N, Clearwater - Infrastructure Bldg | Lochinvar 171916085717, Mod# SNA501-125 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 | |
| DET - GROUP A - ANNUAL TOTAL | $ - 0 | $ - 0 | ||||||
| DET - GROUP A - TERM TOTAL (5 years) |
| GROUP B - MID | |||||||
| 33 | MID - 12211-A Walsingham Rd, Largo - Main - Gulf Coast Museum of Art | Futrua III 11981815 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 34 | MID - 12211-A Walsingham Rd, Largo - Main - Gulf Coast Museum of Art | Futrua III 11981815 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 35 | MID - 12450 Ulmerton Rd, Largo - Animal Services - Admin/Hospital | Raypak Gas 1409385205 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 36 | MID - 12450 Ulmerton Rd, Largo - Animal Services - Admin/Hospital | Raypak Gas 1409385205 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 37 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205826 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 38 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205826 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 39 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205827 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 40 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205827 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 41 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205829 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 42 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205829 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 43 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205828 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 44 | MID - 10900 Ulmerton Rd, Largo - Medical Examiner | Raypak Gas 302205828 | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 45 | MID - 12376 Ulmerton Rd, Largo - Vet Tech | Raypak Gas V372500526, Mod# H7-0800B | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 46 | MID - 12376 Ulmerton Rd, Largo - Vet Tech | Raypak Gas V372500526, Mod# H7-0800B | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| 47 | MID - 12376 Ulmerton Rd, Largo - Vet Tech | Raypak Gas V372500527, Mod# H7-0800B | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 48 | MID - 12376 Ulmerton Rd, Largo - Vet Tech | Raypak Gas V372500527, Mod# H7-0800B | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| GROUP B - ANNUAL TOTAL | $ - 0 | $ - 0 | |||||
| GROUP B - TERM TOTAL (5 years) | |||||||
| GROUP C - UTILITIES | |||||||
| 49 | Utilities - Logan Lab, Building B,1620 Ridge Road, Largo | Mighty Therm II, MT2H1000PACK1CJX, C18286660, 2018 | Yearly | $ - 0 | 1 | $ - 0 | $ - 0 |
| 50 | Utilities - Logan Lab, Building B,1620 Ridge Road, Largo | Raypak Gas V372500527, Mod# H7-0800B | Quarterly | $ - 0 | 3 | $ - 0 | $ - 0 |
| GROUP C - ANNUAL TOTAL | $ - 0 | $ - 0 | |||||
| GROUP C - TERM TOTAL (5 years) |
| SERVICE CALLS | ||||
| Service Call Type | Rate | Annual Service Hours | Annual | 5-Years |
| Regular Hourly Rate (7:00 AM - 3:30 PM) | $ - 0 | 500 | $ - 0 | $ - 0 |
| After Hours Rate (Including evenings, weekends, & holidays) | $ - 0 | 500 | $ - 0 | $ - 0 |
| Service Calls - ANNUAL TOTAL | $ - 0 | $ - 0 | ||
| Service Calls - TERM TOTAL (5 years) |
| PARTS | ||||
| Discount % off List | ESTIMATED ANNUAL PARTS SPEND | $ 50,000.00 | Five Year Total | $ 250,000.00 |
| Annual | TERM (5-Year) | |
| GROUP A - DET | $ - 0 | $ - 0 |
| GROUP B - MID | $ - 0 | $ - 0 |
| GROUP C - UTILITIES | $ - 0 | $ - 0 |
| Service Calls - Regular Hours | $ - 0 | $ - 0 |
| Service Calls - After Hours | $ - 0 | $ - 0 |
| Parts | $ 50,000.00 | $ 250,000.00 |
| ANNUAL CONTRACT TOTAL | $ 50,000.00 | $ 250,000.00 |
| TERM (5 year) CONTRACT TOTAL |
| UNSPECIFIED 10% of Contract Total | $ 25,000.00 | $ 275,000.00 |
| (Will not be used to determine award) | Contract NTE |
File details come from the government source that posted it. Updated .