Level of Effort Spreadsheet.xlsx

This is a Level of Effort Spreadsheet that outlines estimated labor requirements and cost structure for a maintenance services contract supporting the Berthing and Messing Program Services solicitation (N0018926RL013) for the Department of the Navy Naval Supply Systems Command. The contract spans a base year (August 1, 2026 – July 31, 2027) plus four option years and a partial final period extending through January 31, 2032. The spreadsheet provides detailed labor hour estimates across three geographic locations: Hampton Roads, Virginia; Groton, Connecticut; and Kittery, Maine, with all contract values currently showing $0.00, indicating this is a template awaiting cost data completion.

The labor structure identifies 16 distinct maintenance-focused job categories including supervisory, administrative, technical, and skilled trades positions such as Electrician, HVAC Mechanic, Pipefitter, Plumber, Sheet-Metal Worker, Welder, and Painter. Each period includes both regular and overtime hour estimates, with labor costs broken down by cost elements including Direct Labor Rate, Fringe, Overhead, General & Administrative expenses, and Fee percentages to calculate Fully Burdened Labor Rates. The base year and option years maintain consistent staffing levels with identical FTE counts per position, while the FAR 52.217-8 period (August 1, 2031 – January 31, 2032) reflects proportionally reduced hours corresponding to its six-month duration. The spreadsheet also includes separate line items for Materials (CLIN 0002/1002/2002/3002/4002/5002), Other Direct Costs (CLIN 0003/1003/2003/3003/4003/5003), and Travel (CLIN 0004/1004/2004/3004/4004/5004) to capture the full contract cost structure.