HPASS_revision_2_pricing_sheet_6_4.xlsx

XLSX spreadsheet 27 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

Revision 2 of pricing sheet (corrected)

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
Price_Model_Worksheet_R2.xlsx XLSX spreadsheet
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
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
ATTACHMENT_-_Past_Performance_Questionnaire.doc DOC document
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
projnet_05.30.18.pdf PDF
amendment_2.pdf PDF
Amendment_01_17R0071_53018.pdf PDF
DD254_(HISS)_-_ERDC_concurred_version.pdf PDF
projnet_05.30.18.pdf PDF
conformed_copy_17R0071_53018.pdf PDF
HPASS_price_analysis_sheet_for_soliciation_5_24.xlsx XLSX spreadsheet
WD_15_Charles_county_MD_and_Fairfax_county_VA.docx DOCX document
WD_15_Montgomery_county_MD.docx DOCX document
W912DY17R0071_HPASS_solicitation_17_May_18_KO.pdf PDF
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
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.