Attach_2_Pricing_Spreadsheet_xls.xlsx

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

Attachment 2-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
RFP_Solicitation_2-28-13.docx DOCX document
Attach_11_1449.pdf PDF
Attach_2-PricingSpreadsheet_2-28-13_xls.xlsx XLSX spreadsheet
Attach_12_Q A.doc DOC document
Attach_1__SOW_2-28-13.docx DOCX document
Attach_10_Notice_and_Order.pdf PDF
ATTACH__9-StatementofEquiv_FederalWageRates.docx DOCX document
Attach_3__CLIN_Structure.docx DOCX document
Attach_4_NDA.pdf PDF
Solicit_ILMS.docx DOCX document
Attach_1_SOW.docx DOCX document
Attach_5_DD254.pdf PDF
Attach_8_PPQ.doc DOC 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

Yr.1 TO Pricing Year One Task Ordering Period - Date of Award through 12 Months Thereafter

CLIN No.Labor & Activity DescriptionEstimated HoursOn-Site RateOff-Site RateOn-Site Total RateOff-Site Total Rate
1001Program Manager5,000$0.00$0.00
1002Project Task Manager5,000$0.00$0.00
1003Program Analyst I5,000$0.00$0.00
1004Program Analyst II5,000$0.00$0.00
1005Program Analyst III5,000$0.00$0.00
1006Program Analyst IV5,000$0.00$0.00
1007Subject Matter Expert5,000$0.00$0.00
1008Systems Engineer5,000$0.00$0.00
1009Senior Engineer5,000$0.00$0.00
1010Engineer5,000$0.00$0.00
1011Test Engineer5,000$0.00$0.00
1012Sr. Systems Analyst5,000$0.00$0.00
1013Systems Analyst5,000$0.00$0.00
1014Telecom/RF Systems Field Engineer5,000$0.00$0.00
1015Sr. Telecom/RF Systems Technician5,000$0.00$0.00
1016Integrated Systems Technician I5,000$0.00$0.00
1017Integrated Systems Technician II6,000$0.00$0.00
1018Integrated Systems Technician III7,000$0.00$0.00
1019Integrated Systems Technician IV6,000$0.00$0.00
1020System Adminstrator5,000$0.00$0.00
1021Comms / Network Engineer5,000$0.00$0.00
1022Comms / Network Technician I5,000$0.00$0.00
1023Comms / Network Technician II6,000$0.00$0.00
1024Comms / Network Technician III7,000$0.00$0.00
1025Comms / Network Technician IV7,000$0.00$0.00
1026Comms / Network Technician V6,000$0.00$0.00
1027Training Specialist5,000$0.00$0.00
1028Electronics Tech, Maintenance I40,000$0.00$0.00
1029Electronics Tech, Maintenance II40,000$0.00$0.00
1030Electronics Tech, Maintenance III40,000$0.00$0.00
1031Engineering Technician I20,000$0.00$0.00
1032Engineering Technician II30,000$0.00$0.00
1033Engineering Technician III40,000$0.00$0.00
1034Engineering Technician IV40,000$0.00$0.00
1035Engineering Technician V40,000$0.00$0.00
1036Engineering Technician VI30,000$0.00$0.00
1037Visual Information Services Technician I5,000$0.00$0.00
1038Visual Information Services Technician II10,000$0.00$0.00
1039Visual Information Services Technician III10,000$0.00$0.00
1040Visual Information Services Technician IV5,000$0.00$0.00
1041Logistics Specialist5,000$0.00$0.00
1042Logistics Technician5,000$0.00$0.00
1043Technical Writer I5,000$0.00$0.00
1044Technical Writer II5,000$0.00$0.00
1045Technical Writer III5,000$0.00$0.00
1046IT Installation Technician3,000$0.00$0.00
1047Electrician, Maintenance4,000$0.00$0.00
1048Travel and Per Diem including G&ANTE$10,000,000.00$10,000,000.00
1049Material Costs including G&ANTE$6,474,090.00$6,474,090.00
1050ODCs including G&ANTE$2,000,000.00$2,000,000.00
Total Price527,000$18,474,090.00

TOTAL ALL YEARS:

YEARHOURSCOST
Base Year:527,000$18,474,090.00
Option Year I:527,000$22,649,890.43
Option Year II:527,000$26,825,690.86
Option Year III:527,000$31,001,491.29
Option Year IV:527,000$35,177,291.72

TOTAL OF ALL YEARS: 2,635,000 $134,128,454.30

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

Yr.2 TO Pricing Year Two Task Ordering Period - 13 Months After award through 24 Months Thereafter

CLIN No.Labor & Activity DescriptionEstimated HoursOn-Site RateOff-Site RateOn-Site Total RateOff-Site Total Rate
2001Program Manager5,000$0.00$0.00
2002Project Task Manager5,000$0.00$0.00
2003Program Analyst I5,000$0.00$0.00
2004Program Analyst II5,000$0.00$0.00
2005Program Analyst III5,000$0.00$0.00
2006Program Analyst IV5,000$0.00$0.00
2007Subject Matter Expert5,000$0.00$0.00
2008Systems Engineer5,000$0.00$0.00
2009Senior Engineer5,000$0.00$0.00
2010Engineer5,000$0.00$0.00
2011Test Engineer5,000$0.00$0.00
2012Sr. Systems Analyst5,000$0.00$0.00
2013Systems Analyst5,000$0.00$0.00
2014Telecom/RF Systems Field Engineer5,000$0.00$0.00
2015Sr. Telecom/RF Systems Technician5,000$0.00$0.00
2016Integrated Systems Technician I5,000$0.00$0.00
2017Integrated Systems Technician II6,000$0.00$0.00
2018Integrated Systems Technician III7,000$0.00$0.00
2019Integrated Systems Technician IV6,000$0.00$0.00
2020System Adminstrator5,000$0.00$0.00
2021Comms / Network Engineer5,000$0.00$0.00
2022Comms / Network Technician I5,000$0.00$0.00
2023Comms / Network Technician II6,000$0.00$0.00
2024Comms / Network Technician III7,000$0.00$0.00
2025Comms / Network Technician IV7,000$0.00$0.00
2026Comms / Network Technician V6,000$0.00$0.00
2027Training Specialist5,000$0.00$0.00
2028Electronics Tech, Maintenance I40,000$0.00$0.00
2029Electronics Tech, Maintenance II40,000$0.00$0.00
2030Electronics Tech, Maintenance III40,000$0.00$0.00
2031Engineering Technician I20,000$0.00$0.00
2032Engineering Technician II30,000$0.00$0.00
2033Engineering Technician III40,000$0.00$0.00
2034Engineering Technician IV40,000$0.00$0.00
2035Engineering Technician V40,000$0.00$0.00
2036Engineering Technician VI30,000$0.00$0.00
2037Visual Information Services Technician I5,000$0.00$0.00
2038Visual Information Services Technician II10,000$0.00$0.00Yr.
2039Visual Information Services Technician III10,000$0.00$0.00
2040Visual Information Services Technician IV5,000$0.00$0.00
2041Logistics Specialist5,000$0.00$0.00
2042Logistics Technician5,000$0.00$0.00
2043Technical Writer I5,000$0.00$0.00
2044Technical Writer II5,000$0.00$0.00
2045Technical Writer III5,000$0.00$0.00
2046IT Installation Technician3,000$0.00$0.00
2047Electrician, Maintenance4,000$0.00$0.00
2048Travel and Per Diem including G&ANTE$11,000,000.00$11,000,000.00
2049Material Costs including G&ANTE$7,649,890.43$7,649,890.43
2050ODCs including G&ANTE$4,000,000.00$4,000,000.00
Total Price527,000$22,649,890.43

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

Yr.3 TO Pricing Year Three Task Ordering Period - 25 Months After award through 36 Months Thereafter

