Document Sample
End_to_End__E2E__Actionable_Intelligence_System__E2E-AIS_ Powered By Docstoc
					      End to End (E2E) Actionable Intelligence System (E2E-AIS)

                                      United States Marine Corps
                                    Marine Corps Logistics Command
                                    Distribution Management Center
                                     814 Radford Blvd STE 20250
                                        Albany, Ga 31704-20250

      NOTE: USTRANSCOM decided not to fund this as a FY12 project.

                       End to End (E2E) Actionable Intelligence System (E2E-AIS)
                                Period of performance: FY 2012 - FY2017
                                       Estimated Cost: $9,600,000

Technical POC:   Gary L. Luce
                       Director, Capacity Management Div.,
                       Enterprise Distribution Department
                       Distribution Management Center
                       Marine Corps Logistics Command
                       Albany, GA 31704
                       TEL: 229-639-8338
                       FAX: 229-639-7583

Contracting POC: Larry Pendley
                        Director, Contracting
                        Marine Corps Logistics Command
                        Albany, GA 31704
                        TEL: 229-639-6764

                                               Page 1 of 13
       End to End (E2E) Actionable Intelligence System (E2E-AIS)

1. General Project Summary:

a. Marine Corps Logistics Command envisions a web-browser providing Total Asset Visibility (TAV) including
integration of Time Definite Movement Plans (TDMP), In-transit Visibility (ITV) at asset level with rollup reports
by attributes and nodal management with dwell time monitoring and automatic exception alerts utilized to improve
systemic velocity issues.

While the current proposal bears the title E2E-AIS, it is recognized that this naming convention invites some
misconceptions. It is our intent to re-brand if awarded. For continuity on this effort, E2E-AIS shall be maintained.

In testimony before the House Armed Services Committee Subcommittee on Readiness United States House of
Representatives Regarding Logistics, March 30, 2004 BG Edward G. Usher III Director Logistics Plans, Policies
and Strategic Mobility United States Marine Corps stated “One of our greatest challenges during OIF was visibility
of materials and supplies in distribution”.

As recent initiatives to mitigate those challenges have led to the implementation of RFID, and as more systems/tools
are employed to read those tags, and as Distribution teams with "interrogators" are established at key nodes in
theater, full integration into the End-to-End (E2E) distribution process to achieve visibility is still wanting as the
systems employed are standalone and do not communicate horizontally. Great effort is required to provide the basic
of visibility for targeted assets. In order to obtain enterprise visibility from E2E for both Fielding, Sustainment and
Reset and Retrograde (R2), an asset tracking capability is required to maintain accountability of all equipment from
the establishment of an asset plan, initial entry, for both inbound and outbound movements, into the distribution
pipeline (road/rail/surface/air), and to the final destination. To obtain that visibility, E2E-AIS will pull data from all
available sources (Automated Systems, spreadsheets, and manual input) and integrate with a time definite plan and
exception management process which enhances the context of visibility to provide an accurate distribution Common
Operating Picture (COP). This capability does not currently exist, resulting in unsynchronized and sub-optimized
distribution support to the warfighter.

Marine Corps Logistics Command (MARCORLOGCOM) Distribution Management Center (DMC) is requesting
the creation of a web-based equipment tracking system (E2E-AIS) that will leverage current visibility efforts to
provide movement visibility at the asset level with rollup reports by various attributes. E2E-AIS shall provide
distribution planning and nodal management capability as well as to manage/track exceptions or specific missions.
The completion of E2E-AIS is important to support the readiness of fleet operations and the decision making
processes regarding resetting the force, workload allocation and capital investments. In attempting to meet visibility
requirements, DMC has developed a local MS Access program “Tracker”(see Appendix 1.3) which pulls data from
disparate enterprise systems and spreadsheets. This tool was successful in a limited way in providing a means to
locate equipment in a timely manner when others across the enterprise could not locate critical gear. This was
mainly accomplished by providing a matching matrix capability to re-link data that was lost or disconnected when
passing through a node or from one agency to another. The limitation of this tool was soon realized due to one user
at a time access, bandwidth, and computing power. While the concept proved itself, DMC did not have the
resources to maintain it and realized that a more powerful tool was needed. DMC would leverage lessons learned in
building the “Tracker” to develop E2E-AIS (See Appendix 1.4,5,6).

