N0002418R6102_Attachment_9_-_Part_A_Supporting_Cost_Data_Workbook__DRAFT.xlsx

XLSX spreadsheet 4 MB Posted Jan 11, 2019

Attached to: AN/BYG-1 Combat Control System (CCS) Payload Control System
Solicitation number: N00024-18-R-6102
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Part A

View the file

Other files

File	Type	Posted
Exhibit_C_-_Contract_Data_Requirements_List(s),_DD_Form_1423_DRAFT.doc	DOC document	Jan 11, 2019
Attachment_1_-_Appendix_G_Eng_Svcs_(DRAFT).doc	DOC document	Jan 11, 2019
Exhibit_A_-_Contract_Data_Requirements_List(s),_DD_Form_1423_DRAFT.doc	DOC document	Jan 11, 2019
Attachment_8_-_RFP_Question_Submittal_Form_DRAFT.pdf	PDF	Jan 11, 2019
N00024-18-R-6102_DRAFT.pdf	PDF	Jan 11, 2019
Attachment_1_-_Appendix_D_TI24APB23_(DRAFT).doc	DOC document	Jan 11, 2019
Attachment_1_-_Statement_of_Work_for_the_Payload_Control_System_(DRAFT).doc	DOC document	Jan 11, 2019
N0002418R6102_Attachment_9_-_Part_B_Supporting_Cost_Data_Workbook_DRAFT.xlsx	XLSX spreadsheet	Jan 11, 2019
Attachment_1_-_Appendix_C_TI22APB23_(DRAFT).doc	DOC document	Jan 11, 2019
Attachment_1_-_Appendix_E_TI24APB25_(DRAFT).doc	DOC document	Jan 11, 2019
Attachment_4B_-_CLASSIFIED_GFI_Form_DRAFT.xlsx	XLSX spreadsheet	Jan 11, 2019
Attachment_13_-_Classified_Material_Request_Form_DRAFT.pdf	PDF	Jan 11, 2019
Attachment_2__-_DD_Form_254_(DRAFT).pdf	PDF	Jan 11, 2019
Attachment_1_-_Appendix_B_TI22APB21_(DRAFT).doc	DOC document	Jan 11, 2019
Attachment_4B_-_CLASSIFIED_GFI_Form_DRAFT.pdf	PDF	Jan 11, 2019
Attachment_1_-_Appendix_A_TI20APB21_(DRAFT).doc	DOC document	Jan 11, 2019
Attachment_5_-_PCS_GFP_Form_DRAFT.xlsx	XLSX spreadsheet	Jan 11, 2019
Exhibit_B_-_Contract_Data_Requirements_List(s),_DD_Form_1423_DRAFT.doc	DOC document	Jan 11, 2019
DRAFT_Attachment_4A_-_PCS_GFI_List_16_aug_18_N00024-18-NR-98173.pdf	PDF	Jan 11, 2019
Attachment_3_CDRLS_DRAFT.pdf	PDF	Jan 11, 2019

Show all 20

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.

