Appendix A_DO-0019_DLA DM-ER_Monthly Progress Report_May 2021.docx

DOCX document 100 KB Posted

Attached to
DLA Installation Management, Environmental Management, Environmental Liabilities Management Program Support Federal contract opportunity
Solicitation number
W912DR22R0011
Issued by
Department of the Army Corps of Engineers Engineering District Baltimore

About this file

This solicitation is for a firm-fixed-price services contract to provide program management and environmental liabilities management support to the Defense Logistics Agency Installation Management Environmental Management division. The U.S. Army Corps of Engineers, Baltimore District has issued the solicitation on behalf of DLA to assist in executing environmental programs, satisfying DoD reporting requirements, and ensuring auditable financial statements. The contractor will support planning, programming, budgeting, and execution processes to integrate financial reporting and address audit findings. The acquisition is a full and open competition set aside for small businesses, with a NAICS code of 561990. Proposals are due in accordance with the solicitation and any amendments. The contractor must register in SAM and representations and certifications applications to be eligible for award.

View the file

Other files for this federal contract opportunity

Other files attached to DLA Installation Management, Environmental Management, Environmental Liabilities Management Program Support, newest first.
File Type Posted
Appendix D_1115_FY21 Site ID Annual Determination Report_DWCF_sign_PDF.pdf PDF
Appendix D_FY21 Site ID_Data Gathering and Annual Report QAQC Checklist_....pdf PDF
ASCA Training Completion Certificate.pdf PDF
Appendix B_Env Event Repository.pdf PDF
W912DR22R0011 Solicitation Amendment 0001.pdf PDF
FY22_PCM_43_ELM_01182022.pdf PDF
Appendix C_Site ID Monthly Report_June 2021.pdf PDF
Appendix B_Env Event Repository Input.pdf PDF
Price Schedule.xlsx XLSX spreadsheet
Proposal TEMPLATE.xlsx XLSX spreadsheet
W912DR22R0011 Solicitation.pdf PDF
Show all 11

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

MONTHLY PROGRESS REPORT

MAY 2021

Defense Logistics Agency (DLA) Headquarters-Fort Belvoir DLA Installation Management Environmental Management and Annual Cost-to-Complete (CTC) Restoration Team Program Support

CLӔNE Group LLC Contract Number: W912DR-17-C-0019 (Option 4) Period of Performance: April 1, 2021 through March 31, 2022

Prime A/E: CLӔNE Group
Contact: Christopher Weesner
Contract: USACE, Baltimore
Contact: Stephen Wood
Installation: Defense Logistics Agency, DM-ER
Contact: Kevin Kivimaki

Accomplishments during the Period:

Task 1: Current-Year Requirements and Environmental Cost Estimates Analysis (16.67% complete)

· Task 1.1: Program Management:

0. Managed and tracked overall schedule and progress toward milestones for all Task 1 activities and deliverables

0. Participated in the weekly status meeting with DLA Installation Management, Environmental Management Restoration Division (DM-ER) to discuss the status for Task 1 activities and deliverables as well as any issues, proposed solutions, and paths forward

· Task 1.2: Current-Year Funding Requirements and Environmental Cost Estimates Analysis:

· Continued to assist with coordination with DLA Financial Operations (J86) and the Assistant Secretary of Defense for Energy, Installations, and Environment (ASD EI&E) to ensure timely execution of the initial round of Fiscal Year 2021 (FY21) Defense Environmental Restoration Account (DERA) Funds totaling $7.664 million

· Prepared and submitted an FY21 DERA Direct Citation (Category 2) Military Interdepartmental Purchase Requests (MIPR) and a Determinations and Findings (D&F) memo required by DLA Acquisition (J7) sending funds to the Air Force Civil Engineering Center (AFCEC) for annual contract requirements at DLA Installation Management (DM) San Joaquin

· Participated in the FY22 CTC Data Gathering for DM Richmond to provide input on anticipated FY21 funding requirements that assist with accuracy of out-year cost estimating

· Updated the FY21 DERA Funding Requirements and CTC comparative analysis for DM Richmond based on discussion of current and out-year requirements during the FY22 CTC Data Gathering

· Coordinated with DLA Energy Restoration Division Chief and Program Manager (PM) on remaining FY21 Per- and polyfluoroalkyl substances (PFAS) requirements at Defense Fuel Support Point (DFSP) San Pedro and Ozol based on projected remaining FY21 DERA funds

· Processed the awarded contract for DM San Joaquin requirements associated with the FY21 DERA Category 2 MIPR obligating funds in DLA’s Enterprise Business System (EBS)

· Began creating the FY20 Execution audit file for inclusion in the FY20 Environmental Liabilities Management (ELM) audit file

· Prepared and submitted an FY21 DERA Funding Document Request (FDR) sending funds to the United States(U.S.) Army Corps of Engineers (USACE) Baltimore District for DM Susquehanna Lease Agreements and associated USACE Real Estate Division fee

· Updated the FY21 DERA Execution Summary as a result of current fiscal year funding execution activities

· Prepared and submitted an FY21 DERA FDR sending funds to the USACE Baltimore District for Curtis Bay PBA21 Post Award

· Prepared and submitted an FY21 Base Realignment and Closure (BRAC) FDR amendment sending funds to DM Philadelphia for remaining Vapor Barrier installations

· Coordinated with USACE Baltimore to ensure the accuracy of the Supervisory and Review (S&R) estimate that is used to determine the Service Center Fee to apply to out-year requirements in the FY22 CTC

