Attachment 4-BEMS COST TEMPLATE.xlsx

XLSX spreadsheet 27 KB Posted Apr 27, 2012

Attached to: BEMS Software Development and Operational Maintenance
Solicitation number: HSBP1012R0025
Issued by: Department of Homeland Security Customs and Border Protection

About this file

From the source

Attachment 4-Cost Template

View the file

Other files

File	Type	Posted
HSBP1012R0025 Solicitation Amendment A004(SF30).pdf	PDF	Jun 8, 2012
HSBP1012R0025 Solicitation Amendment A0003(SF30).pdf	PDF	May 30, 2012
A0003 Questions and Answers.pdf	PDF	May 30, 2012
LABOR CATEGORY DESCRIPTIONS-ADJUSTEDA0003.pdf	PDF	May 30, 2012
EQUIVALENT WORK EXP TRANSLATIONS A0003.pdf	PDF	May 30, 2012
Attachment 4-LABOR CATEGORY DESCRIPTIONS.pdf	PDF	May 24, 2012
HSBP1012R0025 Consolidated Question Matrix Answers A0002(RELEASE QA ONLY).pdf	PDF	May 24, 2012
HSBP1012R0025 Solicitation Amendment A002(SF30).pdf	PDF	May 24, 2012
Attachment 3 Cost Template-A0002.xlsx	XLSX spreadsheet	May 24, 2012
HSBP1012R0025 Consolidated Question Matrix Answers	—	May 18, 2012
HSBP1012R0025 Amendment A001	—	May 18, 2012
Attachment 4 BEMS cost template - A001.xlsx	XLSX spreadsheet	May 18, 2012
HSBP1012R0025 Consolidated Question Matrix Answers	—	May 18, 2012
HSBP1012R0025	—	Apr 27, 2012

Show all 14

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.

RFP Model - CPFF

Offeror:		BASE YEAR				OPTION YEAR 1			OPTION YEAR 2			OPTION YEAR 3			OPTION YEAR 4			TOTAL
DIRECT LABOR	EST # for Base Yr	Hours	Rate	Cost	EST # for All Options	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Total Cost
Contractor Labor Category
Sr. Bus Proc Re-engin	4	7,680.00		$0.00	7	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	$0.00
Int. Enterprise Resource Planning	4	7,680.00		$0.00	6	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	$0.00
Sr. Enterprise Resource Planning	4	7,680.00		$0.00	7	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	$0.00
Pr. Enterprise Resource Planning	7	13,440.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Sr. Inf Sec Spec	6	11,520.00		$0.00	10	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	$0.00
Int. IT Suppt Spec	4	7,680.00		$0.00	7	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	$0.00
Sr. IT Suppt Spec	3	5,760.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Int. IT Tech Spec	4	7,680.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Sr. IT Tech Spec	17	32,640.00		$0.00	21	40,320.00		$0.00	40,320.00		$0.00	40,320.00		$0.00	40,320.00		$0.00	$0.00
Int. Project Manager	4	7,680.00		$0.00	5	9,600.00		$0.00	9,600.00		$0.00	9,600.00		$0.00	9,600.00		$0.00	$0.00
Sr. Program Mng	5	9,600.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Int. Programer Analy/Eng	9	17,280.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Sr. Programer Analy/Eng	15	28,800.00		$0.00	21	40,320.00		$0.00	40,320.00		$0.00	40,320.00		$0.00	40,320.00		$0.00	$0.00
Int. Qual Assur	5	9,600.00		$0.00	6	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	$0.00
Sr. Subj Matter Exp	11	21,120.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Pr. Subj Matter Exp	5	9,600.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Int. Sys Spec	5	9,600.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Sr. Sys Spec	8	15,360.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Web Designer	6	11,520.00		$0.00	7	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	13,440.00		$0.00	$0.00
IT Admin Spec	6	11,520.00		$0.00	6	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	$0.00
Sr. IT Admin Spec	6	11,520.00		$0.00	6	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	$0.00
Telecom Eng	8	15,360.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Sys Arch	8	15,360.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Data Arch	8	15,360.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
SW Dev/Programmer	8	15,360.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Sr. Bus Proc Re-Eng	5	9,600.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Pr. Enterprise Resource Planning	5	9,600.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Int. Programer Analy/Eng	10	19,200.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Sr. Programer Analy/Eng	17	32,640.00		$0.00	19	36,480.00		$0.00	36,480.00		$0.00	36,480.00		$0.00	36,480.00		$0.00	$0.00
Int. Subj Matter Exp	8	15,360.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Sr. Subj Matter Exp	9	17,280.00		$0.00	10	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	$0.00
Pr. Subj Matter Exp	9	17,280.00		$0.00	10	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	$0.00
Int. Sys Spec	9	17,280.00		$0.00	10	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	19,200.00		$0.00	$0.00
Sr. Sys Spec	11	21,120.00		$0.00	11	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	21,120.00		$0.00	$0.00
Int. IT Suppt Spec	8	15,360.00		$0.00	8	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	$0.00
Int. IT Tech Spec	8	15,360.00		$0.00	8	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	$0.00
Sr. IT Tech Spec	9	17,280.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Pr. IT Tech Spec	7	13,440.00		$0.00	8	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	$0.00
Info Sys Sec Spec	7	13,440.00		$0.00	8	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	$0.00
IS Tech Spec	7	13,440.00		$0.00	8	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	15,360.00		$0.00	$0.00
Multi-Discipline SW Engineer	6	11,520.00		$0.00	6	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	11,520.00		$0.00	$0.00
Sr. Multi-Disc SW Engineer	8	15,360.00		$0.00	9	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	17,280.00		$0.00	$0.00
Total Direct Labor	313.0	600,960		$0.00	404.0	775,680		$0.00	775,680		$0.00	775,680		$0.00	775,680		$0.00	$0.00

