Cost_table_- Merjent.xlsx

XLSX spreadsheet 77 KB Posted Jan 1, 2025

Attached to: Ecological Services
Contract number: 395002-O24-0510574-000
Issued by: Wisconsin

About this file

Written by GovTribe AI · Aug 7, 2025

This document is a contract cost worksheet and price proposal from Merjent submitted in response to RFP 510574, which appears to be a state contract vehicle for ecological and environmental services. The document contains detailed pricing structures across multiple service categories including bat and asbestos inspections for bridges, ecological assessments, rare species surveys, wetland services, and various environmental management activities. Merjent has structured their proposal with 22 different rate classifications ranging from field technicians to contract managers, with hourly rates spanning from $24.04 for Field Technician I to $93.84 for Engineer III positions.

The contract encompasses a comprehensive range of environmental services with both lump sum and hourly rate pricing structures. Bridge inspection services are priced on a tiered system, with combined bat and asbestos inspections ranging from $10,900 to $13,970 per structure depending on project size, while bat-only inspections range from $5,900 to $7,470 per structure. The proposal includes detailed cost breakdowns for ten specific project scenarios covering ecological assessments, prairie management, wetland delineation and monitoring, and large-scale functional planting projects. Merjent applies a 123.64% overhead rate and 12% profit margin to direct labor costs, with no markup on subcontractor costs or direct expenses. The total estimated annual contract value across all service categories reaches approximately $17.95 million, with the largest component being ecological services at $16.89 million and bat inspection services at $1.04 million based on projected annual demand.

View the file

Other files

File	Type	Posted
GEI_CostProposal_510574.xlsx	XLSX spreadsheet	Jan 1, 2025
REL _RFP_510574_Cost_table.xlsx	XLSX spreadsheet	Jan 1, 2025
Stantec._Cost_Proposal.xlsx	XLSX spreadsheet	Jan 1, 2025
TRC - RFP_510574_Cost_table.xlsx	XLSX spreadsheet	Jan 1, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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:	Merjent
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)	$ 13,970.00	$ 11,685.00	$ 11,285.00	$ 10,900.00
Asbestos and Bat inspection - Confined Space or Two Person project (for traffic control, water entry or other safety considerations)# Terms: Lump Sum	$ 14,970.00	$ 12,685.00	$ 12,285.00	$ 11,900.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)	$ 7,470.00	$ 6,685.00	$ 6,285.00	$ 5,900.00
Bat inspection of bridges without asbestos inspection - Confined space # (Terms: lump sum)	$ 7,470.00	$ 6,685.00	$ 6,285.00	$ 5,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	$89.90	Average Hourly Rate
Project Supervisor I	$57.46	Average Hourly Rate
Project Supervisor II	$73.72	Average Hourly Rate
Engineer I	$36.07	Average Hourly Rate
Engineer II	$61.98	Average Hourly Rate
Engineer III	$93.84	Average Hourly Rate
Hydrogeologist I	$38.37	Average Hourly Rate
Hydrogeologist II	$45.05	Average Hourly Rate
Hydrogeologist III	$50.92	Average Hourly Rate
Scientist I	$25.41	Average Hourly Rate
Scientist II	$28.37	Average Hourly Rate
Scientist III	$33.21	Average Hourly Rate
Field Technician I	$24.04	Average Hourly Rate
Field Technician II	$28.37	Average Hourly Rate
Field Technician III	$36.32	Average Hourly Rate
CADD/GIS I	$49.66	Average Hourly Rate
CADD/GIS II	$65.43	Average Hourly Rate
Accounting I	$33.70	Average Hourly Rate
Accounting II	$47.71	Average Hourly Rate
Administrative Support I	$33.70	Average Hourly Rate
Administrative Support II	$47.71	Average Hourly Rate
Asbestos Inspector	$49.10	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	123.640%	Percentage of Direct Labor
Profit Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses
Proposed Rate	12.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.)

Merjent 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:

EC9/RC9/NRS9.1

EC5/RC5/NRS5.1

EC7/RC7/NRS7.1