· Participated in a discussion on May 27th with the DM Philadelphia PM to review the current version of the FY21 BRAC Philadelphia Funding Requirements to determine path forward and schedule for funding remaining requirements and items that require further coordination with USACE Philadelphia prior to sending funds

· Updated the FY21 DERA Funding Requests for DM San Joaquin, Curtis Bay, Defense and State Memorandum of Agreement (DSMOA), DM Columbus, DM Pacific, DM Susquehanna, and DM Richmond

· Updated the FY21 BRAC DM Philadelphia Request based on discussions and requested updates from the PM

· Updated the FY21 DERA and BRAC Execution Summaries as a result of current fiscal year funding execution activities

· Updated the FY21 DERA and BRAC Consolidated Requirements Workbooks as a result of current fiscal year funding execution activities

· Task 1.3: Requirements Justification and Program Objective Memorandum (POM) Submission Preparation:

· Prepared and submitted final and updated versions of the FY22 President’s Budget (PB22) BRAC J-Book Budget exhibits and narrative that provides detail and justification for the need for out-year BRAC funding as prior year unobligated funds are anticipated to be used during FY22

· Updated and re-submitted two versions of the DLA ENV30 PB22 submission to the Office of the Secretary of Defense (OSD) Select Native and Programming (SNaP) database input system that put forward the FY20 actual obligations, anticipated current year (FY21) requirements, Future Year Defense Plan (FYDP) (FY22-FY26), and balance to complete requirements to the OSD Cost Assessment and Program Evaluation (CAPE) Office

· Assisted the DM-ER Chief with updating the PB22 PFAS Exhibit detailing prior year, anticipated current year, and FY22 planned obligations for DERA funded PFAS sites

· Provided a response to the ASD EI&E providing a change reason for the difference between the FY21 and FY20 CTC for the Former Defense Supply Center Philadelphia for input to the Defense Environmental Programs Annual Report to Congress (DEP ARC)

· Updated and re-submitted three data transmission templates for DLA DERA (Installation Restoration Program [IRP] and Military Munitions Response Program [MMRP]) and BRAC that make up the Cleanup Module PB22 Backup Data to Knowledge Based Corporate Reporting System (KBCRS) that puts forth the FY20 actual obligations, anticipated current year (FY21) requirements, FYDP (FY22-FY26) requirements, and balance to complete requirements to the ASD EI&E

· Updated and re-submitted the FY20 KBCRS Installation and Site Data Submission based on changes to the PB22 KBCRS and SNaP Submissions

· Populated the draft DLA Net CTC Calculation Slides based on the KBCRS PB22 data submission that detail high level funding requirements to include Active IRP, MMRP IRP, and BRAC IRP

· Coordinate with DLA Energy Environmental and Strategic Material Environmental personnel to assist with the development of the Government Manpower Memorandums for Record (MFRs) that are utilized in the FY22 CTC Program Management Costs

· Task 1.4: Prior Year Unliquidated Obligation (ULO) Reconciliation Efforts & Collecting/Analyzing Data:

· Continued to research and review the DERA and BRAC ULO and Negative Payables in EBS to determine current status, follow-on actions, and coordination that is required with the appropriate Service Centers

· Processed an FY18 DERA MIPR Acceptance (DD 448-2) returning excess funds for USACE Fort Worth fees related to a DM San Joaquin contract

· Prepared and submitted the FY21 BRAC Negative Payable Report to USACE Philadelphia requesting Voucher for Transfers Between Appropriations or Funds (DD 4445-R) to reconcile negative payables in EBS

· Began reconciliation efforts for the Dormant Account Review Quarterly (DAR-Q) due to J86 on June 15th

· Began preparing the FY21 Accounts Payable Action Report issued by J86 in conjunction with the Negative Payable Report

· Began preparing the Monthly DLA Finance (J8) ULO Report as of the end of April for the EBS BRAC Fund Center (70002T1 & 70002T2)

· Prepared and submitted the FY21 DERA Negative Payable Report to DM Richmond requesting DD 4445-R to reconcile negative payables in EBS

· Prepared and submitted the FY21 DERA Negative Payable Report USACE Alaska requesting DD 4445-R to reconcile negative payables in EBS

· Prepared and submitted the Monthly J7 ULO Report as of the end of April for the EBS DERA Fund Center (7000218)

· Submitted three DD 4445-R to the DM Business Management Office (BMO) for final reconciliation of FY16 MIPRs identified to expire at the end of the current fiscal year

· Task 1.5: HQ DLA Environmental Liabilities (EL) Reporting:

· Continued to assist DM-E with requests for information and review of documentation as required by the FY21 audit of DLA's financial statements and the reporting of EL

· Reviewed the Provide by Client (PBC) coversheet and supporting documentation for EL-021 prior to submittal to the DLA Response Center (RC) Tool

· Coordinated with J7 and the DM-E Deputy Staff Director to provide input on the status of the Transaction Fund (TF) EL Beginning Balance Package and the FY21 Audit of EL for the Collaborative Joint Audit Remediation (CJAR) slides

· Participated in TF Beginning Balance meetings on May 5th, 6th, 12th, and 19th to discuss the status of Beginning Balance packages, compliance with applicable Financial Accounting Standards, departure from U.S. Generally Accepted Accounting Principles (GAAP) statements on the Annual Financial Report (AFR), and related follow-up PBCs

· Assisted with the preparation of MFRs detailing TF EL Compliance with Federal Accounting Standards Advisory Board (FASAB) Interpretation 9 and addressing the EL departure from U.S. GAAP statement on the FY20 DLA AFR as well as the PBC Coversheet in response to PBC GEN-143

