Appendix D_FY21 Site ID_Data Gathering and Annual Report QAQC Checklist_....pdf
PDF 212 KB Posted
- Attached to
- DLA Installation Management, Environmental Management, Environmental Liabilities Management Program Support Federal contract opportunity
- Solicitation number
- W912DR22R0011
About this file
This document contains a quality assurance checklist for a Defense Logistics Agency site identification data gathering and annual determination report. It outlines the steps taken to verify the accuracy and completeness of environmental event data in the agency's repository, including cross-checks of export counts, site details, and meeting minute documentation. It also describes the compilation of the annual report and verification of included documents.
The related federal contract opportunity is a firm-fixed-price solicitation for program support services to DLA Installation Management's Environmental Management and Environmental Liabilities Management Program. Services include assisting with program management functions and providing environmental liabilities and audit expertise. The requirement aims to produce auditable financial statements to satisfy DoD reporting requirements. The solicitation is a Full and Open Competition after exclusion of sources set-aside for small businesses. The NAICS code is 561990 with a $12M size standard. The issuing agency is the US Army Corps of Engineers Baltimore District in support of DLA. Requests for information must be submitted through ProjNet and proposals in accordance with the solicitation and amendments. Vendors must register in SAM and representations & certifications applications to receive an award.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Appendix A_DO-0019_DLA DM-ER_Monthly Progress Report_May 2021.docx | DOCX document | |
| Appendix D_1115_FY21 Site ID Annual Determination Report_DWCF_sign_PDF.pdf | ||
| FY22_PCM_43_ELM_01182022.pdf | ||
| Appendix C_Site ID Monthly Report_June 2021.pdf | ||
| Appendix B_Env Event Repository Input.pdf | ||
| Price Schedule.xlsx | XLSX spreadsheet | |
| ASCA Training Completion Certificate.pdf | ||
| Appendix B_Env Event Repository.pdf | ||
| W912DR22R0011 Solicitation Amendment 0001.pdf | ||
| W912DR22R0011 Solicitation.pdf | ||
| Proposal TEMPLATE.xlsx | XLSX spreadsheet |
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
Defense Logistics Agency
FY21 Site Identification Data Gathering and Annual Determination Report QA/QC
FY21 4th Quarter/Annual Determination Report QA Checklist DWCF Fund
Fiscal Year 2021 (FY21) 4th Quarter Site ID Data Gathering and Annual Determination Report
Defense Working Capital Fund (DWCF)
Please refer to the Review Guide for Data Gathering and Annual Determination Reports (Appendix A.5) (Review Guide) when completing this checklist as a reviewer. The Review Guide provides step-by-step instructions for completion of the following tables.
Section 1. Reviews Prior to the Creation of Draft Meeting Minutes
Initial Reviewer Final
Reviewer A. Quality Assurance (QA) of the Initial Environmental Event Repository Export (Export)a and Mail Merge Template
Repository Event/Site Count or Detail
1. Date of Export? (Add the date to the footer of the exported report.) 072721 NA Verified
2. Does the total number of events/sites in the repository match that in the Export? Yes No 845 Verified
3. Sort the Export by fund. What is the total number of events/sites in each fund? Does the sum match the total in A.2?
General Fund 153
Verified
DWCF 618
DWCF (NEM) 58
Transaction
Fund 16
Total 845 Verified
4. For a selection of 10 individual events/sites (rows) in the Export, does the information in each cell in the Export match that in the repository? (List items in event/site detail.)
Yes No (009) R&H Oil Verified
Yes No (010) Smith Junkyard Verified
Yes No (011) Ward Transformer Verified
Yes No (012) Thermalkem Verified
Yes No (015) Yosemite Slough Verified
Yes No (016) Peck Iron & Metal Verified
Yes No (0333) Bailey Metal Processors Verified
Yes No (0387) Former Standard Steel Site Verified
Yes No (0548) Ogden Swift Verified a DM-E has implemented QA/QC steps in effort to comply with the guidance set out in Directive-Type Memorandum (DTM) 18-011 Management Review of System Generated Reports for Data Completeness and Accuracy (September 5, 2018). As DM-E’s Site ID process for corrective action sites does not use reports from the Enterprise Business System (EBS), nor is there a tie to the trial balance, not all the guidance in the DTM applies.
Final
Reviewer A. Quality Assurance (QA) of the Initial Environmental Event Repository Export (Export)a and Mail Merge Template
Repository Event/Site Count or Detail
Yes No (0549) Chemical
Commodities, Inc.
(CCI)
Verified
5. Using a sample export for 10 events/sites, create a sample meeting minute document to test the mail merge template. Does the information in each cell of the meeting minute document match that in the Export?
Yes No (009) R&H Oil Verified
Yes No (010) Smith Junkyard Verified
Yes No (011) Ward Transformer Verified
Yes No (012) Thermalkem Verified
Yes No (015) Yosemite Slough Verified
Yes No (016) Peck Iron & Metal Verified
Yes No (0333) Bailey Metal Processors Verified
Yes No (0387) Former Standard Steel Site Verified
Yes No (0548) Ogden Swift Verified
Yes No (0549) Chemical
Commodities, Inc.
(CCI)
Verified
Comments: None.
Reviewer B. Fund-Specific Detail of the Initial Export Repository
Event/Site Count or Detail
1. What is the total number of events/sites in DWCF included in the Export with the determinations of:
N/A – Reported after determination event,
1. Potential EL
Site ID Events for review with
PMs 72 Verified
2. What is the total number of events/sites in DWCF included in the Export with the determination of:
2. Out-Year ELs
Current anticipated CTC Sites
77 Verified
Reviewer B. Fund-Specific Detail of the Initial Export Repository
Event/Site Count or Detail
3. What is the total number of events/sites in DWCF included in the Export with determinations of:
3. Non-ELs,
4. Former ELs
Site ID Events tracked for completeness 469 Verified
4. Add up the totals in B.1, B.2, and B.3.
Does the total match the fund total in A.3? Yes No NA Verified
5. Cross-check the population of Out-Year ELs (B.2) to the current (i.e., to date) population of CTC sites. Is the population of Out-Year ELs identical? If not, include notes in the Site Detail column.
Yes No NA Verified
6. Comments: None.
Section 2. Site ID Data Gathering Draft Meeting Minute Reviews
Final
Reviewer C. QA Review of the Draft Site ID Meeting Minutes Event/Site Count or Detail
1. List the name and total number of sites for each PM in the fund for whom a meeting minute document was created.
NA NA Amanda Mano’i Total Sites – 13* Verified
NA NA William Potter Total Sites - 12 Verified
NA NA David McBride Total Sites – 10* Verified
NA NA Jeanne Meadows Total Sites - 13 Verified
NA NA Robert Johnson Total Sites - 6 Verified
NA NA
Stephen
Deatherage Total Sites - 9
Verified
NA NA Therese Deardorff Total Sites - 9 Verified
2. Were Draft Meeting Minutes created for all PMs in DWCF where events were reported or tracked (in categories N/A – Reported after determination event or 1. Potential EL), per the Export?
Yes No NA Verified
3. Add up the total number of events/sites listed for all PMs in DWCF in C.1. Does the total number of events/sites match the number of events/sites in B.1?
Yes No 72 Verified
4. Comments: Event 0683 and 0684 were reassigned from Mr. McBride’s area of responsibility to Ms.
Mano’i’s for data gathering.
D. Technical and Editorial Reviews
Meeting Minute Document
1. Technical Review 2. Editorial Review
Comments? Comments Addressed? Comments? Comments
Addressed?
Robert Johnson No Yes NA Yes Yes NA
David McBride No Yes NA No Yes NA
Therese Deardorff No Yes NA No Yes NA
William Potter No Yes NA Yes Yes NA
Stephen Deatherage No Yes NA No Yes NA
Jeanne Meadows Yes Yes NA Yes Yes NA
Amanda Mano’i Yes Yes NA No Yes NA
Section 3. Reviews Prior to the Creation of Final Meeting Minutes
Final Reviewer E. QA of the Final Environmental Event Repository Export
(Export)a
Repository Event/Site Count or Detail
1. Date of Export? (Add the date to the footer of the exported report.) 091621 NA Verified
2. Does the total number of events/sites in the repository match that in the Export? Yes No 853 Verified
3. Sort the Export by each fund. Record the total number of events/sites in each fund. Confirm that the total matches that in E.2. Determine the change from A.3.
DWCF 626
General Fund 153
DWCF (NEM) 58
Transaction
Fund 16
Total 853 Verified
Reviewer E. QA of the Final Environmental Event Repository Export (Export)a
Repository Event/Site Count or Detail Change from
A.3 8 Verified
4. For a selection of 10 individual events/sites (rows) in the Export, does the information in each cell in the Export match that in the repository? (List items in event/site detail.)
Yes No (0686) Incident 2014 Verified
Yes No (0702) Gasket Failure Below Isolation Valve
Verified
Yes No
(0006) DFSP
Newington Petroleum
Verified
Yes No (0042) Facility 2100
JP-8 Cleanup –
SS014D
Verified
Yes No (0043) A-B Pipeline Release Verified
Yes No (0074) High Point Cover Fuel Line
Release Verified
Yes No (0243) Rose Barracks JP-8 Spill Verified
Yes No (0418) Area A Verified
Yes No (0419) Area B Verified
Yes No (0423) Area H Verified
Reviewer F. Fund-Specific Detail of the Final Export Repository
Event/Site Count or Detail
1. What is the total number of events/sites in DWCF included in the Export with the determinations of:
N/A – Reported after determination event,
1. Potential EL
Site ID Events for review with
PMs 44 Verified
2. What is the total number of events/sites in DWCF included in the Export with the determination of:
Current anticipated CTC Sites
80* Verified
Reviewer F. Fund-Specific Detail of the Final Export Repository
Event/Site Count or Detail
2. Out-Year ELs
3. What is the total number of events/sites in
DWCF included in the Export with determinations of:
3. Non-ELs,
4. Former ELs
Site ID Events for tracking for completeness
502 Verified
4. Add up the totals in F.1, F.2, and F.3.
Does the total match the fund total in E.3? Yes No 626 Verified
5. Cross-check the population of Out-Year ELs (F.2) to the current (i.e., to date) population of CTC sites. Is the population of Out-Year ELs identical? If not, include notes in the Site Detail column.
Yes No See comments Verified
Comments: F.2. Four events (0460, 0540, 0666, and 0691) were determined to be Out-Year ELs during the 4th Quarter Determination Event, however, since these changes were immaterial for the FY22 CTC Roll Forward process, no ARD was prepared.
F.5. See above. Additionally, one event (0042) was determined a Potential Out-Year EL during the 4th Quarter Determination Event, while an FY22 CTC ARD had been previously prepared. This change was noted for the FY22 CTC Roll Forward.
Section 4. Final Site ID Data Gathering Meeting Minute Reviews
Final Reviewer G. Verification of Final Site ID Meeting Minutes Event/Site Count or Detail
1. For a selection of two events/sites (rows) for each PM with reported or tracked events in DWCF, does the information in each cell in the Final Meeting Minutes match that in the Export? (List items in event/site detail, where applicable.)
Yes No
Robert Johnson Number of sites: 7
(0243) Rose Barracks JP-8 Spill (0642) Spill Cover-up
Verified
Yes No
David McBride Number of sites: 11
(0610) DFSP
Hakozaki
(0704) Tank A1 Leak
Verified
Yes No
Therese Deardorff Number of sites: 9
(0687) Incident 2018 (0688) Tanker Pump
House Bldg 1211
Verified
Yes No
William Potter Number of sites: 14
(0418) Area A (0419) Area B
Verified
Yes No
Stephen Deatherage
Number of sites: 10 (0702) Gasket Failure Below Isolation Valve
(0006) DFSP
Newington Petroleum
Verified
Yes No
Jeanne Meadows Number of sites: 16 (0042) Facility 2100
JP-8 Cleanup –
SS014D
(0043) A-B Pipeline Release
Verified
Yes No Amanda Mano’i
Number of sites: 14 (0360) Incident 1148
Reviewer G. Verification of Final Site ID Meeting Minutes Event/Site Count or Detail
(0644) Flightline Spill/Pit Repair
Project
2. Were Meeting Minutes created for all PMs in
DWCF where events were reported or tracked, per the Export?
Yes No NA Verified
3. Add up the total number of events/sites listed for the PMs in DWCF in G.1. Does the total number of events/sites match the number of events/sites in F.1?
Yes No
Total Events in Meeting Minutes: 81
Events not included in F1, but included in meeting minutes:
Events determined
Out-Year EL: 4 Events determined
Non-EL: 32 Events determined
Former EL: 1
Section 5. Compiling the Annual Determination Report
Final Reviewer H. Verification of Documents Event/Site Count or Detail
1. Is the Environmental Event Export included and formatted correctly? Yes No NA Verified
2. Are Meeting Minute documents included in the Annual Determination Report for all PMs? Yes No NA Verified
3. Is the 2nd Quarter Data Gathering Meeting Minute summary document included, if applicable?
Yes No
40 events (5 Out- Year ELs and 35
Non or Former ELs) are included in the document
Verified
Comments: H.1. The EER Export includes all those events that were determined Out-Year ELs or Potential ELs in FY21 4th quarter for purposes of comparison, as well as those events reported since the end of FY20 Site ID data gathering. Status notes for those events which did not require data gathering in 4th quarter based on their 2nd quarter determination (i.e., Out-Year EL, Non-EL, or Former EL) are included in the Events Excluded from 4th Quarter Data Gathering section of the Annual Report.
Reviewer H. Verification of Documents Event/Site Count or Detail
A total of 192 events are included in the export. This includes 80 Out-Year ELs (per FY21 Site ID 4th Quarter Data Gathering and the FY22 CTC/FY22 CTC Roll Forward), 33 events determined Non or Former EL in 4th quarter, 35 events determined Non or Former EL in 2nd quarter, and 44 events continuing to be tracked as Potential Out-Year ELs.
Section 6. Review Verification I. Review Verification
Initial Reviewer I attest that I have completed the review steps indicated above and per the Review Guide. This package is complete and accurate to the best of my knowledge.
Signature Date Technical Reviewer
I attest that I have completed technical review per the Review Guide.
Signature Date Editorial Reviewer
I attest that I have completed editorial review as per the Review Guide.
Signature Date Final Reviewer
I attest that I have completed the review steps indicated above and outlined in the Review Guide. This package is complete and accurate to the best of my knowledge.
Signature Date
DOBRY.CHARLOTTE.PAIGE.1515557195 Digitally signed by DOBRY.CHARLOTTE.PAIGE.1515557195 Date: 2021.09.21 09:26:31 -04'00'
Katharine Hastie Digitally signed by Katharine Hastie DN: cn=Katharine Hastie, o=CLAENE Group, ou=CLAENE Group, email=hastie.katharine@claenegroup.com, c=US Date: 2021.09.21 09:43:30 -04'00'
Maureen A Helms Digitally signed by Maureen A Helms DN: cn=Maureen A Helms, o, ou=CLAENE Group, email=helms.maureen@claenegroup.com, c=US Date: 2021.09.21 07:30:01 -06'00'
Maureen A Helms Digitally signed by Maureen A Helms DN: cn=Maureen A Helms, o, ou=CLAENE Group, email=helms.maureen@claenegroup.com, c=US Date: 2021.09.21 07:30:19 -06'00'
File details come from the government source that posted it. Updated .