RFP_510573_Attachment_D_Cost_table_Ramboll.xlsx
XLSX spreadsheet 95 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 Ramboll Americas Engineering Solutions, Inc. for a state and local contract vehicle covering various environmental assessment and inspection services. The document contains detailed pricing structures, staff classifications, hourly rates, and cost calculations across multiple service categories including asbestos inspections, environmental assessments, and related technical services.
The contract covers comprehensive environmental services with specific pricing for bridge asbestos inspections ranging from $700-$1,200 per structure depending on quantity and complexity, with confined space or two-person team requirements commanding premium rates of $950-$1,600 per structure. Additional services include fueling system removal, Phase 2 site assessments, construction dewatering, pre-acquisition assessments, and residential lead sampling. The proposal includes 27 staff classifications with hourly rates ranging from $29.90 for Administrative Support I to $84.29 for Contract Managers, plus a 174% overhead rate and 9% profit margin. The total estimated contract value across all service categories (market basket approach) is $5,233,688, which includes $1,068,800 for asbestos inspections, $4,128,451 for environmental assessments, and $36,437 for program management assistance. Direct expenses are charged at cost with no markup, and subcontractor costs are passed through without profit.
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_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 |
_x000D_&1#&"Verdana"&7&K000000 Confidential
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: | Ramboll Americas Engineering Solutions, 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) | $ 1,200.00 | $ 900.00 | $ 800.00 | $ 800.00 | |
| Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum) | $ 1,200.00 | $ 900.00 | $ 800.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,600.00 | $ 1,300.00 | $ 1,200.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) | $ 800.00 | $ 750.00 | $ 700.00 | $ 700.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,100.00 | $ 1,000.00 | $ 950.00 | $ 950.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 | $84.29 | Average Hourly Rate | |
| Project Supervisor I | $45.19 | Average Hourly Rate | |
| Project Supervisor II | $45.87 | Average Hourly Rate | |
| Engineer I | $39.90 | Average Hourly Rate | |
| Engineer II | $40.77 | Average Hourly Rate | |
| Engineer III | $56.98 | Average Hourly Rate | |
| Hydrogeologist I | $35.17 | Average Hourly Rate | |
| Hydrogeologist II | $48.80 | Average Hourly Rate | |
| Hydrogeologist III | $68.62 | Average Hourly Rate | |
| Scientist I | $35.25 | Average Hourly Rate | |
| Scientist II | $42.91 | Average Hourly Rate | |
| Scientist III | $48.92 | Average Hourly Rate | |
| Field Technician I | $0.00 | Average Hourly Rate | |
| Field Technician II | $30.68 | Average Hourly Rate | |
| Field Technician III | $43.25 | Average Hourly Rate | |
| CADD/GIS I | $35.98 | Average Hourly Rate | |
| CADD/GIS II | $45.52 | Average Hourly Rate | |
| Accounting I | $36.44 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $29.90 | Average Hourly Rate | |
| Administrative Support II | $40.75 | Average Hourly Rate | |
| Asbestos Inspector | $0.00 | 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 | 174.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 |
&G Page &P_x000D_&1#&"Verdana"&7&K000000 Confidential
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.) | ||||||||||||||||||||||||||||
| Ramboll Americas Engineering Solutions, 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: | Principal | Sr. Lead Consultant | Sr. Project Scientist | Engineer | Project Engineer | Managing Consultant | Staff Geologist | Sr. Project Hydrogeologist | Sr. Managing Consultant | Associate Consultant | Project Hydrogeologist | Sr. Project Scientist | ftI1 | Staff Geologist | Sr. Technician | Scientist | Sr. Project Scientist | Project Controller | accII1 | Sr. Administrative Professional | Sr. Administrative Professional | ai1 | eaw1 | eas1 | aw1 | as1 | apd1 | amp1 |
| Project Officer | psI2 | Sr. Lead Consultant | eI2 | eII2 | Project Manager | Geologist | Technical Manager | Sr. Technical Manager | Consultant | sII2 | Sr. Lead Consultant | ftI2 | Staff Scientist | ftIII2 | cadI2 | Sr. Lead Consultant | accI2 | accII2 | admI2 | Office Manager | ai2 | eaw2 | eas2 | aw2 | as2 | apd2 | amp2 | |
| Sr. Project Manager | psI3 | psII3 | eI3 | eII3 | eIII3 | hI3 | Sr. Lead Consultant | hIII3 | sI3 | sII3 | sIII3 | ftI3 | ftII3 | ftIII3 | cadI3 | Project Scientist | accI3 | accII3 | admI3 | admII3 | ai3 | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 | |
| cm4 | psI4 | psII4 | eI4 | eII4 | eIII4 | hI4 | hII4 | hIII4 | sI4 | sII4 | sIII4 | ftI4 | ftII4 | ftIII4 | cadI4 | Sr. Project Data Scientist | 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 |
&G Page &P
Tab 3 Average Wage Rate Calc
| Ramboll Americas Engineering Solutions, 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 | $84.29 | Principal | $ 86.54 | Project Officer | $ 91.35 | Sr. Project Manager | $ 74.98 | cm4 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | |||||||
| Project Supervisor I | $45.19 | Sr. Lead Consultant | $ 45.19 | psI2 | psI3 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | |||||||||
| Project Supervisor II | $45.87 | Sr. Project Scientist | $ 44.96 | Sr. Lead Consultant | $ 46.77 | psII3 | psII4 | psII5 | psII6 | psII7 | psII8 | psII9 | psII10 | ||||||||
| Engineer I | $39.90 | Engineer | $ 39.90 | eI2 | eI3 | eI4 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | |||||||||
| Engineer II | $40.77 | Project Engineer | $ 40.77 | eII2 | eII3 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||||
| Engineer III | $56.98 | Managing Consultant | $ 56.73 | Project Manager | $ 57.22 | eIII3 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | ||||||||
| Hydrogeologist I | $35.17 | Staff Geologist | $ 30.14 | Geologist | $ 40.19 | hI3 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | ||||||||
| Hydrogeologist II | $48.80 | Sr. Project Hydrogeologist | $ 45.61 | Technical Manager | $ 55.26 | Sr. Lead Consultant | $ 45.53 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | |||||||
| Hydrogeologist III | $68.62 | Sr. Managing Consultant | $ 72.12 | Sr. Technical Manager | $ 65.12 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | ||||||||
| Scientist I | $35.25 | Associate Consultant | $ 31.15 | Consultant | $ 39.34 | sI3 | sI4 | sI5 | sI6 | sI7 | sI8 | sI9 | sI10 | ||||||||
| Scientist II | $42.91 | Project Hydrogeologist | $ 42.91 | sII2 | sII3 | sII4 | sII5 | sII6 | sII7 | sII8 | sII9 | sII10 | |||||||||
| Scientist III | $48.92 | Sr. Project Scientist | $ 47.12 | Sr. Lead Consultant | $ 50.72 | sIII3 | sIII4 | 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 | $30.68 | Staff Geologist | $ 32.21 | Staff Scientist | $ 29.14 | ftII3 | ftII4 | ftII5 | ftII6 | ftII7 | ftII8 | ftII9 | ftII10 | ||||||||
| Field Technician III | $43.25 | Sr. Technician | $ 43.25 | ftIII2 | ftIII3 | ftIII4 | ftIII5 | ftIII6 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | |||||||||
| CADD/GIS I | $35.98 | Scientist | $ 35.98 | cadI2 | cadI3 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||||
| CADD/GIS II | $45.52 | Sr. Project Scientist | $ 44.23 | Sr. Lead Consultant | $ 47.62 | Project Scientist | Sr. Project Data Scientist | $ 44.71 | cadII5 | cadII6 | cadII7 | cadII8 | cadII9 | cadII10 | |||||||
| Accounting I | $36.44 | Project Controller | $ 36.44 | 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 | $29.90 | Sr. Administrative Professional | $ 29.90 | admI2 | admI3 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | |||||||||
| Administrative Support II | $40.75 | Sr. Administrative Professional | $ 32.69 | Office Manager | $ 48.81 | admII3 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | ||||||||
| Asbestos Inspector | $0.00 | ai1 | $ - 0 | ai2 | ai3 | 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 |
&G Page &P
Tab 4 Fueling System Removal
| Ramboll Americas Engineering Solutions, Inc. | Fueling System Removal | |||||||||||||||
| STAFF HOURS | Direct Expenses | Subcontract | ||||||||||||||
| Classification | Hourly rate | Task 1 | 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 | $84.29 | 1 | 2 | 1 | 4 | $ 337.16 | Truck | 2 | 132 | $ 264.00 | Tank remover/cleaner | 3 | $ 8,500.00 | |||
| Project Supervisor I | $45.19 | 3 | 3 | 6 | 1 | 13 | $ 587.47 | PID | 1 | 75 | $ 75.00 | Analytical laboratory | 3 | $ 1,300.00 | ||
| Project Supervisor II | $45.87 | 0 | $ - 0 | Misc Supplies | 1 | 100 | $ 100.00 | $ - 0 | ||||||||
| Engineer I | $39.90 | 0 | $ - 0 | GPS | 1 | 125 | $ 125.00 | $ - 0 | ||||||||
| Engineer II | $40.77 | 0 | $ - 0 | Lunch | 2 | 13 | $ 26.00 | $ - 0 | ||||||||
| Engineer III | $56.98 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist I | $35.17 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist II | $48.80 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Hydrogeologist III | $68.62 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist I | $35.25 | 2 | 3 | 20 | 12 | 37 | $ 1,304.07 | $ - 0 | $ - 0 | |||||||
| Scientist II | $42.91 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Scientist III | $48.92 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician II | $30.68 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Field Technician III | $43.25 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| CADD/GIS I | $35.98 | 4 | 4 | $ 143.92 | $ - 0 | $ - 0 | ||||||||||
| CADD/GIS II | $45.52 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting I | $36.44 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Administrative Support I | $29.90 | 2 | 2 | $ 59.80 | $ - 0 | $ - 0 | ||||||||||
| Administrative Support II | $40.75 | 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Asbestos Inspector | $0.00 | 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,432.42 Total Direct Expenses $ 590.00 Total Subcontracts $ 9,800.00
&G Page &P
Tab 5 Phase 2 Site Assessment
| Ramboll Americas Engineering Solutions, Inc. | 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 | $84.29 | 1 | 2 | 1 | 4 | $ 337.16 | Truck | 1 | Day | 132 | $ 132.00 | Geoprobe contractor | Soil borings, bore hole abandonments, and private locate | $ 4,000.00 | |||||
| Project Supervisor I | $45.19 | 3 | 2 | 6 | 1 | 12 | $ 542.28 | PID | 1 | Day | 75 | $ 75.00 | Traffic control contractor | Traffic control | $ 1,400.00 | ||||
| Project Supervisor II | $45.87 | 0 | $ - 0 | Miscellaneous Field Supplies | 1 | Each | 100 | $ 100.00 | Analytical Laboratory | Sample analysis | $ 5,000.00 | ||||||||
| Engineer I | $39.90 | 0 | $ - 0 | GPS Unit | 1 | Day | 125 | $ 125.00 | $ - 0 | ||||||||||
| Engineer II | $40.77 | 0 | $ - 0 | Lunch | 1 | Lunch | 13 | $ 13.00 | $ - 0 | ||||||||||
| Engineer III | $56.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $35.17 | 4 | 4 | $ 140.66 | $ - 0 | $ - 0 | |||||||||||||
| Hydrogeologist II | $48.80 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $68.62 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $35.25 | 2 | 3 | 12 | 1 | 16 | 34 | $ 1,198.33 | $ - 0 | $ - 0 | |||||||||
| Scientist II | $42.91 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $48.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $30.68 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $43.25 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $35.98 | 5 | 5 | $ 179.90 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $45.52 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $36.44 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $29.90 | 4 | 4 | $ 119.60 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support II | $40.75 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $0.00 | 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,517.93 | Total Direct Expenses | $ 445.00 | Total Subcontracts | $ 10,400.00 |
&G Page &P
Tab 6 Construction Dewatering
| Ramboll Americas Engineering Solutions, Inc. | 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 | $84.29 | 1 | 1 | $ 84.29 | Truck | 3 | day | 132 | $ 396.00 | Analytical Laboratory | Sample analysis | $ 500.00 | |||||||
| Project Supervisor I | $45.19 | 2 | 2 | 2 | 3 | 3 | 4 | 16 | $ 723.04 | PID | 3 | day | 75 | $ 225.00 | $ - 0 | ||||
| Project Supervisor II | $45.87 | 0 | $ - 0 | Miscellaneous Field Supplies | 1 | each | 100 | $ 100.00 | $ - 0 | ||||||||||
| Engineer I | $39.90 | 0 | $ - 0 | Lunch | 3 | lunch | 13 | $ 39.00 | $ - 0 | ||||||||||
| Engineer II | $40.77 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Engineer III | $56.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $35.17 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $48.80 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist III | $68.62 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $35.25 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist II | $42.91 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $48.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $30.68 | 36 | 4 | 40 | $ 1,227.00 | $ - 0 | $ - 0 | ||||||||||||
| Field Technician III | $43.25 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $35.98 | 2 | 2 | $ 71.96 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $45.52 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $36.44 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support I | $29.90 | 2 | 2 | $ 59.80 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support II | $40.75 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $0.00 | 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,166.09 Total Direct Expenses $ 760.00 Total Subcontracts $ 500.00
&G Page &P
Tab 7 Pre-Acquisition Assessmen
| Ramboll Americas Engineering Solutions, Inc. | 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 | $84.29 | 1 | 1 | $ 84.29 | Truck | 2 | Day | 132 | $ 264.00 | Geoprobe contractor | Soil borings, bore hole abandonments, and private locate | $ 6,500.00 | |||||||
| Project Supervisor I | $45.19 | 1 | 1 | 3 | 5 | $ 225.95 | PID | 2 | Day | 75 | $ 150.00 | Analytical Laboratory | Sample analysis | TBD | |||||
| Project Supervisor II | $45.87 | 0 | $ - 0 | Miscellaneous Field Supplies | 1 | Each | 100 | $ 100.00 | $ - 0 | ||||||||||
| Engineer I | $39.90 | 0 | $ - 0 | GPS Unit | 2 | Day | 125 | $ 250.00 | $ - 0 | ||||||||||
| Engineer II | $40.77 | 0 | $ - 0 | Lunch | 2 | Lunch | 13 | $ 26.00 | $ - 0 | ||||||||||
| Engineer III | $56.98 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist I | $35.17 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Hydrogeologist II | $48.80 | 1 | 4 | 2 | 1 | 2 | 10 | $ 488.00 | $ - 0 | $ - 0 | |||||||||
| Hydrogeologist III | $68.62 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist I | $35.25 | 1 | 1 | 16 | 8 | 1 | 12 | 39 | $ 1,374.56 | $ - 0 | $ - 0 | ||||||||
| Scientist II | $42.91 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Scientist III | $48.92 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician I | $0.00 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician II | $30.68 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Field Technician III | $43.25 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| CADD/GIS I | $35.98 | 6 | 6 | $ 215.88 | $ - 0 | $ - 0 | |||||||||||||
| CADD/GIS II | $45.52 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting I | $36.44 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Accounting II | $0.00 | 4 | 4 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| Administrative Support I | $29.90 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Administrative Support II | $40.75 | 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Asbestos Inspector | $0.00 | 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,388.68 Total Direct Expenses $ 790.00 Total Subcontracts $ 6,500.00
&G Page &P
Tab 8 Residential Lead Sampling
| Ramboll Americas Engineering Solutions, Inc. | Residential Lead Sampling | |
| Sample Type | Price per Sample | Expedited Turnaround Price per Sample |
| Paint chips | ||
| Bulk Lead Sampling | ||
| Wipe Sampling |
&G Page &P
_x000D_&1#&"Verdana"&7&K000000 Confidential
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 | 388402.314058 |
| Phase 2 Site Assessment | 157 | 2883312.808866 |
| Construction Dewatering | 25 | 193231.10985 |
| Pre-Acquisition Assessment | 46 | 663504.77073 |
| Total Environmental Assessment COST | 4128451.003504 |
| Residential Lead Sampling | Market basket | |
| Paint Chips | 5 | $ - 0 |
| Bulk Lead | 100 | $ - 0 |
| Wipe | 1250 | $ - 0 |
| Paint chips expedited | 0 | $ - 0 |
| Bulk Lead expedited | 10 | $ - 0 |
| Wipe Expedited | 3000 | $ - 0 |
Total Residential Lead Sampling Cost $ - 0
| Program Management Assistance | Number of Hours | Staff classification | total |
| 1040 | Admin Support 1 | $ 31,096.00 | |
| 40 | Project supervisor 2 | $ 1,834.60 | |
| 20 | Contract Manager | $ 1,685.80 | |
| 40 | CADD/GIS 2 | $ 1,820.80 |
| Total Program Management Assistance Cost | $ 36,437.20 | ||
| Market Basket | |||
| Asbestos inspection | |||
| Normal one person | 844 | $ 1,012,800.00 | |
| Asbestos plus bats | |||
| confined space, two people | 35 | $ 56,000.00 | |
| Total Asbestos Inspection cost | $ 1,068,800.00 |
Total Cost 5233688.203504
&G Page &P image1.png
File details come from the government source that posted it. Updated .