Price_Model_Worksheet_R1.xlsx

XLSX spreadsheet 28 KB Posted Jun 22, 2018

Attached to: HPCMP Program Administrative Support Services (H-PASS) Federal contract opportunity
Solicitation number: W912DY17R0071
Issued by: Department of the Army Corps of Engineers Engineering Support Center Huntsville

About this file

From the source

Price Worksheet

View the file

Other files for this federal contract opportunity

Other files attached to HPCMP Program Administrative Support Services (H-PASS), newest first.
File	Type	Posted
Conformed_Solicitation_W912DY17R0071.pdf	PDF	Jul 2, 2018
Amendment_8__17R0071_2JUL18.pdf	PDF	Jul 2, 2018
Price_Model_Worksheet_R2_(1).xlsx	XLSX spreadsheet	Jun 29, 2018
Amendment_7_Conformed_Copy.pdf	PDF	Jun 28, 2018
Amendment_7_Modification_Copy.pdf	PDF	Jun 28, 2018
Amendment_0007_17R0071_27JUN18.pdf	PDF	Jun 27, 2018
Price_Model_Worksheet_R2.xlsx	XLSX spreadsheet	Jun 27, 2018
Conformed_Solicitation_W912DY17R0071.pdf	PDF	Jun 22, 2018
Amendment_0006_17R0071_22_JUN_18.pdf	PDF	Jun 22, 2018
Amendment_5.pdf	PDF	Jun 13, 2018
H-Pass_Amendment_4.pdf	PDF	Jun 8, 2018
H-Pass_Amendment_4_conformed_copy.pdf	PDF	Jun 8, 2018
amendment_3.pdf	PDF	Jun 7, 2018
amendment_3_conformed_copy.pdf	PDF	Jun 7, 2018
ATTACHMENT_-_Past_Performance_Questionnaire.doc	DOC document	Jun 5, 2018
DD254_(HISS)_-_ERDC_concurred_version.pdf	PDF	Jun 5, 2018
HPASS_revision_2_pricing_sheet_6_4.xlsx	XLSX spreadsheet	Jun 5, 2018
amendment_2.pdf	PDF	Jun 5, 2018
Amendment_01_17R0071_53018.pdf	PDF	Jun 5, 2018
conformed_copy_17R0071_53018.pdf	PDF	Jun 5, 2018
projnet_05.30.18.pdf	PDF	Jun 5, 2018
HPASS_revision_2_pricing_sheet_6_4.xlsx	XLSX spreadsheet	Jun 4, 2018
amendment_2.pdf	PDF	Jun 4, 2018
DD254_(HISS)_-_ERDC_concurred_version.pdf	PDF	May 30, 2018
projnet_05.30.18.pdf	PDF	May 30, 2018
Amendment_01_17R0071_53018.pdf	PDF	May 30, 2018
conformed_copy_17R0071_53018.pdf	PDF	May 30, 2018
HPASS_price_analysis_sheet_for_soliciation_5_24.xlsx	XLSX spreadsheet	May 30, 2018
WD_15_Montgomery_county_MD.docx	DOCX document	May 21, 2018
W912DY17R0071_HPASS_solicitation_17_May_18_KO.pdf	PDF	May 21, 2018
WD_15_Charles_county_MD_and_Fairfax_county_VA.docx	DOCX document	May 21, 2018
DD254_(HISS)_-_ERDC_concurred_version.pdf	PDF	May 21, 2018
WD_15_Warren_county_MS.docx	DOCX document	May 21, 2018
Price_Worksheet_15_May_18.xlsx	XLSX spreadsheet	May 21, 2018

Show all 34

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.

Sheet1

HPASS PRICING MODEL JUNE 15
	Offeror Input										OUT YEARS
	Provided NTE			A	B	C = A*B	D	E	F = D + E $	G = (F*A)	H	I	J	K	(G,H,I,J,K)
	CLIN	Location	PWS Sub-Section	Hours Per Year	Base Year Rate (No Loads/No Profit)	Base Year Labor Amount (No Loads/No Profit)	Base Year Labor Rate Fully Burdened Less Profit	Proposed Profit %	Fully Burdened Base Year Rate Plus Profit Price	Total Proposed Base Year Price	Total Proposed Option Y1 $ Price	Total Proposed Option Y2 $ Price	Total Proposed Option Y3 $ Price	Total Proposed Option Y4 $ Price	Proposed Price (Base Year, Options 1-4)	Total FTE Hours - Base, Y1, Y2, Y3, Y4	Total Proposed 6 Month Extension Option $ Price	Total Proposed Price All Years + 6 Month Extension
