TRC - RFP_510574_Cost_table.xlsx
XLSX spreadsheet 87 KB Posted
- Attached to
- Ecological Services
- Contract number
- 395002-O24-0510574-000
- Issued by
- Wisconsin
About this file
This document is a contract cost worksheet for RFP 510574, submitted by TRC in response to a state procurement for ecological services. The spreadsheet contains detailed pricing structures across multiple tabs including hourly rates, staff classifications, project scenarios, direct expenses, subcontractor costs, and total cost calculations. TRC has provided comprehensive cost breakdowns for various ecological and environmental services that appear to be for a state transportation or environmental agency.
The contract covers a wide range of ecological services including bat and asbestos inspections for bridge structures (ranging from $500-$1,500 per structure depending on complexity and volume), rare species surveys, wetland delineation and monitoring, roadside prairie management, tree management and planting, and functional planting projects. TRC has established 22 different staff classification rate titles with hourly rates ranging from $21.00 for Administrative Support I to $74.50 for Contract Manager and Project Supervisor II positions. The company applies a 172.25% overhead rate and 7% profit margin on labor costs, with no markup on subcontractor costs or direct expenses. The total estimated five-year contract value exceeds $23.5 million, with individual project scenarios ranging from approximately $3,125 for stream features worksheets to over $294,000 for large functional planting projects. The pricing includes provisions for program management assistance and uses a market basket approach for estimating annual service volumes across different ecological service categories.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| REL _RFP_510574_Cost_table.xlsx | XLSX spreadsheet | |
| Stantec._Cost_Proposal.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: | TRC |
| 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) | $ 1,000.00 | $ 950.00 | $ 900.00 | $ 850.00 | |
| Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum | $ 1,500.00 | $ 1,400.00 | $ 1,300.00 | $ 1,200.00 | # The determination of need for confined space entry, or two person team for traffic control, water entry, or other safety considerations will be made by the consultant. |
| Bat inspection of bridges without asbestos inspection (Terms: lump sum) | $ 575.00 | $ 550.00 | $ 525.00 | $ 500.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,100.00 | $ 1,000.00 | $ 950.00 | $ 900.00 | |
| NOTE: Structures 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 | $74.50 | Average Hourly Rate | |
| Project Supervisor I | $67.00 | Average Hourly Rate | |
| Project Supervisor II | $74.50 | Average Hourly Rate | |
| Engineer I | $51.00 | Average Hourly Rate | |
| Engineer II | $57.00 | Average Hourly Rate | |
| Engineer III | $61.00 | Average Hourly Rate | |
| Hydrogeologist I | $41.00 | Average Hourly Rate | |
| Hydrogeologist II | $45.00 | Average Hourly Rate | |
| Hydrogeologist III | $48.00 | Average Hourly Rate | |
| Scientist I | $34.00 | Average Hourly Rate | |
| Scientist II | $37.00 | Average Hourly Rate | |
| Scientist III | $39.00 | Average Hourly Rate | |
| Field Technician I | $26.00 | Average Hourly Rate | |
| Field Technician II | $30.00 | Average Hourly Rate | |
| Field Technician III | $32.00 | Average Hourly Rate | |
| CADD/GIS I | $28.00 | Average Hourly Rate | |
| CADD/GIS II | $35.00 | Average Hourly Rate | |
| Accounting I | $22.00 | Average Hourly Rate | |
| Accounting II | $24.00 | Average Hourly Rate | |
| Administrative Support I | $21.00 | Average Hourly Rate | |
| Administrative Support II | $24.00 | Average Hourly Rate | |
| Asbestos Inspector | $34.20 | 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 | 172.250% | 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.)
TRC Please fill in the actual titles of your staff. Limit 10 titles per classification
| Rate Title: | Contract Manager | Project Supervisor I | Project Supervisor II | Engineer I | Engineer II | Engineer III | Hydrogeologist I | Hydrogeologist II | Hydrogeologist III | Scientist I | Scientist II | Scientist III | Field Technician I | Field Technician II | Field Technician III | CADD/GIS I | CADD/GIS II | Accounting I | Accounting II | Administrative Support I | Administrative Support II | Asbestos Inspector |
| Classifications included in Rate Titles: | Prog Mgr/Sr Tech Mgr 2 | Project / Sr Tech Mgr 1 | Principal/TechDirect1 | Project / Tech Mgr 2 | Project / Tech Mgr 3 | Project / Sr Tech Mgr 4 | Sr Sci/Eng/Specalist 3 | Sr Sci/Eng/Specalist 4 | Project / Tech Mgr 1 | Proj Sci/Eng/ Specalist 3 | Sr Sci/Eng/Specalist 1 | Sr Sci/Eng/Specalist 2 | Sci/Eng/Spec/Tech 6 | Proj Sci/Eng/ Specalist 1 | Proj Sci/Eng/ Specalist 2 | Sci/Eng/Spec/Tech 6 | Proj Sci/Eng/ Specalist 4 | Sci/Eng/Spec/Tech 4 | Sci/Eng/Spec/Tech 5 | Sci/Eng/Spec/Tech 2 | Sci/Eng/Spec/Tech 5 | Proj Sci/Eng/ Specalist 2 |
| Prog Mgr/Sr Tech Mgr 3 | psl2 | Prog Mgr/Sr Tech Mgr 3 | el2 | ell2 | ell2 | hI2 | hII2 | hIII2 | sI2 | sII2 | sIII2 | ftl2 | ftII2 | ftIII2 | cadl2 | cadll2 | accI2 | accII2 | admI2 | admll2 | Proj Sci/Eng/ Specalist 4 | |
| EXAMPLE: | cm3 | psl3 | psll3 | el3 | ell3 | ell3 | hI3 | hII3 | hIII3 | sI3 | sII3 | sIII3 | ftI3 | ftII3 | ftIII3 | cadI3 | cadII3 | accI3 | accII3 | admI3 | admII3 | Sci/Eng/Spec/Tech 6 |
| Rate Title: Scientist I | cm4 | psI4 | psll4 | eI4 | eII4 | eIII4 | hI4 | hII4 | hIII4 | sI4 | sII4 | sIII4 | ftI4 | ftII4 | ftIII4 | cadI4 | cadII4 | accI4 | accII4 | admI4 | admII4 | Sr Sci/Eng/Specalist 3 |
| Classifications included in title: Staff scientist 1 | cm5 | psI5 | psII5 | eI5 | eII5 | eIII5 | hI5 | hII5 | hIII5 | sI5 | sII5 | sIII5 | ftI5 | ftII5 | ftIII5 | cadI5 | cadII5 | accI5 | accII5 | admI5 | admII5 | ai5 |
| Arborist | cm6 | psI6 | psII6 | eI6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | sI6 | sII6 | sIII6 | ftI6 | ftII6 | ftIII6 | cadI6 | cadII6 | accI6 | accII6 | admI6 | admII6 | ai6 |
| Geologist 1 | cm7 | psI7 | psII7 | eI7 | eII7 | eIII7 | hI7 | hII7 | hIII7 | sI7 | sII7 | sIII7 | ftI7 | ftII7 | ftIII7 | cadI7 | cadII7 | accI7 | accII7 | admI7 | admII7 | ai7 |
| Geologist 2 | cm8 | psI8 | psII8 | eI8 | eII8 | eIII8 | hI8 | hII8 | hIII8 | sI8 | sII8 | sIII8 | ftI8 | ftII8 | ftIII8 | cadI8 | cadII8 | accI8 | accII8 | admI8 | admII8 | ai8 |
| Senior Project Technical 1 | cm9 | psI9 | psII9 | eI9 | eII9 | eIII9 | hI9 | hII9 | hIII9 | sI9 | sII9 | sIII9 | ftI9 | ftII9 | ftIII9 | cadI9 | cadII9 | accI9 | accII9 | admI9 | admII9 | ai9 |
| Senior Project Technical 2 | cm10 | psI10 | psII10 | eI10 | eII10 | eIII10 | hI10 | hII10 | hIII10 | sI10 | sII10 | sIII10 | ftI10 | ftII10 | ftIII10 | cadI10 | cadII10 | accI10 | accII10 | admI10 | admII10 | ai10 |
Tab 3 Average Wage Rate Calc
| TRC | Fill in only those cells highlighted in blue. Cells in green are calculated. | Do not alter or change the formulas. |
| Enter the hourly rate for each classification shown |
| 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 | $74.50 | Prog Mgr/Sr Tech Mgr 2 | $ 72.00 | Prog Mgr/Sr Tech Mgr 3 | $ 77.00 | cm3 | cm4 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | ||||||||
| Project Supervisor I | $67.00 | Project / Sr Tech Mgr 1 | $ 67.00 | psl2 | psl3 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | |||||||||
| Project Supervisor II | $74.50 | Principal/TechDirect1 | $ 72.00 | Prog Mgr/Sr Tech Mgr 3 | $ 77.00 | psll3 | $ 72.00 | psll4 | $ 77.00 | psII5 | psII6 | psII7 | psII8 | psII9 | psII10 | ||||||
| Engineer I | $51.00 | Project / Tech Mgr 2 | $ 51.00 | el2 | el3 | eI4 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | |||||||||
| Engineer II | $57.00 | Project / Tech Mgr 3 | $ 57.00 | ell2 | ell3 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||||
| Engineer III | $61.00 | Project / Sr Tech Mgr 4 | $ 61.00 | ell2 | ell3 | eIII4 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | |||||||||
| Hydrogeologist I | $41.00 | Sr Sci/Eng/Specalist 3 | $ 41.00 | hI2 | hI3 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | |||||||||
| Hydrogeologist II | $45.00 | Sr Sci/Eng/Specalist 4 | $ 45.00 | hII2 | hII3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | |||||||||
| Hydrogeologist III | $48.00 | Project / Tech Mgr 1 | $ 48.00 | hIII2 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||||
| Scientist I | $34.00 | Proj Sci/Eng/ Specalist 3 | $ 34.00 | sI2 | sI3 | sI4 | sI5 | sI6 | sI7 | sI8 | sI9 | sI10 | |||||||||
| Scientist II | $37.00 | Sr Sci/Eng/Specalist 1 | $ 37.00 | sII2 | sII3 | sII4 | sII5 | sII6 | sII7 | sII8 | sII9 | sII10 | |||||||||
| Scientist III | $39.00 | Sr Sci/Eng/Specalist 2 | $ 39.00 | sIII2 | sIII3 | sIII4 | sIII5 | sIII6 | sIII7 | sIII8 | sIII9 | sIII10 | |||||||||
| Field Technician I | $26.00 | Sci/Eng/Spec/Tech 6 | $ 26.00 | ftl2 | ftI3 | ftI4 | ftI5 | ftI6 | ftI7 | ftI8 | ftI9 | ftI10 | |||||||||
| Field Technician II | $30.00 | Proj Sci/Eng/ Specalist 1 | $ 30.00 | ftII2 | ftII3 | ftII4 | ftII5 | ftII6 | ftII7 | ftII8 | ftII9 | ftII10 | |||||||||
| Field Technician III | $32.00 | Proj Sci/Eng/ Specalist 2 | $ 32.00 | ftIII2 | ftIII3 | ftIII4 | ftIII5 | ftIII6 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | |||||||||
| CADD/GIS I | $28.00 | Sci/Eng/Spec/Tech 6 | $ 28.00 | cadl2 | cadI3 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||||
| CADD/GIS II | $35.00 | Proj Sci/Eng/ Specalist 4 | $ 35.00 | cadll2 | cadII3 | cadII4 | cadII5 | cadII6 | cadII7 | cadII8 | cadII9 | cadII10 | |||||||||
| Accounting I | $22.00 | Sci/Eng/Spec/Tech 4 | $ 22.00 | accI2 | accI3 | accI4 | accI5 | accI6 | accI7 | accI8 | accI9 | accI10 | |||||||||
| Accounting II | $24.00 | Sci/Eng/Spec/Tech 5 | $ 24.00 | accII2 | accII3 | accII4 | accII5 | accII6 | accII7 | accII8 | accII9 | accII10 | |||||||||
| Administrative Support I | $21.00 | Sci/Eng/Spec/Tech 2 | $ 21.00 | admI2 | admI3 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | |||||||||
| Administrative Support II | $24.00 | Sci/Eng/Spec/Tech 5 | $ 24.00 | admll2 | admII3 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | |||||||||
| Asbestos Inspector | $34.20 | Proj Sci/Eng/ Specalist 2 | $ 30.26 | Proj Sci/Eng/ Specalist 4 | $ 34.89 | Sci/Eng/Spec/Tech 6 | $ 28.06 | Sr Sci/Eng/Specalist 3 | $ 43.58 | 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 | 2 | $ 74.50 | $ 149.00 | Contract Manager | 1 | $ 74.50 | $ 74.50 | Contract Manager | 2 | $ 74.50 | $ 149.00 | Contract Manager | 1 | $ 74.50 | $ 74.50 | ||||||||
| Project Supervisor I | 8 | $ 67.00 | $ 536.00 | Project Supervisor I | 2 | $ 67.00 | $ 134.00 | Project Supervisor I | 8 | $ 67.00 | $ 536.00 | Project Supervisor I | 3 | $ 67.00 | $ 201.00 | ||||||||
| Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | ||||||||||||
| Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | ||||||||||||
| Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | ||||||||||||
| Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | ||||||||||||
| Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | ||||||||||||
| Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | ||||||||||||
| Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | ||||||||||||
| Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | ||||||||||||
| Scientist II | 129 | $ 37.00 | $ 4,773.00 | Scientist II | 4 | $ 37.00 | $ 148.00 | Scientist II | $ 37.00 | $ - 0 | Scientist II | $ 37.00 | $ - 0 | ||||||||||
| Scientist III | 16 | $ 39.00 | $ 624.00 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | |||||||||||
| Field Technician I | 109 | $ 26.00 | $ 2,834.00 | Field Technician I | 122 | $ 26.00 | $ 3,172.00 | Field Technician I | 4 | $ 26.00 | $ 104.00 | Field Technician I | 10 | $ 26.00 | $ 260.00 | ||||||||
| Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | ||||||||||||
| Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | ||||||||||||
| CADD/GIS I | 12 | $ 28.00 | $ 336.00 | CADD/GIS I | 6 | $ 28.00 | $ 168.00 | CADD/GIS I | $ 28.00 | $ - 0 | CADD/GIS I | $ 28.00 | $ - 0 | ||||||||||
| CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | ||||||||||||
| Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | ||||||||||||
| Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | ||||||||||||
| Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | $ 21.00 | $ - 0 | ||||||||||||
| Administrative Support II | 3 | $ 24.00 | $ 72.00 | Administrative Support II | 2 | $ 24.00 | $ 48.00 | Administrative Support II | $ 24.00 | $ - 0 | Administrative Support II | $ 24.00 | $ - 0 | ||||||||||
| Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | ||||||||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ 100.00 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | ||||||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ 24,540.00 | Subcontract | $ 57,700.00 | ||||||||||||||||
| Overhead | $ 16,060.59 | Overhead | $ 6,449.90 | Overhead | $ 1,359.05 | Overhead | $ 922.40 | ||||||||||||||||
| Profit | $ 1,776.92 | Profit | $ 713.61 | Profit | $ 150.36 | Profit | $ 102.05 | ||||||||||||||||
| Total Cost 4.4.2 | $ 27,161.51 | Total Cost 4.4.3 | $ 11,008.01 | Total Cost 4.4.4 | $ 26,838.42 | Total Cost 4.4.5 | $ 59,259.95 | ||||||||||||||||
| 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 | $ 74.50 | $ 74.50 | Contract Manager | 1 | $ 74.50 | $ 74.50 | Contract Manager | 1 | $ 74.50 | $ 74.50 | Contract Manager | 1 | $ 74.50 | $ 74.50 | Contract Manager | 1 | $ 74.50 | $ 74.50 | Contract Manager | 1 | $ 74.50 | $ 74.50 |
| Project Supervisor I | 3 | $ 67.00 | $ 201.00 | Project Supervisor I | 1 | $ 67.00 | $ 67.00 | Project Supervisor I | 3 | $ 67.00 | $ 201.00 | Project Supervisor I | 1 | $ 67.00 | $ 67.00 | Project Supervisor I | 4 | $ 67.00 | $ 268.00 | Project Supervisor I | 4 | $ 67.00 | $ 268.00 |
| Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | Project Supervisor II | $ 74.50 | $ - 0 | ||||||
| Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | Engineer I | $ 51.00 | $ - 0 | ||||||
| Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | Engineer II | $ 57.00 | $ - 0 | ||||||
| Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | Engineer III | $ 61.00 | $ - 0 | ||||||
| Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | 5 | $ 41.00 | $ 205.00 | Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | Hydrogeologist I | $ 41.00 | $ - 0 | |||||
| Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | Hydrogeologist II | $ 45.00 | $ - 0 | ||||||
| Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | Hydrogeologist III | $ 48.00 | $ - 0 | ||||||
| Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | Scientist I | 3 | $ 34.00 | $ 102.00 | Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | Scientist I | $ 34.00 | $ - 0 | |||||
| Scientist II | $ 37.00 | $ - 0 | Scientist II | 1 | $ 37.00 | $ 37.00 | Scientist II | $ 37.00 | $ - 0 | Scientist II | 18 | $ 37.00 | $ 666.00 | Scientist II | $ 37.00 | $ - 0 | Scientist II | $ 37.00 | $ - 0 | ||||
| Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | Scientist III | $ 39.00 | $ - 0 | ||||||
| Field Technician I | 10 | $ 26.00 | $ 260.00 | Field Technician I | 40 | $ 26.00 | $ 1,040.00 | Field Technician I | 68 | $ 26.00 | $ 1,768.00 | Field Technician I | $ 26.00 | $ - 0 | Field Technician I | 10 | $ 26.00 | $ 260.00 | Field Technician I | 10 | $ 26.00 | $ 260.00 | |
| Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | Field Technician II | $ 30.00 | $ - 0 | ||||||
| Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | Field Technician III | $ 32.00 | $ - 0 | ||||||
| CADD/GIS I | $ 28.00 | $ - 0 | CADD/GIS I | 6 | $ 28.00 | $ 168.00 | CADD/GIS I | 8 | $ 28.00 | $ 224.00 | CADD/GIS I | $ 28.00 | $ - 0 | CADD/GIS I | $ 28.00 | $ - 0 | CADD/GIS I | $ 28.00 | $ - 0 | ||||
| CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | 6 | $ 35.00 | $ 210.00 | CADD/GIS II | $ 35.00 | $ - 0 | CADD/GIS II | $ 35.00 | $ - 0 | |||||
| Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | Accounting I | $ 22.00 | $ - 0 | ||||||
| Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | Accounting II | $ 24.00 | $ - 0 | ||||||
| Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | 2 | $ 21.00 | $ 42.00 | Administrative Support I | 1 | $ 21.00 | $ 21.00 | Administrative Support I | $ 21.00 | $ - 0 | Administrative Support I | $ 21.00 | $ - 0 | ||||
| Administrative Support II | $ 24.00 | $ - 0 | Administrative Support II | 2 | $ 24.00 | $ 48.00 | Administrative Support II | $ 24.00 | $ - 0 | Administrative Support II | $ 24.00 | $ - 0 | Administrative Support II | $ 24.00 | $ - 0 | Administrative Support II | $ 24.00 | $ - 0 | |||||
| Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | Asbestos Inspector | $ 34.20 | $ - 0 | ||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ 200.00 | Direct Expenses | $ 200.00 | Direct Expenses | $ 100.00 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | ||||||||||||
| Subcontract | $ 38,400.00 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ 144,500.00 | Subcontract | $ 146,100.00 | ||||||||||||
| Overhead | $ 922.40 | Overhead | $ 2,470.93 | Overhead | $ 4,506.92 | Overhead | $ 1,788.82 | Overhead | $ 1,037.81 | Overhead | $ 1,037.81 | ||||||||||||
| Profit | $ 102.05 | Profit | $ 273.38 | Profit | $ 498.64 | Profit | $ 197.91 | Profit | $ 114.82 | Profit | $ 114.82 | ||||||||||||
| Total Cost 4.4.6 | $ 39,959.95 | Total Cost 4.4.7 | $ 4,378.81 | Total Cost 4.4.8 | $ 7,822.06 | Total Cost 4.4.9 | $ 3,125.23 | Total Cost 4.4.10 | $ 146,255.13 | Total Cost 4.4.10A | $ 147,855.13 |
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 & Tablet | 1 | Day | $ 100.00 | $ 100.00 | $ - 0 | $ - 0 | ||||||||||||
| PID Rental | 4 | per day | $ 125.00 | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Sample Jars | 75 | each | $ 3.45 | $ 258.75 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Test Blank | 4 | each | $ 7.00 | $ 28.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Trip Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Dry ice | 6 | per pound | $ 5.75 | $ 34.50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Cooler | 2 | each | $ 12.50 | $ 25.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||
| Method Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 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 | ||||||||||||||||||||
| 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 | $ 100.00 | Total Expenses | $ - 0 | Total Expenses | $ - 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 | ||||||||||||||||||||||||
| 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 |
| $ - 0 | GPS & Tablet | 2 | Day | $ 100.00 | $ 200.00 | GPS & Tablet | 2 | Day | $ 100.00 | $ 200.00 | GPS & Tablet | 1 | Day | $ 100.00 | $ 100.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 | $ - 0 | Total Expenses | $ 200.00 | Total Expenses | $ 200.00 | Total Expenses | $ 100.00 | Total Expenses | $ - 0 | Total Expenses | $ - 0 |
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 | Heartland Ecological Group | Project Management, and Health and Safety Plan | $1,855.00 | RES | Health and Safety Plan | $ 300.00 | ||||||
| Green Drilling | 175' direct push borings | $ 3,550.00 | Heartland Ecological Group | Site Assessment | $1,870.00 | RES | Partner Communication Plan | $ 800.00 | ||||||
| FGH Research | database research | $ 450.00 | Heartland Ecological Group | Adaptive Management Plan | $2,815.00 | RES | Installation of 5 2.5" DBH Swamp White Oaks | $ 4,600.00 | ||||||
| $ 5,745.00 | Heartland Ecological Group | Vegetation Management- Year 1 | $18,000.00 | RES | Installation of 20 eight-foot tall Green Spruce | $ 18,200.00 | ||||||||
| RES | 26 Care Cyle Events | $ 21,300.00 | ||||||||||||
| RES | Existing Tree Health and Hazard Evaluation | $ 2,700.00 | ||||||||||||
| RES | Pruning Existing 16 Trees | $ 5,200.00 | ||||||||||||
| RES | Two Replacement Inspections | $ 1,100.00 | ||||||||||||
| RES | Project Management | $ 3,500.00 |
Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ 24,540.00 Total Subcontract $ 57,700.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 |
| RES | Health and Safety Plan | $ 3,000.00 | RES | Health and Safety Plan | $ 300.00 | RES | Health and Safety Plan | $ 300.00 | |||||||||
| RES | Partner Communication Plan | $ 800.00 | RES | Partner Communication Plan | $ 800.00 | RES | Partner Communication Plan | $ 800.00 | |||||||||
| RES | Site Preperation | $ 5,500.00 | RES | Site Preparation | $ 13,600.00 | RES | Site Preparation | $ 13,600.00 | |||||||||
| RES | Native Prairie Intallation | $ 1,600.00 | RES | Living Snow Fence Install | $ 77,800.00 | RES | Living Snow Fence Install | $ 77,400.00 | |||||||||
| RES | 3-Year Establishment Period | $ 23,000.00 | RES | 26 Care Cycles | $ 33,500.00 | RES | Oak Tree Install(3-5 gallon container) | $ 1,100.00 | |||||||||
| RES | Project Management/Supervision | $ 4,500.00 | RES | Replacement Inspections | $ 1,200.00 | RES | Red Cedars Install (forestry plugs) | $ 400.00 | |||||||||
| RES | Spring Replacement Plantings | $ 6,100.00 | RES | 26 Care Cycles | $ 33,500.00 | ||||||||||||
| RES | Project Management/Supervision | $ 11,200.00 | RES | Replacement Inspections | $ 1,200.00 | ||||||||||||
| RES | Spring Replacement Plantings | $ 6,600.00 | |||||||||||||||
| RES | Project Management/Supervision | $ 11,200.00 |
Total Subcontract $ 38,400.00 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ 144,500.00 Total Subcontract $ 146,100.00
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 | ||
| $ 575.00 | $ 550.00 | $ 525.00 | $ 500.00 | |||
| Bat Inspection Market Basket (based on 5 year daily request totals) | 59 | 50 | 23 | 21 | $ 84,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 | $ 21.00 | $ 2,100.00 | $ 3,617.25 | $ 400.21 | $ 6,117.46 |
| Contract Manager | 25 | $ 74.50 | $ 1,862.50 | $ 3,208.16 | $ 354.95 | $ 5,425.60 |
| Project Supervisor I | 25 | $ 67.00 | $ 1,675.00 | $ 2,885.19 | $ 319.21 | $ 4,879.40 |
| CADD/GIS I | 50 | $ 28.00 | $ 1,400.00 | $ 2,411.50 | $ 266.81 | $ 4,078.31 |
| Accounting I | 8 | $ 22.00 | $ 176.00 | $ 303.16 | $ 33.54 | $ 512.70 |
| Total Program Management Assistance Cost | $ 16,422.46 |
| Ecological Services | Cost | Market Basket | Extended Cost |
| 4.4.2 ESA Biological assessment | $ 27,161.51 | 7 | 190130.5791 |
| 4.4.3 Rare Species Survey | $ 11,008.01 | 130 | 1431041.213875 |
| 4.4.4 Roadside remnant prairie and invasive species management | $ 26,838.42 | 138 | 3703701.43215 |
| 4.4.5 Roadside facilities tree management and planting | $ 59,259.95 | 19 | 1125939.0815875 |
| 4.4.6 Roadside facilities prairie management and planting | $ 39,959.95 | 17 | 679319.1782625 |
| 4.4.7 Wetland Delineation | $ 4,378.81 | 214 | 937064.502725 |
| 4.4.8 Wetland Monitoring | $ 7,822.06 | 50 | 391103.036875 |
| 4.4.9 Stream Features Worksheet | $ 3,125.23 | 5 | 15626.1419375 |
| 4.4.10 Functional Planting - Large Project | $ 294,110.26 | 51 | 14999623.024125 |
| Total Ecological Services Cost | $ 23,473,548.19 | ||
| FIRM Name: | TRC | ||
| Total Cost | $ 23,573,970.65 |
File details come from the government source that posted it. Updated .