Technical Exhibit CFO Audit Readiness.docx

TECHNICAL EXHIBIT 2

Specific Tasks

Aberdeen Proving Ground (APG), Adelphi Laboratory Center (ALC) and Blossom Point Research Facility (BPRF)

APG-ALC-BPRF Chief Financial Officers Audit (CFOA) Audit Readiness Support

14 November 2023

Data collection referred to in this PWS excludes Architectural and Engineering (A/E) services including inspections, surveying and mapping as it pertains to the design, construction, and repair of buildings, facilities and other real property. Data collection involving A/E quality work requiring these types of services by a professional land surveyor will be performed using other existing contracts that meet the Brooks Act requirements.

1.0. Project Management Plan (PMP).

1.1. The Contractor shall develop, submit and maintain a detailed Project Management Plan (PMP) for the awarded set of customer requirements described in this performance work statement. The PMP shall be submitted with the request for proposal (RFP).

1.2 The PMP shall be broken into individual sections specific to each set of requirements and include at a minimum the following information:

· Technical Approach (ePRISMS Management and CFOA & FIAR Audit Readiness)

· Deliverables

· Assumptions

· Schedule (if required)

· Organization and integration of the project team

· Schedule management and project controls

· Quality management

2.0. Real Property 406

2.1. Provide Accountability Controls.

2.1.1. Controls must be put in place to ensure that proper accountability is maintained, in accordance with OPORD 23-022, FY23 RP Audit Guidance, from the time the Real Property Accountability Officer (RPAO) signs a Department of Defense Form (DD Form) 1354, Transfer and Acceptance of Military Real Property, then adds it to the accountable records until the time that the Government relinquishes ownership through such means as asset transfer or disposal actions. The Contractor shalll demonstrate a knowledge of IMCOM required facility turn-in processes, maintain documentation of all installation and IMCOM required facility clearance documents including but not limited to environmental clearance procedures and documentation, safety clearance procedures and documentation, operations and maintenance clearance procedures and documentation, and the drafting, routing and documenting of facility release and reassignment correspondence. The Contractor shall also maintain Facility Information Folders, and update GFEBS with release and reassignment data, major rehabilitation and renovation data, and other data as required through GFEBS.

2.2. GFEBS Support.

2.2.1. The Contractor shall update, manage and maintain the database of record (GFEBS). The reporting of real property assets is required by 10 USC 2701 and DODI 4165.14. Existing Installation assets are identified and maintained in GFEBS to satisfy the Office of the Secretary of Defense (OSD) reporting requirements. The installation inventory is electronically uploaded to the HQIIS and to Installation RPLANS on a quarterly basis to feed the Army’s integrated suite of planning tools, such as OSD’s Facility Sustainment model (FSM). Contractor must be cognizant of GFEBS Current Capabilities & Deficiencies as to specific Army Policy and procedures in both inventory management and reporting capabilities.

2.2.1.1. The contractor shall update GFEBS with acceptance, transfer, release and reassignment, major rehabilitation and renovation data, and other data as required.

2.2.1.2. The contractor shall coordinate with the ASIP & RPLANs database managers to compare data of authorized tenants assigned to the facilities, and develop plans, timelines, and estimates to input this data into GFEBS.

2.2.1.3. Development and update Real Property SOP’s.

2.2.1.4. Develop and utilize spreadsheets to extract and organize data from GFEBS for the Real Property Team for financial analysis of acquisitions, Space Utilization, Acquisition Type, Asset Configuration and Allocation, User Status, existence, and demographic information.

2.2.1.5. Provide data support for the Real Property in real-time, and the creation of spreadsheets and reports derived from data analyses.

2.2.1.6. Provide technical support and assistance to the Real Property staff for GFEBS utilizing the database to prepare reports, provide data to support meetings and briefings for Real Property, and other Command Level meetings.

2.3. GIS Support (Real Property).

2.3.1. The contractor shall provide on-site, Geographic Information Systems (GIS) support to the Real Property (RP) Office to assist the Real Property staff with numerous projects and surveys for the management of built and natural infrastructure including, but not limited to Financial Improvement Audit Readiness (FIAR), Linear segmentation and space utilization/management accountability and planning, physical inventory, and de-consolidation efforts. The contractor shall apply principles of GIS to be SDFIE compliant, following the GIS QAP, and utilize the Uniform Facilities Criteria (UFC) to provide expertise in the areas of RP accounting. Principals shall adhere to the Army criteria, when necessary as described in Army publications. The Contractor shall also be responsible for creating customized database solutions in Microsoft Access and Oracle to efficiently manage RP data and assets as well as streamline operations between RP and other offices.

2.3.2. The contractor shall support the Installation’s Real Property staff in developing a comprehensive management approach to delineating physical and built infrastructure, and creating or expanding GIS databases with the specific goal of demonstrating compliance with FIAR guidance, Army Linear Segmentation Implementation Guidance and the Office of Secretary of Defense Linear Segmentation Policy, as applicable, and Army policy with respect to the use of GFEBS and ePRISMS for Space utilization/Management accountability and space planning. The support shall be provided as required throughout the performance period and include identification/verification of any buildings, facilities, and boundaries. In addition, the contractor shall support data collection of any and all known proposed changes to the installation built infrastructure that may impact operability and provide the collected data on these sites to the Geobase office for entry to the GIS Common Installation Picture (CIP) database. This may be through field GPS data collection, field verified maps or field notes of site surveys and/or physical facility inspections.

The contractor shall assist in reviewing and updating installation RP accountable records with respect to physical inspection and inventories completed on buildings and facilities as well as managing FIAR requirements as they pertain to GIS. The contractor shall work with the installation GIS team to reconcile RP assets per FIAR requirements as well as provide documentation and information needed to identify RP assets on GIS data layers. The contractor shall submit timely and accurate reports on the results of inventories and inspections and take appropriate action to initiate corrective actions for keeping RP information current. The contractor shall ensure accuracy and reliability of records and reports. The contractor shall be well versed in gathering, evaluation and interpreting data to arrive at valid conclusions and offer meaningful recommendations. The contractor shall have the experience and ability to use various office automation software programs, tools and techniques to support office operations and produce a variety of documents, such as letters, reports, spreadsheets, databases and graphs. The contractor shall have the ability to administer GIS geodatabases and be responsible for the performance and integrity, as well as the planning and development of the database(s), and troubleshooting any issues in order to ensure that the Real Property GIS data is properly maintained.

2.4. Audit Readiness and Compliance.

2.4.1. Asset Record Management.

2.4.1.1. The purpose of this contract is to complete a full validation and correction of all GFEBS asset records to include creation/assembly/updates of Facility Information Folders (FIF) for Existence, Completeness, Rights and Obligations, Valuation, Presentation and Disclosure for the purpose of sustaining effective management of real property data in order to become Audit Ready and Army compliant.

The Contractor shall execute administrative and analytical tasks to include reviewing, analyzing, documenting, and providing recommendations on corrective actions needed to reconcile GFEBS records and supporting documentation contained in the FIF folders. Upon RPAO approval, the Contractor shall execute actual corrective actions needed within GFEBS and finalize Facility Information Folder contents.

The contractor shall digitize all existing Facility Information Folders and make available through APG’s Facility Management System.

2.4.2. Asset Record Analysis/Validation.

2.4.2.1. The Contractor shall conduct an examination of all existing assets by reviewing GFEBS records along with FIF folder supporting documentation as well as conducting physical inspection surveys to document any incomplete, inaccurate, missing, or outstanding real property asset data. The Contractor shall also work with the Installation RPAO to find and address all real property assets that may not yet be in GFEBS but are valid and should be included in the GFEBS. The Contractor shall be responsible for recording any discrepancies detected between GFEBS records and it’s supporting FIF folder using the PIMD or PIW Worksheet. The contractor shall utilize the PIW Information sheet to verify real property asset data during the physical inspection. The examination shall include:

2.4.2.2 Analysis of real property data in GFEBS

2.4.2.2.1. The contractor shall review and validate all real property records currently entered into GFEBS for accuracy and completeness.

2.4.2.2.2. Analysis of real property module (RE80) in GFEBS such as functional location, building, pooled space and rental & contract objects and asset records

2.4.2.2.3. Analysis of functional space assignment/space utilization

2.4.2.3 Analysis of real property Facility Information Folders

2.4.2.3.1. The contractor shall examine all hard copy, physical inventory records and documentation. If records are found to be deficient, the contractor shall record the deficiency found and notify the Government of the deficiency for resolution. The Supporting Documentation Checklist has been provided by OACSIM and the details include, but are not limited to general details (such as DD Forms 1354, floor plans, maps, date/time stamped color photographs (mandatory), Property Cards, cost details, GFEBS screen shots & attestation memos), disposal records (such as DD Forms 1354, DD Forms 337, historic and environmental reviews, DD Forms 1391, Excess or Disposal reports, transfer and privatization documentation), equipment records that exceed capitalization thresholds or change depreciation schedules, and other data (such as inventory inspection reports, diversion/conversion requests to IMCOM, utilization reports, out-grants, contracts & contract mods, work authorizations, statements of work, task and delivery orders, legislative documents and DD Forms 1351).

2.4.3 Physical Surveys (GFEBS)

2.4.3.1. the Contractor shall physically survey all assets to validate existence compared to existing GIS information using the Army Installation Atlas and GFEBS real property data. All physical surveys shall identify the “minimum Asset Information to be Validated During Physical Inventory” in accordance with OPORD 23-022: Real Property Physical Inventory.

2.4.3.2. The contractor shall conduct inspections and physical surveys of real property assets as required to meet Real Property Audit Readiness. The contractor shall create GFEBS records for each asset. The contractor shall use the Army’s approved inspection checklist to ensure all key data elements of the asset are inspected and verified, to include but not be limited to the geospatial location and physical address, correct design use category code, condition of the asset, main and predominant usage types, unit of measure, quantity and other data elements.

2.4.3.3. The contractor shall use a mobile application to accurately collect data in the field, verify location by GPS coordinates, and take color photographs with time and date stamp. The data collected shall match the DoD’s Master Real Property Categorization System and Master UIC Codes, as well as GFEBS record requirements for every data element collected. The application must allow for additional data to be added/updated for an asset record during data validation and GFEBS record update processes to track progress of each step until the asset is completed 100% in GFEBS.

2.4.3.4. Completion of the Physical Inventory (Minimum Data) Worksheet, validation of all data elements defined in Appendix J of the OASIM Real Property Management Handbook, October 2022, validation of all data elements defined in Appendix C of the IMCOM Real Property Accountable Officer Handbook, October 2022 and updates to the Army Installation Atlas using the Asset Validation tool.

2.4.3.5. From results of the examination the contractor shall develop a submittal package with detailed findings to the RPAO within 10 days of the physical inspection date. The submittal package shall include:

2.4.3.6. Updated PIW Worksheet - The Contractor shall complete and submit a redlined and updated PIW Worksheet, with changed fields highlighted. The Government will provide acquisition data (e.g., DD1354 Form) where necessary for the PIMD worksheet update. If none exists, the Government will provide its best estimates of acquisition data, and the Contractor shall annotate with a Memorandum for Record in the Notes section that this data is estimated or not provided.

2.4.3.7. All Supporting Record Documentation, Acquisition Records, Capital Improvement records, Disposal Records, and other supplemental data including photos, maps, and floor plans.

2.4.3.8. The government shall be given the opportunity to review the submittal package and provide concurrence or requested changes. Requested changes shall be made to the submittal and approved by the RPAO before final corrections to GFEBS. All updates and changes must be completed within 30 days of RPAO signature on the PIW and/or DD Form 1354.

2.4.4 GFEBS Updates.

2.4.4.1 Upon RPAO approval and based upon GFEBS and FIF folder review and physical inspections the contractor’s real property Subject Matter Experts (SME) shall conduct the following actions to ensure DPW real property records are accurate, complete and CFOA compliant:

2.4.4.2 The Contractor shall update/correct and upload all GFEBS real property information for accuracy and completeness to meet CFOA audit compliance standards. This shall include, but not limited to, updating pooled space and rental objects, unit of measure, CATCODES (including CATCODE changes for SCIF structures), and other data as required for CFOA compliance and accountability including Memorandum for Records of changes and updated floor plans.

Once GFEBS uploads and edits are complete, the Contractor must submit electronic copies of the records and submit a Letter of Completion to the PM and Installation POC within 5 business days of upload.

2.4.5. Facility Information Folders (FIF) Folder Assembly.

2.4.5.1. The Contractor shall create/update physical hard-copy FIF folders for each asset surveyed. The FIF deliverables shall include a physical folder in accordance with the Supporting Documentation Checklist with supporting documentation that aligns with GFEBS. A phased approach may be exercised to deliver against the total record line items but all FIF folders shall be delivered to the RPAO NLT 15 days before the end of each month.

2.4.5.2. The Contractor shall report status of FIF Folder creation on the MSR, as well as, track the completion rate for use of future estimation efforts. Following assembly of all required FIF folder for the contract period of performance, the Contractor shall submit a Letter of Completion indicating all FIF folders delivered to the government NLT 10 calendar days prior to the PoP end date.

2.4.5.3. The Government will have the opportunity to conduct random sampling in order to analyze the overall completeness and quality of the FIF folders. If any discrepancies are identified the Contractor shall make the appropriate corrections and ensure all other FIF folder satisfy any identified issues. The Contractor shall report and document the completion of FIF folders during the MSR.

2.4.5.4. The contractor shall accomplish the above tasks by meeting the requirements of Operations Order 23: Real Property Physical Inventory, OACSIM’s Real Property Audit Readiness Handbook (October 2022) and IMCOM’s Real Property Accountable Officer Handbook (September 2020) along with following the below Army HQ and IMCOM standards to ensure compliance with CFOA and Army requirements:

· Department of Defense Financial Management Regulation (DoDFMR), DoD 7000.14-R, Volume 4, Accounting Policy, Volume 4, Chapter 24, Real Property

· DoDI 4165.14, Real Property Inventory (RPI) and Forecasting

· DoDI 4000.19, Support Agreements,

· DoDI 4165.70, Real Property Management,

· Office of the Under Secretary of Defense/Chief Financial Officer, Financial Improvement and Audit Readiness (FIAR) Guidance

