Bay West 2024 rate table final version.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
Haz Mat
Contract number
3950002-O20-0510292-000-01
Issued by
Wisconsin

About this file

This is a 2024 contract rate table and cost worksheet for Bay West, a consulting firm providing environmental inspection services. The document appears to be part of a state contract vehicle, likely with a Wisconsin state agency, as evidenced by references to Wisconsin-specific bridges and state reimbursement rates for expenses.

Bay West provides specialized asbestos and bat inspection services for bridge structures under a tiered pricing structure based on the number of structures inspected. Single asbestos inspections range from $1,410 for one structure down to $770 for ten or more structures, while combined bat and asbestos inspections range from $1,600 to $1,000 respectively. Confined space inspections requiring enhanced safety measures command significantly higher rates, from $4,000 down to $2,240 for asbestos and bat work. The contract also includes hourly professional services with 28 different labor classifications ranging from Field Technician I at $40.31 per hour to Contract Manager and Engineer III at $134.36 per hour. The company applies a 65% overhead rate and 6% profit margin on labor and overhead costs. Additional services include building inspections, asbestos abatement, and various technical and administrative support roles, with expenses reimbursed at current state rates including $0.51 per mile for vehicle use and lodging rates of $98-$103 per night depending on county location.

View the file

Other files

File Type Posted
2022 Renewal Cost Table_Bay West.xlsx XLSX spreadsheet
Bay West Contract.pdf PDF

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

Instructions

Contract Cost Worksheets CY 2024
INSTRUCTIONS Return as Excel Spreadsheet! Do not reformat.
Fill in only those cells highlighted in blue. Cells in green are calculated.
Tab 1 Hourly Rates and CostsCell #
1. Fill in firm nameB2
2. Fill in asbestos inspection costs per bridge structure, cellsB5, C5, D5, E5
3. Fill in combined bat and asbestos inspection cost per bridge structure, cellsB6, C6, D6, E6
4. Fill in confined space combined bat and asbestos inspection cost per bridge structure, cellsB7 C7 D7 E7
5. Fill in standalone bat inspections cost per bridge structure, cellsB8, C8, D8, E8
6. Fill in confined space standalone bat inspection cost per bridge structure, cellsB9, C9, D9, E9
7. Fill in proposed overhead rateB42
8. Fill in proposed profit percentage as a whole number, field is formatted as a percentageB45
Tab 2 Classifications in titlesCell #
1. Please fit each of your current employee classifications into one of the Twenty Eight contract Rate titlesB4 through AC13
2. Put no more than ten classifications into each rate category.
3. Leave unused cells blank
Tab 3 Average Wage Rate CalcCell #
1. Enter the direct hourly wage rate (without overhead or profit) for each classification entered in Tab 2Columns D,F,H,J,L,N,P,R,T,V, Cells 4 through 31
2. Leave unused cells blank

Tab 1 Hourly Rates and Costs

