GEI- Renewal Cost Table_GEI_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 renewal pricing table for GEI Consultants, Inc., submitted as part of a state contract renewal process. The spreadsheet contains detailed instructions and rate structures for various professional services, with specific tabs dedicated to hourly rates, staff classifications, wage calculations, and cost estimates for ecological services and hazardous materials work. The document appears to be part of a Wisconsin state contract vehicle, as evidenced by references to Wisconsin-specific bridges and counties including Milwaukee, Racine, and Kenosha.

The contract covers a comprehensive range of environmental and engineering services including asbestos inspections, abatement services, ecological consulting, and hazardous materials work. Asbestos bridge inspections are priced on a tiered structure ranging from $594 to $694 per structure depending on volume, with special negotiation provisions for major Wisconsin bridges. Professional staff hourly rates vary significantly by classification, from Field Technicians at $22.54 per hour to Contract Managers at $62.77 per hour. The pricing structure includes a 190.67% overhead rate on direct labor and a 7% profit margin on labor and overhead costs, with no markup on subcontractor costs or direct expenses. Reimbursement rates follow current state standards including $0.51 per mile for vehicle usage, standardized meal allowances, and lodging rates of $82-90 per night depending on location within Wisconsin.

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 .