· AR 405-45, Real Property Inventory Management

· AR 210-20, Real Property Master Planning for Army Installations

· AR 405-70, Real Estate Utilization of Real Property

· AR 415-28, Real Property Category Codes

· AR 420-10, Space Management Guide

· AR 5-9, Management Installation Agreements

· AR 25-50, Preparing and Managing Correspondence

· DA PAM 415-28, Guide to Army Real Property Category Codes

· UFC 1-300-08, Criteria for Transfer and Acceptance of DoD Real Property

· DoDi 4165.14, Real Property Inventory (RPI) and Forecasting

· Executive Order 13327, Federal Real Property Asset Management

· OUSD(C) Financial Improvement and Audit Readiness (FIAR) Guidance

· OUSD (EI&E) Required DoD Reconciliation Data Elements

2.4.5.5. The Contractor shall produce a weekly Validation Report with detailed findings on the last business day of the week. The report document will include, but is not limited to, actual findings of correct, inaccurate, missing, and suggested real property corrections in GFEBS and FIF folders. The report should also document assets that are found on post but could not be matched within the GFEBS system. A section within the report shall identify opportunities for cost efficiencies and consistent categorical discrepancies within the data as a whole that will lead to changes populating future GFEBS real property records; as well as, any issues uncovered that could hinder compliance.

2.4.6. Document and Drawing Library Consolidation.

2.4.6.1. The contractor shall dispose of duplicate hard and electronic data sets and files via incineration in accordance with established DoD directives. The contractor shall develop a comprehensive document management plan identifying the management processes, roles, responsibilities, file structure, naming conventions, document retrieval process, and document inventory that complies with DoD records management directives and supports the annual document archival efforts. Contractor shall provide staffing to occupy library during business hours when customer access is required.

2.4.6. Design/Construction Document Quality Control.

2.4.6.1. The contractor shall provide quality control reviews of 2D CAD and construction deliverables as related to the CAD Standards to create, edit, sustain, QC, populate, secure, CAFM and related graphic facility information based on contract requirements, condition verifications, sketches, and other existing hardcopy and electronic documents. Contractor shall oversee compliance and conformance of hard and electronic copy construction documents and CAD deliverables with the CAD standards. Contractor must perform CAD deliverable compliance reviews to ensure that fonts, dimensions, line styles, levels, nomenclature, layering, symbol libraries, labeling and other data elements are in compliance with the CAD standards.

2.4.6.2 Contractor has responsibility for providing and retrieving, tracking and monitoring specifications and drawing changes, sketches and document reproduction services and CAD drawing and SOP development. The contractor shall review each document or piece of information and use all naming convention types and attributes necessary to identify the document or piece of information and provide the full range search attributing established in the EDMS. The Contractor shall review assigned project statements of work and provide recommendations on the application of the CAD standards and required technical language for government approval and inclusion in contract documents. Contractor shall attend project kickoff meetings and establish communication channels with project teams and AE contractors responsible for development and delivery of CAD deliverables. Contractor shall develop metric data tracking CAD requirements development and EDS compliance for government approval. Contractor shall review incoming documents and data against the work process/procedures and technical requirements for that function. If submitted drawings or electronic files do not meet required standards (e.g., line thickness, levels and colors are incorrect), the contractor shall develop a detailed compliance report and submit it to the COR for follow up with the project team.

2.5 ePRISMS Data Support.

2.5.1 This contract action requires professional services to review, validate and develop standardized ePRISMS facility floor plans and related data necessary to populate and implement ePRISMS. The Contractor shall also be responsible for uploading data into the ePRISMS database.

2.5.2 Kick-Off Meeting.

2.5.2.1 The Contractor shall conduct (1) one Kick-off meeting at the installation before initiating on-site visits.

2.5.2.2 Kick-off meeting shall be held before site visit with the Installation. This meeting shall introduce the key personnel involved and summarize the effort associated with the aforementioned task listed within the performance work statement. 3.2.3. During the kick off meeting, the Contractor shall be responsible for obtaining missing data such as but not limited to; Floor Plans, Real Estate documents that outline property boundaries, POC Interview schedules, building/facility accesses, and other data.

2.5.2.3 Contractor shall be responsible for documenting meeting minutes of each meeting. Meeting minutes are required NLT 5 working days following the conclusion of a meeting. Meeting minutes are required to all attendees with a request for comment and revision. Contractor shall advise all attendees of a 5 days window to review and revise meeting minutes. Contractor shall present finalized meeting notes 10 days following the conclusion of any meeting.

2.5.3 Data Collection.

2.5.3.1 The Contractor shall coordinate with the designated government representative to determine facilities, facility types or category codes to be surveyed.

