590pricing-Vital_Assurance_VA-0710.xlsx

XLSX spreadsheet 100 KB Posted Jul 1, 2025

Attached to: Competitive Selection OH|DOT59026-1
Contract number: DOT59026-1
Issued by: Ohio

About this file

Written by GovTribe AI · Jul 15, 2025

This document is a detailed labor rates and cost proposal for a Safety Oversight (Rail Transit) contract involving Vital Assurance Ltd., prepared for the Ohio Department of Transportation (ODOT) and involving two primary transit agencies: Greater Cleveland Regional Transit Authority (GCRTA) and Cincinnati's transit system. The proposal is dated May 19, 2025, and includes a comprehensive breakdown of labor rates, staff positions, and projected work hours across eight primary task categories.

The contract encompasses safety monitoring, risk-based inspections, reporting, and oversight services for rail transit systems, with a total proposed cost of $1,372,984 and 8,600 projected labor hours. The pricing structure includes direct labor rates ranging from $39.50 to $89.12 per hour, with a consultant overhead rate of 93.50% and a net fee percentage of 8%. The tasks are divided into specific areas such as data analysis, safety and security monitoring, planning and oversight, on-site reviews, reporting, and risk-based inspections for both Cleveland and Cincinnati transit systems. The proposal allows for known tasks and potential future task expansions, with detailed hour allocations and cost breakdowns for each task category.

View the file

Other files

File	Type	Posted
590-26.pdf	PDF	Jul 1, 2025
Affirmation_and_Disclosure-signed__2_.pdf	PDF	Jul 1, 2025
Exhibit_A-_Affirmative_Action-signed.pdf	PDF	Jul 1, 2025
Exhibit_B-_Non-Collusion-signed.pdf	PDF	Jul 1, 2025
Exhibit_C-_Debarment_and_Suspension-signed.pdf	PDF	Jul 1, 2025
590-26_VA_Technical_Proposal_VA-0710.pdf	PDF	Jul 1, 2025
Exhibit_D-_Certification_on_Lobbying-signed.pdf	PDF	Jul 1, 2025
Score_Sheet.xlsx	XLSX spreadsheet	Jul 1, 2025
Signature.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: Safety Oversight (Rail Transit)	PROPOSAL LABOR SUMMARY			Version:
Feb 2021		RFP: Safety Oversight (Rail Transit)	PROPOSAL COST SUMMARY	Version:
Feb 2021		RFP: Safety Oversight (Rail Transit)	DIRECT COSTS	Version:

Feb 2021

Consultant:	Vital Assurance Ltd.	Consultant:	Vital Assurance Ltd.			Consultant:	Vital Assurance Ltd.
Agreement No.		Agreement No.	0	State Average Overhead Rate	159.98%	Agreement No.	0	Travel Cleveland per trip per person

tc={E92F1BAE-17FA-4BBC-AC43-CE0423209E15}: [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.)	Travel Cincinnati per trip per person	Total
	Modification No.		Modification No.	0	Consultant Overhead Rate:	93.50%

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:	0.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/19/25	Example			Proposal Date	5/19/25	Net Fee Percentage:	8%

tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]

Comment:

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

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

Comment:

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

Deputy Program Manager

Program Analyst

Senior Safety Consultant I

Senior Safety Consultant II

Senior Safety Consultant III

Safety Analyst I

Safety Analyst II

Project Administrator

Safety Analyst III

Total

No. of Units

Average Hourly

Total

Labor

Overhead

Cost of

Direct

Subcon

Net

Total

Direct Cost Category:

Task Description

Direct Labor Rate

$89.12

tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [Threaded comment]

Comment:

