Cost Sheet- OBrien.xlsx
XLSX spreadsheet 85 KB Posted
- Attached to
- Ecological, Hazmat and Asbestos Services
- Contract number
- 395002-O20-0510292-000-
- Issued by
- Wisconsin
About this file
This document is a cost worksheet proposal from Ramboll for a Wisconsin state contract vehicle covering environmental and hazardous materials services. The cost sheet serves as Attachment 16 - 7.1 Cost Worksheets and includes detailed pricing structures for asbestos inspections, hazardous materials site investigations, ecological services, and program management assistance. Ramboll has proposed overhead rates of 163% and profit margins of 9% on labor and overhead, with no profit markup on subcontractors or direct expenses.
The contract covers comprehensive environmental services with tiered pricing for asbestos inspections ranging from $600-$1,000 per bridge structure based on quantity, and detailed cost scenarios for hazardous materials investigations including Phase 1, Phase 2, Phase 2.5, Phase 3, and Phase 4 assessments with total costs ranging from $7,349 to $22,582 per scenario. Hourly rates are established for 16 different staff classifications from Contract Manager ($60.46/hour) to Field Technician ($24.79/hour), with standardized reimbursement rates for mileage ($0.51/mile), meals ($8-$20), and lodging ($70-$80/night). The total proposal value is $3,333,151.47, encompassing a market basket approach based on five-year statewide averages including $248,500 for asbestos inspections, $2,997,993 for hazmat site investigations, $86,659 for program management assistance, and provisions for ecological services with quantities determined by historical demand patterns.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| AECOM-2021 Renewal Cost Table_ REVISED Team.xlsx | XLSX spreadsheet | |
| GEI- Renewal Cost Table_GEI_2021.xlsx | XLSX spreadsheet | |
| TRC_2021-2022 Renewal Cost Table.xlsx | XLSX spreadsheet | |
| REVISED_Ecological_Haz_Mat_Asbestos_RFP510292.docx | DOCX document | |
| Contract and Vendor information 2020 -2024 contracts for piggybacking request.docx | DOCX document | |
| Ramboll Contract 2022 510292 Renewal Package.pdf | ||
| Stantec2021 Renewal Cost Table_ REVISED.pdf | ||
| REL Renewal Cost Table- 2021.pdf | ||
| GEI- ECO- Renewal Cost Table_2021.xlsx | XLSX spreadsheet | |
| Bay West- 2022 Renewal Cost Table.xlsx | XLSX spreadsheet | |
| Haz Mat 2020 -2024 contracts for piggybacking.docx | DOCX document |
Show all 11
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| ATTACHMENT 16 - 7.1 Cost Worksheets | |
| INSTRUCTIONS | |
| 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 structure | B5, C5, D5, E5 |
| 3. Fill in proposed overhead rate | B41 |
| 4. Fill in proposed profit percentage as a whole number, field is formatted as a percentage | B44 |
| Tab 2 Classifications in titles | Cell # |
| 1. Please fit each of your current employee classifications into one of the sixteen contract Rate titles | B4 through Q13 |
| 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 | D4-19, F4-19, H 4-19, J 4-19, l 4-19, N 4-19, P 4-19, R 4-19, T 4-19, V 4-19 |
| 2. Put a zero in any blank cell in column D (Hourly Rate 1) | |
| 3. Leave all other unused cells blank | |
| Tab 4 Ecological Services Cost | Cell # |
| 1. For each scenario in Section 6.1 provide a cost estimate. | B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19, AK4-19, AU4-19, AZ4-19 |
| 2. Enter the total number of hours for each rate title used for each scenario | |
| 3. Leave unused cells blank |
| Tab 5 Hazmat Cost | Cell # |
| 1. For each scenario in Section 6.2 provide a cost estimate. | B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19 |
| 2. Enter the total number of hours for each rate title used for each scenario | |
| 3. Leave unused cells blank |
| Tab 6 Direct Expense Calc | Cell # |
| 1. Enter the direct expenses for each scenario in Tab 4 and Tab 5 | Tab 4 G6 through BR 27 and Tab 5 G35 through AT56 |
| 2. Do not include mileage, meals or lodging in your expenses | |
| 3. Leave unused cells blank |
| Tab 7 Subcontract Calculations | Cell # |
| 1. Enter the subcontract expenses for each scenario in Tab 4 and Tab 5 | Tab 4 E6 through AU 24 and Tab 5 E33 through AE 51 |
| 2. Leave unused cells blank |
| Tab 8 Cost Total | Cell # |
| There is nothing to enter under this tab. This is the calculation of the proposal cost total. | NONE |
Tab 1 Hourly Rates and Costs
| ATTACHMENT 16 - 7.1 Cost Worksheets | Fill in only those cells highlighted in blue. Cells in green are calculated. | |||
| FIRM NAME: | Ramboll | |||
| 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 | $ 1,000.00 | $ 750.00 | $ 650.00 | $ 600.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 | $ 60.46 | Average Hourly Rate | ||
| Project Supervisor | $ 42.51 | Average Hourly Rate | ||
| Engineer | $ 36.82 | Average Hourly Rate | * | |
| Hydrogeologist | $ 36.20 | Average Hourly Rate | ||
| Scientist | $ 33.72 | Average Hourly Rate | ||
| Field Technician | $ 24.79 | Average Hourly Rate | ||
| CADD, GIS | $ 35.18 | Average Hourly Rate | ||
| Accounting | $ 25.06 | Average Hourly Rate | ||
| Administrative Support | $ 27.66 | Average Hourly Rate | ||
| Asbestos Inspector | $ 32.48 | Average Hourly Rate | ||
| Exterior Abatement Worker | 0 | Average Hourly Rate | ||
| Exterior Asbestos Supervisor | 0 | Average Hourly Rate | ||
| Asbestos Worker | 0 | Average Hourly Rate | ||
| Asbestos Supervisor | 0 | Average Hourly Rate | ||
| Asbestos Project Designer | 0 | Average Hourly Rate | ||
| Asbestos Management Planner | 0 | 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 | $ 8.00 | |||
| Lunch | $ 10.00 | |||
| Dinner | $ 20.00 | |||
| Lodging | Terms: current state reimbursement rate, excluding taxes | |||
| Per night | $70.00 | |||
| Per night, Milwaukee, Racine and Kenosha counties | $80.00 | |||
| Overhead rate | Terms: Percentage of Direct Labor | |||
| Proposed rate | 163% | Percentage of Direct Labor | ||
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | |||
| Proposed Rate | 9.00% | 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.) | ||||||||||||||||
| Ramboll | Please fill in the actual titles of your staff. Limit 10 titles per classification | |||||||||||||||
| Rate Title: | Contract Manager | Project Supervisor | Engineer | Hydrogeologist | Scientist | Field Technician | CADD/GIS | Accounting | Administrative Support | Asbestos Inspector | Exterior Abatement Worker | Exterior Asbestos Supervisor | Asbestos Worker | Asbestos Supervisor | Asbestos Project Designer | Asbestos Management Planner |
| Classifications included in Rate Titles: | Principal | Project Manager 1 | Engineer 3 | Scientist 3 | Scientist 3 | Consultant 2 | Business Professional 3 | Project Controls 2 | Admin Assistant 3 | Scientist 2 | eaw1 | eas1 | aw1 | as1 | apd1 | amp1 |
| Project Manager 2 | Managing Consultant | Sr Consultant 2 | Scientist 2 | Sr Consultant 2 | Scientist 1 | Scientist 3 | Project Accountant 3 | Admin Assistant 1 | ai2 | eaw2 | eas2 | aw2 | as2 | apd2 | amp2 | |
| EXAMPLE: | Technical Manager 1 | Scientist 3 | Engineer 2 | h3 | Scientist 2 | Field Technician 1 | Business Professional 1 | Project Controls 1 | adm3 | ai3 | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 |
| Rate Title: Scientist | Division Manager 1 | Engineer 3 | Engineer 1 | h4 | Consultant 3 | ft4 | Scientist 2 | Project Accountant 2 | adm4 | ai4 | eaw4 | eas4 | aw4 | as4 | apd4 | amp4 |
| Classifications included in title: Staff scientist 1 | Engineer 3 | Sr Consultant 2 | e5 | h5 | Scientist 1 | ft5 | cad5 | Project Accountant 1 | adm5 | ai5 | eaw5 | eas5 | aw5 | as5 | apd5 | amp5 |
| Staff scientist 2 | cm6 | Scientist 2 | e6 | h6 | s6 | ft6 | cad6 | acc6 | adm6 | ai6 | eaw6 | eas6 | aw6 | as6 | apd6 | amp6 |
| Arborist | cm7 | Scientist 1 | e7 | h7 | s7 | ft7 | cad7 | acc7 | adm7 | ai7 | eaw7 | eas7 | aw7 | as7 | apd7 | amp7 |
| Geologist 1 | cm8 | ps8 | e8 | h8 | s8 | ft8 | cad8 | acc8 | adm8 | ai8 | eaw8 | eas8 | aw8 | as8 | apd8 | amp8 |
| Geologist 2 | cm9 | ps9 | e9 | h9 | s9 | ft9 | cad9 | acc9 | adm9 | ai9 | eaw9 | eas9 | aw9 | as9 | apd9 | amp9 |
| Senior Project Technical | cm10 | ps10 | e10 | h10 | s10 | ft10 | cad10 | acc10 | adm10 | ai10 | eaw10 | eas10 | aw10 | as10 | apd10 | amp10 |
| 0 |
Tab 3 Average Wage Rate Calc
| Ramboll | 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 | $60.46 | Principal | $ 76.92 | Project Manager 2 | $ 65.11 | Technical Manager 1 | $ 60.92 | Division Manager 1 | $ 55.62 | Engineer 3 | $ 43.75 | cm6 | cm7 | cm8 | cm9 | cm10 | |||||
| Project Supervisor | $42.51 | Project Manager 1 | $ 61.60 | Managing Consultant | $ 47.96 | Scientist 3 | $ 46.19 | Engineer 3 | $ 43.75 | Sr Consultant 2 | $ 38.10 | Scientist 2 | $ 33.54 | Scientist 1 | $ 26.45 | ps8 | ps9 | ps10 | |||
| Engineer | $36.82 | Engineer 3 | $ 42.07 | Sr Consultant 2 | $ 39.18 | Engineer 2 | $ 37.03 | Engineer 1 | $ 29.01 | e5 | e6 | e7 | e8 | e9 | e10 | ||||||
| Hydrogeologist | $36.20 | Scientist 3 | $ 40.65 | Scientist 2 | $ 31.75 | h3 | h4 | h5 | h6 | h7 | h8 | h9 | h10 | ||||||||
| Scientist | $33.72 | Scientist 3 | $ 41.02 | Sr Consultant 2 | $ 37.02 | Scientist 2 | $ 31.98 | Consultant 3 | $ 30.73 | Scientist 1 | $ 27.87 | s6 | s7 | s8 | s9 | s10 | |||||
| Field Technician | $24.79 | Consultant 2 | $ 28.36 | Scientist 1 | $ 25.04 | Field Technician 1 | $ 20.98 | ft4 | ft5 | ft6 | ft7 | ft8 | ft9 | ft10 | |||||||
| CADD/GIS | $35.18 | Business Professional 3 | $ 42.85 | Scientist 3 | $ 36.80 | Business Professional 1 | $ 30.58 | Scientist 2 | $ 30.50 | cad5 | cad6 | cad7 | cad8 | cad9 | cad10 | ||||||
| Accounting | $25.06 | Project Controls 2 | $ 35.03 | Project Accountant 3 | $ 25.94 | Project Controls 1 | $ 25.55 | Project Accountant 2 | $ 21.74 | Project Accountant 1 | $ 17.05 | acc6 | acc7 | acc8 | acc9 | acc10 | |||||
| Administrative Support | $27.66 | Admin Assistant 3 | $ 28.59 | Admin Assistant 1 | $ 26.72 | adm3 | adm4 | adm5 | adm6 | adm7 | adm8 | adm9 | adm10 | ||||||||
| Asbestos Inspector | $32.48 | Scientist 2 | $ 32.48 | 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 | $17.52 | Staff Scientist 1 | $ 12.35 | Staff Scientist 2 | $ 13.50 | Staff Scientist 3 | $ 14.75 | Geologist 1 | $ 17.50 | Geologist 2 | $ 23.50 | Senior Project Technical | $ 23.50 |
Tab 4 Ecolocgical Services Cost
| Enter the number of hours per Rate Title. Total Subcontract and Direct Expenses are entered in Tab 5 and Tab 6 | |||||||||||||||||||||||||||||||||||||||||||
| Fill in only those cells highlighted in blue. Cells in green are calculated. | |||||||||||||||||||||||||||||||||||||||||||
| 6.1.1 Wetland Delineation | Total number of hours | Rate | Extended Cost | 6.1.2 Wetland Mitigation Site Monitoring | Total number of hours | Rate | Extended Cost | 6.1.3 Rare Species Survey | Total number of hours | Rate | Extended Cost | 6.1.4 Vegetation Management - Wetland Mitigation Site | Total number of hours | Rate | Extended Cost | 6.1.5 Invasive Species Management - Roadside | Total number of hours | Rate | Extended Cost | 6.1.6 Remnant Prairie Management - Roadside | Total number of hours | Rate | Extended Cost | 6.1.7 Hazard Tree Assessment | Total number of hours | Rate | Extended Cost | 6.1.8 Functional Planting - Large project | Total number of hours | Rate | Extended Cost | 6.1.9 Functional Planting - Small Project | Total number of hours | Rate | Extended Cost | 6.1.10 Functional Planting - Care Cycles | Total number of hours | Rate | Extended Cost | 6.1.11 Roadside Facilities Functional Planting | Total number of hours | Rate | Extended Cost |
| Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | Contract Manager | $ 60.46 | $ - 0 | |||||||||||
| Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | Project Supervisor | $ 42.51 | $ - 0 | |||||||||||
| Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | |||||||||||
| Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | |||||||||||
| Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | Scientist | $ 33.72 | $ - 0 | |||||||||||
| Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | |||||||||||
| CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | CADD, GIS | $ 35.18 | $ - 0 | |||||||||||
| Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | Accounting | $ 25.06 | $ - 0 | |||||||||||
| Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | Administrative Support | $ 27.66 | $ - 0 | |||||||||||
| Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | |||||||||||
| Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | |||||||||||
| Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | |||||||||||
| Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | |||||||||||
| Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | |||||||||||
| Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | |||||||||||
| Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | |||||||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | ||||||||||||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | ||||||||||||||||||||||
| Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | Overhead | $ - 0 | ||||||||||||||||||||||
| Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | Profit | $ - 0 | ||||||||||||||||||||||
| Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 | Total Cost | $ - 0 |
Tab 5 Hazmat Costs
| Enter the number of hours per Rate Title and Total Subcontract and Direct Expenses | Ramboll | ||||||||||||||||||||||||||
| Fill in only those cells highlighted in blue. Cells in green are calculated. | |||||||||||||||||||||||||||
| 6.2.1 Construction Emergency | Total number of hours | Rate | Total Cost | 6.2.2 Construction Emergency | Total number of hours | Rate | Total Cost | 6.2.3 Phase 1 | Total number of hours | Rate | Total Cost | 6.2.3 Phase 2 | Total number of hours | Rate | Total Cost | 6.2.4 Phase 2.5 | Total number of hours | Rate | Total Cost | 6.2.5 Phase 4 | Total number of hours | Rate | Total Cost | 6.2.6 Phase 3 | Total number of hours | Rate | Total Cost |
| Contract Manager | 1 | $ 60.46 | $ 60.46 | Contract Manager | 1 | $ 60.46 | $ 60.46 | Contract Manager | 1 | $ 60.46 | $ 60.46 | Contract Manager | 1 | $ 60.46 | $ 60.46 | Contract Manager | 1 | $ 60.46 | $ 60.46 | Contract Manager | 2 | $ 60.46 | $ 120.93 | Contract Manager | 1 | $ 60.46 | $ 60.46 |
| Project Supervisor | 4 | $ 42.51 | $ 170.05 | Project Supervisor | 6 | $ 42.51 | $ 255.08 | Project Supervisor | 6 | $ 42.51 | $ 255.08 | Project Supervisor | 6 | $ 42.51 | $ 255.08 | Project Supervisor | 6 | $ 42.51 | $ 255.08 | Project Supervisor | 9 | $ 42.51 | $ 382.62 | Project Supervisor | 6 | $ 42.51 | $ 255.08 |
| Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | Engineer | $ 36.82 | $ - 0 | |||||||
| Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | 8 | $ 36.20 | $ 289.60 | Hydrogeologist | 18 | $ 36.20 | $ 651.60 | Hydrogeologist | 15 | $ 36.20 | $ 543.00 | Hydrogeologist | $ 36.20 | $ - 0 | Hydrogeologist | 15 | $ 36.20 | $ 543.00 | |||
| Scientist | 14 | $ 33.72 | $ 472.14 | Scientist | 15 | $ 33.72 | $ 505.86 | Scientist | 46 | $ 33.72 | $ 1,551.30 | Scientist | 60 | $ 33.72 | $ 2,023.44 | Scientist | 62 | $ 33.72 | $ 2,090.89 | Scientist | 15 | $ 33.72 | $ 505.86 | Scientist | 51 | $ 33.72 | $ 1,719.92 |
| Field Technician | 22 | $ 24.79 | $ 545.45 | Field Technician | 22 | $ 24.79 | $ 545.45 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | $ 24.79 | $ - 0 | Field Technician | 60 | $ 24.79 | $ 1,487.60 | Field Technician | $ 24.79 | $ - 0 | ||||
| CADD, GIS | 4 | $ 35.18 | $ 140.73 | CADD, GIS | 4 | $ 35.18 | $ 140.73 | CADD, GIS | 4 | $ 35.18 | $ 140.73 | CADD, GIS | 6 | $ 35.18 | $ 211.10 | CADD, GIS | 6 | $ 35.18 | $ 211.10 | CADD, GIS | 5 | $ 35.18 | $ 175.91 | CADD, GIS | 6 | $ 35.18 | $ 211.10 |
| Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 | Accounting | 1 | $ 25.06 | $ 25.06 |
| Administrative Support | 2 | $ 27.66 | $ 55.31 | Administrative Support | 2 | $ 27.66 | $ 55.31 | Administrative Support | 4 | $ 27.66 | $ 110.62 | Administrative Support | 4 | $ 27.66 | $ 110.62 | Administrative Support | 4 | $ 27.66 | $ 110.62 | Administrative Support | 4 | $ 27.66 | $ 110.62 | Administrative Support | 4 | $ 27.66 | $ 110.62 |
| Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | Asbestos Inspector | $ 32.48 | $ - 0 | |||||||
| Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | Exterior Abatement Worker | $ - 0 | $ - 0 | |||||||
| Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | Exterior Asbestos Supervisor | $ - 0 | $ - 0 | |||||||
| Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | Asbestos Worker | $ - 0 | $ - 0 | |||||||
| Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | Asbestos Supervisor | $ - 0 | $ - 0 | |||||||
| Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | Asbestos Project Designer | $ - 0 | $ - 0 | |||||||
| Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | Asbestos Management Planner | $ - 0 | $ - 0 | |||||||
| Direct Expenses | $ 200.00 | Direct Expenses | $ 200.00 | Direct Expenses | $ 100.00 | Direct Expenses | $ 400.00 | Direct Expenses | $ 475.00 | Direct Expenses | $ 550.00 | Direct Expenses | $ 375.00 | ||||||||||||||
| Subcontract | $ 4,048.00 | Subcontract | $ 4,048.00 | Subcontract | $ 275.00 | Subcontract | $ 12,615.00 | Subcontract | $ 12,180.00 | Subcontract | $ 5,183.20 | Subcontract | $ 7,560.00 | ||||||||||||||
| Overhead | $ 2,394.81 | Overhead | $ 2,588.37 | Overhead | $ 3,965.56 | Overhead | $ 5,439.89 | Overhead | $ 5,372.82 | Overhead | $ 4,578.02 | Overhead | $ 4,768.14 | ||||||||||||||
| Profit | $ 347.76 | Profit | $ 375.87 | Profit | $ 575.86 | Profit | $ 789.95 | Profit | $ 780.21 | Profit | $ 664.80 | Profit | $ 692.40 | ||||||||||||||
| Total Cost 6.2.1 Construction Emergency | $ 8,459.78 | Total Cost 6.2.2 Construction Emergency | $ 8,800.19 | Total Cost 6.2.3 Phase 1 | $ 7,349.27 | Total Cost 6.2.3 Phase 2 | $ 22,582.20 | Total Cost 6.2.4 Phase 2.5 | $ 22,104.23 | Total Cost 6.2.5 Phase 4 | $ 13,784.61 | Total Cost 6.2.6 Phase 3 | $ 16,320.79 |
Tab 6 Direct Expense Calc
| List each direct expense item individually, include quantity and unit or rate. Do not include mileage, lodging, or per diems. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Fill in only those cells highlighted in blue. Cells in green are calculated. | Ramboll | ||||||||||||||||||||||||||||||||||||||||||||||||
| Example | Section 6.1 Expenses (Tab 4) | ||||||||||||||||||||||||||||||||||||||||||||||||
| Item | Quantity | Unit or Rate | Unit Cost | Total | 6.1.1 Wetland Delineation | 6.1.2 Wetland Mitigation Site Monitoring | 6.1.3 Rare Species Survey | 6.1.4 Vegetation Management - Wetland Mitigation Site | 6.1.5 Invasive Species Management - Roadside | 6.1.6 Remnant Prairie Management - Roadside | 6.1.7 Hazard Tree Assessment | 6.1.8 Functional Planting - Large project | 6.1.9 Functional Planting - Small Project | ||||||||||||||||||||||||||||||||||||
| Photo Copies | 250 | per page | $ 0.15 | $ 37.50 | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total |
| PID Rental | 4 | per day | $ 125.00 | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Sample Jars | 75 | each | $ 3.45 | $ 258.75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Test Blank | 4 | each | $ 7.00 | $ 28.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Trip Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Dry ice | 6 | per pound | $ 5.75 | $ 34.50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Cooler | 2 | each | $ 12.50 | $ 25.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Method Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| Postage | 1 | package | $ 6.75 | $ 6.75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||||||||||||||
| Total Expenses | $ 918.50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||||||||||||||||||||||||||||
| Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 |
| SECTION 6.2 Expenses (Tab 5) | ||||||||||||||||||||||||||||||||||
| 6.2.1 Construction Emergency Expenses | 6.2.2 Construction Emergency Expenses | 6.2.3 Phase 1 Expenses | 6.2.3 Phase 2 Expenses | 6.2.4 Phase 2.5 Expenses | 6.2.5 Phase 4 Expenses | 6.2.6 Phase 3 Expenses | ||||||||||||||||||||||||||||
| Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total | Item | Quantity | Unit or Rate | Unit Cost | Total |
| GPS Unit | 1 | day | $ 125.00 | $ 125.00 | GPS Unit | 1 | day | $ 125.00 | $ 125.00 | Copies | 1 | each | $ 100.00 | $ 100.00 | GPS Unit | 1 | day | $ 125.00 | $ 125.00 | GPS Unit | 1 | day | $ 125.00 | $ 125.00 | PID | 5 | day | $ 75.00 | $ 375.00 | PID | 2 | day | $ 75.00 | $ 150.00 |
| PID | 1 | day | $ 75.00 | $ 75.00 | PID | 1 | day | $ 75.00 | $ 75.00 | $ - 0 | PID | 3 | day | $ 75.00 | $ 225.00 | PID | 3 | day | $ 75.00 | $ 225.00 | Misc. Field Supplies (gloves, etc.) | 1 | each | $ 50.00 | $ 50.00 | Misc. Field Supplies (gloves, etc.) | 1 | each | $ 100.00 | $ 100.00 | ||||
| $ - 0 | $ - 0 | $ - 0 | Misc. Field Supplies (buckets and filter) | 1 | each | $ 50.00 | $ 50.00 | Misc. Field Supplies (buckets) | 1 | each | $ 50.00 | $ 50.00 | GPS Unit | 1 | day | $ 125.00 | $ 125.00 | GPS Unit | 1 | day | $ 125.00 | $ 125.00 | ||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | Contingency - PID | 1 | day | $ 75.00 | $ 75.00 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| Total Expenses | $ 200.00 | Total Expenses | $ 200.00 | Total Expenses | $ 100.00 | Total Expenses | $ 400.00 | Total Expenses | $ 475.00 | Total Expenses | $ 550.00 | Total Expenses | $ 375.00 |
Tab 7 Subcontract Calculations
| List each Subcontracted item individually, include quantity and unit or rate. Do not include mileage, lodging, or per diems. | |||||||||||||||||||||||||||||||||||
| Fill in only those cells highlighted in blue. Cells in green are calculated. | Ramboll | ||||||||||||||||||||||||||||||||||
| Example | SECTION 6.1 SUBCONTRACTS (TAB 4) | ||||||||||||||||||||||||||||||||||
| Subcontractor | Task | Total | 6.1.1 wetland Delineation Subcontract | 6.1.2 Wetland Mitigation Site Monitoring | 6.1.3 Rare Species Survey | 6.1.4 Vegetation Management - Wetland Mitigation Site | 6.1.5 Invasive Species Management - Roadside | 6.1.6 Remnant Prairie Management - Roadside | 6.1.7 Hazard Tree Assessment | 6.1.8 Functional Planting - Large project | 6.1.9 Functional Planting - Small Project | 6.1.10 Functional Planting - Care Cycles | 6.1.11 Roadside Facilities Functional Planting | ||||||||||||||||||||||
| XYZ Analytical | Laboratory Analysis | $ 1,745.00 | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total |
| Green Drilling | 175' direct push borings | $ 3,550.00 | |||||||||||||||||||||||||||||||||
| FGH Research | database research | $ 450.00 | |||||||||||||||||||||||||||||||||
| $ 5,745.00 |
| Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | Total Subcontract | $ - 0 | |||||||
| SECTION 6.2 SUBCONTRACTS (TAB 5) | ||||||||||||||||||||||||||||
| 6.2.1 Construction Emergency Subcontract | 6.2.2 Construction Emergency Subcontract | 6.2.3 Phase 1 Subcontract | 6.2.3 Phase 2 Subcontract | 6.2.4 Phase 2.5 Subcontract | 6.2.5 Phase 4 Subcontract | 6.2.6 Phase 3 Subcontract | ||||||||||||||||||||||
| Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | ||||||||
| North Shore Environmental | UST Removal and Cleaning | $ 3,200.00 | North Shore Environmental | UST Removal and Cleaning | $ 3,200.00 | HIG | Database Search | $ 275.00 | On-Site Environmental | Probes and Temp Wells | $ 4,500.00 | On-Site Environmental | Probes and Temp Wells | $ 6,000.00 | North Shore Environmental | UST Removal and Cleaning | $ 4,500.00 | On-Site Environmental | Probes and Temp Wells | $ 4,900.00 | ||||||||
| TestAmerica | Sample Analysis | $ 480.00 | TestAmerica | Sample Analysis | $ 480.00 | TestAmerica | Sample Analysis | $ 4,300.00 | TestAmerica | Sample Analysis | $ 5,600.00 | TestAmerica | Sample Analysis | $ 212.00 | TestAmerica | Sample Analysis | $ 1,800.00 | |||||||||||
| Contingency | 10% | $ 368.00 | Contingency | 10% | $ 368.00 | Private Lines | Private Utility Locate | $ 500.00 | Contingency | 5% | $ 580.00 | Contingency | 10% | $ 471.20 | Private Lines | Private Utility Locate | $ 500.00 | |||||||||||
| Base Subcontractor Contingency | 5% | $ 465.00 | Contingency | 5% | $ 360.00 | |||||||||||||||||||||||
| Contingency (Test America) | PFAS Sample Analysis | $ 2,850.00 |
Total Subcontract $ 4,048.00 Total Subcontract $ 4,048.00 Total Subcontract $ 275.00 Total Subcontract $ 12,615.00 Total Subcontract $ 12,180.00 Total Subcontract $ 5,183.20 Total Subcontract $ 7,560.00
Tab 8 Cost Total
| Asbestos inspections | 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 | ||
| $ 1,000.00 | $ 750.00 | $ 650.00 | $ 600.00 | |||
| Asbestos Market Basket (based on 5 year daily request totals) | 117 | 101 | 47 | 42 | $ 248,500.00 | Total asbestos inspection cost |
| Hazmat Site investigation | Cost of Inspection | Market Basket** | Extended Cost | ** Site investigation market basket based on 5 year statewide average | ||
| 6.2.3 Phase 1 | $ 7,349.27 | 11 | $ 80,841.99 | |||
| 6.2.3 Phase 2 | $ 22,582.20 | 11 | $ 248,404.25 | |||
| 6.2.4 Phase 2.5 | $ 22,104.23 | 51 | $ 1,127,315.94 | |||
| 6.2.6 Phase 3 | $ 16,320.79 | 11 | $ 179,528.71 | |||
| 6.2.5 Phase 4 | $ 13,784.61 | 70 | $ 964,922.60 | |||
| 6.2.1 Construction Emergency 1 | $ 8,459.78 | 23 | $ 194,574.83 | |||
| 6.2.2 Construction Emergency | $ 8,800.19 | 23 | $ 202,404.48 | |||
| Total Hazmat Site Investigation Cost | $ 2,997,992.79 | |||||
| Program management assistance | ^ based on estimated annual program needs | |||||
| Title | Hours ^ | Average Rate | Cost | Overhead | Profit | Total |
| Administrative Support | 1000 | $ 27.66 | $ 27,655.00 | 45077.65 | 6545.9385 | $ 79,278.59 |
| Contract Manager | 25 | $ 60.46 | $ 1,511.60 | 2463.908 | 357.79572 | $ 4,333.30 |
| Project Supervisor | 25 | $ 42.51 | $ 1,062.82 | 1732.3989285714 | 251.5698321429 | $ 3,046.79 |
| Scientist | 50 | $ 33.72 | $ 1,686.20 | 2748.506 | 399.12354 | $ 4,833.83 |
| Accounting | 8 | $ 25.06 | $ 200.50 | 326.80848 | 47.4574032 | $ 574.76 |
| Total Program Management Assistance Cost | $ 86,658.68 |
| Ecological Services | Cost | Market Basket | Extended Cost |
| 6.1.1 Wetland Delineation | $ - 0 | 33 | $ - 0 |
| 6.1.2 Wetland Mitigation Site Monitoring | $ - 0 | 17 | $ - 0 |
| 6.1.3 Rare Species Survey | $ - 0 | 2 | $ - 0 |
| 6.1.4 Vegetation Management - Wetland Mitigation Site | $ - 0 | 24 | $ - 0 |
| 6.1.5 Invasive Species Management - Roadside | $ - 0 | 55 | $ - 0 |
| 6.1.6 Remnant Prairie Management - Roadside | $ - 0 | 2 | $ - 0 |
| 6.1.7 Hazard Tree Assessment - Roadside | $ - 0 | 6 | $ - 0 |
| 6.1.8 Functional Planting - large project | $ - 0 | 5 | $ - 0 |
| 6.1.9 Functional Planting - small project | $ - 0 | 9 | $ - 0 |
| 6.1.10 Functional Planting - care cycles | $ - 0 | 4 | $ - 0 |
| 6.1.11 Roadside Facilities functional planting | $ - 0 | 3 | $ - 0 |
| Total Ecological Services Cost | $ - 0 | ||
| FIRM Name: | Ramboll | ||
| Total Cost | $ 3,333,151.47 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .