Maxwell_Manpower_Matrix_13_Jul_2015.xlsx

XLSX spreadsheet 79 KB Posted Aug 6, 2015

Attached to: Maxwell-Gunter BOS Federal contract opportunity
Solicitation number: FA300213R0012
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Manpower Matrix

View the file

Other files for this federal contract opportunity

Other files attached to Maxwell-Gunter BOS, newest first.
File	Type	Posted
Memorandum_of_Agreement_002.tif	TIF image	Jun 24, 2016
SCA_WD_2005-2011_(Rev_20).pdf	PDF	Jun 15, 2016
Maxwell_Memorandum_Amendment_0007_(2).docx	DOCX document	Jun 15, 2016
FA3002-13-R-0012-0007-Conformed_Copy.docx	DOCX document	Jun 15, 2016
Maxwell_BOS_PWS_Changes_Amendment_7.pdf	PDF	May 25, 2016
13350_CBA_Maxwell.pdf	PDF	May 25, 2016
9504_CBA_Maxwell.pdf	PDF	May 25, 2016
Amendment_0007_Conform_Copy.doc	DOC document	May 25, 2016
Amendment_0006.pdf	PDF	Oct 7, 2015
MFR-_PWS_Appendix_25FF.1.3..docx	DOCX document	Sep 25, 2015
MFR-_Revised_PWS_Amend_0005.docx	DOCX document	Sep 17, 2015
Maxwell_BOS_RFP_Amendment_0005.pdf	PDF	Sep 15, 2015
Maxwell_BOS_PWS_11_Sep_2015.pdf	PDF	Sep 15, 2015
Maxwell_BOS_Amend_0004_Modification_Document_RFP.doc	DOC document	Aug 26, 2015
Maxwell_Memorandum_Amendment_0004.docx	DOCX document	Aug 26, 2015
Maxwell_BOS_PWS_26_Aug_2015.pdf	PDF	Aug 26, 2015
Signed_Q A_MFR_-_20_Aug_15.pdf	PDF	Aug 20, 2015
DBA_WD_(All_Combined)-_Amendment_0003.pdf	PDF	Aug 6, 2015
Amendment_0003.pdf	PDF	Aug 6, 2015
Signed_DD254.pdf	PDF	Aug 6, 2015
RFP_QAs_Consolidated_Final.xlsx	XLSX spreadsheet	Aug 6, 2015
Proposal_Due_Date_Extention_Notice.docx	DOCX document	Jul 23, 2015
FA3002-13-R-0012_-_Maxwell_RFP_Amend_0002.pdf	PDF	Jun 11, 2015
Proposal_Due_Date_Extension.pdf	PDF	Jun 4, 2015
Maxwell_BOS__Solicitation_Brief_(13_May_15).pptx	PPTX presentation	May 15, 2015
WBS_-_Example-_3_Apr_15.xlsx	XLSX spreadsheet	May 15, 2015
Mission_Essential_Services.pdf	PDF	May 5, 2015
Maxwell_BOS_DD254_Dec_2014.pdf	PDF	Apr 30, 2015
MAXWELL-GUNTER_WORKFORCE_DEMOGRAPHIC_INFORMATION.pdf	PDF	Apr 30, 2015
FA3002-13-R-0012_-_Maxwell_RFP_FINAL.pdf	PDF	Apr 30, 2015
(Building).pdf	PDF	Apr 30, 2015
PAST_PERFORMANCE_INFORMATION.pdf	PDF	Apr 30, 2015
CBA_13350_Effective_Date_1_Aug_12.pdf	PDF	Apr 30, 2015
Subcontractor_consent_letter.pdf	PDF	Apr 30, 2015
Technical_Library_Memo.pdf	PDF	Apr 30, 2015
CBA_9504 _Effective_Date_1_Jul_12.pdf	PDF	Apr 30, 2015
Executive_Summary_-_Maxwell_BOS.pdf	PDF	Apr 30, 2015
(Highway).pdf	PDF	Apr 30, 2015
Attachment_for_Section_L_-_PPI_Tool_Instructions.pdf	PDF	Apr 30, 2015
BOS_Comment_Matrix.docx	DOCX document	Nov 18, 2014
DRAFT_Maxwell_BOS_PWS.pdf	PDF	Jul 31, 2014
Consolidated_Response_to_Industry_Questions_as_of_18_Mar_14.pdf	PDF	Mar 18, 2014
Maxwell_CE_Staged_Tier_Workload.xlsx	XLSX spreadsheet	Mar 6, 2014
PWS.zip	ZIP file	Feb 7, 2014
RWP.zip	ZIP file	Feb 7, 2014
WBS_Example.xlsx	XLSX spreadsheet	Feb 7, 2014
Maxwell_Additional_Workload_in_Tech_Library.zip	ZIP file	Feb 7, 2014
Support_Agreements.zip	ZIP file	Feb 7, 2014
RFI_Comment_Question_Form.doc	DOC document	Mar 21, 2013
PWS_Draft_(v1)_-_File_2_of_3.zip	ZIP file	Mar 14, 2013

