Attachment_A-_Estimate_Development_Spreadsheet-_26033.xlsx

XLSX spreadsheet 56 KB Posted Feb 27, 2026

Attached to: Design Services - CTH CV/Hoepker Road Intersection
Solicitation number: 2026-RFP-033-PR
Issued by: Dane County, Mattoon Village, Wisconsin

About this file

Written by GovTribe AI · Apr 27, 2026

This is a consultant contract cost estimate workbook instruction document provided by the Department of Transportation for use by engineering firms submitting contract cost estimates. The document serves as a guideline for preparing cost estimates for consulting contracts and includes templates for multiple compensation structures including lump sum, actual cost, and conditional "if authorized" work arrangements. The workbook contains worksheets for summarizing staff hours and direct labor costs, establishing work schedules, calculating consultant direct labor rates with weighted averages, computing fees by engineering task, itemizing direct costs, and calculating total contract fees for both single and phased contracts. The document accommodates projects with multiple tasks and allows for subcontractor cost estimates to be integrated within the overall contract structure. While the workbook format is provided as a guideline, firms are permitted to modify the template to suit their specific project requirements, provided they follow the general format outlined in Chapter 8 of the Facilities Development Manual.

The workbook specifies that only hard copies should be submitted with consultant contracts and that electronic files are for internal use only. The instructions emphasize the importance of verifying all formulas and totals when inserting or deleting rows and columns, as modifications can undermine the spreadsheet calculations. When contracts include different types of work arrangements, a summary sheet showing all work is required. For contracts with multiple projects, all cost estimate forms for each individual project should be organized consecutively, with prime vendor estimates followed by subcontractor estimates for that specific project, rather than grouping all prime estimates together followed by all subcontractor estimates. The document provides no specific funding amounts, budget ranges, or award values, functioning instead as an instructional template for cost estimation methodology compliant with departmental standards.

View the file

Other files

File	Type	Posted
Design_Services_-_CTH_CV_Hoepker_Road_Intersection.pdf	PDF	Feb 27, 2026
Attachment_A-_Estimate_Development_Spreadsheet-_26033.xlsx	XLSX spreadsheet	Feb 27, 2026

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

Consultant Contract Cost Estimate Workbook Instructions:

This workbook is designed as a guideline for consulting firms to use when submitting contract cost estimates to the Department of Transportation. It is not required that firms use this workbook for submitting contract cost estimates.

However, any contract cost estimates should follow the general format shown here and in Chapter 8 of the Facilities Development Manual.

Most firms will have to make changes to the format of these worksheets when submitting estimates. On the "Hours" worksheet, for example, a project may include work under more than 15 tasks. The firm would then have

to insert rows on that sheet to add in the additional tasks. Other contracts may have less than 15 tasks, so rows would have to be deleted. Inserting rows and columns can undermine formulas set in the spreadsheet to

sum individual rows and columns, so please double-check that all totals are correct when using these spreadsheets to submit contract cost estimates!

Cells that do not need to be filled in, such as totals and titles, are shaded yellow or gray.

The footer of each form in this workbook contains the applicable FDM Procedure number.

Do not submit electronic files of this workbook. Submit only hard copies with consultant contracts. This workbook is for firms' internal use only!

Additional Notes for Submitting Contract Cost Estimates

Some contracts break down engineering costs by "lump sum", "actual cost", and "if authorized" work. Any supporting documents that require the definition of these type of costs must also include a summary sheet

for ALL work for each project on the contract. Examples are shown on the "Hours" and "Fee Task" worksheets. If the contract does not include these different types of work (e.g. all work is "lump sum") the additional breakdown is not necessary.

Subcontractors must submit estimate sheets like those shown in this workbook. The subcontractor's original signed proposal to the prime consultant is to be submitted as well.

If a contract has multiple projects, all of the cost estimate forms--prime and subs--for each project should be on consecutive pages. Currently, most contracts list all of the prime vendor estimates for each project together and

then show subcontractor estimates at the end of the contract. We prefer that the material for each project ID be kept together within the contract. For example, a contract with projects 0000-00-00 & 0000-00-01 should be laid

out like this: prime vendor forms for 0000-00-00, subcontract forms for 0000-00-00, prime vendor forms for 0000-00-01, subcontract forms for 0000-00-01.

Hours Summary of Staff Hours and Direct Labor Costs

PROJECT TOTAL

Project ID:

Classification
Avg. Hourly Wage										Total Direct Labor
Task	Activity Code	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
TOTAL:		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00

Lump Sum Tasks

Project ID:

