Section_L_-_Attachment_8_-_Total_Evaluated_Price_Workbook_(locked)_FINAL _rev_2.xlsx

XLSX spreadsheet 541 KB Posted

Attached to
N-ITSS RFP
Solicitation number
FA8604-16-R-7000
Issued by

About this file

Updated Attachment 8 TEP Workbook

View the file

Other files

File Type Posted
28_Jan_16_-_Government_Response.docx DOCX document
26_Jan_16_-_Government_Response.docx DOCX document
N-ITSS_Section_L_v8 _rev_2.docx DOCX document
N-ITSS_Section_M_PPT_v10 _rev_2.docx DOCX document
14_Jan_16_-_Government_Response.docx DOCX document
Section_L_-_Attachment_4_-_Past_Performance_Questionnaire _rev_2.docx DOCX document
Section_L_-_Attachment_8_-_Total_Evaluated_Price_Workbook_(locked)_FINAL _rev_1.xlsx XLSX spreadsheet
Section_L_-_Attachment_9_-_Past_Performance_Teaming_Matrix _rev_1.xlsx XLSX spreadsheet
11_Jan_16_-_Government_Response.docx DOCX document
N-ITSS_Section_L_v8 _rev_1.docx DOCX document
Section_L_-_Attachment_4_-_Past_Performance_Questionnaire _rev_1.docx DOCX document
ppi_tool.accdb —
N-ITSS_Section_M_PPT_v10 _rev_1.docx DOCX document
N-ITSS_PWS_Task_Order_2_GSP_v8 _rev_1.docx DOCX document
22_Dec_-_Government_Response.docx DOCX document
Section_L_-_Attachment_6_-_Past_Performance_Consent_Letter.docx DOCX document
Section_L_-_Attachment_8_-_Total_Evaluated_Price_Workbook_(locked)_FINAL.xlsx XLSX spreadsheet
Section_L_-_Attachment_7_-_Skills-to-Technology_Matrix.xlsx XLSX spreadsheet
N-ITSS_PWS_Task_Order_1_SC.pdf PDF
N-ITSS_IDIQ_PWS.pdf PDF
N-ITSS_CDRL_A002.pdf PDF
Section_L_-_Attachment_4_-_Past_Performance_Questionnaire.docx DOCX document
Section_L_-_Attachment_1_-_Cross_Reference_Matrix.docx DOCX document
N-ITSS_Section_L_v8.docx DOCX document
N-ITSS_CDRL_A001.pdf PDF
N-ITSS_PWS_Task_Order_2_GSP.pdf PDF
N-ITSS_CDRL_A005.pdf PDF
N-ITSS_CDRL_A004.pdf PDF
N-ITSS_PWS_Task_Order_3_SO.pdf PDF
Section_L_-_Attachment_2_-_Past_Peformance_Information_Tool.docx DOCX document
N-ITSS_CDRL_A003.pdf PDF
Section_L_-_Attachment_3_-_Past_Performance_Cover_Letter.docx DOCX document
Section_L_-_Attachment_9_-_Past_Performance_Teaming_Matrix.xlsx XLSX spreadsheet
FA8604-16-R-7000_(12-9-15)_for_FBO_POSTING.pdf PDF
N-ITSS_Section_M_PPT_v10.docx DOCX document
Section_L_-_Attachment_5_-_Past_Performance_Client_Authorization_Letter.docx DOCX document
N-ITSS_CDRL_A006.pdf PDF
Show all 37

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Summary TEP

Total Evaluated Price (TEP)
The TEP will be your summation of all five years for all three task orders for Labor, Equipment & Material, Travel, and Emergency Support.

At least 50% of the labor cost must be incurred by the Prime.

Instructions:

1) Go to 'Contractor Labor Rates Summary' tab and insert labor categories (examples highlighted in yellow) and fully burdened hourly labor rates (prime and subcontractor) for each functional area. All labor categories required for each of the three task orders should be included here. The labor category and fully burdented labor rates for each year will be added to Section J of the IDIQ with the award of the contract.

2) Go to the 'Transition Price (TO 1)' tab and insert the full burdened hourly labor rate (highlighted orange) for each of the functional SME's that will be utilized during the first 30 day transition time period (IAW Task Order 1 PWS section 11). Fully burdented hourly labor rates shall coincide with 'Contractor Labor Rates Summary' tab.

