Attachment_11_-Cost_and_Price_Evaluation_Worksheet.xls

XLS spreadsheet 144 KB Posted Jun 15, 2017

Attached to: U. S Navy Electronic Chart Display and Information System Software
Solicitation number: N00024-17-R-5216
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment 11 - Cost/Price Spreadsheet

View the file

Other files

File	Type	Posted
Q&A_Response_Package_-_Batch_4.pdf	PDF	Aug 16, 2017
Attachment_11_-Cost_and_Price_Evaluation_Worksheet_Rev._2_8-9-2017.xls	XLS spreadsheet	Aug 10, 2017
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_2_-_Conformed_Copy.pdf	PDF	Aug 10, 2017
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_2.pdf	PDF	Aug 10, 2017
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_1.pdf	PDF	Aug 2, 2017
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_1_-_Conformed_Copy.pdf	PDF	Aug 2, 2017
Attachment_11_-Cost_and_Price_Evaluation_Worksheet_Rev._1_8-2-2017.xls	XLS spreadsheet	Aug 2, 2017
NAVY_ECDIS_SOFTWARE_(17-R-5216)_SIGNED_CDRLS_DTD_7-27-17.pdf	PDF	Aug 2, 2017
Q&A_Response_Package_-_Batch_3.pdf	PDF	Jul 25, 2017
Q&A_Response_Package_-_Batch_2.pdf	PDF	Jul 12, 2017
Q&A_Response_Package_-_Batch_1.pdf	PDF	Jul 3, 2017
N00024-17-R-5216_Ex_A_CDRLs_(Searchable_File).pdf	PDF	Jun 21, 2017
Attachment_12_-_Past_Performance_Questionnaire.docx	DOCX document	Jun 15, 2017
NAVY_ECDIS_SOFTWARE_(17-R-5216)_SIGNED_CDRLS_DTD_1-31-17.pdf	PDF	Jun 15, 2017
Attachment_5_-_Terms_of_Use_Letter_-_SRD.docx	DOCX document	Jun 15, 2017
Attachment_13_-_Contractor_Compliance_Checklist.docx	DOCX document	Jun 15, 2017
NAVY_(17-R-5216)_ADDRESSEE_LIST_6-15-17.pdf	PDF	Jun 15, 2017
Attachment_10_-_Offerors_Question_and_Answer_Sheet.xls	XLS spreadsheet	Jun 15, 2017
Attachment_9_-_Navy_ECDIS_GFI_List_2017-06-12.xlsx	XLSX spreadsheet	Jun 15, 2017
N00024-17-R-5216_Final_Solicitation.pdf	PDF	Jun 15, 2017
15-NR-46120_DD254_Signed.pdf	PDF	Jun 15, 2017
Attachment_4_-_Terms_of_Use_Letter_-_COGENT.docx	DOCX document	Jun 15, 2017
Draft_RFP_QA_-_Batch_2_-_FBO_Posted_6-9-17.pdf	PDF	Jun 9, 2017
Draft_RFP_Q&A_Response_Packages_-_Batch_1.pdf	PDF	Jun 2, 2017
Offeror_Question_and_Answer_Sheet.xls	XLS spreadsheet	Apr 24, 2017
Navy_ECDIS_SW_N00024-17-R-5216_-_Draft_RFP_.docx	DOCX document	Apr 24, 2017

Show all 26

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.

J-11 (Summary Matrix)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11
CLIN	Description	2a (CLIN Summary by FY)	2b (CLIN Breakout)	2c (Breakout by CY)	2d (Eng Svcs Breakout)	2e (WBS Breakout)	2f (Rate Summary)
CLIN summary	Summary data including all CLINS, excluding CLIN 0004	X
0001	Navy ECDIS SW 1.0 Production Build		X	X		X	X
0002	Engineering Services		X	X	X	X	X
0003	Travel and ODC		X	X		X	X
0004	Data
1001	Navy ECDIS Software 1.1 (Maintenance Build) Engineering Services		X	X	X	X	X
1002	Travel and ODC		X	X		X	X
1003	Government Purpose Data Rights/ Licenses		X	X		X	X
2001	Navy ECDIS Software 1.2 (Maintenance Build) Engineering Services		X	X	X	X	X
2002	Travel and ODC		X	X		X	X
N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11

&CDRAFT

2a (CLIN Summary by FY)

N00024-17-R-5216 Navy ECDIS SW SECTION L - COST TABLE ATTACHMENT J-11 2a
FY Cost Summary Detail for Priced CLINs
CLIN	FY18	FY19	FY20	FY21	FY22	FY23	FY24	FY25	FY26	TOTAL Proposed CLIN Amount
CLIN 0001
CLIN 0002
CLIN 0003
CLIN 0004
CLIN 1001
CLIN 1002
CLIN 1003
CLIN 2001
CLIN 2002
TOTAL
* CLIN 0004 Data Rights is Not Seperately Priced. Does not need to be broken out by FY.
Round cost values to whole dollars.
The cells on this form do not need to be linked to any other form.
Cost should be through FCCM

