Cost_Format_Worksheets__Template_DLE_14_June.xlsx

XLSX spreadsheet 126 KB Posted Jul 13, 2017

Attached to: Data Link Enterprise (DLE) Federal contract opportunity
Solicitation number: FA8726-17-R-0004
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hanscom Air Force Base

About this file

From the source

Amended Cost Format Worksheets

View the file

Other files for this federal contract opportunity

Other files attached to Data Link Enterprise (DLE), newest first.
File	Type	Posted
NOTICE_TO_CONTRACTORS_Page_Count_Clarification_20170726.docx	DOCX document	Jul 26, 2017
NOTICE_TO_CONTRACTORS_(Final_Question).docx	DOCX document	Jul 24, 2017
Final_DLE_Questions.docx	DOCX document	Jul 18, 2017
NOTICE_TO_CONTRACTORS__(Post__Amendment_Questions)__13_July_17.docx	DOCX document	Jul 13, 2017
39618_Amended_RFP_FA8726-17-R-0004_0001.pdf	PDF	Jul 13, 2017
RPF_Amendment_Letter.pdf	PDF	Jul 13, 2017
Amended_38686_FA8726-17-F-0009.pdf	PDF	Jul 13, 2017
NOTICE_TO_CONTRACTORS_(Responses_and_Questions)_07102017.docx	DOCX document	Jul 13, 2017
NOTICE_TO_CONTRACTORS-_Amendment_RFP_and_Past_Performance_Date_Change.docx	DOCX document	Jul 7, 2017
NOTICE_TO_CONTRACTORS-_Amendment_RFP.docx	DOCX document	Jun 27, 2017
IDIQ_Cross_Ref_Matrix.xlsx	XLSX spreadsheet	Jun 14, 2017
Cost_Format_Worksheets__DLE_6_June.xlsx	XLSX spreadsheet	Jun 6, 2017
38684_FA8726-17-F-0008.pdf	PDF	Jun 6, 2017
NOCA_DLE-_POST_RFP.docx	DOCX document	Jun 6, 2017
36028_FA8726-17-R-0004.pdf	PDF	Jun 6, 2017
RFP_Letter-_Signed.pdf	PDF	Jun 6, 2017
38686_FA8726-17-F-0009.pdf	PDF	Jun 6, 2017
NOTICE_TO_CONTRACTORS_(Responses_and_Questions).docx	DOCX document	May 11, 2017
NOCA_DLE.docx	DOCX document	May 9, 2017
DLE_IDIQ_Section_L__4-25-2017.docx	DOCX document	Apr 25, 2017
DLE_IDIQ_-_Section_M_4-25-2017.docx	DOCX document	Apr 25, 2017
NOTICE_TO_CONTRACTORS_(release_L&M)_25_April_2017.docx	DOCX document	Apr 25, 2017
Remove_L&M-_NOTICE_TO_CONTRACTORS.docx	DOCX document	Mar 30, 2017
DLE_IDIQ_-_Section_M_Rev22__3-27-2017.docx	DOCX document	Mar 29, 2017
DLE_IDIQ_-_Section_L_Rev22__3-27-2017.docx	DOCX document	Mar 29, 2017
RFP_-_NOTICE_TO_OFFERORS.docx	DOCX document	Mar 24, 2017
NOTICE_TO_CONTRACTORS-_Responses_to_DO2_-_SOW_Questions.docx	DOCX document	Mar 22, 2017
NOTICE_TO_CONTRACTORS_DRAFT_SOW_Deadline.docx	DOCX document	Feb 8, 2017
DLE_Disclaimer_Form.docx	DOCX document	Jan 26, 2017
NOTICE_TO_CONTRACTORS-_DO2-_SOW_release.docx	DOCX document	Jan 26, 2017
OCI_Announcement.docx	DOCX document	Nov 7, 2016

Show all 31

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.

Cost Price Summary

COST PRICE SUMMARY
Table 1: CLIN Summary
CLIN	Contract Type	CLIN Description	Estimated Cost	Fixed Fee/Profit	Total Price

D.O. 0001
0001	FFP	Post Award Conference		$ 5,000
		Subtotal		$ 5,000
D.O. 0002
0005AA	CPFF	High Capactiy Backbone Demo		$ -
0005AB	CPFF	High Capactiy Backbone Demo Option (Alpine Demo)		$ -
0009	CR	Travel	$ 83,400	$ 83,400
0010	CR	Other Direct Costs (ODC)	$ 24,000	$ 24,000
		Subtotal		$ 107,400

	Total Delivery Order		$ 112,400
