; ALMIS_COTS_GOTS
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

ALMIS_COTS_GOTS

VIEWS: 8 PAGES: 98

  • pg 1
									                              EXECUTIVE SUMMARY
PURPOSE.

The U.S. Coast Guard is developing a single, integrated aviation logistics system—ALMIS
(Aviation Logistics Management Information System)—that incorporates the functionality of
existing legacy systems, provides for single source of data entry, and is ―open‖ to other U.S.
Coast Guard systems. The ALMIS end-state envisions five major areas of functionality:
Procurement, Finance, Supply, Maintenance and Flight Operations. This paper examines the
ability of each COTS/GOTS solution to fulfill specific functionality of the final ALMIS solution.

BACKGROUND.

Commercial and government organizations either have developed or are actively developing
applications whose functionality corresponds to ALMIS functional areas. In recent federal
acquisition initiatives, the Government has focused on the use of off-the-shelf products, where
practical. The motivation for the increased use of existing off-the-shelf products is that they may
provide for faster development and lower life cycle costs. Thus, it is in the best interest of the
ALMIS project to examine available products and incorporate the best mix of off-the-shelf and
custom developed products that optimize benefits and minimize risks over the ALMIS life cycle.
The following COTS/GOTS applications were evaluated: EAL, ACMS, AMMIS, LUFS-NT,
FLS, GOLD, Oracle U.S. Federal Financial Applications, Oracle Integrated Solutions, and
CMplus.

DISCUSSION.

From the analysis of COTS/GOTS products, it is clear that there is no easy answer or obviously
compelling solution. In general, COTS/GOTS solutions are difficult and have inherent risks. To
mitigate risks while simultaneously achieving the desired functionality, the Coast Guard should
position ALMIS in the same direction as other U.S. Coast Guard software development.

FCBS recommends future ALMIS development in Oracle RDBMS, and transitioning legacy
systems, EAL, ACMS, and AMMIS, to Oracle RDBMS on an appropriate transition schedule.
Moving ALMIS development to Oracle RDBMS will facilitate future integration/interoperability
with other U.S. Coast Guard systems and a wide range of Oracle Integrated Applications. FCBS
recommends prototyping Oracle Applications for ALMIS supply and financial functionality, and
interfacing LUFS-NT procurement capability into ALMIS.
                                           ARC-DO-160000.1R2
                                                     3-Jul-11

AVIATION LOGISTICS MANAGEMENT
      INFORMATION SYSTEM

      ARCHITECTURE DESIGN


     REVIEW OF COTS & GOTS



                 Prepared for:

             U.S. COAST GUARD
          OFFICE OF ENGINEERING
    AERONAUTICAL ENGINEERING DIVISION
         2100 SECOND STREET, S.W.
        WASHINGTON, DC 20593-0001




                 Prepared by:

         FC BUSINESS SYSTEMS, INC.
       5205 LEESBURG PIKE, SUITE 700
       FALLS CHURCH, VIRGINIA 22041



                 Prepared On:

               12 February 1999


       Contract No.: DTCG23-97-D-TAZ040
      Task Order No.: DTCG23-98-F-ACMS16
                 CDRL No.: A010
        Version No.: ARC-DO-160000.1R2




                      ii
                                     ARC-DO-160000.1R2
                                               3-Jul-11




This Page Intentionally Left Blank




               iii
                                                                                                           ARC-DO-160000.1R2
                                                                                                                     3-Jul-11
                                                TABLE OF CONTENTS

Section/Para.                                             Title                                                            Page

1.              INTRODUCTION ................................................................................... 1-1

1.1             Purpose..................................................................................................... 1-1
1.2             Scope ........................................................................................................ 1-1
1.3             Methodology ............................................................................................ 1-1
1.4             Background .............................................................................................. 1-2
1.5             Government Regulations and Obligations ............................................... 1-3
1.6             Development Issues ................................................................................. 1-4

2.              IDENTIFY POSSIBLE COTS/GOTS PRODUCTS ............................... 2-1

2.1             EAL .......................................................................................................... 2-1
2.2             ACMS ...................................................................................................... 2-1
2.3             AMMIS .................................................................................................... 2-1
2.4             LUFS-NT ................................................................................................. 2-1
2.5             FLS ........................................................................................................... 2-2
2.6             Government On Line Data (GOLD) ........................................................ 2-2
2.7             Oracle U.S. Federal Financials Applications ........................................... 2-3
2.7.1           Oracle U.S. Federal General Ledger ........................................................ 2-3
2.7.2           Oracle U.S. Federal Payables................................................................... 2-3
2.7.3           Oracle U.S. Federal Receivables ............................................................. 2-3
2.8             Oracle Integrated Solutions...................................................................... 2-3
2.8.1           Oracle Alert .............................................................................................. 2-4
2.8.2           Oracle Application for the Web ............................................................... 2-4
2.8.3           Oracle Assets ........................................................................................... 2-4
2.8.4           Oracle Bills of Material ........................................................................... 2-4
2.8.5           Oracle Capacity........................................................................................ 2-4
2.8.6           Oracle Cash Management ........................................................................ 2-4
2.8.7           Oracle Cost Management ......................................................................... 2-5
2.8.8           Oracle EDI Gateway ................................................................................ 2-5
2.8.9           Oracle Financial Analyzer ....................................................................... 2-5
2.8.10          Oracle Federal Human Resources ............................................................ 2-5
2.8.11          Oracle Inventory ...................................................................................... 2-5
2.8.12          Oracle Master Scheduling ........................................................................ 2-5
2.8.13          Oracle MPR (Manufacturing Resource Planning) ................................... 2-6
2.8.14          Oracle Personal Time and Expense ......................................................... 2-6
2.8.15          Oracle Project Costing ............................................................................. 2-6
2.8.16          Oracle U.S. Federal Purchasing ............................................................... 2-6
2.8.17          Oracle Quality .......................................................................................... 2-6
2.8.18          Oracle Supplier Scheduling ..................................................................... 2-6
2.8.19          Oracle Supply Chain Planning ................................................................. 2-6
2.8.20          Oracle Workflow ..................................................................................... 2-7



                                                                  iv
                                                                                                          ARC-DO-160000.1R2
                                                                                                                    3-Jul-11
                                        TABLE OF CONTENTS (Cont‘d)

Section/Para.                                            Title                                                           Page

2.8.21          Oracle Work in Process ........................................................................... 2-7
2.9             CMplus..................................................................................................... 2-7

3.              EVALUATION CRITERIA .................................................................... 3-1

3.1             Functionality ............................................................................................ 3-1
3.1.1           Procurement ............................................................................................. 3-1
3.1.1.1         AMMIS Procurement Functionality ........................................................ 3-2
3.1.1.2         LUFS-NT Procurement Functionality ..................................................... 3-2
3.1.1.3         FLS Procurement Functionality ............................................................... 3-3
3.1.1.4         GOLD Procurement Functionality........................................................... 3-3
3.1.1.5         Oracle Procurement Functionality ........................................................... 3-3
3.1.2           Finance ..................................................................................................... 3-3
3.1.2.1         AMMIS Finance Functionality ................................................................ 3-4
3.1.2.2         LUFS-NT Finance Functionality ............................................................. 3-5
3.1.2.3         FLS Finance Functionality ....................................................................... 3-5
3.1.2.4         Oracle Finance Functionality ................................................................... 3-5
3.1.3           Supply ...................................................................................................... 3-5
3.1.3.1         AMMIS Supply Functionality ................................................................. 3-6
3.1.3.2         LUFS-NT Supply Functionality .............................................................. 3-7
3.1.3.3         FLS, GOLD, CMplus, and Oracle Supply Functionality......................... 3-7
3.1.4           Scheduled Maintenance ........................................................................... 3-7
3.1.5           Flight Operations/EAL............................................................................. 3-8
3.2             Reliability/Maturity.................................................................................. 3-9
3.3             Portability............................................................................................... 3-10
3.3.1           Environment ........................................................................................... 3-11
3.3.1.1         Hardware ................................................................................................ 3-11
3.3.1.2         Operating Systems ................................................................................. 3-11
3.3.1.3         Communications and Object Management ............................................ 3-11
3.3.1.4         Communications .................................................................................... 3-12
3.3.1.5         Distributed Object Management ............................................................ 3-12
3.3.2           Relational Database Management System ............................................. 3-12
3.3.3           Client-Server Environment .................................................................... 3-13
3.4             Testability .............................................................................................. 3-13
3.5             Availability ............................................................................................ 3-13


4.              COST ....................................................................................................... 4-1

4.1             Cost Definitions and Impacts ................................................................... 4-1
4.1.1           Site Surveys ............................................................................................. 4-1
4.1.2           Acquisition/Licensing Costs .................................................................... 4-1



                                                                 v
                                                                                                         ARC-DO-160000.1R2
                                                                                                                   3-Jul-11
                                        TABLE OF CONTENTS (Cont‘d)

Section/Para.                                            Title                                                          Page

4.1.3           Development Costs .................................................................................. 4-1
4.1.4           Integration Costs ...................................................................................... 4-1
4.1.5           Documentation Costs ............................................................................... 4-2
4.1.6           Maintenance Costs ................................................................................... 4-2
4.1.7           Software Cost Estimation ....................................................................... 4-2
4.2             Relative Cost Table .................................................................................. 4-3
4.3             Initial – Short-Term Cost Impacts ........................................................... 4-3
4.3.1           GOLD ...................................................................................................... 4-3
4.3.2           Oracle Financials ..................................................................................... 4-4
4.3.3           Oracle Integrated Solution ....................................................................... 4-5

5.              RISKS ...................................................................................................... 5-1

5.1             Experience With COTS/GOTS Systems ................................................. 5-1
5.2             Interoperability and Maintainability ........................................................ 5-1
5.3             Availability .............................................................................................. 5-2

6.              CONCLUSIONS...................................................................................... 6-1

6.1             Benefits/Risks .......................................................................................... 6-1
6.2             Functionality ............................................................................................ 6-1
6.3             Risk Mitigation ........................................................................................ 6-1
6.4             Recommendations .................................................................................... 6-2

Appendix A      FUNCTIONAL ANALYSIS .................................................................. A-1

Appendix B      COTS/GOTS POINTS OF CONTACT ...................................................B-1

Appendix C      ACRONYMS/ABBREVIATIONS..........................................................C-1

Appendix D      REFERENCED DOCUMENTS ............................................................. D-1




                                                                 vi
                                                                                             ARC-DO-160000.1R2
                                                                                                       3-Jul-11
                                    LIST OF ILLUSTRATIONS

Number                                          Title                                                       Page

1-1      COTS Defined ......................................................................................... 1-2
1-2      Two Examples of COTS/GOTS Integration ............................................ 1-3




                                                        vii
                                                                                                   ARC-DO-160000.1R2
                                                                                                             3-Jul-11
                                             LIST OF TABLES

Number                                            Title                                                           Page

2-1      Matrix of COTS/GOTS Products............................................................. 2-8
3-1      Procurement ............................................................................................. 3-1
3-2      Finance ..................................................................................................... 3-4
3-3      Supply ...................................................................................................... 3-6
3-4      Scheduled Maintenance ........................................................................... 3-8
3-5      Flight Operations ..................................................................................... 3-9
3-6      Operating Environment Elements .......................................................... 3-10
4-1      Relative Cost Table .................................................................................. 4-3
4-2      GOLD for AR&SC .................................................................................. 4-3
4-3      GOLD for Additional Eight-User License ............................................... 4-4
4-4      Oracle Financials ..................................................................................... 4-4
4-5      Oracle Integrated Solution ....................................................................... 4-5




                                                         viii
                                     ARC-DO-160000.1R2
                                               3-Jul-11




This Page Intentionally Left Blank




                ix
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
                              SECTION 1. INTRODUCTION

1.1 PURPOSE.

The purpose of this analysis is to identify and evaluate COTS (Commercial-Off-The-Shelf) and
GOTS (Government-Off-The-Shelf) products that have potential for satisfying ALMIS (Aviation
Logistics Management Information System) functionality.

The ALMIS objective is to develop an aviation enterprise information system that incorporates
the functionality of existing legacy systems, provides for single source of data entry, implements
Decision Support System/Executive Information System capability, and is ―open‖ to other U.S.
Coast Guard systems.

1.2 SCOPE.

Approximately 80% of the core ALMIS functional requirements were identified and documented
based on the EAL (Electronic Aircraft Logbook), ACMS (Aviation Computerized Maintenance
System) and AMMIS (Aviation Maintenance Management Information System) functionality.
This list of requirements is a ―first cut‖ at determining ALMIS functional requirements and is
suitable only for COTS/GOTS functional analysis since these requirements have not been
verified through Technical Reviews or Joint Application Development sessions with the U.S.
Coast Guard. Potential COTS/GOTS solutions were mapped to this ―first cut‖ of ALMIS
functionality and evaluated for their portability, cost, risk and availability. Additionally, this
analysis addresses reliability, maturity, interoperability, maintainability and licensing issues.

1.3 METHODOLOGY.

FCBS (FC Business Systems) evaluated potential COTS/GOTS solutions based on vendor
marketing literature, web material, product demonstrations, and discussions with government
project managers and vendor marketing and technical representatives. Vendor‘s information is
by nature slanted and commercial products typically operate in a less demanding and more
narrowly focused environment. Some of the GOTS systems examined are currently under
development, and their evaluation was based on their ―planned‖ functionality.

Based on the sources of information for this report, a full understanding of the products‘
limitations and demonstrated degree of interoperability was not possible and was beyond the
scope of this evaluation. Any off-the-shelf product should be thoroughly prototyped to
determine if it can achieve the desired results in the U.S. Coast Guard operating environment.

The definition of COTS as shown in Figure 1-1 is from a slide presentation prepared by the
Software Engineering Institute and sponsored by the DOD (Department of Defense).

GOTS products are defined as government-furnished property. Typically, GOTS are custom-
developed for a specific business area/need.




                                               1-1
                                                                          ARC-DO-160000.1R2
                                                                                    3-Jul-11




                                   Figure 1-1. COTS Defined

1.4 BACKGROUND.

The U.S. Coast Guard IT (Information Technology) Management Strategy, in an effort to build a
collaborative IT management vision, focuses on changing from independent program specific
systems to developing enterprise-wide systems. This interest can be attributed to the increased
availability of both generic and domain specific COTS/GOTS products, the increased level of
interoperability, and standards compliance. This enables software integration, increased market
competition, and the need for larger, more integrated solutions that often cannot be built by a
single organization. In addition, government policies on the development and acquisition of
software systems have undergone a shift toward the use of existing COTS products. The interest
in COTS products is based on several factors. Of primary significance is the perception that
COTS products are less costly, based on the large commercial market of low-cost, easy-to-use
office automation software. At the same time, there are custom designed GOTS systems, whose
development costs have already been paid for, that could fulfill some ALMIS functionality.
With the current state of shrinking budgets and increasing software development costs, it appears
that integrating commercial/government software products could achieve the required
functionality in a cost-effective manner. Where existing software is available, it may no longer
be necessary for the U.S. Coast Guard to specify, build, and maintain proprietary systems.

Achieving a truly integrated solution is a significant issue in building a COTS/GOTS based
system. Figure 1-2 shows two ways of achieving this COT/GOTS integrated solution.




                                               1-2
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11

          Combined
                                                             Interfaced

      EAL/                                EAL/ACMS                           COTS/
                                                               Interfaces
                  COTS/                    /AMMIS                            GOTS
      ACMS/
                  GOTS
      AMMIS


                    Figure 1-2. Two Examples of COTS/GOTS Integration

The ―Combined‖ system is not a realistic expectation on several levels. Source code would be
required to achieve this state, and it is improbable that a commercial vendor with a viable
product would provide source code. If source code were obtained, it would then be modified to
fit into the final ALMIS application. Once COTS/GOTS software is modified, the product is no
longer a COTS/GOTS product, and future versions of the COTS/GOTS product could not be
readily adapted into ALMIS.

The ―Interfaced‖ system is the commonly accepted approach for an off-the-shelf, integrated
system. It is based on the current industry buzzword ―plug and play‖ where heterogeneous
components can be easily inserted or replaced, and where there is a high degree of
interoperability. However, ―plug and play‖ is based on conditions found in the hardware world,
not in the software world. Commonly, software components do not fit together well, and
systems often have a very large amount of integrating code, often called ―glueware‖ that binds
heterogeneous pieces together. In a Carnegie Mellon University Software Engineering Institute
monograph, David Carney and Patricia Oberndorf write ―In terms of software, this tempting
picture [plug and play] is a myth, and will remain a myth for several years.‖

In spite of the lack of ―plug and play‖ capability in software components, commercial software is
moving in that direction. The challenge in incorporating COTS/GOTS software is to identify
those products that have a high degree of interoperability and minimize the amount of glueware
and future maintenance costs.

1.5 GOVERNMENT REGULATIONS AND OBLIGATIONS.

COMDTINST 5230.58, the Government Performance and Results Act of 1993 and the Clinger-
Cohen Act have changed the focus for IT. The goal of this legislation is to improve the
management of IT resources throughout the federal government. The U.S. Coast Guard IT Five
Year Plan (Principles) states ― Information Systems will use best available mix of off-the-shelf
and custom developed products to optimize benefit to cost ratio over the life cycle.‖

The strategic plan for improving financial management systems adopted by the Chief Financial
Officers Council and OMB (Office of Management and Budget) includes the use of more COTS
software.

According to the U.S. Coast Guard IT Five Year Plan, ―LUFS-NT (Large Unit Financial System)
is the U.S. Coast Guard‘s mandated procurement and funds management tool.‖



                                               1-3
                                                                          ARC-DO-160000.1R2
                                                                                    3-Jul-11


1.6 DEVELOPMENT ISSUES.

The use of off-the-shelf products may provide for faster development and lower life cycle costs.
To take advantage of existing software, either commercial or governmental, today‘s system
developers will have to adapt to a new role as system integrators. The paradigms associated with
traditional development methodologies will need to be changed, and system integrators will have
to wrestle with the complexities of integrating off-the-shelf products into their system and also
recognize associated issues -- system distribution, interface standards, legacy system
reengineering, maintainability, product upgrades, licenses, etc. A COTS/GOTS-based approach
must be balanced, weighing disadvantages as well as benefits. Significant trade-offs exist and
must be thoroughly analyzed prior to making a decision. This paper focuses on product
functionality (i.e., benefits) versus costs and risks (i.e., drawbacks) of a COTS/GOTS solution.
To better understand the complex set of trade-offs, a detailed risk analysis, including
prototyping, should be completed before full implementation of any COTS/GOTS solution. This
is discussed further in the Section 5 (RISKS) of this paper.




                                              1-4
                                                                             ARC-DO-160000.1R2
                                                                                       3-Jul-11
              SECTION 2. IDENTIFY POSSIBLE COTS/GOTS PRODUCTS.

The COTS marketplace is huge and constantly changing. To determine the scope of the survey
for selecting and qualifying appropriate COTS/GOTS products, FCBS focused on products that
were considered relevant to the final ALMIS solution and that the Coast Guard was interested in
pursuing. CDR Ray of the U.S. Coast Guard sent FC Business Systems an e-mail on 3
December 1998 approving the following products for this analysis.

2.1 EAL.

The EAL is currently under development by MISD (Management Information Systems Division)
at the U. S. Coast Guard AR&SC (Aircraft Repair and Supply Center), in Elizabeth City, NC. It
is currently scheduled for deployment in the fourth quarter of 1999. The principle design
objectives of the EAL include automation of the CG-4377, capture of data related to unscheduled
maintenance, pilot/aircrew qualifications, and incorporation of all existing AMMIS Flight
Operations functionality. It will be web enabled, provide single point of data entry, utilize the
legacy hardware and Open Ingres RDBMS (Relational Database Management System), and
operate under Windows NT, SWIII (Standard Workstation III).

2.2 ACMS.

ACMS is the primary tool currently used by AR&SC and all U.S. Coast Guard Air Stations to
schedule and track aircraft maintenance and document aircraft configuration. ACMS provides
aircraft maintenance tracking, maintenance requirements definition, projections of pending
maintenance, records of completed maintenance, actual aircraft configuration including part
numbers and serial numbers, consumable and hazardous material usage, and analysis of
maintenance effectiveness.

2.3 AMMIS.

AMMIS is the primary inventory management tool currently used by AR&SC and U.S. Coast
Guard Air Stations. AMMIS provides requisitioning, wholesale and retail inventory
management, procurement, fiscal accounting, disbursing, warehousing, shipping, receiving,
aircraft flight and operations tracking, pilot and aircrew training and qualification tracking, and
flight pay reporting.

2.4 LUFS-NT.

According to the U.S. Coast Guard Fiscal Year 1998 Five Year IT Plan, LUFS-NT has proven to
be a stable and consistent procurement and funds management tool with a host of sophisticated
features. It is used for the transmission of financial and procurement data to the U.S. Coast
Guard FINCEN (Finance Center) for update to DAFIS (Departmental Accounting and Financial
Information Systems). LUFS-NT automates the simplified acquisition function and ensures the
timely commitment, obligation, and reconciliation of accounting data to and from DAFIS. It
also promotes fiscal responsibility by providing funds status and funds management capabilities.
LUFS-NT uses a graphical user interface to do line item accounting, paperless workflow routing,



                                                 2-1
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
and travel order generation. Key Chief Financial Officer functionality has recently been built
into LUFS-NT to track assets and projects.

At this time, LUFS-NT has been deployed at U.S. Coast Guard HQ (Headquarters), Maintenance
Logistics Center Atlantic, and the Research and Development Center. Deployment to other units
has been suspended for six months to allow for the stabilization and maturation of the system.
The Office of Procurement and Management realizes that the use of LUFS-NT at production data
sites is limited to simplified acquisitions. Although the system does about 96% of all the units‘
procurement volume (number of acquisitions, not dollar value), it does not handle many
functions associated with formal contracts. Because of this, the two inventory control points of
the U.S. Coast Guard, Engineering Logistics Center and AR&SC are not included in the
deployment plan.

2.5 FLS.

The FLS (Fleet Logistics System) project is a Level IIIA major acquisition managed under the
guidance provided in OMB Circular A-109, DOT (Department of Transportation) Major
Acquisition Policies and Procedures, and the U.S. Coast Guard Systems Acquisition Manual.
The Deputy Secretary of the Department of Transportation approved the Mission Need
Statement for FLS on November 1, 1994. This information resource management project was
established to integrate legacy logistics information systems into a single system to improve
logistics support to U.S. Coast Guard cutters and standard boats. The FLS is currently under
development and will consist of five modules: Configuration Management; Maintenance
Management; Supply Management; Financial Management and Procurement Management. FLS
is being built on a foundation that integrates SCCR (Supply Center Computer Replacement) with
other re-engineered COTS/GOTS, including Shipboard Computer Aided Management Program,
CMplus (Configuration Management Plus), Automated Requisition Management System and
LUFS-NT, with additional links as part of future increments. The initial increment of FLS is
scheduled for release during FY-99, but will not be fully developed and implemented before the
end of the year 2002.

The FLS system had major functionality shortfalls during OT&E (Operational Test and
Evaluation) on September 11, 1998. All interfaces were unsuccessful, security measures were
inadequate, and the financial functionality was questionable. All measurements indicate that the
system needs further work before deployment. The next OT&E is scheduled for late January or
early February 1999.

2.6 GOVERNMENT ON LINE DATA (GOLD).

For this analysis, the U.S. Air Force was determined to be the most relevant user of GOLD. The
U.S. Air Force is replacing multiple legacy logistics systems with GOLD, developed by WPDS
(Western Pacific Data Systems). Litton PRC is the added value reseller for WPDS and supports
its GOLD products available on the GSA (General Services Administration) schedule. The U.S.
Air Force wants a commercial logistics product to replace existing systems that are hard to use,
not integrated, and built on antiquated technology. The GOLD Logistics System contains
integrated maintenance and supply functionality that the U.S. Air Force will configure to their



                                               2-2
                                                                             ARC-DO-160000.1R2
                                                                                       3-Jul-11
specific needs. Additional custom functional requirements and associated business rules will be
built in; some of which the U.S. Air Force will be responsible for maintaining. For the users, the
screens will be designed to have the look and feel of a government logistics system. According
to an April 1997 press release by WPDS, the U.S. Air Force ―regards GOLD as a 70 percent to
80 percent solution‖ of the functional requirements for the U.S. Air Force Standard Base Supply
System. However, U.S. Air Force sources currently place this figure somewhere below 60
percent of the needed functionality for supply. As of this date, no part of the GOLD product has
been fully developed or implemented by the U.S. Air Force and it is not expected to be
operational before the year 2002.

2.7 ORACLE U.S. FEDERAL FINANCIAL APPLICATIONS.

Oracle U.S. Federal Financial Applications is a Federal compliant integrated suite of software
solutions that includes General Ledger, Payables, and Receivables described in the following
subparagraphs. The U.S. Coast Guard‘s Finance Center is building the FINCEN Total System
on Oracle products. The FINCEN Total System provides the centralized consolidation of the
source data collected through the financial desktop. The goal of the FINCEN Total System is to
provide a centralized and integrated data warehouse, which supports all of the needs of the U.S.
Coast Guard financial managers.

2.7.1 ORACLE U.S. FEDERAL GENERAL LEDGER.

Oracle U.S. Federal General Ledger provides flexible general accounting, cost accounting,
budgeting, and related regulatory reporting capabilities. It is the central repository of accounting
information, receiving transactions from both Oracle and non-Oracle subledgers.

2.7.2 ORACLE U.S. FEDERAL PAYABLES.

Oracle U.S. Federal Payables provides flexible invoice and payment processing including
support of the Prompt Payment Act.

2.7.3 ORACLE U.S. FEDERAL RECEIVABLES.

Oracle U.S. Federal Receivables provides flexibility for managing and streamlining the billing
and collection process. It can generate standard invoices, OPACs (on-line payment and
collections), credit and debit memos, recurring invoices, and commitments.

2.8 ORACLE INTEGRATED SOLUTIONS.

Oracle has a family of applications that offer fully integrated enterprise solutions. ALMIS
functionality could potentially be achieved using a combination of Oracle Applications and
custom designed modules developed with Oracle development tools. The following applications
are identified as potentially offering added functionality for ALMIS.




                                                2-3
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11
2.8.1 ORACLE ALERT.

