Attachment P1_Prime_Cost_Breakout.xlsx

XLSX spreadsheet 64 KB Posted Jun 2, 2025

Attached to: Draft RFP: Aircraft Instrumentation Division (AID) Follow On
Solicitation number: N0042124R0081
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Jun 2, 2025

The file is an Excel-based Cost Spreadsheet Template for a prime contractor's cost proposal, specifically for the Naval Air Warfare Center Aircraft Division's Aircraft Instrumentation Division (AID) follow-on contract (Solicitation N0042124R0081). The comprehensive template requires detailed cost breakdowns across a base year and four option years, mandating prime contractors to enter specific information including employee names, labor categories, employment status, work location, hours, rates, and indirect cost calculations.

The spreadsheet provides a structured format for capturing labor costs, including prime and subcontractor personnel, with sections for direct and indirect labor costs, fixed fees, other direct costs (ODCs), and total contract pricing. Key instructions include populating labor categories, specifying employment status (current, contingent, prospective), indicating full-time/part-time work, work location, and applying appropriate indirect rates and fixed fee percentages. The template supports a Cost-Plus-Fixed-Fee (CPFF) contract mechanism, with specific guidance on calculating fee per hour and ensuring alignment with contract section requirements.

View the file

Other files

File	Type	Posted
Government Responses 082225.pdf	PDF	Aug 22, 2025
Attachment L1 AID CSS Experience Verification Worksheet .xlsx	XLSX spreadsheet	Aug 22, 2025
Attachment 5 WD 2025-0064 Rev 3.pdf	PDF	Jul 16, 2025
Attachment 1b Labor Categories Draft v2.pdf	PDF	Jul 16, 2025
Government Responses 07162025.pdf	PDF	Jul 16, 2025
Attachment 1a - GOP Guidance Draft v2.pdf	PDF	Jul 16, 2025
Attachment 2 - Surveillance Activity Checklist Draft v2.pdf	PDF	Jul 16, 2025
Attachment 1 Statement of Work (SOW) Draft v2.pdf	PDF	Jul 16, 2025
Attachment 4 WD 2015-4279 Rev 28.pdf	PDF	Jul 16, 2025
Exhibit A CDRLs Draft v2.pdf	PDF	Jul 16, 2025
Attachment L1 AID CSS Experience Verification Worksheet Draft v2.xlsx	XLSX spreadsheet	Jul 16, 2025
Draft RFP N00421-24-R-0081 v2.pdf	PDF	Jul 16, 2025
Government Responses 06272025.pdf	PDF	Jun 27, 2025
Attachment 4 WD 2015-4279 Rev 27.pdf	PDF	Jun 2, 2025
Attachment 1a - GOP Guidance.pdf	PDF	Jun 2, 2025
Attachment L1 AID CSS Experience Verification Worksheet.xlsx	XLSX spreadsheet	Jun 2, 2025
Attachment 1 Statement of Work (SOW).pdf	PDF	Jun 2, 2025
Attachment 2 - Surveillance Activity Checklist.pdf	PDF	Jun 2, 2025
Attachment P3 Labor Hours.xlsx	XLSX spreadsheet	Jun 2, 2025
DRAFT N00421-24-R-0081.pdf	PDF	Jun 2, 2025
Attachment 5 WD 2025-0064 Rev 2.pdf	PDF	Jun 2, 2025
Attachment 1b Labor Categories.pdf	PDF	Jun 2, 2025
Attachment 3 DD254.pdf	PDF	Jun 2, 2025
Exhibit A CDRLs.pdf	PDF	Jun 2, 2025
Attachment P2_Sub_Cost_Breakout.xlsx	XLSX spreadsheet	Jun 2, 2025

Show all 25

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.

Instructions

	Prime Contractor Instructions for Cost Spreadsheet (LOE) tab
