B08 Attachment 0002 - Staffing and Labor Mix.xlsx

XLSX spreadsheet 35 KB Posted Dec 9, 2024

Attached to: EAGLE Fort Huachuca, AZ W519TC-24-R-0027
Solicitation number: W519TC24R0027
Issued by: Department of the Army Materiel Command Contracting Command Rock Island Arsenal

About this file

Written by GovTribe AI · Dec 10, 2024

This is a staffing and labor mix template spreadsheet for a contract at Fort Huachuca, AZ that requires contractors to detail their proposed staffing across Program Management Office (PMO), Maintenance, Supply, and Transportation functional areas. The template requires input of proposed hours per FTE for both base period and option periods 1-4, with separate tracking for exempt, CBA, and SCA labor categories.

The spreadsheet is divided into sections for different service areas with specific CLINs: PMO (CLIN 0002), Maintenance (CLIN 0003), Supply (CLIN 0004), and Transportation (CLIN 0005). For each area, contractors must specify FTE counts, labor categories, SCA codes, security clearance requirements, and whether positions are exempt or non-exempt. An example is provided showing sample entries including positions like Project Manager, Quality Manager, Welders, Aerospace Mechanics, Supply Technicians, and Transportation specialists. Failure to complete the template in the required format will result in the proposal being deemed non-compliant.

View the file

Other files

File	Type	Posted
B08 Attachment 0038 - FHAZ Q and A Responses Round 2.xlsx	XLSX spreadsheet	Jan 22, 2025
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V4.xlsx	XLSX spreadsheet	Jan 22, 2025
B08 Attachment 0007 - Wage Determination 15-5719 REV 24.pdf	PDF	Jan 22, 2025
B08 - W519TC24R0027-0004.pdf	PDF	Jan 22, 2025
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V3.xlsx	XLSX spreadsheet	Jan 13, 2025
W519TC24R0027-0003.pdf	PDF	Jan 13, 2025
B08 Attachment 0024 - PWS Appendix B - Non-ASC Direct Funded Customer USAICoE 111th V2.pdf	PDF	Jan 13, 2025
B08 - Exhibit B - Contract Data Requirements List Listing V2.xlsx	XLSX spreadsheet	Jan 13, 2025
B08 Attachment 0037 - FHAZ Q and A Responses Round 1.xlsx	XLSX spreadsheet	Jan 13, 2025
B08 - W519TC24R0027-0002.pdf	PDF	Jan 2, 2025
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V2.xlsx	XLSX spreadsheet	Dec 11, 2024
B08 - W519TC24R0027-0001.pdf	PDF	Dec 11, 2024
B08 Attachment 0021 - PWS Annex E - Definitions_Acronyms_ Abbreviations.pdf	PDF	Dec 10, 2024
B08 Attachment 0005 - Cost Price Matrix-FHAZ.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0010 - Blocked File Extensions-with updated DoDAAC.pdf	PDF	Dec 9, 2024
B08 - Exhibit B - Contract Data Requirements List Listing.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0011 - Contract References Spreadsheet_FHAZ.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0017 - PWS Annex A - Maintenance PRS.pdf	PDF	Dec 9, 2024
B08 Attachment 0024 - PWS Appendix B - Non-ASC Direct Funded Customer USAICoE 111th.pdf	PDF	Dec 9, 2024
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System SF 1408.pdf	PDF	Dec 9, 2024
B08 Attachment 0020 - PWS Annex D - Environmental Requirements.pdf	PDF	Dec 9, 2024
B08 Attachment 0001 - Performance Work Statement (PWS).pdf	PDF	Dec 9, 2024
B08 Attachment 0009 - Purchasing Invoicing Guide (PIG) FHAZ.pdf	PDF	Dec 9, 2024
B08 Attachment 0033 - FHAZ Industry Question Template.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0007 - Wage Determination 15-5719 REV 23.pdf	PDF	Dec 9, 2024
B08 - Exhibit J - PM-12 KTR Accident Reporting Format.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0023 - PWS Appendix A - Non-ASC Direct Funded Customer IMCOM.pdf	PDF	Dec 9, 2024
B08 - Exhibit D - ITD-01 Transportation Report Format.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0003 - Performance Questionnaire-FHAZ.pdf	PDF	Dec 9, 2024
B08 Attachment 0013 - NOT APPLICABLE.pdf	PDF	Dec 9, 2024
B08 - Exhibit G - PM-08 Scheduled Government Furnished Property Format.xlsx	XLSX spreadsheet	Dec 9, 2024
W519TC24R0027.pdf	PDF	Dec 9, 2024
B08 Attachment 0015 - Subcontractor Cost Information Submission.pdf	PDF	Dec 9, 2024
B08 - Exhibit H - PM-09 Performance Management Review Format (version 5-01-23).pptx	PPTX presentation	Dec 9, 2024
B08 Attachment 0018 - PWS Annex B - Supply PRS.pdf	PDF	Dec 9, 2024
B08 - Exhibit K - SS-01 Supply and Services Report Format.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 - Exhibit E - MMD-01 Maintenance Report Format.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 - Exhibit A - DD Form 1423-1 Contract Data Requirements List.pdf	PDF	Dec 9, 2024
B08 Attachment 0014 - NOT APPLICABLE.pdf	PDF	Dec 9, 2024
B08 Attachment 0004 - Letter of Consent-FHAZ.pdf	PDF	Dec 9, 2024
B08 Attachment 0025 - PWS Appendix C - Non-ASC Direct Funded Customer EPG.pdf	PDF	Dec 9, 2024
B08 - Exhibit F - PM-01 Contractor Employee Information Format.xlsx	XLSX spreadsheet	Dec 9, 2024
B08 Attachment 0019 - PWS Annex C - Transportation PRS.pdf	PDF	Dec 9, 2024
B08 Attachment 0022 - PWS Annex F - Publications and Forms.pdf	PDF	Dec 9, 2024
B08 - Exhibit C - CD-02 Burn Rate Report Format.xlsx	XLSX spreadsheet	Dec 9, 2024