CENTERS
Business Analysis Support	1	Remote	4.4.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Optional Admin and Meeting Sppt	2	Lorton, VA	4.7.1.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
CENTERS Travel NTE	3									$ 8,817	$ 9,082	$ 9,354	$ 9,635	$ 9,924	$ 46,812	0	$ 5,111	$ 51,923
CENTERS Materials & ODC NTE	4									$ 1,000	$ 1,030	$ 1,061	$ 1,093	$ 1,126	$ 5,310	0	$ 580	$ 5,890
TOTAL CENTERS				3,840		$ - 0				$ 9,817	$ 10,112	$ 10,415	$ 10,728	$ 11,050	$ 52,122	19,200	$ 5,691	$ 57,813

CREATE
Program Analysis	5	Remote	4.2.1.7	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Business Analysis Support	5	Carderock, MD	4.4.7	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Business Analysis Support	5	Lorton, VA	4.4.7	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 5				5,760		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	28,800	$ - 0	$ - 0
Admin and Meeting Sppt	6	Lorton, VA	4.7.1.6.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Admin and Meeting Sppt	6	Patuxent River, MD	4.7.1.6.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 6				3,840		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	19,200	$ - 0	$ - 0
CREATE Travel NTE	7									$ 21,945	$ 22,603	$ 23,281	$ 23,980	$ 24,699	$ 116,508	0	$ 12,720	$ 129,228
CREATE Materials & ODC NTE	8									$ 15,922	$ 16,400	$ 16,892	$ 17,399	$ 17,921	$ 84,534	0	$ 9,229	$ 93,763
TOTAL CREATE				9,600		$ - 0				$ 37,867	$ 39,003	$ 40,173	$ 41,379	$ 42,620	$ 201,042	48,000	$ 21,949	$ 222,991

DREN
Program Analysis	9	Lorton, VA	4.2.3.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Program Analysis	9	Remote	4.2.3.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Program Analysis	9	Remote	4.2.3.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Business Analysis Support	9	Lorton, VA	4.4.5.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Business Analysis Support	9	Remote	4.4.5.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 9				9,600		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	48,000	$ - 0	$ - 0
Admin and Meeting Sppt	10	Lorton, VA	4.7.1.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
DREN Travel NTE	11									$ 13,508	$ 13,913	$ 14,330	$ 14,760	$ 15,203	$ 71,714	0	$ 7,829	$ 79,543
DREN Materials & ODC NTE	12									$ 480	$ 494	$ 509	$ 524	$ 540	$ 2,547	0	$ 278	$ 2,825
TOTAL DREN				11,520		$ - 0				$ 13,988	$ 14,407	$ 14,839	$ 15,284	$ 15,743	$ 74,261	57,600	$ 8,107	$ 82,368

P&P
Program Analysis	13	Lorton, VA	4.2.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Program Analysis	13	Remote	4.2.2.8	960	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	4,800	$ - 0	$ - 0
Business Analysis Support	13	Lorton, VA	4.4.4	480	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	2,400	$ - 0	$ - 0
Total CLIN 13				3,360		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	16,800	$ - 0	$ - 0
Optional Admin and Meeting Sppt	14	Lorton, VA	4.7.1.5	640	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	3,200	$ - 0	$ - 0
P&P Travel NTE	15									$ 22,971	$ 23,660	$ 24,370	$ 25,101	$ 25,854	$ 121,956	0	$ 13,315	$ 135,271
P&P Materials & ODC NTE	16									$ 14,818	$ 15,262	$ 15,720	$ 16,192	$ 16,678	$ 78,670	0	$ 8,589	$ 87,259
TOTAL P&P				4,000		$ - 0				$ 37,789	$ 38,922	$ 40,090	$ 41,293	$ 42,532	$ 200,626	20,000	$ 21,904	$ 222,530

