N00039-18-R-0009 - Attachment (4) - Section L Cost Summary Spreadsheet - Rev 02 - 4-4-18.xlsx

XLSX spreadsheet 464 KB Posted Dec 21, 2018

Attached to: Consolidated Afloat Networks and Enterprise Services (CANES) Training Virtual Environment
Solicitation number: N00039-18-R-0009
Issued by: Department of the Navy Information Warfare Systems Command

View the file

Other files

File	Type	Posted
N00039-18-R-0009 - DD2345 - Export Controlled Information Instruction (Rev 1).pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (2a) - TO 0001 - CANES Training VE SOW - Rev 04 - 04-12-18-REV.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (8) CANES Training VE Technical Documents (REV 1).pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (1) - CANES Training VE Base SOW - Rev 03 - 04-04-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (5) - Past Performance Questionnaire.docx	DOCX document	Dec 21, 2018
N00039-18-R-0009 - Exhibit (A) - CANES Training VE - CDRL DD1423 - Rev 1 - 02-26-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP QA Set 3 - 5 Apr 18 - Final.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (2) - DRAFT TO 0001 - Rev 02 - 04-04-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Amendment 0008 - 04-19-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - PKI Certificate Information.docx	DOCX document	Dec 21, 2018
N00039-18-R-0009 - Amendment 0001 - 1 March 2018.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP QA Set 2 - 20 Mar 18 - Amendment 0002.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP QA Set 6 - 18 Apr 18 - Final.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Amendment 0002 - 3-20-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (7) - Small Business Participation Data - Rev 01 - 3-8-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP Q&A Set_1 - 01 March 18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Conformed RFP through Amendment 0008 - 04-19-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP QA Set 4 - 9 Apr 18_Final.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - GWBS Mod F.xlsx	XLSX spreadsheet	Dec 21, 2018
N00039-18-R-0009 - Amendment 0003.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Amendment 0004.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Amendment 0005.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (3) -N00039-18-R-0009 - DD254 - 11-07-17.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (6) - Reference Information Sheet - Rev 1.doc	DOC document	Dec 21, 2018
N00039-18-R-0009 - Amendment 0007 - 04-18-2018.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Amendment 0006.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - Attachment (2b) -Exhibit (A) - TO 0001 - CANES Training VE - CDRL 1423 - Rev 1 - 02-26-18.pdf	PDF	Dec 21, 2018
N00039-18-R-0009 - RFP QA Set 5 - 13 Apr 18 - Final.pdf	PDF	Dec 21, 2018

Show all 28

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.

4-1a PrimeCost Summary Roll-up Prime Offeror Name:

		Total
Cost Elements	RFP Labor Category	Rate	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Labor Category
Labor Category 1	Program Manager
Labor Category 2	Senior Software Engineer
Etc.	Etc.

Total Direct Labor Cost

Prime Contractor Indirect Labor Cost

Overhead

Fringe Benefits

G&A

Total Indirect Labor Cost

Total Direct and Indirect Labor cost

FCCOM

Total Prime Contractor Labor Cost

Material

Material and Handeling Charge

Subcontractor 1 Cost

Subcontractor 2 Cost

Total Cost

Target Fee

Total Cost Plus Target Fee

N00039-18-R-0009

CANES TRAINING VIRTUAL ENVIRONMENT

4-1b Sub Cost Summary Roll-up

Prime Offeror Name:
Subcontractor Name:
		Total
Cost Elements	RFP Labor Category	Rate	Hours	Amount
Sub Contractor Labor Cost
Sub Contractor Labor Category
Labor Category 1	Program Manager
Labor Category 2	Senior Software Engineer
Etc.	Etc.

Total Direct Labor Cost

Sub Contractor Indirect Labor Cost

Overhead

Fringe Benefits

G&A

Total Indirect Labor Cost

Total Direct and Indirect Labor cost

FCCOM

Total Sub Contractor Labor Cost

Material

Material and Handeling Charge

Total Cost

Target Fee

Total Cost Plus Target Fee

4-2 WBS Cost Data

LABOR (Unburdened)

MATERIAL (Unburdened)

SUBCONTRACTS (Unburdened)

Indirect Costs

Fee

Other Costs Not Shown Elsewhere

FY18

FY19

Total

FY18

FY19

Total

FY18

FY19

Total

FY18

FY19

Total

FY18

FY19

Total

FY18

FY19

Total

Description

WBS

Hardware

1.1.1

Hardware

1.1.1

Software/Hosting

1.1.2

Integration, Assembly, Test, and Checkout

1.1.3

Project Management

2.1.2