1	Enter Prime offeror name into cell C3.
2	Enter all prime current employee or Contingent hire names in Column C (starting at row 9), If proposed employee is prospective leave cell blank. If necessary, insert additional rows, delete blank rows, but ensure integrity of formulas.
3	Select the employment status (Current, Contingent or Prospective) in Column D.
4	Select the prime labor category for the employee in Column E (starting at row 9). Labor categories having more than one position shall be listed with a separate row for each person performing work. For example, if the offeror proposes nine Aerospace Engineering, Instrumentation and Operations Technician, Senior, then the labor category Aerospace Engineering, Instrumentation and Operations Technician, Senior shall be listed four times along with their applicable rates and information.
5	Only one worksheet shall be prepared for the entire period of performance.
6	All cells shall be unprotected and unlocked, with formulas intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places. Use the rounding function.
8	In column F, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
9	In column G, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces. Regarless of the location, pricing will be in accordance with the Section L instructions to Offerors.
10	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
11	For each subcontractor, enter the subcontractor name, total hours, and the "fully burdened rate" for each labor catgeory for each contract year. Labor categories having more than one position shall be listed with a separate row for each person performing work.
12	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them but ensure integrity of formulas. Delete any blank rows, but ensure integrity of formulas.
13	The prime should insert the subcontractor handling charge, if any.
14	The prime should insert the fixed fee rate on Prime Labor applied to its cost.
15	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
16	Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions. If necessary, insert additional rows, but ensure integrity of formulas.
17	On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet.
18	In accordance with HTXT.232-9510 PAYMENT OF FIXED FEE, the resultant contract payment of fixed fee will be dollars per hour (based on the fixed fee divided by the level of effort in hours). Cells D165-D169, calculates the fee per hour as required to only two decimal places. The values stated in cell D165-D169 will be used to populate the fee per hour value within HTXT.232-9510.

The Offeror shall ensure the fee ceiling value calculated in cell E165 matches the value calculated in cell J134, cell E166 matches the value calculated in cell M134, cell E167 matches the value calculated in cell P134, cell E168 matches the value calculated in cell S134, cell E169 matches the value calculated in cell V134 . This ensures that the Offeror is able to earn the full fee if all level of effort (hours) are executed during contract performance. Following these directions will also ensure that the fee ceiling for CLINs on resultant TOs can be calculated correctly with no errors due to rounding.

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET

	Prime Offeror Name:
	Subcontractor Name (if applicable):
						Base			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Total
Position Designator	Cost Elements	Employment Status	Labor Category	F/P	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
	Prime Contractor Labor Cost
	Prime Contractor Direct Labor (0001)
1	Employee Name 1	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
2	Employee Name 2	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
3	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
4	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
5	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
6	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
7	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
8	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
9	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
10	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
11	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
12	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
13	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
14	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
15	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
16	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
17	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
18	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
19	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
20	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
21	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
22	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
23	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
24	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
25	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
26	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
27	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
28	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
29	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
30	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
31	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
32	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
33	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
34	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
35	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
36	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
37	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
38	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
39	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
40	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
41	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
42	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
43	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
44	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
45	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
46	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
47	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
48	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
49	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
50	Etc.	Select	Select					$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	0	$ - 0
	Total Direct Labor Cost						0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0	0	$ - 0
	Prime Contractor Indirect Labor Cost
	Overhead
	Fringe Benefits
	G&A
	Total Indirect Labor Cost							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0		$ - 0
	Total Direct and Indirect Labor cost							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0		$ - 0
	COM
	Total Prime Contractor Labor Cost							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0		$ - 0

	Subcontractor Labor Cost
	Subcontractor proposed cost and fee
1	Subcontractor Name 1	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
2	Subcontractor Name 2	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
3	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
4	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
5	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
6	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
7	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
8	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
9	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
10	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
11	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
12	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
13	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
14	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
15	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
16	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
17	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
18	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
19	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
20	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
21	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
22	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
23	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
24	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
25	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
26	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
27	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
28	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
29	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
30	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
31	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
32	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
33	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
34	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
35	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
36	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
37	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
38	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
39	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
40	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
41	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
42	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
43	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
44	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
45	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
46	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
47	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
48	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
49	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
50	Etc.	Select	Select		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	0	$ - 0
	Total proposed subcontractor labor cost and fee			0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0
	Prime contractor pass through (not including fee)
	Handling
	G&A
	Other (if any)
	Total pass through (not including fee)
	Total Subcontractor Cost including pass through

