Att JS-2 - Staffing Plan.xlsx

XLSX spreadsheet 150 KB Posted Aug 4, 2023

Attached to: Surface Ship Undersea Warfare (USW) Combat System Production Federal contract opportunity
Solicitation number: N0002423R5202
Issued by: Department of the Navy Naval Sea Systems Command

About this file

Written by GovTribe AI · Dec 21, 2023

The document contains a staffing plan template and related details for a federal contract opportunity for Surface Ship Undersea Warfare (USW) Combat System Production solicited by the Department of the Navy Naval Sea Systems Command. The staffing plan template requires information on proposed labor hours, individuals, labor categories, experience, education, work locations, and task areas supported across multiple contract line item numbers for years 2024 through 2031. It includes estimated labor hour breakdowns by category including program management, administration, engineering, engineering support, and production management. Pricing and award details are not provided as the document appears to be an attachment to a broader solicitation.

View the file

Other files for this federal contract opportunity

Other files attached to Surface Ship Undersea Warfare (USW) Combat System Production, newest first.
File	Type	Posted
N0002423R5202 Amendment 0002.pdf	PDF	Sep 26, 2023
N00024-23-R-5202 Bidders Question Responses 09072023.pdf	PDF	Sep 7, 2023
Att J-2 - GFP List Amendment 0001.xlsx	XLSX spreadsheet	Sep 7, 2023
Attch JS-2 - Staffing Plan Amendment 0001.xlsx	XLSX spreadsheet	Sep 7, 2023
Attch JS-3 - Cost Element Summary Spreadsheets Amendment 0001.xlsx	XLSX spreadsheet	Sep 7, 2023
N0002423R5202 Amendment 0001.pdf	PDF	Sep 7, 2023
N00024-23-R-5202 Bidders Questions Response 080823.pdf	PDF	Aug 8, 2023
N00024-23-R-5203 Draft RFP Responses.pdf	PDF	Aug 4, 2023
Exhibit A - Contract Data Requirements List.xlsx	XLSX spreadsheet	Aug 4, 2023
Exhibit A_Attachment 1 - Data Distribution List.docx	DOCX document	Aug 4, 2023
Att JS-4 Contractor Award Information.docx	DOCX document	Aug 4, 2023
Att J-1 DD254.pdf	PDF	Aug 4, 2023
Att J-2 - GFP List.xlsx	XLSX spreadsheet	Aug 4, 2023
Att J-5 - CDRL Reference.xlsx	XLSX spreadsheet	Aug 4, 2023
N00024-23-R-5202 FINAL 08042023.pdf	PDF	Aug 4, 2023
Att JS-1 Bidders Question Submittal Form.xlsx	XLSX spreadsheet	Aug 4, 2023
Att JS-3 Cost Element Summary Spreadsheets.xlsx	XLSX spreadsheet	Aug 4, 2023
Att J-3 - GFI List - 23Mar23.pdf	PDF	Aug 4, 2023

Show all 18

On GovTribe

Work with this file on GovTribe

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.

Staffing Plan - 5218 numbers

	Attachment JS-15
	N0002422R5231
	Prime Offeror Name											82288	93884	197982	206612	225375	211245	162432	137382	0	1200	28846	28846	28846	28846	28846	28846
	a.	b.	c.	d.	e.	f.	g.	h.	i.	j.	k.	l. LABOR HOURS PROPOSED
	INDIVIDUAL'S NAME	COMPANY NAME
(Prime or subcontractor)	COMPANY LABOR CATEGORY	YEARS OF APPLICABLE PROFESSIONAL EXPERIENCE	HIGHEST DEGREE	DEGREE AREA	IF NO DEGREE, RELEVANT CERTIFICATES ATTAINED	WORK LOCATION	TASK AREA SUPPORTED	RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002	CLIN 0008	CLIN 1008	CLIN 2008	CLIN 3008	CLIN 4008	CLIN 5008	CLIN 6008	CLIN 7008
									ETS	Sr Program Manager	Senior Level	4278	4882	10295	10508	11325	10591	8052	6748
									ETS	Program Manager	Mid-Level	2138	2441	5147	5253	5662	5296	4026	3374
									ETS	Contracts Manager	Mid-Level	1605	1831	3861	3940	4247	3971	3019	2531
									ETS	Business Financial Manager	Mid-Level	1070	1221	2574	2627	2831	2648	2013	1687
									ETS	Operations Manager	Mid-Level	1605	1831	3861	3940	4247	3971	3019	2531
									ETS	Financial Analyst	Mid-Level	926	1056	2227	2273	2450	2291	1742	1460
									ETS	Operations Support	Mid-Level	720	821	1732	1768	1906	1782	1355	1136
									ETS	Scientist	Mid-Level	8393	9576	20194	20610	22214	20773	15794	13239
									ETS	Chief Engineer	Senior Level	8393	9576	20194	20610	22214	20773	15794	13239
									ETS	Sr Engineer	Senior Level	5596	6384	13463	13740	14809	13848	10529	8826
									ETS	Mid Engineer	Mid-Level	2798	3192	6731	6870	7405	6924	5265	4413
									ETS	Jr Engineer	Junior Level	2798	3192	6731	6870	7405	6924	5265	4413
									ETS	Cybersecurity Engineer	Mid-Level	2798	3192	6731	6870	7405	6924	5265	4413
									ETS	System Engineer	Senior Level	5596	6384	13463	13740	14809	13848	10529	8826
									ETS	Programmer	Mid-Level	5596	6384	13463	13740	14809	13848	10529	8826
									ETS	IT Analyst	Junior Level	1119	1277	2693	2748	2962	2770	2106	1765
									ETS	Sr Software Engineer	Senior Level	5596	6384	13463	13740	14809	13848	10529	8826
									ETS	Software Engineer	Mid-Level	4476	5107	10770	10992	11848	11079	8423	7061
									ETS	Manufacturing Engineer	Mid-Level	1679	1915	4039	4122	4443	4155	3159	2648
									ETS	Draftsman	Junior Level	1119	1277	2693	2748	2962	2770	2106	1765
									ETS	Sr Logistics Manager	Senior Level	3317	3785	7981	8145	8779	8210	6242	5232
									ETS	ILS Mgmt Support Specialist IV	Mid-Level	4860	5545	11693	11934	12863	12028	9145	7666
									ETS	ILS Mgmt Support Specialist III	Junior Level	4166	4753	10023	10229	11025	10310	7839	6571
									ETS	Support/Admin	Junior Level	1646	1878	3960	4041	4356	4073	3097	2596
									ETS	Specialist Technician/Admin offsite	Senior Level	0	0	0	2277	3795	3795	3795	3795
									ETS	Sr Specialist Technician/Admin offsite	Mid-Level	0	0	0	2277	3795	3795	3795	3795
									PMO	Sr Principal Analyst										0	87	2099	2099	2099	2099	2099	2099
									PMO	Principal Analyst										0	316	7634	7634	7634	7634	7634	7634
									PMO	Analyst										0	56	1335	1335	1335	1335	1335	1335
									PMO	Sr Engineer										0	187	4487	4487	4487	4487	4487	4487
									PMO	Engineer										0	20	475	475	475	475	475	475
									PMO	Sr Staff Engineer										0	186	4475	4475	4475	4475	4475	4475
									PMO	Staff Engineer										0	176	4220	4220	4220	4220	4220	4220
									PMO	Principal Engineer										0	86	2070	2070	2070	2070	2070	2070
									PMO	Associate Engineer										0	49	1181	1181	1181	1181	1181	1181
									PMO	Manufacturing Non Technical Professional										0	0	0	0	0	0	0	0
									PMO	Manufacturing Technical Professional										0	0	0	0	0	0	0	0
									PMO	Manufacturing Technical Non exempt										0	0	0	0	0	0	0	0
									PMO	Manufacturing Support exempt										0	0	0	0	0	0	0	0
									PMO	Test Specialist										0	27	653	653	653	653	653	653
									PMO	Production Test Engineer										0	1	22	22	22	22	22	22
									PMO	Designer-Drafter-Illustrator										0	0	0	0	0	0	0	0

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PM			ADMIN			ENG			ENG SUPPORT
	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior
