Vance_BOS_ManpowerMatrix_-_13_Aug_14.xlsx

XLSX spreadsheet 74 KB Posted Nov 6, 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

FA3002-13-R-0011 Vance BOS Attachment 10 Vance BOS 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
Amendment_0013_-_Vance_BOS.pdf	PDF	Apr 21, 2016
Final_CBA_August_2015.pdf	PDF	Sep 24, 2015
Signature_Page_072315.pdf	PDF	Sep 24, 2015
Amendment_0008.pdf	PDF	Jun 23, 2015
11_05_VNC_Operations_Workload_Appendix_Amendment_0008.pdf	PDF	Jun 23, 2015
28_01_VNC_Community_Services.pdf	PDF	Jun 23, 2015
Vance_RFI_Q A.xls	XLS spreadsheet	Jan 23, 2015
Vance_AFB_Custodial_PWS_admendment_0004.pdf	PDF	Dec 19, 2014
Copy_of_Vance_BOS_Workbook_11_Dec_14_pm.xlsx	XLSX spreadsheet	Dec 11, 2014
Vance_AFB_Custodial_PWS_admendment_0003.pdf	PDF	Dec 11, 2014
02_01_VNC_Applicable_to_All_Services_Description_of_Services_amendment_0003-V2.pdf	PDF	Dec 11, 2014
02_05_VNC_Applicable_to_All_Services_Appendix_2B_Workload_amendment_0003.doc	DOC document	Dec 11, 2014
28_05_VNC_Community_Services_Appendix_28B_Workload_admendment_0003.doc	DOC document	Dec 11, 2014
Amendment_0003.pdf	PDF	Dec 11, 2014
Amendment_0001-_25_Nov_14_-_Change_in_Past_Performance_Vol_III_Submission_Date.pdf	PDF	Nov 25, 2014
01_Wing_Mission_Brief.pdf	PDF	Nov 14, 2014
AttendeesActual.pdf	PDF	Nov 14, 2014
DeCA_Approved_Agreement_14_Mar_05.pdf	PDF	Nov 6, 2014
DBA___OK140008_(Residential).pdf	PDF	Nov 6, 2014
CFIS_Approved_Agreement_21_Dec_05.pdf	PDF	Nov 6, 2014
Vance__AFB_Dumpster_Locations.pdf	PDF	Nov 6, 2014
P-Plan_Revision_1_for_Implementation_of_PAD_12-03_-_Vol_3 1 .pdf	PDF	Nov 6, 2014
PAD_12-03_Rev_1_MAJCOM_Org_Chart.pdf	PDF	Nov 6, 2014
Tab_4_-_Atch_3_to_Tab_1_-Work_Prioritization_Implementation_Plan.pdf	PDF	Nov 6, 2014
Vance_BOS_CBA_WD_CBA-2012-5286.pdf	PDF	Nov 6, 2014
Vance_AFB_Custodial_PWS.pdf	PDF	Nov 6, 2014
457_-_Paint_MAS.pdf	PDF	Nov 6, 2014
Vance_AFB_GM_PWS.pdf	PDF	Nov 6, 2014
Army_BRAC_Approved_Agreement.pdf	PDF	Nov 6, 2014
Vance_AFB_ISWM_(Refuse-Recycling)_PWS.pdf	PDF	Nov 6, 2014
WBS_-_Example-_18_Jul_14(1).xlsx	XLSX spreadsheet	Nov 6, 2014
Vance_BOS_RFP_-_Questions_and_Answers_(Q A)_Form.doc	DOC document	Nov 6, 2014
PAD_12-03_MAJCOM_OSCs_Revision_I.pptx	PPTX presentation	Nov 6, 2014
Armed_Forces_Reserve_Center_Support_Agreement.pdf	PDF	Nov 6, 2014
Vance_Custodial_Drawings.pdf	PDF	Nov 6, 2014
2014_SCA_H W_Fringe_Benefit_Changes.pdf	PDF	Nov 6, 2014
471_-_Electric_MAS.pdf	PDF	Nov 6, 2014
P-Plan_Revision_1_for_Implementation_of_PAD_12-03_-_Vol_1 1 .pdf	PDF	Nov 6, 2014
VNC_Additional_CE_Workload_Data(1)10_June_14.pdf	PDF	Nov 6, 2014
FA3002-13-R-0011_Vance_BOS_Pre-Solicitation_Notice_(26_Sep_2014)_(2).pdf	PDF	Sep 26, 2014
SCA_WD_2005-2432_Rev_17_dated_19_Jun_13.pdf	PDF	Aug 13, 2014
MOAs.zip	ZIP file	Aug 13, 2014
Support_Agreements_Part_2.zip	ZIP file	Aug 13, 2014
RWP.zip	ZIP file	Aug 13, 2014
Technical_Library_Table_Content.pdf	PDF	Aug 13, 2014
VANCE_BOS_CBA.pdf	PDF	Aug 13, 2014
FOUO - Vance - 28Apr14.pdf	PDF	Aug 13, 2014
Sample_-_Vance_CLIN_10_Revised_6_Feb_14.xlsx	XLSX spreadsheet	Mar 6, 2014
Vance_BOS_Schedule_B.pdf	PDF	Mar 6, 2014
ROAD_MAP_to_complete_CE_Tier_workload.xlsx	XLSX spreadsheet	Feb 7, 2014

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.