Total Labor Cost (Prime and Subcontractor Labor) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor						$ - 0
Prime Contractor Fee for Subcontractor Labor
Total Fee (for Prime and Subcontractor Labor)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Total Labor Cost Plus Fixed Fee (CPFF) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Other Direct Costs
Material (CLIN X002)						$ - 0
Travel (CLIN X003)						$ - 0
ODCs (CLIN X004)						$ - 0
SubTotal ODCs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
ODC Indirect Costs
Total ODCs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Total CPFF all CLINs (Labor and ODCs) 0 $ - 0 0 $ - 0 0 $ - 0 0 $ - 0 0 $ - 0 0 $ - 0

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All Years	Amount	Percent
Subcontractor proposed cost and fee	$0
Pass Through Amount (not including fee)	$0
Prime Contractor Fee for Subcontractor Labor *	$0
Total Pass Through Amount (including fee)	$0	ERROR:#DIV/0!

			Fee Analysis - Total for All Years	Amount	Percent
			Prime Contractor Labor Cost	$0
			Fixed Fee for Labor Performed by Prime Contractor	$0	ERROR:#DIV/0!
			Step 1	Step 2	Step 3
			Fee Per Hour based on "Total Fee ( for Prime and Subcontractor Labor)" / Total Proposed Labor Hours	Fee Per Hour to use in
HTXT.232-9510	Fee Ceiling Value
		Base	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
		OY 1	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
		OY 2	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
		OY 3	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
		OY 4	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Employment Status Data Field

Select

Current

Contingent

Prospective

Labor Category Data Field

Select

Administrative Assistant , Journeyman

Computer Scientist , Journeyman

Configuration Manager , Journeyman

Configuration Manager , Senior

Engineer, Instrumentation , Senior

Engineer , Junior

Engineer , Journeyman

Engineer , Senior

Engineer, Structural , Journeyman

General Technician I

General Technician II

General Technician II - OT

Graphic Designer , Journeyman

Aerospace Engineering, Instrumentation and Operations Technician I

Aerospace Engineering, Instrumentation and Operations Technician I - OT

Aerospace Engineering, Instrumentation and Operations Technician II

Aerospace Engineering, Instrumentation and Operations Technician II- OT

Aerospace Engineering, Instrumentation and Operations Technician III

Aerospace Engineering, Instrumentation and Operations Technician IV

Aerospace Machinist Technician I

Aerospace Machinist Technician II

Aerospace Machinist Technician III

Aerospace Sheet Metal Technician I

Aerospace Sheet Metal Technician I - OT

Aerospace Sheet Metal Technician II

Aerospace Sheet Metal Technician III

Aerospace Sheet Metal Technician IV

Aerospace Structures Technician I

Aerospace Structures Technician II

Aerospace Structures Technician III

Aerospace Structures Technician IV

Laborer

Management Analyst , Journeyman

Material Coordinator

Mechanical Drafter II

Mechanical Drafter III

Mechanical Drafter IV

Program Manager , Senior

Project Analyst , Journeyman

Safety / QA Specialist , Junior

Safety / QA Specialist , Journeyman

Supply Tech

Page &P &F

KTR: (name) Source Selection Information - See: FAR 2.101 and 3.104 RFP:

Summary CLIN Summary Sheet

CLINS	CLIN Description	Total Cost	Total Fixed Fee	Total Value $
0001	CPFF Labor
0002	Material
0003	Travel
0004	ODCs
Base Year Total				0
1001	CPFF Labor
1002	Material
1003	Travel
1004	ODCs
Option Year 1 Total				0
2001	CPFF Labor
2002	Material
2003	Travel
2004	ODCs
Option Year 2 Total				0
3001	CPFF Labor
3002	Material
3003	Travel
3004	ODCs
Option Year 3 Total				0
4001	CPFF Labor
4002	Material
4003	Travel
4004	ODCs
Option Year 4 Total				0

Total Labor Cat. HR Proposed