Oracle Alert is a flexible, automated exception management and reporting tool that keeps users
aware of critical activity in the database, helping to automate the workflows and make better
business decisions faster. It works with electronic mail system to notify users automatically
when certain transactions occur.

2.8.2 ORACLE APPLICATIONS FOR THE WEB.

Oracle Web Employees, allows authorized employees using a standard Web browser to perform
common business functions, such as creating and approving expense reports, placing
requisitions, or updating Human Resource information.

Oracle Web Suppliers, allows authorized suppliers using a standard Web browser to review the
status of their invoices and payments over the Internet.

2.8.3 ORACLE ASSETS.

Oracle Assets is a complete asset management solution that helps maintain an accurate property
and equipment inventory. Assets can be found based on asset detail, assignment, invoice, or
lease information. Users can review financial, assignment, and other detailed asset information,
perform transfers, review purchasing or other source information, and retire the asset.

2.8.4 ORACLE BILLS OF MATERIAL.

Oracle Bills of Material helps manage essential engineering, business planning, sales order
configuration, material planning, and material handling information. The user can keep revisions
up to date, forecast demand for product families, accurately plan material and resource
requirements, and specify automated material-handling transactions using simple replenishment
and backflush techniques.

2.8.5 ORACLE CAPACITY.

Oracle Capacity lets users evaluate rough-cut and detailed capacity plans on-line, in real time. It
allows validation of master schedules and detailed material plans against available capacity
before finalizing them to simulate the impact of changing resources and product demands on
current capacity requirements.

2.8.6 ORACLE CASH MANAGEMENT.

Oracle Cash Management provides comprehensive bank reconciliation and cash forecasting
capabilities.




                                                2-4
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11
2.8.7 ORACLE COST MANAGEMENT.

Oracle Cost Management allows for flexible cost structures to support complex cost information
needs, and can maintain perpetual inventory costs using either standard or average costing. It
supports ―what-if‖ analysis by allowing users to create unlimited cost types to forecast unit cost
and gross margin impacts of engineering changes, new product introduction, and make-versus-
buy decisions.

2.8.8 ORACLE EDI (ELECTRONIC DATA INTERCHANGE) GATEWAY.

Oracle EDI Gateway lets users electronically exchange business transactions between Oracle
Applications and other trading partners. It integrates with Oracle Purchasing, Oracle Order
Entry and Oracle Receivables to streamline and automate high volume business transactions,
reduce paperwork, improve accuracy, and lower costs.

2.8.9 ORACLE FINANCIAL ANALYZER.

The Oracle Financial Analyzer, when integrated with Oracle‘s U.S. Federal General Ledger,
provides users with the ability to perform on-line analysis, identification, modeling, budgeting,
forecasting and reporting of information stored in the general ledger. It is an enterprise solution
that provides individual control—ensuring users only have access to the information they require
and supports full multidimensional analysis.

2.8.10 ORACLE FEDERAL HUMAN RESOURCES.

Oracle Federal Human Resources is a Federal compliant application that tracks the history of
organizational changes, offers self service employee access to personal data, tracks and assesses
training, and measures human resource costs in any unit.

2.8.11 ORACLE INVENTORY.

Oracle Inventory provides for management of multiple warehouses, each with multiple
storerooms. It offers complete intra-and inter-site transfer capabilities to facilitate stock
movement and replenishment. This application allows definition, update, and view of items and
item-related data and can attach multimedia files to the items.

2.8.12 ORACLE MASTER SCHEDULING.

Oracle Master Scheduling provides demand management tools, flexible forecasting techniques,
and simulation capabilities to manage customer service goals effectively and efficiently. Users
can use different ―what-if‖ scenarios to schedule production of key products, and quickly
simulate the impact of changes in resources, purchasing assumptions, and product demand, either
as a result of forecast changes or customer order mix and volume.




                                                2-5
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
2.8.13 ORACLE MRP (MANUFACTURING RESOURCE PLANNING).

Oracle MRP is a comprehensive planning and simulation system that combines time-phased
demand supply planning with a planner-based execution environment that helps users respond
quickly to changes in customer demand and operational requirements. It plans each part‘s
inventory requirements based on demand and applies replenishment policies to maintain the
appropriate on-hand inventory required to meet U.S. Coast Guard objectives.

2.8.14 ORACLE PERSONAL TIME AND EXPENSE.

Oracle Personal Time and Expense is a cost collection tool that allows employees to record and
submit timecards and expense reports on the road or on-line. The functionality of this
application can be extended by adding up to ten additional fields, or descriptive flexfields, to
timesheets and expense reports.

2.8.15 ORACLE PROJECT COSTING.

Oracle Project Costing is the bridge between project planning and scheduling systems and
financial accounting. Project managers can create unlimited work breakdown structures to
define and control how work is performed. Expenditure and commitment entry against a
project‘s work break-down structure, coupled with an integrated transaction charge control
mechanism, permits the project manager to track detailed costs, keep under budget, and stay on
schedule.

2.8.16 ORACLE U.S. FEDERAL PURCHASING.

Oracle U.S. Federal Purchasing automates and simplifies routine transactions such as processing
requisitions, purchase orders, request for quotations, and receipts. It can generate commitments
and produce obligations from commitments created by on-line requestors, inventory
replenishments, or Oracle‘s planning products.

2.8.17 ORACLE QUALITY.

Oracle Quality collects, distributes, and analyzes quality information throughout the supply chain
to measure product and process quality and adherence to standards.

2.8.18 ORACLE SUPPLIER SCHEDULING.

Oracle Supplier Scheduling consolidates forecast and shipping requirements from planned
orders, approved requisitions, and approved releases. It creates planning and shipping schedules
and creates schedule revisions.

2.8.19 ORACLE SUPPLY CHAIN PLANNING.

Oracle Supply Chain Planning lets users generate Distribution Requirement Plans, multi-plant
Master Schedules and Material Requirements Plans. It also permits users to generate supply



                                               2-6
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
chain plans that plan material requirements and replenishments for all facilities where inventory
or manufacture products are stored, including trading partner‘s inventory locations and plants.

2.8.20 ORACLE WORKFLOW.

Oracle Workflow can be used to automatically route expense reports for approval.

2.8.21 ORACLE WORK IN PROCESS.

Oracle Work in Process provides flexible hybrid manufacturing support for unique requirements.
Users can build both serial and lot-controlled assemblies and control all subcontract, prototype,
rework, and maintenance activities. It also offers responsive scheduling, total materials
management, flexible shop floor control and resource tracking.

2.9 CMPLUS.

CMplus is a unit-level, stand-alone GOTS product that links physical configuration information
to related supply, maintenance and technical information. CMplus provides automated central
information storage and retrieval for inventory, maintenance, requisitioning and equipment
history information. Using CMplus, each unit updates and maintains baseline configuration data,
schedules and records completion of preventive and corrective maintenance, maintains
allowance and inventory information, requisitions materials and maintains technical data indices
including selected record drawings, technical publications and other related data. CMplus is
targeted for six major cutter classes, all new vessel acquisitions and all standard boats.

The development effort for CMplus was chartered in 1992 and it is scheduled for implementation
in 1999. CMplus was developed for two reasons. First, CMplus supports the Cutter‘s supply
mission by ensuring that materials and parts are available in sufficient quantity and quality to
meet cutter maintenance needs for operational readiness. Second, CMplus supports the cutter‘s
maintenance mission by automating support for such operations as preventive maintenance,
corrective maintenance, grooming, updating, and overhaul.

2.10 COTS/GOTS MATRIX.

The ALMIS Business Area Analysis identified five major areas of functionality: Procurement,
Finance, Supply, Maintenance and Flight Operations. The analysis in this paper focuses on the
ability of each COTS/GOTS solution to fulfill specific functionality of the final ALMIS solution.




                                               2-7
                                                                                     ARC-DO-160000.1R2
                                                                                               3-Jul-11


Table 2-1 shows which ALMIS functionality each product is being evaluated to fulfill.




                                                                                     Oracle Integrated
                                                 LUFS-NT




                                                                        Financials
                                                                        ORACLE



                                                                                         Solution
                                         AMMIS




                                                                                                         CMplus
                                  ACMS




                                                                 GOLD
                        EAL
     ALMIS




                                                           FLS
  Functional Area



Procurement                                                                           
Finance                                                                               
Supply                                                                                              
Maintenance                                                                                           
Flight Operations                                                                                  

                              Table 2-1. Matrix of COTS/GOTS Products




                                                 2-8
                                                                                                    ARC-DO-160000.1R2
                                                                                                              3-Jul-11
                          SECTION 3. EVALUATION CRITERIA

3.1 FUNCTIONALITY.

Appendix A provides details of our analysis by functional area and shows the extent the software
meets functional requirements, or the degree that developmental effort is required. Tables 3-1
through 3-5 summarize the data in Appendix A as cumulative percentages of functions
performed versus the total functions. A dash (-) indicates that the software is not applicable in
that business area, or provides no functionality at that level of effort.

3.1.1 PROCUREMENT.

The functions of this area include all the processes required to conduct procurements, administer
contracts, and perform procurement reporting and analysis. These include:

a.   Manage Annual Procurement Plan and Submit to HQ
b.   Prepare Purchase Request or Maintenance Requirement Package
c.   Determine Funds Availability
d.   Determine Federal or Commercial Source
e.   Process Requisition Requirement
f.   Initiate Procurement Action
g.   Solicit for Contract
h.   Establish Contract
i.   Perform Start-up Activities
j.   Perform Contract Operations
k.   Closeout Contract
l.   Perform Pre-award and Post-award Procurement Reporting and Analysis
m.   Other reports per regulations

Table 3-1 shows the level to which the COTS/GOTS products offer procurement functionality.
                                                                                Oracle Financials
                                                                                                    Oracle Integrated
                                                         LUFS-NT




                                                                                                        Solution
                                               AMMIS




                                                                                                                        CMplus
                                       ACMS




                                                                         GOLD
                                EAL




                                                                   FLS




        Level of Effort



No modifications required       -       -      61% 67% 61% 61%                     -                 39%                 -
Modify business process         -       -      61% 78% 72% 94%                     -                 61%                 -
Minor software modification     -       -      78% 89% 100% 94%                    -                 61%                 -
Software development effort     -       -     100% 100% 100% 100%                  -                100%                 -

                                      Table 3-1. Procurement




                                                   3-1
                                                                              ARC-DO-160000.1R2
                                                                                        3-Jul-11


3.1.1.1 AMMIS PROCUREMENT FUNCTIONALITY.

AMMIS tracks procurement functions on both formal contracts and simplified acquisitions.
Although the analysis shows 61% functionality without modification, AMMIS current
functionality has significant limitations:

   a. AMMIS does not automatically generate the delivery order/purchase order number.

     b. When procurement personnel enter new vendors, they must go into the same screen three
times in order to input billing, shipping and correspondence addresses. The process could be
simplified if a single screen could be utilized for all three addresses. If all pertinent information
for the vendor is not loaded into the database, the obligation process cannot be completed. Also,
if the vendor has more than one correspondence location site and the requiring activity does not
specify the address, then AMMIS will not allow the user to complete the obligation process.

    c. Each line item must be obligated individually instead of obligating the entire purchase
request. If the user makes an error in the obligation process, AMMIS does not alert them of the
error. Each line item must be decommitted and deleted individually, and the purchase request
unrouted. Then the purchase request must be reobligated individually by line item.

   d. AMMIS does not generate travel orders. They must be done in jet form filler. AMMIS
only tracks the money portion for finance.

    e. All MIPR (Military Interdepartmental Purchase Requests) are tracked as miscellaneous
obligations. AMMIS does not allow the user to create subcategories of MIPRs under the same
document number for different product lines or programs. Therefore, the original miscellaneous
document number is decreased and new document numbers are established for each subcategory.
Typically, this is accomplished by adding a suffix to the original document number.
Additionally, each time a part is shipped for repair, the document number for the subcategory is
decreased by the amount needed for the item being shipped. The new document number (created
automatically by AMMIS) cannot be traced on the system to the original MIPR number. This
makes it difficult for the requiring activity to determine the balance of funds available for each
MIPR.

3.1.1.2 LUFS-NT PROCURMENT FUNCTIONALITY.

LUFS-NT is capable of handling simplified acquisitions up to $25,000. A CIMS (Contract
Information Management System) product to supplement LUFS-NT is being developed to
handle formal contracts, but is not yet available. CIMS will be developed from a COTS product
(to be determined) to track government contracts from ‗cradle‘ (design phase) to ‗grave‘ (award
phase). The U.S. Coast Guard HQ‘s CIMS package has not been put into the solicitation phase
of contracting, and therefore does not have a projected completion date.




                                                 3-2
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
3.1.1.3 FLS PROCURMENT FUNCTIONALITY.

The FLS procurement module has not been developed; it is scheduled to begin development in
FY-00. FLS was evaluated based on its projected functionality.

3.1.1.4 GOLD PROCURMENT FUNCTIONALITY.

GOLD has significant procurement functionality, and with some changes in the way AR&SC
does some of their functions, the system could perform 94% of the procurement functionality.
GOLD does not perform travel order functions.

3.1.1.5 ORACLE PROCURMENT FUNCTIONALITY.

Oracle has a Government Purchasing package, but it does not create formal documents (contract
awards) automatically. This capability can be added on in Oracle but would require
development effort.

3.1.2 FINANCE.

The functions of this area include recording budget and expenditure activity; maintaining asset,
liability and equity account balances; recording expenses; and controlling subsidiary accounts.
The six functions to support this area of responsibility are:

   a. Manage General Ledger

   b. Manage Funds Control

   c. Manage Supplies and Services Accounting

   d. Manage Personnel Services Accounting

   e. Manage Industrial Services Accounting

   f. Manage Transaction Processing




                                               3-3
                                                                                                     ARC-DO-160000.1R2
                                                                                                               3-Jul-11
Table 3-2 shows the level to which the COTS/GOTS products offer financial functionality.




                                                                                 Oracle Financials
                                                                                                     Oracle Integrated
                                                        LUFS–NT




                                                                                                         Solution
                                              AMMIS




                                                                                                                         CMplus
                                      ACMS




                                                                         GOLD
                                EAL




                                                                   FLS
       Level of Effort



No modifications required       -      -      48%     45%          73%   -       75% 75%                                  -
Modify business process         -      -      50%     46%          93%   -       96% 96%                                  -
Minor software modification     -      -      86%     46%          98%   -      100% 100%                                 -
Software development effort     -      -     100%     46%         100%   -      100% 100%                                 -

                                       Table 3-2. Finance

3.1.2.1 AMMIS FINANCE FUNCTIONALITY.

Many of the financial functions performed by AMMIS do not conform to the Federal Financial
Management System Requirements (the minimum specific functional requirements to conform to
Treasury and Office of Management and Budget guidance). For example, AMMIS does not:

    a. Allow the user to record complete and partial (accounts receivable) receipts according to
the Debt Collection Act of 1982 and other applicable regulations (i.e. the collection module is
not available).

    b. Provide audit trails to trace transactions from source documents, original input, other
systems, system-generated transactions, and internal allocation transactions through the system.

   c. Provide transaction details to support account balances.

   d. Provide controls to prevent the creation of duplicate finance transactions.

    e. Provide for easy access to historical files for comparative, analytical, and trend
information. For example, document numbers can not be traced to originating MIPRS on
AMMIS.

   f. Provide for reconciliation of all open accounting period balances to their respective
subsidiaries through on-line queries and reports.

    g. Provide for the production of formatted reports. Allow for the reformatting of reports to
present different sorts of the information, the presentation of only specific information in the
format selected, the summarization of data, and the modification of report formats to tailor the
reports to the specific requirements of the user. For example, a user can define a finance table
via an ad hoc query, but AMMIS can only print the screen (not the entire table) to the printer.



                                                  3-4
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
3.1.2.2 LUFS-NT FINANCIAL FUNCTIONALITY.

LUFS-NT has some purchasing, funds management, reconciliation, and reporting capability, but
it does not support all the financial functional requirements of ALMIS.

3.1.2.3 FLS FINANCIAL FUNCTIONALITY.

Currently, FLS uses SCCR for financials. It will be replaced by a new FLS financial module
scheduled to be developed in FY-02.

3.1.2.4 ORACLE FINANCIAL FUNCTIONALITY.

Oracle Financials was the only product analyzed that currently has significant financial
functional capability. Oracle Integrated Solution will contain all Oracle applications
advantageous to the solution – including the Oracle Financial Application. All of the financial
functional capability identified in this analysis can be performed within the Oracle Financial
Application with the level of effort shown in table 3-3.

3.1.3 SUPPLY.

This Depot Supply includes the following six functions:

a. Manage Requisitions

b. Manage Inventory

c. Manage Depot Material

d. Manage Depot Procurement

e. Manage Provisioning

f. Manage Technical Information

Air Station Supply includes the following five functions:

a. Requisition Processing

b. Manage Air Station Inventory

c. Manage Air Station Material

d. Manage Allowance List Data

e. Manage Exception Unsatisfactory Reports




                                               3-5
                                                                                                  ARC-DO-160000.1R2
                                                                                                            3-Jul-11
Table 3-3 shows the level to which the COTS/GOTS products offer supply functionality.




                                                                              Oracle Financials
                                                                                                  Oracle Integrated
                                                       LUFS–NT




                                                                                                      Solution
                                             AMMIS




                                                                                                                      CMplus
                                      ACMS




                                                                       GOLD
                                EAL




                                                                 FLS
       Level of Effort



No modifications required       -     23%    84%     15% - 49%                15%                   4%   -
Modify business process         -     23%    86%     15% - 50%                15%                  44% -
Minor software modification     -     23%    87%     15% 100% 83%             15%                  73% 100%
Software development effort     -     23%    97%     15% 100% 100%            15%                 100% 100%

                                       Table 3-3. Supply

3.1.3.1 AMMIS SUPPLY FUNCTIONALITY.

AMMIS has made great improvements in supply related programs since its inception. However,
there are a significant number of software changes/development efforts that are required for
AMMIS to function properly. In some cases, menus or screens indicate functionality, but the
underlying functions are not available. Some AMMIS deficiencies are listed below:

    a. For a vendor to receive payment for material received by direct shipment, Air Station
personnel must process a receipt both manually and in AMMIS. They are also required to send
an email to AR&SC finance personnel providing all pertinent information.

    b. The ability to process receipt exceptions is not currently available in AMMIS.
Processing receipts determines payment to vendors, NRFI (Not Ready For Issue Material) turn in
requirements, and requisitioning availability, as well as other Air Station and AR&SC
requirements. Frequently only partial shipments are received at the Air Station for orders placed.
Without this functionality in AMMIS, the Air Station cannot process a receipt for that portion of
the shipment that was received. This delays payments, requires extra documentation, and ―hands
on‖ vice ―electronic‖ management of material.

    c. The programs designed for creating and managing surveys do not function. The screens
are available in AMMIS, and, in some cases, the user is allowed to make entries on the screen.
However, the management review, approval, and forwarding to AR&SC screens do not function.

    d. GSE (Ground Support Equipment) programs in AMMIS do not function. To
view/manage GSE material, the user must utilize the screens intended for other types of material.
In most cases, the functions available on these screens are not sufficient to properly manage GSE
equipment for either Air Station personnel or Item Managers.

   e. The screens used for management of Rockwell Collins material on backorder have not
been developed.


                                                 3-6
                                                                          ARC-DO-160000.1R2
                                                                                    3-Jul-11


   f. The programs that process Type 7 (Textron) material in AMMIS do not function.

   g. The screens that will be used for creating and approving recommended buys of OGA
(Other Government Agency) material have not been developed.

   h. Program DS173600, Manage Status, has not been developed.

   i. The Supply Study programs are currently unavailable in AMMIS.

    j. The parts pooling program has been modified several times since its inception. The
original parts pooling program does not function, however, documentation has been provided
stating that the entire parts pooling program has been re-written and will be on-line soon.

    k. UR (Unsatisfactory Reports) programs do not function at the present time. However, as
with parts pooling, documentation has been provided stating the program has been re-written and
will be on-line soon.

3.1.3.2 LUFS-NT SUPPLY FUNCTIONALITY.

LUFS-NT performs only a small number of supply related functions and would require an
enormous amount of software development and financial support to achieve any degree of
compliance.

3.1.3.3 FLS, GOLD, CMPLUS AND ORACLE SUPPLY FUNCTIONALITY.

Although, FLS, GOLD, and CMplus appear to achieve 100% functionality with limited software
or business process modification, this is based on documentation provided. These products
require more detailed analysis or prototyping to demonstrate actual supply capabilities. Oracle
Integrated Solution (Supply Chain Management Module) could provide functionality required,
but would require major modification or major adjustments in U.S. Coast Guard processes to
meet current U.S. Coast Guard Supply functional requirements.

3.1.4 SCHEDULED MAINTENANCE.

Scheduled Maintenance includes:

    a. Performing scheduling and reporting tasks in support of the maintenance activities for the
U.S. Coast Guard‘s fixed and rotary wing aircraft, MSR (Mandatory Special Requirements)
items, and selected SR (Special Requirements) items

    b. Managing aircraft configuration data to provide tracking and maintenance history for all
items designated as SNT (Serial Number Tracked) components or assemblies

   c. Tracking maintenance, repairs, calibration, and transportation times of avionics
equipment and aircraft components



                                               3-7
                                                                                                   ARC-DO-160000.1R2
                                                                                                             3-Jul-11


   d. Producing operational, managerial and system reports

   e. Providing for trend and statistical analysis

   f. Providing for interactive query of the database and retrieving historical data about a
component's status and configuration information

Table 3-4 shows the level to which the COTS/GOTS products offer scheduled maintenance
functionality.




                                                                               Oracle Financials
                                                                                                   Oracle Integrated
                                                        LUFS-NT




                                                                                                       Solution
                                              AMMIS




                                                                                                                       CMplus
                                       ACMS




                                                                        GOLD
                                EAL




                                                                  FLS
       Level of Effort



No modifications required        -    100%    -          -          -   -         -                      -               -
Modify business process          -    100%    -          -          -   -         -                      -             10%
Minor software modification      -    100%    -          -        56% 82%         -                      -             10%
Software development effort      -    100%    -          -        56% 82%         -                      -             67%

                               Table 3-4. Scheduled Maintenance

GOLD performs much of the functionality required for scheduled maintenance. Oracle
Manufacturing Module could potentially satisfy ALMIS functional requirements, but requires
major modifications to meet current U.S. Coast Guard scheduled maintenance functional
requirements.

3.1.5 FLIGHT OPERATIONS/EAL.

Flight Operations/EAL accumulates flight hours for each aircraft, pilot, and aircrew, as well as
data on what training is accomplished during each flight, annual required aircrew training, and
the status of the aircraft. Data collected is manipulated for report generation and management of
aviation resources.

Table 3-5 shows the level to which the COTS/GOTS products offer flight operations
functionality.




                                                  3-8
                                                                                                   ARC-DO-160000.1R2
                                                                                                             3-Jul-11




                                                                               Oracle Financials
                                                                                                   Oracle Integrated
                                                        LUFS-NT




                                                                                                       Solution
                                              AMMIS




                                                                                                                       CMplus
                                       ACMS




                                                                        GOLD
                                EAL




                                                                  FLS
       Level of Effort



No modifications required     100%    18%     51%        -          -   -         -                  -    -
Modify business process       100%    18%     51%        -          -   -         -                  -   1%
Minor software modification   100%    28%     63%        -        19% 25%         -                  -   1%
Software development effort   100%    31%     66%        -        19% 25%         -                100% 14%

                                  Table 3-5. Flight Operations

None of the COTS products evaluated have the inherent capability to meet the Flight Operations
requirements, but can modified in varying degrees to meet these requirements. Oracle would
require the addition of a flight operations module to their existing software.

3.2 RELIABILITY/MATURITY.

Reliability/Maturity is an attempt to capture the risk associated with changing/updating the
software once integrated in ALMIS. We researched how long the COTS/GOTS products have
been used and how many software versions/changes have been implemented over this period of
time.

We did not identify any government agency that had used the products under evaluation for more
than one year. Since all of the GOTS products under evaluation are either in development or
have been fully operational for less than one year, none can be said to have demonstrated
reliability or maturity as evidenced by an established track record.

Oracle Corporation is the world's second largest software company, and the largest independent
supplier of software for information management. The Company introduced the first
commercially available RDBMS in 1979 and entered the business applications market in the late
1980‘s. Oracle U.S. Federal Financials is included on GSA‘s FMSS (Financial Management
Systems Software) 1997 Schedule. To achieve this, they were required to meet the stringent
federal standards for financial and accounting software. Oracle‘s customer profile includes the
U.S. Coast Guard, U.S. Air Force, U.S. DOD Civilian Personnel Data System and the U.K.
Royal Air Force. Oracle version changes have occurred once per year for the last six to seven
years. They are required upgrades if you want continued support for that product… Oracle
supports the previous version for a limited time, but at some point (not clearly defined how long)
Oracle discontinues support for the previous version.
Within each of these version changes there are two to three point changes (1.1, 1.2, 2.01, etc.)
that are optional, and minor in nature... these changes are incorporated in the next version
release.




                                                  3-9
                                                                                                                 ARC-DO-160000.1R2
                                                                                                                           3-Jul-11
GOLD was designed specifically to comply with government procurement regulations and to
readily interface with federal supply systems. GOLD has evolved since it was originally
developed in COBOL in 1981. Their first redesign was done in 1985, a second in 1991, and then
a third in 1994. It is currently written to operate in conjunction with the Oracle database and
offers more than 1,700 UNIFACE forms that can be tailored for each individual customer.
GOLD‘s government customer profile includes the U.S. Navy, the U.S. Air Force, the U.K.
Royal Navy, and the Australian Air Force.

3.3 PORTABILITY.

Portability is defined as the ability of an application to operate in a specific environment. Within
the scope of this analysis, we evaluated an application's relative ability to operate in the existing
AR&SC MISD environment (Open Ingres 2.0) and the potentially new environment (Oracle).
We also evaluated each application's ability to operate in a distributed Web enabled environment.

