Attachment P2_Sub_Cost_Breakout.xlsx

XLSX spreadsheet 45 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 a detailed Excel-based SubContractor Cost Breakout spreadsheet for a federal contract opportunity with the Naval Air Warfare Center Aircraft Division. The spreadsheet provides comprehensive instructions for subcontractors to document labor costs, requiring detailed entries for each employee including employment status, labor category, full-time/part-time designation, work location, and rates across five performance periods (base year and four option years). Contractors must populate the spreadsheet with employee names, labor categories, hourly rates, and calculate total labor costs, indirect costs, and fixed fees, with specific formatting requirements such as using two decimal places for dollar figures and maintaining unlocked cells with intact formulas.

The related federal contract opportunity is a draft Request for Proposal (RFP) for the Aircraft Instrumentation Division (AID) Follow On solicitation (N0042124R0081), seeking technical, engineering, supply, administrative, program analysis/management, and facility contractor support services. The opportunity is issued by the Department of the Navy's Naval Air Systems Command, with questions to be submitted to Contract Specialist Shannon Summers by 2:00 PM Eastern Time on 06 June 2025. The draft RFP is available on the Procurement Integrated Enterprise Environment (PIEE) platform, and interested contractors should review the detailed solicitation for full requirements and submission guidelines.

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 P1_Prime_Cost_Breakout.xlsx	XLSX spreadsheet	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

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

	SubContractors Instructions for Cost Spreadsheet (LOE) tab:
1	Enter Prime offeror name into cell C3 and Subcontractor name into cell C4
2	Enter all subcontractor current employee or Contingent hire names in Column C (starting at row 9), If proposed employee is prospective leave blank. If necessary, insert additional rows or delete blank rows, but ensure integrity of formulas.
3	Select the employment status (Current, Contingent or Prospective) in Column D.
4	Select the subcontractor 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 four Senior Analysts, then the labor category Senior Analyst 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	Insert the fixed fee rate applied to its cost.

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET

	Prime Offeror Name:
	Subcontractor Name:
						Base			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Total
Position	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
	Subcontractor Labor Cost
	Subcontractor Direct Labor
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
	Subcontractor 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 Subcontractor Labor Cost							0			0			0			0			0		0

Total Subcontractor Labor Cost 0 0 0 0 0 0

Fixed Fee
Subcontractor Fee	0	0	0	0	0	0

Total Labor Cost Plus Fixed Fee (CPFF) 0 0 0 0 0 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:

Instructions Fully Burdened Instructions to Subcontractors Contractors for completing Attachment P6 Annual Fully Burdened Labor

RFP # N00421-24-R-0081

COLUMN/AREA	COLUMN HEADING	DESCRIPTION OF DATA UNDER THIS COLUMN HEADING
B	Proposed Labor Category	Enter the Proposed Labor Category as entered in the Cost Spreadsheet (LOE) Tab column E.
C	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.
D-H	Proposed Annual Fully-Burdened Labor per Labor Catergory, per Labor Individual Designator	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. 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.

Fully Burdened Labor Rates

Proposed Labor Category	Position Designator	Proposed Annual Fully-Burdened Labor
		Year 1	Year 2	Year 3	Year 4	Year 5

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