A.07.23 Section J - Attachment 12 ERS Tables_9MAR2021.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- W912DW21R0022
About this file
This document includes a solicitation for multiple task order contracts to provide environmental remediation services to the U.S. Army Corps of Engineers Seattle District. Services sought include full environmental remediation and restoration, site characterization and assessment, incidental construction, hazardous and toxic waste remediation and disposal. Projects will focus on PFAS site investigations, remedial investigations and actions. Work will support Defense Environmental Restoration Program, Superfund, environmental compliance, Brownfields, Formerly Utilized Sites Remedial Action Program, Base Realignment and Closure Program, and other environmental cleanup activities for military installations, civil works projects, and other federal agencies under the Installation Restoration Program. The solicitation is a 100% small business set-aside for 8(a) firms under NAICS code 562910.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| A.07.23 W912DW21R0022 R0002 (04-19-2021).pdf | ||
| A.07.23 W912DW21R0022 R0001.pdf | ||
| A.07.23 W912DW21R0022 (03-15-2021) FINAL.pdf |
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
Table 1 Labor Rate Schedule
| Table 1 BINDING CAPPED LABOR RATE SCHEDULE, Firm Fixed Price Task Orders |
| Instructions: Fill in the yellow cells. For calculated values, leave equations viewable. Reference Section B, Paragraph 6 Pricing and Section L Instructions to Offerors. Note: This worksheet is protected to prevent inadvertent changes to the text and format. A password is not required to unprotect the sheet. |
| DISCIPLINE | PRIME OR SUB | Base Period Year 1 | |
| UNBURDENED LABOR RATES | Base Period Year 1 | ||
| BURDENED LABOR RATE | Base Period Year 2 | ||
| BURDENED LABOR RATE | Base Period Year 3 | ||
| BURDENED LABOR RATE | Option Period / Year 4 | ||
| BURDENED LABOR RATE | Option Period / Year 5 | ||
| BURDENED LABOR RATE | Six-month extension |
BURDENED LABOR RATE
| 0001 - Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0002 - Project Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0003 - On-Site Contractor Quality Control Supv (CQCS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0004 - On-Site Superintendent/ Site Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0005 - Safety & Health Manager (SHM)/Certified Industrial Hygienist (CIH) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0006 - Site Safety and Health Officer (SSHO) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0007 - Senior Contracts Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0008 - Procurement Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0009 - Cost Estimator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0010 – Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0011 - Mechanical/ Electrical Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0012 - Process Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0013 – Geophysicist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0014 - Risk Assessor/ Toxicologist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0015 – Geologist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0016 - Scientist/ Biologist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0017 – Chemist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0018 - Hazardous Waste Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0019 - Regulatory Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0020 - CADD Operator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0021 - GIS Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0022 - Engineering Technician | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0023 - Field Technician | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0024 – Clerical | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Table 2 Rates-Markups
| Table 2 Rates / Markups |
| Instructions: Fill in the yellow cells. For calculated values, leave equations viewable. Reference Section B, Paragraph 6 Pricing and Section L Instructions to Offerors. Note: This worksheet is not locked. Offerors may edit the table to add other indirect applied rates, if applicable, per Section B and Section L. |
| Base Contract | |||||||
| Year 1 | Base Contract | ||||||
| Year 2 | Base Contract Year 3 | Option Period 1 (Year 4) | Option Period 1 (Year 5) | Option Period 2 (Six-month extension) | |||
| Overhead Rate* | 0.00% | ||||||
| G&A Rate* | 0.00% | ||||||
| If Applicable: Other Indirect Applied Rates | 0.00% | ||||||
| Binding Capped Burdened Labor Rate Annual Escalation | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| *Must be substantiated by DCAA at a later time |
Table 3 Profit & Fee
| Table 3 Maximum Profit and Fee Rates |
| Instructions: Fill in the yellow cells. For calculated values, leave equations viewable. Reference Section B, Paragraph 6 Pricing and Section L Instructions to Offerors. Note: This worksheet is protected to prevent inadvertent changes to the text and format. A password is not required to unprotect the sheet. |
| Maximum Fixed Fee Rate (Cost Reimbursable Work) | Maximum Profit Rate (Firm Fixed Price Work) |
| 0.00% | 0.00% |
Cost Spreadsheet
| Cost Spreadsheet |
| Instructions: Fill in the yellow cells. For calculated values, leave equations viewable. Reference Section L Instructions to Offerors. Note: This worksheet is protected to prevent inadvertent changes to the text and format. A password is not required to unprotect the sheet. |
| Unburdened Labor Rate | Burdened Binding Capped Labor Rate - Base Period Year 1 | Units | Quantity (plugged number) | Subtotal | |
| A. Home Office Personnel | |||||
| 0001 - Program Manager | $ - 0 | $ - 0 | Hrs. | 60 | $ - 0 |
| 0002 - Project Manager | $ - 0 | $ - 0 | Hrs. | 240 | $ - 0 |
| 0008 - Procurement Specialist | $ - 0 | $ - 0 | Hrs. | 80 | $ - 0 |
| 0005 - Safety & Health Manager (SHM)/Certified Industrial Hygienist (CIH) | $ - 0 | $ - 0 | Hrs. | 80 | $ - 0 |
| 0014 - Risk Assessor/ Toxicologist | $ - 0 | $ - 0 | Hrs. | 80 | $ - 0 |
| 0024 – Clerical | $ - 0 | $ - 0 | Hrs. | 80 | $ - 0 |
| Total Section A - Home Office Personnel | $ - 0 | ||||
| B. Field Office Personnel | |||||
| 0016 - Scientist/ Biologist | $ - 0 | $ - 0 | Hrs. | 140 | $ - 0 |
| 0010 – Engineer | $ - 0 | $ - 0 | Hrs. | 160 | $ - 0 |
| 0017 – Chemist | $ - 0 | $ - 0 | Hrs. | 140 | $ - 0 |
| 0006 - Site Safety and Health Officer (SSHO) | $ - 0 | $ - 0 | Hrs. | 160 | $ - 0 |
| 0015 – Geologist | $ - 0 | $ - 0 | Hrs. | 160 | $ - 0 |
| 0019 - Regulatory Specialist | $ - 0 | $ - 0 | Hrs. | 160 | $ - 0 |
| 0018 - Hazardous Waste Specialist | $ - 0 | $ - 0 | Hrs. | 160 | $ - 0 |
| Total Section B - Field Office Personnel | $ - 0 | ||||
| C. Other Direct Costs | |||||
| Materials, supplies, equipment, and other ODCs (plugged number) | LS | 1.00 | $ 10,000.00 | ||
| Markup Rate (Base Period Year 1) | % | ||||
| Markup Amount (Base Period Year 1) | $ - 0 | ||||
| Subtotal materials, supplies, equipment, and other ODCs | $ - 0 | ||||
| Subcontractor Effort (plugged number) | LS | 1.00 | $ 100,000.00 | ||
| Markup Rate (Base Period Year 1) | % | ||||
| Markup Amount (Base Period Year 1) | $ - 0 | ||||
| Subtotal subcontractor effort | $ - 0 | ||||
| Total Section C | $ - 0 | ||||
| Total Estimated Cost | |||||
| Total Estimated Cost (A+B+C) | $ - 0 | ||||
| Fixed Fee | |||||
| Fixed Fee Rate | % | ||||
| Fixed Fee Amount | $ - 0 | ||||
| Total Estimated Cost Plus Fixed Fee | $ - 0 |
Note: The labor rates used in the Cost Spreadsheet should match the respective Binding Capped Labor Rates proposed in Volume II, Factor 3, Table 1. The overhead, G&A and other indirect costs should match the rates proposed in Volume II, Factor 3, Table 2. The fixed fee should match the maximum fixed fee rate proposed in Volume II, Factor 3, Table 3.
File details come from the government source that posted it. Updated .