Solicitation_Attachment_1_Cost_Summary_Worksheet.xls

XLS spreadsheet 152 KB Posted Dec 2, 2014

Attached to: Inertial Navigation System- Replacement Federal contract opportunity
Solicitation number: N00024-15-R-5226
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

N00024-15-R-5226_SolictiationAttachment1_CostSummary

View the file

Other files for this federal contract opportunity

Other files attached to Inertial Navigation System- Replacement, newest first.
File	Type	Posted
Exhibit_A_INS-R_Contract_Data_Requirements_List_(CDRL)_update_22JAN15.pdf	PDF	Jan 27, 2015
Attachment_2_BiddersQuestion_Response7.pdf	PDF	Jan 27, 2015
v2_N00024-15-R-5226_page_Count.docx	DOCX document	Jan 16, 2015
v3_RFP_Generated_12-2-2014_withtrackchanges_1-16-2015.pdf	PDF	Jan 16, 2015
v2_Solicitation_Attachment_4_Relevant_Experience_Form_amendment_12-11-2014.pdf	PDF	Jan 16, 2015
Attachment2_BiddersQuestions_Response6.pdf	PDF	Jan 12, 2015
Attachment2_BiddersQuestions_Response5.pdf	PDF	Jan 12, 2015
N00024-15-R-5226_page_Count.docx	DOCX document	Jan 9, 2015
Attachment_2_Bidders_Question_response_4.pdf	PDF	Dec 23, 2014
v2_RFP_Generated_12-2-2014_withtrackchanges.pdf	PDF	Dec 23, 2014
Attachment_2_-Bidders_Question_response_3.pdf	PDF	Dec 23, 2014
Attachment_2_-Bidders_Question_response_2.pdf	PDF	Dec 22, 2014
Attachment_2_-Bidders_Question_response_1.pdf	PDF	Dec 15, 2014
Solicitation_Attachment_2_-Bidders_Question_Form.xls	XLS spreadsheet	Dec 2, 2014
Section_J_Attachment1_DD254.pdf	PDF	Dec 2, 2014
Section_J_ExhibitA_CDRLs.pdf	PDF	Dec 2, 2014
Section_J_Attachment2_GFI_GFP_List_11-04-14.xlsx	XLSX spreadsheet	Dec 2, 2014
RFP_Generated_12-2-2014.pdf	PDF	Dec 2, 2014
Solicitation_Attachment_4_Relevant_Experience_Form.doc	DOC document	Dec 2, 2014

Show all 19

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.

(Summary Matrix)

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1
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
0001	ISM Design (PDR)
0002	EDM Build (Surface)
0003	EDM Build (Submarine)
0004	Data
0005	Other Direct Costs (ODCs)
0006	Design (CDR) (Surface)
0007	Design (CDR) (Submarine)
0008	Engineering Support Services Yr 1
0009	Data Rights
1001	ISM Testing (Including TRR)
1002	PPU Build (Surface)
1003	PPU Build (Submarine)
1004	Reserved
1005	Other Direct Costs (ODCs)
1006	Modeling & Simulation
1007	Reserved
1008	Engineering Support Services Yr 2
2001	Production Readiness Review (PRR)
2002	LRIP (Surface)
2003	LRIP (Submarine)
2004	Reserved
2005	Other Direct Costs (ODCs)
2006	Modeling & Simulation
2007	PIO
2008	Depot Spares (Surface)
2009	Depot Spares (Submarine)
2010	INCO Spares (Surface)
2011	INCO Spares (Submarine)
2012	OBRP Spares (Surface)
2013	OBRP Spares (Submarine)
3001	Reserved
3002	Production (Surface)
3003	Production (Submarine)
3004
3005	Other Direct Costs (ODCs)
3006	Reserved
3007	Reserved
3008	Engineering Support Services Yr 4
3009	Depot Spares (Surface)
3010	Depot Spares (Submarine)
3011	INCO Spares (Surface)
3012	INCO Spares (Submarine)
3013	OBRP Spares (Surface)
3014	OBRP Spares (Submarine)
4001	Reserved
4002	Production (Surface)
4003	Production (Submarine)
4004	Reserved
4005	Other Direct Costs (ODCs)
4006	Reserved
4007	Reserved
4008	Engineering Support Services Yr 5
4009	Depot Spares (Surface)
4010	Depot Spares (Submarine)
4011	INCO Spares (Surface)
4012	INCO Spare (Submarine)
4013	OBRP Spares (Surface)
4014	OBRP Spares (Submarine)
INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1

&CDRAFT

2a (CLIN Summary by FY)

INS-R ISM SECTION L - COST TABLE SOLICITATION ATTACHMENT 1 2a
FY Cost Summary Detail for Priced CLINs
CLIN	FY15	FY16	FY17	FY18	FY18	FY19	FY20	FY21	FY22	FY23	TOTAL Proposed CLIN Amount
0001
0002
0003
0004
0005
0006
0007
0008
0009
1001
1002
1003
1004
1005
1006
1007
1008
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
3001
3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
4001
4002
4003
4004
4005
4006
4007
4008
4009
4010
4011
4012
4013
4014
Total

2b (CLIN Breakout)

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2b

Cost Summary Table By CLIN/SLIN

Major Cost Element

CLIN 0001

CLIN 0002

CLIN 0003

CLIN 0005

CLIN 0006

CLIN 0007

CLIN 0008

CLIN 0009

CLIN 1001

CLIN 1002

CLIN 1003

CLIN 1005

CLIN 1006

CLIN 1008

CLIN 2001

CLIN 2002

CLIN 2003

CLIN 2005

CLIN 2006

CLIN 2007

CLIN 2008

CLIN 3002

CLIN 3003

CLIN 3005

CLIN 3008

CLIN 4002

CLIN 4003

CLIN 4005

CLIN 4008

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

COST

CPIF

CPFF

CPIF

COST

CPIF

CPFF

CPIF

CPFF

FPIF

CPFF

FPIF

CPFF

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.

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2b

2c (Breakout by CY)

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2c

Cost Summary Detail by Calendar Year For CLINs 0001, 0002, 0003, 0005, 0006, 0007, 0008, 0009, 1001, 1002, 1003, 1005, 1006, 1008, 2001, 2002, 2003, 2005, 2006, 2007, 2008, 3002, 3003, 3005, 3008, 4002, 4003, 4005, 4008 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

Base

Year 2

Year 3

Year 4

Year 5

Total $

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

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2c

2d (Eng Svcs Breakout)

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2d

Cost Summary Detail for CLINs 0008, 1008, 2008, 3008, and 4008 (Offeror shall provide a separate sheet for each CLIN)

Major Cost Element

Base

Year 2

Year 3

Year 4

Year 5

TOTAL

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

Base

Year 2

Year 3

Year 4

Year 5

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 $

Program Manager

Senior Engineer

Engineer

Senior Production Manager

Senior Logistician

Admin

TOTAL CLIN COST

Prepare one of these forms for each CLIN

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.

Total values shall be computed in this form.

Provide equations for Total Cost computation.

2e (WBS )

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2e
		Total														Base
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	INS-R ISM
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.
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.
INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1 2e

2f (Rate Summary)

INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1
Cost Category
	Rates by Calendar Year
Rates Category	Base	Year 2	Year 3	Year 4	Year 5
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 applicable
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.
INS-R ISM SECTION L COST TABLE SOLICITATION ATTACHMENT 1

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.