Both Transportation/Distribution Planning and Execution are integral areas because these capabilities are tied to
over 60% of the LOG IT gaps (Appendix 1.1,1.2) which shall continue if this capability is not realized. E2E-AIS
(Appendix 1.4,5,6) addresses closing the gaps to some degree for several critical USTRANSCOM Joint Deployment
Distribution Enterprise capabilities including: Total Asset Visibility (TAV); Distribution Planning and Forecasting;
Requisition Priorities; Process Management and Business Rules; Distribution Performance Metrics Strategy;
Container Management; and Supply Chain Simulation Tools.

The Distribution Planning aspect of E2E-AIS provides a workflow process where a using units requisition will:
    1. Create a transaction for the specific organization that manages the wholesale stock;
    2. Provide the organization with planning capabilities to satisfy the requisition from picking, packing, to
        requesting forward movement;
    3. Associate organic resources to plan the actions of picking, issuing, and distributing activities of that
        requisition i.e. people, tools, containers, boxes, etc…
                                                       Page 2 of 13
         End to End (E2E) Actionable Intelligence System (E2E-AIS)

    4.   Transmit a movement transaction to TRANSCOM to initiate shipping requirements of assets whether to a
         Consolidation and Containerization Point (CCP) or to a Port of Embarkation (POE). Upon confirmed
         movement transaction return from the TRANSCOM system, workflow management tool will run the
         appropriate metrics to determine if organic resources or contracted shipper services are available to deliver
         assets to the CCP or POE on time to meet the forward movement approval;
    5.   In-Transit transactions will feed the tool to monitor execution against the plan in order to initiate any
         workflow exception transactions.

The Distribution Planning aspect of E2E-AIS will need to have the following capability sets, this list is not all
     1. Financial: Contain lines of accounting for the various financial requirements to manage distribution
     2. Contract Services: Ability to record organizations and contracting information that the wholesale
         organization utilizes to perform wholesale and distribution activities
     3. Asset: Manages the wholesale assets maintained by the organization satisfying the requisition
     4. People: Manages organic personnel with appropriate skill sets to handle and move assets
     5. Tools: Manages organic tool used locally at the organic unit to distribute assets i.e. packaging material, fork
         lifts, petroleum oil and lubricants (POL)
     6. Maintenance: Manages the work performed on an asset to prep it for shipment
     7. Planning: Ability to plan all activities against a work order
     8. Routing: Store Route information to associate to a plan
     9. Scheduling: Ability to request forward movement from contracted shipper and TRANSCOM
     10. Workflow: Manages the movement of a requirement transaction from inception to completion i.e.
         Requisition, Planning, Picking, Packing, Scheduling, Tracking, Closing
     11. Geospatial: Associating workflow, Automated Identification Data Collection, Asset Current Location to a
         geographic location to monitor movement of assets. Geospatial tool needs to allow managers various
         views and functionality to see assets in a green, yellow, red status based on business rules and restrictions.
     12. Dashboard: Available at the user level to monitor the workflow process.

b. In addition to DMC’s experience in identifying and developing methods to matrix data across nodes to maintain
in-transit visibility, it is recognized that in order to take this effort to the next level, there will be a need to tap
additional technologies such as Work Flow Management tools, Geospatial, and Transportation
Optimization/Simulation Models such as Simplex or QSB (Quantitative Systems for Business).

c. List of systems that would interface with E2E-AIS and is in no way meant to be all inclusive:

         AV: DLA – Asset Visibility
         Birdtrack: NAVY
         BCS3-NM: USA - BCS3-Node Management.
         DTTS: TRANSCOM - Defense Transportation Tracking System
         FACTS: Naval Supply Information System Activity - Financial and Air Clearance Transportation System
         ICODES: TRANSCOM - Integrated Computerized Deployment System
         ILF: USMC: Item Locater File
         IRRIS: SDDC - Intelligent Road/Rail Information Server
         iSDDC: USTRANSCOM’s Integrated Surface Deployment Data Cleansing Tool
         (JFRG II): USJFCOM - Joint Force Requirements Generator
         MERIT: USMC - Equipment Readiness Information Tool
         MDSS-II: USMC - MAGTF Deployment Support System
         MOWASP: USMC- Mechanization of Warehousing and Shipping Procedures
         RF-ITV: USA - Radio Frequency In-Transit Visibility System,
                                                        Page 3 of 13
       End to End (E2E) Actionable Intelligence System (E2E-AIS)

         SASSY: USMC - Supported Activities Supply System (To be replaced by GCCS-MC)
         SCS: USMC/USAF - Stock Control System
         SMS: TRANSCOM - Single Mobility System:
         STS: Serial Tracking System
         WSF: USMC – Weapons Serial File

