HVAC_Bidder_Solicitation_Grid (1).xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- SRC0000032018
- Issued by
- Ashland County, Ohio
About this file
The document is an HVAC Bidder Solicitation Grid spreadsheet for a multi-county contract opportunity covering HVAC, maintenance, and related technical services across five counties. The solicitation includes comprehensive pricing categories for various service types, including regular, non-regular, and holiday/emergency service hours for multiple technical roles such as HVAC technicians, boiler/chiller technicians, plumbers, BAU service technicians, and electricians. Each county section provides a detailed grid for trip charges and hourly rates across different service classifications, with a sample calculation provided using "Kate's HVAC" from Portage County to demonstrate pricing methodology.
The pricing structure allows for a 10% markup on materials (calculated at 110%), with a sample scenario using a $5,000 material cost resulting in a $5,500 total materials charge. The bid grid is designed to capture precise pricing for various service scenarios, including trip charges ranging from $50-$80 depending on service type, and hourly rates that similarly vary based on service classification and time of service (regular, non-regular, or holiday/emergency). While the template shows placeholder $0.00 values for most entries, the sample calculation reveals the intended pricing approach, with hourly rates typically at $50 for regular hours, $70 for non-regular hours, and $80 for holiday/emergency hours.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HVAC_Bidder_Solicitation_Grid (1).xlsx | XLSX spreadsheet | |
| HVAC_County_Facilities_ACS_Bid.xlsx | XLSX spreadsheet | |
| Affirmation_and_Disclosure_Form_5-20-24_fillable_form.pdf | ||
| DAS Standard_T_C_3-31-25.pdf | ||
| RFQ_HVAC_Secondary_Solicitation - NE.docx | DOCX document | |
| Addendum to Bid Quote Base Template (Non-Federal Funds)_Rev. 2024 09 13.docx | DOCX document | |
| DAS Standard_T_C_3-31-25.pdf | ||
| Addendum to Bid Quote Base Template (Non-Federal Funds)_Rev. 2024 09 13.docx | DOCX document | |
| RFQ_HVAC_Secondary_Solicitation - NE.docx | DOCX document | |
| Affirmation_and_Disclosure_Form_5-20-24_fillable_form.pdf | ||
| HVAC County Facilities ACS Bid.xlsx | XLSX spreadsheet |
Show all 11
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 .