RFP_510573_Attachment_D_Cost_table_Terracon.xlsx
XLSX spreadsheet 72 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 cost proposal spreadsheet (RFP 510573 Attachment D) submitted by Terracon Consultants, Inc. for state and local environmental consulting services. The spreadsheet contains detailed pricing structures across multiple service categories including asbestos and bat inspections for bridge structures, environmental assessments, residential lead sampling, and program management assistance. Terracon has provided comprehensive hourly rates for 28 different staff classifications ranging from field technicians to contract managers, with rates spanning from $22.00 for Field Technician II to $81.75 for Project Supervisor II.
The contract covers diverse environmental services with specific pricing tiers based on project scale. Bridge asbestos inspections range from $750-$850 per structure depending on quantity, while combined bat and asbestos inspections cost $800-$900 per structure. Confined space inspections requiring two-person teams are priced at $1,100-$1,500 per structure. The proposal includes detailed cost breakdowns for fueling system removal, Phase 2 site assessments, construction dewatering, and pre-acquisition assessments, with total environmental assessment costs of $2,390,595. Residential lead sampling services range from $7.60-$16.03 per sample depending on type and turnaround time. The company applies a 200.86% overhead rate and 8% profit margin on labor costs, with direct expenses and subcontractor costs billed at actual cost without markup. The total market basket cost across all services amounts to $3,252,600.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 6_Cost_Proposal_Attachment_D_Cost_table_AECOM.xlsx | XLSX spreadsheet | |
| RFP_510573_Attachment_D_Cost_table_TRC.xlsx | XLSX spreadsheet | |
| RFP_510573_Attachment_D_Cost_table_Ramboll.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: | Terracon Consultants, Inc. | ||||
| 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) | $ 850.00 | $ 800.00 | $ 800.00 | $ 750.00 | |
| Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum) | $ 900.00 | $ 850.00 | $ 850.00 | $ 800.00 | |
| Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum | $ 1,500.00 | $ 1,450.00 | $ 1,450.00 | $ 1,400.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) | $ 600.00 | $ 550.00 | $ 550.00 | $ 500.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,200.00 | $ 1,150.00 | $ 1,150.00 | $ 1,100.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 | $58.41 | Average Hourly Rate | |
| Project Supervisor I | $53.10 | Average Hourly Rate | |
| Project Supervisor II | $81.75 | Average Hourly Rate | |
| Engineer I | $25.43 | Average Hourly Rate | |
| Engineer II | $45.10 | Average Hourly Rate | |
| Engineer III | $0.00 | Average Hourly Rate | |
| Hydrogeologist I | $33.12 | Average Hourly Rate | |
| Hydrogeologist II | $41.83 | Average Hourly Rate | |
| Hydrogeologist III | $0.00 | Average Hourly Rate | |
| Scientist I | $27.47 | Average Hourly Rate | |
| Scientist II | $31.79 | Average Hourly Rate | |
| Scientist III | $41.17 | Average Hourly Rate | |
| Field Technician I | $0.00 | Average Hourly Rate | |
| Field Technician II | $22.00 | Average Hourly Rate | |
| Field Technician III | $0.00 | Average Hourly Rate | |
| CADD/GIS I | $29.45 | Average Hourly Rate | |
| CADD/GIS II | $0.00 | Average Hourly Rate | |
| Accounting I | $0.00 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $27.83 | Average Hourly Rate | |
| Administrative Support II | $0.00 | Average Hourly Rate | |
| Asbestos Inspector | $34.93 | Average Hourly Rate | |
| Exterior Abatement Worker | $0.00 | Average Hourly Rate | |
| Exterior Asbestos Supervisor | $0.00 | Average Hourly Rate | |
| Asbestos Worker | $25.98 | Average Hourly Rate | |
| Asbestos Supervisor | $41.92 | Average Hourly Rate | |
| Asbestos Project Designer | $41.35 | Average Hourly Rate | |
| Asbestos Management Planner | $41.35 | 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 | 200.860% | Percentage of Direct Labor | |
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 8% | 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.) | ||||||||||||||||||||||||||||
| Terracon Consultants, Inc. | 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: | Department Manager II | Group Manager | Senior Environmental Engineer | Field Environmental Engineer | Senior Staff Environmental Engineer | eIII1 | Senior Staff Geologist | Project Geologist | hIII1 | Field Scientist | Field Geologist | Project Manager | ftI1 | Engineering Technician I | ftIII1 | Senior Cad Operator | cadII1 | accI1 | accII1 | Administrative Manager | admII1 | Group Manager | eaw1 | eas1 | Assistant Scientist | Senior Staff Scientist | Group Manager | Group Manager |
| cm2 | Project Geologist | National Director I | eI2 | eII2 | eIII2 | Senior Staff Geologist | hII2 | hIII2 | Field Scientist | Staff Scientist | Group Manager | ftI2 | ftII2 | ftIII2 | cadI2 | cadII2 | accI2 | accII2 | Administrative Staff I | admII2 | Project Manager | eaw2 | eas2 | Assistant Scientist | Senior Scientist | apd2 | amp2 | |
| cm3 | Senior Geologist | Senior Environmental Engineering Consultant | eI3 | eII3 | eIII3 | Staff Geologist | hII3 | hIII3 | Field Geologist | Staff Geologist | Project Manager | ftI3 | ftII3 | ftIII3 | cadI3 | cadII3 | accI3 | accII3 | admI3 | admII3 | Staff Scientist | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 | |
| cm4 | Senior Geologist | National Director I | eI4 | eII4 | eIII4 | hI4 | hII4 | hIII4 | sI4 | Group Manager (Part Time) | Senior Staff Scientist | ftI4 | ftII4 | ftIII4 | cadI4 | cadII4 | accI4 | accII4 | admI4 | admII4 | Senior Staff Scientist | eaw4 | eas4 | aw4 | as4 | apd4 | amp4 | |
| cm5 | Department Manager I | Department Manager I | eI5 | eII5 | eIII5 | hI5 | hII5 | hIII5 | sI5 | Field Geologist | sIII5 | ftI5 | ftII5 | ftIII5 | cadI5 | cadII5 | accI5 | accII5 | admI5 | admII5 | Project Geologist | eaw5 | eas5 | aw5 | as5 | apd5 | amp5 | |
| cm6 | Senior Environmental Engineer | psII6 | eI6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | sI6 | Staff Scientist | sIII6 | ftI6 | ftII6 | ftIII6 | cadI6 | cadII6 | accI6 | accII6 | admI6 | admII6 | Environmental Technician IV | 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 | Senior Staff Scientist | 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
| Terracon 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 | |||||||||||||||||||||
| 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 | $58.41 | Department Manager II | $ 58.41 | cm2 | cm3 | cm4 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | |||||||||
| Project Supervisor I | $53.10 | Group Manager | $ 38.08 | Project Geologist | $ 37.98 | Senior Geologist | $ 53.61 | Senior Geologist | $ 46.88 | Department Manager I | $ 60.34 | Senior Environmental Engineer | $ 81.73 | psI7 | psI8 | psI9 | psI10 | ||||
| Project Supervisor II | $81.75 | Senior Environmental Engineer | $ 68.03 | National Director I | $ 87.02 | Senior Environmental Engineering Consultant | $ 93.26 | National Director I | $ 94.09 | Department Manager I | $ 66.35 | psII6 | psII7 | psII8 | psII9 | psII10 | |||||
| Engineer I | $25.43 | Field Environmental Engineer | $ 25.43 | eI2 | eI3 | eI4 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | |||||||||
| Engineer II | $45.10 | Senior Staff Environmental Engineer | $ 45.10 | eII2 | eII3 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||||
| Engineer III | $0.00 | eIII1 | $ - 0 | eIII2 | eIII3 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | |||||||||
| Hydrogeologist I | $33.12 | Senior Staff Geologist | $ 34.62 | Senior Staff Geologist | $ 32.66 | Staff Geologist | $ 32.07 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | |||||||
| Hydrogeologist II | $41.83 | Project Geologist | $ 41.83 | hII2 | hII3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | |||||||||
| Hydrogeologist III | $0.00 | hIII1 | $ - 0 | hIII2 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||||
| Scientist I | $27.47 | Field Scientist | $ 28.08 | Field Scientist | $ 27.40 | Field Geologist | $ 26.92 | sI4 | sI5 | sI6 | sI7 | sI8 | sI9 | sI10 | |||||||
| Scientist II | $31.79 | Field Geologist | $ 26.92 | Staff Scientist | $ 28.85 | Staff Geologist | $ 32.07 | Group Manager (Part Time) | $ 43.00 | Field Geologist | $ 26.92 | Staff Scientist | $ 33.00 | sII7 | sII8 | sII9 | sII10 | ||||
| Scientist III | $41.17 | Project Manager | $ 39.09 | Group Manager | $ 40.26 | Project Manager | $ 48.56 | Senior Staff Scientist | $ 36.78 | sIII5 | sIII6 | sIII7 | sIII8 | sIII9 | sIII10 | ||||||
| Field Technician I | $0.00 | ftI1 | $ - 0 | ftI2 | ftI3 | ftI4 | ftI5 | ftI6 | ftI7 | ftI8 | ftI9 | ftI10 | |||||||||
| Field Technician II | $22.00 | Engineering Technician I | $ 22.00 | ftII2 | ftII3 | ftII4 | ftII5 | ftII6 | ftII7 | ftII8 | ftII9 | ftII10 | |||||||||
| Field Technician III | $0.00 | ftIII1 | $ - 0 | ftIII2 | ftIII3 | ftIII4 | ftIII5 | ftIII6 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | |||||||||
| CADD/GIS I | $29.45 | Senior Cad Operator | $ 29.45 | cadI2 | cadI3 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||||
| CADD/GIS II | $0.00 | cadII1 | $ - 0 | cadII2 | cadII3 | cadII4 | cadII5 | cadII6 | cadII7 | cadII8 | cadII9 | cadII10 | |||||||||
| Accounting I | $0.00 | accI1 | $ - 0 | accI2 | accI3 | accI4 | accI5 | accI6 | accI7 | accI8 | accI9 | accI10 | |||||||||
| Accounting II | $0.00 | accII1 | $ - 0 | accII2 | accII3 | accII4 | accII5 | accII6 | accII7 | accII8 | accII9 | accII10 | |||||||||
| Administrative Support I | $27.83 | Administrative Manager | $ 33.65 | Administrative Staff I | $ 22.00 | admI3 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | ||||||||
| Administrative Support II | $0.00 | admII1 | $ - 0 | admII2 | admII3 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | |||||||||
| Asbestos Inspector | $34.93 | Group Manager | $ 38.08 | Project Manager | $ 39.09 | Staff Scientist | $ 28.85 | Senior Staff Scientist | $ 31.68 | Project Geologist | $ 41.83 | Environmental Technician IV | $ 28.23 | Senior Staff Scientist | $ 36.78 | 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 | $25.98 | Assistant Scientist | $ 26.25 | Assistant Scientist | $ 25.70 | aw3 | aw4 | aw5 | aw6 | aw7 | aw8 | aw9 | aw10 | ||||||||
| Asbestos Supervisor | $41.92 | Senior Staff Scientist | $ 35.58 | Senior Scientist | $ 48.26 | as3 | as4 | as5 | as6 | as7 | as8 | as9 | as10 | ||||||||
| Asbestos Project Designer | $41.35 | Group Manager | $ 41.35 | apd2 | apd3 | apd4 | apd5 | apd6 | apd7 | apd8 | apd9 | apd10 | |||||||||
| Asbestos Management Planner | $41.35 | Group Manager | $ 41.35 | 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
| Terracon Consultants, Inc. | Fueling System Removal | |||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | ||||||||||||||
| Classification | Hourly rate | Task 1: Project Planning | Task 2: Field Work (Groundwater Sampling for Dewatering Permit) | Task 3: Field Work (Tank Removal) | Task 4: Reports | Task 5: Project Management (Quality Control) | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total | Subcontractor | Task | Total |
| Contract Manager | $58.41 | 1 | 0.5 | 1 | 1 | 1 | 4.5 | $ 262.84 | GPS | 1 | day | 50 | $ 50.00 | Earth Retention Contractor | Task 3 | $ 2,000.00 |
| Project Supervisor I | $53.10 | 0 | $ - 0 | PID | 0.5 | day | 95 | $ 47.50 | Tank Removal/Cleaner | Task 3 | $ 2,750.00 | |||||
| Project Supervisor II | $81.75 | 0 | $ - 0 | Expendables | 1 | day | 20 | $ 20.00 | Lab GW PVOC+N (1 sample) | Task 2 | $ 35.00 | |||||
| Engineer I | $25.43 | 0 | $ - 0 | $ - 0 | Lab GW PFAS (1 sample) | Task 2 | $ 285.00 | |||||||||
| Engineer II | $45.10 | 0 | $ - 0 | $ - 0 | Lab Soil PVOC+N (7 samples) | Task 3 | $ 287.00 | |||||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist I | $33.12 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist II | $41.83 | 0.5 | 1 | 1.5 | $ 62.75 | $ - 0 | $ - 0 | |||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist I | $27.47 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist II | $31.79 | 8 | 8 | $ 254.35 | $ - 0 | $ - 0 | ||||||||||
| Scientist III | $41.17 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $22.00 | 1 | 2 | 6 | 9 | $ 198.00 | $ - 0 | $ - 0 | ||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| CADD/GIS I | $29.45 | 1 | 1 | $ 29.45 | $ - 0 | $ - 0 | ||||||||||
| CADD/GIS II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Administrative Support I | $27.83 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Administrative Support II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Inspector | $34.93 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Worker | $25.98 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Supervisor | $41.92 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Project Designer | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Management Planner | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 807.39 Total Direct Expenses $ 117.50 Total Subcontracts $ 5,357.00
Tab 5 Phase 2 Site Assessment
| Terracon Consultants, Inc. | Phase 2 Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | Task 1: Project Planning | Task 2: Safety Plan | Task 3: Field Work | Task 4: Reporting | Task 5: Project Management (Quality Control) | 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 | $58.41 | 1 | 0.5 | 0.5 | 2 | $ 116.82 | GPS | 1 | day | 50 | $ 50.00 | Drilling | Task 3 | $ 2,200.00 | |||||
| Project Supervisor I | $53.10 | 1 | 1 | $ 53.10 | PID | 0.75 | day | 95 | $ 71.25 | Lab Soil VOCs (5 samples) | $ 400.00 | ||||||||
| Project Supervisor II | $81.75 | 0 | $ - 0 | Expendables | 1 | day | 20 | $ 20.00 | Lab Soil PAHs (5 samples) | $ 395.00 | |||||||||
| Engineer I | $25.43 | 0 | $ - 0 | $ - 0 | Lab Soil PCBs (5 samples) | $ 330.00 | |||||||||||||
| Engineer II | $45.10 | 0 | $ - 0 | $ - 0 | Lab Soil Metals (5 samples) | $ 440.00 | |||||||||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | Lab Groundwater VOCs (3 samples) | $ 222.00 | |||||||||||||
| Hydrogeologist I | $33.12 | 0 | $ - 0 | $ - 0 | Lab Groundwater PAHs (3 samples) | $ 237.00 | |||||||||||||
| Hydrogeologist II | $41.83 | 0.5 | 1 | 1 | 2.5 | $ 104.57 | $ - 0 | Lab Groundwater PCBs (3 samples) | $ 198.00 | ||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | Lab Groundwater Metals (3 samples) | $ 264.00 | |||||||||||||
| Scientist I | $27.47 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist II | $31.79 | 8 | 8 | $ 254.35 | $ - 0 | $ - 0 | |||||||||||||
| Scientist III | $41.17 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $22.00 | 1 | 8 | 9 | $ 198.00 | $ - 0 | $ - 0 | ||||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $29.45 | 1 | 1 | $ 29.45 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $27.83 | 0.5 | 0.5 | $ 13.91 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $25.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $41.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Total Staff Labor | $ 770.21 | Total Direct Expenses | $ 141.25 | Total Subcontracts | $ 4,686.00 |
Tab 6 Construction Dewatering
| Terracon Consultants, Inc. | Construction Dewatering | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | task 1: Project Planning | Task 2: Safety Plan | Task 3: Field Work | Task 4: Reporting | Task 5: Project Management (Quality Control) | 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 | $58.41 | 1 | 1.5 | 2.5 | $ 146.02 | GPS | 1 | day | 50 | $ 50.00 | Driller | Task 3 | $ 1,450.00 | ||||||
| Project Supervisor I | $53.10 | 0 | $ - 0 | PID | 0.5 | day | 95 | $ 47.50 | Lab Soil VOCs (1 samples) | Task 3 | $ 80.00 | ||||||||
| Project Supervisor II | $81.75 | 0 | $ - 0 | Expendables | 1 | day | 20 | $ 20.00 | Lab Soil PFAS (1 samples) | Task 3 | $ 291.00 | ||||||||
| Engineer I | $25.43 | 0 | $ - 0 | $ - 0 | Lab GW VOCs (1 samples) | Task 3 | $ 74.00 | ||||||||||||
| Engineer II | $45.10 | 1 | 1 | $ 45.10 | $ - 0 | Lab GW PFAS (1 samples) | Task 3 | $ 285.00 | |||||||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $33.12 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $41.83 | 3 | 1 | 4 | $ 167.32 | $ - 0 | $ - 0 | ||||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $27.47 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist II | $31.79 | 6 | 6 | $ 190.76 | $ - 0 | $ - 0 | |||||||||||||
| Scientist III | $41.17 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $22.00 | 1 | 1 | 4 | 6 | $ 132.00 | $ - 0 | $ - 0 | |||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $29.45 | 1 | 1 | $ 29.45 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $27.83 | 1 | 1 | $ 27.83 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $25.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $41.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 738.48 Total Direct Expenses $ 117.50 Total Subcontracts $ 2,180.00
Tab 7 Pre-Acquisition Assessmen
| Terracon Consultants, Inc. | Pre- Acquisition Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | task 1: Project Planning | Task 2: Safety Plan | Task 3: Field Work | Task 4: Reporting | Task 5: Project Management (Quality Control) | 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 | $58.41 | 1 | 3 | 4 | $ 233.64 | GPS | 3 | day | 50 | $ 150.00 | Driller | Task 3 | $ 7,000.00 | ||||||
| Project Supervisor I | $53.10 | 1 | 1 | $ 53.10 | PID | 3 | day | 95 | $ 285.00 | Lab Soil VOCs (21 samples) | Task 3 | $ 1,680.00 | |||||||
| Project Supervisor II | $81.75 | 0 | $ - 0 | Expendables | 3 | day | 20 | $ 60.00 | Lab Soil PAHs (19 samples) | Task 3 | $ 1,501.00 | ||||||||
| Engineer I | $25.43 | 0 | $ - 0 | Lodging | 2 | day | 98 | $ 196.00 | Lab Soil PCBs (10 samples) | Task 3 | $ 660.00 | ||||||||
| Engineer II | $45.10 | 0 | $ - 0 | Breakfast | 2 | day | 10 | $ 20.00 | Lab Soil Metals (17 samples) | Task 3 | $ 1,496.00 | ||||||||
| Engineer III | $0.00 | 0 | $ - 0 | Lunch | 2 | day | 12 | $ 24.00 | Lab Groundwater VOCs (6 samples) | Task 3 | $ 444.00 | ||||||||
| Hydrogeologist I | $33.12 | 0 | $ - 0 | Dinner | 2 | day | 23 | $ 46.00 | Lab Groundwater PAHs (6 samples) | Task 3 | $ 474.00 | ||||||||
| Hydrogeologist II | $41.83 | 1 | 3 | 3 | 7 | $ 292.81 | $ - 0 | Lab Groundwater PCBs (6 samples) | Task 3 | $ 396.00 | |||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | Lab Groundwater Metals (6 samples) | Task 3 | $ 528.00 | ||||||||||||
| Scientist I | $27.47 | 0 | $ - 0 | $ - 0 | Lab Groundwater Nitrogen (1 sample) | Task 3 | $ 28.00 | ||||||||||||
| Scientist II | $31.79 | 12 | 12 | $ 381.52 | $ - 0 | Lab private well Nitrate (1 sample) | Task 3 | $ 28.00 | |||||||||||
| Scientist III | $41.17 | 0 | $ - 0 | $ - 0 | Lab private well Arsenic (1 sample) | Task 3 | $ 22.00 | ||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | Lab private well Bacteria (1 sample) | Task 3 | $ 55.00 | ||||||||||||
| Field Technician II | $22.00 | 1 | 1 | 24 | 26 | $ 572.00 | $ - 0 | Lab private well VOCs (1 sample) | Task 3 | $ 80.00 | |||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $29.45 | 2 | 2 | $ 58.90 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $27.83 | 2 | 2 | $ 55.65 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Abatement Worker | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Exterior Asbestos Supervisor | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Worker | $25.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Supervisor | $41.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Project Designer | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Management Planner | $41.35 | 0 | $ - 0 | $ - 0 | $ - 0 |
Total Staff Labor $ 1,647.62 Total Direct Expenses $ 781.00 Total Subcontracts $ 14,392.00
Tab 8 Residential Lead Sampling
| Terracon Consultants, Inc. | Residential Lead Sampling | |
| Sample Type | Price per Sample | Expedited Turnaround Price per Sample |
| Paint chips | 7.6 | 16.03 |
| Bulk Lead Sampling | 9.41 | 16.03 |
| Wipe Sampling | 7.6 | 16.03 |
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 | 178154.49976192 |
| Phase 2 Site Assessment | 157 | 1150790.52999982 |
| Construction Dewatering | 25 | 117425.855056 |
| Pre-Acquisition Assessment | 46 | 944223.72537392 |
| Total Environmental Assessment COST | 2390594.61019166 |
| Residential Lead Sampling | Market basket | |
| Paint Chips | 5 | $ 38.00 |
| Bulk Lead | 100 | $ 941.00 |
| Wipe | 1250 | $ 9,500.00 |
| Paint chips expedited | 0 | $ - 0 |
| Bulk Lead expedited | 10 | $ 160.30 |
| Wipe Expedited | 3000 | $ 48,090.00 |
Total Residential Lead Sampling Cost $ 58,729.30
| Program Management Assistance | Number of Hours | Staff classification | total |
| 1040 | Admin Support 1 | $ 28,938.00 | |
| 40 | Project supervisor 2 | $ 3,270.00 | |
| 20 | Contract Manager | $ 1,168.20 | |
| 40 | CADD/GIS 2 | $ - 0 |
| Total Program Management Assistance Cost | $ 33,376.20 | ||
| Market Basket | |||
| Asbestos inspection | |||
| Normal one person | 844 | $ 717,400.00 | |
| Asbestos plus bats | |||
| confined space, two people | 35 | $ 52,500.00 | |
| Total Asbestos Inspection cost | $ 769,900.00 |
Total Cost 3252600.11019166
File details come from the government source that posted it. Updated .