· Coordinated with DLA Financial Reporting (J85) and DLA Installation Management, Process Management (DM-A) to submit the EL related PBC GEN-143 Response Coversheet and supporting documentation to the Response Center (RC) Tool

· Reviewed the PBC EL-022 and EL-023 mapping, documentation, and PBC Coversheet prior to submittal to the RC Tool

· Reviewed the FY20 TF Estimates to Actuals (E2A) Analysis Workbook and Process Results Document

· Reviewed the PBC EL-022 and EL-023 mapping, documentation, and PBC Coversheet prior to submittal to the RC Tool

· Participated in a meeting with the DM-ER Chief and team to discuss the draft DLA Financial Reporting Standard Operating Procedure (SOP)

· Reviewed and updated the MFR detailing the DM-E response addressing the EL departure from U.S. GAAP statement on the FY20 DLA AFR in response to PBC GEN-147

· Reviewed the PBC EL-027 documentation and PBC Coversheet prior to submittal to the RC Tool

· Reviewed and updated the FY16-FY19 E2A Analysis Workbooks to ensure accuracy and completeness for inclusion in the final DLA General Fund (GF) E2A Lookback Analysis package to be submitted to DM-ER

· Updated the GF E2A Historical Trends Workbook with FY16-18 data to include total assets, total liabilities, and Environmental and Disposal Liabilities (E&DL) balances from the AFR for inclusion in the final DLA GF E2A Lookback Analysis Package

· Reviewed and updated the GF E2A Lookback Analysis Package prior to submittal to DM-ER

· Task 1.6: Miscellaneous Support:

1. No Activity

Task 2: Annual CTC Current Year Requirements (16.67% complete)

· Task 2.1: CTC Program Management:

1. Managed and coordinated Task 2 activities to achieve ELM timeline goals for completion of process steps and delivery of key documents

1. Participated in weekly meetings with DM-ER to discuss the status for Task 2 activities and deliverables as well as any issues, proposed solutions, and paths forward

1. Participated in the biweekly Energy CTC Status Calls with Mr. William Potter and Mr. Muhammad Irfan

· Task 2.2: CTC Training & Standard Operating Procedures (SOPs) Updates:

· Continued preparing draft slides for the consolidated ELM training currently being developed to replace the existing Learning Management System (LMS) Site ID and CTC trainings

· Task 2.3: CTC Data Gathering and Environmental Cost Estimating:

· Continued receiving and reviewing data needs provided by the PMs

· Continued preparing FY22 CTC Draft Assumptions and Requirements Documents (ARDs) for sites with data gathering completed

· Submitted the Agenda and conducted the DM Richmond Data Gathering Meeting on May 5th

· Conducted the Disposition Services Data Gathering Meeting for Fort Polk on May 6th

· Conducted a current year funding review with DM Energy PM, Mr. Steve Deatherage, on May 13th for Energy sites he manages

· Conducted follow-up CTC data gathering for TF with Mr. Joseph Kitko and Ms. Theresa Leland (Strategic Materials) on Defense National Stockpile Center (DNSC) Somerville via teleconference and email on May 21st

· Submitted Draft Data Gathering Memos, Draft ARDs, and Record of PM Approval documents to PMs for the following sites:

· Mr. Robert Johnson, DM Energy (Europe)

· RAF Mildenhall NSBF

· RAF Mildenhall PSI4

· RAF Lakenheath POL 7

· Thule AB Facility 558

· Ms. Carol Devier-Heeney, DM Energy

· DFSP San Pedro Admin Area

· DFSP San Pedro South Control Area

· DFSP San Pedro Tank Farm Area

· Mr. William Potter, DM Energy

· DFSP Ozol

· Ms. Lisa McWhirter, Cutis Bay Depot

· IRP Sites

· MMRP Sites

· Mr. Robert Scalamera, DM Columbus

· SSI Sites

· Mr. Cameron Schuemann, Disposition Services

· Fort Polk Bldg 4050 DRMO Closure

· Received approval from the PMs to begin estimating the requirements in the Draft ARDs for the following sites:

· Mr. William Potter, DM Energy

· DFSP Ozol

· Mr. Cameron Schuemann, Disposition Services

· Yellow Water Road

· Mr. Robert Johnson, DM Europe

· RAF Mildenhall NSBF

· RAF Mildenhall PSI4

· RAF Lakenheath POL 7

· Thule AB Facility 558

· Ms. Carol Devier-Heeney, DM Energy

· San Pedro Admin Area

· San Pedro South Control Area

· San Pedro Tank Farm

· Continued creating and reviewing estimates for Draft ARDs approved by the PM

· Submitted Draft Final Data Gathering Memo and Draft Final ARD documents to PMs for the following sites:

· Ms. Therese Deardorff, DM Energy

· Eielson AFB Take Off Pad

· Eielson AFB Tanker Row

· Whittier Fuel Terminal

· Fort Wainwright, Building 3484

· Indian Booster Station

· Ms. Amanda Mano’i, DM Energy

· Hickam AFB Stripper Pit

· Hickam AFB Valve Pit

· Hickam AFB Challenger Loop

· Red Hill

· Ms. Therese Deardorff, DM Pacific

· Arctic Surplus

· Ms. Jeanne Meadows, DM Energy

· McEntire, Product Recovery Tank

· Seymour Johnson KC-135

· Ms. Carol Devier-Heeney, DM Energy

· Norwalk Terminal

· DFSP San Pedro Admin Area

· DFSP San Pedro South Control Area

· DFSP San Pedro Tank Farm Area

· Tustin El Toro Pipeline Spill

· Mr. William Potter, DM Energy

· MCAS Camp Pendleton Product Recovery Tank