Show all 45

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.

Staff & Labor Mix

As of 01 June 2023
LRC Ft. Huachuca, AZ
Formulate proposed hours for your Fully Operational Capable staffing. Refer to L.5.2.1.1(c)(6) for more information on this form.	Base Period Proposed Hours per FTE:			Option Periods 1 - 4 Proposed Hours per FTE:
	Hours Per Year	Employee Type	Provide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).	Hours Per Year	Employee Type	Provide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).
		Exempt			Exempt
		CBA 1 (if applicable)			CBA 1 (if applicable)
		CBA 2 (if applicable)			CBA 2 (if applicable)
		SCA (non-CBA)			SCA (non-CBA)
L.5.2.1.1(c) Staffing/Labor Mix (Attachment 0002 - Staffing/Labor Mix): Staffing/Labor Mix (Attachment 0002 - Staffing/Labor Mix): The Offeror must provide its proposed staffing mix/labor categories (skill sets / skill level, number of employees) in relation to the PWS requirements and Attachment xxxx TD-02 Workload Data and Density List. (see applicable Technical Data) for both the base period and option periods (fully operational capable 12-month periods (365 day periods)). The Offeror's proposal must present a staffing approach which demonstrates a thorough understanding of the effort and provides the expected skill sets / skill level of each position, to include level of responsibility in order to successfully perform the specific workload requirements.

L.5.2.1.1(c)(3)(i) The Offeror shall not add or remove any tabs (other than the example tab) to the Attachment 0002 Staffing/Labor Mix.

