Att (L-9B) Surf FF-DC Manpower Projection Workbook_7 Oct 2019.xlsx

XLSX spreadsheet 328 KB Posted Nov 20, 2019

Attached to: Surface Fire Fighter and Damage Control Contractor Operation & Maintenance Services
Solicitation number: N61340-20-R-0005
Issued by: Department of the Navy Naval Air Systems Command

About this file

Written by GovTribe AI · Dec 28, 2023

This document provides instructions for a labor projection workbook attachment to a solicitation for Surface Fire Fighter and Damage Control Contractor Operation and Maintenance Services. The solicitation seeks proposals for contractor operation and maintenance services to maintain training systems and equipment at seven commands located at six geographic locations including Mayport, FL; Norfolk, VA; Newport, RI; San Diego, CA; Pearl Harbor, HI; RTC Great Lakes, IL; and SWOSU Great Lakes, IL. Offerors must fill out the labor projection workbook identifying necessary labor categories by task and location on a monthly basis over a one-year base period and four one-year options. The firm-fixed-price contract with cost-reimbursable lines for consumables has a 100% small business set-aside with an NAICS code of 541330 and product service code of J069. The submission due date is per the SF33 and points of contact are in section L of the solicitation.

View the file

Other files

File	Type	Posted
Att (L-9B) Surf FF-DC Manpower Projection Workbook_23 Dec 2019.xlsx	XLSX spreadsheet	Dec 23, 2019
Att (1) Surface FF-DC COMS PWS_2 Dec 2019_TrkChgs.DOCX	DOCX document	Dec 20, 2019
Att (L-14) Consolidated Solicitation Question_19 Dec 2019 Amend 0001.xlsx	XLSX spreadsheet	Dec 20, 2019
ATCH 10I_CBA_San Diego - SDAMP - FINAL.PDF	PDF	Dec 20, 2019
Att (L-9B) Surf FF-DC Manpower Projection Workbook_20 Dec 2019.xlsx	XLSX spreadsheet	Dec 20, 2019
Att (1A) Appendix A_Surf FF-DC_Mayport_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
ATCH 10J_CBA_Newport - NFSMWA - FINAL.PDF	PDF	Dec 20, 2019
Att (1G) Appendix G_Surf FF-DC_SWOSU Great Lakes_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
Att (1B) Appendix B_Surf FF-DC_Norfolk_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
ATCH 10H_CBA_Norfolk - TAMP - FINAL.PDF	PDF	Dec 20, 2019
Att (1C) Appendix C_Surf FF-DC_San Diego_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
ATCH 10K_CBA_Pearl Harbor - LMS - FINAL.pdf	PDF	Dec 20, 2019
Att (1E) Appendix E_Surf FF-DC_Pearl Harbor_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
.N61340-20-R-0005 Amendment 0001.docx	DOCX document	Dec 20, 2019
ATCH 10L_CBA_Great Lakes - GLAFFSP - FINAL.PDF	PDF	Dec 20, 2019
Att (9A) Surf FF-DC Sect B_Price Evaluation Worksht_11 Dec 2019 Amend 1.xlsx	XLSX spreadsheet	Dec 20, 2019
ATCH 10G_CBA_Mayport - MAMP - FINAL.pdf	PDF	Dec 20, 2019
Att (9A) Surf FF-DC Sect B_Price Evaluation Worksht_10 Dec 2019.xlsx	XLSX spreadsheet	Dec 10, 2019
ATCH 10C_WD 15-5636 (Rev.-11) San Diego.pdf	PDF	Dec 9, 2019
ATCH 10C_CBA_San Diego - SDAMP - FINAL.PDF	PDF	Dec 9, 2019
ATCH 10D_CBA_Newport - NFSMWA - FINAL.PDF	PDF	Dec 9, 2019
Surface FF_DC Washer and Dryer List_4 Dec 2019.pdf	PDF	Dec 9, 2019
ATCH 10E_CBA_Pearl Harbor - LMS - FINAL.pdf	PDF	Dec 9, 2019
Att (L-12) Surf FF-DC COMS Consumables Report All Sites_4 Dec 2019.xlsx	XLSX spreadsheet	Dec 9, 2019
ATCH 10B_CBA_Norfolk - TAMP - FINAL.PDF	PDF	Dec 9, 2019
ATCH 10F_CBA_Great Lakes - GLAFFSP - FINAL.PDF	PDF	Dec 9, 2019
Att (L-14) Consolidated Solicitation Question_5 Dec 2019 FINAL.xlsx	XLSX spreadsheet	Dec 9, 2019
ATCH 10A_CBA_Mayport - MAMP - FINAL.pdf	PDF	Dec 9, 2019
Att (L-13E) CDRL A005 Pearl Harbor_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (5A) COMS Prem Time Request_2 Jul 2019.doc	DOC document	Nov 20, 2019
Att (L-13G) CDRL A005 SWOSU Great Lakes_Inventory Report_2 Jul 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
ATCH 10A_WD 15-4539 (Rev.-9) Mayport.pdf	PDF	Nov 20, 2019
ATCH 10E_WD 15-5689 (Rev.-9) Pearl Harbor.pdf	PDF	Nov 20, 2019
Exhibit (A4) CDRL A004 Monthly Rpt (1423 and Annex only)_FF_DC COMS_23 Oct 2019.doc	DOC document	Nov 20, 2019
Att (L-16C) San Diego Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (L-13D) CDRL A005 OTC Newport_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
.Announcement_FinalRFP_11.20.2019.pdf	PDF	Nov 20, 2019
Att (9A) Surf FF-DC Sect B_Price Evaluation Worksht_7 Oct 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
Att (1G) Appendix G_Surf FF-DC_SWOSU Great Lakes_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (1C) Appendix C_Surf FF-DC_San Diego_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (L-16B) Norfolk Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (L-13A) CDRL A005 Mayport_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
ATCH 10D_WD 15-4089 (Rev.-11) Newport.pdf	PDF	Nov 20, 2019
Att (5B) Premium Time Hours Log_15 Oct 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (L-16G) SWOSU Great Lakes Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (L-18) Contractor Performance Assessment Questionnaire May 2016.msg.pdf	PDF	Nov 20, 2019
Exhibit (A3) CDRL A003 Mob PSR w attach_FF_DC_23 Oct 2019.doc	DOC document	Nov 20, 2019
Att (1B) Appendix B_Surf FF-DC_Norfolk_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (L-13B) CDRL A005 Norfolk_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (3) Quality Assurance Surveillance Plan_2 Jul 2019.doc	DOC document	Nov 20, 2019