workbook instructions

	Bidders will enter the company name in the footer of each workbook.
	OVERVIEW TAB: Contains formulas and links back to other tabs in the workbook. When ODC/LOE values are updated in their respective tabs; the overview tab will auto populate to show the grand totals by CLIN. If for any reason the bidder needs to add any further “indirect cost/rates” the overview tab will need to be updated to insert additional columns and link to the corresponding data in each supporting tab.
	ODCs Tab: Broken out by CLIN and further divided between Material and Travel. Each CLINs Material and Travel have Column C which indicates the CY the cost should be applicable to in order to accommodate for the Bidders Fiscal Year. When the two (2) CY values are added, the summation will total on the CLIN total Line and represent the GY in its totality due to a POP of 1 October 2019 – 30 September 2020. The ODC tables are split between USN/RAN Shared and Legacy and RAN Unique.
	1. Column B: If the Bidder has specific burden pools assigned to ODC costs, indicate it for each CLIN for both Material and Travel. If there is no burden pool, please leave Column B Blank.
	2. Column D: Bidders will populate the direct cost associated with the material/travel by the CY indicated in Column C.
	3. Columns E, G and I: Bidders will update cells E2, G2 and I2 to indicate the title of the “indirect rate” being applied to the CLIN [EXAMPLE: G&A Rate, OH Rate, FCCM Rate, etc.]. In the columns below for each CLIN, please enter the rate (%) applied to derive the Grand total Cost.
	4. Columns F, H and J: Bidders will update cells F2, H2 and J2 to indicate the title of the “indirect cost”
	[EXAMPLE: G&A, OH, FCCM, etc.]. In the columns below for each CLIN, please enter the formula to show what each indirect rate is applied to.
	5. Column K: Once steps 1-4 have been completed, the Grand Total column should auto update and each CLIN total row should auto update for totals further rippling through to the Grand Totals for ODC efforts over the entire contract performance period.
	USN-RAN SHARED HR BY GFY – CWBS & RAN HR BY GFY - CWBS
	These tabs will capture the Basis of Estimate (BOE) hours by CLIN, WBS and Labor category. These tabs also separate the effort between USN/RAN Shared tasking and RAN Unique Tasking.
	1. WBS#: The bidders will populate each cell with the WBS # and the corresponding description of the WBS task (directly below the WBS #).
	2. Labor Category: The bidders will populate the entire list of labor categories (even if tasking is not associated with that specific CLIN) to maintain consistency through the document. Labor categories shall be divided between Prime and Subcontractors.
	3. Hours by WBS/Task: The bidder will notate how many hours (for each labor category) are assigned by WBS #/task. The grand total for that CLIN will auto populate as formulas were entered to sum all of the hours.
	4. Multiple Baselines: If multiple TI/APBs are being proposed in any given CLIN (POP) and additional cells are needed, the bidder will insert them as structured in the original template. The bidder will also update the “total” tab to ensure that a grand total is presented for each CLIN.
	CLIN Specific Tabs [0001, 0003,0201, 0203,0301, 0303, 0401, 0403, 0501, 0503, 0601, 0603, 0701, 0703]: Each CLIN breaks out the work by Prime/Sub and further breaks it down to labor category and hours/cost associated with each CY notated.
	1. Column A: The bidders will provide a resource ID for each labor category (if the company has assigned one to specific labor categories).
	2. Column B: The bidders will indicated what company the category applies to (Prime in peach shade/ Sub in green shade)
	3. Column E: If the bidder utilizes employees from multiple locations to complete the task, please indicate what “location/burden pool” applies to the specific labor category. This will help verify that the appropriate Rates were used in developing the estimate.
	4. Column F: The bidder will notate the labor category of the employee [Senior Engineer, Junior Engineer, Logistics, Program Management, Administration, etc.]
	5. Column G: The bidder shall enter the labor rate by CY
	6. Column H: The bidder shall enter the number of hours by labor category for each CY.
	7. Column I: This column should auto populate as it was prepopulated with formulas to compute the direct cost.
	8. Columns J, L and N: Bidders will update cells J2, L2 and N2 to indicate the title of the “indirect rate” being applied to the CLIN [EXAMPLE: G&A Rate, OH Rate, FCCM Rate, etc.]. In the columns below for each CLIN, please enter the rate (%) applied to derive the Indirect cost element.
	9. Columns K, M and O: Bidders will update cells K2, M2 and O2 to indicate the title of the “indirect cost”
	[EXAMPLE: G&A, OH, FCCM, etc.]. In the columns below for each CLIN, please enter the formula to show what each indirect rate is applied to.
	10. Column P: Once items 1-9 above have been completed, the total cost without fee should auto update due to prepopulated formulas.
	11. Column Q: The bidder will enter the formula to document how the total fee is derived from all the other cost elements.
	12. Column R: Once items 1-11 have been completed, the Total CPFF value should auto update due to prepopulated formulas.
	13. If there are more labor categories for the effort then space available, the bidder will insert more rows to accommodate all labor categories and check formulas in totals columns and rows to ensure they include the additional data provided.
	HRS BY CLIN & LOE Mix
	1. Once the CLIN tabs have been completely populated, the bidder will update this tab.
	2. Column A: The bidder will enter the labor categories in the same order as provided in each CLIN tab, and they shall split prime and sub labor categories.
	3. Columns B, D, F, H, J, L, M, N, P: The bidder will link the rows in these cells with the respective total hours listed in each CLIN tab for each labor category. Once they are fully linked the Labor Mix column will auto populate.
	4. Once completed, this tab will display the labor mix for every CLIN solicited and proposed.
	PRIME CLIN EXAMPLE :
	A	B			E	F	G	H	I	J	K	L	M	N	O	P	Q	R
	Resource
