Attach_2-PricingSpreadsheet_2-28-13_xls.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
INSTALLATION & LOGISTICS MANAGEMENT SERVICES (ILMS) Federal contract opportunity
Solicitation number
HSCG44-13-R-ILMS
Issued by
Department of Homeland Security US Coast Guard

About this file

Pricing Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to INSTALLATION & LOGISTICS MANAGEMENT SERVICES (ILMS), newest first.
File Type Posted
Attach_1__SOW_2-28-13.docx DOCX document
Attach_11_1449.pdf PDF
Attach_12_Q A.doc DOC document
RFP_Solicitation_2-28-13.docx DOCX document
Attach_10_Notice_and_Order.pdf PDF
Attach_2_Pricing_Spreadsheet_xls.xlsx XLSX spreadsheet
Attach_8_PPQ.doc DOC document
Attach_4_NDA.pdf PDF
Solicit_ILMS.docx DOCX document
Attach_1_SOW.docx DOCX document
Attach_5_DD254.pdf PDF
ATTACH__9-StatementofEquiv_FederalWageRates.docx DOCX document
Attach_3__CLIN_Structure.docx DOCX document
Attach_7_Wage_Det.txt TXT text file
Attach_6_Labor_Definitions.docx DOCX document
Show all 15

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

Text version

Base Year 2013

ATTACHMENT 2 - PRICING SPREADSHEET - TASK ORDER PRICING -BASE YEAR - 2013

CLIN No.Labor & Activity DescriptionEST. ON-SITEEST. OFF-SITEOn-Site RateOff-Site RateTotal On-SiteTotal Off-Site
1001Program Manager1,0004,000$0.00$0.00
1002Project Task Manager1,0004,000$0.00$0.00
1003Program Analyst I1,0004,000$0.00$0.00
1004Program Analyst II1,0004,000$0.00$0.00
1005Program Analyst III1,0004,000$0.00$0.00
1006Program Analyst IV1,0004,000$0.00$0.00
1007Subject Matter Expert1,0004,000$0.00$0.00
1008Systems Engineer1,0004,000$0.00$0.00
1009Senior Engineer1,0004,000$0.00$0.00
1010Engineer1,0004,000$0.00$0.00
1011Test Engineer1,0004,000$0.00$0.00
1012Sr. Systems Analyst1,0004,000$0.00$0.00
1013Systems Analyst1,0004,000$0.00$0.00
1014Telecom/RF Systems Field Engineer1,0004,000$0.00$0.00
1015Sr. Telecom/RF Systems Technician1,0004,000$0.00$0.00
1016Integrated Systems Technician I1,0004,000$0.00$0.00
1017Integrated Systems Technician II1,2004,800$0.00$0.00
1018Integrated Systems Technician III1,4005,600$0.00$0.00
1019Integrated Systems Technician IV1,2004,800$0.00$0.00
1020System Adminstrator1,0004,000$0.00$0.00
1021Comms / Network Engineer1,0004,000$0.00$0.00
1022Comms / Network Technician I1,0004,000$0.00$0.00
1023Comms / Network Technician II1,2004,800$0.00$0.00
1024Comms / Network Technician III1,4005,600$0.00$0.00
1025Comms / Network Technician IV1,4005,600$0.00$0.00
1026Comms / Network Technician V1,2004,800$0.00$0.00
1027Training Specialist1,0004,000$0.00$0.00
1028Electronics Tech, Maintenance I8,00032,000$0.00$0.00
1029Electronics Tech, Maintenance II8,00032,000$0.00$0.00
1030Electronics Tech, Maintenance III8,00032,000$0.00$0.00
1031Engineering Technician I4,00016,000$0.00$0.00
1032Engineering Technician II6,00024,000$0.00$0.00
1033Engineering Technician III8,00032,000$0.00$0.00
1034Engineering Technician IV8,00032,000$0.00$0.00
1035Engineering Technician V8,00032,000$0.00$0.00
1036Engineering Technician VI6,00024,000$0.00$0.00
1037Visual Information Services Technician I1,0004,000$0.00$0.00
1038Visual Information Services Technician II2,0008,000$0.00$0.00
1039Visual Information Services Technician III2,0008,000$0.00$0.00
1040Visual Information Services Technician IV1,0004,000$0.00$0.00
1041Logistics Specialist1,0004,000$0.00$0.00
1042Logistics Technician1,0004,000$0.00$0.00
1043Technical Writer I1,0004,000$0.00$0.00
1044Technical Writer II1,0004,000$0.00$0.00
1045Technical Writer III1,0004,000$0.00$0.00
1046IT Installation Technician6002,400$0.00$0.00
1047Electrician, Maintenance8003,200$0.00$0.00
1048Travel and Per Diem including G&ANTENTE$2,000,000.00$8,000,000.00
1049Material Costs including G&ANTENTE$1,294,818.00$5,179,272.00
1050ODCs including G&ANTENTE$400,000.00$1,600,000.00
Total Price105,400421,600$3,694,818.00$14,779,272.00

