AECOM-2021 Renewal Cost Table_ REVISED Team.xlsx

XLSX spreadsheet 38 KB Posted

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

About this file

This document is an AECOM Team contract cost worksheet for a 2021 renewal related to environmental consulting services. The file contains detailed cost calculations and pricing structures for various professional services including asbestos inspection, ecological services, and hazardous materials consulting. The document appears to be part of a state contract vehicle, likely with a Wisconsin state agency based on references to Wisconsin River bridges and Milwaukee area locations.

The contract covers asbestos inspection services for bridges with tiered pricing ranging from $700 to $950 per structure depending on volume, with single structures costing $950 and ten or more structures costing $700 each. The services include various professional classifications with hourly rates ranging from $21.09 for Administrative Support to $68.81 for Contract Managers. The pricing structure includes a 148% overhead rate on direct labor and a 9% profit margin on labor and overhead costs, with no profit markup on subcontractor costs or direct expenses. Additional services covered include ecological assessments, hazardous materials consulting, and various technical support roles. The contract also establishes standardized rates for travel expenses including mileage at $0.51 per mile, meals ranging from $8 for breakfast to $20 for dinner, and lodging at $82 per night ($90 in Milwaukee, Racine, and Kenosha counties).

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:AECOM Team
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$ 950.00$ 850.00$ 775.00$ 700.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$ 68.81Average Hourly Rate
Project Supervisor$ 58.45Average Hourly Rate
Engineer$ 46.98Average Hourly Rate*
Hydrogeologist$ 38.84Average Hourly Rate
Scientist$ 31.82Average Hourly Rate
Field Technician$ 25.53Average Hourly Rate
CADD, GIS$ 28.12Average Hourly Rate
Accounting$ 30.34Average Hourly Rate
Administrative Support$ 21.09Average Hourly Rate
Asbestos Inspector$ 36.31Average Hourly Rate
Exterior Abatement WorkerERROR:#DIV/0!Average Hourly Rate
Exterior Asbestos SupervisorERROR:#DIV/0!Average Hourly Rate
Asbestos WorkerERROR:#DIV/0!Average Hourly Rate
Asbestos SupervisorERROR:#DIV/0!Average 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 rate148.000%Percentage of Direct Labor
ProfitTerms: percentage of labor and overhead, no profit on subcontractors or direct expenses
Proposed Rate9.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.)
AECOM TeamPlease 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:Engineer VEngineer IVEngineer IIIEngineer IIEngineer ITechnician ITechnician IAccountant IProject Administrator IEngineer IIeaw1eas1aw1as1apd1amp1
Project Director IScientist IVScientist IIIScientist IIScientist ITechnician IITechnician IIProject Administrator IIIProject Administrator IIEngineer IIIeaw2eas2aw2as2apd2amp2
EXAMPLE:Project Director IIScientist Ve3h3Technician IIIft3Technician IIIacc3Project Administrator IIIScientist IIIeaw3eas3aw3as3apd3amp3
Rate Title: Scientistcm4ps4e4h4s4ft4Technician IVacc4adm4Scientist IIeaw4eas4aw4as4apd4amp4
Classifications included in title: Staff scientist 1cm5ps5e5h5s5ft5cad5acc5adm5Technicain IIIeaw5eas5aw5as5apd5amp5
Staff scientist 2cm6ps6e6h6s6ft6cad6acc6adm6Engineer Ieaw6eas6aw6as6apd6amp6
Arboristcm7ps7e7h7s7ft7cad7acc7adm7Technician Ieaw7eas7aw7as7apd7amp7
Geologist 1cm8ps8e8h8s8ft8cad8acc8adm8Scientist Ieaw8eas8aw8as8apd8amp8
Geologist 2cm9ps9e9h9s9ft9cad9acc9adm9ai9eaw9eas9aw9as9apd9amp9
Senior Project Technicalcm10ps10e10h10s10ft10cad10acc10adm10ai10eaw10eas10aw10as10apd10amp10
0

Tab 3 Average Wage Rate Calc

AECOM TeamFill 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$68.81Engineer V$ 72.18Project Director I$ 68.64Project Director II$ 65.62cm4cm5cm6cm7cm8cm9cm10
Project Supervisor$58.45Engineer IV$ 62.01Scientist IV$ 58.35Scientist V$ 55.00ps4ps5ps6ps7ps8ps9ps10
Engineer$46.98Engineer III$ 49.00Scientist III$ 44.95e3e4e5e6e7e8e9e10
Hydrogeologist$38.84Engineer II$ 40.43Scientist II$ 37.24h3h4h5h6h7h8h9h10
Scientist$31.82Engineer I$ 33.71Scientist I$ 31.90Technician III$ 29.85s4s5s6s7s8s9s10
Field Technician$25.53Technician I$ 23.41Technician II$ 27.64ft3ft4ft5ft6ft7ft8ft9ft10
CADD/GIS$28.12Technician I$ 23.41Technician II$ 27.64Technician III$ 29.85Technician IV$ 31.57cad5cad6cad7cad8cad9cad10
Accounting$30.34Accountant I$ 28.45Project Administrator III$ 32.23acc3acc4acc5acc6acc7acc8acc9acc10
Administrative Support$21.09Project Administrator I$ 17.75Project Administrator II$ 20.15Project Administrator III$ 25.38adm4adm5adm6adm7adm8adm9adm10
Asbestos Inspector$36.31Engineer II$ 40.43Engineer III$ 49.00Scientist III$ 44.95Scientist II$ 37.24Technicain III$ 29.85Engineer I$ 33.71Technician I$ 23.41Scientist I$ 31.90ai9ai10
Exterior Abatement WorkerERROR:#DIV/0!eaw1eaw2eaw3eaw4eaw5eaw6eaw7eaw8eaw9eaw10
Exterior Asbestos SupervisorERROR:#DIV/0!eas1eas2eas3eas4eas5eas6eas7eas8eas9eas10
Asbestos WorkerERROR:#DIV/0!aw1aw2aw3aw4aw5aw6aw7aw8aw9aw10
Asbestos SupervisorERROR:#DIV/0!as1as2as3as4as5as6as7as8as9as10
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 .