CLIN No.Labor & Activity DescriptionEstimated HoursOn-SiteOff-SiteOn-Site Total RateOff-Site Total Rate
3001Program Manager5,000$0.00$0.00
3002Project Task Manager5,000$0.00$0.00
3003Program Analyst I5,000$0.00$0.00
3004Program Analyst II5,000$0.00$0.00
3005Program Analyst III5,000$0.00$0.00
3006Program Analyst IV5,000$0.00$0.00
3007Subject Matter Expert5,000$0.00$0.00
3008Systems Engineer5,000$0.00$0.00
3009Senior Engineer5,000$0.00$0.00
3010Engineer5,000$0.00$0.00
3011Test Engineer5,000$0.00$0.00
3012Sr. Systems Analyst5,000$0.00$0.00
3013Systems Analyst5,000$0.00$0.00
3014Telecom/RF Systems Field Engineer5,000$0.00$0.00
3015Sr. Telecom/RF Systems Technician5,000$0.00$0.00
3016Integrated Systems Technician I5,000$0.00$0.00
3017Integrated Systems Technician II6,000$0.00$0.00
3018Integrated Systems Technician III7,000$0.00$0.00
3019Integrated Systems Technician IV6,000$0.00$0.00
3020System Adminstrator5,000$0.00$0.00
3021Comms / Network Engineer5,000$0.00$0.00
3022Comms / Network Technician I5,000$0.00$0.00
3023Comms / Network Technician II6,000$0.00$0.00
3024Comms / Network Technician III7,000$0.00$0.00
3025Comms / Network Technician IV7,000$0.00$0.00
3026Comms / Network Technician V6,000$0.00$0.00
3027Training Specialist5,000$0.00$0.00
3028Electronics Tech, Maintenance I40,000$0.00$0.00
3029Electronics Tech, Maintenance II40,000$0.00$0.00
3030Electronics Tech, Maintenance III40,000$0.00$0.00
3031Engineering Technician I20,000$0.00$0.00
3032Engineering Technician II30,000$0.00$0.00
3033Engineering Technician III40,000$0.00$0.00
3034Engineering Technician IV40,000$0.00$0.00
3035Engineering Technician V40,000$0.00$0.00
3036Engineering Technician VI30,000$0.00$0.00
3037Visual Information Services Technician I5,000$0.00$0.00
3038Visual Information Services Technician II10,000$0.00$0.00
3039Visual Information Services Technician III10,000$0.00$0.00
3040Visual Information Services Technician IV5,000$0.00$0.00
3041Logistics Specialist5,000$0.00$0.00
3042Logistics Technician5,000$0.00$0.00
3043Technical Writer I5,000$0.00$0.00
3044Technical Writer II5,000$0.00$0.00
3045Technical Writer III5,000$0.00$0.00
3046IT Installation Technician3,000$0.00$0.00
3047Electrician, Maintenance4,000$0.00$0.00
3048Travel and Per Diem including G&ANTE$12,000,000.00$12,000,000.00
3049Material Costs including G&ANTE$8,825,690.86$8,825,690.86
3050ODCs including G&ANTE$6,000,000.00$6,000,000.00
Total Price527,000$26,825,690.86

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

Yr.4 TO Pricing Year Four Task Ordering Period - 37 Months After award through 48 Months Thereafter

CLIN NO.fEstimated HoursOn-SiteOff-SiteOn-Site Total PriceOff-Site Total Price
4001Program Manager5,000$0.00$0.00
4002Project Task Manager5,000$0.00$0.00
4003Program Analyst I5,000$0.00$0.00
4004Program Analyst II5,000$0.00$0.00
4005Program Analyst III5,000$0.00$0.00
4006Program Analyst IV5,000$0.00$0.00
4007Subject Matter Expert5,000$0.00$0.00
4008Systems Engineer5,000$0.00$0.00
4009Senior Engineer5,000$0.00$0.00
4010Engineer5,000$0.00$0.00
4011Test Engineer5,000$0.00$0.00
4012Sr. Systems Analyst5,000$0.00$0.00
4013Systems Analyst5,000$0.00$0.00
4014Telecom/RF Systems Field Engineer5,000$0.00$0.00
4015Sr. Telecom/RF Systems Technician5,000$0.00$0.00
4016Integrated Systems Technician I5,000$0.00$0.00
4017Integrated Systems Technician II6,000$0.00$0.00
4018Integrated Systems Technician III7,000$0.00$0.00
4019Integrated Systems Technician IV6,000$0.00$0.00
4020System Adminstrator5,000$0.00$0.00
4021Comms / Network Engineer5,000$0.00$0.00
4022Comms / Network Technician I5,000$0.00$0.00
4023Comms / Network Technician II6,000$0.00$0.00
4024Comms / Network Technician III7,000$0.00$0.00
4025Comms / Network Technician IV7,000$0.00$0.00
4026Comms / Network Technician V6,000$0.00$0.00
4027Training Specialist5,000$0.00$0.00
4028Electronics Tech, Maintenance I40,000$0.00$0.00
4029Electronics Tech, Maintenance II40,000$0.00$0.00
4030Electronics Tech, Maintenance III40,000$0.00$0.00
4031Engineering Technician I20,000$0.00$0.00
4032Engineering Technician II30,000$0.00$0.00
4033Engineering Technician III40,000$0.00$0.00
4034Engineering Technician IV40,000$0.00$0.00
4035Engineering Technician V40,000$0.00$0.00
4036Engineering Technician VI30,000$0.00$0.00
4037Visual Information Services Technician I5,000$0.00$0.00
4038Visual Information Services Technician II10,000$0.00$0.00
4039Visual Information Services Technician III10,000$0.00$0.00
4040Visual Information Services Technician IV5,000$0.00$0.00
4041Logistics Specialist5,000$0.00$0.00
4042Logistics Technician5,000$0.00$0.00
4043Technical Writer I5,000$0.00$0.00
4044Technical Writer II5,000$0.00$0.00
4045Technical Writer III5,000$0.00$0.00
4046IT Installation Technician3,000$0.00$0.00
4047Electrician, Maintenance4,000$0.00$0.00
4048Travel and Per Diem including G&ANTE$13,000,000.00$13,000,000.00
4049Material Costs including G&ANTE$11,001,491.29$11,001,491.29
4050ODCs including G&ANTE$7,000,000.00$7,000,000.00
Total Price527,000$31,001,491.29

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