· DFSP Ozol

· Mr. Robert Johnson, DM Energy

· RAF Lakenheath, POL 7

· Thule AB, Facility 558

· RAF Mildenhall, NSBFI

· RAF Mildenhall PSI 4

· Received comments from the PM on the Draft Final Data Gathering Memos, Draft Final ARDs for the following sites:

· Ms. Therese Deardorff, DM Energy

· Whittier Fuel Terminal

· Fort Wainwright, Building 3484

· Ms. Carol Devier-Heeney, DM Energy

· Norwalk Terminal

· Received approval from the PMs on the Draft Final Data Gathering Memos, Draft Final ARDs for the following sites:

· Ms. Therese Deardorff, DM Energy

· Eielson AFB Take Off Pad

· Eielson AFB Tanker Row

· Ms. Amanda Mano’i, DM Energy

· Hickam AFB Stripper Pit

· Hickam AFB Valve Pit

· Hickam AFB Challenger Loop

· Red Hill

· Ms. Jeanne Meadows, DM Energy

· McEntire, Product Recovery Tank

· Seymour Johnson KC 135

· Ms. Therese Deardorff, DM Pacific

· Arctic Surplus

· Mr. William Potter, DM Energy

· MCAS Camp Pendleton Product Recovery Tank

· DFSP Ozol

· Submitted Final Data Gathering Memo and Final ARD documents to PM for the following site:

· Ms. Therese Deardorff, DM Energy

· Whittier Fuel Terminal

· Fort Wainwright, Building 3484

· Ms. Carol Devier-Heeney, DM Energy

· Norwalk Terminal

· Received approval from the PM on the Final Data Gathering Memo, Final ARD for the following site:

· Ms. Carol Devier-Heeney, DM Energy

· Norwalk Terminal

· Ms. Therese Deardorff, DM Energy

· Fort Wainwright, Building 3484

· Whittier Fuel Terminal

· Task 2.4: CTC Reporting:

· Compiled the Energy Fund-Level Roll-Up via the FY22 CTC Macro and began performing Quality Assurance/Quality Control (QA/QC) checks

· Finalized and submitted PM-Level Roll-Ups to the follow Energy PMs for use in the budget submission:

· Ms. Therese Deardorff

· Mr. Steve Deatherage

· Ms. Carol Devier-Heeney

· Mr. Robert Johnson

· Ms. Amanda Mano’i

· Ms. Jeanne Meadows

· Mr. William Potter

· Task 2.5: Site Identification (ID) Process Support:

· Compiled fund-level excerpts of events to be excluded from 4th quarter Site ID data gathering per their 2nd quarter determination

· Finalized FY21 Site ID 2nd QA/QC and checklists

· Task 2.6: EL Audit Support:

· Assisted with gathering and reviewing documentation, and preparation of response and mapping spreadsheet for PBCs EL-022 through EL-028

· Prepared and uploaded response coversheet for GEN-147 (EL portion)

· Task 2.7: RPM, OSD and E2DMS Support:

· Restoration Program Management (RPM) Support

· Participated in the Tracy monthly RPM meeting

· OSD Support

· No activity

· E2DMS

· No activity

· Task 2.8: RACER Support:

· As-Built Model Addenda

· Participated in a call with AECOM to discuss open comments on and completed final back-check of Group 3 As-Built RACER Addenda

· Other RACER Support

· Participated in the RACER Draft Database Update Report conference call and requested that AECOM identify changes to ACFs from the Draft report

· Participated in the RACER MSR call

· Participated in a RACER TRG Nascent Defect call and recommended that two bugs be reclassified to deferred

· RACER 11.7

· Participated in the RACER 11.7 Alpha call

· Downloaded the software test scripts and supporting documentation

· Participated in the Alpha to Beta call for RACER 11.7

· Downloaded latest version of the RACER 11.6 patch and began checking responses to comments

· Back-checked RACER 11.6 patch comments

· EII Support

· No activity

· Cost Book

· Participated in the biweekly HTW meeting

Task 3: EL Audit and Sustainment Support (16.67% complete) Audit Readiness

· Reviewed the daily DLA PBC List received from the DLA Audit Readiness and Sustainment (ARS) Team to ensure receipt of any new ELM PBCs, MEET, and SITE requests as well as track the status of PBCs submitted to ensure timely coordination with DM-A and the ARS Team as well as final release to the DLA Independent Public Accountant (IPA)

· Participated in biweekly status calls with Ernst and Young (EY) for ELM MEET-10

· Prepared PBC response coversheet and documentation for PBC EL-021 and uploaded to the RC Tool on May 3rd

· Participated in meeting on May 5th to discuss the TF Beginning Balance packages and all applicable Financial Accounting Standards

· Developed PBC Coversheets and mapping spreadsheets and gathered documentation in response to PBCs EL-022 and EL-023, and uploaded PBC Coversheets and mapping spreadsheets to the RC Tool on May 7th

· Participated in a meeting on May 7th between DM-E and DM-A to discuss the status of EL Notice of Findings and Recommendations (NFRs) Plan of Action and Milestones (POAM) and the dependency of the EL Reporting process on J8 policies and procedures that are currently under development and not yet published

· Participated in Risk Management Internal Control Program (RMIC) Discussion with DM-ER on May 11th

· Prepared coversheets and document mapping spreadsheet for EL-024, EL-025, and EL-026 (PM Cost Samples), and submitted via the RC Tool on May 12th

· Participated in Departures from GAAP Overview on May 12th with the ATF

· Participated in call with J8 on May 14th to discuss U.S. GAAP Departures in TF AFR and response to ELM portion of GEN-147

