N0017325R0007 - Attachment 14_Task Order 002 Cost Proposal Spreadsheet.xls

This is a cost proposal spreadsheet template (Attachment 14) for Task Order 002 under solicitation N0017323RTJ01 for the Naval Research Laboratory's Focused Radio Frequency Optimized Signal Transference (FROST) program. The template requires pricing for 21 labor categories over three years, including required positions (Program Manager IV, Electro-Optical Scientists, Analysts, and Electrical Engineers) and optional positions (Systems Engineers, Software Engineers, IT Systems Engineers, Technical Writer, and Administrative Support). The positions require various security clearance levels from SECRET to TS/SCI, with work performed at both contractor and government sites.

The spreadsheet includes sections for direct labor costs, indirect rates (overhead, fringe benefits, G&A), subcontractor costs, fixed fee calculations, and Other Direct Costs (ODCs) with plugged values of $150,000 for travel and $5,850,000 for materials/equipment across three years. The total CPFF (Cost Plus Fixed Fee) value shown is $6,000,000, allocated as $2,000,000 per year. Each labor category is structured for 1,920 hours per year (except Technical Writer at 1,200 hours), with detailed rate build-up tables for both government and contractor site calculations.