Contract Cost Package 2024Fill in only those cells highlighted in blue. Cells in green are calculated.
FIRM NAME:Bay West
Asbestos Inspections - BridgesTerms: Lump Sum
Cost per single structureTwo to four structures, cost per structureFive to nine structures, cost per structureTen or more structures, cost per structure
Asbestos inspection, per bridge structure (Terms: Lump Sum)$ 1,410.00$ 1,250.00$ 940.00$ 770.00
Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum)$ 1,600.00$ 1,500.00$ 1,200.00$ 1,000.00
Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum$ 4,000.00$ 3,500.00$ 2,660.00$ 2,240.00# The determination of need for confined space entry, or two person team for traffic control, water entry, or other safety considerations will be made by the consultant.
Bat inspection of bridges without asbestos inspection (Terms: lump sum)$ 1,300.00$ 1,150.00$ 850.00$ 700.00
Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum)$ 3,800.00$ 3,400.00$ 2,530.00$ 2,130.00
NOTE: Structures requrested at the same time in the same spreadsheet constitute a single request, number of structures for pricing is determined by number of structures in request, not number of project IDs. Prices for long, multiple-section structures such as the Hoan Bridge, Wisconsin River bridges, St Croix river bridges, and Mississippi River bridges, will be negotiated separately at the time of request.
Asbestos inspection, buildings, bridge tender houses, other structuresTerms: average direct hourly rate*
Asbestos abatementTerms: average direct hourly rate*
Project StaffTerms: average direct hourly rate**the average direct hourly rate for each classification shall be the rate charged for the contract
Contract Manager$134.36Average Hourly Rate
Project Supervisor I$98.11Average Hourly Rate
Project Supervisor II$121.90Average Hourly Rate
Engineer I$72.84Average Hourly Rate
Engineer II$79.98Average Hourly Rate
Engineer III$134.36Average Hourly Rate
Hydrogeologist I$72.84Average Hourly Rate
Hydrogeologist II$79.98Average Hourly Rate
Hydrogeologist III$134.36Average Hourly Rate
Scientist I$60.95Average Hourly Rate
Scientist II$72.84Average Hourly Rate
Scientist III$79.98Average Hourly Rate
Field Technician I$40.31Average Hourly Rate
Field Technician II$45.74Average Hourly Rate
Field Technician III$51.46Average Hourly Rate
CADD/GIS I$60.03Average Hourly Rate
CADD/GIS II$80.27Average Hourly Rate
Accounting I$48.60Average Hourly Rate
Accounting II$60.95Average Hourly Rate
Administrative Support I$48.60Average Hourly Rate
Administrative Support II$60.95Average Hourly Rate
Asbestos Inspector$43.02Average Hourly Rate
Exterior Abatement Worker$40.31Average Hourly Rate
Exterior Asbestos Supervisor$70.04Average Hourly Rate
Asbestos Worker$40.31Average Hourly Rate
Asbestos Supervisor$70.04Average Hourly Rate
Asbestos Project Designer$121.90Average Hourly Rate
Asbestos Management Planner$121.90Average Hourly Rate
Equipment and suppliesTerms: direct expense, no markup
Subcontractor CostsTerms: actual cost, no markup
MileageTerms: current state reimbursement rate
Per mile, personal vehicle rate$0.51/mile
MealsTerms: current state reimbursement rate
Breakfast$ 10.00
Lunch$ 12.00
Dinner$ 23.00
LodgingTerms: current state reimbursement rate, excluding taxes
Per night$98.00
Per night, Milwaukee, Racine and Kenosha counties$103.00
Asbestos inspection, buildings, bridge tender houses, other structuresTerms: average direct hourly rate*
Overhead
Proposed rate65%Percentage of Direct Labor
ProfitTerms: percentage of labor and overhead, no profit on subcontractors or direct expenses
Proposed Rate6%Percentage of Direct Labor + Labor Overhead, NO PROFIT ON SUBCONTRACTORS OR DIRECT EXPENSES

Tab 2 Classifications in Titles

