Attachment 4 Subcontractor Cost Proposal Spreadsheet_.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- REQUEST FOR PROPOSALS – Test, Evaluation, Repair, Modification & Upgrade of Electronic Warfare Systems
- Solicitation number
- N0016426RWS78
About this file
This is a Subcontractor Cost Proposal Spreadsheet template for federal contract solicitation N0016426RWS78, issued by the Naval Sea Systems Command for Test, Evaluation, Repair, Modification & Upgrade of Electronic Warfare Systems. The spreadsheet serves as an attachment to the Request for Information and is designed to capture comprehensive labor and other direct cost (ODC) information for subcontractor proposals.
The template requires detailed labor cost breakdowns organized by employee name, labor category, place of performance, and FLSA exemption status. It mandates entry of direct labor payroll rates, uncompensated overtime (UCOT) percentages, base year escalation rates, and adjusted rates across a five-year performance period. The spreadsheet accounts for indirect costs including fringe, overhead, and general and administrative (G&A) expenses, with separate calculations for subcontractor fees on regular labor, surge CLINs, and special studies CLINs. Additionally, the template includes sections for cost-plus-fixed-fee (CPFF) pricing structures, other direct costs (travel and materials), overtime tracking by year, and burdened overtime premium proposals for the prime contractor and multiple subcontractors. The spreadsheet is structured to provide year-by-year and total cost summaries, enabling clear cost visibility across all labor categories and cost elements required for the Electronic Warfare Systems contract performance.
View the file
Other files
Show all 16
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
Labor Cost Summary
| N0016426RWS78 | |
| Prime Offeror Name: | Escalation Rate |
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter escalation percentage noted in RFP Subcontractor Name: Year 1 Year 2 Year 3 Year 4 Year 5
| Total for All Years | Direct Labor Adjustments | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||
| Cost Elements | Corresponding eCraft Labor Code | Direct Labor: Employee Name | Place of Performance |
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Contractor Site Government Site Other Exempt/Non-Exempt Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Indicate if proposed employees are exempt/non-exempt from FLSA
| Hours | Amount | Current Rate | |
| Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter direct labor payroll rate | Uncompensated Overtime % (UCOT) |
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter UCOT percentage Adjusted Rate with UCOT Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Calculate direct labor rate adjusted for UCOT (if applicable)
Base Year Escalation Rate (%) Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter BY escalation percentage Base Year Labor Rate Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Calculate Base Year Direct Labor rate
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Contractor Site Government Site Other Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Indicate if proposed employees are exempt/non-exempt from FLSA
| Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | |
| Sub-Contractor Labor Cost | ||||||||||||||
| Sub-Contractor Direct Labor | ||||||||||||||
| Company Labor Category |
| Total Direct Labor Cost |
| Sub-Contractor Indirect Labor Cost |
| Fringe ( %) |
| Overhead ( %) |
| G&A ( %) |
| Etc. |
| Total Indirect Labor Cost |
| Total Direct and Indirect Labor cost |
| COM |
| Total Sub-Contractor Labor Cost |
Total Labor Cost
Subcontractor Fee on Regular Labor ( %)
Surge CLINs (use Weighted Average Loaded Labor Rate - before fee) Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): If applicable
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter escalation percentage noted in RFP Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter direct labor payroll rate Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter UCOT percentage Sub Contractor Fee on Surge Labor ( %)
Special Studies CLINs (use Weighted Average Loaded Labor Rate - before fee) Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): If applicable
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Calculate direct labor rate adjusted for UCOT (if applicable)
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter BY escalation percentage Sub Contractor Fee on Special Studies Labor ( %)
Total Labor Cost Plus Fixed Fee (CPFF)
| Other Direct Costs |
| Travel |
| Any adders to Travel such as G&A (cost only - no fee) |
| Material |
| Any adders to Material such as G&A (cost only - no fee) |
| Total ODCs |
Total CPFF all CLINs (Labor and ODCs)
Labor Rates
| Employee Name (if applicable) | Labor Category | DL rate | Total Burdened Rate | Total WY Hours (e.g., 1880, 1920, 2080) | FTE $ |
| John Doe - SAMPLE | Sr. Engineer | $55.00 | $85.00 | 1920 | $163,200.00 |
Add rows as needed.
Overtime
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |
| Total Burdened Overtime proposed by year |
Overtime Premium Breakdown
| Base Yr 1 | Base Yr 2 | Option 1 | Option 2 | Option 3 | |
| Prime Proposed Burdened OT Premium | |||||
| Sub-contractor 1 Proposed Burdened OT Premium | |||||
| Sub-contractor 2 Proposed Burdened OT Premium | |||||
| Sub-contractor 3 Proposed Burdened OT Premium | |||||
| Etc. | |||||
| Total Proposed Burdened OT Premium |
File details come from the government source that posted it. Updated .