Supplier Bid Response.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
DNR facilities Plumbing Contract awarded by County
Solicitation number
SRC0000034884
Issued by
Ashland County, Ohio

About this file

This is a Supplier Bid Response template for plumbing services across five counties. The document outlines service offerings for emergency, regular business hours, and non-normal business hours service calls. The bid structure requires suppliers to provide pricing for trip charges, hourly rates for licensed plumbers and pipe fitters, and hourly rates for apprentice plumbers across all three service categories. Additionally, suppliers must specify their materials and parts markup percentage over supplier cost, with the template providing a sample calculation showing a 110% markup applied to a $1,000 materials cost for a total bid of $1,520.00.

The template is designed to standardize pricing submissions across five geographic jurisdictions (County 1 through County 5), allowing for comparative analysis of supplier costs. Each county section includes identical line items for trip charges and hourly labor rates, enabling the procuring entity to evaluate proposals consistently. The sample calculation section demonstrates the bid structure with example rates of $50 per trip charge and $50 per hour for plumber services, $40 per hour for apprentice services, and a materials markup calculation. All five county bid sections are currently blank with $0.00 entries, indicating this is a template awaiting supplier completion with actual pricing data.

View the file

Other files

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 DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours1Hour$0.00
Hourly Apprentice Plumber Service - Regular Service Hours1Hour$0.00
Trip Charge - non-Normal Business Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours1Hour$0.00
Hourly Apprentice Plumber Service - non-Normal Business Hours1Hour$0.00
Trip Charge - Emergency Service1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Emergency Service1Hour$0.00
Hourly Apprentice Plumber Service - Emergency Service1Hour$0.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)$1,000Supplier cost of materials needed$0.00

Total $0.00

Supplier Bid County 2 Supplier Name: County:

Item DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours1Hour$0.00
Hourly Apprentice Plumber Service - Regular Service Hours1Hour$0.00
Trip Charge - non-Normal Business Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours1Hour$0.00
Hourly Apprentice Plumber Service - non-Normal Business Hours1Hour$0.00
Trip Charge - Emergency Service1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Emergency Service1Hour$0.00
Hourly Apprentice Plumber Service - Emergency Service1Hour$0.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)$1,000Supplier cost of materials needed$0.00

Total $0.00

Supplier Bid County 3 Supplier Name: County:

Item DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours1Hour$0.00
Hourly Apprentice Plumber Service - Regular Service Hours1Hour$0.00
Trip Charge - non-Normal Business Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours1Hour$0.00
Hourly Apprentice Plumber Service - non-Normal Business Hours1Hour$0.00
Trip Charge - Emergency Service1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Emergency Service1Hour$0.00
Hourly Apprentice Plumber Service - Emergency Service1Hour$0.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)$1,000Supplier cost of materials needed$0.00

Total $0.00

Supplier Bid County 4 Supplier Name: County:

Item DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours1Hour$0.00
Hourly Apprentice Plumber Service - Regular Service Hours1Hour$0.00
Trip Charge - non-Normal Business Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours1Hour$0.00
Hourly Apprentice Plumber Service - non-Normal Business Hours1Hour$0.00
Trip Charge - Emergency Service1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Emergency Service1Hour$0.00
Hourly Apprentice Plumber Service - Emergency Service1Hour$0.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)$1,000Supplier cost of materials needed$0.00

Total $0.00

Supplier Bid County 5 Supplier Name: County:

Item DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours1Hour$0.00
Hourly Apprentice Plumber Service - Regular Service Hours1Hour$0.00
Trip Charge - non-Normal Business Hours1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours1Hour$0.00
Hourly Apprentice Plumber Service - non-Normal Business Hours1Hour$0.00
Trip Charge - Emergency Service1Occurrence$0.00
Hourly Plumber and Pipe Fitter Service - Emergency Service1Hour$0.00
Hourly Apprentice Plumber Service - Emergency Service1Hour$0.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)$1,000Supplier cost of materials needed$0.00

Total $0.00

Sample Calculation Supplier Name: County:

Item DescriptionPrice for one unit (hour, trip, etc.)Sample ScenarioTotal Cost
Trip Charge - Regular Service Hours$501Occurrence$50.00
Hourly Plumber and Pipe Fitter Service - Regular Service Hours$501Hour$50.00
Hourly Apprentice Plumber Service - Regular Service Hours$401Hour$40.00
Trip Charge - non-Normal Business Hours$501Occurrence$50.00
Hourly Plumber and Pipe Fitter Service - non-Normal Business Hours$501Hour$50.00
Hourly Apprentice Plumber Service - non-Normal Business Hours$401Hour$40.00
Trip Charge - Emergency Service$501Occurrence$50.00
Hourly Plumber and Pipe Fitter Service - Emergency Service$501Hour$50.00
Hourly Apprentice Plumber Service - Emergency Service$401Hour$40.00
Materials and Parts Markup over Supplier Cost (Ex: 10% markup = 110% for calculation)110%$1,000Supplier cost of materials needed$1,100.00

Total $1,520.00

File details come from the government source that posted it. Updated .