Price_Model_Worksheet_R2.xlsx

XLSX spreadsheet 28 KB Posted

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

Attached is a DRAFT of Price Worksheet. The official worksheet is forthcoming.

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
Amendment_8__17R0071_2JUL18.pdf PDF
Price_Model_Worksheet_R2_(1).xlsx XLSX spreadsheet
Amendment_7_Conformed_Copy.pdf PDF
Amendment_7_Modification_Copy.pdf PDF
Amendment_0007_17R0071_27JUN18.pdf PDF
Conformed_Solicitation_W912DY17R0071.pdf PDF
Amendment_0006_17R0071_22_JUN_18.pdf PDF
Price_Model_Worksheet_R1.xlsx XLSX spreadsheet
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
ATTACHMENT_-_Past_Performance_Questionnaire.doc DOC document
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
HPASS_revision_2_pricing_sheet_6_4.xlsx XLSX spreadsheet
amendment_2.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
conformed_copy_17R0071_53018.pdf PDF
projnet_05.30.18.pdf PDF
HPASS_revision_2_pricing_sheet_6_4.xlsx XLSX spreadsheet
amendment_2.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
projnet_05.30.18.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
conformed_copy_17R0071_53018.pdf PDF
HPASS_price_analysis_sheet_for_soliciation_5_24.xlsx XLSX spreadsheet
WD_15_Montgomery_county_MD.docx DOCX document
W912DY17R0071_HPASS_solicitation_17_May_18_KO.pdf PDF
WD_15_Charles_county_MD_and_Fairfax_county_VA.docx DOCX document
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
WD_15_Warren_county_MS.docx DOCX document
Price_Worksheet_15_May_18.xlsx XLSX spreadsheet
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 27 (CLINS 18 AND 37 RESERVED)
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
Optional 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$ 5,111$ 51,923
CENTERS Materials & ODC NTE4$ 1,000$ 1,030$ 1,061$ 1,093$ 1,126$ 5,3100$ 580$ 5,890
TOTAL CENTERS3,840$ - 0$ 9,817$ 10,112$ 10,415$ 10,728$ 11,050$ 52,12219,200$ 5,691$ 57,813
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,720$ 129,228
CREATE Materials & ODC NTE8$ 15,922$ 16,400$ 16,892$ 17,399$ 17,921$ 84,5340$ 9,229$ 93,763
TOTAL CREATE9,600$ - 0$ 37,867$ 39,003$ 40,173$ 41,379$ 42,620$ 201,04248,000$ 21,949$ 222,991
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,829$ 79,543
DREN Materials & ODC NTE12$ 480$ 494$ 509$ 524$ 540$ 2,5470$ 278$ 2,825
TOTAL DREN11,520$ - 0$ 13,988$ 14,407$ 14,839$ 15,284$ 15,743$ 74,26157,600$ 8,107$ 82,368
P&P
Program Doc Sppt13Lorton, VA4.2.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program Outreach Workforce Dev13Remote4.2.2.5960$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 04,800$ - 0$ - 0
PO Current/Legacy Bus Mgmt Sppt13Lorton, VA4.4.4480$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,400$ - 0$ - 0
Total CLIN 133,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 016,800$ - 0$ - 0
Optional 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$ 13,315$ 135,271
P&P Materials & ODC NTE16$ 14,818$ 15,262$ 15,720$ 16,192$ 16,678$ 78,6700$ 8,589$ 87,259
TOTAL P&P4,000$ - 0$ 37,789$ 38,922$ 40,090$ 41,293$ 42,532$ 200,62620,000$ 21,904$ 222,530
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 Support17Vicksburg, MS4.2.2.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLIN 175,760$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 028,800$ - 0$ - 0
PM&A Travel NTE19$ 7,432$ 7,655$ 7,885$ 8,121$ 8,365$ 39,4580$ 4,308$ 43,766
PM&A Materials & ODC NTE20$ 20,372$ 20,983$ 21,612$ 22,261$ 22,929$ 108,1570$ 11,808$ 119,965
TOTAL PM&A5,760$ - 0$ 27,804$ 28,638$ 29,497$ 30,382$ 31,294$ 147,61528,80016,116163,731
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
Optional 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$ 6,007$ 61,026
RM Materials & ODC NTE24$ 4,600$ 4,738$ 4,880$ 5,027$ 5,178$ 24,4230$ 2,667$ 27,090
TOTAL RM6,400$ - 0$ 14,963$ 15,412$ 15,874$ 16,351$ 16,842$ 79,44232,000$ 8,674$ 88,116
SAS
Business Analysis Support25Lorton, VA4.4.81,440$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 07,200$ - 0$ - 0
Optional 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,970$ 20,011
SAS Materials & ODC NTE28$ 292$ 301$ 310$ 319$ 329$ 1,5510$ 169$ 1,720
TOTAL SAS2,080$ - 0$ 3,690$ 3,801$ 3,915$ 4,032$ 4,154$ 19,59210,400$ 2,139$ 21,731
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
Optional 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,203$ 32,542
SECURITY Materials & ODC NTE32$ 12,376$ 12,747$ 13,130$ 13,524$ 13,929$ 65,7060$ 7,174$ 72,880
TOTAL SECURITY7,680$ - 0$ 17,902$ 18,439$ 18,993$ 19,562$ 20,149$ 95,04538,400$ 10,377$ 105,422
OPTIONAL MARKETING TEAM
Pro Strategic Mkt & Comm Sppt33Lorton, VA4.2.2.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Senior Web Dev Sppt34Lorton, VA4.2.2.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Program Outreach Graphic Arts Sppt35Lorton, VA4.2.2.31,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Web Content & Dev Sppt36Lorton, VA4.2.2.41,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
TOTAL CLINs 33,34,35,367,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 038,400$ - 0$ - 0
OPTIONAL ADMIN and MEETING SPPT
HPCMP Senior Lead Admin Sppt38Lorton, VA4.7.1.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Daily Senior Admin Office Sppt39Lorton, VA4.7.3.11,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Senior Admin Travel Sppt40Lorton, VA4.7.3.21,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Facilities and Inv Mgmt Sppt41Lorton, VA4.7.41,920$ - 0$ - 0$ - 00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 09,600$ - 0$ - 0
Total CLINs 38,39,40,417,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 038,400$ - 0$ - 0
CONTRACT COSTS
Phase In/Out420$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0$ - 0
CMRA430$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0$ - 0
TOTAL Phase In/Out & CMRA COSTS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL PROPOSED PRICE66,240$ - 0$ 163,820$ 168,734$ 173,796$ 179,011$ 184,384$ 869,745331,200$ 94,957$ 964,702
(CLINS 18 AND 37 RESERVED)

File details come from the government source that posted it.