Table 3-6 provides a matrix that cross-references the candidate COTS/GOTS products against
the relevant elements of the operating environment elements.




                                                                                                                 Oracle Integrated


                                                                                                                                     CMplus (Oracle
                                                 (Oracle based)


                                                                  (Oracle based)


                                                                                   (Oracle based)
                                                   LUFS-NT




                                                                                                    Financials
                                                                                                    ORACLE



                                                                                                                     Solution
                                         AMMIS




    Operating
                                  ACMS




                                                                                      GOLD




                                                                                                                                        based)
                        EAL




                                                                       FLS


   Environment
    Elements


DEC ALPHA                                                                                                                       
HP-9000 (series)                                                                                                                    
DIGITAL UNIX                                                                                                                    
HP UNIX                                                                                                                            
TCP/IP                                                                                                                          
CORBA                                               1                1                1               1              1                  
COM/DCOM                                         1                1                1               1              1                  
OPEN INGRES 2.0                                  2                2                2               2              2                  2
ORACLE                                                                                                                             
NT 4.0 SP – 3                                                                                                                   

                              Table 3-6. Operating Environment Elements

A check mark () in a cell indicates that the application is able to operate in the corresponding
operating environment. A number in a cell indicates that one of the following notes applies:

    1 - Oracle based products can be configured, at installation, to employ either CORBA
(Common Business Oriented Language) or DCOM (Distributed Component Object Model) for
the management of distributed products. Further, the current version of Oracle (v8.0) includes
an interchange cartridge capable of bridging communications between CORBA and DCOM.


                                                  3-10
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11


    2 - All of the Oracle products described in the table above require additional middleware to
communicate with Open Ingres. Such additional middleware may degrade overall performance
or increase the cost and complexity of application development and maintenance.

3.3.1 ENVIRONMENT.

AR&SC is the only U.S. Coast Guard data center operating in the Digital/DEC Unix/Ingres
environment. Other U.S. Coast Guard data centers, FINCEN and ELC (Engineering Logistics
Center), operate in the Hewlett Packard 9000/HP Unix/Oracle environment.

3.3.1.1 HARDWARE.

The products were evaluated in terms of their ability to operate on: DEC Alpha (series) and HP-
9000 (series). Both Oracle and Open Ingres operate in these environments.

3.3.1.2 OPERATING SYSTEMS.

The products were evaluated in terms of their ability to operate on the Digital Unix 4.0B, Digital
ULTRIX 4.4 and HP-UX operating systems. Both Oracle and Open Ingres operate in these
environments.

3.3.1.3 COMMUNICATIONS AND OBJECT MANAGEMENT.

Connectivity software (middleware that consists of a set of enabling services that allow multiple
processes running on one or more machines to interact across a network) is essential in migrating
applications to client/server environments in order to provide for communication and
―understanding‖ across multiple heterogeneous platforms. Effective employment of middleware
technology in the development and/or integration of a distributed system provides for sustainable
interoperability, maintainability, scalability, and to some degree, insulation from the effects of
technological evolution.

From a COTS/GOTS perspective, the analysis issue is one of tools that enable or implement the
appropriate middleware that is compatible with the results from the tools analysis and the
COTS/GOTS recommendations in Section 6 of this report. An additional analysis issue is the
ability of any middleware to bridge existing Coast Guard systems, AMMIS and ACMS, with any
future development.

Enterprise Middleware is typically enabled through the acquisition of tools and the
implementation of an architecture that enables CORBA or DCOM compliant objects across
heterogeneous application and database servers. The tool set evaluated in the Tools Report
includes Delphi as well as Oracle Developer. Both tools can satisfy current and future Coast
Guard needs to connect through ODBC to an Ingres database. Both toolkits support transition to
Oracle or other relational databases, as determined by the Coast Guard, without major migration
and re-implementation effort.




                                               3-11
                                                                             ARC-DO-160000.1R2
                                                                                       3-Jul-11
The Delphi and Oracle developer toolkits also lend themselves well to the implementation of an
N-tier application architecture and the GUIs (Graphical User Interface) associated with them.
The Delphi toolkit provides some inherent capabilities that enable future N-tier application
development and integration, although this is not an immediate need.

Since ODBC is envisioned as the database connection method between a logical application
server and a logical database server, the nature of the relational database recommended in this
report is transparent to any middleware analysis. Both Oracle and Ingres can be comprehended
in a straightforward manner as long as ODBC is used as the connection mechanism.

Other COTS/GOTS evaluated in this report, e.g. Oracle Financials and LUFTS-NT, can be
connected using ODBC and a CORBA compliant communication layer. Since the Coast Guard
only uses TCP/IP, there is a single group of communication protocol drivers throughout all
deployed ALMIS systems, and no specific communication protocol issues come into play.

3.3.1.4 COMMUNICATIONS.

Communications, for the purpose of this analysis, is defined as the ability for clients and hosts to
exchange data and services in a distributed processing network environment.

COTS/GOTS products were evaluated in terms of their ability to communicate via TCP/IP—the
standard Internet and Intranet communications protocol and the proscribed communications
protocol of the CG SWIII/Windows NT 4.0 installation. All of the COTS/GOTS products
evaluated and the primary candidate RDBMS‘s (OpenIngres 2.0 and Oracle 8), are designed for,
and are fully capable of, communicating via TCP/IP.

3.3.1.5 DISTRIBUTED OBJECT MANAGEMENT.

COTS/GOTS products were also evaluated in terms of vendor/developer claims and
documentation regarding the product(s) ability and supporting methodology to deploy
components/objects and manage data/services exchange compliant with COM (Component
Object Model)/DCOM or CORBA standards. A primary consideration in the adaptation and
integration of a COTS/GOTS product into an existing or evolving system is the product‘s object
interface definition/implementation—the compatibility of ORB (Object Request Broker)
implementations between the product and the architecture of the target system. The issue of
concern is that the COTS/GOTS product(s) selected for integration into ALMIS employ an
ALMIS-architecture-compliant (and, thus, a CG SWIII compliant) ORB.

Oracle based product objects can be configured at installation to comply with either CORBA or
COM/DCOM standards for the management of distributed products. Oracle 8 also includes an
interchange cartridge capable of bridging communications between CORBA and COM/DCOM.

3.3.2 RELATIONAL DATABASE MANAGEMENT SYSTEM.




                                                3-12
                                                                                ARC-DO-160000.1R2
                                                                                          3-Jul-11
The products were evaluated in terms of their ability to interface with the existing RDBMS
(OpenIngres 2.0). All the prospective products are Oracle RDBMS systems. They would
require additional middleware to communicate with an OpenIngres RDBMS, which could
potentially degrade system performance and/or increase the cost and complexity of application
development and maintenance.

3.3.3 CLIENT-SERVER ENVIRONMENT.

Windows NT 4.0 with Service Pack 3 is part of the CG SWIII standard installation package. All
of the COTS/GOTS products are designed to operate in this environment.

3.4 TESTABILITY.

Testability is important throughout the software development life cycle to assess that the code
characteristics are acceptably safe and reliable. A software product is testable to the extent that it
facilitates the establishment of verification criteria and supports evaluation of its performance.

Testability analysis is an assertion about the ability of an input selection criteria (in combination
with the program) to satisfy a particular testing goal – in this case, allocating the functional
requirements to each ―off-the-shelf‖ product considered. In order for these software products to
be assessed as having a greater testability, it must be likely that a failure (an incorrect output that
was caused by a flaw in the program) occurs during testing whenever a fault exists. Software
failure only occurs when the following three necessary and sufficient conditions occur in the
following sequence:
1. The input must cause a fault to be executed.
2. Once the fault is executed, the succeeding data state must contain a data state error.
3. Once the data state error is created, the data state error must propagate to an output state.
The software is said to have high testability for a set of tests if the tests are likely to uncover any
faults that exist; the software has low testability for those tests if the tests are unlikely to uncover
any faults that exist. In order to make a prediction about the probability that existing faults will
be revealed during testing, formal testability analysis should:
1. Be able to predict whether a fault will be executed
2. Whether it will infect the succeeding data state creating a data state error
3. And whether the data state error will propagate its incorrectness into an output variable
These conditions provide a formal means for predicting the testability of software. While the
GOTS products are still under design and development, their source code is not available. The
unknown testability of these products has been identified as a risk and is included in the Risk
Matrix (Table 5-1). Since the source code for COTS products is not available, they would be
tested as ―black boxes.‖ Their functionality can be tested at the lowest component level during
prototyping.




                                                 3-13
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11
3.5 AVAILABILITY.

Availability is defined as the percentage of time a user has access to information on the software
system. Detailed information on system availability was not readily available in a format that
was comparable across products. In a full-scale prototype evaluation of any product,
availability/performance criteria should be determined and used as a basis for comparison. The
following is an example of the type of availability/response time metrics that can be used:

   During work hours
   (e.g., 0800-2000 EST)               98% availability
   During off hours
   (e.g., 2000-0800 EST)               90% availability (Backup and maintenance on
                                                        the system will normally be
                                                        done after normal working
                                                        hours.)
   On-line System Response Time: 85% of the time  5 seconds
                                   10% of the time 5-10 seconds
                                   04% of the time 10-30 seconds
                    01% of the time  30 seconds




                                               3-14
                                     ARC-DO-160000.1R2
                                               3-Jul-11




This Page Intentionally Left Blank




              3-15
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
                                     SECTION 4. COST

Cost analysis addresses site surveys, acquisition/licensing, development, integration,
documentation and maintenance costs. The following paragraphs define the scope of these cost
elements for this analysis.

4.1 COST DEFINITIONS AND IMPACTS.

4.1.1 SITE SURVEYS.

The site survey is used to determine what hardware/software/communications are currently in
place. When software is custom designed/developed, site survey costs are included as part of the
architecture design in the development process.

4.1.2 ACQUISITION/LICENSING COSTS.

Acquisition/licensing costs authorize the customer to use the software. Licensing costs are a
function of the number of concurrent users and the number of individually licensed products (or
modules), and will be relatively high for COTS products. For GOTS products, acquisition costs
are the costs of obtaining the software from the agency that funded the development of the
GOTS product. Since the GOTS products examined are U.S. Coast Guard developed software,
there are no acquisition costs.

4.1.3 DEVELOPMENT COSTS.

Development costs for COTS products include adding functionality (such as adding a new
module) to the existing COTS product. For a GOTS product, development costs include
modifying the software to meet the specific needs of the acquiring agency. Development costs
for both COTS and GOTS products include costs associated with training developers,
maintainers, operators, and functional users to integrate, maintain, and use the integrated
software products. Development cost for custom designed software is relatively high. The
development effort for COTS and GOTS products will vary depending on the ―out of the box‖
functional capability. If significant functionality has to be added, then development costs will
increase proportionately.

4.1.4 INTEGRATION COSTS.

Integration costs are associated with writing ―glueware‖ - wrappers or bridges that facilitate
communications between applications. Integration costs are directly related to the number of
interfaces and the degree of difficulty in writing the interfaces. Integration of off-the-shelf
components is no simpler than integration of proprietary components, and in fact may be more
difficult. Information that crosses interface boundaries is semantically complex, and there are no
widely accepted agreements about shared data. As a result, interface or ―glueware‖ costs have
the potential to exceed custom development costs.




                                               4-1
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11
4.1.5 DOCUMENTATION COSTS.

Documentation costs include writing standard operating procedures and training manuals in
compliance with CG-SDDS (Coast Guard Software Documentation Development Standards).

Since all the GOTS under evaluation are CG products, it is anticipated that the documentation is
being developed to these standards. It is unrealistic to expect that any of the COTS products'
documentation have been written to meet USCG standards.

4.1.6 MAINTENANCE COSTS.

Maintenance costs include product upgrades as well as patches for application bugs, and all
associated documentation following implementation. These fees are renewable, and typically
cover a one year period. They do not include technical support from the software manufacturer.

If complex interfaces (i.e., ―glueware‖) are required, then there will be associated maintenance
costs for those applications as well. The costs to sustain any COTS or GOTS software can
potentially exceed those for custom developed software. Determining the actual cost of
maintaining functional and non-functional aspects of a COTS-based system is beyond the scope
of this analysis. But generally, maintenance costs are a function of troubleshooting problems,
glueware, and the number software releases. These costs increase with the complexity of the
integrated applications.

4.1.7 SOFTWARE COST ESTIMATION

The cost of the software development effort is proportional to the software size, and this
estimation is the first and most important part of the project-planning phase. The two most
common metrics used to measure software size are source lines of code and function points.
Performing a size estimation relies on a credible and timely requirements definition of the
project, a project summary, and high quality historical data. In addition, assumptions about the
future and reasonableness of the historical basis of the estimate must be established. Based on
this information, the time to implement per source line of code (or function point) and cost per
source line of code (or function point) can be determined. Then, based on the estimate of the
total number of source lines of code (or function points), the total time to implement and the total
cost can be determined. A cost estimator must follow a well-defined estimation process and use
cost modeling tools to provide a useful basis for estimating the cost of developing interfaces and
the cost of developing additional functionality (customization). Obtaining information to the
detail required to make reasonable estimates for the COTS/GOTS solutions was beyond the
scope of this paper. As discussed in section 5 (RISKS), one strategy to mitigate risks is to
prototype (product evaluation in the actual operating environment). If this strategy is employed,
then software cost estimating should be applied to the prototype. Upon completion of the
prototype, cost, schedule and performance estimates can be compared with actual results, thus
providing good historical data for use in future cost estimates.




                                                4-2
                                                                            ARC-DO-160000.1R2
                                                                                      3-Jul-11


4.2 RELATIVE COST TABLE.

Table 4-1 shows the cost of each element relative to the other product types. A ‗H‘ means that
the cost is relatively higher, a ‗M‘ means that the cost is relatively medium, and a ‗L means that
the cost is relatively lower. An explanation of the results follows.

                                                                       CUSTOM
        COST ELEMENTS                     COTS            GOTS
                                                                      DEVELOPED
Site survey                                  H              M             L
Acquisition/licensing costs                  H              L             L
Development costs                            L              M             H
Integration costs                            H              M             L
Documentation costs                          L             L            H
Maintenance costs                            H             M             L

                                 Table 4- 1. Relative Cost Table

4.3 INITIAL – SHORT-TERM COST IMPACTS.

4.3.1 GOLD.

Table 4-2 shows the cost of GOLD on the GSA FSS (Federal Supply Schedule).

GOLD Logistics Systems
Gold Site Survey
One week on site survey and production of a program plan detailing                  $57,795
resources and schedule needed for a successful implementation.
Large Supply Management System
License for 1 server and 32 client workstations. Includes 1-year                    703,089
warranty. Requires site survey.
Maintenance of Supply System                                                             757
Large Asset Management System
License for 1 server and 32 client workstations. Includes 1-year                    703,089
warranty. Requires site survey.
Maintenance of Asset System                                                              757
Large Maintenance Management System
License for 1 server and 32 client workstations. Includes 1-year                    703,089
warranty. Requires site survey.
Maintenance of Management                                                               757
                                           Total initial cost for AR&SC:         $2,169,333

                                 Table 4- 2. GOLD for AR&SC




                                                4-3
                                                                              ARC-DO-160000.1R2
                                                                                        3-Jul-11
Table 4-3 shows the cost of each additional eight-user license.

Additional eight-user license for all three systems (Large Supply
Management, Large Asset Management, and Large Maintenance                             $27,122
Management).
Maintenance of each additional eight-user licenses.                                       189
                                          Costs for eight additional users:           $27,311

                      Table 4- 3. GOLD for Additional Eight-User License

Table 4-2 shows the initial cost to set up GOLD at AR&SC with one server and 32 client
stations. Even though AR&SC has 200 system users, a GOLD representative stated that no more
than 20 licenses (concurrent users) should be required to meet the requirements at AR&SC. If it
turned out that 200 licenses were required at AR&SC, then the total cost (based on additional
licensing costs in Table 4-3) would be approximately $2.74M.

Table 4-3 shows the costs for an eight-user license (concurrent users). FCBS arrived at a total
cost estimate of $682,775 to license 25 Air Stations. This estimate is based on one eight-user
license for each Air Station.

A quantity discount for multiple licenses was not available on the GSA FSS. While GOLD is
available on the GSA schedule, it should be noted that the schedule has a maximum dollar
limitation of $500,000. Negotiations with the contractor carrying that schedule are mandatory
prior to placing an order over $500,000. Renewal of maintenance plans is required each year.

4.3.2 ORACLE FINANCIALS.

Table 4-4 shows the cost of Oracle Financials on the GSA FSS.

Oracle Financials
Oracle U.S. Federal General Ledger                                                $    769.05
Oracle U.S. Federal Payables                                                          1,142.50
Oracle U.S. Federal Receivables                                                       1,142.50
                                              Total initial cost per user:        $ 3,054.05

                                  Table 4-4. Oracle Financials

If all 12 users currently working at AR&SC Fiscal Branch require access to all three modules,
the total licensing cost for Oracle Financials is $36,648.60.




                                               4-4
                                                                         ARC-DO-160000.1R2
                                                                                   3-Jul-11


4.3.3 ORACLE INTEGRATED SOLUTION.

Table 4-5 shows the per user cost of Oracle products available on the GSA FSS as of 12/11/98.

Oracle Integrated Solution
Oracle Assets                                                                $     739.36
Oracle Bill of Materials                                                          1,127.88
Oracle Capacity.                                                                  1,631.13
Oracle Cost Management                                                             769.05
Oracle Financial Analyzer                                                          502.94
Oracle Inventory                                                                   769.05
Oracle Personal Time & Expenses                                                    114.53
Oracle Project Costing                                                            1,025.10
Oracle U.S. Federal Purchasing                                                    1,142.50
Oracle Supplier Scheduling                                                       11,650.90
Oracle Supply Chain Planning                                                      1,025.10
Oracle Work In Process                                                            1,025.10

                             Table 4-5. Oracle Integrated Solution




                                              4-5
                                                                          ARC-DO-160000.1R2
                                                                                    3-Jul-11
In analyzing costs for Oracle Integrated Solutions and attempting to make them comparable to
GOLD, FCBS made two estimates for the number of concurrent users. Each Oracle module
listed below shows our estimate of the number of licenses required for a ―minimum‖ number of
concurrent users (comparable to GOLD‘s one server/32 client licenses, Table 4-2), and the
number of licenses required for a ―maximum‖ number of concurrent users (comparable to
GOLD‘s 200 licenses for AR&SC, ref. Tables 4-2 and 4-3).

Assets                Minimum Users 32                        $ 23,659.52
                      Maximum Users 200                                       147,872.00
Bill Of Materials     Minimum Users 32                          36,092.16
                      Maximum Users 32                                         36,092.16
Capacity              Minimum Users 5                            8,155.65
                      Maximum Users 32                                         52,196.16
Cost Management       Minimum Users 5                            3,845.25
                      Maximum Users 12                                          9,228.60
Financial Analyzer    Minimum Users 12                           6,035.28
                      Maximum Users 12                                          6,035.28
Inventory             Minimum Users 10                           7,690.50
                      Maximum Users 15                                         11,535.75
Per. Time & Exp.      Minimum Users 10                           1,145.30
                      Maximum Users12                                           1,374.36
Project Costing       Minimum Users 25                          25,627.50
                      Maximum Users 50                                         51,255.00
U. S. Fed Purchase    Minimum Users 20                          22,850.00
                      Maximum Users 38                                         43,415.00
Supplier Schedule     Minimum Users 5                           58,254.50
                      Maximum Users 10                                        116,509.10
Supply Chain Plan     Minimum Users 20                          20,502.00
                      Maximum Users 32                                         32,803.20
Work In Process       Minimum Users 25                          25,627.50
                      Maximum Users 50                                         51,255.00
Total Estimate for Minimum Number of Users                     251,236.52
Total Estimate for Maximum Number of Users                                    571,322.97
Both estimates include the following Oracle Applications: Web Solutions at $100.46 for Web
Server and $11,650.90 for Web Employees.

4.3.4 ESTIMATED COST FOR GOTS PRODUCTS

According to U.S. Coast Guard project managers, there will be no acquisition costs to the
ALMIS Project for the GOTS applications (LUFS-NT, FLS and CMplus) currently under
development.


                                              4-6
                                                                              ARC-DO-160000.1R2
                                                                                        3-Jul-11
                                     SECTION 5. RISKS

5.1 RISKS WITH COTS/GOTS SYSTEMS.

In a Carnegie Mellon University Software Engineering Institute monograph, David Carney and
Patricia Oberndorf write, ―As of yet, there is little real Government experience with building and
fielding significant COTS-based systems, especially over any significant part of an overall
system lifecycle. We have far more promises and wishful thinking than facts or verified cost
models on which to base our enthusiasm for the use of COTS products in government systems.‖
Additionally, software evaluation is an area in which there is little wisdom. Current techniques
for software evaluation are immature and unreliable, and it is rare for two components to be fully
comparable.

At the same time, there is a genuine need to engineer the system well. Few COTS/GOTS
products are designed to work with other products – most are built as stand-alone products – and
even if they are designed to work with other products, it is usually from the same vendor or a
vendor with whom they share special interest. A COTS/GOTS integrated system will be unique
– designed, brought together, tested and managed in much the same way as legacy systems –
except with additional players.

Interoperability is defined as the product‘s relative ability to integrate seamlessly with all system
components so they are compatible, secure, and reliable. One of the problems faced by
integrators of COTS/GOTS components in a complex system is that the assembly of these
components can involve a complex interaction of architecture, infrastructure, and possibly
middleware elements. Since components rarely plug and play, the usual way to integrate
software products is to use ―glueware‖ that traps output from one system and formats it for input
into another system.

Initial writing of glueware is a complex activity and any new release may require
upgrading/modifying the glueware. Subsequent changes in a vendor‘s release have the potential
for incompatible files and databases, changes in naming conventions, and introduction of
conflicts between components. Integrated software has a very heavy dependence on various
release cycles of the vendors, which is not controlled by the user. COTS/GOTS means giving up
control and depending on vendors who are now critical to the success of the system. Depending
on the number of components from different vendors, the effect of multi-dependencies can range
from short-term inconvenience to system instability. Hence, glueware development might lead
to higher maintenance costs.

Troubleshooting problems on an integrated system is more challenging than traditional
debugging. Integrators must approach troubleshooting from three perspectives:

   a. Intra-component visibility - observes the behavior of an individual component; seeks to
understand the component developer‘s assumptions and intended use of the component.

   b. Inter-component visibility - observes the behavior of two or more components; seeks to
understand potential mismatches between components.



                                                 5-1
                                                                             ARC-DO-160000.1R2
                                                                                       3-Jul-11


   c. Extra-component visibility - observes a system of components in ensemble; seeks to
understand macro-level issues dealing with performance, maintenance, misfits, etc.

Integrators must have technical prowess, diagnostic and deductive insight, and a willingness to
try many approaches. They must coordinate with multiple vendors for support. Each vendor
must be responsive. If the application is critical to operational needs, then support must be
available 24 hours/day. Integrators need sufficient documentation – everything from system
administration to end user – and it must be well written and accurate.

5.2 RISK MITIGATION.

The best way to achieve the desired functionality with the selected COTS/GOTS product(s) is to
take the following steps to mitigate risks:

Studies at Hewlett-Packard have shown that up to 22% development effort was associated with
risk analysis of reusable software components. Risk analysis should include prototyping --
product evaluation in the actual operating environment. There are three critical stages in this
evaluation:

   a. Functionality evaluation (ensure product is tested and can support ALMIS functional
requirements as determined by ALMIS Requirements Database CDRL A009)

   b. Interoperability evaluation (develop small software adapters ―glueware‖ to enable
communications between service domains)

   c. Performance evaluation (results are compared against system overall performance
requirements)

Partnership with a commercial vendor should be with a large, successful, service-oriented
organization with established software in the ALMIS functional area. The number of
vendors/products integrated in ALMIS should be minimized to reduce complexity and number of
interfaces.

Software should be modular and built to specified standards to facilitate interoperability and
reduce complexity of interfaces. ―Plug and Play‖ software is not yet a reality. This is especially
true across different vendor product lines, although the industry is attempting to get there. In the
current environment, AMMIS is not modular and will generate the biggest obstacles to an
integrated environment.




                                                5-2
                                                                             ARC-DO-160000.1R2
                                                                                       3-Jul-11


5.3 RISK MANAGEMENT.

The purpose of risk management is to identify risks that are relevant to the project and to make a
preliminary assessment of these risks. This risk assessment addresses three risk elements: cost,
schedule and performance. Risks are evaluated to determine the likelihood of their occurrence
and potential impact on the project. The assessment also includes selecting handling actions to
mitigate each risk.

Three general areas of impact have been identified in the selection of COTS/GOTS products for
the ALMIS project:

        a. Cost Risk – Risk of cost growth and funding instability. Other cost risks involve
obtaining and using resources, including funding and supporting activities, under the control of
other projects or programs.
        b. Schedule Risk – Risks associated with schedule slippage within the ALMIS projects
and in related programs and projects which may be dependant on ALMIS.
        c. Functional or Technical Performance Risk – Although COTS/GOTS lowers risks, any
new software, interfaces, and port adaptation data must be monitored.

The probability of occurrence is the likelihood that a risk will materialize. The probability of
occurrence may be quantified as a percentage from 0% to 100%. To keep the rating system
simple, the probabilities of occurrence are categorized as being high, moderate, or low.

        a. High – 66 2/3 to 100 %
        b. Moderate – 33 1/3 to 66 2/3 %
        c. Low – 0 to 33 1/3 %

The severity of impact measures of how serious the effect on the project will be if the risk
materializes. The impact may be on project cost, project schedule, or technical or functional
performance. The three levels of impact are:

       a. High – Is likely to cause increased cost, significant disruption of schedule, or
       degradation of performance, even with special attention and monitoring.
       b. Moderate – Has the potential to cause increased cost, some disruption of schedule, or
       degraded performance. However, special attention and monitoring should overcome the
       difficulties.
       c. Low – Has the potential to cause limited increased cost, disruption of schedule, or
       degraded performance. Normal attention and monitoring should overcome the
       difficulties.