2. Requirements Traceability: Refer to Appendix 1.1 and 1.2. As you can see by the charts, the USMC MAGTF
Gap Lists (MGL) identifies major capability gaps in integrated E2E visibility of distribution information as well as
route, schedule, and distribution planning capability with little or no ability for predictive analysis or exception
management. E2E-AIS further seeks to satisfy Time Definite Delivery requirements under DoD Directive 4140.1-
R "Materiel Management Regulation".

3. Project Suitability:

a. While the request and focus is on solving a problem for the Marine Corps, it is felt that the difficulties mentioned
above with E2E visibility is experienced by each agency involved with global distribution of assets and material,
and as such E2E-AIS would be general in terminology to be applicable to the Joint Deployment Distribution

b. There are numerous, mature but disparate, systems providing portions of the data required. What is missing is an
enterprise application which combines data from these systems, provide some computations and presents the data in
a manner which is actionable, providing the user with the ability to perform predictive analysis, planning or
exception management. Upon Full Operational Capability, E2E-AIS will be at TRL9.

c. While several entities have launched initiatives, including USTC, to provide improved In-Transit Visibility (ITV)
or Total Asset Visibility (TAV), none are known to link visibility efforts to transportation/distribution plans in order
to provide actionable event management. DMC intends to leverage accomplishments achieved on visibility by
USTC and others as a foundation or building block for a time definite structured approach. From there an exception
management process can be created which enhances the context of visibility to provide an accurate distribution COP
which is a common problem across DoD.

4. Return on Investment, Affordability, and Business Case:

a. Assumptions: In order to achieve the benefits of implementing E2E-AIS, it is assumed that:

    1. Required Interface Control Documents (ICD’s) are realized with other Systems of Record to capture
       required data feeds.
    2. ROI will be similar to what has been reported by private sector companies implementing similar efforts
    3. Efficiencies will be achieved by identifying and generating exceptions through automated actionable
       analyses reducing the need of utilizing human capital to perform such analyses.
    4. Infrastructure exist/can be established to host the tool.
    5. Organizations are flexible to adopt built in business process rules of the COTS product wherever possible
       thus reducing cost for customization.
    6. E2E-AIS will be able to operate in an austere environment with the ability to perform required functions in a
       disconnected stand-alone environment with the ability to connect and update the enterprise.

b. Evaluation of Alternatives: see “d” below.

                                                       Page 4 of 13
         End to End (E2E) Actionable Intelligence System (E2E-AIS)

c. Business Case for Implementation/ROI: If fielded, the capability generated by this investment shall reduce
the time and effort of the Enterprise to search for and expedite lost or overdue equipment by as much as 40%. In
OIF, it has been estimated that 25% of material/supplies were duplicate orders due to late/no delivery status caused
by lack of E2E visibility of the supply/distribution chain. Additional benefits expected from E2E-AIS are:

    1.   Reduction in misidentification/loss of material
    2.   Improvement in expected material arrival dates
    3.   Improvements in configuration management
    4.   Increased capability in reliability tracking
    5.   Improvements in repair turn around time tracking
    6.   Improvements in repair and repair material planning
    7.   Reduction of carcass tracking thresholds
    8.   Improved efficiency in supply document reconciliation

d. Applicability to Industrial Practices and Partnerships: There are several Commercial Off The Shelf (COTS)
systems that are available and being utilized by commercial industry in some form to support or solve transportation
and distribution problems. It would be the intent of this project to leverage those known and presently unknown
products to fill and integrate certain elements as seen appropriate. One such example which may or may not be
pursued is Arclogistics-Navigator utilized by FEDEX to monitor and manage their ground transportation fleet for
intransit visibility, event management, and route optimization. This system employs the seamless integration of GIS
and transportation software. Any utilization of such tools would require some “tweaking” to be useful in support of
the warfighter. Development work and integration of systems for E2E-AIS will be contracted to one or more
appropriate institutions having the knowledge and skills in DoD Supply, Distribution, and Transportation Systems.
Additionally, it is anticipated that USTC would work with DMC as functional on visibility.

