N0017325R0007 - Attachment 9_Base IDIQ Cost Proposal Spreadsheet.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Focused Radio Frequency Optimized Signal Transference (FROST) Federal contract opportunity
- Solicitation number
- N00173-25-R-0007
About this file
This is a cost proposal spreadsheet template (Attachment 9) for the Focused Radio Frequency Optimized Signal Transference (FROST) IDIQ contract. The template provides formatted tables for offerors to input indirect rates, labor build-up calculations, and cost summaries covering fiscal years 2025-2029.
The spreadsheet includes sections for prime contractor direct labor rates, subcontractor labor rates, and various indirect cost elements including fringe benefits, overhead rates (both government-site and contractor-site), material handling, G&A, and fee calculations. The summary section provides a detailed breakdown structure for five years of cost elements including direct labor, indirect costs, subcontractor costs, ODCs, and total CPFF calculations. The template is designed to support pricing for an R&D effort focused on RF engineering and space-to-ground research, being solicited by the Naval Research Laboratory under solicitation N00173-25-R-0007 as a small business set-aside with proposals due March 27, 2025.
View the file
Other files for this federal contract opportunity
Show all 18
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
INDIRECT RATES TEMPLATE
TABLE BELOW MAY BE EDITED BY OFFEROR AS REQUIRED
INDIRECT RATES
OFFEROR:
| FY-25 | FY-26 | FY-27 | FY-28 | FY-29 | |
| FRINGE KTR-SITE | |||||
| FRINGE GOV-SITE | |||||
| KTR-SITE OH | |||||
| GOV-SITE OH | |||||
| M&H | |||||
| G&A | |||||
| FEE | |||||
| COM |
Only fill-in applicable FY information
CONTRACTOR SHALL ADJUST COLUMN A INDIRECT COST ELEMENTS AS REQUIRED FOR APPLICABLE CORPORATE INDIRECT COST ELEMENTS. CONTRACTOR IS RESPONSIBLE FOR ENSURING ACCURACY OF ANY ADJUSTMENTS MADE TO THIS TAB AND THERE CORRESPONDING LINKS TO OTHER TABS IN THIS WORKBOOK.
FROST REQUIREMENT: N00173-24-R-RJ01
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-25 | Escalation FY-26 | Escalation FY-27 | Escalation FY-28 | |||
| 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-25 | Escalation FY-26 | Escalation FY-27 | Escalation FY-28 |
| 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
TABLE 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 .