Financial Management

2.1.3

Logistics Management

2.1.4

Contract Management

2.1.6

Travel

2.1.7

Studies & Design

2.2.1

Certification Authority

2.2.5

Systems Engineering Management

2.2.6

Configuration Management

2.2.8

Logistics Engineering

2.2.9

Cybersecurity Engineering

2.2.11

System DT&E

2.3.1

System OT&E

2.3.2

Security Testing

2.3.4

Systems Integration/Interoperability Testing

2.3.5

Technical Publications

2.5.1

Peculiar Support Equipment

2.7.1

Common Support Equipment

2.7.2

* Specify in proposal if Government FYs OR Contractor FYs are used.

4-3 WBS Labor Hours

		LABOR BY HOURS (Provide in Hours)
Description	WBS	Basis Of Estimate	FY18	FY19	FY19	FY19	FY19	Total
Hardware	1.1.1		Q4	Q1	Q2	Q3	Q4
Hardware	1.1.1
Software/Hosting	1.1.2
Integration, Assembly, Test, and Checkout	1.1.3
Project Management	2.1.2
Financial Management	2.1.3
Logistics Management	2.1.4
Contract Management	2.1.6
Travel	2.1.7
Studies & Design	2.2.1
Certification Authority	2.2.5
Systems Engineering Management	2.2.6
Configuration Management	2.2.8
Logistics Engineering	2.2.9
Cybersecurity Engineering	2.2.11
System DT&E	2.3.1
System OT&E	2.3.2
Security Testing	2.3.4
Systems Integration/Interoperability Testing	2.3.5
Technical Publications	2.5.1
Peculiar Support Equipment	2.7.1
Common Support Equipment	2.7.2
* Specify in proposal if Government FYs OR Contractor FYs are used.

4-4 Supporting Cost Data

SUPPORTING COST DATA - CONTRACTOR'S CURRENT DIRECT & INDIRECT RATES

Company Name:

DCAA Point of Contact Information:

Direct Labor:

Employee Name Labor Category (Actual Current Labor Rate/FPRA/FPRR) Proposed Labor Rate Add additional columns as required Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.

Ex: John Doe	Ex: Sr. Program Mgr	$	$	$
Ex: Jane Doe	Ex: Sr. Systems Engineer	$	$	$
Ex: New Employee 1	Ex: Jr. Junior Analyst	$	$	$
		$	$	$
		$	$	$

Indirect Rates:		Historical Year 1	Historical Year 2	Historical Year 3	Proposed Rate	Add additional columns as required	Reason for difference between historical indirect rates and proposed indirect rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Fringe
Overhead
G&A
Material and Handling
Other
Rate Period	Start Date	End Date
Historical Year 1:
Historical Year 2:
Historical Year 3:

4-5 Basis Of Estimate

Description	WBS	Basis of Estimate Narative	Recurring/ Non-Recurring	Cross-Reference Matrix
Hardware	1.1.1
Software/Hosting	1.1.2
Integration, Assembly, Test, and Checkout	1.1.3
Project Management	2.1.2
Financial Management	2.1.3
Logistics Management	2.1.4
Contract Management	2.1.6
Travel	2.1.7
Studies & Design	2.2.1
Certification Authority	2.2.5
Systems Engineering Management	2.2.6
Configuration Management	2.2.8
Logistics Engineering	2.2.9
Cybersecurity Engineering	2.2.11
System DT&E	2.3.1
System OT&E	2.3.2
Security Testing	2.3.4
Systems Integration/Interoperability Testing	2.3.5
Technical Publications	2.5.1
Support Equipment	2.7

4-7a Prime Eng. Services CL

COST SUMMARY FORMAT - PRIME CONTRACTOR

Prime Offeror Name:
DCAA Point of Contact Information:
					Period (Provide this information for Each CLIN 0004 Ordering Year)
Cost Elements	Labor Category	Category Level (Senior, Mid, Junior)	Actual Current Labor Rate/FPRA/ FPRR	Escalation Rate	Labor Rate	Hours	Amount	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Prime Contractor Labor Cost
Prime Contractor Direct Labor:
Labor Category 1
Labor Category 2
Etc.
Total Direct Labor Cost
Prime Contractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Prime Contractor Indirect Cost
Total Direct and Indirect Labor cost
COM (If Applicable)
Total Prime Contractor Labor Cost

Subcontractor Labor Cost

Subcontractor proposed cost and fee

Subcontractor 1

Subcontractor 2

Etc.

Total proposed subcontractor labor cost and fee

Prime contractor pass through (not including fee)

Handling

G&A

Other (if any)

