Atch_7-_Manpower_Matrix_SAFB_(final_revision).xlsx

MAN HOURS

AVAILABLE PRODUCTIVE MANHOURS SHEPPARD, AFB - SUPPLY, VEHICLE OPERATIONS AND MAINTENANCE OPERATIONS, MANAGEMENT AND ADMINISTRATIVE SERVICES

Notes: Complete this worksheet for the "total" workforce (a separate matrix is not required for each service area). This matrix divided into 3 categories of labor: Non-exempt employees to include employess covered by the Service Contract Act (SCA) in the Wage Determination category and Collective Bargaining Agreements category. The third ategory 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.

&8FA3020-17-R-0002

Attachment 7 Manpower Matrix-Man-Years 24 Jan 2017 Page1 of 5

&26FOR OFFICIAL USE ONLY

Overall Workforce WORKFORCE MATRIX-SHEPPARD AFB, SUPPLY, VEHICLE OPERATIONS, AND VEHICLE MAINTENANCE AND MANAGEMENT AND ADMINISTRATION SERVICES

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).

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 management and overhead administration). Work is considered overhead when tasks encompasses fifty percent or more of management tasks. Overhead labor refers to on-site management overhead only.

&8FA3020-17-R-0002

Attachment 7 Manpower Matrix-Man-Years 24 Jan 2017

&26FOR OFFICIAL USE ONLY

SUPPLY SERVICES

WORKFORCE MATRIX - SHEPPARD AFB - SUPPLY SUPPORT WORKFORCE MATRIX - SHEPPARD AFB, SUPPLY SUPPORT WORKFORCE MATRIX - SHEPPARD AFB - SUPPLY SUPPORT

Manpower Matrix-Man-Years 24 Jan 2017

&26FOR OFFICIAL USE ONLY

VEHICLE OPS AND MX SERVICES

WORKFORCE MATRIX - SHEPPARD AFB - VEHICLE OPERATIONS AND MAINTENANCE WORKFORCE MATRIX - SHEPPARD AFB - VEHCILE OPERATIONS AND MAINTENANCE WORKFORCE MATRIX - SHEPPARD AFB - VEHICLE OPERATIONS AND MAINTENANCE

Manpower Matrix-Man-Years 24 Jan 2017

&26FOR OFFICIAL USE ONLY

MANAGEMENT AND ADMIN SRVS

WORKFORCE MATRIX - SHEPPARD AFB - VEHICLE OPERATIONS AND MAINTENANCE WORKFORCE MATRIX - SHEPPARD AFB - MANAGEMENT AND ADMINISTRATION SERVICES

Manpower Matrix-Man-Years 24 Jan 2017

&26FOR OFFICIAL USE ONLY