L-6 CLIN 0003 Labor Pricing Spreadsheet.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
Global Positioning System Based Range Instrumentation Equipment (GPS-BRIE)
Solicitation number
N6893627R0002
Issued by

About this file

This is a labor pricing spreadsheet (L-6 CLIN 0003) for the GPS-BRIE (Global Positioning System Based Range Instrumentation Equipment) support services contract with the Naval Air Warfare Center. The spreadsheet is a template designed to calculate labor costs for CLIN 0003 across a five-year period, with identical staffing and hour requirements for each year. Offerors are required to populate the yellow cells with unburdened labor rates per labor category and indirect cost rates (fringe, overhead, and G&A) to generate burdened labor rates that will be used to evaluate overall labor costs.

The labor structure identifies ten distinct positions required to support GPS-BRIE operations: Senior Electrical Engineer (2,040 hours annually), Senior Logistician (867 hours), Senior Program Manager (480 hours), Subject Matter Expert/Software Engineer (2,550 hours), Electronics Technician (8,075 hours), Financial Analyst (510 hours), Security Specialist (442 hours), Technical Writer/DB/Doc Management Analyst (442 hours), Administrative Assistant (1,768 hours), and Information Assurance Analyst (140 hours), totaling 17,314 hours per year. Four positions are designated as Key Personnel (marked with asterisks): Engineering, Logistician, and Program Manager roles. Labor categories reference either Bureau of Labor Statistics (BLS) codes or Service Contract Labor Standards (SCLS) codes to ensure compliance with federal wage requirements. The spreadsheet instructs offerors to review calculated burdened rates and proposed fee entries, with recommendations to utilize composite labor rates for completion of related pricing documents. All monetary values currently display as $0, indicating this is an unfilled template awaiting cost data submission.

View the file

Other files

File Type Posted
L-1 Executive Summary Tables.xlsx XLSX spreadsheet
Attachment 3 - OPSEC and Critical Info Annex.pdf PDF
L-3 Past Performance Contract Data.xlsx XLSX spreadsheet
L-2 Past Perf Questionnaire PPQ.docx DOCX document
Exhibit A - Contract Data Requirements List.pdf PDF

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

CLIN 0003 Labor

