Attachment 3 Prime Cost Proposal Spreadsheet_.xlsx
XLSX spreadsheet 38 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 Prime Cost Proposal Spreadsheet template for Solicitation N0016426RWS78, issued by the Naval Sea Systems Command for test, evaluation, repair, modification, and upgrade of electronic warfare systems. The spreadsheet is designed to capture comprehensive labor and other direct cost (ODC) pricing information across a five-year performance period.
The template requires contractors to provide detailed labor cost breakdowns including direct labor costs by employee, labor category, and year with associated hours and rates; uncompensated overtime (UCOT) percentages; base year escalation rates; indirect costs across multiple categories; subcontractor costs and fees; prime contractor pass-through costs; and surge and special studies labor costs. Additional sections address other direct costs such as travel and materials for both prime contractors and subcontractors, with provisions for G&A adders. The spreadsheet includes analytical sections for fee calculation, pass-through analysis (capped at 8% per SeaPort-NxG IDIQ Contract terms), and fixed fee analysis for labor performed by the prime contractor. A labor rates summary table captures employee names, labor categories, total burdened rates, annual hours, and full-time equivalent (FTE) calculations, with separate tracking for overtime and overtime premiums across base years and option periods. This template appears to be a standard cost proposal requirement for SeaPort-NxG IDIQ contracts under the Department of the Navy.
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 Solicitation No. N0016426RWS78 Escalation Rate Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter escalation percentage noted in RFP Prime Offeror 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
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 Hours Amount Labor Rate Hours Amount Labor Rate Hours Amount Labor Rate Hours Amount Labor Rate Hours Amount
| Prime Contractor Labor Cost |
| Prime Contractor Direct Labor |
| Company Labor Category |
Total CORE Direct Labor Cost
| Prime Contractor Indirect Labor Cost |
| Indirect Cost 1 ( %) |
| Indirect Cost 2 ( %) |
| Indirect Cost 3 ( %) |
| Etc. |
| Total Indirect Labor Cost |
| Total Direct and Indirect Labor cost |
| COM |
| Total Prime Contractor Labor Cost |
| Subcontractor proposed cost and fee |
| Subcontractor 1 Cost |
| Subcontractor 1 Fee |
| Subcontractor 2 Cost |
| Subcontractor 2 Fee |
| Etc. |
| Total proposed subcontractor labor cost and fee |
| Prime contractor pass through |
| Handling ( %) |
| G&A ( %) |
| Other (if any) |
| Total pass through (not including fee) |
Total Subcontractor Cost including pass through
Total Labor Cost (Prime and Subcontractor Labor)
| Fee on Labor |
| Prime Contractor Fee for Prime Contractor Labor |
| Prime Contractor Fee for Subcontractor Labor |
| Total Fee (for Prime and Subcontractor 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): 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
| Fee on Surge Labor |
| Prime Contractor Fixed Fee on Surge Labor |
Total Surge Costs
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): 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
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Calculate direct labor rate adjusted for UCOT
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Enter BY escalation percentage
Langell, Tisha N CIV USN NSWC CD CRANE IN (USA): Calculate Base Year Direct Labor rate
| Fee on Special Studies Labor |
| Prime Contractor Fixed Fee on Special Studies Labor |
| Total Special Studies Costs |
| Total Labor Cost (including Surge, Special Studies and Fee) |
| Other Direct Costs - Prime |
| Prime Travel |
| Prime Material |
| Any adders to ODCs such as G&A (cost only - no fee) |
| Other Direct Costs - Sub-Contractor |
| Sub-Contractor Travel |
| Subcontractor 1 |
| Subcontractor 2 |
| Etc. |
| Sub-Contractor Material |
| Subcontractor 1 |
| Subcontractor 2 |
| Etc. |
| Any adders to ODCs such as G&A (cost only - no fee) to Subcontractor ODC |
| Total ODCs |
Total CPFF all CLINs (Labor and ODCs)
| Pass Through Analysis - Total for All Years | Amount | Percent |
| Subcontractor proposed cost and fee | ||
| Pass Through Amount (not including fee) | ||
| Prime Contractor Fee for Subcontractor Labor * | ||
| Total Pass Through Amount (including fee) | ERROR:#DIV/0! | |
| Maximum Pass Through Allowed by SeaPort-NxG IDIQ Contract | 8% |
| Fee Analysis - Total for All Years | Percent |
| Prime Contractor Labor Cost | |
| Fixed Fee for Labor Performed by Prime Contractor | ERROR:#DIV/0! |
| Maximum Fixed Fee Allowed by SeaPort-NxG IDIQ Contract | |
| * When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B. |
Labor Rates
| Employee Name (if applicable) | Labor Category | Total Burdened Rate | Total WY Hours (e.g., 1880, 1920, 2080) | FTE $ |
| John Doe - SAMPLE | Sr. Engineer | $85.00 | 1920 | $163,200.00 |
Add rows as needed.
Overtime
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Prime Proposed Burdened OT | |||||
| Sub-contractor 1 Proposed Burdened OT | |||||
| Sub-contractor 2 Proposed Burdened OT | |||||
| Sub-contractor 3 Proposed Burdened OT | |||||
| Etc. |
Total Proposed Burdened OT
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 .