HPASS_revision_2_pricing_sheet_6_4.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
HPCMP Professional Administrative Support Services (HPASS) Federal contract opportunity
Solicitation number
W912DY-17-R-0071
Issued by
Department of the Army Corps of Engineers Engineering Support Center Huntsville

About this file

From the source

revised pricing sheet

View the file

Other files for this federal contract opportunity

Other files attached to HPCMP Professional Administrative Support Services (HPASS), newest first.
File Type Posted
Amendment_5.pdf PDF
H-Pass_Amendment_4_conformed_copy.pdf PDF
H-Pass_Amendment_4.pdf PDF
amendment_3_conformed_copy.pdf PDF
amendment_3.pdf PDF
projnet_05.30.18.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
conformed_copy_17R0071_53018.pdf PDF
amendment_2.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
WD_15_Warren_county_MS.docx DOCX document
W912DY17R0071_HPASS_solicitation_17_May_18_KO.pdf PDF
WD_15_Charles_county_MD_and_Fairfax_county_VA.docx DOCX document
Price_Worksheet_15_May_18.xlsx XLSX spreadsheet
ATTACHMENT_-_Past_Performance_Questionnaire.doc DOC document
WD_15_Montgomery_county_MD.docx DOCX document
A.01.23_-_Sources_Sought_-_Attachment_2_Capabilities_Questionnaire.pdf PDF
A.01.23_Sources_Sought_Attach_1_PWS_HISS.pdf PDF
Sources_Sought_Attach_1_PWS_HISS.pdf PDF
A.01.23_-_Sources_Sought_-_Attachment_2_Capabilities_Questionnaire.pdf PDF
Show all 20

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
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$ 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 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$ 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&P11,680$ - 0$ 37,789$ 38,922$ 40,090$ 41,293$ 42,532$ 200,62658,400$ 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 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,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&A16,320$ - 0$ 27,804$ 28,638$ 29,497$ 30,382$ 31,294$ 147,61581,600$ 16,116$ 163,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
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 PM&A6,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
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
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$ 32,376$ 34,348$ 34,348$ 35,378$ 36,439$ 172,8890$ 18,766$ 191,655
TOTAL SECURITY7,680$ - 0$ 37,902$ 40,040$ 40,211$ 41,416$ 42,659$ 202,22838,400$ 21,969$ 224,197
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 $ 183,820 $ 190,335 $ 195,014 $ 200,865 $ 206,894 $ 976,928 345,600 $ 106,549 $ 1,083,477

File details come from the government source that posted it.