Stantec._Cost_Proposal.xlsx
XLSX spreadsheet 80 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 submitted by Stantec Consulting Services Inc. in response to RFP 510574, which appears to be for a state and local contract vehicle covering ecological and environmental services. The proposal includes detailed pricing structures across multiple service categories and project scenarios, with comprehensive breakdowns of labor rates, overhead calculations (155.550%), and profit margins (13.500%) for various professional classifications ranging from Contract Managers to Field Technicians.
The contract covers a broad range of environmental services including bat and asbestos inspections of bridge structures (priced as lump sums from $5,000 for single structures to $25,000 for ten or more structures), ecological assessments, rare species surveys, wetland delineation and monitoring, prairie management, tree management and planting, and stream features analysis. Labor rates vary by classification, with Contract Managers at $76.01/hour, various Engineer levels from $42.86 to $70.52/hour, and Field Technicians from $22.46 to $32.55/hour. The proposal includes detailed cost estimates for ten specific project scenarios, ranging from $1,019.46 for alternative functional planting to $141,821.15 for large-scale functional planting projects. The total contract value across all ecological services is estimated at $26,654,500.53, with the complete program including bat inspections and program management totaling $28,162,773.24 based on projected five-year market basket requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| REL _RFP_510574_Cost_table.xlsx | XLSX spreadsheet | |
| TRC - RFP_510574_Cost_table.xlsx | XLSX spreadsheet | |
| Cost_table_- Merjent.xlsx | XLSX spreadsheet | |
| GEI_CostProposal_510574.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: | Stantec Consulting Services 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) | |||||
| Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum | # 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) | $5,000 | $7,000 | $14,000 | $25,000 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | |||||
| 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 | $76.01 | Average Hourly Rate | |
| Project Supervisor I | $48.71 | Average Hourly Rate | |
| Project Supervisor II | $60.06 | Average Hourly Rate | |
| Engineer I | $42.86 | Average Hourly Rate | |
| Engineer II | $56.24 | Average Hourly Rate | |
| Engineer III | $70.52 | Average Hourly Rate | |
| Hydrogeologist I | $0.00 | Average Hourly Rate | |
| Hydrogeologist II | $0.00 | Average Hourly Rate | |
| Hydrogeologist III | $0.00 | Average Hourly Rate | |
| Scientist I | $32.44 | Average Hourly Rate | |
| Scientist II | $39.96 | Average Hourly Rate | |
| Scientist III | $48.50 | Average Hourly Rate | |
| Field Technician I | $22.46 | Average Hourly Rate | |
| Field Technician II | $25.44 | Average Hourly Rate | |
| Field Technician III | $32.55 | Average Hourly Rate | |
| CADD/GIS I | $32.87 | Average Hourly Rate | |
| CADD/GIS II | $46.32 | Average Hourly Rate | |
| Accounting I | $36.31 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $24.92 | Average Hourly Rate | |
| Administrative Support II | $26.79 | Average Hourly Rate | |
| Asbestos Inspector | $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 |
| Overhead | ||
| Proposed rate | 155.550% | Percentage of Direct Labor |
| Profit Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 13.500% | 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.)
Stantec Consulting Services 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: | Principal Project Manager | Associate, Senior Project Manager | Senior Scientist | Water Resource Engineer | Project Manager, PE | Technical Discipline Leader | hI1 | hII1 | hIII1 | Environmental Specialist | Environmental Scientist | Senior NEPA Specialist | Ecosystem Restoration Technician | Biologist | Biologist | GIS Analyst | Associate GIS Analyst | Project Controls Specialist | accII1 | Project Controls Administrator | Project Controls Administrator | ai1 |
| Senior Ecologist | Restoration Ecologist | Senior Botanist | Civil Engineer, EIT | Environmental Engineer | eIII2 | hI2 | hII2 | hIII2 | Environmental Scientist | Environmental Scientist | Senior Ecologist | Ecosystem Restoration Technician | Environmental Restoration Technician | Restoration Ecologist | GIS Analyst | Associate, GIS Manager | Project Control Specialist | accII2 | Administrative Assistant | Administrative Assistant | ai2 | |
| EXAMPLE: | Senior Environmental Scientist | psI3 | Associate, GIS Manager | Geological Engineer in Training | Senior Engineer | eIII3 | hI3 | hII3 | hIII3 | Restoration Ecologist | Senior Ecosystem Restoration Technician | Senior Wildlife Biologist | Ecosystem Restoration Technician | Scientific Technician | Environmental Scientist | CAD/GIS Technician | GIS Specialist | Project Controls Coordinator | accII3 | Administrative Assistant | admII3 | ai3 |
| Rate Title: Scientist I | Senior Wildlife Biologist | psI4 | Senior Environmental Engineer | Environmental Engineer In Training | Senior Project Engineer | eIII4 | hI4 | hII4 | hIII4 | Commercial Diver | Environmental Scientist | Wetland Scientist | Ecosystem Restoration Technician | Environmental Technician | Restoration Ecologist | GIS Analyst | GIS Analyst | Project Controls Specialist | accII4 | admI4 | admII4 | ai4 |
| Classifications included in title: Staff scientist 1 | Principal Scientist | psI5 | Senior Restoration Ecologist | eI5 | Civil Engineer | eIII5 | hI5 | hII5 | hIII5 | Senior Environmental Scientist | Ecologist | Commerical Dive Supervisor | Ecosystem Restoration Technician | Ecosystem Restoration Technician | Biologist | CAD/GIS Technician | Senior GIS Analyst | accI5 | accII5 | admI5 | admII5 | ai5 |
| Arborist | Principal, Aquatic Ecologist | psI6 | Senior Biologist | eI6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | Commercial Diver | Environmental Scientist | Senior Environmental Scientist | Ecosystem Restoration Technician | Ecosystem Restoration Technician | Environmental Scientist | GIS Analyst | GIS Analyst | accI6 | accII6 | admI6 | admII6 | ai6 |
| Geologist 1 | Associate, Senior Scientist | psI7 | Senior Associate | eI7 | eII7 | eIII7 | hI7 | hII7 | hIII7 | Marine Biologist | Environmental Scientist | Senior Scientist | Ecosystem Restoration Technician | Ecosystem Restoration Technician | ftIII7 | GIS Analyst | Senior GIS Analyst | accI7 | accII7 | admI7 | admII7 | ai7 |
| Geologist 2 | cm8 | psI8 | Project Manager | eI8 | eII8 | eIII8 | hI8 | hII8 | hIII8 | sI8 | Environmental Scientist | Environmental Scientist | Ecosystem Restoration Technician | ftII8 | ftIII8 | cadI8 | GIS Analyst | accI8 | accII8 | admI8 | admII8 | ai8 |
| Senior Project Technical 1 | cm9 | psI9 | psII9 | eI9 | eII9 | eIII9 | hI9 | hII9 | hIII9 | sI9 | Commerical Diver | Senior Scientist | ftI9 | ftII9 | ftIII9 | cadI9 | cadII9 | accI9 | accII9 | admI9 | admII9 | ai9 |
| Senior Project Technical 2 | cm10 | psI10 | psII10 | eI10 | eII10 | eIII10 | hI10 | hII10 | hIII10 | sI10 | Biologist | Senior Environmental Scientist | ftI10 | ftII10 | ftIII10 | cadI10 | cadII10 | accI10 | accII10 | admI10 | admII10 | ai10 |
Tab 3 Average Wage Rate Calc
| Stantec Consulting Services 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 | $76.01 | Principal Project Manager | $ 89.71 | Senior Ecologist | $ 79.92 | Senior Environmental Scientist | $ 75.07 | Senior Wildlife Biologist | $ 74.05 | Principal Scientist | $ 72.88 | Principal, Aquatic Ecologist | $ 70.34 | Associate, Senior Scientist | $ 70.13 | cm8 | cm9 | cm10 | |||
| Project Supervisor I | $48.71 | Associate, Senior Project Manager | $ 50.31 | Restoration Ecologist | $ 47.11 | psI3 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | ||||||||
| Project Supervisor II | $60.06 | Senior Scientist | $ 66.84 | Senior Botanist | $ 64.66 | Associate, GIS Manager | $ 64.10 | Senior Environmental Engineer | $ 58.86 | Senior Restoration Ecologist | $ 58.49 | Senior Biologist | $ 58.31 | Senior Associate | $ 56.99 | Project Manager | $ 52.26 | psII9 | psII10 | ||
| Engineer I | $42.86 | Water Resource Engineer | $ 44.70 | Civil Engineer, EIT | $ 44.00 | Geological Engineer in Training | $ 41.66 | Environmental Engineer In Training | $ 41.06 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | ||||||
| Engineer II | $56.24 | Project Manager, PE | $ 61.90 | Environmental Engineer | $ 61.89 | Senior Engineer | $ 54.87 | Senior Project Engineer | $ 54.37 | Civil Engineer | $ 48.16 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||
| Engineer III | $70.52 | Technical Discipline Leader | $ 70.52 | eIII2 | eIII3 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | |||||||||
| Hydrogeologist I | $0.00 | hI1 | $ - 0 | hI2 | hI3 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | |||||||||
| Hydrogeologist II | $0.00 | hII1 | $ - 0 | hII2 | hII3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | |||||||||
| Hydrogeologist III | $0.00 | hIII1 | $ - 0 | hIII2 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||||
| Scientist I | $32.44 | Environmental Specialist | $ 34.67 | Environmental Scientist | $ 33.17 | Restoration Ecologist | $ 32.30 | Commercial Diver | $ 32.14 | Senior Environmental Scientist | $ 31.65 | Commercial Diver | $ 31.63 | Marine Biologist | $ 31.54 | sI8 | sI9 | sI10 | |||
| Scientist II | $39.96 | Environmental Scientist | $ 44.57 | Environmental Scientist | $ 41.83 | Senior Ecosystem Restoration Technician | $ 40.90 | Environmental Scientist | $ 40.44 | Ecologist | $ 40.04 | Environmental Scientist | $ 39.88 | Environmental Scientist | $ 39.63 | Environmental Scientist | $ 38.03 | Commerical Diver | $ 37.21 | Biologist | $ 37.03 |
| Scientist III | $48.50 | Senior NEPA Specialist | $ 51.28 | Senior Ecologist | $ 50.16 | Senior Wildlife Biologist | $ 49.65 | Wetland Scientist | $ 49.52 | Commerical Dive Supervisor | $ 49.42 | Senior Environmental Scientist | $ 48.21 | Senior Scientist | $ 47.77 | Environmental Scientist | $ 47.16 | Senior Scientist | $ 46.31 | Senior Environmental Scientist | $ 45.52 |
| Field Technician I | $22.46 | Ecosystem Restoration Technician | $ 23.18 | Ecosystem Restoration Technician | $ 23.18 | Ecosystem Restoration Technician | $ 22.66 | Ecosystem Restoration Technician | $ 22.62 | Ecosystem Restoration Technician | $ 22.15 | Ecosystem Restoration Technician | $ 22.15 | Ecosystem Restoration Technician | $ 22.15 | Ecosystem Restoration Technician | $ 21.63 | ftI9 | ftI10 | ||
| Field Technician II | $25.44 | Biologist | $ 27.09 | Environmental Restoration Technician | $ 26.78 | Scientific Technician | $ 25.76 | Environmental Technician | $ 25.75 | Ecosystem Restoration Technician | $ 24.30 | Ecosystem Restoration Technician | $ 24.21 | Ecosystem Restoration Technician | $ 24.21 | ftII8 | ftII9 | ftII10 | |||
| Field Technician III | $32.55 | Biologist | $ 37.06 | Restoration Ecologist | $ 34.67 | Environmental Scientist | $ 31.28 | Restoration Ecologist | $ 31.16 | Biologist | $ 30.90 | Environmental Scientist | $ 30.21 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | ||||
| CADD/GIS I | $32.87 | GIS Analyst | $ 36.31 | GIS Analyst | $ 36.19 | CAD/GIS Technician | $ 34.02 | GIS Analyst | $ 32.84 | CAD/GIS Technician | $ 31.13 | GIS Analyst | $ 29.89 | GIS Analyst | $ 29.72 | cadI8 | cadI9 | cadI10 | |||
| CADD/GIS II | $46.32 | Associate GIS Analyst | $ 55.08 | Associate, GIS Manager | $ 52.51 | GIS Specialist | $ 50.06 | GIS Analyst | $ 46.80 | Senior GIS Analyst | $ 46.14 | GIS Analyst | $ 41.17 | Senior GIS Analyst | $ 40.22 | GIS Analyst | $ 38.57 | cadII9 | cadII10 | ||
| Accounting I | $36.31 | Project Controls Specialist | $ 40.12 | Project Control Specialist | $ 38.26 | Project Controls Coordinator | $ 33.56 | Project Controls Specialist | $ 33.31 | accI5 | accI6 | accI7 | accI8 | accI9 | accI10 | ||||||
| Accounting II | $0.00 | accII1 | $ - 0 | accII2 | accII3 | accII4 | accII5 | accII6 | accII7 | accII8 | accII9 | accII10 | |||||||||
| Administrative Support I | $24.92 | Project Controls Administrator | $ 26.01 | Administrative Assistant | $ 24.84 | Administrative Assistant | $ 23.92 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | |||||||
| Administrative Support II | $26.79 | Project Controls Administrator | $ 26.94 | Administrative Assistant | $ 26.63 | admII3 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | ||||||||
| Asbestos Inspector | $0.00 | ai1 | $ - 0 | ai2 | ai3 | ai4 | ai5 | ai6 | ai7 | ai8 | ai9 | ai10 |
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 | 4 | $ 76.01 | $ 304.06 | Contract Manager | 4 | $ 76.01 | $ 304.06 | Contract Manager | $ 76.01 | $ - 0 | Contract Manager | 1 | $ 76.01 | $ 76.01 | |||||||||
| Project Supervisor I | 42 | $ 48.71 | $ 2,045.77 | Project Supervisor I | $ 48.71 | $ - 0 | Project Supervisor I | 54.5 | $ 48.71 | $ 2,654.62 | Project Supervisor I | 26 | $ 48.71 | $ 1,266.43 | |||||||||
| Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | ||||||||||||
| Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | ||||||||||||
| Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | ||||||||||||
| Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | ||||||||||||
| Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | ||||||||||||
| Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | ||||||||||||
| Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | ||||||||||||
| Scientist I | 44 | $ 32.44 | $ 1,427.45 | Scientist I | $ 32.44 | $ - 0 | Scientist I | 10 | $ 32.44 | $ 324.42 | Scientist I | $ 32.44 | $ - 0 | ||||||||||
| Scientist II | 156 | $ 39.96 | $ 6,233.10 | Scientist II | 138 | $ 39.96 | $ 5,513.89 | Scientist II | $ 39.96 | $ - 0 | Scientist II | 30 | $ 39.96 | $ 1,198.67 | |||||||||
| Scientist III | 32 | $ 48.50 | $ 1,552.02 | Scientist III | 90 | $ 48.50 | $ 4,365.06 | Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | ||||||||||
| Field Technician I | $ 22.46 | $ - 0 | Field Technician I | $ 22.46 | $ - 0 | Field Technician I | 310 | $ 22.46 | $ 6,963.13 | Field Technician I | 21 | $ 22.46 | $ 471.70 | ||||||||||
| Field Technician II | $ 25.44 | $ - 0 | Field Technician II | $ 25.44 | $ - 0 | Field Technician II | 231 | $ 25.44 | $ 5,876.87 | Field Technician II | 125 | $ 25.44 | $ 3,180.13 | ||||||||||
| Field Technician III | $ 32.55 | $ - 0 | Field Technician III | $ 32.55 | $ - 0 | Field Technician III | 24 | $ 32.55 | $ 781.11 | Field Technician III | 139 | $ 32.55 | $ 4,523.93 | ||||||||||
| CADD/GIS I | 12 | $ 32.87 | $ 394.44 | CADD/GIS I | 16 | $ 32.87 | $ 525.92 | CADD/GIS I | 5 | $ 32.87 | $ 164.35 | CADD/GIS I | $ 32.87 | $ - 0 | |||||||||
| CADD/GIS II | $ 46.32 | $ - 0 | CADD/GIS II | 8 | $ 46.32 | $ 370.56 | CADD/GIS II | $ 46.32 | $ - 0 | CADD/GIS II | $ 46.32 | $ - 0 | |||||||||||
| Accounting I | 4 | $ 36.31 | $ 145.25 | Accounting I | 2 | $ 36.31 | $ 72.63 | Accounting I | 2 | $ 36.31 | $ 72.63 | Accounting I | 2 | $ 36.31 | $ 72.63 | ||||||||
| Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | ||||||||||||
| Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | 2 | $ 24.92 | $ 49.85 | Administrative Support I | $ 24.92 | $ - 0 | |||||||||||
| Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | ||||||||||||
| Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | ||||||||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ 699.00 | Direct Expenses | $ 7,550.28 | Direct Expenses | $ 16,115.84 | ||||||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ 8,000.00 | ||||||||||||||||
| Overhead | $ 18,824.79 | Overhead | $ 17,347.12 | Overhead | $ 26,267.70 | Overhead | $ 16,783.06 | ||||||||||||||||
| Profit | $ 4,175.13 | Profit | $ 3,847.40 | Profit | $ 5,825.88 | Profit | $ 3,722.29 | ||||||||||||||||
| Total Cost 4.4.2 | $ 35,102.01 | Total Cost 4.4.3 | $ 33,045.64 | Total Cost 4.4.4 | $ 56,530.85 | Total Cost 4.4.5 | $ 55,410.68 | ||||||||||||||||
| 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 | $ 76.01 | $ - 0 | Contract Manager | $ 76.01 | $ - 0 | Contract Manager | $ 76.01 | $ - 0 | Contract Manager | $ 76.01 | $ - 0 | Contract Manager | 2 | $ 76.01 | $ 152.03 | Contract Manager | $ 76.01 | $ - 0 | |||||
| Project Supervisor I | 37 | $ 48.71 | $ 1,802.22 | Project Supervisor I | $ 48.71 | $ - 0 | Project Supervisor I | $ 48.71 | $ - 0 | Project Supervisor I | $ 48.71 | $ - 0 | Project Supervisor I | 91 | $ 48.71 | $ 4,432.49 | Project Supervisor I | 1 | $ 48.71 | $ 48.71 | |||
| Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | 29 | $ 60.06 | $ 1,741.87 | Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | Project Supervisor II | $ 60.06 | $ - 0 | |||||
| Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | Engineer I | $ 42.86 | $ - 0 | ||||||
| Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | Engineer II | $ 56.24 | $ - 0 | ||||||
| Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | Engineer III | $ 70.52 | $ - 0 | ||||||
| Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | ||||||
| Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | Hydrogeologist II | $ - 0 | $ - 0 | ||||||
| Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | Hydrogeologist III | $ - 0 | $ - 0 | ||||||
| Scientist I | 11 | $ 32.44 | $ 356.86 | Scientist I | 70 | $ 32.44 | $ 2,270.94 | Scientist I | 2 | $ 32.44 | $ 64.88 | Scientist I | $ 32.44 | $ - 0 | Scientist I | $ 32.44 | $ - 0 | Scientist I | $ 32.44 | $ - 0 | |||
| Scientist II | $ 39.96 | $ - 0 | Scientist II | 16 | $ 39.96 | $ 639.29 | Scientist II | 126 | $ 39.96 | $ 5,034.43 | Scientist II | 30 | $ 39.96 | $ 1,198.67 | Scientist II | 2 | $ 39.96 | $ 79.91 | Scientist II | $ 39.96 | $ - 0 | ||
| Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | Scientist III | $ 48.50 | $ - 0 | ||||||
| Field Technician I | 140 | $ 22.46 | $ 3,144.64 | Field Technician I | $ 22.46 | $ - 0 | Field Technician I | $ 22.46 | $ - 0 | Field Technician I | $ 22.46 | $ - 0 | Field Technician I | 371 | $ 22.46 | $ 8,333.30 | Field Technician I | 2 | $ 22.46 | $ 44.92 | |||
| Field Technician II | 70 | $ 25.44 | $ 1,780.87 | Field Technician II | 70 | $ 25.44 | $ 1,780.87 | Field Technician II | 158 | $ 25.44 | $ 4,019.68 | Field Technician II | $ 25.44 | $ - 0 | Field Technician II | 474 | $ 25.44 | $ 12,059.03 | Field Technician II | 2 | $ 25.44 | $ 50.88 | |
| Field Technician III | $ 32.55 | $ - 0 | Field Technician III | $ 32.55 | $ - 0 | Field Technician III | $ 32.55 | $ - 0 | Field Technician III | $ 32.55 | $ - 0 | Field Technician III | 434 | $ 32.55 | $ 14,125.09 | Field Technician III | 2 | $ 32.55 | $ 65.09 | ||||
| CADD/GIS I | 4 | $ 32.87 | $ 131.48 | CADD/GIS I | 16 | $ 32.87 | $ 525.92 | CADD/GIS I | 17 | $ 32.87 | $ 558.79 | CADD/GIS I | 4 | $ 32.87 | $ 131.48 | CADD/GIS I | $ 32.87 | $ - 0 | CADD/GIS I | $ 32.87 | $ - 0 | ||
| CADD/GIS II | $ 46.32 | $ - 0 | CADD/GIS II | 4 | $ 46.32 | $ 185.28 | CADD/GIS II | 6 | $ 46.32 | $ 277.92 | CADD/GIS II | $ 46.32 | $ - 0 | CADD/GIS II | $ 46.32 | $ - 0 | CADD/GIS II | $ 46.32 | $ - 0 | ||||
| Accounting I | 2 | $ 36.31 | $ 72.63 | Accounting I | 1 | $ 36.31 | $ 36.31 | Accounting I | 2 | $ 36.31 | $ 72.63 | Accounting I | $ 36.31 | $ - 0 | Accounting I | 2 | $ 36.31 | $ 72.63 | Accounting I | $ 36.31 | $ - 0 | ||
| Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | ||||||
| Administrative Support I | 2 | $ 24.92 | $ 49.85 | Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | $ 24.92 | $ - 0 | Administrative Support I | $ 24.92 | $ - 0 | |||||
| Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | Administrative Support II | $ 26.79 | $ - 0 | ||||||
| Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | Asbestos Inspector | $ - 0 | $ - 0 | ||||||
| Direct Expenses | $ 12,190.59 | Direct Expenses | $ 650.00 | Direct Expenses | $ 3,261.00 | Direct Expenses | $ 127.50 | Direct Expenses | $ 27,963.83 | Direct Expenses | $ 411.50 | ||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | ||||||||||||
| Overhead | $ 11,415.11 | Overhead | $ 8,459.78 | Overhead | $ 18,308.54 | Overhead | $ 2,069.05 | Overhead | $ 61,060.34 | Overhead | $ 326.04 | ||||||||||||
| Profit | $ 2,531.74 | Profit | $ 1,876.28 | Profit | $ 4,060.63 | Profit | $ 458.89 | Profit | $ 13,542.50 | Profit | $ 72.31 | ||||||||||||
| Total Cost 4.4.6 | $ 33,475.99 | Total Cost 4.4.7 | $ 16,424.69 | Total Cost 4.4.8 | $ 37,400.37 | Total Cost 4.4.9 | $ 3,985.60 | Total Cost 4.4.10 | $ 141,821.15 | Total Cost 4.4.10A | $ 1,019.46 |
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 | iPad + GPS | 6 | day | $ 65.00 | $ 390.00 | Prescribed Burn Equipment | 6 | Day | $ 35.00 | $ 210.00 | Skidsteer Auger | 2 | Day | $ 150.00 | $ 300.00 | ||||
| PID Rental | 4 | per day | $ 125.00 | $ 500.00 | $ - 0 | 8.5 x 11 BW Copy | 20 | each | $ 0.15 | $ 3.00 | Water Pump | 1 | Day | $ 52.00 | $ 52.00 | Skidsteer Daily Rental | 2 | Day | $ 750.00 | $ 1,500.00 | ||||
| Sample Jars | 75 | each | $ 3.45 | $ 258.75 | $ - 0 | Standard Mileage | 600 | mile | $ 0.51 | $ 306.00 | Water Tank | 2 | Day | $ 30.00 | $ 60.00 | Water Pump | 16 | Day | $ 52.00 | $ 832.00 | ||||
| Test Blank | 4 | each | $ 7.00 | $ 28.00 | $ - 0 | $ - 0 | Back-Pack Sprayer | 13 | Day | $ 25.00 | $ 325.00 | Water Tank | 16 | Day | $ 30.00 | $ 480.00 | ||||||||
| Trip Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | Chainsaw | 1 | Day | $ 25.00 | $ 25.00 | Back-Pack Sprayer | 20 | Day | $ 25.00 | $ 500.00 | ||||||||
| Dry ice | 6 | per pound | $ 5.75 | $ 34.50 | $ - 0 | $ - 0 | Brush Saw | 33 | Day | $ 27.00 | $ 891.00 | Pesticide (Glyphosate) | 32 | Oz | $ 0.55 | $ 17.60 | ||||||||
| Cooler | 2 | each | $ 12.50 | $ 25.00 | $ - 0 | $ - 0 | Leaf Blower | 2 | Day | $ 27.00 | $ 54.00 | Pesticide (Clopyralid) | 5 | Oz | $ 2.11 | $ 10.55 | ||||||||
| Method Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | Walk Behind Brush Mower | 2 | Day | $ 175.00 | $ 350.00 | Adjuvant (Mineral Oil/MSO) | 24 | Oz | $ 0.18 | $ 4.32 | ||||||||
| Postage | 1 | package | $ 6.75 | $ 6.75 | $ - 0 | $ - 0 | Chipper | 1 | Day | $ 300.00 | $ 300.00 | Adjuvant (Spray Indicator Dye) | 1.5 | Oz | $ 0.58 | $ 0.87 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | Dump Trailer | 1 | Day | $ 300.00 | $ 300.00 | Brush Saw | 4 | Day | $ 27.00 | $ 108.00 | ||||||||||||
| $ - 0 | $ - 0 | $ - 0 | Disposal Fee | 1 | Ton | $ 600.00 | $ 600.00 | iPad/Tablet | 2 | Day | $ 30.00 | $ 60.00 | ||||||||||||
| Total Expenses | $ 918.50 | $ - 0 | $ - 0 | ATV/UTV & Sprayer | 2 | Day | $ 140.00 | $ 280.00 | Truck Mileage | 3100 | Mile | $ 0.51 | $ 1,581.00 | |||||||||||
| $ - 0 | $ - 0 | 8.5x11 B&W Copies | 60 | each | $ 0.15 | $ 9.00 | Truck with load (all trailers) | 6 | Mile | $ 75.00 | $ 450.00 | |||||||||||||
| $ - 0 | $ - 0 | Adjuvant (Spray Indicator Dye) | 49 | Oz. | $ 0.58 | $ 28.42 | Shade Tree (Quercus bicolor, 2.5” DBH) | 5 | Each | $ 320.00 | $ 1,600.00 | |||||||||||||
| $ - 0 | $ - 0 | Adjuvant (Crop Oil) | 92 | Oz. | $ 0.17 | $ 15.64 | Evergreen Tree (Picea pungens, 8 ft tall) | 20 | Each | $ 350.00 | $ 7,000.00 | |||||||||||||
| $ - 0 | $ - 0 | Pesticide (Aminopyralid Florpyrauxifen-Benzyl) | 21 | Oz. | $ 3.22 | $ 67.62 | Replacement Shade Tree | 1 | Each | $ 320.00 | $ 320.00 | |||||||||||||
| $ - 0 | $ - 0 | Pesticide (Aquatic Glyphosate, RoundUp Custom®) | 139 | Oz. | $ 0.50 | $ 69.50 | Replacement Evergreen Tree | 2 | Each | $ 350.00 | $ 700.00 | |||||||||||||
| $ - 0 | $ - 0 | Pesticide (Clopyralid) | 20 | Oz. | $ 2.11 | $ 42.20 | Mulch | 3 | CY | $ 28.00 | $ 84.00 | |||||||||||||
| $ - 0 | $ - 0 | iPad/tablet | 21 | Day | $ 30.00 | $ 630.00 | Compost | 4 | CY | $ 30.00 | $ 120.00 | |||||||||||||
| $ - 0 | $ - 0 | Mileage (Standard) | 4400 | Mile | $ 0.51 | $ 2,244.00 | Guying Kit | 25 | Each | $ 16.00 | $ 400.00 | |||||||||||||
| $ - 0 | $ - 0 | Mileage (Truck w/ Trailer) | 13 | Hour | $ 75.00 | $ 975.00 | Rodent Protection | 25 | Each | $ 1.90 | $ 47.50 | |||||||||||||
| $ - 0 | $ - 0 | Postage | 30 | stamp | $ 0.73 | $ 21.90 | $ - 0 | |||||||||||||||||
| Total Expenses | $ - 0 | Total Expenses | $ 699.00 | Total Expenses | $ 7,550.28 | Total Expenses | $ 16,115.84 |
| 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 |
| Water Pump | 3 | Day | $ 52.00 | $ 156.00 | iPad + GPS | 1 | week | $ 195.00 | $ 195.00 | Ipad/tablet | 5 | day | $ 30.00 | $ 150.00 | mileage | 250 | mile | $ 0.51 | $ 127.50 | Skidsteer with Mulcher (Daily) | 3 | Day | $ 1,200.00 | $ 3,600.00 | Bare Root Shrub (12-18") | 105 | each | $ (1.10) | $ (115.50) |
| Water Tank | 3 | Day | $ 30.00 | $ 90.00 | Sub-soil probe | 5 | day | $ 25.00 | $ 125.00 | Ipad/tablet + GPS | 12 | day | $ 65.00 | $ 780.00 | $ - 0 | Tractor (inlcudes fuel charge) | 1 | Day | $ 300.00 | $ 300.00 | Red Cedar Forestry plugs | 24 | each | $ 3.00 | $ 72.00 | ||||
| Back-Pack Sprayer | 12 | Day | $ 25.00 | $ 300.00 | mileage | 500 | mile | $ 0.51 | $ 255.00 | Hydrology – Water Level Data Logger | 10 | year | $ 200.00 | $ 2,000.00 | $ - 0 | Rotary Mower | 1 | Day | $ 150.00 | $ 150.00 | Containerized Oak Tree (#5) | 7 | each | $ 65.00 | $ 455.00 | ||||
| Brush Saw | 2 | Day | $ 27.00 | $ 54.00 | Misc Traffic Control | 5 | day | $ 15.00 | $ 75.00 | 8.5 x 11 B&W Copy | 100 | each | $ 0.15 | $ 15.00 | $ - 0 | Water Pump | 16 | Day | $ 52.00 | $ 832.00 | $ - 0 | ||||||||
| Tractor | 4 | Day | $ 300.00 | $ 1,200.00 | $ - 0 | 8.5 x 11 Color Copy | 20 | each | $ 0.50 | $ 10.00 | $ - 0 | Water Tank | 16 | Day | $ 30.00 | $ 480.00 | $ - 0 | ||||||||||||
| Tractor - Rotary/Flail Mower | 3 | Day | $ 150.00 | $ 450.00 | $ - 0 | Mileage (standard) | 600 | mile | $ 0.51 | $ 306.00 | $ - 0 | ATV/ UTV Daily | 8 | Day | $ 100.00 | $ 800.00 | $ - 0 | ||||||||||||
| Tractor - Great Plains Drill | 1 | Day | $ 175.00 | $ 175.00 | $ - 0 | $ - 0 | $ - 0 | Sprayer (70 Gallon) Daily | 1 | Day | $ 40.00 | $ 40.00 | $ - 0 | ||||||||||||||||
| ATV/UTV | 3 | Day | $ 100.00 | $ 300.00 | $ - 0 | $ - 0 | $ - 0 | Back-Pack Sprayer | 20 | Day | $ 25.00 | $ 500.00 | $ - 0 | ||||||||||||||||
| ATV/UTV - Sprayer (25 Gallon) | 3 | Day | $ 40.00 | $ 120.00 | $ - 0 | $ - 0 | $ - 0 | Pesticide (Glyphosate) | 252 | Oz | $ 0.55 | $ 138.60 | $ - 0 | ||||||||||||||||
| Annual Rye | 25 | Lb. | $ 1.90 | $ 47.50 | $ - 0 | $ - 0 | $ - 0 | Pesticide (Clopyralid) | 39 | Oz | $ 2.11 | $ 82.29 | $ - 0 | ||||||||||||||||
| Winter Wheat | 100 | Lb. | $ 1.25 | $ 125.00 | $ - 0 | $ - 0 | $ - 0 | Adjuvant (Mineral Oil/ MSO) | 186 | Oz | $ 0.18 | $ 33.48 | $ - 0 | ||||||||||||||||
| Native Seed | 5 | Acres | $ 1,000.00 | $ 5,000.00 | $ - 0 | $ - 0 | $ - 0 | Adjuvant (Spray Indicator Dye) | 12 | Oz | $ 0.58 | $ 6.96 | $ - 0 | ||||||||||||||||
| Adjuvant (Spray Indicator Dye) | 232 | Oz. | $ 0.58 | $ 134.56 | $ - 0 | $ - 0 | $ - 0 | Gas Drill & Soil Auger | 3 | Day | $ 27.00 | $ 81.00 | $ - 0 | ||||||||||||||||
| Adjuvant (Crop Oil) | 464 | Oz. | $ 0.17 | $ 78.88 | $ - 0 | $ - 0 | $ - 0 | Chainsaw | 2 | Day | $ 25.00 | $ 50.00 | $ - 0 | ||||||||||||||||
| Pesticide (2,4-D) | 900 | Oz. | $ 0.32 | $ 288.00 | $ - 0 | $ - 0 | $ - 0 | Brush Cutter | 4 | Day | $ 27.00 | $ 108.00 | $ - 0 | ||||||||||||||||
| Pesticide (Clethodim) | 39 | Oz. | $ 1.99 | $ 77.61 | $ - 0 | $ - 0 | $ - 0 | Truck Mileage | 2600 | Mile | $ 0.51 | $ 1,326.00 | $ - 0 | ||||||||||||||||
| Pesticide (Clopyralid) | 20 | Oz. | $ 2.11 | $ 42.20 | $ - 0 | $ - 0 | $ - 0 | Truck with load (all trailers) | 50 | Hour | $ 75.00 | $ 3,750.00 | $ - 0 | ||||||||||||||||
| Pesticide (Glyphosate) | 1568 | Oz. | $ 0.55 | $ 862.40 | $ - 0 | $ - 0 | $ - 0 | Bare Root Shrub (12-18") | 5,005 | Each | $ 1.10 | $ 5,505.50 | $ - 0 | ||||||||||||||||
| Pesticide (Triclopyramine,Water-Based) | 64 | Oz. | $ 0.81 | $ 51.84 | $ - 0 | $ - 0 | $ - 0 | Weed Barrier Fabric | 6,500 | SY | $ 1.48 | $ 9,620.00 | $ - 0 | ||||||||||||||||
| iPad/tablet | 14 | Day | $ 30.00 | $ 420.00 | $ - 0 | $ - 0 | $ - 0 | Sod Staples (6") | 6,500 | Each | $ 0.04 | $ 260.00 | $ - 0 | ||||||||||||||||
| Mileage (Standard) | 1260 | Mile | $ 0.51 | $ 642.60 | $ - 0 | $ - 0 | $ - 0 | Compost | 10 | CY | $ 30.00 | $ 300.00 | $ - 0 | ||||||||||||||||
| Mileage (Truck w/ Trailer) | 21 | Hour | $ 75.00 | $ 1,575.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| Total Expenses | $ 12,190.59 | Total Expenses | $ 650.00 | Total Expenses | $ 3,261.00 | Total Expenses | $ 127.50 | Total Expenses | $ 27,963.83 | Total Expenses | $ 411.50 |
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 | Tree Care Specialist/Arborist | 4. Tree Pruning | $ 8,000.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 $ 8,000.00
| 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 | ||
| $ 5,000.00 | $ 7,000.00 | $ 14,000.00 | $ 25,000.00 | |||
| Bat Inspection Market Basket (based on 5 year daily request totals) | 59 | 50 | 23 | 21 | $ 1,492,000.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 | $ 24.92 | $ 2,492.26 | $ 3,876.71 | $ 859.81 | $ 7,228.77 |
| Contract Manager | 25 | $ 76.01 | $ 1,900.35 | $ 2,955.99 | $ 655.61 | $ 5,511.95 |
| Project Supervisor I | 25 | $ 48.71 | $ 1,217.72 | $ 1,894.16 | $ 420.10 | $ 3,531.98 |
| CADD/GIS I | 50 | $ 32.87 | $ 1,643.51 | $ 2,556.48 | $ 567.00 | $ 4,766.99 |
| Accounting I | 8 | $ 36.31 | $ 290.50 | $ 451.87 | $ 100.22 | $ 842.60 |
| Total Program Management Assistance Cost | $ 16,272.70 |
| Ecological Services | Cost | Market Basket | Extended Cost |
| 4.4.2 ESA Biological assessment | $ 35,102.01 | 7 | 245714.036648205 |
| 4.4.3 Rare Species Survey | $ 33,045.64 | 130 | 4295933.54320631 |
| 4.4.4 Roadside remnant prairie and invasive species management | $ 56,530.85 | 138 | 7801256.92799695 |
| 4.4.5 Roadside facilities tree management and planting | $ 55,410.68 | 19 | 1052802.98192906 |
| 4.4.6 Roadside facilities prairie management and planting | $ 33,475.99 | 17 | 569091.860451719 |
| 4.4.7 Wetland Delineation | $ 16,424.69 | 214 | 3514883.41069266 |
| 4.4.8 Wetland Monitoring | $ 37,400.37 | 50 | 1870018.64943173 |
| 4.4.9 Stream Features Worksheet | $ 3,985.60 | 5 | 19928.0051893764 |
| 4.4.10 Functional Planting - Large Project | $ 142,840.61 | 51 | 7284871.11910985 |
| Total Ecological Services Cost | $ 26,654,500.53 | ||
| FIRM Name: | Stantec Consulting Services Inc. | ||
| Total Cost | $ 28,162,773.24 |
File details come from the government source that posted it. Updated .