Attachment_2_CE_Lab_Support_Labor_Block_Princing_Schedule.xlsx

XLSX spreadsheet 30 KB Posted May 6, 2016

Attached to: CIVIL ENGINEER FACILITY AND EQUIPMENT SUPPORT TO INTELLIGENCE AND RESEARCH AND DEVELOPMENT ACTIVITIES
Solicitation number: FA8601-16-R-0002
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

From the source

CE Lab Support Labor Block Pricing Schedule with corrected links

View the file

Other files

File	Type	Posted
Attachment_2_CE_Lab_Support_Labor_Block_Princing_Schedule.xlsx	XLSX spreadsheet	May 18, 2016
Attachment_5_V2__SCA_Wage_Determination_05-2419.pdf	PDF	May 6, 2016
Attachment_12_Facility_Tools_List.xlsx	XLSX spreadsheet	May 6, 2016
Attachment_11_WPAFB_PMTLs.xlsx	XLSX spreadsheet	May 6, 2016
Attachment_3_CE_Lab_Support_Contract_-_Equipment_List_dated_27_Apr_2016.pdf	PDF	May 6, 2016
Responses_to_Site_Visit_Questions.pdf	PDF	May 6, 2016
Attachment_1_PWS_APPENDIX_C-_Amendment.pdf	PDF	Apr 22, 2016
Attachment_4_FA8601-16-R-0002.pdf	PDF	Apr 20, 2016
Attachment_10_Contactor_Price_Book.xlsx	XLSX spreadsheet	Apr 20, 2016
Attachment_1_CE_Support_Contract_PWS__18_February_2016.pdf	PDF	Apr 20, 2016
Attachment_8_WPAFB_BFS_and_Appendicies_Aug_2014.pdf	PDF	Apr 20, 2016
Attachment_5_SCA_Wage_Determination_05-2420.pdf	PDF	Apr 20, 2016
Attachment_3_CE_Lab_Support_Contract_-_Equipment_List_dated_11_Feb_2016.pdf	PDF	Apr 20, 2016
Attachment_6_Ordering_Procedures.pdf	PDF	Apr 20, 2016
Attachment_9_QASP.pdf	PDF	Apr 20, 2016
Attachment_2_CE_Lab_Support_Labor_Block_Princing_Schedule.xlsx	XLSX spreadsheet	Apr 20, 2016
Attachment_7_CE_Services_Technical_Capability.pdf	PDF	Apr 20, 2016

Show all 17

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.

Instructions

STEP 1: COMPLETE CELLS IN TABS B & C

Complete the Regular and Overtime Labor Block Pricing Worksheets, Tabs B & C, by placing the fully burdened total dollars for the number of hours specified by labor/skill type. A value shall be entered for all cells marked "Fill In" in Tabs B & C. Each block is calculated by taking the number of hours in the “Hours” column and multiplying by fully burdened labor rate for each labor category.

STEP 2: COMPLETE MATERIAL HANDLING % IN TAB A

Insert Material Handling % in Tab A, cell C65 and C68. Do not insert any other values into Tab A

STEP 3: REVIEW TOTAL EVALUATED PRICE IN TAB A

Review the Total Evaluated Price you will be submitting in Tab A cell C71 for accuracy. The TEP is a summation of 1) total price of the most likely scenario of regular and overtime hours to be ordered by the Government for each lab 2) Government Estimated Material and 3) Material Handling Charge for GPC and Time and Material CLINs.

FA8601-16-R-0002

Attachment 2 11 February 2016

Tab A-Labor hour Est.

9 month Regular Hours Expected Ordered Option
	Lab 1	Lab 2	lab 3	Lab 4	Lab 5	Lab 6	Lab 7	Lab 8	Lab 9	Lab 10	Lab 11	Lab 12	Total Hours
