Level of Effort Spreadsheet.xlsx

This is a Level of Effort Spreadsheet that outlines the labor, materials, and other direct costs (ODCs) for a berthing and messing program services contract spanning approximately 5.5 years. The contract includes a one-year base period (August 1, 2026 – July 31, 2027), four one-year option periods (August 1, 2027 – July 31, 2031), and a partial period under FAR 52.217-8 (August 1, 2031 – January 31, 2032). The spreadsheet contains four cost line items (CLINs) for each period: Labor (CLIN X001), Materials (CLIN X002), Other Direct Costs (CLIN X003), and Travel (CLIN X004). All CLIN values are currently listed at $0.00, indicating this is a template awaiting cost data completion.

The labor section details 15 distinct occupational categories with estimated hours and full-time equivalent (FTE) staffing levels for each period. The base year and option years one through four each specify identical labor requirements: 1st Fore Person/Supervisor (2,440 hours, 1 FTE), 1st Lead Person/Assistant Supervisor (6,592 hours, 3 FTE), Administrative Assistant (1,920 hours, 1 FTE), Supply Technician (1,920 hours, 1 FTE), System Support Specialist (11,784 hours, 5 FTE), Warehouse Specialist (4,672 hours, 2 FTE), and various maintenance specialists including electricians, HVAC mechanics, painters, pipefitters, plumbers, sheet metal workers, telecommunications mechanics, and welders. The FAR 52.217-8 period reflects approximately half the labor hours of the annual periods. The spreadsheet also includes a materials and supplies section listing 30+ line items for vessel maintenance, including mooring lines, valve replacements, deck preservation, fire safety equipment, HVAC components, and various cleaning and certification services with estimated quantities and labor dollars budgeted at $100,000 and $250,000 for specific repair categories.