6_Cost_Proposal_Attachment_D_Cost_table_AECOM.xlsx
XLSX spreadsheet 76 KB Posted
- Attached to
- Environmental Services-Hazardous Materials and Asbestos-Investigation and Remediation Services
- Contract number
- 395002-O24-0510573-000
- Issued by
- Wisconsin
About this file
This document is a detailed cost proposal spreadsheet for RFP 510573 submitted by AECOM Team to a state agency, containing comprehensive pricing information for environmental assessment services. The spreadsheet includes multiple worksheets covering hourly rates, staff classifications, and cost calculations for various environmental services including asbestos inspections, site assessments, and residential lead sampling. AECOM has provided detailed staff classifications ranging from Contract Managers at $76.67/hour to Field Technicians at $24.81/hour, with proposed overhead rates of 148% and profit margins of 9% on labor and overhead costs.
The contract covers a comprehensive range of environmental services with specific pricing structures: asbestos inspections for bridges ranging from $1,200-$2,500 per structure depending on quantity, combined bat and asbestos inspections from $1,800-$5,000 per structure, and confined space inspections from $6,000-$12,000 per structure. Additional services include fueling system removal, Phase 2 site assessments, construction dewatering, pre-acquisition assessments, and residential lead sampling with paint chip samples at $10 each and bulk lead sampling at $62 per sample. The total market basket cost breakdown shows $2,983,455 for environmental assessments, $182,118 for residential lead sampling, $30,881 for program management assistance, and $2,530,000 for asbestos inspections, resulting in a total contract value of approximately $5.73 million. Direct expenses are charged at cost with no markup, subcontractor costs at actual cost with no markup, and mileage at the current state reimbursement rate of $0.51 per mile.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP_510573_Attachment_D_Cost_table_TRC.xlsx | XLSX spreadsheet | |
| RFP_510573_Attachment_D_Cost_table_Ramboll.xlsx | XLSX spreadsheet | |
| RFP_510573_Attachment_D_Cost_table_Terracon.xlsx | XLSX spreadsheet | |
| GEI__Attachment_D_Cost_table_510573.xlsx | XLSX spreadsheet |
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 RFP 510573 Attachment E | |
| 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 Costs | Cell # |
| 1. Fill in firm name | B2 |
| 2. Fill in asbestos inspection costs per bridge structure, cells | B5, C5, D5, E5 |
| 3. Fill in combined bat and asbestos inspection cost per bridge structure, cells | B6, C6, D6, E6 |
| 4. Fill in confined space combined bat and asbestos inspection cost per bridge structure, cells | B7 C7 D7 E7 |
| 5. Fill in standalone bat inspections cost per bridge structure, cells | B8, C8, D8, E8 |
| 6. Fill in confined space standalone bat inspection cost per bridge structure, cells | B9, C9, D9, E9 |
| 7. Fill in proposed overhead rate | B42 |
| 8. Fill in proposed profit percentage as a whole number, field is formatted as a percentage | B45 |
| Tab 2 Classifications in titles | Cell # |
| 1. Please fit each of your current employee classifications into one of the Twenty Eight contract Rate titles | B4 through AC13 |
| 2. Put no more than ten classifications into each rate category. | |
| 3. Leave unused cells blank | |
| Tab 3 Average Wage Rate Calc | Cell # |
| 1. Enter the direct hourly wage rate (without overhead or profit) for each classification entered in Tab 2 | Columns D,F,H,J,L,N,P,R,T,V, Cells 4 through 31 |
| 2. Put a zero in any unused cell in column D | |
| 3. Leave all other unused cells blank |
| Tab 4 Fueling System Removal | |
| 1. Enter the number of hours for each classification for each task in columns C through F G | Columns C, D, E, F, G rows 4 through 31 |
| 2. Enter direct expenses in columns J K through M N | Columns J K, L, M, N rows 4 through 31 |
| 3. Enter subcontract costs in columns P Q through R S | Columns P, Q, R S rows 4 through 31 |
| Tab 5 Phase 2 Site Assessment | |
| 1. Enter the tasks from the project scope document in Cells C3 through J3 | Columns C, D, E, F, G, H, I, J row 3 |
| 2. Enter the number of hours for each classification for each task in Columns C through J | Columns C, D, E, F, G, H, I, J rows 4-31 |
| 3. Enter the direct expenses in columns N through Q | Columns N, O, P, Q, rows 4-31 |
| 5. Enter the subcontract costs in columns T through V | Columns T, U, V rows 4-31 |
| Tab 6 Construction Dewatering |
| 1. Enter the tasks from the project scope document in Cells C3 through J3 |
| 2. Enter the number of hours for each classification for each task in Columns C through J |
| 3. Enter the direct expenses in columns N through Q |
| 5. Enter the subcontract costs in columns T through V |
| Tab 7 Pre-Acquisition Site Assessment |
| 1. Enter the tasks from the project scope document in Cells C3 through J3 |
| 2. Enter the number of hours for each classification for each task in Columns C through J |
| 3. Enter the direct expenses in columns N through Q |
| 5. Enter the subcontract costs in columns T through V |
| Tab 8 Residential Lead Sampling |
| 1. Fill in the price per sample in Column B |
| 2.Fill in the price per expedited sample in Column C |
Tab 1 Hourly Rates and Costs
| Contract Cost Package 2024 | Fill in only those cells highlighted in blue. Cells in green are calculated. | ||||
| FIRM NAME: | AECOM Team | ||||
| Asbestos Inspections - Bridges | Terms: Lump Sum | ||||
| Cost per single structure | Two to four structures, cost per structure | Five to nine structures, cost per structure | Ten or more structures, cost per structure | ||
| Asbestos inspection, per bridge structure (Terms: Lump Sum) | $ 2,500.00 | $ 2,000.00 | $ 1,500.00 | $ 1,200.00 | |
| Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum) | $ 5,000.00 | $ 3,500.00 | $ 2,200.00 | $ 1,800.00 | |
| Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum | $ 12,000.00 | $ 10,000.00 | $ 8,000.00 | $ 7,000.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) | $ 4,000.00 | $ 2,500.00 | $ 1,500.00 | $ 1,100.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 10,000.00 | $ 8,500.00 | $ 6,800.00 | $ 6,000.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 structures | Terms: average direct hourly rate* | ||
| Asbestos abatement | Terms: average direct hourly rate* | ||
| Project Staff | Terms: average direct hourly rate* | *the average direct hourly rate for each classification shall be the rate charged for the contract | |
| Contract Manager | $76.67 | Average Hourly Rate | |
| Project Supervisor I | $50.00 | Average Hourly Rate | |
| Project Supervisor II | $66.67 | Average Hourly Rate | |
| Engineer I | $48.89 | Average Hourly Rate | |
| Engineer II | $57.41 | Average Hourly Rate | |
| Engineer III | $62.96 | Average Hourly Rate | |
| Hydrogeologist I | $39.26 | Average Hourly Rate | |
| Hydrogeologist II | $46.67 | Average Hourly Rate | |
| Hydrogeologist III | $54.07 | Average Hourly Rate | |
| Scientist I | $32.59 | Average Hourly Rate | |
| Scientist II | $38.15 | Average Hourly Rate | |
| Scientist III | $45.93 | Average Hourly Rate | |
| Field Technician I | $24.81 | Average Hourly Rate | |
| Field Technician II | $29.26 | Average Hourly Rate | |
| Field Technician III | $35.93 | Average Hourly Rate | |
| CADD/GIS I | $30.37 | Average Hourly Rate | |
| CADD/GIS II | $41.11 | Average Hourly Rate | |
| Accounting I | $31.48 | Average Hourly Rate | |
| Accounting II | $42.59 | Average Hourly Rate | |
| Administrative Support I | $24.07 | Average Hourly Rate | |
| Administrative Support II | $35.93 | Average Hourly Rate | |
| Asbestos Inspector | $41.11 | Average Hourly Rate | |
| Exterior Abatement Worker | $0.00 | Average Hourly Rate | |
| Exterior Asbestos Supervisor | $0.00 | Average Hourly Rate | |
| Asbestos Worker | $0.00 | Average Hourly Rate | |
| Asbestos Supervisor | $0.00 | Average Hourly Rate | |
| Asbestos Project Designer | $0.00 | Average Hourly Rate | |
| Asbestos Management Planner | $0.00 | Average Hourly Rate | |
| Equipment and supplies | Terms: direct expense, no markup | ||
| Subcontractor Costs | Terms: actual cost, no markup | ||
| Mileage | Terms: current state reimbursement rate | ||
| Per mile, personal vehicle rate | $0.51/mile | ||
| Meals | Terms: current state reimbursement rate | ||
| Breakfast | $ 10.00 | ||
| Lunch | $ 12.00 | ||
| Dinner | $ 23.00 | ||
| Lodging | Terms: 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 structures | Terms: average direct hourly rate* | ||
| Overhead | |||
| Proposed rate | 148.000% | Percentage of Direct Labor | |
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 9% | 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 Team | Please fill in the actual titles of your staff. Limit 10 titles per classification | |||||||||||||||||||||||||||
| Rate Title: | Contract Manager | Project Supervisor I | Project Supervisor II | Engineer I | Engineer II | Engineer III | Hydrogeologist I | Hydrogeologist II | Hydrogeologist III | Scientist I | Scientist II | Scientist III | Field Technician I | Field Technician II | Field Technician III | CADD/GIS I | CADD/GIS II | Accounting I | Accounting II | Administrative Support I | Administrative Support II | Asbestos Inspector | Exterior Abatement Worker | Exterior Asbestos Supervisor | Asbestos Worker | Asbestos Supervisor | Asbestos Project Designer | Asbestos Management Planner |
| Classifications included in Rate Titles: | Project Director I | Scientist IV | Scientist V | Engineer I | Engineer II | Engineer III | Scientist I | Scientist II | Scientist III | Scientist I | Scientist II | Scientist III | Technician I | Technician III | Technician III | Technician IV | Scientist I | Accountant I | Accountant II | Project Administrator I | Project Administrator II | Scientist I | eaw1 | eas1 | aw1 | as1 | apd1 | amp1 |
| Project Director II | Scientist V | Scientist VI | Engineer II | Engineer III | Engineer IV | Scientist II | Scientist III | Scientist IV | Technician II | Scientist I | Scientist II | Technician II | ftII2 | Scientist I | cadI2 | Engineer I | Accountant II | Accountant III | Project Administrator II | Project Administrator II | Scientist II | eaw2 | eas2 | aw2 | as2 | apd2 | amp2 | |
| Project Director III | Scientist VI | Scientist VII | Engineer III | Engineer IV | Engineer V | hI3 | hII3 | Engineer I | Technician III | Technician IV | Technician V | Techncian III | ftII3 | Technician V | cadI3 | cadII3 | accI3 | accII3 | Project Administrator III | Project Administrator II | Engineer I | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 | |
| cm4 | psI4 | psII4 | eI4 | eII4 | eIII4 | hI4 | hII4 | hIII4 | sI4 | sII4 | sIII4 | ftI4 | ftII4 | ftIII4 | cadI4 | cadII4 | accI4 | accII4 | admI4 | admII4 | ai4 | eaw4 | eas4 | aw4 | as4 | apd4 | amp4 | |
| cm5 | psI5 | psII5 | eI5 | eII5 | eIII5 | hI5 | hII5 | hIII5 | sI5 | sII5 | sIII5 | ftI5 | ftII5 | ftIII5 | cadI5 | cadII5 | accI5 | accII5 | admI5 | admII5 | ai5 | eaw5 | eas5 | aw5 | as5 | apd5 | amp5 | |
| cm6 | psI6 | psII6 | eI6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | sI6 | sII6 | sIII6 | ftI6 | ftII6 | ftIII6 | cadI6 | cadII6 | accI6 | accII6 | admI6 | admII6 | ai6 | eaw6 | eas6 | aw6 | as6 | apd6 | amp6 | |
| cm7 | psI7 | psII7 | eI7 | eII7 | eIII7 | hI7 | hII7 | hIII7 | sI7 | sII7 | sIII7 | ftI7 | ftII7 | ftIII7 | cadI7 | cadII7 | accI7 | accII7 | admI7 | admII7 | ai7 | eaw7 | eas7 | aw7 | as7 | apd7 | amp7 | |
| cm8 | psI8 | psII8 | eI8 | eII8 | eIII8 | hI8 | hII8 | hIII8 | sI8 | sII8 | sIII8 | ftI8 | ftII8 | ftIII8 | cadI8 | cadII8 | accI8 | accII8 | admI8 | admII8 | ai8 | eaw8 | eas8 | aw8 | as8 | apd8 | amp8 | |
| cm9 | psI9 | psII9 | eI9 | eII9 | eIII9 | hI9 | hII9 | hIII9 | sI9 | sII9 | sIII9 | ftI9 | ftII9 | ftIII9 | cadI9 | cadII9 | accI9 | accII9 | admI9 | admII9 | ai9 | eaw9 | eas9 | aw9 | as9 | apd9 | amp9 | |
| cm10 | psI10 | psII10 | eI10 | eII10 | eIII10 | hI10 | hII10 | hIII10 | sI10 | sII10 | sIII10 | ftI10 | ftII10 | ftIII10 | cadI10 | cadII10 | accI10 | accII10 | admI10 | admII10 | ai10 | eaw10 | eas10 | aw10 | as10 | apd10 | amp10 | |
| EXAMPLE: | 0 | |||||||||||||||||||||||||||
| Rate Title: Scientist I | ||||||||||||||||||||||||||||
| Classifications included in title: Staff scientist 1 | ||||||||||||||||||||||||||||
| Arborist | ||||||||||||||||||||||||||||
| Geologist 1 | ||||||||||||||||||||||||||||
| Geologist 2 | ||||||||||||||||||||||||||||
| Senior Project Technical 1 | ||||||||||||||||||||||||||||
| Senior Project Technical 2 |
Tab 3 Average Wage Rate Calc
| AECOM Team | 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 | |||||||||||||||||||||
| Title | Average Hourly Rate | Classification 1 | Hourly rate 1 | Classification 2 | Hourly Rate 2 | Classification 3 | Hourly Rate 3 | Classification 4 | Hourly Rate 4 | Classification 5 | Hourly Rate 5 | Classification 6 | Hourly Rate 6 | Classification 7 | Hourly Rate 7 | Classification 8 | Hourly Rate 8 | Classification 9 | Hourly Rate 9 | Classification 10 | Hourly Rate 10 |
| Contract Manager | $76.67 | Project Director I | $ 72.38 | Project Director II | $ 77.00 | Project Director III | $ 80.62 | cm4 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | |||||||
| Project Supervisor I | $50.00 | Scientist IV | $ 47.00 | Scientist V | $ 50.00 | Scientist VI | $ 53.00 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | |||||||
| Project Supervisor II | $66.67 | Scientist V | $ 61.70 | Scientist VI | $ 66.90 | Scientist VII | $ 71.40 | psII4 | psII5 | psII6 | psII7 | psII8 | psII9 | psII10 | |||||||
| Engineer I | $48.89 | Engineer I | $ 43.30 | Engineer II | $ 49.29 | Engineer III | $ 54.08 | eI4 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | |||||||
| Engineer II | $57.41 | Engineer II | $ 52.58 | Engineer III | $ 57.15 | Engineer IV | $ 62.50 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||
| Engineer III | $62.96 | Engineer III | $ 58.18 | Engineer IV | $ 63.10 | Engineer V | $ 67.60 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | |||||||
| Hydrogeologist I | $39.26 | Scientist I | $ 34.60 | Scientist II | $ 43.91 | hI3 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | ||||||||
| Hydrogeologist II | $46.67 | Scientist II | $ 41.50 | Scientist III | $ 51.83 | hII3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | ||||||||
| Hydrogeologist III | $54.07 | Scientist III | $ 49.29 | Scientist IV | $ 63.81 | Engineer I | $ 49.10 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||
| Scientist I | $32.59 | Scientist I | $ 38.90 | Technician II | $ 27.46 | Technician III | $ 31.40 | sI4 | sI5 | sI6 | sI7 | sI8 | sI9 | sI10 | |||||||
| Scientist II | $38.15 | Scientist II | $ 41.31 | Scientist I | $ 31.99 | Technician IV | $ 41.15 | sII4 | sII5 | sII6 | sII7 | sII8 | sII9 | sII10 | |||||||
| Scientist III | $45.93 | Scientist III | $ 50.28 | Scientist II | $ 42.07 | Technician V | $ 45.43 | sIII4 | sIII5 | sIII6 | sIII7 | sIII8 | sIII9 | sIII10 | |||||||
| Field Technician I | $24.81 | Technician I | $ 19.50 | Technician II | $ 25.84 | Techncian III | $ 29.10 | ftI4 | ftI5 | ftI6 | ftI7 | ftI8 | ftI9 | ftI10 | |||||||
| Field Technician II | $29.26 | Technician III | $ 29.26 | ftII2 | ftII3 | ftII4 | ftII5 | ftII6 | ftII7 | ftII8 | ftII9 | ftII10 | |||||||||
| Field Technician III | $35.93 | Technician III | $ 29.73 | Scientist I | $ 34.80 | Technician V | $ 43.26 | ftIII4 | ftIII5 | ftIII6 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | |||||||
| CADD/GIS I | $30.37 | Technician IV | $ 30.37 | cadI2 | cadI3 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||||
| CADD/GIS II | $41.11 | Scientist I | $ 38.85 | Engineer I | $ 43.37 | cadII3 | cadII4 | cadII5 | cadII6 | cadII7 | cadII8 | cadII9 | cadII10 | ||||||||
| Accounting I | $31.48 | Accountant I | $ 27.78 | Accountant II | $ 35.17 | accI3 | accI4 | accI5 | accI6 | accI7 | accI8 | accI9 | accI10 | ||||||||
| Accounting II | $42.59 | Accountant II | $ 34.85 | Accountant III | $ 50.32 | accII3 | accII4 | accII5 | accII6 | accII7 | accII8 | accII9 | accII10 | ||||||||
| Administrative Support I | $24.07 | Project Administrator I | $ 21.22 | Project Administrator II | $ 24.00 | Project Administrator III | $ 27.00 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | |||||||
| Administrative Support II | $35.93 | Project Administrator II | $ 23.29 | Project Administrator II | $ 34.00 | Project Administrator II | $ 50.50 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | |||||||
| Asbestos Inspector | $41.11 | Scientist I | $ 38.79 | Scientist II | $ 41.28 | Engineer I | $ 43.26 | ai4 | ai5 | ai6 | ai7 | ai8 | ai9 | ai10 | |||||||
| Exterior Abatement Worker | $0.00 | eaw1 | $ - 0 | eaw2 | eaw3 | eaw4 | eaw5 | eaw6 | eaw7 | eaw8 | eaw9 | eaw10 | |||||||||
| Exterior Asbestos Supervisor | $0.00 | eas1 | $ - 0 | eas2 | eas3 | eas4 | eas5 | eas6 | eas7 | eas8 | eas9 | eas10 | |||||||||
| Asbestos Worker | $0.00 | aw1 | $ - 0 | aw2 | aw3 | aw4 | aw5 | aw6 | aw7 | aw8 | aw9 | aw10 | |||||||||
| Asbestos Supervisor | $0.00 | as1 | $ - 0 | as2 | as3 | as4 | as5 | as6 | as7 | as8 | as9 | as10 | |||||||||
| Asbestos Project Designer | $0.00 | apd1 | $ - 0 | apd2 | apd3 | apd4 | apd5 | apd6 | apd7 | apd8 | apd9 | apd10 | |||||||||
| Asbestos Management Planner | $0.00 | amp1 | $ - 0 | amp2 | amp3 | amp4 | amp5 | amp6 | amp7 | amp8 | amp9 | amp10 |
| Example: | Average Hourly Rate | Classification 1 | Hourly rate 1 | Classification 2 | Hourly Rate 2 | Classification 3 | Hourly Rate 3 | Classification 4 | Hourly Rate 4 | Classification 5 | Hourly Rate 5 | Classification 6 | Hourly Rate 6 |
| Scientist | $30.57 | Staff Scientist 1 | $ 21.20 | Staff Scientist 2 | $ 23.70 | Staff Scientist 3 | $ 27.50 | Geologist 1 | $ 32.50 | Geologist 2 | $ 37.50 | Senior Project Technical | $ 41.00 |
Tab 4 Fueling System Removal
| AECOM Team | Fueling System Removal | |||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | ||||||||||||||
| Classification | Hourly rate | Gen'l, H&S, Pre-Field | Field Work | Disposal | Reporting | Task 5 | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total | Subcontractor | Task | Total |
| Contract Manager | $76.67 | 1 | 1 | $ 76.67 | PID (OVM) | 1 | Day | $75 | $ 75.00 | Tank remover/cleaner | Tank Sys'm Rem'l, Disposal | $ 8,600.00 | ||||
| Project Supervisor I | $50.00 | 6 | 1 | 3 | 10 | $ 500.00 | Level D PPE | 2 | Day | $15 | $ 30.00 | Landfill (Haul & Disposal) | Disposal: 1 Load C-Soil | $ 1,500.00 | ||
| Project Supervisor II | $66.67 | 0 | $ - 0 | Field Supplies | 1 | LS | $10 | $ 10.00 | Laboratory | Soil & Wastewater Testing | $ 2,895.00 | |||||
| Engineer I | $48.89 | 0 | $ - 0 | Vehicle Usage | 20 | Mile | $0.51 | $ 10.20 | $ - 0 | |||||||
| Engineer II | $57.41 | 0 | $ - 0 | Lunch | 1 | Day | $12 | $ 12.00 | $ - 0 | |||||||
| Engineer III | $62.96 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist I | $39.26 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist II | $46.67 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist III | $54.07 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist I | $32.59 | 2 | 2 | $ 65.17 | $ - 0 | $ - 0 | ||||||||||
| Scientist II | $38.15 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist III | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician I | $24.81 | 2 | 10 | 4 | 12 | 28 | $ 694.77 | $ - 0 | $ - 0 | |||||||
| Field Technician II | $29.26 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician III | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| CADD/GIS I | $30.37 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| CADD/GIS II | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting I | $31.48 | 4 | 4 | $ 125.90 | $ - 0 | $ - 0 | ||||||||||
| Accounting II | $42.59 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Administrative Support I | $24.07 | 2 | 2 | 4 | $ 96.29 | $ - 0 | $ - 0 | |||||||||
| Administrative Support II | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Inspector | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Project Designer | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Management Planner | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 1,558.80 Total Direct Expenses $ 137.20 Total Subcontracts $ 12,995.00
Tab 5 Phase 2 Site Assessment
| AECOM Team | Phase 2 Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | Gen'l, H&S, Pre-Field | Field Work & Analysis | Reporting | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total cost | Subcontractor | Task | Total cost |
| Contract Manager | $76.67 | 1 | 1 | $ 76.67 | PID (OVM) | 1 | Day | $75 | $ 75.00 | Driller (direct-push) | Soil Borings & Sampling | $ 2,600.00 | |||||||
| Project Supervisor I | $50.00 | 6 | 1 | 3 | 10 | $ 500.00 | Level D PPE | 1 | Day | $15 | $ 15.00 | Laboratory | Soil & Water Analysis | $ 3,468.00 | |||||
| Project Supervisor II | $66.67 | 0 | $ - 0 | Field Supplies | 1 | LS | $10 | $ 10.00 | $ - 0 | ||||||||||
| Engineer I | $48.89 | 0 | $ - 0 | Vehicle Usage | 10 | Mile | $0.51 | $ 5.10 | $ - 0 | ||||||||||
| Engineer II | $57.41 | 0 | $ - 0 | Lunch | 1 | Day | $12 | $ 12.00 | $ - 0 | ||||||||||
| Engineer III | $62.96 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $39.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $46.67 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $54.07 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $32.59 | 2 | 2 | $ 65.17 | $ - 0 | $ - 0 | |||||||||||||
| Scientist II | $38.15 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $24.81 | 4 | 10 | 20 | 34 | $ 843.65 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $29.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $30.37 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS II | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $31.48 | 4 | 4 | $ 125.90 | $ - 0 | $ - 0 | |||||||||||||
| Accounting II | $42.59 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.07 | 2 | 2 | 4 | $ 96.29 | $ - 0 | $ - 0 | ||||||||||||
| Administrative Support II | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Total Staff Labor | $ 1,707.68 | Total Direct Expenses | $ 117.10 | Total Subcontracts | $ 6,068.00 |
Tab 6 Construction Dewatering
| AECOM Team | Construction Dewatering | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | Gen'l, H&S and Pre-Field | Field Work and Analysis | Reporting | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total cost | Subcontractor | Task | Total cost |
| Contract Manager | $76.67 | 1 | 1 | $ 76.67 | PID (OVM) | 2 | Day | $118 | $ 236.00 | None | $ - 0 | ||||||||
| Project Supervisor I | $50.00 | 6 | 2 | 2 | 10 | $ 500.00 | Level D PPE | 2 | Day | $15 | $ 30.00 | $ - 0 | |||||||
| Project Supervisor II | $66.67 | 0 | $ - 0 | Field Supplies (expendable) | 1 | LS | $10 | $ 10.00 | $ - 0 | ||||||||||
| Engineer I | $48.89 | 0 | $ - 0 | 2,500-gallon Poly Tanks | 2 | Each | 3,000 | $ 6,000.00 | $ - 0 | ||||||||||
| Engineer II | $57.41 | 0 | $ - 0 | Vehicle Mileage | 20 | Mile | $0.51 | $ 10.20 | $ - 0 | ||||||||||
| Engineer III | $62.96 | 0 | $ - 0 | Lunch | 2 | day | $12 | $ 24.00 | $ - 0 | ||||||||||
| Hydrogeologist I | $39.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $46.67 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $54.07 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $32.59 | 2 | 2 | $ 65.17 | $ - 0 | $ - 0 | |||||||||||||
| Scientist II | $38.15 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $24.81 | 2 | 16 | 12 | 30 | $ 744.40 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $29.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $30.37 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS II | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $31.48 | 4 | 4 | $ 125.90 | $ - 0 | $ - 0 | |||||||||||||
| Accounting II | $42.59 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.07 | 1 | 2 | 3 | $ 72.22 | $ - 0 | $ - 0 | ||||||||||||
| Administrative Support II | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 1,584.36 Total Direct Expenses $ 6,310.20 Total Subcontracts $ - 0
Tab 7 Pre-Acquisition Assessmen
| AECOM Team | Pre- Acquisition Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | Gen'l, H&S, Pre-Field | Field Work & Analysis | Reporting | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total cost | Subcontractor | Task | Total cost |
| Contract Manager | $76.67 | 1 | 1 | $ 76.67 | PID (OVM) | 1 | Day | $75 | $ 75.00 | Driller (direct-push) | Soil Borings & Sampling | $ 2,600.00 | |||||||
| Project Supervisor I | $50.00 | 6 | 1 | 3 | 10 | $ 500.00 | Level D PPE | 1 | Day | $15 | $ 15.00 | Laboratory | Soil & Water Samples Analysis | $ 6,537.00 | |||||
| Project Supervisor II | $66.67 | 0 | $ - 0 | Field Supplies | 1 | LS | $10 | $ 10.00 | $ - 0 | ||||||||||
| Engineer I | $48.89 | 0 | $ - 0 | Vehicle Usage | 10 | Mile | $0.51 | $ 5.10 | $ - 0 | ||||||||||
| Engineer II | $57.41 | 0 | $ - 0 | Lunch | 1 | Day | $12 | $ 12.00 | $ - 0 | ||||||||||
| Engineer III | $62.96 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $39.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $46.67 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $54.07 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $32.59 | 2 | 2 | $ 65.17 | $ - 0 | $ - 0 | |||||||||||||
| Scientist II | $38.15 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $24.81 | 4 | 10 | 22 | 36 | $ 893.28 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $29.26 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $30.37 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS II | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $31.48 | 4 | 4 | $ 125.90 | $ - 0 | $ - 0 | |||||||||||||
| Accounting II | $42.59 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.07 | 1 | 2 | 3 | $ 72.22 | $ - 0 | $ - 0 | ||||||||||||
| Administrative Support II | $35.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $41.11 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 1,733.24 Total Direct Expenses $ 117.10 Total Subcontracts $ 9,137.00
Tab 8 Residential Lead Sampling
| AECOM Team | Residential Lead Sampling | |
| Sample Type | Price per Sample | Expedited Turnaround Price per Sample |
| Paint chips | $10 | $54 |
| Bulk Lead Sampling | $62 | $193 |
| Wipe Sampling | $9.55 | $54 |
Total Cost Score
| Category | Market Basket | Total Cost |
| Environmental Assessment | {(Labor + Labor*overhead)*profit +(Labor + Labor*overhead)+Direct Expenses + Subcontractor}* Market Basket | |
| Fueling system Removal | 22 | 381611.0974016 |
| Phase 2 Site Assessment | 157 | 1695805.8880416 |
| Construction Dewatering | 25 | 264825.868586667 |
| Pre-Acquisition Assessment | 46 | 641211.809335467 |
| Total Environmental Assessment COST | 2983454.66336533 |
| Residential Lead Sampling | Market basket | |
| Paint Chips | 5 | $ 50.00 |
| Bulk Lead | 100 | $ 6,200.00 |
| Wipe | 1250 | $ 11,937.50 |
| Paint chips expedited | 0 | $ - 0 |
| Bulk Lead expedited | 10 | $ 1,930.00 |
| Wipe Expedited | 3000 | $ 162,000.00 |
Total Residential Lead Sampling Cost $ 182,117.50
| Program Management Assistance | Number of Hours | Staff classification | total |
| 1040 | Admin Support 1 | $ 25,036.27 | |
| 40 | Project supervisor 2 | $ 2,666.67 | |
| 20 | Contract Manager | $ 1,533.33 | |
| 40 | CADD/GIS 2 | $ 1,644.40 |
| Total Program Management Assistance Cost | $ 30,880.67 | ||
| Market Basket | |||
| Asbestos inspection | |||
| Normal one person | 844 | $ 2,110,000.00 | |
| Asbestos plus bats | |||
| confined space, two people | 35 | $ 420,000.00 | |
| Total Asbestos Inspection cost | $ 2,530,000.00 |
Total Cost 5726452.830032
File details come from the government source that posted it. Updated .