Attachment 4 BEMS cost template - A001.xlsx

XLSX spreadsheet 25 KB Posted May 18, 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

Cost Templated A0001

View the file

Other files

File	Type	Posted
HSBP1012R0025 Solicitation Amendment A004(SF30).pdf	PDF	Jun 8, 2012
LABOR CATEGORY DESCRIPTIONS-ADJUSTEDA0003.pdf	PDF	May 30, 2012
EQUIVALENT WORK EXP TRANSLATIONS A0003.pdf	PDF	May 30, 2012
HSBP1012R0025 Solicitation Amendment A0003(SF30).pdf	PDF	May 30, 2012
A0003 Questions and Answers.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 Consolidated Question Matrix Answers	—	May 18, 2012
HSBP1012R0025 Amendment A001	—	May 18, 2012
Attachment 4-BEMS COST TEMPLATE.xlsx	XLSX spreadsheet	Apr 27, 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
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
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
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
Int. IT Suppt Spec	12	23,040.00		$0.00	15	28,800.00		$0.00	28,800.00		$0.00	28,800.00		$0.00	28,800.00		$0.00	$0.00
Int. IT Tech Spec	12	23,040.00		$0.00	17	32,640.00		$0.00	32,640.00		$0.00	32,640.00		$0.00	32,640.00		$0.00	$0.00
Int. Programer Analy/Eng	19	36,480.00		$0.00	22	42,240.00		$0.00	42,240.00		$0.00	42,240.00		$0.00	42,240.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
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
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
Int. Sys Spec	14	26,880.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
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
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
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
Pr. Enterprise Resource Planning	12	23,040.00		$0.00	20	38,400.00		$0.00	38,400.00		$0.00	38,400.00		$0.00	38,400.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
Pr. Subj Matter Exp	14	26,880.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
Sr. Bus Proc Re-Eng	9	17,280.00		$0.00	16	30,720.00		$0.00	30,720.00		$0.00	30,720.00		$0.00	30,720.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
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
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
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
Sr. IT Tech Spec	26	49,920.00		$0.00	30	57,600.00		$0.00	57,600.00		$0.00	57,600.00		$0.00	57,600.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
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
Sr. Programer Analy/Eng	32	61,440.00		$0.00	40	76,800.00		$0.00	76,800.00		$0.00	76,800.00		$0.00	76,800.00		$0.00	$0.00
Sr. Subj Matter Exp	20	38,400.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
Sr. Sys Spec	19	36,480.00		$0.00	22	42,240.00		$0.00	42,240.00		$0.00	42,240.00		$0.00	42,240.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
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
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
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
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.