Attachment 2 Level of Effort Spreadsheet.xlsx

This is a Level of Effort Spreadsheet that outlines labor staffing and hours required for a five-year ordering period supporting maintenance and overhaul services for Commander Naval Surface Force, Atlantic (CNSL) shipboard material handling equipment (MHE) and mobile support equipment. The contract period spans August 30, 2026 through August 29, 2031, with an additional FAR 52.217-8 option period from August 30, 2031 through February 29, 2032.

The spreadsheet details labor requirements across five operational periods (OP 1-5), each covering a 12-month period, plus the final six-month option period. Each operational period specifies staffing for ten labor categories: Program Manager (1,040 hours/FTE), Shop Supervisor (2,080 hours/FTE), Senior Engineering Technician—Mechanical (6,240 hours/3 FTE), Junior Engineering Technician—Mechanical (8,320 hours/4 FTE), Shop Warehouse—Electrical Battery specialist (2,080 hours/FTE), Material Expediter (4,160 hours/2 FTE), Administrative Assistant (2,080 hours/FTE), Production Manager (2,080 hours/FTE), Senior Engineering Technician—Mechanical Mobile (4,160 hours/2 FTE), and Quality Assurance Inspector (2,080 hours/FTE). The spreadsheet also captures overtime hours for each labor category across all periods. The cost structure includes columns for direct labor rates, fringe benefits, overhead, general and administrative (G&A) expenses, and fee calculations to determine fully burdened labor rates; however, all CLIN values currently display as $0.00, indicating the spreadsheet is a template awaiting cost data completion.