2.5.3.2 Contractor shall submit a list outlining all data required from the Government including existing floor plans in digital format, real property records, site plans and unit stationing information. The Government shall cooperate with the Contractor in the production of the requested data. The Government shall respond to the Contractor request within 5 days. The Contractor shall confirm receipt of all Government furnished data required to perform task herein. The Contractor shall notify the COR that the Government furnished data provided is sufficient to proceed with on-site tasks.

2.5.3.3 The Contractor shall provide services specific to the development of ePRISMS QAP compliant Floor Plans that depicts the space layout, utilization, and unit assignments of each facility.

2.5.3.4 The Contractor shall comply with government accountability management procedures sufficient to maintain records for all real property. For all ePRISMS real property corrections, to include but not limited to Category Code Change(s), Unit of Measure Change(s), and Tenant Change(s), the Contractor shall memorialize and submit all ePRISMS changes to the Real Property Accountable Officer (RPAO) via a Department of Defense Form (DD Form) 1354, for signature prior to formally making any edits in ePRISMS, GFEBS, or RPLANS. All hard copy change(s) and approval(s) shall be updated and maintained in the Facility Information Folders.

2.5.4 Physical Surveys (ePRISMS)

2.5.4.1 The Contractor shall conduct field surveys to develop/update CAD floor plans using Bentley Microstation Connect for facilities prioritized during the kickoff meeting. The Contractor field team shall use existing floor plans collected during data collection at the kickoff meeting to mark up space information and measurements for development of updated floor plans. The following information should be collected during floor plan field surveys for each building:

· Measurement of each building room space (including covered exterior spaces) to provide:

· Gross square feet

· Net square feet

· Net usable square feet

· Building features such as:

· Columns (with dimensions)

· Doors (with dimensions)

· Windows (with dimensions)

· Hallways (with dimensions)

· Open to Below Spaces (with dimensions)

· Building photos both internal and external

· Key building space use elements including:

· Building number

· Site number of facility code

· Space codes for each space

· Category codes for each assigned space

· Organization/Unit, UIC for each assigned space

· Number of employees by type for each assigned space

· Capacity for bedrooms in barracks facilities (if applicable)

2.5.4.2 The Contractor shall be responsible for scheduling interviews with the facility manager for each real property asset surveyed for the purpose of verifying personnel data and space utilization. At a minimum, the Contractor shall complete the following actions during each interview:

· Identify each unit (UIC and employee type) utilizing a specific facility

· Identify the correct facility category code associated with each space occupied by a specific unit.

· Identify each unit’s storage facilities, maintenance facilities, armories, educational facilities and any and all space occupied by a unit.

2.5.5 CAD Drawing, Maintenance, and Quality Assurance (ePRISMS).

2.5.5.1 Upon the completion of site surveys and data collection, the Contractor shall be responsible for development of a full set of facility utilization survey floor plans meeting the standards of the Army and requirements of the latest Army IGI&S Pro-active Real Property Interactive Management System Quality Assurance Plan (ePRISMS QAP). The floor plan drawing will be reviewed in detail by the task lead responsible for oversight of floor plan development/update, and checked for spatial accuracy, integrity, and attribute completeness. Ideally, the Contractor will provide personnel for the following line of development and QA:

· Field team survey and collection with CADD technician, ePRISMS technician, Surveyors, and Project Management

· Floor plan development by ePRISMS experienced CADD Technician

· Floor Plan Review by ePRISMS experienced Task Lead

· Final review by PM

2.5.5.2 Upon completion of each buildings floor plan development/update, the Contractor shall confirm the quality of the spatial information and compliance with Army CADD floor plan standards and the latest specification of the Army IGI&S Pro-active Real Property Interactive Management System Quality Assurance Plan (ePRISMS QAP).

2.5.5.3 Each floor plan shall be developed/updated within a 2% level of accuracy or discrepancies that equal no more than 6”. Each floor plan shall depict all windows, doors, and hallways. Each floor plan shall depict both the net square footage of the facility along with the net usable square footage of the facility in accordance with the guidelines set forth in the latest specification of the Army IGI&S Pro-active Real Property Interactive Management System Quality Assurance Plan (ePRISMS QAP).

2.5.5.4 The Contractor shall develop/update Floor Plans and Facility Space Utilization survey information per Facility Category Code under the latest specification of the Army IGI&S Pro-active Real Property Interactive Management System Quality Assurance Plan (ePRISMS QAP), listed in publications section of this PWS, to support for use in facility planning, design and management.

2.5.5.5 The contractor shall copy, scan, reproduce, and update master record drawings and master record databases. The contractor shall create custom CAD drawings that reflect the current physical attributes of buildings which have been identified by the designated government representative as requiring updates in ePRISMS.

2.5.5.6 Contractor shall provide 2D drafting to create new details or modify existing drawing data which show dimensions and specifications of building infrastructure.

