Atch_7_(Rev_1)_-_Sheppard_Manpower_Matrix.xlsx

XLSX spreadsheet 74 KB Posted Dec 8, 2015

Attached to: Sheppard Aircraft Maintenance Support Services Federal contract opportunity
Solicitation number: FA3002-14-R-0015
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Atch 7 (Rev 1) - Sheppard Manpower Matrix

View the file

Other files for this federal contract opportunity

Other files attached to Sheppard Aircraft Maintenance Support Services, newest first.
File	Type	Posted
Amend_0001_PWS_Change_Matrix_(1_Dec_15).pdf	PDF	Dec 8, 2015
FA3002-14-R-0015-0001.doc	DOC document	Dec 8, 2015
Atch_16_(Rev_1)_-_SGEM_Calculations.xlsx	XLSX spreadsheet	Dec 8, 2015
Atch_1_(Rev_1)_-_Performance_Work_Statement_(1_Dec_15).pdf	PDF	Dec 8, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_Brief.pdf	PDF	Dec 3, 2015
Cover_Letter_for_Q A__1_and_Site_Visit_Brief_Release.pdf	PDF	Dec 3, 2015
Consolidated_Q A__1_(FA3002-14-R-0015).pdf	PDF	Dec 3, 2015
Sheppard_Acft_MX_Site_Visit_Q A_Form.doc	DOC document	Nov 2, 2015
Sheppard_Acft_MX_Pre-Proposal_Conf_ _Site_Visit_Invitation.docx	DOCX document	Nov 2, 2015
Atch_8_-_Sample_Vehicle_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_9_-_Subcontracting_Plan_Checklist.docx	DOCX document	Nov 2, 2015
Atch_7_-_Sheppard_Manpower_Matrix.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_6_-_Proposal_Incorporation_Memorandum.docx	DOCX document	Nov 2, 2015
Atch_11-_Subktr_Letter_of_Consent.docx	DOCX document	Nov 2, 2015
Atch_15_-_Past_Perf_Questionnaire.docx	DOCX document	Nov 2, 2015
Atch_16_-_SGEM_Calculations.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_13_-_Solicitation_Question_and_Comment_Sheet.xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_1_-_Performance_Work_Statement_(1_Oct_15).pdf	PDF	Nov 2, 2015
Atch_4a_-_CBA_(18_May_2015).pdf	PDF	Nov 2, 2015
RFP_FA3002-14-R-0015 _Sheppard_Acft_MX_(2_Nov_15_Release).doc	DOC document	Nov 2, 2015
Atch_3_-_SCLS_WD_05-2525_(Rev_18)_8_Jul_15.pdf	PDF	Nov 2, 2015
Atch_2_-_DD_254.pdf	PDF	Nov 2, 2015
Atch_12_-_Client_Authorization_Letter.docx	DOCX document	Nov 2, 2015
Atch_4b_-_CBA_(TSquare_-_AGE)_(24_May_15).pdf	PDF	Nov 2, 2015
Atch_5_-_PIR_Calculator_(Rev).xlsx	XLSX spreadsheet	Nov 2, 2015
Atch_10_-_Past_Performance_Information_Sheet.docx	DOCX document	Nov 2, 2015
Atch_4c_-_CBA_Memorandum_1_(Fringe_Benefit_Rate).pdf	PDF	Nov 2, 2015
Atch_14_-_Workforce_Demographic_Information_as_of_Aug_15.xls	XLS spreadsheet	Nov 2, 2015
Sheppard_Acft_MX_RFP_Cover _FA3002-14-R-0015.pdf	PDF	Nov 2, 2015
Sheppard_RFP_Cover_Attachment_1_-_PWS_Change_Matrix_(1_Oct_15).pdf	PDF	Nov 2, 2015

Show all 30

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.

Example

	Manpower Matrix Example
		Labor Category			Mobilization				Basic				Option Year 2				Option Year 3				Option Year 4				Option Year 5
	CLIN X001 - SHEPPARD AFB SITE SUPPORT AND STEADY STATE				Shift				Shift				Shift				Shift				Shift				Shift
	Duty Titles	Sal.	CBA	*AWD	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total
	Contract/Program Management
	Program Manager	X			1	1		2	1	1		2	1	1		2	1	1		2	1	1		2	1	1		2
	Production Supervisors	X			2	2		4				0				0				0				0				0
	Management support							0				0				0				0				0				0
								0				0				0				0				0				0
								0				0				0				0				0				0
								0				0				0				0				0				0
	Total				3	3	0	6	1	1	0	2	1	1	0	2	1	1	0	2	1	1	0	2	1	1	0	2

		Labor Category			Mobilization				Basic				Option Year 2				Option Year 3				Option Year 4				Option Year 5
	CLIN X002 - T-6A FLYING HOUR AIRCRAFT MAINTENANCE				Shift				Shift				Shift				Shift				Shift				Shift
	Duty Titles	Sal.	CBA	*AWD	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total
	T-6A Unscheduled Maintenance
	Aircraft Mechanic		X		0	0	1	1	1	1		2	1	1		2	1	1		2	1	1		2	1	1		2
								0				0				0				0				0				0
								0				0				0				0				0				0
								0				0				0				0				0				0
	Total				0	0	1	1	1	1	0	2	1	1	0	2	1	1	0	2	1	1	0	2	1	1	0	2

		Labor Category			Mobilization				Basic			Option Year 2			Option Year 3			Option Year 4				Option Year 5
	CLIN X003 - T-38C UPT AIRCRAFT FLYING HOUR MAINTENANCE				Shift				Shift			Shift			Shift			Shift				Shift
	Duty Titles	Sal.	CBA	*AWD	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total
	T-38C UPT Unscheduled Maintenance
	Aircraft Mechanic		X		0	1		1	1	1	2	1	1	2	1	1	2	1	1	1	3	1	1	1	3
								0			0			0			0				0				0
								0			0			0			0				0				0
								0			0			0			0				0				0
	Total				0	1	0	1			2			2			2				3				3