Yr.5 TO Pricing Year Five Task Ordering Period - 49 Months After award through 60 Months Thereafter

CLIN No.Labor & Activity DescriptionEstimated HoursOn-SiteOff-SiteOn-Site Total RateOff-Site Total Rate
5001Program Manager5,000$0.00$0.00
5002Project Task Manager5,000$0.00$0.00
5003Program Analyst I5,000$0.00$0.00
5004Program Analyst II5,000$0.00$0.00
5005Program Analyst III5,000$0.00$0.00
5006Program Analyst IV5,000$0.00$0.00
5007Subject Matter Expert5,000$0.00$0.00
5008Systems Engineer5,000$0.00$0.00
5009Senior Engineer5,000$0.00$0.00
5010Engineer5,000$0.00$0.00
5011Test Engineer5,000$0.00$0.00
5012Sr. Systems Analyst5,000$0.00$0.00
5013Systems Analyst5,000$0.00$0.00
5014Telecom/RF Systems Field Engineer5,000$0.00$0.00
5015Sr. Telecom/RF Systems Technician5,000$0.00$0.00
5016Integrated Systems Technician I5,000$0.00$0.00
5017Integrated Systems Technician II6,000$0.00$0.00
5018Integrated Systems Technician III7,000$0.00$0.00
5019Integrated Systems Technician IV6,000$0.00$0.00
5020System Adminstrator5,000$0.00$0.00
5021Comms / Network Engineer5,000$0.00$0.00
5022Comms / Network Technician I5,000$0.00$0.00
5023Comms / Network Technician II6,000$0.00$0.00
5024Comms / Network Technician III7,000$0.00$0.00
5025Comms / Network Technician IV7,000$0.00$0.00
5026Comms / Network Technician V6,000$0.00$0.00
5027Training Specialist5,000$0.00$0.00
5028Electronics Tech, Maintenance I40,000$0.00$0.00
5029Electronics Tech, Maintenance II40,000$0.00$0.00
5030Electronics Tech, Maintenance III40,000$0.00$0.00
5031Engineering Technician I20,000$0.00$0.00
5032Engineering Technician II30,000$0.00$0.00
5033Engineering Technician III40,000$0.00$0.00
5034Engineering Technician IV40,000$0.00$0.00
5035Engineering Technician V40,000$0.00$0.00
5036Engineering Technician VI30,000$0.00$0.00
5037Visual Information Services Technician I5,000$0.00$0.00
5038Visual Information Services Technician II10,000$0.00$0.00
5039Visual Information Services Technician III10,000$0.00$0.00
5040Visual Information Services Technician IV5,000$0.00$0.00
5041Logistics Specialist5,000$0.00$0.00
5042Logistics Technician5,000$0.00$0.00
5043Technical Writer I5,000$0.00$0.00
5044Technical Writer II5,000$0.00$0.00
5045Technical Writer III5,000$0.00$0.00
5046IT Installation Technician3,000$0.00$0.00
5047Electrician, Maintenance4,000$0.00$0.00
5048Travel and Per Diem including G&ANTE$15,000,000.00$15,000,000.00
5049Material Costs including G&ANTE$12,177,291.72$12,177,291.72
5050ODCs including G&ANTE$8,000,000.00$8,000,000.00
Total Price527,000$35,177,291.72

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

Pricing Summary

ATTACHMENT 2: PRICING SPREADSHEET (SUMMARY)

CALENDAR YEARS ONE THRU FIVE EST LABOR HOURS: TOTAL LABOR/YEAR : TOTAL CALENDAR YEAR (CY) ONE THRU FIVE PROPOSED PRICING:

Yr. 1 TO Pricing 527,000 $0.00 $0.00

Yr. 2 TO Pricing 527,000 $0.00 $0.00

Yr. 3 TO Pricing 527,000 $0.00 $0.00

Yr. 4 TO Pricing 527,000 $0.00 $0.00

Yr. 5 TO Pricing 527,000 $0.00 $0.00

SUBTOTAL (LABOR): 2,635,000 $0.00 $0.00

TRAVEL AND PER DIEM: NTE $61,000,000.00

MATERIAL COSTS: NTE $46,128,454.30

ODC COSTS: NTE $27,000,000.00

SUBTOTAL (ODCs): $134,128,454.30

TOTAL PROPOSED PRICE: $134,128,454.30

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