Attachment 5 - Cost-Price Summary Spreadsheet.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Support for Design, Development and Integration of a Mobile Over-the-Horizon Radar (MOTHR)
- Solicitation number
- N00173-23-R-MB13
About this file
This document contains a cost proposal template and instructions for a federal contract opportunity to provide engineering support services to the Department of the Navy for the design, development, and integration of a mobile over-the-horizon radar system. The cost proposal template includes charts for building up direct labor rates, subcontractor labor rates, and indirect cost rates over multiple years. It also includes a summary template to calculate total cost plus fixed fee for the base year and multiple option years. The related federal contract opportunity is solicitation number N00173-23-R-MB13 issued by the Department of the Navy Secretary of the Navy Office of Naval Research to provide support for the design, development, and integration of a Mobile Over-the-Horizon Radar system. The response due date and award date are not specified.
View the file
Other files
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-22 | 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 |
Add Rows as Necessary
&"Times New Roman,Regular"&9Radar Engineering Support for the Radar Division Advanced Concept Group &"Times New Roman,Regular"&9RFP: N00173-23-R-MB13 Attachment 5 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"&9Radar Engineering Support for the Radar Division Advanced Concept Group &"Times New Roman,Regular"&9RFP: N00173-23-R-MB13
SUMMARY TEMPLATE
CHART BELOW MAY BE EDITED IF NEEDED.
TASK ORDER 1 -- COST SUMMARY FORMAT
| Total | Base Year | Option 1 | Option 2 | Option 3 | Option 4 | |||||||||||||
| 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"&9Radar Engineering Support for the Radar Division Advanced Concept Group &"Times New Roman,Regular"&9RFP: N00173-23-R-MB13
File details come from the government source that posted it. Updated .