Maxwell_Manpower_Matrix_13_Jul_2015.xlsx

XLSX spreadsheet 79 KB Posted Aug 6, 2015

Attached to: Maxwell-Gunter BOS
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

File	Type	Posted
FA3002-13-R-0012_Conformed_Solicitation_Document.docx	DOCX document	Feb 15, 2017
FA3002-13-R-0012-0008.docx	DOCX document	Feb 14, 2017
Maxwell_BOS_PWS_-_Amend_8.pdf	PDF	Feb 14, 2017
Maxwell_Memorandum_Amendment_0007_CBA_Addendum.docx	DOCX document	Jun 24, 2016
Memorandum_of_Agreement_002.tif	TIF image	Jun 24, 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
SCA_WD_2005-2011_(Rev_20).pdf	PDF	Jun 15, 2016
FA3002-13-R-0012-0007.docx	DOCX document	Jun 14, 2016
Maxwell_Memorandum_Amendment_0007.docx	DOCX document	Jun 14, 2016
MFR_correcting_due_date_in_Amend_0007.docx	DOCX document	May 25, 2016
CBA_M1_and_USW_Maxwell_AFB_April_14_2016_through_June_30_2018.pdf	PDF	May 25, 2016
9504_CBA_Maxwell.pdf	PDF	May 25, 2016
Amendment_0007_Conform_Copy.doc	DOC document	May 25, 2016
Amendment_0007_Modification_Document.doc	DOC document	May 25, 2016
13350_CBA_Maxwell.pdf	PDF	May 25, 2016
Maxwell_BOS_PWS_Changes_Amendment_7.pdf	PDF	May 25, 2016
Vehicle_Replacement_Comment-Question.pdf	PDF	Oct 13, 2015
Amendment_0006.pdf	PDF	Oct 7, 2015
Vehicle_Replacement_Schedule_-_Maxwell_AFB_BOS.pdf	PDF	Oct 7, 2015
MFR-_Amendment_0006.pdf	PDF	Oct 7, 2015
MFR-_PWS_Appendix_25FF.1.3..docx	DOCX document	Sep 25, 2015
Maxwell_BOS_PWS_Revised_Amend_5_(17_Sep_15).pdf	PDF	Sep 17, 2015
MFR-_Revised_PWS_Amend_0005.docx	DOCX document	Sep 17, 2015
Attch_4_PAST_PERFORMANCE_INFORMATION.pdf	PDF	Sep 15, 2015
Attachment_5_-_PPI_Tool_Instructions.pdf	PDF	Sep 15, 2015
Maxwell_BOS_RFP_Amendment_0005.pdf	PDF	Sep 15, 2015
Maxwell_BOS_RFP_(Conformed_Copy).pdf	PDF	Sep 15, 2015
Maxwell_BOS_PWS_11_Sep_2015.pdf	PDF	Sep 15, 2015
Maxwell_Manpower_Matrix_Atch_9_14_Sep_2015.xlsx	XLSX spreadsheet	Sep 15, 2015
SCA_WD_2005-2011_Rev_19.pdf	PDF	Sep 15, 2015
Maxwell_Memorandum_Amendment_0004.docx	DOCX document	Aug 26, 2015
Maxwell_BOS_PWS_26_Aug_2015.pdf	PDF	Aug 26, 2015
Maxwell_RFP_Amendment_4_Q A.xls	XLS spreadsheet	Aug 26, 2015
Maxwell_BOS_Amend_0004_Modification_Document_RFP.doc	DOC document	Aug 26, 2015
Signed_Q A_MFR_-_20_Aug_15.pdf	PDF	Aug 20, 2015
MFR _Max_Bos _Amendment_0003.pdf	PDF	Aug 6, 2015
Maxwell_BOS_PWS_5_Aug_15_-_Amendment_0003.pdf	PDF	Aug 6, 2015
Amendment_0003.pdf	PDF	Aug 6, 2015
MAX_Additional_Operations_Workload_7_Jul_2015.pdf	PDF	Aug 6, 2015
Signed_DD254.pdf	PDF	Aug 6, 2015
RFP_QAs_Consolidated_Final.xlsx	XLSX spreadsheet	Aug 6, 2015
Maxwell-Gunter_Contractor_Workforce_Demographics_.pdf	PDF	Aug 6, 2015
AFSFMS_Users_Guide_-_June_2008_RevisedMB(13_Nov_08).pdf	PDF	Aug 6, 2015
Real_Property_Report _7115_(22_June_2015)-Amendment_0003.pdf	PDF	Aug 6, 2015
SCA_WD_2005-2011_Rev_18-Amendment_0003.pdf	PDF	Aug 6, 2015
DBA_WD_(All_Combined)-_Amendment_0003.pdf	PDF	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

Show 40 more

Latest 50 of 110 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.

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.