Show all 50

Maxwell-Gunter BOS 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.

MANYEAR

AVAILABLE PRODUCTIVE MANHOURS

MAXWELL ABW

BASE OPERATIONS SUPPORT

	SCA - Wage Determination
Total Non-Exempt Workforce	BASIC 45 day Mob and 10.5 months	FY17	FY18	FY19	FY20	IOP 1 FY21	IOP 2 FY 22
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	2096	2080	2080	2088	2096	2088	2088
Less Holidays
Less Vacation
Less Sick
Less Other (e.g. breaks, personal

hygiene, etc.)

Productive Manhours Available

SCA - Collective Bargaining Agreement (when applicable)

Total Non-Exempt Workforce	FY16	FY17	FY18	FY19	FY20	FY21	FY22
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	2096	2080	2080	2088	2096	2088	2088
Less Holidays
Less Vacation
Less Sick
Less Other (e.g. breaks, personal

hygiene, etc.)

Productive Manhours Available

	Non-W.D. & CBA
Total Exempt Workforce	FY16	FY17	FY18	FY19	FY20	FY21	FY22
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	2096	2080	2080	2088	2096	2088	2088
Less Holidays
Less Vacation
Less Sick
Less Other (e.g. breaks, personal

hygiene, etc.)

Productive Manhours Available

Notes:

Complete this worksheet for the "total" workforce (a separate matrix is not required for each service area). This matrix is divided into 3 categories of labor: Non-exempt employees to include employees covered by the Service Contract Act (SCA) in the Wage Determination category and Collective Bargaining Agreement category. The third category is for employees exempt from the SCA, e.g. management, salary employees. Productive manhours available is the annual manhours available (fixed) minus holidays, vacation, sick, and other time (enter categories into the worksheet as needed) as provided by the offeror. Do not include overtime hours on this matrix. The following matrices are required to be completed by the prime and each subcontractor. Due to the proprietary nature of this data, a subcontractor may opt to submit this data directly to the contracting officer in lieu of submitting through it's prime contractor.

SOLICITATION NUMBER F41689-02-R-0048

As of 25 Jan 02 Attachment 4 to Section J Page &P of &N

Overall Workforce

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

WORKFORCE TOTALS

BASIC includes MOB

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

TOTAL DIRECT

2. All Services

3. Maintenance (FOD, Transient Maintenance, Static Display)

5. Resource Management

7. Comm & Information Technology

9. Publishing Management

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

21. Airfield Management

23. Supply

25. Transportation

28. Community Services

30. Human Resources

32. Weather

TOTAL INDIRECT

2. All Services

3. Maintenance (FOD, Transient Maintenance, Static Display)

5. Resource Management

7. Comm & Information Technology

9. Publishing Management

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

21. Airfield Management

23. Supply

25.Transportation

28. Community Services

30. Human Resources

32. Weather

TOTAL OVERHEAD

2. All Services

3. Maintenance (FOD, Transient Maintenance, Static Display)

5. Resource Management

7. Comm & Information Technology

9. Publishing Management

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

21. Airfield Management

23. Supply

25. Transportation

28. Community Services

30. Human Resources

32. Weather

TOTAL DIRECT

TOTAL INDIRECT

TOTAL OVERHEAD

TOTAL PROGRAMMED MANYEARS (Note 2)