PM&A
Program and Project Mgmt.	17	Lorton, VA	4.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Program and Project Mgmt.	17	Lorton, VA	4.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Business Analysis Support	17	Vicksburg, MS	4.2.2.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 17				5,760		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	28,800	$ - 0	$ - 0
Optional Admin and Meeting Sppt	18	Lorton, VA	4.7.1.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Optional Admin and Meeting Sppt	18	Lorton, VA	4.7.3.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Optional Admin and Meeting Sppt	18	Lorton, VA	4.7.3.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Optional Admin and Meeting Sppt	18	Lorton, VA	4.7.4	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 18				7,680		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	38,400	$ - 0	$ - 0
PM&A Travel NTE	19									$ 7,432	$ 7,655	$ 7,885	$ 8,121	$ 8,365	$ 39,458	0	$ 4,308	$ 43,766
PM&A Materials & ODC NTE	20									$ 20,372	$ 20,983	$ 21,612	$ 22,261	$ 22,929	$ 108,157	0	$ 11,808	$ 119,965
TOTAL PM&A				13,440		$ - 0				$ 27,804	$ 28,638	$ 29,497	$ 30,382	$ 31,294	$ 147,615	67,200	$ 16,116	$ 163,731

RM
Requirements/Data Analysis	21	Lorton, VA	4.3.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Requirements/Data Analysis	21	Lorton, VA	4.3.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Requirements/Data Analysis	21	Remote	4.3.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 21				5,760		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	28,800	$ - 0	$ - 0
Optional Admin and Meeting Sppt	22	Lorton, VA	4.7.1.5	640	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	3,200	$ - 0	$ - 0
RM Travel NTE	23									$ 10,363	$ 10,674	$ 10,994	$ 11,324	$ 11,664	$ 55,019	0	$ 6,007	$ 61,026
RM Materials & ODC NTE	24									$ 4,600	$ 4,738	$ 4,880	$ 5,027	$ 5,178	$ 24,423	0	$ 2,667	$ 27,090
TOTAL RM				6,400		$ - 0				$ 14,963	$ 15,412	$ 15,874	$ 16,351	$ 16,842	$ 79,442	32,000	$ 8,674	$ 88,116

SAS
Business Analysis Support	25	Lorton, VA	4.4.8	1,440	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	7,200	$ - 0	$ - 0
Optional Admin and Meeting Sppt	26	Lorton, VA	4.7.1.5	640	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	3,200	$ - 0	$ - 0
SAS Travel NTE	27									$ 3,398	$ 3,500	$ 3,605	$ 3,713	$ 3,825	$ 18,041	0	$ 1,970	$ 20,011
SAS Materials & ODC NTE	28									$ 292	$ 301	$ 310	$ 319	$ 329	$ 1,551	0	$ 169	$ 1,720
TOTAL SAS				2,080		$ - 0				$ 3,690	$ 3,801	$ 3,915	$ 4,032	$ 4,154	$ 19,592	10,400	$ 2,139	$ 21,731

SECURITY
Business Analysis Support	29	Lorton, VA	4.4.6	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Security Support	29	Lorton, VA	4.6.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Security Support	29	Lorton, VA	4.6.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Total CLIN 29				5,760		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	28,800	$ - 0	$ - 0
Optional Admin and Meeting Sppt	30	Lorton, VA	4.7.1.4	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
SECURITY Travel NTE	31									$ 5,526	$ 5,692	$ 5,863	$ 6,038	$ 6,220	$ 29,339	0	$ 3,203	$ 32,542
SECURITY Materials & ODC NTE	32									$ 12,376	$ 12,747	$ 13,130	$ 13,524	$ 13,929	$ 65,706	0	$ 7,174	$ 72,880
TOTAL SECURITY				7,680		$ - 0				$ 17,902	$ 18,439	$ 18,993	$ 19,562	$ 20,149	$ 95,045	38,400	$ 10,377	$ 105,422

CONTRACT COSTS
Phase In	33									$ - 0					$ - 0	0		$ - 0
CMRA	35									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0	$ - 0	$ - 0
TOTAL Phase In & CMRA COSTS										$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0	$ - 0
OPTIONAL MARKETING TEAM
Pro Strategic Mkt & Comm Sppt	34	Lorton, VA	4.2.2.1	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Senior Web Dev Sppt	34	Lorton, VA	4.2.2.2	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Program Outreach Graphic Arts Sppt	34	Lorton, VA	4.2.2.3	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
Web Content & Dev Sppt	34	Lorton, VA	4.2.2.4	1,920	$ - 0	$ - 0	$ - 0	0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	9,600	$ - 0	$ - 0
TOTAL CLIN 34				7,680		$ - 0				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	38,400	$ - 0	$ - 0
TOTAL PROPOSED PRICE				66,240		$ - 0				$ 163,820	$ 168,734	$ 173,796	$ 179,011	$ 184,384	$ 869,745	331,200	94,957	964,702

File details come from the government source that posted it.