Attachment 2 Level of Effort Spreadsheet.xlsx

This is a Level of Effort Spreadsheet detailing labor staffing and hours for a five-year maintenance and overhaul services contract for Commander Naval Surface Force, Atlantic (CNSL) Shipboard Material Handling Equipment (MHE) and Shipboard Mobile Support Equipment (SMSE). The contract period of performance spans from August 30, 2026 through August 29, 2031, with an additional six-month FAR 52.217-8 period extending through February 29, 2032. The spreadsheet is structured as a cost estimate template with line items for four cost elements: Labor (CLIN 0001), Materials (CLIN 0002), Other Direct Costs/ODCs (CLIN 0003), and Travel (CLIN 0004), with corresponding CLINs for the option period (1001-1004). All cost values are currently shown as $0.00, indicating this is a template awaiting completion.

The labor staffing plan identifies ten primary labor categories required throughout the five-year base period, each for one fiscal year operational period (OP 1 through OP 5): Program Manager, Shop Supervisor, Senior and Junior Engineering Technicians (Mechanical), Shop Warehouse Specialist (Electrical/Battery), Material Expediter, Administrative Assistant, Production Manager, Senior Engineering Technician (Mechanical Mobile), and Quality Assurance Inspector. Regular labor hours total 32,240 hours annually across these categories, supplemented by overtime hours for each position. The final six-month option period reduces all labor categories to approximately half the annual hours. The spreadsheet includes columns for calculating direct labor rates, fringe percentages, overhead, G&A rates, fee percentages, and fully burdened labor rates, though these financial details remain incomplete in the template provided.