ODOT_OTAP_563-26_Michael_Baker.xlsx

XLSX spreadsheet 90 KB Posted Jul 1, 2025

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

About this file

Written by GovTribe AI · Jul 15, 2025

This document is a detailed cost proposal from Michael Baker International for Transit Support Services, prepared for the Oregon Department of Transportation (ODOT) in February 2021. The proposal outlines a comprehensive labor rates and cost breakdown for various transit-related tasks, with an overhead rate of 140.86% and a net fee percentage of 9%.

The contract covers six primary task areas with an average annual scope, including Section 5311 Staff Support, Drug & Alcohol Program Reviews, Subrecipient On-Site Technical Assistance, Subrecipient Reviews Support, Section 5310 Staff Support, and RTAP Training Workshops & Program. The total known tasks encompass 5,963 labor hours valued at $1,087,328.36, with costs broken down by task, subtask, labor rates, overhead, and direct expenses. The proposal includes different staffing levels across roles such as Project Manager, Principal, Associate, Technical Lead, Planner, and QAQC, with hourly rates ranging from $48.30 to $125.00. Direct costs include potential expenses for mileage, lodging, rental cars, and meals, with a cost of money rate set at 5.00%.

View the file

Other files

File	Type	Posted
563-26_Score_Sheet.xlsx	XLSX spreadsheet	Jul 1, 2025
Affirmation_and_Disclosure__1___1_.pdf	PDF	Jul 1, 2025
563-26.pdf	PDF	Jul 1, 2025
ODOT_OTAP_563-26_Michael_Baker.pdf	PDF	Jul 1, 2025
Signature_-_2025-07-11T102103.015.pdf	PDF	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 Support Services	COST PROPOSAL SUMMARY			Version:
Feb 2021		RFP: Transit Support Services	PROPOSAL COST SUMMARY	Version:
Feb 2021		RFP: Transit Support Services	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={7EC14185-8681-4BA6-8A74-573A7FD9C76D}: [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={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [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={953A55F2-FC43-4D27-9524-DAD905EC8290}: [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={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]

Comment:

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

tc={375C69B9-5530-4600-9629-661986A5ABA9}: [Threaded comment]

Comment:

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

Principal (Subs)

Associate

Technical Lead

Planner

QAQC

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={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [Threaded comment]

Comment:

Insert employee's labor rate excluding overhead rate $125.00 $91.70 $71.50 $48.30 $86.89 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $550.00 tc={F647D137-43C3-4A2B-A111-DAA954AF1F8F}: [Threaded comment]

Comment:

Insert unit cost related to the direct cost category tc={375C69B9-5530-4600-9629-661986A5ABA9}: [Threaded comment]

Comment:

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

tc={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [Threaded comment]

Comment:

Complete as a percentage rate tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [Threaded comment]

Comment:

Insert employee's labor rate excluding overhead rate tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [Threaded comment]

Comment:

Complete as a percentage rate, for example 0.08% tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [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: Section 5311 Staff Support (3-year average of 2,051 hours per year)													Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)											Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)
	Subtask 1: General Planning Support	200	80	250	390	1100	31					2051	$131,986	Subtask 1: General Planning Support	0	$64.35	2051	$131,985.59	$185,914.90	$6,599.28	$11,220.00	$0.00	$28,611.04	$364,330.82	Subtask 1: General Planning Support	10		20	20	20					$11,220.00
	Subtask 2:											0	$0	Subtask 2:	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:	0		0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:										$0.00
	TOTAL Task 1	200	80	250	390	1100	31	0	0	0	0	2051	$131,986	TOTAL Task 1		$64.35	2051	$131,986	$185,915	$6,599	$11,220	$0	$28,611	$364,330.82	TOTAL Task 1	10	0	20	20	20	0	0	0	0	$11,220.00

Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)														Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)										Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)
Subtask 1: Data Collection		12		12	20	80	2					126	$7,489	Subtask 1: Data Collection	$59.44	126	$7,489.30	$10,549.43	$374.47	$0.00	$0.00	$1,623.49	$20,036.68	Subtask 1: Data Collection											$0.00
Subtask 2: Data Plotting		16		12	40	80	3					151	$9,313	Subtask 2: Data Plotting	$61.68	151	$9,313.23	$13,118.62	$465.66	$0.00	$0.00	$2,018.87	$24,916.37	Subtask 2: Data Plotting											$0.00
Subtask 3: Testing Overview Report		16	18	12	40	80	4					170	$11,650	Subtask 3: Testing Overview Report	$68.53	170	$11,650.12	$16,410.36	$582.51	$0.00	$0.00	$2,525.44	$31,168.43	Subtask 3: Testing Overview Report											$0.00
	TOTAL Task 2	44	18	36	100	240	9	0	0	0	0	447	$28,453	TOTAL Task 2	$63.65	447	$28,452.65	$40,078.40	$1,422.63	$0.00	$0.00	$6,167.79	$76,121.48		TOTAL Task 2	0	0	0	0	0	0	0	0	0	$0.00

Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)													Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)										Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)
Subtask 1: Data Collection	8		10	20	60	2					100	$6,033	Subtask 1: Data Collection	$60.33	100	$6,032.86	$8,497.89	$301.64	$0.00	$0.00	$1,307.77	$16,140.16	Subtask 1: Data Collection										$0.00
Subtask 2: Technical Review	8	8	10	20	60	2					108	$7,033	Subtask 2: Technical Review	$65.12	108	$7,032.86	$9,906.49	$351.64	$0.00	$0.00	$1,524.54	$18,815.53	Subtask 2: Technical Review										$0.00
Subtask 3: Assistance	8	8	12	20	60	2					110	$7,216	Subtask 3: Assistance	$65.60	110	$7,216.26	$10,164.82	$360.81	$4,488.00	$0.00	$1,564.30	$23,794.19	Subtask 3: Assistance	4		8	8	8					$4,488.00
TOTAL Task 3	24	16	32	60	180	6	0	0	0	0	318	$20,282	TOTAL Task 3	$63.78	318	$20,281.98	$28,569.20	$1,014.10	$4,488.00	$0.00	$4,396.61	$58,749.88	TOTAL Task 3	4	0	8	8	8	0	0	0	0	$4,488.00

Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)													Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)										Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)
Subtask 1: Develop Review Process and Guideline	22	8	12	80	200	3					325	$19,430	Subtask 1: Develop Review Process and Guideline	$59.78	325	$19,429.79	$27,368.80	$971.49	$0.00	$0.00	$4,211.87	$51,981.95	Subtask 1: Develop Review Process and Guideline										$0.00
Subtask 2: Preform Review	22	34	12	80	200	8					356	$23,114	Subtask 2: Preform Review	$64.93	356	$23,114.24	$32,558.72	$1,155.71	$0.00	$0.00	$5,010.57	$61,839.24	Subtask 2: Preform Review										$0.00
Subtask 3: Final Report	24	34	12	80	200	8					358	$23,268	Subtask 3: Final Report	$64.99	358	$23,267.76	$32,774.97	$1,163.39	$0.00	$0.00	$5,043.85	$62,249.96	Subtask 3: Final Report										$0.00
TOTAL Task 4	68	76	36	240	600	19	0	0	0	0	1039	$65,812	TOTAL Task 4	$63.34	1039	$65,811.79	$92,702.49	$3,290.59	$0.00	$0.00	$14,266.28	$176,071.15	TOTAL Task 4	0	0	0	0	0	0	0	0	0	$0.00

