A.07.23 Section J - Attachment 12 ERS Tables_9MAR2021.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
Northwestern Division Regional $115M Section 8(a) SB Set-Aside IDIQ MATOC for Environmental Remediation Services (ERS)
Solicitation number
W912DW21R0022
Issued by

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

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.
DISCIPLINEPRIME OR SUBBase Period Year 1
UNBURDENED LABOR RATESBase Period Year 1
BURDENED LABOR RATEBase Period Year 2
BURDENED LABOR RATEBase Period Year 3
BURDENED LABOR RATEOption Period / Year 4
BURDENED LABOR RATEOption Period / Year 5
BURDENED LABOR RATESix-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 1Base Contract
Year 2Base Contract Year 3Option 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 Rates0.00%
Binding Capped Burdened Labor Rate Annual Escalation0.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 RateBurdened Binding Capped Labor Rate - Base Period Year 1UnitsQuantity (plugged number)Subtotal
A. Home Office Personnel
0001 - Program Manager$ - 0$ - 0Hrs.60$ - 0
0002 - Project Manager$ - 0$ - 0Hrs.240$ - 0
0008 - Procurement Specialist$ - 0$ - 0Hrs.80$ - 0
0005 - Safety & Health Manager (SHM)/Certified Industrial Hygienist (CIH)$ - 0$ - 0Hrs.80$ - 0
0014 - Risk Assessor/ Toxicologist$ - 0$ - 0Hrs.80$ - 0
0024 – Clerical$ - 0$ - 0Hrs.80$ - 0
Total Section A - Home Office Personnel$ - 0
B. Field Office Personnel
0016 - Scientist/ Biologist$ - 0$ - 0Hrs.140$ - 0
0010 – Engineer$ - 0$ - 0Hrs.160$ - 0
0017 – Chemist$ - 0$ - 0Hrs.140$ - 0
0006 - Site Safety and Health Officer (SSHO)$ - 0$ - 0Hrs.160$ - 0
0015 – Geologist$ - 0$ - 0Hrs.160$ - 0
0019 - Regulatory Specialist$ - 0$ - 0Hrs.160$ - 0
0018 - Hazardous Waste Specialist$ - 0$ - 0Hrs.160$ - 0
Total Section B - Field Office Personnel$ - 0
C. Other Direct Costs
Materials, supplies, equipment, and other ODCs (plugged number)LS1.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)LS1.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 .