% of Total	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Note:	1. Full Staffing Plan to be provided in the format above
	2. Cost information should not be included in this sheet

Staffing Plan - 5218 Percentage

	Attachment JS-15
	N0002422R5231
	Prime Offeror Name											82288	93884	197982	206612	225375	211245	162432	137382	0	1200	28846	28846	28846	28846	28846	28846
	a.	b.	c.	d.	e.	f.	g.	h.	i.	j.	k.	l. LABOR HOURS PROPOSED
	INDIVIDUAL'S NAME	COMPANY NAME
(Prime or subcontractor)	COMPANY LABOR CATEGORY	YEARS OF APPLICABLE PROFESSIONAL EXPERIENCE	HIGHEST DEGREE	DEGREE AREA	IF NO DEGREE, RELEVANT CERTIFICATES ATTAINED	WORK LOCATION	TASK AREA SUPPORTED	RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002	CLIN 0008	CLIN 1008	CLIN 2008	CLIN 3008	CLIN 4008	CLIN 5008	CLIN 6008	CLIN 7008	Average
									ETS	Sr Program Manager	Senior Level	5.20%	5.20%	5.20%	5.09%	5.02%	5.01%	4.96%	4.91%									5.07%
									ETS	Program Manager	Mid-Level	2.60%	2.60%	2.60%	2.54%	2.51%	2.51%	2.48%	2.46%									2.54%
									ETS	Contracts Manager	Mid-Level	1.95%	1.95%	1.95%	1.91%	1.88%	1.88%	1.86%	1.84%									1.90%
									ETS	Business Financial Manager	Mid-Level	1.30%	1.30%	1.30%	1.27%	1.26%	1.25%	1.24%	1.23%									1.27%
									ETS	Operations Manager	Mid-Level	1.95%	1.95%	1.95%	1.91%	1.88%	1.88%	1.86%	1.84%									1.90%
									ETS	Financial Analyst	Mid-Level	1.13%	1.12%	1.12%	1.10%	1.09%	1.08%	1.07%	1.06%
									ETS	Operations Support	Mid-Level	0.87%	0.87%	0.87%	0.86%	0.85%	0.84%	0.83%	0.83%
									ETS	Scientist	Mid-Level	10.20%	10.20%	10.20%	9.98%	9.86%	9.83%	9.72%	9.64%
									ETS	Chief Engineer	Senior Level	10.20%	10.20%	10.20%	9.98%	9.86%	9.83%	9.72%	9.64%
									ETS	Sr Engineer	Senior Level	6.80%	6.80%	6.80%	6.65%	6.57%	6.56%	6.48%	6.42%
									ETS	Mid Engineer	Mid-Level	3.40%	3.40%	3.40%	3.33%	3.29%	3.28%	3.24%	3.21%
									ETS	Jr Engineer	Junior Level	3.40%	3.40%	3.40%	3.33%	3.29%	3.28%	3.24%	3.21%
									ETS	Cybersecurity Engineer	Mid-Level	3.40%	3.40%	3.40%	3.33%	3.29%	3.28%	3.24%	3.21%
									ETS	System Engineer	Senior Level	6.80%	6.80%	6.80%	6.65%	6.57%	6.56%	6.48%	6.42%
										Programmer	Mid-Level	6.80%	6.80%	6.80%	6.65%	6.57%	6.56%	6.48%	6.42%
									ETS	IT Analyst	Junior Level	1.36%	1.36%	1.36%	1.33%	1.31%	1.31%	1.30%	1.28%
										Sr Software Engineer	Senior Level	6.80%	6.80%	6.80%	6.65%	6.57%	6.56%	6.48%	6.42%
									ETS	Software Engineer	Mid-Level	5.44%	5.44%	5.44%	5.32%	5.26%	5.24%	5.19%	5.14%
									ETS	Manufacturing Engineer	Mid-Level	2.04%	2.04%	2.04%	2.00%	1.97%	1.97%	1.94%	1.93%
									ETS	Draftsman	Junior Level	1.36%	1.36%	1.36%	1.33%	1.31%	1.31%	1.30%	1.28%
									ETS	Sr Logistics Manager	Senior Level	4.03%	4.03%	4.03%	3.94%	3.90%	3.89%	3.84%	3.81%									3.93%
									ETS	ILS Mgmt Support Specialist IV	Mid-Level	5.91%	5.91%	5.91%	5.78%	5.71%	5.69%	5.63%	5.58%
									ETS	ILS Mgmt Support Specialist III	Junior Level	5.06%	5.06%	5.06%	4.95%	4.89%	4.88%	4.83%	4.78%
									ETS	Support/Admin	Junior Level	2.00%	2.00%	2.00%	1.96%	1.93%	1.93%	1.91%	1.89%									16.62%
									ETS	Specialist Technician/Admin offsite	Senior Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%
									ETS	Sr Specialist Technician/Admin offsite	Mid-Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%
									PMO	Sr Principal Analyst										0.00%	7.25%	7.28%	7.28%	7.28%	7.28%	7.28%	7.28%
									PMO	Principal Analyst										0.00%	26.33%	26.46%	26.46%	26.46%	26.46%	26.46%	26.46%
									PMO	Analyst										0.00%	4.67%	4.63%	4.63%	4.63%	4.63%	4.63%	4.63%
									PMO	Sr Engineer										0.00%	15.58%	15.56%	15.56%	15.56%	15.56%	15.56%	15.56%
									PMO	Sr Staff Engineer										0.00%	1.67%	1.65%	1.65%	1.65%	1.65%	1.65%	1.65%
									PMO	Staff Engineer										0.00%	15.50%	15.51%	15.51%	15.51%	15.51%	15.51%	15.51%
									PMO	Principal Engineer										0.00%	14.67%	14.63%	14.63%	14.63%	14.63%	14.63%	14.63%
									PMO	Associate Engineer										0.00%	7.17%	7.18%	7.18%	7.18%	7.18%	7.18%	7.18%
									PMO	Manufacturing Non Technical Professional										0.00%	4.08%	4.09%	4.09%	4.09%	4.09%	4.09%	4.09%
									PMO	Manufacturing Technical Professional										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
									PMO	Manufacturing Technical Non exempt										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
									PMO	Manufacturing Support exempt										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
									PMO	Test Specialist										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
									PMO	Production Test Engineer										0.00%	2.25%	2.26%	2.26%	2.26%	2.26%	2.26%	2.26%
									PMO	Designer-Drafter-Illustrator										0.00%	0.08%	0.08%	0.08%	0.08%	0.08%	0.08%	0.08%