L . 5 . 2 . 1 . 1 ( c ) ( 4 ) COMPLIANCE REQUIREMENT: Failure to provide the Staffing/Labor Mix Attachment 0002 in the Government provided format, in_ compliance with L.5.2.1.1(c)(3) and L.5.2.1.1(c)(3)(i), and to provide the following required information, shall render the Offeror's_proposal non-compliant, and the proposal will not be evaluated and will not be further considered for award: proposed hours per FTE for_both the base period and option periods 1-4; identification of SCA/Exempt; SCA Code; Offeror Position Title.

NOTE: Offerors are allowed to add more rows by using the Excel insert row feature.

Option Period Total Proposed FLC1 Hours by Functional Area
	Maintenance	Supply	Transportation
FLC1 Proposed

FFP Program Management Office (PMO)
Labor Category					CLIN 0002AA	CLIN 0002BA	CLIN 0002CA	CLIN 0002DA	CLIN 0002EA
					ASC Maint SAG 131 PMO	ASC Supply Support SAG 131 PMO	ASC ASP SAG 121 PMO	Non-ASC IMCOM PMO	ASC Trans SAG 131 PMO
FLC1 / FLC2	SCA/CBA Exempt	SCA Code	Offeror Provided Position Title or SCA Position Title/CBA	Secret Clearance Yes(Y)	FTE Count	FTE Count	FTE Count	FTE Count	FTE Count

Total FTE's	0.00	0.00	0.00	0.00	0.00
Total Maintenance FTE's	0.00

Mantenance Functional Area
Labor Category					CLIN 0003AA	CLIN 0003BA	CLIN 0003CA
					ASC BASOPS Maintenance	Non-ASC EPG	Non-ASC ISEC
FLC1 / FLC2	SCA/CBA Exempt	SCA Code	Offeror Provided Position Title or SCA Position Title/CBA	Secret Clearance Yes(Y)	FTE Count	FTE Count	FTE Count

Total FTE's	0.00	0.00	0.00
Total Maintenance FTE's	0.00

Supply Functional Area
Labor Category					CLIN 0004AA	CLIN 0004BA	CLIN 0004CA	CLIN 0004DA	CLIN 0004EA	CLIN 0004FA	CLIN 0004GA
					ASC CIF Supply	ASC CIPBO Supply	ASC HAZMAT Supply	ASC ASP Supply	ASC Retail Supply/SSA	ASC Wholesale Fuel Supply	Non-ASC IMCOM POL Fuel Labor
FLC1 / FLC2	SCA/CBA Exempt	SCA Code	Offeror Provided Position Title or SCA Position Title/CBA	Secret Clearance Yes(Y)	FTE Count	FTE Count	FTE Count	FTE Count	FTE Count	FTE Count	FTE Count

Total FTE's	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Total Supply FTE's	0.00

Transportation Functional Area
Labor Category					CLIN 0005AA	CLIN 0005BA	CLIN 0005CA	CLIN 0005DA	CLIN 0005EA
					ASC Fleet Management Operation	ASC Freight/Cargo Movement	ASC Personnel Movement and Travel Service	ASC Personal Property Office	Non-ASC 111th MI BDE
FLC1 / FLC2	SCA/CBA Exempt	SCA Code	Offeror Provided Position Title or SCA Position Title/CBA	Secret Clearance Yes(Y)	FTE Count	FTE Count	FTE Count	FTE Count	FTE Count

Total FTE's	0.00	0.00	0.00	0.00
Total Transportation FTE's
Grand Total PMO, Maintenance, Supply, and Transportation FTEs

EXAMPLE

As of 01 June 2023

Joint Base Langford-Wahl

(not intended to portray actual site, data or effort)

Formulate proposed hours for your Fully Operational Capable staffing. Refer to L.5.2.1.1(c)(6) for more information on this form.	Base Period Proposed Hours per FTE:			Option Periods 1 - 4 Proposed Hours per FTE:
	Hours Per Year	Employee Type	Provide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).	Hours Per Year	Employee Type	Provide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).
	1586.00	Exempt		1580.00	Exempt
	1542.00	CBA 1 (if applicable)		1856.00	CBA 1 (if applicable)
	1700.00	CBA 2 (if applicable)		1920.00	CBA 2 (if applicable)
	1700.00	SCA (non-CBA)		1920.00	SCA (non-CBA)
