U.S. Department of Education: Promoting Educational Excellence for all Americans

Financial Management Support System (FMSS)

Exhibit 300: Capital Asset Plan and Business Case Summary
Part I: Summary Information And Justification

Section A: Overview

  1. Date of submission: May 30, 2008
  2. Agency: 018
  3. Bureau: 14
  4. Name of this Capital Asset: Financial Management Support System (FMSS)
  5. Unique Project (Investment) Identifier: 018-14-01-01-01-1020-00
  6. What kind of investment will this be in FY2010? Mixed Life Cycle
  7. What was the first budget year this investment was submitted to OMB? FY2001 or earlier
  8. Provide a brief summary and justification for this investment, including a brief description of how this closes in part or in whole an identified agency performance gap: The FMSS is a mission critical system of the Department of Education and is supported by the ISS business case for infrastructure and testing as part of the EDCAPS environment. The Department expects to continue on its improvements in the following performance outcomes from this initiative: continued control over and accountability of Department financial management services including, financial management system controls and practices; financial system reporting capabilities and continued ability to respond quickly to internal and external financial information inquiries. Additional outcomes are continued tight integration and streamlining with the Office of Federal Student Aid (OFSA) and business processes; reduced manual reconciliation efforts for the Financial Management Operations Group within the Office of the Chief Financial Officer; reduction of errors and improved funds control; better data sharing and centralized data edits and controls that could otherwise get out of synchronization between the FMSS and other feeder systems.
  9. Did the Agency's Executive/Investment Committee approve this request? yes
    1. If "yes," what was the date of this approval? Jun 29, 2007
  10. Did the Project Manager review this Exhibit? yes
    1. What is the current FAC-P/PM (for civilian agencies) or DAWIA (for defense agencies) certification level of the program/project manager? Senior/Expert/DAWIA-Level 3
  1. Has the agency developed and/or promoted cost effective, energy efficient and environmentally sustainable techniques or practices for this project. yes
    1. Will this investment include electronic assets (including computers)? yes
    2. Is this investment for new construction or major retrofit of a Federal building or facility? (answer applicable to non-IT assets only) no
      1. If "yes," is an ESPC or UESC being used to help fund this investment? [Not answered]
      2. If "yes," will this investment meet sustainable design principles? [Not answered]
      3. If "yes," is it designed to be 30% more energy efficient than relevant code? [Not answered]
  2. Does this investment directly support one of the PMA initiatives? yes
    Financial Performance
    Eliminating Improper Payments
    1. Briefly and specifically describe for each selected how this asset directly supports the identified initiative(s)? This investment provides; a department-wide core financial management system for funds control, general ledger, payments and receivables; financial management system controls; financial system reports, including financial statements, FACTS, SF224, etc., and greater ability to respond to internal and external inquiries. These improvements allow Department managers better access to data to make informed financial decisions. Cross-validation rules help to eliminate improper payments.
  3. Does this investment support a program assessed using the Program Assessment Rating Tool (PART)? (For more information about the PART, visit www.whitehouse.gov/omb/part.) no
    1. If "yes," does this investment address a weakness found during a PART review? [Not answered]
    2. If "yes," what is the name of the PARTed program? [Not answered]
    3. If "yes," what rating did the PART receive? [Not answered]
  4. Is this investment for information technology? yes

For information technology investments only:

  1. What is the level of the IT Project? (per CIO Council PM Guidance) Level 2
  2. In addition to the answer in 11(a), what project management qualifications does the Project Manager have? (per CIO Council PM Guidance) (1) Project manager has been validated as qualified for this investment
  3. Is this investment or any project(s) within this investment identified as "high risk" on the Q4-FY 2008 agency high risk report (per OMB Memorandum M-05-23)? no
  4. Is this a financial management system? yes
    1. If "yes," does this investment address a FFMIA compliance area? no
      1. If "yes," which compliance area: [Not answered]
      2. If "no," what does it address? This investment is in compliance with FASAB, USSGL JFMIP and FSIO guidelines for financial management systems.
    2. If "yes," please identify the system name(s) and system acronym(s) as reported in the most recent financial systems inventory update required by Circular A-11 section 52 [Not answered]
  5. What is the percentage breakout for the total FY2010 funding request for the following?
Hardware 0
Software 12
Services 88
Other 0
  1. If this project produces information dissemination products for the public, are these products published to the Internet in conformance with OMB Memorandum 05-04 and included in your agency inventory, schedules and priorities? n/a
  2. Contact information of individual responsible for privacy related questions:
   
   
   
   
  1. Are the records produced by this investment appropriately scheduled with the National Archives and Records Administration's approval? yes
  2. Does this investment directly support one of the GAO High Risk Areas? no

