ODOT_Planning___Research_557-26_Michael_Baker.xlsx

XLSX spreadsheet 97 KB Posted Jul 1, 2025

Attached to: Competitive Selection OH|DOT55726-2
Contract number: DOT55726-2
Issued by: Ohio

About this file

Written by GovTribe AI · Jul 15, 2025

This document is a Cost Proposal for Transit Planning and Research from Michael Baker International for the Oregon Department of Transportation (ODOT). The proposal is dated May 14, 2025, and includes a detailed breakdown of labor rates, task allocations, and cost structures for various project components involving transportation planning, research, alternative fuels operations, and cultural resource investigations.

The contract encompasses seven primary task areas with specific subtasks, including contract management, research, planning, alternative fuels operations, data reporting, project management, and Governor's Apportionment Support. The total authorized project costs are $578,859, with a comprehensive fee structure that includes direct labor rates ranging from $36.17 to $125.00 per hour, an overhead rate of 140.86%, a cost of money rate of 5.00%, and a net fee percentage of 9%. The proposal details 3,187 total labor hours across multiple staff positions such as Principal, Senior Associate, Project Manager, and various specialist roles, with direct costs covering elements like mileage, lodging, and other project-related expenses.

View the file

Other files

File	Type	Posted
Signature.pdf	PDF	Jul 1, 2025
Affirmation_and_Disclosure2.pdf	PDF	Jul 1, 2025
ODOT_Planning___Research_557-26_Michael_Baker.pdf	PDF	Jul 1, 2025
557-26.pdf	PDF	Jul 1, 2025
557-26_Score_Sheet.xlsx	XLSX spreadsheet	Jul 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.

Labor Rates_Cost Proposal

	RFP: Transit Planning and Research	COST PROPOSAL SUMMARY			Version:
Feb 2021		RFP: Transit Planning and Research	PROPOSAL COST SUMMARY	Version:
Feb 2021		RFP: Transit Planning and Research	DIRECT COSTS	Version:

Feb 2021

Consultant:	Michael Baker International	Consultant:	Michael Baker International			Consultant:	Michael Baker International
Agreement No.		Agreement No.	0	State Average Overhead Rate	159.98%	Agreement No.	0	Airfare

tc={FF561444-D518-4EB4-9ADB-6B1CF9BAF3B4}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.)	Mileage	Lodging	Rental Cars	Meals	Total
	Modification No.					Modification No.	0	Consultant Overhead Rate:	140.86%

tc={25B140CB-E7E4-4717-8B3C-39EA17D9F8F9}: [Threaded comment]

Comment:

Complete as a percentage rate			Modification No.	0
	PID No.	Assigned Staff Positions & Associated Rates			PID No.	0	Cost of Money:	5.00%

tc={7EC11373-4253-4FDA-9AAC-793516C26C41}: [Threaded comment]

Comment:

Complete as a percentage rate, for example 0.08%				PID No.	0
	Proposal Date	5/14/25	Example			Proposal Date	5/14/25	Net Fee Percentage:	9%

tc={06A4BABD-80CD-45F5-BB27-CA39E8BF41E1}: [Threaded comment]

Comment:

Complete as a percentage that goes no higher than 11.0%			Proposal Date	5/14/25
	Staff Position	Project Manager

tc={2E033D03-1356-4892-A590-635CC50D0B07}: [Threaded comment]

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)

Principal (Subs)

Associate

Senior Planner

Technical Lead

QAQC

Planners

Alt Fuels Lead

Specialists

Architectural Historian

Archaeologist

Total

No. of Units

Average Hourly

Total

Labor

Overhead

Cost of

Direct

Subcon

Net

Total

Direct Cost Category:

Task Description

Direct Labor Rate

$76.76

tc={9F00147C-147E-403C-BE31-3FAC20F1902D}: [Threaded comment]

Comment:

Insert employee's labor rate excluding overhead rate $125.00 $91.70 $63.83 $71.50 $86.89 $48.30 $95.94 $56.60 $47.94 $36.17 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $550.00 tc={35A4093A-B2FB-4FA3-A10B-17058C44F754}: [Threaded comment]

Comment:

