ITB_32110-13905_SWC_700_Cost_Proposal_Final.xlsx
XLSX spreadsheet 918 KB Posted
- Solicitation number
- Event 32110-13905
- Issued by
- Davidson County, Tennessee
About this file
This is a cost proposal template for State of Tennessee Statewide Contract (SWC) #700 for Electrical, HVAC, Plumbing, Boiler, and Chiller Systems Maintenance & Repair. The contract seeks qualified respondents to provide maintenance and repair services across Tennessee counties organized into four geographic regions. The solicitation includes five distinct job groups: Electrical, HVAC, Plumbing, Boiler, and Chiller maintenance and repair services. Respondents are not required to bid on all job groups or regions but must provide complete pricing for all four labor categories (Technician Regular Time, Technician Premium Time, Helper Regular Time, and Helper Premium Time) for any region or county they elect to serve. Up to five responsive and responsible respondents will be awarded contracts per county for the Electrical job group in Hardin, Henderson, and Henry counties. The response due date is May 22, 2026, by 2:00 pm Central Time. The contract structure breaks out four high-volume counties (Davidson, Hamilton, Knox, and Shelby) separately from regional pricing to account for their disproportionately higher usage under the current statewide contract.
Respondents must submit hourly labor rates and trip charges by county for all services selected. The cost proposal template includes estimated annual labor hour quantities and job quantities for each county to assist respondents in pricing their responses. Purple cells in the spreadsheet indicate where respondents should enter pricing information, and the template automatically calculates total estimated costs by county based on submitted rates. Respondents may leave fields blank or respond with "N/A" for counties or regions they are not bidding. The spreadsheet provides historical usage data from the current statewide contract as reference information, including estimated annual quantity of jobs and labor hour breakdowns by skill level and pay status for each geographic area. Regional pricing applies to all counties within a region except the four separately-priced high-volume counties, which must receive distinct labor rates if the respondent is serving that region.
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
1 Instructions
| State of Tennessee | |||
| SWC #700 Electrical, HVAC, Plumbing, Boiler, and Chiller Systems Maintenance & Repair | Response Due Date: | ||
| May 22, 2026 by 2:00 pm Central Time |
| Cost Proposal | Respondent's Company Name: |
| Your Name: | |
| Instructions for Submitting a Price Response: | Email: |
| Phone: | |
| Respondents will find three (3) tabs on this spreadsheet. There are instructions provided on this Tab (1 Instructions) detailing how to complete the cost proposal model. Respondents should begin by entering their company and contact information in the YELLOW Cells F7-F10 to the right side of this tab. |
Tab 1 - Instructions Tab 2 - Electrical Maintenance & Repair Tab 3 - Region List
| Contract Award Structure: See Contract Terms and Conditions Section 2.1 for details surrounding the Contract Award Structure. Up to five (5) responsive and responsible Respondents will be awarded a Contract per County for the Electrical job group for Hardin, Henderson, & Henry counties. Contractors will receive a designation of either A, B, C, D, or E Contractor in their County for the Electrical job group for Hardin, Henderson, & Henry counties. |
| As stated below in the instructions for the "Job Group One: Electrical (Tab 2)" below, the State is requesting Labor Rates for Hardin, Henderson, & Henry counties in Tennessee, indicated as "Region 4:Technician - Regular Time, Technician - Premium Time,Helper - Regular Time, & Helper - Premium Time" in cells F10:I10. If a Respondent provides pricing for any county in a particular Region, they must also provide pricing for all four (4) labor categories in that Region. For example, if the Respondent is responding to service only Henderson and Hardin counties, the Respondent must provide pricing for all four (4) labor categories in Region 4. |
As stated below in the instructions for the "Job Group One: Electrical (Tab 2)" below, the State is requesting Trip Charges by County for Hardin, Henderson, & Henry counties. For all Counties in which the Respondent selects "yes" to provide service, they must also provide their proposed Trip Charge.
Respondents should also refer to each Tab they have interest in responding to for specific instructions for that Tab.
| Job Group One: Electrical (Tab 2) | |
| Step One | Identify which counties you will be responding to provide service in by selecting "Yes" in Column C, Rows 10-12. Alternatively, select "No" in Colum C if you will not be responding to provide service in the listed county. |
| Step Two | After selecting the counties in which you are responding, you will need to provide the hourly labor rates in Columns F, G, H, & I in Row 7 for Region 4. The estimated annual labor hours incurred under the current statewide contract are included for your reference in Columns F, G, H, & I in Rows 10-12 for each county. |
| Step Three | Davidson, Hamilton, Knox, and Shelby Counties are the four (4) counties in Tennessee which have the highest usage from the current statewide contract. These four (4) counties will be priced out separately and should not be taken into consideration when providing regional pricing. If responding for any of these four (4) counties, Respondents should provide labor rates in Columns F, G, H, & I in Rows 11-14. For example, if you are responding to service Region 1 in its entirety, you must provide the labor rates for Region 1 and labor rates for Knox County. These two (2) rates (Region and Knox) will be broken out on the contract. The same applies to the largest County in each Region. |
| Step Three | For every County you are responding to provide service in that you identified as "Yes" in Column C, Respondents must provide the Trip Charge for each County in Column J, Rows 10-12. |
| Job Group Two: HVAC (Tab 3) | |
| Step One | Identify which counties you will be responding to provide service in by selecting "Yes" in Column C, Rows 18-114. Alternatively, select "No" in Colum C if you will not be responding to provide service in the listed county. |
| Step Two | After selecting the counties in which you are responding, you will need to provide the hourly labor rates in Columns F, G, H, & I in Rows 7-10 for each Region. The estimated annual labor hours incurred under the current statewide contract are included for your reference in Columns F, G, H, & I in Rows 18-114 for each county. |
| Step Three | Davidson, Hamilton, Knox, and Shelby Counties are the four (4) counties in Tennessee which have the highest usage from the current statewide contract. These four (4) counties will be priced out separately and should not be taken into consideration when providing regional pricing. If responding for any of these four (4) counties, Respondents should provide labor rates in Columns F, G, H, & I in rows 11-14. For example, if you are responding to service Region 1 in its entirety, you must provide the labor rates for Region 1 and labor rates for Knox County. These two (2) rates (Region and Knox) will be broken out on the contract. The same applies to the largest County in each Region. |
| Step Four | For every County you are responding to provide service in that you identified as "Yes" in Column C, Respondents must provide the Trip Charge for each County in Column J, Rows 18-114. |
| Job Group Three: Plumbing (Tab 4) | |
| Step One | Identify which counties you will be responding to provide service in by selecting "Yes" in Column C, Rows 18-114. Alternatively, select "No" in Colum C if you will not be responding to provide service in the listed county. |
| Step Two | After selecting the counties in which you are responding, you will need to provide the hourly labor rates in Columns F, G, H, & I in Rows 7-10 for each Region. The estimated annual labor hours incurred under the current statewide contract are included for your reference in Columns F, G, H, & I in Rows 18-114 for each county. |
| Step Three | Davidson, Hamilton, Knox, and Shelby Counties are the four (4) counties in Tennessee which have the highest usage from the current statewide contract. These four (4) counties will be priced out separately and should not be taken into consideration when providing regional pricing. If responding for any of these four (4) counties, Respondents should provide labor rates in Columns F, G, H, & I in rows 11-14. For example, if you are responding to service Region 1 in its entirety, you must provide the labor rates for Region 1 and labor rates for Knox County. These two (2) rates (Region and Knox) will be broken out on the contract. The same applies to the largest County in each Region. |
| Step Four | For every County you are responding to provide service in that you identified as "Yes" in Column C, Respondents must provide the Trip Charge for each County in Column J, Rows 18-114. |
| Job Group Four: Boiler (Tab 5) | |
| Step One | Identify which counties you will be responding to provide service in by selecting "Yes" in Column C, Rows 18-114. Alternatively, select "No" in Colum C if you will not be responding to provide service in the listed county. |
| Step Two | After selecting the counties in which you are responding, you will need to provide the hourly labor rates in Columns F, G, H, & I in Rows 7-10 for each Region. The estimated annual labor hours incurred under the current statewide contract are included for your reference in Columns F, G, H, & I in Rows 18-114 for each county. |
| Step Three | Davidson, Hamilton, Knox, and Shelby Counties will be priced out separately and should not be taken into consideration when providing regional pricing. If responding for any of these four (4) counties, Respondents should provide labor rates in Columns F, G, H, & I in rows 11-14. For example, if you are responding to service Region 1 in its entirety, you must provide the labor rates for Region 1 and labor rates for Knox County. These two (2) rates (Region and Knox) will be broken out on the contract. The same applies to the largest County in each Region. |
| Step Four | For every County you are responding to provide service in that you identified as "Yes" in Column C, Respondents must provide the Trip Charge for each County in Column J, Rows 18-114. |
| Job Group Four: Chiller (Tab 6) | |
| Step One | Identify which counties you will be responding to provide service in by selecting "Yes" in Column C, Rows 18-114. Alternatively, select "No" in Colum C if you will not be responding to provide service in the listed county. |
| Step Two | After selecting the counties in which you are responding, you will need to provide the hourly labor rates in Columns F, G, H, & I in Rows 7-10 for each Region. The estimated annual labor hours incurred under the current statewide contract are included for your reference in Columns F, G, H, & I in Rows 18-114 for each county. |
| Step Three | Davidson, Hamilton, Knox, and Shelby Counties will be priced out separately and should not be taken into consideration when providing regional pricing. If responding for any of these four (4) counties, Respondents should provide labor rates in Columns F, G, H, & I in rows 11-14. For example, if you are responding to service Region 1 in its entirety, you must provide the labor rates for Region 1 and labor rates for Knox County. These two (2) rates (Region and Knox) will be broken out on the contract. The same applies to the largest County in each Region. |
| Step Four | For every County you are responding to provide service in that you identified as "Yes" in Column C, Respondents must provide the Trip Charge for each County in Column J, Rows 18-114. |
LOOKUP
ELECTRICIAN REGION 1 ELECTRICIAN REGION 3
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| ANDERSON | 3 | 97 | 1 | 38 | 1 | BEDFORD | 1 | 8 | 1 | 1 | 1 |
| BLOUNT | 1 | 5 | 1 | 4 | 1 | CHEATHAM | 1 | 46 | 1 | 44 | 1 |
| CAMPBELL | 7 | 73 | 2 | 34 | 1 | DAVIDSON | 80 | 985 | 48 | 763 | 30 |
| CARTER | 1 | 5 | 1 | 2 | 1 | DICKSON | 3 | 38 | 1 | 16 | 1 |
| COCKE | 6 | 65 | 1 | 40 | 2 | GILES | 4 | 41 | 1 | 9 | 1 |
| GREENE | 1 | 22 | 11 | 21 | 1 | HICKMAN | 3 | 28 | 1 | 15 | 1 |
| HAMBLEN | 9 | 121 | 2 | 61 | 4 | HUMPHREYS | 6 | 80 | 1 | 57 | 1 |
| HAWKINS | 1 | 12 | 1 | 12 | 1 | LAWRENCE | 2 | 40 | 1 | 2 | 1 |
| JEFFERSON | 1 | 2 | 1 | 1 | 1 | LEWIS | 1 | 11 | 1 | 11 | 1 |
| JOHNSON | 1 | 9 | 8 | 4 | 1 | LINCOLN | 1 | 1 | 1 | 1 | 1 |
| KNOX | 26 | 420 | 6 | 277 | 4 | MARSHALL | 4 | 60 | 1 | 25 | 1 |
| LOUDON | 1 | 4 | 1 | 1 | 1 | MAURY | 2 | 34 | 1 | 40 | 1 |
| MONROE | 1 | 22 | 1 | 17 | 1 | MONTGOMERY | 4 | 54 | 1 | 40 | 1 |
| MORGAN | 5 | 44 | 3 | 34 | 2 | PERRY | 1 | 12 | 1 | 11 | 1 |
| ROANE | 4 | 51 | 1 | 42 | 1 | ROBERTSON | 1 | 2 | 1 | 1 | 1 |
| SEVIER | 1 | 45 | 1 | 39 | 1 | RUTHERFORD | 1 | 26 | 1 | 31 | 1 |
| SULLIVAN | 1 | 10 | 1 | 9 | 1 | SUMNER | 8 | 119 | 2 | 104 | 1 |
| UNICOI | 1 | 11 | 1 | 11 | 1 | WAYNE | 1 | 36 | 1 | 1 | 1 |
| UNION | 4 | 43 | 1 | 29 | 1 | WILLIAMSON | 1 | 8 | 1 | 8 | 1 |
| WASHINGTON | 9 | 133 | 7 | 82 | 1 | WILSON | 3 | 21 | 3 | 15 | 2 |
ELECTRICIAN REGION 2 ELECTRICIAN REGION 2 ELECTRICIAN REGION 4
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| BLEDSOE | 1 | 9 | 1 | 3 | 1 | CARROLL | 2 | 19 | 1 | 1 | 1 |
| BRADLEY | 3 | 28 | 2 | 23 | 2 | CHESTER | 1 | 3 | 1 | 3 | 1 |
| COFFEE | 11 | 121 | 3 | 98 | 1 | CROCKETT | 1 | 1 | 1 | 1 | 1 |
| CUMBERLAND | 5 | 60 | 1 | 31 | 1 | GIBSON | 1 | 9 | 1 | 9 | 1 |
| FENTRESS | 1 | 4 | 1 | 1 | 1 | HARDEMAN | 5 | 116 | 16 | 77 | 7 |
| FRANKLIN | 2 | 18 | 3 | 20 | 1 | HARDIN | 1 | 12 | 1 | 1 | 1 |
| GRUNDY | 1 | 6 | 1 | 6 | 1 | HAYWOOD | 1 | 6 | 1 | 1 | 1 |
| HAMILTON | 22 | 233 | 13 | 140 | 9 | HENRY | 1 | 9 | 1 | 1 | 1 |
| MCMINN | 1 | 9 | 1 | 9 | 1 | LAKE | 1 | 33 | 1 | 1 | 1 |
| OVERTON | 1 | 7 | 1 | 1 | 1 | LAUDERDALE | 13 | 317 | 2 | 69 | 1 |
| PICKETT | 1 | 1 | 1 | 1 | 1 | MADISON | 7 | 108 | 17 | 76 | 1 |
| POLK | 1 | 7 | 1 | 3 | 1 | MCNAIRY | 1 | 2 | 1 | 2 | 1 |
| PUTNAM | 9 | 110 | 1 | 5 | 1 | SHELBY | 30 | 870 | 34 | 137 | 16 |
| SEQUATCHIE | 17 | 155 | 4 | 67 | 3 | ||||||
| VAN BUREN | 2 | 30 | 1 | 21 | 1 | ||||||
| WARREN | 1 | 2 | 1 | 2 | 1 | ||||||
| WHITE | 1 | 1 | 1 | 1 | 1 | ||||||
| HVAC REGION 1 | HVAC REGION 3 |
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| ANDERSON | 7 | 59 | 1 | 46 | 1 | BEDFORD | 1 | 28 | 1 | 1 | 1 |
| BLOUNT | 4 | 49 | 1 | 43 | 1 | CHEATHAM | 1 | 13 | 1 | 1 | 1 |
| CAMPBELL | 8 | 69 | 2 | 47 | 1 | DAVIDSON | 125 | 1318 | 193 | 64 | 1 |
| CARTER | 10 | 53 | 1 | 28 | 10 | DICKSON | 20 | 79 | 43 | 14 | 8 |
| COCKE | 4 | 32 | 1 | 25 | 1 | GILES | 1 | 16 | 1 | 1 | 1 |
| GRAINGER | 1 | 6 | 1 | 3 | 1 | HICKMAN | 5 | 47 | 4 | 1 | 1 |
| GREENE | 32 | 141 | 3 | 25 | 1 | HUMPHREYS | 4 | 79 | 1 | 4 | 4 |
| HAMBLEN | 14 | 91 | 4 | 51 | 2 | LAWRENCE | 6 | 69 | 2 | 1 | 1 |
| HAWKINS | 1 | 16 | 1 | 7 | 1 | MACON | 1 | 11 | 1 | 1 | 1 |
| JOHNSON | 2 | 20 | 1 | 13 | 1 | MARSHALL | 1 | 20 | 1 | 14 | 1 |
| KNOX | 48 | 382 | 7 | 229 | 1 | MAURY | 1 | 8 | 1 | 1 | 1 |
| LOUDON | 1 | 8 | 1 | 6 | 1 | MONTGOMERY | 2 | 36 | 1 | 1 | 1 |
| MONROE | 1 | 3 | 1 | 6 | 1 | PERRY | 1 | 6 | 1 | 1 | 1 |
| MORGAN | 3 | 37 | 1 | 23 | 1 | ROBERTSON | 1 | 2 | 1 | 1 | 1 |
| ROANE | 3 | 35 | 1 | 18 | 1 | RUTHERFORD | 3 | 42 | 1 | 3 | 1 |
| SEVIER | 0 | 7 | 1 | 7 | 1 | SMITH | 1 | 19 | 1 | 1 | 10 |
| SULLIVAN | 13 | 80 | 3 | 31 | 1 | SUMNER | 2 | 21 | 1 | 1 | 1 |
| UNICOI | 1 | 8 | 1 | 7 | 1 | WAYNE | 3 | 35 | 1 | 1 | 1 |
| UNION | 4 | 23 | 1 | 12 | 1 | WILLIAMSON | 1 | 3 | 1 | 1 | 1 |
| WASHINGTON | 10 | 85 | 1 | 47 | 1 | WILSON | 3 | 36 | 2 | 1 | 1 |
| HVAC REGION 2 | HVAC REGION 4 |
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| BLEDSOE | 7 | 51 | 5 | 31 | 1 | BENTON | 1 | 7 | 1 | 2 | 1 |
| BRADLEY | 5 | 28 | 1 | 1 | 1 | CARROLL | 4 | 99 | 1 | 62 | 1 |
| CANNON | 1 | 1 | 2 | 1 | 1 | CHESTER | 12 | 71 | 4 | 1 | 1 |
| COFFEE | 46 | 345 | 13 | 11 | 1 | DYER | 1 | 9 | 1 | 12 | 1 |
| CUMBERLAND | 33 | 112 | 4 | 59 | 1 | GIBSON | 1 | 12 | 1 | 1 | 1 |
| FENTRESS | 8 | 36 | 1 | 23 | 1 | HARDEMAN | 4 | 64 | 1 | 1 | 1 |
| FRANKLIN | 11 | 72 | 9 | 1 | 1 | HARDIN | 22 | 223 | 7 | 32 | 1 |
| GRUNDY | 6 | 20 | 5 | 1 | 1 | HENDERSON | 3 | 34 | 3 | 1 | 1 |
| HAMILTON | 59 | 551 | 10 | 4 | 1 | HENRY | 7 | 67 | 1 | 10 | 3 |
| MARION | 1 | 5 | 1 | 1 | 1 | LAKE | 10 | 78 | 1 | 1 | 1 |
| MCMINN | 5 | 26 | 2 | 6 | 1 | LAUDERDALE | 24 | 361 | 1 | 2 | 1 |
| OVERTON | 6 | 27 | 1 | 15 | 1 | MADISON | 31 | 353 | 6 | 61 | 3 |
| PICKETT | 2 | 10 | 1 | 9 | 1 | MCNAIRY | 3 | 90 | 1 | 77 | 1 |
| POLK | 5 | 27 | 1 | 1 | 1 | OBION | 1 | 33 | 1 | 10 | 1 |
| PUTNAM | 20 | 67 | 3 | 20 | 1 | SHELBY | 50 | 667 | 30 | 42 | 1 |
| RHEA | 1 | 1 | 1 | 1 | 1 | WEAKLEY | 1 | 5 | 1 | 1 | 1 |
| SEQUATCHIE | 25 | 178 | 1 | 4 | 1 | ||||||
| VAN BUREN | 32 | 200 | 38 | 7 | 1 | ||||||
| WARREN | 2 | 4 | 1 | 1 | 1 | ||||||
| WHITE | 2 | 7 | 1 | 1 | 1 | ||||||
| PLUMBING REGION 1 | PLUMBING REGION 3 |
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| ANDERSON | 2 | 18 | 1 | 9 | 1 | BEDFORD | 2 | 41 | 1 | 1 | 1 |
| BLOUNT | 3 | 17 | 1 | 1 | 1 | CHEATHAM | 2 | 11 | 1 | 1 | 1 |
| CAMPBELL | 8 | 43 | 1 | 22 | 3 | DAVIDSON | 47 | 543 | 45 | 13 | 4 |
| CARTER | 2 | 23 | 1 | 9 | 2 | DICKSON | 2 | 12 | 1 | 1 | 1 |
| CLAIBORNE | 1 | 1 | 1 | 1 | 1 | GILES | 6 | 291 | 2 | 1 | 1 |
| COCKE | 8 | 53 | 2 | 21 | 1 | HICKMAN | 1 | 21 | 2 | 1 | 2 |
| GREENE | 7 | 96 | 1 | 1 | 1 | HUMPHREYS | 8 | 87 | 4 | 11 | 1 |
| HAMBLEN | 17 | 214 | 2 | 25 | 7 | LAWRENCE | 4 | 142 | 1 | 1 | 1 |
| HAWKINS | 1 | 4 | 1 | 1 | 1 | LEWIS | 1 | 1 | 1 | 1 | 1 |
| JOHNSON | 3 | 45 | 4 | 1 | 1 | LINCOLN | 1 | 6 | 1 | 1 | 1 |
| KNOX | 27 | 168 | 1 | 114 | 1 | MARSHALL | 4 | 24 | 5 | 3 | 15 |
| LOUDON | 1 | 11 | 1 | 1 | 1 | MAURY | 1 | 2 | 1 | 1 | 1 |
| MONROE | 2 | 13 | 3 | 1 | 1 | MONTGOMERY | 9 | 104 | 4 | 1 | 1 |
| MORGAN | 8 | 48 | 7 | 45 | 2 | PERRY | 1 | 2 | 1 | 1 | 1 |
| ROANE | 4 | 38 | 1 | 4 | 1 | ROBERTSON | 1 | 5 | 1 | 1 | 1 |
| SEVIER | 1 | 2 | 1 | 1 | 1 | RUTHERFORD | 3 | 30 | 1 | 1 | 1 |
| SULLIVAN | 20 | 143 | 8 | 1 | 1 | SMITH | 1 | 3 | 1 | 4 | 1 |
| UNICOI | 1 | 1 | 1 | 1 | 1 | SUMNER | 11 | 47 | 7 | 18 | 4 |
| UNION | 10 | 100 | 3 | 81 | 1 | WAYNE | 1 | 9 | 1 | 1 | 1 |
| WASHINGTON | 14 | 100 | 1 | 1 | 1 | WILLIAMSON | 1 | 6 | 1 | 1 | 1 |
| WILSON | 4 | 38 | 1 | 1 | 1 | ||||||
| PLUMBING REGION 2 | |||||||||||
| PLUMBING REGION 4 | |||||||||||
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | |||||||
| BLEDSOE | 1 | 6 | 1 | 1 | 1 | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | |
| BRADLEY | 1 | 9 | 1 | 2 | 1 | CARROLL | 8 | 140 | 6 | 66 | 3 |
| COFFEE | 19 | 239 | 36 | 4 | 1 | CHESTER | 5 | 45 | 1 | 2 | 1 |
| CUMBERLAND | 13 | 83 | 1 | 62 | 3 | DYER | 1 | 5 | 1 | 1 | 1 |
| FENTRESS | 3 | 15 | 1 | 10 | 1 | GIBSON | 1 | 17 | 1 | 9 | 3 |
| FRANKLIN | 3 | 33 | 4 | 1 | 1 | HARDEMAN | 5 | 50 | 7 | 8 | 4 |
| GRUNDY | 2 | 15 | 1 | 1 | 1 | HARDIN | 15 | 164 | 8 | 135 | 4 |
| HAMILTON | 65 | 443 | 13 | 1 | 1 | HAYWOOD | 1 | 10 | 1 | 8 | 1 |
| MCMINN | 4 | 22 | 9 | 1 | 1 | HENDERSON | 1 | 3 | 1 | 1 | 1 |
| OVERTON | 1 | 4 | 1 | 4 | 1 | HENRY | 4 | 41 | 4 | 23 | 4 |
| PICKETT | 1 | 9 | 1 | 12 | 1 | LAKE | 4 | 47 | 1 | 1 | 1 |
| POLK | 3 | 20 | 1 | 1 | 1 | LAUDERDALE | 14 | 229 | 1 | 1 | 1 |
| PUTNAM | 15 | 66 | 34 | 32 | 4 | MADISON | 46 | 525 | 13 | 286 | 9 |
| RHEA | 1 | 1 | 1 | 1 | 1 | MCNAIRY | 2 | 58 | 1 | 46 | 1 |
| SEQUATCHIE | 58 | 586 | 29 | 1 | 1 | OBION | 1 | 13 | 1 | 9 | 1 |
| VAN BUREN | 6 | 64 | 1 | 5 | 1 | SHELBY | 53 | 576 | 19 | 53 | 31 |
| WARREN | 1 | 6 | 2 | 4 | 1 | TIPTON | 1 | 2 | 2 | 1 | 1 |
| WHITE | 3 | 20 | 1 | 12 | 1 | WEAKLEY | 1 | 2 | 1 | 1 | 1 |
| BOILER REGION 1 | BOILER REGION 3 |
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| JOHNSON | 1 | 6 | 0 | 1 | 1 | DAVIDSON | 36 | 302 | 25 | 3 | 1 |
| KNOX | 1 | 0 | 1 | 1 | 1 | DICKSON | 1 | 20 | 1 | 1 | 1 |
| MORGAN | 1 | 0 | 0 | 1 | 1 | HICKMAN | 3 | 36 | 1 | 1 | 1 |
| MARSHALL | 1 | 5 | 1 | 2 | 1 | ||||||
| BOILER REGION 2 | MONTGOMERY | 1 | 2 | 1 | 1 | 1 | |||||
| RUTHERFORD | 5 | 92 | 5 | 1 | 1 | ||||||
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | WAYNE | 1 | 10 | 1 | 1 | 1 | |
| BLEDSOE | 1 | 6 | 1 | 2 | 36 | WILSON | 1 | 2 | 1 | 1 | 1 |
| COFFEE | 1 | 1 | 1 | 1 | 8 | ||||||
| FENTRESS | 1 | 1 | 1 | 1 | 8 | BOILER REGION 4 | |||||
| PUTNAM | 1 | 1 | 1 | 1 | 1 | ||||||
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | |||||||
| HARDEMAN | 8 | 119 | 2 | 1 | 1 | ||||||
| HARDIN | 2 | 12 | 6 | 1 | 4 | ||||||
| HENRY | 1 | 3 | 1 | 1 | 1 | ||||||
| LAKE | 11 | 57 | 2 | 1 | 1 | ||||||
| LAUDERDALE | 12 | 235 | 4 | 1 | 1 | ||||||
| MADISON | 1 | 18 | 1 | 1 | 1 | ||||||
| SHELBY | 20 | 247 | 10 | 1 | 8 | ||||||
| CHILLER REGION 1 | CHILLER REGION 3 |
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | ||
| CAMPBELL | 1 | 5 | 1 | 1 | 1 | CHEATHAM | 1 | 1 | 1 | 1 | 2 |
| JOHNSON | 4 | 44 | 22 | 1 | 1 | DAVIDSON | 9 | 129 | 25 | 1 | 5 |
| KNOX | 2 | 20 | 3 | 1 | 1 | DICKSON | 1 | 3 | 1 | 1 | 1 |
| MARSHALL | 1 | 2 | 1 | 1 | 1 | ||||||
| CHILLER REGION 2 | RUTHERFORD | 1 | 5 | 1 | 1 | 1 | |||||
| WAYNE | 1 | 5 | 1 | 1 | 1 | ||||||
| Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | |||||||
| BLEDSOE | 1 | 1 | 3 | 1 | 1 | CHILLER REGION 3 | |||||
| CANNON | 1 | 1 | 2 | 1 | 1 | ||||||
| HAMILTON | 1 | 1 | 6 | 1 | 1 | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | |
| PUTNAM | 1 | 1 | 3 | 1 | 1 | CARROLL | 1 | 1 | 1 | 1 | 2 |
| HARDEMAN | 6 | 61 | 9 | 12 | 1 | ||||||
| HARDIN | 1 | 5 | 1 | 1 | 1 | ||||||
| LAKE | 1 | 8 | 1 | 1 | 1 | ||||||
| LAUDERDALE | 2 | 17 | 1 | 1 | 1 | ||||||
| MADISON | 5 | 44 | 1 | 6 | 1 | ||||||
| SHELBY | 10 | 111 | 11 | 8 | 1 |
Electrical LOOKUP
Below Respondents will find the cells to enter pricing for Job Group 1: Electrical Maintenance and Repair. Respondents should refer back to the Instructions Tab for higher level instructions for this event. Respondents must enter a Trip Charge and Hourly Labor Rates pricing for all the County(ies) and Region(s) they wish to cover in this Job Group. Respondents are not required to bid on every County within the Region or all Regions to be considered for award.
In Rows 18-114, as soon as you select "Yes" in Column C for a County, you will be prompted by "InputNeeded" in the corresponding cell in Column J to enter the rate for Trip Charge by County. As soon as you input the Trip Charge, you will be prompted by "InputNeeded" in the Hourly Labor Rates section to provide your labor rates in Columns F, G, H, and I in Rows 7-14, based on the Region(s)/County(ies) in which you will respond. Respondents should reference Tab 7 Region List or the Attachment B Region and County Map document attached to this event to see the counties contained in each Region. Respondents can find the State's Estimated Annual Labor Hour Quantities for each County in Columns F, G, H, and I. Respondents can find the Estimated Annual Quantity of Jobs for each County in Column E. The Total Estimated Cost by County for each County (Column K) will automatically calculate based on the Response prices entered into the applicable Purple Cells.
Purple Cells are fields where Respondents should enter bid information. If a Respondent is not bidding a County or Region, you can leave it blank or respond N/A.
| Electrical Maintenance & Repair | |||||||
| Region/County | Estimated Annual Quantity of Jobs | Estimated Annual Labor Hours* | Estimated Annual Spend | Hourly Labor Rates | |||
| Technician - Regular Time | Technician - Premium Time | Helper - Regular Time | Helper - Premium Time | ||||
| Region 1 | 65 | 1,340 | $ 269,986.44 | ||||
| Region 2 | 65 | 932 | $ 557,705.97 | ||||
| Region 3 | 56 | 1,167 | $ 259,706.26 | ||||
| Region 4 | 42 | 967 | $ 323,021.42 | ||||
| Davidson | 80 | 1,826 | $ 179,944.46 | ||||
| Hamilton | 22 | 394 | $ 139,272.47 | ||||
| Knox | 26 | 707 | $ 97,064.00 | ||||
| Shelby | 30 | 1,057 | $ 82,724.67 | ||||
| *Regional Labor Hours do not include Labor Hours for the Counties of Davidson, Hamilton, Knox, and Shelby. The Labor Rates for these Counties are broken out separately. |
| County | Select "Yes" if Responding to County in Column B | Region | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Trip Charge BY COUNTY | Total Estimated Cost by County | ||||
| Anderson | 1 | 7 | 97 | 1 | 38 | 1 | ERROR:#VALUE! | Reg 1 | $ - 0 | Region 1 | |||
| Blount | 1 | 1 | 5 | 1 | 4 | 1 | ERROR:#VALUE! | Knox | $ - 0 | ||||
| Campbell | 1 | 7 | 73 | 2 | 34 | 1 | ERROR:#VALUE! | ||||||
| Carter | 1 | 1 | 5 | 1 | 2 | 1 | ERROR:#VALUE! | ||||||
| Claiborne | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Cocke | 1 | 6 | 65 | 1 | 40 | 2 | ERROR:#VALUE! | ||||||
| Grainger | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Greene | 1 | 1 | 22 | 11 | 21 | 1 | ERROR:#VALUE! | ||||||
| Hamblen | 1 | 9 | 121 | 2 | 61 | 4 | ERROR:#VALUE! | ||||||
| Hancock | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hawkins | 1 | 1 | 12 | 1 | 12 | 1 | ERROR:#VALUE! | ||||||
| Jefferson | 1 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Johnson | 1 | 1 | 9 | 8 | 4 | 1 | ERROR:#VALUE! | ||||||
| Knox | 1 | 26 | 420 | 6 | 277 | 4 | ERROR:#VALUE! | ||||||
| Loudon | 1 | 1 | 4 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Monroe | 1 | 1 | 22 | 1 | 17 | 1 | ERROR:#VALUE! | ||||||
| Morgan | 1 | 5 | 44 | 3 | 34 | 2 | ERROR:#VALUE! | ||||||
| Roane | 1 | 4 | 51 | 1 | 42 | 1 | ERROR:#VALUE! | ||||||
| Scott | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sevier | 1 | 1 | 45 | 1 | 39 | 1 | ERROR:#VALUE! | ||||||
| Sullivan | 1 | 1 | 10 | 1 | 9 | 1 | ERROR:#VALUE! | ||||||
| Unicoi | 1 | 1 | 11 | 1 | 11 | 1 | ERROR:#VALUE! | ||||||
| Union | 1 | 4 | 43 | 1 | 29 | 1 | ERROR:#VALUE! | ||||||
| Washington | 1 | 9 | 133 | 7 | 82 | 1 | ERROR:#VALUE! | ||||||
| Bledsoe | 2 | 1 | 9 | 1 | 3 | 1 | ERROR:#VALUE! | Reg 2 | $ - 0 | Region 2 | |||
| Bradley | 2 | 3 | 28 | 2 | 23 | 2 | ERROR:#VALUE! | Hamilton | $ - 0 | ||||
| Cannon | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Catoosa County, GA | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Clay | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Coffee | 2 | 11 | 121 | 3 | 98 | 1 | ERROR:#VALUE! | ||||||
| Cumberland | 2 | 5 | 60 | 1 | 31 | 1 | ERROR:#VALUE! | ||||||
| DeKalb | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Fentress | 2 | 1 | 4 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Franklin | 2 | 2 | 18 | 3 | 20 | 1 | ERROR:#VALUE! | ||||||
| Grundy | 2 | 1 | 6 | 1 | 6 | 1 | ERROR:#VALUE! | ||||||
| Hamilton | 2 | 22 | 233 | 13 | 140 | 9 | ERROR:#VALUE! | ||||||
| Jackson | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Marion | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| McMinn | 2 | 1 | 9 | 1 | 9 | 1 | ERROR:#VALUE! | ||||||
| Meigs | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Overton | 2 | 1 | 7 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Pickett | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Polk | 2 | 1 | 7 | 1 | 3 | 1 | ERROR:#VALUE! | ||||||
| Putnam | 2 | 9 | 110 | 1 | 5 | 1 | ERROR:#VALUE! | ||||||
| Rhea | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sequatchie | 2 | 17 | 155 | 4 | 67 | 3 | ERROR:#VALUE! | ||||||
| Van Buren | 2 | 2 | 30 | 1 | 21 | 1 | ERROR:#VALUE! | ||||||
| Warren | 2 | 1 | 2 | 1 | 2 | 1 | ERROR:#VALUE! | ||||||
| White | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Bedford | 3 | 1 | 8 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 3 | $ - 0 | Region 3 | |||
| Cheatham | 3 | 1 | 46 | 1 | 44 | 1 | ERROR:#VALUE! | ||||||
| Christian County, KY | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Davidson | 3 | 80 | 985 | 48 | 763 | 30 | ERROR:#VALUE! | ||||||
| Dickson | 3 | 3 | 38 | 1 | 16 | 1 | ERROR:#VALUE! | ||||||
| Giles | 3 | 4 | 41 | 1 | 9 | 1 | ERROR:#VALUE! | ||||||
| Hickman | 3 | 3 | 28 | 1 | 15 | 1 | ERROR:#VALUE! | ||||||
| Houston | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Humphreys | 3 | 6 | 80 | 1 | 57 | 1 | ERROR:#VALUE! | ||||||
| Lawrence | 3 | 2 | 40 | 1 | 2 | 1 | ERROR:#VALUE! | ||||||
| Lewis | 3 | 1 | 11 | 1 | 11 | 1 | ERROR:#VALUE! | ||||||
| Lincoln | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Macon | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Marshall | 3 | 4 | 60 | 1 | 25 | 1 | ERROR:#VALUE! | ||||||
| Maury | 3 | 2 | 34 | 1 | 40 | 1 | ERROR:#VALUE! | ||||||
| Montgomery | 3 | 4 | 54 | 1 | 40 | 1 | ERROR:#VALUE! | ||||||
| Moore | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Perry | 3 | 1 | 12 | 1 | 11 | 1 | ERROR:#VALUE! | ||||||
| Robertson | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Rutherford | 3 | 1 | 26 | 1 | 31 | 1 | ERROR:#VALUE! | ||||||
| Smith | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Stewart | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sumner | 3 | 8 | 119 | 2 | 104 | 1 | ERROR:#VALUE! | ||||||
| Trousdale | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Wayne | 3 | 1 | 36 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Williamson | 3 | 1 | 8 | 1 | 8 | 1 | ERROR:#VALUE! | ||||||
| Wilson | 3 | 3 | 21 | 3 | 15 | 2 | ERROR:#VALUE! | ||||||
| Benton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 4 | $ - 0 | Region 4 | |||
| Carroll | 4 | 2 | 19 | 1 | 1 | 1 | ERROR:#VALUE! | Shelby | $ - 0 | ||||
| Chester | 4 | 1 | 3 | 1 | 3 | 1 | ERROR:#VALUE! | ||||||
| Crockett | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Decatur | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Dyer | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Fayette | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Gibson | 4 | 1 | 9 | 1 | 9 | 1 | ERROR:#VALUE! | ||||||
| Hardeman | 4 | 5 | 116 | 16 | 77 | 7 | ERROR:#VALUE! | ||||||
| Hardin | 4 | 1 | 12 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Haywood | 4 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Henderson | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Henry | 4 | 1 | 9 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Lake | 4 | 1 | 33 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Lauderdale | 4 | 13 | 317 | 2 | 69 | 1 | ERROR:#VALUE! | ||||||
| Madison | 4 | 7 | 108 | 17 | 76 | 1 | ERROR:#VALUE! | ||||||
| McNairy | 4 | 1 | 2 | 1 | 2 | 1 | ERROR:#VALUE! | ||||||
| Obion | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Shelby | 4 | 30 | 870 | 34 | 137 | 16 | ERROR:#VALUE! | ||||||
| Tipton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Weakley | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Yes | |||||
| No |
HVAC LOOKUP
Below Respondents will find the cells to enter pricing for Job Group 1: Electrical Maintenance and Repair. Respondents should refer back to the Instructions Tab for higher level instructions for this event. Respondents must enter a Trip Charge and Hourly Labor Rates pricing for all the County(ies) and Region(s) they wish to cover in this Job Group. Respondents are not required to bid on every County within the Region or all Regions to be considered for award.
In Rows 18-114, as soon as you select "Yes" in Column C for a County, you will be prompted by "InputNeeded" in the corresponding cell in Column J to enter the rate for Trip Charge by County. As soon as you input the Trip Charge, you will be prompted by "InputNeeded" in the Hourly Labor Rates section to provide your labor rates in Columns F, G, H, and I in Rows 7-14, based on the Region(s)/County(ies) in which you will respond. Respondents should reference Tab 7 Region List or the Attachment B Region and County Map document attached to this event to see the counties contained in each Region. Respondents can find the State's Estimated Annual Labor Hour Quantities for each County in Columns F, G, H, and I. Respondents can find the Estimated Annual Quantity of Jobs for each County in Column E. The Total Estimated Cost by County for each County (Column K) will automatically calculate based on the Response prices entered into the applicable Purple Cells.
Purple Cells are fields where Respondents should enter bid information. If a Respondent is not bidding a County or Region, you can leave it blank or respond N/A.
| Electrical Maintenance & Repair | |||||||
| Region/County | Estimated Annual Quantity of Jobs | Estimated Annual Labor Hours* | Estimated Annual Spend | Hourly Labor Rates | |||
| Technician - Regular Time | Technician - Premium Time | Helper - Regular Time | Helper - Premium Time | ||||
| Region 1 | 122 | 1,339 | $ 269,986.44 | ||||
| Region 2 | 221 | 1,540 | $ 557,705.97 | ||||
| Region 3 | 66 | 750 | $ 259,706.26 | ||||
| Region 4 | 130 | 1,848 | $ 323,021.42 | ||||
| Davidson | 125 | 1,576 | $ 179,944.46 | ||||
| Hamilton | 59 | 565 | $ 139,272.47 | ||||
| Knox | 48 | 618 | $ 97,064.00 | ||||
| Shelby | 50 | 739 | $ 82,724.67 | ||||
| *Regional Labor Hours do not include Labor Hours for the Counties of Davidson, Hamilton, Knox, and Shelby. The Labor Rates for these Counties are broken out separately. |
| County | Select "Yes" if Responding to County in Column B | Region | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Trip Charge BY COUNTY | Total Estimated Cost by County | ||||
| Anderson | 1 | 7 | 59 | 1 | 46 | 1 | ERROR:#VALUE! | Reg 1 | $ - 0 | Region 1 | |||
| Blount | 1 | 4 | 49 | 1 | 43 | 1 | ERROR:#VALUE! | Knox | $ - 0 | ||||
| Campbell | 1 | 8 | 69 | 2 | 47 | 1 | ERROR:#VALUE! | ||||||
| Carter | 1 | 10 | 53 | 1 | 28 | 10 | ERROR:#VALUE! | ||||||
| Claiborne | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Cocke | 1 | 4 | 32 | 1 | 25 | 1 | ERROR:#VALUE! | ||||||
| Grainger | 1 | 1 | 6 | 1 | 3 | 1 | ERROR:#VALUE! | ||||||
| Greene | 1 | 32 | 141 | 3 | 25 | 1 | ERROR:#VALUE! | ||||||
| Hamblen | 1 | 14 | 91 | 4 | 51 | 2 | ERROR:#VALUE! | ||||||
| Hancock | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hawkins | 1 | 1 | 16 | 1 | 7 | 1 | ERROR:#VALUE! | ||||||
| Jefferson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Johnson | 1 | 2 | 20 | 1 | 13 | 1 | ERROR:#VALUE! | ||||||
| Knox | 1 | 48 | 382 | 7 | 229 | 1 | ERROR:#VALUE! | ||||||
| Loudon | 1 | 1 | 8 | 1 | 6 | 1 | ERROR:#VALUE! | ||||||
| Monroe | 1 | 1 | 3 | 1 | 6 | 1 | ERROR:#VALUE! | ||||||
| Morgan | 1 | 3 | 37 | 1 | 23 | 1 | ERROR:#VALUE! | ||||||
| Roane | 1 | 3 | 35 | 1 | 18 | 1 | ERROR:#VALUE! | ||||||
| Scott | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sevier | 1 | 0 | 7 | 1 | 7 | 1 | ERROR:#VALUE! | ||||||
| Sullivan | 1 | 13 | 80 | 3 | 31 | 1 | ERROR:#VALUE! | ||||||
| Unicoi | 1 | 1 | 8 | 1 | 7 | 1 | ERROR:#VALUE! | ||||||
| Union | 1 | 4 | 23 | 1 | 12 | 1 | ERROR:#VALUE! | ||||||
| Washington | 1 | 10 | 85 | 1 | 47 | 1 | ERROR:#VALUE! | ||||||
| Bledsoe | 2 | 7 | 51 | 5 | 31 | 1 | ERROR:#VALUE! | Reg 2 | $ - 0 | Region 2 | |||
| Bradley | 2 | 5 | 28 | 1 | 1 | 1 | ERROR:#VALUE! | Hamilton | $ - 0 | ||||
| Cannon | 2 | 1 | 1 | 2 | 1 | 1 | ERROR:#VALUE! | ||||||
| Catoosa County, GA | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Clay | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Coffee | 2 | 46 | 345 | 13 | 11 | 1 | ERROR:#VALUE! | ||||||
| Cumberland | 2 | 33 | 112 | 4 | 59 | 1 | ERROR:#VALUE! | ||||||
| DeKalb | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Fentress | 2 | 8 | 36 | 1 | 23 | 1 | ERROR:#VALUE! | ||||||
| Franklin | 2 | 11 | 72 | 9 | 1 | 1 | ERROR:#VALUE! | ||||||
| Grundy | 2 | 6 | 20 | 5 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hamilton | 2 | 59 | 551 | 10 | 4 | 1 | ERROR:#VALUE! | ||||||
| Jackson | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Marion | 2 | 1 | 5 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| McMinn | 2 | 5 | 26 | 2 | 6 | 1 | ERROR:#VALUE! | ||||||
| Meigs | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Overton | 2 | 6 | 27 | 1 | 15 | 1 | ERROR:#VALUE! | ||||||
| Pickett | 2 | 2 | 10 | 1 | 9 | 1 | ERROR:#VALUE! | ||||||
| Polk | 2 | 5 | 27 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Putnam | 2 | 20 | 67 | 3 | 20 | 1 | ERROR:#VALUE! | ||||||
| Rhea | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sequatchie | 2 | 25 | 178 | 1 | 4 | 1 | ERROR:#VALUE! | ||||||
| Van Buren | 2 | 32 | 200 | 38 | 7 | 1 | ERROR:#VALUE! | ||||||
| Warren | 2 | 2 | 4 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| White | 2 | 2 | 7 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Bedford | 3 | 1 | 28 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 3 | $ - 0 | Region 3 | |||
| Cheatham | 3 | 1 | 13 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Christian County, KY | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Davidson | 3 | 125 | 1,318 | 193 | 64 | 1 | ERROR:#VALUE! | ||||||
| Dickson | 3 | 20 | 79 | 43 | 14 | 8 | ERROR:#VALUE! | ||||||
| Giles | 3 | 1 | 16 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hickman | 3 | 5 | 47 | 4 | 1 | 1 | ERROR:#VALUE! | ||||||
| Houston | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Humphreys | 3 | 4 | 79 | 1 | 4 | 4 | ERROR:#VALUE! | ||||||
| Lawrence | 3 | 6 | 69 | 2 | 1 | 1 | ERROR:#VALUE! | ||||||
| Lewis | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Lincoln | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Macon | 3 | 1 | 11 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Marshall | 3 | 1 | 20 | 1 | 14 | 1 | ERROR:#VALUE! | ||||||
| Maury | 3 | 1 | 8 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Montgomery | 3 | 2 | 36 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Moore | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Perry | 3 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Robertson | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Rutherford | 3 | 3 | 42 | 1 | 3 | 1 | ERROR:#VALUE! | ||||||
| Smith | 3 | 1 | 19 | 1 | 1 | 10 | ERROR:#VALUE! | ||||||
| Stewart | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Sumner | 3 | 2 | 21 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Trousdale | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Wayne | 3 | 3 | 35 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Williamson | 3 | 1 | 3 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Wilson | 3 | 3 | 36 | 2 | 1 | 1 | ERROR:#VALUE! | ||||||
| Benton | 4 | 1 | 7 | 1 | 2 | 1 | ERROR:#VALUE! | Reg 4 | $ - 0 | Region 4 | |||
| Carroll | 4 | 4 | 99 | 1 | 62 | 1 | ERROR:#VALUE! | Shelby | $ - 0 | ||||
| Chester | 4 | 12 | 71 | 4 | 1 | 1 | ERROR:#VALUE! | ||||||
| Crockett | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Decatur | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Dyer | 4 | 1 | 9 | 1 | 12 | 1 | ERROR:#VALUE! | ||||||
| Fayette | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Gibson | 4 | 1 | 12 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hardeman | 4 | 4 | 64 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Hardin | 4 | 22 | 223 | 7 | 32 | 1 | ERROR:#VALUE! | ||||||
| Haywood | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Henderson | 4 | 3 | 34 | 3 | 1 | 1 | ERROR:#VALUE! | ||||||
| Henry | 4 | 7 | 67 | 1 | 10 | 3 | ERROR:#VALUE! | ||||||
| Lake | 4 | 10 | 78 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Lauderdale | 4 | 24 | 361 | 1 | 2 | 1 | ERROR:#VALUE! | ||||||
| Madison | 4 | 31 | 353 | 6 | 61 | 3 | ERROR:#VALUE! | ||||||
| McNairy | 4 | 3 | 90 | 1 | 77 | 1 | ERROR:#VALUE! | ||||||
| Obion | 4 | 1 | 33 | 1 | 10 | 1 | ERROR:#VALUE! | ||||||
| Shelby | 4 | 50 | 667 | 30 | 42 | 1 | ERROR:#VALUE! | ||||||
| Tipton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | ||||||
| Weakley | 4 | 1 | 5 | 1 | 1 | 1 | ERROR:#VALUE! | Yes | |||||
| No |
Plumbing LOOKUP
Below Respondents will find the cells to enter pricing for Job Group 3: Plumbing Maintenance and Repair. Respondents should refer back to the Instructions Tab for higher level instructions for this event. Respondents must enter a Trip Charge and Hourly Labor Rates pricing for all the County(ies) and Region(s) they wish to cover in this Job Group. Respondents are not required to bid on every County within the Region or all Regions to be considered for award.
In Rows 18-114, as soon as you select "Yes" in Column C for a County, you will be prompted by "InputNeeded" in the corresponding cell in Column J to enter the rate for Trip Charge by County. As soon as you input the Trip Charge, you will be prompted by "InputNeeded" in the Hourly Labor Rates section to provide your labor rates in Columns F, G, H, and I in Rows 7-14, based on the Region(s)/County(ies) in which you will respond. Respondents should reference Tab 7 Region List or the Attachment B Region and County Map document attached to this event to see the counties contained in each Region. Respondents can find the State's Estimated Annual Labor Hour Quantities for each County in Columns F, G, H, and I. Respondents can find the Estimated Annual Quantity of Jobs for each County in Column E. The Total Estimated Cost by County for each County (Column K) will automatically calculate based on the Response prices entered into the applicable Purple Cells.
Purple Cells are fields where Respondents should enter bid information. If a Respondent is not bidding a County or Region, you can leave it blank or respond N/A.
| Plumbing Maintenance & Repair | |||||||
| Region/County | Estimated Annual Quantity of Jobs | Estimated Annual Labor Hours* | Estimated Annual Spend | Hourly Rates | |||
| Technician - Regular Time | Technician - Premium Time | Helper - Regular Time | Helper - Premium Time | ||||
| Region 1 | 115 | 1,283 | $ 347,127.83 | ||||
| Region 2 | 143 | 1,526 | $ 464,621.90 | ||||
| Region 3 | 71 | 1,030 | $ 665,611.06 | ||||
| Region 4 | 113 | 2,054 | $ 377,322.69 | ||||
| Davidson | 47 | 605 | $ 467,948.97 | ||||
| Hamilton | 65 | 458 | $ 78,179.95 | ||||
| Knox | 27 | 284 | $ 83,378.93 | ||||
| Shelby | 53 | 679 | $ 147,311.33 | ||||
| *Regional Labor Hours do not include Labor Hours for the Counties of Davidson, Hamilton, Knox, and Shelby. The Labor Rates for these Counties are broken out separately. |
| County | Select "Yes" if Responding to County in Column B | Region | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Trip Charge BY COUNTY | Total Estimated Cost by County | |||
| Anderson | 1 | 2 | 18 | 1 | 9 | 1 | ERROR:#VALUE! | Reg 1 | $ - 0 | Region 1 | ||
| Blount | 1 | 3 | 17 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Campbell | 1 | 8 | 43 | 1 | 22 | 3 | ERROR:#VALUE! | |||||
| Carter | 1 | 2 | 23 | 1 | 9 | 2 | ERROR:#VALUE! | |||||
| Claiborne | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cocke | 1 | 8 | 53 | 2 | 21 | 1 | ERROR:#VALUE! | |||||
| Grainger | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Greene | 1 | 7 | 96 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamblen | 1 | 17 | 214 | 2 | 25 | 7 | ERROR:#VALUE! | |||||
| Hancock | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hawkins | 1 | 1 | 4 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Jefferson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Johnson | 1 | 3 | 45 | 4 | 1 | 1 | ERROR:#VALUE! | |||||
| Knox | 1 | 27 | 168 | 1 | 114 | 1 | ERROR:#VALUE! | |||||
| Loudon | 1 | 1 | 11 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Monroe | 1 | 2 | 13 | 3 | 1 | 1 | ERROR:#VALUE! | |||||
| Morgan | 1 | 8 | 48 | 7 | 45 | 2 | ERROR:#VALUE! | |||||
| Roane | 1 | 4 | 38 | 1 | 4 | 1 | ERROR:#VALUE! | |||||
| Scott | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sevier | 1 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sullivan | 1 | 20 | 143 | 8 | 1 | 1 | ERROR:#VALUE! | |||||
| Unicoi | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Union | 1 | 10 | 100 | 3 | 81 | 1 | ERROR:#VALUE! | |||||
| Washington | 1 | 14 | 100 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Bledsoe | 2 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 2 | $ - 0 | Region 2 | ||
| Bradley | 2 | 1 | 9 | 1 | 2 | 1 | ERROR:#VALUE! | |||||
| Cannon | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Catoosa County, GA | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Clay | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Coffee | 2 | 19 | 239 | 36 | 4 | 1 | ERROR:#VALUE! | |||||
| Cumberland | 2 | 13 | 83 | 1 | 62 | 3 | ERROR:#VALUE! | |||||
| DeKalb | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Fentress | 2 | 3 | 15 | 1 | 10 | 1 | ERROR:#VALUE! | |||||
| Franklin | 2 | 3 | 33 | 4 | 1 | 1 | ERROR:#VALUE! | |||||
| Grundy | 2 | 2 | 15 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamilton | 2 | 65 | 443 | 13 | 1 | 1 | ERROR:#VALUE! | |||||
| Jackson | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Marion | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| McMinn | 2 | 4 | 22 | 9 | 1 | 1 | ERROR:#VALUE! | |||||
| Meigs | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Overton | 2 | 1 | 4 | 1 | 4 | 1 | ERROR:#VALUE! | |||||
| Pickett | 2 | 1 | 9 | 1 | 12 | 1 | ERROR:#VALUE! | |||||
| Polk | 2 | 3 | 20 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Putnam | 2 | 15 | 66 | 34 | 32 | 4 | ERROR:#VALUE! | |||||
| Rhea | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sequatchie | 2 | 58 | 586 | 29 | 1 | 1 | ERROR:#VALUE! | |||||
| Van Buren | 2 | 6 | 64 | 1 | 5 | 1 | ERROR:#VALUE! | |||||
| Warren | 2 | 1 | 6 | 2 | 4 | 1 | ERROR:#VALUE! | |||||
| White | 2 | 3 | 20 | 1 | 12 | 1 | ERROR:#VALUE! | |||||
| Bedford | 3 | 2 | 41 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 3 | $ - 0 | Region 3 | ||
| Cheatham | 3 | 2 | 11 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Christian County, KY | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Davidson | 3 | 47 | 543 | 45 | 13 | 4 | ERROR:#VALUE! | |||||
| Dickson | 3 | 2 | 12 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Giles | 3 | 6 | 291 | 2 | 1 | 1 | ERROR:#VALUE! | |||||
| Hickman | 3 | 1 | 21 | 2 | 1 | 2 | ERROR:#VALUE! | |||||
| Houston | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Humphreys | 3 | 8 | 87 | 4 | 11 | 1 | ERROR:#VALUE! | |||||
| Lawrence | 3 | 4 | 142 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lewis | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lincoln | 3 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Macon | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Marshall | 3 | 4 | 24 | 5 | 3 | 15 | ERROR:#VALUE! | |||||
| Maury | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Montgomery | 3 | 9 | 104 | 4 | 1 | 1 | ERROR:#VALUE! | |||||
| Moore | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Perry | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Robertson | 3 | 1 | 5 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Rutherford | 3 | 3 | 30 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Smith | 3 | 1 | 3 | 1 | 4 | 1 | ERROR:#VALUE! | |||||
| Stewart | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sumner | 3 | 11 | 47 | 7 | 18 | 4 | ERROR:#VALUE! | |||||
| Trousdale | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Wayne | 3 | 1 | 9 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Williamson | 3 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Wilson | 3 | 4 | 38 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Benton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 4 | $ - 0 | Region 4 | ||
| Carroll | 4 | 8 | 140 | 6 | 66 | 3 | ERROR:#VALUE! | |||||
| Chester | 4 | 5 | 45 | 1 | 2 | 1 | ERROR:#VALUE! | |||||
| Crockett | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Decatur | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Dyer | 4 | 1 | 5 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Fayette | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Gibson | 4 | 1 | 17 | 1 | 9 | 3 | ERROR:#VALUE! | |||||
| Hardeman | 4 | 5 | 50 | 7 | 8 | 4 | ERROR:#VALUE! | |||||
| Hardin | 4 | 15 | 164 | 8 | 135 | 4 | ERROR:#VALUE! | |||||
| Haywood | 4 | 1 | 10 | 1 | 8 | 1 | ERROR:#VALUE! | |||||
| Henderson | 4 | 1 | 3 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Henry | 4 | 4 | 41 | 4 | 23 | 4 | ERROR:#VALUE! | |||||
| Lake | 4 | 4 | 47 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lauderdale | 4 | 14 | 229 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Madison | 4 | 46 | 525 | 13 | 286 | 9 | ERROR:#VALUE! | |||||
| McNairy | 4 | 2 | 58 | 1 | 46 | 1 | ERROR:#VALUE! | |||||
| Obion | 4 | 1 | 13 | 1 | 9 | 1 | ERROR:#VALUE! | |||||
| Shelby | 4 | 53 | 576 | 19 | 53 | 31 | ERROR:#VALUE! | |||||
| Tipton | 4 | 1 | 2 | 2 | 1 | 1 | ERROR:#VALUE! | |||||
| Weakley | 4 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! |
Boiler LOOKUP
Below Respondents will find the cells to enter pricing for Job Group 4: Boiler Maintenance and Repair. Respondents should refer back to the Instructions Tab for higher level instructions for this event. Respondents must enter a Trip Charge and Hourly Labor Rates pricing for all the County(ies) and Region(s) they wish to cover in this Job Group. Respondents are not required to bid on every County within the Region or all Regions to be considered for award.
In Rows 18-114, as soon as you select "Yes" in Column C for a County, you will be prompted by "InputNeeded" in the corresponding cell in Column J to enter the rate for Trip Charge by County. As soon as you input the Trip Charge, you will be prompted by "InputNeeded" in the Hourly Labor Rates section to provide your labor rates in Columns F, G, H, and I in Rows 7-14, based on the Region(s)/County(ies) in which you will respond. Respondents should reference Tab 7 Region List or the Attachment B Region and County Map document attached to this event to see the counties contained in each Region. Respondents can find the State's Estimated Annual Labor Hour Quantities for each County in Columns F, G, H, and I. Respondents can find the Estimated Annual Quantity of Jobs for each County in Column E. The Total Estimated Cost by County for each County (Column K) will automatically calculate based on the Response prices entered into the applicable Purple Cells.
Purple Cells are fields where Respondents should enter bid information. If a Respondent is not bidding a County or Region, you can leave it blank or respond N/A.
| Boiler Maintenance & Repair | |||||||
| Region/County | Estimated Annual Quantity of Jobs | Estimated Annual Labor Hours* | Estimated Annual Spend | Hourly Rates | |||
| Technician - Regular Time | Technician - Premium Time | Helper - Regular Time | Helper - Premium Time | ||||
| Region 1 | 23 | 97 | $ 32,647.65 | ||||
| Region 2 | 24 | 151 | $ 14,807.88 | ||||
| Region 3 | 31 | 268 | $ 324,580.15 | ||||
| Region 4 | 48 | 532 | $ 10,260.03 | ||||
| Davidson | 36 | 331 | $ 294,549.93 | ||||
| Hamilton | 1 | 4 | $ 900.00 | ||||
| Knox | 1 | 4 | $ 350.00 | ||||
| Shelby | 20 | 266 | $ 3,000.00 | ||||
| *Regional Labor Hours do not include Labor Hours for the Counties of Davidson, Hamilton, Knox, and Shelby. The Labor Rates for these Counties are broken out separately. |
| County | Select "Yes" if Responding to County in Column B | Region | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Trip Charge BY COUNTY | Total Estimated Cost by County | |||
| Anderson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 1 | $ - 0 | Region 1 | ||
| Blount | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Campbell | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Carter | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Claiborne | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cocke | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Grainger | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Greene | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamblen | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hancock | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hawkins | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Jefferson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Johnson | 1 | 1 | 6 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Knox | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Loudon | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Monroe | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Morgan | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Roane | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Scott | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sevier | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sullivan | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Unicoi | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Union | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Washington | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Bledsoe | 2 | 1 | 6 | 1 | 2 | 36 | ERROR:#VALUE! | Reg 2 | $ - 0 | Region 2 | ||
| Bradley | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cannon | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Catoosa County, GA | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Clay | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Coffee | 2 | 1 | 1 | 1 | 1 | 8 | ERROR:#VALUE! | |||||
| Cumberland | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| DeKalb | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Fentress | 2 | 1 | 1 | 1 | 1 | 8 | ERROR:#VALUE! | |||||
| Franklin | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Grundy | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamilton | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Jackson | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Marion | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| McMinn | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Meigs | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Overton | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Pickett | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Polk | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Putnam | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Rhea | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sequatchie | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Van Buren | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Warren | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| White | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Bedford | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 3 | $ - 0 | Region 3 | ||
| Cheatham | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Christian County, KY | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Davidson | 3 | 36 | 302 | 25 | 3 | 1 | ERROR:#VALUE! | |||||
| Dickson | 3 | 1 | 20 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Giles | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hickman | 3 | 3 | 36 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Houston | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Humphreys | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lawrence | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lewis | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lincoln | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Macon | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Marshall | 3 | 1 | 5 | 1 | 2 | 1 | ERROR:#VALUE! | |||||
| Maury | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Montgomery | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Moore | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Perry | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Robertson | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Rutherford | 3 | 5 | 92 | 5 | 1 | 1 | ERROR:#VALUE! | |||||
| Smith | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Stewart | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sumner | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Trousdale | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Wayne | 3 | 1 | 10 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Williamson | 3 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Wilson | 3 | 1 | 2 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Benton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 4 | $ - 0 | Region 4 | ||
| Carroll | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Chester | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Crockett | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Decatur | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Dyer | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Fayette | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Gibson | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hardeman | 4 | 8 | 119 | 2 | 1 | 1 | ERROR:#VALUE! | |||||
| Hardin | 4 | 2 | 12 | 6 | 1 | 4 | ERROR:#VALUE! | |||||
| Haywood | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Henderson | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Henry | 4 | 1 | 3 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Lake | 4 | 11 | 57 | 2 | 1 | 1 | ERROR:#VALUE! | |||||
| Lauderdale | 4 | 12 | 235 | 4 | 1 | 1 | ERROR:#VALUE! | |||||
| Madison | 4 | 1 | 18 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| McNairy | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Obion | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Shelby | 4 | 20 | 247 | 10 | 1 | 8 | ERROR:#VALUE! | |||||
| Tipton | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Weakley | 4 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! |
Chiller LOOKUP
Below Respondents will find the cells to enter pricing for Job Group 5: Chiller Maintenance and Repair. Respondents should refer back to the Instructions Tab for higher level instructions for this event. Respondents must enter a Trip Charge and Hourly Labor Rates pricing for all the County(ies) and Region(s) they wish to cover in this Job Group. Respondents are not required to bid on every County within the Region or all Regions to be considered for award.
In Rows 18-114, as soon as you select "Yes" in Column C for a County, you will be prompted by "InputNeeded" in the corresponding cell in Column J to enter the rate for Trip Charge by County. As soon as you input the Trip Charge, you will be prompted by "InputNeeded" in the Hourly Labor Rates section to provide your labor rates in Columns F, G, H, and I in Rows 7-14, based on the Region(s)/County(ies) in which you will respond. Respondents should reference Tab 7 Region List or the Attachment B Region and County Map document attached to this event to see the counties contained in each Region. Respondents can find the State's Estimated Annual Labor Hour Quantities for each County in Columns F, G, H, and I. Respondents can find the Estimated Annual Quantity of Jobs for each County in Column E. The Total Estimated Cost by County for each County (Column K) will automatically calculate based on the Response prices entered into the applicable Purple Cells.
Purple Cells are fields where Respondents should enter bid information. If a Respondent is not bidding a County or Region, you can leave it blank or respond N/A.
| Chiller Maintenance & Repair | |||||||
| Region/County | Estimated Annual Quantity of Jobs | Estimated Annual Labor Hours* | Estimated Annual Spend | Hourly Rates | |||
| Technician - Regular Time | Technician - Premium Time | Helper - Regular Time | Helper - Premium Time | ||||
| Region 1 | 26 | 160 | $ 4,637.18 | ||||
| Region 2 | 24 | 102 | $ 9,280.00 | ||||
| Region 3 | 26 | 115 | $ 82,547.90 | ||||
| Region 4 | 29 | 236 | $ 9,759.70 | ||||
| Davidson | 9 | 160 | $ 55,332.91 | ||||
| Hamilton | 1 | 9 | $ 2,465.00 | ||||
| Knox | 2 | 25 | $ 255.23 | ||||
| Shelby | 10 | 131 | $ 4,471.22 | ||||
| *Regional Labor Hours do not include Labor Hours for the Counties of Davidson, Hamilton, Knox, and Shelby. The Labor Rates for these Counties are broken out separately. |
| County | Select "Yes" if Responding to County in Column B | Region | Estimated Annual Quantity of Jobs | Technician - Regular Time Estimated Annual Hours | Technician - Premium Time Estimated Annual Hours | Helper - Regular Time Estimated Annual Hours | Helper - Premium Time Estimated Annual Hours | Trip Charge BY COUNTY | Total Estimated Cost by County | |||
| Anderson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | Reg 1 | $ - 0 | Region 1 | ||
| Blount | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Campbell | 1 | 1 | 5 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Carter | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Claiborne | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cocke | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Grainger | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Greene | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamblen | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hancock | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hawkins | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Jefferson | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Johnson | 1 | 4 | 44 | 22 | 1 | 1 | ERROR:#VALUE! | |||||
| Knox | 1 | 2 | 20 | 3 | 1 | 1 | ERROR:#VALUE! | |||||
| Loudon | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Monroe | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Morgan | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Roane | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Scott | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sevier | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sullivan | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Unicoi | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Union | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Washington | 1 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Bledsoe | 2 | 1 | 1 | 3 | 1 | 1 | ERROR:#VALUE! | Reg 2 | $ - 0 | Region 2 | ||
| Bradley | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cannon | 2 | 1 | 1 | 2 | 1 | 1 | ERROR:#VALUE! | |||||
| Catoosa County, GA | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Clay | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Coffee | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Cumberland | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| DeKalb | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Fentress | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Franklin | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Grundy | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Hamilton | 2 | 1 | 1 | 6 | 1 | 1 | ERROR:#VALUE! | |||||
| Jackson | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Marion | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| McMinn | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Meigs | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Overton | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Pickett | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Polk | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Putnam | 2 | 1 | 1 | 3 | 1 | 1 | ERROR:#VALUE! | |||||
| Rhea | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! | |||||
| Sequatchie | 2 | 1 | 1 | 1 | 1 | 1 | ERROR:#VALUE! |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .