Att_L5_Cost_Summary.xlsx

XLSX spreadsheet 61 KB Posted Aug 2, 2023

Attached to: Systems Engineering Contractor Support Services Follow-On Federal contract opportunity
Solicitation number: N0042123R0007
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

View the file

Other files for this federal contract opportunity

Other files attached to Systems Engineering Contractor Support Services Follow-On, newest first.
File	Type	Posted
RFP_N0042123R0007_Amend0003.pdf	PDF	Sep 27, 2023
RFP_N0042123R0007_Amend0002.pdf	PDF	Sep 14, 2023
Att_L5_Cost_Summary_Amend0002.xlsx	XLSX spreadsheet	Sep 14, 2023
RFP_N0042123R0007_Amend01.pdf	PDF	Aug 30, 2023
Att_L5_Cost_Summary_Amend0001.xlsx	XLSX spreadsheet	Aug 30, 2023
CDRLs.pdf	PDF	Aug 30, 2023
Att_L1_CA_Tables_Amend0001.xlsx	XLSX spreadsheet	Aug 30, 2023
Att_L4_CRM_Amend0001.xlsx	XLSX spreadsheet	Aug 30, 2023
Draft RFP_v2_QA.pdf	PDF	Aug 30, 2023
RFP_N0042123R0007_Amend01.pdf	PDF	Aug 30, 2023
Att_J3_Form DD254_Amend0001.pdf	PDF	Aug 30, 2023
Att_L3_PPCE_Data_Amend0001.xlsx	XLSX spreadsheet	Aug 30, 2023
Att_L7 5.4 Labor Hours Table_Amend0001.xlsx	XLSX spreadsheet	Aug 30, 2023
Att_J1_Org_Conflict_of_Interest.docx	DOCX document	Aug 2, 2023
2a - C073 DD254 N00421-23-R-0007 TBD.pdf	PDF	Aug 2, 2023
Att_L1_CA_Tables.xlsx	XLSX spreadsheet	Aug 2, 2023
Att_J4_Data_Item_Transmittal_Acceptance_Rejection_Form.docx	DOCX document	Aug 2, 2023
Att_L2_PPQ.docx	DOCX document	Aug 2, 2023
Att_L4_CRM.xlsx	XLSX spreadsheet	Aug 2, 2023
N0042123R0007.pdf	PDF	Aug 2, 2023
Att_L6_Annual_Fully_Burdened_Rates.xlsx	XLSX spreadsheet	Aug 2, 2023
Draft RFP QAs.pdf	PDF	Aug 2, 2023
Att_J3_DD_Form_254.pdf	PDF	Aug 2, 2023
Att_L3_PPCE_Data.xlsx	XLSX spreadsheet	Aug 2, 2023

Show all 24

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.

Offeror Instructions Instructions for the Offeror for the Cost Summary Sheet (using the Sample Cost Summary Sheet for Row/Column references):

	General Instructions		1	The Offeror shall prepare only one Cost Summary Sheet for the entire period of performance. Where Subcontractors are proposed, Subcontractors shall each complete a copy of the Cost Summary Sheet.
			2	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
			3	All cells shall be unprotected and unlocked, with formulas intact to show mathematical operations.
			4	Where it is necessary to add additional rows, the Offeror shall ensure the integrity of all formulas.
			5	All dollar figures shall be carried out no further than two decimal places.
			6	Cells in the Offeror Cost Summary sheet that do not require edits are highlighted in gray.
			7	Cells in the Offeror Cost Summary sheet that require Offeror inputs are highlighted in yellow.
			8	Cells in the Offeror Cost Summary sheet that are auto calculated are highlighted in green. Offerors shall ensure that formulas are properly applied to any inserted rows.
			9	On the Offeror CLIN Summary tab, ensure that the total costs of the CLINs match Section B and the total on the Offeror Cost Summary Spreadsheet.
	Offeror Name		Cell B3	Enter the Offeror name
	Prime Contractor Labor Cost	Prime Contractor Direct Labor	Rows 9-11+