ID	Company			Burden
Pool	Labor
Category	Labor
Rate	Hours	Direct
Cost	G&A
Rate	G&A
Cost	OH
Rate	OH
Cost	FCCM
Rate	FCCM
Cost	Total Cost
w/o Fee	Total Fee	CPFF
	ENG-4	Prime Company Name				Senior Engineer	$ 154.20	2,230	$ 343,860		$ 257,895		$ 451,316		$ 263	$ 1,053,335	$ 63,184	$ 1,116,519
		2019					$ 150.00	150	$ 22,500	75.000%	$ 16,875	75.000%	$ 29,531	0.025%	$ 17	$ 68,923	$ 4,134	$ 73,058
		2020	2018				$ 154.50	2,080	$ 321,360	75.000%	$ 241,020	75.000%	$ 421,785	0.025%	$ 246	$ 984,411	$ 59,050	$ 1,043,461
	SUBCONTRACTOR CLIN EXAMPLE:
	ABC123	Subcontract Company Name			Burden Pool	Program Manager	$ 102.61	575	$ 59,000		$ 51,466		$ 99,419		$ 21	$ 209,906	$ 12,593	$ 222,499
		2019					$ 100.00	75	$ 7,500	87.230%	$ 6,542	90.000%	$ 12,638	0.010%	$ 3	$ 26,683	$ 1,601	$ 28,284
		2020	2018				$ 103.00	500	$ 51,500	87.230%	$ 44,923	90.000%	$ 86,781	0.010%	$ 18	$ 183,223	$ 10,992	$ 194,215
	CWBS EXAMPLE:
	CLIN SAMPLE
	Calendar Year	2019
	TI/APB	20/19

TOTALS

WBS #	1.1.1	1.1.2	1.1.3	1.1.4	1.1.5	1.1.6	1.1.7
Description	Task 1	Task 2	Task 3	Task 4	Task 5	Task 6	Task 7
Labor Category
Program Manager								- 0
Senior Engineer								- 0
Mid-Level Engineer								- 0
Junior Engineer								- 0
Senior Finance								- 0
Mid-Level Finance								- 0
Junior Finance								- 0
Quality Assurace								- 0
Logistics								- 0
Administrative - Senior
Administrative - Mid
Administrative - Junior
SUBCONTRACTORS								- 0
Program Manager								- 0
Senior SW Engineer								- 0
Mid SW Engineer								- 0
Contracts Manager								- 0
Administrative - Mid								- 0
Administrative - Junior								- 0
	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

OVERVIEW

	CLIN	Description	RFP	Lockheed Martin Proposed
			Hours
(RFP)	Est. Cost

(Direct)

RFP	Hours	Direct Cost	Indirect Cost	Indirect Cost	Indirect Cost	Fixed Fee
5%	CPFF

