REL _RFP_510574_Cost_table.xlsx
XLSX spreadsheet 76 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 for RFP 510574 submitted by Robert E. Lee & Associates, Inc., appearing to be for a state contract vehicle covering ecological and environmental services. The document contains detailed cost worksheets with instructions for completing hourly rates, classifications, staff hours, direct expenses, and subcontractor costs across multiple service categories. The firm has provided comprehensive pricing for various ecological services including biological assessments, species surveys, prairie management, wetland services, and tree management programs.
The contract covers a broad range of environmental services with specific pricing structures including lump sum costs for bat and asbestos bridge inspections ranging from $400-$1,200 per structure depending on quantity and complexity, hourly rates for professional staff ranging from $18.03 for Field Technician I to $57.03 for Engineer III, and an overhead rate of 175% with an 8.25% profit margin. The total ecological services market basket is valued at approximately $21.9 million, with individual project costs ranging from $3,810 for wetland delineation to $266,368 for large functional planting projects. The proposal includes extensive subcontracting arrangements with companies like Double D Landscape, Inter-Fluve, and Selner Tree & Shrub, with subcontractor costs billed at actual cost without markup. Direct expenses include specialized equipment, materials, and supplies with no markup, while travel reimbursement follows current state rates at $0.51 per mile and standard per diem rates.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Stantec._Cost_Proposal.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: | Robert E. Lee & Associates, 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) | $ 1,100.00 | $ 800.00 | $ 575.00 | $ 400.00 | |
| Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum) | $ 1,200.00 | $ 900.00 | $ 675.00 | $ 500.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 | $55.75 | Average Hourly Rate | |
| Project Supervisor I | $55.75 | Average Hourly Rate | |
| Project Supervisor II | $0.00 | Average Hourly Rate | |
| Engineer I | $35.00 | Average Hourly Rate | |
| Engineer II | $46.12 | Average Hourly Rate | |
| Engineer III | $57.03 | Average Hourly Rate | |
| Hydrogeologist I | $0.00 | Average Hourly Rate | |
| Hydrogeologist II | $35.50 | Average Hourly Rate | |
| Hydrogeologist III | $38.50 | Average Hourly Rate | |
| Scientist I | $24.50 | Average Hourly Rate | |
| Scientist II | $27.98 | Average Hourly Rate | |
| Scientist III | $33.70 | Average Hourly Rate | |
| Field Technician I | $18.03 | Average Hourly Rate | |
| Field Technician II | $21.69 | Average Hourly Rate | |
| Field Technician III | $31.75 | Average Hourly Rate | |
| CADD/GIS I | $26.32 | Average Hourly Rate | |
| CADD/GIS II | $34.75 | Average Hourly Rate | |
| Accounting I | $0.00 | Average Hourly Rate | |
| Accounting II | $0.00 | Average Hourly Rate | |
| Administrative Support I | $24.58 | Average Hourly Rate | |
| Administrative Support II | $38.75 | Average Hourly Rate | |
| Asbestos Inspector | $38.50 | 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 | 175.000% | Percentage of Direct Labor |
| Profit Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | ||
| Proposed Rate | 8.250% | 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.)
Robert E. Lee & Associates, 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: | Natural Resource Scientist IV | Natural Resource Scientist IV | psII1 | Engineer I | Engineer II | Engineer III | hI1 | Geologist II | Geologist III | Natural Resources Scientist I | Natural Resources Scientist II | Natural Resources Scientist III | Natural Resources Techncian I | Natural Resources Technician II | Environmental Technician II | CAD Tech I | CAD Tech II | accI1 | accII1 | Clerical II | Clerical Manager | Geologist III |
| cm2 | psI2 | psII2 | Engineer I | Engineer II | Engineer III | hI2 | hII2 | hIII2 | Natural Resources Scientist I | Natural Resources Scientist II | Natural Resources Scientist III | Natural Resources Techncian I | Natural Resources Technician II | ftIII2 | GIS Tech | CAD Tech II | accI2 | accII2 | Clerical II | admII2 | ai2 | |
| EXAMPLE: | cm3 | psI3 | psII3 | Engineer I | Engineer II | Engineer III | hI3 | hII3 | hIII3 | sI3 | Natural Resources Scientist II | Natural Resources Scientist III | Natural Resources Techncian I | Natural Resources Technician II | ftIII3 | Eng Tech I | GIS Specialist | accI3 | accII3 | admI3 | admII3 | ai3 |
| Rate Title: Scientist I | cm4 | psI4 | psII4 | eI4 | eII4 | Engineer III | hI4 | hII4 | hIII4 | sI4 | sII4 | sIII4 | Natural Resources Techncian I | Natural Resources Technician II | ftIII4 | cadI4 | cadII4 | accI4 | accII4 | admI4 | admII4 | ai4 |
| Classifications included in title: Staff scientist 1 | cm5 | psI5 | psII5 | eI5 | eII5 | eIII5 | hI5 | hII5 | hIII5 | sI5 | sII5 | sIII5 | Natural Resources Techncian I | Natural Resources Technician II | ftIII5 | cadI5 | cadII5 | accI5 | accII5 | admI5 | admII5 | ai5 |
| Arborist | cm6 | psI6 | psII6 | eI6 | eII6 | eIII6 | hI6 | hII6 | hIII6 | sI6 | sII6 | sIII6 | Natural Resources Techncian I | Natural Resources Technician II | ftIII6 | cadI6 | cadII6 | accI6 | accII6 | admI6 | admII6 | ai6 |
| Geologist 1 | cm7 | psI7 | psII7 | eI7 | eII7 | eIII7 | hI7 | hII7 | hIII7 | sI7 | sII7 | sIII7 | Natural Resources Techncian I | Natural Resources Technician II | ftIII7 | cadI7 | cadII7 | accI7 | accII7 | admI7 | admII7 | ai7 |
| Geologist 2 | cm8 | psI8 | psII8 | eI8 | eII8 | eIII8 | hI8 | hII8 | hIII8 | sI8 | sII8 | sIII8 | ftI8 | Eng Tech I | 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
| Robert E. Lee & Associates, 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 | $55.75 | Natural Resource Scientist IV | $ 55.75 | cm2 | cm3 | cm4 | cm5 | cm6 | cm7 | cm8 | cm9 | cm10 | |||||||||
| Project Supervisor I | $55.75 | Natural Resource Scientist IV | $ 55.75 | psI2 | psI3 | psI4 | psI5 | psI6 | psI7 | psI8 | psI9 | psI10 | |||||||||
| Project Supervisor II | $0.00 | psII1 | $ - 0 | psII2 | psII3 | psII4 | psII5 | psII6 | psII7 | psII8 | psII9 | psII10 | |||||||||
| Engineer I | $35.00 | Engineer I | $ 34.25 | Engineer I | $ 31.25 | Engineer I | $ 39.50 | eI4 | eI5 | eI6 | eI7 | eI8 | eI9 | eI10 | |||||||
| Engineer II | $46.12 | Engineer II | $ 48.00 | Engineer II | $ 45.10 | Engineer II | $ 45.25 | eII4 | eII5 | eII6 | eII7 | eII8 | eII9 | eII10 | |||||||
| Engineer III | $57.03 | Engineer III | $ 57.30 | Engineer III | $ 60.75 | Engineer III | $ 52.75 | Engineer III | $ 57.30 | eIII5 | eIII6 | eIII7 | eIII8 | eIII9 | eIII10 | ||||||
| Hydrogeologist I | $0.00 | hI1 | $ - 0 | hI2 | hI3 | hI4 | hI5 | hI6 | hI7 | hI8 | hI9 | hI10 | |||||||||
| Hydrogeologist II | $35.50 | Geologist II | $ 35.50 | hII2 | hII3 | hII4 | hII5 | hII6 | hII7 | hII8 | hII9 | hII10 | |||||||||
| Hydrogeologist III | $38.50 | Geologist III | $ 38.50 | hIII2 | hIII3 | hIII4 | hIII5 | hIII6 | hIII7 | hIII8 | hIII9 | hIII10 | |||||||||
| Scientist I | $24.50 | Natural Resources Scientist I | $ 24.50 | Natural Resources Scientist I | $ 24.50 | sI3 | sI4 | sI5 | sI6 | sI7 | sI8 | sI9 | sI10 | ||||||||
| Scientist II | $27.98 | Natural Resources Scientist II | $ 27.60 | Natural Resources Scientist II | $ 27.60 | Natural Resources Scientist II | $ 28.75 | sII4 | sII5 | sII6 | sII7 | sII8 | sII9 | sII10 | |||||||
| Scientist III | $33.70 | Natural Resources Scientist III | $ 36.10 | Natural Resources Scientist III | $ 33.00 | Natural Resources Scientist III | $ 32.00 | sIII4 | sIII5 | sIII6 | sIII7 | sIII8 | sIII9 | sIII10 | |||||||
| Field Technician I | $18.03 | Natural Resources Techncian I | $ 18.60 | Natural Resources Techncian I | $ 17.50 | Natural Resources Techncian I | $ 17.50 | Natural Resources Techncian I | $ 18.00 | Natural Resources Techncian I | $ 19.00 | Natural Resources Techncian I | $ 17.50 | Natural Resources Techncian I | $ 18.10 | ftI8 | ftI9 | ftI10 | |||
| Field Technician II | $21.69 | Natural Resources Technician II | $ 22.30 | Natural Resources Technician II | $ 22.30 | Natural Resources Technician II | $ 22.30 | Natural Resources Technician II | $ 21.75 | Natural Resources Technician II | $ 19.10 | Natural Resources Technician II | $ 19.10 | Natural Resources Technician II | $ 19.10 | Eng Tech I | $ 27.58 | ftII9 | ftII10 | ||
| Field Technician III | $31.75 | Environmental Technician II | $ 31.75 | ftIII2 | ftIII3 | ftIII4 | ftIII5 | ftIII6 | ftIII7 | ftIII8 | ftIII9 | ftIII10 | |||||||||
| CADD/GIS I | $26.32 | CAD Tech I | $ 25.60 | GIS Tech | $ 25.75 | Eng Tech I | $ 27.60 | cadI4 | cadI5 | cadI6 | cadI7 | cadI8 | cadI9 | cadI10 | |||||||
| CADD/GIS II | $34.75 | CAD Tech II | $ 34.00 | CAD Tech II | $ 38.25 | GIS Specialist | $ 32.00 | cadII4 | cadII5 | cadII6 | cadII7 | cadII8 | cadII9 | cadII10 | |||||||
| Accounting I | $0.00 | accI1 | $ - 0 | accI2 | accI3 | accI4 | accI5 | accI6 | accI7 | accI8 | accI9 | accI10 | |||||||||
| Accounting II | $0.00 | accII1 | $ - 0 | accII2 | accII3 | accII4 | accII5 | accII6 | accII7 | accII8 | accII9 | accII10 | |||||||||
| Administrative Support I | $24.58 | Clerical II | $ 24.25 | Clerical II | $ 24.90 | admI3 | admI4 | admI5 | admI6 | admI7 | admI8 | admI9 | admI10 | ||||||||
| Administrative Support II | $38.75 | Clerical Manager | $ 38.75 | admII2 | admII3 | admII4 | admII5 | admII6 | admII7 | admII8 | admII9 | admII10 | |||||||||
| Asbestos Inspector | $38.50 | Geologist III | $ 38.50 | 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 | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | ||||||||||||
| Project Supervisor I | 16 | $ 55.75 | $ 892.00 | Project Supervisor I | 8 | $ 55.75 | $ 446.00 | Project Supervisor I | 16 | $ 55.75 | $ 892.00 | Project Supervisor I | 10 | $ 55.75 | $ 557.50 | ||||||||
| Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | ||||||||||||
| Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | ||||||||||||
| Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | ||||||||||||
| Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | ||||||||||||
| Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | Hydrogeologist I | $ - 0 | $ - 0 | ||||||||||||
| Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | ||||||||||||
| Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | ||||||||||||
| Scientist I | $ 24.50 | $ - 0 | Scientist I | $ 24.50 | $ - 0 | Scientist I | $ 24.50 | $ - 0 | Scientist I | 9 | $ 24.50 | $ 220.50 | |||||||||||
| Scientist II | $ 27.98 | $ - 0 | Scientist II | $ 27.98 | $ - 0 | Scientist II | 70 | $ 27.98 | $ 1,958.83 | Scientist II | 26 | $ 27.98 | $ 727.57 | ||||||||||
| Scientist III | 66 | $ 33.70 | $ 2,224.20 | Scientist III | 55.5 | $ 33.70 | $ 1,870.35 | Scientist III | 62.5 | $ 33.70 | $ 2,106.25 | Scientist III | 4.5 | $ 33.70 | $ 151.65 | ||||||||
| Field Technician I | $ 18.03 | $ - 0 | Field Technician I | $ 18.03 | $ - 0 | Field Technician I | 36 | $ 18.03 | $ 649.03 | Field Technician I | $ 18.03 | $ - 0 | |||||||||||
| Field Technician II | $ 21.69 | $ - 0 | Field Technician II | $ 21.69 | $ - 0 | Field Technician II | 44 | $ 21.69 | $ 954.41 | Field Technician II | $ 21.69 | $ - 0 | |||||||||||
| Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | ||||||||||||
| CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | ||||||||||||
| CADD/GIS II | $ 34.75 | $ - 0 | CADD/GIS II | 6 | $ 34.75 | $ 208.50 | CADD/GIS II | 10 | $ 34.75 | $ 347.50 | CADD/GIS II | 2 | $ 34.75 | $ 69.50 | |||||||||
| Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | ||||||||||||
| Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | Accounting II | $ - 0 | $ - 0 | ||||||||||||
| Administrative Support I | 4 | $ 24.58 | $ 98.30 | Administrative Support I | 1 | $ 24.58 | $ 24.58 | Administrative Support I | 2 | $ 24.58 | $ 49.15 | Administrative Support I | 1 | $ 24.58 | $ 24.58 | ||||||||
| Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | ||||||||||||
| Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | ||||||||||||
| Direct Expenses | $ - 0 | Direct Expenses | $ 450.00 | Direct Expenses | $ 292.80 | Direct Expenses | $ 41.25 | ||||||||||||||||
| Subcontract | $ 36,478.00 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ 39,770.00 | ||||||||||||||||
| Overhead | $ 5,625.38 | Overhead | $ 4,461.49 | Overhead | $ 12,175.06 | Overhead | $ 3,064.76 | ||||||||||||||||
| Profit | $ 729.29 | Profit | $ 578.40 | Profit | $ 1,578.41 | Profit | $ 397.32 | ||||||||||||||||
| Total Cost 4.4.2 | $ 46,047.16 | Total Cost 4.4.3 | $ 8,039.32 | Total Cost 4.4.4 | $ 21,003.45 | Total Cost 4.4.5 | $ 45,024.63 | ||||||||||||||||
| 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 | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | Contract Manager | $ 55.75 | $ - 0 | ||||||
| Project Supervisor I | 21 | $ 55.75 | $ 1,170.75 | Project Supervisor I | 6 | $ 55.75 | $ 334.50 | Project Supervisor I | 36 | $ 55.75 | $ 2,007.00 | Project Supervisor I | 6 | $ 55.75 | $ 334.50 | Project Supervisor I | 18.5 | $ 55.75 | $ 1,031.38 | Project Supervisor I | 18.5 | $ 55.75 | $ 1,031.38 |
| Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | Project Supervisor II | $ - 0 | $ - 0 | ||||||
| Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | Engineer I | $ 35.00 | $ - 0 | ||||||
| Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | Engineer II | $ 46.12 | $ - 0 | ||||||
| Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 0 | Engineer III | $ 57.03 | $ - 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 | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | Hydrogeologist II | $ 35.50 | $ - 0 | ||||||
| Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | Hydrogeologist III | $ 38.50 | $ - 0 | ||||||
| Scientist I | 20 | $ 24.50 | $ 490.00 | Scientist I | 12.5 | $ 24.50 | $ 306.25 | Scientist I | 78 | $ 24.50 | $ 1,911.00 | Scientist I | $ 24.50 | $ - 0 | Scientist I | 10 | $ 24.50 | $ 245.00 | Scientist I | 10 | $ 24.50 | $ 245.00 | |
| Scientist II | 130 | $ 27.98 | $ 3,637.83 | Scientist II | 17 | $ 27.98 | $ 475.72 | Scientist II | 31.5 | $ 27.98 | $ 881.48 | Scientist II | 11 | $ 27.98 | $ 307.82 | Scientist II | 42 | $ 27.98 | $ 1,175.30 | Scientist II | 42 | $ 27.98 | $ 1,175.30 |
| Scientist III | 42 | $ 33.70 | $ 1,415.40 | Scientist III | $ 33.70 | $ - 0 | Scientist III | 158 | $ 33.70 | $ 5,324.60 | Scientist III | 31.5 | $ 33.70 | $ 1,061.55 | Scientist III | 4.5 | $ 33.70 | $ 151.65 | Scientist III | 4.5 | $ 33.70 | $ 151.65 | |
| Field Technician I | 107 | $ 18.03 | $ 1,929.06 | Field Technician I | $ 18.03 | $ - 0 | Field Technician I | $ 18.03 | $ - 0 | Field Technician I | $ 18.03 | $ - 0 | Field Technician I | $ 18.03 | $ - 0 | Field Technician I | $ 18.03 | $ - 0 | |||||
| Field Technician II | 222 | $ 21.69 | $ 4,815.46 | Field Technician II | $ 21.69 | $ - 0 | Field Technician II | $ 21.69 | $ - 0 | Field Technician II | $ 21.69 | $ - 0 | Field Technician II | 9 | $ 21.69 | $ 195.22 | Field Technician II | 9 | $ 21.69 | $ 195.22 | |||
| Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | Field Technician III | $ 31.75 | $ - 0 | ||||||
| CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | CADD/GIS I | $ 26.32 | $ - 0 | ||||||
| CADD/GIS II | 6 | $ 34.75 | $ 208.50 | CADD/GIS II | 4 | $ 34.75 | $ 139.00 | CADD/GIS II | 12 | $ 34.75 | $ 417.00 | CADD/GIS II | 4 | $ 34.75 | $ 139.00 | CADD/GIS II | 4 | $ 34.75 | $ 139.00 | CADD/GIS II | 4 | $ 34.75 | $ 139.00 |
| Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 0 | Accounting I | $ - 0 | $ - 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 | 1 | $ 24.58 | $ 24.58 | Administrative Support I | 1 | $ 24.58 | $ 24.58 | Administrative Support I | 3 | $ 24.58 | $ 73.73 | Administrative Support I | 1 | $ 24.58 | $ 24.58 | Administrative Support I | 1 | $ 24.58 | $ 24.58 | Administrative Support I | 1 | $ 24.58 | $ 24.58 |
| Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | Administrative Support II | $ 38.75 | $ - 0 | ||||||
| Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | Asbestos Inspector | $ 38.50 | $ - 0 | ||||||
| Direct Expenses | $ 4,364.65 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ - 0 | Direct Expenses | $ 41.25 | Direct Expenses | $ 41.25 | ||||||||||||
| Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ - 0 | Subcontract | $ 124,075.00 | Subcontract | $ 124,575.00 | ||||||||||||
| Overhead | $ 23,960.25 | Overhead | $ 2,240.07 | Overhead | $ 18,575.90 | Overhead | $ 3,268.02 | Overhead | $ 5,183.71 | Overhead | $ 5,183.71 | ||||||||||||
| Profit | $ 3,106.28 | Profit | $ 290.41 | Profit | $ 2,408.23 | Profit | $ 423.68 | Profit | $ 672.03 | Profit | $ 672.03 | ||||||||||||
| Total Cost 4.4.6 | $ 45,122.75 | Total Cost 4.4.7 | $ 3,810.52 | Total Cost 4.4.8 | $ 31,598.93 | Total Cost 4.4.9 | $ 5,559.14 | Total Cost 4.4.10 | $ 132,934.11 | Total Cost 4.4.10A | $ 133,434.11 |
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 | DSLR Camera & Lens Rental | 3 | per day | $ 150.00 | $ 450.00 | AquaNeat - Herbicide | 4 | Gallon | $ 35.00 | $ 140.00 | AquaNeat - Herbicide | 0.5 | Gallon | $ 35.00 | $ 17.50 | ||||
| PID Rental | 4 | per day | $ 125.00 | $ 500.00 | $ - 0 | $ - 0 | Polaris - Herbicide | 1 | Gallon | $ 70.00 | $ 70.00 | Methylated Seed Oil (MSO) | 0.5 | Gallon | $ 20.00 | $ 10.00 | ||||||||
| Sample Jars | 75 | each | $ 3.45 | $ 258.75 | $ - 0 | $ - 0 | Milestone - Herbicide | 5 | Ounce | $ 2.81 | $ 14.05 | AquaMark Blue SS | 0.25 | Gallon | $ 55.00 | $ 13.75 | ||||||||
| Test Blank | 4 | each | $ 7.00 | $ 28.00 | $ - 0 | $ - 0 | Escort - Herbicide | 0.25 | Ounce | $ 5.00 | $ 1.25 | $ - 0 | ||||||||||||
| Trip Blank | 2 | each | $ 7.00 | $ 14.00 | $ - 0 | $ - 0 | Methylated Seed Oil (MSO) | 2 | Gallon | $ 20.00 | $ 40.00 | $ - 0 | ||||||||||||
| Dry ice | 6 | per pound | $ 5.75 | $ 34.50 | $ - 0 | $ - 0 | AquaMark Blue SS | 0.5 | Gallon | $ 55.00 | $ 27.50 | $ - 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 | $ 450.00 | Total Expenses | $ 292.80 | Total Expenses | $ 41.25 |
| 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 |
| AquaNeat - Herbicide | 5 | Gallon | $ 35.00 | $ 175.00 | $ - 0 | $ - 0 | $ - 0 | AquaNeat - Herbicide | 0.5 | Gallon | $ 35.00 | $ 17.50 | AquaNeat - Herbicide | 0.5 | Gallon | $ 35.00 | $ 17.50 | ||||||||||||
| Milestone - Herbicide | 15 | Ounce | $ 2.81 | $ 42.15 | $ - 0 | $ - 0 | $ - 0 | Methylated Seed Oil (MSO) | 0.5 | Gallon | $ 20.00 | $ 10.00 | Methylated Seed Oil (MSO) | 0.5 | Gallon | $ 20.00 | $ 10.00 | ||||||||||||
| Methylated Seed Oil (MSO) | 5.5 | Gallon | $ 20.00 | $ 110.00 | $ - 0 | $ - 0 | $ - 0 | AquaMark Blue SS | 0.25 | Gallon | $ 55.00 | $ 13.75 | AquaMark Blue SS | 0.25 | Gallon | $ 55.00 | $ 13.75 | ||||||||||||
| Prairie Seed Mix | 65 | Pound | $ 60.00 | $ 3,900.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| AquaMark Blue SS | 2.5 | Gallon | $ 55.00 | $ 137.50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||||||
| Total Expenses | $ 4,364.65 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ - 0 | Total Expenses | $ 41.25 | Total Expenses | $ 41.25 |
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 | Inter-Fluve | Agency Coordination & Background Data Collection | $ 2,690.00 | Selner Tree & Shrub | Hazard Tree Assessment | $ 675.00 | ||||||
| Green Drilling | 175' direct push borings | $ 3,550.00 | Inter-Fluve | Pre-Consultation Meeting & Draft BA | $ 28,390.00 | Selner Tree & Shrub | Site Meeting | $ 300.00 | ||||||
| FGH Research | database research | $ 450.00 | Inter-Fluve | Formal Consultation Meeting | $ 3,522.00 | Selner Tree & Shrub | Tree Pruning | $ 3,250.00 | ||||||
| $ 5,745.00 | Inter-Fluve | USFWS Biological Opinion | $ 1,876.00 | Double D Landscape | Tree Planting | $ 28,590.00 | ||||||||
| Double D Landscape | Care Cylces | $ 6,955.00 |
Total Subcontract $ 36,478.00 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ 39,770.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 |
| Double D Landscape | Site Preparation | $ 5,000.00 | Double D Landscape | Site Preparation | $ 5,000.00 | ||||||||||||
| Double D Landscape | Install Living Snowfence | $ 94,075.00 | Double D Landscape | Install Living Snowfence | $ 94,575.00 | ||||||||||||
| Double D Landscape | Care Cycles | $ 25,000.00 | Double D Landscape | Care Cycles | $ 25,000.00 |
Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ 124,075.00 Total Subcontract $ 124,575.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 | ||
| $ 1,100.00 | $ 800.00 | $ 575.00 | $ 400.00 | |||
| Bat Inspection Market Basket (based on 5 year daily request totals) | 59 | 50 | 23 | 21 | $ 126,525.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.58 | $ 2,457.50 | $ 4,300.63 | $ 557.55 | $ 7,315.67 |
| Contract Manager | 25 | $ 55.75 | $ 1,393.75 | $ 2,439.06 | $ 316.21 | $ 4,149.02 |
| Project Supervisor I | 25 | $ 55.75 | $ 1,393.75 | $ 2,439.06 | $ 316.21 | $ 4,149.02 |
| CADD/GIS I | 50 | $ 26.32 | $ 1,315.83 | $ 2,302.71 | $ 298.53 | $ 3,917.07 |
| Accounting I | 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Program Management Assistance Cost | $ 15,613.71 |
| Ecological Services | Cost | Market Basket | Extended Cost |
| 4.4.2 ESA Biological assessment | $ 46,047.16 | 7 | 322330.1528125 |
| 4.4.3 Rare Species Survey | $ 8,039.32 | 130 | 1045111.54109375 |
| 4.4.4 Roadside remnant prairie and invasive species management | $ 21,003.45 | 138 | 2898475.54777411 |
| 4.4.5 Roadside facilities tree management and planting | $ 45,024.63 | 19 | 855467.901223958 |
| 4.4.6 Roadside facilities prairie management and planting | $ 45,122.75 | 17 | 767086.772159449 |
| 4.4.7 Wetland Delineation | $ 3,810.52 | 214 | 815452.143802084 |
| 4.4.8 Wetland Monitoring | $ 31,598.93 | 50 | 1579946.6375 |
| 4.4.9 Stream Features Worksheet | $ 5,559.14 | 5 | 27795.7020572917 |
| 4.4.10 Functional Planting - Large Project | $ 266,368.23 | 51 | 13584779.6990016 |
| Total Ecological Services Cost | $ 21,896,446.10 | ||
| FIRM Name: | Robert E. Lee & Associates, Inc. | ||
| Total Cost | $ 22,038,584.81 |
File details come from the government source that posted it. Updated .