**RITAX004: Intermodal Transportation Data Base (previously BTSXX004)**

  -----------------------------------------------------------------------
  **Exhibit 300: Part I: Summary Information and Justification (All
  Capital Assets)**

  -----------------------------------------------------------------------

  ----------------------------------- -----------------------------------
  **I.A. Overview**                   

                                      

  **1. Date of Submission:**          6/2/2006

  **2. Agency:**                      Department of Transportation

  **3. Bureau:**                      Research & Innovative technology
                                      Administration

  **4. Name of this Capital Asset:**  RITAX004: Intermodal Transportation
                                      Data Base (previously BTSXX004)

  **5. Unique Project (Investment)    021-53-01-14-01-1220-00
  Identifier: (For IT investment      
  only, see section 53. For all       
  other, use agency ID system.)**     

  **6. What kind of investment will   Mixed Life Cycle
  this be in FY2008? (Please NOTE:    
  Investments moving to O&M ONLY in   
  FY2008, with Planning/Acquisition   
  activities prior to FY2008 should   
  not select O&M. These investments   
  should indicate their current       
  status.)**                          

  **7. What was the first budget year FY2001 or earlier
  this investment was submitted to    
  OMB?**                              

  **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:**                              

  TranStats is a Congress-mandated    
  system for disseminating intermodal 
  transportation data in a format     
  suitable for analysis and catering  
  to the needs of decision-makers and 
  transportation researchers. It      
  consists of a Data Warehouse, a Web 
  Site (http://www.transtats.bts.gov) 
  for public distribution, and an     
  intranet to provide internal data   
  analysis service. In FY2002,        
  TranStats completed its development 
  and went into the operations and    
  maintenance phase of its lifecycle. 
  TranStats was deemed mission        
  critical by Office of Secretary of  
  Transportation International and    
  Aviation Affairs (OSTX) in their    
  analyses that help formulate        
  aviation policies affecting a       
  trillion-dollar industry. TranStats 
  was rebaselined in FY2005 and then  
  in FY2007 due to BTS budget cut in  
  the Transportation Re-Authorization 
  Bill (SAFETEA LU, 12/20/2005).      
  Based on the newly defined RITA BTS 
  strategic goals, TranStats reduced  
  its O&M scope and placed its first  
  priority on scheduled releases of   
  timely, user-friendly, and          
  high-quality airline data. In       
  FY2005, TranStats became part of    
  the Total Quality Management (TQM)  
  task force to improve airline data  
  quality, an effort jointly          
  sponsored by OSTX and RITA BTS. The 
  task force identified these         
  performance gaps in airline data    
  collection, processing, and         
  dissemination: 1) The reporting     
  carriers submit data in variegated  
  formats, forcing a lot of manual    
  processing. 2) The support tables   
  used by RITA BTS to validate and    
  process data lack internal          
  consistency and referential         
  integrity. 3) Internal data release 
  is not complete, nor timely. 4)     
  Data gaps are identified in OST     
  Docket 1998-4043, which calls for a 
  complete re-engineering of how      
  airline TRAFFIC and O&D will be     
  reported to DOT. TranStats was      
  tasked to address gaps 1 to 3. It   
  started project planning and a      
  pilot project for web-filing in     
  FY2005 to address Gap #1 and in FY  
  2006 started initial work on        
  support table cleanup and           
  maintenance (Gap#2) and Auto Flow   
  (Gat #3). The three enhancement     
  tasks planned for 2007 and 2008     
  explain the DME in FY2008. In       
  FY2006, the TQM task force reached  
  the consensus that the Airline      
  Reporting Data and Information      
  System (ARDIS\--RITA008) and the    
  TranStats system should be          
  integrated so that airline data     
  collection, processing, and         
  dissemination can be re-engineered  
  to meet the challenges when Gap #4  
  will be closed by rule making in    
  the future. In FY2008, TranStats    
  will investigate the approaches     
  towards the integration.            

  **9. Did the Agency\'s              Yes
  Executive/Investment Committee      
  approve this request?**             

  **   a. If \"yes,\" what was the    9/1/2006
  date of this approval?**            

  **10. Did the Project Manager       Yes
  review this Exhibit?**              

  **11. Contact information of        
  Project Manager?**                  

  **Name**                            

  Yao, Fusheng                        

  **Phone Number**                    202-366-5572

  **Email**                           fusheng.yao@dot.gov

  **12. Has the agency developed      No
  and/or promoted cost effective,     
  energy efficient and                
  environmentally sustainable         
  techniques or practices for this    
  project.**                          

  **   a. Will this investment        Yes
  include electronic assets           
  (including computers)?**            

  **   b. Is this investment for new  No
  construction or major retrofit of a 
  Federal building or facility?       
  (answer applicable to non-IT assets 
  only)**                             

  **      1. If \"yes,\" is an ESPC   
  or UESC being used to help fund     
  this investment?**                  

  **      2. If \"yes,\" will this    
  investment meet sustainable design  
  principles?**                       

  **      3. If \"yes,\" is it         
  designed to be 30% more energy      
  efficient than relevant code?**     

  **13. Does this investment support  No
  one of the PMA initiatives?**       

  **   If \"yes,\" check all that     
  apply:**                            

  **   13a. Briefly describe how this  
  asset directly supports the         
  identified initiative(s)?**         

  **14. Does this investment support  Yes
  a program assessed using the        
  Program Assessment Rating Tool      
  (PART)? (For more information about 
  the PART, visit                     
  www.whitehouse.gov/omb/part.)**     

  **   a. If \"yes,\" does this       No
  investment address a weakness found 
  during the PART review?**           

  **   b. If \"yes,\" what is the     BTS (Transportation Statistics
  name of the PART program assessed   Program)
  by OMB\'s Program Assessment Rating 
  Tool?**                             

  **   c. If \"yes,\" what PART       Moderately Effective
  rating did it receive?**            

  **15. Is this investment for        Yes
  information technology?**           

  **If the answer to Question: \"Is   
  this investment for information     
  technology?\" was \"Yes,\" complete 
  this sub-section. If the answer is  
  \"No,\" do not answer this          
  sub-section.**                      

  **For information technology        
  investments only:**                 

  **16. What is the level of the IT   Level 1
  Project? (per CIO Council PM        
  Guidance)**                         

  **17. What project management       \(1\) Project manager has been
  qualifications does the Project     validated as qualified for this
  Manager have? (per CIO Council PM   investment
  Guidance):**                        

  **18. Is this investment identified No
  as \"high risk\" on the Q4 - FY     
  2006 agency high risk report (per   
  OMB\'s \"high risk\" memo)?**       

  **19. Is this a financial           No
  management system?**                

  **   a. If \"yes,\" does this       No
  investment address a FFMIA          
  compliance area?**                  

  **      1. If \"yes,\" which         
  compliance area:**                  

  **      2. If \"no,\" what does it   
  address?**                          

  **   b. 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**                        

                                      

  **20. What is the percentage        
  breakout for the total FY2008       
  funding request for the following?  
  (This should total 100%)**          

  **Hardware**                        0

  **Software**                        0

  **Services**                        100.000000

  **Other**                            

  **21. If this project produces      Yes
  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?**                       

  **22. Contact information of        
  individual responsible for privacy  
  related questions:**                

  **Name**                            

  Monniere, Robert                    

  **Phone Number**                    202.366-5498

  **Title**                           Privacy Officer

  **E-mail**                          Robert.Monniere@dot.gov

  **23. Are the records produced by   Yes
  this investment appropriately       
  scheduled with the National         
  Archives and Records                
  Administration\'s approval?**       
  ----------------------------------- -----------------------------------

  --------------------------------------------------------------------- --
  **I.B. Summary of Funding**                                           

                                                                        

  **Provide the total estimated life-cycle cost for this investment by  
  completing the following table. All amounts represent budget          
  authority in millions, and are rounded to three decimal places.       
  Federal personnel costs should be included only in the row designated 
  \"Government FTE Cost,\" and should be excluded from the amounts      
  shown for \"Planning,\" \"Full Acquisition,\" and                     
  \"Operation/Maintenance.\" The total estimated annual cost of the     
  investment is the sum of costs for \"Planning,\" \"Full               
  Acquisition,\" and \"Operation/Maintenance.\" For Federal buildings   
  and facilities, life-cycle costs should include long term energy,     
  environmental, decommissioning, and/or restoration costs. The costs   
  associated with the entire life-cycle of the investment should be     
  included in this report.**                                            

  **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)**                                     
  --------------------------------------------------------------------- --

<table>
<colgroup>
<col style="width: 20%" />
<col style="width: 7%" />
<col style="width: 7%" />
<col style="width: 7%" />
<col style="width: 7%" />
<col style="width: 9%" />
<col style="width: 14%" />
<col style="width: 11%" />
<col style="width: 8%" />
<col style="width: 6%" />
</colgroup>
<tbody>
<tr class="odd">
<td></td>
<td><strong>PY - 1<br />
and<br />
Earlier</strong></td>
<td><strong>PY 2006</strong></td>
<td><strong>CY 2007</strong></td>
<td><strong>BY 2008</strong></td>
<td><strong>BY + 1 2009</strong></td>
<td><strong>BY + 2 2010</strong></td>
<td><strong>BY + 3 2011</strong></td>
<td><strong>BY + 4<br />
and<br />
Beyond</strong></td>
<td><strong>Total</strong></td>
</tr>
<tr class="even">
<td colspan="10">Planning</td>
</tr>
<tr class="odd">
<td>    Budgetary Resources</td>
<td>0</td>
<td>0</td>
<td>0</td>
<td>0.087</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td colspan="10">Acquisition</td>
</tr>
<tr class="odd">
<td>    Budgetary Resources</td>
<td>8.54</td>
<td>0</td>
<td>0.303</td>
<td>0.245</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td colspan="10">Subtotal Planning &amp; Acquisition</td>
</tr>
<tr class="odd">
<td>    Budgetary Resources</td>
<td>8.54</td>
<td>0</td>
<td>0.303</td>
<td>0.332</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td colspan="10">Operations &amp; Maintenance</td>
</tr>
<tr class="odd">
<td>    Budgetary Resources</td>
<td>4.078</td>
<td>1.18</td>
<td>0.605</td>
<td>0.61</td>
<td></td>
<td><p>&lt;FY09 and</p>
<p>beyond redacted&gt;</p></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td colspan="10">TOTAL</td>
</tr>
<tr class="odd">
<td>    Budgetary Resources</td>
<td>12.618</td>
<td>1.18</td>
<td>0.908</td>
<td>0.942</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td colspan="10">Government FTE Costs</td>
</tr>
<tr class="odd">
<td>  Budgetary Resources</td>
<td>2.1</td>
<td>0.43</td>
<td>0.82</td>
<td>0.861</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr class="even">
<td>Number of FTE represented by Costs:</td>
<td>20.0</td>
<td>5.0</td>
<td>4.0</td>
<td>4.0</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>

  ----------------------------------- -----------------------------------
  **Note: For the cross-agency        
  investments, this table should      
  include all funding (both managing  
  partner and partner agencies).      
  Government FTE Costs should not be  
  included as part of the TOTAL       
  represented.**                      

                                      

  **2. Will this project require the  No
  agency to hire additional FTE\'s?** 

  **   a. If \"yes,\" How many and in  
  what year?**                        

  **3. If the summary of spending has 
  changed from the FY2007             
  President\'s budget request,        
  briefly explain those changes:**    

  \<Redacted\>                        
  ----------------------------------- -----------------------------------

  --------------------------------------------------------------------- --
  **I.C. Acquisition/Contract Strategy**                                

                                                                        

  **1. Complete the table for all (including all non-Federal) contracts 
  and/or task orders currently in place or planned for this investment. 
  Total Value should include all option years for each contract.        
  Contracts and/or task orders completed do not need to be included.**  

  **Contracts/Task Orders Table:**                                      
  --------------------------------------------------------------------- --

  ---------- ------------ ----------- ------------ --------- ----------- ----------- ----------- ---------------- ------------------------ ----------------- ------------- ------------- ------------ -------- ----------------- --------------- ----------------
  **Row      **Contract   **Type of   **Has the    **If so   **Start     **End date  **Total     **Is this an     **Is it performance      **Competitively   **What, if    **Is EVM in   **Does the   **Name   **CO Contact      **Contracting   **If N/A, has
  Number**   or Task      Contract/   contract     what is   date of     of          Value of    Interagency      based?**                 awarded?**        any,          the           contract     of CO**  information       Officer         the agency
             Order        Task        been         the date  Contract/   Contract/   Contract/   Acquisition?**                                              alternative   contract?**   include the           (phone/email)**   Certification   determined the
             Number**     Order**     awarded?**   of the    Task        Task        Task                                                                    financing                   required                                Level**         CO assigned has
                                                   award? If Order**     Order**     Order**                                                                 option is                   security and                                            the competencies
                                                   not, what                                                                                                 being used?**               privacy                                                 and skills
                                                   is the                                                                                                                                clauses?**                                              necessary to
                                                   planned                                                                                                                                                                                       support this
                                                   award                                                                                                                                                                                         acquisition?**
                                                   date?**                                                                                                                                                                                       

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  

                                                                                                                  \<Acquisition/contract                                                                                                          
                                                                                                                  data redacted\>                                                                                                                

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  

                                                                                                                                                                                                                                                  
  ---------- ------------ ----------- ------------ --------- ----------- ----------- ----------- ---------------- ------------------------ ----------------- ------------- ------------- ------------ -------- ----------------- --------------- ----------------

![](media/image1.png){width="0.20833333333333334in" height="0.15625in"}

  ----------------------------------- -----------------------------------
                                      

  **2. If earned value is not         
  required or will not be a contract  
  requirement for any of the          
  contracts or task orders above,     
  explain why:**                      

  EVM was not in the contracts        
  awarded for FY2006 because at the   
  time the original contracts were    
  awarded, they covered Operations    
  and Maintenance only. An operation  
  analysis plan was required in the   
  task orders for all three           
  contracts. The contractors report   
  their operational analysis numbers  
  each month to the COTR. When the    
  SAFTEA LU cut BTS budget by \$5M,   
  RITA BTS decided for TranStats to   
  limit its scope and focus on        
  airline data. When the airline data 
  Total Quality Management (TQM) task 
  force was set up in FY2005,         
  TranStats was tasked with           
  enhancements to improve airline     
  data. In FY2005, Federal Employees  
  started planning and piloting of    
  the Web Filing project, and in      
  FY2006 supportable cleanup and      
  maintenance as well as data         
  autoflow were initiated as          
  TranStats enhancements but the      
  total cost of these enhancements    
  did not exceed 25% and using the    
  criteria at the time, TranStats     
  remained in the Operation and       
  Maintenance Mode and EVM was not    
  added to the contracts. In FY2007   
  and FY2008, the contracts will      
  include EVM requirements. As we do  
  not have extra funding to require   
  the use of specific EVM tools, the  
  requirement will be for the         
  contractors involved in new         
  developments (mainly supportable    
  cleanup, web-filing, and auto flow) 
  to produce the required numbers     
  that conform to the ANSI standards. 

  **3. Do the contracts ensure        Yes
  Section 508 compliance?**           

  **   a. Explain why:**               

  **4. Is there an acquisition plan   No
  which has been approved in          
  accordance with agency              
  requirements?**                     

  **   a. If \"yes,\" what is the      
  date?**                             

  **   b. If \"no,\" will an          Yes
  acquisition plan be developed?**    

  **      1. If \"no,\" briefly       This project started with goals to
  explain why:**                      cover data from all modes. Since
                                      then, the goals have undergone a
                                      number of changes and only
                                      short-term acquisition planning had
                                      been done. The most recent change
                                      came from the reduction of fund in
                                      the final Highway Trust Fund
                                      reauthorization (SAFETEA LU). The
                                      project manager is working with
                                      RITA BTS when the Agency is working
                                      out its final strategic plan. A
                                      long-term aquisition plan is
                                      expected to be completed early
                                      FY06.
  ----------------------------------- -----------------------------------

  --------------------------------------------------------------------- --
  **I.D. Performance Information**                                      

                                                                        

  **In order to successfully address this area of the exhibit 300,      
  performance goals must be provided for the agency and be linked to    
  the annual performance plan. The investment must discuss the          
  agency\'s mission and strategic goals, and performance measures must  
  be provided. These goals need to map to the gap in the agency\'s      
  strategic goals and objectives this investment is designed to fill.   
  They are the internal and external performance benefits this          
  investment is expected to deliver to the agency (e.g., improve        
  efficiency by 60 percent, increase citizen participation by 300       
  percent a year to achieve an overall citizen participation rate of 75 
  percent by FY 2xxx, etc.). The goals must be clearly measurable       
  investment outcomes, and if applicable, investment outputs. They do   
  not include the completion date of the module, milestones, or         
  investment, or general goals, such as, significant, better, improved  
  that do not have a quantitative or qualitative measure.**             

  **Agencies must use Table 1 below for reporting performance goals and 
  measures for all non-IT investments and for existing IT investments   
  that were initiated prior to FY 2005. The table can be extended to    
  include measures for years beyond FY 2006.**                          

                                                                        

  **Performance Information Table 1:**                                  
  --------------------------------------------------------------------- --

  ---------- ---------------- --------------- ------------------- ---------------- ---------------
  **Fiscal   **Strategic      **Performance   **Actual/baseline   **Planned        **Performance
  Year**     Goal(s)          Measure**       (from Previous      Performance      Metric Results
             Supported**                      Year)**             Metric           (Actual)**
                                                                  (Target)**       

  2003       Organizational   number of       85 databases (35    100 databases    100%
             Excellence       available       hosted databases +  available to     
                              databases       50 links to other   users (40 hosted 
                                              transportation data databases + 60   
                                              sites)              links to other   
                                                                  transportation   
                                                                  data sites)      

  2004       Organizational   number of       40                  15 actively      100%
             Excellence       databases                           updated          
                              hosted and                          databases        
                              actively                                             
                              updated (Reduce                                      
                              number of                                            
                              databases and                                        
                              ensure regular                                       
                              data releases)                                       

  2004       Organizational   number of       Not previously      80% of all web   100%
             Excellence       databases       measured (New       queries will be  
                              queries         measurement; no     performed in 15  
                              performed in 15 previous data)      sec or less      
                              sec or less                                          

  2004       Organizational   Create process  Not previously      2 new process    100% (Data
             Excellence       improvements    measured (New       will be          release
                              that lead to    measurement; no     implemented to   streamline and
                              measurable cost previous data)      improve data     Data Error
                              savings and                         integration,     Check, both
                              reduction in                        validation, or   ensuring timely
                              process time                        delivery         release of
                                                                                   scheduled data
                                                                                   and flagging
                                                                                   possible data
                                                                                   errors as
                                                                                   feedback.)
  ---------- ---------------- --------------- ------------------- ---------------- ---------------

  --------------------------------------------------------------------- --
                                                                        

  **All new IT investments initiated for FY 2005 and beyond must use    
  Table 2 and are required to use the Federal Enterprise Architecture   
  (FEA) Performance Reference Model (PRM). Please use Table 2 and the   
  PRM to identify the performance information pertaining to this major  
  IT investment. Map all Measurement Indicators to the corresponding    
  \"Measurement Area\" and \"Measurement Grouping\" identified in the   
  PRM. There should be at least one Measurement Indicator for at least  
  four different Measurement Areas (for each fiscal year). The PRM is   
  available at www.egov.gov.**                                          

  **Performance Information Table 2:**                                  
  --------------------------------------------------------------------- --

  ---------- --------------- ---------------- --------------- --------------- ---------------- -------------- ---------------
  **Fiscal   **Measurement   **Measurement    **Measurement   **Measurement   **Baseline**     **Planned      **Actual
  Year**     Area**          Category**       Grouping**      Indicator**                      Improvement to Results**
                                                                                               the Baseline** 

  2005       Customer        Service Quality  Accuracy of     All data errors Not measured     Over 99%       Over 99% errors
             Results                          Service or      flagged. Work   before           errors         are flagged
                                              Product         with the                         flagged; over  routinely
                                              Delivered       customers and                    50% resolved.  (including new
                                                              OAI to resolve                                  released
                                                              the flagged                                     airline
                                                              errors.                                         data);over 80%
                                                                                                              of errors
                                                                                                              resolved.

  2005       Customer        Timeliness and   Delivery Time   Timely release  95% for          98% and 100%   99% and 100%
             Results         Responsiveness                   of airline data scheduled        respectively   respectively
                                                              (weekly for     releases; 100%                  
                                                              OSTX and        for White House,                
                                                              government      Congress, and                   
                                                              users; monthly  OSTX special                    
                                                              or quarterly as requests                        
                                                              scheduled for                                   
                                                              the general                                     
                                                              public).                                        

  2005       Customer        Timeliness and   Delivery Time   Timely release  95% for          98% (improved) 99% and 100%
             Results         Responsiveness                   of airline data scheduled        and 100%       respectively
                                                              (weekly for     releases; 100%   (maintained)   
                                                              OSTX and        for White House, respectively   
                                                              government      Congress, and                   
                                                              users; monthly  OSTX special                    
                                                              or quarterly as requests                        
                                                              scheduled for                                   
                                                              the general                                     
                                                              public).                                        

  2005       Mission and     Public Affairs   Customer        Number of       15 hosted        20 hosted      19 hosted
             Business                         Services        databases       databases        databases + 73 databases + 73
             Results                                          available to    (analyzable and  linked         linked
                                                              the users       downloadable via databases      databases
                                                                              the TranStats                   (hosted
                                                                              web                             databases
                                                                              application) +                  further reduced
                                                                              73 linked                       due to budget
                                                                              databases (with                 cut)
                                                                              data profile and                
                                                                              links to the                    
                                                                              data owners\'                   
                                                                              websites)                       

  2005       Processes and   Management and   Compliance      \# of process   Two new          Maintain and   1 process of
             Activities      Innovation                       improvements    processes (data  improve        data validation
                                                              that lead to    release          streamline and implemented;1
                                                              measurable cost streamline and   data check     process of
                                                              savings and     data check)      processes      carrier decode
                                                              reduction in    introduced in    developed in   table
                                                              processing time 2004             2004 and start management is
                                                                                               developing 3   in the working
                                                                                               new processes. (scheduled for
                                                                                                              completion in
                                                                                                              2006);1 process
                                                                                                              of auto flow
                                                                                                              dependent on
                                                                                                              ARDIS O&M
                                                                                                              schedules.
                                                                                                              Schedule
                                                                                                              extended
                                                                                                              because of
                                                                                                              resource
                                                                                                              reduction.

  2005       Technology      Reliability and  Availability    \% of time      90%              93%            95%
                             Availability                     TranStats web                                   
                                                              site is                                         
                                                              available to                                    
                                                              end users                                       

  2005       Technology      Reliability and  Availability    \% of time      95%              98%            98%
                             Availability                     TranStats data                                  
                                                              warehouse is                                    
                                                              available to                                    
                                                              end users                                       

  2006       Customer        Customer Benefit Customer Impact Number of       0                9+              TBD by
             Results                          or Burden       carriers filing                                 9/30/2006
                                                              data over the                                   
                                                              internet                                        

  2006       Customer        Service Quality  Accuracy of     All data errors 99%              Over 99%       Over 99%
             Results                          Service or      flagged. Work                                   
                                              Product         with the                                        
                                              Delivered       customers and                                   
                                                              OAI to resolve                                  
                                                              the flagged                                     
                                                              errors.                                         

  2006       Customer        Timeliness and   Delivery Time   Timely release  96%              99% & 100%     99%
             Results         Responsiveness                   of airline data                  respectively   
                                                              (daily for OSTX                                 
                                                              and government                                  
                                                              users; monthly                                  
                                                              or quarterly as                                 
                                                              scheduled for                                   
                                                              the general                                     
                                                              public).                                        

  2006       Customer        Timeliness and   Delivery Time   OSTX required   Weekly           Daily          Daily autoflow
             Results         Responsiveness                   data release                                    

  2006       Mission and     Public Affairs   Customer        Number of       19 hosted        25 hosted      25+73 (9 with
             Business                         Services        hosted and      databases        databases + 73 scheduled
             Results                                          linked          (analyzable and  linked         releases) as of
                                                              databases       downloadable via databases      June 2006
                                                              available to    the TranStats                   
                                                              the users       web                             
                                                                              application) +                  
                                                                              73 linked                       
                                                                              databases (with                 
                                                                              data profile and                
                                                                              links to the                    
                                                                              data owners\'                   
                                                                              websites)                       

  2006       Processes and   Management and   Compliance      \# of process   Streamline, data Stabilize and  Carrier Decode
             Activities      Innovation                       improvements    check, Error     improve the    Table
                                                              that lead to    Report processes processes      maintenance
                                                              measurable cost implemented for  implemented in process
                                                              savings and     timely release   2004 and 2005  completed to
                                                              reduction in    and data quality and complete   ensure airline
                                                              processing time improvement.     Carrier Decode data integrity;
                                                                                               Table          started airport
                                                                                               maintenance    support table
                                                                                               process.       and autoflow
                                                                                                              processes in
                                                                                                              June.

  2006       Technology      Reliability and  Availability    \% of time      95%              95%            98%
                             Availability                     TranStats web                                   
                                                              site is                                         
                                                              available to                                    
                                                              end users                                       

  2007       Customer        Customer Benefit Customer Impact \% of carriers  FY2006 Actual    9+               TBD
             Results                          or Burden       filing via the  TBD 10/30/2006                  10/30/2007
                                                              internet                                        

  2007       Customer        Customer Benefit Customer Impact Number of       9+               24+             
             Results                          or Burden       carriers filing                                 
                                                              data via the                                    
                                                              internet                                        

  2007       Customer        Timeliness and   Delivery Time   Timely release  FY2006 Actual    99% and 100%     TBD
             Results         Responsiveness                   of airline data TBD 10/30/2006   respectively   10/30/2007
                                                              (daily for OSTX                                 
                                                              and government                                  
                                                              users; monthly                                  
                                                              or quarterly as                                 
                                                              scheduled for                                   
                                                              the general                                     
                                                              public).                                        

  2007       Mission and     Public Affairs   Customer        Number of       25 hosted        26 + 73 (Add a   TBD
             Business                         Services        hosted and      databases        new National   10/30/2007
             Results                                          linked          (analyzable and  Ferry Database 
                                                              databases       downloadable via as mandated by 
                                                              available to    the TranStats    Congress)      
                                                              the users       web                             
                                                                              application) +                  
                                                                              73 linked                       
                                                                              databases (with                 
                                                                              data profile and                
                                                                              links to the                    
                                                                              data owners\'                   
                                                                              websites)                       

  2007       Processes and   Productivity and Efficiency      \# of process   Streamline, data Complete         TBD
             Activities      Efficiency                       improvements    check, Error     airport        10/30/2007
                                                              that lead to    Report processes support table  
                                                              measurable cost implemented for  maintenance    
                                                              savings and     timely release   and autoflow   
                                                              reduction in    and data quality according to   
                                                              processing time improvement.     project        
                                                                              Carrier Decode   milestones     
                                                                              table            (T100 and F41) 
                                                                              maintenance                     
                                                                              implemented for                 
                                                                              data integrity;                 
                                                                              airport support                 
                                                                              table                           
                                                                              maintenance and                 
                                                                              auto flow                       
                                                                              process started.                

  2008       Customer        Customer Benefit Customer Impact \# of carriers  Actual for 2007  65+             TBD 10/30/2008
             Results                          or Burden       filing data via                                 
                                                              the internet                                    

  2008       Customer        Timeliness and   Delivery Time   \% of time      Actual for       Over 98% for     TBD
             Results         Responsiveness                   scheduled data  FY2007           public and     10/30/2008
                                                              are released on                  over 99% for   
                                                              time                             OSTX           

  2008       Customer        Timeliness and   Delivery Time   \% of web       Actual for       90%            TBD 10/30/2008 
             Results         Responsiveness                   queries         FY2007                          
                                                              performed in 15                                 
                                                              sec. or less                                    

  2008       Processes and   Productivity and Productivity    \# of process   Actual for 2007  Completed        TBD
             Activities      Efficiency                       improvements                     autoflow       10/30/2008
                                                              that lead to                     according to   
                                                              measurable cost                  project        
                                                              savings and                      milestones     
                                                              reduction in                     (Support       
                                                              processing time                  Tables)        

  2008       Technology      Effectiveness    IT Contribution \% of time      Actual for       Over 98%         TBD
                                              to Process,     TranStats web   FY2007                          10/30/2008
                                              Customer, or    site is                                         
                                              Mission         available to                                    
                                                              the public                                      

  2008       Technology      Effectiveness    IT Contribution \% of time      Actual for 2007  Over 99%         TBD
                                              to Process,     internal                                        10/30/2008
                                              Customer, or    database is                                     
                                              Mission         available to                                    
                                                              users                                           

  2008       Technology      Effectiveness    User            \% of time      Actual for       Over 99%         TBD
                                              Satisfaction    internal        FY2007                          10/30/2008
                                                              database is                                     
                                                              available to                                    
                                                              users                                           
  ---------- --------------- ---------------- --------------- --------------- ---------------- -------------- ---------------

  -----------------------------------------------------------------------

  -----------------------------------------------------------------------

  --------------------------------------------------------------- ----------
  **I.E. Security and Privacy**                                   

                                                                  

  **In order to successfully address this area of the business    
  case, each question below must be answered at the               
  system/application level, not at a program or agency level.     
  Systems supporting this investment on the planning and          
  operational systems security tables should match the systems on 
  the privacy table below. Systems on the Operational Security    
  Table must be included on your agency FISMA system inventory    
  and should be easily referenced in the inventory (i.e., should  
  use the same name or identifier).**                             

  **All systems supporting and/or part of this investment should  
  be included in the tables below, inclusive of both agency owned 
  systems and contractor systems. For IT investments under        
  development, security and privacy planning must proceed in      
  parallel with the development of the system/s to ensure IT      
  security and privacy requirements and costs are identified and  
  incorporated into the overall lifecycle of the system/s.**      

  **Please respond to the questions below and verify the system   
  owner took the following actions:**                             

  **1. Have the IT security costs for the system(s) been          Yes
  identified and integrated into the overall costs of the         
  investment:**                                                   

  **   a. If \"yes,\" provide the \"Percentage IT Security\" for  4.500000
  the budget year:**                                              

  **2. Is identifying and assessing security and privacy risks a  Yes
  part of the overall risk management effort for each system      
  supporting or part of this investment.**                        

                                                                  

  **3. Systems in Planning - Security Table:**                    
  --------------------------------------------------------------- ----------

  ---------- ----------------------- --------------- ----------------------
  **Name of  **Agency/ or Contractor **Planned       **Planned or Actual
  System**   Operated System?**      Operational     C&A Completion Date**
                                     Date**          

                                                     

                                                     

                                                     

                                     \<Security data 
                                     redacted\>      

                                                     

                                                     

                                                     

                                                     
  ---------- ----------------------- --------------- ----------------------

  --------------------------------------------------------------------- --
                                                                        

  **4. Operational Systems - Security Table:**                          
  --------------------------------------------------------------------- --

  ---------- ------------ --------- ------------ ------------ ----------- -------------- -------------
  **Name of  **Agency/ or **NIST    **Has C&A    **Date C&A   **What      **Date         **Date the
  System**   Contractor   FIPS 199  been         Complete**   standards   Complete(d):   contingency
             Operated     Risk      Completed,                were used   Security       plan tested**
             System?**    Impact    using NIST                for the     Control        
                          level**   800-37?**                 Security    Testing**      
                                                              Controls                   
                                                              tests?**                   

                                    \<Security                                           
                                    data                                                 
                                    redacted\>                                           
  ---------- ------------ --------- ------------ ------------ ----------- -------------- -------------

  ------------------------------------------------------------------- -----
                                                                      

  **5. Have any weaknesses related to any of the systems part of or   Yes
  supporting this investment been identified by the agency or IG?**   

  **   a. If \"yes,\" have those weaknesses been incorporated         Yes
  agency\'s plan of action and milestone process?**                   

  **6. Indicate whether an increase in IT security funding is         Yes
  requested to remediate IT security weaknesses?**                    

  **   a. If \"yes,\" specify the amount, provide a general           
  description of the weakness, and explain how the funding request    
  will remediate the weakness.**                                      

  Plan of Corrective Actions was created in 2004 and all items but    
  one was taken care of by fund requested from FY2004. The cost of    
  addressing the weaknesses were covered by the Office of IT budget.  
  The four weaknesses included a) Password length and special         
  character requirements not implemented; b) Password change no       
  required; and c) sensitive data and public data share one fail-over 
  server (though in different views). The last weakness has been      
  scheduled for FY2006 to address and fund was allocated to OIT in    
  FY2005. Additional fund may be requested if vulnerabilities are     
  identified during the re-certification and re-accreditation process 
  in the last quarter of FY2006.                                      

  **7. How are contractor security procedures monitored, verified,    
  validated by the agency for the contractor systems above?**         

  \<Redacted\>                                                        

                                                                      

  **8. Planning & Operational Systems - Privacy Table:**              
  ------------------------------------------------------------------- -----

  ----------- ----------- ---------------- ------------ ----------- ----------------
  **Name of   **Is this a **Is there a     **Is the PIA **Is a      **Was a new or
  System**    new         Privacy Impact   available to System of   amended SORN
              system?**   Assessment (PIA) the          Records     published in FY
                          that covers this public?**    Notice      06?**
                          system?**                     (SORN)      
                                                        required    
                                                        for this    
                                                        system?**   

  TranStats   No          No, because the  No, because  No          No, because the
                          system does not  a PIA is not             existing Privacy
                          contain,         yet required             Act system of
                          process, or      to be                    records was not
                          transmit         completed at             substantially
                          personal         this time.               revised in FY
                          identifying                               06.
                          information.                              
  ----------- ----------- ---------------- ------------ ----------- ----------------

  -----------------------------------------------------------------------

  -----------------------------------------------------------------------