· Uploaded E&DL response to PBC GEN-147 and response coversheet to the RC Tool on May 17th

· Gathered and prepared documents for ELM PBC EL-027 and submitted to the DLA RC Tool on May 18th

· Participated in RMIC Discussion with DM-ER on May 19th to capture DM-ER comments on the Risk Assessment, and revised and resubmitted to DM-ER following the meeting

· Gathered and prepared documents for ELM PBC EL-028 and submitted to the DLA RC Tool on May 27th

· Participated in TF Beginning Balance meeting on May 27th to discuss the status of recent PBCs GEN-143/147, compliance with applicable Financial Accounting Standards, departure from U.S. GAAP statements on the Annual Financial Report, and follow up meetings requested by the DLA IPA to discuss questions related to beginning balance packages and related documentation

· Developed an MFR detailing DLA’s E&DL balance compliance with FASAB Interpretation 9 submitted in response to the EL portion of PBC GEN-143

· Developed an MFR addressing the statement of DLA’s E&DL departure from U.S. GAAP on the FY20 AFR in response to the EL portion of PBC GEN-143

· Prepared the PBC Response Coversheet for the EL portion of PBC GEN-143 and submitted to the RC Tool along with the final signed MFRs

· Prepared responses to questions from the ATF on MFR addressing EL portion of GEN-143 (Departure from U.S. GAAP)

· Developed an expanded MFR detailing the DM-E response addressing the EL departure from U.S. GAAP statement on the FY20 DLA AFR in response to PBC GEN-147

· Populated the revised Template for Risk Assessment for the RMIC program for ELM and provided to DM-ER for review

· Participated in call with DM-ER to discuss comments on J8 SOP 7710.11-001

· Prepared the FY20 TF E2A Analysis Workbook and Process Results Document and submitted to DM-E

· Developed the GF E2A Historical Trends Workbook with FY16-FY20 data for inclusion in the final DLA GF E2A Lookback Analysis Package

· Developed and submitted the GF E2A Lookback Analysis Package and provided to DM-ER for use in Corrective Action Plan (CAP) POAM Milestone for NFRs GF-110/TF-099/WCF-225

· Prepared and provided responses to question list received from EY on May 24th regarding follow-up on TF FY21 CTC estimates

Planned Activities for June:

Task 1: Current-Year Requirements and Environmental Cost Estimates Analysis

1. Task 1.1: Program Management:

5. Manage and track overall schedule and progress toward milestones for all Task 1 activities and deliverables

5. Participate in the weekly status meeting with DM-ER to discuss the status for Task 1 activities and deliverables as well as any issues, proposed solutions, and path forward

1. Task 1.2: Current-Year Funding Requirements and Environmental Cost Estimates Analysis:

5. Continue updating the DLA FY21 DERA and BRAC IRP Funding Requests for DLA Installation Management as they are updated by Installation Restoration PMs and current year funds are executed

5. Continue to update the DERA and BRAC FY21 monthly Execution Summaries and Consolidated Funding Requirements Workbooks based on current year funds execution activity

5. Continue to coordinate with J86 and ASD EI&E to provide updates on the status of the execution of FY21 DERA Funds

5. Assist DM-ER as necessary with processing FY21 FDRs and MIPRs for DERA and BRAC funding requirements

5. Continue to coordinate with the Philadelphia PM as well as the USACE Philadelphia District contract specialist and PM to update and revise the FY21 BRAC Philadelphia funding requirements and impacts to out-year costs

5. Coordinate with DLA Energy Restoration Division Chief and PMs to determine remaining FY21 DERA PFAS requirements to be funded

5. Coordinate with USACE Baltimore to fund remaining Curtis Bay funding requirements

1. Task 1.3: Requirements Justification and Program Objective Memorandum (POM) Submission Preparation:

2. Update and submit the final DLA Net CTC Calculation Slides based on the KBCRS PB22 data submission that detail high level funding requirements to include Active IRP, MMRP IRP, and BRAC IRP

2. Continue to coordinate with DLA Energy Environmental and Strategic Material Environmental personnel to assist with the development of the Government Manpower MFRs, PM Cost Requests, and other supporting documentation that are utilized in the FY22 CTC Program Management Costs

2. Assist DM-E with the development of the DM-ER POM brief as necessary

Task 1.4: Prior Year Unliquidated Obligations (ULO) Reconciliation Efforts & Collecting/Analyzing Data:

5. Continue to validate and reconcile DERA and BRAC prior year ULOs and de-obligate funds when possible

· Continue to assist with researching and resolving various DERA and BRAC negative payables within EBS as necessary

5. Review and update the May J7 DERA ULO Report

5. Review and update the May J8 BRAC ULO Report

5. Prepare DERA and BRAC ULO Service Center Validation spreadsheets as necessary to assist with the reconciliation of prior FY ULO balances.

5. Assist J8 with the focused reconciliation of FY16 DERA prior year ULOs that will expire at the end of the current fiscal year

5. Continue to assist DM-ER with reconciliation efforts for the DAR-Q due to J86 on June 15th

1. Task 1.5: HQ DLA EL Reporting:

5. Continue to assist DM-ER with responding to PBC requests from DM-A and the DLA ARS Team, as well as any ad hoc tasks and meeting support related to the FY21 IPA audit and the reporting of DLA EL

5. Continue participating in the TF Audit Strategy Working Group meetings as necessary to assist with issues related to the EL reporting process

5. Assist the DM-ER Chief with the development of a Directive Type Memorandum (DTM) that details changes to the ELM EL Reporting SOP due to process changes identified during FY21 2nd Quarter Financial Reporting process