Total Manyears	3	4	1	8	2	2	0	6	2	2	0	6	2	2	0	6	2	2	0	7	2	2	0	7
***Insert lines as needed in each CLIN.

*AWD is Area Wage Determination. The AWD labor category applies to individuals covered under an Area Wage Determination vice the Collective Bargaining Agreement, see RFP attachment 3.

&"Times New Roman,Regular"&12FA3002-14-R-0015-0001 Attachment 7 01 Dec 2015

For Example only!

Manpower Matrix

		Labor Cat			FY16 Mobilization				FY17				FY18				FY19				FY20				FY21				FY22				FY23
					Shift				Shift				Shift				Shift				Shift				Shift				Shift				Shift
		Sal.	CBA	AWD	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total	Day
Shift	Swing
Shift	Mid
Shift	Total
	CLIN X001 - SHEPPARD AFB SITE SUPPORT AND STEADY STATE
	Duty Titles
	Contract Management Staff							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Management Support							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Quality Control							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Debrief							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Maintenance Operations Branch							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Maintenance Operations Center (MOC)							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Plans, Scheduling and Documentation (PS&D)							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	CEMS							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Data Management							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Repair Cycle Management							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Training							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Tool Crib							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	T-6, T-38C UPT, T-38C IFF and Maint Branch Mgmt							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	AGE/CASS/Vehicles							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
	Misc Additive Maintenance Requirements (Not MH/FH)							0				0				0				0				0				0				0				0
								0				0				0				0				0				0				0				0
												0				0				0				0				0				0				0
	Total				0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Labor Cat

FY16 Mobilization

FY17

FY18

FY19

FY20

FY21

FY22

FY23

Shift

Sal.

CBA

AWD

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

CLIN X002 - T-6A FLYING HOUR AIRCRAFT MAINTENANCE

Direct Support (expeditors)


T-6A Flight Line


T-6A Unscheduled Maintenance


T-6A Scheduled Maintenance


T-6A Post Dock


Avionics


Electrical/Environmental Systems


Pneudraulics


Fuels Maintenance


Egress Maintenance


Sheet Metal


Welding


Machine Shop


Corrosion Control


Wheel/Tire Maintenance


Engine Maintenance


NDI/OAP


Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Labor Cat

FY16 Mobilization

FY17

FY18

FY19

FY20

FY21

FY22

FY23

Shift

Sal.

CBA

AWD

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

CLIN X003 T-38C UPT AIRCRAFT FLYING HOUR MAINTENANCE

Direct Support (expeditors)


T-38C UPT Flight Line


T-38C UPT Unscheduled Maintenance


T-38C UPT Scheduled Maintenance


T-38C UPT Post Dock


Avionics


Electrical/Environmental Systems


Pneudraulics


Fuels Maintenance


Egress Maintenance


Sheet Metal


Welding


Machine Shop


Corrosion Control


Wheel/Tire Maintenance


Unschedule Engine Maintenance


Scheduled/Test Cell Engine Maintenance


NDI/OAP


Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Labor Cat

FY16 Mobilization

FY17

FY18

FY19

FY20

FY21

FY22

FY23

Shift

Sal.

CBA

AWD

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

CLIN X004 T-38C IFF AIRCRAFT FLYING HOUR MAINTENANCE

Direct Support (expeditors)


T-38C IFF Flight Line


T-38C IFF Unscheduled Maintenance


T-38C IFF Scheduled Maintenance


T-38C IFF Post Dock


Avionics


Electrical/Environmental Systems


Pneudraulics


Fuels Maintenance


Egress Maintenance


Sheet Metal


Welding


Machine Shop


Corrosion Control


Wheel/Tire Maintenance


Unscheduled Engine Maintenance


Scheduled/Test Cell Engine Maintenance


NDI/OAP


Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Labor Cat

FY16 Mobilization

FY17

FY18

FY19

FY20

FY21

FY22

FY23

Shift

Sal.

CBA

AWD

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

Day

Shift

Swing

Shift

Mid

Shift

Total

CLIN X005 TRANSIENT AIRCRAFT MAINTENANCE




Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Total Manyears 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Manpower Matrix

&"Times New Roman,Regular"&12FA3002-14-R-0015-0001 Attachment 7 01 Dec 2015

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