HVAC_Bidder_Solicitation_Grid.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- SRC0000032056
- Issued by
- Erie County, Ohio
About this file
The document is an HVAC Bidder Solicitation Grid, a pricing grid for multi-county HVAC and related technical service contracts covering five counties. The solicitation covers comprehensive maintenance and service pricing across multiple technical disciplines including HVAC technicians, boiler/chiller technicians, plumbers, pipe fitters, BAU service technicians, and electricians. The grid provides detailed pricing structures for three distinct service categories: regular service hours, non-regular service hours, and holiday/emergency service hours, with each category including trip charges and hourly rates for different technical specialties.
The pricing model includes a 10% markup on materials (calculated at 110% of supplier cost), with a sample scenario using a supplier named Kate's HVAC from Portage County demonstrating the pricing calculation. The sample scenario shows varied pricing for different service types, with regular service hours priced at $50 per hour, non-regular service hours at $70 per hour, and holiday/emergency service hours at $80 per hour. Trip charges also vary by service type, ranging from $50 for regular hours to $80 for holiday/emergency hours. The grid is structured to allow suppliers from each of the five counties to submit their specific pricing, though in the provided example, all county grids are currently populated with $0.00 placeholders.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| OWC HVAC.xlsx | XLSX spreadsheet | |
| RFQ.docx | DOCX document |
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
Supplier Bid County 1 Supplier Name: County:
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Regular Service Hours | 10 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Non-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Holiday/Emergency Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | $5,000 | Supplier cost of materials needed | $0.00 |
Total $0.00
Supplier Bid County 2 Supplier Name: County:
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Regular Service Hours | 10 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Non-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Holiday/Emergency Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | $5,000 | Supplier cost of materials needed | $0.00 |
Total $0.00
Supplier Bid County 3 Supplier Name: County:
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Regular Service Hours | 10 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Non-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Holiday/Emergency Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | $5,000 | Supplier cost of materials needed | $0.00 |
Total $0.00
Supplier Bid County 4 Supplier Name: County:
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Regular Service Hours | 10 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Non-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Holiday/Emergency Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | $5,000 | Supplier cost of materials needed | $0.00 |
Total $0.00
Supplier Bid County 5 Supplier Name: County:
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Regular Service Hours | 10 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Non-Regular Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Non-Regular Service Hours | 2 | hours | $0.00 | |
| Trip Charge-Holiday/Emergency Service Hours | 1 | trip | $0.00 | |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly BAU Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Hourly Electrician Service-Holiday/Emergency Service Hours | 2 | hours | $0.00 | |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | $5,000 | Supplier cost of materials needed | $0.00 |
Total $0.00
Sample Calculation Supplier Name: Kate's HVAC County: Portage
| Item Description | Price for one unit (hour, trip, etc.) | Sample Scenario | Total Cost | |
| Trip Charge-Regular Service Hours | $50.00 | 1 | trip | $50.00 |
| Hourly HVAC Technician Service-Regular Service Hours | $50.00 | 10 | hours | $500.00 |
| Hourly Boiler/Chiller Technician-Regular Service Hours | $50.00 | 2 | hours | $100.00 |
| Hourly Plumber and Pipe Fitter Service-Regular Service Hours | $50.00 | 2 | hours | $100.00 |
| Hourly BAU Service-Regular Service Hours | $50.00 | 2 | hours | $100.00 |
| Hourly Electrician Service-Regular Service Hours | $50.00 | 2 | hours | $100.00 |
| Trip Charge-Non-Regular Service Hours | $70.00 | 1 | trip | $70.00 |
| Hourly HVAC Technician Service-Non-Regular Service Hours | $70.00 | 2 | hours | $140.00 |
| Hourly Boiler/Chiller Technician-Non-Regular Service Hours | $70.00 | 2 | hours | $140.00 |
| Hourly Plumber and Pipe Fitter Service-Non-Regular Service Hours | $70.00 | 2 | hours | $140.00 |
| Hourly BAU Service-Non-Regular Service Hours | $70.00 | 2 | hours | $140.00 |
| Hourly Electrician Service-Non-Regular Service Hours | $70.00 | 2 | hours | $140.00 |
| Trip Charge-Holiday/Emergency Service Hours | $80.00 | 1 | trip | $80.00 |
| Hourly HVAC Technician Service-Holiday/Emergency Service Hours | $80.00 | 2 | hours | $160.00 |
| Hourly Boiler/Chiller Technician-Holiday/Emergency Service Hours | $80.00 | 2 | hours | $160.00 |
| Hourly Plumber and Pipe Fitter Service-Holiday/Emergency Service Hours | $80.00 | 2 | hours | $160.00 |
| Hourly BAU Service-Holiday/Emergency Service Hours | $80.00 | 2 | hours | $160.00 |
| Hourly Electrician Service-Holiday/Emergency Service Hours | $80.00 | 2 | hours | $160.00 |
| Materials and Parts Markup over Supplier Cos t- 10% markup = 110% for calculation | 110% | $5,000 | Supplier cost of materials needed | $5,500.00 |
| Total | $8,100.00 |
File details come from the government source that posted it. Updated .