Attachment 2 Level of Effort Cost Spreadsheet.xlsx

This is a Level of Effort Cost Spreadsheet 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 includes a base year period of performance from August 30, 2026, to August 29, 2027, followed by four option years with identical annual periods through August 29, 2031, and a final FAR 52.217-8 period from August 30, 2031, to February 29, 2032. The spreadsheet outlines the cost structure across five Contract Line Item Numbers (CLINs) per period: Labor, Materials, Other Direct Costs (ODCs), and Travel, though all CLIN values are currently shown as $0.00 pending detailed cost estimation.

The labor cost estimates detail a comprehensive staffing plan including ten primary labor categories (Program Manager, Shop Supervisor, Senior and Junior Engineering Technicians-Mechanical, Shop Warehouse Electrician, Material Expediter, Administrative Assistant, Production Manager, Senior Engineering Technician-Mechanical Mobile, and Quality Assurance Inspector) with consistent full-time equivalent allocations throughout the base year and option years. Each labor category includes standard annual hours (ranging from 1,040 to 8,320 hours) plus overtime hours, with overhead, fringe benefits, General & Administrative (G&A), and fee percentages to be applied for calculating fully burdened labor rates. The FAR 52.217-8 period reflects reduced staffing at approximately 50 percent of the standard annual hours due to its six-month duration rather than a full fiscal year.