Attachment_7_-_DIB_Development_5th_Edition_-Cost_Format_-Final.xlsx

XLSX spreadsheet 67 KB Posted Sep 22, 2017

Attached to: DIB Development 5th Edition FINAL RFP FA873017R0024
Solicitation number: FA873017R0024
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hanscom Air Force Base

About this file

From the source

Correct version of Attachment 7 - DIB Development 5th Edition - Cost Format

View the file

Other files

File	Type	Posted
Attachment_5-_DIB_Development_5th_Edition_-_Section_L_-Final.pdf	PDF	Sep 28, 2017
DIB_RFP_Questions_and_Answers_27_Sept_17.xlsx	XLSX spreadsheet	Sep 28, 2017
Model_Contract-_DIB_Development_5th_Edition_-_FA8730-17-R-0024_Final.pdf	PDF	Sep 28, 2017
Attachment_3_-_DIB_Development_5th_Edition_-Labor_Category_Descriptions-Final.pdf	PDF	Sep 22, 2017
Attachment_5_-_DIB_Development_5th_Edition_-_Section_L_-Final.pdf	PDF	Sep 22, 2017
Attachment_4_-_DIB_Development_5th_Edition_-DD_Form_254-Final.pdf	PDF	Sep 20, 2017
Model_Contract-_DIB_Development_5th_Edition_-FA8730-17-R-0024.pdf	PDF	Sep 20, 2017
Attachment_3_-_DIB_Development_5th_Edition_-Labor_Category_Descriptions-Final.pdf	PDF	Sep 20, 2017
20170920_DIB_Development_5th_Edition_RFP_Cover_Letter.pdf	PDF	Sep 20, 2017
Reference_-_DIB_Development_5th_Edition-_High_Level_Roadmap_-_Subject_to_Change.pdf	PDF	Sep 20, 2017
Attachment_6_-_DIB_Development_5th_Edition_-_Section_M_-_Final.pdf	PDF	Sep 20, 2017
Attachment_1-_DIB_Development_5th_Edition_-_SOW-_Final.pdf	PDF	Sep 20, 2017
Attachment_5_-_DIB_Development_5th_Edition_-_Section_L_-Final.pdf	PDF	Sep 20, 2017
Attachment_2_-DIB_Development_5th_Edition_-TRN_Instructions-Final.pdf	PDF	Sep 20, 2017
EXHIBIT_A_-DIB_Development_5th_Edition_-CDRLs-_Final.pdf	PDF	Sep 20, 2017
Attachment_7_-_DIB_Development_5th_Edition_Section_L_Cost_Format_-Final.pdf	PDF	Sep 20, 2017

Show all 16

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.

Cover Page

Table of Contents

Cost Format	Section L #
Summary	5.3.4.1
B-Table	5.3.4.2
Delivery Order 01- Initial TRN	5.3.4.3
Sample Epic	5.3.4.4
LH Rates at BEQ	5.3.4.5
Price Track	5.3.4.6

&"Times New Roman,Bold"&18&UTable of Contents

Summary

Table 1- Delivery Order 01- Initial TRN
	Contract
CLIN	Type	Description	Total Price
0001	LH	DMO Labor	$ - 0
0002	NSP	DMO Data
0003	CR	DMO Other Direct Costs	$ 5,000
0004	CR	DMO Travel	$ 5,000
		Total Table 1	$ 10,000

Table 2- CR CLINs
CLIN	Type	Description	Total Price
0003	CR	DMO Other Direct Costs	$ 100,000
0004	CR	DMO Travel	$ 100,000
0006	CR	DCGS AF Other Direct Costs	$ 100,000
0007	CR	DCGS AF Travel	$ 100,000
0009	CR	DCGS ARMY Other Direct Costs	$ 100,000
0010	CR	DCGS ARMY Travel	$ 100,000
0012	CR	DCGS NAVY Other Direct Costs	$ 100,000
0013	CR	DCGS NAVY Travel	$ 100,000
0015	CR	DCGS USMC Other Direct Costs	$ 100,000
0016	CR	DCGS USMC Travel	$ 100,000
0018	CR	DCGS SOCOM Other Direct Costs	$ 100,000
0019	CR	DCGS SOCOM Travel	$ 100,000
0021	CR	DCGS NGA Other Direct Costs	$ 100,000
0022	CR	DCGS NGA Travel	$ 100,000
0024	CR	DCGS INTEL COMMUNITY Other Direct Costs	$ 100,000
0025	CR	DCGS INTEL COMMUNITY Travel	$ 100,000
		Total Table 2	$ 1,620,000