Engineering Technician VI (Technical Lead)	420	-	1,400	1,400	420	-	1,400	1,400	1,400	560	-	140	8,540
Engineering Technician V (including controls credentials)	-	-	1,400	-	-	-	1,400	1,400	1,400	-	-	-	5,600
Engineering Technician V (including electrical credentials)	140	-	1,400	1,400	560	140	1,400	1,400	2,800	560	70	1,120	10,920
Engineering Technician V (including chiller credentials)	-	-	280	280	140	-	1,400	280	280	140	-	-	2,800
Engineering Technician IV (including pipefitter & welder credentials)	140	-	1,400	1,400	420	140	4,200	2,800	2,800	700	-	-	14,000
Engineering Technician IV (including HVAC credentials)	420	70	2,800	2,800	420	140	4,200	5,600	4,200	420	-	140	21,210
Engineering Technician IV (including sheet metal credentials)	-	-	-	-	-	-	1,400	1,400	-	-	-	-	2,800
Engineering Technician IV (including insulator credentials)	-	-	-	-	-	-	1,400	1,400	-	-	-	-	2,800
Engineering Technician II (maintenance specialist)	-	-	1,400	-	-	-	1,400	4,200	2,800	-	-	-	9,800
General Clerk II(Administrative)	-	-	1,400	-	-	-	1,400	1,400	1,400	-	-	-	5,600
Total	1,120	70	11,480	7,280	1,960	420	19,600	21,280	17,080	2,380	- 0	1,400	83,720
9 Month Overtime Hours Expected Ordered Option
	Lab 1	Lab 2	lab 3	Lab 4	Lab 5	Lab 6	Lab 7	Lab 8	Lab 9	Lab 10	Lab 11	Lab 12	Total Hours
Engineering Technician VI (Technical Lead)	-	-	40	80	-	-	60	160	160	20	-	20	540
Engineering Technician V (including controls credentials)	10	-	40	-	-	-	40	100	160	-	-	-	350
Engineering Technician V (including electrical credentials)	20		40	120	10	-	60	100	300	20	-	40	710
Engineering Technician V (including chiller credentials)	-	-	-	-	-	-	-	-	-	-	-	-	- 0
Engineering Technician IV (including pipefitter & welder credentials)	-	-	40	40	20	-	40	200	300	20	-	-	660
Engineering Technician IV (including HVAC credentials)	20	-	40	180	40	-	60	400	500	20	-	20	1,280
Engineering Technician IV (including sheet metal credentials)	-	-	-	-	-	-	20	100	-	-	-	-	120
Engineering Technician IV (including insulator credentials)	-	-	-	-	-	-	20	100	-	-	-	-	120
Engineering Technician II (maintenance specialist)	-	-	60	-	-	-	60	300	300	-	-	-	720
General Clerk II(Administrative)	-	-	40	-	-	-		100	160	-	-	-	300
Total	50	0	300	420	70	0	360	1560	1880	80	0	80	4,800

Regular Total Evaluated Price CLIN 0001
	Lab 1	Lab 2	lab 3	Lab 4	Lab 5	Lab 6	Lab 7	Lab 8	Lab 9	Lab 10	Lab 11	Lab 12	CLIN 0001 Total Regular Labor Price
Engineering Technician VI (Technical Lead)	FILL IN		FILL IN	FILL IN	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	-	FILL IN	- 0
Engineering Technician V (including controls credentials)	-	-	FILL IN	-	-	-	FILL IN	FILL IN	FILL IN	-	-	-	- 0
Engineering Technician V (including electrical credentials)	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	- 0
Engineering Technician V (including chiller credentials)	-	-	FILL IN	FILL IN	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	-	-	- 0
Engineering Technician IV (including pipefitter & welder credentials)	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	-	-	- 0
Engineering Technician IV (including HVAC credentials)	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	-	FILL IN	- 0
Engineering Technician IV (including sheet metal credentials)	-	-	-	-	-	-	FILL IN	FILL IN	-	-	-	-	- 0
Engineering Technician IV (including insulator credentials)	-	-	-	-	-	-	FILL IN	FILL IN	-	-	-	-	- 0
Engineering Technician II (maintenance specialist)	-	-	FILL IN	-	-	-	FILL IN	FILL IN	FILL IN	-	-	-	- 0
General Clerk II(Administrative)	-	-	FILL IN	-	-	-	FILL IN	FILL IN	FILL IN	- 0	-	-	- 0
Total	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Overtime Total Evaluated Price CLIN 0011
	Lab 1	Lab 2	lab 3	Lab 4	Lab 5	Lab 6	Lab 7	Lab 8	Lab 9	Lab 10	Lab 11	Lab 12	CLIN 0011 Total Overtime Labor Price