Insert employee's labor rate excluding overhead rate $71.40 $56.40 $81.69 $75.78 $73.00 $63.97 $58.70 $39.50 $52.71 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $783.53 tc={4D6A823F-DE15-4A68-80CC-679AC9DC9756}: [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%							$483.32
	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: Data Analysis (Average 1250 Hours)													Task 1: Data Analysis (Average 1250 Hours)											Task 1: Data Analysis (Average 1250 Hours)
	Agency Safety Plans, Min Safety Stds	40	40	16		20	8	48		12		184	$12,967	Agency Safety Plans, Min Safety Stds	0	$70.47	184	$12,967.36	$12,124.48	$0.00	$0.00	$0.00	$2,697.00	$27,788.85	Agency Safety Plans, Min Safety Stds										$0.00
	Preventive/Corrective Maintenance, Data Analysis	40	40	16	16	24	16	48		12		212	$15,162	Preventive/Corrective Maintenance, Data Analysis	0	$71.52	212	$15,161.52	$14,176.02	$0.00	$0.00	$0.00	$3,153.35	$32,490.89	Preventive/Corrective Maintenance, Data Analysis										$0.00
	Safety Data - Notif, Invest, ISRs, CAPs	88	96	48	16	160	236	200		10		854	$61,253	Safety Data - Notif, Invest, ISRs, CAPs	0	$71.72	854	$61,253.00	$57,271.56	$0.00	$0.00	$0.00	$12,739.64	$131,264.20	Safety Data - Notif, Invest, ISRs, CAPs										$0.00
	TOTAL Task 1	168	176	80	32	204	260	296	0	34	0	1250	$89,382	TOTAL Task 1		$71.51	1250	$89,382	$83,572	$0.00	$0	$0	$18,590	$191,543.94	TOTAL Task 1	0	0	0	0	0	0	0	0	0	$0.00

Task 2: GCRTA Safety and Security Monitoring (Average 3500 hours)														Task 2: GCRTA Safety and Security Monitoring (Average 3500 hours)										Task 2: GCRTA Safety and Security Monitoring (Average 3500 hours)
Quarterly and other meetings		144	56	16	160	288	160	240	24			1088	$81,071	Quarterly and other meetings	$74.51	1088	$81,070.72	$75,801.12	$0.00	$31,341.20	$0.00	$16,861.41	$205,074.46	Quarterly and other meetings		40									$31,341.20
SRMM process		120	48	16	200	288	196	360	40			1268	$92,872	SRMM process	$73.24	1268	$92,871.84	$86,835.17	$0.00	$0.00	$0.00	$19,315.86	$199,022.87	SRMM process											$0.00
Capital projects		120	56	20	160	274	196	288	30			1144	$84,147	Capital projects	$73.56	1144	$84,147.28	$78,677.71	$0.00	$0.00	$0.00	$17,501.29	$180,326.27	Capital projects											$0.00
	TOTAL Task 2	384	160	52	520	850	552	888	94	0	0	3500	$258,090	TOTAL Task 2	$73.74	3500	$258,089.84	$241,314.00	$0.00	$31,341.20	$0.00	$53,678.56	$584,423.60		TOTAL Task 2	40	0	0	0	0	0	0	0	0	$31,341.20

Task 3: RWP Planning and Oversight (Average 500 hours)													Task 3: RWP Planning and Oversight (Average 500 hours)										Task 3: RWP Planning and Oversight (Average 500 hours)
Manual and Track Access	40	24	4	4	20		60				152	$11,185	Manual and Track Access	$73.58	152	$11,184.56	$10,457.56	$0.00	$0.00	$0.00	$2,326.21	$23,968.33	Manual and Track Access										$0.00
Reviews and Approvals	24	16	4	4	40		60				148	$10,703	Reviews and Approvals	$72.32	148	$10,703.04	$10,007.34	$0.00	$0.00	$0.00	$2,226.06	$22,936.44	Reviews and Approvals										$0.00
Annual Audit	40	24	4	4	48		50	24	6		200	$14,313	Annual Audit	$71.56	200	$14,312.50	$13,382.19	$0.00	$0.00	$0.00	$2,976.77	$30,671.46	Annual Audit										$0.00
TOTAL Task 3	104	64	12	12	108	0	170	24	6	0	500	$36,200	TOTAL Task 3	$72.40	500	$36,200.10	$33,847.09	$0.00	$0.00	$0.00	$7,529.04	$77,576.24	TOTAL Task 3	0	0	0	0	0	0	0	0	0	$0.00

