Vance_BOS_ManpowerMatrix_-_Amendment_0009.xlsx

XLSX spreadsheet 75 KB Posted Jun 23, 2015

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

Vance BOS Manpower Matrix

View the file

Other files

File	Type	Posted
Amendment_0013_-_Vance_BOS.pdf	PDF	Apr 21, 2016
FA3002-13-R-0011_RFP_Conformed_Copy_-_5_Oct_15.pdf	PDF	Oct 7, 2015
11_05_VNC_Operations_Workload_Appendix_Amendment_0012.pdf	PDF	Oct 5, 2015
Amendment_0012.pdf	PDF	Oct 5, 2015
18_01_VNC_Fire_Emergency_Services_Description_of_Services_Amendment_0011.pdf	PDF	Sep 25, 2015
MFR-_Amendment_0009.pdf	PDF	Sep 25, 2015
FA3002-13-R-0011-_Amendment_0011.pdf	PDF	Sep 25, 2015
FA3002-13-R-0011-Amendment_0009.pdf	PDF	Sep 25, 2015
APPENDIX_C2015.pdf	PDF	Sep 24, 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
Final_CBA_August_2015.pdf	PDF	Sep 24, 2015
Signature_Page_072315.pdf	PDF	Sep 24, 2015
Amendment_0010.pdf	PDF	Sep 24, 2015
18_01_VNC_Fire_Emergency_Services_Description_of_Services_Amendment_0009.pdf	PDF	Jun 23, 2015
11_05_VNC_Operations_Workload_Appendix_Amendment_0009.pdf	PDF	Jun 23, 2015
FA3002-13-R-0011-Amendment_0009.pdf	PDF	Jun 23, 2015
28_01_VNC_Community_Services.pdf	PDF	Jun 23, 2015
11_05_VNC_Operations_Workload_Appendix_Amendment_0008.pdf	PDF	Jun 23, 2015
18_01_VNC_Fire_Emergency_Services_Description_of_Services_Amendment_0008.pdf	PDF	Jun 23, 2015
Amendment_0008.pdf	PDF	Jun 23, 2015
11_03_VNC_Operations_General_Information_Amendment_0008.pdf	PDF	Jun 23, 2015
Vance_RFI_Q A_-_28_Jan_15.xls	XLS spreadsheet	Jan 28, 2015
Vance_RFI_Q A.xls	XLS spreadsheet	Jan 23, 2015
Amendment_0007.pdf	PDF	Jan 23, 2015
11_04_VNC_Operations_Appendix_11A_Publications_Amendment0007.pdf	PDF	Jan 23, 2015
Signed_Vance_CBA.pdf	PDF	Jan 22, 2015
Amendment_0006.pdf	PDF	Jan 12, 2015
Amendment_0005.pdf	PDF	Dec 31, 2014
Vance_RFI_Q A_Nov14.xls	XLS spreadsheet	Dec 19, 2014
Vance_AFB_Custodial_PWS_admendment_0004.pdf	PDF	Dec 19, 2014
00_Vance_Title_Page_and_Table_of_contents_Amendment_0004.pdf	PDF	Dec 19, 2014
Tab_4_-_CAMP_VANCE_AFB_Prospectus_Amendment_0004.pdf	PDF	Dec 19, 2014
Vance_AFB_GM_PWS_Amendment_0004-v2.pdf	PDF	Dec 19, 2014
VNC_VTE_PWS_Amendment_0004-v2.pdf	PDF	Dec 19, 2014
Vance_AFB_ISWM_(Refuse-Recycling)_PWS-_Amendment_0004.pdf	PDF	Dec 19, 2014
Consolidated_AFAMP_Playbook_Amendment_0004.pdf	PDF	Dec 19, 2014
Tab_1_-_VANCE_AFB_Prospectus_-_signed___Amendment_0004.pdf	PDF	Dec 19, 2014
Amendment_0004_-_19_Dec_14.pdf	PDF	Dec 19, 2014
Recycling_Pick-Up_Schedule_Amendment_0004.pdf	PDF	Dec 19, 2014
CBA_Memo_-_19_Dec_14.docx	DOCX document	Dec 19, 2014
Vance_RFI_Q A_Nov14.xls	XLS spreadsheet	Dec 11, 2014
Copy_of_Vance_BOS_Workbook_11_Dec_14_pm.xlsx	XLSX spreadsheet	Dec 11, 2014
28_05_VNC_Community_Services_Appendix_28B_Workload_admendment_0003.doc	DOC document	Dec 11, 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
Amendment_0003.pdf	PDF	Dec 11, 2014
10_05_VNC_Installation_Management_Appendix_10B_Workload_amendment_0003.doc	DOC document	Dec 11, 2014
26_05_VNC_Purchasing_Appendix_26B_Workload_amendment_0003_.doc	DOC document	Dec 11, 2014

Show 40 more

Latest 50 of 206 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

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, with the exception of scheduled overtime for Fire Emergency Services personnel (FES Operations, Asst Fire Chief(s) of Operations and ECC dispatchers). 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.