· Begin the coordination of the FY21 3rd Quarter EL Reporting process with J85, DLA HQ Operational Accounting (J81), DLA Enterprise Accounting (J82), and DLA Energy Finance to ensure accuracy and timely delivery of data calls, variance analyses, and standard disclosures.

· Review the J85 FY21 3rd Quarter Financial Reporting timeline to ensure process accuracy and completeness as well as correct timelines and due dates.

· Prepare the FY21 3rd Quarter GF and Defense Working Capital Fund (DWCF) Non-Energy EL Data Call Templates and DM-ER Review Checklists to reflect accurate information for the upcoming quarterly EL reporting process.

· Review the DLA Strategic Materials FY21 3rd Quarter TF EL Data Call Templates to reflect accurate information for the upcoming quarterly EL reporting process.

· Review the DWCF Energy FY21 3rd Quarter TF EL Data Call Templates to reflect accurate information for the upcoming quarterly EL reporting process.

1. Task 1.6: Miscellaneous Support:

5. Participate in DLA Enterprise Environmental Data Management System (E2DMS) requirements bi-weekly discussions between DM-E and ENFOS that focus on incorporating out-year requirements and installation and site environmental data into the system development and implementation currently underway

5. Resume the development of EL Budgeting, Funds Execution, and Reporting content for inclusion in the new DLA ELM Process Training

Task 2: Annual CTC Current Year Requirements

· Task 2.1: CTC Program Management:

· Prepare and provide weekly status update and meetings reports

· Provide and discuss current CTC status with DM-ER during weekly meetings

· Participate in the DLA Energy Biweekly CTC Status calls

· Continue managing and tracking the overall schedule for all Task 2 activities, to include all deliverables and milestones required for completion of all tasks for the FY22 CTC

· Task 2.2: CTC Training and SOPs Updates:

· Continue assisting with the development of a new consolidated ELM Training module and provide a draft to DM-ER for review

· Task 2.3: CTC Data Gathering and Environmental Cost Estimating:

· Continue preparing and submitting FY22 CTC Draft ARDs for sites with data gathering completed

· Continue creating and reviewing estimates for Draft ARDs approved by the PM

· Continue preparing and submitting Draft Final ARDs

· Submit the PFAS site Draft ARDs

· Task 2.4: CTC Reporting:

· Complete and submit the Energy Fund Level Roll Up report for use in the Energy budget submission

· Task 2.5: Site ID Process Support:

· Log events reported to the Environmental Event Inbox into the Environmental Event Repository

· Prepare and deliver the May 2021 Site ID Monthly Report

· Begin planning the schedule for FY21 Site ID 4th Quarter Data Gathering Meetings

· Task 2.6: EL Audit Support:

· Assist with review and response to PBC and meeting requests from EY, as received

· Assist with review and response to questions and requests from DM-A, as received

· Assist with revisions to CAPs prepared to address reissued open ELM NFRs, as required

· Assist with implementation of CAP plan of action and milestones (POAMs)

· Assist with any additional follow up for ELM Audit Walkthroughs

· Task 2.7: RPM, OSD and E2DMS Support:

· Participate in DM San Joaquin at Tracy meetings as needed

· Participate in the biweekly E2DMS Status Calls, as needed

· Review and respond to information requests from ENFOS, as required

· Assist with preparation for and participate in the OSD E&DL Working Group conference call

· Task 2.8: RACER Support:

· Complete reviews of and deliver comments on RACER as-built addenda, as requested

· Review AECOM responses to comments on third as-built addenda set and submit backcheck of AECOM responses to USACE

· Participate in RACER meetings and conduct deliverable reviews, as requested

Task 3: EL Audit and Sustainment Support

· Continue to assist DM-ER with responding to ad hoc requests and tasks from DM-A and the DLA ARS team, as well as meeting support related to the IPA audit and the reporting of DLA ELs, as requested

· Continue to review the daily PBC listings from the DLA IPA to ensure timely audit responses for the FY21 Audit Cycle

· Participate in additional audit support meetings and efforts, as requested

· Finalize the submit the FY20 DWCF E2A Analysis documentation to the DM-ER Division Chief

· Continue to participate in the bi-weekly MEET-010 meetings with EY to clarify questions or content for PBCs and answer questions about the ELM process from previous PBC submittals

Problems, Issues, Concerns:

· None at this time

Manpower Reporting Requirement

· Personnel utilized in the Reporting Period – 9

Deliverables:

Task
Deliverable
Delivered

Task 1