Task 4: Cincinnati Safety and Security Monitoring (Average 1750 hrs)													Task 4: Cincinnati Safety and Security Monitoring (Average 1750 hrs)										Task 4: Cincinnati Safety and Security Monitoring (Average 1750 hrs)
Quarterly and other meetings	48	96	16	60	120	160	96	18			614	$44,907	Quarterly and other meetings	$73.14	614	$44,907.28	$41,988.31	$0.00	$11,599.68	$0.00	$9,340.00	$107,835.26	Quarterly and other meetings		24								$11,599.68
SRMM process	20	40	20	60	160	196	88	24			608	$44,139	SRMM process	$72.60	608	$44,138.76	$41,269.74	$0.00	$0.00	$0.00	$9,180.16	$94,588.66	SRMM process										$0.00
Capital projects	20	40	16	48	120	196	88				528	$38,493	Capital projects	$72.90	528	$38,492.88	$35,990.84	$0.00	$0.00	$0.00	$8,005.90	$82,489.63	Capital projects										$0.00
TOTAL Task 4	88	176	52	168	400	552	272	42	0	0	1750	$127,539	TOTAL Task 4	$72.88	1750	$127,538.92	$119,248.89	$0.00	$11,599.68	$0.00	$26,526.05	$284,913.54	TOTAL Task 4	0	24	0	0	0	0	0	0	0	$11,599.68

Task 5: Cincinnati On-site Triennial SSO Review (Average 200 hours)													Task 5: Cincinnati On-site Triennial SSO Review (Average 200 hours)										Task 5: Cincinnati On-site Triennial SSO Review (Average 200 hours)
Planning	8	28	8	4							48	$3,490	Planning	$72.71	48	$3,490.12	$3,263.26	$0.00	$0.00	$0.00	$725.89	$7,479.27	Planning											$0.00
Onsite	0	40	8	4							52	$3,634	Onsite	$69.88	52	$3,633.96	$3,397.75	$0.00	$0.00	$0.00	$755.81	$7,787.52	Onsite											$0.00
Reporting	12	56	8	4	4	4			12		100	$6,915	Reporting	$69.15	100	$6,914.92	$6,465.45	$0.00	$0.00	$0.00	$1,438.19	$14,818.56	Reporting		0	0	0	0	0	0	0	0	0	$0.00
TOTAL Task 5	20	124	24	12	4	4	0	0	12	0	200	$14,039	TOTAL Task 5	$70.20	200	$14,039.00	$13,126.47	$0.00	$0.00	$0.00	$2,919.89	$30,085.35		TOTAL Task 5	0	0	0	0	0	0	0	0	0	$0.00

Task 6: ODOT Reports/FTA Annual Report/Program Revision/Other Tasks Assigned (Average 800 hours)													Task 6: ODOT Reports/FTA Annual Report/Program Revision/Other Tasks Assigned (Average 800 hours)										Task 6: ODOT Reports/FTA Annual Report/Program Revision/Other Tasks Assigned (Average 800 hours)
Program Standard and Reference Guide	80	24	16	12	4		60		40		236	$16,447	Program Standard and Reference Guide	$69.69	236	$16,447.20	$15,378.13	$0.00	$0.00	$0.00	$3,420.75	$35,246.09	Program Standard and Reference Guide										$0.00
Annual Reporting	24	24	16	24	4		240		20		352	$23,161	Annual Reporting	$65.80	352	$23,161.36	$21,655.87	$0.00	$0.00	$0.00	$4,817.19	$49,634.42	Annual Reporting										$0.00
Other Reporting	40	24	20		16		96		16		212	$14,392	Other Reporting	$67.89	212	$14,392.00	$13,456.52	$0.00	$0.00	$0.00	$2,993.31	$30,841.83	Other Reporting										$0.00
TOTAL Task 6	144	72	52	36	24	0	396	0	76	0	800	$54,001	TOTAL Task 6	$67.50	800	$54,000.56	$50,490.52	$0.00	$0.00	$0.00	$11,231.25	$115,722.34	TOTAL Task 6	0	0	0	0	0	0	0	0	0	$0.00

