Attachment_2_-_Task_Table_TFP_15Nov2018.xlsx

XLSX spreadsheet 137 KB Posted

Attached to
Electrical Safety Assessments, Repairs Program, Materials Management and Control Services for U. S. Forces-Afghanistan (USFOR-A) Task Force POWER
Solicitation number
W912DY-19-R-XXX1
Issued by

About this file

From the source

Attachment 2 - Task Table dated 15 November 2018

View the file

Other files

File Type Posted
TF_POWER_addtl_questions.pdf PDF
Consolidated_Questions_TFP_15Nov2018.pdf PDF
Attachment_1_-_Performance_Work_Statement_TFP_15Nov2018.docx DOCX document
AMENDMENT_1_-_Combined_Synopsis-Sol_TF_POWER.PDF PDF
Attachment_6_-_Class_Deviation_2017-O0004.pdf PDF
Attachment_4_-_CENTCOM_Clauses.docx DOCX document
Attachment_2_-_Task_Table_Task_Force_POWER.xlsx XLSX spreadsheet
PWS_Attachment_B_-_GFP_List_-_TFP_as_of_29_Oct_18.xlsx XLSX spreadsheet
Attachment_1_-_TF_POWER_Afghan_PWS_Final_02Nov18.docx DOCX document
PWS_Attachment_A_-_UFC_3-520-01_Appendix_D-2.pdf PDF
Attachment_3_-_FY19_TF_POWER_QASP.DOCX DOCX document
Attachment_5_-_Class_Deviation_2017-O0003.pdf PDF
Combined_Synopsis-Sol_TF_POWER.PDF PDF
Show all 13

On GovTribe

Work with this file

  • 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.

Task Table (Pricing Summary)

Task Force POWER - Afghanistan - FY2019Task Force POWER - AfghanistanTask Force POWER - Afghanistan
Base Year Task TableOption Year 1 Task TableOption Year 2 Task Table
CLINTaskDescriptionTypeUnit# Units# MonthsPrice / unitTotalCLINTaskDescriptionTypeUnit# Units# monthsPrice / unitTotalCLINTaskDescriptionTypeUnit# Units# monthsPrice / unitTotal
1Initial Reports, Phase-in (60 days), and MobilizationFFP1Initial Reports, Phase-in (60 days), and Mobilization1Initial Reports, Phase-in (60 days), and Mobilization
0001Initial Reports and Phase-inFFPEach1N/A$ - 01001Initial Reports and Phase-in2001Initial Reports and Phase-in
0002Mobilization Teams (Up to 20). Include Key Personnel and Support PersonnelFFPEach20N/A$ - 01002Mobilization Teams (Up to 20). Include Key Personnel and Support PersonnelFFPEach20N/A$ - 02002Mobilization Teams (Up to 20). Include Key Personnel and Support PersonnelFFPEach20N/A$ - 0
0003Option: Mobilization (per laborer) Up to 20. Include any additional support personnel.FFPEach20N/A$ - 01003Option: Mobilization (per laborer) Up to 20. Include any additional support personnel.FFPEach20N/A$ - 02003Option: Mobilization (per laborer) Up to 20. Include any additional support personnel.FFPEach20N/A$ - 0
2Electrical Assessment, Update and Repairs (Elecrical Teams and Laborers)FFP2Electrical Assessment, Update and Repairs (Elecrical Teams and Laborers)FFPMonth2Electrical Assessment, Update and Repairs (Elecrical Teams and Laborers)FFPMonth
00042ABase (Monthly cost per two person team) * 15 Teams for 12 months, include Key Personnel and Support PersonnelFFPTeam / Month1512$ - 010042ABase (Monthly cost per two person team) * 15 Teams for 12 months, include Key Personnel and Support PersonnelFFPTeam / Month1512$ - 020042ABase (Monthly cost per two person team) * 15 Teams for 12 months, include Key Personnel and Support PersonnelFFPTeam / Month1512$ - 0
00052BOption: Additional Teams (Monthly cost per two person team) * Up to 5 Teams/Up to 12 months, include any additional support personnelFFPTeam / Month512$ - 010052BOption: Additional Teams (Monthly cost per two person team) * Up to 5 Teams/Up to 12 months, include any additional support personnelFFPTeam / Month512$ - 020052BOption: Additional Teams (Monthly cost per two person team) * Up to 5 Teams/Up to 12 months, include any additional support personnelFFPTeam / Month512$ - 0
00062COption: 20 Laborers (Monthly cost per person) * Up to 20 Laborers/Up to 12 Months, include additional support personnelFFPPerson / Month2012$ - 010062COption: 20 Laborers (Monthly cost per person) * Up to 20 Laborers/Up to 12 Months, include additional support personnelFFPPerson / Month2012$ - 020062COption: 20 Laborers (Monthly cost per person) * Up to 20 Laborers/Up to 12 Months, include additional support personnelFFPPerson / Month2012$ - 0
00073Electrical Bill Of Materials (EBOM) FFP Over & AboveFFPEach1N/A$ 750,000.00$ 750,000.0010073Electrical Bill Of Materials (EBOM) FFP Over & AboveFFPEach1N/A$ 750,000.00$ 750,000.0020073Electrical Bill Of Materials (EBOM) FFP Over & AboveFFPEach1N/A$ 750,000.00$ 750,000.00
00084Other Direct Costs (ODC) FFP Over & AboveFFPEach1N/A$ 350,000.00$ 350,000.0010084Other Direct Costs (ODC) FFP Over & AboveFFPEach1N/A$ 350,000.00$ 350,000.0020084Other Direct Costs (ODC) FFP Over & AboveFFPEach1N/A$ 350,000.00$ 350,000.00
5Phase Out (30 days) and DemobilizationFFP5Phase Out (30 days) and DemobilizationFFPEach15Phase Out (30 days) and DemobilizationFFPEach1
0009Phase-outFFPEach1N/A$ - 01009Phase-out2009Phase-out
0010Demobilization (per two person team) Up to 20, Include Key Personnel, Support PersonnelFFPEach20N/A$ - 01010Demobilization (per two person team) Up to 20, Include Key Personnel, Support Personnel20N/A$ - 02010Demobilization (per two person team) Up to 20, Include Key Personnel, Support Personnel20N/A$ - 0
0011Option: Demobilization (per laborer) Up to 20, Include any additional support personnel.FFPEach20N/A$ - 01011Option: Demobilization (per laborer) Up to 20, Include any additional support personnel.20N/A$ - 02011Option: Demobilization (per laborer) Up to 20, Include any additional support personnel.20N/A$ - 0
00126Contractor Manpower And ReportingFFPEach1N/A$ - 010126Contractor Manpower And ReportingFFPEach1N/A$ - 020126Contractor Manpower And ReportingFFPEach1N/A$ - 0
TotalTotalTotal
*Note: To avoid miscalculation and determine the Monthly Cost Per Team (or Per Laborer), Per Month, the Contractor should calculate the yearly cost first, then divide by months(12) and then by Units (5,15,or 20).*Note: To avoid miscalculation and determine the Monthly Cost Per Team (or Per Laborer), Per Month, the Contractor should calculate the yearly cost first, then divide by months(12) and then by Units (5,15,or 20).*Note: To avoid miscalculation and determine the Monthly Cost Per Team (or Per Laborer), Per Month, the Contractor should calculate the yearly cost first, then divide by months(12) and then by Units (5,15,or 20).