TOTAL ALL YEARS:

YEAREST ON-SITEEST OFF-SITETOTAL ON-SITETOTAL OFF-SITE
Base Year:105,400421,600$3,694,818.00$14,779,272.00
Option Year I:105,400421,600$4,529,978.08$18,119,912.34
Option Year II:105,400421,600$5,365,138.18$21,460,552.68
Option Year III:105,400421,600$6,200,298.26$24,801,193.03
Option Year IV:105,400421,600$7,035,458.34$28,141,833.38

TOTAL OF ALL YEARS: 527,000 2,108 $26,825,690.86 $107,302,763.43

&"Arial,Bold"&14Independent Government Estimate - IGE &"Arial,Bold"&12 05/08/2009

TO PRCING-YR. 2

ATTACHMENT 2 - PRICING SPREADSHEET - TASK ORDER PRICING YEAR 2 - 2014
CLIN No.Labor & Activity DescriptionEST.ON-SITEEST. OFF-SITEOn-Site RateOff-Site RateTotal On-SiteTotal Off-Site
2001Program Manager1,0004,000$0.00$0.00
2002Project Task Manager1,0004,000$0.00$0.00
2003Program Analyst I1,0004,000$0.00$0.00
2004Program Analyst II1,0004,000$0.00$0.00
2005Program Analyst III1,0004,000$0.00$0.00
2006Program Analyst IV1,0004,000$0.00$0.00
2007Subject Matter Expert1,0004,000$0.00$0.00
2008Systems Engineer1,0004,000$0.00$0.00
2009Senior Engineer1,0004,000$0.00$0.00
2010Engineer1,0004,000$0.00$0.00
2011Test Engineer1,0004,000$0.00$0.00
2012Sr. Systems Analyst1,0004,000$0.00$0.00
2013Systems Analyst1,0004,000$0.00$0.00
2014Telecom/RF Systems Field Engineer1,0004,000$0.00$0.00
2015Sr. Telecom/RF Systems Technician1,0004,000$0.00$0.00
2016Integrated Systems Technician I1,0004,000$0.00$0.00
2017Integrated Systems Technician II1,2004,800$0.00$0.00
2018Integrated Systems Technician III1,4005,600$0.00$0.00
2019Integrated Systems Technician IV1,2004,800$0.00$0.00
2020System Adminstrator1,0004,000$0.00$0.00
2021Comms / Network Engineer1,0004,000$0.00$0.00
2022Comms / Network Technician I1,0004,000$0.00$0.00
2023Comms / Network Technician II1,2004,800$0.00$0.00
2024Comms / Network Technician III1,4005,600$0.00$0.00
2025Comms / Network Technician IV1,4005,600$0.00$0.00
2026Comms / Network Technician V1,2004,800$0.00$0.00
2027Training Specialist1,0004,000$0.00$0.00
2028Electronics Tech, Maintenance I8,00032,000$0.00$0.00
2029Electronics Tech, Maintenance II8,00032,000$0.00$0.00
2030Electronics Tech, Maintenance III8,00032,000$0.00$0.00
2031Engineering Technician I4,00016,000$0.00$0.00
2032Engineering Technician II6,00024,000$0.00$0.00
2033Engineering Technician III8,00032,000$0.00$0.00
2034Engineering Technician IV8,00032,000$0.00$0.00
2035Engineering Technician V8,00032,000$0.00$0.00
2036Engineering Technician VI6,00024,000$0.00$0.00
2037Visual Information Services Technician I1,0004,000$0.00$0.00
2038Visual Information Services Technician II2,0008,000$0.00$0.00
2039Visual Information Services Technician III2,0008,000$0.00$0.00
2040Visual Information Services Technician IV1,0004,000$0.00$0.00
2041Logistics Specialist1,0004,000$0.00$0.00
2042Logistics Technician1,0004,000$0.00$0.00
2043Technical Writer I1,0004,000$0.00$0.00
2044Technical Writer II1,0004,000$0.00$0.00
2045Technical Writer III1,0004,000$0.00$0.00
2046IT Installation Technician6002,400$0.00$0.00
2047Electrician, Maintenance8003,200$0.00$0.00
2048Travel and Per Diem including G&ANTENTE$2,200,000.00$8,800,000.00
2049Material Costs including G&ANTENTE$1,529,978.08$6,119,912.34
2050ODCs including G&ANTENTE$800,000.00$3,200,000.00
Total Price105,400421,600$4,529,978.08$18,119,912.34