Task 7: Risk-Based Inspections: GCRTA (Average 400 hours)													Task 7: Risk-Based Inspections: GCRTA (Average 400 hours)										Task 7: Risk-Based Inspections: GCRTA (Average 400 hours)
Safety Risk Prioritization	24	40	8		4		48				124	$8,820	Safety Risk Prioritization	$71.13	124	$8,819.76	$8,246.48	$0.00	$0.00	$0.00	$1,834.37	$18,900.60	Safety Risk Prioritization										$0.00
RBI Selection and Completion	24	52	8		4		40				128	$9,165	RBI Selection and Completion	$71.60	128	$9,164.80	$8,569.09	$0.00	$0.00	$0.00	$1,906.13	$19,640.02	RBI Selection and Completion										$0.00
RBI Reporting	24	40	8		4	16	40		16		148	$10,108	RBI Reporting	$68.30	148	$10,108.00	$9,450.98	$0.00	$0.00	$0.00	$2,102.30	$21,661.28	RBI Reporting										$0.00
TOTAL Task 7	72	132	24	0	12	16	128	0	16	0	400	$28,093	TOTAL Task 7	$70.23	400	$28,092.56	$26,266.54	$0.00	$0.00	$0.00	$5,842.80	$60,201.91	TOTAL Task 7	0	0	0	0	0	0	0	0	0	$0.00

Task 8: Risk-Based Inspections: Cincinnati (Average 200 hours)													Task 8: Risk-Based Inspections: Cincinnati (Average 200 hours)										Task 8: Risk-Based Inspections: Cincinnati (Average 200 hours)
Safety Risk Prioritization	4	12	8		4		24				52	$3,503	Safety Risk Prioritization	$67.36	52	$3,502.88	$3,275.19	$0.00	$0.00	$0.00	$728.54	$7,506.62	Safety Risk Prioritization										$0.00
RBI Selection and Completion	8	16	8		4		24				60	$4,145	RBI Selection and Completion	$69.08	60	$4,144.96	$3,875.54	$0.00	$0.00	$0.00	$862.09	$8,882.58	RBI Selection and Completion										$0.00
RBI Reporting	8	12	8		4	16	24		16		88	$5,659	RBI Reporting	$64.31	88	$5,659.36	$5,291.50	$0.00	$0.00	$0.00	$1,177.06	$12,127.92	RBI Reporting										$0.00
TOTAL Task 8	20	40	24	0	12	16	72	0	16	0	200	$13,307	TOTAL Task 8	$66.54	200	$13,307.20	$12,442.23	$0.00	$0.00	$0.00	$2,767.68	$28,517.12	TOTAL Task 8	0	0	0	0	0	0	0	0	0	$0.00

TOTAL Known Tasks 1000 944 320 780 1614 1400 2222 160 160 0 8600 $620,650.06 TOTAL Known Tasks $72.17 8600 $620,650.06 $580,307.81 $0.00 $42,940.88 $0.00 $129,085.28 $1,372,984.03 TOTAL Known Tasks 40 24 0 0 0 0 0 0 0 $42,940.88

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	$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	$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	$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	$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	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 $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	$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	$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	$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	$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	$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	$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 $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	$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 $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 $72.17 8600 $620,650.06 $580,307.81 $0.00 $42,940.88 $0.00 $129,085.28 $1,372,984.03

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. Use the amount of average hours ODOT has provided for these known tasks using the past three years historical data. The subtask lines are provided for the proposer to subdivide the task and hours if desired.	The Known Tasks are comprised of the typical tasks ODOT conducts each year with this 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: Safety Oversight (Rail Transit)
Consultant:	Vital Assurance Ltd.
Agreement No.	0
Modification No.	0
PID No.	0
Proposal Date	5/19/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
$72.17	8600	$620,650	$580,308	$0	$42,941	$0	$129,085	$1,372,984
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
$72.17	8600	$620,650	$580,308	$0	$42,941	$0	$129,085	$1,372,984

IF-AUTHORIZED TASKS:

Planning Phase

Preliminary Engineering Phase

Environmental Engineering Phase

Final Engineering Phase

Construction Engineering Phase

TOTAL IF-AUTHORIZED TASKS

GRAND TOTAL

&"Arial,Bold"&18SUMMARY OF STEPS

&F &9&P of &N &D

Narratives

0	RFP: Safety Oversight (Rail Transit)	Consultant	ODOT	LPA	If-Authorized
Consultant:	Vital Assurance Ltd.
Agreement No.	0
Modification No.	0
PID No.	0
Proposal Date	5/19/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).

The costs submitted to ODOT through this Cost Proposal Summary will serve as the final cost for the awarded contract.

image1.emf

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