Column A	Starting at row 9, the Offeror shall enter all Prime employee names or position designator. If necessary, insert additional rows.
			Rows 9-11+
Column B	Starting in row 9, the Offeror shall specify a Government Labor Category using the information provided in the tables of Section L, Paragraph 5.4.
			Rows 9-11+
Column C	Starting at row 9, the Offeror shall insert the title of the proposed labor category it will be utilizing, as recorded in the Prime's accounting system, that correlates to each of the Government specified labor categories shown in column B. When more than one person is proposed to provide services for a labor category, that labor category shall be listed multiple times 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. If necessary, insert additional rows.
			Rows 9-11+
Column D	The Offeror shall identify whether the individual specified for this labor category is full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
			Rows 9-11+

Column E

	The Offeror shall insert "Off" if the worker will be performing at the Contractor's facility (i.e., off-site location hours) or "On" if it will be performing in the Government Spaces (i.e., on-site location hours).
		Rows 9-11+
Columns F, I, L, O, and R	The Offeror shall insert the proposed direct labor rate for each employee/labor category (starting in Row 9). The proposed direct labor rate shall be equal to or greater than the Minimum Rate (Column H) stated in the "Minimum Direct Labor Rates" worksheet. Note, the Offeror shall not use any fully burdened hourly rates when pricing the labor of its employees.
		Rows 9-11+
Columns G, J, M, P, and S	The Offeror shall insert the proposed 'Hours' for each employee/labor category (starting in Row 9).

Column U sums the respective 'Hours' from each year.

		Rows 9-11+
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Rate x Hours).

Column V sums the respective 'Amounts' from each year.

		Row 12
Columns G, J, M, P, and S	The Total Direct Labor Cost 'Hours' are auto calculated based on the provided formulas (Summation of the Amount for Rows 9-11+)

Column U sums the respective 'Hours' from each year.

		Row 12
Columns H, K, N, Q, and T	The Total Direct Labor Cost 'Amount' is auto calculated based on the provided formulas (Summation of the Amount for Rows 9-11+)

Column V sums the respective 'Amounts' from each year.

		Prime Contractor Indirect Labor Cost	Rows 14-16+
Columns A	The Offeror shall insert the type of/names of any indirect rates. For example, if there are multiple fringe rates, insert additional rows to reflect each fringe rate apply accordingly.
			Rows 14-16+
Columns F, I, L, O, and R	The Offeror shall insert applicable annual indirect rates under the 'Rates' column for the respective year.
			Rows 14-16+
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas for each year (Indirect Rate x Total Direct Labor Cost).

Column V sums the respective 'Amounts' from each year.

		Total Direct and Indirect Labor Cost	Row 18
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Total Direct Labor Cost + Total Indirect Labor Cost)

Column V sums the respective 'Amounts' from each year.

		COM	Row 19
Columns H, K, N, Q, and T	The Offeror shall insert the proposed Facilities Capitol Cost of Money (COM) for each year.

Column V sums the respective 'Amounts' from each year.

		Total Prime Contractor Labor Cost	Row 19
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Total Direct and Indirect Labor Cost + COM)

Column V sums the respective 'Amounts' from each year.

	Subcontractor Labor Cost	Subcontractor Proposed Cost and Fee	Rows 24-16+
Column A	The Offeror shall enter each subcontractor name (starting in Row 24 of the Sample Cost Summary Sheet). If necessary, insert additional rows.
			Rows 24-26+
Columns G, J, M, P, and S	The Offeror shall enter the total hours proposed by the respective subcontractor. Note, the total hours entered in these columns should align with the total hours proposed in the 'Sub Cost Summary' worksheet completed by the respective Subcontractor.

Column U is auto calculated and sums the respective 'Hours' from each year.

		Rows 24-26+
Columns H, K, N, Q, and T	The Offeror shall enter the total dollar amount (inclusive of any subcontractor fees) proposed by the respective subcontractor. Note, the total dollars should align with the total dollars proposed in the 'Sub Cost Summary' worksheet completed by the respective Subcontractor.

Column V is auto calculated and sums the respective 'Amounts' from each year.

		Row 27
