N63394-23-R-0022_Attachment JS-5_Cost_Summary_Workbook.xlsx

XLSX spreadsheet 30 KB Posted Jan 4, 2023

Attached to: MK 41 VLS ISEA Support Federal contract opportunity
Solicitation number: N63394-23-R-0022
Issued by: Department of the Navy Naval Sea Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to MK 41 VLS ISEA Support, newest first.
File	Type	Posted
N6339423R0022_Solicitation_Amendment_08_Conformed_Copy.pdf	PDF	Mar 31, 2023
N6339423R0022_Solicitation_Amendment_08_Summary_of_Changes.pdf	PDF	Mar 31, 2023
N6339423R0022_Solicitation_Amendment_07_Conformed_Copy.pdf	PDF	Mar 28, 2023
N6339423R0022_Solicitation_Amendment_07_Summary_of_Changes.pdf	PDF	Mar 28, 2023
Section J_Rev Amendment 6.docx	DOCX document	Mar 16, 2023
N6339423R0022_Solicitation_Amendment_06_Summary_of_Changes.pdf	PDF	Mar 16, 2023
N63394-23-R-0022_Exhibit A - DIDs_3_13_23.pdf	PDF	Mar 16, 2023
N6339423R0022_Exhibit A CDRLs_Rev.pdf	PDF	Mar 16, 2023
N6339423R0022_Solicitation_Amendment_06_Conformed_Copy.pdf	PDF	Mar 16, 2023
N6339423R0022_Solicitation_Amendment_05_Summary_of_Changes.pdf	PDF	Mar 3, 2023
N6339423R0022_Solicitation_Amendment_05_Conformed.pdf	PDF	Mar 3, 2023
N6339423R0022_Solicitation_Amendment_04_Conformed.pdf	PDF	Feb 13, 2023
N6339423R0022_Solicitation_Amendment_04_Summary_of_Changes.pdf	PDF	Feb 13, 2023
N6339423R0022_Solicitation_Amendment_03_Summary_of_Changes.pdf	PDF	Jan 30, 2023
N6339423R0022_Solicitation_Amendment_03_Conformed.pdf	PDF	Jan 30, 2023
N6339423R0022_Solicitation_Amendment_02_Conformed.pdf	PDF	Jan 18, 2023
N6339423R0022_Solicitation_Amendment_02_Summary_of_Changes.pdf	PDF	Jan 18, 2023
N6339423R0022_Solicitation_Amendment_01_Conformed.pdf	PDF	Jan 11, 2023
N6339423R0022_Solicitation_Amendment_01_Summary_of_Changes.pdf	PDF	Jan 11, 2023
N63394-23-R-0022_Exhibit A - CDRLs.pdf	PDF	Jan 4, 2023
N63394-23-R-0022_Attachment J-2_Contract_Security_Specification (DD Form 254).pdf	PDF	Jan 4, 2023
N63394-23-R-0022_Attachment JS-8_DCAA_Rate_Check_Form.xls	XLS spreadsheet	Jan 4, 2023
N6339423R0022 Solicitation.pdf	PDF	Jan 4, 2023
N63394-23-R-0022_Attachment JS-6_BLS.xlsx	XLSX spreadsheet	Jan 4, 2023
N63394-23-R-0022_Attachment J-9_Quality_Assurance_Surveillance_Plan_(QASP).docx	DOCX document	Jan 4, 2023
N63394-23-R-0022_Exhibit A - DIDs.pdf	PDF	Jan 4, 2023
N63394-23-R-0022_Attachment JS-4_Staffing_Plan_Matrix.xls	XLS spreadsheet	Jan 4, 2023
N63394-23-R-0022_Attachment J-7_SCA_Wage_Determination.pdf	PDF	Jan 4, 2023

Show all 28

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.

Labor

SOLICITATION NO. N63394-23-R0022 ATTACHMENT JS-5

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

Employee Name 2

$ - 0

Etc.

$ - 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

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%.

ODC

SOLICITATION NO. N63394-23-R0022 ATTACHMENT JS-5

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	$ 4,512,100			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 4,512,100
Option Period 1	$ 4,647,463			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 4,647,463
Option Period 2	$ 4,786,887			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 4,786,887
Option Period 3	$ 4,930,493			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 4,930,493
Option Period 4	$ 5,078,408			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 5,078,408
Total Other Direct Costs - Material	$ 23,955,352			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ 23,955,352

Other Direct Cost Travel
Base Period	$ 3,229,557	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,229,557
Option Period 1	$ 3,326,444	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,326,444
Option Period 2	$ 3,426,237	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,426,237
Option Period 3	$ 3,529,025	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,529,025
Option Period 4	$ 3,634,895	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,634,895
Total Other Direct Costs - Travel	$ 17,146,159	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 17,146,159

Total Other Direct Cost $ 41,101,510 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 41,101,510

Indirect Rate Support

Sample Indirect Rate Supporting Documentation
SOLICITATION NO. N63394-23-R0022 ATTACHMENT JS-5
	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.

File details come from the government source that posted it. Updated Jan 4, 2023.