2022 Renewal Cost Table_Bay West.xlsx

XLSX spreadsheet 38 KB Posted

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

About this file

This document is a 2022 renewal cost table spreadsheet for Bay West, serving as a contract cost worksheet for state and local government contracting. The document appears to be part of a Wisconsin state contract vehicle, as evidenced by references to Wisconsin-specific bridges like the Hoan Bridge and Wisconsin River bridges, along with standard state reimbursement rates for mileage, meals, and lodging.

Bay West provides specialized services including asbestos inspection and abatement, ecological services, and hazardous materials management. Asbestos inspection pricing for bridge structures follows a tiered structure: $900 for single structures, $800 per structure for 2-4 structures, $600 per structure for 5-9 structures, and $500 per structure for 10 or more structures requested simultaneously. The company maintains 16 different hourly rate classifications ranging from Administrative Support at $36.03 per hour to Contract Manager at $114.07 per hour. Key technical positions include Asbestos Project Designer and Management Planner at $94.22 per hour, Project Supervisor at $87.05 per hour, and various field technicians and specialists. The contract structure includes a 65% overhead rate on direct labor and 6% profit on labor and overhead costs, with no markup on subcontractor costs or direct expenses. Equipment, supplies, and subcontractor costs are billed at actual cost with no markup.

View the file

Other files

File Type Posted
Bay West 2024 rate table final version.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

ATTACHMENT ----- Contract Cost Worksheets
INSTRUCTIONS
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 structure, cellsB5, C5, D5, E5
3. Fill in proposed overhead rateB41
4. Fill in proposed profit percentage as a whole number, field is formatted as a percentageB44
Tab 2 Classifications in titlesCell #
1. Please fit each of your current employee classifications into one of the sixteen contract Rate titlesB4 through Q13
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 2D4-19, F4-19, H 14-19, J 14-19, l 14-19, N 14-19, P 14-19, R14-19, T 14-19, V 14-19
2. Leave unused cells blank
Tab 4 Ecological Services CostCell #
1. For each scenario in Section 6.1 provide a cost estimate.B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19, AK4-19, AU4-19, AZ4-19
2. Enter the total number of hours for each rate title used for each scenario
3. Leave unused cells blank
Tab 5 Hazmat CostCell #
1. For each scenario in Section 6.2 provide a cost estmiate.B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19
2. Enter the total number of hours for each rate title used for each scenario
3. Leave unused cells blank
Tab 6 Direct Expense CalcCell #
1. Enter the direct expenses for each scenario in Tab 4 and Tab 5Tab 4 G6 through BR 27 and Tab 5 G35 through AT56
2. Do not include mileage, meals or lodging in your expenses
3. Leave unused cells blank
Tab 7 Subcontract CalculationsCell #
1. Enter the subcontract expenses for each scenario in Tab 4 and Tab 5Tab 4 E6 through AU 24 and Tab 5 E33 through AE 51
2. Leave unused cells blank
Tab 8 Cost TotalCell #
There is nothing to enter under this tab. This is the calculation of the proposal cost total.NONE

Tab 1 Hourly Rates and Costs