Columns G, J, M, P, and S	The Total Proposed Subcontractor Labor Cost and Fee 'Hours' columns are auto calculated based on the provided formulas (Summation of the Hours for Rows 24-26+)

Column U sums the respective 'Hours' from each year.

		Row 27
Columns H, K, N, Q, and T	The Total Proposed Subcontractor Labor Cost and Fee 'Amounts' columns are auto calculated based on the provided formulas (Summation of the Amount for Rows 24-26+)

Column V sums the respective 'Amounts' from each year.

		Prime Contractor Pass Through (Not Including Fee)	Rows 29-31+
Column A	The Offeror shall insert the type of/names of any applicable pass through costs (e.g., handling, G&A). If necessary, insert additional rows.
			Rows 29-31+
Columns F, I, L, O, and R	The Offeror shall insert applicable pass through rates under the 'Rates' Column for the respective year.
			Rows 29-31+
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Pass Through Rate x Total Proposed Subcontractor Labor Cost and Fee)

Column V sums the respective 'Amounts' from each year.

		Row 32
Columns H, K, N, Q, and T	The Total Pass Through (not including fee) 'Amounts' columns are auto calculated based on the provided formulas (Summation of the Amount for Rows 29-31+)

Column V sums the respective 'Amounts' from each year.

		Total Subcontractor Cost, Including Pass Through	Row 33
Columns H, K, N, Q, and T	The Total Subcontractor Cost Including Pass Through 'Amounts' columns are auto calculated based on the provided formulas (Total Proposed Subcontractor Labor Cost and Fee + Total Pass Through (Not Including Fee))

Column V sums the respective 'Amounts' from each year.

	Total Labor Cost (Prime and Subcontractor Labor)	Row 35
Columns G, J, M, P, and S	The Total Labor Cost (Prime and Subcontractor Labor) 'Hours' columns are auto calculated based on the provided formulas (Total Direct Labor Cost 'Hours' + Total Proposed Subcontractor Labor Cost and Fee 'Hours')

Column U sums the respective 'Hours' from each year.

		Row 35
Columns H, K, N, Q, and T	The Total Labor Cost (Prime and Subcontractor Labor) 'Amounts' columns are auto calculated based on the provided formulas (Total Direct Labor Cost 'Amounts' + Total Proposed Subcontractor Labor Cost and Fee 'Amounts')

Column V sums the respective 'Amounts' from each year.

	Fixed Fee	Prime Contractor Fee for Prime Contractor Labor	Row 38
Columns F, I, L, O, and R	The Offeror shall insert the fixed fee rate applied to its cost excluding subcontractor labor.
			Row 38
Columns H, K, N, Q, and T	The Prime Contractor Fee for Prime Contractor Labor 'Amounts' columns are auto calculated based on the provided formulas (Total Direct Labor Cost 'Amount' x Prime Contractor Fee for Prime Contractor Labor 'Rate')

Column V sums the respective 'Amounts' from each year.

		Prime Contractor Fee for Subcontractor Labor *	Row 39
Columns F, I, L, O, and R	The Offeror shall insert the fixed fee rate it is applying to the subcontractor labor, if any.
			Row 39
Columns H, K, N, Q, and T	The Prime Contractor Fee for Subcontractor Labor 'Amounts' columns are auto calculated based on the provided formulas (Total Subcontractor Cost, Including Pass Through 'Amount' x Prime Contractor Fee for Subcontractor Labor 'Rate')

Column V sums the respective 'Amounts' from each year.

		Total Fee (For Prime and Subcontractor Labor)	Row 40
Columns H, K, N, Q, and T	The Total Fee (For Prime and Subcontractor Labor) 'Amounts' columns are auto calculated based on the provided formulas (Total Subcontractor Cost, Including Pass Through 'Amount' x Prime Contractor Fee for Subcontractor Labor 'Rate')

Column V sums the respective 'Amounts' from each year.

	Total Labor Cost Plus Fixed Fee (CPFF)	Row 42