Show 40 more

Latest 50 of 87 listed here. See the rest on GovTribe.

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.

Instruction

Line Items	Instructions for Attachment XX
1	Each Tab represents a respective Contract Line Item Number (CLIN) within Section B of this solicitation. Within each Tab is a series of listed individual TS/E's with corresponding respective Trainer locations. These individual TS/E's and corresponding locations are tied to specifc support requirements within Appendices A through G" (e.g. Appendix A "Mayport").
2	Offerors shall fill out the following within the individual Tabs as described in line item 1: A. Offerors need to fill out and identify the labor categories necessary to successfully perform this Task Order, displayed on each individual spreadsheet tab via individual TS/E's as well as corresponding Contract Line Item Number (e.g. 1000). For assistance in developing this Attachment L-9B submission, offerors are advised that the Service Contract Act (clause 52.222-41) applies to this procurement; offerors are also advised of the information in Department of Labor website, http://www.dol.gov/whd/govcontracts/sca.htm; Department of Labor website, http://www.bls.gov/bls/blswage.htm; Wage Determinations OnLine.gov website, http://www.wdol.gov/exitpage.aspx?np=y&url=http://www.dol.gov/whd/regs/compliance/wage/SCADirV5/SCADirectVers5.pdf B. The hours to be performed by each identified labor category within this Task Order. Projected labor hours by labor category will be broken out for each TS/E based on a monthly workload projection. Further, the monthly hours tied to each labor category will display a sum total of all TS/E's. Of note, there is also a "TOTAL FOR CLIN" section within each tab which multiplies projected monthly labor hours per labor category by 12 months of support (12 months full support not including the "Mobilization" period).
3	Offerors shall ensure that the "Installation Labor Workload" tab is completed, representative of projected monthly labor hours by individual labor category by CLIN.
4	While Microsoft Excel Formulas are provided to assist with submission requirements, offerors are required to validate all their information (e.g. input, summary data, etc.) to ensure all data fields are correct and complete.

Installation_Labor Workload

	Monthly Hours
	DoL Code - Job Title	Total Hours (Monthly)	Mauport	Norfolk	San Diego	Newport	Pearl Harbor	RTC GL	SWOSU GL
Example	Site Manager (23183 - E Tech Maint III)	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14042 - Computer Operator II	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23470 - Laborer	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	21410 - Warehouse Specialist	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23181 - Electronics Tech Maintenance I	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23182 - Electronics Tech Maintenance II	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23183 - Electronics Tech Maintenance III	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23370 - General Maintenance Worker	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	23130 - Carpenter, Maintenance	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

Totals: 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Mayport_Labor Workload

