Att (L-9B) Surf FF-DC Manpower Projection Workbook_23 Dec 2019.xlsx

XLSX spreadsheet 328 KB Posted Dec 23, 2019

Attached to: Surface Fire Fighter and Damage Control Contractor Operation & Maintenance Services Federal contract opportunity
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 contains instructions and templates for a federal contractor workforce projection workbook related to a solicitation for Surface Fire Fighter and Damage Control Contractor Operation and Maintenance Services. Offerors are required to fill out the workbook templates identifying the necessary labor categories and projected monthly hours by category for each contract line item number and location. The workbook includes templates for labor projections at locations in Mayport, Norfolk, Newport, San Diego, Pearl Harbor, Great Lakes, and Southwest Ohio State University Great Lakes. Offerors must validate all information and data in the workbook.

The related federal contract opportunity is a solicitation from the Department of the Navy seeking proposals for Surface Fire Fighter and Damage Control Contractor Operation and Maintenance Services at locations in Mayport, Norfolk, Newport, San Diego, Pearl Harbor, Great Lakes, and Southwest Ohio State University Great Lakes. The firm-fixed-price contract has a one-year base period and four one-year options, with cost reimbursable lines for trainer consumables. The 100% small business set-aside contract applies NAICS code 541330 with a $41.5M size standard. Proposals are due by the date specified in the RFP.

View the file

Other files for this federal contract opportunity

Other files attached to Surface Fire Fighter and Damage Control Contractor Operation & Maintenance Services, newest first.
File	Type	Posted
Att (1G) Appendix G_Surf FF-DC_SWOSU Great Lakes_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
Att (L-9B) Surf FF-DC Manpower Projection Workbook_20 Dec 2019.xlsx	XLSX spreadsheet	Dec 20, 2019
ATCH 10K_CBA_Pearl Harbor - LMS - FINAL.pdf	PDF	Dec 20, 2019
Att (1B) Appendix B_Surf FF-DC_Norfolk_4 Dec 2019_TrkChgs.docx	DOCX document	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
Att (9A) Surf FF-DC Sect B_Price Evaluation Worksht_10 Dec 2019.xlsx	XLSX spreadsheet	Dec 10, 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
Att (L-12) Surf FF-DC COMS Consumables Report All Sites_4 Dec 2019.xlsx	XLSX spreadsheet	Dec 9, 2019
ATCH 10C_CBA_San Diego - SDAMP - FINAL.PDF	PDF	Dec 9, 2019
Att (L-9B) Surf FF-DC Manpower Projection Workbook_7 Oct 2019.xlsx	XLSX spreadsheet	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
.N61340-20-R-0005 Surface FF_COMS_11.20.2019_FINAL.pdf	PDF	Nov 20, 2019
Att (1) Surface FF-DC COMS PWS_20 Nov 2019.pdf	PDF	Nov 20, 2019
Att (1F) Appendix F_Surf FF-DC_RTC Great Lakes_1 Oct 2019.docx	DOCX document	Nov 20, 2019
.Announcement_FinalRFP_11.20.2019.pdf	PDF	Nov 20, 2019
Att (4) Data Item Transmittal_Acceptance_Rejection_ Form.pdf	PDF	Nov 20, 2019
.N61340-20-R-0005 Surface FF_COMS_11.20.2019_FINAL.docx	DOCX document	Nov 20, 2019
Att (1B) Appendix B_Surf FF-DC_Norfolk_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (1) Surface FF-DC COMS PWS_20 Nov 2019.DOCX	DOCX document	Nov 20, 2019
Att (L-13F) CDRL A005 RTC Great Lakes_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
ATCH 10C_WD 15-5635 (Rev.-11) San Diego.pdf	PDF	Nov 20, 2019
Att (L-13B) CDRL A005 Norfolk_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (1D) Appendix D_Surf FF-DC_Newport_1 Oct 2019.docx	DOCX document	Nov 20, 2019
.FFDC COMS MOPAS Redacted.pdf	PDF	Nov 20, 2019
ATCH 10E_WD 15-5689 (Rev.-9) Pearl Harbor.pdf	PDF	Nov 20, 2019
Att (L-16G) SWOSU Great Lakes Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (1E) Appendix E_Surf FF-DC_Pearl Harbor_20 Nov 2019.docx	DOCX document	Nov 20, 2019
Att (L-13G) CDRL A005 SWOSU Great Lakes_Inventory Report_2 Jul 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
ATCH 10F_WD 15-4935 (Rev.-11) Great Lakes.pdf	PDF	Nov 20, 2019
Att (5A) COMS Prem Time Request_2 Jul 2019.doc	DOC document	Nov 20, 2019
Att (L-16F) RTC Great Lakes Maint Sep 18 - Aug 19 dtd 7 Oct 19.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 (L-13A) CDRL A005 Mayport_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (2) CDRL Addressee List_23 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (L-13C) CDRL A005 San Diego_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (L-16D) Newport Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (11) Excess Repair_Replacement Form_2 Jul 2019.doc	DOC document	Nov 20, 2019
Att (1A) Appendix A_Surf FF-DC_Mayport_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (5B) Premium Time Hours Log_15 Oct 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (L-16A) Mayport Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Att (9A) Surf FF-DC Sect B_Price Evaluation Worksht_7 Oct 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
ATCH 10D_WD 15-4089 (Rev.-11) Newport.pdf	PDF	Nov 20, 2019
.Announcement_FinalRFP_11.20.2019.docx	DOCX document	Nov 20, 2019
Att (L-18) Contractor Performance Assessment Questionnaire May 2016.msg.pdf	PDF	Nov 20, 2019
ATCH 10A_WD 15-4539 (Rev.-9) Mayport.pdf	PDF	Nov 20, 2019
Att (1G) Appendix G_Surf FF-DC_SWOSU Great Lakes_1 Oct 2019.docx	DOCX document	Nov 20, 2019
Att (L-17) Past Performance Information Form Mar 2017.pdf	PDF	Nov 20, 2019
Att (L-16B) Norfolk Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019

Show all 50

Surface Fire Fighter and Damage Control Contractor Operation & Maintenance Services has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

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 1001 - 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 1001 [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 1002 - 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 1002 [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 1003/1004 - 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/1004 [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 1005 - 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 1005 [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 1006 - 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 1006 [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 1007 - 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 1007 [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 1008 - 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 1008 [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 Dec 23, 2019.