Columns H, K, N, Q, and T	The Total Labor Cost Plus Fixed Fee (CPFF) 'Amounts' columns are auto calculated based on the provided formulas (Total Direct Labor Cost 'Amounts' + Total Proposed Subcontractor Labor Cost and Fee 'Amounts')

Column V sums the respective 'Amounts' from each year.

	Other Direct Costs	Other Direct Costs	Row 45+
Column A	The Offeror shall insert lines to specify ODCs as necessary (e.g., Travel, Material).
			Row 45+
Columns H, K, N, Q, and T	The Offeror shall insert the 'Amount' for each ODC.

Column V is auto calculated and sums the respective 'Amounts' from each year.

		Any Adders to ODCs	Row 46+
Column A	The Offeror shall insert lines to specify Indirect cost types to the Other Direct Costs if applicable and if in compliance with the RFP instructions (e.g., G&A (cost only - no fee)).
			Row 46+
Columns H, K, N, Q, and T	The Offeror shall insert the 'Amount' for each ODC.

Column V is auto calculated and sums the respective 'Amounts' from each year.

		Total ODCs	Row 47
Columns H, K, N, Q, and T	The Total ODCs 'Amounts' columns are auto calculated based on the provided formulas (Other Direct Costs + Any Adders to ODCs)

Column V sums the respective 'Amounts' from each year.

	Total CPFF (Labor and ODCs)	Row 49
Columns H, K, N, Q, and T	The Total CPFF (Labor and ODCs) 'Amounts' columns are auto calculated based on the provided formulas (Total Labor Cost Plus Fixed Fee (CPFF) + Total ODCs)

Column V sums the respective 'Amounts' from each year.

&A &F N00421-23-R-0007

Minimum Direct Labor Rates

