Cost_Price_Template.xlsx

XLSX spreadsheet 71 KB Posted Mar 12, 2015

Attached to: RN Systems Engineering and Integration (RN SE&I) Federal contract opportunity
Solicitation number: 15-044
Issued by: Department of the Air Force Space Command Space and Missile Systems Center

About this file

From the source

Cost/Price Template

View the file

Other files for this federal contract opportunity

Other files attached to RN Systems Engineering and Integration (RN SE&I), newest first.
File	Type	Posted
Section_L_April_17_2015.pdf	PDF	Apr 17, 2015
Attachment_1_PWS_17_April_2015.pdf	PDF	Apr 17, 2015
Signed_Amendment_0003.pdf	PDF	Apr 17, 2015
Signed_Amendment_0002.pdf	PDF	Mar 30, 2015
Section_M.pdf	PDF	Mar 30, 2015
Amendment_0001_Signed.pdf	PDF	Mar 20, 2015
Amendment_0001.pdf	PDF	Mar 20, 2015
Section_L.pdf	PDF	Mar 20, 2015
Section_M.pdf	PDF	Mar 20, 2015
Attachment_1_-_PWS.pdf	PDF	Mar 20, 2015
RFP_Cover_Letter.pdf	PDF	Mar 12, 2015
A-K.pdf	PDF	Mar 12, 2015
Section_M.pdf	PDF	Mar 12, 2015
Section_L.pdf	PDF	Mar 12, 2015

Show all 14

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.

Instructions

Text in Red are example values

Please ensure you link all cells appropriately

Please ensure rounding is IAW RFP instructions, and are consistent with the Model contract values

All formulas shall be entered by the Offeror. Formulas entered in Red text are for instructional use only.

FAR 52.217-9 Option to Extend Services

The Offeror shall calculate the extension of services option by taking the last option’s total cost for CLINs 0501, 502 and 0504, and dividing that cost by two to derive one six-month option amount. The contract type associated with this option is cost-plus-fixed-fee for CLINs 0501 and 0502, and firm-fixed-price for CLIN 0504. For the CPFF efforts, the Offeror shall propose a fixed fee exclusive of Facilities Capital Cost of Money that does not exceed the statutory limitation of 10%.

Summary by CLIN Series

Table 6.2.3 - Cost Summary by Cost Series

	COST ELEMENT	0001	0101	0201	0301	0401	0501	TOTAL
Integration (CPIF)	Prime Hours
	Inter-divisional hours
	Subcontractor hours
	Total Hours
	Direct Labor ($)
	Overhead ($)
	Material ($)
	Subcontracts ($)
	Interdivisional ($)
	Other Direct Costs ($)
	Subtotal ($)
	Fringe ($)
	G&A ($)
	Estimated Cost ($)
	Facilities Capital Cost of Money ($)
	Fee ($)
	Total Price ($)

Systems Engineering (CPIF)	COST ELEMENT	0002	0102	0202	0302	0402	0502	TOTAL
	Prime Hours
	Inter-divisional hours
	Subcontractor hours
	Total Hours
	Direct Labor ($)
	Overhead ($)
	Material ($)
	Subcontracts ($)
	Interdivisional ($)
	Other Direct Costs ($)
	Subtotal ($)
	Fringe ($)
	G&A ($)
	Estimated Cost ($)
	Facilities Capital Cost of Money ($)
	Fee ($)
	Total Price ($)

Architecture Support and Information Protection Support (FFP)	COST ELEMENT	0004	0104	0204	0304	0404	0504	TOTAL
	Prime Hours
	Inter-divisional hours
	Subcontractor hours
	Total Hours
	Direct Labor ($)
	Overhead ($)
	Material ($)
	Subcontracts ($)
	Interdivisional ($)
	Other Direct Costs ($)
	Subtotal ($)
	Fringe ($)
	G&A ($)
	Estimated Cost ($)
	Facilities Capital Cost of Money ($)
	Profit ($)
	Total Price ($)

Special Studies (CPFF)	COST ELEMENT	0005	0105	0205	0305	0405	0505	TOTAL
	Prime Hours
	Inter-divisional hours
	Subcontractor hours
	Total Hours
	Direct Labor ($)
	Overhead ($)
	Material ($)
	Subcontracts ($)
	Interdivisional ($)
	Other Direct Costs ($)
	Subtotal ($)
	Fringe ($)
	G&A ($)
	Estimated Cost ($)
	Facilities Capital Cost of Money ($)
	Fee ($)
	Total Price ($)

Summary by WBS