INDIRECT LABOR COST (Note 1)	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Total Cost
Indirect Labor Cost Pool 1											$0.00
Indirect Labor Cost Pool 2											$0.00
TOTAL INDIRECT BURDEN APPLIED TO LABOR COST		$0.00		$0.00		$0.00		$0.00		$0.00	$0.00

DIRECT MATERIAL	Quantity	Unit Cost	Cost	Quantity	Unit Cost	Cost	Quantity	Unit Cost	Cost	Quantity	Unit Cost	Cost	Quantity	Unit Cost	Cost	Total Cost
Material description			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00
Material description			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00
Material description			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00
Material description			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00
Material description			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00
Total Direct Material			$0.00			$0.00			$0.00			$0.00			$0.00	$0.00

INDIRECT BURDEN APPLIED TO MATERIAL COST (Note 2)	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Total Cost
Indirect Burden Applied To Material Cost Pool 1											$0.00
Indirect Burden Applied To Material Cost Pool 2											$0.00
TOTAL INDIRECT BURDEN APPLIED TO MATERIAL COST		$0.00		$0.00		$0.00		$0.00		$0.00	$0.00

SUBCONTRACT	Cost	Cost	Cost	Cost	Cost	Total Cost	Total Cost
Subcontractor name	$0.00					$0.00
Subcontractor name						$0.00
Subcontractor name						$0.00
TOTAL SUBCONTRACT	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

INDIRECT BURDEN APPLIED TO SUBCONTRACT COST (Note 3)	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Total Cost
Indirect Burden Applied To Subcontract Cost Pool 1	.										ERROR:#VALUE!
Indirect Burden Applied To Subcontract Cost Pool 2											$0.00
TOTAL INDIRECT BURDEN APPLIED TO SUBCONTRACT COST		$0.00		$0.00		$0.00		$0.00		$0.00	$0.00

OTHER DIRECT COST	Cost	Cost	Cost	Cost	Cost	Total Cost
TRAVEL	$0.00					$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Cost description						$0.00
Total Other Direct Cost	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$500,000.00

TOTAL G&A BASE $100,000.00 $100,000.00 $100,000.00 $100,000.00 $100,000.00 $500,000.00

GENERAL AND ADMINISTRATIVE (G&A)	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Total Cost
G&A	0.00%	$0.00		$0.00		$0.00		$0.00		$0.00	$0.00

TOTAL COST $100,000.00 $100,000.00 $100,000.00 $100,000.00 $100,000.00 $500,000.00

FIXED FEE	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Rate	Cost	Total Cost
Profit	0.00%	$0.00		$0.00		$0.00		$0.00		$0.00	$0.00
	0.0
TOTAL COST + FIXED FEE		$100,000.00		$100,000.00		$100,000.00		$100,000.00		$100,000.00	$500,000.00

FACILITIES CAPITAL COST OF MONEY (FCCOM)	Cost	Cost	Cost	Cost	Cost	Total Cost
FCCOM						$0.00

TOTAL COST + FIXED FEE + FCCOM	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$500,000.00
Note 1: For all Indirect Labor Cost pools, please provide the description of the allocation base for each pool (please add additional pools if aplicable):
Indirect Labor Cost Pool 1:
Indirect Labor Cost Pool 2:

Note 2: For all Indirect Material Cost pools, please provide the description of the allocation base for each pool (please add additional pools if aplicable):

Indirect Material Cost Pool 1:

Indirect Material Cost Pool 2:

Note 3: For all Indirect Subcontract Cost pools, please provide the description of the allocation base for each pool (please add additional pools if aplicable):

Indirect Subcontract Cost Pool 1:

Indirect Subcontract Cost Pool 2:

&"Arial,Bold"&16RFP PRICING TEMPLATE - COST PLUS FIXED FEE (ALL)

Page &P of &N

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