GEI- ECO- Renewal Cost Table_2021.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
Ecological, Hazmat and Asbestos Services
Contract number
395002-O20-0510292-000-
Issued by
Wisconsin

About this file

This document is a contract cost worksheet and pricing table for GEI Consultants, Inc., appearing to be part of a state contract renewal for environmental consulting services. The document serves as an attachment for contract cost calculations and includes detailed pricing structures for various professional classifications and specialized services. GEI Consultants, Inc. is the contractor providing these services, though the specific state agency or jurisdiction is not explicitly identified in the provided content.

The contract covers environmental and hazardous materials consulting services, with specific pricing for asbestos inspections ranging from $594 to $694 per bridge structure depending on the number of structures inspected simultaneously. The pricing structure includes 16 different professional classifications with hourly rates ranging from $22.54 for Field Technicians to $62.77 for Contract Managers. Additional services include asbestos abatement, ecological services, and hazardous materials consulting, all billed at average direct hourly rates. The contract includes a proposed overhead rate of 190.67% and a profit margin of 7.00% on labor and overhead only, with no markup on subcontractor costs or direct expenses. Reimbursement rates are established for mileage at $0.51 per mile, meals ranging from $8-20, and lodging at $82-90 per night depending on location.

View the file

Other files

Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

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:GEI Consultants, Inc.
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$ 694.00$ 644.00$ 638.00$ 594.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$ 62.77Average Hourly Rate
Project Supervisor$ 45.89Average Hourly Rate
Engineer$ 33.81Average Hourly Rate*
Hydrogeologist$ 40.34Average Hourly Rate
Scientist$ 33.16Average Hourly Rate
Field Technician$ 22.54Average Hourly Rate
CADD, GIS$ 31.32Average Hourly Rate
Accounting$ 31.96Average Hourly Rate
Administrative Support$ 26.75Average Hourly Rate
Asbestos Inspector$ 39.28Average Hourly Rate
Exterior Abatement WorkerERROR:#DIV/0!Average Hourly Rate
Exterior Asbestos Supervisor39.24Average Hourly Rate
Asbestos WorkerERROR:#DIV/0!Average Hourly Rate
Asbestos Supervisor39.24Average Hourly Rate
Asbestos Project DesignerERROR:#DIV/0!Average Hourly Rate
Asbestos Management PlannerERROR:#DIV/0!Average 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$82.00
Per night, Milwaukee, Racine and Kenosha counties$90.00
Overhead rateTerms: Percentage of Direct Labor
Proposed rate190.670%Percentage of Direct Labor
ProfitTerms: percentage of labor and overhead, no profit on subcontractors or direct expenses
Proposed Rate7.000%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.)
GEI Consultants, Inc.Please 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:Project ManagerProject ManagerSenior EngineerProfessional GeologistEnvironmental ScientistStaff ProfessionalStaff ProfessionalProject AccountantAdministrative AssistantEnvironmental Scientisteaw1Environmental Scientistaw1Environmental Scientistapd1amp1
Vice PresidentSenior Project ScientistGeological EngineerGeological EngineerEcologistStaff ProfessionalConstruction ManagerProject AccountantAdministrative AssistantStaff Professionaleaw2eas2aw2as2apd2amp2
EXAMPLE:Senior HydrogeologistSenior EngineerEngineerSenior HydrogeologistEnvironmental ScientistField TechnicianCAD Drafteracc3Administrative AssistantSenior Project Scientisteaw3eas3aw3as3apd3amp3
Rate Title: ScientistSenior Restoration EcologistSenior EngineerEngineerStaff ProfessionalSenior Project ScientistTechnicianGIS Designeracc4adm4Environmental Engineereaw4eas4aw4as4apd4amp4
Classifications included in title: Staff scientist 1cm5Senior HydrogeologistStaff Professionalh5Staff ProfessionalTechnicianSenior Design Drafteracc5adm5Environmental Scientisteaw5eas5aw5as5apd5amp5
Staff scientist 2cm6Senior ProfessionalStaff Professionalh6Wetland ScientistTechnicianStaff Professionalacc6adm6ai6eaw6eas6aw6as6apd6amp6
Arboristcm7Senior Environmental Scientiste7h7Staff ProfessionalTechniciancad7acc7adm7ai7eaw7eas7aw7as7apd7amp7
Geologist 1cm8Senior Environmental Scientiste8h8Wildlife biologistStaff Professionalcad8acc8adm8ai8eaw8eas8aw8as8apd8amp8
Geologist 2cm9Senior Professionale9h9Staff Environmental Engineerft9cad9acc9adm9ai9eaw9eas9aw9as9apd9amp9
Senior Project Technicalcm10ps10e10h10Senior Natural Resources Managerft10cad10acc10adm10ai10eaw10eas10aw10as10apd10amp10
0