2.5.5.7 The contractor shall create new details, modify, migrate, convert, and standardize new or existing CAD elements. Contractor shall file and index drawings. Contractor gathers supporting data and prepares detailed drawings of building alterations and additions including plans, details, sections, and elevations from rough sketches and outlines with differing levels of detail, format, models, or oral instructions and shall develop solutions and details using the CAD System to complete drafting assignments.

2.5.5.8 The contractor shall maintain, manage, convert, and modify existing CAD drawing data and master records in support of ePRISMS data management and updates.

2.5.5.9 The contractor shall create new master record drawings for buildings which require updates in ePRISMS which the government does not posess master drawings. The contractor shall provide services to include, but not limited to:

· Polyline CAD drawings.

· Draw, create, and update polylined spaces, area overlays, and query boundaries on master record drawing files. Contractor shall attach, publish, and synchronize polylined drawings to specific location data within ePRISMS.

· Attach gross area, gross measured area, and individual space data to ePRISMS.

· Create, update, and develop location and organization hierarchies.

· Attach organizations to specific locations and create, edit, and manage space allocations within the CAD file.

· Create, update, and attach assets to specific locations within the CAD file.

· Associate drawing objects to spatial information within CAD.

· Develop drawing labels, label styles, and label themes.

· Contractor shall perform Quality Assurance compliance reviews to ensure accuracy of all polylined spaces and attachment of metadata, and that internally modified CAD deliverables conform to applicable AEC CAD standards.

2.5.5.10 The contractor shall create and update all CAD floorplans using the latest version of Bentley Microstation.

2.5.5.11 The floor plan development and updates produced by the contractor shall be in accordance with as-built level of detail, typically required by the ePRISMS standards.

2.5.5.12 The finalized floor plans which the contractor produces shall follow ePRISMS QAP guidelines.

2.5.5.13 CAD Standards Migration (Conversion of Drawing Repository).

2.5.5.14 The contractor shall migrate current MicroStation standards into AutoCAD standards that can be used when performing DGN to DWG conversion. The contractor shall develop external standards files that are necessary for plotting and access to the standards themselves. Once the contractor successfully completes the CAD Standards Migration task, the contractor shall deliver products and services as follows:

· Migrated/updated folder structure

· A standard AutoCAD file

· Migrated Layer List

· Up to 20 AutoCAD styles

· Migrated Plot Style Table

· AutoCAD Line type file

· Up to 4 Title blocks (B, C, D, and E sizes)

· A Custom AutoCAD Profile

2.5.5.15 The contractor shall assist in the maintenance of the asbuilt construction plan repository (Currently Mfilm). This data may be used to assist in the creation of ePRISMS floorplans. This task includes intake of asbuilt construction plans, uploading them into the database of record and indexing the plans according to diciplin, notifying GIS manager of any exterior site related changes and completing research requests as directed by the government lead.

2.5.6 ePRISMS Data Loading.

2.5.6.1. Upon completion of the floor plan data the project manager and lead shall check for QA, completeness and spatial accuracy. The files shall be sent to OACSIM IGI&S ePRISMS Support Team for upload and use in the ePRISMS database for new floor plans or downloaded and updated for existing ePRISMS floor plans. Upon completion, the floor plan data must allow the Installation at a minimum be able to:

· Verify real property data

· Support space utilization planning, facility management, and data calls

2.5.6.2. The Contractor shall update ePRISMS with Space and Man Power Data. The following data shall be updated:

· Category code to depict facility usage

· Organization/unit assignments (identified by UIC) for each assignable polygon

· Number and Types of Employees for each Assignable Work Space (Military, US Direct Civilians, Other Civilians or Contractors)

2.5.7. GFEBS Updates and ePRISMS Comparison.

2.5.7.1. The Contractor shall assure real property data matches that which is identified during ePRISMS space surveys . The Contractor shall update and maintain the real property database of record (GFEBS). The Contractor shall update GFEBS for every real property survey inspection date(s) and PN values.

2.5.7.2. The Contractor shall ensure the GFEBS/HQIIS real property module (pooled space and rental space fields) match the facility architectural floor plan, and ePRISMS database. If any discrepancy exists, the contractor shall remedy any errors by re-validating the architectural floor plan and updating all requisite database backed with source documentation.

2.5.7.3. Real Property Documentation Updates.

2.5.7.3.1. The Contractor shall prepare space assignment memorandums for all occupants of building which the contractor surveys. Space assignment memorandums are required for all sustainment ePRISMS surveys and new ePRISMS surveys. Space assignment memorandums shall be submitted to the installation RPAO for review and approval and filed in the installation Facility Information Folders. Based upon the assignment letter and ePRISMS survey – GFEBS shall be updated to reflect the most current space assignment and ePRISMS survey (all data should match).

2.5.7.4. Real Property Reconciliation Report.

