Attachment_10_-_Cost_Summary_Worksheet.xls

XLS spreadsheet 155 KB Posted Jun 17, 2014

Attached to: COMPETITIVE SOLICITATION FOR THE DESIGN & PRODUCTION OF THE TECHNICAL INSERTION 16 (TI-16) COMMON DISPLAY SYSTEM (CDS) (FULL AND OPEN)
Solicitation number: N00024-14-R-5217
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment 10 - Cost Summary Worksheets

View the file

Other files

File	Type	Posted
Response_to_Offerors_Questions.pdf	PDF	Jul 31, 2014
SF30_N00024-14-R-5217_0001.pdf	PDF	Jul 31, 2014
CDS_TI16_N00024-14-R-5217.pdf	PDF	Jun 17, 2014
Attachment_1_-_DD254.pdf	PDF	Jun 17, 2014
Exhibit_A_-_CDRL's_06.09.14.pdf	PDF	Jun 17, 2014
CDS_TI16_N00024-14-R-5217_Word_Version.doc	DOC document	Jun 17, 2014
Attachment_9_-Bidders_Question_Form.xls	XLS spreadsheet	Jun 17, 2014

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-10 (Summary Matrix)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10
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 0008, 1004, 2004, 3004, 4004, 5001, 5002, 5003, 5005, and 5006	X
0001	Variant A Design		X	X			X
0002	Variant A FAU Production		X	X			X
0003	Variant A Testing & Acceptance
0004	Variant B Design		X	X			X
0005	Variant B FAU Production		X	X			X
0006	Variant B Testing & Acceptance
0007	Engineering Services		X		X		X
0008	Other Direct Costs (ODCs) *
0009	Variant A Production Units for DDG 119		X	X		X	X
0010	Variant A Production Units for SSDS		X	X		X	X
0011	Variant B Production Units for SSDS		X	X		X	X
0012	Variant A Production Units for DDG 81		X	X		X	X
0013	Variant A Production Units for DDG 83		X	X		X	X
0014	Schedule Incentives 0001, 0002, 0004, 0005 (CLINs 0009, 0010, 0011, 0012, 0013) *
0014AA	Incentive for DDG 119 Delivery (CLIN 0009) *
0014AB	Incentive for SSDS (CLIN 0010, 0011) *
0014AC	Incentive for DDG 81 (CLIN 0012)
0014AD	Incentive for DDG 83 (CLIN 0013) *
1001	Variant A Production *
1002	Variant B Production *
1003	Engineering Services		X		X		X
1004	Parts & Materials for CLINs 1003
1005	Other Direct Costs (ODCs) *
2001	Variant A Production *
2002	Variant B Production *
2003	Engineering Services		X		X		X
2004	Parts & Materials for CLIN 2003
2005	Other Direct Costs (ODCs) *
3001	Variant A Production *
3002	Variant B Production *
3003	Engineering Services		X		X		X
3004	Parts & Materials for CLIN 3003
3005	Other Direct Costs (ODCs) *
4001	Variant A Production *
4002	Variant B Production *
4003	Engineering Services				X
4004	Parts & Materials for CLIN 4003
4005	Other Direct Costs (ODCs) *
5001	Data *
5002	Data *
5003	Data *
5004	Data Rights
5005	PIO *
5006	Spares and INCO *
	* CLINs not included in the J-10 Cost Summary
TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10

&CDRAFT

2a (CLIN Summary by FY)

TI-16 CDS SECTION L - COST TABLE ATTACHMENT J-10 2a
FY Cost Summary Detail for Priced CLINs *
CLIN	FY15	FY16	FY17	FY18	FY18	FY19	FY20	FY21	FY22	FY23	TOTAL Proposed CLIN Amount
CLIN 0001
CLIN 0002
CLIN 0003
CLIN 0004
CLIN 0005
CLIN 0006
CLIN 0007
CLIN 0008
CLIN 0009
CLIN 0010
CLIN 0011
CLIN 0012
CLIN 0013
CLIN 1003
CLIN 1004
CLIN 1005
CLIN 2001
CLIN 2002
CLIN 2003
CLIN 2004
CLIN 2005
CLIN 3001
CLIN 3002
CLIN 3003
CLIN 3004
CLIN 3005
CLIN 4001
CLIN 4002
CLIN 4003
CLIN 4004
CLIN 4005
CLIN 5004**
TOTAL
* Production FFP CLINs Prices (1001, 1002, 2001, 2002, 3001, 3002, 4001, and 4002) shall be entered at the stepladder quatitiestable as specified in Section B - Note D.
** Offeror shall enter one (1) price for CLIN 5004 Data Rights in total Proposed CLIN amount. 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)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2b
Cost Summary Table By CLIN/SLIN
Major Cost Element	CLIN 0001	CLIN 0002	CLIN 0004	CLIN 0005	CLIN 0009	CLIN 0010	CLIN 0011	CLIN 0012	CLIN 0013	Total
Purchase Parts ($)
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 ($)
Direct Manufacturing Labor (Hours)
Direct Manufacturing Labor ($)
Manufacturing Overhead ($)
Total Manufacturing ($)
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	CPIF	CPIF	CPIF	FPIF	FPIF	FPIF	FPIF	FPIF	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.
*Under CLIN 0006, Offeror shall include a SLIN Column for each Enhanced Data Rights Item priced option offered in section B.
TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2b

2c (Breakout by CY)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2c

Cost Summary Detail by Calendar Year For CLINs 0001, 0002, 0004, 0005, 0009, 0010, 0011, 0012, and 0013 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

CY15

CY16

CY17

CY18

CY19

CY20

CY21

CY22

CY23

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

Purchase Parts

Material Overhead ($)

Major Subs

Other Subs

Interorganizational Transfer

Total Material Non-Recurring

Material Recurring

Purchase Parts

Material Overhead ($)

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

Manufacturing

Category/Personnel

Manufacturing Indirect Rates

Total Labor Non-Recurring

Labor Recurring

Program Management

Category/Personnel

Program Management Indirect Rates

Engineering

Category/Personnel

Engineering Indirect Rates

Manufacturing

Category/Personnel

Manufacturing 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-10 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.)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2c

2d (Eng Svcs Breakout)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2d

Cost Summary Detail for CLINs 0007, 0008, 1003, 2003, 3003, 4003 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

CY15

CY16

CY17

CY18

CY19

CY20

CY21

CY22

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 0007

CLIN 1003

CLIN 2003

CLIN 3003

Total Hours

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 Worksheet J-10 (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 )

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2e
Cost Summary Table by Contract WBS for CLINs 0001, 0002, 0004, 0005, 0009, 0010, 0011, 0012, 0013
		Total														CY13
Line Item *	Description	Material Costs		Major Sub Ktr Costs		Other Sub Ktr Costs		Interorganizational Transfer Costs	Cost of Material	Labor Category Costs		Other Direct Costs		Total Costs		Material 1 Costs			Material 2 Costs			Material N Costs			Material Costs Total		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
Line Item		NRE	RE	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
1.0	TI 16 CDS Console
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 Form L-N Instructions.
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.
TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10 2e

2f (Rate Summary)

TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10
Cost Category
	Rates by Calendar Year
Rates Category	2015	2016	2017	2018	2019	2020	2021	2022	2023
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-10 (Summar 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.
TI-16 CDS SECTION L COST TABLE ATTACHMENT J-10

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.