WERS Contract No. W912DY-10-D-0015 Environmental Protection Support CENTCOM Area of Responsibility

Tetra Tech EC, Inc., 31 October 2016 Use or disclosure of data contained on this sheet is subject to the restriction on the title page of this proposal.

Mapping

TaskPI - 1-60Day 61-150Day 151-240Day 241 - 330Day 331-420
1104A12A5A7A8A4A22E5A44A32I5A84B3A5B4C6A5C102B5A17B8B2F5A52J5A93B5B16B5C1102C5A27C8C2G5A62K5A103C5B26C5C2102D5A37D
1ERROR:#REF!
4A1ERROR:#REF!
2AERROR:#REF!
5AERROR:#REF!
7AERROR:#REF!
8AERROR:#REF!
2BERROR:#REF!
5A1ERROR:#REF!
7BERROR:#REF!
8BERROR:#REF!
2CERROR:#REF!
5A2ERROR:#REF!
7CERROR:#REF!
8CERROR:#REF!
2DERROR:#REF!
5A3ERROR:#REF!
7DERROR:#REF!
8D
4A2ERROR:#REF!
2EERROR:#REF!
5A4ERROR:#REF!
7AERROR:#REF!
8AERROR:#REF!
2FERROR:#REF!
5A5ERROR:#REF!
7BERROR:#REF!
8BERROR:#REF!
2GERROR:#REF!
5A6ERROR:#REF!
7CERROR:#REF!
8CERROR:#REF!
2H
5A7
7DERROR:#REF!
8D
4A3ERROR:#REF!
2IERROR:#REF!
5A8ERROR:#REF!
7AERROR:#REF!
8AERROR:#REF!
2JERROR:#REF!
5A9ERROR:#REF!
7BERROR:#REF!
8BERROR:#REF!
2KERROR:#REF!
5A10ERROR:#REF!
7CERROR:#REF!
8CERROR:#REF!
2L
5A11
7DERROR:#REF!
8D
4BERROR:#REF!
3AERROR:#REF!
5BERROR:#REF!
7AERROR:#REF!
8AERROR:#REF!
3BERROR:#REF!
5B1ERROR:#REF!
7BERROR:#REF!
8BERROR:#REF!
3CERROR:#REF!
5B2ERROR:#REF!
7CERROR:#REF!
8CERROR:#REF!
3D
5B3
7DERROR:#REF!
8D
4CERROR:#REF!
6AERROR:#REF!
5CERROR:#REF!
7AERROR:#REF!
8AERROR:#REF!
6BERROR:#REF!
5C1ERROR:#REF!
7BERROR:#REF!
8BERROR:#REF!
6CERROR:#REF!
5C2ERROR:#REF!
7CERROR:#REF!
8CERROR:#REF!
6D
5C3
7DERROR:#REF!
8D
9
10ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
1104A12A5A7A8A4A22E5A44A32I5A84B3A5B4C6A5C102B5A17B8B2F5A52J5A93B5B16B5C1102C5A27C8C2G5A62K5A103C5B26C5C2102D5A37D
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Task 9ERROR:#REF!ERROR:#REF!
Task 10ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

