Attachment 4 Cost Summary Spreadsheet.xlsx
XLSX spreadsheet 62 KB Posted
- Attached to
- DT-511C and DT-592D Hydrophones and Spare Parts
- Solicitation number
- N6660425R0361
About this file
This document is a Cost Summary Spreadsheet for a naval hydrophone production contract. The spreadsheet provides detailed cost breakdowns for multiple hydrophone components, including first article and production units for DT-511/DT-592 Hydrophones, with separate cost summaries for Hydrophone Resilient Mount, Hydrophone Receptacle, Hydrophone Boot, Hydrophone Pre-Amplifier Circuit Card, and Hydrophone Sub-Assembly. Each component section includes templated sections for direct labor hours, indirect rates/costs, material costs, other direct costs (ODCs), and calculates profit margins and general & administrative (G&A) expenses, though the specific numerical values are not filled in. The spreadsheet is designed to help contractors comprehensively break down and calculate the total estimated firm-fixed price for each hydrophone component, with instructions to insert specific labor categories, hours, rates, quantities, and pricing details.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Solicitation N6660425R03610003.pdf | ||
| Solicitation N6660425R03610002002.pdf | ||
| Solicitation N6660425R03610001.pdf | ||
| Exhibit B CDRLS.pdf | ||
| Exhibit A CDRLS.pdf | ||
| Attachment 2 Performance Based Milestone Plan.pdf | ||
| Solicitation - N6660425R0361.pdf | ||
| Attachment 1 Pricing Tables.docx | DOCX document | |
| Attachment 3 DD254.pdf |
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
First Article Cost Summary - Per Unit (First Article DT-511/DT-592 Hydrophone)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Production Hydrophones Cost Summary - Per Unit (Production DT-511/DT-592 Hydrophone)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Hydrophone Resilient Mount Cost Summary - Per Unit (DT-511C & DT-592D HYDROPHONE RESILIENT MOUNT)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Hydrophone Receptacle Cost Summary - Per Unit (DT-511C & DT-592D HYDROPHONE RECEPTACLE)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Hydrophone Boot Cost Summary - Per Unit (DT-511C HYDROPHONE BOOT)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Hydrophone Pre-Amplifier CC Cost Summary - Per Unit (DT-592D HYDROPHONE PRE-AMPLIFIER CIRCUIT CARD)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
Hydrophone Sub-Assembly Cost Summary - Per Unit (DT-592D HYDROPHONE SUB-ASSEMBLY)
DIRECT LABOR HOURS RATE AMOUNT
| $ - 0 | Insert Labor Categories, Hours of each Labor Quantity needed, and UNBURDENED LABOR RATES. Amount is achieved by multiplying the hours and labor rate. Add lines as necessary. | ||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| $ - 0 | |||
| Total Labor Hours/Cost | 0 | $ - 0 |
INDIRECT RATES/COST HOURS RATE AMOUNT
Insert Indrect rates and costs applied to the Direct Labor. These normally include Overhead and General and Adminstrative costs (include any indirect factor used in developing the firm-fixed price). NOTE: Include the formulas used to capture amounts.
Total Indirect Costs 0 $ - 0
MATERIAL QTY UNIT PRICE TOTAL
| $ - 0 | Add additional lines, as necessary. Insert item, quantity needed and the unit price. Total is achieved by multiplying the quantity and unit price. | |
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total Material Cost | $ - 0 |
| Other Direct Costs (ODCs) | ||
| Any ODCs not included above. Add additional lines, as necessary. Insert item quantity needed and cost of ODCs. Total is achieved by multiplying the quantity and unit price. | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| $ - 0 | ||
| Total ODCs | $ - 0 | |
| Total Material and ODCs | $ - 0 |
| *G&A on Material and ODCs | 0% | $ - 0 | Insert percentage in highlighted fields. |
| Profit on Labor | 0% | $ - 0 | |
| Profit on Material and ODCs | 0% | $ - 0 | |
| Total Estimated Firm Fixed Price | $ - 0 |
*General & Administrative Expenses (G&A) capture the costs of support functions (accounting, personnel, purchasing, legal) that are not directly chargeable to any single project or contract. G&A is calculated by applying the appropriate percentage to the sum of the materials and ODCs.
File details come from the government source that posted it. Updated .