Eng Tech I 1

Eng Tech III/Eng II 1

Eng V/Eng PM II 1

EC3/RC3/NRS3.1

EC4/RC4/NRS4.1

NRT10.1

EC1/RC1/NRS1.1

NRT5.1

EC2/RC2/NRS2.1

RT3.1

RT5.1

RT7.1

EC4/NRS4.1

EC6/NRS6.1

EC2

EC4

EC2

EC4

EC2

NRS9.2

NRS5.2

NRS7.2

Eng Tech I 2

Eng Tech III/Eng II 2

Eng V/Eng PM II 2

NRS3.2

NRS4.2

NRT10.2

NRS1.2

NRT5.2

NRS2.2

RT3.2

RT5.2

RT7.2

NRS4.2

NRS6.2

EC3

EC5

EC3

EC5

EC3

EXAMPLE:

Principal

EC6/RC6/NRS6.1

EC8/RC8/NRS8.1

Eng Tech I 3

Eng Tech III/Eng II 3

Eng V/Eng PM II 3

NRT8.1

NRT9.1/RT9.1

NRT10.3

NRT4.1

NRT6.1

NRT7.1

RT4.1

RT6.1

RT8.1

EC5/NRS5.1

EC7/NRS7.1

EC4/NRS4.1

Rate Title: Scientist I

NRS6.2

NRS8.2

Eng Tech II/Eng I 1

Eng Tech IV/Eng III/Eng PM I 1

Eng VI/Eng PM III 1

NRT8.2

NRT9.2/RT9.2

NRT4.2

NRT6.2

NRT7.2

RT4.2

RT6.2

RT8.2

NRS5.2

NRS7.2

NRS4.2

Classifications included in title: Staff scientist 1

Eng Tech II/Eng I 2

Eng Tech IV/Eng III/Eng PM I 2

Eng VI/Eng PM III 2

NRT9.3

EC5/NRS5.1

Arborist

Eng Tech II/Eng I 3

Eng Tech IV/Eng III/Eng PM I 3

Eng VI/Eng PM III 3

NRS5.2

Geologist 1

Sr Eng Tech/Eng IV 1

Sr Eng/Sr Eng PM 1

EC6

Geologist 2

Sr Eng Tech/Eng IV 2

Sr Eng/Sr Eng PM 2

EC7

Senior Project Technical 1

Sr Eng Tech/Eng IV 3

Sr Eng/Sr Eng PM 3

Senior Project Technical 2

Tab 3 Average Wage Rate Calc