These ratings have been applied to the risks identified and are presented in Table 5.1. The table
also shows proposed risk mitigation handling actions.




                                                5-3
                                                                                                                             ARC-DO-160000.1R2
                                                                                                                                       3-Jul-11
                                                           Probability    Severity
Risk                                         Impact
                  Description                                  of            of                              Handling Actions
 #                                            Area
                                                           Occurrence     Impact
                                                                                         Start with small COTS/GOTS project with limited impact on
       Experience integrating                  Cost
 1                                                            High             High       overall ALMIS project
       COTS/GOTS solutions                   Schedule
                                                                                         Hire/sub-contract experienced integrators
       Complexity of integration/               Cost
 2     compatibility with other              Schedule       Moderate      Moderate       Develop comprehensive interface development plan
       components                           Performance
       Applicability/suitability of                                                      Software evaluation by both integrators and functional users at
                                             Schedule
 3     software to fit functional                             Low              High       sites currently using software
                                            Performance
       requirements                                                                      Initiate prototype to validate schedule/performance estimates
                                                                                         Hands-on training for both integrators and functional users at
       Knowledge and experience on
 4                                           Schedule         High             Low        active site (estimate 2-4 weeks)
       evaluated software
                                                                                         Help desk support
       Troubleshooting/debugging
       ―black box‖ systems (e.g., no            Cost                                     Minimize number of vendors
                                                              High
 5     source code, vendors point            Schedule                          High      Implement structured (scientific method) troubleshooting
       fingers at other system              Performance                                   techniques
       component as cause)
                                                                                         Partner with other Coast Guard project teams
 6     GOTS development priorities           Schedule       Moderate      Moderate       Support other Coast Guard projects by providing human,
                                                                                          financial, technical, or organizational support resources
 7     Version changes                      Performance       High        Moderate       Purchase vendor support package
                                                                                         Purchase from vendors with established track record and stable
 8     Loss of vendor support                Schedule         Low         Moderate
                                                                                          financial position
 9     Difficult to determine testability   Performance       High             High      Select products with good performance record
                                                                                         Train personnel in new roles as integrators vs. developers
                                                                                         Use a ―marketing‖ strategy to sell new product to customers
10     Resistance to change                 Performance     Moderate      Moderate       Use product demos to introduce customers to new software
                                                                                         Re-evaluate current business processes vs. potential
                                                                                          improvements with new software

                                                        Table 5-1. COTS/GOTS Risks Matrix



                                                                         5-5
                                                                              ARC-DO-160000.1R2
                                                                                        3-Jul-11
                                SECTION 6. CONCLUSIONS

6.1 BENEFITS/RISKS.

The ALMIS project is compelled to examine available products and use the best mix of off-the-
shelf and custom developed products that optimize benefits and minimize risks over the ALMIS
life cycle. From our analysis of COTS/GOTS products, it is clear that there is no easy answer or
obviously compelling solution. In general, COTS/GOTS solutions are difficult and have
inherent risks. Underestimating the technical risks associated with software integration could
lead to schedule delays, higher development costs, and higher maintenance costs.

6.2 FUNCTIONALITY.

COTS products are readily available, but it is likely that their advertised functionality will not
fully live up to expectations. It is anticipated that there will be development costs on top of
acquisition costs.

GOTS products (LUFS-NT, FLS and CMplus) are in various stages of development. Integrating
these systems into ALMIS requires coordination with their development schedules, and schedule
delays in their development could delay ALMIS development. It is also unlikely that LUFS-NT,
FLS or CMplus will perform all functions stated in their development plan, and additional time,
as well as development effort, will have to be programmed to meet ALMIS requirements.

In the current EAL/ACMS/AMMIS system, development is completely under the control of
AR&SC. ALMIS development can be tailored to correct AMMIS deficiencies as well as
meeting other ALMIS functional requirements.

6.3 RISK MITIGATION.

The best way to achieve the desired functionality with the selected COTS/GOTS product(s) is to
take the following steps to mitigate risks:

       a. Prototyping -- product evaluation in the actual operating environment.
       b. Partnership with a commercial vendor that is a large, successful, service-oriented
          organization with established software in the ALMIS functional area.
       c. Minimizing the number of vendors/products integrated in ALMIS.
       d. Software should be modular and built to specified standards.

6.4 RECOMMENDATIONS.

Based on our analysis of COTS/GOTS products, FCBS recommends:




                                                 6-1
                                                                           ARC-DO-160000.1R2
                                                                                     3-Jul-11
    a. Prototyping Oracle Applications (Oracle Inventory, Oracle Supply Chain Planning) for
ALMIS supply functionality. This approach requires some in-house development to achieve
100% ALMIS supply functionality. While FLS will have much of the required supply
functionality, its development is scheduled for delivery no earlier than July 2000 (Supply
Operations) and November 2000 (Inventory Control). Prototyping a COTS application and
building interfaces to ALMIS will provide the knowledge and experience to arrive at more
accurate estimates of performance, complexity, cost, risk and effort required to integrate a COTS
based solution. Specifically, using an Oracle application as an initial prototype provides several
advantages:
        Facilitates future integration with a wide range of Oracle applications
        Exists in a RDBMS environment consistent with other U.S. Coast Guard applications
        Oracle is a large, service-oriented organization with well-established software in the
                ALMIS business areas
        Products are available on GSA schedule
        Potentially minimizes the number of vendors, reducing complexity and improving
                troubleshooting
At the same time, there are drawbacks using Oracle products:
        Reliance on a commercial vendor with potential loss of support for product or
                requirement to upgrade to newer product
        Restricted by product limitations/deficiencies
        Expensive

    b. Oracle Financials as the solution for overcoming AMMIS financial accounting
deficiencies. The Finance Center already implements Oracle Financials which is fully compliant
with federally mandated requirements. Incorporating changes in federal regulations will be more
readily accomplished via Oracle product upgrades, rather than AMMIS software modification.

    c. Interfacing LUFS-NT with ALMIS. Currently, LUFS-NT performs many procurement
functions except formal contracts. CIMS will add formal contract capability, however it is
estimated that it will be at least one to two years before it is deployed.

Analysis/selection of an RDBMS is currently in process as part of the Tools Analysis. From a
COTS/GOTS perspective, independent of the Tools Analysis, it is evident that the best choice for
future ALMIS development is Oracle RDBMS. This includes transition of legacy systems, EAL,
ACMS, and AMMIS, to Oracle RDBMS on an appropriate transition schedule. This will make
MISD consistent with U.S. Coast Guard data centers and the Finance Center. More important,
U.S. Coast Guard applications (LUFS-NT, FLS and CMplus) are Oracle based. Moving ALMIS
development to Oracle RDBMS will facilitate potential future integration/interoperability with
these applications as well as a wide range of Oracle Integrated Applications.




                                               6-2
                                                                                                                  ARC-DO-160001.100
                                                                                                                           07/03/11
                                         APPENDIX A. FUNCTIONAL ANALYSIS

The codes Y1, Y2, Y3, Y4, UD1, UD2, UD3 and N are as follows:

No modifications required (Y1, UD1) = software performs the required functions ―out of the box.‖ For items identified as UD1, the
capability is ―under development‖ for that product and it is our estimate that the finished software will perform the required functions
―out of the box.‖

Modify business process (Y2, UD2) = software supports the required functions, but its business process is different from the current
U.S. Coast Guard process. For items identified as UD2, the capability is ―under development‖ for that product and it is our estimate
that the finished software will support the required functions, but its business process will be different from the current U.S. Coast
Guard process.

Minor software modification (Y3, UD3) = software requires minor modification to achieve the required functionality. In some
commercial products, the software can be configured through field definition, use of ―flex‖ fields, or business process definition. For
items identified as UD3, the capability is ―under development‖ for that product and it is our estimate that the finished software will
require minor modification to achieve the required functionality.

Software development effort (Y4) = software requires significant development effort, e.g. development of a separate module to achieve
the desired functionality.

Not applicable (N) = software has no functionality in the business area associated with that product.




                                                                  A-1
                                                                                                         ARC-DO-160001.100
                                                                                                                  07/03/11




                                                                                         LUFS-NT




                                                                                                                Financials

                                                                                                                Integrated
                                                                                                                 Solution
                                                                                 AMMIS




                                                                                                                             CMplus
                                                                                                                  Oracle
                                                                          ACMS




                                                                                                         GOLD



                                                                                                                  Oracle
                                                                    EAL




                                                                                                   FLS
                               FUNCTIONS


PROCUREMENT
Formal Contracts                                                    N     N      Y1      Y4        UD1   Y1     N    Y4      N
Simplified Acquisition                                              N     N      Y1      Y1        UD1   Y1     N    Y1      N
Amendments to Simplified Acquisitions Using SF (Standard Form) 30   N     N      Y1      Y1        UD1   Y1     N    Y1      N
Credit Cards                                                        N     N      Y1      Y2        UD2   Y1     N    Y4      N
MIPR‘S                                                              N     N      Y4      Y1        UD3   Y2     N    Y4      N
BPA‘s                                                               N     N      Y3      Y3        UD1   Y2     N    Y2      N
Recurring Charges                                                   N     N      Y3      Y1        UD1   Y2     N    Y4      N
Miscellaneous Documents                                             N     N      Y1      Y1        UD1   Y1     N    Y4      N
Formatted Reports                                                   N     N      Y1      Y1        UD3   Y1     N    Y1      N
MILSTRIPS                                                           N     N      Y1      Y3        UD3   Y1     N    Y4      N
Numbering Systems (Systems Generated)                               N     N      Y4      Y1        UD3   Y2     N    Y2      N
Travel Orders                                                       N     N      Y4      Y1        UD1   Y4     N    Y4      N
Receipt of Goods                                                    N     N      Y1      Y1        UD1   Y1     N    Y1      N
Personal Property Tracking                                          N     N      Y4      Y2        UD2   Y2     N    Y2      N
Overdue Shipments                                                   N     N      Y1      Y1        UD1   Y1     N    Y1      N
Help Line                                                           N     N      Y3      Y1        UD1   Y2     N    Y2      N
Error Messages                                                      N     N      Y1      Y1        UD1   Y1     N    Y1      N
Inventory Parts                                                     N     N      Y1      Y4        UD3   Y1     N    Y1      N
FINANCE
Account Code Structure
Classify transactions by structure                                  N     N      Y1      Y1        UD1   N      Y1   Y1      N
Consistency in classifications and organization structure           N     N      Y1      Y1        UD1   N      Y1   Y1      N
Fund structure defines each entity                                  N     N      Y1      Y1        UD3   N      Y3   Y3      N
Relate FAST structures to fund structure                            N     N      Y1      Y1        UD1   N      Y3   Y3      N


                                                            A-2
                                                                                                                    ARC-DO-160001.100
                                                                                                                             07/03/11




                                                                                                    LUFS-NT




                                                                                                                           Financials

                                                                                                                           Integrated
                                                                                                                            Solution
                                                                                            AMMIS




                                                                                                                                        CMplus
                                                                                                                             Oracle
                                                                                     ACMS




                                                                                                                    GOLD



                                                                                                                             Oracle
                                                                               EAL




                                                                                                              FLS
                                FUNCTIONS


Differentiate between type of treatment & fund structure                       N     N      Y1      Y1        UD1   N      Y1   Y1      N
Provide detailed program structure                                             N     N      Y1      Y1        UD1   N      Y3   Y3      N
Organization structure based on responsibility assignments                     N     N      Y1      Y1        UD3   N      Y3   Y3      N
Use Agency Location Codes assigned by Treasury                                 N     N      Y1      Y1        UD1   N      Y3   Y3      N
Independent project structure                                                  N     N      Y1      Y1        UD1   N      Y1   Y1      N
Consistent object class structure                                              N     N      Y1      Y1        UD1   N      Y1   Y1      N
Revenue source code structure classified by type                               N     N      Y1      Y1        UD1   N      Y3   Y3      N
Ability to support other classification structure elements                     N     N      Y1      Y1        UD1   N      Y3   Y3      N
Derive expanded classification structure from abbreviated user input           N     N      Y4      Y1        UD1   N      Y1   Y1      N
Accounting classification structure code flexibility                           N     N      Y1      Y1        UD1   N      Y1   Y1      N
Standard General Ledger
Chart of account consistent with U.S. Government SGL                           N     N      Y1      Y1        UD1   N      Y1   Y1      N
Incorporate & relate proprietary and budgetary accounts                        N     N      Y1      Y1        UD1   N      Y3   Y3      N
Consistent account titles provided in SGL                                      N     N      Y1      Y1        UD1   N      Y1   Y1      N
Provide subsidiary ledger support for SGL accounts                             N     N      Y1      Y1        UD1   N      Y1   Y1      N
Account structure for multiple appropriations and fiscal years                 N     N      Y1      Y1        UD1   N      Y1   Y1      N
Maintain amount of expenditures carried forward at the end of each year AC&I   N     N      Y1      Y1        UD1   N      Y1   Y1      N
Automatic reports to OMB and Treasury from SGL accounts                        N     N      Y3      N         UD1   N      Y3   Y3      N
Transaction Definition
Identify standardized transactions by reference codes                          N     N      Y1      Y1        UD1   N      Y1   Y1      N
Allow standardized transactions                                                N     N      Y1      Y1        UD1   N      Y1   Y1      N
Update budgetary & proprietary accounts from single input transaction          N     N      Y3      Y1        UD1   N      Y1   Y1      N
Compound g/l entries from a single transaction reference code                  N     N      Y1      Y1        UD1   N      Y1   Y1      N
Process system-generated transactions                                          N     N      Y1      Y1        UD1   N      Y1   Y1      N
Automatically liquidate through transaction codes                              N     N      Y3      Y1        UD1   N      Y1   Y1      N
Process and track transactions originating in other systems                    N     N      Y4      Y1        UD4   N      Y3   Y3      N



                                                               A-3
                                                                                                              ARC-DO-160001.100
                                                                                                                       07/03/11




                                                                                              LUFS-NT




                                                                                                                     Financials

                                                                                                                     Integrated
                                                                                                                      Solution
                                                                                      AMMIS




                                                                                                                                  CMplus
                                                                                                                       Oracle
                                                                               ACMS




                                                                                                              GOLD



                                                                                                                       Oracle
                                                                         EAL




                                                                                                        FLS
                                  FUNCTIONS


Audit Trails
Trace transactions from source documents, original input, etc.           N     N      Y4      Y1        UD2   N      Y2   Y2      N
Trace source documents through successive levels of summarization        N     N      Y4      Y1        UD2   N      Y2   Y2      N
Identify changes made to system parameters and tables                    N     N      Y3      Y1        UD1   N      Y1   Y1      N
Select items for review based on user-defined criteria                   N     N      Y4      Y1        UD1   N      Y1   Y1      N
Transaction Processing
Post to current and prior months concurrently until month-end closing    N     N      Y1      Y1        UD1   N      Y1   Y1      N
Post to current year and prior year at year-end independently            N     N      Y1      Y1        UD1   N      Y1   Y1      N
Use error files or suspense accts. to control erroneous transactions     N     N      Y1      Y1        UD1   N      Y1   Y1      N
Interface and validate record formats from other systems                 N     N      Y4      Y1        UD4   N      Y3   Y3      N
Support simultaneous data entry/access by users in various modes         N     N      Y4      Y1        UD1   N      Y1   Y1      N
Control transactions to maintain integrity and restrict users            N     N      Y1      Y1        UD1   N      Y1   Y1      N
Provide transaction edits to control fund availability, etc.             N     N      Y1      Y1        UD1   N      Y1   Y1      N
Prevent creation of duplicate transactions                               N     N      Y3      Y1        UD1   N      Y1   Y1      N
Ability for user to verify valid codes during data entry                 N     N      Y4      Y1        UD1   N      Y1   Y1      N
Archiving and Purging
Archive transactions in format accessible by audit software              N     N      Y4      N         UD1   N      Y2   Y2      N
Allow closed documents to be archived or purged                          N     N      Y3      N         UD1   N      Y2   Y2      N
Allow closed documents to be reopened                                    N     N      Y3      N         UD1   N      Y2   Y2      N
Purge other core financial system data stores to limit data maintained   N     N      Y3      N         UD1   N      Y2   Y2      N
Retain system records in accordance with federal regulations             N     N      Y3      N         UD1   N      Y1   Y1      N
General Ledger Management
Post transactions according to Core Financial System definitions         N     N      Y1      N         UD1   N      Y1   Y1      N
Maintain historical data to produce comparative financial reports        N     N      Y1      N         UD1   N      Y1   Y1      N
Automated month-end and year-end closing of g/l accounts & rollover      N     N      Y1      N         UD2   N      Y2   Y2      N
Allow multiple preliminary year-end closings                             N     N      Y1      N         UD2   N      Y2   Y2      N


                                                                 A-4
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                   FUNCTIONS


Automatically generate recurring accrual entries and reversals                   N     N      Y3      N         UD2   N      Y2   Y2      N
Allow for accruals of contracts that cross fiscal years                          N     N      Y4      N         UD2   N      Y2   Y2      N
Selectively generate required transactions for year-end closing procedures       N     N      Y4      N         UD2   N      Y2   Y2      N
Separately generate required transactions for year-end closing procedures        N     N      Y4      N         UD2   N      Y2   Y2      N
Separately identify amounts eliminated for intra/eragency consolidations         N     N      Y4      N         UD2   N      Y2   Y2      N
Prepare trial balances, etc. for external reports & statements                   N     N      Y1      N         UD3   N      Y1   Y1      N
Compare and annotate amounts on reports                                          N     N      Y3      N         UD1   N      Y1   Y1      N
Provide control accounts to balance g/l with other systems                       N     N      Y1      N         UD4   N      Y1   Y1      N
Provide for corrections of out-of-balance conditions during reconciliation       N     N      Y4      N         UD2   N      Y2   Y2      N
Reconcile open accounting period balances to subsidiaries; on-line queries       N     N      Y4      N         UD2   N      Y2   Y2      N
Funds Management
Record funding and related budget execution documents                            N     N      Y1      Y1        UD1   N      Y1   Y1      N
Record limitations and control use of funds with authorization language          N     N      Y1      Y1        UD3   N      Y1   Y1      N
Establish limitations for program lending limits and subsidy amounts             N     N      Y1      N         UD3   N      Y1   Y1      N
Distribute, track, control, and report funds authorized at various fund levels   N     N      Y3      Y1        UD1   N      Y1   Y1      N
Modify limitations in accordance with various adjustments                        N     N      Y3      Y1        UD1   N      Y1   Y1      N
Record and control funds and identify the type of authority                      N     N      Y1      Y2        UD3   N      Y1   Y1      N
Record the expiration and cancellation of appropriation authority                N     N      Y1      N         UD1   N      Y1   Y1      N
Maintain operating plans at or below the funds control level                     N     N      Y3      Y2        UD1   N      Y1   Y1      N
Allow authorized personnel to reallocate funds at designated levels              N     N      Y1      Y1        UD3   N      Y1   Y1      N
Account for budgetary resources at a lower level than they are budgeted          N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide for on-line notification of funds availability prior to transactions     N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide for the establishment and modification of the level of funds control     N     N      Y1      Y1        UD1   N      Y1   Y1      N
Reject transactions or provide warnings for insufficient funds by type           N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide capability to override funds availability edits                          N     N      Y1      Y1        UD1   N      Y1   Y1      N
Record financial impact of transactions that affect availability of funds        N     N      Y3      Y1        UD1   N      Y1   Y1      N



                                                                    A-5
                                                                                                                   ARC-DO-160001.100
                                                                                                                            07/03/11




                                                                                                   LUFS-NT




                                                                                                                          Financials

                                                                                                                          Integrated
                                                                                                                           Solution
                                                                                           AMMIS




                                                                                                                                       CMplus
                                                                                                                            Oracle
                                                                                    ACMS




                                                                                                                   GOLD



                                                                                                                            Oracle
                                                                              EAL




                                                                                                             FLS
                                 FUNCTIONS


Provide automatic real-time notification to users of insufficient funds       N     N      Y1      Y1        UD1   N      Y1   Y1      N
Update appropriate accounts to ensure reports reflect current status          N     N      Y1      Y1        UD1   N      Y1   Y1      N
Determine funds availability on adjustments based on certain criteria         N     N      Y3      Y1        UD1   N      Y1   Y1      N
Check commitment transactions against available funds                         N     N      Y1      Y1        UD1   N      Y1   Y1      N
Check available funds for obligating documents                                N     N      Y1      Y1        UD1   N      Y1   Y1      N
Check available funds when expense exceeds obligating document                N     N      Y1      Y1        UD1   N      Y1   Y1      N
Adjust available fund balances as reimbursable orders are accepted            N     N      Y1      N         UD1   N      Y1   Y1      N
Check available funds for commitments and obligations incurred                N     N      Y1      Y1        UD1   N      Y1   Y1      N
Allow commitment documents to be entered on-line from multiple locations      N     N      Y3      Y1        UD1   N      Y1   Y1      N
Maintain requisition # related to each commitment document                    N     N      Y1      Y1        UD1   N      Y1   Y1      N
Maintain account classif. structure related to each commitment document       N     N      Y1      Y1        UD1   N      Y1   Y1      N
Maintain estimated amounts related to each commitment document                N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide for modifications to commitment documents and invoke editing          N     N      Y1      Y1        UD1   N      Y1   Y1      N
Allow for commitment documents to be future-dated, stored, and posted         N     N      Y3      Y1        UD1   N      Y1   Y1      N
Close commitment by the system upon issuance of an obligation                 N     N      Y3      Y1        UD1   N      Y1   Y1      N
Close commitment by an authorized user                                        N     N      Y1      Y1        UD3   N      Y1   Y1      N
Close commitment as part of the year-end closing                              N     N      Y3      Y1        UD1   N      Y1   Y1      N
Record obligations based on documents, and liquidate commitments              N     N      Y3      Y1        UD1   N      Y1   Y1      N
Record obligations with no related commitment                                 N     N      Y1      Y1        UD1   N      Y1   Y1      N
Capture Obligating Document Number                                            N     N      Y1      Y1        UD1   N      Y1   Y1      N
Capture Vendor Number                                                         N     N      Y1      Y1        UD1   N      Y1   Y1      N
Capture Accounting Classification Structure(s)                                N     N      Y1      Y1        UD1   N      Y1   Y1      N
Capture referenced commitment (if applicable)                                 N     N      Y1      Y1        UD1   N      Y1   Y1      N
Capture dollar amounts                                                        N     N      Y1      Y1        UD1   N      Y1   Y1      N
Allow obligation documents entered on-line, multiple locations, & interface   N     N      N       Y1        UD1   N      Y1   Y1      N
Allow early entry of transactions creating anticipated obligation documents   N     N      Y3      Y1        UD1   N      Y1   Y1      N
Allow the combination of multiple commitments into one obligating doc.        N     N      Y3      Y1        UD1   N      Y1   Y1      N


                                                                 A-6
                                                                                                                    ARC-DO-160001.100
                                                                                                                             07/03/11




                                                                                                    LUFS-NT




                                                                                                                           Financials

                                                                                                                           Integrated
                                                                                                                            Solution
                                                                                            AMMIS




                                                                                                                                        CMplus
                                                                                                                             Oracle
                                                                                     ACMS




                                                                                                                    GOLD



                                                                                                                             Oracle
                                                                               EAL




                                                                                                              FLS
                                 FUNCTIONS


