Attachment J-8 - 2024 Maximum Labor Rate Calculation for Firm Fixed Price Task Orders - Revised Version 1 - Final.xlsx

XLSX spreadsheet 63 KB Posted Dec 13, 2023

Attached to: Amendment 0001 - Request for Proposal (RFP) Project Management Oversight (PMO) Requirement
Solicitation number: FTA_2024_PMO_0005
Issued by: Department of Transportation Federal Transit Administration

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a spreadsheet with labor categories, rates, and calculations for a firm fixed price contract. It includes 33 labor categories for technical staff along with program managers, consultants, and administrative support. Standard labor categories include engineers, managers, and technical writers. Key personnel and mission critical personnel are designated. Fully loaded hourly rates are calculated for each labor category and escalated at 3.7% annually over five years. Estimated hours and direct costs are provided for each year and in total. This analysis appears to support a request for proposals for project management oversight services from the Department of Transportation Federal Transit Administration, solicitation number FTA_2024_PMO_0005, as amended.

View the file

Other files

File	Type	Posted
Attachment 1 - 2024 PMO RFP Response to Questions.xlsx	XLSX spreadsheet	Dec 13, 2023
Attachment J-1 - Proposal Checklist - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-3 - Past Performance Questionnaire - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-4 - Small Business Subcontracting Plan - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-7 - 2024 PMO Contract Pricing Summary Workbook - Revised Version 1 - Final.xlsx	XLSX spreadsheet	Dec 13, 2023
Amendment 0001 - Soliciation 69319524R000001 Executed.pdf	PDF	Dec 13, 2023
Attachment 1 - 2024 PMO RFP Response to Questions.pdf	PDF	Dec 13, 2023
Attachment J-14 - Small Business Certification - Letter of Intent - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-13 - Tables B.24, B.25, B.28 and B.29 - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-2 - Resume Form - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-11 - Conflict of Interest Matrix for 2024 - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-12 - Appendix F - 2023 FTA PMOC Invoice Template - V3.0.2 - Final.pdf	PDF	Dec 13, 2023
Attachment J-7 - 2024 PMO Contract Pricing Summary Workbook - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-8 - 2024 Maximum Labor Rate Calculation for Firm Fixed Price Task Orders - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-10 - Combined 2024 Final OPs - Revised Version 1 - Final.pdf	PDF	Dec 13, 2023
Attachment J-11 - Conflict of Interest Matrix for 2024 - Revised Version 1 - Final.xlsx	XLSX spreadsheet	Dec 13, 2023
Attachment J-13 - Tables B.24, B.25, B.28 and B.29 - Revised Version 1 - Final.xlsx	XLSX spreadsheet	Dec 13, 2023

Show all 17

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.

1 - FFP Labor Rate - Revised

Attachment J-8: 2024 Maximum Labor Rate Calculation for Firm Fixed Price Task Orders

Labor Category

Direct Labor Rate

Fringe Benefit Rates

Fringe Benefits

Overhead Rates

Overhead

G&A Rates

G&A

Profit Rates

Profit

Year I Fully Loaded Hourly Labor Rate

Year II*** Fully Loaded Hourly Labor Rate

Year III*** Fully Loaded Hourly Labor Rate

Year IV*** Fully Loaded Hourly Labor Rate

Year V*** Fully Loaded Hourly Labor Rate

Year I Hours

Year II Hours

Year III Hours

Year IV Hours

Year V Hours

5-Year Sum of

Total Hours (J thru N) O Year I Direct Cost (D*J) Q Year II Direct Cost (E*K) R Year III Direct Cost (F*L) S Year IV Direct Cost (G*M) T Year V Direct Cost (H*N) U 5-Year Sum of Total Direct Cost (P thru T) V

L
1	Program Manager*	$ 50.00	15%	$ 7.50	95.00%	$ 47.50	5%	$ 2.50	9%	$ 9.67	$ 117.18	$ 121.51	$ 126.01	$ 130.67	$ 135.50	2000	2000	2000	2000	2000	10000	$234,350.00	$243,020.95	$252,012.73	$261,337.20	$271,006.67	$ 1,261,728
2	Task Order Manager I*	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	2000	2000	2000	2000	2000	10000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
3	Task Order Manager I*	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	2000	2000	2000	2000	2000	10000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
4	Task Order Manager II*	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	2000	2000	2000	2000	2000	10000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
5	Task Order Manager II*	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	2000	2000	2000	2000	2000	10000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
6	Systems Integration Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
7	Systems Integration Engineer II**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
8	Risk Assessment Mgr I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
9	Risk Assessment Mgr II**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
10	Civil/Environmental Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
11	Civil/Environmental Engineer II**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	1000	1000	1000	1000	1000	5000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
12	QA/QC Manager**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	400	400	400	400	400	2000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
13	Systems Safety Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	400	400	400	400	400	2000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
14	Cost Estimation Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	200	200	200	200	200	1000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
15	Project Scheduling Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
16	Vehicle Engineer	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
17	Real Estate Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
18	Contract Procurement Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	200	200	200	200	200	1000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
19	Transit Operations Manager	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
20	Communications Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
21	Communications Engineer II	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
22	Structural Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
23	Structural Engineer II**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
24	Buy America Expert I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
25	Buy America Expert II	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
26	Mechanical Engineer	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
27	Electrical Power Distribution Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
28	Electrical Power Distribution Engineer II	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
29	Rail Transit Signal and Control Systems Engineer I	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
30	Rail Transit Signal and Control Systems Engineer II	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
31	Tunneling Engineer	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	300	300	300	300	300	1500	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
32	Technical Writer**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	800	800	800	800	800	4000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
33	Clerical Support**	$ - 0	0%	$ - 0	0.00%	$ - 0	0%	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	800	800	800	800	800	4000	$0.00	$0.00	$0.00	$0.00	$0.00	$ - 0
L
	* Key Personnel

** Mission Critical Personnel Note: Assumes a 3.7% Escalation Rate

***Consultants
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
Consultant	$ 100.00	800	800	800	800	800	4000	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$80,000.00	$ 400,000
*** No escalation Rate for Consultants

image1.jpeg image2.jpeg

File details come from the government source that posted it. Updated Dec 13, 2023.