GEI_CostProposal_510574.xlsx
XLSX spreadsheet 78 KB Posted
- Attached to
- Ecological Services
- Contract number
- 395002-O24-0510574-000
- Issued by
- Wisconsin
About this file
This document is a cost proposal spreadsheet (Contract Cost Worksheet) submitted by GEI Consultants, Inc. for RFP 510574, which appears to be a state contract vehicle for environmental consulting services. The spreadsheet contains detailed pricing information across multiple tabs including hourly rates, staff classifications, direct expenses, subcontractor costs, and total project costs for various ecological and environmental assessment scenarios.
The contract covers a comprehensive range of environmental services including bat and asbestos bridge inspections (with lump sum pricing ranging from $594-$1,333.60 per structure depending on complexity and quantity), ecological services such as ESA biological assessments, rare species surveys, wetland delineation and monitoring, prairie management, tree management and planting, and stream feature assessments. GEI proposes an overhead rate of 177.99% and profit margin of 7% on labor costs, with hourly rates ranging from $25.00 for Field Technician I positions to $79.51 for Project Supervisor II roles. The total proposed contract value is $11,274,053.20, which includes a bat inspection market basket totaling $147,621.00, program management assistance costs of $16,004.92, and ecological services costs of $11,110,427.28 based on projected five-year demand across multiple service categories. Direct expenses, subcontractor costs, and specialized equipment rentals are included at actual cost with no markup.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Cost_table_- Merjent.xlsx | XLSX spreadsheet | |
| REL _RFP_510574_Cost_table.xlsx | XLSX spreadsheet | |
| Stantec._Cost_Proposal.xlsx | XLSX spreadsheet | |
| TRC - RFP_510574_Cost_table.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 Worksheet--RFP 510574 Attachment 1 | |
| 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 lump sum amount for Combined Bat and Asbestos Inspection per bridge structure | B7, C7, D7, E7 |
| 3. Fill in lump sum amount for Combined Bat and Asbestos Inspection per bridge structure, two person or confined space | B8, C8, D8, E8 |
| 4. Fill in lump sum amount for Bat inspection without asbestos inspection per bridge structure | B9, C9, D9, E9 |
| 5. Fill in lump sum amount for Bat inspection without asbestos inspection per bridge structure, confined space | B10, C10, D10, E10 |
| 6. Fill in proposed overhead rate | B60 |
| 7. Fill in proposed profit percentage as a whole number, field is formatted as a percentage | B62 |
| Tab 2 Classifications in Titles | Cell # |
| 1. Fit each of your current employee classifications into one of the Twenty Two contract Rate Titles | B6 through W15 |
| 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 8 through 29 |
| 2. Put a zero in any unused cell in column D | |
| 3. Leave all other unused cells blank | |
| Tab 4 Staff Hours | Cell # |
| 1. For each of the project scenarios (Section 4.4 Proposer Solutions), indicate the number of hours proposed for each rate title to complete the project. | Columns B, G, L, and Q--Cells 8 through 29; AND Columns B, G, L, Q, V, and AA--Cells 40 through 61 |
| 2. Scenario 4.4.10 requires two cost estimates: 4.4.10 Functional Planting - Large Project, and 4.4.10A Functional Planting - Large Project Alternative Planting. | |
| 3. Put a 0 for any unused rate titles for a project. | |
| Tab 5 Direct Expenses | Cell # |
| 1. For each of the project scenarios (Section 4.4 Proposer Solutions), indicate the direct expenses to be incurred to complete the project. | Columns G through J--Cells 7 through 28 and 36 through 57; |
Columns M through P--Cells 7 through 28 and 36 through 57;
Columns S through V--Cells 7 through 28 and 36 through 57;
Columns Y through AB--Cells 7 through 28 and 36 through 57;
Columns AE through AH--Cells 36 through 57;
And Columns AK through AN--Cells 36 through 57
| 2. Scenario 4.4.10 requires two cost estimates: 4.4.10 Functional Planting - Large Project, and 4.4.10A Functional Planting - Large Project Alternative Planting. |
| 3. In the "Unit or Rate" columns, indicate whether the costs are incurred per "Unit" or as a "Rate" |
| 4. Leave unused cells blank. |
| Tab 6 Subcontractors | Cell # |
| 1. For each of the project scenarios (Section 4.4 Proposer Solutions), indicate the subcontractor to be incurred to complete the project. | Columns E through G--Cells 7 through 25 and 34 through 52; |
Columns I through K--Cells 7 through 25 and 34 through 52;
Columns M through O--Cells 7 through 25 and 34 through 52;
Columns Q through S--Cells 7 through 25 and 34 through 52;
Columns U through W--Cells 34 through 52;
And Columns Y through AA--Cells 34 through 52
| 2. Scenario 4.4.10 requires two cost estimates: 4.4.10 Functional Planting - Large Project, and 4.4.10A Functional Planting - Large Project Alternative Planting. |
| 3. Leave unused cells blank. |
| Tab 7 Cost Total |
| 1. The firm does not input anything on this tab. |
| 2. This tab pulls the total costs of the proposed scenarios, and uses information provided for certain rate titles, lump sums, and proposed overhead and profit rates to calculate a total cost proposal. See Section 6.1 for how scores will be assigned for cost proposals. |
Tab 1 Hourly Rates and Costs
| Contract Cost Package 2024 | |
| FIRM NAME: | GEI Consultants, Inc. |
| INSTRUCTIONS: Return as Excel Spreadsheet! Do not reformat. | |
| Fill in only those cells highlighted in blue. Cells in green are calculated. |
| Bat and 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 | |
| Combined Bat and Asbestos inspection, per bridge structure (Terms:Lump Sum) | $ 694.00 | $ 644.00 | $ 638.00 | $ 594.00 | |
| Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum | $ 1,333.60 | $ 1,236.80 | $ 1,225.60 | $ 1,140.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) | $ 990.00 | $ 970.00 | $ 962.00 | $ 885.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,333.60 | $ 1,236.00 | $ 1,225.00 | $ 1,140.00 | |
| NOTE: Structures requested 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. |
| Bat and Asbestos inspection, buildings, bridge tender houses, other structures | Terms: average direct hourly rate* |
| Asbestos inspection, buildings, bridge tender houses, other structures | 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 | $59.50 | Average Hourly Rate | |
| Project Supervisor I | $48.77 | Average Hourly Rate | |
| Project Supervisor II | $79.51 | Average Hourly Rate | |
| Engineer I | $36.31 | Average Hourly Rate | |
| Engineer II | $43.44 | Average Hourly Rate | |
| Engineer III | $63.22 | Average Hourly Rate | |
| Hydrogeologist I | $38.85 | Average Hourly Rate | |
| Hydrogeologist II | $48.88 | Average Hourly Rate | |
| Hydrogeologist III | $66.56 | Average Hourly Rate | |
| Scientist I | $33.28 | Average Hourly Rate | |
| Scientist II | $41.88 | Average Hourly Rate | |
| Scientist III | $57.08 | Average Hourly Rate | |
| Field Technician I | $25.00 | Average Hourly Rate | |
| Field Technician II | $29.05 | Average Hourly Rate | |
| Field Technician III | $37.53 | Average Hourly Rate | |
| CADD/GIS I | $38.85 | Average Hourly Rate | |
| CADD/GIS II | $51.90 | Average Hourly Rate | |
| Accounting I | $37.36 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $26.74 | Average Hourly Rate | |
| Administrative Support II | $33.65 | Average Hourly Rate | |
| Asbestos Inspector | $40.71 | 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 |
| Overhead | ||
| Proposed rate | 177.990% | Percentage of Direct Labor |
| Profit Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 7.000% | 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.)
GEI Consultants, Inc. Please fill in the actual titles of your staff. Limit 10 titles per classification
| Rate Title: | Contract Manager | Project Supervisor I | Project Supervisor II | Engineer I | Engineer II | Engineer III | Hydrogeologist I | Hydrogeologist II | Hydrogeologist III | Scientist I | Scientist II | Scientist III | Field Technician I | Field Technician II | Field Technician III | CADD/GIS I | CADD/GIS II | Accounting I | Accounting II | Administrative Support I | Administrative Support II | Asbestos Inspector |
| Classifications included in Rate Titles: | Senior Project Scientist 2 | Senior Enviornmental Scientist 6 | Senior Project Scientist 1 | Staff Engineer | Engineer | Senior Engineer | Project Geologist | Staff Professional | Professional Geologist | Restoration Ecologist 3 | Senior Enviornmental Scientist 6 | Restoration Ecologist 1 | Biological Field Technician 4 | Environmental Scientist 10 | Invertebrate Lab Manager 1 | Wetland Ecologist 4 | Senior Enviornmental Scientist 6 | Billing Specialist | Administrative Assistant | Regional Safety Manager | Senior Environmental Scientist 3 | |
| Senior Project Scientist 5 | Senior Project Scientist 5 | Senior Engineer 1 | Staff Professional | Senior Engineer | Senior Engineer | Geological Engineer | Senior Hydrogeologist | Senior Geologist | Environmental Scientist 4 | Senior Project Scientist 5 | Senior Enviornmental Scientist 5 | Biological Field Technician 5 | Wetland Ecologist 4 | Regional Safety Manager 1 | GIS Analyst 1 | Senior GIS Analyst 1 | Billing Team Lead | Administrative Assistant | Regional Administrative Manager | Environmental Scientist 16 | ||
| EXAMPLE: | Senior Hydrogeologist | Senior Enviornmental Scientist 4 | Senior Urban Design/Waterfront Planning Practice Leader 1 | Project Professional | Project Professional | Project Manager | Project Professional | Senior Hydrogeologist | Environmental Scientist 6 | Fisheries Ecologist 1 | Senior Project Scientist 3 | Environmental Scientist 12 | Environmental Scientist 11 | Aquatic Ecologist 2 | Aquatic Ecologist 1 | Senior Project Scientist 5 | Administrative Assistant | Senior Enviornmental Scientist 4 | ||||
| Rate Title: Scientist I | Senior Engineer | Senior Environmental Scientist 2 | Senior Project Scientist 6 | Staff Professional | Engineer | Senior Professional | Project Professional | Environmental Scientist 15 | Engineer 1 | Senior Project Scientist 4 | Environmental Scientist 13 | Biological Field Technician 1 | Engineer 2 | Restoration Ecologist 2 | Senior Project Scientist 6 | Administrative Assistant | Senior Hydrogeologist 1 | |||||
| Classifications included in title: Staff scientist 1 | Senior Environmental Scientist 1 | Staff Professional | Structural Engineer | Environmental Scientist 9 | Senior Technician 1 | Senior Environmental Scientist 1 | Restoration Ecologist 4 | Environmental Scientist 17 | Environmental Scientist 7 | Environmental Scientist 3 | Engineer 1 | Senior Project Scientist 7 | ||||||||||
| Arborist | Senior Hydrogeologist 1 | Geological Engineer | Senior Consultant | Environmental Scientist 5 | Environmental Scientist 3 | Regulatory Specialist 1 | Restoration Ecologist 5 | Biological Field Technician 3 | Restoration Ecologist 2 | Senior Technician 1 | Senior Environmental Scientist 2 | Environmental Scientist 6 | ||||||||||
| Geologist 1 | Senior Project Scientist 4 | Project Environmental Engineer | Environmental Scientist 2 | Senior Enviornmental Scientist 4 | Senior Project Scientist 2 | Environmental Scientist 14 | Wetland Ecologist 3 | Engineer 1 | Environmental Scientist 3 | Environmental Scientist 2 | ||||||||||||
| Geologist 2 | Senior Environmental Scientist 3 | Landscape Architect/CAD Designer 1 | Invertebrate Lab Manager 1 | Senior GIS Analyst 1 | Wetland and Aquatic Ecologist 1 | Wetland Ecologist 1 | Environmental Scientist 16 | Restoration Ecologist 1 | Environmental Scientist 13 | |||||||||||||
| Senior Project Technical 1 | Environmental Scientist 16 | Regional Safety Manager 2 | Regional Safety Manager 1 | Environmental Scientist 1 | Biological Field Technician 2 | Wetland Ecologist 2 | Environmental Scientist 1 | Senior Project Scientist 2 | ||||||||||||||
| Senior Project Technical 2 | Senior Hydrogeologist 1 | Restoration Ecologist 3 | Aquatic Ecologist 2 | Senior Environmental Scientist 1 |
Tab 3 Average Wage Rate Calc
| GEI Consultants, Inc. | Fill in only those cells highlighted in blue. Cells in green are calculated. | Do not alter or change the formulas. |
| Enter the hourly rate for each classification shown |
| 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 |
| 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 | $59.50 | Senior Project Scientist 2 | $ 57.92 | Senior Project Scientist 5 | $ 43.68 | Senior Hydrogeologist | $ 76.56 | Senior Engineer | $ 59.84 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| Project Supervisor I | $48.77 | Senior Enviornmental Scientist 6 | $ 45.04 | Senior Project Scientist 5 | $ 43.68 | Senior Enviornmental Scientist 4 | $ 40.64 | Senior Environmental Scientist 2 | $ 47.20 | Senior Environmental Scientist 1 | $ 58.44 | Senior Hydrogeologist 1 | $ 50.08 | Senior Project Scientist 4 | $ 59.16 | Senior Environmental Scientist 3 | $ 47.68 | Environmental Scientist 16 | $ 47.00 | 0 | |
| Project Supervisor II | $79.51 | Senior Project Scientist 1 | $ 92.12 | Senior Engineer 1 | $ 77.48 | Senior Urban Design/Waterfront Planning Practice Leader 1 | $ 81.04 | Senior Project Scientist 6 | $ 67.40 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| Engineer I | $36.31 | Staff Engineer | $ 32.64 | Staff Professional | $ 32.80 | Project Professional | $ 36.16 | Staff Professional | $ 36.36 | Staff Professional | $ 37.24 | Geological Engineer | $ 38.20 | Project Environmental Engineer | $ 40.76 | 0 | 0 | 0 | |||
| Engineer II | $43.44 | Engineer | $ 42.24 | Senior Engineer | $ 42.32 | Project Professional | $ 43.80 | Engineer | $ 45.40 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| Engineer III | $63.22 | Senior Engineer | $ 58.92 | Senior Engineer | $ 59.84 | Project Manager | $ 59.88 | Senior Professional | $ 63.96 | Structural Engineer | $ 64.60 | Senior Consultant | $ 72.12 | 0 | 0 | 0 | 0 | ||||
| Hydrogeologist I | $38.85 | Project Geologist | $ 34.40 | Geological Engineer | $ 38.20 | Project Professional | $ 40.32 | Project Professional | $ 42.48 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| Hydrogeologist II | $48.88 | Staff Professional | $ 47.68 | Senior Hydrogeologist | $ 50.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
| Hydrogeologist III | $66.56 | Professional Geologist | $ 56.08 | Senior Geologist | $ 67.04 | Senior Hydrogeologist | $ 76.56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
| Scientist I | $33.28 | Restoration Ecologist 3 | $ 34.68 | Environmental Scientist 4 | $ 34.60 | Environmental Scientist 6 | $ 33.88 | Environmental Scientist 15 | $ 33.00 | Environmental Scientist 9 | $ 33.00 | Environmental Scientist 5 | $ 32.88 | Environmental Scientist 2 | $ 32.80 | Landscape Architect/CAD Designer 1 | $ 32.48 | Regional Safety Manager 2 | $ 32.20 | 0 | |
| Scientist II | $41.88 | Senior Enviornmental Scientist 6 | $ 45.04 | Senior Project Scientist 5 | $ 43.68 | Fisheries Ecologist 1 | $ 42.56 | Engineer 1 | $ 42.24 | Senior Technician 1 | $ 41.76 | Environmental Scientist 3 | $ 41.60 | Senior Enviornmental Scientist 4 | $ 40.64 | Invertebrate Lab Manager 1 | $ 40.52 | Regional Safety Manager 1 | $ 38.88 | 0 | |
| Scientist III | $57.08 | Restoration Ecologist 1 | $ 62.48 | Senior Enviornmental Scientist 5 | $ 61.56 | Senior Project Scientist 3 | $ 59.48 | Senior Project Scientist 4 | $ 59.16 | Senior Environmental Scientist 1 | $ 58.44 | Regulatory Specialist 1 | $ 58.00 | Senior Project Scientist 2 | $ 57.92 | Senior GIS Analyst 1 | $ 53.04 | Environmental Scientist 1 | $ 50.68 | Senior Hydrogeologist 1 | $ 50.08 |
| Field Technician I | $25.00 | Biological Field Technician 4 | $ 25.00 | Biological Field Technician 5 | $ 25.00 | Environmental Scientist 12 | $ 25.00 | Environmental Scientist 13 | $ 25.00 | Restoration Ecologist 4 | $ 25.00 | Restoration Ecologist 5 | 0 | 0 | 0 | 0 | |||||
| Field Technician II | $29.05 | Environmental Scientist 10 | $ 30.32 | Wetland Ecologist 4 | $ 30.04 | Environmental Scientist 11 | $ 29.72 | Biological Field Technician 1 | $ 29.12 | Environmental Scientist 17 | $ 29.00 | Biological Field Technician 3 | $ 28.64 | Environmental Scientist 14 | $ 28.52 | Wetland and Aquatic Ecologist 1 | $ 28.12 | Biological Field Technician 2 | $ 28.00 | 0 | |
| Field Technician III | $37.53 | Invertebrate Lab Manager 1 | $ 40.52 | Regional Safety Manager 1 | $ 38.88 | Aquatic Ecologist 2 | $ 38.84 | Engineer 2 | $ 38.44 | Environmental Scientist 7 | $ 37.52 | Restoration Ecologist 2 | $ 37.20 | Wetland Ecologist 3 | $ 37.08 | Wetland Ecologist 1 | $ 36.64 | Wetland Ecologist 2 | $ 35.52 | Restoration Ecologist 3 | $ 34.68 |
| CADD/GIS I | $38.85 | Wetland Ecologist 4 | $ 30.04 | GIS Analyst 1 | $ 31.68 | Aquatic Ecologist 1 | $ 27.44 | Restoration Ecologist 2 | $ 37.20 | Environmental Scientist 3 | $ 41.60 | Senior Technician 1 | $ 41.76 | Engineer 1 | $ 42.24 | Environmental Scientist 16 | $ 47.00 | Environmental Scientist 1 | $ 50.68 | Aquatic Ecologist 2 | $ 38.84 |
| CADD/GIS II | $51.90 | Senior Enviornmental Scientist 6 | $ 45.04 | Senior GIS Analyst 1 | $ 53.04 | Senior Project Scientist 5 | $ 43.68 | Senior Project Scientist 6 | $ 67.40 | Engineer 1 | $ 42.24 | Senior Environmental Scientist 2 | $ 47.20 | Environmental Scientist 3 | $ 41.60 | Restoration Ecologist 1 | $ 62.48 | Senior Project Scientist 2 | $ 57.92 | Senior Environmental Scientist 1 | $ 58.44 |
| Accounting I | $37.36 | Billing Specialist | $ 32.48 | Billing Team Lead | $ 42.24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
| Accounting II | $0.00 | 0 | $ - 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||
| Administrative Support I | $26.74 | Administrative Assistant | $ 26.36 | Administrative Assistant | $ 27.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
| Administrative Support II | $33.65 | Regional Safety Manager | $ 32.20 | Regional Administrative Manager | $ 37.44 | Administrative Assistant | $ 27.88 | Administrative Assistant | $ 37.08 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| Asbestos Inspector | $40.71 | Senior Environmental Scientist 3 | $ 47.68 | Environmental Scientist 16 | $ 47.00 | Senior Enviornmental Scientist 4 | $ 40.64 | Senior Hydrogeologist 1 | $ 50.08 | Senior Project Scientist 7 | $ 48.60 | Environmental Scientist 6 | $ 33.88 | Environmental Scientist 2 | $ 32.80 | Environmental Scientist 13 | $ 25.00 | 0 | 0 |
Tab 4 Staff Hours
| For each Proposer Solution (Section 4.4) enter the number of hours per Rate Title. Total Direct Expenses and Subcontractors will be entered on subsequent tabs. |
| Fill in only those cells highlighted in blue. Cells in green are calculated. |
| There are 10 scenarios to provide Staff Hours information for: 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7, 4.4.8, 4.4.9, 4.4.10, and 4.4.10A |
| 4.4.2 ESA Biological assessment | 4.4.3 Rare Species Survey | 4.4.4 Roadside remnant prairie and invasive species management | 4.4.5 Roadside facilities tree management and planting | ||||||||||||||||||||
| Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | ||||||||
| Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | ||||||||
| Project Supervisor I | 20 | $ 48.77 | $ 975.38 | Project Supervisor I | 4 | $ 48.77 | $ 195.08 | Project Supervisor I | 7 | $ 48.77 | $ 341.38 | Project Supervisor I | 12 | $ 48.77 | $ 585.23 | ||||||||
| Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | ||||||||
| Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | ||||||||
| Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | ||||||||
| Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | ||||||||
| Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | ||||||||
| Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | ||||||||
| Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | ||||||||
| Scientist I | 133 | $ 33.28 | $ 4,426.24 | Scientist I | 4 | $ 33.28 | $ 133.12 | Scientist I | 0 | $ 33.28 | $ - 0 | Scientist I | 0 | $ 33.28 | $ - 0 | ||||||||
| Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 | ||||||||
| Scientist III | 13 | $ 57.08 | $ 742.09 | Scientist III | 0 | $ 57.08 | $ - 0 | Scientist III | 0 | $ 57.08 | $ - 0 | Scientist III | 0 | $ 57.08 | $ - 0 | ||||||||
| Field Technician I | 0 | $ 25.00 | $ - 0 | Field Technician I | 98 | $ 25.00 | $ 2,450.00 | Field Technician I | 47 | $ 25.00 | $ 1,175.00 | Field Technician I | 357 | $ 25.00 | $ 8,925.00 | ||||||||
| Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | ||||||||
| Field Technician III | 0 | $ 37.53 | $ - 0 | Field Technician III | 0 | $ 37.53 | $ - 0 | Field Technician III | 5 | $ 37.53 | $ 187.66 | Field Technician III | 24 | $ 37.53 | $ 900.77 | ||||||||
| CADD/GIS I | 6 | $ 38.85 | $ 233.09 | CADD/GIS I | 8 | $ 38.85 | $ 310.78 | CADD/GIS I | 3 | $ 38.85 | $ 116.54 | CADD/GIS I | 0 | $ 38.85 | $ - 0 | ||||||||
| CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | ||||||||
| Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | ||||||||
| Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | ||||||||
| Administrative Support I | 2 | $ 26.74 | $ 53.48 | Administrative Support I | 0 | $ 26.74 | $ - 0 | Administrative Support I | 1 | $ 26.74 | $ 26.74 | Administrative Support I | 2 | $ 26.74 | $ 53.48 | ||||||||
| Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | ||||||||
| Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | ||||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ 375.00 | Direct Expenses | $ 310.00 | Direct Expenses | $ 12,357.27 | ||||||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | ||||||||||||||||
| Overhead | $ 11,551.16 | Overhead | $ 5,603.98 | Overhead | $ 3,393.96 | Overhead | $ 18,731.62 | ||||||||||||||||
| Profit | $ 1,262.87 | Profit | $ 612.67 | Profit | $ 371.06 | Profit | $ 2,047.89 | ||||||||||||||||
| Total Cost 4.4.2 | $ 19,303.80 | Total Cost 4.4.3 | $ 9,740.13 | Total Cost 4.4.4 | $ 5,981.84 | Total Cost 4.4.5 | $ 43,660.76 | ||||||||||||||||
| 4.4.6 Roadside facilities prairie management and planting | 4.4.7 Wetland Delineation | 4.4.8 Wetland Monitoring | 4.4.9 Stream Features Worksheet | 4.4.10 Functional Planting - Large Project | 4.4.10A Functional Planting - Large Project Alternate Planting | ||||||||||||||||||
| Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost | Classification | Total Number of Hours | Rate | Total Cost |
| Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 3 | $ 59.50 | $ 178.50 | Contract Manager | 1 | $ 59.50 | $ 59.50 | Contract Manager | 0 | $ 59.50 | $ - 0 |
| Project Supervisor I | 15 | $ 48.77 | $ 731.53 | Project Supervisor I | 6 | $ 48.77 | $ 292.61 | Project Supervisor I | 14 | $ 48.77 | $ 682.76 | Project Supervisor I | 0 | $ 48.77 | $ - 0 | Project Supervisor I | 13 | $ 48.77 | $ 634.00 | Project Supervisor I | 0 | $ 48.77 | $ - 0 |
| Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 | Project Supervisor II | 0 | $ 79.51 | $ - 0 |
| Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 | Engineer I | 0 | $ 36.31 | $ - 0 |
| Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 | Engineer II | 0 | $ 43.44 | $ - 0 |
| Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 | Engineer III | 0 | $ 63.22 | $ - 0 |
| Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 | Hydrogeologist I | 0 | $ 38.85 | $ - 0 |
| Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 | Hydrogeologist II | 0 | $ 48.88 | $ - 0 |
| Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 | Hydrogeologist III | 0 | $ 66.56 | $ - 0 |
| Scientist I | 0 | $ 33.28 | $ - 0 | Scientist I | 0 | $ 33.28 | $ - 0 | Scientist I | 0 | $ 33.28 | $ - 0 | Scientist I | 50 | $ 33.28 | $ 1,664.00 | Scientist I | 0 | $ 33.28 | $ - 0 | Scientist I | 0 | $ 33.28 | $ - 0 |
| Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 2 | $ 41.88 | $ 83.76 | Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 | Scientist II | 0 | $ 41.88 | $ - 0 |
| Scientist III | 0 | $ 57.08 | $ - 0 | Scientist III | 2 | $ 57.08 | $ 114.17 | Scientist III | 6 | $ 57.08 | $ 342.50 | Scientist III | 4 | $ 57.08 | $ 228.34 | Scientist III | 0 | $ 57.08 | $ - 0 | Scientist III | 0 | $ 57.08 | $ - 0 |
| Field Technician I | 160 | $ 25.00 | $ 4,000.00 | Field Technician I | 89 | $ 25.00 | $ 2,225.00 | Field Technician I | 240 | $ 25.00 | $ 6,000.00 | Field Technician I | 30 | $ 25.00 | $ 750.00 | Field Technician I | 709 | $ 25.00 | $ 17,725.00 | Field Technician I | 40 | $ 25.00 | $ 1,000.00 |
| Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 | Field Technician II | 0 | $ 29.05 | $ - 0 |
| Field Technician III | 12 | $ 37.53 | $ 450.38 | Field Technician III | 0 | $ 37.53 | $ - 0 | Field Technician III | 0 | $ 37.53 | $ - 0 | Field Technician III | 0 | $ 37.53 | $ - 0 | Field Technician III | 24 | $ 37.53 | $ 900.77 | Field Technician III | 0 | $ 37.53 | $ - 0 |
| CADD/GIS I | 6 | $ 38.85 | $ 233.09 | CADD/GIS I | 6 | $ 38.85 | $ 233.09 | CADD/GIS I | 17 | $ 38.85 | $ 660.42 | CADD/GIS I | 14 | $ 38.85 | $ 543.87 | CADD/GIS I | 0 | $ 38.85 | $ - 0 | CADD/GIS I | 0 | $ 38.85 | $ - 0 |
| CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 6 | $ 51.90 | $ 311.42 | CADD/GIS II | 0 | $ 51.90 | $ - 0 | CADD/GIS II | 0 | $ 51.90 | $ - 0 |
| Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 | Accounting I | 0 | $ 37.36 | $ - 0 |
| Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 | Accounting II | 0 | $ - 0 | $ - 0 |
| Administrative Support I | 4 | $ 26.74 | $ 106.96 | Administrative Support I | 1 | $ 26.74 | $ 26.74 | Administrative Support I | 4 | $ 26.74 | $ 106.96 | Administrative Support I | 0 | $ 26.74 | $ - 0 | Administrative Support I | 1 | $ 26.74 | $ 26.74 | Administrative Support I | 0 | $ 26.74 | $ - 0 |
| Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 | Administrative Support II | 0 | $ 33.65 | $ - 0 |
| Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 | Asbestos Inspector | 0 | $ 40.71 | $ - 0 |
| Direct Expenses | $ 5,980.00 | Direct Expenses | $ 450.00 | Direct Expenses | $ 2,455.00 | Direct Expenses | $ 100.00 | Direct Expenses | $ 20,289.70 | Direct Expenses | $ 4,233.40 | ||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | ||||||||||||
| Overhead | $ 9,934.45 | Overhead | $ 5,252.68 | Overhead | $ 14,125.12 | Overhead | $ 6,543.15 | Overhead | $ 34,433.95 | Overhead | $ 1,779.90 | ||||||||||||
| Profit | $ 1,086.11 | Profit | $ 574.27 | Profit | $ 1,544.27 | Profit | $ 715.35 | Profit | $ 3,764.60 | Profit | $ 194.59 | ||||||||||||
| Total Cost 4.4.6 | $ 22,582.03 | Total Cost 4.4.7 | $ 9,228.05 | Total Cost 4.4.8 | $ 26,060.29 | Total Cost 4.4.9 | $ 11,034.63 | Total Cost 4.4.10 | $ 77,834.25 | Total Cost 4.4.10A | $ 7,207.89 |
Tab 5 Direct Expenses
| 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. | 0 |
| There are 10 scenarios to provide Direct Expenses information for: 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7, 4.4.8, 4.4.9, 4.4.10, and 4.4.10A |
| Example | 4.4.2 ESA Biological assessment | 4.4.3 Rare Species Survey | 4.4.4 Roadside remnant prairie and invasive species management | 4.4.5 Roadside facilities tree management and planting | ||||||||||||||||||||
| 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 |
| Photo Copies | 250 | per page | $ 0.15 | $ 37.50 | $ - 0 | GPS Unit | 5 | daily | $ 50.00 | $ 250.00 | WDNR Aquatic Plant Management Permit | 1 | Total Expenses | $ 50.00 | $ 50.00 | Herbicide and adjuvants | 0.25 | gallons | $ 50.00 | $ 12.50 | ||||
| PID Rental | 4 | per day | $ 125.00 | $ 500.00 | $ - 0 | Field Tablet | 5 | daily | $ 25.00 | $ 125.00 | Herbicides and adjuvants (concentrate) | 4 | gallons | $ 50.00 | $ 200.00 | Backpack Sprayer | 1 | daily | $ 15.00 | $ 15.00 | ||||
| Sample Jars | 75 | each | $ 3.45 | $ 258.75 | $ - 0 | $ - 0 | Backpack Sprayer | 4 | daily | $ 15.00 | $ 60.00 | 2.5” DBH swamp white oak trees | 5 | each | $ 325.00 | $ 1,625.00 | ||||||||
| Test Blank | 4 | each | $ 7.00 | $ 28.00 | $ - 0 | $ - 0 | $ - 0 | 8’ spruce trees | 20 | each | $ 325.00 | $ 6,500.00 | ||||||||||||
| Trip Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | $ - 0 | Estimated replacement trees | 6 | each | $ 325.00 | $ 1,950.00 | ||||||||||||
| Dry ice | 6 | per pound | $ 5.75 | $ 34.50 | $ - 0 | $ - 0 | $ - 0 | Tractor with auger | 1 | daily | $ 250.00 | $ 250.00 | ||||||||||||
| Cooler | 2 | each | $ 12.50 | $ 25.00 | $ - 0 | $ - 0 | $ - 0 | Shredded bark mulch and delivery | 31 | cubic yards | $ 43.06 | $ 1,334.86 | ||||||||||||
| Method Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | $ - 0 | Staking and guy wiring materials per tree | 31 | each | $ 21.61 | $ 669.91 | ||||||||||||
| Postage | 1 | package | $ 6.75 | $ 6.75 | $ - 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 | |||||||||||||||||||||
| Total Expenses | $ - 0 | Total Expenses | $ 375.00 | Total Expenses | $ 310.00 | Total Expenses | $ 12,357.27 |
| 4.4.6 Roadside facilities prairie management and planting | 4.4.7 Wetland Delineation | 4.4.8 Wetland Monitoring | 4.4.9 Stream Features Worksheet | 4.4.10 Functional Planting - Large Project | 4.4.10A Functional Planting - Large Project Alternate Planting | ||||||||||||||||||||||||
| 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 |
| UTV | 2 | daily | $ 250.00 | $ 500.00 | GPS Unit | 6 | daily | $ 50.00 | $ 300.00 | Water Level Tape (Daily Rate) | 9 | Daily | $ 20.00 | $ 180.00 | Stream Worksheet Kit | 2 | each | $ 50.00 | $ 100.00 | Herbicides and adjuvants | 2 | gallons | $ 50.00 | $ 100.00 | Oak Tree (3 to 5 gallon) | 61 | each | $ 50.50 | $ 3,080.50 |
| 55 gal UTV Tank Sprayer | 1 | daily | $ 50.00 | $ 50.00 | Field Tablet | 6 | daily | $ 25.00 | $ 150.00 | Data Logger Rental | 8 | Annual | $ 200.00 | $ 1,600.00 | $ - 0 | ATV with spray tank equipment | 2 | days | $ 125.00 | $ 250.00 | Red Cedar (forestry plugs) | 549 | each | $ 2.10 | $ 1,152.90 | ||||
| No-till drill/drop seeder | 1 | daily | $ 250.00 | $ 250.00 | $ - 0 | Field Tablet | 15 | Daily | $ 25.00 | $ 375.00 | $ - 0 | Bareroot shrub seedlings | 4575 | each | $ 2.10 | $ 9,607.50 | $ - 0 | ||||||||||||
| Native Prairie Seed and Cover Crop | 5 | acres | $ 900.00 | $ 4,500.00 | $ - 0 | GPS Unit | 6 | Daily | $ 50.00 | $ 300.00 | $ - 0 | Estimated replacement shrub seedlings | 902 | each | $ 2.10 | $ 1,894.20 | $ - 0 | ||||||||||||
| Backpack Sprayer | 12 | daily | $ 15.00 | $ 180.00 | $ - 0 | $ - 0 | $ - 0 | Weed barrier cloth and staples | 124,000 | sq. ft. | $ 0.06 | $ 7,688.00 | $ - 0 | ||||||||||||||||
| Herbicides and adjuvants (concentrate) | 10 | gallons | $ 50.00 | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | Tractor with mechanical tree planter | 3 | days | $ 250.00 | $ 750.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 | ||||||||||||||||||||||||
| Total Expenses | $ 5,980.00 | Total Expenses | $ 450.00 | Total Expenses | $ 2,455.00 | Total Expenses | $ 100.00 | Total Expenses | $ 20,289.70 | Total Expenses | $ 4,233.40 |
Tab 6 Subcontractors
| 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. | 0 |
| There are 10 scenarios to provide Subcontractor information for: 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7, 4.4.8, 4.4.9, 4.4.10, and 4.4.10A |
| Example | 4.4.2 ESA Biological assessment | 4.4.3 Rare Species Survey | 4.4.4 Roadside remnant prairie and invasive species management | 4.4.5 Roadside facilities tree management and planting | ||||||||||
| Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total |
| XYZ Analytical | Laboratory Analysis | $ 1,745.00 | ||||||||||||
| 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
| 4.4.6 Roadside facilities prairie management and planting | 4.4.7 Wetland Delineation | 4.4.8 Wetland Monitoring | 4.4.9 Stream Features Worksheet | 4.4.10 Functional Planting - Large Project | 4.4.10A Functional Planting - Large Project Alternate Planting | ||||||||||||
| Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total | Subcontractor | Task | Total |
Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0
Tab 7 Cost Total
| Bat inspections, per bridge structure (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 | ||
| $ 990.00 | $ 970.00 | $ 962.00 | $ 885.00 | |||
| Bat Inspection Market Basket (based on 5 year daily request totals) | 59 | 50 | 23 | 21 | $ 147,621.00 | Total bat inspection cost |
| Program management assistance | * based on estimated annual program needs | |||||
| Title | Hours * | Average Rate | Cost | Overhead | Profit | Total |
| Administrative Support I | 100 | $ 26.74 | $ 2,674.00 | $ 4,759.45 | $ 520.34 | $ 7,953.79 |
| Contract Manager | 25 | $ 59.50 | $ 1,487.50 | $ 2,647.60 | $ 289.46 | $ 4,424.56 |
| Project Supervisor I | 25 | $ 48.77 | $ 1,219.22 | $ 2,170.09 | $ 237.25 | $ 3,626.57 |
| CADD/GIS I | 50 | $ 38.85 | $ 1,942.40 | $ 3,457.28 | $ 377.98 | $ 5,777.66 |
| Accounting I | 8 | $ 37.36 | $ 298.88 | $ 531.98 | $ 58.16 | $ 889.02 |
| Total Program Management Assistance Cost | $ 16,004.92 |
| Ecological Services | Cost | Market Basket | Extended Cost |
| 4.4.2 ESA Biological assessment | $ 19,303.80 | 7 | 135126.590000889 |
| 4.4.3 Rare Species Survey | $ 9,740.13 | 130 | 1266216.9518236 |
| 4.4.4 Roadside remnant prairie and invasive species management | $ 5,981.84 | 138 | 825494.09252987 |
| 4.4.5 Roadside facilities tree management and planting | $ 43,660.76 | 19 | 829554.420585369 |
| 4.4.6 Roadside facilities prairie management and planting | $ 22,582.03 | 17 | 383894.502583625 |
| 4.4.7 Wetland Delineation | $ 9,228.05 | 214 | 1974803.56760622 |
| 4.4.8 Wetland Monitoring | $ 26,060.29 | 50 | 1303014.61093344 |
| 4.4.9 Stream Features Worksheet | $ 11,034.63 | 5 | 55173.14450538 |
| 4.4.10 Functional Planting - Large Project | $ 85,042.15 | 51 | 4337149.40285273 |
| Total Ecological Services Cost | $ 11,110,427.28 | ||
| FIRM Name: | GEI Consultants, Inc. | ||
| Total Cost | $ 11,274,053.20 |
File details come from the government source that posted it. Updated .