Labor Category	Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4	Total Labor Hours
Administrative Assistant , Journeyman						0
Computer Scientist , Journeyman						0
Configuration Manager , Journeyman						0
Configuration Manager , Senior						0
Engineer, Instrumentation , Senior						0
Engineer , Junior						0
Engineer , Journeyman						0
Engineer , Senior						0
Engineer, Structural , Journeyman						0
General Technician I						0
General Technician II						0
General Technician II - OT						0
Graphic Designer , Journeyman						0
Aerospace Engineering, Instrumentation and Operations Technician I						0
Aerospace Engineering, Instrumentation and Operations Technician I - OT						0
Aerospace Engineering, Instrumentation and Operations Technician II						0
Aerospace Engineering, Instrumentation and Operations Technician II- OT						0
Aerospace Engineering, Instrumentation and Operations Technician III						0
Aerospace Engineering, Instrumentation and Operations Technician IV						0
Aerospace Machinist Technician I						0
Aerospace Machinist Technician II						0
Aerospace Machinist Technician III						0
Aerospace Sheet Metal Technician I						0
Aerospace Sheet Metal Technician I - OT						0
Aerospace Sheet Metal Technician II						0
Aerospace Sheet Metal Technician III						0
Aerospace Sheet Metal Technician IV						0
Aerospace Structures Technician I						0
Aerospace Structures Technician II						0
Aerospace Structures Technician III						0
Aerospace Structures Technician IV						0
Laborer						0
Management Analyst , Journeyman						0
Material Coordinator						0
Mechanical Drafter II						0
Mechanical Drafter III						0
Mechanical Drafter IV						0
Program Manager , Senior						0
Project Analyst , Journeyman						0
Safety / QA Specialist , Junior						0
Safety / QA Specialist , Journeyman						0
Supply Tech						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
						0
Total	0	0	0	0	0	0
* Add up proposed labor categories from the Cost Spreadsheet tab. *

Instructions Fully Burdened Instructions to Prime Contractors for completing Attachment P1 Annual Fully Burdened Labor

RFP # N00421-24-R-0081

COLUMN/AREA	COLUMN HEADING	DESCRIPTION OF DATA UNDER THIS COLUMN HEADING
B	Offeror Name	Enter the Offeror (Prime's name or Subcontractor's name) in this field to distinguish between the companies.
C	Proposed Labor Category	Enter the Proposed Labor Category as entered in the Cost Spreadsheet (LOE) Tab column E.
D	Position Designator	For each individual Contractor employee proposed, the contractor shall enter the corresponding Position Number as found on the Cost Spreadsheet (LOE) Tab column B.
E-I	Proposed Annual Fully-Burdened Rates for Prime	Enter the Annual Fully-Burdened Labor proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator by linking back to the applicable performance period direct and indirect rates. This formula should show the Government how a Prime develops its fully burdened rates in accordance with its disclosure statement so that the Government has a full understanding of how fully burdened rates were developed. The Government should be able to trace this formula back for each labor category for each period of performance. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. Annual Fully-Burdened Labor shall include fringe, overhead, G&A, and fee on total cost, but should not include Fully-Burdened Other Direct Costs (ODCs) such as Materials, Travel, and Cost of Money costs. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate times the amount of hours proposed for the applicable performance period.
E-I	Proposed Annual Fully-Burdened Labor Rates for proposed Subcontractors	Enter the Annual Fully-Burdened Labor proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator back to the applicable performance period direct and indirect rates. This formula should show the Government how a Prime develops its fully burdened rates in accordance with its disclosure statement so that the Government has a full understanding of how fully burdened rates were developed. The Government should be able to trace this formula back for each labor category for each period of performance. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. For subcontractor labor, the fully burdened labor rates shall be inclusive of any pass-through charges (e.g., subcontractor handling, fixed fee on subcontractor labor, etc.) applied by the prime contractor. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate times the amount of hours proposed for the applicable performance period.

Fully Burdened Labor Rates

Offeror Name	Proposed Labor Category	Position Designator	Proposed Annual Fully-Burdened Labor
			Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select
	Select

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