Note:	1. Full Staffing Plan to be provided in the format above
	2. Cost information should not be included in this sheet

Engineering Services Estimated Breakout & Labor Mix – CLINs x002

ADMIN

ENG

TECH

Junior

Mid

Senior

Junior

Mid

Senior

Junior

Mid

Senior

Junior

Mid

Senior

% of Total

Staffing Plan - Follow on %

	Attachment JS-15
	N0002422R5231
	Prime Offeror Name																				0	1200	28846	28846	28846	28846	28846	28846
	a.	b.	c.	d.	e.	f.	g.	h.		i.	j.	k.	l. LABOR HOURS PROPOSED																		Deltas
	INDIVIDUAL'S NAME	COMPANY NAME
(Prime or subcontractor)	COMPANY LABOR CATEGORY	YEARS OF APPLICABLE PROFESSIONAL EXPERIENCE	HIGHEST DEGREE	DEGREE AREA	IF NO DEGREE, RELEVANT CERTIFICATES ATTAINED	WORK LOCATION	PM/ADMIN/ENG/SUPPORT	TASK AREA SUPPORTED	RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002	CLIN 0008	CLIN 1008	CLIN 2008	CLIN 3008	CLIN 4008	CLIN 5008	CLIN 6008	CLIN 7008	Average		RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002-2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002
									PM	ETS	Sr Program Manager	Senior Level	5.00%	5.00%	5.00%	4.59%	4.52%	4.51%	4.46%	4.41%									4.69%		Sr Program Manager	Senior Level	-0.20%	-0.50%	-0.50%	-0.50%	-0.50%	-0.50%
									PM	ETS	Program Manager	Mid-Level	2.90%	2.90%	2.90%	2.84%	2.81%	2.81%	2.78%	2.76%									2.84%		Program Manager	Mid-Level	0.30%	0.30%	0.30%	0.30%	0.30%	0.30%
									PM	ETS	Contracts Manager	Mid-Level	1.95%	1.95%	1.95%	2.21%	2.18%	2.18%	2.16%	2.14%									2.09%		Contracts Manager	Mid-Level	0.00%	0.30%	0.30%	0.30%	0.30%	0.30%
									PM	ETS	Business Financial Manager	Mid-Level	1.30%	1.30%	1.30%	1.17%	1.16%	1.15%	1.14%	1.13%									1.21%		Business Financial Manager	Mid-Level	0.00%	-0.10%	-0.10%	-0.10%	-0.10%	-0.10%
									PM	ETS	Operations Manager	Mid-Level	1.95%	1.95%	1.95%	1.71%	1.68%	1.68%	1.66%	1.64%									1.78%		Operations Manager	Mid-Level	0.00%	-0.20%	-0.20%	-0.20%	-0.20%	-0.20%
									ADMIN	ETS	Financial Analyst	Mid-Level	1.13%	1.13%	1.13%	1.10%	1.09%	1.08%	1.07%	1.06%									1.10%		Financial Analyst	Mid-Level	0.00%	0	0	0	0	0
									ADMIN	ETS	Operations Support	Mid-Level	0.87%	0.87%	0.87%	0.86%	0.85%	0.84%	0.83%	0.83%									0.85%		Operations Support	Mid-Level	0.00%	0	0	0	0	0
									SUPPORT	ETS	Scientist	Mid-Level	8.60%	8.60%	8.60%	8.18%	8.06%	8.03%	7.92%	7.84%									8.23%		Scientist	Mid-Level	-1.60%	0.20%	0.20%	0.20%	0.20%	0.20%
									SUPPORT	ETS	Scientist	Junior Level	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%									2.00%		Scientist	Junior Level
									ENG	ETS	Chief Engineer	Senior Level	10.60%	10.60%	10.60%	10.38%	10.26%	10.23%	10.12%	10.04%									10.35%		Chief Engineer	Senior Level	0.40%	0.40%	0.40%	0.40%	0.40%	0.40%
									ENG	ETS	Sr Engineer	Senior Level	9.80%	9.80%	9.80%	9.65%	9.57%	9.56%	9.48%	9.42%									9.64%		Sr Engineer	Senior Level	3.00%	3%	3%	3%	3%	3%
									ENG	ETS	Mid Engineer	Mid-Level	5.80%	5.80%	5.80%	5.63%	5.59%	5.58%	5.54%	5.51%									5.66%		Mid Engineer	Mid-Level	2.40%	2.30%	2.30%	2.30%	2.30%	2.30%
									ENG	ETS	Jr Engineer	Junior Level	5.40%	5.40%	5.40%	5.63%	5.59%	5.58%	5.54%	5.51%									5.51%		Jr Engineer	Junior Level	2.00%	2%	2%	2%	2%	2%
									ENG	ETS	Cybersecurity Engineer	Mid-Level	3.80%	3.80%	3.80%	3.73%	3.69%	3.68%	3.64%	3.61%									3.72%		Cybersecurity Engineer	Mid-Level	0.40%	0.40%	0.40%	0.40%	0.40%	0.40%
									ENG	ETS	System Engineer	Senior Level	6.90%	6.90%	6.90%	6.75%	6.67%	6.66%	6.58%	6.52%									6.74%		System Engineer	Senior Level	0.10%	0.10%	0.10%	0.10%	0.10%	0.10%
									ENG	ETS	System Engineer	Mid-Level	2.00%	2.00%	2.00%	2.16%	2.00%	2.00%	2.00%	2.00%									2.02%		System Engineer	Mid-Level	-4.80%	-4.49%	-4.57%	-4.56%	-4.48%	-4.42%
									SUPPORT	ETS	IT Analyst	Junior Level	2.16%	2.16%	2.16%	2.13%	2.11%	2.11%	2.10%	2.08%									2.13%		IT Analyst	Junior Level	0.80%	0.80%	0.80%	0.80%	0.80%	0.80%
																																	-6.80%	-6.65%	-6.57%	-6.56%	-6.48%	-6.42%
									ENG	ETS	Software Engineer	Mid-Level	6.44%	6.44%	6.44%	6.32%	6.26%	6.22%	6.01%	5.84%									6.25%		Software Engineer	Mid-Level	1.00%	1%	1%	1%	1%	1%
									ENG	ETS	Manufacturing Engineer	Mid-Level	5.04%	5.04%	5.04%	4.84%	4.81%	4.81%	4.78%	4.77%									4.89%		Manufacturing Engineer	Mid-Level	3.00%	3%	3%	3%	3%	3%
									SUPPORT	ETS	Draftsman	Junior Level	3.36%	3.36%	3.36%	3.33%	3.31%	3.31%	3.30%	3.28%									3.33%		Draftsman	Junior Level	2.00%	2%	2%	2%	2%	2%
									PM	ETS	Sr Logistics Manager	Senior Level	4.03%	4.03%	4.03%	3.94%	3.90%	3.89%	3.84%	3.81%									3.93%		Sr Logistics Manager	Senior Level	0.00%	0	0	0	0	0
									ADMIN	ETS	ILS Mgmt Support Specialist IV	Mid-Level	3.91%	3.91%	3.91%	3.78%	3.71%	3.69%	3.63%	3.58%									3.76%		ILS Mgmt Support Specialist IV	Mid-Level	-2.00%	-2%	-2%	-2%	-2%	-2%
									ADMIN	ETS	ILS Mgmt Support Specialist III	Junior Level	3.06%	3.06%	3.06%	2.95%	2.89%	2.88%	2.83%	2.78%									2.94%		ILS Mgmt Support Specialist III	Junior Level	-2.00%	-2%	-2%	-2%	-2%	-2%
									ADMIN	ETS	Support/Admin	Junior Level	2.00%	2.00%	2.00%	1.96%	1.93%	1.93%	1.91%	1.89%									1.95%		Support/Admin	Junior Level	0.00%	0	0	0	0	0
									ADMIN	ETS	Specialist Technician/Admin offsite	Senior Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%									1.21%		Specialist Technician/Admin offsite	Senior Level	0.00%	0	0	0	0	0
									ADMIN	ETS	Sr Specialist Technician/Admin offsite	Mid-Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%									1.21%		Sr Specialist Technician/Admin offsite	Mid-Level	0.00%	0	0	0	0	0
										PMO	Sr Principal Analyst										0.00%	7.25%	7.28%	7.28%	7.28%	7.28%	7.28%	7.28%	6.36%
										PMO	Principal Analyst										0.00%	26.33%	26.46%	26.46%	26.46%	26.46%	26.46%	26.46%	23.14%
										PMO	Analyst										0.00%	4.67%	4.63%	4.63%	4.63%	4.63%	4.63%	4.63%	4.05%
										PMO	Sr Engineer										0.00%	15.58%	15.56%	15.56%	15.56%	15.56%	15.56%	15.56%	13.61%
										PMO	Sr Staff Engineer										0.00%	1.67%	1.65%	1.65%	1.65%	1.65%	1.65%	1.65%	1.44%
										PMO	Staff Engineer										0.00%	15.50%	15.51%	15.51%	15.51%	15.51%	15.51%	15.51%	13.57%
										PMO	Principal Engineer										0.00%	14.67%	14.63%	14.63%	14.63%	14.63%	14.63%	14.63%	12.81%
										PMO	Associate Engineer										0.00%	7.17%	7.18%	7.18%	7.18%	7.18%	7.18%	7.18%	6.28%
										PMO	Manufacturing Non Technical Professional										0.00%	4.08%	4.09%	4.09%	4.09%	4.09%	4.09%	4.09%	3.58%
										PMO	Manufacturing Technical Professional										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
										PMO	Manufacturing Technical Non exempt										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
										PMO	Manufacturing Support exempt										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
										PMO	Test Specialist										0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
										PMO	Production Test Engineer										0.00%	2.25%	2.26%	2.26%	2.26%	2.26%	2.26%	2.26%	1.98%
										PMO	Designer-Drafter-Illustrator										0.00%	0.08%	0.08%	0.08%	0.08%	0.08%	0.08%	0.08%	0.07%

