SABLE Model Systematic Approach to Better LongRange Estimating

1
SABLE Model(Systematic Approach to Better
Long-Range Estimating)

• Capabilities Briefing

2
What is the SABLE Model

• Estimates aircraft peacetime operating and
  support (OS) costs for typical flying units.
• Utilizes standard Air Force cost factors and
  algorithms.
• Flexible and easy to use interface.
• Fully Customizable for complete user control over
  estimating cost factors and parameters.
• Standard cost element reporting and Ad-hoc
  reporting capability

3
Computer Requirements

• Pentium based PC 100MZ, 32 MB RAM, 20 MB of free
  HD
• MS Windows 95/NT

4
SABLE model Inputs
Program Factors PAA Qty TAI Qty Crew
Ratios Flying Hours/PAA Manpower
Factors Officers/Enlisted Civilians PCS
Separation Logistics Factors Fuel/FH Maint.
Support/FH CLS/FH Depot Maint./FH etc. Inflati
on Factors EE
Fuel Factors ACC,AETC,AFMC,etc. Cost /
Gal. Miscellaneous Factors Training, Mil/Civ
Pay Turnover Costs PCS, Non-Pay Base ops,
Munitions/FH Flyaway Cost Additional
Factors User Defined Costs by FH, PAA,
TAI Military Cost Civilian Cost Military
Personnel Civilian Personnel Pass through
5
SABLE Model Outputs
Direct Costs Aviation Fuel Engine
DPEM Aircraft DPEM Consumable Supplies Depot
Level Repairs Replacement GSE Aircraft
Modifications Military Pay Civilian
Pay Contractor Logistics Supt. Misc.
Contracts IMPACT CARD Packaged POL Ground
Fuel Indirect Costs Installation Support
Non-Pay PCS (Military) Training
Munitions Medical Non-Pay Training
Summarized by MDS BOS Component MAJCOM PEC
SAG EEIC Appropriation
Cost Type Then Year () Budget Year Budget
Year 1 Budget Year 2
Years Budget Year Budget Year 1 Budget
Year 7
6
Model Capabilities

• Create, Edit, Retrieve, Delete, Import, Export
  various Scenarios
• Create, Edit, Retrieve, Delete, Import, Export
  user defined MDSs
• Full user control of all factors and costs
  utilized in calculating a given scenario
• Exporting and Importing of selected SABLE Data
  Tables to Excel
• Exporting and Importing of SABLE Data Tables to a
  new Access Database
• Full on-line user Help system
• Standard reporting by MDS or combined MDS totals
• Pivot Table analysis reporting capability
• Exporting of Scenario results to various other
  formats (excel, Lotus, Paradox, Foxpro, dBase,
  Btrieve, Access)
• Easy to use Graphical User Interface
• Form or Menu Bar access to most functions
• Full Runtime version or Access 8.0 install
  programs
• Full user documentation and OPR documentation

7
SABLE Main Menu Form

• Provides the main navigation to create and edit
  scenarios
• Provides the path for the user to edit the SABLE
  data

Also Displays Current Time/Date Base Year of
Data Current Loaded Scenario Data
Description Location of Data File
8
SABLE Data Tables Edit Menu

• Provides the main navigation menu for the user to
  alter the SABLE Data factors tables
• Provides the user to systematically change the
  base year of all SABLE factors at once.

WARNING This menu should only be used by the
SABLE OPR and power users of the SABLE
model. This menu is password protected to
prevent novice users the ability to alter SABLE
Data.
9
SABLE Data Import / Export Menu

• Provides the user the main interface to Export or
  Import various data elements of the SABLE model

Export / Imports User Defined MDSs SABLE Tables
to Excel User Scenarios SABLE Tables to Access DB
10
Creating a Scenario Screen

• Select Component Wing
• Active
• National Guard
• Reserves
• Select M/D/S (Aircraft)
• Select Wing Unit
• Select Factors
• Composite Log Factors
• Composite Pay Factors
• Add Addl Base Ops Support Cost
• Select Fuel Factors
• MAJCOM
• Composite
• Select Multiple M/D/S per Scenario

11
Editing Scenario Factors

• Edit and M/D/S Factor for Current Scenario
• Program Factors
• Manpower Factors
• Logistics Factors
• Inflation Factors
• Miscellaneous
• Other Misc. Factors
• Fuel Factors
• Additional Costs
• By FY 1 - 8

12
Process Scenario

• Calculate the Scenario for the following options
• Then Year
• Base Year
• Base Year 1
• Base Year 2

13
View Results

• Preview / Print Reports
• MDS Summary
• Consolidation MDS Summary
• Appropriation Summary
• Appropriation by Cost Element
• Appropriation by MDS by Cost Element
• PEC by Appropriation by MAJCOM
• Select Individual MDS or all Combined
• Export Scenario
• Save Scenario
• View Pivot Table Summary

14
Reports
15
Pivot Table Results

• Ad-Hoc Reporting capabilities
• Flexible cross tabulation summaries
• Easy to use interface
• Requires Office 97 and Excel

16
Key Benefits

• Universal cost tool for all Air Force units
• Proven and tested cost application
• Flexible cost tool for all users
• Easy to use GUI
• On-Line Help System and users manual

17
Next Steps

• Download SABLE from
• http\Usairforce.com\??????
• Start generating your cost estimates