Attachment P1_Cost Summary_spreadsheet.xls

This is a cost summary spreadsheet template for the Aeromechanics Systems and Engineering solicitation N00421-26-R-1009. The template provides instructions for contractors to develop detailed cost proposals across multiple Contract Line Item Numbers (CLINs) organized by period of performance.

The spreadsheet is designed to capture labor costs organized by government labor categories with columns for proposed contractor categories, work location (contractor or government facility), full-time or part-time status, and employee names. Contractors must enter unburdened labor rates for prime contractor employees and fully burdened rates for subcontractor labor. The template accommodates up to eight subcontractors and requires entries for fringe benefits, overhead rates (differentiated by work location), General and Administrative (G&A) rates, and material handling rates. Other Direct Costs (ODCs) are captured separately for travel, materials, and NMCI (Navy/Marine Corps Intranet) expenses, with provision for material handling and G&A applied to ODCs. The template includes automatic calculations for fixed fees and profit pools applied to labor, subcontractor costs, and ODCs. For proposals with multiple option periods, contractors must create separate worksheets for each period and a summary sheet consolidating all periods. A Capacity Increase CLIN (CIC) at 10% is provided for contingency planning but can be modified or eliminated per solicitation requirements. The file notes that colored cells contain formulas and should not be edited, and all dollar figures must be carried to two decimal places.