3) Go to each of the three Proposal Labor Price tabs and insert Contractor Labor Category, FTE quantity (# of employees) needed for that labor category within each functional area and the fully burdened hourly labor rate. Contractor Labor Category should align with the 'Contractor Labor Rates Summary' tab previously filled out. Also in tabs four through six, provide the fully burdened hourly labor rates for years two through five with the assumption that the number of contractors and functional areas will remain the same for each year for each of the three task orders. Year 1 for Task Order 1 is based on 1,760 hours due to 30 day transition period. All other years are based on 1,920 hours per year. Transition price for task orders 2 and 3 are included in the Year 1 (12 month) period. Based on your inputs to FTE quantity and fully burdened hourly labor rate, the yearly price will be automatically calculated using embedded Excel forumlas.

All data provided in tabs two through six will automatically roll up into tab one (Summary TEP) to show your Total Evaluated Price using embedded Excel formulas.

NOTE: Equipment & Material, Travel, and Emergency Support are Government provided Cost CLINs on the contract having not to exceed (NTE) dollar amounts and they are provided below, which are automatically calculated into your TEP.

CLIN STRUCTURE: LABOR WILL BE FIRM FIXED PRICE; EQUIPMENT & MATERIAL, TRAVEL AND SURGE ARE GOVERNMENT PROVIDED COST CLINS.

TASK ORDER 1LABOREQUIPMENT & MATERIALTRAVELEMERGENCY
SUPPORTTOTAL
Year 1$ - 0

TylerOda: Government:

Includes transition price$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 2$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 3$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 4$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 5$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Task Order 1 Total$ 3,550,000.00
TASK ORDER 2LABOREQUIPMENT & MATERIALTRAVELEMERGENCY
SUPPORTTOTAL
Year 1$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 2$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 3$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 4$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Year 5$ - 0$ 200,000.00$ 10,000.00$ 500,000.00$ 710,000.00
Task Order 2 Total$ 3,550,000.00
TASK ORDER 3LABOREQUIPMENT & MATERIALTRAVELEMERGENCY
SUPPORTTOTAL
Year 1$ - 0$ 200,000.00$ 10,000.00$ 200,000.00$ 410,000.00
Year 2$ - 0$ 200,000.00$ 10,000.00$ 200,000.00$ 410,000.00
Year 3$ - 0$ 200,000.00$ 10,000.00$ 200,000.00$ 410,000.00
Year 4$ - 0$ 200,000.00$ 10,000.00$ 200,000.00$ 410,000.00
Year 5$ - 0$ 200,000.00$ 10,000.00$ 200,000.00$ 410,000.00
Task Order 3 Total$ 2,050,000.00

Total Evaluated Price $ 9,150,000.00

Contractor Labor Rates Summary

Contractor Fully Burdened Labor Rates Summary
* Fully Burdened Hourly Labor Rates

** These are examples of Contractor Labor Categories. Contractor is permitted to propose a different mix of labor categories.

Note: The labor category and labor rates for each year will be added to Section J of the IDIQ with the award of the contract.

Note: Insert rows to add additional contractor labor categories as needed.

Government Functional Area (from Task Order PWSs)Contractor Labor CategoryPrime or Sub?Year 1
Hourly Rate*Year 2
Hourly Rate*Year 3
Hourly Rate*Year 4
Hourly Rate*Year 5

Hourly Rate*

Communication Focal Point Support (24/7 Ops)e.g. Senior Service Desk Specialist**
Infrastructure Engineering and Installation and Network Technicane.g. Senior Infrastructure Specialist**
Infrastructure Engineering and Installation and Network Technicane.g. Junior Infrastructure Specialist**
Hardware Technician (Desktop, Peripherals & Datacenter Support)
System Administration (Windows)
System Administration (Windows)
System Administration (RHEL/Solaris/Linux)
System Administration (RHEL/Solaris/Linux)
Storage and Enterprise Backup Services
VTC Operations
Multimedia Hardware Technician
Software Testing Support (Windows/RHEL/Solaris/Linux)
GSP Helpdesk Support
Network Administration
Systems Engineer
Security Engineer Support
Data Center Support Engineer
Physical Access Control System & Intrusion Detection System Support
Program Manager
Task Order Manager

Transition Price (TO 1)

Contractor Fully Burdened Labor Rates Summary
Task Order 1 Transition PriceFTE Quantity (# of Employees)Hours per MonthHourly Labor Rate*30 Day Price
Task Order Manager1160$0.00$0.00
3.1 Communications Focal Point (24/7 Ops) SME1160$0.00$0.00
3.2 Infrastructure Engineering SME1160$0.00$0.00
3.4 System Administration SME1160$0.00$0.00
3.4 Exchange SME1160$0.00$0.00
3.5 Storage and Enterprise Backup Services SME1160$0.00$0.00
3.6 VTC Operations1160$0.00$0.00
Total Transition Price (First 30 Days)7$0.00

* Fully Burdened Hourly Labor Rates

Proposal Labor Price (TO 1) Proposal Labor Price: Task Order 1

Labor CategoryFTE Quantity (# of Employees)Year 1 HoursYear 1
Hourly Rate*Year 1 Price
(11 Months)Year 2 HoursYear 2
Hourly Rate*Year 2 Price (12 Months)Year 3 HoursYear 3
Hourly Rate*Year 3 Price (12 Months)Year 4 HoursYear 4
Hourly Rate*Year 4 Price (12 Months)Year 5 HoursYear 5
Hourly Rate*Year 5 Price (12 Months)
3.1 Communications Focal Point (24/7 Ops)
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.2 Infrastructure Engineering and Installation and Network Technican
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.3 Hardware Technican (Desktops, Peripherals & Data Center)
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.4 System Administration
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.5 Storage and Enterprise Backup Services
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.6 VTC Operations
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.7 Multimedia Hardware Technician
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.8 Software Testing Support
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
5.8 Program Manager & Task Order Manager
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
1760$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
Total (per PoP)$0.00$0.00$0.00$0.00$0.00$0.00

* Fully Burdened Hourly Labor Rates shall coincide with hourly rates on 'Contractor Labor Rates Summary' tab.

Proposal Labor Price (TO 2) Proposal Labor Price: Task Order 2

Labor CategoryFTE Quantity (# of Employees)Year 1 HoursYear 1
Hourly Rate*Year 1 Price
(12 Months)Year 2 HoursYear 2
Hourly Rate*Year 2 Price (12 Months)Year 3 HoursYear 3
Hourly Rate*Year 3 Price (12 Months)Year 4 HoursYear 4
Hourly Rate*Year 4 Price (12 Months)Year 5 HoursYear 5
Hourly Rate*Year 5 Price (12 Months)
3.1 GSP Helpdesk Support
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.2 Network Administration (Network Hardware Support)
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.3 Hardware Technician
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.4 System Administration (Windows)
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.5 System Administration (RHEL/Unix/Linux/Solaris)
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.6 Storage and Backup Administration
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.7 Systems Engineer
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.8 Security Engineer Support
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
3.9 Data Center Support Engineer
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
5.8 Program Manager & Task Order Manager
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
Total (per PoP)$0.00$0.00$0.00$0.00$0.00$0.00

* Fully Burdened Hourly Labor Rates shall coincide with hourly rates on 'Contractor Labor Rates Summary' tab.

Proposal Labor Price (TO 3) Proposal Labor Price: Task Order 3

Contractor Labor CategoryFTE Quantity (# of Employees)Year 1 HoursYear 1
Hourly Rate*Year 1 Price
(12 Months)Year 2 HoursYear 2
Hourly Rate*Year 2 Price (12 Months)Year 3 HoursYear 3
Hourly Rate*Year 3 Price (12 Months)Year 4 HoursYear 4
Hourly Rate*Year 4 Price (12 Months)Year 5 HoursYear 5
Hourly Rate*Year 5 Price (12 Months)
3.1 Physical Access Control/Instrusion Detection Support
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
5.8 Program Manager & Task Order Manager
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
1920$0.001920$0.001920$0.001920$0.001920$0.00
Functional Area Total0.00$0.00$0.00$0.00$0.00$0.00
Total (per PoP)$0.00$0.00$0.00$0.00$0.00$0.00

* Fully Burdened Hourly Labor Rates shall coincide with hourly rates on 'Contractor Labor Rates Summary' tab.

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