Insert unit cost related to the direct cost category tc={2E033D03-1356-4892-A590-635CC50D0B07}: [Threaded comment]

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)

tc={9F00147C-147E-403C-BE31-3FAC20F1902D}: [Threaded comment]

Comment:

Insert employee's labor rate excluding overhead rate tc={25B140CB-E7E4-4717-8B3C-39EA17D9F8F9}: [Threaded comment]

Comment:

Complete as a percentage rate tc={7EC11373-4253-4FDA-9AAC-793516C26C41}: [Threaded comment]

Comment:

Complete as a percentage rate, for example 0.08% tc={06A4BABD-80CD-45F5-BB27-CA39E8BF41E1}: [Threaded comment]

Comment:

Complete as a percentage that goes no higher than 11.0%							$0.58	$131.00	$75.00	$80.00
	AUTHORIZED TASKS:													AUTHORIZED TASKS:										AUTHORIZED TASKS:
	Known Tasks													Known Tasks										Known Tasks
		Staff Hours																							Units	Units	Units	Units	Units	Units	Units	Units	Units	$
	Task 1: Contract Management													Task 1: Contract Management										Task 1: Contract Management
	Subtask 1:	108	54				36	108				306	$23,385	Subtask 1:	$76.42	306	$23,385	$32,939	$1,169	$5,155	$0	$5,069	$67,717	Subtask 1:	4	1150	8	8	8					$5,155
	TOTAL Task 1	108	54	0	0	0	36	108	0	0	0	306	$23,385	TOTAL Task 1	$76.42	306	$23,385	$32,939	$1,169	$5,155	$0	$5,069	$67,717	TOTAL Task 1	4	1150	8	8	8	0	0	0	0	$5,155

Task 2: Research														Task 2: Research										Task 2: Research
Subtask 1: Literature Review/Background Research	4			20	8		80					112	$6,020	Subtask 1: Literature Review/Background Research	$53.75	112	$6,020	$8,479	$301	$0	$0	$1,305	$16,105	Subtask 1: Literature Review/Background Research										$0
Subtask 2: Interviews	4			20	8		40					72	$4,088	Subtask 2: Interviews	$56.77	72	$4,088	$5,758	$204	$0	$0	$886	$10,936	Subtask 2: Interviews										$0
Subtask 3: Best Practice Document	4			20	8	4	80					116	$6,367	Subtask 3: Best Practice Document	$54.89	116	$6,367	$8,969	$318	$0	$0	$1,380	$17,035	Subtask 3: Best Practice Document										$0
TOTAL Task 2	12	0	0	60	24	4	200	0	0	0	0	300	$16,474	TOTAL Task 2	$54.91	300	$16,474	$23,206	$824	$0	$0	$3,571	$44,075	TOTAL Task 2	0	0	0	0	0	0	0	0	0	$0

Task 3: Planning														Task 3: Planning										Task 3: Planning
Subtask 1: Develop Work Plan and Schedule	40		18	18	18		34					128	$8,799	Subtask 1: Develop Work Plan and Schedule	$68.74	128	$8,799	$12,394	$440	$1,122	$0	$1,907	$24,663	Subtask 1: Develop Work Plan and Schedule		1		2	2	2					$1,122
Subtask 2: Outreach and Data collection	16			46			80					142	$8,028	Subtask 2: Outreach and Data collection	$56.54	142	$8,028	$11,309	$401	$3,831	$0	$1,740	$25,310	Subtask 2: Outreach and Data collection		3		6	9	9					$3,831
Subtask 3: Service Area Profiles	8			24			136					168	$8,715	Subtask 3: Service Area Profiles	$51.87	168	$8,715	$12,276	$436	$0	$0	$1,889	$23,315	Subtask 3: Service Area Profiles											$0
Subtask 4: Organizational analysis	32		40		72	4	104					252	$16,643	Subtask 4: Organizational analysis	$66.04	252	$16,643	$23,443	$832	$1,277	$0	$3,608	$45,803	Subtask 4: Organizational analysis		1		2	3	3					$1,277
Subtask 5: Final Plan	32		72	14	56	4	160					338	$22,032	Subtask 5: Final Plan	$65.18	338	$22,032	$31,034	$1,102	$1,277	$0	$4,776	$60,221	Subtask 5: Final Plan		1		2	3	3					$1,277
TOTAL Task 3	128	0	130	102	146	8	514	0	0	0	0	1028	$64,217	TOTAL Task 3	$62.47	1028	$64,217	$90,456	$3,211	$7,507	$0	$13,921	$179,312		TOTAL Task 3	6	0	12	17	17	0	0	0	0	$7,507