Engineering Technician VI (Technical Lead)	-	-	FILL IN	FILL IN	-	-	FILL IN	FILL IN	FILL IN	FILL IN	-	FILL IN	$ - 0
Engineering Technician V (including controls credentials)	FILL IN	-	FILL IN	-	-	-	FILL IN	FILL IN	FILL IN	-	-	-	$ - 0
Engineering Technician V (including electrical credentials)	FILL IN	-	FILL IN	FILL IN	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	-	FILL IN	$ - 0
Engineering Technician V (including chiller credentials)	-	-	-	-	-	-	-	-	-	-	-	-	$ - 0
Engineering Technician IV (including pipefitter & welder credentials)	-	-	FILL IN	FILL IN	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	-	-	$ - 0
Engineering Technician IV (including HVAC credentials)	FILL IN	-	FILL IN	FILL IN	FILL IN	-	FILL IN	FILL IN	FILL IN	FILL IN	-	FILL IN	$ - 0
Engineering Technician IV (including sheet metal credentials)	-	-	-	-	-	-	FILL IN	FILL IN	-	-	-	-	$ - 0
Engineering Technician IV (including insulator credentials)	-		-	-	-	-	FILL IN	FILL IN	-	-	-	-	$ - 0
Engineering Technician II (maintenance specialist)	-	-	FILL IN	-	-	-	FILL IN	FILL IN	FILL IN	-	-	-	$ - 0
General Clerk II(Administrative)	-	-	FILL IN	-	-	-	-	FILL IN	FILL IN	-	-	-	$ - 0
Total	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
* Total Evaluated Price will be populated once Regular and Overtime Labor Blocks have been completed.

Government Estimated T&M Materials	$ 200,000.00
Material Handling %
Total Material and Handling	$ 200,000.00
Government Estimated GPC Materials	$ 2,100,000.00
Material Handling %
Total Material and Handling	$ 2,100,000.00
Total Regular and Overtime Labor	$ - 0
Total Evaluated Price	$ 2,300,000.00

FA8601-16-R-0002

Tab B-Regular Time Labor Block

Hours	Engineering Tech VI (Technical Lead)	Engineering Tech V (Controls Credentials)	Engineering Tech V (Electrical Credentials)	Engineering Tech V (Chiller Credentials)	Engineering Tech IV (pipefilter & Welder Credentials)	Engineering Tech IV (HVAC Credentials)	Engineering Tech IV (Sheet metal credentials)	Engineering Tech IV (Insulator credentials)	Engineering Tech II (Maintenance Specialsist)	General Clerk II (Administrative)
70	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
140	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
280	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
420	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
560	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
700	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
840	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
980	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
1120	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
1260	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
1400	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
2100	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
2800	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
3500	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
4200	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
4900	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
5600	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
6300	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
7000	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN

*Govt can exercise add'l hours for individual labs at any point during the base or option periods

**Maxmium hours to be exercised for an individual lab in the base or any option period is 7,000 hrs

***Complete the Regular Time Labor Block sheet by placing the fully burdened total dollars for the number of hours specified by labor/skill type. i.e. This is calcuated by taking the hours in colume B times the contractors hourly rate to inclued overhead, general administrative cost and profit will equal the total dollars to placed in each block.

&A FA8601-16-R-0002

Tab C-Overtime Labor Block

Hours	Engineering Tech VI (Technical Lead)	Engineering Tech V (Controls Credentials)	Engineering Tech V (Electrical Credentials)	Engineering Tech V (Chiller Credentials)	Engineering Tech IV (pipefilter & Welder Credentials)	Engineering Tech IV (HVAC Credentials)	Engineering Tech IV (Sheet metal credentials)	Engineering Tech IV (Insulator credentials)	Engineering Tech II (Maintenance Specialsist)	General Clerk II (Administrative)
10	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
20	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
40	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
60	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
80	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
100	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
120	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
140	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
160	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
180	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
200	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
300	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
400	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
500	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
600	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
700	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
800	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
900	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN
1000	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN	FILL IN

*Government may exercise additional hours for individual labs within each base or option period at the prices listed within those base or option periods

**Maxmium hours to be exercised for an individual lab in the base or any option period is 1,000 hrs

***Complete the Overtime Labor Block sheet by placing the fully burden total dollars for the number of hours specified by labor/skill type. i.e. This is calcuated by taking the hours in colume B times the contractors hourly rate to inclued overhead, general administrative cost and profit will equal the total dollars to placed in each block.

&A FA8601-16-R-0002

17 Febuary 2016

File details come from the government source that posted it. Updated Nov 14, 2017.