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

XLSX spreadsheet 328 KB Posted Dec 20, 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 provides instructions for a federal contractor manpower projection workbook attachment for a Surface Fire Fighter and Damage Control Contractor Operation and Maintenance Services solicitation. Offerors are required to fill out workbooks projecting monthly labor hours by category for each contract line item number and location. The workbooks include tabs for locations at Mayport, Norfolk, Newport, San Diego, Pearl Harbor, Great Lakes RTC, and Great Lakes SWOSU. Offerors must identify required labor categories and project hours to be performed by each category on a monthly basis. The total projected hours will be multiplied by 12 months to calculate totals for each contract line item number. The solicitation is a 100% small business set-aside with an engineering services NAICS code and seeks proposals for contractor operation and maintenance services for surface warfare officer school training systems at multiple Navy commands.

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 (L-9B) Surf FF-DC Manpower Projection Workbook_23 Dec 2019.xlsx	XLSX spreadsheet	Dec 23, 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 (1C) Appendix C_Surf FF-DC_San Diego_4 Dec 2019_TrkChgs.docx	DOCX document	Dec 20, 2019
ATCH 10H_CBA_Norfolk - TAMP - FINAL.PDF	PDF	Dec 20, 2019
ATCH 10I_CBA_San Diego - SDAMP - FINAL.PDF	PDF	Dec 20, 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 10G_CBA_Mayport - MAMP - FINAL.pdf	PDF	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 10C_WD 15-5636 (Rev.-11) San Diego.pdf	PDF	Dec 9, 2019
ATCH 10F_CBA_Great Lakes - GLAFFSP - FINAL.PDF	PDF	Dec 9, 2019
ATCH 10E_CBA_Pearl Harbor - LMS - FINAL.pdf	PDF	Dec 9, 2019
ATCH 10B_CBA_Norfolk - TAMP - FINAL.PDF	PDF	Dec 9, 2019
ATCH 10A_CBA_Mayport - MAMP - FINAL.pdf	PDF	Dec 9, 2019
Att (L-14) Consolidated Solicitation Question_5 Dec 2019 FINAL.xlsx	XLSX spreadsheet	Dec 9, 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
Att (L-13D) CDRL A005 OTC Newport_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (L-12) Surf FF-DC COMS Consumables Report All Sites_Feb 2018 - Jan 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
Att (1C) Appendix C_Surf FF-DC_San Diego_1 Oct 2019.docx	DOCX document	Nov 20, 2019
FFDC COMS MOPAS for RFP posting.pdf	PDF	Nov 20, 2019
Exhibit (A6) CDRL A006 Quality System Plan (w attach)_FF_DC_23 Oct 2019.doc	DOC document	Nov 20, 2019
Att (6) SCA Price Adjustment Form_10 Oct 19.xls	XLS spreadsheet	Nov 20, 2019
ATCH 10B_WD 15-4341 (Rev.-12) Norfolk.pdf	PDF	Nov 20, 2019
Att (L-14) Solicitation QuestionResponse Form_10 Oct 19.xlsx	XLSX spreadsheet	Nov 20, 2019
Att (3) Quality Assurance Surveillance Plan_2 Jul 2019.doc	DOC document	Nov 20, 2019
Exhibit (A5) CDRL A005 Inventory Report (w attach)_FF_DC_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
Exhibit (A4-1) Samplet Rpt for Annex of Exhibit A004_23 Oct 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
Att (L-13E) CDRL A005 Pearl Harbor_Inventory Report_2 Jul 2019.xls	XLS spreadsheet	Nov 20, 2019
Att (L-16E) Pearl Harbor Maint Sep 18 - Aug 19 dtd 7 Oct 19.pdf	PDF	Nov 20, 2019
Exhibit (A1) CDRL A001 CFSR w attach_FF_DC COMS_23 Oct 2019.doc	DOC document	Nov 20, 2019
Exhibit (A2) CDRL A002 Conference Minutes_FF_DC COMS_23 Oct 2019.doc	DOC document	Nov 20, 2019
Evaluation Factor Guide Version 1.3 July 2019.docx	DOCX document	Nov 20, 2019
.Section J Attachments_11.20.19.docx	DOCX document	Nov 20, 2019
Att (L-15) Maint Hours and Throughput Feb 18 - Aug 19 dtd 7 Oct 2019.xlsx	XLSX spreadsheet	Nov 20, 2019
Att (8) OAWR Procedures and Form_2 Jul 2019.docx	DOCX document	Nov 20, 2019
Att (7) DOL Wage Adjust Baseline_10 Oct 19.xls	XLS spreadsheet	Nov 20, 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

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 20, 2019.