+-------------------------------------------------------------------+---+
| **I.F. Enterprise Architecture (EA)**                             |   |
+-------------------------------------------------------------------+---+
|                                                                   |   |
+-------------------------------------------------------------------+---+
| **In order to successfully address this area of the business case |   |
| and capital asset plan you must ensure the investment is included |   |
| in the agency\'s EA and Capital Planning and Investment Control   |   |
| (CPIC) process, and is mapped to and supports the FEA. You must   |   |
| also ensure the business case demonstrates the relationship       |   |
| between the investment and the business, performance, data,       |   |
| services, application, and technology layers of the agency\'s     |   |
| EA.**                                                             |   |
+-------------------------------------------------------------------+---+
| **1. Is this investment included in your agency\'s target         | Y |
| enterprise architecture?**                                        | e |
|                                                                   | s |
+-------------------------------------------------------------------+---+
| **   a. If \"no,\" please explain why?**                          |   |
+-------------------------------------------------------------------+---+
|                                                                   |   |
+-------------------------------------------------------------------+---+
| **2. Is this investment included in the agency\'s EA Transition   | N |
| Strategy?**                                                       | o |
+-------------------------------------------------------------------+---+
| **   a. If \"yes,\" provide the investment name as identified in  |   |
| the Transition Strategy provided in the agency\'s most recent     |   |
| annual EA Assessment.**                                           |   |
+-------------------------------------------------------------------+---+
| **   b. If \"no,\" please explain why?**                          |   |
+-------------------------------------------------------------------+---+
| For the first version of the DOT Transition Strategy provided to  |   |
| OMB in February 2006, the Department chose to focus on those      |   |
| areas where new development was taking place, placing an emphasis |   |
| on the transitional aspects of the Department. At that time, this |   |
| investment was in steady state. With that in mind, those          |   |
| investments existing in O&M (Steady State), although integral     |   |
| parts of the Department\'s Enterprise Architecture, were not      |   |
| included within the scope of the initial release of the           |   |
| Transition Strategy. It is intended that those investments such   |   |
| as RITA\'s Intermodal Transportation Database (TranStats) will be |   |
| included in subsequent releases of the Department\'s Transition   |   |
| Strategy.                                                         |   |
+-------------------------------------------------------------------+---+
|                                                                   |   |
+-------------------------------------------------------------------+---+
| **3. Service Reference Model (SRM) Table:**                       |   |
|                                                                   |   |
| **Identify the service components funded by this major IT         |   |
| investment (e.g., knowledge management, content management,       |   |
| customer relationship management, etc.). Provide this information |   |
| in the format of the following table. For detailed guidance       |   |
| regarding components, please refer to                             |   |
| http://www.whitehouse.gov/omb/egov/.**                            |   |
+-------------------------------------------------------------------+---+

  -------------- ------------------------- ------------ --------------- -------------- ----------- ----------- ------------ --------------
  **Agency       **Agency Component        **Service    **FEA SRM       **FEA SRM      **FEA       **FEA       **Internal   **BY Funding
  Component      Description**             Domain**     Service Type**  Component**    Service     Service     or External  Percentage**
  Name**                                                                               Component   Component   Reuse?**     
                                                                                       Reused      Reused                   
                                                                                       Name**      UPI**                    

  TranStats Data Databases housed by the   Back Office  Data Management Data Cleansing                         No Reuse     10
  Warehouse      TranStats system where a  Services                                                                         
                 data checking and error                                                                                    
                 flag process has been                                                                                      
                 established for each data                                                                                  
                 release.                                                                                                   

  TranStats Data Databases housed by the   Back Office  Data Management Data Warehouse                         No Reuse     20
  Warehouse      TranStats System          Services                                                                         
                 organized and indexed for                                                                                  
                 quick access and                                                                                           
                 exploration of data in                                                                                     
                 the magnitude of hundreds                                                                                  
                 of millions of records.                                                                                    

  TranStats Data Databases housed by the   Back Office  Data Management Meta Data                              No Reuse     10
  Warehouse      TranStats system          Services                     Management                                          
                 supoprted by metadata                                                                                      
                 created by transportation                                                                                  
                 experts and                                                                                                
                 statisticians, based on                                                                                    
                 user requirements.                                                                                         

  TranStats Web  Applications and tools    Business     Analysis and    Mathematical                           No Reuse     10
  Applications   hosted on the TranStats   Analytical   Statistics                                                          
                 website                   Services                                                                         
                 (www.transtats.bts.gov)                                                                                    
                 that allow summary data                                                                                    
                 exploration (including                                                                                     
                 one-way, crosstabs and                                                                                     
                 time series) of most of                                                                                    
                 the databases hosted on                                                                                    
                 the TranStats system with                                                                                  
                 a number specialized                                                                                       
                 applications developed to                                                                                  
                 dynamically summarize and                                                                                  
                 present data of a special                                                                                  
                 nature, such as Border                                                                                     
                 Crossing and Ferry data.                                                                                   

  TranStats      Airline data prepocessed  Business     Business        Decision                               No Reuse     15
  Intranet       with metadata accessible  Analytical   Intelligence    Support and                                         
                 via intranet and 3rd      Services                     Planning                                            
                 party applications in                                                                                      
                 support of decision                                                                                        
                 making by the OSTX-50 of                                                                                   
                 the Department of                                                                                          
                 Transportation.                                                                                            

  TranStats Web  Applications and tools    Business     Reporting       Ad Hoc                                 No Reuse     10
  Applications   hosted on the TranStats   Analytical                                                                       
                 website                   Services                                                                         
                 (www.transtats.bts.gov)                                                                                    
                 that allow summary data                                                                                    
                 exploration (including                                                                                     
                 crosstabs and time                                                                                         
                 series) of most of the                                                                                     
                 databases hosted on the                                                                                    
                 TranStats system with a                                                                                    
                 number specialized                                                                                         
                 applications developed to                                                                                  
                 summarize and present                                                                                      
                 data of a special nature,                                                                                  
                 such as Border Crossing                                                                                    
                 and Ferry data.                                                                                            

  TranStats Web  Applications and tools    Business     Visualization   Graphing /                             No Reuse     5
  Applications   hosted on the TranStats   Analytical                   Charting                                            
                 website                   Services                                                                         
                 (www.transtats.bts.gov)                                                                                    
                 that present data summary                                                                                  
                 both in tables and                                                                                         
                 charts.                                                                                                    

  TranStats Web  TranStats web             Digital      Content         Content                                No Reuse     10
  Service        dissemination of data and Asset        Management      Publishing and                                      
                 statistics                Services                     Delivery                                            

  TranStats Web  TranStats web             Digital      Knowledge       Knowledge                              No Reuse     10
  Site           dissemination of data and Asset        Management      Distribution                                        
                 statistics                Services                     and Delivery                                        
  -------------- ------------------------- ------------ --------------- -------------- ----------- ----------- ------------ --------------

