Attachment 3 - Cost Summary Format v2.xls
XLS spreadsheet 135 KB Posted
- Attached to
- South Florida Waterfront and Maritime Operations Federal contract opportunity
- Solicitation number
- N00167-24-R-0016
About this file
This document contains cost tables and rate sheets submitted as part of a proposal for the solicitation N00167-24-R-0016 for South Florida Waterfront and Maritime Operations services. The proposal includes fully burdened labor rates for multiple labor categories across five program years, as well as other direct costs and subcontractor costs. Labor categories cover areas such as program and project management, administrative support, marine operations, engineering, and maintenance technicians. Other direct costs include amounts for travel, materials, and general and administrative expenses. Subcontractor costs incorporate labor, other direct expenses, fees, and pass-through amounts. The tables provide estimated hours and extended costs by labor category and year. Supporting documentation includes substantiation data for labor rates and sample indirect rate documentation.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Questions and Answers 1282023.pdf | ||
| Attachment 9 - Key and Non-Key Personnel Qualifications v.2.pdf | ||
| N0016724R0016-0002.pdf | ||
| CARDEROCKDIVINST 11262.2D Weight Handling Program Management.pdf | ||
| Additional Questions and Answers.pdf | ||
| N0016724R0016-0001.pdf | ||
| Questions and Answers.pdf | ||
| Exhibit A - Contract Data Requirements List.pdf | ||
| Attachment 9 - Key and Non-Key Personnel Qualifications.pdf | ||
| N0016724R0016 RFP.pdf | ||
| Attachment 7 - Technical Scenario Final.pdf | ||
| Attachment 2 - DD 254.pdf | ||
| Attachment 8 - Staffing Plan.xlsx | XLSX spreadsheet | |
| Attachment 5 - Wage Determination 2015-4525.pdf | ||
| Attachment 1 - Quality Assurance Surveillance Plan (QASP).pdf | ||
| Attachment 3 - Cost Summary Format.xls | XLS spreadsheet | |
| Attachment 4 - Past Performance Reference Sheet.pdf | ||
| Attachment 6 - OPSEC Requirements.pdf |
Show all 18
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Rates
| COST TABLE ATTACHMENT 4 | ||||||
| Rates Contractor FPRA/ FPRR | ||||||
| Rates Category | Gov or Contractor Site | 2024 | 2025 | 2026 | 2027 | 2028 |
| Program/Project Manager 2 (MANP2) | KTR | |||||
| Program/Project Manager 1 (MANP1) | Govt | |||||
| Administrative Assistant (01020, Wage Determ. 2015-4535) | Govt | |||||
| Boat Operator (BTO, O*Net Local Wages 49-3051.00) | Govt | |||||
| Electrician (23160, Wage Determ. 2015-4535) | Govt | |||||
| Fabricator/Welder (23960, Wage Determ. 2015-4535) | Govt | |||||
| Fabricator/Welder Overtime (OT) time + 1/2 | Govt | |||||
| GIS Specialist (30030, O*Net Local Wages 15-1299.02) | Govt | |||||
| Instrumentation Technician (23180, 23460,, O*Net Local Wages 49-9069.00) | Govt | |||||
| Machinist/CNC Programmer (23550O*Net Local Wages 51-9162.00) | Govt | |||||
| Marine Mechanic/Marine HVAC (23410, Wage Determ. 2015-4535) | Govt | |||||
| Marine Mechanic/Marine HVAC Overtime (OT) time + 1/2 | Govt | |||||
| Mechanical/Readiness Maintenance Technician (23530, Wage Determ. 2015-4535) | Govt | |||||
| Mechanical/ Readiness Maintenance Technician Overtime (OT) time + 1/2 | Govt | |||||
| Ocean Engineer (E1) | Govt | |||||
| Rigger (23850, Wage Determ. 2015-4535) | Govt | |||||
| Rigger Overtime (OT) time + 1/2 | Govt | |||||
| Fringe | ||||||
| G&A | ||||||
| FCCM | ||||||
| Rate categories shall include Direct and Indirect labor, Overhead and all other rates used in this proposal. | ||||||
| Values in the Rates (Government Fiscal Year) table shall be linked to all cost tables that use these rates. | ||||||
| Instructions: Each prime offeror and subcontractor offeror shall complete and submit one copy of this table in MS Excel format. The prime's submission must cover only the prime's proposed categories. The subcontractor's submission must cover only the subcontractor's proposed categories. In Column A, the offeror shall list all labor categories proposed using the Government's labor category titles identified in Section L of the solicitation. The offeror shall include separate rows for each rate within a given labor category (e.g., if two System Administrators are proposed using two different direct labor rates, include a row for each). The offeror shall include separate rows for Government site and contractor site rates. In Parentheses, the offeror shall list the contractor's titles for the Government's labor categories, if the titles used in the solicitation do not match. |
&LSOLICITATION N00167-24-R-0016-- ATTACHMENT 3
Prime Offeror Name and Cage Code:
Subcontractor Name and Cage Code (if applicable):
DCAA Point of Contact Information:
&CAttachment 3
Rate Sheet &LN00167-24-R-0016&C Source Selection Information See FAR 2.101 & 3.104
LOE HOURS
| ESTIMATED LOE ATTACHMENT 3 | |||||||
| TOTAL LOE Hours | |||||||
| HOURS | |||||||
| Rates Category | Gov or Contractor Site | 2024 | 2025 | 2026 | 2027 | 2028 | TOTAL |
| Program/Project Manager 2 (MANP2) | KTR | 960 | 960 | 960 | 960 | 960 | 4,800 |
| Program/Project Manager 1 | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | 9,600 |
| Administrative Assistant (01020, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | 9,600 |
| Boat Operator (BTO, O*Net Local Wages 49-3051.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | 19,200 |
| Electrician (23160, Wage Determ. 2015-4535) | Govt | 960 | 960 | 960 | 960 | 960 | 4,800 |
| Fabricator/Welder (23960, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | 9,600 |
| Fabricator/Welder Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | 1,500 |
| GIS Specialist (30030, O*Net Local Wages 15-1299.02) | Govt | 960 | 960 | 960 | 960 | 960 | 4,800 |
| Instrumentation Technician (23180, 23460, O*Net Local Wages 49-9069.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | 19,200 |
| Machinist/CNC Programmer (O*Net Local Wages 51-9162.00) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | 9,600 |
| Marine Mechanic/Marine HVAC (23410, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | 9,600 |
| Marine Mechanic/Marine HVAC Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | 1,500 |
| Mechanical/Maintenance Technician (23530, Wage Determ. 2015-4535) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | 19,200 |
| Mechanical/Maintenance Technician Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | 1,500 |
| Ocean Engineer (O*Net Local Wages 17-2141.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | 19,200 |
| Rigger (23850, Wage Determ. 2015-4535) | Govt | 4,800 | 4,800 | 4,800 | 4,800 | 4,800 | 24,000 |
| Rigger Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | 1,500 |
Substantiation Data
| SUBSTANTIATION DATA | ||||
| Labor Category | Employee Name | Employment Status | Rationale for Proposed Rate | Attached Supporting Documentation |
| Program Manager | Joe Smith | Current ABC employee | Current salary | Payroll data |
| Project Manager | Jim Jones | Contingency Hire | Agreed to contingency salary | Contingency Hire agreement |
| Database Administrator | TBD | New Hire | Survey or Index | Economic Research Institute Report |
| Senior Installer | TBD | New Hire | Survey or Index | Salary.com Survey |
| Installer | Steve Johnson | Current ABC employee | Projected Salary | Will be transferred and promoted to higher salary - Payroll data from position provided |
| Customer Service Rep | TBD | New Hire | Other | See attached narrative of employment |
| contract/agreement |
Indirect Supporting Doc
| Rates Contractor FPRA/ FPRR/PBR | ACTUAL RATES | ||||||||
| Rates Category | Gov or Contractor Site | 2024 | 2025 | 2026 | 2027 | 2028 | 2021 | 2022 | 2023 |
| Labor OH | Govt | ||||||||
| Fringe | Govt | ||||||||
| G&A | Govt | ||||||||
| FCCM | Govt | ||||||||
| Labor OH | KTR | ||||||||
| Fringe | KTR | ||||||||
| G&A | KTR | ||||||||
| FCCM | KTR | ||||||||
| Etc. | |||||||||
| Etc. | |||||||||
| Etc. |
&C&"Arial,Bold" Sample Indirect Rate Supporting Documentation
Fully Burdened Rates
| COST TABLE ATTACHMENT 3 | ||||||
| Fully Burdened Rates | ||||||
| Fully Burdened Rates | ||||||
| Rates Category | Gov or Contractor Site | 2023 | 2024 | 2025 | 2026 | 2027 |
| Program/Project Manager 2 (MANP2) | KTR | |||||
| Program/Project Manager 1 (MANP1) | GOVT | |||||
| Administrative Assistant (01020, Wage Determ. 2015-4535) | GOVT | |||||
| Boat Operator (BTO, O*Net Local Wages 49-3051.00) | GOVT | |||||
| Electrician (23160, Wage Determ. 2015-4535) | GOVT | |||||
| Fabricator/Welder (23960, Wage Determ. 2015-4535) | GOVT | |||||
| Fabricator/Welder Overtime (OT) time + 1/2 | GOVT | |||||
| GIS Specialist (30030, O*Net Local Wages 15-1299.02) | GOVT | |||||
| Instrumentation Technician (23180, 23460, O*Net Local Wages 49-9069.00) | GOVT | |||||
| Machinist/CNC Programmer (O*Net Local Wages 51-9162.00) | GOVT | |||||
| Marine Mechanic/Marine HVAC (23410, Wage Determ. 2015-4535) | GOVT | |||||
| Marine Mechanic/Marine HVAC Overtime (OT) time + 1/2 | GOVT | |||||
| Mechanical/Maintenance Technician (23530, Wage Determ. 2015-4535) | GOVT | |||||
| Mechanical/Maintenance Technician Overtime (OT) time + 1/2 | GOVT | |||||
| Ocean Engineer (O*Net Local Wages 17-2141.00) | GOVT | |||||
| Rigger (23850, Wage Determ. 2015-4535) | GOVT | |||||
| Rigger Overtime (OT) time + 1/2 | GOVT |
PRIME Total
| COST TABLE | |||||||||||||||||
| Cost Summary | |||||||||||||||||
| Major Cost Element | Gov or Contractor Site | YEAR 1 FY22 | YEAR 2 FY23 | YEAR 3 FY24 | YEAR 4 FY25 | YEAR 5 FY26 | Total $ | ||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | |||
| OTHER DIRECT COST | |||||||||||||||||
| ODC | $ 60,000 | $ 60,000 | $ 60,000 | $ 60,000 | $ 60,000 | $ 300,000 | |||||||||||
| Other (if any) | |||||||||||||||||
| Material Handling % | |||||||||||||||||
| G&A | |||||||||||||||||
| Total ODC | |||||||||||||||||
| Labor/Program Management Services | |||||||||||||||||
| Program/Project Manager 2 (MANP2) | KTR | 960 | 960 | 960 | 960 | 960 | |||||||||||
| Program/Project Manager 1 | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Administrative Assistant (01020, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Boat Operator (BTO, O*Net Local Wages 49-3051.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Electrician (23160, Wage Determ. 2015-4535) | Govt | 960 | 960 | 960 | 960 | 960 | |||||||||||
| Fabricator/Welder (23960, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Fabricator/Welder Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | |||||||||||
| GIS Specialist (30030, O*Net Local Wages 15-1299.02) | Govt | 960 | 960 | 960 | 960 | 960 | |||||||||||
| Instrumentation Technician (23180, 23460, O*Net Local Wages 49-9069.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Machinist/CNC Programmer (O*Net Local Wages 51-9162.00) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Marine Mechanic/Marine HVAC (23410, Wage Determ. 2015-4535) | Govt | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Marine Mechanic/Marine HVAC Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | |||||||||||
| Mechanical/Maintenance Technician (23530, Wage Determ. 2015-4535) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Mechanical/Maintenance Technician Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | |||||||||||
| Ocean Engineer (O*Net Local Wages 17-2141.00) | Govt | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Rigger (23850, Wage Determ. 2015-4535) | Govt | 4,800 | 4,800 | 4,800 | 4,800 | 4,800 | |||||||||||
| Rigger Overtime (OT) time + 1/2 | Govt | 300 | 300 | 300 | 300 | 300 | |||||||||||
| Total DIRECT Labor | 33,840 | 33,840 | 33,840 | 33,840 | 33,840 | ||||||||||||
| Labor OH | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| Other Rates** | |||||||||||||||||
| Overhead | |||||||||||||||||
| * | |||||||||||||||||
| * | |||||||||||||||||
| Total Labor & Overhead Rate | |||||||||||||||||
| G&A | |||||||||||||||||
| FCCM | |||||||||||||||||
| TOTAL LABOR OH | |||||||||||||||||
| SUBCONTRACTS | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| Subcontractor proposed cost and fee | |||||||||||||||||
| Subcontractor 1 | |||||||||||||||||
| Subcontractor 2 | |||||||||||||||||
| Etc. | |||||||||||||||||
| Total proposed subcontractor labor cost and fee | |||||||||||||||||
| Prime contractor pass through (not including fee) | |||||||||||||||||
| Handling | |||||||||||||||||
| G&A | |||||||||||||||||
| Other (if any) | |||||||||||||||||
| Total pass through (not including fee) | |||||||||||||||||
| Total Subcontractor Cost including pass through | |||||||||||||||||
| FCCM | |||||||||||||||||
| Total Labor Cost (Prime and Subcontractor Labor) | |||||||||||||||||
| Fixed Fee | |||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | |||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor | |||||||||||||||||
| Total Fee (Prime and Subcontractor Labor) | |||||||||||||||||
| Total FEE | |||||||||||||||||
| Total CPFF all CLINs (Labor and ODCs) | |||||||||||||||||
| Escalation Analysis | Percent | ||||||||||||||||
| Escalation from Base Period to Option Period 1 | |||||||||||||||||
| Escalation from Option Period 1 to Option Period 2 | |||||||||||||||||
| Escalation from Option Period 2 to Option Period 3 | |||||||||||||||||
| Escalation from Option Period 3 to Option Period 4 |
Sub 1
| COST TABLE | ||||||||||||||||||||
| Cost Summary | ||||||||||||||||||||
| Major Cost Element | Gov or Contractor Site | FY23 | FY24 | FY25 | FY26 | FY27 | FY28 | Total $ | ||||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | |||
| OTHER DIRECT COST | ||||||||||||||||||||
| ODC | ||||||||||||||||||||
| TRAVEL | ||||||||||||||||||||
| Material Handling | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Total ODC | ||||||||||||||||||||
| Labor | ||||||||||||||||||||
| Program/Project Manager 2 (MANP2) | ||||||||||||||||||||
| Program/Project Manager 1 | ||||||||||||||||||||
| Administrative Assistant (01020, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Boat Operator (BTO, O*Net Local Wages 49-3051.00) | ||||||||||||||||||||
| Electrician (23160, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Fabricator/Welder (23960, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Fabricator/Welder Overtime (OT) time + 1/2 | ||||||||||||||||||||
| GIS Specialist (30030, O*Net Local Wages 15-1299.02) | ||||||||||||||||||||
| Instrumentation Technician (23180, 23460, O*Net Local Wages 49-9069.00) | ||||||||||||||||||||
| Machinist/CNC Programmer (O*Net Local Wages 51-9162.00) | ||||||||||||||||||||
| Marine Mechanic/Marine HVAC (23410, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Marine Mechanic/Marine HVAC Overtime (OT) time + 1/2 | ||||||||||||||||||||
| Mechanical/Maintenance Technician (23530, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Mechanical/Maintenance Technician Overtime (OT) time + 1/2 | ||||||||||||||||||||
| Ocean Engineer (O*Net Local Wages 17-2141.00) | ||||||||||||||||||||
| Rigger (23850, Wage Determ. 2015-4535) | ||||||||||||||||||||
| Rigger Overtime (OT) time + 1/2 | ||||||||||||||||||||
| Total Labor | ||||||||||||||||||||
| Total Labor | - 0 | |||||||||||||||||||
| Labor OH | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| Other Rates** | ||||||||||||||||||||
| Overhead | ||||||||||||||||||||
| * | ||||||||||||||||||||
| * | ||||||||||||||||||||
| Total Labor & Overhead Rate | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| FCCM | ||||||||||||||||||||
| SUBTOTAL COSTS ($) | ||||||||||||||||||||
| FIXED FEE | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| SubContractor Fee for Labor | ||||||||||||||||||||
| Total CPFF all CLINs (Labor and ODCs) |
sub 2
| COST TABLE | ||||||||||||||||||||
| Cost Summary | ||||||||||||||||||||
| Major Cost Element | Gov or Contractor Site | FY23 | FY24 | FY25 | FY26 | FY27 | FY28 | Total $ | ||||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | |||
| OTHER DIRECT COST | ||||||||||||||||||||
| ODC | ||||||||||||||||||||
| TRAVEL | ||||||||||||||||||||
| Material Handling | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Total ODC | ||||||||||||||||||||
| Labor | ||||||||||||||||||||
| Program Manager | ||||||||||||||||||||
| Senior Technical Support Specialist | ||||||||||||||||||||
| Financial Analyst | ||||||||||||||||||||
| Database Developer | ||||||||||||||||||||
| Technical Writer | ||||||||||||||||||||
| Senior System Enginner | ||||||||||||||||||||
| Senior Technical Support Specialist | ||||||||||||||||||||
| Junior Engineer | ||||||||||||||||||||
| Engineer II | ||||||||||||||||||||
| Engineer III | ||||||||||||||||||||
| Senior Principal Engineer | ||||||||||||||||||||
| Senior Data Analyst | ||||||||||||||||||||
| Technician | ||||||||||||||||||||
| Senior Technician | ||||||||||||||||||||
| Management Analyst | ||||||||||||||||||||
| Senior Management Analyst | ||||||||||||||||||||
| Financial Analyst | ||||||||||||||||||||
| Software Developer | ||||||||||||||||||||
| Systems Administrator | ||||||||||||||||||||
| Senior Systems Administrator | ||||||||||||||||||||
| Database Developer | ||||||||||||||||||||
| Total Labor | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| Total Labor | - 0 | |||||||||||||||||||
| Labor OH | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| Other Rates** | ||||||||||||||||||||
| Overhead | ||||||||||||||||||||
| * | ||||||||||||||||||||
| * | ||||||||||||||||||||
| Total Labor & Overhead Rate | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| FCCM | ||||||||||||||||||||
| SUBTOTAL COSTS ($) | ||||||||||||||||||||
| FIXED FEE | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | Base | % | $ | ||
| SubContractor Fee for Labor | ||||||||||||||||||||
| Total CPFF all CLINs (Labor and ODCs) |
File details come from the government source that posted it. Updated .