Total pass through (not including fee)

Total Subcontractor Cost including pass through

Total Labor Cost (Prime and Subcontractor Labor)

Fixed Fee

Prime Contractor Fee for Prime Contractor Labor

Prime Contractor Fee for Subcontractor Labor

Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF)

4-7a Prime Total (cont)

COST SUMMARY FORMAT - PRIME CONTRACTOR

Prime Offeror Name:
DCAA Point of Contact Information:
			Total for CLIN 0004
Cost Elements	Labor Category	Category Level (Senior, Mid, Junior)	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor:
Labor Category 1
Labor Category 2
Etc.
Total Direct Labor Cost
Prime Contractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Prime Contractor Indirect Cost
Total Direct and Indirect Labor cost
COM (If Applicable)
Total Prime Contractor Labor Cost

Subcontractor Labor Cost

Subcontractor proposed cost and fee

Subcontractor 1

Subcontractor 2

Etc.

Total proposed subcontractor labor cost and fee

Prime contractor pass through (not including fee)

Handling

G&A

Other (if any)

Total pass through (not including fee)

Total Subcontractor Cost including pass through

Total Labor Cost (Prime and Subcontractor Labor)

Fixed Fee

Prime Contractor Fee for Prime Contractor Labor

Prime Contractor Fee for Subcontractor Labor

Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF)

4-7a Prime Supporting Cost

SUPPORTING COST DATA - PRIME CONTRACTOR'S CURRENT INDIRECT RATES

Company Name:

DCAA Point of Contact Information:

			Historical Rates
	Indirect Rates:		Historical Year 1	Historical Year 2	Historical Year 3	Proposed Rate
Ordering Year 2	Proposed Rate
Ordering Year 3	Proposed Rate
Ordering Year 4	Proposed Rate
Ordering Year 5	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
	Fringe
	Overhead
	G&A
	Material and Handling
	Other
	Rate Period	Start Date	End Date
	Historical Year 1:
	Historical Year 2:
	Historical Year 3:
	Ordering Year 2:
	Ordering Year 3:
	Ordering Year 4:
	Ordering Year 5:

4-7b Sub Eng. Services CLINs

COST SUMMARY FORMAT - SUBCONTRACTOR

Subcontractor Offeror Name:
DCAA Point of Contact Information:
					Period (Provide this information for Each CLIN 0004 Ordering Year)
Cost Elements	Labor Category	Category Level (Senior, Mid, Junior)	Actual Current Labor Rate/FPRA/ FPRR	Escalation Rate	Labor Rate	Hours	Amount	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Sub Contractor Labor Cost
Sub Contractor Direct Labor:
Labor Category 1
Labor Category 2
Etc.
Total Direct Labor Cost
Subcontractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Subcontractor Indirect Cost
Total Direct and Indirect Labor Cost
COM (If Applicable)
Total Subcontractor Labor Cost

Fixed Fee

Total Labor Cost Plus Fixed Fee (CPFF)

4-7b Subcontractor Total (Cont)

COST SUMMARY FORMAT - SUBCONTRACTOR

Subcontractor Name:
DCAA Point of Contact Information:
			Total for CLIN 0004
Cost Elements	Labor Category	Category Level (Senior, Mid, Junior)	Hours	Amount
Sub Contractor Labor Cost
Sub Contractor Direct Labor:
Labor Category 1
Labor Category 2
Etc.
Total Direct Labor Cost
Subcontractor Indirect Labor Costs:
Fringe Benefits
Subtotal
Overhead
Subtotal
G&A
Total Subcontractor Indirect Cost
Total Direct and Indirect Labor Cost
COM (If Applicable)
Total Subontractor Labor Cost

Fixed Fee

Total Labor Cost Plus Fixed Fee (CPFF)

4-7b Sub Supporting Cost

SUPPORTING COST DATA - SUBCONTRACTOR'S CURRENT DIRECT & INDIRECT RATES

Subcontractor Name:

DCAA Point of Contact Information:

			Historical Rates
	Indirect Rates:		Historical Year 1	Historical Year 2	Historical Year 3	Proposed Rate
Ordering Year 2	Proposed Rate
Ordering Year 3	Proposed Rate
Ordering Year 4	Proposed Rate
Ordering Year 5	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
	Fringe
	Overhead
	G&A
	Material and Handling
	Other
	Rate Period	Start Date	End Date
	Historical Year 1:
	Historical Year 2:
	Historical Year 3:
	Ordering Year 2:
	Ordering Year 3:
	Ordering Year 4:
	Ordering Year 5:

Sheet1

File details come from the government source that posted it.