1 / 30

Air Force Total Ownership Cost AFTOC Management Information System AFTOC making access and analysis of your data e

10/12/2011. 2. Overview. Why is there an AFTOC?What does AFTOC bring to the table?What kinds of information can you findSome DemographicsWhere is AFTOC going?Summary. 10/12/2011. 3. Why is There an AFTOC Purpose. Provide routine, timely visibility into all AF costsIncludes all major Air Force systemsIncludes all appropriations and Major CommandsCrosses cost - logistics data boundariesProvides permanent archive of cost and logistics dataSatisfy Congressional O

Ava
Download Presentation

Air Force Total Ownership Cost AFTOC Management Information System AFTOC making access and analysis of your data e

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Air Force Total Ownership Cost (AFTOC) Management Information System “AFTOC … making access and analysis of your data easier” Presentation to: SCEA Conference Scott Belford 12 June 2002

    2. 10/13/2011 2 This briefing is to present a brief history of AFTOC … why it came into being … where is it now … and where is it going.This briefing is to present a brief history of AFTOC … why it came into being … where is it now … and where is it going.

    3. 10/13/2011 3 Why is There an AFTOC Purpose Provide routine, timely visibility into all AF costs Includes all major Air Force systems Includes all appropriations and Major Commands Crosses cost - logistics data boundaries Provides permanent archive of cost and logistics data Satisfy Congressional O&S reporting requirements Primary tool chosen by leadership to assist in the analysis and management of Weapon System and Infrastructure Costs This is what AFTOC was chartered to do. Its unclassified nature limits the full implementation but we are working on that.This is what AFTOC was chartered to do. Its unclassified nature limits the full implementation but we are working on that.

    4. 10/13/2011 4

    5. 10/13/2011 5 What Does AFTOC Bring to the Table Scope – Today This chart shows the size and scope of AFTOC and to introduce new additions. Previously AFTOC contained only engine commodity data in aggregate, now: Commodities data can be viewed by MAJCOM Expanded cost coverage (manpower, spares, DPEM, etc)of engines For each MD in the CAIG format, engines can be analyzed separately Engine TMSs now have their own CAIG format We now will be able to get better insight into total commodities cost with the inclusion of the D035K feed We will be to provide mod detail in the Appropriations format by including summary information from the IDOCS database.This chart shows the size and scope of AFTOC and to introduce new additions. Previously AFTOC contained only engine commodity data in aggregate, now: Commodities data can be viewed by MAJCOM Expanded cost coverage (manpower, spares, DPEM, etc)of engines For each MD in the CAIG format, engines can be analyzed separately Engine TMSs now have their own CAIG format We now will be able to get better insight into total commodities cost with the inclusion of the D035K feed We will be to provide mod detail in the Appropriations format by including summary information from the IDOCS database.

    6. 10/13/2011 6 What Does AFTOC Bring to the Table Data Sources This slide depicts the Data Sources of AFTOC. Historically these were stove pipe systems in that they did not talk or interface with each other. What AFTOC has done is to collect all of this data and store it in a common data warehouse at Hill AFB. The advantage is that it allows data to be displayed together in a meaningful manner. For Financial and Mod Data we use: Command On-line Accounting and Reporting System (COARS) Automated Budget Interactive Data Environment System (ABIDES) Investment budget DOCumentation System (IDOCS) For Flying Hours, Inventory, and Performance data we use: Reliability and Maintainability Information System (REMIS) For Personnel data we use: Military Personnel Data System (E300Z extract) Automated Budget Interactive Data Environment System (ABIDES) AFI 65-503 For Logistics data we use: Combat Ammunition System (CAS) Fuels Automated Management System (FAMS) Standard Base Supply System (SBSS) – we get over 200 daily feeds from bases world-wide D035K to pick up depot supply transactionsThis slide depicts the Data Sources of AFTOC. Historically these were stove pipe systems in that they did not talk or interface with each other. What AFTOC has done is to collect all of this data and store it in a common data warehouse at Hill AFB. The advantage is that it allows data to be displayed together in a meaningful manner. For Financial and Mod Data we use: Command On-line Accounting and Reporting System (COARS) Automated Budget Interactive Data Environment System (ABIDES) Investment budget DOCumentation System (IDOCS) For Flying Hours, Inventory, and Performance data we use: Reliability and Maintainability Information System (REMIS) For Personnel data we use: Military Personnel Data System (E300Z extract) Automated Budget Interactive Data Environment System (ABIDES) AFI 65-503 For Logistics data we use: Combat Ammunition System (CAS) Fuels Automated Management System (FAMS) Standard Base Supply System (SBSS) – we get over 200 daily feeds from bases world-wide D035K to pick up depot supply transactions

    7. 10/13/2011 7 What AFTOC Brings to the Table Integration AFTOC Integrates Data to Produce Information Total Ownership Cost Focus is on total cost information on AF systems and functions Integrates cost information from multiple PEs to produce “total” cost profiles Aggregates infrastructure costs by function (e.g., base supply) Quarterly Updates Tool for Mid to Long Range Analysis: Logistics - Cost Analysis MSD/GSD usage/cost history Price analysis Monthly updates Where source data is unclear, business rules used to assign or allocate costs to most logical “bucket” AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    8. 10/13/2011 8 This is what I are talking about when I say AFTOC takes data and integrates it to produce information. This is a simplified example of the process used to come up with our CAIG product.This is what I are talking about when I say AFTOC takes data and integrates it to produce information. This is a simplified example of the process used to come up with our CAIG product.

    9. 10/13/2011 9 What AFTOC Brings to the Table Data Outputs This chart represents the various outputs of AFTOC. Standard products are canned reports which can be displayed both as HTML or Excel. This product is for fast answers to simple questions and are great for managers. We also have data cubes for most of the data that can be accessed with an online analytical processing tool which is really an Excel Pivot table. This tool is for analysts who need to get into the details of the data and who need to make comparisons over time or organizations The Account Tool is a brand new application that allows users to access supply transactions in something we call the Logistics Distribution Table. This table captures millions of pieces of information about the parts our systems use. Users can also request special data requests that would have to have a customized query built to obtain the product. The metadata is data about data or in other words help screens about the data. Finally, we do have the source data available upon request but we caution users that this is the raw data that came in from the feeder systems and has not been processed or cleaned up using various business rules.This chart represents the various outputs of AFTOC. Standard products are canned reports which can be displayed both as HTML or Excel. This product is for fast answers to simple questions and are great for managers. We also have data cubes for most of the data that can be accessed with an online analytical processing tool which is really an Excel Pivot table. This tool is for analysts who need to get into the details of the data and who need to make comparisons over time or organizations The Account Tool is a brand new application that allows users to access supply transactions in something we call the Logistics Distribution Table. This table captures millions of pieces of information about the parts our systems use. Users can also request special data requests that would have to have a customized query built to obtain the product. The metadata is data about data or in other words help screens about the data. Finally, we do have the source data available upon request but we caution users that this is the raw data that came in from the feeder systems and has not been processed or cleaned up using various business rules.

    10. 10/13/2011 10 What AFTOC Brings to the Table (https://aftoc.af.hill.mil) Connection

    11. 10/13/2011 11 What AFTOC Brings to the Table AFTOC Products

    12. 10/13/2011 12 What AFTOC Brings to the Table Kinds of Information Cost BA, Obligations, Current year outlays Where spent MAJCOM Base RC/CC How Spent Appropriation PE EEIC BPAC Supply Issues and Serviceable Turn-ins by NSN Munitions Expenditures NSN Price Changes AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    13. 10/13/2011 13 What AFTOC Brings to the Table Kinds of Information Non-Cost TAI, PAA, Avg Inventory Flying Hours (working on operating hours for non-AC) MC Rates TNMC-S, NMC-M, CANNs Personnel Counts Location Squadron Grade AFSC, FAC Issue, Turn-in, NRTS Counts by NSN AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    14. 10/13/2011 14 Some Demographics AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    15. 10/13/2011 15

    16. 10/13/2011 16 Who Uses AFTOC? MOST ACTIVE ORGANIZATIONS AF.MIL 875 LOCKHEED-MARTIN 189 BOEING 147 GENERAL ELECTRIC 38 NORTHRUP GRUMMAN 34 SAIC 26 SPRINT COMMUNICATIONS 24 DFI INTERNATIONAL 13 OSD 17 CBO 12 RAND 11 This shows the most active organizations to use AFTOC. The Air Force is of course the number one organization but it is interesting to see that Manufacturing Contractors are also top users.This shows the most active organizations to use AFTOC. The Air Force is of course the number one organization but it is interesting to see that Manufacturing Contractors are also top users.

    17. 10/13/2011 17 Who Uses AFTOC? TOP AF VISITORS WPAFB 304 HQ.AF.MIL (other than team) 137 Tinker AFB 112 AFSAA 67 Peterson AFB 15 Hill AFB (other than team) 14 Patrick AFB 22 Hurlburt Field 12 Los Angeles AFB 12 Robins AFB 12 This breaks out the total Air Force visitors for Jan – March 02. Wright Patterson by far is the leading AF organization. The reason for this is that the Aircraft SPOs, HQ AFMC, and the AF Research Laboratory are located there.This breaks out the total Air Force visitors for Jan – March 02. Wright Patterson by far is the leading AF organization. The reason for this is that the Aircraft SPOs, HQ AFMC, and the AF Research Laboratory are located there.

    18. 10/13/2011 18 How is AFTOC Used Today Outside the Air Force GAO Appropriations Format Analysis of overall O&S costs CBO Appropriations Format Analysis of weapon system O&S costs OSD PA&E CAIG and Indirect Formats Infrastructure Analysis AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    19. 10/13/2011 19 How is AFTOC Used Today Studies & Research Air Force Audit Agency ACCOUNT Tool (Logistics Database) To analyze transactions to identify areas requiring further research. Georgia State University – WR-ALC ACCOUNT Tool (Logistics Database) Avionics research RAND-SAF/FMC Commodities Format Aging Aircraft and internal RAND studies Composite O&S Factors AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    20. 10/13/2011 20 How is AFTOC Used Today Studies & Research Air Force Materials Lab Commodities Format To study aging aircraft to identify high cost drivers LMI Commodities Format Alternative CPFH methods Boeing CAIG and Commodities Formats Study life cycle costs for Boeing aircraft, compare aircraft, do trend analysis for avionics and engines, model validation General Electric CAIG Format To review cost per engine flight hour data for GE programs and apply processes to reduce TOC. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    21. 10/13/2011 21 How is AFTOC Used Today Cost Estimating AFCAA/FMS CAIG Format To reconcile AFCAA estimates with Program Office estimates AFCAA/FMF CAIG Format Analogies for F-22 cost estimates AFCAA/FMA CAIG Format JPATS Estimate AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    22. 10/13/2011 22 How is AFTOC Used Today

    23. 10/13/2011 23 How is AFTOC Used Today

    24. 10/13/2011 24 How is AFTOC Used Today AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    25. 10/13/2011 25 How is AFTOC Used Today AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    26. 10/13/2011 26 AFTOC Initiatives AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    27. 10/13/2011 27 Where is AFTOC Going? Complete back-end reengineering (30 Sep 02) Complete front-end reengineering (1 Jan 03) Complete SIPRNET study (30 Jun 02) If approved, stand-up classified version (Nov 03) Complete IDOCS- Procurment Mods (30 Sep 02) IDOCS – RDT&E (28 Feb 03) Capture More Historical Costs (31 Jan 03) Training Munitions in CAIG (30 Aug 02) IT Infrasturcture Costs (Jun 03) AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    28. 10/13/2011 28 Where is AFTOC Going? (cont) Review Allocation Schemes (Jan 03) Review Direct vs Indirect partition (Jun 03) WUC-NSN (30 Sep 02 – I hope!) Constant dollar capability in COGNOS (Mar 03) CLS Review (Dec 02) On-Line Tutorial (Jun 03) Add AFSOC (Feb 03) Price Change Table (Nov 02) AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers. AFTOC is not an accounting system … it is a Decision Support Tool. It takes data from multiple sources and converts it into usable information for a variety of customers. Customer demand has pushed AFTOC in two directions at once. On the one hand, AFTOC takes financial data to produce total cost profiles of AF systems and infrastructure. On the other hand, AFTOC takes logistics information, currently supply data, and relates it to cost to help identify important cost drivers.

    29. 10/13/2011 29 Need Help?

    30. 10/13/2011 30 Summary Provides one-stop shopping for historical, current year, and FYDP cost information Most comprehensive data on individual weapon systems available Uses latest technology to make data easily accessible to users via Internet The AFTOC team stands ready to help you in any way that we can. If you have a special data request or need help in using AFTOC, don’t hesitate to ask us.

More Related