5. Technical Merit and Maturity:

a. Technology advancement and partnering among private sector organizations such as IBM and ESRI have
streamlined an organizations ability to succeed in enterprise asset management (EAM) including what could be
considered Asset End to End Actionable Intelligence. For example, MAXIMO a leading IBM enterprise asset
management product provides an organization’s ability to seamlessly manage their resources. By partnering with
ESRI and their leading geographic information system (GIS) products, organizations can now (1) geoprocess,
goefence, geocode, and geoalert based on data from EAM databases, (2) assess the common operating picture
presented, and (3) act upon what is presented. The interface eliminates redundancies of storing data thus allowing
the EAM and GIS views to be virtually real-time. Future releases of MAXIMO 7.1 Spatial R3 and future will
enhance the capabilities to initiate events geospatially.

Risks: The risk of these technologies consists of changing technologies and IT hardware and getting through the
accreditation process to connect. To mitigate those risks, leveraging existing programs of record utilizing these
COTS products would improve the accreditation and reduce the number of platforms for which personnel must be
trained. Department of the Navy at Marine Corps and Navy bases and stations have already implemented GIS and
MAXIMO technology to manage their fixed and mobile assets, personnel, tools, finance, contract services and other
business processes into a seamless integrated EAM and Geospatial tools. Consistent coordination with these
programs as they mature would ensure harmonious implementation of IT in garrison and in austere environments.
Allowing push/pull among these programs in garrison will reduce redundancies of data entry and automated
identification data capturing (AIDC)

b. Expertise: IBM and third party MAXIMO/GIS developers exist with expertise in both DoD and Private Sector
Total Asset Visibility/Management initiatives. Lessons learned from private sector projects will improve the
success rate in implementing these initiatives within DoD. The Marine Corps also has subject matter experts
familiar with Enterprise Asset Management, Geographical Information Systems, and Automated Identification Data
Collection through the various programs of record USMCMax, GeoFidelis, and Global Combat Support System –
Marine Corps(GCSS-MC).

                                                     Page 5 of 13
         End to End (E2E) Actionable Intelligence System (E2E-AIS)

6. Programmatics:

6.1 The following list of deliverables is a compilation of E2E-AIS requirements:

    1.    Web-based with Single sign-on CAC card
    2.    Ability to integrate with / to GCSS-MC
    3.    Asset Time Definite Distribution Plan and Plan Attainment
          3.1. Distribution Plan, Execution Status of Plan, Variance to Plan
    4.    Require visibility of Strategic Transportation Plans (phase II)
          4.1. Forecast Future Operations – (Adaptive Planning).
          4.2. Movement Flow Demand (What if scenarios, comparative planning)
          4.3. Planning info – need to plan in advance how to move equipment - demand received
          4.4. Commit to Mode - Customer RDD, Cost, and Capacity of Systems
          4.5. Ability to enable a Recovery Plan
          4.6. Identify planned equipment quantities to be sourced
          4.7. Equipment that has been sourced
    5.    Automatic notification of event variance
    6.     Exception Management Capability
    7.    Dashboard with nodal performance (Visual Alert for Cargo beyond Std Dwell Time)
          7.1. Calculate average node time
          7.2. Capture the minimum and maximum node time
          7.3. Capture the difference of maximum node time and actual dwell time
          7.4. Display difference of actual dwell time over maximum node time
          7.5. Equipment at each node
          7.6. Node Dwell Time
          7.7. Percentage of equipment that has gone through each node within target dwell time
          7.8. Calculate equipment percentage flowing through each node
          7.9. Capture and Display tonnage and personnel velocity for each node
          7.10. Identify equipment shipped from a node
          7.11. Equipment currently on-hand at each location
          7.12. Display number of items currently held by Marine Forces in Theater
          7.13. Report date that items arrived/departed from each node
    8.    Capture Enterprise Distribution System Metrics
          8.1. Intermodal Distribution Lane (IDL) Performance
          8.2. Required Delivery Date (RDD) Performance
          8.3. On Time Delivery without damage
          8.4. Time Definite Service
          8.5. Customer Wait Time
    9.    Cross matrix to establish relationships to mitigate transposition/syntax errors thru a node.
          9.1. Capability to cross reference important data elements (i.e. TCN's, Document numbers, container
                 #(s), serial #(s), etc.).
          9.2. Must include movement of data from wholesale to retail to warfighter.
    10.   Track serialized assets
    11.   Track containers to line item (level 6) detail
    12.   Track relationships between sub-components and major end items
    13.   Visually track items as they move from location to location (spatial front-end)
    14.   Automated tracking of TPFDD'd items shipped from CONUS to OCONUS
          14.1. Cross reference original MRO Doc/TCN with ULN based TCN.
    15.   Drill-Down with workflow capability to provide various users more detailed information
    16.   Ability for AIT integration
    17.   Ability to deploy off-line
    18.   Ability to Drill-Down to Q/A inspection records
    19.   Capture cost of maintenance and actions performed to the equipment by serial number
    20.   Track maintenance on assets in temporary or extended storage. (Conus / Oconus)
    21.   Ability to import/export information
    22.   Ability to develop tailored reports
                                                     Page 6 of 13
       End to End (E2E) Actionable Intelligence System (E2E-AIS)

6.2 Proposed schedule with phased funding:

                                                                       $1,658     $1,780

6.3 Project Management. The following is a sample boiler plate (not to be assumed complete) which will
provide the framework to establish the project management controls for E2E-AIS. It is the intent of DMC
to out source the project to the successful software integrator from the solicitation process. The contractor
shall establish strict program of control processes to ensure mitigation of risks and minimal schedule

6.3.1 Work Breakdown Structure (WBS) and Schedule. The contractor shall provide a draft schedule and
WBS within five (5) business days after the kickoff meeting. 8”x11” or 11”x17” paper is acceptable for the
draft WBS and schedule. The kickoff meeting shall take place within five (5) business days of contract
award. The WBS and schedule shall demonstrate the capability to provide competent resources within a
logical management framework to accomplish the scope of performance anticipated for the task support
areas. This WBS and schedule shall be incorporated into each of the tasks. Significant milestones and
delivery dates shall not be changed without the Government’s approval via contract modification.

6.3.2     Risk Management Plan (RMP). The contractor shall implement a risk management process, in
accordance with commercial best practices and documented in the contractor’s Risk Management Plan,
including tools that outline specific plans, efforts, and processes that shall be used to minimize the potential
for negative impact to the E2E-AIS project. Risk management is vital to effectively managing any large-
scale software effort because each software system being developed or maintained is dependent on a unique
set of changing factors. Risk identification and tracking, assessment and mitigation/contingency plans shall
be addressed at all In-Process Reviews.

6.3.3    Bi-Weekly Status Reports (BSR) and Project Status Maps (PSM). The contractor shall prepare
BSRs due by COB every other Thursday and provide weekly PSMs due by COB Tuesday. Each BSR shall
cover accomplishments, status of deliverables, planned activities for the next reporting period, and any
other items that need the Government’s attention. The final format for the BSR shall be coordinated
between the E2E-AIS project manager and the contractor’s project manager.

6.3.4    Solution Design. The contractor(s) shall provide a solution design. This task has three parts: (1)
Analysis and Assessments; (2) Requirements and Solution; and (3) Evaluation, Software Selection and
Final Solution Design. Final solution must be compliant with the Navy/Marine Corps Intranet (NMCI) and
DoD IA regulations.

6.3.5     Baseline Process and Systems Assessment
The contractor(s) shall conduct a baseline assessment of the business processes. Activities shall include
interviews with MARCORLOGCOM, DMC logistics operations personnel to determine current processes
and workflows that will be affected by the E2E-AIS solutions. The contractor shall identify the baseline
business processes supported by the E2E-AIS solutions and provide recommendations and documentation
of the architectural requirements.

                                                       Page 7 of 13
       End to End (E2E) Actionable Intelligence System (E2E-AIS)

6.3.6     Requirements and Solution Planning
The contractor(s) shall conduct the requisite implementation planning to ensure that the solution meets
specific operational requirements for improving existing business processes and enhancing war fighting
capabilities. Specific operational requirements shall be refined through frequent contractor meetings (in
person, via email, via phone) with the government to determine how the government wishes to implement
E2E-AIS capabilities within their business process. Key personnel from government agencies shall be
included in this collaborative planning process with the contractor (the list of key personnel will be
coordinated by and with the E2E-AIS Project Manager). The contractor shall identify and provide
recommendations and documentation of requirements supporting the E2E-AIS processes, its design, the
system requirements, and solutions.

6.3.7    Final Solution Design
Based on the requirements and solution planning the contractor shall work with the E2E-AIS Project
Manager to design the total solution and resolve outstanding questions or issues. The contractor shall
provide recommendations and documentation of the final software options.

6.3.8    Build & Deploy: Configuration, Deployment, Certification and Training
The contractor shall develop, implement, and sustain E2E-AIS solution system in Albany, GA. The
contractor shall also integrate required data elements with existing legacy systems that will ensure
modularity into future systems, such as GCSS-XX. The final recommendation shall be documented and
delivered to the government before deployment, certification and training. The government will work with
the contractor for local and enterprise certification of the system to operate on the Marine Corps Enterprise
Network/Navy Marine Corps Internet (MCEN/NMCI). Configuration and testing of the systems shall be
conducted by the contractor and the government before final acceptance and installation. ATC (Authority
to Connect) and ATO (Authority to Operate) should be taken into consideration when dealing with a
government to contract proposal.

6.3.9    Training
The contractor shall conduct user training sessions as directed by the E2E-AIS project manager. The
contractor shall deliver training at or near the time when deployment occurs for each organization. The
contractor shall also provide detailed electronic user manuals along with online simulations; the quantity of
user manuals TBD by the Government. Training shall be conducted at sites TBD.

                                                      Page 8 of 13
      End to End (E2E) Actionable Intelligence System (E2E-AIS)

6.2 Proposed high-level simplistic project schedule with major deliverables:

                                                  Page 9 of 13
       End to End (E2E) Actionable Intelligence System (E2E-AIS)

b. Prior expended and requested funding for the RDT&E effort in then-year thousands. N/A

c. Team of experts which will be dedicated to conducting project technical/management activities, citing prior
experience and qualifications. The Distribution Management Center serves as the Distribution Process Owner for the
United States Marine Corps. In such, DMC is staffed with experts in Storage, Distribution and Transportation
disciplines as well as project management and systems analysis providing the foundation to manage the
development and implementation of E2E-AIS.

e. Performance metrics:
     6.1. Dashboard with nodal performance (Visual Alert for Cargo beyond Std Dwell Time)
     6.2. Ability to create: Distribution Plan, Execution Status of Plan, Variance to Plan
     6.3. Display Asset Time Definite Distribution Plan and Attainment of that Plan
     6.4. Provide automatic notification of event variance
     6.5. Demonstrate cross matrix to establish relationships to mitigate transposition/syntax errors thru a node.
          (key - must have). Capability to cross reference important data elements (i.e. TCN's, Document numbers,
          container #(s), serial #(s), etc.).
     6.6. Ability to deploy off-line
     6.7. Visually track items as they move from location to location (spatial front-end)

7. Technology Transition Planning:

a. It is fully anticipated that upon Full Operational Capability, including Information Assurance compliance
requirements, that ownership shall be transferred to the appropriate organization of USTC for sustainment. If
awarded, a plan shall be mutually developed with USTC for transfer of technology and intellectual property as
deemed appropriate.

b. Organization(s) and address/point of contact to which project funds, once approved, should be forwarded for
management/execution of technology proposal.

Contracting POC:          Larry Pendley
                          Director, Contracting
                          Marine Corps Logistics Command
                          Albany, GA 31704
                          TEL: 229-639-6764

                                                    Page 10 of 13
      End to End (E2E) Actionable Intelligence System (E2E-AIS)

8. Appendix 1:

                                   MAGTF LOG IT CAPABILITY GAPS
                                            APPENDIX 1.1

                 • Most stakeholders achieve some visibility from pulling from GTN, SMS etc.
                 to spreadsheets

                 • Little or no analytical capability exists to optimize distribution channels
                 • Little or no capability to measure variance against a Distribution Plan.
                                         MAGTF CAPABILITY GAPS
                                               APPENDIX 1.2
                                                  Page 11 of 13
     End to End (E2E) Actionable Intelligence System (E2E-AIS)

        EDL                                                      In-Transit
       Equipment                         In-Process
      Density Listing
        MS Excel
                                                                     DLA              SMS                  GTN
                                                                    Bill of Lading                       Transportation
              In-Storage                                            Manual entry      Manifest
TAMCN                                                                                                        Data
                                                                     MS Excel         Server
                                  MRO           MDSSII                    ASSET ID
                                   Tracker                                DOC NUM         TCN                       TCN
SOURCE                                            Tracker
                                 Requisitions                                             VDN
                   SCS           MS Access      Requisitions              STOCK NUM
                                                                          QTY             PCFN
                 Requisitions                       dbf                                   POE
                                                                          TCN                                       LAST KNOWN
                 Mainframe                             ASSET ID           LEAD TCN        POD                       SOURCE
ACAMS                                  DOC#            UIC                GBL             RF TAG                    DATES
 Container              DOC#           SUFFIX          PACKAGE ID                         SAIL DATE                 SOURCE
Management              SUFFIX         NSN             PARENT ACKAGE ID                   DATES
                        NSN            SERIAL          ITEM ID
                        QTY            #               TCN
                        STATUS         QTY             REF TAG

                                                                   TRACKER                                               NODE
                                                                                                                           MS Excel

             MDR                                                                                                     TCN
                                                               TABULAR                                               DATES

                                                                 DMC’s Tracker
                                                                 APPENDIX 1.3

        EDL                                                      In-Transit
       Equipment                         In-Process
      Density Listing
        MS Excel
                                                                     DLA                              GTN                NODE
                                                                    Bill of Lading    SMS           Transportation         SITREPS
              In-Storage                                            Manual entry      Manifest          Data               MS Excel
                                                                     MS Excel         Server            Web
                                  MRO           MDSSII                    ASSET ID     Export         Extraction           TCN
SOURCE                             Tracker                                DOC NUM         TCN               TCN            CONTAINER
                                 Requisitions     Tracker                                 VDN                              NUM
                   SCS           MS Access      Requisitions              STOCK NUM
                                                                          QTY             PCFN
                                                                                                            NUM            SERIAL
                 Requisitions                       dbf                                   POE
                                                                          TCN                               LAST KNOWN     STATUS
                 Mainframe                             ASSET ID                           POD               SOURCE         DATES
ACAMS                                                                     LEAD TCN
                                       DOC#            UIC                                RF TAG            DATES
 Container                                                                GBL
                        DOC#           SUFFIX          PACKAGE ID                         SAIL DATE         SOURCE
Management              SUFFIX         NSN             PARENT ACKAGE ID                   DATES
                        NSN            SERIAL          ITEM ID
                        QTY            #               TCN
                        STATUS         QTY             REF TAG                                                    EDL’s, Nodes
                                                                                                 Standards        Std Node Dwell
                                                                    E2E-AIS                                       Time Definite Std
                                                                Integrated Database
             MDR                                                                                                 Transportation Netwrk
                                                                                                                  Mode and Carrier
                                                                                                                  Business Rules
                              TABULAR                                                                             Alert Level
                        REPORTS/SPREADSHEETS                                                                      Workflow rules
                                                                                              Work Flow           Import/Export
                                                                                                                  Create/Update status

                                                      E2E Actionable Intelligence System
                                                               APPENDIX 1.4

                                                                    Page 12 of 13
    End to End (E2E) Actionable Intelligence System (E2E-AIS)


            Systemic Improvements                     Metrics

               MARFORS & MDO                      Notification                   Event
Recovery Plan           DOC                                                     Web based
                                                                              Automated Event
                                             Exception Mgmt
                        DPAs                                                      Manager

  PLAN / Act / Var   Node 1       Node 2         Node 3       Node 4      Node n       STATUS

  PLAN / Act / Var   Node 1       Node 2         Node 3       Node 4      Node n       STATUS

  PLAN / Act / Var   Node 1       Node 2         Node 3       Node 4      Node n       STATUS

                              E2E Actionable Intelligence System
                                       APPENDIX 1.5

                                                    Status: Excessive Dwell (6hrs)
                                                    Cause: Equipment Failure
                                                    Priority: Mission Critical
                                                    Action Required:
                                                             - Coordinate w/Carrier
                                                             - Re-plan
 Customs                 Equipment Failure                   - Notify Receiving Unit
 Nodal Dwell Time
           Tardy Arrival Time        Geo-Fencing            Plan Modification

                              E2E Actionable Intelligence System
                                       APPENDIX 1.6
                                          Page 13 of 13

Shared By: