Attach_L-7_DCGS_Cost_Model_REV_19Sep14.xls

XLS spreadsheet 122 KB Posted Oct 24, 2014

Attached to: 25 AF DCGS IDIQ Federal contract opportunity
Solicitation number: FA7037-15-R-0001
Issued by: Department of the Air Force Air Combat Command

About this file

From the source

Attach L-7 DCGS Cost Model

View the file

Other files for this federal contract opportunity

Other files attached to 25 AF DCGS IDIQ, newest first.
File	Type	Posted
Solicitation_Amend_06_Released.pdf	PDF	Apr 2, 2015
Solicitation_Amend_06.pdf	PDF	Apr 2, 2015
Attach_11_L-7_DCGS_Cost_Model_REV_02Apr15.xls	XLS spreadsheet	Apr 2, 2015
Solicitation_Amendment_05.pdf	PDF	Apr 1, 2015
Solicitation_Amendment_04.pdf	PDF	Mar 30, 2015
Attach_11_L-7_DCGS_Cost_Model_REV_30Mar15B.xls	XLS spreadsheet	Mar 30, 2015
Attach_11_L-7_DCGS_Cost_Model_REV_27Mar15.xls	XLS spreadsheet	Mar 27, 2015
Solicitation_Amendment_03.pdf	PDF	Mar 27, 2015
Solicitation_Amend_02.pdf	PDF	Mar 26, 2015
Attach_11_L-7_DCGS_Cost_Model_REV_25Mar15.xls	XLS spreadsheet	Mar 26, 2015
Attach_10_L-6b_Sample_TO_Pricing_Sheet_REV_25Mar15.xls	XLS spreadsheet	Mar 26, 2015
Solicitation_Q As.pdf	PDF	Mar 11, 2015
Attach_10_L-6b_Sample_TO_Pricing_Sheet_REV_11Mar15.xls	XLS spreadsheet	Mar 11, 2015
Attach_9_L-6a_DCGS_Sample_TO_REV_11Mar15.pdf	PDF	Mar 11, 2015
Attach_1-DCGS_PWS_REV_11Mar15.pdf	PDF	Mar 11, 2015
Amendment_01.pdf	PDF	Mar 11, 2015
Attach_12_L-8_Matrix_REV_11Mar15.pdf	PDF	Mar 11, 2015
Attach_11_L-7_DCGS_Cost_Model_REV_11Mar15.xls	XLS spreadsheet	Mar 11, 2015
Attach_2-PWS_Appendix_A_Job_Desc_REV_11Mar15.xls	XLS spreadsheet	Mar 11, 2015
Attach_3-PWS_Appendix_B_Mission_Essential_Personnel_REV_11Mar15.pdf	PDF	Mar 11, 2015
Attach_7_L-4_Consent_Form_REV_11Mar2015.pdf	PDF	Mar 11, 2015
Attach_13_L-9_Risk_Assessment_Template.pdf	PDF	Mar 11, 2015
Attach_6_L-3_PPQ_Cover_Sheet.docx	DOCX document	Feb 20, 2015
Attach_1-PWS.pdf	PDF	Feb 20, 2015
Exhibit_B-DD254.pdf	PDF	Feb 20, 2015
Attach_7_L-4_Consent_Form.doc	DOC document	Feb 20, 2015
Attach_11_L-7_DCGS_Cost_Model.xls	XLS spreadsheet	Feb 20, 2015
Attach_2-PWS_Appendix_A_Job_Desc_9Dec14.xlsx	XLSX spreadsheet	Feb 20, 2015
FA7037-15-R-0001_Solicitation.pdf	PDF	Feb 20, 2015
Attach_9_L-6a_DCGS_Sample_TO.pdf	PDF	Feb 20, 2015
Attach_8_L-5_Client_Author.docx	DOCX document	Feb 20, 2015
Exhibit_A-CDRL.pdf	PDF	Feb 20, 2015
Attach_4_L-1_PP_Info_Sheet.docx	DOCX document	Feb 20, 2015
Attach_5_L-2_PPQ.docx	DOCX document	Feb 20, 2015
Attach_12_L-8_Matrix_REV_7Jan15.docx	DOCX document	Feb 20, 2015
Attach_10_L-6b_Sample_TO_Pricing_Sheet.xlsx.xls	XLS spreadsheet	Feb 20, 2015
Attach_3-PWS_Appendix_B_Mission_Essential_Personnel.pdf	PDF	Feb 20, 2015
Draft_Docs_Q A.pdf	PDF	Jan 28, 2015
Attach_1-DCGS_PWS.pdf	PDF	Oct 24, 2014
Attach_L-6b_DCGS_Sample_TO_Pricing_Sheet_219Sep14.xlsx.xls	XLS spreadsheet	Oct 24, 2014
Attach_L-4_Consent_Form_26Mar2014.doc	DOC document	Oct 24, 2014
Attach_1b-PWS_Appendix_A_Job_Desc.pdf	PDF	Oct 24, 2014
Attach_4-Sect_M.pdf	PDF	Oct 24, 2014
Attach_L-3_PPQ_Cover_Sheet_07Oct14.docx	DOCX document	Oct 24, 2014
Attach_L-2_PPQ_26Mar2014.docx	DOCX document	Oct 24, 2014
Attach_L-8_Matrix.docx	DOCX document	Oct 24, 2014
Attach_L-6a_DCGS_Sample_TO.pdf	PDF	Oct 24, 2014
Attach_L-1_PP_Info_Sheet.pdf	PDF	Oct 24, 2014
Attach_3-Sect_L.pdf	PDF	Oct 24, 2014
Attach_L-5_Client_Author_26Mar2014.docx	DOCX document	Oct 24, 2014