Labor Category1	Level	BLS Code	Location	Area	Percentile	Base Rate	Minimum Rate8
Computer & Information Systems Analyst	Junior	11-3021	Contractor Site or PAX River	California-Lexington Park, MD	25th	$61.14	$63.77
Computer & Information Systems Analyst	Journeyman	11-3021	Contractor Site or PAX River	California-Lexington Park, MD	50th	$78.88	$82.27
Computer & Information Systems Analyst	Senior	11-3021	Contractor Site or PAX River	California-Lexington Park, MD	75th	$99.93	$104.23
Data Scientist	Journeyman	15-2051	Contractor Site	California-Lexington Park, MD	50th	$49.76	$51.90
Engineer	Apprentice	17-20002	Contractor Site	California-Lexington Park, MD	10th	$36.00	$37.55
Engineer	Junior	17-20002	Contractor Site or PAX River	California-Lexington Park, MD	25th	$41.44	$43.22
Engineer	Journeyman	17-20002	Contractor Site or PAX River	California-Lexington Park, MD	50th	$52.00	$54.24
Engineer	Senior	17-20002	Contractor Site or PAX River	California-Lexington Park, MD	75th	$66.28	$69.13
Engineer	Senior	17-20002	NAS Jacksonville	Jacksonville, FL	75th	$66.28	$69.13
Engineer	Senior	17-20003	Marine Corps Air Station (MCAS) Cherry Point, NC	New Bern, NC	75th	$63.89	$66.64
Engineer	Senior	17-20002	NAS North Island	San Diego, CA	75th	$66.28	$69.13
Engineer	Senior	17-20003	NAS Whidbey Island Oak Harbor, WA	Western Washington nonmetropolitan area	75th	$63.89	$66.64
Engineer	Senior	17-20003	Raytheon Tucson, AZ	Tucson, AZ	75th	$63.89	$66.64
Engineer	Senior	17-20002	Dept of Energy, Idaho Falls, ID	Idaho Falls, ID	75th	$66.28	$69.13
Engineer	Senior	17-20003	Marine Corps Base Camp LeJeune	Jacksonville, NC9	75th	$63.89	$66.64
Engineer	Senior	17-20002	Sikorsky, Stratford, CT	Bridgeport-Stamford-Norwalk, CT	75th	$66.28	$69.13
Engineer	Senior	17-20002	Lockheed Martin	Orlando, FL	75th	$66.28	$69.13
Engineer	Senior	17-20002	Boeing, St. Louis, MO	St. Louis, MO	76th	$66.28	$69.13
Engineer (Model-Based Systems)	Junior	17-20002	Contractor Site	California-Lexington Park, MD	25th	$41.44	$43.22
Engineer (Model-Based Systems)	Journeyman	17-20002	Contractor Site	California-Lexington Park, MD	50th	$52.00	$54.24
Engineer (Model-Based Systems)	Senior	17-20002	Contractor Site	California-Lexington Park, MD	75th	$66.28	$69.13
Engineer (Production Quality)	Senior	17-20002	Contractor Site	California-Lexington Park, MD	75th	$66.28	$69.13
Engineer (Systems)	Journeyman	17-2199	Contractor Site or PAX River	California-Lexington Park, MD	50th	$50.29	$52.45
Engineer (Systems)	Senior	17-2199	Contractor Site or PAX River	California-Lexington Park, MD	75th	$65.05	$67.85
Engineering Technician IV	N/A	17-30204	Contractor Site or PAX River	California-Lexington Park, MD	50th	$35.78	$37.32
Engineering Technician IV	N/A	17-30205	Marine Corps Air Station (MCAS) Cherry Point, NC	New Bern, NC	50th	$31.50	$32.85
Engineering Technician IV	N/A	17-30205	Marine Corps Base Camp LeJeune	Jacksonville, NC9	50th	$31.50	$32.85
Engineering Technician VI	N/A	17-30204	Contractor Site or PAX River	California-Lexington Park, MD	75th	$46.23	$48.22
Engineering Technician VI	N/A	17-30205	Marine Corps Air Station (MCAS) Cherry Point, NC	New Bern, NC	75th	$41.31	$43.09
Engineering Technician VI	N/A	17-30205	Marine Corps Base Camp LeJeune	Jacksonville, NC9	75th	$41.31	$43.09
Engineering Technician VI	N/A	17-30205	Boeing	St Louis, MO	75th	$41.31	$43.09
Engineering Technician VI	N/A	17-30204	Raytheon El Segundo, CA	Los Angeles - Long Beach - Anaheim, CA	75th	$46.23	$48.22
Engineering Technician (Model-Based) IV	N/A	17-30204	Contractor Site	California-Lexington Park, MD	50th	$35.78	$37.32
Engineering Technician (Model-Based) VI	N/A	17-30204	Contractor Site	California-Lexington Park, MD	75th	$46.23	$52.70
Management Analyst	Junior	13-1111	PAX River	California-Lexington Park, MD	25th	$33.81	$35.26
Management Analyst (Configuration)	Junior	13-1111	Contractor Site or PAX River	California-Lexington Park, MD	25tth	$33.81	$35.26
Mathematical Science Occupations (All Other)	Senior	15-20996	Contractor Site or PAX River	California-Lexington Park, MD	75th	$65.68	$68.50
Mathematical Scientist (Systems Specialist)	Senior	15-20996	Contractor Site or PAX River	California-Lexington Park, MD	75th	$65.68	$68.50
Operations Manager	Senior	11-1021	Contractor Site	California-Lexington Park, MD	75th	$74.31	$77.51
Operations Manager Deputy	Journeyman	11-1021	Contractor Site	California-Lexington Park, MD	50th	$47.16	$49.19
Operations Research Analyst	Junior	15-2031	Contractor Site or PAX River	California-Lexington Park, MD	25th	$30.80	$32.12
Operations Research Analyst	Journeyman	15-2031	Contractor Site or PAX River	California-Lexington Park, MD	50th	$41.21	$42.98
Operations Research Analyst	Senior	15-2031	Contractor Site or PAX River	California-Lexington Park, MD	75th	$54.80	$57.16
Operations Research Analyst	Senior	15-2031	NAWCTSD Orlando	Orlando, FL	75th	$54.80	$57.16
Operations Research Analyst (Model-Based)	Junior	15-2031	Contractor Site	California-Lexington Park, MD	25th	$30.80	$32.12
Operations Research Analyst (Model-Based)	Journeyman	15-2031	Contractor Site	California-Lexington Park, MD	50th	$41.21	$42.98
Operations Research Analyst (Model-Based)	Senior	15-2031	Contractor Site	California-Lexington Park, MD	75th	$54.80	$57.16
Program Management Analyst	Journeyman	13-1111	Contractor Site or PAX River	California-Lexington Park, MD	50th	$45.81	$47.78
Program Management Analyst	Journeyman	13-1111	Marine Corps Air Station (MCAS) Cherry Point, NC	New Bern, NC	50th	$45.81	$47.78
Program Management Analyst	Journeyman	13-1111	Marine Corps Base Camp LeJeune	Jacksonville, NC	50th	$45.81	$47.78
Program Management Analyst	Senior	13-1111	Contractor Site or PAX River	California-Lexington Park, MD	75th	$61.29	$63.93
Program Management Analyst (Model-Based Systems Engineering)	Junior	13-1111	Contractor Site	California-Lexington Park, MD	25th	$33.81	$35.26
Program Management Analyst (Model-Based Systems Engineering)	Journeyman	13-1111	Contractor Site	California-Lexington Park, MD	50th	$45.81	$47.78
Program Management Analyst (Model-Based Systems Engineering)	Senior	13-1111	Contractor Site	California-Lexington Park, MD	75th	$61.29	$63.93
Software Developer	Junior	15-1252	Contractor Site	California-Lexington Park, MD	25th	$46.54	$48.54
Software Developer	Journeyman	15-1252	Contractor Site	California-Lexington Park, MD	50th	$61.18	$63.81
Software Developer	Senior	15-1252	Contractor Site	California-Lexington Park, MD	75th	$77.64	$80.98
Tactical Operations and Air/Weapons Specialist	Journeyman	55-30007	PAX River	California-Lexington Park, MD	50th	$49.96	$52.10
Tactical Operations and Air/Weapons Specialist	Senior	55-30007	PAX River	California-Lexington Park, MD	75th	$71.72	$74.80
Notes:
1includes Key Personnel
217-2072, Electronics Engineers, Except Computerwas used to calculate the minimum rate for 17-2000.
317-2071 Electrical Engineers was used to calculate the minimum rate for 17-2000 in these locations.
417-3021 Aerospace Engineering & Operations Technologists and Technicians was used to calculate the minimum rate for 17-3020.
517-3029 Aerospace Engineering & Operations Technologists and Technicians, Except Drafters, All Other was used to calculate the minimum rate for 17-3020.
615-2051 Data Scientists was used to calculate the minimum rate for 15-2099.
7BLS does not provide wage estimates for the 55-0000 Military Specific Occupations group. 53-2012 Commercial Pilots was used to calculate the minimum rate (salary/2080).
8includes 4.3% escalation
9New Bern rate used to calculate the minimum rate.