Classifications included in average wage rate: (list each classification on a separate line, do not insert or delete rows, do not leave blank rows between classifications.)
Bay WestPlease fill in the actual titles of your staff. Limit 10 titles per classification
Rate Title:Contract ManagerProject Supervisor IProject Supervisor IIEngineer IEngineer IIEngineer IIIHydrogeologist IHydrogeologist IIHydrogeologist IIIScientist IScientist IIScientist IIIField Technician IField Technician IIField Technician IIICADD/GIS ICADD/GIS IIAccounting IAccounting IIAdministrative Support IAdministrative Support IIAsbestos InspectorExterior Abatement WorkerExterior Asbestos SupervisorAsbestos WorkerAsbestos SupervisorAsbestos Project DesignerAsbestos Management Planner
Classifications included in Rate Titles:Sr. Project Manager IIProject ManagerSr. Project Manager IStaff Professional IIStaff Professional IIISr. Project Manager IIStaff Professional IIStaff Professional IIISr. Project Manager IIStaff Professional IStaff Professional IIStaff Professional IIIField Technician IField Technician IIField Technician IIIGIS Analyst IGIS Analyst IIOffice SupportStaff Professional IOffice SupportStaff Professional IField Technician IField Technician ISite Supervisor IField Technician ISite Supervisor ISr. Project Manager ISr. Project Manager I
cm2psI2psII2eI2eII2eIII2hI2hII2hIII2sI2sII2sIII2ftI2ftII2ftIII2cadI2cadII2accI2accII2admI2admII2Field Technician IIeaw2Site Supervisor IIaw2Site Supervisor IIapd2amp2
EXAMPLE:cm3psI3psII3eI3eII3eIII3hI3hII3hIII3sI3sII3sIII3ftI3ftII3ftIII3cadI3cadII3accI3accII3admI3admII3ai3eaw3eas3aw3as3apd3amp3
Rate Title: Scientist Icm4psI4psII4eI4eII4eIII4hI4hII4hIII4sI4sII4sIII4ftI4ftII4ftIII4cadI4cadII4accI4accII4admI4admII4ai4eaw4eas4aw4as4apd4amp4
Classifications included in title: Staff scientist 1cm5psI5psII5eI5eII5eIII5hI5hII5hIII5sI5sII5sIII5ftI5ftII5ftIII5cadI5cadII5accI5accII5admI5admII5ai5eaw5eas5aw5as5apd5amp5
Arboristcm6psI6psII6eI6eII6eIII6hI6hII6hIII6sI6sII6sIII6ftI6ftII6ftIII6cadI6cadII6accI6accII6admI6admII6ai6eaw6eas6aw6as6apd6amp6
Geologist 1cm7psI7psII7eI7eII7eIII7hI7hII7hIII7sI7sII7sIII7ftI7ftII7ftIII7cadI7cadII7accI7accII7admI7admII7ai7eaw7eas7aw7as7apd7amp7
Geologist 2cm8psI8psII8eI8eII8eIII8hI8hII8hIII8sI8sII8sIII8ftI8ftII8ftIII8cadI8cadII8accI8accII8admI8admII8ai8eaw8eas8aw8as8apd8amp8
Senior Project Technical 1cm9psI9psII9eI9eII9eIII9hI9hII9hIII9sI9sII9sIII9ftI9ftII9ftIII9cadI9cadII9accI9accII9admI9admII9ai9eaw9eas9aw9as9apd9amp9
Senior Project Technical 2cm10psI10psII10eI10eII10eIII10hI10hII10hIII10sI10sII10sIII10ftI10ftII10ftIII10cadI10cadII10accI10accII10admI10admII10ai10eaw10eas10aw10as10apd10amp10
0

Tab 3 Average Wage Rate Calc