CLIN 1001AA (Monthly $)
CLIN 1000 - Appendix A "Mayport"		MAYPORT	MAYPORT	MAYPORT	MAYPORT	MAYPORT
	Unit of Measure (UoM)	19F1A	19F4A	DCWT	FOM	TSG	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1000 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours						0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours						0.00	0.00
Example	23470 - Laborer	Monthly Hours						0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours						0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours						0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours						0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours						0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours						0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours						0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours						0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Norfolk_Labor Workload

			CLIN 1001AA (Monthly $)
			CLIN 1001 - Appendix B "Norfolk"		NORFOLK	NORFOLK	NORFOLK	NORFOLK	NORFOLK	NORFOLK	NORFOLK
				Unit of Measure (UoM)	19F1B	19F3B	19F4A	DCWT	FAC	TSG	TSG
(CIN A-4G-1111)	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1001 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours								0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours								0.00	0.00
Example	23470 - Laborer	Monthly Hours								0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours								0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours								0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours								0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours								0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours								0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours								0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours								0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

San Diego_Labor Workload

			CLIN 1001AA (Monthly $)
			CLIN 1002/1003 - Appendix C "San Diego"		San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego
				Unit of Measure (UoM)	19F1B	19F3B	19F4A	DCWT	FAC	TSG	TSG
(CIN A-4G-1111)	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1003 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours								0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours								0.00	0.00
Example	23470 - Laborer	Monthly Hours								0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours								0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours								0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours								0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours								0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours								0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours								0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours								0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Newport_Labor Workload

CLIN 1001AA (Monthly $)
CLIN 1004 - Appendix D "Newport"		NEWPORT	NEWPORT	NEWPORT	NEWPORT
	Unit of Measure (UoM)	19F3A	DCWT	FOM	TSG	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1004 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours					0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours					0.00	0.00
Example	23470 - Laborer	Monthly Hours					0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours					0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours					0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours					0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours					0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours					0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours					0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours					0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00

Pearl Harbor_Labor Workload

			CLIN 1001AA (Monthly $)
			CLIN 1005 - Appendix E "Pearl Harbor"			PEARL HARBOR	PEARL HARBOR	PEARL HARBOR	PEARL HARBOR	PEARL HARBOR
				Unit of Measure (UoM)		19F6
(MMB)	19F6
(AVIATION)	20C28	FOM	TSG	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1005 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours						0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours						0.00	0.00
Example	23470 - Laborer	Monthly Hours						0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours						0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours						0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours						0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours						0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours						0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours						0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours						0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00

RTC GL_Labor Workload

CLIN 1001AA (Monthly $)
CLIN 1006 - Appendix F "RTC Great Lakes"		RTC GL	RTC GL	RTC GL
	Unit of Measure (UoM)	19F5	FOM	TSG	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1006 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours				0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours				0.00	0.00
Example	23470 - Laborer	Monthly Hours				0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours				0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours				0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours				0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours				0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours				0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours				0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours				0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00

SWOSU GL_Labor Workload

CLIN 1001AA (Monthly $)
CLIN 1007 - Appendix G "SWOSU Great Lakes"		SWOSU GL	SWOSU GL	SWOSU GL	SWOSU GL
	Unit of Measure (UoM)	19F3C	FOM	TSG	DCWT	Total Hours Per 1 Month by Labor Category	TOTAL for CLIN 1007 [Hours per one Month * 12 Months (Month for Mobilization CLIN is not included)]

	Total Monthly Man Hours
	Labor		QTY	QTY	QTY	QTY
Example	Site Manager (23183 - E Tech Maint III)	Monthly Hours	0.00	0.00	0.00	0.00	0.00	0.00
Example	14170 - System Support Specialist	Monthly Hours					0.00	0.00
Example	14042 - Computer Operator II	Monthly Hours					0.00	0.00
Example	23470 - Laborer	Monthly Hours					0.00	0.00
Example	11210 - Laborer, Grounds Maintenance	Monthly Hours					0.00	0.00
Example	21410 - Warehouse Specialist	Monthly Hours					0.00	0.00
Example	23181 - Electronics Tech Maintenance I	Monthly Hours					0.00	0.00
Example	23182 - Electronics Tech Maintenance II	Monthly Hours					0.00	0.00
Example	23183 - Electronics Tech Maintenance III	Monthly Hours					0.00	0.00
Example	23370 - General Maintenance Worker	Monthly Hours					0.00	0.00
Example	23130 - Carpenter, Maintenance	Monthly Hours					0.00	0.00

Totals 0.00 0.00 0.00 0.00 0.00 0.00

File details come from the government source that posted it. Updated Nov 20, 2019.