Sample Offeror Cost Summary

SAMPLE OFFEROR COST SUMMARY SPREADSHEET

Offeror (Prime) Name:

					Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Government Labor Category	Proposed 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
Employee Name 1							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Employee Name 2							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Etc.							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Total Direct Labor Cost						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 Contractor Indirect Labor Cost
Overhead							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Fringe Benefits							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
G&A							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Indirect Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Direct and Indirect Labor cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
COM																					$0.00
Total Prime Contractor Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00

Subcontractor Labor Cost
Subcontractor Proposed Cost and Fee
Subcontractor 1											0.00	$0.00
Subcontractor 2											0.00	$0.00
Etc.											0.00	$0.00
Total Proposed Subcontractor Labor Cost and Fee	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 contractor pass through (not including fee)
Handling		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
G&A		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Other (if any)		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Total Pass Through (Not Including Fee)		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Total Subcontractor Cost, Including Pass Through		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00

Total Labor Cost (Prime and Subcontractor Labor) 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Prime Contractor Fee for Subcontractor Labor *	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total Fee (for Prime and Subcontractor Labor)	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Total Labor Cost Plus Fixed Fee (CPFF) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Other Direct Costs
Other Direct Costs (ODCs)						$0.00
Any adders to ODCs						$0.00
Total ODCs	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Total CPFF all CLINs (Labor and ODCs) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Grand Total of CPFF all CLINs
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!