Total

	0001	Engineering & Tech Services USN/RAN Shared	80,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0002	Material, Travel and Subistence in support of 0001	- 0	$ 520,000	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0003	Engineering & Tech Services RAN Unique	12,000		- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0004	Material, Travel and Subistence in support of 0003	- 0	$ 78,000	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0005	DATA - NSP	- 0	$ - 0	- 0
	0006	Orders (CPFF)	- 0		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Base Year Totals		92,000	598,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	0101	Engineering & Tech Services USN/RAN Shared	40,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0102	Material, Travel and Subistence in support of 0101	- 0	$ 267,800	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0103	Engineering & Tech Services RAN Unique	6,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0104	Material, Travel and Subistence in support of 0103	- 0	$ 40,170	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (1) Totals		46,000	307,970	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	0201	Engineering & Tech Services USN/RAN Shared	53,333		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0202	Material, Travel and Subistence in support of 0201		$ 367,779	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0203	Engineering & Tech Services RAN Unique	8,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0204	Material, Travel and Subistence in support of 0203		$ 55,167	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (2) Totals		61,333	422,946	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	0301	Engineering & Tech Services USN/RAN Shared	60,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0302	Material, Travel and Subistence in support of 0301		$ 426,164	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0303	Engineering & Tech Services RAN Unique	9,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0304	Material, Travel and Subistence in support of 0303		$ 63,925	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (3) Totals		69,000	490,089	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	0401	Engineering & Tech Services USN/RAN Shared	60,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0402	Material, Travel and Subistence in support of 0401		$ 438,948	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0403	Engineering & Tech Services RAN Unique	9,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0404	Material, Travel and Subistence in support of 0403		$ 65,842	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (4) Totals		69,000	504,790	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0501	Engineering & Tech Services USN/RAN Shared	60,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0502	Material, Travel and Subistence in support of 0501		$ 451,117	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0503	Engineering & Tech Services RAN Unique	9,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0504	Material, Travel and Subistence in support of 0503		$ 67,818	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (5) Totals		69,000	518,935	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0601	Engineering & Tech Services USN/RAN Shared	40,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0602	Material, Travel and Subistence in support of 0601		$ 310,454	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0603	Engineering & Tech Services RAN Unique	6,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0604	Material, Travel and Subistence in support of 0603		$ 46,568	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (6) Totals		46,000	357,022	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0701	Engineering & Tech Services USN/RAN Shared	26,667		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0702	Material, Travel and Subistence in support of 0701		$ 213,178	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0703	Engineering & Tech Services RAN Unique	4,000		- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0704	Material, Travel and Subistence in support of 0703		$ 31,977	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Option Year (7) Totals		30,667	245,155	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Grand Totals
LOE + ODC+ ORDERS		483,000	3,444,907	- 0	- 0	- 0	- 0	- 0	- 0	- 0

&"-,Bold"INSERT PRIME CONTRACTOR NAME &"-,Bold"Payload Control System (PCS) &"-,Bold"N00024-18-R-6102

Direct Rates

	Direct Labor Rates
	Labor
Category	2019
rate	2020
rate	2021
rate	2022
rate	2023
rate	2024
rate	2025
rate	2026
rate	2027

rate

ENTER PRIME NAME Payload Control System (PCS) N00024-18-R-6102

Indirect Rates

	Indirect Labor Rates
	Indirect Rate Category	2019
rate	2020
rate	2021
rate	2022
rate	2023
rate	2024
rate	2025
rate	2026
rate	2027

rate

ENTER PRIME CONTRACTOR NAME Payload Control System N00024-18-R-6102

ODC's

	ODCs for USN/RAN Shared/ Legacy
	CLIN	BURDEN POOL	CY	Direct
Cost	Indirect
Rate	Indirect Cost	Indirect
Rate	Indirect
Cost	Indirect
Rate	Indirect
Cost	Grand Total

	MATERIAL		2019						$ - 0
			2020						$ - 0
	TRAVEL		2019						$ - 0
			2020						$ - 0
	0002 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2020						$ - 0
			2021						$ - 0
	TRAVEL		2020						$ - 0
			2021						$ - 0
	0102 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2021						$ - 0
			2022						$ - 0
	TRAVEL		2021						$ - 0
			2022						$ - 0
	0202 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2022						$ - 0
			2023						$ - 0
	TRAVEL		2022						$ - 0
			2023						$ - 0
	0302 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2023						$ - 0
			2024						$ - 0
	TRAVEL		2023						$ - 0
			2024						$ - 0
	0402 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2024						$ - 0
			2025						$ - 0
	TRAVEL		2024						$ - 0
			2025						$ - 0
	0502 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2025						$ - 0
			2026						$ - 0
	TRAVEL		2025						$ - 0
			2026			- 0			$ - 0
	0602 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	MATERIAL		2026						$ - 0
			2027						$ - 0
	TRAVEL		2026						$ - 0
			2027			- 0			$ - 0
	0702 TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	USN TOTALS			$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
	ODCs for RAN Unique
	CLIN	BURDEN POOL	CY	Direct
Cost	Indirect
Rate	Indirect Cost	Indirect
Rate	Indirect
Cost	Indirect
Rate	Indirect
Cost	Grand