Start Date End Date Start Date End Date Start Date End Date Start Date End Date Start Date End Date Start Date End Date FAR 52.217-9

		WBS/CES Description		Base year (CLIN 00XX)		Option 1 (CLIN 01XX)		Option 2 (CLIN 02XX)		Option 3 (CLIN 03XX)		Option 4 (CLIN 04XX)		Option 5 (CLIN 05XX)		6 Month Option
CLIN	WBS#	Level 1	Level 2	Costs	Hours	Costs	Hours	Costs	Hours	Costs	Hours	Costs	Hours	Costs	Hours	Costs	Hours
	SMC/RN SE&I Program Direct Labor Cost CPIF CLINs Total					$ 417,860										DO NOT ENTER DATA HERE
XX01	1.0	SE&I RN Integration				$ 417,860
CPIF	1.1		General Systems Integration		Example	$ 417,860	$ 10,000
	1.2		Out Year Plan
	1.3		Spend Plan
	1.4		Support Generation of RFP Documentation for Projects
	1.5		Facilitate RFP Activities
	1.6		Program Integrated Master Schedule
	1.7		Integrate Between RN Projects
	1.8		Support Reviews
	1.9		Evaluate Designs
	1.10		Test Support
	1.11		Anomaly Reporting
	1.12		Independent Verification and Validation (IV&V)
	1.13		Transition Support
	1.14		Turnover Support
	1.15		Program Management of SE&I RN Integration
CLIN
XX02	2.0	SE&I RN Systems Engineering Processes														DO NOT ENTER DATA HERE
CPIF	2.1		Manage SE Processes and Products
	2.2		Configuration Management (CM)
	2.3		Data Management (DM)
	2.4		Requirements Management (RM)
	2.5		Risk and Opportunities Management
	2.6		Test
	2.7		Security
	2.8		Information Assurance/Cybersecurity
	2.9		Safety
	2.10		Reliability, Maintainability, Availability (RMA)
	2.11		Total Life Cycle Analysis
	2.12		Systems Engineering Process Training
	2.13		Program Management of SE&I RN Systems Engineering Processes