+---------------------------------------------------------------------+---+
|                                                                     |   |
+---------------------------------------------------------------------+---+
| **Use existing SRM Components or identify as \"NEW\". A \"NEW\"     |   |
| component is one not already identified as a service component in   |   |
| the FEA SRM.**                                                      |   |
+---------------------------------------------------------------------+---+
| **A reused component is one being funded by another investment, but |   |
| being used by this investment. Rather than answer yes or no,        |   |
| identify the reused service component funded by the other           |   |
| investment and identify the other investment using the Unique       |   |
| Project Identifier (UPI) code from the OMB Ex 300 or Ex 53          |   |
| submission.**                                                       |   |
+---------------------------------------------------------------------+---+
| **\'Internal\' reuse is within an agency. For example, one agency   |   |
| within a department is reusing a service component provided by      |   |
| another agency within the same department. \'External\' reuse is    |   |
| one agency within a department reusing a service component provided |   |
| by another agency in another department. A good example of this is  |   |
| an E-Gov initiative service being reused by multiple organizations  |   |
| across the federal government.**                                    |   |
+---------------------------------------------------------------------+---+
| **Please provide the percentage of the BY requested funding amount  |   |
| used for each service component listed in the table. If external,   |   |
| provide the funding level transferred to another agency to pay for  |   |
| the service.**                                                      |   |
+---------------------------------------------------------------------+---+
|                                                                     |   |
+---------------------------------------------------------------------+---+
| **4. Technical Reference Model (TRM) Table:**                       |   |
|                                                                     |   |
| **To demonstrate how this major IT investment aligns with the FEA   |   |
| Technical Reference Model (TRM), please list the Service Areas,     |   |
| Categories, Standards, and Service Specifications supporting this   |   |
| IT investment.**                                                    |   |
+---------------------------------------------------------------------+---+

  -------------- ---------------- ---------------- -------------- ------------------
  **FEA SRM      **FEA TRM        **FEA TRM        **FEA TRM      **Service
  Component**    Service Area**   Service          Service        Specification
                                  Category**       Standard**     (i.e. vendor or
                                                                  product name)**

  Content        Component        Business Logic   Platform       JavaScript
  Publishing and Framework                         Independent    
  Delivery                                                        

  Content        Component        Data Management  Database       Active Data
  Publishing and Framework                         Connectivity   Objects (ADO)
  Delivery                                                        

  Knowledge      Component        Data Management  Database       Open Database
  Distribution   Framework                         Connectivity   Connectivity
  and Delivery                                                    (ODBC)

  Knowledge      Component        Presentation /   Dynamic        Microsoft .Net
  Distribution   Framework        Interface        Server-Side    Framework
  and Delivery                                     Display        

  Content        Service Access   Delivery         Internet       Microsoft IIS
  Publishing and and Delivery     Channels                        
  Delivery                                                        

  Mathematical   Service Access   Delivery         Internet       Microsoft IIS
                 and Delivery     Channels                        

  Knowledge      Service Access   Delivery         Intranet       Microsoft ODBC
  Distribution   and Delivery     Channels                        
  and Delivery                                                    

  Knowledge      Service Access   Service          Service        Hyper Text
  Distribution   and Delivery     Transport        Transport      Transfer Protocol
  and Delivery                                                    (HTTP)

  Content        Service Access   Service          Service        Hyper Text
  Publishing and and Delivery     Transport        Transport      Transfer Protocol
  Delivery                                                        (HTTP)

  Data Warehouse Service          Integration      Enterprise     Sybase IQ
                 Interface and                     Application    
                 Integration                       Integration    

  Meta Data      Service          Integration      Middleware     Database Access:
  Management     Interface and                                    OPEN ANSI SQL/92
                 Integration                                      

  Ad Hoc         Service          Integration      Middleware     Database Access:
                 Interface and                                    OPEN ANSI SQL/92
                 Integration                                      

  Graphing /     Service          Integration      Middleware     Object Request
  Charting       Interface and                                    Broker (ORB):
                 Integration                                      Component Object
                                                                  Model (COM)

  Data Cleansing Service Platform Database /       Database       Oracle
                 and              Storage                         
                 Infrastructure                                   

  Data Cleansing Service Platform Database /       Database       SQL Server
                 and              Storage                         
                 Infrastructure                                   

  Data Cleansing Service Platform Database /       Database       Sybase IQ
                 and              Storage                         
                 Infrastructure                                   

  Graphing /     Service Platform Delivery Servers Application    CORDA PopChart
  Charting       and                               Servers        
                 Infrastructure                                   

  Decision       Service Platform Delivery Servers Application    SAS
  Support and    and                               Servers        
  Planning       Infrastructure                                   

  Content        Service Platform Delivery Servers Web Servers    Internet
  Publishing and and                                              Information Server
  Delivery       Infrastructure                                   

  Knowledge      Service Platform Delivery Servers Web Servers    Internet
  Distribution   and                                              Information Server
  and Delivery   Infrastructure                                   

  Data Warehouse Service Platform Hardware /       Servers /      Enterprise Server
                 and              Infrastructure   Computers      
                 Infrastructure                                   

  Content        Service Platform Hardware /       Servers /      Enterprise Server
  Publishing and and              Infrastructure   Computers      
  Delivery       Infrastructure                                   

  Knowledge      Service Platform Hardware /       Servers /      Enterprise Server
  Distribution   and              Infrastructure   Computers      
  and Delivery   Infrastructure                                   
  -------------- ---------------- ---------------- -------------- ------------------

  ----------------------------------- -----------------------------------
  **Service Components identified in  
  the previous question should be     
  entered in this column. Please      
  enter multiple rows for FEA SRM     
  Components supported by multiple    
  TRM Service Specifications**        

  **In the Service Specification      
  field, Agencies should provide      
  information on the specified        
  technical standard or vendor        
  product mapped to the FEA TRM       
  Service Standard, including model   
  or version numbers, as              
  appropriate.**                      

                                      

  **5. Will the application leverage  No
  existing components and/or          
  applications across the Government  
  (i.e., FirstGov, Pay.Gov, etc)?**   

  **   a. If \"yes,\" please          
  describe.**                         

                                      

  **6. Does this investment provide   Yes
  the public with access to a         
  government automated information    
  system?**                           

  **   a. If \"yes,\" does customer   Yes
  access require specific software    
  (e.g., a specific web browser       
  version)?**                         

  **      1. If \"yes,\" provide the  IE browser 6.1 and above or
  specific product name(s) and        NetScape browser 7.0 and above
  version number(s) of the required   
  software and the date when the      
  public will be able to access this  
  investment by any software (i.e. to 
  ensure equitable and timely access  
  of government information and       
  services).**                        

                                      
  ----------------------------------- -----------------------------------

  -----------------------------------------------------------------------
  **Exhibit 300: Part II: Planning, Acquisition and Performance
  Information**

  -----------------------------------------------------------------------