Show all 50

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

The rates used in this cost model are for illustrative purposes only. They have been selected for no other reason than to indicate where Contractor's rates should be entered into the spreadsheet. They are not target rates, and have no relation to the Government's Estimate. Contractors should overtype the existing rates with their own company rates. The rates that should be overtyped have been highlighted in blue.

Worksheets "Base Year Rate Development", "Option One Rate Development", and "Option Two Rate Development" can be modified to reflect Contractor's rate development. Add or delete columns if needed. The last two columns shall remain "Profit" and "Loaded Wage"

Worksheet "Hourly Rates" requires no contractor input. Rates are taken from the "Base Year Hourly Rates", "Option One Hourly Rates", and "Option Two Hourly Rates" worksheets.

Base Year Rate Development

	Base Hourly Wage	Labor Overhead	Subtotal	G&A	Subtotal	Profit	Loaded Wage
	Base Year FFP
		10.00%		10.00%		5.00%
Configuration/Integration Manager		- 0	- 0	- 0	- 0	- 0	- 0
Server Programmer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developler (Mid-Level)		- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developer (Jr-Level)		- 0	- 0	- 0	- 0	- 0	- 0
Senior Software Tester/Integrateor	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Software Tester/Integrator		- 0	- 0	- 0	- 0	- 0	- 0
Quality Assurance/Software Test Engineer		- 0	- 0	- 0	- 0	- 0	- 0
Database Administrator		- 0	- 0	- 0	- 0	- 0	- 0
System Administrator/Spt Engineer III		- 0	- 0	- 0	- 0	- 0	- 0
Network Technician		- 0	- 0	- 0	- 0	- 0	- 0
Project Manager		- 0	- 0	- 0	- 0	- 0	- 0
Senior Consultant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Security Specialist		- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-II		- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III		- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Requirements Engineer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
SIGINT Systems Engineer II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Subject Matter Expert	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Operations/Research Analysts	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Base Year T&M
		10.00%		10.00%		5.00%
Intelligence Analyst I-II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Option One Rate Development

	Base Hourly Wage	Labor Overhead	Subtotal	G&A	Subtotal	Profit	Loaded Wage
	Option Year One FFP