Task 4: Alternative Fuels Operations														Task 4: Alternative Fuels Operations										Task 4: Alternative Fuels Operations
Subtask 1: Existing Conditions Assessment	30	40				4	146	16	32			268	$18,048	Subtask 1: Existing Conditions Assessment	$67.34	268	$18,048	$25,423	$902	$0	$0	$3,912	$48,286	Subtask 1: Existing Conditions Assessment										$0
Subtask 2: Fleet, Facility, and Charging Needs Evaluation	24	40				4	120	44	320			552	$35,319	Subtask 2: Fleet, Facility, and Charging Needs Evaluation	$63.98	552	$35,319	$49,751	$1,766	$1,421	$0	$7,656	$95,913	Subtask 2: Fleet, Facility, and Charging Needs Evaluation	1	240	2	2	4					$1,421
Subtask 3: Financial Review								12	24			36	$2,510	Subtask 3: Financial Review	$69.71	36	$2,510	$3,535	$125	$0	$0	$544	$6,714	Subtask 3: Financial Review										$0
TOTAL Task 4	54	80	0	0	0	8	266	72	376	0	0	856	$55,877	TOTAL Task 4	$65.28	856	$55,877	$78,709	$2,794	$1,421	$0	$12,113	$150,914	TOTAL Task 4	1	240	2	2	4	0	0	0	0	$1,421

Task 5: Data and Reporting														Task 5: Data and Reporting										Task 5: Data and Reporting
Subtask 1: Agency Outreach and Coordination	3				3		24					30	$1,604	Subtask 1: Agency Outreach and Coordination	$53.47	30	$1,604	$2,259	$80	$0	$0	$348	$4,291	Subtask 1: Agency Outreach and Coordination										$0
Subtask 2: Data Collection	3				3		24					30	$1,604	Subtask 2: Data Collection	$53.47	30	$1,604	$2,259	$80	$5,632	$0	$348	$9,923	Subtask 2: Data Collection	4		12	12	12					$5,632
Subtask 3: GTFS Feed Development	3				3		96					102	$5,082	Subtask 3: GTFS Feed Development	$49.82	102	$5,082	$7,158	$254	$0	$0	$1,102	$13,595	Subtask 3: GTFS Feed Development										$0
Subtask 4: Publish and Upload GTFS Data URL	3				3	4	24					34	$1,952	Subtask 4: Publish and Upload GTFS Data URL	$57.40	34	$1,952	$2,749	$98	$0	$0	$423	$5,221	Subtask 4: Publish and Upload GTFS Data URL										$0
TOTAL Task 5	12	0	0	0	12	4	168	0	0	0	0	196	$10,241	TOTAL Task 5	$52.25	196	$10,241	$14,426	$512	$5,632	$0	$2,220	$33,031	TOTAL Task 5	4	0	12	12	12	0	0	0	0	$5,632

Task 6: Project Management														Task 6: Project Management										Task 6: Project Management
Subtask 1: ODOT Section 106 Scoping Request Form	4				4					18		26	$1,456	Subtask 1: ODOT Section 106 Scoping Request Form	$56.00	26	$1,456	$2,051	$73	$0	$0	$316	$3,895	Subtask 1: ODOT Section 106 Scoping Request Form											$0
Subtask 2: Phase I Cultural Resources Historic/Architecture Survey	4				16	4				84		108	$5,826	Subtask 2: Phase I Cultural Resources Historic/Architecture Survey	$53.94	108	$5,826	$8,206	$291	$569	$0	$1,263	$16,154	Subtask 2: Phase I Cultural Resources Historic/Architecture Survey			220	1	2	2					$569
Subtask 3: Phase I Cultural Resources/Archaeological Survey	4				17	4					69	94	$4,366	Subtask 3: Phase I Cultural Resources/Archaeological Survey	$46.45	94	$4,366	$6,150	$218	$569	$0	$946	$12,249	Subtask 3: Phase I Cultural Resources/Archaeological Survey			220	1	2	2					$569
Subtask 4: NEPA					105	4	28					137	$9,207	Subtask 4: NEPA	$67.21	137	$9,207	$12,970	$460	$569	$0	$1,996	$25,202	Subtask 4: NEPA			220	1	2	2					$569
TOTAL Task 6	12	0	0	0	142	12	28	0	0	102	69	365	$20,855	TOTAL Task 6	$57.14	365	$20,855	$29,376	$1,043	$1,706	$0	$4,521	$57,500		TOTAL Task 6	0	660	3	6	6	0	0	0	0	$1,706