Merjent	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	$89.90	EC9/RC9/NRS9.1	$ 84.93	NRS9.2	$ 86.58	Principal	$ 98.20	0		0		0		0		0		0		0
Project Supervisor I	$57.46	EC5/RC5/NRS5.1	$ 52.04	NRS5.2	$ 55.49	EC6/RC6/NRS6.1	$ 58.93	NRS6.2	$ 63.38	0		0		0		0		0		0
Project Supervisor II	$73.72	EC7/RC7/NRS7.1	$ 67.84	NRS7.2	$ 71.56	EC8/RC8/NRS8.1	$ 75.27	NRS8.2	$ 80.22	0		0		0		0		0		0
Engineer I	$36.07	Eng Tech I 1	$ 29.09	Eng Tech I 2	$ 31.26	Eng Tech I 3	$ 33.43	Eng Tech II/Eng I 1	$ 38.38	Eng Tech II/Eng I 2	$ 40.88	Eng Tech II/Eng I 3	$ 43.38	0		0		0		0
Engineer II	$61.98	Eng Tech III/Eng II 1	$ 48.28	Eng Tech III/Eng II 2	$ 50.76	Eng Tech III/Eng II 3	$ 53.23	Eng Tech IV/Eng III/Eng PM I 1	$ 58.19	Eng Tech IV/Eng III/Eng PM I 2	$ 62.02	Eng Tech IV/Eng III/Eng PM I 3	$ 65.86	Sr Eng Tech/Eng IV 1	$ 70.81	Sr Eng Tech/Eng IV 2	$ 73.16	Sr Eng Tech/Eng IV 3	$ 75.52	0
Engineer III	$93.84	Eng V/Eng PM II 1	$ 80.47	Eng V/Eng PM II 2	$ 82.94	Eng V/Eng PM II 3	$ 85.42	Eng VI/Eng PM III 1	$ 90.37	Eng VI/Eng PM III 2	$ 93.47	Eng VI/Eng PM III 3	$ 96.56	Sr Eng/Sr Eng PM 1	$ 101.51	Sr Eng/Sr Eng PM 2	$ 105.10	Sr Eng/Sr Eng PM 3	$ 108.69	0
Hydrogeologist I	$38.37	EC3/RC3/NRS3.1	$ 36.50	NRS3.2	$ 39.94	NRT8.1	$ 37.48	NRT8.2	$ 39.55	0		0		0		0		0		0
Hydrogeologist II	$45.05	EC4/RC4/NRS4.1	$ 43.38	NRS4.2	$ 47.71	NRT9.1/RT9.1	$ 42.65	NRT9.2/RT9.2	$ 44.72	NRT9.3	$ 46.79	0		0		0		0		0
Hydrogeologist III	$50.92	NRT10.1	$ 48.85	NRT10.2	$ 50.92	NRT10.3	$ 52.99	0		0		0		0		0		0		0
Scientist I	$25.41	EC1/RC1/NRS1.1	$ 24.02	NRS1.2	$ 27.46	NRT4.1	$ 24.56	NRT4.2	$ 25.59	0		0		0		0		0		0
Scientist II	$28.37	NRT5.1	$ 26.62	NRT5.2	$ 27.92	NRT6.1	$ 28.95	NRT6.2	$ 29.98	0		0		0		0		0		0
Scientist III	$33.21	EC2/RC2/NRS2.1	$ 30.90	NRS2.2	$ 33.70	NRT7.1	$ 33.09	NRT7.2	$ 35.15	0		0		0		0		0		0
Field Technician I	$24.04	RT3.1	$ 22.49	RT3.2	$ 23.52	RT4.1	$ 24.56	RT4.2	$ 25.59	0		0		0		0		0		0
Field Technician II	$28.37	RT5.1	$ 26.62	RT5.2	$ 27.92	RT6.1	$ 28.95	RT6.2	$ 29.98	0		0		0		0		0		0
Field Technician III	$36.32	RT7.1	$ 33.09	RT7.2	$ 35.15	RT8.1	$ 37.48	RT8.2	$ 39.55	0		0		0		0		0		0
CADD/GIS I	$49.66	EC4/NRS4.1	$ 43.38	NRS4.2	$ 47.71	EC5/NRS5.1	$ 52.04	NRS5.2	$ 55.49	0		0		0		0		0		0
CADD/GIS II	$65.43	EC6/NRS6.1	$ 58.93	NRS6.2	$ 63.38	EC7/NRS7.1	$ 67.84	NRS7.2	$ 71.56	0		0		0		0		0		0
Accounting I	$33.70	EC2	$ 30.90	EC3	$ 36.50	0		0		0		0		0		0		0		0
Accounting II	$47.71	EC4	$ 43.38	EC5	$ 52.04	0		0		0		0		0		0		0		0
Administrative Support I	$33.70	EC2	$ 30.90	EC3	$ 36.50	0		0		0		0		0		0		0		0
Administrative Support II	$47.71	EC4	$ 43.38	EC5	$ 52.04	0		0		0		0		0		0		0		0
Asbestos Inspector	$49.10	EC2	$ 30.90	EC3	$ 36.50	EC4/NRS4.1	$ 43.38	NRS4.2	$ 47.71	EC5/NRS5.1	$ 52.04	NRS5.2	$ 55.49	EC6	$ 58.93	EC7	$ 67.84	0		0

Tab 4 Staff Hours

For each Proposer Solution (Section 4.4) enter the number of hours per Rate Title. Total Direct Expenses and Subcontractors will be entered on subsequent tabs.

Fill in only those cells highlighted in blue. Cells in green are calculated.