Task 5: Section 5310 Staff Support (average 684 hours per year)													Task 5: Section 5310 Staff Support (average 684 hours per year)										Task 5: Section 5310 Staff Support (average 684 hours per year)
Subtask 1: General Planning Services	60	40	76	160	330	18					684	$45,518	Subtask 1: General Planning Services	$66.55	684	$45,517.82	$64,116.40	$2,275.89	$5,610.00	$0.00	$9,867.08	$127,387.19	Subtask 1: General Planning Services		5		10	10	10					$5,610.00
Subtask 2:											0	$0	Subtask 2:		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:		0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Subtask 3:		0	0	0	0	0	0	0	0	0	$0.00
TOTAL Task 5	60	40	76	160	330	18	0	0	0	0	684	$45,518	TOTAL Task 5	$66.55	684	$45,517.82	$64,116.40	$2,275.89	$5,610.00	$0.00	$9,867.08	$127,387.19		TOTAL Task 5	5	0	10	10	10	0	0	0	0	$5,610.00

Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)													Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)										Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)
Subtask 1: Identification of Training needs	8		20	40	80						148	$9,172	Subtask 1: Identification of Training needs	$61.97	148	$9,172.08	$12,919.79	$458.60	$0.00	$0.00	$1,988.27	$24,538.74	Subtask 1: Identification of Training needs										$0.00
Subtask 2: Training Coordination	12		40	60	120						232	$14,675	Subtask 2: Training Coordination	$63.25	232	$14,675.12	$20,671.37	$733.76	$0.00	$0.00	$3,181.18	$39,261.43	Subtask 2: Training Coordination										$0.00
Subtask 3: Provide Training	100	84	280	280	300						1044	$78,362	Subtask 3: Provide Training	$75.06	1044	$78,362.00	$110,380.71	$3,918.10	$11,220.00	$0.00	$16,986.84	$220,867.66	Subtask 3: Provide Training	10		20	20	20					$11,220.00
TOTAL Task 6	120	84	340	380	500	0	0	0	0	0	1424	$102,209	TOTAL Task 6	$71.78	1424	$102,209.20	$143,971.88	$5,110.46	$11,220.00	$0.00	$22,156.30	$284,667.84	TOTAL Task 6	10	0	20	20	20	0	0	0	0	$11,220.00

