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
Issued by

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

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

TotalTotal
SOWLaborLaborBaseBaseBaseOption 1Option 1Option 1Option 2Option 2Option 2Option 3Option 3Option 3Option 4Option 4Option 4EXTEXTEXT
PWSLocationLabor Category Description per PWSHoursCostsRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
3.1.5.1BahrainEngineering Technician - Mechanical Auxiliary211221122112211221121056
3.1.5.2BahrainEngineering Technician - Mechanical Hydraulics211221122112211221121056
3.2.1BahrainProduction Controller - D level planner2112211221121056
3.2.2BahrainProduction Controller - IMA Planner2112211221121056
3.2.3RotaProduction Controller - Dive Planner211221122112211221121056
3.1.6RotaTechnician - METCAL Program211221122112211221121056
3.1.5.3RotaEngineering Technician - Marine Gas Turbine Inspector211221122112211221121056
3.1.5.5RotaCombat System Technician - CANES/Afloat Network211221122112211221121056
3.1.5.4RotaCombat System Technician - SPY Technician211221122112211221121056
Total Hours14784147841900819008190089504
Full Time Equivalent (FTE)779999

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 .