Section B: Summary of Spending

  1.  

Table 1: SUMMARY OF SPENDING FOR PROJECT PHASES
(REPORTED IN MILLIONS)
(Estimates for BY+1 and beyond are for planning purposes only and do not represent budget decisions)

  PY-1 and earlier PY 2008 CY 2009 BY 2010 BY+1 2011 BY+2 2012 BY+3 2013 BY+4 and beyond Total
Planning: 0 0 0 0          
Acquisition: 26.16 0.44 1.55 1.25          
Subtotal Planning amp; Acquisition: 26.16 0.44 1.55 1.25          
Operations & Maintenance: 20.07 3.7 2.487 2.787          
TOTAL: 46.23 4.14 4.037 4.037          

Government FTE Costs should not be included in the amounts provided above.

Government FTE Costs 6.46 1.23 1.29 1.35          
Number of FTE represented by Costs: 79 11 10 10          
  1. Will this project require the agency to hire additional FTE's? no
    1. If "yes", How many and in what year? [Not answered]
  2. If the summary of spending has changed from the FY2009 President's budget request, briefly explain those changes: No change from the FY2008 President's budget request.

Section D: Performance Information

Performance Information Table

Fiscal Year Strategic Goal(s) Supported Measurement Area Measurement Grouping Measurement Indicator Baseline Target Actual Results
2007 Cross-goal Strategy on Management Mission and Business Results Reporting and Information FMSS receives an unqualified audit opinion by independent auditors on FY 2007 annual financial statements. Unqualified opinion on the FY2006 financial statements. Maintain unqualified opinion The Department received a clean audit opinion on the FY 2007 financial statements produced by the FMSS.
2007 Cross-goal Strategy on Management Customer Results Accuracy of Service or Product Delivered 10% or less of Help Desk items are FMSS related. 10% of Teamtrack items are FMSS related. 8-9% of Teamtrack items are FMSS related. For the fourth quarter of FY 2007 Help Desk items were <8%.
2007 Cross-goal Strategy on Management Processes and Activities Errors A Green rating on the OMB Stoplight Scorecard System Green rating on scorecard system Maintain Green rating The FMSS received a GREEN rating on the scorecard for 2007
2007 Cross-goal Strategy on Management Technology Availability % of time system is available is 98% or greater System available 98% of time Maintain 98% or greater As of the fourth quarter of FY 2007 the FMSS was available 100% of the planned scheduled availability with the only "down times" being for planned scheduled maintenance.
2007 Cross-goal Strategy on Management Mission and Business Results Reporting and Information Ability to produce financial statements on a quarterly basis (4 times per year). Financial statements are produced on an annual basis (4 times per year). Financial statements will be produced quarterly The fiscal year 2007 fourth quarter financial statements (audited version) were successfully generated by the FMSS per the requirement.
2007 Cross-goal Strategy on Management Processes and Activities Risk 100% of risks in the Risk Log are reviewed monthly or quarterly, as indicated for each risk, by the Project Management Team. 100% of risks are reviewed either monthly or quarterly. Maintain 100% review of all risks both monthly and quarterly. As of the fourth quarter of FY 2007, 100% of all scheduled risk reviews were held by the Project Management Team.
2008 Cross-goal Strategy on Management Customer Results Accuracy of Service or Product Delivered Less than 10% of Teamtrack items are FMSS related 8-9% of Teamtrack issues are FMSS related 7-8% of Teamtrack issues are FMSS related For FY 2008 FMSS Help Desk items were <9%.
2008 Cross-goal Strategy on Management Mission and Business Results Reporting and Information FMSS receives an unqualified audit opinion by independent auditors on FY 2008 annual financial statements. Unqualified audit opinion on previous year's financial statements Maintain unqualified opinions on financial statements Results are expected to be available November 2008
2008 Cross-goal Strategy on Management Mission and Business Results Reporting and Information Ability to produce financial statements on on a quarterly basis (4 times per year). Financial statements are produced on an annual basis (4 times per year) Quarterly financial statements will be produced by the FMSS during FY2008 (4 times per year). All fiscal year 2008 quarterly financial statements were successfully generated by the FMSS per the requirement.
2008 Cross-goal Strategy on Management Processes and Activities Errors FMSS receives a GREEN rating on the OMB scorecard FMSS has scored GREEN in previous years FMSS will maintain GREEN rating The FMSS received a GREEN rating on the scorecard for 2008
2008 Cross-goal Strategy on Management Processes and Activities Risk 100% ofl risks associated with the FMSS are reviewed monthly by the Project Manager 100% of risks are reviewed by the Project Manager Continue reviewing all FMSS risks monthly For FY 2008, 100% of all scheduled risk reviews were completed by the Project Management Team.
2008 Cross-goal Strategy on Management Technology Service Availability % of time FMSS is available is 98% or greater FMSS is available 98% or better Maintain 98% availability of the FMSS during FY2008 During FY 2008 the FMSS was available 100% of the planned scheduled availability with the only "down times" being for planned scheduled maintenance.
2009 Cross-goal Strategy on Management Customer Results Accuracy of Service or Product Delivered Less than 10% of Teamtrack items are FMSS related 8-9% of Teamtrack issues are FMSS related 6-7% of Teamtrack issues are FMSS related Results will be available on a quarterly basis during FY2009
2009 Cross-goal Strategy on Management Mission and Business Results Reporting and Information FMSS receives an unqualified audit opinion by independent auditors on FY 2009 annual financial statements. Unqualified audit opinion on previous year's financial statements Maintain unqualified opinions on financial statements Results are expected to be available November 2009
2009 Cross-goal Strategy on Management Mission and Business Results Reporting and Information Ability to produce financial statements on a quarterly basis (4 times per year). Financial statements are produced on an annual basis (4 times per year). Quarterly financial statements will be produced by the FMSS during FY2009 (4 times per year). Results will be available each quarter during FY2009
2009 Cross-goal Strategy on Management Processes and Activities Errors FMSS receives a GREEN rating on the OMB scorecard FMSS has scored GREEN in previous years FMSS will maintain GREEN rating Results will be available June 2009
2009 Cross-goal Strategy on Management Processes and Activities Risk 100% of risks associated with the FMSS are reviewed monthly by the Project Manager 100% of risks are reviewed by the Project Manager Continue reviewing all FMSS risks monthly Results will be available monthly during FY2009
2009 Cross-goal Strategy on Management Technology Service Availability % of time FMSS is available is 98% or greater FMSS is available 98% or better Maintain 98% availability of the FMSS during FY2009 Results will be available quarterly during FY2009
2010 Cross-goal Strategy on Management Customer Results Accuracy of Service or Product Delivered Less than 10% of Help Desk items are FMSS related 8-9% of Help Desk issues are FMSS related 6-7% of Help Desk issues are FMSS related Results will be available quarterly during FY2010
2010 Cross-goal Strategy on Management Mission and Business Results Reporting and Information FMSS receives an unqualified audit opinion by independent auditors on FY 2010 annual financial statements. Unqualified audit opinion on previous year's financial statements Maintain unqualified opinions on financial statements Results are expected to be available November 2010
2010 Cross-goal Strategy on Management Mission and Business Results Reporting and Information Ability to produce financial statements on a quarterly basis (4 times per year). Financial statements are produced on an annual basis (4 times per year). Quarterly financial statements will be produced by the FMSS during FY2010 (4 times per year). Results will be available each quarter during FY2010
2010 Cross-goal Strategy on Management Processes and Activities Errors FMSS receives a GREEN rating on the OMB scorecard FMSS has scored GREEN in previous years FMSS will maintain GREEN rating Results will be available June 2010
2010 Cross-goal Strategy on Management Processes and Activities Risk 100% of risks associated with the FMSS are reviewed monthly by the Project Manager 100% of risks are reviewed by the Project Manager Continue reviewing all FMSS risks monthly Results will be available monthly during FY2010
2010 Cross-goal Strategy on Management Technology Service Availability % of time FMSS is available is 98% or greater FMSS is available 98% or better Maintain 98% availability of the FMSS during FY2010 Results will be available quarterly during FY2010
               

