Atch 8_Manpower Matrix.xlsx

XLSX spreadsheet 63 KB Posted Jul 11, 2017

Attached to: AWARD NOTICE: Sheppard Air Force Base, Base Maintenance Contract (BMC)
Solicitation number: FA3002-16-R-0019
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Not Listed

View the file

Other files

File	Type	Posted
Atch 6_PPI Tool Instructions _7 Aug 17.pdf	PDF	Aug 22, 2017
FA3002-16-R-0019-0003.docx	DOCX document	Aug 22, 2017
Sheppard AFB BMC PWS Summary of Changes_18Aug17.pdf	PDF	Aug 22, 2017
Tech Library_SAFB Snow and Ice Control Plan 4-4-16.pdf	PDF	Aug 22, 2017
Atch 8_Manpower Matrix_7 Aug 17.xlsx	XLSX spreadsheet	Aug 22, 2017
Sheppard AFB BMC PWS_18Aug17.pdf	PDF	Aug 22, 2017
QA Government Response_21Aug17.xlsx	XLSX spreadsheet	Aug 22, 2017
Atch 21_Sections L and M_21Aug17.docx	DOCX document	Aug 22, 2017
FA3002-16-R-0019-0002.docx	DOCX document	Aug 3, 2017
Sheppard_Pre-Proposal_Conf_Sign-In_Sheets.pdf	PDF	Aug 3, 2017
Sheppard_BMC_PWS_3_Aug_2017.pdf	PDF	Aug 3, 2017
https://www.fbo.gov/utils/view?id=772bf55182c342f8dcff6522131f3264	—	Aug 3, 2017
Atch_11_-_Performance_Incentive_Plan_2_Aug_2017.docx	DOCX document	Aug 3, 2017
Sheppard_BMC_Pre-Proposal_Conf_Brief_Final.ppt	PPT presentation	Aug 3, 2017
Atch_21_Sections_L_and_M_2_Aug_2017.docx	DOCX document	Aug 3, 2017
Sheppard_BMC_Summary_of_Changes__3_Aug_2017.pdf	PDF	Aug 3, 2017
FA3002-16-R-0019-0001.pdf	PDF	Jul 12, 2017
FA3002-16-R-0019-0001.pdf	PDF	Jul 12, 2017
FA3002-16-R-0019-0001.pdf	PDF	Jul 12, 2017
Atch 21_Sections L and M_30 Jun 2017.docx	DOCX document	Jul 11, 2017
Atch 2_ SCA WD 15-5263.pdf	PDF	Jul 11, 2017
Atch 6_PPI Tool Instructions.pdf	PDF	Jul 11, 2017
Atch 9_Q and A Template.xlsx	XLSX spreadsheet	Jul 11, 2017
1_Sheppard Pre-Proposal Conference and Site Visit Invitation.docx	DOCX document	Jul 11, 2017
2_Sheppard Site Visit.xlsx	XLSX spreadsheet	Jul 11, 2017
Atch 1_Sheppard PWS_11 Jul 2017.pdf	PDF	Jul 11, 2017
4_Sheppard Map.pdf	PDF	Jul 11, 2017
Atch 20_SB Ind Subcontracting Plan Checklist.docx	DOCX document	Jul 11, 2017
Atch 19a_FY16 Inventory_Software.pdf	PDF	Jul 11, 2017
Atch 16_WBS SAFB_16 Mar 2016.xlsx	XLSX spreadsheet	Jul 11, 2017
Atch 17_Incidental to Place of Performance.xls	XLS spreadsheet	Jul 11, 2017
Atch 18_ECS and ME Functions - 09 Nov 16.docx	DOCX document	Jul 11, 2017
RFP_Package.zip	ZIP file	Jul 11, 2017
Atch 12_Tech Library Notice.docx	DOCX document	Jul 11, 2017
Atch 13 - Workforce Demographic.docx	DOCX document	Jul 11, 2017
3_MapToSheppardClub.pdf	PDF	Jul 11, 2017
Atch 10_ Consolidated GFP Attachment _v1_Sheppard.xlsx	XLSX spreadsheet	Jul 11, 2017
Atch 19b_FY16 Inventory_ITE.PDF	PDF	Jul 11, 2017
Atch 14_Section B and Price Proposal Workbook.xlsx	XLSX spreadsheet	Jul 11, 2017
Atch 7_ Sample Client Authorization Letter.docx	DOCX document	Jul 11, 2017
Atch 5_ Sample Subcontractor Letter of Consent.docx	DOCX document	Jul 11, 2017
1_FA3002-16-R-0019 - Sheppard BMC RFP - 11Jul2017.pdf	PDF	Jul 11, 2017
Atch 11 - Performance Incentive Plan_23 Jun 17.docx	DOCX document	Jul 11, 2017
Atch 4_DDForm254.pdf	PDF	Jul 11, 2017
Atch 3_CBA FY17 PAE SAFB.PDF	PDF	Jul 11, 2017
Atch 15_QASP_SAFB.pdf	PDF	Jul 11, 2017
Sheppard_Draft_RFP_Master_Q&A_17May17.xlsx	XLSX spreadsheet	May 18, 2017
Sheppard_BMC_DRAFT_RFP_documents.zip	ZIP file	Apr 12, 2017

Show all 48

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

SHEPPARD AFB

BASE MAINTENANCE CONTRACT SUPPORT

	SCA - Wage Determination
Total Non-Exempt Workforce	Base Period (30-day Mobilization)
FY18	Base Period

(11 Months)

FY19	FY20	FY21	FY22	FY23	IOP 1 FY24	IOP 2 FY 25
		Manhours		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	152	1840	2088	2080	2080	2080	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	FY18	FY19	FY20	FY21	FY22	FY23	IOP 1 FY24	IOP 2 FY 25
		Manhours		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	152	1840	2088	2080	2080	2080	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	FY18	FY19	FY20	FY21	FY22	FY23	IOP 1 FY24	IOP 2 FY 25
		Manhours		Manhours	Manhours	Manhours	Manhours	Manhours	Manhours

Annual Manhours Available	152	1840	2088	2080	2080	2080	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.

RFP Attachment 8

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

Overall Workforce

WORKFORCE MATRIX - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
WORKFORCE TOTALS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

F/T

P/T

TOTAL DIRECT

2. All Services

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

TOTAL INDIRECT

2. All Services

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

TOTAL OVERHEAD

2. All Services

10. Installation Management

11. Operations

12. Installation Engineering

14. Emergency Management

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.

Attachment 13 Page &P of &N

All Services (2)

WORKFORCE MATRIX - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
ALL-SERVICE REQUIREMENTS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

Installation Mgmt (10)

WORKFORCE MATRIX - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
ALL-SERVICE REQUIREMENTS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

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 - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
ALL-SERVICE REQUIREMENTS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

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 - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
ALL-SERVICE REQUIREMENTS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

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 - SHEPPARD AFB BASE MAINTENANCE CONTRACT SUPPORT
ALL-SERVICE REQUIREMENTS	BASE

(30-day Mob)

FY 18 BASE

(11 Mos)

FY 19

FY20

FY21

FY22

FY23

FY24

FY25

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

F/T

P/T

DIRECT

TOTAL DIRECT

INDIRECT

TOTAL INDIRECT

OVERHEAD

TOTAL OVERHEAD

TOTAL

OVERTIME

LAPSE

Attachment 13 Page &P of &N

File details come from the government source that posted it. Updated Nov 14, 2017.