Attachment_A-_Estimate_Development_Spreadsheet-_26033.xlsx

This file is a consultant contract cost estimate workbook template designed by the Wisconsin Department of Transportation (WisDOT) for use by consulting firms submitting contract cost estimates. The template provides a standardized format for estimating costs associated with design services contracts, including the CTH CV/Hoepker Road Intersection design engineering services project. The workbook includes sections for summarizing staff hours and direct labor costs, organizing work by task classification and activity codes, and establishing consultant direct labor rates. It accommodates multiple types of work arrangements including lump sum, actual cost, and "if authorized" tasks, with separate worksheets for each category. The template is designed to be flexible, allowing firms to modify the number of tasks and worksheets as needed for their specific project scope, though users must verify that all formulas and totals remain accurate after making changes.

The workbook requires consultants to provide detailed breakdowns of direct labor costs, indirect costs, fixed fees, and direct expenses, along with calculations of weighted average hourly rates that account for pay increases during the contract period. For contracts with multiple projects, the document specifies that all cost estimate forms for each project should be organized consecutively, with prime consultant estimates followed by subcontractor estimates. Subcontractors must submit estimate sheets in the same format with their original signed proposals. The template references the WisDOT Facilities Development Manual Chapter 8 procedures and is intended for internal use only by consulting firms; only hard copies should be submitted with consultant contracts. The workbook is not mandatory but provides recommended guidance for cost estimate preparation and submission.