Task 7: Governors Apportionment Support														Task 7: Governors Apportionment Support										Task 7: Governors Apportionment Support
Subtask 1:	12	120				4						136	$16,269	Subtask 1:	$119.62	136	$16,269	$22,916	$813	$2,785	$0	$3,527	$46,310	Subtask 1:		1000	5	10	10					$2,785
TOTAL Task 7	12	120	0	0	0	4	0	0	0	0	0	136	$16,269	TOTAL Task 7	$119.62	136	$16,269	$22,916	$813	$2,785	$0	$3,527	$46,310	TOTAL Task 7	0	1000	5	10	10	0	0	0	0	$2,785

TOTAL Known Tasks	338	254	130	162	324	76	1284	72	376	69	3085	$207,318	TOTAL Known Tasks	$65.05	$3,187	$207,318	$292,028	$10,366	$24,206	$0	$44,941	$578,859	TOTAL Known Tasks	15	3050	42	55	57	0	0	0	0	$24,206
					.

Unknown Tasks												Unknown Tasks										Unknown Tasks
Task 1:												Task 1:										Task 1:
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL Task 1	0	0	0	0	0	0	0	0	0	0	$0	TOTAL Task 1	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL Task 1	0	0	0	0	0	0	0	0	0	$0.00

Task 2:												Task 2:										Task 2:
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL Task 2	0	0	0	0	0	0	0	0	0	0	$0	TOTAL Task 2	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL Task 2	0	0	0	0	0	0	0	0	0	$0.00

Task 3:												Task 3:										Task 3:
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL Task 3	0	0	0	0	0	0	0	0	0	0	$0	TOTAL Task 3	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL Task 3	0	0	0	0	0	0	0	0	0	$0.00

Task 4:												Task 4:										Task 4:
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL Task 4	0	0	0	0	0	0	0	0	0	0	$0	TOTAL Task 4	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL Task 4	0	0	0	0	0	0	0	0	0	$0.00

Task 5:												Task 5:										Task 5:
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL Task 5	0	0	0	0	0	0	0	0	0			TOTAL Task 5	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL Task 5	0	0	0	0	0	0	0	0	0	$0.00

Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Unknown Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks Section												Future Tasks Section										Future Tasks Section
Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks Section												Future Tasks Section										Future Tasks Section
Task Name												Task Name										Task Name
Subtask 1:										0	$0	Subtask 1:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 1:										$0.00
Subtask 2:										0	$0	Subtask 2:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 2:										$0.00
Subtask 3:										0	$0	Subtask 3:	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
TOTAL	0	0	0	0	0	0	0	0	0	0	$0	TOTAL	ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	TOTAL	0	0	0	0	0	0	0	0	0	$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

TOTAL AUTHORIZED PARTS TOTAL AUTHORIZED PARTS $65.05 3187 $207,318.07 $292,028.23 $10,365.90 $24,206.00 $0.00 $44,941.17 $578,859.37

IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:

TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS

GRAND TOTAL GRAND TOTAL

&9&P of &N

Instructions for Completion Instructions for Completing the Cost Proposal Summary