1.2
Updated FY21 DM Richmond CTC/FR Comparison
5/5/2021
1.3
DLA PB22 BRAC J-Book Budget Narrative
5/5/2021
1.3
DLA PB22 BRAC J-Book Budget Workbook
5/5/2021
1.2
Updated FY21 DERA Consolidated Funding Requirements Workbook
5/6/2021
1.2
Updated FY21 DERA Columbus Funding Request
5/11/2021
1.3
Updated PB22 BRAC JBook Submission
5/12/2021
1.3
Updated DLA SNaP PB22 ENV 30 Working Copy Workbook
5/13/2021
1.3
Updated DLA SNaP PB22 ENV 30 Final Workbook
5/13/2021
1.3
Updated DLA SNaP PB22 ENV 30 Narrative
5/13/2021
1.2
Updated FY21 DERA Susquehanna Funding Request
5/13/2021
1.2
Updated FY21 DERA PFAS Funding Request
5/13/2021
1.2
Updated FY21 DERA RACER Fairshare Funding Request
5/13/2021
1.3
DLA Installation CTC Change Reasons Philadelphia
5/13/2021
1.2
Updated FY21 DERA San Joaquin Funding Request
5/14/2021
1.2
Updated FY21 DERA Consolidated Funding Requirements Workbook
5/14/2021
1.3
Updated FY20 KBCRS Installation & Site Data Call
5/18/2021
1.3
Updated KBCRS PB22 CTC CHG Working Copy Leveled
5/18/2021
1.3
Updated KBCRS PB22 Leveled Data Call
5/18/2021
1.3
Updated KBCRS PB22 Final Data Call
5/18/2021
1.3
Updated SNaP PB22 ENV30 Data Call
5/18/2021
1.4
FY21 April Monthly DLA Acquisition (J7) ULO Report
5/19/2021
1.2
Updated FY21 DERA Consolidated Requirements Workbook
5/21/2021
1.5
Updated FY16 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
1.5
Updated FY17 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
1.5
Updated FY18 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
1.5
Updated FY19 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
1.2
Updated FY21 DM San Joaquin Requirements Workbook
5/21/2021
1.2
Updated FY21 DM Curtis Bay Requirements Workbook
5/21/2021
1.2
Updated FY21 DSMOA Requirements Workbook
5/21/2021
1.2
Updated FY21 DM Columbus Requirements Workbook
5/21/2021
1.2
Updated FY21 DM Pacific Requirements Workbook
5/21/2021
1.2
Updated FY21 DM Susquehanna Requirements Workbook
5/21/2021
1.2
Updated FY21 DM Richmond Requirements Workbook
5/21/2021
1.2
Updated FY21 DERA Curtis Bay Funding Request
5/25/2021
1.2
Updated FY21 DERA San Joaquin Funding Request
5/26/2021
1.2
Updated FY21 BRAC Philadelphia Funding Request
5/27/2021
1.2
Updated FY21 DERA Execution Summary
5/28/2021
1.2
Updated FY21 DERA Execution Summary
5/28/2021
1.2
Updated FY21 BRAC Consolidated Funding Requirements Workbook
5/28/2021
1.2
Updated FY21 DERA Consolidated Funding Requirements Workbook
5/28/2021
1.3
Draft DLA Net CTC Slides
5/28/2021

Task 2