L.5.2.1.1(c) Staffing/Labor Mix (Attachment 0002 - Staffing/Labor Mix): Staffing/Labor Mix (Attachment 0002 - Staffing/Labor Mix): The Offeror must provide its proposed staffing mix/labor categories (skill sets / skill level, number of employees) in relation to the PWS requirements and Attachment 003 TD-02 Workload Data and Density List. (see applicable Technical Data) for both the base period and option periods (fully operational capable 12-month periods (365 day periods)). The Offeror's proposal must present a staffing approach which demonstrates a thorough understanding of the effort and provides the expected skill sets / skill level of each position, to include level of responsibility in order to successfully perform the specific workload requirements.

L.5.2.1.1(c)(3)(i) The Offeror shall not add or remove any tabs (other than the example tab) to the Attachment 0002 Staffing/Labor Mix.

NOTE: Offerors are allowed to add more rows by using the Excel insert row feature.

Option Period Total Proposed FLC1 Hours by Functional Area
	Maintenance	Supply	Transportation
FLC1 Proposed	50,510.00	15,541.20	67,182.00

Program Management Office (PMO)
Labor Category					FFP PMO
					CLIN 0002
FLC1 / FLC2	SCA/CBA Exempt	SCA Code	Offeror Provided Position Title or SCA Position Title/CBA	Secret Clearance Yes(Y)	FTE Count
FLC2	Exempt		Project Manager		1.00
FLC2	Exempt		Quality Manager		1.00
FLC2	SCA	01020	Administrative Assistance		1.00

Total PMO FTE's 3

Mantenance Functional Area

Labor Category

CLIN 0003AA

CLIN 0003BA

SDDC

PASSBACK

FLC1 / FLC2

SCA/CBA Exempt

SCA Code

Offeror Provided Position Title or SCA Position Title/CBA

Secret Clearance Yes(Y)

FTE Count

FLC1

SCA

23010

Welder

1.50

2.50

FLC1

CBA 1

Aerospace Master Mechanic

18.00

2.00

FLC1

CBA 2

Aerosapce Inspector

2.50

1.50

Total FTE's	22	6	0	0	0	0	0	0	0	0
Total Maintenance FTE's	28

Supply Functional Area

Labor Category

CLIN 0004AA

CLIN 0004BA

CIF

ISSA

FLC1 / FLC2

SCA/CBA Exempt

SCA Code

Offeror Provided Position Title or SCA Position Title/CBA

Secret Clearance Yes(Y)

FTE Count

FLC2

Exempt

Supply Supervisor

0.60

FLC1

CBA 1

Hospital Supply Technician

0.40

FLC1

CBA 2

Supply Technician

3.00

4.50

Total FTE's	4	4.5	0	0	0	0	0	0	0	0
Total Supply FTE's	8.5

Transportation Functional Area

Labor Category

CLIN 0005AA

CLIN 0005BA

PPSO

HHG Inspection

FLC1 / FLC2

SCA/CBA Exempt

SCA Code

Offeror Provided Position Title or SCA Position Title/CBA

Secret Clearance Yes(Y)

FTE Count

FLC1

30010

Air Traffic Control Specialist

6.00

FLC1

31051

Flight Engineer

4.00

FLC1

31061

Helicopter Pilot

6.00

FLC1

47010

Boatswain (Bosun)

2.00

FLC1

47030

Deck Hand

15.00

Total FTE's	16.00	17.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Total Transportation FTE's	33
Grand Total PMO, Maintenance, Supply, and Transportation FTEs	72.5

File details come from the government source that posted it. Updated Dec 9, 2024.