2.5.7.4.1. The Contractor shall tabulate space measured and analyzed in floor plan development for each facility by building number with category code and UIC. The tabulation should also include requirements for facilities and current existing building SF assets from the Installation’s Real Property Report for comparison of what is on record to what was measured in the field by the Contractor team. From this comparison, the Contractor shall produce a report that identifies where building asset information for the Installation is incorrect or absent. This report will be used by the Installation RPAO and the Installation Master Planner to improve the data quality within their real property records and ASIP for more accurate facility planning and management.

2.5.1.4.2 The Contractor shall conduct a yearly project briefing at the installation. The presentation shall be PowerPoint and summarize the data, findings and real property reconciliation report.

3.0 GIS Support

3.1. The Contractor shall provide services for the collection, production, analysis, dissemination and maintenance of consistent and accurate, installation geospatial data and products, which includes both GIS and Computer Aided Design and Drafting (CADD); in support of the installation management mission.

3.2. The Contractor shall provide all personnel, equipment, supplies, facilities, transportation, tools, materials, supervision, and other items and non-personal services necessary to perform geospatial information systems support, as defined in this Performance Work Statement (PWS), except for those items specified as government furnished property and services. The Contractor shall perform in accordance with (IAW) the terms and conditions of the contract and consistently with the established standards in this PWS and contract.

3.3. Geospatial Data Layer Creation and Maintenance.

3.3.1. The Contractor shall create and maintain geospatial information. The geospatial data layers are identified in the attachment, Installation Geospatial Data Layer Inventory.

3.3.2. All geospatial data layer creation and updates shall be maintained locally and uploaded to OACSIM IGI&S geospatial data repository quarterly.

3.3.3. The contractor shall provide services specific to geospatial data. Work shall include, but not be limited to: (1) Conversion of existing geospatial data from various raster or vector formats (e.g., different CADD or GIS digital formats) to the Government provided data standard; (2) Conversion of existing paper maps, drawings or images to digital vector file formats (through scanning and heads-up digitizing); and (3) Geospatial data acquisition through the use of Global Positioning System (GPS) technology. All delivered digital geospatial data files shall conform to the established QAPs.

3.3.4. The contractor shall maintain the existing geospatial data layers to include, but not limited to; Buildings, Structures, utilities, other linear elements, and signs. The contractor shall keep these layers compliant with the latest Spatial Data Standards for Facilities, Infrastructure, and Environment (SDSFIE) version. If the data layer does not currently exist the contractor shall coordinate with the Installation directorates and/or other local or national entities (e.g. Federal, State and County government, Municipalities, and/or Utility providers) for existing geospatial data, which includes GIS and/or CADD drawings, before developing or creating the geospatial data layer.

3.3.4.1 The contactor shall maintain geospatial data layers as outlined in the appropriate QAP. Geospatial data metrics shall be applied to, but is not limited to:

· The addition, deletion, or modification of geospatial data and features in existing layers

· The performance of Quality Control (QC) steps for maintaining the spatial accuracy of new and existing data (i.e. clean, eliminate overshoots/undershoots, sliver polygons and other similar anomalies)

· Validation that geospatial data meets SDSFIE and Federal Geographic Data Committee (FGDC) standards.

· Submit data to the Government for QA prior to uploading to OACSIM IGI&S.

· Review Quarterly IMCOM Dta review results and perform all deficiencies are addressed.

3.3.4.2 Geospational Data Layer Invetory and Deconsolidation for Utilities, Linear Elements, and Signs

3.3.4.2.1 Communications. The contractor shall compare, verify, and update all communications geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall correct and deconsolidate all geospatial data communications layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, and structure. The contractor shall field verify all communications data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the Garrison’s Signal Command and their contractors to acquire and update communications layers and deconflict any discrepancies with historic data. The contractor shall validate, veridy, add, correct, update, maintain, and delete all communications geospatial data layers to include, but not limited to;

· CommUtilitySegment_L

· UtilityFeature_CommDuctBank_L

· UtilityFeature_CommManhole_P

· SupportStructure_UtilityPole_P

3.3.4.2.2 Electrical Utilities. The contractor shall compare, verify, and update all electrical geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all electrical geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all electrical data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the electrical utility privatization contractor and the designated government utilities representative for each site to acquire and update electrical geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all electrical geospatial data layers to include, but not limited to

· ElectricalUtilityNode_ArfldLgt_P

· ElectricalUtilityNode_ExterLgt_P

· ElectricalUtilityNode_Meter_P

· ElectricalUtilityNode_P

· ElectricalUtilityNode_Substatn_P

· ElectricalUtilityNode_Switch_P

· ElectricalUtilityNode_Xformer_P

· ElectricalUtilitySegment_L

· UtilityFeature_ElecDuctBank_L

· UtilityFeature_ElecJunction_P