There are 10 scenarios to provide Staff Hours information for: 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7, 4.4.8, 4.4.9, 4.4.10, and 4.4.10A

4.4.2 ESA Biological assessment				4.4.3 Rare Species Survey				4.4.4 Roadside remnant prairie and invasive species management				4.4.5 Roadside facilities tree management and planting
Classification	Total Number of Hours	Rate	Total Cost	Classification	Total Number of Hours	Rate	Total Cost	Classification	Total Number of Hours	Rate	Total Cost	Classification	Total Number of Hours	Rate	Total Cost
Contract Manager	3	$ 89.90	$ 269.71	Contract Manager	1	$ 89.90	$ 89.90	Contract Manager	3	$ 89.90	$ 269.71	Contract Manager	4	$ 89.90	$ 359.61
Project Supervisor I	167	$ 57.46	$ 9,595.97	Project Supervisor I	30	$ 57.46	$ 1,723.83	Project Supervisor I	21	$ 57.46	$ 1,206.68	Project Supervisor I	24	$ 57.46	$ 1,379.06
Project Supervisor II	85	$ 73.72	$ 6,266.32	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0
Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0
Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0
Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0
Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0
Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II	12	$ 45.05	$ 540.60	Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II		$ 45.05	$ - 0
Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0
Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0
Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0
Scientist III		$ 33.21	$ - 0	Scientist III		$ 33.21	$ - 0	Scientist III	19	$ 33.21	$ 630.99	Scientist III	46	$ 33.21	$ 1,527.65
Field Technician I		$ 24.04	$ - 0	Field Technician I		$ 24.04	$ - 0	Field Technician I	148	$ 24.04	$ 3,557.92	Field Technician I	184	$ 24.04	$ 4,423.36
Field Technician II		$ 28.37	$ - 0	Field Technician II		$ 28.37	$ - 0	Field Technician II	68	$ 28.37	$ 1,928.99	Field Technician II	176	$ 28.37	$ 4,992.68
Field Technician III		$ 36.32	$ - 0	Field Technician III		$ 36.32	$ - 0	Field Technician III	12	$ 36.32	$ 435.81	Field Technician III	56	$ 36.32	$ 2,033.78
CADD/GIS I	15	$ 49.66	$ 744.83	CADD/GIS I	6	$ 49.66	$ 297.93	CADD/GIS I	7	$ 49.66	$ 347.59	CADD/GIS I	4	$ 49.66	$ 198.62
CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0
Accounting I		$ 33.70	$ - 0	Accounting I		$ 33.70	$ - 0	Accounting I	1	$ 33.70	$ 33.70	Accounting I	2	$ 33.70	$ 67.40
Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0
Administrative Support I		$ 33.70	$ - 0	Administrative Support I	3	$ 33.70	$ 101.10	Administrative Support I		$ 33.70	$ - 0	Administrative Support I		$ 33.70	$ - 0
Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0
Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0
		Direct Expenses	$ - 0			Direct Expenses	$ 151.00			Direct Expenses	$ 4,200.00			Direct Expenses	$ 27,350.00
		Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0
		Overhead	$ 20,866.51			Overhead	$ 3,404.25			Overhead	$ 10,399.83			Overhead	$ 18,523.95
		Profit	$ 4,529.20			Profit	$ 738.91			Profit	$ 2,257.35			Profit	$ 4,020.73
		Total Cost 4.4.2	$ 42,272.54			Total Cost 4.4.3	$ 7,047.52			Total Cost 4.4.4	$ 25,268.56			Total Cost 4.4.5	$ 64,876.85
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	5	$ 89.90	$ 449.52	Contract Manager	1	$ 89.90	$ 89.90	Contract Manager	8	$ 89.90	$ 719.23	Contract Manager	1	$ 89.90	$ 89.90	Contract Manager	5	$ 89.90	$ 449.52	Contract Manager		$ 89.90	$ - 0
Project Supervisor I	10	$ 57.46	$ 574.61	Project Supervisor I	7	$ 57.46	$ 402.23	Project Supervisor I		$ 57.46	$ - 0	Project Supervisor I	6	$ 57.46	$ 344.77	Project Supervisor I	23	$ 57.46	$ 1,321.60	Project Supervisor I		$ 57.46	$ - 0
Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0	Project Supervisor II		$ 73.72	$ - 0
Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0	Engineer I	20	$ 36.07	$ 721.37	Engineer I		$ 36.07	$ - 0	Engineer I		$ 36.07	$ - 0
Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0	Engineer II		$ 61.98	$ - 0
Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0	Engineer III		$ 93.84	$ - 0
Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I	138	$ 38.37	$ 5,294.63	Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0	Hydrogeologist I		$ 38.37	$ - 0
Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II	10	$ 45.05	$ 450.50	Hydrogeologist II		$ 45.05	$ - 0	Hydrogeologist II		$ 45.05	$ - 0
Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0	Hydrogeologist III		$ 50.92	$ - 0
Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0	Scientist I		$ 25.41	$ - 0
Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0	Scientist II		$ 28.37	$ - 0
Scientist III	28	$ 33.21	$ 929.88	Scientist III	72.5	$ 33.21	$ 2,407.71	Scientist III	122	$ 33.21	$ 4,051.60	Scientist III		$ 33.21	$ - 0	Scientist III	63	$ 33.21	$ 2,092.22	Scientist III	1	$ 33.21	$ 33.21
Field Technician I	14	$ 24.04	$ 336.56	Field Technician I		$ 24.04	$ - 0	Field Technician I		$ 24.04	$ - 0	Field Technician I		$ 24.04	$ - 0	Field Technician I	720	$ 24.04	$ 17,308.80	Field Technician I	3	$ 24.04	$ 72.12
Field Technician II	67	$ 28.37	$ 1,900.62	Field Technician II		$ 28.37	$ - 0	Field Technician II		$ 28.37	$ - 0	Field Technician II		$ 28.37	$ - 0	Field Technician II	412	$ 28.37	$ 11,687.41	Field Technician II	3	$ 28.37	$ 85.10
Field Technician III	7	$ 36.32	$ 254.22	Field Technician III		$ 36.32	$ - 0	Field Technician III		$ 36.32	$ - 0	Field Technician III		$ 36.32	$ - 0	Field Technician III	148	$ 36.32	$ 5,374.99	Field Technician III		$ 36.32	$ - 0
CADD/GIS I	8	$ 49.66	$ 397.24	CADD/GIS I	5	$ 49.66	$ 248.28	CADD/GIS I	20	$ 49.66	$ 993.11	CADD/GIS I	5	$ 49.66	$ 248.28	CADD/GIS I	6	$ 49.66	$ 297.93	CADD/GIS I	0.5	$ 49.66	$ 24.83
CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0	CADD/GIS II		$ 65.43	$ - 0
Accounting I	3	$ 33.70	$ 101.10	Accounting I		$ 33.70	$ - 0	Accounting I		$ 33.70	$ - 0	Accounting I		$ 33.70	$ - 0	Accounting I	2	$ 33.70	$ 67.40	Accounting I		$ 33.70	$ - 0
Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0	Accounting II		$ 47.71	$ - 0
Administrative Support I		$ 33.70	$ - 0	Administrative Support I	3	$ 33.70	$ 101.10	Administrative Support I		$ 33.70	$ - 0	Administrative Support I	3	$ 33.70	$ 101.10	Administrative Support I		$ 33.70	$ - 0	Administrative Support I		$ 33.70	$ - 0
Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0	Administrative Support II		$ 47.71	$ - 0
Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0	Asbestos Inspector		$ 49.10	$ - 0
		Direct Expenses	$ 8,535.00			Direct Expenses	$ 704.50			Direct Expenses	$ 1,533.60			Direct Expenses	$ 267.50			Direct Expenses	$ 43,880.00			Direct Expenses	$ 500.00
		Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0			Subcontract	$ - 0
		Overhead	$ 6,112.45			Overhead	$ 4,017.33			Overhead	$ 13,672.80			Overhead	$ 2,418.29			Overhead	$ 47,724.88			Overhead	$ 266.15
		Profit	$ 1,326.74			Profit	$ 871.99			Profit	$ 2,967.76			Profit	$ 524.90			Profit	$ 10,358.97			Profit	$ 57.77
		Total Cost 4.4.6	$ 20,917.94			Total Cost 4.4.7	$ 8,843.04			Total Cost 4.4.8	$ 29,232.72			Total Cost 4.4.9	$ 5,166.61			Total Cost 4.4.10	$ 140,563.71			Total Cost 4.4.10A	$ 1,039.18

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	Mileage	100	per mile	$ 0.51	$ 51.00	Crew Truck	7	Per Day	$ 210.00	$ 1,470.00	Crew Truck	21	Per Day	$ 210.00	$ 4,410.00
PID Rental	4	per day	$ 125.00	$ 500.00					$ - 0	Breakfast		Unit	$ 10.00	$ - 0	Enclosed Trailer	4	Per Day	$ 60.00	$ 240.00	Equipment Trailer	7	Per Day	$ 100.00	$ 700.00
Sample Jars	75	each	$ 3.45	$ 258.75					$ - 0	Lunch		Unit	$ 12.00	$ - 0	Dump Trailer	1	Per Day	$ 60.00	$ 60.00	Skid Steer	5	Per Day	$ 380.00	$ 1,900.00
Test Blank	4	each	$ 7.00	$ 28.00					$ - 0	Dinner		Unit	$ 23.00	$ - 0	UTV	4	Per Day	$ 170.00	$ 680.00	Skid Steer Auger	2	Per Day	$ 140.00	$ 280.00
Trip Blank	2	each	$ 7.00	$ 14.00					$ - 0	GPS	2	Unit	$ 50.00	$ 100.00	UTV Skid Sprayer	3	Per Day	$ 60.00	$ 180.00	Skid Steep Grapple	2	Per Day	$ 140.00	$ 280.00
Dry ice	6	per pound	$ 5.75	$ 34.50					$ - 0	Lodging Per Diem		per night	$ 98.00	$ - 0	Bruschcutter	3	Per Day	$ 30.00	$ 90.00	Chainsaw	4	Per Day	$ 30.00	$ 120.00
Cooler	2	each	$ 12.50	$ 25.00					$ - 0					$ - 0	Bacpack Sprayer	12	Per Day	$ 10.00	$ 120.00	Misc Hand Tools	14	Per Day	$ 40.00	$ 560.00
Method Blank	2	each	$ 7.00	$ 14.00					$ - 0					$ - 0	Misc. Hand Tools	4	Per Day	$ 40.00	$ 160.00	Lift (Rental)	1	Cost	$ 4,500.00	$ 4,500.00
Postage	1	package	$ 6.75	$ 6.75					$ - 0					$ - 0	Chipper (Rental)	1	Cost	$ 250.00	$ 250.00	Chipper (Rental)	1	Cost	$ 1,500.00	$ 1,500.00
				$ - 0					$ - 0					$ - 0	Herbicide, Surfactants, Dye	1	Cost	$ 800.00	$ 800.00	25x Trees	1	Cost	$ 10,500.00	$ 10,500.00
				$ - 0					$ - 0					$ - 0	Dump Fee	1	Cost	$ 150.00	$ 150.00	Mulch, Stakes, Guy Strap, ECB, Seed	1	Cost	$ 1,000.00	$ 1,000.00
			Total Expenses	$ 918.50					$ - 0					$ - 0					$ - 0	Gator Watering Bags	1	Cost	$ 300.00	$ 300.00
									$ - 0					$ - 0					$ - 0	Misc Maintenance Materials (strap, stakes, etc)	1	cost	$ 150.00	$ 150.00
									$ - 0					$ - 0					$ - 0	Herbicides and Pesticides	1	Cost	$ 350.00	$ 350.00
									$ - 0					$ - 0					$ - 0	2x Replacement Trees	1	Cost	$ 800.00	$ 800.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
							Total Expenses		$ - 0			Total Expenses		$ 151.00			Total Expenses		$ 4,200.00			Total Expenses		$ 27,350.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
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
Crew Truck	5.5	Per Day	$ 210.00	$ 1,155.00	Mileage	450	per mile	$ 0.51	$ 229.50	Mileage	360	per mile	$ 0.51	$ 183.60	Mileage	250	per mile	$ 0.51	$ 127.50	Crew Truck	60	Per Day	$ 210.00	$ 12,600.00	#5 Container Oak Trees	1	Cost	$ 450.00	$ 450.00
Enclosed Trailer	4	Per Day	$ 60.00	$ 240.00	Breakfast	5	Unit	$ 10.00	$ 50.00	Breakfast		Unit	$ 10.00	$ - 0	Breakfast	2	Unit	$ 10.00	$ 20.00	Enclosed Trailer	20	Per Day	$ 60.00	$ 1,200.00	Tree Cages	1	Cost	$ 50.00	$ 50.00
Equipment Trailer	0.5	Per Day	$ 100.00	$ 50.00	Lunch	5	Unit	$ 12.00	$ 60.00	Lunch		Unit	$ 12.00	$ - 0	Lunch	2	Unit	$ 12.00	$ 24.00	Equipment Trailer	19	Per Day	$ 100.00	$ 1,900.00					$ - 0
UTV	4	Per Day	$ 170.00	$ 680.00	Dinner	5	Unit	$ 23.00	$ 115.00	Dinner		Unit	$ 23.00	$ - 0	Dinner	2	Unit	$ 23.00	$ 46.00	UTV	8	Per Day	$ 170.00	$ 1,360.00					$ - 0
UTV Skid Sprayer	1.5	Per Day	$ 60.00	$ 90.00	GPS	5	Unit	$ 50.00	$ 250.00	GPS	7	Unit	$ 50.00	$ 350.00	GPS	1	Unit	$ 50.00	$ 50.00	UTV Skid Sprayer	1	Per Day	$ 60.00	$ 60.00					$ - 0
UTV Pull-Behind Mower	2.5	Per Day	$ 60.00	$ 150.00	Lodging Per Diem		per night	$ 98.00	$ - 0	Lodging Per Diem		per night	$ 98.00	$ - 0	Lodging Per Diem		per night	$ 98.00	$ - 0	Zero Turn Mower	10	Per Day	$ 265.00	$ 2,650.00					$ - 0
Backpack Sprayer	2	Per Day	$ 10.00	$ 20.00					$ - 0	Data Logger	10	Unit	$ 100.00	$ 1,000.00					$ - 0	Skid Steer Grapple	1	Per Day	$ 140.00	$ 140.00					$ - 0
0-100 HP Tractor	0.5	Per Day	$ 480.00	$ 240.00					$ - 0					$ - 0					$ - 0	Skid Steer Mower	1	Per Day	$ 140.00	$ 140.00					$ - 0
8' Native No-Tll Seed Drill	0.5	Per Day	$ 120.00	$ 60.00					$ - 0					$ - 0					$ - 0	Skid Steer	9	Per Day	$ 380.00	$ 3,420.00					$ - 0
WisDOT 70 Seed Mix	1	Cost	$ 5,250.00	$ 5,250.00					$ - 0					$ - 0					$ - 0	Rotary Tiller	4	Per Day	$ 150.00	$ 600.00					$ - 0
Herbicide	1	Cost	$ 600.00	$ 600.00					$ - 0					$ - 0					$ - 0	Fabric Trencher	3	Per Day	$ 200.00	$ 600.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	0-100 HP Tractor	7	Per Day	$ 480.00	$ 3,360.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Misc Hand Tools	33	Per Day	$ 40.00	$ 1,320.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Backpack Sprayer	18	Per Day	$ 10.00	$ 180.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Forestry Mulcher Head (Rental)	1	Cost	$ 1,200.00	$ 1,200.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Bare Root Shrubs/Live Stakes (Install)	1	Cost	$ 5,300.00	$ 5,300.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Bare Root Shrubs/Live Stakes (Replants)	1	Cost	$ 1,800.00	$ 1,800.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Herbicide	1	Cost	$ 550.00	$ 550.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Weed Barrier Fabric and Staples	1	Cost	$ 4,000.00	$ 4,000.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Pea Gravel Mulch	1	Cost	$ 1,200.00	$ 1,200.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Plant Skydd	1	Cost	$ 200.00	$ 200.00					$ - 0
				$ - 0					$ - 0					$ - 0					$ - 0	Root Dip	1	Cost	$ 100.00	$ 100.00					$ - 0
		Total Expenses		$ 8,535.00			Total Expenses		$ 704.50			Total Expenses		$ 1,533.60			Total Expenses		$ 267.50			Total Expenses		$ 43,880.00			Total Expenses		$ 500.00

