RFP_510573_Attachment_D_Cost_table_TRC.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 worksheet (RFP 510573 Attachment D) submitted by TRC Companies for environmental consulting services. The worksheet is structured as an Excel-based pricing template that includes multiple tabs for different service categories, hourly rates, classifications, and cost calculations. TRC has provided detailed pricing for various environmental assessment and inspection services, with staff classifications ranging from Contract Managers to Field Technicians, Administrative Support, and specialized roles like Asbestos Inspectors.
The contract covers a comprehensive range of environmental services including asbestos and bat inspections for bridge structures (priced from $500-$1,500 per structure depending on complexity and quantity), fueling system removal, Phase 2 site assessments, construction dewatering, pre-acquisition site assessments, and residential lead sampling. Bridge inspection services are offered on a tiered pricing structure with volume discounts, while other services are billed at hourly rates ranging from $24.36 for Administrative Support to $71.81 for Contract Managers, plus a 172.25% overhead rate and 7% profit margin. The market basket totals show significant contract values: $1.9 million for environmental assessments, $44,744 for residential lead sampling, $31,150 for program management assistance, and $601,100 for asbestos inspections, culminating in a total contract value of approximately $2.58 million. Direct expenses include standard government rates for mileage ($0.51/mile), meals, and lodging, with subcontractor costs passed through at actual cost with no markup.
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_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: | TRC | ||||
| 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) | $ 650.00 | $ 625.00 | $ 600.00 | $ 575.00 | |
| Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum) | $ 1,000.00 | $ 950.00 | $ 900.00 | $ 850.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,400.00 | $ 1,300.00 | $ 1,200.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) | $ 575.00 | $ 550.00 | $ 525.00 | $ 500.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,100.00 | $ 1,000.00 | $ 950.00 | $ 900.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 | $71.81 | Average Hourly Rate | |
| Project Supervisor I | $56.48 | Average Hourly Rate | |
| Project Supervisor II | $63.57 | Average Hourly Rate | |
| Engineer I | $35.95 | Average Hourly Rate | |
| Engineer II | $0.00 | Average Hourly Rate | |
| Engineer III | $0.00 | Average Hourly Rate | |
| Hydrogeologist I | $42.32 | Average Hourly Rate | |
| Hydrogeologist II | $50.85 | Average Hourly Rate | |
| Hydrogeologist III | $0.00 | Average Hourly Rate | |
| Scientist I | $31.73 | Average Hourly Rate | |
| Scientist II | $0.00 | Average Hourly Rate | |
| Scientist III | $0.00 | Average Hourly Rate | |
| Field Technician I | $29.39 | Average Hourly Rate | |
| Field Technician II | $0.00 | Average Hourly Rate | |
| Field Technician III | $0.00 | Average Hourly Rate | |
| CADD/GIS I | $34.66 | Average Hourly Rate | |
| CADD/GIS II | $45.93 | Average Hourly Rate | |
| Accounting I | $0.00 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $24.36 | Average Hourly Rate | |
| Administrative Support II | $34.05 | Average Hourly Rate | |
| Asbestos Inspector | $34.20 | 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 | 172.250% | Percentage of Direct Labor | |
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 7% | 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.) | ||||||||||||||||||||||||||||
| TRC | 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: | Contract Manager 1 | Project Supervisor I-1 | Project Supervisor II-1 | Engineer I-1 | ell1 | elll1 | Hydrogeologist I-1 | Hydrogeologist II-1 | hIII1 | Scientist I-1 | sII1 | sIII1 | Field Technician I-1 | ftII1 | ftIII1 | CADD/GIS I-1 | CADD/GIS II-1 | accI1 | accII1 | Administrative Support I-1 | Administrative Support II-1 | Asbestos Inspector-1 | eaw1 | eas1 | aw1 | as1 | apd1 | amp1 |
| Contract Manager 2 | Project Supervisor I-2 | Project Supervisor II-2 | Engineer I-2 | ell2 | elll2 | Hydrogeologist I-2 | Hydrogeologist II-2 | hIII2 | Scientist I-2 | sII2 | sIII2 | Field Technician I-2 | ftII2 | ftIII2 | CADD/GIS I-2 | cadII2 | accI2 | accII2 | Administrative Support I-2 | Administrative Support II-2 | Asbestos Inspector-2 | eaw2 | eas2 | aw2 | as2 | apd2 | amp2 | |
| Contract Manager 3 | Project Supervisor 1-3 | Project Supervisor II-3 | Engineer I-3 | ell3 | elll3 | Hydrogeologist I-3 | hll3 | hIII3 | Scientist I-3 | sII3 | sIII3 | Field Technician I-3 | ftII3 | ftIII3 | CADD/GIS I-3 | cadII3 | accI3 | accII3 | admI3 | Administrative Support II-3 | Asbestos Inspector-3 | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 | |
| Contract Manager 4 | psI4 | Project Supervisor II-4 | Engineer I-4 | eII4 | eIII4 | hI4 | hII4 | hIII4 | Scientist I-4 | sII4 | sIII4 | ftI4 | ftII4 | ftIII4 | cadI4 | cadII4 | accI4 | accII4 | admI4 | Administrative Support II-4 | Asbestos Inspector-4 | eaw4 | eas4 | aw4 | as4 | apd4 | amp4 | |
| cm5 | psI5 | psII5 | Engineer I-5 | eII5 | eIII5 | hI5 | hII5 | hIII5 | Scientist I-5 | sII5 | sIII5 | ftI5 | ftII5 | ftIII5 | cadI5 | cadII5 | accI5 | accII5 | admI5 | admII5 | ai5 | eaw5 | eas5 | aw5 | as5 | apd5 | amp5 | |
| cm6 | psI6 | psII6 | Engineer I-6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | Scientist I-6 | 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
| TRC | 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 | $71.81 | Contract Manager 1 | $ 69.63 | Contract Manager 2 | $ 64.46 | Contract Manager 3 | $ 66.61 | Contract Manager 4 | $ 86.54 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | ||||||
| Project Supervisor I | $56.48 | Project Supervisor I-1 | $ 53.21 | Project Supervisor I-2 | $ 57.73 | Project Supervisor 1-3 | $ 58.49 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | |||||||
| Project Supervisor II | $63.57 | Project Supervisor II-1 | $ 60.05 | Project Supervisor II-2 | $ 65.88 | Project Supervisor II-3 | $ 62.34 | Project Supervisor II-4 | $ 65.99 | psII5 | psII6 | psII7 | psII8 | psII9 | psII10 | ||||||
| Engineer I | $35.95 | Engineer I-1 | $ 35.79 | Engineer I-2 | $ 34.89 | Engineer I-3 | $ 35.98 | Engineer I-4 | $ 37.56 | Engineer I-5 | $ 34.32 | Engineer I-6 | $ 37.14 | eI7 | eI8 | eI9 | eI10 | ||||
| Engineer II | $0.00 | ell1 | $ - 0 | ell2 | ell3 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||||
| Engineer III | $0.00 | elll1 | $ - 0 | elll2 | elll3 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | |||||||||
| Hydrogeologist I | $42.32 | Hydrogeologist I-1 | $ 43.58 | Hydrogeologist I-2 | $ 43.30 | Hydrogeologist I-3 | $ 40.07 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | |||||||
| Hydrogeologist II | $50.85 | Hydrogeologist II-1 | $ 48.40 | Hydrogeologist II-2 | $ 53.30 | hll3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | ||||||||
| Hydrogeologist III | $0.00 | hIII1 | $ - 0 | hIII2 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||||
| Scientist I | $31.73 | Scientist I-1 | $ 33.68 | Scientist I-2 | $ 30.26 | Scientist I-3 | $ 32.19 | Scientist I-4 | $ 30.77 | Scientist I-5 | $ 32.70 | Scientist I-6 | $ 30.77 | sI7 | sI8 | sI9 | sI10 | ||||
| Scientist II | $0.00 | sII1 | $ - 0 | sII2 | sII3 | sII4 | sII5 | sII6 | sII7 | sII8 | sII9 | sII10 | |||||||||
| Scientist III | $0.00 | sIII1 | $ - 0 | sIII2 | sIII3 | sIII4 | sIII5 | sIII6 | sIII7 | sIII8 | sIII9 | sIII10 | |||||||||
| Field Technician I | $29.39 | Field Technician I-1 | $ 28.06 | Field Technician I-2 | $ 29.81 | Field Technician I-3 | $ 30.29 | ftI4 | ftI5 | ftI6 | ftI7 | ftI8 | ftI9 | ftI10 | |||||||
| Field Technician II | $0.00 | ftII1 | $ - 0 | 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 | $34.66 | CADD/GIS I-1 | $ 33.48 | CADD/GIS I-2 | $ 36.50 | CADD/GIS I-3 | $ 33.99 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||
| CADD/GIS II | $45.93 | CADD/GIS II-1 | $ 45.93 | 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 | $24.36 | Administrative Support I-1 | $ 26.01 | Administrative Support I-2 | $ 22.71 | admI3 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | ||||||||
| Administrative Support II | $34.05 | Administrative Support II-1 | $ 34.60 | Administrative Support II-2 | $ 32.83 | Administrative Support II-3 | $ 31.77 | Administrative Support II-4 | $ 36.99 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | ||||||
| Asbestos Inspector | $34.20 | Asbestos Inspector-1 | $ 30.26 | Asbestos Inspector-2 | $ 34.89 | Asbestos Inspector-3 | $ 28.06 | Asbestos Inspector-4 | $ 43.58 | 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
| TRC | Fueling System Removal | |||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | ||||||||||||||
| Classification | Hourly rate | Task1 | Task 2 | Task 3 | Task 4 | Task 5 | Total Hours | Total cost | Item | Quantity | Unit or rate | Rate or Unit Cost | Total | Subcontractor | Task | Total |
| Contract Manager | $71.81 | 0.5 | 0.5 | $ 35.91 | Meals - Lunch | 1 | Each | 12 | $ 12.00 | Laboratory | 11 PVOCs + naphthalene | $ 473.00 | ||||
| Project Supervisor I | $56.48 | 1 | 0.5 | 1 | 1.5 | 4 | $ 225.91 | Mileage | 50 | Mile | 0.51 | $ 25.50 | Tank Remover/Cleaner | fueling system removal | $ 8,500.00 | |
| Project Supervisor II | $63.57 | 0 | $ - 0 | Misc. Field Supplies | 1 | Each | 25 | $ 25.00 | $ - 0 | |||||||
| Engineer I | $35.95 | 1 | 1 | 2 | $ 71.89 | PID | 1 | Day | 110 | $ 110.00 | $ - 0 | |||||
| Engineer II | $0.00 | 0 | $ - 0 | GPS | 1 | Day | 150 | $ 150.00 | $ - 0 | |||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist I | $42.32 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist II | $50.85 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist I | $31.73 | 4 | 1 | 10 | 8 | 23 | $ 729.75 | $ - 0 | $ - 0 | |||||||
| Scientist II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician I | $29.39 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| CADD/GIS I | $34.66 | 4 | 4 | $ 138.63 | $ - 0 | $ - 0 | ||||||||||
| CADD/GIS II | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Administrative Support I | $24.36 | 1 | 0.5 | 4 | 2 | 7.5 | $ 182.70 | $ - 0 | $ - 0 | |||||||
| Administrative Support II | $34.05 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Inspector | $34.20 | 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,384.78 Total Direct Expenses $ 322.50 Total Subcontracts $ 8,973.00
Tab 5 Phase 2 Site Assessment
| TRC | Phase 2 Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | Task 1 | Task 2 | Task 3 | 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 | $71.81 | 1 | 1 | $ 71.81 | Meals - Lunch | 1 | Each | 12 | $ 12.00 | Laboratory | 5 VOCs, 3 PCBs, 5 metals, 3 PAHs | $ 1,185.75 | |||||||
| Project Supervisor I | $56.48 | 0.5 | 0.5 | 1 | 2 | 4 | $ 225.91 | Mileage | 50 | Mile | 0.51 | $ 25.50 | Geoprobe Subcontractor | 3 soil borings and 2 temp wells | $ 1,405.00 | ||||
| Project Supervisor II | $63.57 | 0 | $ - 0 | Misc. Field Supplies | 1 | Each | 25 | $ 25.00 | $ - 0 | ||||||||||
| Engineer I | $35.95 | 0 | $ - 0 | PID | 1 | Day | 110 | $ 110.00 | $ - 0 | ||||||||||
| Engineer II | $0.00 | 0 | $ - 0 | Misc. Field Equipment | 1 | Each | 100 | $ 100.00 | $ - 0 | ||||||||||
| Engineer III | $0.00 | 0 | $ - 0 | GPS | 1 | Day | 150 | $ 150.00 | $ - 0 | ||||||||||
| Hydrogeologist I | $42.32 | 1 | 1 | 1 | 3 | $ 126.95 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist II | $50.85 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $31.73 | 1 | 8 | 9 | $ 285.56 | $ - 0 | $ - 0 | ||||||||||||
| Scientist II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $29.39 | 4 | 2 | 1 | 10 | 1 | 1 | 19 | $ 558.35 | $ - 0 | $ - 0 | ||||||||
| Field Technician II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $34.66 | 3 | 3 | $ 103.97 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.36 | 1 | 1 | 1 | 4 | 2 | 9 | $ 219.24 | $ - 0 | $ - 0 | |||||||||
| Administrative Support II | $34.05 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.20 | 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,591.78 | Total Direct Expenses | $ 422.50 | Total Subcontracts | $ 2,590.75 |
Tab 6 Construction Dewatering
| TRC | Construction Dewatering | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | task 1 | Task 2 | Task 3 | 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 | $71.81 | 1 | 1 | $ 71.81 | Meals - Lunch | 2 | Each | 12 | $ 24.00 | Laboratory | 2 VOCs, 2 PFAS, 1 TCLP | $ 1,202.00 | |||||||
| Project Supervisor I | $56.48 | 1 | 0.5 | 0.5 | 1 | 2 | 5 | $ 282.38 | Mileage | 100 | Mile | 0.51 | $ 51.00 | $ - 0 | |||||
| Project Supervisor II | $63.57 | 0 | $ - 0 | Misc. Field Supplies | 1 | Each | 50 | $ 50.00 | $ - 0 | ||||||||||
| Engineer I | $35.95 | 2 | 2 | $ 71.89 | PID | 2 | Day | 110 | $ 220.00 | $ - 0 | |||||||||
| Engineer II | $0.00 | 0 | $ - 0 | GPS | 1 | Day | 150 | $ 150.00 | $ - 0 | ||||||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $42.32 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $50.85 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $31.73 | 4 | 1 | 4 | 20 | 4 | 10 | 43 | $ 1,364.32 | $ - 0 | $ - 0 | ||||||||
| Scientist II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $29.39 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $34.66 | 1 | 3 | 4 | $ 138.63 | $ - 0 | $ - 0 | ||||||||||||
| CADD/GIS II | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.36 | 1 | 0.5 | 1 | 0.5 | 4 | 2 | 9 | $ 219.24 | $ - 0 | $ - 0 | ||||||||
| Administrative Support II | $34.05 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.20 | 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 $ 2,148.27 Total Direct Expenses $ 495.00 Total Subcontracts $ 1,202.00
Tab 7 Pre-Acquisition Assessmen
| TRC | Pre- Acquisition Site Assessment | ||||||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | |||||||||||||||||
| Classification | Hourly rate | task 1 | Task 2 | Task 3 | 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 | $71.81 | 1 | 1 | $ 71.81 | Meals - Lunch | 1 | Each | 12 | $ 12.00 | $ - 0 | |||||||||
| Project Supervisor I | $56.48 | 1 | 0.5 | 2 | 2 | 5.5 | $ 310.62 | Mileage | 50 | Mile | 0.51 | $ 25.50 | $ - 0 | ||||||
| Project Supervisor II | $63.57 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Engineer I | $35.95 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Engineer II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Engineer III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $42.32 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $50.85 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $31.73 | 1 | 1 | 6 | 20 | 28 | $ 888.39 | $ - 0 | $ - 0 | ||||||||||
| Scientist II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $29.39 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $34.66 | 4 | 4 | $ 138.63 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $45.93 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $24.36 | 1 | 0.5 | 2 | 2 | 5.5 | $ 133.98 | $ - 0 | $ - 0 | ||||||||||
| Administrative Support II | $34.05 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $34.20 | 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,543.43 Total Direct Expenses $ 37.50 Total Subcontracts $ - 0
Tab 8 Residential Lead Sampling
| TRC | Residential Lead Sampling | |
| Sample Type | Price per Sample | Expedited Turnaround Price per Sample |
| Paint chips | 10 | 10.6 |
| Bulk Lead Sampling | 10 | 10.6 |
| Wipe Sampling | 9.55 | 10.55 |
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 | 293248.5095925 |
| Phase 2 Site Assessment | 157 | 1201084.48793488 |
| Construction Dewatering | 25 | 198876.912134375 |
| Pre-Acquisition Assessment | 46 | 208547.08130925 |
| Total Environmental Assessment COST | 1901756.990971 |
| Residential Lead Sampling | Market basket | |
| Paint Chips | 5 | $ 50.00 |
| Bulk Lead | 100 | $ 1,000.00 |
| Wipe | 1250 | $ 11,937.50 |
| Paint chips expedited | 0 | $ - 0 |
| Bulk Lead expedited | 10 | $ 106.00 |
| Wipe Expedited | 3000 | $ 31,650.00 |
Total Residential Lead Sampling Cost $ 44,743.50
| Program Management Assistance | Number of Hours | Staff classification | total |
| 1040 | Admin Support 1 | $ 25,334.40 | |
| 40 | Project supervisor 2 | $ 2,542.60 | |
| 20 | Contract Manager | $ 1,436.20 | |
| 40 | CADD/GIS 2 | $ 1,837.20 |
| Total Program Management Assistance Cost | $ 31,150.40 | ||
| Market Basket | |||
| Asbestos inspection | |||
| Normal one person | 844 | $ 548,600.00 | |
| Asbestos plus bats | |||
| confined space, two people | 35 | $ 52,500.00 | |
| Total Asbestos Inspection cost | $ 601,100.00 |
Total Cost 2578750.890971
File details come from the government source that posted it. Updated .