Total

	MATERIAL	2019								$ - 0
		2020								$ - 0
	TRAVEL	2019								$ - 0
		2020								$ - 0
	0004 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2020								$ - 0
		2021								$ - 0
	TRAVEL	2020								$ - 0
		2021								$ - 0
	0104 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2021								$ - 0
		2022								$ - 0
	TRAVEL	2021								$ - 0
		2022								$ - 0
	0204 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2022								$ - 0
		2023								$ - 0
	TRAVEL	2022								$ - 0
		2023								$ - 0
	0304 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2023								$ - 0
		2024								$ - 0
	TRAVEL	2023								$ - 0
		2024								$ - 0
	0404 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2024								$ - 0
		2025								$ - 0
	TRAVEL	2024								$ - 0
		2025								$ - 0
	0504 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2025								$ - 0
		2026								$ - 0
	TRAVEL	2025								$ - 0
		2026								$ - 0
	0604 TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	MATERIAL	2026								$ - 0
		2027								$ - 0
	TRAVEL	2026								$ - 0
		2027								$ - 0
	0704 TOTALS		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	RAN
TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0
	GRAND
TOTALS		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

&"-,Bold" ATTACHMENT 9 - LOE & ODC Cost Summary

&"-,Bold"

INSERT PRIME CONTRACTOR NAME

&"-,Bold"Payload Control System (PCS)

&"-,Bold"N00024-18-R-6102

HRS BY CLIN & LOE MIX

	USN/RAN Shared LOE Labor Mix
	Labor Category	CLIN
0001	LABOR

MIX

0001	CLIN
0101	LABOR

MIX

0101	CLIN
0201	LABOR

MIX

0201	CLIN
0301	LABOR

MIX

0301	CLIN
0401	LABOR

MIX

0401	CLIN
0501	LABOR

MIX

0501	CLIN
0601	LABOR

MIX

0601	CLIN
0701	LABOR

MIX

0701	TOTAL
USN	LABOR

MIX

USN

			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
	PRIME	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
			0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%
	Sub Contractor Totals	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%			- 0	0.00%	- 0	0.00%
	GRAND TOTALS	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	ERROR:#REF!
	RFP Hours	80,000.00		40,000		53,333		60,000		60,000		60,000		40,000		26,667		420,000
	Delta	(80,000.00)	0.00%	(40,000)	0.00%	(53,333)	0.00%	(60,000)	0.00%	(60,000)	0.00%	(60,000)	0.00%	(40,000)	0.00%	(26,667)	0.00%	(420,000)	ERROR:#REF!
	RAN LOE Labor Mix
	Labor Category	CLIN
0003	LABOR

MIX

0003	CLIN
0103	LABOR

MIX

0103	CLIN
0203	LABOR

MIX

0203	CLIN
0303	LABOR

MIX

0303	CLIN
0403	LABOR

MIX

0403	CLIN
0503	LABOR

MIX

0503	CLIN
0603	LABOR

MIX

0603	CLIN
0703	LABOR

MIX

0703	TOTAL
RAN	LABOR

MIX

RAN

		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
PRIME TOTALS	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%		0.00%	- 0	0.00%
Sub Contractor Totals	- 0	0.00%	- 0	- 0	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.00%
GRAND TOTALS	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	0.00%	- 0	ERROR:#REF!
RFP Hours	12,000.00		6,000		8,000		9,000		9,000		9,000		6,000		4,000		63,000
Delta	(12,000.00)		(6,000)		(8,000)		(9,000)		(9,000)		(9,000)		(6,000)		(4,000)		(63,000)

&"-,Bold" ATTACHMENT 9 - LOE ODC Cost Summary

&"-,Bold"INSERT PRIME CONTRACTOR NAME &"-,Bold" Payload Control System (PCS) &"-,Bold"N00024-18-R-6102

USN-RAN SHARE HR BY GFY - CWBS

	CLIN 0001 - USN/RAN Shared
	Contractor FY	2020
	TI/APB								TOTALS
	WBS #
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
	SUBCONTRACTORS								- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0101 - USN/RAN SHARED
	Contractor FY	2021
	TI/APB								TOTALS								TOTALS	GRAND TOTALS
	WBS #
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0201 - USN/RAN SHARED
	Contractor FY	2022
	TI/APB								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0301 - USN/RAN SHARED
	Contractor FY	2023
	TI/APB								TOTALS								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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
									- 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
									- 0								- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

CLIN 0401 - USN/RAN SHARED
Contractor FY	2024
TI/APB		TOTALS	TOTALS	TOTALS	GRAND TOTALS
WBS