Escalation	1.00%	10.00%		10.00%		5.00%
Configuration/Integration Manager	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Server Programmer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developler (Mid-Level)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developer (Jr-Level)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Software Tester/Integrateor	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Software Tester/Integrator	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Quality Assurance/Software Test Engineer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Database Administrator	- 0	- 0	- 0	- 0	- 0	- 0	- 0
System Administrator/Spt Engineer III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Technician	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Project Manager	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Consultant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Security Specialist	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Requirements Engineer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
SIGINT Systems Engineer II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Subject Matter Expert	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Operations/Research Analysts	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Option Year One T&M
Escalation	1.00%	10.00%		10.00%		5.00%
Intelligence Analyst I-II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0

&LFA7037-15-R-0001

Attachment l-7&CContractor Name&R&A Page &P of &N

Option Two Rate Development

	Base Hourly Wage	Labor Overhead	Subtotal	G&A	Subtotal	Profit	Loaded Wage
	Option Year Two FFP
Escalation	1.00%	10.00%		10.00%		5.00%
Configuration/Integration Manager	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Server Programmer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developler (Mid-Level)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Web Software Developer (Jr-Level)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Software Tester/Integrateor	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Software Tester/Integrator	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Quality Assurance/Software Test Engineer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Database Administrator	- 0	- 0	- 0	- 0	- 0	- 0	- 0
System Administrator/Spt Engineer III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Technician	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Project Manager	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Consultant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Security Specialist	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Requirements Engineer	- 0	- 0	- 0	- 0	- 0	- 0	- 0
SIGINT Systems Engineer II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Subject Matter Expert	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Operations/Research Analysts	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Option Year Two T&M
Escalation	1.00%	10.00%		10.00%		5.00%
Intelligence Analyst I-II	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst I-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Intelligence Analyst II-III	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Senior Management Analyst	- 0	- 0	- 0	- 0	- 0	- 0	- 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Hourly Rates

FFP
Classification	Base Year	Option Year One	Option Year Two
Configuration/Integration Manager	$ - 0	$ - 0	$ - 0
Server Programmer	$ - 0	$ - 0	$ - 0
Web Software Developler (Mid-Level)	$ - 0	$ - 0	$ - 0
Web Software Developer (Jr-Level)	$ - 0	$ - 0	$ - 0
Senior Software Tester/Integrateor	$ - 0	$ - 0	$ - 0
Software Tester/Integrator	$ - 0	$ - 0	$ - 0
Quality Assurance/Software Test Engineer	$ - 0	$ - 0	$ - 0
Database Administrator	$ - 0	$ - 0	$ - 0
System Administrator/Spt Engineer III	$ - 0	$ - 0	$ - 0
Network Technician	$ - 0	$ - 0	$ - 0
Project Manager	$ - 0	$ - 0	$ - 0
Senior Consultant	$ - 0	$ - 0	$ - 0
Security Specialist	$ - 0	$ - 0	$ - 0
Intelligence Analyst I-II	$ - 0	$ - 0	$ - 0
Intelligence Analyst I-III	$ - 0	$ - 0	$ - 0
Intelligence Analyst II-III	$ - 0	$ - 0	$ - 0
Senior Management Analyst	$ - 0	$ - 0	$ - 0
Senior Requirements Engineer	$ - 0	$ - 0	$ - 0
SIGINT Systems Engineer II	$ - 0	$ - 0	$ - 0
Senior Management Subject Matter Expert	$ - 0	$ - 0	$ - 0
Operations/Research Analysts	$ - 0	$ - 0	$ - 0
T&M
Classification	Base Year	Option Year One	Option Year Two
Intelligence Analyst I-II	$ - 0	$ - 0	$ - 0
Intelligence Analyst I-III	$ - 0	$ - 0	$ - 0
Intelligence Analyst II-III	$ - 0	$ - 0	$ - 0
Senior Management Analyst	$ - 0	$ - 0	$ - 0

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Labor Totals

	Base Year			Option Yr 1			Option Yr 2
