N63394-21-R-0504_Attachment_JS-8_Cost_summary_format(2).xls

XLS spreadsheet 82 KB Posted Jul 14, 2021

Attached to: Cooperative Engagement Capability (CEC) Alteration Installation Team (AIT)
Solicitation number: N6339421R0504
Issued by: Department of the Navy Naval Sea Systems Command

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a cost summary format template and required staffing plan for a federal contract solicitation.

The Naval Surface Warfare Center Port Hueneme Division is soliciting engineering and technical support services for Cooperative Engagement Capability Alteration Installation Teams. The contractor will perform installation, modification, logistics, and upgrade services for various CEC systems. Duties include installation task planning, material procurement, prefabrication, execution and closeout. The contractor will also handle material tracking, inventory management, shipping, disposal, and database updates. The primary work location is the Naval Surface Warfare Center Port Hueneme Division in California.

The cost summary format template includes tables for labor costs by category and employee, other direct costs by material and travel expenses, and indirect rate documentation. The required staffing plan outlines estimated labor hours by year and labor category. Solicitation number N6339421R0504 has been set aside as a total small business set-aside under NAICS code 336611 for ship repair and maintenance services.

View the file

Other files

File	Type	Posted
CEC AIT Amendment 5 conformed full.docx	DOCX document	Aug 5, 2021
CEC AIT Mod Amendment 5.docx	DOCX document	Aug 5, 2021
CEC AIT Amendment 4 conformed.docx	DOCX document	Jul 23, 2021
CEC AIT Amendment 4 mod.docx	DOCX document	Jul 23, 2021
CEC AIT mod Amendment 3.docx	DOCX document	Jul 19, 2021
CEC AIT conformed Amendment 3.docx	DOCX document	Jul 16, 2021
CEC AIT mod Amendment 3.docx	DOCX document	Jul 16, 2021
Build Connect and Test Cables.xlsx	XLSX spreadsheet	Jul 14, 2021
CEC AIT mod Amendment 2.docx	DOCX document	Jul 14, 2021
CEC AIT conformed Amendment 2.docx	DOCX document	Jul 14, 2021
Cable Repair and Test.xlsx	XLSX spreadsheet	Jul 14, 2021
CEC AIT Amendment 1 mod.docx	DOCX document	Jul 8, 2021
CEC AIT Amendment 1 conformed.pdf	PDF	Jul 8, 2021
Exhibit_A_CDRLs Combined PDF.pdf	PDF	Jul 2, 2021
N63394-21-R-0504_Attachment_JS-8_Cost_summary_format(2).xls	XLS spreadsheet	Jun 23, 2021
CEC AIT RFP Final.pdf	PDF	Jun 23, 2021
J-6_ GFI.pdf	PDF	Jun 23, 2021
JS-9_SCA Wage Determinations.pdf	PDF	Jun 23, 2021
N63394-21-R-0504_Attachment_JS-10_Past_Performance_Questionnaire(Clean).doc	DOC document	Jun 23, 2021
J-4_QASP - CEC AIT.docx	DOCX document	Jun 23, 2021
Exhibit_A_CDRLs Combined PDFs.pdf	PDF	Jun 23, 2021
N63394-21-R-0504_Attachment_JS-7_DCAA_rate_check_form.xls	XLS spreadsheet	Jun 23, 2021
N63394-21-R-0504_Attachment_J-3_Staffing_Plan_no_cost.xlsx	XLSX spreadsheet	Jun 23, 2021

Show all 23

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.

Labor

SOLICITATION NO. N63394-21-R-0504 ATTACHMENT JS-8
COST SUMMARY FORMAT - LABOR COST ESTIMATE
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
		Direct Costs			Indirect Cost Burden 1:			Indirect Cost Burden 2:			Indirect Cost Burden 3:			Indirect Cost Burden 4:			Fixed Fee:			Facilities Capital Cost of Money Burden 1:			Facilities Capital Cost of Money Burden 2:
Cost Elements	Labor Category	Rate	Hours	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Estimated Cost Plus Fixed Fee
Prime Contractor Labor Cost
Prime Contractor Labor
Item 1001
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1101
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1201
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1301
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1401
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Total Prime Contractor Labor Cost				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Subcontractor Labor Cost
Item 1001
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1101
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1201
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1301
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Item 1401
Employee Name 1				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Employee Name 2				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Etc.				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Total Subcontractor Labor Cost				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Total Labor Cost				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0

ODC

SOLICITATION NO. N63394-21-R-0504 ATTACHMENT JS-8
COST SUMMARY FORMAT - ODC ESTIMATE
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
		Indirect Cost Burden 1:			Indirect Cost Burden 2:			Indirect Cost Burden 3:			Indirect Cost Burden 4:			Facilities Capital Cost of Money Burden 1:			Facilities Capital Cost of Money Burden 2:
Cost Elements	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Rate	Allocation Base	Amount	Total Price
Other Direct Cost
Other Direct Cost Material
Base Period	$ 95,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 95,000
Option Period 1	$ 95,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 95,000
Option Period 2	$ 95,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 95,000
Option Period 3	$ 95,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 95,000
Option Period 4	$ 95,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 95,000
Total Other Direct Costs - Material	$ 475,000			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 475,000
Other Direct Cost Travel
Base Period	$ 240,053			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 240,053
Option Period 1	$ 240,053			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 240,053
Option Period 2	$ 240,053			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 240,053
Option Period 3	$ 240,053			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 240,053
Option Period 4	$ 240,053			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 240,053
Total Other Direct Costs - Travel	$ 1,200,265			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 1,200,265
Total Other Direct Cost	$ 1,675,265			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 1,675,265

Offerors may add additional columns to account for the application of additional burdens. Pricing shall be derived from left to right with the far left side including the direct costs and the far right including the direct cost following application of all fees and burdens. Please ensure working formulas. Please remember maximum pass-through rate that shall be charged against any non-ODC CLIN where labor is proposed under this contract shall not exceed 8%.

Required Staff Plan_LOE

	SOLICITATION NO. N63394-21-R-0504 - ATTACHMENT JS-8 REQUIRED STAFFING PLAN
	Labor Category	BLS
Occupation Code	BLS Percentile					eCraft
Occupation Code	SCA
Occupation Code	Place of Performance	Estimated Labor Hours
			10%	25%	50%	75%	90%				Base	OY1	OY2	OY3	OY4	Total
	Manager, Program/Project III	11-9198	$27.08	$39.14	$55.94	$73.88	$94.84	MANP3	N/A	Government Site, TBD	1,135	2,790	3,115	2,635	2,055	11,730
	Project Coordinator	13-1081	$26.96	$35.41	$47.54	$62.95	$81.70	ANM1	N/A	Government Site, TBD	4,427	8,549	10,559	8,642	7,787	39,964
	Platform Manager	11-3000	$27.08	$39.14	$55.94	$73.88	$94.84	MANO2	N/A	Government Site, TBD	3,366	7,681	8,706	7,056	5,791	32,598
	Quality	47-4011	$18.20	$23.49	$30.22	$38.93	$48.64	SQC2	N/A	Government Site, TBD	2,101	3,764	4,526	3,619	3,301	17,311
	Task Leader	11-1021	$22.04	$32.43	$49.83	$77.49	Varies	OS2	N/A	Government Site, TBD	11,496	20,746	27,971	24,996	22,811	108,018
	Electronics Technician Maintenance I	49-2094	$18.83	$24.05	$29.81	$36.12	$42.29	23181	23181	Government Site, TBD	11,575	19,870	26,830	25,270	22,555	106,100
	Electronics Technician Maintenance II	49-2094	$18.83	$24.05	$29.81	$36.12	$42.29	23182	23182	Government Site, TBD	10,675	17,210	23,615	21,835	20,020	93,355
	Electronics Technician Maintenance III	49-2094	$18.83	$24.05	$29.81	$36.12	$42.29	23183	23183	Government Site, TBD	8,565	15,425	20,125	18,675	16,300	79,090
	Laborer/Helper	47-2061	$12.54	$14.75	$18.22	$24.20	$33.60	23470	23470	Government Site, TBD	5,516	10,935	13,366	11,690	9,976	51,483
	Fire Watch	33-2011	$12.95	$17.24	$25.24	$34.07	$45.09	99100	99100	Government Site, TBD	3,135	5,940	7,120	5,325	4,985	26,505
	Welder	51-4121	$14.73	$17.37	$21.25	$25.88	$31.85	23960	23960	Government Site, TBD	5,070	10,140	11,460	7,950	7,350	41,970
	Marine Chemist	19-2031	$21.62	$27.92	$38.13	$52.11	$67.14	CHEM1	30090	Government Site, TBD	1051	2102	2921	2838	2466	11,378
	Foundation Machining	51-4041	$14.06	$17.26	$22.04	$27.85	$33.20	23550	23550	Government Site, TBD	836	1340	1973	1830	1739	7,718
	Optical Alignment Services	17-3098	$17.88	$23.28	$30.86	$39.86	$49.42	30390	30390	Government Site, TBD	95	191	191	95	95	667
	Piping Flush, Clean and Testing	47-2152	$16.09	$20.35	$27.08	$36.24	$47.59	23790	23790	Government Site, TBD	936	2919	3014	2363	1697	10,929
	Total										69,978	129,601	165,491	144,818	128,927	638,816