2b (CLIN Breakout)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2b
Cost Summary Table By CLIN/SLIN
Major Cost Element	CLIN 0001	CLIN 0002	CLIN 0003	CLIN 1001	CLIN 1002	CLIN 1003	CLIN 2001	CLIN 2002	Total
Material Overhead ($)
Major SubContracts ($)
Other SubContracts ($)
Interorganizational Transfer ($)
Total Material ($)
Direct Program Management Labor (Hours)
Direct Program Management Labor ($)
Program Management Overhead ($)
Total Program Management ($)
Direct Engineering Labor (Hours)
Direct Engineering Labor ($)
Engineering Overhead ($)
Total Engineering ($)
Subtotal Labor ($)
Subtotal Material, Labor, and ODC ($)
G&A Expense ($)
Subtotal Estimated Costs less FCCM ($)
Facilities Capital Cost of Money (FCCM) ($)
Total Target Cost ($)
Target Fee/Profit ($)
Target Fee/Profit (%)
CLIN Type	CPIF	CPFF	COST	CPFF	COST	FFP	CPFF	COST	N/A
TOTAL ($)
Round cost values to whole dollars.
Link each cell in this form with the appropriate cells in the Worsheet 2f for each of the CLIN. Do not just paste values where value can be linked to another form.
N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2b

2c (Breakout by CY)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2c

Cost Summary Detail by Calendar Year For CLINs 0001, 0002, 0003, 1001, 1002, 1003, 2001, 2002 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

CY18

CY19

CY20

CY21

CY22

CY23

CY24

CY25

CY26

Total $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Hours/Cost

Rate

SubTotal $

Material Non-Recurring

Major Subs

Other Subs

Interorganizational Transfer

Total Material Non-Recurring

Material Recurring

Major Subs

Other Subs

Interorganizational Transfer

Total Material Recurring

Labor Non-Recurring

Program Management

Category/Personnel

Program Management Indirect Rates

Engineering

Category/Personnel

Engineering Indirect Rates

Total Labor Non-Recurring

Labor Recurring

Program Management

Category/Personnel

Program Management Indirect Rates

Engineering

Category/Personnel

Engineering Indirect Rates

Total Labor Recurring

SUBTOTAL COSTS ($)

G&A Expense ($)

Type

SUBTOTAL COSTS ($)

Facilities Capital Cost of Money (FCCM) ($)

Type

TOTAL ESTIMATED COSTS ($)

Fee/Profit ($)

Fee/Profit (%)

TOTAL ($)

Offeror to fill out this template in accrodance with the CLIN breakout in the J-11 Summary Matrix.

Round cost values to whole dollars.

Link values on this form with values/equations on Worksheet 2f. Do not just paste values where value can be linked to another form.

Sub totals must calculate within this form and not be linked to other forms

Link each cell containing the NRE/RE Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Interorganizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs with the unburdened values in Form L-I or L-J. Link each cell containing rates to appropriate cells in Form L-L.

Calculations with rates computed on this form shall link to rates from Form L-L and material and labor costs from Form L-J.

Cost basis for application of Material Overhead, Indirect Labor Rates, G&A and FCCM must link to value(s) contained in Form L-H, not Form L-J.

For CLIN/SLINs which do not have a required Form L-I or L-J, contractor shall enter costs directly onto this form.

Categories provided are for example only, link categories to actual categories listed on Form L-L.

All values shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2c

2d (Eng Svcs Breakout)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2d

Cost Summary Detail for CLINs 0002, 1001, and 2001 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

CY18

CY19

CY20

CY21

CY22

CY23

CY24

CY25

TOTAL

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

Total $

Labor

Program Management

Category/Personnel

Program Management Indirect Rates

Engineering

Category/Personnel

Engineering Indirect Rates

Manufacturing

Category/Personnel

Manufacturing Indirect Rates

Total Labor

SUBTOTAL COSTS ($)

G&A Expense ($)

SUBTOTAL COSTS ($)

Facilities Capital Cost of Money (FCCM) ($)

TOTAL ESTIMATED COSTS ($)

Fee ($)

Fee (%)

TOTAL ESTIMATED COSTS ($) Plus Fixed Fee

** Shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.)

Major Cost Element

CY15

CY16

CY17

CY18

CY19

CY20

CY21

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Total Labor (Hours)

TOTAL Estimated COSTS ($) Plus Fixed Fee

Composite Rate through Fee

Labor Category

CLIN 0010

CLIN 1010

CLIN 2010

CLIN 3010

CLIN 4010

Total Hours

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Hours

Rate

SubTotal $

Sample Program Manager

Senior Engineer

Engineer

Site Support / Technician

