L-6 CLIN 0003 Labor Pricing Spreadsheet.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- N6893627R0002
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 | ||
| 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 |
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
| $ - 0 | CLIN 0003 Labor Cost | |
| Profit/Fee % | $ - 0 | CLIN 0003 Fixed Fee |
| $ - 0 | CLIN 0003 TOTAL PRICE |
| CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE) | YEAR 1 | ||||||||||||
| Labor Category | Bureau of Labor Statistics (BLS) or | ||||||||||||
| Service Contract Labor Standards (SCLS) Labor Category | Level | Direct Labor Rate | |||||||||||
| (per hour) | Other | ||||||||||||
| (if applicable) | Other | ||||||||||||
| (if applicable) | Fringe | Overhead | G&A | Burdened Labor Rates | |||||||||
| (absent Fee) | Hours | Summary | |||||||||||
| Total | Comments | ||||||||||||
| Enter %s: | |||||||||||||
| Engineering* | Electrical Engineer Sr., BLS 17-2071 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,040 | $ - 0 | |||
| Financial Specialist | Financial Analyst, BLS 13-2051 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 510 | $ - 0 | |||
| Electronics Technician | Electronics Technician, SCLS 23183 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 8,075 | $ - 0 | |||
| Logistician* | Logistician Sr., BLS 13-1081 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 867 | $ - 0 | |||
| Security Specialist | Security Specialist/Management Analyst BLS 13-1111 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| DB/Doc Management Analyst | Technical Writer, SCLS 30462 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| Administrative | Administrative Assistant, SCLS 0120 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1,768 | $ - 0 | |||
| Information Assurance Analyst | Information Assurance/Industrial Engineer, BLS 17-2112 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 140 | $ - 0 | |||
| Program Manager* | Manager/Operations Manager Sr., BLS 11-1021 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 480 | $ - 0 | |||
| Subject Matter Expert (SME) | SME/Software Engineer, BLS 17-2199 | SME | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,550 | $ - 0 | |||
| Categories noted with an "*" are Key Personnel | Total: | 17,314 | $ - 0 |
| CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE) | YEAR 2 | ||||||||||||
| Labor Category | Bureau of Labor Statistics (BLS) or | ||||||||||||
| Service Contract Labor Standards (SCLS) Labor Category | Level | Direct Labor Rate | |||||||||||
| (per hour) | Other | ||||||||||||
| (if applicable) | Other | ||||||||||||
| (if applicable) | Fringe | Overhead | G&A | Burdened Labor Rates | |||||||||
| (absent Fee) | Hours | Summary | |||||||||||
| Total | Comments | ||||||||||||
| Enter %s: | Enter %s: | ||||||||||||
| Engineering* | Electrical Engineer Sr., BLS 17-2071 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,040 | $ - 0 | |||
| Financial Specialist | Financial Analyst, BLS 13-2051 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 510 | $ - 0 | |||
| Electronics Technician | Electronics Technician, SCLS 23183 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 8,075 | $ - 0 | |||
| Logistician* | Logistician Sr., BLS 13-1081 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 867 | $ - 0 | |||
| Security Specialist | Security Specialist/Management Analyst BLS 13-1111 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| DB/Doc Management Analyst | Technical Writer, SCLS 30462 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| Administrative | Administrative Assistant, SCLS 0120 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1,768 | $ - 0 | |||
| Information Assurance Analyst | Information Assurance/Industrial Engineer, BLS 17-2112 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 140 | $ - 0 | |||
| Program Manager* | Manager/Operations Manager Sr., BLS 11-1021 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 480 | $ - 0 | |||
| Subject Matter Expert (SME) | SME/Software Engineer, BLS 17-2199 | SME | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,550 | $ - 0 | |||
| Categories noted with an "*" are Key Personnel | Total: | 17,314 | $ - 0 |
| CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE) | YEAR 3 | ||||||||||||
| Labor Category | Bureau of Labor Statistics (BLS) or | ||||||||||||
| Service Contract Labor Standards (SCLS) Labor Category | Level | Direct Labor Rate | |||||||||||
| (per hour) | Other | ||||||||||||
| (if applicable) | Other | ||||||||||||
| (if applicable) | Fringe | Overhead | G&A | Burdened Labor Rates | |||||||||
| (absent Fee) | Hours | Summary | |||||||||||
| Total | Comments | ||||||||||||
| Enter %s: | Enter %s: | ||||||||||||
| Engineering* | Electrical Engineer Sr., BLS 17-2071 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,040 | $ - 0 | |||
| Financial Specialist | Financial Analyst, BLS 13-2051 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 510 | $ - 0 | |||
| Electronics Technician | Electronics Technician, SCLS 23183 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 8,075 | $ - 0 | |||
| Logistician* | Logistician Sr., BLS 13-1081 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 867 | $ - 0 | |||
| Security Specialist | Security Specialist/Management Analyst BLS 13-1111 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| DB/Doc Management Analyst | Technical Writer, SCLS 30462 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| Administrative | Administrative Assistant, SCLS 0120 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1,768 | $ - 0 | |||
| Information Assurance Analyst | Information Assurance/Industrial Engineer, BLS 17-2112 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 140 | $ - 0 | |||
| Program Manager* | Manager/Operations Manager Sr., BLS 11-1021 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 480 | $ - 0 | |||
| Subject Matter Expert (SME) | SME/Software Engineer, BLS 17-2199 | SME | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,550 | $ - 0 | |||
| Categories noted with an "*" are Key Personnel | Total: | 17,314 | $ - 0 |
| CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE) | YEAR 4 | ||||||||||||
| Labor Category | Bureau of Labor Statistics (BLS) or | ||||||||||||
| Service Contract Labor Standards (SCLS) Labor Category | Level | Direct Labor Rate | |||||||||||
| (per hour) | Other | ||||||||||||
| (if applicable) | Other | ||||||||||||
| (if applicable) | Fringe | Overhead | G&A | Burdened Labor Rates | |||||||||
| (absent Fee) | Hours | Summary | |||||||||||
| Total | Comments | ||||||||||||
| Enter %s: | Enter %s: | ||||||||||||
| Engineering* | Electrical Engineer Sr., BLS 17-2071 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,040 | $ - 0 | |||
| Financial Specialist | Financial Analyst, BLS 13-2051 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 510 | $ - 0 | |||
| Electronics Technician | Electronics Technician, SCLS 23183 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 8,075 | $ - 0 | |||
| Logistician* | Logistician Sr., BLS 13-1081 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 867 | $ - 0 | |||
| Security Specialist | Security Specialist/Management Analyst BLS 13-1111 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| DB/Doc Management Analyst | Technical Writer, SCLS 30462 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| Administrative | Administrative Assistant, SCLS 0120 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1,768 | $ - 0 | |||
| Information Assurance Analyst | Information Assurance/Industrial Engineer, BLS 17-2112 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 140 | $ - 0 | |||
| Program Manager* | Manager/Operations Manager Sr., BLS 11-1021 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 480 | $ - 0 | |||
| Subject Matter Expert (SME) | SME/Software Engineer, BLS 17-2199 | SME | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,550 | $ - 0 | |||
| Categories noted with an "*" are Key Personnel | Total: | 17,314 | $ - 0 |
| CLIN 0003 - GPS BRIE Support Services - Term Level of Effort (LOE) | YEAR 5 | ||||||||||||
| Labor Category | Bureau of Labor Statistics (BLS) or | ||||||||||||
| Service Contract Labor Standards (SCLS) Labor Category | Level | Direct Labor Rate | |||||||||||
| (per hour) | Other | ||||||||||||
| (if applicable) | Other | ||||||||||||
| (if applicable) | Fringe | Overhead | G&A | Burdened Labor Rates | |||||||||
| (absent Fee) | Hours | Summary | |||||||||||
| Total | Comments | ||||||||||||
| Enter %s: | Enter %s: | ||||||||||||
| Engineering* | Electrical Engineer Sr., BLS 17-2071 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,040 | $ - 0 | |||
| Financial Specialist | Financial Analyst, BLS 13-2051 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 510 | $ - 0 | |||
| Electronics Technician | Electronics Technician, SCLS 23183 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 8,075 | $ - 0 | |||
| Logistician* | Logistician Sr., BLS 13-1081 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 867 | $ - 0 | |||
| Security Specialist | Security Specialist/Management Analyst BLS 13-1111 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| DB/Doc Management Analyst | Technical Writer, SCLS 30462 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 442 | $ - 0 | |||
| Administrative | Administrative Assistant, SCLS 0120 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 1,768 | $ - 0 | |||
| Information Assurance Analyst | Information Assurance/Industrial Engineer, BLS 17-2112 | Journeyman | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 140 | $ - 0 | |||
| Program Manager* | Manager/Operations Manager Sr., BLS 11-1021 | Senior | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 480 | $ - 0 | |||
| Subject Matter Expert (SME) | SME/Software Engineer, BLS 17-2199 | SME | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 2,550 | $ - 0 | |||
| Categories noted with an "*" are Key Personnel | Total: | 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 .