Attachment 0002 Staffing and Labor Mix.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
EAGLE Detroit, MI W519TC-24-R-0006
Solicitation number
W519TC24R0006
Issued by

About this file

This document contains a staffing and labor mix template and instructions for a federal contract solicitation. The solicitation is for maintenance, supply, and transportation services at Detroit Arsenal, Michigan. Offerors must submit a completed staffing and labor mix template as an attachment to their proposals, including proposed hours per FTE for the base period and four option periods, identification of SCA/exempt status and codes, position titles, and FTE counts by labor category and functional area. Failure to complete the template correctly will result in a non-compliant proposal. The template includes examples to demonstrate the required format and level of detail.

View the file

Other files

File Type Posted
B08 Amendment 0003 W519TC-24-R-0006(13MAR24).pdf PDF
B08 Amendment 0002 W519TC-24-R-0006 (06MAR24).pdf PDF
B08 Amendment 0001 W519TC-24-R-0006.pdf PDF
Exhibit A DD Form 1423.pdf PDF
Attachment 0005 - Cost Price Matrix (DTA).xlsx XLSX spreadsheet
Exhibit D PM-01 Contractor Employee Information Format.xlsx XLSX spreadsheet
Attachment 0019 Annex C Transportation PRS.pdf PDF
Attachment 0014 - NOT APPLICABLE.pdf PDF
Attachment 0021 Annex E Definitions - Acronyms - Abbreviations.docx DOCX document
Attachment 0015 - Subcontractor Cost Information Submission_09 MAY 23.pdf PDF
Exhibit B CDRL Listing Updated Format.xlsx XLSX spreadsheet
Exhibit F PM-09 Performance Management Review Format.pptx PPTX presentation
Attachment 0017 Annex A Maintenance PRS.pdf PDF
Attachment 0018 Annex B Supply PRS.pdf PDF
Exhibit C CD-02 Burn Rate Report Format.xlsx XLSX spreadsheet
Attachment 0009 - Purchasing Invoicing Guide (PIG).docx DOCX document
Exhibit E PM-08 Scheduled Government Furnished Property (SGFP).xlsx XLSX spreadsheet
Exhibit J SS-01 Supply and Services Report Format.xlsx XLSX spreadsheet
B08 Solicitation - W519TC24R0006.pdf PDF
Attachment 0013 Mission Essential Contractor Services.pdf PDF
Attachment 0023 - NOT APPLICABLE.pdf PDF
Attachment 0012 - NOT APPLICABLE.pdf PDF
Attachment 0011 Contract References Spreadsheet_29 JUN 2023.xlsx XLSX spreadsheet
Attachment 0020 Annex D Environmental Requirements.docx DOCX document
Attachment 0006 - SF1408 Preaward Survey of Prospective Contractor Accounting System.pdf PDF
Attachment 0010 - Blocked File Extensions.pdf PDF
Attachment 0004 - Letter of Consent.docx DOCX document
Exhibit H MMD-07 Maintenance Report Format.xlsx XLSX spreadsheet
Attachment 0022 Annex F Publications and Forms.docx DOCX document
Attachment 0003 - Performance Questionnaire.docx DOCX document
Exhibit G PM-12 KTR Accident Reporting Format.xlsx XLSX spreadsheet
Attachment 0001 PWS.pdf PDF
Exhibit K ITD-01 Transportation Report Format.xlsx XLSX spreadsheet
Attachment 0007 Wage Determination (2015-4867).pdf PDF
Show all 34

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Staff & Labor Mix

As of 01 June 2023
LRC or AFSBn XXXX
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 YearEmployee TypeProvide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).Hours Per YearEmployee TypeProvide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).
ExemptExempt
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
MaintenanceSupplyTransportation
FLC1 Proposed
FFP Program Management Office (PMO)
Labor CategoryCLIN 0002AACLIN 0002BACLIN 0002CACLIN 0002DACLIN 0002EACLIN 0002FACLIN 0002GACLIN 0002HACLIN 0002JACLIN 0002KA
CLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAME
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
Total FTE's0.000.000.000.000.000.000.000.000.000.00
Total Maintenance FTE's0.00
Mantenance Functional Area
Labor CategoryCLIN 0003AACLIN 0003BACLIN 0003CACLIN 0003DACLIN 0003EACLIN 0003FACLIN 0003GA
CLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAME
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
Total FTE's0.000.000.000.000.000.000.000.000.000.00
Total Maintenance FTE's0.00
Supply Functional Area
Labor CategoryCLIN 0004AACLIN 0004BACLIN 0004CACLIN 0004DACLIN 0004EACLIN 0004FACLIN 0004GACLIN 0004HACLIN 0003JA
CLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAME
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
Total FTE's0.000.000.000.000.000.000.000.000.000.00
Total Supply FTE's0.00
Transportation Functional Area
Labor CategoryCLIN 0005AACLIN 0005BACLIN 0005CACLIN 0005DACLIN 0005EACLIN 0005FACLIN 0005GACLIN 0005HACLIN 0005JA
CLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAMECLIN NAME
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
Total FTE's0.000.000.000.000.000.000.000.000.000.00
Total Transportation FTE's0.00
Grand Total PMO, Maintenance, Supply, and Transportation FTEs0.00

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 YearEmployee TypeProvide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).Hours Per YearEmployee TypeProvide proposed annual hours per FTE for each employee type indicated to the left. Missing hours will be evaluated as zero (0).
1586.00Exempt1580.00Exempt
1542.00CBA 1 (if applicable)1856.00CBA 1 (if applicable)
1700.00CBA 2 (if applicable)1920.00CBA 2 (if applicable)
1700.00SCA (non-CBA)1920.00SCA (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.

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
MaintenanceSupplyTransportation
FLC1 Proposed50,510.0015,541.2067,182.00
Program Management Office (PMO)
Labor CategoryFFP PMO
CLIN 0002
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE Count
FLC2ExemptProject Manager1.00
FLC2ExemptQuality Manager1.00
FLC2SCA01020Administrative Assistance1.00

Total PMO FTE's 3

Mantenance Functional Area
Labor CategoryCLIN 0003AACLIN 0003BA
SDDCPASSBACK
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
FLC1SCA23010Welder1.502.50
FLC1CBA 1Aerospace Master Mechanic18.002.00
FLC1CBA 2Aerosapce Inspector2.501.50
Total FTE's22600000000
Total Maintenance FTE's28
Supply Functional Area
Labor CategoryCLIN 0004AACLIN 0004BA
CIFISSA
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
FLC2ExemptSupply Supervisor0.60
FLC1CBA 1Hospital Supply Technician0.40
FLC1CBA 2Supply Technician3.004.50
Total FTE's44.500000000
Total Supply FTE's8.5
Transportation Functional Area
Labor CategoryCLIN 0005AACLIN 0005BA
PPSOHHG Inspection
FLC1 / FLC2SCA/CBA ExemptSCA CodeOfferor Provided Position Title or SCA Position Title/CBASecret Clearance Yes(Y)FTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE CountFTE Count
FLC130010Air Traffic Control Specialist6.00
FLC131051Flight Engineer4.00
FLC131061Helicopter Pilot6.00
FLC147010Boatswain (Bosun)2.00
FLC147030Deck Hand15.00
Total FTE's16.0017.000.000.000.000.000.000.000.000.00
Total Transportation FTE's33
Grand Total PMO, Maintenance, Supply, and Transportation FTEs72.5

File details come from the government source that posted it. Updated .