Jaeger, Angel A CIV PEO SUB, PMS 425: Jaeger, Angel A CIV PEO SUB, PMS 425:

Why was this element skipped in the WBS?	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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
									- 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
									- 0								- 0								- 0	- 0
									- 0								- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0501 - USN/RAN SHARED
	Contractor FY	2025
	TI/APB								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0

	CLIN 0601 - USN/RAN SHARED
	Contractor FY	2026
	TI/APB								TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
	SUBCONTRACTORS								- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

CLIN 0701- USN/RAN SHARED
Contractor FY	2027
TI/APB								TOTALS								TOTALS	GRAND TOTALS
WBS
Description
Labor Category
								- 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								- 0	- 0
								- 0								- 0	- 0
								- 0								- 0	- 0
								- 0								- 0	- 0
								- 0								- 0	- 0
								- 0								- 0	- 0
SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

&"-,Bold"INSERT PRIME CONTRACTOR NAME &"-,Bold"TACTICAL CONTROL SYSTEM (TCS) &"-,Bold"N00024-18-R-6407

RAN HR BY GFY-CWBS

	CLIN 0003 - RAN UNIQUE
	Contractor FY	2020
	TI/APB								TOTALS
	WBS #
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
	SUBCONTRACTORS								- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0103 - RAN UNIQUE
	Contractor FY	2026
	TI/APB								TOTALS								TOTALS	GRAND TOTALS
	WBS #
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 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
	SUBCONTRACTORS								- 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

	CLIN 0203 - RAN UNIQUE
	Contractor FY	2022
	TI/APB								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0303 - RAN UNIQUE
	Contractor FY	2023
	TI/APB								TOTALS								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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
									- 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
									- 0								- 0								- 0	- 0
									- 0								- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

	CLIN 0403 - RAN UNIQUE
	Contractor FY	2024
	TI/APB								TOTALS								TOTALS								TOTALS	GRAND TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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
									- 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
									- 0								- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

CLIN 0503 - RAN UNIQUE
Contractor FY	2025
TI/APB		TOTALS	TOTALS

GRAND TOTALS

	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
									- 0								- 0	- 0
	SUBCONTRACTORS								- 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	- 0	- 0	- 0	- 0

	CLIN 0603 - RAN UNIQUE
	Contractor FY	2026
	TI/APB								TOTALS
	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
	SUBCONTRACTORS								- 0
									- 0
									- 0
									- 0
									- 0
									- 0
									- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

CLIN 0703 - RAN UNIQUE
Contractor FY	2027
TI/APB		TOTALS	TOTALS

GRAND TOTALS

	WBS
	Description	System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities		System
Engineering	System
Development	Test &
Evaluation	Platform
Integration	Program
Management	ILS	Facilities
	Labor Category
									- 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								- 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
	SUBCONTRACTORS								- 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	- 0

&"-,Bold"INSERT PRIME CONTRACTOR NAME &"-,Bold"TACTICAL CONTROL SYSTEM (TCS) &"-,Bold"N00024-18-R-6407

CLIN 0001

Resource

Company

Burden

Pool

Labor

		ERROR:#DIV/0!	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
2019				$ - 0				$ - 0		$ - 0
2020	2018			$ - 0				$ - 0		$ - 0

(SUB) TOTAL VALUES FOR CLIN 0001	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0
(PRIME)TOTAL VALUES FOR CLIN 0001	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0
(PRIME + SUB) GRAND TOTALS FOR CLIN 0001	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0
2019 VALUES	- 0	- 0		- 0		- 0		- 0	- 0	- 0	- 0
2020 VALUES	- 0	- 0		- 0		- 0		- 0	- 0	- 0	- 0

	CLIN 0003
	Resource
ID	Company			Burden
Pool	Labor
Category	Labor Rate	HOURS	Direct
Cost	Indirect Rate	Indirect Cost	Indirect Rate	Indirect Cost	Indirect Rate	Indirect Cost	TOTAL COST
W/O FEE	TOTAL
FEE	TOTAL PRICE
							ERROR:#DIV/0!	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		2019							$ - 0				$ - 0		$ - 0
		2020	2018						$ - 0				$ - 0		$ - 0