Steps	Description	Notes
Step 1:	Input prime consultant firm's name in the highlighted B2 cell - Consultant
Step 2:	In the highlighted cells D7 through M7, input the prime consultant's staff position names who would be participating in the contract should the consultant be selected. Any important subconsultant staff positions may be included. Additional columns may be added as necessary.
Step 3:	In the highlighted cells D8 through M8, input the prime consultant's staff position direct labor rate associated with the position name directly above. Any important subconsultant staff position's direct labor rate may be included and additional columns may be added as necessary.	IMPORTANT: The direct labor rates proposed will be binding with the selected consultant.
Step 4:	Complete the Known Tasks with proposed task hours per staff position from the prime consultant's firm or team of firms.	The Known Tasks are comprised of the tasks ODOT expects to include in the contract. The task amounts proposed by the consultant will be used for comparison purposes only and will not be final task orders with the selected contractor.
Step 5:	In the highlighted X4 cell, input the prime consultant's overhead rate expressed as a percentage.
Step 6:	In the highlighted X5 cell, input the prime consultant's cost of money rate expressed as a percentage.
Step 7:	In the highlighted X6 cell, input the prime consultant's net fee (profit) rate expressed as a percentage.	The net fee has been set as a maximum of 11% for this contract.
Step 8:	In the highlighted cells AF3 through AN3, input the prime consultant's direct cost category name (ex: airfare, mileage, printing/copies, rental car, etc.)
Step 9:	In the highlighted cells AF8 through AN8, input the prime consultant's unit cost rate associated with the direct cost category directly above.
Step 10:	Complete the Direct Costs with proposed amounts per category from the prime consultant's firm or team of firms.

Information for use Version: Sept. 2016

SUMMARY OF STEPS

		SUMMARY OF STEPS
$0.00	RFP: Transit Planning and Research
Consultant:	Michael Baker International
Agreement No.	0
Modification No.	0
PID No.	0
Proposal Date	5/14/25

Average Hourly	Total	Labor	Overhead	Cost of	Direct	Subcon	Net	Total
Rate	Hours	Costs	Costs	Money	Costs	Costs	Fee	Cost
AUTHORIZED TASKS:
Known Tasks
$65.05	3187	$207,318	$292,028	$10,366	$24,206	$0	$44,941	$578,859
Unknown Tasks
ERROR:#DIV/0!	0	$0	$0	$0	$0	$0	$0	$0
Future Tasks
ERROR:#DIV/0!	0	$0	$0	$0	$0	$0	$0	$0
Future Tasks
ERROR:#DIV/0!	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL AUTHORIZED TASKS
$65.05	3187	$207,318	$292,028	$10,366	$24,206	$0	$44,941	$578,859

IF-AUTHORIZED TASKS:

TOTAL IF-AUTHORIZED TASKS

GRAND TOTAL

&"Arial,Bold"&18SUMMARY OF STEPS

&F &9&P of &N &D

Narratives

0	RFP: Transit Planning and Research	Consultant	ODOT	LPA	If-Authorized
Consultant:	Michael Baker International
Agreement No.	0
Modification No.	0
PID No.	0
Proposal Date	5/14/25

Task Description					Narrative
Copy task in scope from the Labor Rates_Cost Proposal Tab	X	X	X	X	Add Narratives as needed here

Microsoft_Word_97_-_2003_Document.doc Information for Use of Spreadsheet

The intent of the spreadsheet(s) is to help guide ODOT and a Consultant in the development of a fair and reasonable fee for a specific project Scope of Services. The generic list was generated from items as outlined in the PDP process (may not be all inclusive). The list can be altered by adding additional activities as needed to comply with the Scope, but do not re-numbered tasks from this list.

Comments have been provided for most tasks in the Labor Rates_Cost Proposal tab describing the work typically required for that task. View the comments by hovering on the name of the task in column A/B. For further information on the work to be included in the proposed hours, also see the ODOT “Consultant Fee Estimation Guidance”.

The Narratives tab is to be used to provide additional detail on the work to be included in each task specific to the project such as number of sheets, plan scales, number of meetings, etc. An “X” should be placed in the ODOT/Consultant/LPA column based on who is responsible, and if the task is if-authorized. The intent of this tab is for it to be included as an attachment to the Scope of Services document.

Sample formulas have been provided in Section 1.1 of the Labor Rates_Cost Proposal tab for information only. ODOT does not warrant the formulas of the spreadsheet. It is the Consultant’s responsibility to check and verify all cells for accuracy (both in content and formula).

image1.emf

File details come from the government source that posted it. Updated Jul 15, 2025.