Tab 3 Average Wage Rate Calc

GEI Consultants, Inc.Fill 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$62.77Project Manager$ 41.24Vice President$ 83.32Senior Hydrogeologist$ 68.80Senior Restoration Ecologist$ 57.72cm5cm6cm7cm8cm9cm10
Project Supervisor$45.89Project Manager$ 41.24Senior Project Scientist$ 44.28Senior Engineer$ 37.20Senior Engineer$ 53.56Senior Hydrogeologist$ 44.24Senior Professional$ 46.76Senior Environmental Scientist$ 53.88Senior Environmental Scientist$ 43.28Senior Professional$ 48.60ps10
Engineer$33.81Senior Engineer$ 37.20Geological Engineer$ 33.12Engineer$ 36.48Engineer$ 34.48Staff Professional$ 29.24Staff Professional$ 32.36e7e8e9e10
Hydrogeologist$40.34Professional Geologist$ 48.84Geological Engineer$ 33.12Senior Hydrogeologist$ 44.24Staff Professional$ 35.16h5h6h7h8h9h10
Scientist$33.16Environmental Scientist$ 39.24Ecologist$ 36.08Environmental Scientist$ 32.72Senior Project Scientist$ 44.28Staff Professional$ 29.24Wetland Scientist$ 32.00Staff Professional$ 26.60Wildlife biologist$ 26.00Staff Environmental Engineer$ 29.40Senior Natural Resources Manager$ 36.08
Field Technician$22.55Staff Professional$ 22.36Staff Professional$ 29.80Field Technician$ 21.64Technician$ 21.52Technician$ 22.28Technician$ 19.28Technician$ 17.00Staff Professional$ 26.48ft9ft10
CADD/GIS$31.32Staff Professional$ 33.00Construction Manager$ 37.04CAD Drafter$ 31.48GIS Designer$ 25.00Senior Design Drafter$ 34.28Staff Professional$ 27.12cad7cad8cad9cad10
Accounting$31.96Project Accountant$ 34.96Project Accountant$ 28.96acc3acc4acc5acc6acc7acc8acc9acc10
Administrative Support$26.75Administrative Assistant$ 24.28Administrative Assistant$ 33.20Administrative Assistant$ 22.76adm4adm5adm6adm7adm8adm9adm10
Asbestos Inspector$39.28Environmental Scientist$ 32.72Staff Professional$ 35.16Senior Project Scientist$ 44.28Environmental Engineer$ 45.00Environmental Scientist$ 39.24ai6ai7ai8ai9ai10
Exterior Abatement WorkerERROR:#DIV/0!eaw1eaw2eaw3eaw4eaw5eaw6eaw7eaw8eaw9eaw10
Exterior Asbestos Supervisor$39.24Environmental Scientist$ 39.24eas2eas3eas4eas5eas6eas7eas8eas9eas10
Asbestos WorkerERROR:#DIV/0!aw1aw2aw3aw4aw5aw6aw7aw8aw9aw10
Asbestos Supervisor$39.24Environmental Scientist$ 39.24as2as3as4as5as6as7as8as9as10
Asbestos Project DesignerERROR:#DIV/0!apd1apd2apd3apd4apd5apd6apd7apd8apd9apd10
Asbestos Management PlannerERROR:#DIV/0!amp1amp2amp3amp4amp5amp6amp7amp8amp9amp10
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 .