Attachment 4 - Cost Spreadsheet.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- N00173-25-R-HH01
About this file
This file is a Cost Spreadsheet Template for a federal contract opportunity related to R&D Support for Specialized Aerospace System, specifically RFP N00173-21-R-LM01. The Excel template provides a comprehensive cost breakdown structure with sections for indirect rates, labor rate build-up, and cost summaries across five years. The template allows offerors to input detailed financial information including direct and indirect labor costs, labor categories, hours, rates, fringe benefits, overhead, and general and administrative (G&A) expenses.
The template includes placeholders for prime contractor and subcontractor labor costs, with columns for calculating total labor costs, fixed fees, and other direct costs (ODCs). It supports financial modeling across fiscal years 2023-2027, enabling contractors to develop detailed cost proposals with multiple rate calculations, escalation factors, and fee structures. While the template is currently blank, it is designed to support a Cost-Plus-Fixed-Fee (CPFF) contract type for the Department of the Navy's Office of Naval Research, specifically for spacecraft engineering, software, research, and development services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N00173-25-R-HH01 0002.pdf | ||
| Attachment 9 - QA 3 Sep 2025.docx | DOCX document | |
| Attachment 1 - Personnel Qualifications 3 Sep.docx | DOCX document | |
| Exhibit A - CDRLs.pdf | ||
| N00173-25-R-HH01 0001.pdf | ||
| Attachment 2 - SOW 3 Sep.docx | DOCX document | |
| Attachment 5 -SBPCD.pdf | ||
| Attachment 7 - Req for Onsite KTRs.pdf | ||
| Attachment 3 - Past Performance Questionnaire.pdf | ||
| Attachment 2 - SOW 8 July.docx | DOCX document | |
| Attachment 8 - Initial DD254 23 Jul.pdf | ||
| Attachment 1 - Personnel Qualifications.docx | DOCX document | |
| Attachment 6 -Direct Labor Rate Substantiation.xls | XLS spreadsheet | |
| N00173-25-R-HH01.pdf |
Show all 14
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-23 | FY-24 | FY-25 | FY-26 | FY-27 | |
| FRINGE KTR-SITE | |||||
| FRINGE GOV-SITE | |||||
| KTR-SITE OH | |||||
| GOV-SITE OH | |||||
| M&H | |||||
| G&A | |||||
| FEE | |||||
| COM |
Only fill-in applicable FY information
LABOR 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-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 |
| 2. SUBCONTRACTOR LABOR RATE BUILD-UP | |||||||||||
| Labor Category | Employee | Base Rate | M&H | G&A | Burdened Rate | Fee | Burdened | 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 |
&"Times New Roman,Regular"&9R&D Support for Specialized Aerospace System &"Times New Roman,Regular"&9RFP: N00173-21-R-LM01 Attachment 04 - Cost-Price Summary Spreadsheet
SUMMARY TEMPLATE
CHART BELOW MAY BE EDITED IF NEEDED.
COST SUMMARY FORMAT
| Total | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||
| Cost Elements | Labor Category (LCAT) | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| Prime Contractor Direct Labor | ||||||||||||||||||
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $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 $0.00 - 0 $0.00 - 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 | Rate | Amount |
| Fringe Benefits | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| On-Site Overhead (Gov't Facility) | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Off-Site Overhead (KTR Facility) | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total Indirect Labor Cost | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| Total Direct and Indirect Labor Cost | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| COM | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| Total Prime Contractor Labor Cost | $0.00 | $0.00 | $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 | Rate | Hours | Amount | |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $0.00 | - 0 | $0.00 |
| Name/Company | LCAT | - 0 | $0.00 | $0.00 | - 0 | $0.00 | $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 $0.00 - 0 $0.00 $0.00 $0.00 $0.00 $0.00
| Prime contractor pass through (not including fee) | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | |
| Material & Handling | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | $0.00 | 0.00% | $0.00 | 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 $0.00 $0.00 $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 $0.00
| Fee | Rate | Amount | Amount | Amount | Amount | Amount | |||||
| Fixed Fee - Prime Labor Costs Only | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Fixed Fee - Subcontract Labor Costs Only | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total Fee (for Prime and Subcontractor Labor Costs) | $0.00 | $0.00 | $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 $0.00
| Other Direct Costs | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | Rate | Amount | |
| ODC - Gov't Plug | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| M&H | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| G&A | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 | 0.00% | $0.00 |
| Total ODC | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Total Task Order CPFF $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
&"Times New Roman,Regular"&9R&D Support for Specialized Aerospace System &"Times New Roman,Regular"&9RFP: N00173-21-R-LM01 Attachment 04 - Cost-Price Summary Spreadsheet
File details come from the government source that posted it. Updated .