&F &A Page &P N00421-23-R-0007

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

Offeror Cost Summary

OFFEROR COST SUMMARY SHEET

Offeror (Prime) Name:

					Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Government Labor Category	Proposed 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
Employee Name 1							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Employee Name 2							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Etc.							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Total Direct Labor Cost						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 Contractor Indirect Labor Cost
Overhead							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Fringe Benefits							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
G&A							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Indirect Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Direct and Indirect Labor cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
COM																					$0.00
Total Prime Contractor Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00

Subcontractor Labor Cost
Subcontractor Proposed Cost and Fee
Subcontractor 1											0.00	$0.00
Subcontractor 2											0.00	$0.00
Etc.											0.00	$0.00
Total Proposed Subcontractor Labor Cost and Fee	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 contractor pass through (not including fee)
Handling		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
G&A		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Other (if any)		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Total Pass Through (Not Including Fee)		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
Total Subcontractor Cost, Including Pass Through		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00

Total Labor Cost (Prime and Subcontractor Labor) 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Prime Contractor Fee for Subcontractor Labor *	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total Fee (for Prime and Subcontractor Labor)	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Total Labor Cost Plus Fixed Fee (CPFF) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Other Direct Costs
Other Direct Costs (ODCs)						$0.00
Any adders to ODCs						$0.00
Total ODCs	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Total CPFF all CLINs (Labor and ODCs) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Grand Total of CPFF all CLINs
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!

&A Page &P N00421-23-R-0007

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

Offeror CLIN Summary

CLIN Summary Sheet

CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
1000	CPFF Labor Ceiling	0.00	0.00	0.00	0.00
1010	Cost ODC Ceiling	NA	0.00	NA	0.00
Total		0.00	0.00	0.00	0.00

&A N00421-23-R-0007

Subcontractor Instructions Instructions for Subcontractors for the Cost Summary Sheet (using the Subcontractor Sample Cost Summary Sheet for Row/Column references):

	General Instructions		1	The Subcontractor shall prepare only one Cost Summary Sheet for the entire period of performance. When Subcontractors are submitting documents directly to the Government vice as part of the Offeror's proposal, the Subcontractor shall provide the Offeror with the total proposed hours and cost per year such that the Offeror can complete its Cost Summary sheet.
			2	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
			3	All cells shall be unprotected and unlocked, with formulas intact to show mathematical operations.
			4	Where it is necessary to add additional rows, the Subcontractor shall ensure the integrity of all formulas.
			5	All dollar figures shall be carried out no further than two decimal places.
			6	Cells in the Subcontractor Cost Summary sheet that do not require edits are highlighted in gray.
			7	Cells in the Subcontractor Cost Summary sheet that require Subcontractor inputs are highlighted in yellow.
			8	Cells in the Subcontractor Cost Summary sheet that are auto calculated are highlighted in green. Offerors shall ensure that formulas are properly applied to any inserted rows.
			9	The Subcontractor shall change the name of the "Subcontractor Cost Summary" Worksheet, by replacing "Subcontractor" with the Subcontractor's name.
	Offeror Name		Cell B3	Enter the Offeror name
	Subcontractor Name		Cell C3	Enter the Subcontractor name
	Subcontractor Labor Cost	Prime Contractor Direct Labor	Rows 9-11+
Column A	Starting at row 9, the Subcontractor shall enter all Subcontractor employee names. If necessary, insert additional rows.
			Rows 9-11+
Column B	Starting in row 9, the Subcontractor shall specify a Government Labor Category using the information provided in the tables of Section L, Paragraph 5.4.
			Rows 9-11+
Column C	Starting at row 9, the Subcontractor shall insert the title of the proposed labor category it will be utilizing, as recorded in the Subcontractor's accounting system, that correlates to each of the Government specified labor categories shown in column B. When more than one person is proposed to provide services for a labor category, that labor category shall be listed multiple times 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. If necessary, insert additional rows.
			Rows 9-11+