+---------------------------------------------------------------+------+
| **II.A. Alternatives Analysis**                               |      |
+---------------------------------------------------------------+------+
|                                                               |      |
+---------------------------------------------------------------+------+
| **Part II should be completed only for investments identified |      |
| as \"Planning\" or \"Full Acquisition,\" or \"Mixed           |      |
| Life-Cycle\" investments in response to Question 6 in Part I, |      |
| Section A above.**                                            |      |
+---------------------------------------------------------------+------+
| **In selecting the best capital asset, you should identify    |      |
| and consider at least three viable alternatives, in addition  |      |
| to the current baseline, i.e., the status quo. Use OMB        |      |
| Circular A- 94 for all investments, and the Clinger Cohen Act |      |
| of 1996 for IT investments, to determine the criteria you     |      |
| should use in your Benefit/Cost Analysis.**                   |      |
+---------------------------------------------------------------+------+
| **1. Did you conduct an alternatives analysis for this        | Yes  |
| project?**                                                    |      |
+---------------------------------------------------------------+------+
| **   a. If \"yes,\" provide the date the analysis was         | 5    |
| completed?**                                                  | /15/ |
|                                                               | 2006 |
+---------------------------------------------------------------+------+
| **   b. If \"no,\" what is the anticipated date this analysis |      |
| will be completed?**                                          |      |
+---------------------------------------------------------------+------+
| **   c. If no analysis is planned, please briefly explain     |      |
| why:**                                                        |      |
+---------------------------------------------------------------+------+
|                                                               |      |
+---------------------------------------------------------------+------+
|                                                               |      |
+---------------------------------------------------------------+------+
| **2. Alternative Analysis Results:**                          |      |
|                                                               |      |
| **Use the results of your alternatives analysis to complete   |      |
| the following table:**                                        |      |
+---------------------------------------------------------------+------+

  -------- --------------- ---------------- ----------------- ------------------
  **Send   **Alternative   **Description of **Risk Adjusted   **Risk Adjusted
  to OMB** Analyzed**      Alternative**    Lifecycle Costs   Lifecycle Benefits
                                            estimate**        estimate**

                                                              

                           \<Alternative                      
                           analysis data                      
                           redacted\>                         

                                                              

                                                              
  -------- --------------- ---------------- ----------------- ------------------

  -----------------------------------------------------------------------

  **3. Which alternative was selected by the Agency\'s
  Executive/Investment Committee and why was it chosen?**

  \<Redacted\>

  **4. What specific qualitative benefits will be realized?**

  \<Redacted\>
  -----------------------------------------------------------------------

  ----------------------------------- -----------------------------------
  **II.B. Risk Management**           

                                      

  **You should have performed a risk  
  assessment during the early         
  planning and initial concept phase  
  of this investment\'s life-cycle,   
  developed a risk-adjusted           
  life-cycle cost estimate and a plan 
  to eliminate, mitigate or manage    
  risk, and be actively managing risk 
  throughout the investment\'s        
  life-cycle.**                       

  **1. Does the investment have a     Yes
  Risk Management Plan?**             

  **   a. If \"yes,\" what is the     5/31/2006
  date of the plan?**                 

  **   b. Has the Risk Management     Yes
  Plan been significantly changed     
  since last year\'s submission to    
  OMB?**                              

  **c. If \"yes,\" describe any       
  significant changes:**              

  Since TranStats has been re-scoped  
  due to budget cut and priority      
  changes in RITA BTS strategic       
  goals, its Operation and            
  Maintenance tasks has focused on    
  scheduled releases of airline data  
  and its presentation while new      
  enhancement requirements have been  
  identified to ensure data quality   
  and data usability. The change      
  impacts the project most in FY2007  
  and FT2008. New risks have been     
  identified, the most prominent one  
  is its dependence on ARDIS. If      
  ARDIS could not perform because     
  funding or other issues, TranStats  
  would have to change its scope and  
  direction again. The probability    
  was medium but the impact would be  
  large. TranStats would drop all its 
  enhancement/development tasks and   
  reduce its O&M operations.          
  TranStats would have to be reduced  
  from a major project to a non-major 
  project \-- as the mission-critical 
  qualification is mainly related to  
  airline data. General risks         
  associated with the new             
  enhancements are addressed in the   
  Risk Management Plan, including new 
  security risks introduced by        
  interfacing the two systems         
  (TranStats and ARDIS). Fund has     
  been allocated for a new security   
  plan for ARDIS and an improved      
  security plan for TranStats to      
  mitigate the risks.                 

  **2. If there currently is no plan, 
  will a plan be developed?**         

  **   a. If \"yes,\" what is the      
  planned completion date?**          

  **   b. If \"no,\" what is the      
  strategy for managing the risks?**  

                                      

  **3. Briefly describe how           
  investment risks are reflected in   
  the life cycle cost estimate and    
  investment schedule:**              

  Costs required by risk mitigation   
  have been built in from the initial 
  planning or rebaslining in the      
  previous years. The TranStats       
  system has been developed with      
  scability and robustness, following 
  the industry best practice, for     
  example, separate and redundant     
  development, test, and production   
  environments and separate           
  application and data warehouse      
  servers. This explains the          
  relatively large initial investment 
  (8 million) and the ease and speed  
  of system adaption to changing      
  scope and goals. However, with      
  continuous budget cuts, the risk    
  may increase, especially that of    
  obsolete technology affecting the   
  performance of the system. We would 
  like to build in hardware and       
  software upgrade requirements in    
  the budget starting from FY2008 but 
  are unable to identify the funding  
  source. It will remain a risk we    
  have to accept for a couple of more 
  years.                              
  ----------------------------------- -----------------------------------