CLIN
XX04	3.0	SE&I Architecture, LAAFB Security Support, and Certification and Accreditation (C&A) Support				$ 1,253,580	30000									DO NOT ENTER DATA HERE
FFP	3.1		FFP- RN Architecture Documents (PWS# 5.2.5.1)			$ 417,860	10000
	3.2		FFP-Transition/Assessment of existing As-Is Architecture (PWS# 5.2.5.2.1)
	3.3		FFP- Update/Implementation of As-Is Architecture (PWS# 5.2.5.2.2)
	3.4		FFP- To-Be and Future Projects for Architecture Definition Documents (ADDs) (PWS# 5.2.5.2.3.1)
	3.5		FFP- End-to-End Systems Requirements and Verification (PWS# 5.2.5.3.2)
	3.6		FFP- Impacts to Architecture (PWS# 5.2.5.4)
	3.7		FFP- Identify Effective and Efficient Architecture Analysis and Trades (PWS# 5.2.5.5.1)
	3.8		FFP- Assess and Present the As-Is, To-Be, and Future Technical Baselines (PWS# 5.2.5.5.6)
	3.9		FFP- LAAFB Security Support (PWS# 5.2.7.3)			$ 417,860	10000
	3.10		FFP- Manage Certification and Accreditation (C&A) Processes (PWS# 5.2.8.12)			$ 417,860	10000
	3.11		Program Management of SE&I Architecture, LAAFB Security Support, and Certification and Accreditation (C&A) Support
CLIN
XX05	4.0	SE&I RN Architecture Improvement Implementation, Future Planning, and Special Studies				$ 1,829,992	20000
CPFF	4.1		CPFF-Implement Architecture Baseline Changes (PWS#5.2.5.2.2.1)
	4.2		CPFF -Implement Improvements to ADDs (PWS# 5.2.5.2.3.2)
	4.3		CPFF- RN Operations and Employment Concepts Production and Management (PWS# 5.2.5.3.1)
	4.4		CPFF- Architectural Analysis and Trades Excursion (PWS # 5.2.5.5.2)
	4.5		CPFF- Architectural Analysis and Modification Assessments (PWS # 5.2.5.5.3)
	4.6		CPFF- Architectural Analysis and Trade Studies (PWS # 5.2.5.5.4)
	4.7		CPFF-Architecture Gap Analysis Report (PWS # 5.2.5.5.5)
	4.8		CPFF-Special Studies (PWS# 5.2.12)

Base year (CLIN 00XX)

Option 1 (CLIN 01XX)

Option 2 (CLIN 02XX)

Option 3(CLIN 03XX)

Option 4 (CLIN 04XX)

Option 5 (CLIN 05XX)

FAR 52.217-9 (6 Month Option)

Cost

Factor/Method

Cost

Factor/Method

Cost

Factor/Method

Cost

Factor/Method

Cost

Factor/Method

Cost

Factor/Method

Cost

Factor/Method

Includes CLINS XX01, XX02

SMC/RN SE&I Program Direct Labor Cost CPIF CLINs Total

$ 417,860

DO NOT ENTER DATA HERE

Overhead

$ 208,930

50%

Direct Labor + Overhead Subtotal

$ 626,790

Other Direct Costs (ODC)

$ 20,831

Travel

$ 831

Material/Other

$ 20,000

Subtotal with ODCs

$ 668,452

Fringe

$ 83,572

20%

General and Administrative (G&A)

$ 20,893

Facilities Capital Cost of Money (FCCOM)

$ 836

Total Costs

$ 773,753

$ - 0

	Fee	Fee		Fee	Fee	Fee	Fee	Fee
Fee Summary		$ 15,458
Incentive Fee		$ 15,458	2%
Fixed Fee								$ - 0

		Price	Price	Price	Price	Price	Price	Price
Includes CLIN XX04	SE&I RN Architecture Support Price		$ 1,253,580					$ - 0
Includes CLIN XX05	SE&I RN Architecture Improvement Implementation, Future Planning, and Special Studies		$ 1,949,711
								FAR 52.217-9 (6 Month Option)
	Total Price Per Year		$ 3,992,502					$ - 0

Enter "Rights In Data" total costs as detailed in Tables 1 and 2 of Attachment 5 $100,000

GFE-GFI $8,000

Total Price $ 4,100,502

Direct Labor by Year

Hours per Contract Period

Rates per Contract Period

Cost per Contract Period

WBS Number

WBS/CES Description

Base year

Option 1

Option 2

Option 3

Option 4

Option 5

Totals

Company Name

Base year

Option 1

Option 2

Option 3

Option 4

Option 5

Company Name

Base year

Option 1

Option 2

Option 3

Option 4

Option 5

Company Name

SMC/RN SE&I Program Total

40,000.00

$ 1,671,440.00

1.0

SE&I RN Integration

10,000.00

$ 417,860.00

1.1

General Systems Integration

10000

$ 417,860.00

Labor Category (Insert Offeror Specific label)

Example

6000

KTR A

Example

$ 42.13

KTR A

Example

$ 252,780.00

KTR A

Labor Category (Insert Offeror Specific label)

4000

KTR B

$ 41.27

KTR B

$ 165,080.00

KTR B

Additional Space

Units in Dollars per hours

1.2

Out Year Plan

Labor Category (Insert Offeror Specific label)

Additional Space

1.3

Spend Plan

Labor Category (Insert Offeror Specific label)

Additional Space

1.4

Support Generation of RFP Documentation for Projects

Labor Category (Insert Offeror Specific label)

Additional Space

1.5

Facilitate RFP Activities

Labor Category (Insert Offeror Specific label)

Additional Space

1.6

Program Integrated Master Schedule

Labor Category (Insert Offeror Specific label)

Additional Space

1.7

Integrate Between RN Projects

Labor Category (Insert Offeror Specific label)

Additional Space

1.8

Support Reviews

Labor Category (Insert Offeror Specific label)

Additional Space

1.9

Evaluate Designs

Labor Category (Insert Offeror Specific label)

Additional Space

1.10

Test Support

Labor Category (Insert Offeror Specific label)

Additional Space

1.11

Anomaly Reporting

Labor Category (Insert Offeror Specific label)

Additional Space

1.12

Independent Verification and Validation (IV&V)

Labor Category (Insert Offeror Specific label)

Additional Space

1.13

Transition Support

Labor Category (Insert Offeror Specific label)

Additional Space

1.14

Turnover Support

Labor Category (Insert Offeror Specific label)

Additional Space

1.15

Program Management of SE&I RN Integration

Labor Category (Insert Offeror Specific label)

Additional Space

2.0	SE&I RN Systems Engineering Processes
2.1		Manage SE Processes and Products
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.2		Configuration Management (CM)
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.3		Data Management (DM)
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.4		Requirements Management (RM)
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.5		Risk and Opportunities Management
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.6		Test
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.7		Security
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.8		Information Assurance/Cybersecurity
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.9		Safety
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.10		Reliability, Maintainability, Availability (RMA)
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.11		Total Life Cycle Analysis
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.12		Systems Engineering Process Training
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space
2.13		Program Management of SE&I RN Systems Engineering Processes
			Labor Category (Insert Offeror Specific label)
			Labor Category (Insert Offeror Specific label)
			Additional Space

3.0

SE&I Architecture, LAAFB Security Support, and Certification and Accreditation (C&A) Support

30000

$ 1,253,580.00

3.1

FFP- RN Architecture Documents (PWS# 5.2.5.1)

10000

$ 417,860.00

Labor Category (Insert Offeror Specific label)

Example

6000

KTR A (Prime)

Example

$ 42.13

KTR A (Prime)

Example

$ 252,780.00

KTR A (Prime)

Labor Category (Insert Offeror Specific label)

4000

KTR B (Subcontractor)

$ 41.27

KTR B (Subcontractor)

$ 165,080.00

KTR B (Subcontractor)

Additional Space

Units in Dollars per hours

3.2

FFP-Transition/Assessment of existing As-Is Architecture (PWS# 5.2.5.2.1)

Labor Category (Insert Offeror Specific label)

Additional Space

3.3

FFP- Update/Implementation of As-Is Architecture (PWS# 5.2.5.2.2)

Labor Category (Insert Offeror Specific label)

Additional Space

3.4

FFP- To-Be and Future Projects for Architecture Definition Documents (ADDs) (PWS# 5.2.5.2.3.1)

Labor Category (Insert Offeror Specific label)

Additional Space

3.5

FFP- End-to-End Systems Requirements and Verification (PWS# 5.2.5.3.2)

Labor Category (Insert Offeror Specific label)

Additional Space

3.6

FFP- Impacts to Architecture (PWS# 5.2.5.4)

Labor Category (Insert Offeror Specific label)

Additional Space

3.7

FFP- Identify Effective and Efficient Architecture Analysis and Trades (PWS# 5.2.5.5.1)

Labor Category (Insert Offeror Specific label)

Additional Space

3.8

FFP- Assess and Present the As-Is, To-Be, and Future Technical Baselines (PWS# 5.2.5.5.6)

Labor Category (Insert Offeror Specific label)

Additional Space

3.9

FFP- LAAFB Security Support (PWS# 5.2.7.3)

10000

$ 417,860.00

Labor Category (Insert Offeror Specific label)

Example

6000

KTR A (Prime)

Example

$ 42.13

KTR A (Prime)

Example

$ 252,780.00

KTR A (Prime)

Labor Category (Insert Offeror Specific label)

4000

KTR B (Subcontractor)

$ 41.27

KTR B (Subcontractor)

$ 165,080.00

KTR B (Subcontractor)

Additional Space

Units in Dollars per hours

3.10

FFP- Manage Certification and Accreditation (C&A) Processes (PWS# 5.2.8.12)

10000

$ 417,860.00

Labor Category (Insert Offeror Specific label)

Example

6000

KTR A (Prime)

Example

$ 42.13

KTR A (Prime)

Example

$ 252,780.00

KTR A (Prime)

Labor Category (Insert Offeror Specific label)

4000

KTR B (Subcontractor)

$ 41.27

KTR B (Subcontractor)

$ 165,080.00

KTR B (Subcontractor)

Additional Space

3.11

Program Management of SE&I Architecture, LAAFB Security Support, and Certification and Accreditation (C&A) Support

Labor Category (Insert Offeror Specific label)

Additional Space

Units in Dollars per hours

Other Direct Costs

	Totals
Other Direct Costs (ODC)	$ 20,831.00
Travel	$ 831.00
Material/Other	$ 20,000.00

Travel

Base year

Totals

$ - 0

From:

To:

# of Trips

# of People

# of Days

Airfare

Lodging

Per diem

Car Rental

Total Airfare

Total Lodging

Total Per diem

Total Car Rental

Total Amount

Material/Other QTY Unit Price Extended Price Total Amount

Travel	Option 1	Totals	$ 20,831.00
From:	To:	# of Trips	# of People	# of Days	Airfare	Lodging	Per diem	Car Rental	Total Airfare	Total Lodging	Total Per diem	Total Car Rental	Total Amount
LA	CO	1	1	1	$ 600	$ 100	$ 71	$ 60	$ 600	$ 100	$ 71	$ 60	$ 831

Material/Other	QTY	Unit Price	Extended Price	Total Amount
Software License (Yearly Subscription)	2	$ 10,000	$ 20,000	$ 20,000

Travel

Option 2

Totals

$ - 0

From:

To:

# of Trips

# of People

# of Days

Airfare

Lodging

Per diem

Car Rental

Total Airfare

Total Lodging

Total Per diem

Total Car Rental

Total Amount

Material/Other QTY Unit Price Extended Price Total Amount

Travel

Option 3

Totals

$ - 0

From:

To:

# of Trips

# of People

# of Days

Airfare

Lodging

Per diem

Car Rental

Total Airfare

Total Lodging

Total Per diem

Total Car Rental

Total Amount

Material/Other QTY Unit Price Extended Price Total Amount

Travel

Option 4

Totals

$ - 0

From:

To:

# of Trips

# of People

# of Days

Airfare

Lodging

Per diem

Car Rental

Total Airfare

Total Lodging

Total Per diem

Total Car Rental

Total Amount

Material/Other QTY Unit Price Extended Price Total Amount

Travel

Option 5

Totals

$ - 0

From:

To:

# of Trips

# of People

# of Days

Airfare

Lodging

Per diem

Car Rental

Total Airfare

Total Lodging

Total Per diem

Total Car Rental

Total Amount

Material/Other QTY Unit Price Extended Price Total Amount

CLIN XX05

Special Studies

Inflation used		2.5%	2.5%	2.5%	2.5%	2.5%
Contract Period	Base Year	Option 1	Option 2	Option 3	Option 4	Option 5
Fully Burdened Composite Labor Rate	$ 89.27	$ 91.50	$ 93.79	$ 96.13	$ 98.54	$ 101.00
Hours per year	20,000	20,000	20,000	20,000	20,000	20,000
Yearly Total	$ 1,785,358	$ 1,829,992	$ 1,875,742	$ 1,922,635	$ 1,970,701	$ 2,019,969

Fixed Fee Proposed (%)	7%
Fixed Fee Proposed ($)	$116,799	$119,719	$122,712	$125,780	$128,924	$132,147

Basis of Estimate for Base year rate
Labor Categories	Hours	Direct Rate	Total Direct Labor	Overhead/Fringe/G&A	ODCs\Travel	FCCOM	Fixed Fee	Extended Rate	Extended Price
Labor Category (Insert Offeror Specific label)	25	$ 35.22	$ 880.50	$ 660	$ 500	$ 2	$ 143	$ 87	$ 2,185
Labor Category (Insert Offeror Specific label)	15	$ 30.20	$ 453.00	$ 340	$ 501	$ 1	$ 91	$ 92	$ 1,385
Labor Category (Insert Offeror Specific label)
Labor Category (Insert Offeror Specific label)
Labor Category (Insert Offeror Specific label)
Labor Category (Insert Offeror Specific label)
Labor Category (Insert Offeror Specific label)
Labor Category (Insert Offeror Specific label)
Additional Space if Necessary
	40							$ 89.27	$ 3,571

Efficiency Matrix

Table 9 Sample Efficiency Matrix

Volume II Technical				Volume III Cost/Price			Page Ref.	Likelihood
Factor	Subfactor	Proposal Requirement	Efficiency Implementation	WBS and CLIN Number	Cost, Hours, and Benefits	Schedule Benefits		0% or 100%
T2	3-Program Management	Transition Plan	As stated in the technical volume page 13 paragraph 5 the team will use a cross organizational approach as we transfer information from knowledge managers and process owners. We will set up a KM system that will provide access to past work in a living document format, which will allow for uninterrupted service and little to no oversight by the Government. See Proposal Volume II, Attachment T4, paragraphs 1.5-1.9 for additional justification.	1.15 - CLIN 1501	$200,000, 1960 hours, Reduction of 4 Engineers (490 hours per person).	Potential Schedule savings of 4 weeks to allotted 6 month transition.		For Government Use

GFE-GFI

Table 1: Government Furnished Equipment/Information
Item No.	ITEM DESCRIPTION	QTY	UNIT PRICE	TOTAL PRICE	LOCATION	DATE FURNISHED TO CONTRACTOR	PERIOD AVAILABLE	ISSUED BY
1	Example: Computer workstation and accessories	2	$ 4,000	$ 8,000	El Segundo, CA	TBD	TBD (if all options exercised)	SMC/RN

Total Price $ 8,000

Rate Table

	Base year	Option 1	Option 2	Option 3	Option 4	Option 5
Direct labor
Labor Category (Insert Offeror Specific label)

Indirect Rates
Overhead	50.00%
Fringe	20.00%
G&A	5.00%
Facilities Capital Cost of Money	0.20%
Target Fee	2.00%
Fixed Fee	7.00%

	6 Month Option
52.217-9 Option to extend services (Fixed Fee)	8%

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