LAPSE MANYEARS (Note 3)

AVAILABLE MANYEARS (Note 4)

OVERTIME MANYEARS (Note 5)

TOTAL MANYEARS PRICED (Note 6)

NOTES:

Note 1: Direct, Indirect, and Overhead labor (total full and part time numbers appearing in the matrix should include lapse because you do not know specifically where the lapse will occur.

Note 2: Total programmed manyears should represent the total of Direct, Indirect, and Overhead figures in the previous upper portion of the chart (and thus include lapse figures and mobilization).

Note 3: Total projected lapse extracted from the total programmed manyears.

Note 4: Available manyears are programmed manyears less lapse manyears.

Note 5: Total of projected overtime hours (hours worked at a premium rate of pay), as indicated in the cost proposal (translated to overtime manyears).

Note 6: Priced manyears is the total programmed manyears less lapse manyear plus overtime manyears.

Note 7: This matrix may be completed jointly by the prime and each subcontractor. Due to the proprietary nature of this data, a subcontractor may opt to submit their portion of this data directly to the contracting officer in lieu of submitting through it's prime contractor.

DEFINITIONS

Applies to technical proposal & should not affect cost summaries previously submitted

Direct Labor - Direct labor involves those tasks that are readily identifiable with a work center's specific product or service. For example, fuels distribution or vehicle maintenance. Supervision of direct labor tasks is considered direct labor when direct labor encompasses fifty percent or more of the tasks.

Indirect Labor - Indirect labor involves those tasks that are not readily identifiable with a work center's specific product or service. The major categories of standard indirect work are: Directs work center activity, provides administrative support; prepares for and conducts/attends meetings; performs planning and scheduling; maintains system and equipment status, configuration, usage, location and historical records; administers training, quality, budget, data collection and analysis programs; manages supplies and tools, monitors and coordinates work center production, and performs clean-up. Supervision of indirect tasks is considered indirect labor when indirect labor encompasses fifty percent or more of the tasks.

LAPSE MANYEARS - The lapse rate factor is comprised of pricing/manning figures to compensate for personnel turnover, excess sick leave, excess annual leave, etc. Basically, it is the timeframe from when a job is vacated up until a trained replacement is back into the position. Note: A zero lapse rate is unrealistic since it assumes that no employee will quit, retire, die or require excess sick leave or annual leave without a trained replacement being in place.

Overhead Labor - Work and tasks related to overall management of both support and production activities. This category includes staff support activities, (for example human resource, contract managment and overhead administration). Work is considered overhead when tasks encompasses fifty percent or more of managment tasks. Overhead labor refers to on-site management overhead only.

SOLICITATION NUMBER FA3002-13-R-0012

Attachment 13 Page &P of &N

ALL-SERVICE (2)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

ALL-SERVICE REQUIREMENTS

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

SOLICITATION NUMBER F41689-00-R-0050

Attachment 13 Page &P of &N

Maintenance (3)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

MAINTENANCE (FOD, TRANSIENT MAINTENANCE AND STATIC DISPLAY)

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Resource Mgmt(5)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

RESOURCE MANAGEMENT

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Communications and Info (7)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

COMMUNICATIONS AND INFORMATION TECHNOLOGY

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Publishing (9)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

PUBLISHING

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

SOLICITATION NUMBER FA3002-13-R-0012

Attachment 13 Page &P of &N

Installation Mgmt (10)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

INSTALLATION MANAGEMENT

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Operations (11)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

OPERATIONS

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Installation Eng (12)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

INSTALLATION ENGINEERING

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Emergency Mgmt (14)

WORKFORCE MATRIX -MAXWELL ABW BASE OPERATIONS SUPPORT

EMERGENCY MANAGEMENT

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Airfield Mgmt (21)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

AIRFIELD MANAGEMENT

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Supply (23)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

SUPPLY

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Transportation (25)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

TRANSPORTATION

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Community Services (28)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

COMMUNITY SERVICES

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Human Resources (30)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

HUMAN RESOURCES

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Weather (32)

WORKFORCE MATRIX - MAXWELL ABW BASE OPERATIONS SUPPORT

WEATHER

BASIC

FY17

FY18

FY19

FY20

FY21

FY22

Manyears

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

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