HPASS_price_analysis_sheet_for_soliciation_5_24.xlsx

27 KB Posted

Attached to
HPCMP Program Administrative Support Services (H-PASS)
Solicitation number
W912DY17R0071
Issued by

About this file

From the source

revised/updated price sheet

View the file

Other files

File Type Posted
Amendment_8__17R0071_2JUL18.pdf PDF
Conformed_Solicitation_W912DY17R0071.pdf PDF
Price_Model_Worksheet_R2_(1).xlsx XLSX spreadsheet
Amendment_7_Conformed_Copy.pdf PDF
Amendment_7_Modification_Copy.pdf PDF
Price_Model_Worksheet_R2.xlsx XLSX spreadsheet
Amendment_0007_17R0071_27JUN18.pdf PDF
Amendment_0006_17R0071_22_JUN_18.pdf PDF
Price_Model_Worksheet_R1.xlsx XLSX spreadsheet
Conformed_Solicitation_W912DY17R0071.pdf PDF
Amendment_5.pdf PDF
H-Pass_Amendment_4.pdf PDF
H-Pass_Amendment_4_conformed_copy.pdf PDF
amendment_3.pdf PDF
amendment_3_conformed_copy.pdf PDF
HPASS_revision_2_pricing_sheet_6_4.xlsx XLSX spreadsheet
projnet_05.30.18.pdf PDF
amendment_2.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
conformed_copy_17R0071_53018.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
ATTACHMENT_-_Past_Performance_Questionnaire.doc DOC document
amendment_2.pdf PDF
HPASS_revision_2_pricing_sheet_6_4.xlsx XLSX spreadsheet
conformed_copy_17R0071_53018.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
projnet_05.30.18.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
W912DY17R0071_HPASS_solicitation_17_May_18_KO.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
WD_15_Charles_county_MD_and_Fairfax_county_VA.docx DOCX document
WD_15_Warren_county_MS.docx DOCX document
Price_Worksheet_15_May_18.xlsx XLSX spreadsheet
WD_15_Montgomery_county_MD.docx DOCX document
Show all 34

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.

Sheet1

