ATTACHEMENT L-4 COST MODEL.xls

XLS spreadsheet 79 KB Posted Aug 25, 2011

Attached to: DOD RED TEAM
Solicitation number: HDTRA1-11-R-0024
Issued by: Defense Threat Reduction Agency

About this file

From the source

Attachment L-4 Task Order 0001 Cost Model

View the file

Other files

File	Type	Posted
EXHIBIT A CDRLS.pdf	PDF	Sep 13, 2011
HDTRA1-11-R-0024 AMEND 0001.pdf	PDF	Sep 13, 2011
ATTACHMENT 2 T.O. 0001 RED SOW.doc	DOC document	Sep 13, 2011
ATTACHMENT 1 RED SOO.doc	DOC document	Sep 13, 2011
FINAL HDTRA1-11-R-0024 Q As.xls	XLS spreadsheet	Sep 13, 2011
ATTACHMENT L-3 PERSONNEL MATRIX.xls	XLS spreadsheet	Aug 25, 2011
ATTACHMENT L-1 PPPI.doc	DOC document	Aug 25, 2011
ATTACHMENT 2 T.O. 0001 RED SOW.doc	DOC document	Aug 25, 2011
EXHIBIT A CDRLS.pdf	PDF	Aug 25, 2011
ATTACHMENT L-2 PPPQ.doc	DOC document	Aug 25, 2011
ATTACHMENT S-1 SOCIO-ECONOMIC TEMPLATE.xls	XLS spreadsheet	Aug 25, 2011
ATTACHMENT 1 RED SOO.doc	DOC document	Aug 25, 2011
ATTACHMENT 3 DD254.pdf	PDF	Aug 25, 2011
FINAL HDTRA1-11-R-0024.doc	DOC document	Aug 25, 2011
ATTACHMENT 4 NON-DISCLOSURE AGREEMENT.doc	DOC document	Aug 25, 2011
Draft HDTRA1-11-R-0024 Q As.xls	XLS spreadsheet	Aug 25, 2011
ATTACHMENT L-2 PPPQ.doc	DOC document	Jul 8, 2011
ATTACHMENT 1 STATEMENT OF OBJECTIVES	—	Jul 8, 2011
DRAFT HDTRA1-11-R-0024.doc	DOC document	Jul 8, 2011
ATTACHMENT L-1 PPPI.doc	DOC document	Jul 8, 2011
ATTACHMENT 2 T.O. 0001 STATEMENT OF WORK	—	Jul 8, 2011
EXHIBIT A CDRLS.pdf	PDF	Jul 8, 2011
ATTACHMENT 3 DD254.pdf	PDF	Jul 8, 2011
ATTACHEMENT L-4 COST MODEL.xls	XLS spreadsheet	Jul 8, 2011
ATTACHMENT L-3 PERSONNEL MATRIX.xls	XLS spreadsheet	Jul 8, 2011
ATTACHMENT S-1 SOCIO-ECONOMIC TEMPLATE.xls	XLS spreadsheet	Jul 8, 2011

Show all 26

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.

BASE

Please fill-in according to the model and format below
(Sample data below for purposes of general instruction)
[Please fill out one of these sheets for each year (Base and 4 Options), then provide summary total of all 5 years.
BASE YEAR
Direct Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$460,800
Subcontractor Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$403,200
Indirect Costs
(add/delete quantity & categories as needed)
Overhead (% of labor only)		85.00%	$391,680
Subtotal
G&A (% of Labor only)		15.00%	$69,120
Subtotal
Travel (Use Plug Number L.5.6.4)			$250,000
Other ODCs			$0
Cost (Subtotal All)			$1,324,800
Fee		6.50%	$86,112
CPFF			$1,410,912

&C&"Times New Roman,Bold"&24COST PROPOSAL MODEL- TASK ORDER 1&14 &R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

OPTION 1

Please fill-in according to the model and format below
(Sample data below for purposes of general instruction)
OPTION YEAR 1
Direct Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Subcontractor Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Indirect Costs
(add/delete quantity & categories as needed)
Overhead (% of labor only)		85.00%	$244,800
Subtotal
G&A (% of Labor only)		15.00%	$43,200
Subtotal
Travel (Use Plug Number L.5.6.4)			$275,000
Other ODCs			$0
Cost (Subtotal All)			$1,139,000
Fee		6.50%	$74,035
CPFF			$1,213,035

&C&"Times New Roman,Bold"&24COST PROPOSAL MODEL- TASK ORDER 1 &R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

OPTION 2

Please fill-in according to the model and format below
(Sample data below for purposes of general instruction)
OPTION YEAR 2
Direct Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Subcontractor Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Indirect Costs
(add/delete quantity & categories as needed)
Overhead (% of labor only)		85.00%	$244,800
Subtotal
G&A (% of Labor only)		15.00%	$43,200
Subtotal
Travel (Use Plug Number L.5.6.4)			$275,000
Other ODCs			$0
Cost (Subtotal All)			$1,139,000
Fee		6.50%	$74,035
CPFF			$1,213,035

&C&"Times New Roman,Bold"&24COST PROPOSAL MODEL- TASK ORDER 1 &R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

OPTION 3

Please fill-in according to the model and format below
(Sample data below for purposes of general instruction)
OPTION YEAR 3
Direct Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Subcontractor Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Indirect Costs
(add/delete quantity & categories as needed)
Overhead (% of labor only)		85.00%	$244,800
Subtotal
G&A (% of Labor only)		15.00%	$43,200
Subtotal
Travel (Use Plug Number L.5.6.4)			$300,000
Other ODCs			$0
Cost (Subtotal All)			$1,164,000
Fee		6.50%	$75,660
CPFF			$1,239,660

&C&"Times New Roman,Bold"&24COST PROPOSAL MODEL- TASK ORDER 1 &R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

OPTION 4

Please fill-in according to the model and format below
(Sample data below for purposes of general instruction)
OPTION YEAR 4
Direct Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Subcontractor Labor
Category (modify titles):	#hrs	Rate/hr	Total
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
Red Team Program Manager	1920	$30.00	$57,600
(add/delete quantity as needed)
Subtotal Labor:			$288,000
Indirect Costs
(add/delete quantity & categories as needed)
Overhead (% of labor only)		85.00%	$244,800
Subtotal
G&A (% of Labor only)		15.00%	$43,200
Subtotal
Travel (Use Plug Number L.5.6.4)			$300,000
Other ODCs			$0
Cost (Subtotal All)			$1,164,000
Fee		6.50%	$75,660
CPFF			$1,239,660

&C&"Times New Roman,Bold"&24COST PROPOSAL MODEL- TASK ORDER 1 &R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

SUMMARY

Cost Proposal Model- Task Order 1 Summary (Sample data below will populate based on information from all five Price Model Worksheets)
	PERFORMANCE YEAR	TOTAL COSTS
	Base Year	$1,410,912.00
	Option Year 1	$1,213,035.00
	Option Year 2	$1,213,035.00
	Option Year 3	$1,239,660.00
	Option Year 4	$1,239,660.00
	TOTAL COST ALL YEARS	$6,316,302.00

&R&"Times New Roman,Regular"ATTACHMENT L-4

HDTRA1-11-R-0024

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