+-----------------------------------+-----------------------------------+
| **II.C. Cost and Schedule         |                                   |
| Performance**                     |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+
| **1. Does the earned value        | No                                |
| management system meet the        |                                   |
| criteria in ANSI/EIA              |                                   |
| Standard-748?**                   |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+
| **2. Answer the following         |                                   |
| questions about current           |                                   |
| cumulative cost and schedule      |                                   |
| performance. The numbers reported |                                   |
| below should reflect current      |                                   |
| actual information. (Per OMB      |                                   |
| requirements Cost/Schedule        |                                   |
| Performance information should    |                                   |
| include both Government and       |                                   |
| Contractor Costs):**              |                                   |
+-----------------------------------+-----------------------------------+
| **   a. What is the Planned Value | 5060.795000                       |
| (PV)?**                           |                                   |
+-----------------------------------+-----------------------------------+
| **   b. What is the Earned Value  | 5057.400000                       |
| (EV)?**                           |                                   |
+-----------------------------------+-----------------------------------+
| **   c. What is the actual cost   | 15070.000                         |
| of work performed (AC)?**         |                                   |
+-----------------------------------+-----------------------------------+
| **   d. What costs are included   | Contractor Only                   |
| in the reported Cost/Schedule     |                                   |
| Performance information           |                                   |
| (Government Only/Contractor       |                                   |
| Only/Both)?**                     |                                   |
+-----------------------------------+-----------------------------------+
| **   e. \"As of\" date:**         | 11/30/2006                        |
+-----------------------------------+-----------------------------------+
| **3. What is the calculated       | 0.999000                          |
| Schedule Performance Index (SPI=  |                                   |
| EV/PV)?**                         |                                   |
+-----------------------------------+-----------------------------------+
| **4. What is the schedule         | -11.554000                        |
| variance (SV = EV-PV)?**          |                                   |
+-----------------------------------+-----------------------------------+
| **5. What is the calculated Cost  | 1.000000                          |
| Performance Index (CPI =          |                                   |
| EV/AC)?**                         |                                   |
+-----------------------------------+-----------------------------------+
| **6. What is the cost variance    | -0.380000                         |
| (CV=EV-AC)?**                     |                                   |
+-----------------------------------+-----------------------------------+
| **7. Is the CV% or SV% greater    | No                                |
| than +/- 10%? (CV%= CV/EV x 100;  |                                   |
| SV%= SV/PV x 100)**               |                                   |
+-----------------------------------+-----------------------------------+
| **   a. If \"yes,\" was it the?** |                                   |
+-----------------------------------+-----------------------------------+
| **   b. If \"yes,\" explain the   |                                   |
| variance:**                       |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+
| **   c. If \"yes,\" what          |                                   |
| corrective actions are being      |                                   |
| taken?**                          |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+
| **   d. What is most current      | 129999.800000                     |
| \"Estimate at Completion\"?**     |                                   |
+-----------------------------------+-----------------------------------+
| **8. Have any significant changes | Yes                               |
| been made to the baseline during  |                                   |
| the past fiscal year?**           |                                   |
+-----------------------------------+-----------------------------------+
| **8. If \"yes,\" when was it      | Yes                               |
| approved by OMB?**                |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+
| **Comparison of Initial Baseline  |                                   |
| and Current Approved Baseline**   |                                   |
+-----------------------------------+-----------------------------------+
|   ------------- ----              |                                   |
| ----------- ------------ -------- |                                   |
| ------- -------------- ---------- |                                   |
| -- ------------- ------------ --- |                                   |
| --------- ---------- ------------ |                                   |
|   **Milestone   *                 |                                   |
| *Description   **Initial          |                                   |
|            **Current              |                                   |
|                                   |                                   |
| **Current               **Percent |                                   |
|   Number**      of                |                                   |
|  Milestone**  Baseline**          |                                   |
|           Baseline**              |                                   |
|                                 B |                                   |
| aseline                Complete** |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|          Variance**               |                                   |
|                                   |                                   |
|                                   |                                   |
|                         **Planned |                                   |
|     **Total Cost    **Completion  |                                   |
|                **Total            |                                   |
|          **Schedule   **Cost**    |                                   |
|                                   |                                   |
|                         Completio |                                   |
| n   (Estimated)**   Date**        |                                   |
|                Cost**             |                                   |
|          (# days)**               |                                   |
|                                   |                                   |
|                         Date**    |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                     **Planned**   |                                   |
|   **Actual**   **Planned**   **Ac |                                   |
| tual**                            |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|     \<Baseline data               |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|     redacted\>                    |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|                                   |                                   |
|   ------------- ----              |                                   |
| ----------- ------------ -------- |                                   |
| ------- -------------- ---------- |                                   |
| -- ------------- ------------ --- |                                   |
| --------- ---------- ------------ |                                   |
+-----------------------------------+-----------------------------------+
|                                   |                                   |
+-----------------------------------+-----------------------------------+