Table 3- Sample Epic*
	Type	Description	Total Price
	LH	Sample Epic	$ - 0
		Total Table 3	$ - 0
*Table 2 - Sample Epic will not be included as part of the Total Evaluated Price

Table 4 - LH Rates at BEQ
	Type	Description	TEP
	LH	CY1	ERROR:#DIV/0!
	LH	CY2	ERROR:#DIV/0!
	LH	CY3	ERROR:#DIV/0!
	LH	CY4	ERROR:#DIV/0!
	LH	CY5	ERROR:#DIV/0!
		Total Table 4	ERROR:#DIV/0!

B-Table

Labor Hour
B-Table for CLINs 0001, 0005, 0008, 0011, 0014, 0017, 0020 and 0023
Prime Contractor
		DO 01 - Initial TRN	CY1	CY2	CY3	CY4	CY5
		1 February 2018 - 16 March 2018	17 March 2018-16 March 2019	17 March 2019-16 March 2020	17 March 2020-16 March 2021	17 March 2021-16 March 2022	17 March 2022-31 January 2023
	Labor Category
	Engineer Level 6 – E6
	Engineer Level 5 – E5
	Engineer Level 4 – E4
	Engineer Level 3 – E3
	Engineer Level 2 – E2
	Engineer Level 1 – E1
	Technician Level 5 – T5
	Technician Level 4 – T4
	Technician Level 3 – T3
	Technician Level 2 – T2
	Technician Level 1 – T1
	Program Manager
	General Administration

Subcontractor A
		DO 01 - Initial TRN	CY1	CY2	CY3	CY4	CY5
		1 February 2018 - 16 March 2018	17 March 2018-16 March 2019	17 March 2019-16 March 2020	17 March 2020-16 March 2021	17 March 2021-16 March 2022	17 March 2022-31 January 2023
	Labor Category
	Engineer Level 6 – E6
	Engineer Level 5 – E5
	Engineer Level 4 – E4
	Engineer Level 3 – E3
	Engineer Level 2 – E2
	Engineer Level 1 – E1
	Technician Level 5 – T5
	Technician Level 4 – T4
	Technician Level 3 – T3
	Technician Level 2 – T2
	Technician Level 1 – T1
	Program Manager
	General Administration
IDT A
		DO 01 - Initial TRN	CY1	CY2	CY3	CY4	CY5
		1 February 2018 - 16 March 2018	17 March 2018-16 March 2019	17 March 2019-16 March 2020	17 March 2020-16 March 2021	17 March 2021-16 March 2022	17 March 2022-31 January 2023
	Labor Category
	Engineer Level 6 – E6
	Engineer Level 5 – E5
	Engineer Level 4 – E4
	Engineer Level 3 – E3
	Engineer Level 2 – E2
	Engineer Level 1 – E1
	Technician Level 5 – T5
	Technician Level 4 – T4
	Technician Level 3 – T3
	Technician Level 2 – T2
	Technician Level 1 – T1
	Program Manager
	General Administration
*The Prime Contractor, Subcontractor, and IDT B-Tables will be incorporated in to the contract at time of award.

Delivery Order 01-Initial TRN Delivery Order 01 (Initial TRN)

	Delivery Order 01 -Initial TRN
	CLIN 0001
	1 February 2018- 16 March 2018
	Prime Contractor			Subcontractor A			IDT A			Total Price