ATTACHMENT ____ Contract Cost PackageFill 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$ 900.00$ 800.00$ 600.00$ 500.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$ 114.07Average Hourly Rate
Project Supervisor$ 87.05Average Hourly Rate
Engineer$ 70.67Average Hourly Rate*
Hydrogeologist$ 60.04Average Hourly Rate
Scientist$ 48.03Average Hourly Rate
Field Technician$ 42.02Average Hourly Rate
CADD, GIS$ 51.03Average Hourly Rate
Accounting$ 42.03Average Hourly Rate
Administrative Support$ 36.03Average Hourly Rate
Asbestos Inspector$ 35.33Average Hourly Rate
Exterior Abatement Worker32.39Average Hourly Rate
Exterior Asbestos Supervisor61.835Average Hourly Rate
Asbestos Worker32.39Average Hourly Rate
Asbestos Supervisor61.835Average Hourly Rate
Asbestos Project Designer94.22Average Hourly Rate
Asbestos Management Planner94.22Average 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$ 8.00
Lunch$ 10.00
Dinner$ 20.00
LodgingTerms: current state reimbursement rate, excluding taxes
Per night$70.00
Per night, Milwaukee, Racine and Kenosha counties$80.00
Overhead rateTerms: Percentage of Direct Labor
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 SupervisorEngineerHydrogeologistScientistField TechnicianCADD/GISAccountingAdministrative SupportAsbestos InspectorExterior Abatement WorkerExterior Asbestos SupervisorAsbestos WorkerAsbestos SupervisorAsbestos Project DesignerAsbestos Management Planner
Classifications included in Rate Titles:Sr. Project Manager IIProject ManagerStaff Professional IVStaff Professional IIStaff Professional IField Technician IGIS TechOffice SupportOffice SupportField Technician IField Technician ISite Supervisor IField Technician ISite Supervisor ISr. Project Manager ISr. Project Manager I
Sr. Project Manager IIISr. Project Manager Ie2Staff Professional IIIs2Field Technician IIGIS Analyst IStaff Professional Iadm2Field Technician IISite Supervisor IISite Supervisor II
EXAMPLE:cm3PS3e3h3s3Field Technician IIIGIS Analyst IIacc3adm3ai3eas3as3
Rate Title: Scientistcm4PS4e4h4S4Field Technician IVcad4acc4adm4ai4eas4as4
Classifications included in title: Staff scientist 1cm5PS5e5h5S5ft5cad5acc5adm5ai5eas5as5
Staff scientist 2cm6ps6e6h6s6ft6cad6acc6adm6ai6eaw6eas6aw6as6apd6amp6
Arboristcm7ps7e7h7s7ft7cad7acc7adm7ai7eaw7eas7aw7as7apd7amp7
Geologist 1cm8ps8e8h8s8ft8cad8acc8adm8ai8eaw8eas8aw8as8apd8amp8
Geologist 2cm9ps9e9h9s9ft9cad9acc9adm9ai9eaw9eas9aw9as9apd9amp9
Senior Project Technicalcm10ps10e10h10s10ft10cad10acc10adm10ai10eaw10eas10aw10as10apd10amp10
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$114.07Sr. Project Manager II$ 108.07Sr. Project Manager III$ 120.07cm3cm4cm5cm6cm7cm8cm9cm10
Project Supervisor$87.05Project Manager$ 78.05Sr. Project Manager I$ 96.05PS3PS4PS5ps6ps7ps8ps9ps10
Engineer$70.67Staff Professional IV$ 70.67e2e3e4e5e6e7e8e9e10
Hydrogeologist$60.04Staff Professional II$ 57.04Staff Professional III$ 63.03h3h4h5h6h7h8h9h10
Scientist$48.03Staff Professional I$ 48.03s2s3S4S5s6s7s8s9s10
Field Technician$42.02Field Technician I$ 33.02Field Technician II$ 39.02Field Technician III$ 45.02Field Technician IV$ 51.03ft5ft6ft7ft8ft9ft10
CADD/GIS$51.03GIS Tech$ 42.02GIS Analyst I$ 48.03GIS Analyst II$ 63.03cad4cad5cad6cad7cad8cad9cad10
Accounting$42.03Office Support$ 36.03Staff Professional I$ 48.03acc3acc4acc5acc6acc7acc8acc9acc10
Administrative Support$36.03Office Support$ 36.03adm2adm3adm4adm5adm6adm7adm8adm9adm10
Asbestos Inspector$35.33Field Technician I$ 32.39Field Technician II$ 38.27ai3ai4ai5ai6ai7ai8ai9ai10
Exterior Abatement Worker$32.39Field Technician I$ 32.390000eaw6eaw7eaw8eaw9eaw10
Exterior Asbestos Supervisor$61.84Site Supervisor I$ 55.95Site Supervisor II$ 67.72eas3eas4eas5eas6eas7eas8eas9eas10
Asbestos Worker$32.39Field Technician I$ 32.390000aw6aw7aw8aw9aw10
Asbestos Supervisor$61.84Site Supervisor I$ 55.95Site Supervisor II$ 67.72as3as4as5as6as7as8as9as10
Asbestos Project Designer$94.22Sr. Project Manager I$ 94.220000apd6apd7apd8apd9apd10
Asbestos Management Planner$94.22Sr. Project Manager I$ 94.220000amp6amp7amp8amp9amp10
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 .