Indirect Rate Support

Sample Indirect Rate Supporting Documentation
SOLICITATION NO. N63394-21-R-0504 - ATTACHMENT JS-8
	Budget	Actual Expenses
Overhead Expense	2021	2020	2019	2018
Payroll Taxes	$ 110,000	$ 93,000	$ 90,000	$ 85,000
Vacation	$ 50,000	$ 46,000	$ 43,000	$ 42,000
Holiday	$ 40,000	$ 40,000	$ 39,000	$ 38,500
Sick Leave	$ 10,000	$ 9,000	$ 8,000	$ 7,000
Pensions	$ 200,000	$ 175,000	$ 165,000	$ 155,000
Office Equipment	$ 5,000	$ 6,000	$ 65,000	$ 3,000
Depreciation	$ 4,000	$ 1,000	$ 4,000	$ 2,000
Travel	$ 40,000	$ 35,000	$ 33,000	$ 33,000
Reproduction	$ 10,000	$ 9,800	$ 9,700	$ 9,600
Rent	$ 130,000	$ 82,000	$ 75,000	$ 68,000
Advertising	$ 55,000	$ 44,000	$ 50,000	$ 42,000
Insurance	$ 48,000	$ 46,000	$ 44,000	$ 42,000
Telephone	$ 12,000	$ 12,000	$ 11,500	$ 10,000
Total Pool	$ 714,000	$ 598,800	$ 637,200	$ 537,100
Less Unallowable Costs
Entertainment	$ 6,000	$ 4,000	$ 1,000	$ 3,000
Net Allowable Costs	$ 708,000	$ 594,800	$ 636,200	$ 534,100
Allocation Base
Direct Labor	$ 1,895,500	$ 1,756,200	$ 1,650,000	$ 1,530,000
Overhead Rate	37.35%	33.87%	38.56%	34.91%
*Contributing Government Contracts	Expiration Date	Value of Contracts
N000XX-XX-X-00XX	6/1/18
N000XX-XX-X-00XX	9/1/19
N000XX-XX-X-00XX	8/1/17
* When developing your percentage, these are the contracts contributing
to development of the percentage.

Non-Key Proposed Staffing Plan

This table may be used for completing the proposed staffing plan. Key personnel have been removed from this table because their resumes will be provided as a separate part of the proposal. Bidders may propose alternate labor categories and work locations but should note any changes from the baseline. (Note: Number of rows may not total number of FTEs due to part time efforts. Bidders may add rows if desired.)
Labor Category	Gov't Site	KTR Site	CLIN	Name	Company	Company Labor Category	Years of Experience	Highest level of education	Degree	Clearance
Clerical
Admin & Security
* Task Paragraphs with an "X" imply that those labor categories perform multiple subtasks within the primary task paragraph.
FTE = Full Time Equivalent
KTR = Contractor

File details come from the government source that posted it. Updated Jul 14, 2021.