Senior Logistician

Logistician

Admin

TOTAL CLIN COST

Prepare one of these forms for each CLIN as specified on J-11 (Summary Matrix)

See Instructions for Engineering Services Composite Labor Rate BOE to the right of the table.

Round cost values to whole dollars, Round Rates to two decimal points and G&A and FCCM to three decimal points.

Link values on this form with values/equations on other forms. Do not just paste values where value can be linked to another form.

Categories provided are for example only, link categories to actual categories listed on Worksheet 2f.

Rate cells should be linked to the rates Form L-L. Total values shall be computed in this form.

Provide equations for Total Cost computation.

2e (WBS )

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2e
Cost Summary Table by Contract WBS for CLINs 0001, 0002, 0003, 1001, 1002, 1003, 2001, 2002
Line Item *	Description	Major Sub Ktr Costs		Other Sub Ktr Costs		Interorganizational Transfer Costs	Cost of Material	Labor Category Costs		Other Direct Costs		Total Costs		Major Sub Ktr 1 Costs			Major Sub Ktr 2 Costs			Major Sub Ktr N Costs			Major Sub Ktr Costs Total		Other Sub Ktr 1 Costs			Other Sub Ktr 2 Costs			Other Sub Ktr N Costs			Other Sub Ktr Costs Total		Interorganizational Transfer 1 Costs			Interorganizational Transfer 2 Costs			Interorganizational Transfer N Costs			Interorganizational Transfer Costs Total		Labor Category 1 Costs
Line Item		NRE	RE	NRE	RE	NRE	RE	NRE	RE	NRE	RE	NRE	RE	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	Rate	NRE	RE	NRE	RE	Rate
1.0	Navy ECDIS SW - Production Build 1.0
1.1	* Sample WBS Structure
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.1.3.1
1.1.1.3.2
1.1.1.3.3
1.1.1.4
1.1.1.5
1.1.1.6
1.1.1.7
1.1.1.7.1
1.1.1.7.2
1.1.1.8
1.1.1.9
1.1.1.10
1.1.1.11
1.1.1.12
1.1.1.13
1.1.1.13.1
1.1.1.13.2
1.1.1.13.3
1.1.1.14
1.1.1.14.1
1.1.1.14.2
1.1.1.14.3
1.1.1.15
1.1.2
1.1.3
1.1.4
1.1.4.1
1.1.4.1.1
1.1.4.1.1.1
1.1.4.1.1.2
1.1.4.1.2
1.1.4.1.3
1.1.4.1.3.1
1.1.4.1.3.2
1.1.4.1.3.3
1.1.4.1.4
1.1.4.1.4.1
1.1.4.1.4.2
1.1.4.1.4.3
1.1.4.2
1.1.4.3
1.1.4.4
1.1.4.5
1.1.5
1.1.5.1
1.1.5.2
1.1.5.3
1.1.6
1.1.6.1
1.1.6.2
1.1.6.3
1.1.6.4
1.1.6.5
1.1.7
1.1.7.1
1.1.7.2
1.1.8
1.1.8.1
1.1.8.2
1.1.9
1.1.10
1.1.11
1.2
	Totals
Prepare one of these forms for each CLIN as specified on J-11 (Summary Matrix).
Round cost values to whole dollars.
Rate cells should be linked to the rates Worksheet 2f. Total values shall be computed in the form.
Cells containing the NRE/RE Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Interorganizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs in this form are industry inputs.
Link each cell containing rates to appropriate cells in Worksheet 2f. Displayed rate shall be through G&A.
Provide equations for Total Cost computation. Costs shall be through G&A.
Add additional columns for additional labor, material and sub-contractor costs as required.
The formulas in this form shall compute the appropriate parent/child cost roll up relationships.
N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2e

2f (Rate Summary)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2f
Cost Category
Rates Category	2018	2019	2020	2021	2022	2023	2024	2025
Material Overhead
Category 1
Category 2
Category n
Direct Labor Rate
Category 1
Category 2
Category n
Indirect Rate
Category 1
Category 2
Category n
General & Adminstrative Rate
Category 1
Category 2
Category n
Facility Capital Cost of Money Rate
Category 1
Category 2
Category n
Other Rate
Category 1
Category 2
Category n
*
*
*
Category N
Prepare one of these forms as needed for each CLIN as specified in the J-11 (Summary Matrix)
These rates will be used in rates cells in Worksheets 2a, 2b, 2c, 2d, 2e.
Round cost values to whole dollars, Round Rates to two decimal points and G&A and FCCM to three decimal points.
Rate categories shall include all rates used in this proposal.
Categories listed are for example only, provide actual categories included in the proposal.
N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2f

2g (BOM)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2g
Bill of Material (BOM)
Item #	CLIN	WBS	Part Number	Part Description	Supplier	Qty	Unit Price	Extended Price	Total

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Nov 14, 2017.