Column D	The Subcontractor shall identify whether the individual specified for this labor category is full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
			Rows 9-11+

Column E

	The Subcontractor shall insert "Off" if the worker will be performing at the Contractor's facility (i.e., off-site location hours) or "On" if it will be performing in the Government Spaces (i.e., on-site location hours).
		Rows 9-11+
Columns F, I, L, O, and R	The Subcontractor shall insert the proposed direct labor rate for each employee/labor category (starting in Row 9). The proposed direct labor rate shall be equal to or greater than the Minimum Rate (Column H) stated in the "Minimum Direct Labor Rates" worksheet. Note, the Subcontractor shall not use any fully burdened hourly rates when pricing the labor of its employees.
		Rows 9-11+
Columns G, J, M, P, and S	The Subcontractor shall insert the proposed 'Hours' for each employee/labor category (starting in Row 9).

Column U sums the respective 'Hours' from each year.

		Rows 9-11+
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Rate x Hours).

Column V sums the respective 'Amounts' from each year.

		Row 12
Columns G, J, M, P, and S	The Total Direct Labor Cost 'Hours' are auto calculated based on the provided formulas (Summation of the Amount for Rows 9-11+)

Column U sums the respective 'Hours' from each year.

		Row 12
Columns H, K, N, Q, and T	The Total Direct Labor Cost 'Amount' is auto calculated based on the provided formulas (Summation of the Amount for Rows 9-11+)

Column V sums the respective 'Amounts' from each year.

		Prime Contractor Indirect Labor Cost	Rows 14-16+
Columns A	The Subcontractor shall insert the type of/names of any indirect rates. For example, if there are multiple fringe rates, insert additional rows to reflect each fringe rate apply accordingly.
			Rows 14-16+
Columns F, I, L, O, and R	The Subcontractor shall insert applicable annual indirect rates under the 'Rates' column for the respective year.
			Rows 14-16+
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas for each year (Indirect Rate x Total Direct Labor Cost).

Column V sums the respective 'Amounts' from each year.

		Total Direct and Indirect Labor Cost	Row 18
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Total Direct Labor Cost + Total Indirect Labor Cost)

Column V sums the respective 'Amounts' from each year.

		COM	Row 19
Columns H, K, N, Q, and T	The Subcontractor shall insert the proposed Facilities Capitol Cost of Money (COM) for each year.

Column V sums the respective 'Amounts' from each year.

		Total Prime Contractor Labor Cost	Row 19
Columns H, K, N, Q, and T	The 'Amounts' are auto calculated based on the provided formulas (Total Direct and Indirect Labor Cost + COM)

Column V sums the respective 'Amounts' from each year.

&A N00421-23-R-0007

Sample Sub Cost Summary

SAMPLE SUBCONTRACTOR COST SUMMARY SPREADSHEET

Offeror (Prime) Name:
Subcontractor Name:
					Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Government Labor Category	Proposed 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
Employee Name 1							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Employee Name 2							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Etc.							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Total Direct Labor Cost						0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00	0.00	$0.00
Subcontractor Indirect Labor Cost
Overhead							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Fringe Benefits							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
G&A							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Indirect Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Direct and Indirect Labor cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
COM																					$0.00
Total Subcontractor Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00

&F &A Page &P N00421-23-R-0007

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

Subcontractor Cost Summary

COST SUMMARY SPREADSHEET

Offeror (Prime) Name:
Subcontractor Name:
					Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Government Labor Category	Proposed 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
Employee Name 1							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Employee Name 2							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Etc.							$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
Total Direct Labor Cost						0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00	0.00	$0.00
Subcontractor Indirect Labor Cost
Overhead							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Fringe Benefits							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
G&A							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Indirect Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
Total Direct and Indirect Labor cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00
COM																					$0.00
Total Subcontractor Labor Cost							$0.00			$0.00			$0.00			$0.00			$0.00		$0.00

&F &A Page &P N00421-23-R-0007

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

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