Level of Effort Spreadsheet.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- Berthing and Messing Program Services
- Solicitation number
- N0018926RL013
About this file
This is a Level of Effort Spreadsheet detailing labor requirements and cost allocation for the Berthing and Messing Program Services contract with the Naval Supply Systems Command. The contract spans approximately 5.5 years from August 1, 2026 through January 31, 2032, comprising a one-year base period, four one-year option periods, and a partial year extension under FAR 52.217-8. The spreadsheet establishes a staffing model with 15 distinct labor categories including supervisory, technical, and trades personnel such as fore persons, engineering technicians, HVAC mechanics, electricians, plumbers, welders, and telecommunications mechanics, with the base year requiring approximately 104,544 total hours (approximately 50 FTE equivalent) and proportionally reduced hours for the FAR 52.217-8 period.
The spreadsheet includes cost line items (CLINs) structured around Labor, Materials, Other Direct Costs (ODCs), and Travel for each contract period, though specific pricing is not filled in. A detailed materials/services schedule lists approximately 40 distinct line items with estimated quantities and units required, including turnkey solutions for hotel and utility hookups, KEVLAR mooring lines, CHT system overhauls, deck preservation, HVAC equipment maintenance, fire safety systems inspections, and various cleaning and repair services for yard and repair barges (YR, YRBM, YRBM(L), and APL classes). The labor spreadsheet framework includes columns for direct labor rates, fringe percentages, overhead, G&A allocation, and fee calculations to establish fully burdened labor rates, but the actual rates and percentages remain to be completed.
View the file
Other files
Show all 32
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Summary
| Base Year Period Period of Performance: 01 August 2026 - 31 July 2027 | |
| CLIN | Total CLIN Value |
| CLIN 0001 Labor | $0.00 |
| CLIN 0002 Materials | $0.00 |
| CLIN 0003 ODCs | $0.00 |
| CLIN 0004 Travel | $0.00 |
| Base Total | $0.00 |
| Option Year 1 Period of Performance : 01 August 2027 - 31 July 2028 | |
| CLIN | Total CLIN Value |
| CLIN 1001 Labor | $0.00 |
| CLIN 1002 Materials | $0.00 |
| CLIN 1003 ODCs | $0.00 |
| CLIN 1004 Travel | $0.00 |
| Option 1 Total | $0.00 |
| Option Year 2 Period of Performance : 01 August 2028 - 31 July 2029 | |
| CLIN | Total CLIN Value |
| CLIN 2001 Labor | $0.00 |
| CLIN 2002 Materials | $0.00 |
| CLIN 2003 ODCs | $0.00 |
| CLIN 2004 Travel | $0.00 |
| Option 2 Total | $0.00 |
| Option Year 3 Period of Performance : 01 August 2029 - 31July 2030 | |
| CLIN | Total CLIN Value |
| CLIN 3001 Labor | $0.00 |
| CLIN 3002 Materials | $0.00 |
| CLIN 3003 ODCs | $0.00 |
| CLIN 3004 Travel | $0.00 |
| Option 3 Total | $0.00 |
| Option Year 4 Period of Performance : 01 August 2030 - 31 July 2031 | |
| CLIN | Total CLIN Value |
| CLIN 4001 Labor | $0.00 |
| CLIN 4002 Materials | $0.00 |
| CLIN 4003 ODCs | $0.00 |
| CLIN 4004 Travel | $0.00 |
| Option 4 Total | $0.00 |
| FAR 52.217-8 Period of Performance : 01 August 2031 - 31 January 2032 | |
| CLIN | Total CLIN Value |
| CLIN 5001 Labor | $0.00 |
| CLIN 5002 Materials | $0.00 |
| CLIN 5003 ODCs | $0.00 |
| CLIN 5004 Travel | $0.00 |
| FAR 52.217-8 Total | $0.00 |
| ContractTotal |
_x000D_&1#&"Calibri"&10&K0000FF Information in this document/e-mail is considered Business Use Only. Please treat accordingly.
Materials
| Supplies/Services | Est Qty | Unit | Unit | |||
| Price | Amount | |||||
| A | 102AE | Deliver a Turnkey Hotel and Utility Hookup Solution to include but not limited to sewage, potable water, steam, shore power, telephone, fire main, gangways and cable television connections (Down River) | 50 | EA | ||
| A | 102AG | Supply 1 inch KEVLAR mooring lines (150 ft. in length). With 6' loop in both ends, with Chafing gear installed. | 60 | EA | ||
| A | 102AH | Supply 2 inch KEVLAR mooring lines (200 ft. in length). With 6' loop in both ends, with Chafing gear installed. | 20 | EA | ||
| A | 104AC | Deliver a Turnkey CHT System Overhaul, resulting in a system certified as safe for entry and hot work, fully inspected, tested, and upgraded with four (4) new floats. (YR, YRBM, YRBM(L), and all APL's except for APL-61) | 10 | SY | ||
| A | 106AA | Deliver newly installed and operational Commercial-Grade Garbage Disposal. | 4 | EA | ||
| A | 110AC | Procure a Turnkey Replacement for 2-4 inch diameter Copper-Nickel (CU-NI) Valves. | 800 | LF | ||
| A | 113AC | Deliver a newly preserved interior deck surface (90% Interior Compartments, 10% Wet Spaces) | 100,000 | SF | ||
| A | 115AA | Material (in support of ELIN 115) to Deliver repairs identified during testing, as well as itmes identified on the trouble call log | 100000 | US Dollars | ||
| A | 103AB | Deliver clean and sanitize the entire Craft (YRBM Class) | 10 | EA | ||
| A | 103AC | Deliver clean and sanitize the entire Craft (YRBM(L) Class) | 15 | EA | ||
| A | 103AD | Deliver clean and sanitize the entire Craft (YRBM(57) Class) | 4 | EA | ||
| A | 103AG | Deliver clean and sanitize the entire Craft (APL-66, 67, 71, 73 Class) | 12 | EA | ||
| A | 103AH | Deliver cllean using Crygenic (Dry Ice) entire Galley Exhaust Ventilation (YR Class) | 10 | EA | ||
| A | 103AI | Deliver cllean using Crygenic (Dry Ice) entire Galley Exhaust Ventilation (APL Class) except APL-66, 67, 71, 73 Class | 5 | EA | ||
| A | 105AC | Procure new dry chemical fire extinguishers, 20 lbs. | 500 | EA | ||
| A | 105AD | Deliver Annual Inspection and Certification of Gaylord Hood system | 25 | EA | ||
| A | 105AF | Deliver Annual Inspection and Certification of Fire and Flooding Alarm Panel and System, including all attached equipment for legacy IC/SM Systems. | 25 | EA | ||
| A | 105AG | Deliver Annual Inspection and Certification of Fire and Flooding Alarm Panel and System, including all attached equipment for Siemens Systems. | 25 | EA | ||
| A | 105AH | Deliver Annual Inspection and Certification of Fire and Flooding Alarm Panel and System, including all attached equipment for Notifier Systems. | 25 | EA | ||
| A | 105AK | Provide Certificate of Calibration for specified gage | 1000 | EA | ||
| A | 106AA | Deliver newly installed and operational Commercial-Grade Garbage Disposal. | 4 | EA | ||
| A | 111AB | Material (in support of ELIN 111) to Deliver repairs to A/C and refrigeration equipment (for bidding purposes only) | 250000 | US Dollars | ||
| A | 111AD | Deliver newly installed 12 in. x 20 in. Ventilation Duct Assembly | 300 | LF | ||
| A | 111AN | Deliver OEM-Certified HVAC Condenser Coils Inspection, Preservation and Cleaning Package - MITSUBISHI YRBM(L) | 75 | EA | ||
| A | 111AO | Provide Condensing Coil Cleaning, Preservation and Certification Package for Walk-in Reefer/Freezer Units | 10 | EA | ||
| A | 111AP | Deliver OEM-Certified HVAC Units and Compressor Cleaning Package ( YR, YRBM, YRBM(L) ) | 10 | EA | ||
| A | 112AK | Deliver Terrazzo Deck Replacement Solution. | 2,500 | SF |
Base Year
| Estimated Level of Effort: 01 August 2026 - 31 July 2027 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 2440 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 6592 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 1920 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 1920 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 11784 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 4672 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 7112 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 11784 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 9448 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 4360 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 7112 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 7112 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 7112 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 4360 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 9448 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
Option Year 1
| Estimated Level of Effort: 01 August 2027 - 31 July 2028 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 2440 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 6592 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 1920 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 1920 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 11784 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 4672 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 7112 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 11784 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 9448 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 4360 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 7112 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 7112 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 7112 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 4360 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 9448 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
Option Year 2
| Estimated Level of Effort: 01 August 2028 - 31 July 2029 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 2440 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 6592 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 1920 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 1920 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 11784 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 4672 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 7112 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 11784 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 9448 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 4360 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 7112 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 7112 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 7112 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 4360 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 9448 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
Option Year 3
| Estimated Level of Effort: 01 August 2029 - 31 July 2030 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 2440 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 6592 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 1920 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 1920 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 11784 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 4672 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 7112 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 11784 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 9448 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 4360 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 7112 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 7112 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 7112 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 4360 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 9448 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
Option Year 4
| Estimated Level of Effort: 01 August 2030 - 31 July 2031 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 2440 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 6592 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 1920 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 1920 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 11784 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 4672 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 7112 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 11784 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 9448 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 4360 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 7112 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 7112 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 7112 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 4360 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 9448 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
FAR 52.217-8
| Estimated Level of Effort: 01 August 2031 - 31 January 2032 | |||||||||||||||
| Labor Category | Total Hours | FTE | Direct Labor Rate | Fringe % | Fringe $ | DL + Fringe | Overhead % | Overhead $ | G&A % | G&A $ | Subtotal | Fee % | Fee $ | Fully Burdened Labor Rate | Total Labor Cost (FBLR x Hours) |
| 1st FORE PERSON/SUPERVISOR | 1220 | 1 | |||||||||||||
| 1ST LEAD PERSON/ ASSISTANT SUPERVISOR | 3296 | 3 | |||||||||||||
| ADMINISTRATIVE ASSISTANT | 960 | 1 | |||||||||||||
| SUPPLY TECHNICIAN | 960 | 1 | |||||||||||||
| SYSTEM SUPPORT SPECIALIST | 5892 | 5 | |||||||||||||
| WAREHOUSE SPECIALIST | 2336 | 2 | |||||||||||||
| ELECTRICIAN, MAINTENANCE | 3556 | 3 | |||||||||||||
| ENGINEERING TECHNICIAN VI | 5892 | 5 | |||||||||||||
| HEATING, REFRIGERATION, AND AIR CONDITIONING MECHANIC | 4724 | 4 | |||||||||||||
| PAINTER, MAINTENANCE | 2180 | 2 | |||||||||||||
| PIPEFITTER, MAINTENANCE | 3556 | 3 | |||||||||||||
| PLUMBER, MAINTENANCE | 3556 | 3 | |||||||||||||
| SHEET-METAL WORKER, MAINTENANCE | 3556 | 3 | |||||||||||||
| TELECOMMUNICATIONS MECHANIC II | 2180 | 2 | |||||||||||||
| WELDER, COMBINATION, MAINTENANCE | 4724 | 4 |
Labor Category Total Hours FTE Direct Labor Rate Fringe % Fringe $ DL + Fringe Overhead % Overhead $ G&A % G&A $ Subtotal Fee % Fee $ Fully Burdened Labor Rate Total Labor Cost (FBLR x Hours)
File details come from the government source that posted it. Updated .