Table 2: Sample Problem
	Description	Total
	Sample Problem	$ - 0

Cost Element Summary

COST ELEMENT SUMMARY BY CLIN
	CLIN	CLIN	CLIN	CLIN	CLIN
	0001	0005AA	0005AB	0009	0010
	FFP	CPFF	CPFF	CR	CR
Cost Element

Materials
	Material Category A
	Material Category B
	Material Category C
		Subtotal

Major Subcontracts/IDTs
	Subcontractor A
	Subcontractor B
	Subcontractor C
		Subtotal

Labor Costs
	Labor Category A
	Labor Category B
	Labor Category C
		Subtotal

Indirect Costs
	Indirect A
	Indirect B
	Indirect C
		Subtotal

Travel $ 83,400

ODC $ 24,000

G&A

Subtotal Cost

FCCOM
	FCCOM A
	FCCOM B
	FCCOM C
		Subtotal

Total Estimated Cost $ 83,400 $ 24,000

Fixed Fee

Total Delivery Order $ 5,000 $ 83,400 $ 24,000

CLIN 0005AA CPFF

COST ELEMENT SUMMARY BY CLIN
	CFY 17*	CFY 18*	Total CLIN 0005AA

	CLIN 0005AA
Cost Element		Base	Rate	Total	Base	Rate	Total	Base	Total

Materials
	Material Category A		$ - 0	$ - 0	$ - 0
	Material Category B		$ - 0	$ - 0	$ - 0
	Material Category C		$ - 0	$ - 0	$ - 0
		Total Materials	$ - 0	$ - 0	$ - 0

Major Subcontracts/IDT
	Major Subcontractor/IDT A		$ - 0	$ - 0	$ - 0
	Major Subcontractor/IDT B		$ - 0	$ - 0	$ - 0
	Major Subcontractor/IDT C		$ - 0	$ - 0	$ - 0
		Total Major Subcontracts/IDT	$ - 0	$ - 0	$ - 0

Labor Costs
	Labor Category A		$ - 0	$ - 0	$ - 0
	Labor Category B		$ - 0	$ - 0	$ - 0
	Labor Category C		$ - 0	$ - 0	$ - 0
		Total Labor Costs	$ - 0	$ - 0	$ - 0

Indirect Costs
	Indirect A		$ - 0	$ - 0	$ - 0
	Inidrect B		$ - 0	$ - 0	$ - 0
	Indirect C		$ - 0	$ - 0	$ - 0
		Total Indirects	$ - 0	$ - 0	$ - 0

G&A - 0 $ - 0 - 0 $ - 0 $ - 0

Subtotal Cost $ - 0 $ - 0 $ - 0

FCCOM
	FCCOM A		$ - 0	$ - 0	$ - 0
	FCCOM B		$ - 0	$ - 0	$ - 0
	FCCOM C		$ - 0	$ - 0	$ - 0
		Total FCCOM	$ - 0	$ - 0	$ - 0

Total Estimated Cost $ - 0 $ - 0 $ - 0

Fixed Fee $ - 0 $ - 0 $ - 0

TOTAL PRICE $ - 0 $ - 0 $ - 0

*Contractor Fiscal Year - Please identify your Contractor Fiscal Year

CLIN 0005AB CPFF

COST ELEMENT SUMMARY BY CLIN
	CFY 17*	CFY 18*	Total CLIN 0005AB

	CLIN 0005AB
Cost Element		Base	Rate	Total	Base	Rate	Total	Base	Total

Materials
	Material Category A		$ - 0	$ - 0	$ - 0
	Material Category B		$ - 0	$ - 0	$ - 0
	Material Category C		$ - 0	$ - 0	$ - 0
		Total Materials	$ - 0	$ - 0	$ - 0

Major Subcontracts/IDT
	Major Subcontractor/IDT A		$ - 0	$ - 0	$ - 0
	Major Subcontractor/IDT B		$ - 0	$ - 0	$ - 0
	Major Subcontractor/IDT C		$ - 0	$ - 0	$ - 0
		Total Major Subcontracts/IDT	$ - 0	$ - 0	$ - 0

Labor Costs
	Labor Category A		$ - 0	$ - 0	$ - 0
	Labor Category B		$ - 0	$ - 0	$ - 0
	Labor Category C		$ - 0	$ - 0	$ - 0
		Total Labor Costs	$ - 0	$ - 0	$ - 0

