Attachment 2 Level of Effort Spreadsheet.xlsx

This is a Level of Effort (LOE) Spreadsheet that details the staffing plan and labor categories for a five-year contract with four option years supporting maintenance and overhaul services for Commander Naval Surface Force, Atlantic (CNSL) shipboard material handling equipment (MHE) and mobile support equipment. The base year runs from 30 August 2026 through 29 August 2027, followed by four one-year option periods (30 August 2027 through 29 August 2031) and a final partial period from 30 August 2031 through 29 February 2032 under FAR 52.217-8.

The spreadsheet identifies ten core labor categories required across the performance periods: Program Manager, Shop Supervisor, Senior Engineering Technician (Mechanical), Junior Engineering Technician (Mechanical), Shop Warehouse Electrician (Battery), Material Expediter, Administrative Assistant, Production Manager, Senior Engineering Technician (Mechanical Mobile), and Quality Assurance Inspector. For the base year and each option year, the contractor must maintain staffing at one Full-Time Equivalent (FTE) for most positions, with Senior Engineering Technicians allocated three FTEs and Junior Engineering Technicians allocated four FTEs. The spreadsheet also itemizes overtime (OT) hours for each labor category across all periods. The summary indicates all Contract Line Item Numbers (CLINs) are structured with separate line items for Labor, Materials, Other Direct Costs (ODCs), and Travel across all performance periods. The document notes that pricing details (Direct Labor Rates, Fringe, Overhead, G&A, and Fee percentages) and fully burdened labor rate calculations are to be completed within the spreadsheet template, though the current version displays $0.00 values pending cost input.