Maxwell_Manpower_Matrix_Atch_9_14_Sep_2015.xlsx

XLSX spreadsheet 79 KB Posted Sep 15, 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 (Attachment 9)

View the file

Other files for this federal contract opportunity

Other files attached to Maxwell-Gunter BOS, newest first.
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
Maxwell_Memorandum_Amendment_0007.docx	DOCX document	Jun 14, 2016
FA3002-13-R-0012-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
Amendment_0007_Modification_Document.doc	DOC document	May 25, 2016
Vehicle_Replacement_Comment-Question.pdf	PDF	Oct 13, 2015
MFR-_Amendment_0006.pdf	PDF	Oct 7, 2015
Maxwell_BOS_PWS_Revised_Amend_5_(17_Sep_15).pdf	PDF	Sep 17, 2015
Attachment_5_-_PPI_Tool_Instructions.pdf	PDF	Sep 15, 2015
Maxwell_BOS_RFP_(Conformed_Copy).pdf	PDF	Sep 15, 2015
Maxwell_RFP_Amendment_4_Q A.xls	XLS spreadsheet	Aug 26, 2015
MAX_Additional_Operations_Workload_7_Jul_2015.pdf	PDF	Aug 6, 2015
Real_Property_Report _7115_(22_June_2015)-Amendment_0003.pdf	PDF	Aug 6, 2015
MFR _Max_Bos _Amendment_0003.pdf	PDF	Aug 6, 2015
Maxwell_BOS_PWS_5_Aug_15_-_Amendment_0003.pdf	PDF	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
Maxwell_BOS_Technical_Requirements.pptx	PPTX presentation	May 15, 2015
Maxwell_BOS__Past_Performance_(13_May_15).pptx	PPTX presentation	May 15, 2015
Maxwell_BOS_Welcome_(13_May_2015).pptx	PPTX presentation	May 15, 2015
Maxwell_BOS_PWS.pptx	PPTX presentation	May 15, 2015
ppi_tool.accdb	—	May 7, 2015
FA3002-13-R-0012_-_Maxwell_RFP_Amend_0001.pdf	PDF	May 5, 2015
Maxwell-Gunter_Site_Visit_Letter.pdf	PDF	May 5, 2015
Maxwell-Gunter_BOS_RFP_Questions_and_Answers_Form.doc	DOC document	Apr 30, 2015
SubC_Checklist.pdf	PDF	Apr 30, 2015
Maxwell_BOS_PWS_9_Apr_15.pdf	PDF	Apr 30, 2015
Client_authorization_letter.pdf	PDF	Apr 30, 2015
(Residential).pdf	PDF	Apr 30, 2015
WD_05-2011_(Rev._-17).pdf	PDF	Apr 30, 2015
Maxwell-Gunter_Site_Visit_Letter.pdf	PDF	Apr 30, 2015
Maxwell_BOS_Draft_RFP.doc	DOC document	Jan 12, 2015
FA3002-13-R-0012_Maxwell_BOS_Pre-Solicitation_Notice_(30_Dec_15).docx	DOCX document	Jan 6, 2015
Maxwell_BOS_-_Section_L.docx	DOCX document	Dec 19, 2014
Maxwell_Draft_PWS_14_Nov_14.pdf	PDF	Nov 14, 2014
10_Dec_13_Tier_Pricing_Industry_Q A.pdf	PDF	Mar 6, 2014
Sample_-_Maxwell_CLIN_X016.xlsx	XLSX spreadsheet	Mar 6, 2014
CE_Technical_Library_Table_Content.doc	DOC document	Feb 7, 2014
Tier_Pricing_Documents.zip	ZIP file	Feb 7, 2014
MOUs_and_MOAs.zip	ZIP file	Feb 7, 2014
MAS_Sheets.zip	ZIP file	Feb 7, 2014
7115_Report.zip	ZIP file	Feb 7, 2014
General_Transformation_Information.zip	ZIP file	Feb 7, 2014
DRAFT_Concept_PI_Clause.docx	DOCX document	Aug 21, 2013
Initial_Draft_PWS_Q A_-_Maxwell_BOS.xlsx	XLSX spreadsheet	May 23, 2013
PWS_Draft_(v1)_-_File_3_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 (Attachment 9)

	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

Attachment 9

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.