Labor Category	Wrap Rate	Hours	Total Price	Wrap Rate	Hours	Total Price	Wrap Rate	Hours	Total Price
Engineer Level 6 – E6	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineer Level 5 – E5	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineer Level 4 – E4	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineer Level 3 – E3	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineer Level 2 – E2	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineer Level 1 – E1	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 5 – T5	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 4 – T4	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 3 – T3	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 2 – T2	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 1 – T1	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Program Manager	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
General Administration	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Total CLIN 0001			$ - 0			$ - 0			$ - 0	$ - 0

Sample Epic Sample Epic

	Sample Epic
					17 March 2018 - 16 March 2019
	Prime Contractor			Subcontractor A			IDT A			Total Price
Labor Category	Wrap Rate	Hours	Total Price	Wrap Rate	Hours	Total Price	Wrap Rate	Hours	Total Price
Engineering Level 6 – E6	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineering Level 5 – E5	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineering Level 4 – E4	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineering Level 3 – E3	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineering Level 2 – E2	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Engineering Level 1 – E1	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 5 – T5	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 4 – T4	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 3 – T3	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 2 – T2	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Technician Level 1 – T1	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Program Manager	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
General Administration	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0
Total Sample Epic			$ - 0			$ - 0			$ - 0	$ - 0

LH Rates at BEQ Labor Hour Rates at BEQ

	CY1												CY2												CY3												CY4												CY5
	17 March 2018-16 March 2019												17 March 2019 -16 March 2020												17 March 2020 - 16 March 2021												17 March 2021 - 16 March 2022												17 March 2022 - 31 January 2023
	Prime Contractor			Subcontractor A			IDT A			Total Price	# Rates Proposed	TEP	Prime Contractor			Subcontractor A			IDT A			Total Price	# Rates Proposed	TEP	Prime Contractor			Subcontractor A			IDT A			Total Price	# Rates Proposed	TEP	Prime Contractor			Subcontractor A			IDT A			Total Price	# Rates Proposed	TEP	Prime Contractor
Labor Category	Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension				Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension				Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension				Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension	Wrap Rate	BEQ	BEQ Extension				Wrap Rate
Engineering Level 6 – E6	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	1,008	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Engineering Level 5 – E5	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	2,081	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Engineering Level 4 – E4	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	1,163	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Engineering Level 3 – E3	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	1,160	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Engineering Level 2 – E2	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	3,076	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Engineering Level 1 – E1	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	1,730	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Technician Level 5 – T5	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Technician Level 4 – T4	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	194	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Technician Level 3 – T3	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	405	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Technician Level 2 – T2	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Technician Level 1 – T1	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	20	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Program Manager	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	702	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
General Administration	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	70	$ - 0	$ - 0	- 0	ERROR:#DIV/0!	$ - 0
Total Price @ BEQ			$ - 0			$ - 0			$ - 0	$ - 0		ERROR:#DIV/0!			$ - 0			$ - 0			$ - 0	$ - 0		ERROR:#DIV/0!			$ - 0			$ - 0			$ - 0	$ - 0		ERROR:#DIV/0!			$ - 0			$ - 0			$ - 0	$ - 0		ERROR:#DIV/0!

Price Track

PRICE TRACK ($)

Description	INITIAL PROPOSAL PRICE	Schedule Shift	Change in Labor Hours	Change in Wrap Rates	Change in Material	Change in Indirects	Total Changes	FPR PRICE
Delivery Order 01 - Intitial TRN (CLIN 0001)

Sample Epic

LH Rates at BEQ

TOTAL PROPOSAL

Microsoft_Word_Document1.docx For Official Use Only (FOUO)

D-ILS Statement of Objectives 1st DRAFT V ((0) 13-May-2009

ATTACHMENT 7

COST FORMATS

COST/PRICE VOLUME III

DISTRIBUTED COMMON GROUND/SURFACE SYSTEM (DCGS) INTEGRATION BACKBONE (DIB) DEVELOPMENT 5th Edition

19 September 2017

Version: Original i

For Official Use Only (FOUO) image1.emf

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.