Section F: Enterprise Architecture (EA)

  1. Is this investment included in your agency's target enterprise architecture? yes
    1. If "no," please explain why? [Not answered]
  2. Is this investment included in the agency's EA Transition Strategy? yes
    1. If "yes," provide the investment name as identified in the Transition Strategy provided in the agency's most recent annual EA Assessment. Financial Management Support System
    2. If "no," please explain why? [Not answered]
  3. Is this investment identified in a completed and approved segment architecture? yes
    1. If "yes," provide the six digit code corresponding to the agency segment architecture. The segment architecture codes are maintained by the agency Chief Architect. For detailed guidance regarding segment architecture codes, please refer to http://www.egov.gov/. 402-000

4. Service Component Reference Model (SRM) Table :

Agency Component Name Agency Component Description FEA SRM Service Type FEA SRM Component Service Component Reused Internal or External Reuse? BY Funding Percentage
Component Name UPI
Reports Development of reports and queries in response to end user requests Reporting Ad Hoc [Not answered] [Not answered] No Reuse 2
Reports Development of reports and queries in response to end user requests Reporting Standardized / Canned [Not answered] [Not answered] No Reuse 2
Enhancements Modification of business processes and system configurations Knowledge Management Information Sharing [Not answered] [Not answered] No Reuse 4
Enhancements Modification of business processes and system configurations Document Management Document Review and Approval [Not answered] [Not answered] No Reuse 2
Maintenance Issue resolution and baseline support Financial Management Expense Management [Not answered] [Not answered] No Reuse 7
FMLOB Development Development of implementing a shared service provider solution for financial management Development and Integration Enterprise Application Integration [Not answered] [Not answered] No Reuse 2
Maintenance Issue resolution and baseline support Financial Management Payment / Settlement [Not answered] [Not answered] No Reuse 7
Enhancements Modification of business processes and system configurations Management of Processes Change Management [Not answered] [Not answered] No Reuse 1
Enhancements Modification of business processes and system configurations Management of Processes Requirements Management [Not answered] [Not answered] No Reuse 1
FMLOB Analysis Analysis on the ability to migrate financial management functions to a shared service provider Data Management Data Exchange [Not answered] [Not answered] No Reuse 1
Maintenance Issue resolution and baseline support Financial Management Billing and Accounting [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Financial Management Credit / Charge [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Financial Management Debt Collection [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Financial Management Auditing [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Data Management Loading and Archiving [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Development and Integration Data Integration [Not answered] [Not answered] No Reuse 7
Security Support for the validation of system users Security Management Identification and Authentication [Not answered] [Not answered] No Reuse 1
Maintenance Issue resolution and baseline support Data Management Data Exchange [Not answered] [Not answered] No Reuse 7
Maintenance Issue resolution and baseline support Financial Management Payroll [Not answered] [Not answered] No Reuse 7
Security Support for the validation of system users Security Management Access Control [Not answered] [Not answered] No Reuse 1
Licenses The legal purchase of usage contracts for software Systems Management License Management [Not answered] [Not answered] No Reuse 12
Training The building of employee competencies for using the financial management system Human Resources Education / Training [Not answered] [Not answered] No Reuse 1
EDUCATE Services Information Technology Infrastructure Services provided by the DoED EDUCATE Investment. Development and Integration Instrumentation and Testing Instrumentation and Testing 018-24-02-00-01-1020-00 Internal 0
EDUCATE Services Information Technology Infrastructure Services provided by the DoED EDUCATE Investment. Organizational Management Network Management Network Management 018-24-02-00-01-1020-00 Internal 0
EDUCATE Services Information Technology Infrastructure Services provided by the DoED EDUCATE Investment. Security Management Cryptography Cryptography 018-24-02-00-01-1020-00 Internal 0
EDUCATE Services Information Technology Infrastructure Services provided by the DoED EDUCATE Investment. Security Management Intrusion Detection Intrusion Detection 018-24-02-00-01-1020-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Asset / Materials Management Computers / Automation Management Computers / Automation Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Data Management Data Exchange Data Exchange 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Data Management Extraction and Transformation Extraction and Transformation 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Data Management Meta Data Management Meta Data Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Development and Integration Data Integration Data Integration 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Development and Integration Enterprise Application Integration Enterprise Application Integration 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Development and Integration Legacy Integration Legacy Integration 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Human Resources Education / Training Education / Training 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Management of Processes Change Management Change Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Management of Processes Configuration Management Configuration Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Management of Processes Program / Project Management Program / Project Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Management of Processes Quality Management Quality Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Management of Processes Requirements Management Requirements Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Security Management Access Control Access Control 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Security Management Digital Signature Management Digital Signature Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Security Management Intrusion Detection Intrusion Prevention 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Systems Management License Management License Management 018-14-01-01-01-1040-00 Internal 0
ISS Services Integrated Support Services (ISS) provided by the DoED ISS Investment. Systems Management System Resource Monitoring System Resource Monitoring 018-14-01-01-01-1040-00 Internal 0

 

5. Technical Reference Model (TRM) Table:

FEA SRM Component FEA TRM Service Area FEA TRM Service Category FEA TRM Service Standard Service Specification
Ad Hoc Component Framework Data Management Reporting and Analysis Oracle 11.5.10
Standardized / Canned Component Framework Data Management Reporting and Analysis Oracle 11.5.10
Information Sharing Component Framework Data Interchange Data Exchange Oracle 11.5.10
Document Review and Approval Component Framework Data Management Reporting and Analysis Oracle 11.5.10
Expense Management Component Framework Business Logic Independent Platform Oracle 11.5.10
Enterprise Application Integration Service Interface and Integration Integration Enterprise Application Integration Oracle 11.5.10
Payment / Settlement Component Framework Business Logic Independent Platform Oracle 11.5.10
Change Management Service Platform and Infrastructure Software Engineering Software Configuration Management Rational Enterprise Suite and Rational Clearcase
Requirements Management Service Platform and Infrastructure Software Engineering Modeling IBM Rational Rose
Data Exchange Component Framework Data Interchange Data Exchange Oracle 11.5.10
Billing and Accounting Component Framework Business Logic Independent Platform Oracle 11.5.10
Credit / Charge Component Framework Business Logic Independent Platform Oracle 11.5.10
Debt Collection Component Framework Business Logic Independent Platform Oracle 11.5.10
Auditing Component Framework Business Logic Independent Platform Oracle 11.5.10
Loading and Archiving Component Framework Data Management Database Connectivity Oracle 11.5.10
Data Integration Service Interface and Integration Integration Enterprise Application Integration Oracle 11.5.10
Identification and Authentication Component Framework Security Reporting and Analysis Oracle 11.5.10
Data Exchange Component Framework Data Interchange Data Exchange Oracle 11.5.10
Payroll Component Framework Business Logic Independent Platform Oracle 11.5.10
Access Control Service Access and Delivery Service Requirements Authentication / Single Sign-on Oracle 11.5.10
License Management Service Access and Delivery Service Requirements Legislative / Compliance Oracle 11.5.10
Education / Training Service Interface and Integration Integration Enterprise Application Integration Oracle 11.5.10
Instrumentation and Testing Service Platform and Infrastructure Software Engineering Test Management Mercury zinteractive Load Runner/Win Runner
Network Management Service Access and Delivery Service Requirements Hosting Internal provided by EDUCATE
Cryptography Component Framework Security Supporting Security Services Unix Secure Shell
Intrusion Detection Component Framework Security Supporting Security Services Intrusion Detection Services
Computers / Automation Management Service Platform and Infrastructure Hardware / Infrastructure Servers / Computers Sun Sunfire; Compaq ProLiant; IBM PSeries
Data Exchange Service Access and Delivery Service Transport Supporting Network Services Provided by EDUCATE
Extraction and Transformation Service Interface and Integration Interoperability Data Transformation eXtensible Stylesheet Language Transform (XSLT)
Meta Data Management Service Platform and Infrastructure Database / Storage Database Oracle 10g
Data Integration Service Interface and Integration Integration Middleware Oracle PL SQL and Net 8
Enterprise Application Integration Service Platform and Infrastructure Support Platforms Dependent Platform Microsoft Windows and Sun Solaris provided by EDUCATE; IBM AIX
Legacy Integration Service Interface and Integration Integration Middleware Oracle PL SQL and Net 8
Education / Training Service Access and Delivery Delivery Channels Intranet OnDemand Software
Change Management Service Platform and Infrastructure Software Engineering Software Configuration Management Rational Enterprise Suite and Rational Clearcase
Configuration Management Service Platform and Infrastructure Software Engineering Software Configuration Management Rational Enterprise Suite and Rational Clearcase
Program / Project Management Service Platform and Infrastructure Software Engineering Integrated Development Environment IBM Rational Team Unifying Platform
Quality Management Component Framework Data Management Reporting and Analysis Oracle Runtime; Cognos Impromptu, Cognos Query
Requirements Management Service Platform and Infrastructure Software Engineering Modeling IBM Rational Rose
Access Control Service Access and Delivery Service Requirements Authentication / Single Sign-on IBM Tivoli Identity Manager, Federal Identity Manager, Tivoli IBM Directory, Directory Integrator provided by EDUCATE
Digital Signature Management Component Framework Security Authentication / Single Sign-on TBD
Intrusion Prevention Component Framework Security Certificates / Digital Signatures SSL
License Management Component Framework Data Management Reporting and Analysis Oracle Runtime; Cognos Impromptu, Cognos Query
System Resource Monitoring Service Platform and Infrastructure Hardware / Infrastructure Network Devices / Standards F5 Big - IP
  1. Will the application leverage existing components and/or applications across the Government (i.e., USA.Gov, Pay.Gov, etc)? no
    1. If "yes," please describe. [Not answered]

Part II: Planning, Acquisition And Performance Information

Section A: Alternatives Analysis

  1. Did you conduct an alternatives analysis for this investment? yes
    1. If "yes," provide the date the analysis was completed? Aug 3, 2007
    2. If "no," what is the anticipated date this analysis will be completed? [Not answered]
    3. If no analysis is planned, please briefly explain why: [Not answered]

2. Alternatives Analysis Results:

Alternative Analyzed Description of Alternative Risk Adjusted Lifecycle Costs estimate Risk Adjusted Lifecycle Benefits estimate
Oracle 11i w/ tight integration to FMS - FSA sub-ledger will continue to reside in a separate environment. (Status quo solution) This alternative allows FSA and OCFO the flexibility to phase-in efforts to modernize and integrate feeder systems, it avoids performance contention, provides the ability to isolate requirements of system modernization efforts, keeps the interface between FMS and FMSS constant and minimizes risk to all Departmental financial system implementations e.g. GAPS Redesign. However, this alternative maintains the dual implementation of Oracle Federal Financials, one for FMS and the other for FMSS. 94.17 10.97
Combine FMS and FMSS with 11i Implementation - Department would consolidate the Federal Student Aid (FSA) office's instance of Oracle Federal Financials (FMS) with FMSS and implement a single Oracle 11i solution. Potential to consolidate and streamline FSA business processes, require less work for Financial Management Operations and FSA staff, elimination of redundant entry of allotments into both the FMSS and FMS systems, reduce chance of errors and better funds control and data sharing. However, the modernization effort underway at FSA requires significant oversight and coordination. The many resources needed to manage several projects simultaneously would put all projects at risk of failure. 96.3 4.49
FMLOB Solution - Department would migrate to a Shared Service Center (SSC) for financial management functions. This would include core financial functions (A/R, A/P, purchasing, budgeting, budget planning and G/L) and financial interfaces. The concept of SSCs is new to the federal government and is currently not mature enough to manage the complexities of the Department's 200+ funds and varied business processes based on analysis and discussions with SSCs. No current SSC shares the diversity of financial requirements that ED maintains. The FMSS is tightly integrated all other EDCAPS systems and FSA's FMS. This integration would be difficult to replicate at a SSC and maintain the high financial integrity for which ED is known. 84.54 17.45
Implement version 12 of the Oracle Financial management system. Oracle Federal Financials version 12 is to be released as a replacement for version 11i, the Department's current version. Version 12 is expected to included additional/improved features compared to the 11i version. This alternative was not selected since the Department recently completed the implementation of 11i. Also, OMB has directed all agencies to move their financial management functions to a shared service provider at the time of implementing a major release. V12 requires this. 72.22 8.41
  1. Which alternative was selected by the Agency's Executive/Investment Committee and why was it chosen? Alternative One, Oracle 11i w/ tight integration to FMS was chosen because it allows for OCFO and OFSA to manage their individual modernization efforts without interfering with each other, avoids processing contention, provides the best performance capabilities and positions the Department for the FMLOB initiative. It maintains strong internal controls and business processes that have been developed and functioning over the past year. This solution is not the least expensive, however, it has the least amount of risk to the government of the four alternatives.
    1. What year will the investment breakeven? (Specifically, when the budgeted costs savings execced the cumulative costs.) 2021
  2. What specific qualitative benefits will be realized? Continued control over and accountability of Department finances, financial management system and practices, financial system reporting capabilities, system performance and the ability to quickly respond to internal and external information inquiries. This alternative has produced clean financial statements and allowed the Department to perform monthly closes within three days of the month-end. Improved business processes are also available in this alternative, e.g. IPAC transactions have been automated to process them out of the suspense account upon receipt. Erroneous payments are avoided with a system of strong internal controls including data edit checks and clear separation of duties.

5. Federal Quantitative Benefits ($millions):

  Budgeted Cost Savings Cost Avoidance Justification for Budgeted Cost Savings Justification for Budgeted Cost Avoidance
PY-1 and Prior  
PY  
CY  
BY 0 11 [Not answered] The cost avoidance represents avoidance of staff salaries due to the reduced number of staff necessary for FMSS operations resulting from improved system efficiencies.
BY+1  
BY+2  
BY+3  
BY+4 and Beyond  
Total LCC Benefit 0 11 LCC = Life-cycle cost
  1. Will the selected alternative replace a legacy system in-part or in-whole? no
    1. If "yes," are the migration costs associated with the migration to the selected alternative included in this investment, the legacy investment, or in a separate migration investment? [Not answered]
    2. If "yes," please provide the following information:

List of Legacy Investment or Systems

Name of the Legacy Investment or Systems UPI if available Date of the System Retirement
There are no Legacy Investment or Systems.

Section B: Risk Management (All Capital Assets)

  1. Does the investment have a Risk Management Plan? yes
    1. If "yes," what is the date of the plan? Jul 31, 2008
    2. Has the Risk Management Plan been significantly changed since last year's submission to OMB? no
    3. If "yes," describe any significant changes: [Not answered]
  2. If there currently is no plan, will a plan be developed? [Not answered]
    1. If "yes," what is the planned completion date? [Not answered]
    2. If "no," what is the strategy for managing the risks? [Not answered]
  3. Briefly describe how investment risks are reflected in the life cycle cost estimate and investment schedule: This investment has completed the implementation portion of the task and is currently in a mixed life cycle because of enhancements requested by end users for reporting and/or functionality. Specific risks were identified and tracked during the implementation phase and those that remain valid beyond implementation continue to be tracked and monitored routinely. Additional risks appropriate to the mixed life cycle stage have been identified and are being tracked and reviewed monthly. All enhancements to reports and functionality are assessed for risk areas, have mitigation strategies assigned and are monitored as part of the monthly review process. Statements of objectives prepared for each enhancement includes a section for identifying risks for the task and are included in the consideration of the task schedule. Costs related to the mitigation of the risk are also included if necessary.

Section C: Cost and Schedule Performance (All Capital Assets)

  1. Does the earned value management system meet the criteria in ANSI/EIA Standard - 748? no
  2. Is the CV% or SV% greater than ± 10%? (CV%= CV/EV x 100; SV%= SV/PV x 100) no
    1. If "yes," was it the? [Not answered]
    2. If "yes," explain the causes of the variance: [Not answered]
    3. If "yes," describe the corrective actions [Not answered]
  3. Has the investment re-baselined during the past fiscal year? no
    1. If "yes," when was it approved by the agency head? [Not answered]

4. Comparison of Initial Baseline and Current Approved Baseline:

Description of Milestone Initial Baseline Current Baseline Current Baseline Variance  
Planned Completion Date Total Cost ($M) Estimated Completion Date
Planned:Actual
Total Cost ($M)
Planned:Actual
Schedule:Cost
(# days:$M)
Percent Complete
Oracle 11.03 implementation Delay Jan 22, 2002 3.165 Jan 22, 2002 Jan 22, 2002 3.165 3.153 0 0.012 100
Tier I Jun 28, 2002 0.157 Jun 28, 2002 Jun 28, 2002 0.157 0.151 0 0.006 100
Tier II Sep 30, 2004 2.115 Sep 30, 2004 Jan 30, 2005 2.115 2.3869 -122 -0.27 100
Pre-Implementation and Ramp Up Mar 31, 2004 0.75 Mar 31, 2004 Jan 23, 2004 0.75 0.786 68 -0.036 100
Tier III Aug 31, 2004 0.195 Aug 31, 2004 Feb 28, 2005 0.195 0.195 -105 0 100
Tier IV Sep 27, 2006 9.571 Sep 27, 2006 Sep 27, 2006 9.571 8.837 0 0.734 100
Project Management Office Dec 29, 2006 1.976 Dec 29, 2006 Dec 29, 2006 1.976 1.5289 0 0.4471 100
Independent Verification and Validation Dec 29, 2006 4.723 Dec 29, 2006 Dec 29, 2006 4.723 3.8118 0 0.9112 100
Execute CRPs/EP Apr 30, 2006 6.097 Apr 30, 2006 Jun 30, 2006 6.097 5.891 -61 0.21 100
Execute Conversion Sep 18, 2006 1.093 Sep 18, 2006 Sep 18, 2006 1.093 0.518 0 0.57 100
Execute Testing Jul 31, 2006 2.087 Jul 31, 2006 Jul 31, 2006 2.087 1.907 0 0.18 100
Support Training Delivery Sep 27, 2006 0.294 Sep 27, 2006 Sep 27, 2006 0.294 0.521 0 -0.23 100
iSupplier Licenses Sep 30, 2006 0.227 Sep 30, 2006 Sep 30, 2006 0.227 0.227 0 0 100
Financial Statement Improvements Dec 31, 2006 0.705 Dec 31, 2006 Dec 31, 2006 0.705 0.1695 0 0.54 100
Financial Statement Adjustment Module Dec 31, 2006 0.437 Dec 31, 2006 Dec 31, 2006 0.437 0.132 0 0.3 100
Financial Statement Footnotes Dec 31, 2006 0.268 Dec 31, 2006 Dec 31, 2006 0.268 0.0375 0 0.23 100
GAPS Document Conversion Sep 30, 2006 0.1 Sep 30, 2006 Sep 30, 2006 0.1 0.1 0 0 100
Training Dec 31, 2006 0.137 Dec 31, 2006 Dec 31, 2006 0.137 0.14 0 -0.003 100
Pre-Production Validation Sep 25, 2006 0.698 Sep 25, 2006 Sep 25, 2006 0.698 0.698 0 0.698 100
Execution of Cutover Oct 20, 2006 0.204 Oct 20, 2006 Oct 20, 2006 0.204 0.204 0 0 100
Post-Production Validation Dec 29, 2006 0.268 Dec 29, 2006 Dec 29, 2006 0.268 0.268 0 0 100
FY01 Maintenance Sep 30, 2001 0.9452 Sep 30, 2001 Sep 30, 2001 0.9452 0.9452 0 0 100
FY02 Maintenance Sep 30, 2002 3.5495 Sep 30, 2002 Sep 30, 2002 3.5495 3.5994 0 -0.05 100
FY03 Maintenance Sep 30, 2003 4.656 Sep 30, 2003 Sep 30, 2003 4.656 4.0921 0 0.56 100
FY04 Maintenance Sep 30, 2004 3.4352 Sep 30, 2004 Sep 30, 2004 3.4352 3.4596 0 -0.02 100
FY04 Report/Enhancemens Sep 30, 2004 0.35 Sep 30, 2004 Sep 30, 2004 0.35 0.36 0 -0.01 100
FY04 Interface Enhancements Sep 30, 2004 0.41 Sep 30, 2004 Sep 30, 2004 0.41 0.422 0 -0.01 100
FY05 Maintenance Sep 30, 2005 3.1543 Sep 30, 2005 Sep 30, 2005 3.1543 3.285727 0 -0.13 100
FY05 Interface Enhancements Sep 30, 2005 0 Sep 30, 2005 Sep 30, 2005 0 0 0 0 0
FY06 Maintenance Sep 30, 2006 3.0318 Sep 30, 2006 Sep 30, 2006 3.0318 3.0318 0 0 100
FY06 Enhancements Sep 30, 2006 0.1 Sep 30, 2006 Apr 30, 2006 0.1 0.055 153 0.045 100
FY06 Interface Enhancements Sep 30, 2006 0.1 Sep 30, 2006 Jun 30, 2007 0.1 0.109 92 -0.01 100
FY06 Licenses Sep 30, 2006 0.3455 Sep 30, 2006 Sep 30, 2006 0.3455 0.3455 0 0 100
FY07 Maintenance Sep 30, 2007 3.0314 Sep 30, 2007 Sep 30, 2007 3.0314 3.0314 0 0 100
FY07 Enhancements Sep 30, 2007 0.989 Sep 30, 2007 Sep 30, 2007 0.989 0.989 0 0 100
FY07 Licenses Sep 30, 2007 0.404 Sep 30, 2007 Sep 30, 2007 0.404 0.404 0 0 100
FY07 Security Sep 30, 2007 0.025 Sep 30, 2007 Sep 30, 2007 0.025 0.025 0 0 100
FY08 Reports Sep 30, 2008 0.2 Sep 30, 2008 Aug 28, 2008 0.2 0.2 30 0 100
FY08 Enhancements Sep 30, 2008 0.29 Sep 30, 2008 Jun 30, 2008 0.29 0.29 92 0 100
FY08 Security Jun 30, 2008 0.03 Jun 30, 2008 Jun 30, 2008 0.03 0.03 0 0 100
FY08 Licenses Jun 30, 2008 0.522 Jun 30, 2008 Jun 30, 2008 0.522 0.522 0 0 100
FY08 Maintenance Sep 30, 2008 3.15 Sep 30, 2008 [Not answered] 3.15 2.835 0 0 90
FY09 C&A Sep 30, 2009 0.015 Sep 30, 2009 [Not answered] 0.015 [Not answered] [Not answered] [Not answered] 0
FY09 Reports Sep 12, 2009 0.2 Sep 12, 2009 [Not answered] 0.2 [Not answered] [Not answered] [Not answered] 0
FY09 Enhancements Sep 12, 2009 1.345 Sep 12, 2009 [Not answered] 1.345 [Not answered] [Not answered] [Not answered] 0
FY09 Security Sep 30, 2009 0.03 Sep 30, 2009 [Not answered] 0.03 [Not answered] [Not answered] [Not answered] 0
FY09 Licenses Sep 30, 2009 0.622 Sep 30, 2009 [Not answered] 0.622 [Not answered] [Not answered] [Not answered] 0
FY09 Maintenance Sep 30, 2009 1.825 Sep 30, 2009 [Not answered] 1.825 [Not answered] [Not answered] [Not answered] 0
FY10 Reports Sep 30, 2010 0.2 Sep 30, 2010 [Not answered] 0.2 [Not answered] [Not answered] [Not answered] 0
FY10 Enhancements Sep 30, 2010 1.05 Sep 30, 2010 [Not answered] 1.05 [Not answered] [Not answered] [Not answered] 0
FY10 Security Sep 30, 2010 0.03 Sep 30, 2010 [Not answered] 0.03 [Not answered] [Not answered] [Not answered] 0
FY10 Licenses Sep 30, 2010 0.622 Sep 30, 2010 [Not answered] 0.622 [Not answered] [Not answered] [Not answered] 0
FY10 Maintenance Sep 30, 2010 1.720312 Sep 30, 2010 [Not answered] 1.720312 [Not answered] [Not answered] [Not answered] 0
                   

Return to OMB Exhibit 300 page