2.00d Attachment 04 Calculation of Indirect Costs - Amendment 01.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- FDRMC ENGINEERING SUPPORT SERVICES
- Solicitation number
- N6817126RN005
About this file
This file is an indirect cost calculation worksheet structured to support a cost-plus fixed fee task order proposal for engineering support services under the SeaPort NxG contract vehicle. The spreadsheet outlines labor categories, hours, and rates across a base year and four option years, with extension periods, organized by performance work statement (PWS) sections and geographic locations (Bahrain and Rota).
The labor structure identifies nine distinct engineering and production control positions, including mechanical technicians, hydraulics specialists, production planners, dive planners, METCAL program technicians, marine gas turbine inspectors, and combat systems technicians. The base year and each option year show consistent labor hour allocations of 14,784 hours (7 FTE) for the base period, 19,008 hours (9 FTE) for Options 1-3, and 9,504 hours (9 FTE) for Option 4 and extensions, indicating workforce scaling across contract periods. The worksheet provides placeholders for rate calculations, base costs, and indirect rate applications, with separate sections designated for both prime contractor and subcontractor indirect cost allocation and documentation. This template is designed to support transparent cost accounting and indirect rate justification required for Cost Plus Fixed Fee contracts under the SeaPort NxG vehicle awarded by Naval Supply Systems Command.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2.00a Attachment 01 Past Performance Information - Amendment 01.doc | DOC document | |
| QandA.pdf | ||
| 26RN005 Schedule B - Amendment 01.xlsx | XLSX spreadsheet | |
| 2.00e Attachment 05 Support for Unloaded Labor Rates and Costs - Amendment 01.xlsx | XLSX spreadsheet | |
| Solicitation Amendment N6817126RN0050001 SF 30.pdf | ||
| Attachment 01 Past Performance Information.doc | DOC document | |
| Attachment 02 Past Performance Questionnaire.docx | DOCX document | |
| Attachment 04 Calculation of Indirect Costs.xlsx | XLSX spreadsheet | |
| Attachment 09 CDRL_A0003_ODC REPORT.pdf | ||
| Attachment 05 Support for Unloaded Labor Rates and Costs.xlsx | XLSX spreadsheet | |
| Attachment 10 CDRL_A0004_TRIP REPORT.pdf | ||
| Attachment 07 CDRL_A0001_CO MGMT REPORT.pdf | ||
| Attachment 08 CDRL_A0002_ROSTER.pdf | ||
| Attachment 03 DD Form 254_ENG.pdf | ||
| Solicitation - N6817126RN005.pdf | ||
| Attachment 06 QUALITY ASSURANCE SURVEILLANCE PLAN.docx | DOCX document |
Show all 16
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
Sheet1
| Total | Total | |||||||||||||||||||||
| SOW | Labor | Labor | Base | Base | Base | Option 1 | Option 1 | Option 1 | Option 2 | Option 2 | Option 2 | Option 3 | Option 3 | Option 3 | Option 4 | Option 4 | Option 4 | EXT | EXT | EXT | ||
| PWS | Location | Labor Category Description per PWS | Hours | Costs | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| 3.1.5.1 | Bahrain | Engineering Technician - Mechanical Auxiliary | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.1.5.2 | Bahrain | Engineering Technician - Mechanical Hydraulics | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.2.1 | Bahrain | Production Controller - D level planner | 2112 | 2112 | 2112 | 1056 | ||||||||||||||||
| 3.2.2 | Bahrain | Production Controller - IMA Planner | 2112 | 2112 | 2112 | 1056 | ||||||||||||||||
| 3.2.3 | Rota | Production Controller - Dive Planner | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.1.6 | Rota | Technician - METCAL Program | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.1.5.3 | Rota | Engineering Technician - Marine Gas Turbine Inspector | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.1.5.5 | Rota | Combat System Technician - CANES/Afloat Network | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| 3.1.5.4 | Rota | Combat System Technician - SPY Technician | 2112 | 2112 | 2112 | 2112 | 2112 | 1056 | ||||||||||||||
| Total Hours | 14784 | 14784 | 19008 | 19008 | 19008 | 9504 | ||||||||||||||||
| Full Time Equivalent (FTE) | 7 | 7 | 9 | 9 | 9 | 9 |
Rate Base Costs Rate Base Costs Rate Base Costs Rate Base Costs Rate Base Costs Rate Base Costs
Applicable Indirect Rates
| Notes: | Show calculation and allocation of prime and subcontor indirect |
| rates. Separate schedule for prime and subcontractor. |
File details come from the government source that posted it. Updated .