Rate Comparison

PositionsBase Rate ($/hr)Loaded Rate ($/hr)Loaded Rate ($/hr) with ProfitLoaded Rate ($/hr) with Danger Pay & Post Differential Premium UpliftsLoaded Rate ($/hr) with Danger Pay & Post Differential Premium Uplifts, and Profit
CONUS PersonnelURSKSINetURSKSINetURSKSINetURSKSINetURSKSINet
ERROR:#REF!ERROR:#REF!$67.50ERROR:#REF!ERROR:#REF!$93.56ERROR:#REF!ERROR:#REF!$102.91ERROR:#REF!
ERROR:#REF!ERROR:#REF!$65.00ERROR:#REF!ERROR:#REF!$90.38ERROR:#REF!ERROR:#REF!$99.41ERROR:#REF!
ERROR:#REF!ERROR:#REF!$50.00ERROR:#REF!ERROR:#REF!$70.51ERROR:#REF!ERROR:#REF!$77.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$53.00ERROR:#REF!ERROR:#REF!$74.52ERROR:#REF!ERROR:#REF!$81.98ERROR:#REF!
ERROR:#REF!ERROR:#REF!$38.00ERROR:#REF!ERROR:#REF!$54.44ERROR:#REF!ERROR:#REF!$59.88ERROR:#REF!
ERROR:#REF!ERROR:#REF!$24.00ERROR:#REF!ERROR:#REF!$35.69ERROR:#REF!ERROR:#REF!$39.26ERROR:#REF!
ERROR:#REF!ERROR:#REF!$46.00ERROR:#REF!ERROR:#REF!$65.15ERROR:#REF!ERROR:#REF!$71.67ERROR:#REF!
ERROR:#REF!ERROR:#REF!$64.00ERROR:#REF!ERROR:#REF!$89.25ERROR:#REF!ERROR:#REF!$98.18ERROR:#REF!
ERROR:#REF!ERROR:#REF!$27.50ERROR:#REF!ERROR:#REF!$40.38ERROR:#REF!ERROR:#REF!$44.42ERROR:#REF!
ERROR:#REF!ERROR:#REF!$30.00ERROR:#REF!ERROR:#REF!$43.73ERROR:#REF!ERROR:#REF!$48.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$24.00ERROR:#REF!ERROR:#REF!$35.69ERROR:#REF!ERROR:#REF!$39.26ERROR:#REF!
ERROR:#REF!ERROR:#REF!$38.00ERROR:#REF!ERROR:#REF!$54.44ERROR:#REF!ERROR:#REF!$59.88ERROR:#REF!
ERROR:#REF!ERROR:#REF!$30.00ERROR:#REF!ERROR:#REF!$43.73ERROR:#REF!ERROR:#REF!$48.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$31.00ERROR:#REF!ERROR:#REF!$44.73ERROR:#REF!ERROR:#REF!$49.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$32.00ERROR:#REF!ERROR:#REF!$45.73ERROR:#REF!ERROR:#REF!$50.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$33.00ERROR:#REF!ERROR:#REF!$46.73ERROR:#REF!ERROR:#REF!$51.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$34.00ERROR:#REF!ERROR:#REF!$47.73ERROR:#REF!ERROR:#REF!$52.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$35.00ERROR:#REF!ERROR:#REF!$48.73ERROR:#REF!ERROR:#REF!$53.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$36.00ERROR:#REF!ERROR:#REF!$49.73ERROR:#REF!ERROR:#REF!$54.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$37.00ERROR:#REF!ERROR:#REF!$50.73ERROR:#REF!ERROR:#REF!$55.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$38.00ERROR:#REF!ERROR:#REF!$51.73ERROR:#REF!ERROR:#REF!$56.10ERROR:#REF!
ERROR:#REF!ERROR:#REF!$39.00ERROR:#REF!ERROR:#REF!$52.73ERROR:#REF!ERROR:#REF!$57.10ERROR:#REF!
OCONUS Personnel
ERROR:#REF!ERROR:#REF!$44.00ERROR:#REF!ERROR:#REF!$59.37ERROR:#REF!ERROR:#REF!$78.69ERROR:#REF!ERROR:#REF!$86.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$45.00ERROR:#REF!ERROR:#REF!$60.37ERROR:#REF!ERROR:#REF!$79.69ERROR:#REF!ERROR:#REF!$87.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$46.00ERROR:#REF!ERROR:#REF!$61.37ERROR:#REF!ERROR:#REF!$80.69ERROR:#REF!ERROR:#REF!$88.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$47.00ERROR:#REF!ERROR:#REF!$62.37ERROR:#REF!ERROR:#REF!$81.69ERROR:#REF!ERROR:#REF!$89.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$48.00ERROR:#REF!ERROR:#REF!$63.37ERROR:#REF!ERROR:#REF!$82.69ERROR:#REF!ERROR:#REF!$90.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$49.00ERROR:#REF!ERROR:#REF!$64.37ERROR:#REF!ERROR:#REF!$83.69ERROR:#REF!ERROR:#REF!$91.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$50.00ERROR:#REF!ERROR:#REF!$65.37ERROR:#REF!ERROR:#REF!$84.69ERROR:#REF!ERROR:#REF!$92.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$51.00ERROR:#REF!ERROR:#REF!$66.37ERROR:#REF!ERROR:#REF!$85.69ERROR:#REF!ERROR:#REF!$93.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$52.00ERROR:#REF!ERROR:#REF!$67.37ERROR:#REF!ERROR:#REF!$86.69ERROR:#REF!ERROR:#REF!$94.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$53.00ERROR:#REF!ERROR:#REF!$68.37ERROR:#REF!ERROR:#REF!$87.69ERROR:#REF!ERROR:#REF!$95.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$54.00ERROR:#REF!ERROR:#REF!$69.37ERROR:#REF!ERROR:#REF!$88.69ERROR:#REF!ERROR:#REF!$96.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$55.00ERROR:#REF!ERROR:#REF!$70.37ERROR:#REF!ERROR:#REF!$89.69ERROR:#REF!ERROR:#REF!$97.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$56.00ERROR:#REF!ERROR:#REF!$71.37ERROR:#REF!ERROR:#REF!$90.69ERROR:#REF!ERROR:#REF!$98.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$57.00ERROR:#REF!ERROR:#REF!$72.37ERROR:#REF!ERROR:#REF!$91.69ERROR:#REF!ERROR:#REF!$99.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$58.00ERROR:#REF!ERROR:#REF!$73.37ERROR:#REF!ERROR:#REF!$92.69ERROR:#REF!ERROR:#REF!$100.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$59.00ERROR:#REF!ERROR:#REF!$74.37ERROR:#REF!ERROR:#REF!$93.69ERROR:#REF!ERROR:#REF!$101.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$60.00ERROR:#REF!ERROR:#REF!$75.37ERROR:#REF!ERROR:#REF!$94.69ERROR:#REF!ERROR:#REF!$102.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$61.00ERROR:#REF!ERROR:#REF!$76.37ERROR:#REF!ERROR:#REF!$95.69ERROR:#REF!ERROR:#REF!$103.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$62.00ERROR:#REF!ERROR:#REF!$77.37ERROR:#REF!ERROR:#REF!$96.69ERROR:#REF!ERROR:#REF!$104.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$63.00ERROR:#REF!ERROR:#REF!$78.37ERROR:#REF!ERROR:#REF!$97.69ERROR:#REF!ERROR:#REF!$105.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$64.00ERROR:#REF!ERROR:#REF!$79.37ERROR:#REF!ERROR:#REF!$98.69ERROR:#REF!ERROR:#REF!$106.56ERROR:#REF!
ERROR:#REF!ERROR:#REF!$65.00ERROR:#REF!ERROR:#REF!$80.37ERROR:#REF!ERROR:#REF!$99.69ERROR:#REF!ERROR:#REF!$107.56ERROR:#REF!

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.