Allow authorized modifications and cancellations of posted obligations         N     N      Y3      Y1        UD3   N      Y1   Y1      N
Provide on-line access to all obligations by selection criteria                N     N      Y3      Y1        UD1   N      Y1   Y1      N
Maintain an on-line history file of closed out documents                       N     N      Y3      Y1        UD1   N      Y1   Y1      N
Retain all system record files along with all amendments                       N     N      Y3      Y1        UD1   N      Y1   Y1      N
Close obligations by the system automatically                                  N     N      Y3      Y1        UD1   N      Y1   Y1      N
Close obligations by an authorized user                                        N     N      Y1      Y1        UD3   N      Y1   Y1      N
Record various intra-governmental acquisition transactions                     N     N      Y1      Y1        UD3   N      Y1   Y1      N
Record and maintain contracts and grants                                       N     N      Y1      Y1        UD2   N      Y2   Y2      N
Record Blanket Purchase Agreements (BPA's) and records of call.                N     N      Y1      Y1        UD2   N      Y2   Y2      N
Record delivery orders on contracts                                            N     N      Y1      Y1        UD2   N      Y2   Y2      N
Record expenditures related to various types of payment methods                N     N      Y1      Y1        UD2   N      Y2   Y2      N
Record expenditures claimed against advance payments made                      N     N      Y1      Y2        UD2   N      Y2   Y2      N
Maintain commitment info. according to class structure on fund basis           N     N      Y1      Y1        UD2   N      Y2   Y2      N
Track the use of funds against operating or financial plans                    N     N      Y1      Y1        UD3   N      Y1   Y1      N
Report plan to actual at the level of the operating plans                      N     N      Y1      Y1        UD2   N      Y2   Y2      N
Summarize, compare, and report operating plans at fund control level           N     N      Y1      Y1        UD2   N      Y2   Y2      N
Produce detailed listings and summary reports at fund control level            N     N      Y1      Y1        UD2   N      Y2   Y2      N
Provide control features to ensure fund control structure agrees with g/l      N     N      Y3      Y1        UD1   N      Y1   Y1      N
Maintain historical data on all commitment, undelivered order, payable, pmt.   N     N      Y3      Y1        UD1   N      Y1   Y1      N
Maintain open documents to show status of items by document line item.         N     N      Y1      Y1        UD2   N      Y2   Y2      N
Payment Management
Payee info. to include support obligation, payables and disbursements          N     N      Y3      N         UD1   N      Y1   Y1      N
Support payments to third parties                                              N     N      Y1      N         UD1   N      Y1   Y1      N
1099 reporting capability                                                      N     N      Y1      N         UD1   N      Y1   Y1      N
Allow multiple payment addresses and/or bank information for each payee        N     N      Y1      N         UD1   N      Y1   Y1      N
Provide search capability for payee information                                N     N      Y1      N         UD1   N      Y1   Y1      N



                                                                 A-7
                                                                                                                  ARC-DO-160001.100
                                                                                                                           07/03/11




                                                                                                  LUFS-NT




                                                                                                                         Financials

                                                                                                                         Integrated
                                                                                                                          Solution
                                                                                          AMMIS




                                                                                                                                      CMplus
                                                                                                                           Oracle
                                                                                   ACMS




                                                                                                                  GOLD



                                                                                                                           Oracle
                                                                             EAL




                                                                                                            FLS
                                 FUNCTIONS


Produce payee listings based on agency defined criteria                      N     N      Y1      N         UD2   N      Y2   Y2      N
Warehouse and schedule payments according to regulations                     N     N      Y1      N         UD2   N      Y2   Y2      N
Record accrued liability upon receipt and acceptance of goods & services     N     N      Y1      N         UD1   N      Y1   Y1      N
Record invoices through keyboard entry through vendor electronic interface   N     N      Y4      N         UD1   N      Y1   Y1      N
Access and/or record additional information to determine due date & pmts.    N     N      Y1      N         UD2   N      Y2   Y2      N
Be capable of splitting an invoice into multiple payments                    N     N      Y1      N         UD2   N      Y2   Y2      N
Record discount terms, and automatically determine whether to take it        N     N      Y3      N         UD1   N      Y1   Y1      N
Record additional shipping charges and other charges to adjust payment       N     N      Y1      N         UD2   N      Y2   Y2      N
Adjust the asset or expense recorded with the liability if pmt. differs      N     N      Y1      N         UD1   N      Y1   Y1      N
Automatically update the funds control and budget execution balances         N     N      Y3      N         UD1   N      Y1   Y1      N
Establish payables and make payments on behalf of another agency             N     N      Y1      N         UD1   N      Y1   Y1      N
Allow orders to be reopened by authorized staff prior to submission          N     N      Y3      N         UD3   N      Y1   Y1      N
Process credit memoranda for returned goods or other adjustments             N     N      Y3      N         UD1   N      Y1   Y1      N
Reestablish payables for voided checks or checks returned                    N     N      Y1      N         UD2   N      Y2   Y2      N
Record obligations, expenses, assets, etc. associated with payments          N     N      Y1      N         UD1   N      Y1   Y1      N
Schedule payments of advances, prepaid expenses, loans, grants, etc.         N     N      Y3      N         UD1   N      Y1   Y1      N
Record expenses, assets, etc., based upon performance funded by ?            N     N      Y3      N         UD1   N      Y1   Y1      N
Automatically identify and select payments in cycles based on due date       N     N      Y3      N         UD1   N      Y1   Y1      N
Allow specific payments selected to be excluded and held for later pmt.      N     N      Y1      N         UD2   N      Y2   Y2      N
Automatically compute amounts to be disbursed and generate transactions      N     N      Y1      N         UD1   N      Y1   Y1      N
Automatically include on each pmt. relevant identification information       N     N      Y3      N         UD1   N      Y1   Y1      N
Collect information on discounts taken, lost, and interest penalties         N     N      Y3      N         UD1   N      Y1   Y1      N
Calculate totals by appropriation symbol for inclusion on pmt. schedule      N     N      Y1      N         UD1   N      Y1   Y1      N
Consolidate multiple payments to a single payee                              N     N      Y1      N         UD1   N      Y1   Y1      N
Allow a payment to be removed from the automated scheduling stream           N     N      Y1      N         UD2   N      Y2   Y2      N
Provide the capability to schedule and make payments in various forms        N     N      Y3      N         UD1   N      Y1   Y1      N
Prepare reports to Treasury on disbursements made by an agency               N     N      Y3      N         UD1   N      Y1   Y1      N


                                                                A-8
                                                                                                                  ARC-DO-160001.100
                                                                                                                           07/03/11




                                                                                                  LUFS-NT




                                                                                                                         Financials

                                                                                                                         Integrated
                                                                                                                          Solution
                                                                                          AMMIS




                                                                                                                                      CMplus
                                                                                                                           Oracle
                                                                                   ACMS




                                                                                                                  GOLD



                                                                                                                           Oracle
                                                                             EAL




                                                                                                            FLS
                                FUNCTIONS


Process transactions resulting from payments made using other systems        N     N      Y4      N         UD4   N      Y1   Y1      N
Record disbursements made through On-line Payment and Collection             N     N      Y3      N         UD1   N      Y1   Y1      N
Record payments made by another entity on behalf of the agency using funds   N     N      Y1      N         UD2   N      Y2   Y2      N
After pmts. are disbursed, allow cancellation of individual pmt.             N     N      Y1      N         UD2   N      Y2   Y2      N
Provide information on the date payment was scheduled                        N     N      Y1      N         UD1   N      Y1   Y1      N
Provide information on the date schedule sent to disbursing office           N     N      Y1      N         UD1   N      Y1   Y1      N
Provide information on the date payment issued by disbursing office          N     N      Y1      N         UD1   N      Y1   Y1      N
Compare agency's payment schedule and disbursing office's schedule           N     N      Y1      N         UD2   N      Y2   Y2      N
Update payment information when confirmation received from disbursing        N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on authorizing document number                      N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on payment schedule number                          N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on payment date                                     N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on invoice number                                   N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on vendor number                                    N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on appropriation charged                            N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain payment history on prompt payment information                       N     N      Y3      N         UD1   N      Y1   Y1      N
Provide on-line access to vendor and payment information                     N     N      Y3      N         UD1   N      Y1   Y1      N
Provide on-line access to open documents based on selection criteria         N     N      Y3      N         UD1   N      Y1   Y1      N
Produce IRS 1099s                                                            N     N      Y1      N         UD1   N      Y1   Y1      N
Produce the SF-224                                                           N     N      Y1      N         UD1   N      Y1   Y1      N
Produce the SF-1219 and SF 1220                                              N     N      Y1      N         UD1   N      Y1   Y1      N
Produce supporting info. To prepare Prompt Pay report                        N     N      Y1      N         UD1   N      Y1   Y1      N
Automatically liquidate related liability or the in-transit amount           N     N      Y3      N         UD1   N      Y1   Y1      N
Receivable Establishment
Support the calculation, generation, and posting of customer bills           N     N      Y1      N         UD1   N      Y1   Y1      N
Record receivables, revenues, expenditure reductions, & other offsets        N     N      Y1      N         UD2   N      Y2   Y2      N



                                                               A-9
                                                                                                                     ARC-DO-160001.100
                                                                                                                              07/03/11




                                                                                                     LUFS-NT




                                                                                                                            Financials

                                                                                                                            Integrated
                                                                                                                             Solution
                                                                                             AMMIS




                                                                                                                                         CMplus
                                                                                                                              Oracle
                                                                                      ACMS




                                                                                                                     GOLD



                                                                                                                              Oracle
                                                                                EAL




                                                                                                               FLS
                                  FUNCTIONS


Establish and track receivables paid under installment plans                    N     N      Y3      N         UD1   N      Y1   Y1      N
Print bills                                                                     N     N      Y1      N         UD2   N      Y2   Y2      N
Prepare and transmit billing data to the OPAC system                            N     N      Y3      N         UD1   N      Y1   Y1      N
Allow transactions related to manually prepared bills to be entered             N     N      Y1      N         UD2   N      Y2   Y2      N
Record adjustments to bills and post to customer accounts                       N     N      Y1      N         UD2   N      Y2   Y2      N
Date the bills with the system-generated date or date supplied                  N     N      Y1      N         UD1   N      Y1   Y1      N
Print statements as well as bills.                                              N     N      Y1      N         UD1   N      Y1   Y1      N
Receivables Management
Maintain sufficient detailed information by account                             N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain accounts for reimbursable orders and id. Gov. and nongov. Accts.       N     N      Y1      N         UD1   N      Y1   Y1      N
Update each account when billing docs. are generated $ collections rec.         N     N      Y3      N         UD1   N      Y1   Y1      N
Allow authorized personnel to add, modify, or delete non-financial data.        N     N      Y1      N         UD3   N      Y1   Y1      N
Maintain data on individual receivables and referenced transactions             N     N      Y3      N         UD1   N      Y1   Y1      N
Provide on-line query capability to receivable and account information          N     N      Y1      N         UD2   N      Y2   Y2      N
Provide information on the age of receivables                                   N     N      Y1      N         UD1   N      Y1   Y1      N
Provide automatic calculation and assessment of interest, charges, etc.         N     N      Y3      N         UD1   N      Y1   Y1      N
Identify and report receivables that meet predetermined criteria for bad debt   N     N      Y3      N         UD1   N      Y1   Y1      N
Maintain data for receivables referred to other Federal agencies                N     N      Y3      N         UD1   N      Y1   Y1      N
Record and maintain the write-off of delinquent or uncollectable receivables    N     N      Y3      N         UD1   N      Y1   Y1      N
Produce dunning (collection) letters for overdue receivables                    N     N      Y3      N         UD1   N      Y1   Y1      N
Provide ability to customize the dunning process parameters                     N     N      Y3      N         UD1   N      Y1   Y1      N
Provide manual or automated reporting of delinquent accounts                    N     N      Y1      N         UD2   N      Y2   Y2      N
Produce IRS 1099s in the amounts of debts forgiven                              N     N      Y1      N         UD2   N      Y2   Y2      N
Maintain a history of billings and receipts for each receivable and account     N     N      Y3      N         UD1   N      Y1   Y1      N
Match receipts to the appropriate receivable and update system balances         N     N      Y3      N         UD1   N      Y1   Y1      N
Provide the ability to apply receipts to more than one receivable.              N     N      Y1      N         UD2   N      Y1   Y1      N



                                                                  A-10
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                  FUNCTIONS


Update receivable balances on a document-by-document basis                       N     N      Y3      N         UD1   N      Y1   Y1      N
Identify receivables that have been reduced by waivers or write-offs.            N     N      Y3      N         UD1   N      Y1   Y1      N
Provide for reestablishment of a receivable for cks. returned NSF                N     N      Y1      N         UD2   N      Y2   Y2      N
Collections
Record complete and partial receipts                                             N     N      UD2     N         UD2   N      Y2   Y2      N
Record revenues, expenditures, -no receivable was previously established         N     N      UD2     N         UD2   N      Y2   Y2      N
Record deposits and related debit vouchers for reconciliation to Treasury        N     N      UD2     N         UD2   N      Y2   Y2      N
Provide for the processing of cash or credit card receipts.                      N     N      UD2     N         UD2   N      Y2   Y2      N
Allow for administrative, federal employee salary, & income tax refund offset.   N     N      UD2     N         UD2   N      Y2   Y2      N
Cost Management
Use the accrual basis of accounting when recognizing costs                       N     N      Y1      Y1 UD1          N      Y1   Y1      N
Reduce asset balances prepaid expenses as they are used and expensed.            N     N      Y1      N UD1           N      Y1   Y1      N
Use the accounting classification structure to identify fund, program, etc.      N     N      Y1      Y1 UD1          N      Y1   Y1      N
Cost Accumulation
Account for fees, royalties, rents, and other charges imposed                    N     N      Y3      N         UD1   N      Y1   Y1      N
Identify all costs incurred by the agency in support of activities of funds      N     N      Y3      N         UD1   N      Y1   Y1      N
Cost reports to be utilized in the analysis of programmatic activities           N     N      Y3      N         UD1   N      Y1   Y1      N
Schedules and operating statements for financial stmt. prep. and audit.          N     N      Y3      N         UD1   N      Y1   Y1      N
Meaningful cost information needed to support performance measures.              N     N      Y3      N         UD1   N      Y1   Y1      N
Ability to transfer cost information directly to and from other systems.         N     N      Y3      N         UD4   N      Y1   Y1      N
Cost information for comparison to other program data                            N     N      Y3      N         UD1   N      Y1   Y1      N
Support of the billing process by providing cost info. to the rec. function      N     N      Y3      N         UD1   N      Y1   Y1      N
Identify and record direct costs incurred                                        N     N      Y1      Y1        UD1   N      Y1   Y1      N
Allocate indirect costs to interim and final cost objectives                     N     N      Y3      Y1        UD1   N      Y1   Y1      N
Allow for multilevel allocation and reallocation                                 N     N      Y3      Y1        UD1   N      Y1   Y1      N
Support variance analysis, adjustment of rates, and disposition of variance      N     N      Y3      Y1        UD1   N      Y1   Y1      N


                                                                A-11
                                                                                                                       ARC-DO-160001.100
                                                                                                                                07/03/11




                                                                                                       LUFS-NT




                                                                                                                              Financials

                                                                                                                              Integrated
                                                                                                                               Solution
                                                                                               AMMIS




                                                                                                                                           CMplus
                                                                                                                                Oracle
                                                                                        ACMS




                                                                                                                       GOLD



                                                                                                                                Oracle
                                                                                  EAL




                                                                                                                 FLS
                                  FUNCTIONS


Allocate costs to entities or cost centers regardless of how they were posted     N     N      Y3      Y1 UD1          N      Y1   Y1      N
Provide an audit trail from the original cost pool to the final cost objective.   N     N      Y3      Y1 UD1          N      Y1   Y1      N
Access to information
Allow for queries to present specific detailed data, per user-defined criteria    N     N      Y4      Y1        UD1   N      Y1   Y1      N
Present queries info. in a non-technical format                                   N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide for the production of formatted reports.                                  N     N      Y1      Y1        UD2   N      Y2   Y2      N
Allow users to design reports and extract files for their specific requirements   N     N      Y4      Y1        UD1   N      Y1   Y1      N
Allow transfer of report information to other applications or analytical tools.   N     N      Y4      Y1        UD1   N      Y1   Y1      N
Provide for easy access to historical files for comparative, analytical, trend    N     N      Y4      Y1        UD1   N      Y1   Y1      N
Print capabilities must be present for all all-line screens.                      N     N      Y4      Y1        UD1   N      Y1   Y1      N
Financial Reporting
Reports providing financial information, whether used internally or externally.   N     N      Y1      Y1        UD2   N      Y2   Y2      N
Permit reporting in accordance with FASAB                                         N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide summarized data electronically to systems used by the agency              N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide data in the format required, including electronic formats                 N     N      Y3      Y1        UD1   N      Y1   Y1      N
Report events and transactions according to the acctg. class. structure           N     N      Y1      Y1        UD2   N      Y2   Y2      N
Maintain info. required for program and financial management performance          N     N      Y3      Y1        UD1   N      Y1   Y1      N
Produce, distribute, and provide access to formatted reports                      N     N      Y1      Y1        UD2   N      Y2   Y2      N
System Monitoring
Determine if operations are on schedule, all necessary operating steps, etc.      N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide system statistics to determine the functions performed                    N     N      Y3      Y1        UD1   N      Y1   Y1      N
Perform and report the result of data integrity verifications                     N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide for sufficient audit trails to trace data errors                          N     N      Y3      Y1        UD1   N      Y1   Y1      N
Security, Internal Controls, and Technical Requirements
Provide a transaction identification scheme to trace to the source document       N     N      Y3      Y1 UD1          N      Y1   Y1      N
Provide a facility for tracing the status of documents.                           N     N      Y3      Y1 UD1          N      Y1   Y1      N


                                                                 A-12
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                   FUNCTIONS


Support authorization for access to specific system functions                    N     N      Y1      Y1        UD1   N      Y1   Y1      N
Control individual user access to specific transactions.                         N     N      Y1      Y1        UD1   N      Y1   Y1      N
Prevent the alteration of financial data except under proper security.           N     N      Y1      Y1        UD1   N      Y1   Y1      N
Provide specifically authorized users with control over data editing criteria.   N     N      Y1      Y1        UD3   N      Y1   Y1      N
Allow authorized personnel to add, change, or delete records.                    N     N      Y1      Y1        UD1   N      Y1   Y1      N
Ensure that the system maintains records on system use                           N     N      Y1      Y1        UD1   N      Y1   Y1      N
Limit user access by accounting class. code structure by various modes           N     N      Y3      Y1        UD1   N      Y1   Y1      N
Limit access to specific data files and/or programs                              N     N      Y1      Y1        UD1   N      Y1   Y1      N
Automatically synchronize and balance files and accounts.                        N     N      Y3      Y1        UD1   N      Y1   Y1      N
Maintain and report history of all changes to tables.                            N     N      Y1      Y1        UD1   N      Y1   Y1      N
Maintain productivity statistics about application usage.                        N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide safeguards to avoid or prevent damage of the accounting data             N     N      Y3      Y1        UD1   N      Y1   Y1      N
Provide the capability to automatically back out all incomplete transactions     N     N      Y1      Y1        UD1   N      Y1   Y1      N
Inventory-Related Financial Requirements
Compute and update varying ordering costs                                        N     N      Y1      N         UD2   N      Y2   Y2      N
Calculate fund usage and project the date funds will be exhausted                N     N      Y1      N         UD2   N      Y2   Y2      N
Value excess, obsolete, and unserviceable inventory at net realizable values     N     N      Y3      N         UD1   N      Y1   Y1      N
Management information on unfilled orders                                        N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on discrepancies                                          N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on acceptance and rejection summary                       N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on days supply                                            N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on master inventory                                       N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on inactive stock                                         N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on item expiration/shelf life                             N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on cycle count                                            N     N      Y1      N         UD2   N      Y2   Y2      N
Management information on inventory accuracy                                     N     N      Y1      N         UD2   N      Y2   Y2      N



                                                                   A-13
                                                                                                                           ARC-DO-160001.100
                                                                                                                                    07/03/11




                                                                                                           LUFS-NT




                                                                                                                                  Financials

                                                                                                                                  Integrated
                                                                                                                                   Solution
                                                                                                   AMMIS




                                                                                                                                               CMplus
                                                                                                                                    Oracle
                                                                                            ACMS




                                                                                                                           GOLD



                                                                                                                                    Oracle
                                                                                      EAL




                                                                                                                     FLS
                                   FUNCTIONS


Separately identify prior period amounts for repair expense and record adjust.        N     N      Y3      N         UD1   N      Y1   Y1      N
Record the value of items issued from storage or shipped to customers                 N     N      Y1      N         UD2   N      Y2   Y2      N
Provide quality controls over input data to the pricing model                         N     N      Y1      N         UD2   N      Y2   Y2      N
Establish methods to capture and accumulate costs for work-in-progress                N     N      Y4      N         UD1   N      Y1   Y1      N
Establish exception thresholds, perform cost analysis, and monitor trends             N     N      Y4      N         UD1   N      Y1   Y1      N
Record reasons for significant deviations between standard and actual costs           N     N      Y4      N         UD1   N      Y1   Y1      N
% of reports of item discrepancies filed with suppliers and other discrepancies       N     N      Y4      N         UD1   N      Y1   Y1      N
Percentage of shipments-on-time accuracy                                              N     N      Y3      N         UD1   N      Y1   Y1      N
Discrepancies by customer. Ratio of discrepancies by cust. to total sales             N     N      Y4      N         UD1   N      Y1   Y1      N
Price ratio of the cost of sample buys to published prices in catalogs                N     N      Y4      N         UD1   N      Y1   Y1      N
Turnover ratio                                                                        N     N      Y3      N         UD1   N      Y1   Y1      N
Ratio of administrative acquisition or order lead times to industry norms             N     N      Y4      N         UD1   N      Y1   Y1      N
Report of Discrepancy (ROD) processing time                                           N     N      Y3      N         UD1   N      Y1   Y1      N
A line item for "deferred maintenance accounts" on operating statement                N     N      Y3      N         UD1   N      Y1   Y1      N
Amounts disclosed for deferred maintenance                                            N     N      Y3      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - ID of each major class           N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - measure deferred mainten.        N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - description of requirements      N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - changes in condition             N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - asset condition & estimates      N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - original date of forecast        N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - prior year balance               N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - dollar amt. by professionals     N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - dollar amt. of performed         N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - diff. forecast - actual maint.   N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - adj. to scheduled amounts        N     N      Y4      N         UD1   N      Y1   Y1      N
Information for all property, plant, and equipment - ending cumulative balance        N     N      Y4      N         UD1   N      Y1   Y1      N


                                                                    A-14
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                  FUNCTIONS


Stratification between critical and non-critical amounts of maintenance needed   N     N      Y4      N         UD1   N      Y1   Y1      N
SUPPLY
Air Station
View Order – AS111000 Input/View Pending A/S Requisitions                        N     N      Y2      N         UD3 Y1       N    Y2      UD3
Release Requisition – AS220000 Input/Release A/S Requisitions to AR&SC           N     N      Y1      N         UD3 Y1       N    Y2      UD3
Backordered Local Orders –AS220100 View/Manage A/S Requisitions on
                                                                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
Backorder
Re-print NRFI Turn-Ins – AS221100 Reprint a list of 265 turn-ins                 N     N      Y1      N         UD3 Y3       N    Y4      UD3
View Requisition Status – AS230000 View status of A/S Requisitions               N     N      Y1      N         UD3 Y1       N    Y2      UD3
ARMS Requisitions – AS240000 Input/Manage ARMS Requisitions                      N     N      Y1      N         UD3 Y1       N    Y4      UD3
Cannibalization/ACMS Reports-AS250000 Print Cannibalization & ACMS
                                                                                 N     Y1     Y1      N         UD3 Y4       N    Y4      UD3
Reports
ALLDATA Type 3/5 Material – AS920000 View ALL DATA for Type 3/5
                                                                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
Material
Requisition History Query - DS171300 View the History of any Requisition         N     N      Y1      N         UD3 Y1       N    Y2      UD3
Manage Issue – AS312000 Issue components at the A/S level from A/S BOH.
                                                                                 N     Y1     Y2      N         UD3 Y1       N    Y2      UD3
(balance on hand)
Manage Direct Ship Receipts - AS321200 Process receipts for components that
                                                                                 N     Y1     Y4      N         UD3 Y1       N    Y2      UD3
are shipped directly from the Manufacturer to the A/S.
RFI Receipts fm Maintenance - AS321300 Receipt material back into A/S supply
from shops that is RFI. Will cancel Priority 12 requisitions, increment BOH, &   N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
fulfill any existing 265 turn-in requirements.
NRFI Turn-In fm Maintenance-AS341000 Receipt 265 material from shops             N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
Receipts from AR&SC – AS321100 Process receipts for material shipped from
                                                                                 N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
AR&SC to A/S
Receipt from Remote Locations-AS910000 Process Receipts from Remote
                                                                                 N     Y1     Y1      N         UD3 Y1       N    Y4      UD3
Locations


                                                                A-15
                                                                                                                         ARC-DO-160001.100
                                                                                                                                  07/03/11




                                                                                                         LUFS-NT




                                                                                                                                Financials

                                                                                                                                Integrated
                                                                                                                                 Solution
                                                                                                 AMMIS




                                                                                                                                             CMplus
                                                                                                                                  Oracle
                                                                                          ACMS




                                                                                                                         GOLD



                                                                                                                                  Oracle
                                                                                    EAL




                                                                                                                   FLS
                                  FUNCTIONS


Manage Discrepancies – AS322100 Manage receipt discrepancies from AR&SC
                                                                                    N     N      Y1      N         UD3 Y3       N    Y4      UD3
to A/S
Modify/Delete Discrepancies – AS322200 Modify/Delete Receipt Discrepancies          N     N      Y1      N         UD3 Y3       N    Y3      UD3
Physical Inv. (Gains/Losses) – AS331000 Enter Gains/Losses in A/S physical
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
inventory
Create New Survey – AS334100 Create survey for missing/damaged material             N     N      Y3      N         UD3 Y3       N    Y4      UD3
Manage Survey – AS334200 Modify/Delete existing surveys. Approve/Release
                                                                                    N     N      Y3      N         UD3 Y3       N    Y4      UD3
surveys to AR&SC.
Manage Location – AS335100 Create material locations. Change/Delete material
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
locations.
Multiple Location Updates – AS335200 Update material locations.                     N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
Generate Inventory Location Reports-AS335300 Run reports based on A/S
                                                                                    N     Y1     Y1      N         UD3 Y3       N    Y4      UD3
inventory locations.
Print Inventory Labels – AS335400 Print labels containing material identification
                                                                                    N     N      Y1      N         UD3 Y1       N    Y4      UD3
& location information for material in A/S physical inventory.
Query Incoming Shipment Manifest - AS342100 View manifests for incoming
                                                                                    N     N      Y1      N         UD3 Y3       N    Y3      UD3
A/S shipments from AR&SC.
GBL Process – AS343000 Create/Modify GBL for outgoing shipment                      N     N      Y1      N         UD3 Y3       N    Y3      UD3
Process Shipment – AS347000 Release shipment from A/S to AR&SC                      N     N      Y1      N         UD3 Y3       N    Y3      UD3
Maintain Remote Locations – AS900000 Create/Modify/Delete remote locations
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
for A/S material.
Monitor Stock Usage – AS410000 Monitor A/S stock usage                              N     Y1     Y1      N         UD3 Y4       N    Y2      UD3
Update/Delete OG30 Material-AS421000 Update/Delete OG30 material
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
information
Add OG30 Material – AS422000 Add OG30 material information                          N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
Generate/Print Surf Sheets – AS423000 Generate/Print Surf sheets for A/S
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y4      UD3
material.


                                                                A-16
                                                                                                                        ARC-DO-160001.100
                                                                                                                                 07/03/11




                                                                                                        LUFS-NT




                                                                                                                               Financials

                                                                                                                               Integrated
                                                                                                                                Solution
                                                                                                AMMIS




                                                                                                                                            CMplus
                                                                                                                                 Oracle
                                                                                         ACMS




                                                                                                                        GOLD



                                                                                                                                 Oracle
                                                                                   EAL




                                                                                                                  FLS
                                 FUNCTIONS


Manage Locations Type 3/5 – AS424000 Create/Update/Delete locations for A/S
                                                                                   N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
Type 3/5 material.
Manage OG30 Status – AS425000 Manage OG30 material status                          N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
OG30 Receipts & Issues – AS426000 Receipt for/Issue out OG30 material              N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
Print OG30 Master Records – AS427000 Print inventory of OG30 material              N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
Show OG30 Shortages – AS428000 View shortages in A/S BOH of OG30
                                                                                   N     Y1     Y1      N         UD3 Y3       N    Y3      UD3
material inventory
Establish ACR – AS430000 Create A/S allowance change request                       N     N      Y1      N         UD3 Y4       N    Y4      UD3
Maintain ACR Data – AS440000 View ACR Data                                         N     N      Y1      N         UD3 Y4       N    Y2      UD3
Print CGAS Allowance Data – AS450000 Print a list of material that the A/S has
                                                                                   N     Y1     Y1      N         UD3 Y3       N    Y2      UD3
an allowance for & what the BOH is.
Query Allow. Change Requests-DS512000 View status of allowance change
                                                                                   N     N      Y1      N         UD3 Y4       N    Y2      UD3
requests
Update/Delete GSE Inv. Data - DS542000 Update/Delete A/S ground support
                                                                                   N     Y1     Y4      N         UD3 Y3       N    Y2      UD3
equipment inventory data
Query GSE Inventory Data – DS543000 View A/S GSE inventory data                    N     Y1     Y4      N         UD3 Y3       N    Y2      UD3
Add UR – AS510000 Create unsatisfactory report                                     N     N      Y4      N         UD3 Y3       N    Y4      UD3
Update/Approve UR – AS520000 Make changes to URs. Approve/Forward URs
                                                                                   N     N      Y4      N         UD3 Y3       N    Y4      UD3
to AR&SC.
Query UR – AS530000 View existing URs.                                             N     N      Y4      N         UD3 Y3       N    Y4      UD3
UR Report – AS540000 Print a list of all A/S URs with current status of each UR.   N     N      Y4      N         UD3 Y3       N    Y4      UD3
Manage CGAS Reports – AS561000 List of all available A/S reports with option
                                                                                   N     Y1     Y1      N         UD3 Y3       N    Y3      UD3
to print any/all reports.
C.O.‘s Air Station Reports - AS611000 Report given to A/S C.O. containing
                                                                                   N     Y1     Y1      N         UD3 Y3       N    Y3      UD3
information regarding inventory overages/shortages and 265 turn-in information.
Depot
Manage Exception – DS130000 Modify/Delete/Cancel/Release exception                 N     N      Y1      N         UD3 Y1       N    Y2      UD3


                                                               A-17
                                                                                                                    ARC-DO-160001.100
                                                                                                                             07/03/11




                                                                                                    LUFS-NT




                                                                                                                           Financials

                                                                                                                           Integrated
                                                                                                                            Solution
                                                                                            AMMIS




                                                                                                                                        CMplus
                                                                                                                             Oracle
                                                                                     ACMS




                                                                                                                    GOLD



                                                                                                                             Oracle
                                                                               EAL




                                                                                                              FLS
                                FUNCTIONS


Requisitions
Manage ‗O‘ Exception Reqs. - DS130005 Modify/Release/Cancel OGA
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Exception Requisitions
Manage Backorders – DS130100 Release/Cancel/Modify Backorders                  N     N      Y1      N         UD3   Y1     N    Y2      UD3
265 Backorder Report – DS130200 Report of all 265 Backorders                   N     N      Y1      N         UD3   Y1     N    Y4      UD3
Backorder Rockwell Collins Mat.-DS132100 Screen not developed                  N     N      Y4      N         UD3   Y3     N    Y2      UD3
Manage Recommended Repairs–DS163000 Screen not developed                       N     Y1     Y4      N         UD3   Y3     N    Y2      UD3
Backorder Type 7 Material – DS131100 Place Type 7 material on backorder        N     N      Y3      N         UD3   Y1     N    Y2      UD3
Release Type 7 Material – DS131200 Release Type 7 material to the A/S          N     Y1     Y3      N         UD3   Y1     N    Y2      UD3
Manage Textron Receipts – DS311150 Process Receipts for Type 7 material        N     Y1     Y1      N         UD3   Y1     N    Y2      UD3
Manage Recommended Buy – DS161000 Screen not developed                         N     N      Y4      N         UD3   Y4     N    Y2      UD3
Create OGA Buy – DS161100 Screen not developed                                 N     N      Y4      N         UD3   Y4     N    Y2      UD3
Approve Recommended Buy – DS162000 Screen not developed                        N     N      Y4      N         UD3   Y3     N    Y2      UD3
Create OGA Requisition – DS164000 Create an OGA Requisition                    N     N      Y1      N         UD3   Y1     N    Y2      UD3
View OGA Requisition Status – DS165000 View status of OGA Requisitions         N     N      Y1      N         UD3   Y1     N    Y2      UD3
View OGA Requisition History-DS165100 View the history of any OGA
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Requisition
View MOV Requisition Status – DS165200 View MOV Requisition Status;
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Download MOVs to MILSTRIP; Delete MOVs.
Carcass Tracking – DS165300View status of AR&SC Requisitions on 265
                                                                               N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
Material
Re-Establish OGA Requisition-DS167000Modify/Update status of OGA
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Requisition
Process Material Request – DS171000Create Requisition for material requested
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
from A/S.
Repair Division Requisition-DS172000Requisitions entered by repair shops at
                                                                               N     N      Y1      N         UD3 Y1       N    Y2      UD3
AR&SC


                                                              A-18
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                FUNCTIONS


Manage Credit Issues – DS173000Credit Issue back to stock                        N     N      Y1      N         UD3 Y1       N    Y2      UD3
View Requisitions–DS173200 View/Update/ Cancel/Modify requisition at
                                                                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
AR&SC
Repair Div. Backorders by Shop-DS173250 Run Report to list, by shop, material
                                                                                 N     N      Y1      N         UD3 Y3       N    Y2      UD3
ordered by repair division at AR&SC that is backordered.
Repair Div. Backorders by I.M.-DS173260 Run report to list material ordered by
                                                                                 N     N      Y1      N         UD3 Y3       N    Y2      UD3
Item Managers that is on backorder.
Query Status Requests – DS173300 Query Requests for requisitions requiring
                                                                                 N     N      Y1      N         UD3 Y4       N    Y2      UD3
Item Manager action.
Maintain Requisition Status – DS173500 Print reports for requisition status      N     N      Y1      N         UD3 Y3       N    Y2      UD3
Manage Status – DS173600 Screen not developed                                    N     N      Y4      N         UD3 Y4       N    Y2      UD3
Release Inventory <Miscellaneous Issue> - DS174100 Release Inventory for
                                                                                 N     N      Y1      N         UD3 Y3       N    Y2      UD3
Issue
Miscellaneous Issues of Purchase Requests DS174150 View Miscellaneous PRs
                                                                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
Issued
Establish Due-In – DS174200 Establish Due-In for Repairable Material             N     N      Y1      N         UD3 Y1       N    Y2      UD3
Delete Non-Funded Due-Ins – DS174300 Delete Due-Ins for Non-funded
                                                                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
Material
Re-Print 1348-1 Issue Document-DS171100 Re-Print a 1348-1                        N     N      Y1      N         UD3 Y3       N    Y4      UD3
Re-Print Priority Issue Document-DS171110 Re-Print a Priority Requisition        N     N      Y1      N         UD3 Y3       N    Y4      UD3
Monitor Batch Requisition Process-DS171200 View number of requisitions by
                                                                                 N     N      Y1      N         UD3 Y3       N    Y3      UD3
document type and status
Requisition History Query – DS171300 View the history of any requisition         N     N      Y1      N         UD3 Y1       N    Y3      UD3
Issue and Receipt History Query-DS171400 View the issue & receipt history of
                                                                                 N     N      Y1      N         UD3 Y1       N    Y3      UD3
any NSN
Print Item Manager Report of Daily Trans. DS171500 Run report of all Item
                                                                                 N     N      Y1      N         UD3 Y3       N    Y3      UD3
Manager transactions for any given day(s).


                                                              A-19
                                                                                                                         ARC-DO-160001.100
                                                                                                                                  07/03/11




                                                                                                         LUFS-NT




                                                                                                                                Financials

                                                                                                                                Integrated
                                                                                                                                 Solution
                                                                                                 AMMIS




                                                                                                                                             CMplus
                                                                                                                                  Oracle
                                                                                          ACMS




                                                                                                                         GOLD



                                                                                                                                  Oracle
                                                                                    EAL




                                                                                                                   FLS
                                 FUNCTIONS


KANBAN Transaction Query – DS264000 Query any KANBAN Material
                                                                                    N     N      Y1      N         UD3 Y3       N    Y2      UD3
transaction
Re-Identify KANBAN Material-DS264100 Identify KANBAN Material and
                                                                                    N     N      Y1      N         UD3 Y3       N    Y2      UD3
enter data for that material
KANBAN Demand Query – DS264200 Demand information for KANBAN
                                                                                    N     N      Y1      N         UD3 Y3       N    Y2      UD3
items
Pre-AMMIS Trans. History-DS999998 Report containing any outstanding
                                                                                    N     N      Y1      N         UD3 Y4       N    Y4      UD3
transactions for a specific NIIN before AMMIS came on line.
Pre-AMMIS RSF History – DS999999 Report containing history of any
                                                                                    N     N      Y1      N         UD3 Y4       N    Y4      UD3
requisition that is still outstanding that was entered before AMMIS came on line.
Supply Study – DS250000 Change Parameters for ―what if‖ models                      N     N      Y4      N         UD3 Y4       N    Y4      UD3
Planned Program Requirements-DS260000 Plans long-range repairable
                                                                                    N     N      Y1      N         UD3 Y4       N    Y4      UD3
requirements for specific NSN
Update Model Parameters–DS261000 Update/Delete Param for ―what if‖ models           N     N      Y4      N         UD3 Y4       N    Y4      UD3
Add Model Params for NIIN - DS262100 Add repairable params for specific
                                                                                    N     N      Y1      N         UD3 Y3       N    Y4      UD3
NIIN
Update Model Param for NIIN-DS262200 Update/Modify repairable params for
                                                                                    N     N      Y1      N         UD3 Y3       N    Y4      UD3
specific NIIN
ALLDATA Query – DS910000 All data information for specific NIIN                     N     N      Y1      N         UD3   Y1     N    Y2      UD3
Maintain I.M. Access – DS921000 Add/Delete Item Managers                            N     N      Y1      N         UD3   Y3     N    Y2      UD3
ALLDATA II Query – DS930000 All data information for specific NIIN                  N     N      Y1      N         UD3   Y1     N    Y2      UD3
Receipts fm CGASs – DS311100 Process receipts for material received from A/S        N     Y1     Y1      N         UD3   Y1     N    Y2      UD3
Receipts fm Depot Maintenance-DS311200 Receive RFI Material back into stock
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
from shops at AR&SC
Receipts fm Commercial Vendor-DS311300 Process receipt for material received
                                                                                    N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
from a commercial vendor.
Receipts fm OGA – DS311400 Process receipts for OGA material received at            N     Y1     Y1      N         UD3 Y1       N    Y2      UD3


                                                                A-20
                                                                                                                       ARC-DO-160001.100
                                                                                                                                07/03/11




                                                                                                       LUFS-NT




                                                                                                                              Financials

                                                                                                                              Integrated
                                                                                                                               Solution
                                                                                               AMMIS




                                                                                                                                           CMplus
                                                                                                                                Oracle
                                                                                        ACMS




                                                                                                                       GOLD



                                                                                                                                Oracle
                                                                                  EAL




                                                                                                                 FLS
                                FUNCTIONS


AR&SC
Import Batch Receipt Data – DS311600 Process batch receipts uploaded from
                                                                                  N     N      Y1      N         UD3 Y4       N    Y4      UD3
warehouse
Manage Credit Receipts – DS311700 Back out receipts that have been done           N     Y1     Y1      N         UD3 Y3       N    Y4      UD3
Process Receipt Exceptions – DS313000 Process partial receipts                    N     N      Y4      N         UD3 Y1       N    Y4      UD3
Input Physical Inventory Data – DS321110 Input data based on physical inventory   N     N      Y1      N         UD3 Y1       N    Y3      UD3
Download Physical Inv. Data-DS321120 Download data from remote location
                                                                                  N     N      Y1      N         UD3 Y4       N    Y4      UD3
after physical inventory
Import Physical Inv. Data – DS321130 Import data from remote program based
                                                                                  N     N      Y1      N         UD3 Y4       N    Y4      UD3
on physical inventory.
Manage Location – DS321210 Modify/ Input/Delete physical location data            N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
Process Multi-location Updates-DS321220 Update multiple locations                 N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
Generate Location Reports–DS321230 Reports based on physical inventory
                                                                                  N     Y1     Y1      N         UD3 Y3       N    Y3      UD3
location
Print Inventory Labels – DS321400 Print labels containing location & other
                                                                                  N     N      Y1      N         UD3 Y1       N    Y4      UD3
information for any specific NSN
Print Inv. Labels for an OPFAC-DS321500 Print labels containing specific
                                                                                  N     N      Y1      N         UD3 Y1       N    Y4      UD3
information and location for all material at an A/S
Warehouse Refusals – DS324200 Process any warehouse refusals that have been
                                                                                  N     N      Y1      N         UD3 Y1       N    Y3      UD3
entered.
Physical Inv. (Gains/Losses) – DS324300 Process a gain or loss to the physical
                                                                                  N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
inventory at AR&SC
Manage Survey @ AR&SC – DS324410 Modify a survey for material at AR&SC            N     N      Y4      N         UD3   Y3     N    Y4      UD3
Process Survey – DS324420 Process all surveys                                     N     N      Y4      N         UD3   Y3     N    Y4      UD3
Create Survey @ AR&SC – DS324430 Create a survey for material at AR&SC            N     N      Y4      N         UD3   Y3     N    Y4      UD3
Cumulative 265 Turn In Report-DS325000 Print a report for all 265 turn-ins due    N     Y1     Y1      N         UD3   Y1     N    Y3      UD3
Delete RFI/NRFI Turn-Ins – DS325100 Delete due-ins for 265 turn-ins               N     Y1     Y1      N         UD3   Y1     N    Y2      UD3


                                                              A-21
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                FUNCTIONS


Re-Identify Inventory – DS326100 Change NSN, condition code, or location for
                                                                                 N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
a specific NSN
Obligate/Hold Repairables – DS326200 Obligates repairable material so that it
                                                                                 N     N      Y1      N         UD3 Y3       N    Y4      UD3
will not be issued
Manage Shipment Manifest – DS331000 Create/Modify a shipment manifest            N     N      Y1      N         UD3 Y1       N    Y3      UD3
Query Shipment Manifest – DS331100 View a manifest                               N     N      Y1      N         UD3 Y1       N    Y3      UD3
Manage Bill of Lading – DS332000 Create/Modify a GBL                             N     N      Y1      N         UD3 Y1       N    Y3      UD3
BL Selection – DS332100 Select a type of bill of lading based on method of
                                                                                 N     N      Y1      N         UD3 Y1       N    Y3      UD3
shipment
Print Shipping Labels – DS333000 Print shipping labels                           N     N      Y1      N         UD3   Y1     N    Y4      UD3
GBL Finalization – DS334000 Finalize GBL                                         N     N      Y1      N         UD3   Y1     N    Y3      UD3
Commercial BL–DS335000 Create/Modify A commercial bill of lading                 N     N      Y1      N         UD3   Y1     N    Y3      UD3
CBL Manifest – DS336000 Create/Modify a commercial shipment manifest             N     N      Y1      N         UD3   Y1     N    Y3      UD3
CBL Finalization–DS337000 Finalize CBL                                           N     N      Y1      N         UD3   Y1     N    Y3      UD3
Exception Finalization–DS338000 Finalize exceptions to existing bill of lading   N     N      Y1      N         UD3   Y3     N    Y3      UD3
Add BL Number Range-DS339000 Add bill of lading range of numbers to be
                                                                                 N     N      Y1      N         UD3 Y1       N    Y1      UD3
used
BL Usage Report-DS339100 Generate report to list bill of lading numbers used     N     N      Y1      N         UD3 Y1       N    Y1      UD3
Add Comp. Location Data – DS342100 Create component location record              N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
Update/Delete Comp. Location-DS342200 Update/Delete component location
                                                                                 N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
record
Query Comp. Location Data – DS342300 View component location records             N     Y1     Y1      N         UD3 Y1       N    Y1      UD3
Component Location Reports – DS342410 Report containing component location
                                                                                 N     Y1     Y1      N         UD3 Y1       N    Y3      UD3
data
Build Procurement Request – DS411100 Create/Route a PR                           N     N      Y1      N         UD3 Y1       N    Y2      UD3
Maintain Procurement Request – DS413100 Modify/Delete/Route a PR                 N     N      Y1      N         UD3 Y1       N    Y2      UD3
Monitor Procurement Request – DS414100 View a PR                                 N     N      Y1      N         UD3 Y1       N    Y2      UD3


                                                              A-22
                                                                                                                      ARC-DO-160001.100
                                                                                                                               07/03/11




                                                                                                      LUFS-NT




                                                                                                                             Financials

                                                                                                                             Integrated
                                                                                                                              Solution
                                                                                              AMMIS




                                                                                                                                          CMplus
                                                                                                                               Oracle
                                                                                       ACMS




                                                                                                                      GOLD



                                                                                                                               Oracle
                                                                                 EAL




                                                                                                                FLS
                                FUNCTIONS


Download Procurement Request-DS415300 Download a PR to await obligation          N     N      Y1      N         UD3   Y1     N    Y2      UD3
Route Procurement Request – DS422000 Route/Query a PR                            N     N      Y1      N         UD3   Y1     N    Y2      UD3
Query Obligation Transaction-PR000006 Query obligation transactions              N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Receipt Transaction – PR000007 Query receipt transactions                  N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Commitment Trans. – PR000008 Query commitment transactions                 N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Routed/Unrouted PR - PR424000 Query any PR                                 N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Create Vendor–DS413401 Add new vendor                                            N     Y1     Y1      Y1        UD3   Y1     Y1   Y2      UD3
Maintain Vendor – DS413402 View/Modify vendor data                               N     Y1     Y1      Y1        UD3   Y1     Y1   Y2      UD3
Generate Vendor Due-In Report-PR415911 Report containing material due-in by
                                                                                 N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
vendor
Vendor Master Data Report – PR413450 Report containing all vendors               N     Y1     Y1      Y1 UD3 Y3              Y1   Y3      UD3
Un-route PR – DS411300 Un-route a PR to allow changes                            N     N      Y1      Y1 UD3 Y3              Y1   Y2      UD3
Generate SF281 Qtrly. Report-DS415281Run SF281 report                            N     N      Y1      Y1 UD3 Y1              Y1   Y2      UD3
Receipt Reject Research Rep.-DS415400Run report containing all receipt rejects
                                                                                 N     N      Y1      N         UD3 Y3       N    Y3      UD3
and available data
Download PO/DO – DS415700 Download Purchase/Delivery Order to be
                                                                                 N     N      Y1      Y1 UD3 Y1              N    Y2      UD3
obligated
Generate CIS Report – DS415800 Run CIS Report                                    N     N      Y1      Y1 UD3 Y1              Y1   Y3      UD3
Download Contract Act. Rep. – DS415900 Generate report containing all contract
                                                                                 N     N      Y1      N         UD3 Y3       N    Y3      UD3
actions for specific time period
Generate Due-In Report–DS415910 Generate report for material due in from
                                                                                 N     N      Y1      N         UD3 Y3       Y1   Y3      UD3
vendor
Due-In Report by NIIN–DS415915 Report for material due in for a specific NIIN    N     N      Y1      N UD3 Y3               Y1   Y3      UD3
Document Closeout Report – DS415920 Report for contracts that are closed out     N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
Query Procurement Shipping Data -DS415925 Report listing material shipped;
                                                                                 N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
Run by NSN/Date/Document No.



                                                              A-23
                                                                                                                       ARC-DO-160001.100
                                                                                                                                07/03/11




                                                                                                       LUFS-NT




                                                                                                                              Financials

                                                                                                                              Integrated
                                                                                                                               Solution
                                                                                               AMMIS




                                                                                                                                           CMplus
                                                                                                                                Oracle
                                                                                        ACMS




                                                                                                                       GOLD



                                                                                                                                Oracle
                                                                                  EAL




                                                                                                                 FLS
                                 FUNCTIONS


Query Inspection/Acceptance Report – DS415930 Report listing material
                                                                                  N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
received/accepted/rejected; Run by document number
Generate Delivery Performance Report – DS415940 Report listing material
                                                                                  N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
delivery performance; Run by document number
Vendor Performance Report - DS415945 Report listing vendor delivery
                                                                                  N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
performance
Generate Commit Status Report-DS415950 Report listing all commitments             N     N      Y1      Y1 UD3 Y1              Y1   Y3      UD3
Generate Duplicate Receipts Report – DS415960 Report listing duplicate receipts
                                                                                  N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
for a specific time period
Generate Outstanding Obligations /Accounts Payable Report – DS415970 Report
listing all outstanding obligations by fiscal year, vendor, or Pre-AMMIS          N     N      Y1      N         UD3 Y4       N    Y3      UD3
document.
Generate Action Code 88 Receipt Report – DS415975 Action Code 88 Report           N     N      Y1      N         UD3   Y4     N    Y3      UD3
Modify Accts. Payable Transactions – DS415985 Modify AP Transactions              N     N      Y1      Y1        UD3   Y4     Y1   Y2      UD3
Create Procurement Obligation-PR000001 Create an obligation/obligate funds        N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Manage Procurement Obligation-PR000002View/Modify an obligation                   N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Obligation Transaction-PR000003 View obligation transactions                N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Receipt Transaction-PR000004 View Procurement receipt transactions          N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Query Commitment Transaction-PR000005 View commitment transactions                N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Maintain PR Section/Specialist-PR000009 Enter PR authorization data               N     N      Y1      Y1        UD3   Y1     Y1   Y2      UD3
Maintain Contracting Officers-DS442104 Add authorized contracting officers        N     N      Y1      Y1        UD3   Y1     Y1   Y3      UD3
Maintain Authorized Req.–PR400000 Add/ Update/Delete authorized
                                                                                  N     N      Y1      Y1 UD3 Y1              Y1   Y3      UD3
requisitioners
Maintain Branch Codes – PR400004 Add/Update/Delete branch codes                   N     N      Y1      Y1        UD3   Y1     Y1   Y3      UD3
Maintain Section Codes – PR400007 Add/Update/Delete section codes                 N     N      Y1      Y1        UD3   Y1     Y1   Y3      UD3
Maintain Document Types – PR400010 Add/Update/Delete document types               N     N      Y1      Y1        UD3   Y1     Y1   Y3      UD3
Authorized A/P Personnel-PR400011 Add/ Delete/authorized accounts payable         N     N      Y1      Y1        UD3   Y1     Y1   Y3      UD3


                                                              A-24
                                                                                                                        ARC-DO-160001.100
                                                                                                                                 07/03/11




                                                                                                        LUFS-NT




                                                                                                                               Financials

                                                                                                                               Integrated
                                                                                                                                Solution
                                                                                                AMMIS




                                                                                                                                            CMplus
                                                                                                                                 Oracle
                                                                                         ACMS




                                                                                                                        GOLD



                                                                                                                                 Oracle
                                                                                   EAL




                                                                                                                  FLS
                                 FUNCTIONS


Authorized SF281 Personnel – PR400012 Add/Delete authorized SF281 report
                                                                                   N     N      Y1      Y1 UD3 Y1              Y1   Y3      UD3
personnel
Authorized OPFAC Add. Pers.-PR400013 Add/Modify/Delete OPFAC address
                                                                                   N     N      Y1      Y1 UD3 Y3              Y1   Y3      UD3
personnel
Maintain SIC Codes – PR400014 Add/Update/Delete SIC Codes                          N     N      Y1      Y1 UD3 Y1              Y1   Y3      UD3
Maintain Remote Locations – AS900000 View remote locations (A/S Supply
                                                                                   N     Y1     Y1      N         UD3 Y1       N    Y2      UD3
Menu)
Establish ACR – AS430000 Establish/ submit allowance change request (A/S
                                                                                   N     N      Y1      N         UD3 Y3       N    Y4      UD3
Supply Menu)
Maintain ACR Data – AS440000 View ACRs (A/S Supply Menu)                           N     N      Y1      N         UD3 Y3       N    Y4      UD3
Manage Allow. Change Requests-DS511000 View ACRs                                   N     N      Y1      N         UD3 Y3       N    Y4      UD3
Query Allow. Change Requests-DS512000 Query ACRs                                   N     N      Y1      N         UD3 Y3       N    Y4      UD3
Fill Air Station Shortages – DS513000 Generate Requisitions to fill A/S material
                                                                                   N     N      Y1      N         UD3 Y3       N    Y4      UD3
shortages based on A/S allowance data
Manage Change Kits Update/Order Parts – DS531000 Update/Order parts for
                                                                                   N     N      Y1      N         UD3 Y3       N    Y4      UD3
change kits
Add GSE Inventory Data – DS541000 Add GSE Data                                     N     Y1     Y4      N         UD3 Y3       N    Y3      UD3
Update/Delete GSE Inv. Data-DS542000 Update/Delete GSE Inventory Data              N     Y1     Y4      N         UD3 Y3       N    Y3      UD3
Query GSE Inventory Data – DS543000 Query/Run report for GSE Inventory
                                                                                   N     Y1     Y4      N         UD3 Y3       N    Y3      UD3
Data
Enter Basic A/C Allow. Data – DS551000 Enter aircraft allowance data               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Update/Del. Basic A/C Allow. – DS552000 Update/Delete A/C allowance list
                                                                                   N     N      Y1      N         UD3 Y1       N    Y2      UD3
data
Query Basic A/C Allow. Data – DS553000 Query A/C allowance list data               N     N      Y1      N         UD3 Y1       N    Y2      UD3
Basic A/C Allow. Value Report-DS554000 Report for value of allowance
                                                                                   N     N      Y1      N         UD3 Y3       N    Y3      UD3
quantity and value of BOH at the A/S level
Establish MID Request – DS621100 Enter Material Identification Data Request        N     N      Y1      N         UD3 Y3       N    Y2      UD3


                                                                A-25
                                                                                                                    ARC-DO-160001.100
                                                                                                                             07/03/11




                                                                                                    LUFS-NT




                                                                                                                           Financials

                                                                                                                           Integrated
                                                                                                                            Solution
                                                                                            AMMIS




                                                                                                                                        CMplus
                                                                                                                             Oracle
                                                                                     ACMS




                                                                                                                    GOLD



                                                                                                                             Oracle
                                                                               EAL




                                                                                                              FLS
                               FUNCTIONS


Update MID Request – DS621200 Update/Modify Material Identification Data
                                                                               N     N      Y1      N         UD3 Y3       N    Y2      UD3
Request
Verify SIS MID Request – DS621300 Verify SIS MID Request                       N     N      Y1      N         UD3   Y3     N    Y2      UD3
Verify IM MID Request – DS621350 Verify Item Manager MID Request               N     N      Y1      N         UD3   Y3     N    Y2      UD3
Update MID (SIS Data) – DS621400 Update MID                                    N     N      Y1      N         UD3   Y3     N    Y2      UD3
Stock Number Modification – DS621450 Modify NSN Data                           N     Y1     Y1      N         UD3   Y1     N    Y3      UD3
Update MID (IM Remarks) – DS621500 MID remarks entered by Item Manager         N     N      Y1      N         UD3   Y3     N    Y3      UD3
CG Flight Critical Items-DS621600 Add/ Modify/Delete U.S. Coast Guard Flight
                                                                               N     Y1     Y1      N         UD3 Y1       N    Y4      UD3
Critical Items
Manage I&S Data – DS622000 Enter Interchangeability and Substitutability
                                                                               N     N      Y1      N         UD3 Y1       N    Y4      UD3
(I&S) data; Run I&S Report
Migrate to Head of Family - DS622600 Attach NSNs to Head of Family NSNs        N     N      Y1      N         UD3   Y3     N    Y4      UD3
Manage IPB Data - DS623000 Enter IPB Data                                      N     N      Y1      N         UD3   Y4     N    Y4      UD3
Manage P/N Cross Reference – DS623700 Enter P/N Cross Reference Data           N     N      Y1      N         UD3   Y3     N    Y3      UD3
Manage Cross Reference Data–DS624000 View Cross Reference Data                 N     N      Y1      N         UD3   Y3     N    Y4      UD3
Query I&S Data – DS628000 View I&S data; Run report listing I&S data           N     N      Y1      N         UD3   Y3     N    Y3      UD3
Query DLSC Passthru – DS631000 Query DLSC Data                                 N     N      Y1      N         UD3   Y4     N    Y4      UD3
Create DLSC Transaction – DS633100 Create DLSC transaction                     N     N      Y1      N         UD3   Y4     N    Y4      UD3
Modify/Delete DLSC Trans. – DS633200 Modify/Delete DLSC transaction            N     N      Y1      N         UD3   Y4     N    Y4      UD3
Release DLSC Transaction – DS633300 Release transaction to DLSC                N     N      Y1      N         UD3   Y4     N    Y4      UD3
Display DLSC Transaction – DS633400 View DLSC transaction                      N     N      Y1      N         UD3   Y4     N    Y4      UD3
Pre-AMMIS Journal Vouc. Inq.-FA999995 Report listing Pre-AMMIS JVs             N     N      Y1      N         UD3   Y4     N    Y4      UD3
Pre-AMMIS Invoice Inquiry – FA999996 Report listing Pre-AMMIS invoices         N     N      Y1      N         UD3   Y4     N    Y4      UD3
Pre-AMMIS GBL Inquiry – FA999997 Report listing Pre-AMMIS GBLs                 N     N      Y1      N         UD3   Y4     N    Y4      UD3
Pre-AMMIS Data Pay. Inq.-FA999998 Report listing Pre-AMMIS payment
                                                                               N     N      Y1      N         UD3 Y4       N    Y4      UD3
information



                                                            A-26
                                                                                                                    ARC-DO-160001.100
                                                                                                                             07/03/11




                                                                                                    LUFS-NT




                                                                                                                           Financials

                                                                                                                           Integrated
                                                                                                                            Solution
                                                                                            AMMIS




                                                                                                                                        CMplus
                                                                                                                             Oracle
                                                                                     ACMS




                                                                                                                    GOLD



                                                                                                                             Oracle
                                                                               EAL




                                                                                                              FLS
                               FUNCTIONS


Pre-AMMIS Liqu. Obliga. Inq.-FA999999 Report listing Pre-AMMIS obligation
                                                                               N     N      Y1      N         UD3 Y4       N    Y4      UD3
liquidation information
Direct Shipments
Support Direct Shipment, EDI auth., EDI name & password, & notif. codes        N     N      Y1      N         UD3   Y1     N    Y1      UD3
Indicate items directly shippable and allow to be marked & selected            N     N      Y1      N         UD3   Y3     N    Y2      UD3
Create Web-enabled Vendor's screens                                            N     N      N       N         UD3   Y2     N    Y2      UD3
Ties between the Inventory Item Master and the vendor file                     N     N      Y4      N         UD3   Y3     N    Y3      UD3
Parts Pooling
Recognition of the geographic region and time zone that Air Station is in      N     N      N       N         UD3 Y4       N    Y4      UD3
Parts Pooling Proposal/Acceptance Screen                                       N     N      Y1      N         UD3 Y4       N    Y2      UD3
Manage Parts Pool Transactions Screen                                          N     N      Y2      N         UD3 Y4       N    Y2      UD3
Remote Locations
Multi-level inventory location identifiers - written and submitted             N     N      N       N         UD3   Y4     N    Y4      UD3
Indicate DEPLOYED, OPCON, ADCON, AND OPBAT on any screens, reports             N     N      N       N         UD3   Y4     N    Y4      UD3
Expanded usage of Supplementary Address for parts shipment                     N     N      N       N         UD3   Y4     N    Y4      UD3
Web site for Air Station and Vendor communication regarding shipment, & rec.   N     N      N       N         UD3   Y4     N    Y4      UD3
Warranty and Maintenance Contract items need to be flagged by serial #         N     N      N       N         UD3   Y4     N    Y4      UD3
SCHEDULED MAINTENANCE
ACMS/ATS Maintenance System
File Maintenance
Enroll new component parts into tracking system. ACMS1110                      N     Y1     N       N         UD3   UD3    N     N      Y4
Review last maintenance activity completed on assigned CMS code. ACMS1120      N     Y1     N       N         UD3    N     N     N      Y4
Capture free form entry of component significant historical data. ACMS1130     N     Y1     N       N          N    UD3    N     N      N
Provide ability to review all existing TCTO's by aircraft type. ACMS1140       N     Y1     N       N          N    UD3    N     N      N
Provide ability to review TCTO's by TCTO chapter number. ACMS1141              N     Y1     N       N          N    UD3    N     N      N
Capture TCTO tracking up-date data to include TCTO number. ACMS1142.1          N     Y1     N       N          N    UD3    N     N      N


                                                            A-27
                                                                                                                       ARC-DO-160001.100
                                                                                                                                07/03/11




                                                                                                      LUFS-NT




                                                                                                                              Financials

                                                                                                                              Integrated
                                                                                                                               Solution
                                                                                              AMMIS




                                                                                                                                           CMplus
                                                                                                                                Oracle
                                                                                       ACMS




                                                                                                                       GOLD



                                                                                                                                Oracle
                                                                                 EAL




                                                                                                                 FLS
                                FUNCTIONS


Capture TCTO tracking up-date data. ACMS1142                                     N     Y1     N       N         N      UD3    N     N      N
Capture TCTO tracking up-date data to include TCTO title. ACMS1142.2             N     Y1     N       N         N      UD3    N     N      N
Capture TCTO tracking up-data data to include date TCTO was initiated.
                                                                                 N     Y1     N       N         N      UD3    N     N      N
ACMS1142.3
Capture TCTO tracking up-date data to include TCTO voided (Y/N).
                                                                                 N     Y1     N       N         N      UD3    N     N      N
ACMS1142.4
Capture TCTO tracking up-date data to include date TCTO received at AR&SC.
                                                                                 N     Y1     N       N         N      UD3    N     N      N
ACMS1142.5
Capture TCTO tracking up-date data to include date TCTO has been included on
                                                                                 N     Y1     N       N         N      UD3    N     N      N
MRL. ACMS1142.7
Capture TCTO tracking up-date data to include date TCTO was complied with.
                                                                                 N     Y1     N       N         N      UD3    N     N      N
ACMS1142.8
Provide ability to transfer a component from one location to another. ACMS1150   N     Y1     N       N         UD3 UD3       N     N      Y2
Capture part information change data. (new part #, serial #, manufacturer)
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y2
ACMS1160
Capture part information change data to include new part number. ACMS1161        N     Y1     N       N         UD3 UD3       N     N      Y2
Capture part information change data to include new serial number. ACMS1162      N     Y1     N       N         UD3 UD3       N     N      Y2
Capture part information change data to include new manufacturer. ACMS1163       N     Y1     N       N         UD3 UD3       N     N      Y2
Capture part information change data to include new bar code number.
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y2
ACMS1164
File Management
Show batch file active queue. ACMS1210                                           N     Y1     N       N         UD3 UD3       N     N      N
Provide ability to transfer queued files from the ACMS computer to a defined
                                                                                 N     Y1     N       N         N      N      N     N      N
computer. ACMS1220
MPC Sign-off
Capture MPC sign-off data will identify personnel completing maintenance
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y4
actions. ACMS1318


                                                              A-28
                                                                                                                       ARC-DO-160001.100
                                                                                                                                07/03/11




                                                                                                      LUFS-NT




                                                                                                                              Financials

                                                                                                                              Integrated
                                                                                                                               Solution
                                                                                              AMMIS




                                                                                                                                           CMplus
                                                                                                                                Oracle
                                                                                       ACMS




                                                                                                                       GOLD



                                                                                                                                Oracle
                                                                                 EAL




                                                                                                                 FLS
                                 FUNCTIONS


Capture MPC sign-off data to include personnel rating man-hours expended.
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y4
ACMS1319
Capture MPC sign-off data to include CMS Code. ACMS1311                          N     Y1     N       N         UD3 UD3       N     N      Y4
Capture MPC sign-off data to include Aircraft type work has been completed on.
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y4
ACMS1310
Capture MPC sign-off data to include MPC revision date. ACMS1312                 N     Y1     N       N         UD3    UD3    N     N      Y4
Identify MPC sign-off as scheduled or unscheduled. ACMS1313                      N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include NHA serial number. ACMS1314                 N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include component serial number. ACMS1315           N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include component part number. ACMS1316             N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include part number flag. ACMS1317                  N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include MPC Bar Code data. ACMS1341                 N     Y1     N       N         UD3    UD3    N     N      Y4
Capture MPC sign-off data to include date maintenance was completed.
                                                                                 N     Y1     N       N         UD3 UD3       N     N      Y4
ACMS1342
MPC sign-off data to include Continue Acceptance option (Y/N). ACMS1344          N     Y1     N       N         N      N      N     N      Y4
MPC sign-off data to include Discrepancies Found (Y/N) input. ACMS1321           N     Y1     N       N         N      N      N     N      Y4
Allow for MPC sign-off to be accomplished in the following areas: (Avionics,
                                                                                 N     Y1     N       N         N      UD3    N     N      N
Aircraft, Special and Mandatory Special Requirements) ACMS1300
Capture MPC sign-off data to include free form remarks. ACMS1322                 N     Y1     N       N         UD3 UD3       N     N      Y4
Capture MPC sign-off data to include component position. ACMS1340.1              N     Y1     N       N         UD3 UD3       N     N      Y4
Capture MPC sign-off data to include RFI or NRFI status of component.
                                                                                 N     Y1     N       N         N      UD3    N     N      Y4
ACMS1343
Report Generation
Produce a component Configuration Report. ACMS1401                               N     Y1     N       N         UD3 UD3       N     N      Y4
Produce a Maintenance Due List. ACMS1402                                         N     Y1     N       N         UD3 UD3       N     N      Y4
Produce a Status Report of the most recent occurrence of selected maintenance
                                                                                 N     Y1     N       N         N      UD3    N     N      N
actions by aircraft type MPC, SR Mandatory SR. ACMS1403


                                                               A-29
                                                                                                                            ARC-DO-160001.100
                                                                                                                                     07/03/11




                                                                                                           LUFS-NT




                                                                                                                                   Financials

                                                                                                                                   Integrated
                                                                                                                                    Solution
                                                                                                   AMMIS




                                                                                                                                                CMplus
                                                                                                                                     Oracle
                                                                                            ACMS




                                                                                                                            GOLD



                                                                                                                                     Oracle
                                                                                      EAL




                                                                                                                      FLS
                                   FUNCTIONS


Produce a Significant Component History Report. ACMS1404                              N     Y1     N       N          N     UD3    N     N      Y4
Produce an Overdue Maintenance Due List. ACMS1405                                     N     Y1     N       N         UD3    UD3    N     N      Y4
Produce a Search and Rescue Deployed Equipment Report. ACMS1406                       N     Y1     N       N          N      N     N     N      Y4
Produce a Maintenance Requirements List. ACMS1407                                     N     Y1     N       N         UD3    UD3    N     N      Y4
Produce a Component Summery Report. ACMS1408                                          N     Y1     N       N         UD3    UD3    N     N      Y4
Produce a CMS Code History Report. ACMS1409                                           N     Y1     N       N          N      N     N     N      N
Produce a Component Removal Explanation Report. ACMS1410                              N     Y1     N       N         UD3     N     N     N      Y4
Produce a Performance and Reliability Summery Report. ACMS1411                        N     Y1     N       N          N     UD3    N     N      Y4
Produce an Inspection and Services Summery. ACMS1412                                  N     Y1     N       N          N     UD3    N     N      Y4
Produce a PDM Maintenance Due List (AR&SC only). ACMS1413                             N     Y1     N       N          N     UD3    N     N      Y4
Produce a Component Monitoring Status Report. ACMS1414                                N     Y1     N       N          N     UD3    N     N      Y4
Produce a Comprehensive TCTO Status Report. ACMS1415                                  N     Y1     N       N          N     UD3    N     N      N
Produce a component Trend Analysis Report. ACMS1416                                   N     Y1     N       N         UD3    UD3    N     N      Y4
Produce a Special HC-130 MDG Summery Report. ACMS1417                                 N     Y1     N       N          N      N     N     N      N
Produce a Service Bulletin/TCTO Compliance Report. ACMS1418                           N     Y1     N       N         UD3    UD3    N     N      N
Produce a CMS Code Status Report. ACMS1419                                            N     Y1     N       N         UD3     N     N     N      Y4
Produce an A & P Tech History Report. ACMS1420                                        N     Y1     N       N          N      N     N     N      N
Produce a Unit Inventory Summary. ACMS1421                                            N     Y1     N       N         UD3    UD3    N     N      Y4
Produce an In Transit Summary Report. ACMS1422                                        N     Y1     N       N         UD3    UD3    N     N      Y4
EAL
Automate the CG-4377, CG5181 and AFTO781J
A monthly ASR on aviation maintenance that enables an Air Station to compare
itself with the rest of the fleet. It is to provide a complete data description and   UD1 Y1       N       N         N      UD3    N     N      N
generate an op stat report replacing current algorithms. (that is one AS vs fleet)
Provide real-time data entry, validation, and response capabilities including
                                                                                      UD1 Y1       Y1      N         UD3 UD3       N     N      N
training requirements and qualification expiration data.
Define the events (time) after which data is locked (I.e. data cannot be changed).    UD1 Y1       Y1      N         UD3 UD3       N     N      N


                                                                   A-30
                                                                                                                               ARC-DO-160001.100
                                                                                                                                        07/03/11




                                                                                                              LUFS-NT




                                                                                                                                      Financials

                                                                                                                                      Integrated
                                                                                                                                       Solution
                                                                                                      AMMIS




                                                                                                                                                   CMplus
                                                                                                                                        Oracle
                                                                                               ACMS




                                                                                                                               GOLD



                                                                                                                                        Oracle
                                                                                         EAL




                                                                                                                         FLS
                                   FUNCTIONS


Determine if there is a requirement for pilots to specifically document "no
                                                                                         UD1 N        N       N         N      UD3    N     N      N
discrepancies" on the pink sheet following a flight with no discrepancies.
Each mouse click must be supported by a corresponding key combination and that
                                                                                         UD1 N        N       N         N      UD3    N     N      Y4
the key combination is identified as appropriate
Provide automatic generation of a Monthly Operating Report (MORPT).                      UD1 Y4       Y4      N         N      UD3    N     N      N
Provide for auto entry w/ mandatory user verification of MPC card revision date.
                                                                                         UD1 Y1       N       N         UD3 UD3       N     N      Y4
Requires auto interface with ACMS per CWO Hall)
The approach and operation sections of the aircrew logbook printout will be
formatted in column order ―# Type Condition‖ so pilots can verify their                  UD1 N        Y3      N         N      N      N     N      N
minimums.
Define type of night approaches on the Deficiency Report.                                UD1 N        Y3      N         N      N      N     N      N
Provide locally customizable lookup tables (Such as local employment codes)              UD1 N        Y1      N         N      N      N     N      N
Provide advanced notice of cyclical aircrew quals coming due (I.e. pilot inst
                                                                                         UD1 N        Y3      N         N      N      N     N      N
check)
Track swimmer minimums on a quarterly basis.                                             UD1 N        Y1      N         N      N      N     N      N
Track fixed wing drops by raft and either a pump/radio/utility can.                      UD1 N        Y1      N         N      N      N     N      N
Track Helicopter Flight Mechanic hoists by category: Hoist or Boat Hoist.                UD1 N        Y1      N         N      N      N     N      N
Track programmed flight hours based on type/model of aircraft and include this
                                                                                         UD1 N        Y1      N         N      N      N     N      N
information on the Air Station Report.
The GUI shall provide the ability to product charts and graphs to support EAL
                                                                                         UD1 N        N       N         N      N      N     N      Y4
reports.
Inputs to the Air Station Report include: Number of days in the month, number of
aircraft, and number of programmed hours (automatically calculate the monthly            UD1 N        Y3      N         N      N      N     N      N
programmed hours based on the number of days in the month),.
Inputs to the Air Station Report include: Total flight hours to date - all aircraft in
                                                                                         UD1 N        Y1      N         N      N      N     N      N
Type / model




                                                                    A-31
                                                                                                                            ARC-DO-160001.100
                                                                                                                                     07/03/11




                                                                                                           LUFS-NT




                                                                                                                                   Financials

                                                                                                                                   Integrated
                                                                                                                                    Solution
                                                                                                   AMMIS




                                                                                                                                                CMplus
                                                                                                                                     Oracle
                                                                                            ACMS




                                                                                                                            GOLD



                                                                                                                                     Oracle
                                                                                      EAL




                                                                                                                      FLS
                                  FUNCTIONS


Automatically calculate flight time from take-off and landing times but allow for
                                                                                      UD1 N        Y3      N         N      N      N     N      N
pilot correction.. Can correct data but not calculations.
Allow for review by maintenance control: deployment data, day/night operations,
actual/simulator instrument co-pilot and crew position, and end of day flight data.   UD1 N        Y1      N         N      N      N     N      N
Subject to aircraft manager review.
Pilot will be able to sign for aircraft at maintenance control on line.               UD1 N        N       N         N      N      N     N      N
Produce a Flight Crew Training and Qualifications Report including
qualifications/dates, day reported on board, date entered syllabus, and date          UD1 N        Y1      N         N      N      N     N      N
completed syllabus.
Provide the ability to record aircraft ground operation time and number of engine
                                                                                      UD1 Y1       N       N         UD3 UD3       N     N      N
cycles.
Provide ability to add engine ground operating time and # of engine operating
                                                                                      UD1 Y3       N       N         UD3 UD3       N     N      N
cycles to flight time.
Provide ground Ops the ability to add # of cycles (this flight) and calculate new
                                                                                      UD1 Y3       N       N         UD3 UD3       N     N      N
totals
Explore and identify possible interfaces Clinic Automated Management System
(CLAMS) in order to access flight physical status. Identify value such interfaces     UD1 N        N       N         N      N      N     N      N
and estimated LOE to establish.
Allow review of change in Aircraft maintenance status and causes (discrepancies
                                                                                      UD1 N        N       N         UD3 UD3       N     N      Y4
from pink sheet) (back_flights or 365 calendar days)
Design the application for user access via GUI on CG SWIII computers in a
                                                                                      UD1 N        N       N         UD3 UD3       N     N      Y2
Windows NT Environment.
Capture data currently documented on paper using the CG 4377 Part 1
                                                                                      UD1 N        N       N         N      N      N     N      N
Capture data currently documented on paper using the CG 4377 Part 2                   UD1 N        Y1      N          N   N        N     N      N
Capture data currently documented on paper using the CG 4377 Part 3                   UD1 N        N       N         UD3 UD3       N     N      Y4




                                                                  A-32
                                                                                                                           ARC-DO-160001.100
                                                                                                                                    07/03/11




                                                                                                          LUFS-NT




                                                                                                                                  Financials

                                                                                                                                  Integrated
                                                                                                                                   Solution
                                                                                                  AMMIS




                                                                                                                                               CMplus
                                                                                                                                    Oracle
                                                                                           ACMS




                                                                                                                           GOLD



                                                                                                                                    Oracle
                                                                                     EAL




                                                                                                                     FLS
                                  FUNCTIONS


Capture data currently documented on paper using related maintenance form CG
                                                                                     UD1 N        N       N         UD3    N      N     N      N
4377a (maintenance release)
Capture data currently documented on paper using related maintenance form 781J       UD1 Y1       N       N         N      UD3    N     N      N
Capture data currently documented on paper using related maintenance form
                                                                                     UD1 N        N       N         UD3 UD3       N     N      Y4
CG5181 Carry Forward
Electronically Capture data currently manually entered on the Aircraft Statistics
                                                                                     UD1 Y1       N       N         N      N      N     N      N
Report (ASR)
Design is to include single point of data entry and automatically update the data
                                                                                     UD1 Y1       Y1      N         UD3 UD3       N     N      N
throughout the application
The application shall provide for non-ambiguous, narrowly focused, drop down
lists to document discrepancies and corrective actions. Research other sources and   UD1 Y4       Y4      N         UD3    N      N     N      N
develop a recommended list per CWO Hall 11/16/98
The application shall provide built in error checking for all user entered data      UD1 Y1       Y1      N         UD3 UD3       N     N      Y4
The contractor shall survey for additional maintenance data concerning aircraft
servicing recorded in maintenance documentation and shall include provisions for
                                                                                     UD1 N        N       N         N      N      N     N      Y4
capturing this data electronically. Such as SAMI TIMI CAMI, remarks block and
fluids O2 fuel.
The Application shall provide automatic input to the U.S. Coast Guard Abstract of
                                                                                     UD1 N        Y1      N         N      N      N     N      N
Operations Report
The Application shall require the input of a password or personal identification
                                                                                     UD1 Y1       Y1      N         UD3 UD3       N     N      N
number (PIN) to verify maintenance action taken (explore various input methods)
The EAL requirements are to include those identified in the Task Order               UD1 Y4       Y3      N         N      N      N     N      N
The EAL requirements are to include those identified in the EAL Requirements
                                                                                     UD1 Y4       Y3      N         N      N      N     N      N
and Analysis
The EAL requirements are to include those logbook items identified in the Flight
                                                                                     UD1 N        Y3      N         N      N      N     N      N
Operational Project




                                                                 A-33
                                                                                                                            ARC-DO-160001.100
                                                                                                                                     07/03/11




                                                                                                            LUFS-NT




                                                                                                                                   Financials

                                                                                                                                   Integrated
                                                                                                                                    Solution
                                                                                                    AMMIS




                                                                                                                                                CMplus
                                                                                                                                     Oracle
                                                                                             ACMS




                                                                                                                            GOLD



                                                                                                                                     Oracle
                                                                                       EAL




                                                                                                                      FLS
                                   FUNCTIONS


Incorporate or adopt the existing AMMIS Flight Operations module to identify
                                                                                       UD1 N        Y1      N         N     N      N     N      N
EAL interfaces.
Incorporate or adopt the ACMS Aircraft Statistics Report (ASR) to identify EAL
                                                                                       UD1 Y1       Y4      N         N     N      N     N      N
interfaces.
Review the ALMIS Business Area Analysis (BAA) Deliverable to identify EAL
                                                                                       UD1 N        Y3      N         N     N      N     N      N
interfaces.
Review the U.S. Coast Guard Abstract of Operations Report to identify EAL
                                                                                       UD1 N        Y1      N         N     N      N     N      N
interfaces.
Review the COMDINST 3710.1D which provides policy for the CG 4377, to
                                                                                       UD1 N        Y1      N         N     N      N     N      N
identify EAL interfaces.
Examine the current paper based Aircraft Logbook processes, to identify EAL
                                                                                       UD1 N        Y3      N         N     N      N     N      Y4
interfaces.
Interview Government designated domain experts and systems users to identify
                                                                                       UD1 N        N       N         N     N      N     N      Y4
EAL interfaces.
Capture all the heading information (aircraft model, aircraft number, unit and
                                                                                       UD1 N        Y1      N         N     N      N     N      N
date) presently captured on the yellow sheet of the CG 4377.
Capture all the flight plan data from the yellow sheet. Route of Flight Section and
                                                                                       UD1 N        N       N         N     N      N     N      Y4
Remarks Section shall allow for free form entry. . Add field for IFR/VFR/SVFR
Capture all the Servicing data from the yellow sheet which shall be specifically
                                                                                       UD1 Y3       N       N         N     N      N     N      N
tailored to the aircraft model
Capture all Preflight data from the yellow sheet by allowing for electronic
verification of the preflight action specifically tied to CG personnel authorized to   UD1 Y1       N       N         N     UD3    N     N      Y4
perform such inspections.
Capture the Pilot in command data from the yellow sheet by allowing for
                                                                                       UD1 N        Y3      N         N     N      N     N      N
electronic verification by CG pilots authorized to sign for aircraft.
Capture Operational Codes listed on the blue sheet of the CG 4377 and allow
                                                                                       UD1 N        Y1      N         N     N      N     N      N
assignment of codes to crewmembers assigned to flight.



                                                                  A-34
                                                                                                                           ARC-DO-160001.100
                                                                                                                                    07/03/11




                                                                                                          LUFS-NT




                                                                                                                                  Financials

                                                                                                                                  Integrated
                                                                                                                                   Solution
                                                                                                  AMMIS




                                                                                                                                               CMplus
                                                                                                                                    Oracle
                                                                                           ACMS




                                                                                                                           GOLD



                                                                                                                                    Oracle
                                                                                     EAL




                                                                                                                     FLS
                                  FUNCTIONS


Capture Operational Employment Codes listed on the bluesheet. Allow for
standardized method for unit to tailor employment codes to specific mission areas
                                                                                     UD1 N        Y1      N         N      N      N     N      N
for that unit as is presently accomplished by the Unit Tracking Code Feature of
AMMIS (GFE)
Capture Total Flight Time, Unit SAR Case Number, Flight Time by each
aircrewman, instrument time, night vision goggle time, and all other variations of   UD1 N        Y1      N         N      N      N     N      N
accounting for flight time presently captured on blue sheet portion of CG 4377
Capture Sortie Data, deployment Data, assignment of resource (necessary to
support the abstract of operations report), and Employment data hours to             UD1 N        Y1      N         N      N      N     N      N
employment codes.
Capture available passenger data, cargo data, and provide for free form entry of
data that is not routinely captured in a standard format. Expand field to capture    UD1 N        Y1      N         N      N      N     N      N
additional / other crew members. (to support Abstract of ops report)
Account for Maintenance hours expended during preflight activities and store with
other maintenance hour data in appropriate database developed for purpose of         UD1 Y1       N       N         UD3 UD3       N     N      Y4
capturing all labor hours required to support aviation maintenance operations.
Provide the option to create a hard copy of the DD-175 or FAA flight plan based
                                                                                     UD1 N        N       N         N      N      N     N      N
on the information/selected in flight plan route section.
Data shall automatically populate other portions of the application, which concern
                                                                                     UD1 Y3       Y3      N         UD3    N      N     N      N
that particular event
Provide for automatic verification from the domain of CG aircrew, which concern
                                                                                     UD1 N        Y3      N         N      N      N     N      N
that particular event.
Generate Passenger/Crew manifest                                                     UD1 N        Y3      N         N      N      N     N      N
Provide for electronic verification of all data captured at completion of
                                                                                     UD1 N        Y1      N         N      N      N     N      N
flight/sortie by Pilot in command




                                                                A-35
                                                                                                                             ARC-DO-160001.100
                                                                                                                                      07/03/11




                                                                                                            LUFS-NT




                                                                                                                                    Financials

                                                                                                                                    Integrated
                                                                                                                                     Solution
                                                                                                    AMMIS




                                                                                                                                                 CMplus
                                                                                                                                      Oracle
                                                                                             ACMS




                                                                                                                             GOLD



                                                                                                                                      Oracle
                                                                                       EAL




                                                                                                                       FLS
                                   FUNCTIONS


Provide for local verification of all records and for correction of records at local
level up to the point where records are "locked" (by CO signature) prior to            UD1 Y1       Y1      N         UD3    N      N     N      N
becoming part of the official Abstract of Operations Report for the unit.
Document unscheduled maintenance discrepancies by specifically capturing: what
                                                                                       UD1 N        N       N         UD3 UD3       N     N      Y4
the discrepancy was and on what aircraft
Document unscheduled maintenance discrepancies by specifically capturing:
                                                                                       UD1 N        N       N         UD3 UD3       N     N      Y4
Date/time the discrepancy was discovered
Document unscheduled maintenance discrepancies by specifically capturing:
                                                                                       UD1 N        N       N         UD3 UD3       N     N      Y4
What Aircraft system was affected
Document unscheduled maintenance discrepancies by specifically capturing:
Corrective Action and Date/Time corrected throughout the list of a pick list (that     UD1 N        N       N         UD3 UD3       N     N      Y4
includes open comments)
Document unscheduled maintenance discrepancies by specifically capturing: who
performed the corrective action, Quality Assurance, and maintenance Release            UD1 N        N       N         UD3 UD3       N     N      Y4
(where required)
Document maintenance discrepancies by specifically capturing direct labor hours
                                                                                       UD1 Y1       N       N         UD3 UD3       N     N      Y4
for both scheduled and unscheduled maintenance.
The EAL shall be capable of indicating the current aircraft maintenance status.        UD1 Y3       N       N         N      UD3    N     N      N
The EAL shall be capable of indicating the current total aircraft flight hours.        UD1 Y1       Y1      N         N       N     N     N      N
The EAL shall be capable of indicating the current aircraft cycles (as appropriate
                                                                                       UD1 Y1       N       N         N      UD3    N     N      N
by aircraft type)
Allow review of discrepancies/maintenance actions completed (back_flights or
365 calendar days) (See CWO Hall for specific number of flights authorized for         UD1 N        N       N         UD3 UD3       N     N      N
review)
Allow for searches by any field within single tail number and across aircraft fleet.   UD1 Y1       Y1      N         N      UD3    N     N      N




                                                                  A-36
                                                                                                                              ARC-DO-160001.100
                                                                                                                                       07/03/11




                                                                                                             LUFS-NT




                                                                                                                                     Financials

                                                                                                                                     Integrated
                                                                                                                                      Solution
                                                                                                     AMMIS




                                                                                                                                                  CMplus
                                                                                                                                       Oracle
                                                                                              ACMS




                                                                                                                              GOLD



                                                                                                                                       Oracle
                                                                                        EAL




                                                                                                                        FLS
                                   FUNCTIONS


Provide linked summary data such as listing open discrepancies, grounding
discrepancies, repeat discrepancies, in a report format that is viewable or printable   UD1 N        N       N         N      UD3    N     N      N
by the user.
Update the completion of applicable MPC, ATS and ACMs maintenance records
automatically during sign off of pre,thru,post flight and unscheduled maintenance       UD1 Y1       N       N         UD3 UD3       N     N      N
actions.
Document cannibalization and provide reports that can be tailored to aircraft
                                                                                        UD1 Y1       N       N         N      UD3    N     N      N
types, aircraft systems and operating sites.
Provide for electronic versions of CG 5181, Maintenance Squawks, 78J1, CG
4377a No Fly, and appropriate data currently stamped on the back of pink sheets.        UD1 N        N       N         N      UD3    N     N      N
CWO Hall to provide a composite of local "Rubber stamps"
Automatically generate ASR Data which is currently calculated manually and
                                                                                        UD1 Y3       N       N         N      N      N     N      N
reported in ACMS
OFCO Mgt. Data Acq.: manage the Operating Facility Change Orders (OFCO) for
an Air Station. Allows Headquarters users to assign initial aircraft allowances         UD1 N        Y1      N         N      N      N     N      N
(number of aircraft by type) and add subsequent changes to each Air Station.
Aircraft Transfer Maintenance: manage the number and type of aircraft assigned
to an Air Station. Allow the Air Station to receipt for Aircraft which have been        UD1 N        Y1      N         N      N      N     N      N
transferred. (Review both ACMS and AMMIS)
Prog Hrs Mgt. Data Acq.: manage the program hour allotments for an Air Station.         UD1 N        Y3      N         N      N      N     N      N
Program Hours Assignment: allow Air Station users to view their OPFAC‘s
summary Model Allowances and Model Hours by Model Number. Enable list to                UD1 N        Y3      N         N      N      N     N      N
be filtered by model number.
Semiannual minimums for flight mechanics                                                UD1   N      Y1      N         N      N      N     N      N
Semiannual deficiencies for flight mechanics                                            UD1   N      Y1      N         N      N      N     N      N
Quarterly minimums for rescue swimmers                                                  UD1   N      Y1      N         N      N      N     N      N
Quarterly deficiencies for rescue swimmers                                              UD1   N      Y1      N         N      N      N     N      N



                                                                   A-37
                                                                                                                               ARC-DO-160001.100
                                                                                                                                        07/03/11




                                                                                                               LUFS-NT




                                                                                                                                      Financials

                                                                                                                                      Integrated
                                                                                                                                       Solution
                                                                                                       AMMIS




                                                                                                                                                   CMplus
                                                                                                                                        Oracle
                                                                                                ACMS




                                                                                                                               GOLD



                                                                                                                                        Oracle
                                                                                          EAL




                                                                                                                         FLS
                                    FUNCTIONS


Semiannual minimums for HU25C sensor systems operators                                    UD1 N        Y1      N         N     N      N     N      N
Flight Inspection Data Acquisition: compile all inspection data for review by the
maintenance chief or designee for their approval. Allows the user to give aircraft        UD1 Y1       N       N         UD3   N      N     N      Y4
inspection sign-off information prior to entering pre-flight data.
Collect Crew Data related to the existing Yellowsheet (Pt1, CG-4377).                     UD1 N        Y1      N         N     N      N     N      N
 Auth Maint Pers enters aircraft servicing information, tailored to aircraft type(s)      UD1 Y3       N       N         N     N      N     N      N
Electronic Signature Author: verify the logged-on user as qualified to sign-off on
                                                                                          UD1 Y1       N       N         N     N      N     N      N
an inspection.
Flight Info Data Acq.: Display data by Tail Number, Pilot/Crew Name, Location
                                                                                          UD1 N        Y1      N         N     N      N     N      N
or date
Itinerary Acquisition: collect the flight leg and itinerary information for the flight,
                                                                                          UD1 N        Y4      N         N     N      N     N      N
including the sortie information for a flight/leg.
Provide continuous tracking of days away from home station and time deployed
                                                                                          UD1 N        Y1      N         N     N      N     N      N
aboard ship.
Collect the deployment data associated with this flight, including the shipboard
                                                                                          UD1 N        Y1      N         N     N      N     N      N
operational hours, days away and deployment type.
Air Station Reporting: evaluate Air Station related information and produce a
variety of operational reports, including the PAULS, AOPS and Aircraft                    UD1 Y4       Y3      N         N     N      N     N      N
Statistical Report (ASR).
Display Acft Utilization Data for a selected period of time. Data displayed
includes Employment Code, Mission, Sortie, Resource Hours (Total, Land-Day,               UD1 N        Y1      N         N     N      N     N      N
Land-Duty, Shipboard), Employment hours.
Maintain Mins Catalog: keep a catalog of mins requirements which can be
                                                                                          UD1 N        Y1      N         N     N      N     N      N
updated as needed when the COMDINST M3710.1D is updated.
Research and identify possible interface with Personnel Info Management: update
personnel basic and detailed information for a USCG employee. Report on value             UD1 N        Y4      N         N     N      N     N      N
and LOE of such interface



                                                                     A-38
                                                                                                                          ARC-DO-160001.100
                                                                                                                                   07/03/11




                                                                                                          LUFS-NT




                                                                                                                                 Financials

                                                                                                                                 Integrated
                                                                                                                                  Solution
                                                                                                  AMMIS




                                                                                                                                              CMplus
                                                                                                                                   Oracle
                                                                                           ACMS




                                                                                                                          GOLD



                                                                                                                                   Oracle
                                                                                     EAL




                                                                                                                    FLS
                                  FUNCTIONS


Semi-Annual Minimums for Fixed Wing Pilots                                           UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Deficiencies for Fixed Wing Pilot                                        UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Minimums for Rotary Wing Pilot                                           UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Deficiencies for Rotary Wing Pilot                                       UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Minimums for AMS                                                         UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Minimums for Dropmaster                                                  UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Deficiencies for Dropmaster                                              UD1   N      Y1      N         N     N      N     N      N
Semi-Annual Minimums for Difpro Pilots                                               UD1   N      Y1      N         N     N      N     N      N
Aircraft Utilization Query/Report                                                    UD1   N      Y1      N         N     N      N     N      N
Blue Sheet Aircraft Hours Query/Report                                               UD1   N      Y1      N         N     N      N     N      N
Pilot/Aircrew Flight Logbooks                                                        UD1   N      Y1      N         N     N      N     N      N
Flight Simulator Data Entry Screen                                                   UD1   N      Y1      N         N     N      N     N      N
 Provide Pilot/Aircrew Rosters                                                       UD1   N      Y1      N         N     N      N     N      N
Flight Orders Status Query/Report                                                    UD1   N      Y1      N         N     N      N     N      N
Aviation Incentive Pay Calculation Report                                            UD1   N      Y1      N         N     N      N     N      N
Aviation Incentive Pay Summary Report (pilot)                                        UD1   N      Y1      N         N     N      N     N      N
Generate Flight Pay Related Letters                                                  UD1   N      Y1      N         N     N      N     N      N
Generate Flight Pay Audit Reports                                                    UD1   N      Y1      N         N     N      N     N      N
Retain existing training codes                                                       UD1   N      Y1      N         N     N      N     N      N
Produce 30/60/90 Training Report                                                     UD1   N      Y1      N         N     N      N     N      N
Enter Aircrew Training Data, external to the 4377 such as swim quals                 UD1   N      Y1      N         N     N      N     N      N
Mins Deficiencies Reporting: examine the completed mins activities against the
                                                                                     UD1 N        Y1      N         N     N      N     N      N
mins catalog and create a report that details deficiencies by person.
Mins Activity: capture and update the person mins data based on flight activities.   UD1 N        Y1      N         N     N      N     N      N
Flight Time & Logbooks: allow the user to produce reports for individual pilots
and aircrew members showing acquired flight time and operations for a requested      UD1 N        Y1      N         N     N      N     N      N
period of time. Report options must include: individual, A/C type or OPFAC


                                                                 A-39
                                                                                                                            ARC-DO-160001.100
                                                                                                                                     07/03/11




                                                                                                            LUFS-NT




                                                                                                                                   Financials

                                                                                                                                   Integrated
                                                                                                                                    Solution
                                                                                                    AMMIS




                                                                                                                                                CMplus
                                                                                                                                     Oracle
                                                                                             ACMS




                                                                                                                            GOLD



                                                                                                                                     Oracle
                                                                                       EAL




                                                                                                                      FLS
                                   FUNCTIONS


Flight Pay eligibility report. Show data by month/year, actual flt hours, credit flt
                                                                                       UD1 N        Y1      N         N     N      N     N      N
hrs, Pay(Y/N) Month1, Month2, Month3, Month 4, month 5, and Notes.
Evaluate Available Aircraft: display the local aircraft with an up status for
                                                                                       UD1 N        N       N         N     UD3    N     N      N
consideration and selection for the flight schedule. (Relates to C553B)
Enter Pilot Experience, external to the 4377                                           UD1   N      Y1      N          N    N      N     N      N
Maintain Aircraft Types and Models                                                     UD1   N      Y1      N         UD3   N      N     N      N
Maintain Unit-Defined Tracking Items                                                   UD1   N      Y1      N          N    N      N     N      N
Aircrew Training/Quals                                                                 UD1   N      Y1      N          N    N      N     N      N
Correct Invalid ID Number (Data entry correction procedure)                            UD1   N      Y1      N          N    N      N     N      N
Flight Pay Administration Data                                                         UD1   N      Y1      N          N    N      N     N      N
Enter Flight Simulator Data                                                            UD1   N      Y1      N          N    N      N     N      N
Enter Flight Crew Data on Non U.S. Coast Guard Aircraft (C-130 Units) (Non
                                                                                       UD1 N        Y1      N         N     N      N     N      N
4377 related)
Query Utilization Data                                                                 UD1 N        Y1      N         N     N      N     N      N
FO Users and Assigned Groups (Identify users to appropriate groups to assure
                                                                                       UD1 Y1       Y1      N         UD3   N      N     N      N
access to necessary information)
Enter Not Mission Capable and Not Met Requirements Data                                UD1   Y1     N       N         N     N      N     N      N
Resource Hours Summary Query                                                           UD1   N      Y1      N         N     N      N     N      N
Query by Unit-Defined Category (UDC)                                                   UD1   N      Y1      N         N     N      N     N      N
Passenger/Cargo Transport Query Entry Screen                                           UD1   N      Y1      N         N     N      N     N      N
Major SAR Query Entry Screen                                                           UD1   N      Y1      N         N     N      N     N      N
Recurrent Training Report Entry Screen (to record training specific to locations)      UD1   N      Y1      N         N     N      N     N      N
Law Enforcement Query Entry Screen                                                     UD1   N      Y1      N         N     N      N     N      N
UDC Quantity Tracking Query Entry Screen                                               UD1   N      Y1      N         N     N      N     N      N
Pilot Experience Query/Report                                                          UD1   N      Y1      N         N     N      N     N      N




                                                                    A-40
                                                                                                                             ARC-DO-160001.100
                                                                                                                                      07/03/11




                                                                                                            LUFS-NT




                                                                                                                                    Financials

                                                                                                                                    Integrated
                                                                                                                                     Solution
                                                                                                    AMMIS




                                                                                                                                                 CMplus
                                                                                                                                      Oracle
                                                                                             ACMS




                                                                                                                             GOLD



                                                                                                                                      Oracle
                                                                                       EAL




                                                                                                                       FLS
                                  FUNCTIONS


Display a detailed listing of all Aircraft assigned an OPFAC: Tail Number, Model
Number and Model Type and allows user to view historical disposition for an            UD1 N        Y1      N         N      N      N     N      N
aircraft.
ASR View Records: user can view previously entered aircraft records for a
selected aircraft. Data includes aircraft hours, status, maintenance status data,      UD1 Y3       N       N         N      N      N     N      N
document data, fuel usage, untracked MLH, squawk.
ASR Create a Report Menu for obtaining aircraft status reports                         UD1 Y1       N       N         N      N      N     N      N
ACFT Grounded or Dep Rpt: list all acft by type that are grounded or dep for a
selected month or activity. Provide date range, activity name, type acft, individual   UD1 Y3       N       N         N      N      N     N      N
dates, acft serial number, hours gnd or dep and reason code.
ACMS Overall NMC/Flight Report: lists the average NMC and percent program
                                                                                       UD1 Y3       N       N         N      N      N     N      N
flight hours.
Aircraft Daily Status Report: allow user to list activity, aircraft number, NMC
status indicator and to determine when it went down, reason (maintenance or            UD1 Y3       N       N         N      N      N     N      Y4
supply) and EST return to up status.
Aircraft Grounded in ASR Report: provides range dates of report, unit name, type
aircraft, aircraft serial number, individual dates, 1 hour blocks(based on 24          UD1 Y3       N       N         N      N      N     N      N
hrs),reason code for grounding for each hour block.
Capture all data required to produce the Dispatch Reliability Report                   UD1 Y1       Y1      N         N      N      N     N      N
Fleet Aircraft Fuel Consumption Report: provides range dates of report, unit
name, aircraft serial number, fuel consumption in gallons, total fuel consumption      UD1 Y3       N       N         N      N      N     N      N
for the time period.
How GOZIT Report: provides range dates of report, activity name, aircraft type,
NMCM percent, NMCS percent, NMCD percent, NMCT percent, hours flown,                   UD1 Y3       N       N         N      UD3    N     N      N
percent of program flight hours, last ASR entry date.
 Produce a Maintenance Labor Hours Report                                              UD1 Y1       N       N         UD3 UD3       N     N      Y4




                                                                  A-41
                                                                                                                             ARC-DO-160001.100
                                                                                                                                      07/03/11




                                                                                                             LUFS-NT




                                                                                                                                    Financials

                                                                                                                                    Integrated
                                                                                                                                     Solution
                                                                                                     AMMIS




                                                                                                                                                 CMplus
                                                                                                                                      Oracle
                                                                                              ACMS




                                                                                                                             GOLD



                                                                                                                                      Oracle
                                                                                        EAL




                                                                                                                       FLS
                                   FUNCTIONS


NMC and % Program Hours Report: provides range dates of report, aircraft type,
                                                                                        UD1 Y1       N       N         N     UD3    N     N      N
NMC, percent of program hours.
NMC Data for AMMIS Report: provides range dates of report, activity name,
aircraft type, aircraft number, maintenance hours total, supply hours total, depot      UD1 Y1       N       N         N     UD3    N     N      N
hours total for day and duty categories.
Operating Statistics Report: provides range dates of report, aircraft types, activity
names, NMCM, NMCS, NMCD, NMCT, availability percent, aircraft allowance,
                                                                                        UD1 Y3       N       N         N     N      N     N      N
average aircraft on board, hours flown, average program hours, fleet averages, and
fleet totals.
Unit Aircraft Fuel Consumption Report: provides range dates of report, activity
                                                                                        UD1 Y3       N       N         N     UD3    N     N      N
name, aircraft serial numbers, fuel consumption used, total fuel used.
All sign off's require within the EAL application require a corresponding date and                                     UD3
                                                                                        UD1 Y1       Y3      N               UD3    N     N      Y4
time block. Per CWO Hall at the technical review conducted on 10/26/98
All reports required by the EAL logbook application must be available in either                                        UD3
                                                                                        UD1 Y3       Y3      N               UD3    N     N      N
print or viewable on screen. Per CWO Hall at Tech Review 10/26/98




                                                                   A-42
                                     ARC-DO-160001.100
                                              07/03/11




This Page Intentionally Left Blank




              A-43
                                                                ARC-DO-160001.100
                                                                         07/03/11


                  APPENDIX BCOTS/GOTS POINTS OF CONTACT

Agency/Products           Name                   Phone #

WPDS GOLD                 Wayne Rogers           619-454-0028
Litton PRC GOLD           John Bucelato          757-766-0244
U.S. Air Force/GOLD       James Peterson         334-273-6013

Oracle                    Manuel Frais           301-913-5177
Oracle                    Koset Surakomal        301-907-2797
Oracle                    Neil Shiffman          301-907-2205
Oracle                    Rui Garcia             703-478-9000
Oracle                    Kolleen Sanford        703-364-2397

USCG FINCEN/Oracle        John Oxley             757-523-6792
USCG FINCEN/LUF-NT        Steve Williams         757-523-6032
USCG FINCEN/AMMIS         Bill Zack              757-523-6720


USCG HQ/CMplus            LCDR Pete Weddington   202-267-6812
USCG HQ/CMplus            LCDR George Vance      202-267-6918
USCG HQ/Oracle            Avie Snow              202-267-1422
USCG HQ/FLS               P. Darcy               202-267-6811
USCG HQ/FLS               LCDR Brian Wright      202-267-6811
USCG HQ/LUFS-NT           Ed Murray              202-267-0676




                                           B-1
                                     ARC-DO-160001.100
                                              07/03/11




This Page Intentionally Left Blank




               B-2
                                                                ARC-DO-160001.100
                                                                         07/03/11
                APPENDIX C ACRONYMS/ABBREVIATIONS

ACMS      Aviation Computerized Maintenance System
ALMIS     Aviation Logistics Management Information System
AMMIS     Aviation Maintenance Management Information System
AR&SC     Aircraft Repair & Supply Center
CDR       Commander
CIMS      Contract Information Management System
CMplus    Configuration Management Plus
COBOL     Common Business Oriented Language
COM       Component Object Management
COMDTINST Commandant Instruction
CORBA     Common Object Request Broker Architecture
COTS      Commercial-Off-The-Shelf
DAFIS     Departmental Accounting and Financial Information System
DCOM      Distributed Component Object Model
DOD       Department of Defense
DOT       Department of Transportation
EAL       Electronic Aircraft Logbook
EDI       Electronic Data Interchange
ELC       Engineering Logistics Center
FCBS      FC Business System Inc.
FINCEN    Finance Center
FLS       Fleet Logistics System
FMSS      Financial Management Systems Software
FSS       Federal Supply Schedule
CG-SDDS   U.S. Coast Guard Software Documentation Development Standards
GOLD      Government On Line Data
GOTS      Government-Off-The-Shelf
GSA       General Services Administration
GSE       Ground Support Equipment
GUI       Graphical User Interface
HQ        U.S. Coast Guard Headquarters
IT        Information Technology
LUFS      Large Unit Financial System
MIPR      Military Interdepartmental Purchase Request
MISD      Management Information Systems Division
MRP       Manufacturing Resource Planning
MSR       Mandatory Special Requirements
NRFI      Not Ready For Issue Material
NT        New/Network Technology
OGA       Other Government Agency
OMB       Office of Management and Budget
OPAC      On-line Payment and Collections
ORB       Object Request Broker
OT & E    Operational Test and Evaluation



                                        C-1
                                                           ARC-DO-160001.100
                                                                    07/03/11
RDBMS    Relational Database Management System
SCCR     Supply Center Computer Replacement
SF       Standard Form
SNT      Serial Number Tracked
SR       Special Requirements
SWIII    Standard Workstation III
TCP/IP   Transmission Control Protocol/Internet Protocol
UR       Unsatisfactory Report
WPDS     Western Pacific Data System




                                       C-2
                                                                        ARC-DO-160001.100
                                                                                 07/03/11
                   APPENDIX D. REFERENCED DOCUMENTS


GOVERNMENT

COMDTINST 5230.58 U.S. Coast Guard Information Technology Management Strategy
Contract DTCG23-97-D-TAZ040 Data Requirements List
FSS GS 35F-4357D
Fleet Logistics System Project Management Plan
G-S Systems Plan dated 20 Nov 1998
LUFS-NT Large Unit Financial System - NT - U.S. Coast Guard Web Page
Oracle Government FSS GS-35F-0189D
Oracle IT FSS GS-35F-0108J
Senate Testimony on CIMS - (Web Paper)
U. S. Coast Guard FY 1998 Five Year IT Plan

NON-GOVERNMENT

Carnegie Mellon University Software Engineering Institute Slide Figure 1-1 - (Web Paper)
Carnegie Mellon University Software Engineering Institute Monographs on the Use of
Commercial Software in Government Systems:
- COTS Based System Overview
- COTS and Open Systems
- The Commandments of COTS: Still in Search of the Promised Land
- Product and Technology Evaluation
- Case Study: Evaluating COTS Products for DOD Information Systems
- Assembling Large Systems from COTS Components: Opportunities, Cautions, and
Complexities
- Case Study: Correcting System Failure in a COTS Information System
- Isolating Faults in Complex COTS-Based Systems
- The Opportunities and Complexities of Applying Commercial-off-the-Shelf Components

Data Standards & Architecture - (Web Paper)
Management Systems Designer Inc. - (Web Paper)
Integration Technologies Group - (Web Paper)
Oracle Corporation Securities and Exchange Commission Annual Report for FY 1997
Thinking Systems Inc - Large-Scale COTS Integrated Software Systems - (Web Paper)
Western Pacific Data Systems Gold Profiles
West Virginia University Dept. of Statistics and Computer Science -Specification and
Measurement of Software Portability - (Web Paper)




                                             D-1
                                     ARC-DO-160001.100
                                              07/03/11




This Page Intentionally Left Blank




               D-2

								
To top