&"Arial,Bold"&14Independent Government Estimate - IGE &"Arial,Bold"&12 05/08/2009

TO PRICING--YR. 3

to ATTACHMENT 2 - PRICING SPREADSHEET - TO PRICING 3 - 2015

CLIN No.Labor & Activity DescriptionEST. ON-SITEEST. OFF-SITEOn-Site RateOff-Site RateTotal On-SiteTotal Off-Site
3001Program Manager1,0004,000$0.00$0.00
3002Project Task Manager1,0004,000$0.00$0.00
3003Program Analyst I1,0004,000$0.00$0.00
3004Program Analyst II1,0004,000$0.00$0.00
3005Program Analyst III1,0004,000$0.00$0.00
3006Program Analyst IV1,0004,000$0.00$0.00
3007Subject Matter Expert1,0004,000$0.00$0.00
3008Systems Engineer1,0004,000$0.00$0.00
3009Senior Engineer1,0004,000$0.00$0.00
3010Engineer1,0004,000$0.00$0.00
3011Test Engineer1,0004,000$0.00$0.00
3012Sr. Systems Analyst1,0004,000$0.00$0.00
3013Systems Analyst1,0004,000$0.00$0.00
3014Telecom/RF Systems Field Engineer1,0004,000$0.00$0.00
3015Sr. Telecom/RF Systems Technician1,0004,000$0.00$0.00
3016Integrated Systems Technician I1,0004,000$0.00$0.00
3017Integrated Systems Technician II1,2004,800$0.00$0.00
3018Integrated Systems Technician III1,4005,600$0.00$0.00
3019Integrated Systems Technician IV1,2004,800$0.00$0.00
3020System Adminstrator1,0004,000$0.00$0.00
3021Comms / Network Engineer1,0004,000$0.00$0.00
3022Comms / Network Technician I1,0004,000$0.00$0.00
3023Comms / Network Technician II1,2004,800$0.00$0.00
3024Comms / Network Technician III1,4005,600$0.00$0.00
3025Comms / Network Technician IV1,4005,600$0.00$0.00
3026Comms / Network Technician V1,2004,800$0.00$0.00
3027Training Specialist1,0004,000$0.00$0.00
3028Electronics Tech, Maintenance I8,00032,000$0.00$0.00
3029Electronics Tech, Maintenance II8,00032,000$0.00$0.00
3030Electronics Tech, Maintenance III8,00032,000$0.00$0.00
3031Engineering Technician I4,00016,000$0.00$0.00
3032Engineering Technician II6,00024,000$0.00$0.00
3033Engineering Technician III8,00032,000$0.00$0.00
3034Engineering Technician IV8,00032,000$0.00$0.00
3035Engineering Technician V8,00032,000$0.00$0.00
3036Engineering Technician VI6,00024,000$0.00$0.00
3037Visual Information Services Technician I1,0004,000$0.00$0.00
3038Visual Information Services Technician II2,0008,000$0.00$0.00
3039Visual Information Services Technician III2,0008,000$0.00$0.00
3040Visual Information Services Technician IV1,0004,000$0.00$0.00
3041Logistics Specialist1,0004,000$0.00$0.00
3042Logistics Technician1,0004,000$0.00$0.00
3043Technical Writer I1,0004,000$0.00$0.00
3044Technical Writer II1,0004,000$0.00$0.00
3045Technical Writer III1,0004,000$0.00$0.00
3046IT Installation Technician6002,400$0.00$0.00
3047Electrician, Maintenance8003,200$0.00$0.00
3048Travel and Per Diem including G&ANTENTE$2,400,000.00$9,600,000.00
3049Material Costs including G&ANTENTE$1,765,138.18$7,060,552.68
3050ODCs including G&ANTENTE$1,200,000.00$4,800,000.00
Total Price105,400421,600$5,365,138.18$21,460,552.68

&"Arial,Bold"&14Independent Government Estimate - IGE &"Arial,Bold"&12 05/08/2009

TO PRICING-YR. 4

ATTACHMENT 2 - PRICING SPREADSHEET - TO PRICING - YR. 4 - 2016

CLIN NO.Labor & Activity DescriptionEST. ON-SITEEST. OFF-SITEOn-Site RateOff-Site RateTotal On-SiteTotal Off-Site
4001Program Manager1,0004,000$0.00$0.00
4002Project Task Manager1,0004,000$0.00$0.00
4003Program Analyst I1,0004,000$0.00$0.00
4004Program Analyst II1,0004,000$0.00$0.00
4005Program Analyst III1,0004,000$0.00$0.00
4006Program Analyst IV1,0004,000$0.00$0.00
4007Subject Matter Expert1,0004,000$0.00$0.00
4008Systems Engineer1,0004,000$0.00$0.00
4009Senior Engineer1,0004,000$0.00$0.00
4010Engineer1,0004,000$0.00$0.00
4011Test Engineer1,0004,000$0.00$0.00
4012Sr. Systems Analyst1,0004,000$0.00$0.00
4013Systems Analyst1,0004,000$0.00$0.00
4014Telecom/RF Systems Field Engineer1,0004,000$0.00$0.00
4015Sr. Telecom/RF Systems Technician1,0004,000$0.00$0.00
4016Integrated Systems Technician I1,0004,000$0.00$0.00
4017Integrated Systems Technician II1,2004,800$0.00$0.00
4018Integrated Systems Technician III1,4005,600$0.00$0.00
4019Integrated Systems Technician IV1,2004,800$0.00$0.00
4020System Adminstrator1,0004,000$0.00$0.00
4021Comms / Network Engineer1,0004,000$0.00$0.00
4022Comms / Network Technician I1,0004,000$0.00$0.00
4023Comms / Network Technician II1,2004,800$0.00$0.00
4024Comms / Network Technician III1,4005,600$0.00$0.00
4025Comms / Network Technician IV1,4005,600$0.00$0.00
4026Comms / Network Technician V1,2004,800$0.00$0.00
4027Training Specialist1,0004,000$0.00$0.00
4028Electronics Tech, Maintenance I8,00032,000$0.00$0.00
4029Electronics Tech, Maintenance II8,00032,000$0.00$0.00
4030Electronics Tech, Maintenance III8,00032,000$0.00$0.00
4031Engineering Technician I4,00016,000$0.00$0.00
4032Engineering Technician II6,00024,000$0.00$0.00
4033Engineering Technician III8,00032,000$0.00$0.00
4034Engineering Technician IV8,00032,000$0.00$0.00
4035Engineering Technician V8,00032,000$0.00$0.00
4036Engineering Technician VI6,00024,000$0.00$0.00
4037Visual Information Services Technician I1,0004,000$0.00$0.00
4038Visual Information Services Technician II2,0008,000$0.00$0.00
4039Visual Information Services Technician III2,0008,000$0.00$0.00
4040Visual Information Services Technician IV1,0004,000$0.00$0.00
4041Logistics Specialist1,0004,000$0.00$0.00
4042Logistics Technician1,0004,000$0.00$0.00
4043Technical Writer I1,0004,000$0.00$0.00
4044Technical Writer II1,0004,000$0.00$0.00
4045Technical Writer III1,0004,000$0.00$0.00
4046IT Installation Technician6002,400$0.00$0.00
4047Electrician, Maintenance8003,200$0.00$0.00
4048Travel and Per Diem including G&ANTENTE$2,600,000.00$10,400,000.00
4049Material Costs including G&ANTENTE$2,200,298.26$8,801,193.03
4050ODCs including G&ANTENTE$1,400,000.00$5,600,000.00
Total Price105,400421,600$6,200,298.26$24,801,193.03

&"Arial,Bold"&14Independent Government Estimate - IGE &"Arial,Bold"&12 05/08/2009

TO PRICING-YR. 5

ATTACHMENT 2 - PRICING SPREADSHEET - TO PRICING YR. 5 - 2017