Classification
Avg. Hourly Wage										Total Direct Labor
Task	Activity Code	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
TOTAL:		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00

Actual Cost Tasks

Project ID:

Classification
Avg. Hourly Wage										Total Direct Labor
Task	Activity Code	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
TOTAL:		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00

"If Authorized" Task #1

Project ID:

Classification
Avg. Hourly Wage										Total Direct Labor
Task	Activity Code	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
TOTAL:		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00

"If Authorized" Task #2

Project ID:

Classification
Avg. Hourly Wage										Total Direct Labor
Task	Activity Code	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars	Hours	Dollars
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
										0	$0.00
TOTAL:		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00

FDM Chapter 8, Procedure 10-1, Figure 1 Page &P of &N

Sched

Staff Work Schedule for Construction Contracts
Project ID:
Work Schedule from:	to

Class	Week/ Month									Total Hours	Total Costs
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
TOTAL:		0	0	0	0	0	0	0	0	0	$0.00

FDM Chapter 8, Procedure 10-1, Figure 2 Page &P of &N

Ind. Wages

Consultant Direct Labor Rates

Project ID:

(a)	(b)	(c)	(d)	(e)	(f)	(g)	(h)	(i)
Employee Name	Classification	Current Rate	% Pay Increase	New Pay Rate	Date of Increase	% Work at Current Rate	% Work at Increased Rate	Weighted Average Hourly Rate
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00
				$0.00				$0.00

Contract Completion Date:

FDM Chapter 8, Procedure 10-30, Figure 1 Page &P of &N

Wgt. Wages

Consultant Weighted Average Direct Labor Rates

Project ID:

Classification:

(a)	(b)	(c)	(d)
Employee Name	Current Rate	Percent Contribution	(b*c)
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
			$0.00
TOTAL		0.00%	$0.00

FDM Chapter 8, Procedure 10-30, Figure 1 Page &P of &N

Fee Task Fee Computation Summary by Engineering Task

PROJECT TOTAL

Project ID:

Task	Activity Code	Direct Labor Costs	Indirect Costs	Fixed Fee	Direct Expenses	Total
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
TOTAL:		$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%):	Fixed Fee (%):
Lump Sum Tasks
Project ID:

Task	Activity Code	Direct Labor Costs	Indirect Costs	Fixed Fee	Direct Expenses	Total
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
TOTAL:		$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%):	Fixed Fee (%):
Actual Cost Tasks
Project ID:

Task	Activity Code	Direct Labor Costs	Indirect Costs	Fixed Fee	Direct Expenses	Total
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
TOTAL:		$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%):	Fixed Fee (%):
"If Authorized" Task #1
Project ID:

Task	Activity Code	Direct Labor Costs	Indirect Costs	Fixed Fee	Direct Expenses	Total
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
TOTAL:		$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%):	Fixed Fee (%):
"If Authorized" Task #2
Project ID:

Task	Activity Code	Direct Labor Costs	Indirect Costs	Fixed Fee	Direct Expenses	Total
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
TOTAL:		$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%): Fixed Fee (%):

FDM Chapter 8, Procedure 10-30, Figure 2 Page &P of &N

Directs

Direct Costs by Item

Project ID:

Item	Unit Amount	Unit Type	Rate	Total Expenses
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
				$0.00
TOTAL				$0.00

FDM Chapter 8, Procedure 10-30, Figure 3 Page &P of &N

Contract Fee Consultant Contract Total Fee Computation

Project ID					Total for Contract
Number of Staff Hours					0
Total Direct Labor					$0.00
Total Indirect Costs					$0.00
Fixed Fee					$0.00
Direct Expenses					$0.00
Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
Subcontract 1					$0.00
Subcontract 2					$0.00
Subcontract Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL COST	$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%): Fixed Fee (%):

FDM Chapter 8, Procedure 10-30, Figure 4 Page &P of &N

Phased Fee Phased Consultant Contract Total Fee Computation

Contract Phase Begin Date
Contract Phase End Date					Total for Contract
Number of Staff Hours					0
Direct Labor Costs					$0.00
Indirect Costs					$0.00
Fixed Fee					$0.00
Direct Expenses					$0.00
Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
Subcontract 1					$0.00
Subcontract 2					$0.00
Subcontract Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL COST:	$0.00	$0.00	$0.00	$0.00	$0.00

Indirect Cost Rate (%): Fixed Fee (%):

FDM Chapter 8, Procedure 10-30, Figure 5 Page &P of &N

File details come from the government source that posted it. Updated Apr 27, 2026.