2.3
Data Gathering Agenda Richmond
5/3/2021
2.3
Eielson AFB DWCF Gathering Memo FY22 CTC
5/3/2021
2.3
Eielson AFB Take Off Pad FY22 CTC Draft Final ARD
5/3/2021
2.3
Eielson AFB Tanker Row FY22 CTC Draft Final ARD
5/3/2021
2.3
RAF Mildenhall DWCF Gathering Memo FY22 CTC
5/4/2021
2.3
RAF Mildenhall NSBF FY22 CTC Draft ARD
5/4/2021
2.3
RAF Mildenhall PSI4 FY22 CTC Draft ARD
5/4/2021
2.3
RAF Mildenhall Record of PM Approval FY22 CTC
5/4/2021
2.3
RAF Lakenheath DWCF Gathering Memo FY22 CTC
5/4/2021
2.3
RAF Lakenheath POL 7 FY22 CTC Draft ARD
5/4/2021
2.3
RAF Lakenheath Record of PM Approval FY22 CTC
5/4/2021
2.3
Whittier DWCF Gathering Memo FY22 CTC
5/4/2021
2.3
Whittier FY22 CTC Draft Final ARD
5/4/2021
2.3
Thule AB DWCF Gathering Memo FY22 CTC
5/5/2021
2.3
Thule AB Facility 558 FY22 CTC Draft ARD
5/5/2021
2.3
Thule AB Record of PM Approval FY22 CTC
5/5/2021
2.3
Hickam AFB Data Gathering Memo FY22 CTC
5/5/2021
2.3
Hickam AFB Stripper Pit FY22 CTC Draft Final ARD
5/5/2021
2.3
Hickam AFB Valve Pit FY22 CTC Draft Final ARD
5/5/2021
2.3
Hickam AFB Challenger Loop FY22 CTC Draft Final ARD
5/5/2021
2.1
Weekly Status Report
5/5/2021
2.3
Fort Polk FY22 CTC Pre-Draft ARD for discussion
5/6/2021
2.3
San Pedro DWCF Gathering Memo FY22 CTC
5/7/2021
2.3
San Pedro Admin Area FY22 CTC Draft ARD
5/7/2021
2.3
San Pedro South Control Area FY22 CTC Draft ARD
5/7/2021
2.3
San Pedro Tank Farm Area FY22 CTC Draft ARD
5/7/2021
2.3
San Pedro Record of PM Approval FY22 CTC
5/7/2021
2.3
Ozol DWCF Gathering Memo FY22 CTC
5/7/2021
2.3
Ozol FY22 CTC Draft ARD
5/7/2021
2.3
Ozol Record of PM Approval FY22 CTC
5/7/2021
2.3
DM Pacific Data Gathering Memo FY22 CTC
5/10/2021
2.3
Arctic Surplus FY22 CTC Draft Final ARD
5/10/2021
2.1
Weekly Status Report
5/11/2021
2.3
Norwalk Data Gathering Memo FY22 CTC
5/12/2021
2.3
Norwalk Terminal FY22 CTC Draft Final ARD
5/12/2021
2.3
Fort Wainwright DWCF Gathering Memo FY22 CTC
5/12/2021
2.3
Fort Wainwright Bldg 3484 FY22 CTC Draft Final ARD
5/12/2021
2.3
McEntire JNGB Data Gathering Memo FY22 CTC
5/13/2021
2.3
McEntire JNGB PRT FY22 CTC Draft Final ARD
5/13/2021
2.3
Whittier DWCF Gathering Memo FY22 CTC
5/14/2021
2.3
Whittier FY22 CTC Final ARD
5/14/2021
2.3
Red Hill Data Gathering Memo FY22 CTC
5/14/2021
2.3
Red Hill Tank #5 Release FY22 CTC Draft Final ARD
5/14/2021
2.3
MCAS Camp Pendleton Data Gathering Memo FY22 CTC
5/17/2021
2.3
MCAS Camp Pendleton PRT FY22 CTC Draft Final ARD
5/17/2021
2.3
Seymour Johnson Data Gathering Memo FY22 CTC
5/18/2021
2.3
Seymour Johnson KC 135 Ramp FY22 CTC Draft Final ARD
5/18/2021
2.3
Norwalk Data Gathering Memo FY22 CTC
5/18/2021
2.3
Norwalk Terminal FY22 CTC Final ARD
5/18/2021
2.1
Weekly Status Report
5/18/2021
2.3
Fort Wainwright DWCF Gathering Memo FY22 CTC
5/21/2021
2.3
Fort Wainwright Bldg 3484 FY22 CTC Final ARD
5/21/2021
2.3
RAF Lakenheath DWCF Gathering Memo FY22 CTC
5/21/2021
2.3
RAF Lakenheath POL 7 FY22 CTC Draft Final ARD
5/21/2021
2.3
Thule AB DWCF Gathering Memo FY22 CTC
5/24/2021
2.3
Thule AB Facility 558 FY22 CTC Draft Final ARD
5/24/2021
2.3
RAF Mildenhall DWCF Gathering Memo FY22 CTC
5/24/2021
2.3
RAF Mildenhall NSBF FY22 CTC Draft Final ARD
5/24/2021
2.3
RAF Mildenhall PSI4 FY22 CTC Draft Final ARD
5/24/2021
2.4
Deatherage FY22 CTC PM Level Roll-Up for Budget
5/24/2021
2.4
Manoi FY22 CTC PM Level Roll-Up for Budget
5/24/2021
2.4
Meadows FY22 CTC PM Level Roll-Up for Budget
5/24/2021
2.3
Indian Booster Station Data Gathering Memo FY22 CTC
5/25/2021
2.3
Indian Booster Station FY22 CTC Draft Final ARD
5/25/2021
2.4
Johnson FY22 CTC PM Level Roll-Up for Budget
5/25/2021
2.4
Deardorff FY22 CTC PM Level Roll-Up for Budget
5/25/2021
2.1
Weekly Status Report
5/25/2021
2.3
Curtis Bay Depot Data Gathering Memo FY22 CTC
5/26/2021
2.3
CBD IRP Sites FY22 CTC Draft ARD
5/26/2021
2.3
CBD MMRP Sites FY22 CTC Draft ARD
5/26/2021
2.3
Curtis Bay Depot Record of PM Approval FY22 CTC
5/26/2021
2.3
Ozol DWCF Gathering Memo FY22 CTC
5/26/2021
2.3
Ozol FY22 CTC Draft Final ARD
5/26/2021
2.3
San Pedro Gathering Memo FY22 CTC
5/27/2021
2.3
San Pedro Admin Area FY22 CTC Draft Final ARD
5/27/2021
2.3
San Pedro South Control Area FY22 CTC Draft ARD
5/27/2021
2.3
San Pedro Tank Farm Area FY22 CTC Draft Final ARD
5/27/2021
2.3
Tustin El Toro Data Gathering Memo FY22 CTC
5/27/2021
2.3
Tustin El Toro FY22 CTC Draft Final ARD
5/27/2021
2.3
Columbus Data Gathering Memo FY22 CTC
5/27/2021
2.3
Columbus SSI Sites FY22 CTC Draft ARD
5/27/2021
2.3
Columbus Record of PM Approval FY22 CTC
5/27/2021
2.4
Potter FY22 CTC PM Level Roll-Up for Budget
5/27/2021
2.4
Devier-Heeney FY22 CTC PM Level Roll-Up for Budget
5/27/2021
2.3
Fort Polk Data Gathering Memo FY22 CTC
5/28/2021
2.3
Fort Polk DRMO Site FY22 CTC Draft ARD
5/28/2021
2.3
Fort Polk Record of PM Approval FY22 CTC
5/28/2021

Task 3

3
PBC EL-021 Coversheet
5/3/2021
3
GEN-143 Coversheet
5/5/2021
3
GEN-143 Interpretation 9 Compliance MFR
5/5/2021
3
GEN-143 EL US GAAP Departure MFR
5/5/2021
3
PBC EL-022 Coversheet
5/7/2021
3
PBC EL-022 Mapping
5/7/2021
3
PBC EL-023 Coversheet
5/7/2021
3
PBC EL-023 Mapping
5/7/2021
3
Error Tolerance for TF E&DL for FY20 Analysis
5/13/2021
3
Responses to ATF Departure from GAAP Questions
5/13/2021
3
FY20 Estimate to Actuals TF Analysis Results document
5/14/2021
3
FY20 Estimate to Actuals TF Analysis Workbook
5/14/2021
3
FY16 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
3
FY17 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
3
FY18 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
3
FY19 GF Estimates to Actuals Results Analysis Workbook
5/21/2021
3
FY21 GF E2A Lookback Analysis Package Summary
5/21/2021
3
Responses to EY question list on Transaction Fund FY21 CTCs
5/25/2021
3
PBC EL-028 Coversheet
5/27/2021

File details come from the government source that posted it. Updated .