HPASS PRICING MODEL
Offeror InputOUT YEARS
Provided NTEABC = A*BDEF = D + E $G = (F*A)HIJK(G,H,I,J,K)
CLINLocationPWS Sub-SectionHours Per YearBase Year Rate (No Loads/No Profit)Base Year Labor Amount (No Loads/No Profit)Base Year Labor Rate Fully Burdened Less ProfitProposed Profit %Fully Burdened Base Year Rate Plus Profit PriceTotal Proposed Base Year PriceTotal Proposed Option Y1 $ PriceTotal Proposed Option Y2 $ PriceTotal Proposed Option Y3 $ PriceTotal Proposed Option Y4 $ PriceProposed Price (Base Year, Options 1-4)Total FTE Hours - Base, Y1, Y2, Y3, Y4Total Proposed 6 Month Extension Option $ PriceTotal Proposed Price All Years + 6 Month Extension
CENTERS
Business Analysis Support1Remote4.4.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Admin and Meeting Sppt2Lorton, VA4.7.1.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
CENTERS Travel NTE3$ 8,817$ 9,082$ 9,354$ 9,635$ 9,924$ 46,8120$ 4,962$ 51,774
CENTERS Materials & ODC NTE4$ 10,186$ 10,491$ 10,806$ 11,130$ 11,464$ 54,0770$ 5,732$ 59,809
TOTAL CENTERS3,840$ - 0$ 19,003$ 19,573$ 20,160$ 20,765$ 21,388$ 100,88919,200$ 10,694$ 111,583
CREATE
Program Analysis5Remote4.2.1.71,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support5Carderock, MD4.4.71,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support5Lorton, VA4.4.71,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 55,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 028,800$ - 0$ - 0
Admin and Meeting Sppt6Lorton, VA4.7.1.6.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Admin and Meeting Sppt6Patuxent River, MD4.7.1.6.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 63,840$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 019,200$ - 0$ - 0
CREATE Travel NTE7$ 21,945$ 22,603$ 23,281$ 23,980$ 24,699$ 116,5080$ 12,350$ 128,858
CREATE Materials & ODC NTE8$ 515$ 531$ 547$ 563$ 580$ 2,7360$ 290$ 3,026
TOTAL CREATE9,600$ - 0$ 22,460$ 23,134$ 23,828$ 24,543$ 25,279$ 119,24448,000$ 12,640$ 131,884
DREN
Program Analysis9Lorton, VA4.2.3.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program Analysis9Remote4.2.3.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program Analysis9Remote4.2.3.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support9Lorton, VA4.4.5.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support9Remote4.4.5.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 99,600$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 048,000$ - 0$ - 0
Admin and Meeting Sppt10Lorton, VA4.7.1.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
DREN Travel NTE11$ 13,508$ 13,913$ 14,330$ 14,760$ 15,203$ 71,7140$ 7,602$ 79,316
DREN Materials & ODC NTE12$ 14,921$ 15,369$ 15,830$ 16,305$ 16,794$ 79,2190$ 8,397$ 87,616
TOTAL DREN11,520$ - 0$ 28,429$ 29,282$ 30,160$ 31,065$ 31,997$ 150,93357,600$ 15,999$ 166,932
P&P
Program Analysis13Lorton, VA4.2.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program Analysis13Remote4.2.2.8960$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 04,800$ - 0$ - 0
Marketing Team13Lorton, VA4.2.2.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Marketing Team13Lorton, VA4.2.2.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Marketing Team13Lorton, VA4.2.2.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Marketing Team13Lorton, VA4.2.2.41,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support13Lorton, VA4.4.4480$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,400$ - 0$ - 0
Total CLIN 1311,040$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 055,200$ - 0$ - 0
Admin and Meeting Sppt14Lorton, VA4.7.1.5640$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 03,200$ - 0$ - 0
P&P Travel NTE15$ 22,971$ 23,660$ 24,370$ 25,101$ 25,854$ 121,9560$ 12,927$ 134,883
P&P Materials & ODC NTE16$ 19,514$ 20,099$ 20,702$ 21,323$ 21,963$ 103,6010$ 10,982$ 114,583
TOTAL P&P11,680$ - 0$ 42,485$ 43,759$ 45,072$ 46,424$ 47,817$ 225,55758,400$ 23,909$ 249,466
PM&A
Program and Project Mgmt.17Lorton, VA4.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program and Project Mgmt.17Lorton, VA4.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support17Remote4.4.2.2960$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 04,800$ - 0$ - 0
Business Analysis Support17Vicksburg, MS4.4.2.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Business Analysis Support17Vicksburg, MS4.2.2.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 178,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 043,200$ - 0$ - 0
Admin and Meeting Sppt18Lorton, VA4.7.1.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Admin and Meeting Sppt18Lorton, VA4.7.3.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Admin and Meeting Sppt18Lorton, VA4.7.3.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Admin and Meeting Sppt18Lorton, VA4.7.41,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 187,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 038,400$ - 0$ - 0
PM&A Travel NTE19$ 7,432$ 7,655$ 7,885$ 8,121$ 8,365$ 39,4580$ 4,183$ 43,641
PM&A Materials & ODC NTE20$ 4,600$ 4,738$ 4,880$ 5,027$ 5,178$ 24,4230$ 2,589$ 27,012
TOTAL PM&A16,320$ - 0$ 12,032$ 12,393$ 12,765$ 13,148$ 13,543$ 63,88181,600$ 6,772$ 70,653
RM
Requirements/Data Analysis21Lorton, VA4.3.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Requirements/Data Analysis21Lorton, VA4.3.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Requirements/Data Analysis21Remote4.3.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 215,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 028,800$ - 0$ - 0
Admin and Meeting Sppt22Lorton, VA4.7.1.5640$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 03,200$ - 0$ - 0
RM Travel NTE23$ 10,363$ 10,674$ 10,994$ 11,324$ 11,664$ 55,0190$ 5,832$ 60,851
RM Materials & ODC NTE24$ 292$ 301$ 310$ 319$ 329$ 1,5510$ 165$ 1,716
TOTAL PM&A6,400$ - 0$ 10,655$ 10,975$ 11,304$ 11,643$ 11,993$ 56,57032,000$ 5,997$ 62,567
SAS
Business Analysis Support25Lorton, VA4.4.81,440$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 07,200$ - 0$ - 0
Admin and Meeting Sppt26Lorton, VA4.7.1.5640$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 03,200$ - 0$ - 0
SAS Travel NTE27$ 3,398$ 3,500$ 3,605$ 3,713$ 3,825$ 18,0410$ 1,913$ 19,954
SAS Materials & ODC NTE28$ 2,358$ 2,429$ 2,502$ 2,577$ 2,654$ 12,5200$ 1,327$ 13,847
TOTAL SAS2,080$ - 0$ 5,756$ 5,929$ 6,107$ 6,290$ 6,479$ 30,56110,400$ 3,240$ 33,801
SECURITY
Business Analysis Support29Lorton, VA4.4.61,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Security Support29Lorton, VA4.6.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Security Support29Lorton, VA4.6.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 295,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 028,800$ - 0$ - 0
Admin and Meeting Sppt30Lorton, VA4.7.1.41,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
SECURITY Travel NTE31$ 5,526$ 5,692$ 5,863$ 6,038$ 6,220$ 29,3390$ 3,110$ 32,449
SECURITY Materials & ODC NTE32$ 2,358$ 2,502$ 2,502$ 2,577$ 2,654$ 12,5930$ 1,327$ 13,920
TOTAL SECURITY7,680$ - 0$ 7,884$ 8,194$ 8,365$ 8,615$ 8,874$ 41,93238,400$ 4,437$ 46,369
CONTRACT COSTS
Phase In33$ - 0$ - 0$ - 0
CMRA34$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL CONTRACT COSTS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

TOTAL PROPOSED PRICE 69,120 - 0 $ 148,704 $ 153,239 $ 157,761 $ 162,493 $ 167,370 $ 789,567 345,600 $ 83,685 $ 873,252

File details come from the government source that posted it.