Section_L_-_Attachment_8_-_Total_Evaluated_Price_Workbook_(locked)_FINAL.xlsx

XLSX spreadsheet 531 KB Posted Dec 10, 2015

Attached to: N-ITSS RFP
Solicitation number: FA8604-16-R-7000
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

From the source

Attachment 8 - TEP Workbook

View the file

Other files

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

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 1	LABOR	EQUIPMENT & MATERIAL	TRAVEL	EMERGENCY
SUPPORT	TOTAL
	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 2	LABOR	DIRECT COSTS	TRAVEL	EMERGENCY
SUPPORT	TOTAL
	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 3	LABOR	DIRECT COSTS	TRAVEL	EMERGENCY
SUPPORT	TOTAL
	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 Category	Prime 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 Technican	e.g. Senior Infrastructure Specialist**
Infrastructure Engineering and Installation and Network Technican	e.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 Price	FTE Quantity (# of Employees)	Hours per Month	Hourly Labor Rate*	30 Day Price
Task Order Manager	1	160	$0.00	$0.00
3.1 Communications Focal Point (24/7 Ops) SME	1	160	$0.00	$0.00
3.2 Infrastructure Engineering SME	1	160	$0.00	$0.00
3.4 System Administration SME	1	160	$0.00	$0.00
3.4 Exchange SME	1	160	$0.00	$0.00
3.5 Storage and Enterprise Backup Services SME	1	160	$0.00	$0.00
3.6 VTC Operations	1	160	$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 Category	FTE Quantity (# of Employees)	Year 1 Hours	Year 1
Hourly Rate*	Year 1 Price
(11 Months)	Year 2 Hours	Year 2
Hourly Rate*	Year 2 Price (12 Months)	Year 3 Hours	Year 3
Hourly Rate*	Year 3 Price (12 Months)	Year 4 Hours	Year 4
Hourly Rate*	Year 4 Price (12 Months)	Year 5 Hours	Year 5
Hourly Rate*	Year 5 Price (12 Months)
	3.1 Communications Focal Point (24/7 Ops)
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.2 Infrastructure Engineering and Installation and Network Technican
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.3 Hardware Technican (Desktops, Peripherals & Data Center)
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.4 System Administration
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.5 Storage and Enterprise Backup Services
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.6 VTC Operations
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.7 Multimedia Hardware Technician
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.8 Software Testing Support
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	5.8 Program Manager & Task Order Manager
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1760		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.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 Category	FTE Quantity (# of Employees)	Year 1 Hours	Year 1
Hourly Rate*	Year 1 Price
(12 Months)	Year 2 Hours	Year 2
Hourly Rate*	Year 2 Price (12 Months)	Year 3 Hours	Year 3
Hourly Rate*	Year 3 Price (12 Months)	Year 4 Hours	Year 4
Hourly Rate*	Year 4 Price (12 Months)	Year 5 Hours	Year 5
Hourly Rate*	Year 5 Price (12 Months)
	3.1 GSP Helpdesk Support
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.2 Network Administration (Network Hardware Support)
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.3 Hardware Technician
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.4 System Administration (Windows)
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.5 System Administration (RHEL/Unix/Linux/Solaris)
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.6 Storage and Backup Administration
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.7 Systems Engineer
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.8 Security Engineer Support
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	3.9 Data Center Support Engineer
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	5.8 Program Manager & Task Order Manager
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.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 Category	FTE Quantity (# of Employees)	Year 1 Hours	Year 1
Hourly Rate*	Year 1 Price
(12 Months)	Year 2 Hours	Year 2
Hourly Rate*	Year 2 Price (12 Months)	Year 3 Hours	Year 3
Hourly Rate*	Year 3 Price (12 Months)	Year 4 Hours	Year 4
Hourly Rate*	Year 4 Price (12 Months)	Year 5 Hours	Year 5
Hourly Rate*	Year 5 Price (12 Months)
	3.1 Physical Access Control/Instrusion Detection Support
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.00			$0.00		$0.00		$0.00		$0.00		$0.00
	5.8 Program Manager & Task Order Manager
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
			1920		$0.00	1920	$0.00	1920	$0.00	1920	$0.00	1920	$0.00
	Functional Area Total	0.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 Nov 14, 2017.