Tab 6 Subcontractors

List each Subcontracted item individually, include quantity and unit or rate. Do not include mileage, lodging, or per diems.
Fill in only those cells highlighted in blue. Cells in green are calculated.	0
There are 10 scenarios to provide Subcontractor information for: 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.4.6, 4.4.7, 4.4.8, 4.4.9, 4.4.10, and 4.4.10A

Example

4.4.2 ESA Biological assessment

4.4.3 Rare Species Survey

4.4.4 Roadside remnant prairie and invasive species management

4.4.5 Roadside facilities tree management and planting

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

XYZ Analytical

Laboratory Analysis

$ 1,745.00

Green Drilling

175' direct push borings

$ 3,550.00

FGH Research

database research

$ 450.00

$ 5,745.00

Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0

4.4.6 Roadside facilities prairie management and planting

4.4.7 Wetland Delineation

4.4.8 Wetland Monitoring

4.4.9 Stream Features Worksheet

4.4.10 Functional Planting - Large Project

4.4.10A Functional Planting - Large Project Alternate Planting

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Subcontractor

Task

Total

Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0 Total Subcontract $ - 0

Tab 7 Cost Total

Bat inspections, per bridge structure (lump sum)	Cost per single structure	Two to four structures, cost per structure	Five to nine structures, cost per structure	Ten or more structures, cost per structure
	$ 7,470.00	$ 6,685.00	$ 6,285.00	$ 5,900.00