Bay WestFill in only those cells highlighted in blue. Cells in green are calculated.Do not alter or change the formulas.
Enter the hourly rate for each classification shown
TitleAverage Hourly RateClassification 1Hourly rate 1Classification 2Hourly Rate 2Classification 3Hourly Rate 3Classification 4Hourly Rate 4Classification 5Hourly Rate 5Classification 6Hourly Rate 6Classification 7Hourly Rate 7Classification 8Hourly Rate 8Classification 9Hourly Rate 9Classification 10Hourly Rate 10
Contract Manager$134.36Sr. Project Manager II$ 134.36cm2cm3cm4cm5cm6cm7cm8cm9cm10
Project Supervisor I$98.11Project Manager$ 98.11psI2psI3psI4psI5psI6psI7psI8psI9psI10
Project Supervisor II$121.90Sr. Project Manager I$ 121.90psII2psII3psII4psII5psII6psII7psII8psII9psII10
Engineer I$72.84Staff Professional II$ 72.84eI2eI3eI4eI5eI6eI7eI8eI9eI10
Engineer II$79.98Staff Professional III$ 79.98eII2eII3eII4eII5eII6eII7eII8eII9eII10
Engineer III$134.36Sr. Project Manager II$ 134.36eIII2eIII3eIII4eIII5eIII6eIII7eIII8eIII9eIII10
Hydrogeologist I$72.84Staff Professional II$ 72.84hI2hI3hI4hI5hI6hI7hI8hI9hI10
Hydrogeologist II$79.98Staff Professional III$ 79.98hII2hII3hII4hII5hII6hII7hII8hII9hII10
Hydrogeologist III$134.36Sr. Project Manager II$ 134.36hIII2hIII3hIII4hIII5hIII6hIII7hIII8hIII9hIII10
Scientist I$60.95Staff Professional I$ 60.95sI2sI3sI4sI5sI6sI7sI8sI9sI10
Scientist II$72.84Staff Professional II$ 72.84sII2sII3sII4sII5sII6sII7sII8sII9sII10
Scientist III$79.98Staff Professional III$ 79.98sIII2sIII3sIII4sIII5sIII6sIII7sIII8sIII9sIII10
Field Technician I$40.31Field Technician I$ 40.31ftI2ftI3ftI4ftI5ftI6ftI7ftI8ftI9ftI10
Field Technician II$45.74Field Technician II$ 45.74ftII2ftII3ftII4ftII5ftII6ftII7ftII8ftII9ftII10
Field Technician III$51.46Field Technician III$ 51.46ftIII2ftIII3ftIII4ftIII5ftIII6ftIII7ftIII8ftIII9ftIII10
CADD/GIS I$60.03GIS Analyst I$ 60.03cadI2cadI3cadI4cadI5cadI6cadI7cadI8cadI9cadI10
CADD/GIS II$80.27GIS Analyst II$ 80.27cadII2cadII3cadII4cadII5cadII6cadII7cadII8cadII9cadII10
Accounting I$48.60Office Support$ 48.60accI2accI3accI4accI5accI6accI7accI8accI9accI10
Accounting II$60.95Staff Professional I$ 60.95accII2accII3accII4accII5accII6accII7accII8accII9accII10
Administrative Support I$48.60Office Support$ 48.60admI2admI3admI4admI5admI6admI7admI8admI9admI10
Administrative Support II$60.95Staff Professional I$ 60.95admII2admII3admII4admII5admII6admII7admII8admII9admII10
Asbestos Inspector$43.02Field Technician I$ 40.31Field Technician II$ 45.74ai3ai4ai5ai6ai7ai8ai9ai10
Exterior Abatement Worker$40.31Field Technician I$ 40.31eaw2eaw3eaw4eaw5eaw6eaw7eaw8eaw9eaw10
Exterior Asbestos Supervisor$70.04Site Supervisor I$ 62.89Site Supervisor II$ 77.19eas3eas4eas5eas6eas7eas8eas9eas10
Asbestos Worker$40.31Field Technician I$ 40.31aw2aw3aw4aw5aw6aw7aw8aw9aw10
Asbestos Supervisor$70.04Site Supervisor I$ 62.89Site Supervisor II$ 77.19as3as4as5as6as7as8as9as10
Asbestos Project Designer$121.90Sr. Project Manager I$ 121.90apd2apd3apd4apd5apd6apd7apd8apd9apd10
Asbestos Management Planner$121.90Sr. Project Manager I$ 121.90amp2amp3amp4amp5amp6amp7amp8amp9amp10
Example:Average Hourly RateClassification 1Hourly rate 1Classification 2Hourly Rate 2Classification 3Hourly Rate 3Classification 4Hourly Rate 4Classification 5Hourly Rate 5Classification 6Hourly Rate 6
Scientist$17.52Staff Scientist 1$ 12.35Staff Scientist 2$ 13.50Staff Scientist 3$ 14.75Geologist 1$ 17.50Geologist 2$ 23.50Senior Project Technical$ 23.50

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