Vance_BOS_ManpowerMatrix_-_13_Aug_14.xlsx

XLSX spreadsheet 74 KB Posted Aug 13, 2014

Attached to: Vance AFB Base Operations Support Federal contract opportunity
Solicitation number: FA3002-13-R-0011
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Attachment 10 - Manpower Matrix

View the file

Other files for this federal contract opportunity

Other files attached to Vance AFB Base Operations Support, newest first.
File	Type	Posted
FA3002-13-R-0011_RFP_Conformed_Copy_-_5_Oct_15.pdf	PDF	Oct 7, 2015
Amendment_0012.pdf	PDF	Oct 5, 2015
18_01_VNC_Fire_Emergency_Services_Description_of_Services_Amendment_0011.pdf	PDF	Sep 25, 2015
FA3002-13-R-0011-_Amendment_0011.pdf	PDF	Sep 25, 2015
401K_Summary_Plan_Description.pdf	PDF	Sep 24, 2015
APPENDIX_B_9_2015docx.pdf	PDF	Sep 24, 2015
APPENDIX_D_2015.pdf	PDF	Sep 24, 2015
18_01_VNC_Fire_Emergency_Services_Description_of_Services_Amendment_0009.pdf	PDF	Jun 23, 2015
Vance_BOS_ManpowerMatrix_-_Amendment_0009.xlsx	XLSX spreadsheet	Jun 23, 2015
11_05_VNC_Operations_Workload_Appendix_Amendment_0009.pdf	PDF	Jun 23, 2015
Signed_Vance_CBA.pdf	PDF	Jan 22, 2015
00_Vance_Title_Page_and_Table_of_contents_Amendment_0004.pdf	PDF	Dec 19, 2014
VNC_VTE_PWS_Amendment_0004-v2.pdf	PDF	Dec 19, 2014
Consolidated_AFAMP_Playbook_Amendment_0004.pdf	PDF	Dec 19, 2014
09_05_VNC_Publishing_Management_Appendix_9B_Workload_amendment_0003.doc	DOC document	Dec 11, 2014
07_04_VNC_Comm_IT__Appendix_7A_Publications_Amendment_0003.pdf	PDF	Dec 11, 2014
10_01_VNC_Installation_Management_Description_of_Services_amendment_0003.pdf	PDF	Dec 11, 2014
11_02_VNC_Operations_Service_Summary_amendment_0003.pdf	PDF	Dec 11, 2014
07_05_VNC_Comm_IT_Appendix_7B_Workload_amendment_0003.doc	DOC document	Dec 11, 2014
Vance_AFB_GM_PWS_Amendment_0003.pdf	PDF	Dec 11, 2014
18_05_VNC_Fire_Emergency_Services_Appendix_18B_Workload_amendment_0003.doc	DOC document	Dec 11, 2014
Vance_RFI_Q A_Nov14.xls	XLS spreadsheet	Dec 2, 2014
FOUO_-_Vance_-_28Apr14 1 .pdf	PDF	Nov 18, 2014
00_Intro_slides.pdf	PDF	Nov 14, 2014
06_Vance_BOS__Past_Performance_(3_Nov_14).pdf	PDF	Nov 14, 2014
ppi_tool.accdb	—	Nov 12, 2014
FA3002-13-R-0011_RFP_Notice_-_Vance_BOS.pdf	PDF	Nov 7, 2014
Technical_Library_Table_Content 1 .pdf	PDF	Nov 6, 2014
VNC_VTE_PWS.pdf	PDF	Nov 6, 2014
Vance_7115_Feb_2014.pdf	PDF	Nov 6, 2014
FA3002-13-R-0011_RFP_Notice_-_Vance_BOS.pdf	PDF	Nov 6, 2014
Updated_HHQ_UP_.pdf	PDF	Nov 6, 2014
Client_authorization_letter.pdf	PDF	Nov 6, 2014
Subcontractor_consent_letter.pdf	PDF	Nov 6, 2014
491_-_Refer_MAS.pdf	PDF	Nov 6, 2014
PAD_12-03_CE_Transformation_w_signature_page_insert__(Signed_26_Oct_2012).pdf	PDF	Nov 6, 2014
Maps_grounds2.pdf	PDF	Nov 6, 2014
Subcontractor_consent_letter.pdf	PDF	Aug 13, 2014
Vance_AFB_PWS_13_Aug_2014.pdf	PDF	Aug 13, 2014
Client_authorization_letter.pdf	PDF	Aug 13, 2014
Vance_BOS_CBA_WD_CBA-2012-5286.pdf	PDF	Aug 13, 2014
Vance_7115_Feb_2014.pdf	PDF	Aug 13, 2014
Statement_of_Equivalent_Rates_-_23_Jul_14.pdf	PDF	Aug 13, 2014
FOUO - Vance - 28Apr14.pdf	PDF	Aug 13, 2014
10_Dec_13_Tier_Pricing_Industry_Q A_Final_-_22_Jan_14.pdf	PDF	Mar 6, 2014
CE_Tier_Workload.xlsx	XLSX spreadsheet	Feb 7, 2014
PWS.pdf	PDF	Feb 7, 2014
General_Transformation_Info.pdf	PDF	Feb 7, 2014
Vance_7115_Feb_2014.pdf	PDF	Feb 7, 2014
DRFP_-FA3002-13-R-0011_13_Aug_14.pdf	PDF	Oct 10, 2013