Bat Inspection Market Basket (based on 5 year daily request totals)	59	50	23	21	$ 1,043,435.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	$ 33.70	$ 3,370.00	$ 4,166.67	$ 904.40	$ 8,441.07
Contract Manager	25	$ 89.90	$ 2,247.58	$ 2,778.91	$ 603.18	$ 5,629.67
Project Supervisor I	25	$ 57.46	$ 1,436.52	$ 1,776.12	$ 385.52	$ 3,598.15
CADD/GIS I	50	$ 49.66	$ 2,482.77	$ 3,069.70	$ 666.30	$ 6,218.76
Accounting I	8	$ 33.70	$ 269.60	$ 333.33	$ 72.35	$ 675.29
				Total Program Management Assistance Cost		$ 17,668.89

Ecological Services	Cost	Market Basket	Extended Cost
4.4.2 ESA Biological assessment	$ 42,272.54	7	295907.772149311
4.4.3 Rare Species Survey	$ 7,047.52	130	916177.975663555
4.4.4 Roadside remnant prairie and invasive species management	$ 25,268.56	138	3487061.62395918
4.4.5 Roadside facilities tree management and planting	$ 64,876.85	19	1232660.23319968
4.4.6 Roadside facilities prairie management and planting	$ 20,917.94	17	355605.034116777
4.4.7 Wetland Delineation	$ 8,843.04	214	1892410.37702624
4.4.8 Wetland Monitoring	$ 29,232.72	50	1461636.12869184
4.4.9 Stream Features Worksheet	$ 5,166.61	5	25833.0485306503
4.4.10 Functional Planting - Large Project	$ 141,602.89	51	7221747.42113984
	Total Ecological Services Cost		$ 16,889,039.61
FIRM Name:	Merjent
Total Cost	$ 17,950,143.51

File details come from the government source that posted it. Updated Aug 7, 2025.