CLIN X001, Labor FFP	Hours - Base Yr	Loaded Wage	Total Price	Hours - 1st Opt	Loaded Wage	Total Price	Hours -2nd Opt	Loaded Wage	Total Price
Configuration/Integration Manager	7,680	-	-	7,680	-	-	7,680	$ - 0	0
Server Programmer	5,760	-	-	5,760	-	-	5,760	$ - 0	0
Web Software Developler (Mid-Level)	3,840	-	-	3,840	-	-	3,840	$ - 0	0
Web Software Developer (Jr-Level)	1,920	-	-	1,920	-	-	1,920	$ - 0	0
Senior Software Tester/Integrateor	1,920	-	-	1,920	-	-	1,920	$ - 0	0
Software Tester/Integrator	3,840	-	-	3,840	-	-	3,840	$ - 0	0
Quality Assurance/Software Test Engineer	1,920	-	-	1,920	-	-	1,920	$ - 0	0
Database Administrator	1,920	-	-	1,920	-	-	1,920	$ - 0	0
System Administrator/Spt Engineer III	13,440	-	-	13,440	-	-	9,600	$ - 0	0
Network Technician	3,840	-	-	3,840	-	-	1,920	$ - 0	0
Project Manager	9,600	-	-	9,600	-	-	9,600	$ - 0	0
Senior Consultant	3,840	-	-	3,840	-	-	3,840	$ - 0	0
Security Specialist	5,760	-	-	5,760	-	-	5,760	$ - 0	0
Intelligence Analyst I-II	9,600	-	-	5,760	-	-	-	$ - 0	0
Intelligence Analyst I-III	38,400	-	-	30,720	-	-	30,720	$ - 0	0
Intelligence Analyst II-III	15,360	-	-	9,600	-	-	9,600	$ - 0	0
Senior Management Analyst	23,040	-	-	23,040	-	-	23,040	$ - 0	0
Senior Requirements Engineer	1,920	-	-	1,920	-	-	1,920	$ - 0	0
SIGINT Systems Engineer II	6,720	-	-	6,720	-	-	6,720	$ - 0	0
Senior Management Subject Matter Expert	5,760	-	-	5,760	-	-	5,760	$ - 0	0
Operations/Research Analysts	7,680	-	-	7,680	-	-	7,680	$ - 0	0
	Total:		-	Total:			Total:
Classification CLIN X002, Surge, CPFF	Hours - Base Yr	Loaded Wage	Total Price	Hours - 1st Opt	Loaded Wage	Total Price	Hours -2nd Opt	Loaded Wage	Total Price
Intelligence Analyst I-II	2,000	-	-	1,500	-	0	-	$ - 0	0
Intelligence Analyst I-III	8,000	-	-	8,000	-	0	8,725	$ - 0	0
Intelligence Analyst II-III	3,200	-	-	2,500	-	0	2,730	$ - 0	0
Senior Management Analyst	4,800	-	-	6,000	-	0	6,545	$ - 0	0
	Total:		-	Total:		-	Total:		-

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

Total Evaluated Price

	Base Year	Option Yr 1	Option Yr 2
CLIN X001, Labor FFP Total	$ - 0	$ - 0	$ - 0
CLIN X002, Surge T&M Total	$ - 0	$ - 0	$ - 0
CLIN X003, Materials, Cost	$ 300,000.00	$ 309,000.00	$ 318,270.00
CLIN X004, Travel, Cost	$ 550,000.00	$ 566,500.00	$ 583,495.00
CLIN X0005, Data, NSP	$ - 0	$ - 0	$ - 0
CLIN X006, TO 0001	$ 3,000.00	$ - 0	$ - 0
Yearly Total:	$ 853,000.00	$ 875,500.00	$ 901,765.00
Total Evaluated Price:	$2,630,265.00
Do NOT change the cells in orange. These will be the same for everyone.

&LFA7037-15-R-0001

Attachment L-7&CContractor Name&R&A Page &P of &N

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