Note:	1. Full Staffing Plan to be provided in the format above
	2. Cost information should not be included in this sheet

			7.34%
Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PM			ADMIN			ENG			ENG SUPPORT
	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior
% of Total	0%	7.91%	8.62%	5%	7%	1%	6%	23%	27%	7%	8%	0%

Staffing Plan - Follow on #s

	Attachment JS-15											2024	2025	2026	2027	2028	2029	2030	2031
	N0002422R5231										FTEs	77.8	203.2	142.8	43.0	104.7	75.3	41.0	104.7																				`	78.7	151.4	129.7	68.0	88.4	77.0	61.6	89.7
	Prime Offeror Name										Hours	161796	422559	296929	89481	217729	156649	85183	217729	0	1200	28846	28846	28846	28846	28846	28846
	a.	b.	c.	d.	e.	f.	g.	h.	i.	j.	k.	l. LABOR HOURS PROPOSED																			FTEs (calculated)									FTEs (Should be)
												HT0 TDP Update	First Article HT0+	Produce HT0+, HT1 T/S & Design	Produce HT0+, HT1 TDP	Produce HT1, EQT HT1	Produce HT1	Produce HT1	Maybe HT1
	INDIVIDUAL'S NAME	COMPANY NAME
(Prime or subcontractor)	COMPANY LABOR CATEGORY	YEARS OF APPLICABLE PROFESSIONAL EXPERIENCE	HIGHEST DEGREE	DEGREE AREA	Affected by First Article	WORK LOCATION	TASK AREA SUPPORTED	RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002	CLIN 0008	CLIN 1008	CLIN 2008	CLIN 3008	CLIN 4008	CLIN 5008	CLIN 6008	CLIN 7008				CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002		CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002
							No	PM	ETS	Sr Program Manager	Senior	8088	8088	8088	8088	8088	8088	8088	8088												3.9	3.9	3.9	3.9	3.9	3.9	3.9	3.9		3.9	3.9	3.9	3.9	3.9	3.9	3.9	3.9
							No	PM	ETS	Program Manager	Mid	4689	4689	4689	4689	4689	4689	4689	4689									13.324222999	15.7694611529		2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3		2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3
							No	PM	ETS	Contracts Manager	Mid	3156	3156	3156	3156	3156	3156	3156	3156									13.6101511536			1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5		1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5
							No	PM	ETS	Business Financial Manager	Mid	2104	2104	2104	2104	2104	2104	2104	2104												1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0		1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0
								PM	ETS	Operations Manager	Mid	3156	8242	5792	1527	3667	2631	1413	3576												1.5	4.0	2.8	0.7	1.8	1.3	0.7	1.7		1.5	4.0	2.8	0.7	1.8	1.3	0.7	1.7
								ADMIN	ETS	Financial Analyst	Mid	1821	4755	3341	984	2367	1699	914	2314												0.9	2.3	1.6	0.5	1.1	0.8	0.4	1.1		0.9	2.3	1.6	0.5	1.1	0.8	0.4	1.1
								ADMIN	ETS	Operations Support	Mid	1416	3697	2598	766	1841	1321	711	1800												0.7	1.8	1.2	0.4	0.9	0.6	0.3	0.9		0.7	1.8	1.2	0.4	0.9	0.6	0.3	0.9
								SUPPORT	ETS	Scientist	Mid	13914	36338	25535	7315	17541	12585	6749	17063												6.7	17.5	12.3	3.5	8.4	6.1	3.2	8.2		6.7	6.7	6.5	6.0	5.0	5.0	4.0	4.0
								SUPPORT	ETS	Scientist	Junior	3236	8451	5939	1790	4355	3133	1704	4355									Varies by Program phases			1.6	4.1	2.9	0.9	2.1	1.5	0.8	2.1		2.0	3.0	3.0	1.0	1.0	1.5	0.8	2.1
								ENG	ETS	Chief Engineer	Senior	4000	4200	4200	4000	4000	4000	4000	4000									Somewhat varies by Program Phases			1.9	2.0	2.0	1.9	1.9	1.9	1.9	1.9		2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0
							Yes	ENG	ETS	Sr Engineer	Senior	20838	41413	29101	8635	20838	14968	8077	20520									Does not vary by Program phases			10.0	19.9	14.0	4.2	10.0	7.2	3.9	9.9		10.0	20.0	21.0	12.0	10.0	10.0	10.0	10.0
							Yes	ENG	ETS	Mid Engineer	Mid	9385	24509	17223	5033	12162	8737	4720	12002												4.5	11.8	8.3	2.4	5.8	4.2	2.3	5.8		10.0	20.0	21.0	12.0	10.0	10.0	10.0	10.0
							Yes	ENG	ETS	Jr Engineer	Junior	8737	22819	16035	5033	12162	8737	4720	12002												4.2	11.0	7.7	2.4	5.8	4.2	2.3	5.8		3.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0
							Yes	ENG	ETS	Cybersecurity Engineer	Mid	6149	16058	11284	3333	8025	5761	3102	7865												3.0	7.7	5.4	1.6	3.9	2.8	1.5	3.8		3.0	5.0	5.0	2.0	2.0	2.0	2.0	2.0
								ENG	ETS	System Engineer	Senior	11165	29159	20490	6040	14524	10426	5607	14206												5.4	14.0	9.9	2.9	7.0	5.0	2.7	6.8		5.4	14.0	9.9	2.9	7.0	5.0	2.7	6.8
								ENG	ETS	System Engineer	Mid	3236	8451	5939	1933	4356	3126	1705	4364												1.6	4.1	2.9	0.9	2.1	1.5	0.8	2.1		1.6	4.1	2.9	0.9	2.1	1.5	0.8	2.1
							Yes	SUPPORT	ETS	IT Analyst	Junior	3495	9127	6413	1906	4603	3307	1786	4539												1.7	4.4	3.1	0.9	2.2	1.6	0.9	2.2		1.7	4.4	3.1	0.9	2.2	1.6	0.9	2.2
												0	0	0	0	0	0	0	0												0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
							Yes	ENG	ETS	Software Engineer	Mid	10419	27210	19121	5655	13623	9751	5116	12715												5.0	13.1	9.2	2.7	6.5	4.7	2.5	6.1		5.0	13.1	9.2	2.7	6.5	4.7	2.5	6.1
								ENG	ETS	Manufacturing Engineer	Mid	8155	21299	14966	4326	10476	7530	4076	10380												3.9	10.2	7.2	2.1	5.0	3.6	2.0	5.0		3.9	10.2	7.2	2.1	5.0	3.6	2.0	5.0
								SUPPORT	ETS	Draftsman	Junior	5436	14197	9976	2980	7216	5187	2808	7152												2.6	6.8	4.8	1.4	3.5	2.5	1.4	3.4		2.6	6.8	4.8	1.4	3.5	2.5	1.4	3.4
								PM	ETS	Sr Logistics Manager	Senior	6522	6522	6522	6522	6522	6522	6522	6522												3.1	3.1	3.1	3.1	3.1	3.1	3.1	3.1		3.1	3.1	3.1	3.1	3.1	3.1	3.1	3.1
								ADMIN	ETS	ILS Mgmt Support Specialist IV	Mid	6320	16506	11598	3379	8072	5786	3092	7795												3.0	7.9	5.6	1.6	3.9	2.8	1.5	3.7		3.0	7.9	5.6	1.6	3.9	2.8	1.5	3.7
								ADMIN	ETS	ILS Mgmt Support Specialist III	Junior	4955	12942	9094	2640	6296	4512	2407	6059												2.4	6.2	4.4	1.3	3.0	2.2	1.2	2.9		2.4	6.2	4.4	1.3	3.0	2.2	1.2	2.9
								ADMIN	ETS	Support/Admin	Junior	3236	8452	5939	1750	4208	3020	1624	4114												1.6	4.1	2.9	0.8	2.0	1.5	0.8	2.0		1.6	4.1	2.9	0.8	2.0	1.5	0.8	2.0
								ADMIN	ETS	Specialist Technician/Admin offsite	Senior	0	0	0	986	3666	2814	1990	6014												0.0	0.0	0.0	0.5	1.8	1.4	1.0	2.9		0.0	0.0	0.0	0.5	1.8	1.4	1.0	2.9
								ADMIN	ETS	Sr Specialist Technician/Admin offsite	Mid	0	0	0	986	3666	2814	1990	6014												0.0	0.0	0.0	0.5	1.8	1.4	1.0	2.9		0.0	0.0	0.0	0.5	1.8	1.4	1.0	2.9
									PMO	Sr Principal Analyst										0	87	2099	2099	2099	2099	2099	2099
									PMO	Principal Analyst										0	316	7634	7634	7634	7634	7634	7634
									PMO	Analyst										0	56	1335	1335	1335	1335	1335	1335
									PMO	Sr Engineer										0	187	4487	4487	4487	4487	4487	4487
									PMO	Sr Staff Engineer										0	20	475	475	475	475	475	475
									PMO	Staff Engineer										0	186	4475	4475	4475	4475	4475	4475
									PMO	Principal Engineer										0	176	4220	4220	4220	4220	4220	4220
									PMO	Associate Engineer										0	86	2070	2070	2070	2070	2070	2070
									PMO	Manufacturing Non Technical Professional										0	49	1181	1181	1181	1181	1181	1181
									PMO	Manufacturing Technical Professional										0	0	0	0	0	0	0	0
									PMO	Manufacturing Technical Non exempt										0	0	0	0	0	0	0	0
									PMO	Manufacturing Support exempt										0	0	0	0	0	0	0	0
									PMO	Test Specialist										0	0	0	0	0	0	0	0
									PMO	Production Test Engineer										0	27	653	653	653	653	653	653
									PMO	Designer-Drafter-Illustrator										0	1	22	22	22	22	22	22
												8,170

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PM			ADMIN			ENG			ENG SUPPORT
	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior
% of Total	0.0%	6.6%	7.1%	4.9%	6.7%	0.9%	5.5%	22.6%	18.7%	7.5%	8.3%	0.0%	88.9%

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PM			ADMIN			ENG			ENG SUPPORT
	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior
% of Total	0.0%	6.0%	4.0%	0.0%	688.2%	0.0%	0.0%	733.0%	602.3%	344.5%	240.6%	0.0%

Note:	1. Full Staffing Plan to be provided in the format above
	2. Cost information should not be included in this sheet

Assumptions 1 Cannot have high fluctuations year to year. However, for a new vendor, there will be a rampup and ramp down for the First Article program

Staffing Plan - Follow on % 2nd

	Attachment JS-15												2024	2025	2026	2027	2028	2029	2030	2031
	N0002422R5231
	Prime Offeror Name											77.7865384615	161796	422559	296929	89481	217729	156649	85183	217729	0	1200	28846	28846	28846	28846	28846	28846
	a.	b.	c.	d.	e.	f.		g.	h.	i.	j.	k.	l. LABOR HOURS PROPOSED
	INDIVIDUAL'S NAME	COMPANY NAME
(Prime or subcontractor)	COMPANY LABOR CATEGORY	YEARS OF APPLICABLE PROFESSIONAL EXPERIENCE	HIGHEST DEGREE	DEGREE AREA		IF NO DEGREE, RELEVANT CERTIFICATES ATTAINED	WORK LOCATION	TASK AREA SUPPORTED	RFP Labor Category (Table L2)	RFP LABOR MIX	CLIN 0002	CLIN 1002	CLIN 2002	CLIN 3002	CLIN 4002	CLIN 5002	CLIN 6002	CLIN 7002	CLIN 0008	CLIN 1008	CLIN 2008	CLIN 3008	CLIN 4008	CLIN 5008	CLIN 6008	CLIN 7008
									PM	ETS	Sr Program Manager	Senior Level	5.00%	1.91%	2.72%	9.04%	3.71%	5.16%	9.49%	3.71%									5.10%	5.10%
									PM	ETS	Program Manager	Mid-Level	2.90%	1.11%	1.58%	5.24%	2.15%	2.99%	5.50%	2.15%									2.95%	2.95%
									PM	ETS	Contracts Manager	Mid-Level	1.95%	0.75%	1.06%	3.53%	1.45%	2.01%	3.70%	1.45%									1.99%	1.99%
									PM	ETS	Business Financial Manager	Mid-Level	1.30%	0.50%	0.71%	2.35%	0.97%	1.34%	2.47%	0.97%									1.33%	1.33%
									PM	ETS	Operations Manager	Mid-Level	1.95%	1.95%	1.95%	1.71%	1.68%	1.68%	1.66%	1.64%									1.78%	1.78%
									ADMIN	ETS	Financial Analyst	Mid-Level	1.13%	1.13%	1.13%	1.10%	1.09%	1.08%	1.07%	1.06%									1.10%	1.10%
									ADMIN	ETS	Operations Support	Mid-Level	0.87%	0.87%	0.87%	0.86%	0.85%	0.84%	0.83%	0.83%									0.85%	0.85%
									SUPPORT	ETS	Scientist	Mid-Level	8.60%	8.60%	8.60%	8.18%	8.06%	8.03%	7.92%	7.84%									8.23%	8.23%
									SUPPORT	ETS	Scientist	Junior Level	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%	2.00%									2.00%	2.00%	Varies by Program phases
									ENG	ETS	Chief Engineer	Senior Level	2.47%	0.99%	1.41%	4.47%	1.84%	2.55%	4.70%	1.84%									2.53%	2.53%	Somewhat varies by Program Phases
									ENG	ETS	Sr Engineer	Senior Level	12.88%	9.80%	9.80%	9.65%	9.57%	9.56%	9.48%	9.42%									10.02%	10.02%	Does not vary by Program phases
									ENG	ETS	Mid Engineer	Mid-Level	5.80%	5.80%	5.80%	5.63%	5.59%	5.58%	5.54%	5.51%									5.66%	5.66%
									ENG	ETS	Jr Engineer	Junior Level	5.40%	5.40%	5.40%	5.63%	5.59%	5.58%	5.54%	5.51%									5.51%	5.51%
									ENG	ETS	Cybersecurity Engineer	Mid-Level	3.80%	3.80%	3.80%	3.73%	3.69%	3.68%	3.64%	3.61%									3.72%	3.72%
									ENG	ETS	System Engineer	Senior Level	6.90%	6.90%	6.90%	6.75%	6.67%	6.66%	6.58%	6.52%									6.74%	6.74%
									ENG	ETS	System Engineer	Mid-Level	2.00%	2.00%	2.00%	2.16%	2.00%	2.00%	2.00%	2.00%									2.02%	2.02%
									SUPPORT	ETS	IT Analyst	Junior Level	2.16%	2.16%	2.16%	2.13%	2.11%	2.11%	2.10%	2.08%									2.13%	2.13%
													0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%									0.00%	0.00%
									ENG	ETS	Software Engineer	Mid-Level	6.44%	6.44%	6.44%	6.32%	6.26%	6.22%	6.01%	5.84%									6.25%	6.25%
									ENG	ETS	Manufacturing Engineer	Mid-Level	5.04%	5.04%	5.04%	4.84%	4.81%	4.81%	4.78%	4.77%									4.89%	4.89%
									SUPPORT	ETS	Draftsman	Junior Level	3.36%	3.36%	3.36%	3.33%	3.31%	3.31%	3.30%	3.28%									3.33%	3.33%
									PM	ETS	Sr Logistics Manager	Senior Level	4.03%	1.54%	2.20%	7.29%	3.00%	4.16%	7.66%	3.00%									4.11%	4.11%
									ADMIN	ETS	ILS Mgmt Support Specialist IV	Mid-Level	3.91%	3.91%	3.91%	3.78%	3.71%	3.69%	3.63%	3.58%									3.76%	3.76%
									ADMIN	ETS	ILS Mgmt Support Specialist III	Junior Level	3.06%	3.06%	3.06%	2.95%	2.89%	2.88%	2.83%	2.78%									2.94%	2.94%
									ADMIN	ETS	Support/Admin	Junior Level	2.00%	2.00%	2.00%	1.96%	1.93%	1.93%	1.91%	1.89%									1.95%	1.95%
									ADMIN	ETS	Specialist Technician/Admin offsite	Senior Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%									1.21%	1.21%
									ADMIN	ETS	Sr Specialist Technician/Admin offsite	Mid-Level	0.00%	0.00%	0.00%	1.10%	1.68%	1.80%	2.34%	2.76%									1.21%	1.21%
										PMO	Sr Principal Analyst										0	87	2099	2099	2099	2099	2099	2099
										PMO	Principal Analyst										0	316	7634	7634	7634	7634	7634	7634
										PMO	Analyst										0	56	1335	1335	1335	1335	1335	1335
										PMO	Sr Engineer										0	187	4487	4487	4487	4487	4487	4487
										PMO	Sr Staff Engineer										0	20	475	475	475	475	475	475
										PMO	Staff Engineer										0	186	4475	4475	4475	4475	4475	4475
										PMO	Principal Engineer										0	176	4220	4220	4220	4220	4220	4220
										PMO	Associate Engineer										0	86	2070	2070	2070	2070	2070	2070
										PMO	Manufacturing Non Technical Professional										0	49	1181	1181	1181	1181	1181	1181
										PMO	Manufacturing Technical Professional										0	0	0	0	0	0	0	0
										PMO	Manufacturing Technical Non exempt										0	0	0	0	0	0	0	0
										PMO	Manufacturing Support exempt										0	0	0	0	0	0	0	0
										PMO	Test Specialist										0	0	0	0	0	0	0	0
										PMO	Production Test Engineer										0	27	653	653	653	653	653	653
										PMO	Designer-Drafter-Illustrator										0	1	22	22	22	22	22	22
													0	0	0	0	0	0	0	0

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PM			ADMIN			ENG			ENG SUPPORT
	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior	Junior	Mid	Senior
% of Total	0%	8.05%	9.20%	5%	7%	1%	6%	23%	19%	7%	8%	0%	1

Note:	1. Full Staffing Plan to be provided in the format above
	2. Cost information should not be included in this sheet

Reverse Take

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	Program Management Junior	Program Management Mid	Program Management Senior	Administrative Junior	Administrative Mid	Administrative Senior	Engineering Junior	Engineering Mid	Engineering Senior	Engineering Support Junior	Engineering Support Mid	Engineering Support Senior
Original	0%	7.91%	8.62%	5%	7%	1%	6%	23%	27%	7%	8%	0%	100%
Target	0%	5.00%	6.00%	5%	7%	1%	10%	25%	26%	7%	8%	0%	100%
Values Across PoP	0	82403	98883	82403	115364	16481	164806	412014	428494	115364	131844	0
				Straight Math	161796	422559	296929	89481	217729	156649	85183	217729		Hrs/FTE	2080
PM	Senior Level	Sr Program Manager		Program Management Senior	9708	25354	17816	5369	13064	9399	5111	13064	181286
PM	Senior Level	Sr Logistics Manager		Program Management Mid	8090	21128	14846	4474	10886	7832	4259	10886
PM	Mid-Level	Program Manager		Program Management Junior	0	0	0	0	0	0	0	0
PM	Mid-Level	Contracts Manager		Administrative Senior	1618	4226	2969	895	2177	1566	852	2177	214247
PM	Mid-Level	Business Financial Manager		Administrative Mid	11326	29579	20785	6264	15241	10965	5963	15241
PM	Mid-Level	Operations Manager		Administrative Junior	8090	21128	14846	4474	10886	7832	4259	10886
ADMIN	Senior Level	Specialist Technician/Admin offsite		Engineering Senior	42067	109865	77202	23265	56610	40729	22148	56610	1005314
ADMIN	Mid-Level	Financial Analyst		Engineering Mid	40449	105640	74232	22370	54432	39162	21296	54432
ADMIN	Mid-Level	Operations Support		Engineering Junior	16180	42256	29693	8948	21773	15665	8518	21773
ADMIN	Mid-Level	ILS Mgmt Support Specialist IV		Engineering Support Senior	0	0	0	0	0	0	0	0	247208
ADMIN	Mid-Level	Specialist Technician/Admin offsite		Engineering Support Mid	12944	33805	23754	7158	17418	12532	6815	17418
ADMIN	Junior Level	ILS Mgmt Support Specialist III		Engineering Support Junior	11326	29579	20785	6264	15241	10965	5963	15241
ADMIN	Junior Level	Support/Admin
ENG	Senior Level	Chief Engineer		FTEs	78	203	143	43	105	75	41	105
ENG	Senior Level	Sr Engineer		Program Management Senior	5	12	9	3	6	5	2	6
ENG	Senior Level	System Engineer		Program Management Mid	4	10	7	2	5	4	2	5
ENG	Mid-Level	Mid Engineer		Program Management Junior	0	0	0	0	0	0	0	0
ENG	Mid-Level	Cybersecurity Engineer		Administrative Senior	1	2	1	0	1	1	0	1
ENG	Mid-Level	System Engineer		Administrative Mid	5	14	10	3	7	5	3	7
ENG	Mid-Level	Software Engineer		Administrative Junior	4	10	7	2	5	4	2	5
ENG	Mid-Level	Manufacturing Engineer		Engineering Senior	20	53	37	11	27	20	11	27
ENG	Junior Level	Jr Engineer		Engineering Mid	19	51	36	11	26	19	10	26
SUPPORT	Mid-Level	Scientist		Engineering Junior	8	20	14	4	10	8	4	10
SUPPORT	Junior Level	Draftsman		Engineering Support Senior	0	0	0	0	0	0	0	0
SUPPORT	Junior Level	Scientist		Engineering Support Mid	6	16	11	3	8	6	3	8
SUPPORT	Junior Level	IT Analyst		Engineering Support Junior	5	14	10	3	7	5	3	7
	5.9%	5.0%	0.0%	1.0%	6.9%	4.9%	25.1%	24.6%	10.6%	0.0%	8.8%	7.1%
	Program Management Senior	Program Management Mid	Program Management Junior	Administrative Senior	Administrative Mid	Administrative Junior	Engineering Senior	Engineering Mid	Engineering Junior	Engineering Support Senior	Engineering Support Mid	Engineering Support Junior
Target Yr1	9%	8%	0%	1%	6%	5%	27%	23%	10%	0%	5%	5%
Target Yr2	5%	5%	0%	1%	7%	4%	23%	23%	13%	0%	10%	8%
Target Yr3	5%	5%	0%	1%	7%	4%	23%	23%	13%	0%	10%	8%
Target Yr4	5%	5%	0%	1%	7%	4%	23%	23%	13%	0%	10%	8%
Target Yr5	6%	4%	0%	1%	8%	5%	24%	24%	9%	0%	11%	9%
Target Yr6	6%	4%	0%	1%	7%	5%	25%	25%	8%	0%	11%	9%
Target Yr7	5%	4%	0%	1%	6%	5%	27%	27%	9%	0%	9%	6%
Target Yr8	6%	5%	0%	1%	6%	6%	31%	29%	10%	0%	3%	1%
Averages	6.1%	5.1%	0.0%	1.0%	6.9%	5.0%	25.4%	24.8%	10.4%	0.0%	8.5%	6.8%
Target	6%	5.00%	0.00%	1%	7%	5%	26%	25%	10%	0%	8%	7%
FTEs from Straight:	78	203	143	43	105	75	41	105	792
FTEs that I really need:	78	115	112	110	100	100	97	80	792			Yr 1	Yr 2	Yr 3	Yr 4	Yr 5	Yr 6	Yr 7	Yr 8	Total	Delta
FTEs Manual Entry	78.0	115.0	112.0	111.5	103.0	101.0	93.0	78.5	Average		Hours	162240	239200	232960	231920	214240	210080	193440	163280	1647360	-695
Program Management Senior	7.0	6.0	6.0	6.0	6.0	6.0	5.0	5.0	5.9		Program Management Senior	14560	12480	12480	12480	12480	12480	10400	10400
Program Management Mid	6.0	6.0	6.0	5.5	4.0	4.0	4.0	4.0	4.9		Program Management Mid	12480	12480	12480	11440	8320	8320	8320	8320
Program Management Junior	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		Program Management Junior	0	0	0	0	0	0	0	0
Administrative Senior	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0		Administrative Senior	2080	2080	2080	2080	2080	2080	2080	2080
Administrative Mid	5.0	8.0	8.0	8.0	8.0	7.0	6.0	5.0	6.9		Administrative Mid	10400	16640	16640	16640	16640	14560	12480	10400
Administrative Junior	4.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	4.9		Administrative Junior	8320	10400	10400	10400	10400	10400	10400	10400
Engineering Senior	21.0	27.0	26.0	26.0	25.0	25.0	25.0	24.0	24.9		Engineering Senior	43680	56160	54080	54080	52000	52000	52000	49920
Engineering Mid	18.0	27.0	26.0	26.0	25.0	25.0	25.0	23.0	24.4		Engineering Mid	37440	56160	54080	54080	52000	52000	52000	47840
Engineering Junior	7.8	15.0	14.0	14.0	9.0	8.0	8.0	8.0	10.5		Engineering Junior	16224	31200	29120	29120	18720	16640	16640	16640
Engineering Support Senior	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		Engineering Support Senior	0	0	0	0	0	0	0	0
Engineering Support Mid	4.0	11.0	11.0	11.0	11.0	11.0	8.0	2.5	8.7		Engineering Support Mid	8320	22880	22880	22880	22880	22880	16640	5200
Engineering Support Junior	4.2	9.0	9.0	9.0	9.0	9.0	6.0	1.0	7.0		Engineering Support Junior	8736	18720	18720	18720	18720	18720	12480	2080

FTEs Calculated									Average	Attachment JS-3 Tab	Total Hours	Engineering Services Estimated Breakout & Labor Mix – CLINs x002
Program Management Senior	5	7	7	7	6	6	6	5	6	Year 1	162240		PM			ADMIN			ENG			ENG TECH
Program Management Mid	4	6	6	6	5	5	5	4	5	Year 2	239200		Senior	Mid	Junior	Senior	Mid	Junior	Senior	Mid	Junior	Senior	Mid	Junior
Program Management Junior	0	0	0	0	0	0	0	0	0	Year 3	232960	% of Total	6%	5%	0%	1%	7%	5%	25%	25%	11%	0%	9%	7%
Administrative Senior	1	1	1	1	1	1	1	1	1	Year 4	231920
Administrative Mid	5	8	8	8	7	7	7	6	7	Year 5	214240
Administrative Junior	4	6	6	6	5	5	5	4	5	Year 6	210080
Engineering Senior	20	30	29	29	26	26	25	21	26	Year 7	193440
Engineering Mid	20	29	28	28	25	25	24	20	25	Year 8	163280
Engineering Junior	8	12	11	11	10	10	10	8	10	TOTAL	1,647,360
Engineering Support Senior	0	0	0	0	0	0	0	0	0
Engineering Support Mid	6	9	9	9	8	8	8	6	8
Engineering Support Junior	5	8	8	8	7	7	7	6	7

And PMO...

			Yr 1	Yr 2	Yr 3	Yr 4	Yr 5	Yr 6	Yr 7	Yr 8
			0	1200	28846	28846	28846	28846	28846	28846
Sr Principal Analyst	PM & ADMIN	Senior	0	87	2099	2099	2099	2099	2099	2099
Principal Analyst	PM & ADMIN	Mid	0	316	7634	7634	7634	7634	7634	7634
Analyst	PM & ADMIN	Junior	0	56	1335	1335	1335	1335	1335	1335
Sr Engineer	ENGINEER	Senior	0	187	4487	4487	4487	4487	4487	4487
Sr Staff Engineer	ENGINEER	Senior	0	20	475	475	475	475	475	475
Staff Engineer	ENGINEER	Mid	0	186	4475	4475	4475	4475	4475	4475
Principal Engineer	ENGINEER	Mid	0	176	4220	4220	4220	4220	4220	4220
Associate Engineer	ENGINEER	Junior	0	86	2070	2070	2070	2070	2070	2070
Manufacturing Non Technical Professional	ENGINEER SUPPORT	Mid	0	49	1181	1181	1181	1181	1181	1181
Manufacturing Technical Professional	ENGINEER SUPPORT	Mid	0	0	0	0	0	0	0	0
Manufacturing Technical Non exempt	ENGINEER SUPPORT	Jr	0	0	0	0	0	0	0	0
Manufacturing Support exempt	ENGINEER SUPPORT	Jr	0	0	0	0	0	0	0	0
Test Specialist	ENGINEER SUPPORT	Jr	0	0	0	0	0	0	0	0
Production Test Engineer	ENGINEER SUPPORT	Mid	0	27	653	653	653	653	653	653
Designer-Drafter-Illustrator	ENGINEER SUPPORT	Mid	0	1	22	22	22	22	22	22

Engineering Services Estimated Breakout & Labor Mix – CLINs x002
	PRODUCTION MANAGEMENT AND ADMINISTRATION			ENGINEERING			SUPPORT
	Senior	Mid	Junior	Senior	Mid	Junior	Senior	Mid	Junior
% of Total	7%	27%	5%	17%	30%	7%	0%	6%	0%

Attachment JS-3 Tab	Total Hours
Year 1	0
Year 2	1200
Year 3	28846
Year 4	28846
Year 5	28846
Year 6	28846
Year 7	28846
Year 8	28846
TOTAL	174,276

File details come from the government source that posted it. Updated Aug 4, 2023.