3.3.4.2.3 Natural Gas Utilities. The contractor shall compare, verify, and update all natural gas geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all natural gas geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all natural gas data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the natural gas utility privatization contractor and the designated government utilities representative for each site to acquire and update natural gas geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all natural gas geospatial data layers to include, but not limited to

· GasUtilityNode_Fitting_P

· GasUtilityNode_Meter_P

· GasUtilityNode_Regulator_P

· GasUtilityNode_Tank_P

· GasUtilityNode_Valve_P

· GasUtilitySegment_L

· UtilityFeature_GasManhole_P

3.3.4.2.4 Stormwater Utilities. The contractor shall compare, verify, and update all stormwater geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all storwater geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all stormwater data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the designated government utilities representative for each site to acquire and update stormwater geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all stormwater geospatial data layers to include, but not limited to

· StormwaterUtilityNode_Area_A

· StormwaterUtilityNode_Dischrge_P

· StormwaterUtilityNode_Dwnspout_P

· StormwaterUtilityNode_Fitting_P

· StormwaterUtilityNode_Inlet_P

· StormwaterUtilityNode_P

· StormwaterUtilitySegment_Clvrt_L

· StormwaterUtilitySegment_Hdwll_L

· StormwaterUtilitySegment_L

· StormwaterUtilitySegment_OpnDn_L

· UtilityFeature_SWJunction_P

3.3.4.2.5 Thermal Utilities. The contractor shall compare, verify, and update all thermal geospatial utilities datasets and layers to include steam, hot water, cold water and condensation lines and vaults for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all thermal utilities geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all thermal utilities data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the the designated government utilities representative for each site to acquire and update thermal utilities geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all thermal utilities geospatial data layers to include, but not limited to

· ThermalUtilityNode_P

· ThermalUtilitySegment_L

3.3.4.2.6 Waste Water Utilities. The contractor shall compare, verify, and update all waste water geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all waste water geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all waste water data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the utility privatization contractor and the designated government utilities representative for each site to acquire and update waste water geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all waste water geospatial data layers to include, but not limited to

· UtilityFeature_WWJunction_P

· WastewaterUtilityNode_Fitting_P

· WastewaterUtilityNode_P

· WastewaterUtilityNode_PmpEjtSn_P

· WastewaterUtilityNode_Valve_P

· WastewaterUtilitySegment_L

3.3.4.2.7 Water Utilities. The contractor shall compare, verify, and update all water utilities geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all water utilities geospatial datasets and layers to accurately reflect the existing location of each feature, segment, node, and structure. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment, feature, node, and structure. The contractor shall field verify all water utilities data layers using contractor furnished GPS data collecting equipment. The contractor shall coordinate with the utilities privatization contractor for water utilities and the designated government utilities representative for each site to acquire and update water utilities geospatial data layers and deconflict any discrepancies with historic data. The contractor shall validate, verify, add, correct, update, maintain, and delete all water utilities geospatial data layers to include, but not limited to

· UtilityFeature_WaterManhole_P

· WaterUtilityNode_Fitting_P

· WaterUtilityNode_Hydrant_P

· WaterUtilityNode_Meter_P

· WaterUtilityNode_P

· WaterUtilityNode_TreatmentPlnt_P

· WaterUtilityNode_Valve_P

· WaterUtilitySegment_L

3.3.4.2.8 Fence, Wall and Gates. The contractor shall compare, verify, and update all fence, wall, and gate geospatial datasets and layers for all Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and deconsolidate all fence, wall, and gate geospatial datasets and layers to accurately reflect the existing location of each asset. The contractor’s updated, corrected, and deconsolidated layers shall not deviate greater than one meter from the existing location of each segment of fence, wall, and gate. The contractor shall field verify the location of all fence, wall, and gate data layers using contractor furnished GPS data collecting equipment.

3.3.4.2.9 Signs. The contractor shall compare, verify, and update all geospatial datasets and layers for all signs at Aberdeen Proving Ground installation sites. The contractor shall maintain, correct and update all sign geospatial datasets and layers to accurately reflect the existing location of each sign. The contractor’s updated and corrected layers shall not deviate greater than one meter from the existing location of each sign. The contractor shall field verify all signs location.

3.3.5 Any geospatial field data collection process must be coordinated with the Government COR. The geospatial data layer must conform to the QAP. All Non-nullable attributes must be correctly populated. If there is no QAP, the contractor shall work with the subject matter expert to create a QAP for layers to be actively maintained. The contractor shall incorporate data layers provided as a result of installation construction (i.e., as-built drawings, CADD files and GIS layers) or any other activity that provides geospatial data for the Installation geospatial data layers. The contractor shall provide all geospatial data to the IGI&S Manager and the Installation GIS repository in accordance with the required geospatial data and security requirements.

3.3.6 The contractor shall be fully proficient in the use and application of common GIS software, specifically Esri Arc GIS Pro version 3.x,…