CLIN No.Labor & Activity DescriptionEST. ON-SITEEST. OFF-SITEOn-Site RateOff-Site RateTotal On-SiteTotal Off-Site
5001Program Manager1,0004,000$0.00$0.00
5002Project Task Manager1,0004,000$0.00$0.00
5003Program Analyst I1,0004,000$0.00$0.00
5004Program Analyst II1,0004,000$0.00$0.00
5005Program Analyst III1,0004,000$0.00$0.00
5006Program Analyst IV1,0004,000$0.00$0.00
5007Subject Matter Expert1,0004,000$0.00$0.00
5008Systems Engineer1,0004,000$0.00$0.00
5009Senior Engineer1,0004,000$0.00$0.00
5010Engineer1,0004,000$0.00$0.00
5011Test Engineer1,0004,000$0.00$0.00
5012Sr. Systems Analyst1,0004,000$0.00$0.00
5013Systems Analyst1,0004,000$0.00$0.00
5014Telecom/RF Systems Field Engineer1,0004,000$0.00$0.00
5015Sr. Telecom/RF Systems Technician1,0004,000$0.00$0.00
5016Integrated Systems Technician I1,0004,000$0.00$0.00
5017Integrated Systems Technician II1,2004,800$0.00$0.00
5018Integrated Systems Technician III1,4005,600$0.00$0.00
5019Integrated Systems Technician IV1,2004,800$0.00$0.00
5020System Adminstrator1,0004,000$0.00$0.00
5021Comms / Network Engineer1,0004,000$0.00$0.00
5022Comms / Network Technician I1,0004,000$0.00$0.00
5023Comms / Network Technician II1,2004,800$0.00$0.00
5024Comms / Network Technician III1,4005,600$0.00$0.00
5025Comms / Network Technician IV1,4005,600$0.00$0.00
5026Comms / Network Technician V1,2004,800$0.00$0.00
5027Training Specialist1,0004,000$0.00$0.00
5028Electronics Tech, Maintenance I8,00032,000$0.00$0.00
5029Electronics Tech, Maintenance II8,00032,000$0.00$0.00
5030Electronics Tech, Maintenance III8,00032,000$0.00$0.00
5031Engineering Technician I4,00016,000$0.00$0.00
5032Engineering Technician II6,00024,000$0.00$0.00
5033Engineering Technician III8,00032,000$0.00$0.00
5034Engineering Technician IV8,00032,000$0.00$0.00
5035Engineering Technician V8,00032,000$0.00$0.00
5036Engineering Technician VI6,00024,000$0.00$0.00
5037Visual Information Services Technician I1,0004,000$0.00$0.00
5038Visual Information Services Technician II2,0008,000$0.00$0.00
5039Visual Information Services Technician III2,0008,000$0.00$0.00
5040Visual Information Services Technician IV1,0004,000$0.00$0.00
5041Logistics Specialist1,0004,000$0.00$0.00
5042Logistics Technician1,0004,000$0.00$0.00
5043Technical Writer I1,0004,000$0.00$0.00
5044Technical Writer II1,0004,000$0.00$0.00
5045Technical Writer III1,0004,000$0.00$0.00
5046IT Installation Technician6002,400$0.00$0.00
5047Electrician, Maintenance8003,200$0.00$0.00
5048Travel and Per Diem including G&ANTENTE$3,000,000.00$12,000,000.00
5049Material Costs including G&ANTENTE$2,435,458.34$9,741,833.38
5050ODCs including G&ANTENTE$1,600,000.00$6,400,000.00
Total Price105,400421,600$7,035,458.34$28,141,833.38

&"Arial,Bold"&14Independent Government Estimate - IGE &"Arial,Bold"&12 05/08/2009

TOTAL ALL YEARS

ATTACHMENT 2: PRICING SPREADSHEET (SUMMARY)

TASK ORDER PRICING YEARS ONE THRU FIVE ESTIMATED ON-SITE HOURS: EST IMATED OFF-SITE HOURS: TOTAL ON-SITE COSTS (LABOR): TOTAL OFF-SITE COSTS (LABOR): TOTAL CALENDAR YEAR (CY) ONE THRU FIVE ON-SITE PRICING: TOTAL CALENDAR YEAR (CY) ONE THRU FIVE OFF-SITE PRICING:

LABOR:

TO PRICING: BASE- 2013: 105,400 421,600 $0.00 $0.00 $0.00 $0.00

TO PRICING: YR. 2-2014: 105,400 421,600 $0.00 $0.00 $0.00 $0.00

TO PRICING: YR.3-2015: 105,400 421,600 $0.00 $0.00 $0.00 $0.00

TO PRICING: YR.4-2016: 105,400 421,600 $0.00 $0.00 $0.00 $0.00

TO PRICING: YR.5-2017: 105,400 421,600 $0.00 $0.00 $0.00 $0.00

SUBTOTAL (LABOR): 527,000 2,108,000 $0.00 $0.00 $0.00

OTHER DIRECT COSTS: ON-SITE: OFF-SITE:

TRAVEL AND PER DIEM/NTENTE$26,825,690.86$107,302,763.43
MATERIAL AND ODC
COSTS (Years 1-5):
(See Summary Table
Total All Years' in
Base Year 2013)

SUBTOTAL ALL ODCs:

TOTAL PROPOSED PRICE: $0.00 $0.00

File details come from the government source that posted it. Updated .