Show all 50

Vance AFB Base Operations Support 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

VANCE AFB

BASE OPERATING SUPPORT

	SCA - Wage Determination
Total Non-Exempt Workforce	MOB	BASIC	FY16	FY17	FY18	FY19	FY08	FY19
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	344	1744	2096	2080	2080	2088	2088	2080
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	MOB	BASIC	FY16	FY17	FY18	FY19	FY08	FY19
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

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

hygiene, etc.)

Productive Manhours Available

	Non-W.D. & CBA
Total Exempt Workforce	MOB	BASIC	FY16	FY17	FY18	FY19	FY08	FY19
		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	344	1744	2096	2080	2080	2088	2088	2080
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.

Note the Following is Demographics for union & SCA personnel
0-8 years	30%
8-12 years	8%
12-20 years	24.50%
20+ years	37.50%

SOLICITATION NUMBER F41689-02-R-0048

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

Overall Workforce

WORKFORCE MATRIX - VANCE AFB BASE OPERATING SUPPORT (Note 7)

WORKFORCE TOTALS

MOB

BASIC

FY16

FY17

FY18

FY19

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

7. Communication & Information Technology

8.Visual Information Services

9.Publishing Management

10.Installation Management

11.Operations

12.Installation Engineering

18.Fire Services

23.Supply

25.Transportation

26.Purchasing

28.Community Services

TOTAL INDIRECT

2. All Services

7. Communication & Information Technology

8. Visual Information Services

9. Publishing Management

10.Installation Management

11.Operations

12.Installation Engineering

18.Fire Services

23.Supply

25.Transportation

26.Purchasing

28.Community Services

TOTAL OVERHEAD

2. All Services

7. Communication & Information Technology

8. Visual Information Services

9. Publishing Management

10.Installation Management

11.Operations

12.Installation Engineering

18.Fire Services

23.Supply

25.Transportation

26.Purchasing

28.Community Services

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 F41689-00-R-0050

Attachment 13 Page &P of &N

Mob

WORKFORCE MATRIX -VANCE AFB BASE OPERATING SUPPORT

MOBILIZATION

MOB

FY16

FY17

FY18

FY19

FY08

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

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

ALL-SERVICE (2)

WORKFORCE MATRIX -VANCE AFB BASE OPERATING SUPPORT

ALL-SERVICE REQUIREMENTS

MOB

BASIC

FY16

FY17

FY18

FY19

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

Comm & IT (7)

WORKFORCE MATRIX - VANCE AFB BASE OPERATING SUPPORT

COMMUNICATION & INFORMATION TECHNOLOGY

MOB

BASIC

FY16

FY17

FY18

FY19

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

Visual Information (8)

WORKFORCE MATRIX - VANCE AFB BASE OPERATING SUPPORT

VISUAL INFORMATION SERVICES

MOB

BASIC

FY16

FY17

FY18

FY19

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 Mgt (9)

WORKFORCE MATRIX - VANCE AFB BASE OPERATING SUPPORT

PUBLISHING MANAGEMENT

MOB

BASIC

FY16

FY17

FY18

FY19

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 Mgt (10)

WORKFORCE MATRIX - VANCE AFB BASE OPERATING SUPPORT

INSTALLATION MANAGEMENT

MOB

BASIC

FY16

FY17

FY18

FY19

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 - VANCE AFB BASE OPERATING SUPPORT

OPERATIONS

MOB

BASIC

FY16

FY17

FY18

FY19

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 - VANCE AFB BASE OPERATING SUPPORT

INSTALLATION ENGINEERING

MOB

BASIC

FY16

FY17

FY18

FY19

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

Fire (18)

WORKFORCE MATRIX -VANCE AFB BASE OPERATING SUPPORT

FIRE SERVICES

MOB

BASIC

FY16

FY17

FY18

FY19

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 -VANCE AFB BASE OPERATING SUPPORT

SUPPLY

MOB

BASIC

FY16

FY17

FY18

FY19

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 - VANCE AFB BASE OPERATING SUPPORT

TRANSPORTATION

MOB

BASIC

FY16

FY17

FY18

FY19

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

Purchasing (26)

WORKFORCE MATRIX -VANCE AFB BASE OPERATING SUPPORT

PURCHASING

MOB

BASIC

FY16

FY17

FY18

FY19

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 - VANCE AFB BASE OPERATING SUPPORT

COMMUNITY SERVICES

MOB

BASIC

FY16

FY17

FY18

FY19

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.