Attachment 4 - Cost Proposal Spreadsheet.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Research & Development, Studies, Design and Engineering Services in Support of Remote Sensing Systems Federal contract opportunity
- Solicitation number
- N00173-25-R-0004
About this file
This is a cost proposal spreadsheet template (Attachment 4) for a research and development contract supporting specialized aerospace systems. The template contains worksheets for indirect rates, labor build-up calculations, and cost summaries spanning fiscal years 2023-2027.
The spreadsheet includes sections for prime contractor direct labor rates, subcontractor labor rates, and detailed cost summaries broken down by labor categories, indirect costs (fringe benefits, on-site/off-site overhead, G&A), material handling, and other direct costs. The template is designed to calculate fully burdened labor rates including various indirect rates, escalation factors, and fees. The format supports a CPFF (Cost Plus Fixed Fee) pricing structure and includes separate fee calculations for prime and subcontractor labor costs.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| N00173-25-R-0004 0004.pdf | ||
| N00173-25-R-0004 0003.pdf | ||
| N00173-25-R-0004 0002.pdf | ||
| Attachment 10 - Questions and Answers 2.docx | DOCX document | |
| Attachment 7 - Draft DD254.pdf | ||
| N00173-25-R-0004 0001.pdf | ||
| Attachment 9 - Questions and Answers 1.docx | DOCX document | |
| Attachment 7 - DD254.pdf | ||
| Attachment 6 -Direct Labor Rate Substantiation.xls | XLS spreadsheet | |
| Attachment 2 - Personnel Quals 14 Jan 2025.docx | DOCX document | |
| Solicitation - N0017325R0004.pdf | ||
| Attachment 3 - Past Performance Questionnaire.pdf | ||
| Attachment 5 -SBPCD.pdf | ||
| Exhibit A - CDRLs.pdf | ||
| Attachment 8 - Req for On-Site Contractors.docx | DOCX document | |
| Attachment 1 - SOW - 14 Jan 2025.docx | DOCX document |
Show all 16
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
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 .