Att 04 - Cost_Proposal_Workbook_N00017326R0008.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- N0017326R0008
About this file
This is a Cost Proposal Workbook template designed for offerors responding to the Naval Research Laboratory's Optoelectronics, Power Electronics and Radiation Effects Research contract (N00173-26-R0008). The workbook serves as the pricing submission vehicle for a Cost Plus Fixed Fee (CPFF) term contract with the Department of the Navy, Office of Naval Research. The contract encompasses a one-year base period plus four optional one-year periods (five years total), with potential for a six-month extension under FAR clause 52.217-8.
As a template document, this workbook provides the structured format and guidance that offerors must use to submit their cost proposals, including labor rates, material costs, overhead allocations, and fixed fee components. The template is formatted in Excel to facilitate systematic cost data entry and calculation. Offerors responding to this solicitation are required to complete all applicable sections of the workbook in accordance with the RFP requirements and submit it as part of their technical and business proposals. This follow-on contract succeeds the current incumbent, Amentum, under contract N00173-23-C-2004.
View the file
Other files
Show all 11
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
INDIRECT RATES TEMPLATE
INDIRECT RATES
OFFEROR:
| FY-27 | FY-28 | FY-29 | FY-30 | FY-31 | |
| FRINGE KTR-SITE | |||||
| FRINGE GOV-SITE | |||||
| KTR-SITE OH | |||||
| GOV-SITE OH | |||||
| M&H | |||||
| G&A | |||||
| FEE | |||||
| COM |
Add Rows as Necessary
&"Times New Roman,Regular"&9Optoelectronics and Radiation Effects Research &"Times New Roman,Regular"&9RFP: N00173-22-R-JD21 Attachment 4 Cost Proposal Workbook - Cost-Price Summary Spreadsheet
LABOR RATE BUILD-UP TEMPLATE
PRIME LABOR BUILD-UP
CHARTS BELOW MAY BE EDITED IF NEEDED.
ADD ADDITIONAL CHARTS TO REFLECT CHANGES IN APPLIED INDIRECTS FOR OUT YEARS IF APPLICABLE.
| 1. DIRECT LABOR RATE BUILD-UP | ||||||||||||||||
| INPUT "0" for the non-applicable OH | ||||||||||||||||
| Fringe | Overhead (Gov-Site) | Overhead (Ktr-Site) | M&H | G&A | Burdened Rate | Fee | Burdened | Escalation FY-22 | Escalation FY-23 | Escalation FY-24 | Escalation FY-25 | Escalation FY-26 | Escalation FY-27 | |||
| Labor Category | Employee | Base Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Rate w/ Fee | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2. SUBCONTRACTOR LABOR RATE BUILD-UP | |||||||||||||
| Labor Category | Employee | Base Rate | M&H | G&A | Burdened Rate | Fee | Burdened | Escalation FY-22 | Escalation FY-23 | Escalation FY-24 | Escalation FY-25 | Escalation FY-26 | Escalation FY-27 |
| 0.00% | 0.00% | 0.00% | Rate w/ Fee | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"Times New Roman,Regular"&9Optoelectronics and Radiation Effects Research &"Times New Roman,Regular"&9RFP: N00173-22-R-JD21
SUMMARY TEMPLATE
CHART BELOW MAY BE EDITED IF NEEDED.
TASK ORDER 1 -- COST SUMMARY FORMAT
| Total | Base Year | Option 1 | Option 2 | Option (6-Month Ext) | |||||||||||
| Cost Elements | Labor Category (LCAT) | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| Prime Contractor Direct Labor | |||||||||||||||
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
Total Direct Labor Cost - 0 ERROR:#REF! - 0 $0.00 - 0 $0.00 - 0 $0.00 - 0 $0.00
| Prime Contractor Indirect Labor Cost | Amount | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount |
| Fringe Benefits | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| On-Site Overhead (Gov't Facility) | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Off-Site Overhead (KTR Facility) | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total Indirect Labor Cost | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Total Direct and Indirect Labor Cost | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| COM | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Total Prime Contractor Labor Cost | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 |
| Subcontractor Labor Cost | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | ERROR:#REF! | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
Total Proposed Subcontractor Labor Cost - 0 ERROR:#REF! - 0 $0.00 $0.00 $0.00 $0.00
| Prime contractor pass through (not including fee) | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | |
| Material & Handling | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
Total M&H and G&A on Subcontractor Labore ERROR:#REF! $0.00 $0.00 $0.00 $0.00
Total Labor Cost (Prime and Subcontractor Labor) $0.00 $0.00 $0.00 $0.00 $0.00
| Fee | Rate | Amount | Amount | Amount | Amount | ||||
| Fixed Fee - Prime Labor Costs Only | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Fixed Fee - Subcontract Labor Costs Only | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total Fee (for Prime and Subcontractor Labor Costs) | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 |
Total Labor Cost Plus Fixed Fee (CPFF) $0.00 $0.00 $0.00 $0.00 $0.00
| Other Direct Costs | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | |
| ODC - Gov't Plug | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| M&H | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | ERROR:#REF! | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total ODC | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 |
Total Task Order CPFF $0.00 $0.00 $0.00 $0.00 $0.00
Optoelectronics and Radiation Effects Research &"Times New Roman,Regular"&9RFP: N00173-22-R-JD21
File details come from the government source that posted it. Updated .