Indirect Costs
	Indirect A		$ - 0	$ - 0	$ - 0
	Inidrect B		$ - 0	$ - 0	$ - 0
	Indirect C		$ - 0	$ - 0	$ - 0
		Total Indirects	$ - 0	$ - 0	$ - 0

G&A - 0 $ - 0 - 0 $ - 0 $ - 0

Subtotal Cost $ - 0 $ - 0 $ - 0

FCCOM
	FCCOM A		$ - 0	$ - 0	$ - 0
	FCCOM B		$ - 0	$ - 0	$ - 0
	FCCOM C		$ - 0	$ - 0	$ - 0
		Total FCCOM	$ - 0	$ - 0	$ - 0

Total Estimated Cost $ - 0 $ - 0 $ - 0

Fixed Fee $ - 0 $ - 0 $ - 0

TOTAL PRICE $ - 0 $ - 0 $ - 0

*Contractor Fiscal Year - Please identify your Contractor Fiscal Year

Sample Problem

Labor Category	Labor Descriptions	BEQ	Rate	Total Extended Price
Harware Engineer (Journeyman)	Possesses and applies expertise on multiple complex work assignments. Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks. Operates with appreciable latitude in developing methodology and presenting solutions to problems. Contributes to deliverables and performance metrics where applicable. (a) Provides analysis related to the design, development, and implementation of hardware for products.

(b) Develops test strategies, devices, and systems.

(c) Performs stress and performance tests on a variety of computer hardware including circuit boards, processors and wiring.

500	$ - 0	$ - 0
Voice/Data Communications Engineer (Senior)	Possesses and applies a comprehensive knowledge across key tasks and high impact assignments. Plans and leads major technology assignments. Evaluates performance results and recommends major changes affecting short-term project growth and success. Functions as a technical expert across multiple project assignments. May supervise others. (a) Provides technical direction and engineering knowledge for communications activities including planning, designing, developing, testing, installing and maintaining large communications networks.

(b) Ensures that adequate and appropriate planning is provided to direct building architects and planners in building communications spaces and media pathways meet industry standards.

1,000	$ - 0	$ - 0
Subject Matter Expert (System Engineer)	(a) Provides analysis related to the design, development, and integration of hardware, software, man-machine interfaces and all system level requirements to provide an integrated IT solution.

(b) Develops integrated system test requirement, strategies, devices and systems.

(d) Serves as subject matter expert, possessing in-depth knowledge of a particular area, such as business, computer science, engineering, mathematics, or the various sciences.

(e) Provides technical knowledge and analysis of highly specialized applications and operational environments, high-level functional systems analysis, design, integration, documentation and implementation advice on exceptionally complex problems that need extensive knowledge of the subject matter for effective implementation.

(f) Participates as needed in all phases of software development with emphasis on the planning, analysis, testing, integration, documentation, and presentation phases.

(g) Applies principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions.

500	$ - 0	$ - 0
	Total Sample Problem		$ - 0

BOM

CFY17
WBS	Type	Description	Part Number	Vendor	Basis for Selection	Subcontract Type	Source of Unit Price	Decrement Factor	Unit Price	Quantity	Total Price
CFY18
WBS	Type	Description	Part Number	Vendor	Basis for Selection	Subcontract Type	Source of Unit Price	Decrement Factor	Unit Price	Quantity	Total Price

Labor Hours

LABOR HOURS - TOTAL CPFF
	CFY 17	CFY 18
	*Identify CFY Start	*Identify CFY Start
	*Identify CFY End	*Identify CFY End
Prime Labor Categories
Labor Category A
Labor Category B
Labor Category C
Subtotal

Rates Rates by Contractor Fiscal Year

Prime Contractor Rates
	CFY 17	CFY 18	CFY 19	CFY 20	CFY 21
Prime Contractor Labor Rates
Labor Category A
Labor Category B
Labor Category C

Prime Contractor Indirect Rates

Indirect A

Indirect B

Indirect C

G&A

FCCOM

FCCOM A

FCCOM B

FCCOM C

Fee

Fixed Fee

GFY Summary

CLIN	GFY16	GFY17	GFY 18	Total
0005AA				$ - 0
0005AB				$ - 0

Total Deilvery Order $ - 0

Price Track

PRICE TRACK ($)

Description	INITIAL PROPOSAL PRICE	Total Changes	FPR PRICE
CLIN 0005AA
CLIN 0005AB

TOTAL Delivery Order

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