TOTAL Known Tasks 516 314 770 1330 2950 83 0 0 0 0 5963 $394,259.03 TOTAL Known Tasks $66.12 5963 $394,259.03 $555,353.27 $19,712.95 $32,538.00 $0.00 $85,465.11 $1,087,328.36 TOTAL Known Tasks 29 0 58 58 58 0 0 0 0 $32,538.00

Unknown Tasks													Unknown Tasks										Unknown Tasks
Task 1:													Task 1:										Task 1:
Subtask 1:											0	$0	Subtask 1:		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:		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:		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	$0	TOTAL Task 1	$0.00	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:		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:		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:		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	$0	TOTAL Task 2	$0.00	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:		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:		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:		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	$0	TOTAL Task 3	$0.00	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:		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:		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:		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	$0	TOTAL Task 4	$0.00	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:		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:		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:		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	0			TOTAL Task 5	$0.00	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 $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:		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:		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:		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	$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:		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:		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:		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	$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:		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:		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:		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	$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:		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:		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:		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	$0	TOTAL	$0.00	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:		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:		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:		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	$0	TOTAL	$0.00	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:		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:		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:		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	$0	TOTAL	$0.00	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 $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:		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:		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:		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	$0	TOTAL	$0.00	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 $0.00 Total - Future Tasks $0.00 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 $66.12 5963 $394,259.03 $555,353.27 $19,712.95 $32,538.00 $0.00 $85,465.11 $1,087,328.36

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

Information for use Version: Sept. 2016

SUMMARY OF STEPS

		SUMMARY OF STEPS
$0.00	RFP: Transit Support Services
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
$66.12	5963	$394,259	$555,353	$19,713	$32,538	$0	$85,465	$1,087,328
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
$0.00	0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
TOTAL AUTHORIZED TASKS
$66.12	5963	$394,259	$555,353	$19,713	$32,538	$0	$85,465	$1,087,328

IF-AUTHORIZED TASKS:

TOTAL IF-AUTHORIZED TASKS

GRAND TOTAL

&"Arial,Bold"&18SUMMARY OF STEPS

&F &9&P of &N &D

Narratives

0	RFP: Transit Support Services	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.