$ - 0CLIN 0003 Labor Cost
Profit/Fee %$ - 0CLIN 0003 Fixed Fee
$ - 0CLIN 0003 TOTAL PRICE
CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE)YEAR 1
Labor CategoryBureau of Labor Statistics (BLS) or
Service Contract Labor Standards (SCLS) Labor CategoryLevelDirect Labor Rate
(per hour)Other
(if applicable)Other
(if applicable)FringeOverheadG&ABurdened Labor Rates
(absent Fee)HoursSummary
TotalComments
Enter %s:
Engineering*Electrical Engineer Sr., BLS 17-2071Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,040$ - 0
Financial SpecialistFinancial Analyst, BLS 13-2051Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0510$ - 0
Electronics TechnicianElectronics Technician, SCLS 23183Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 08,075$ - 0
Logistician*Logistician Sr., BLS 13-1081Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0867$ - 0
Security SpecialistSecurity Specialist/Management Analyst BLS 13-1111Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
DB/Doc Management AnalystTechnical Writer, SCLS 30462Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
AdministrativeAdministrative Assistant, SCLS 0120Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01,768$ - 0
Information Assurance AnalystInformation Assurance/Industrial Engineer, BLS 17-2112Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0140$ - 0
Program Manager*Manager/Operations Manager Sr., BLS 11-1021Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0480$ - 0
Subject Matter Expert (SME)SME/Software Engineer, BLS 17-2199SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,550$ - 0
Categories noted with an "*" are Key PersonnelTotal:17,314$ - 0
CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE)YEAR 2
Labor CategoryBureau of Labor Statistics (BLS) or
Service Contract Labor Standards (SCLS) Labor CategoryLevelDirect Labor Rate
(per hour)Other
(if applicable)Other
(if applicable)FringeOverheadG&ABurdened Labor Rates
(absent Fee)HoursSummary
TotalComments
Enter %s:Enter %s:
Engineering*Electrical Engineer Sr., BLS 17-2071Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,040$ - 0
Financial SpecialistFinancial Analyst, BLS 13-2051Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0510$ - 0
Electronics TechnicianElectronics Technician, SCLS 23183Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 08,075$ - 0
Logistician*Logistician Sr., BLS 13-1081Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0867$ - 0
Security SpecialistSecurity Specialist/Management Analyst BLS 13-1111Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
DB/Doc Management AnalystTechnical Writer, SCLS 30462Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
AdministrativeAdministrative Assistant, SCLS 0120Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01,768$ - 0
Information Assurance AnalystInformation Assurance/Industrial Engineer, BLS 17-2112Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0140$ - 0
Program Manager*Manager/Operations Manager Sr., BLS 11-1021Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0480$ - 0
Subject Matter Expert (SME)SME/Software Engineer, BLS 17-2199SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,550$ - 0
Categories noted with an "*" are Key PersonnelTotal:17,314$ - 0
CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE)YEAR 3
Labor CategoryBureau of Labor Statistics (BLS) or
Service Contract Labor Standards (SCLS) Labor CategoryLevelDirect Labor Rate
(per hour)Other
(if applicable)Other
(if applicable)FringeOverheadG&ABurdened Labor Rates
(absent Fee)HoursSummary
TotalComments
Enter %s:Enter %s:
Engineering*Electrical Engineer Sr., BLS 17-2071Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,040$ - 0
Financial SpecialistFinancial Analyst, BLS 13-2051Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0510$ - 0
Electronics TechnicianElectronics Technician, SCLS 23183Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 08,075$ - 0
Logistician*Logistician Sr., BLS 13-1081Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0867$ - 0
Security SpecialistSecurity Specialist/Management Analyst BLS 13-1111Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
DB/Doc Management AnalystTechnical Writer, SCLS 30462Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
AdministrativeAdministrative Assistant, SCLS 0120Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01,768$ - 0
Information Assurance AnalystInformation Assurance/Industrial Engineer, BLS 17-2112Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0140$ - 0
Program Manager*Manager/Operations Manager Sr., BLS 11-1021Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0480$ - 0
Subject Matter Expert (SME)SME/Software Engineer, BLS 17-2199SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,550$ - 0
Categories noted with an "*" are Key PersonnelTotal:17,314$ - 0
CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE)YEAR 4
Labor CategoryBureau of Labor Statistics (BLS) or
Service Contract Labor Standards (SCLS) Labor CategoryLevelDirect Labor Rate
(per hour)Other
(if applicable)Other
(if applicable)FringeOverheadG&ABurdened Labor Rates
(absent Fee)HoursSummary
TotalComments
Enter %s:Enter %s:
Engineering*Electrical Engineer Sr., BLS 17-2071Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,040$ - 0
Financial SpecialistFinancial Analyst, BLS 13-2051Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0510$ - 0
Electronics TechnicianElectronics Technician, SCLS 23183Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 08,075$ - 0
Logistician*Logistician Sr., BLS 13-1081Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0867$ - 0
Security SpecialistSecurity Specialist/Management Analyst BLS 13-1111Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
DB/Doc Management AnalystTechnical Writer, SCLS 30462Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
AdministrativeAdministrative Assistant, SCLS 0120Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01,768$ - 0
Information Assurance AnalystInformation Assurance/Industrial Engineer, BLS 17-2112Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0140$ - 0
Program Manager*Manager/Operations Manager Sr., BLS 11-1021Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0480$ - 0
Subject Matter Expert (SME)SME/Software Engineer, BLS 17-2199SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,550$ - 0
Categories noted with an "*" are Key PersonnelTotal:17,314$ - 0
CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE)YEAR 5
Labor CategoryBureau of Labor Statistics (BLS) or
Service Contract Labor Standards (SCLS) Labor CategoryLevelDirect Labor Rate
(per hour)Other
(if applicable)Other
(if applicable)FringeOverheadG&ABurdened Labor Rates
(absent Fee)HoursSummary
TotalComments
Enter %s:Enter %s:
Engineering*Electrical Engineer Sr., BLS 17-2071Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,040$ - 0
Financial SpecialistFinancial Analyst, BLS 13-2051Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0510$ - 0
Electronics TechnicianElectronics Technician, SCLS 23183Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 08,075$ - 0
Logistician*Logistician Sr., BLS 13-1081Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0867$ - 0
Security SpecialistSecurity Specialist/Management Analyst BLS 13-1111Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
DB/Doc Management AnalystTechnical Writer, SCLS 30462Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0442$ - 0
AdministrativeAdministrative Assistant, SCLS 0120Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 01,768$ - 0
Information Assurance AnalystInformation Assurance/Industrial Engineer, BLS 17-2112Journeyman$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0140$ - 0
Program Manager*Manager/Operations Manager Sr., BLS 11-1021Senior$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0480$ - 0
Subject Matter Expert (SME)SME/Software Engineer, BLS 17-2199SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 02,550$ - 0
Categories noted with an "*" are Key PersonnelTotal:17,314$ - 0

Purpose:

This tab provides cost calculations specific to CLIN 0003.

Fields in this table autopopulate on the Unburdened Labor Rates and Other Direct Costs are entered in the Yellow fields as directed in the Instructions.

Data in this tab may be utilized to evaluate labor costs associated with CLINs 0001 and 0002.

Instructions:

Enter Unburdened Labor Rates per Labor Category in the yellow cells (Column C).

Enter indirect rates per Labor Category and Year in the yellow cells, Rows: 8, 24,40, 56, 72 Review the Calculated Burdened Rates (Column I) and totals to ensure the formulas are functioning correctly.

Enter proposed fee in yellow cell J86.

Review to confirmautopopulated fields to confirm accuracy.

Completion of the Column N is not required. Offerors may add comments to the comment field at their discretion.

Recommendations:

Utilize the Composite Labor Rates in Column I to complete B-TXT-STRMLND.

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