Data-Driven Vehicle Management at United States Air ...
Data-Driven Vehicle Management at United States Air Force Robert Uren Vehicle Fleet Manager/Analyst, USAF
Darrin Gaines Principal Consultant, Teradata #TDPARTNERS16
GEORGIA WORLD CONGRESS CENTER
Data-Driven Vehicle Management at USAF 1. USAF Vehicles Overview 2. VSCOS Organization 3. Data Services Analytical Environment 4. Vehicle View & Other Applications 5. Lessons Learned and Futures
2
USAF Vehicles The AF vehicle fleet supports the mission of the United States Air Force to fly, fight and win … in air, space and cyberspace. The numerous unique missions across the globe require a diverse vehicle fleet comprised of commercial, specialized, and military designed assets to accomplish these complex tasks.
3
USAF Vehicle Fleet • Nation’s 4th largest federal vehicle fleet Valued at more than $7B Over 90K authorizations Over 78K assets • Installations in US and numerous countries across the globe
4
USAF Vehicle Types • Air Force bases at home and abroad are like self-contained cities, requiring all types of vehicles, from sedans to snowplows to fire trucks to refueling and more.
• There are over 500 distinct vehicle types authorized for use • Can you think of a few unique vehicle types the AF uses? 5
USAF Vehicle Examples There are some interesting types of vehicles needed to achieve mission success. Here are some examples:
6
The M1089A Military Designed Wrecker
USAF Vehicle Examples The 60K Aircraft Cargo Loader:
7
USAF Vehicle Examples The U2 Chase Car:
8
VSCOS Introduction •
Air Force Vehicle Support Chain Operations Squadron (441st VSCOS)
•
Headquartered at Langley, Va.
•
Provides centralized vehicle accountability 11 major commands 307 installations (locations) 6,100 technicians $300M+ annual budget
9
VSCOS Charter Charted to execute enterprise vehicle fleet management and sustainment processes in support of logistics readiness operations, via Direct Liaison Authority (DIRLAUTH), with base level units, MAJCOM, and HAF staff. Consolidated activities are executed in the most efficient manner through continuous and deliberate reengineering of processes; while enhancing global management and situational awareness of the AF’s $7B vehicle fleet.
10
USAF Enterprise Fleet Management
11
USAF GCSS-AF Data Services Overview • • •
Growing Enterprise Data Warehouse since 2001 Teradata 6690, 4+2 node, 20+ TB user data Informatica PowerCenter 200+ Data Feeds (130+ inbound and 70 outbound) 250 Workflows; 3,600+ mappings; 1,050 BTEQ scripts
•
Business Objects
•
12
25,000 Users, 67 Universes 83,000 User Mission Reports 450 Standard Corporate Reports 98 SOA Web Services
Rich Internet Applications (RIA) 12,000+ Users, 26 Mission Applications LIMS-EV (Logistics, Installations, and Mission SupportEnterprise View) applications
Data Services Architecture
Enterprise Data Warehouse
13
LIMS-EV Vehicle View Application
Note: screenshots captured from development system 14
Vehicle View Application Core Components Planning Components • Authorization Validation (What are our requirements?) • Budget Planning (What are our expected annual costs?) • Prioritized Buy Model (Which vehicles should we buy and replace?) Operational Components • Leadership View (Are our vehicles currently mission capable?) • Fleet Posture (What is authorized and what is our inventory?) • Sustainment Costs (What are our ongoing costs?) • Fleet Performance (What are the sensor-based usage statistics?) • Transaction Request Tool (How can we best utilize current assets?) 15
Authorization Validation - Status •
Identifies requirements to be validated for each USAF base Domestic International
•
Requirements are by Vehicle Type Using Organization Use Code
•
16
Each requirement requires re-validation within 3 years
Authorization Validation - Workflow 1. Questions and rules are created for the purpose of determining requirements 2. Surveys are generated for each base 3. Base fleet managers answer survey questions 4. Rules-processing engine calculates vehicle requirement quantities based on survey answers 17
5. VSCOS compares requirements to current authorizations and approves or denies change
Authorization Validation – Results! This capability and methodology contributed to substantial efficiencies and savings Over the past 3 years we have: • • • • 18
Reviewed 50K authorizations Deleted over 5K vehicle requirements Right Sized over 2K authorizations Saved over $309M tax payer $$!
Budget Planning This view automates the Air Forces vehicle budgeting process for both • AF owned (sustainment) • Leased The model substantiates maintenance budget requirements across the Future Years Defense Program (FYDP) planning period. Uses vehicle equivalence (numeric value denoting technical/maintenance complexities of a vehicle), historical budget spending, and other factors to calculate a budget. 19
Budget Planning – Model Initialization •
•
Budget justification model for annual Sustainment Costs Lease Costs Sustainment factors Historical spending Costs-per-Equivalent Environment Variances Inflation and fleet size adjustments 20
•
Results captured for upcoming fiscal year and across Future Years Defense Program (FYDP) planning period
Prioritized Buy Model The Pri-Buy model implements USAF vehicle replacement strategy algorithms to efficiently plan future year purchases. 1. 2. 3. 4. 5. 21
Calculates each vehicle’s projected “end-of-life” Prioritizes each vehicle for replacement Allocates funds to vehicle types to balance fleet health Simulates funding adjustments through “what-if scenarios” Generates vehicle “Buy List” for the upcoming fiscal year
Pri-Buy Model - Calculate Vehicle End-of-Life Vehicle Year
Current Year
Replacement Eligible
$70,000 $60,000
Original Value
$50,000 $40,000 $30,000
Depreciated Value Retain 85% of value of prior year
Maint & Ops Cost
Calculated End-of-Life
$20,000 $10,000
Average Actual Yearly Costs
Estimated 3% annual increase
$0 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026
Calculated End-of-Life Year is when Maintenance & Operations costs exceed Depreciated Value 22
Pri-Buy Model – Vehicle Replacement Priority Each current asset of the same vehicle type is ranked in priority order for replacement, based on the following criteria: Use: Mobility support over daily use and wartime storage Year: Ascending – oldest first End of Life: Ascending – projected end of life year. Miles or Hours: Descending – cumulative miles or hours Sustainment Cost: Descending – higher maintenance cost before low Item Code: Unsuitable substitutes first, all others second Base Fleet Age: Descending – the average age of the fleet for all vehicle types at each base 23
Pri-Buy Model – Funds Allocation Funded Amount:
Vehicle Type A B C D
$1,000,000 Replacement Vacancies Standard % of Fair-Share Need Buy Authorized Eligible without without Cost per Need Cost Need of Funded Qty Qty "due-in" "due-in" Vehicle Cost Amount 170 32 7 569
18 5 3 95
6 0 1 24
24 5 4 119
$31,288 $750,912 26% $260,292 $16,616 $83,080 3% $28,798 $22,830 $91,320 3% $31,655 $16,467 $1,959,573 68% $679,255 $2,884,885 $1,000,000
8 1 1 41
Funding is by category of vehicle, e.g. “Passenger Carrying Vehicles”. Each vehicle type within a category receives its “fair share” of the funding, to help balance the health of the fleet. A vehicle is replacement-eligible when it is within a user-specified number of years (typically 3) of it’s calculated end-of-life and there is not a vehicle allocated (due-in) to replace it. After Buy Quantities are calculated, the specific vehicles to replace are assigned based on priority. Also, the vacancies to fill are assigned. A user-entered ratio (typically 2:1) determines how many vehicles to replace vs. vacancies to fill. 24
Prioritized Buy Model – What-if Scenarios Enables users to create what-if scenarios to see the effect budget adjustments would have on model results: • Budget plus-ups • Budget cuts
25
Prioritized Buy Model – Model Results •
Metrics: results depict vehicle quantity and/or dollars which were funded/unfunded for upcoming years
•
Details: results generate the vehicle “Buy List” for the upcoming fiscal year.
The model and EOL structure reduced the AF Vehicle Buy Requirements by $1.5M in it’s first year! 26
Leadership View •
High level view of current vehicle mission capabilities across Vehicle category Major command
•
Drill-Down capability
Key enabler to identify/source mission capable vehicles to support natural disasters (i.e. Hurricane Sandy) 27
Leadership View – Drill Down •
Drill down to Major Command Base Asset
•
View vehicles which are not mission capable (NMC) (NMCM) In Maintenance (NMCS) Awaiting Supplies
•
28
Estimated return-to-service dates
Fleet Posture
29
•
View the vehicle authorizations including: Vehicle details Vacancies
•
Users select from 68 attributes upon which to view, filter, and sort
Sustainment Costs •
•
30
Current and historical vehicle sustainment costs Displays Computed Maintenance performance metrics Detailed maintenance actions
Fleet Performance • Provides the Air Force the ability to maintain the fleet using Conditioned Base Maintenance (CBM) methodology • Facilitates maintainability and reliability analytics • Data analyzed to review/compare current preventive maintenance measures and policy for efficiency opportunities • Benchmark and best practices opportunities Use data to compare AF with industry standards to help establish a baseline of new preventive maintenance measures 31
Fleet Performance - Typical Vehicle Install OBD-II connection to vehicle onboard computer
Filler Neck Ring
Acronyms: OBD – On-Board Diagnostics RFID – Radio Frequency
Automotive Information Module, 2nd Generation (RF Tag) 32
RFID Interface Module
Fleet Performance – Data Details Grid 26 attributes captured during time of fueling are available for analysis including: • Maximum speed • Gallons consumed • Engine run time • Engine idle time • Oil level • Diagnostic trouble codes • Etc. 33
Transaction Request Tool
• One location for customer requests • Provides workflow & status tracker • Built-in intelligence to support fleet management decisions, e.g. determine disposition for excess assets, broken assets, and redistribution 34
Transaction Request Tool • Gives fleet managers redistribution candidate list •
Teradata Geospatial functionality used to calculate distance between bases. (ST_SPHERICALDISTANCE: calculates distance in meters between two latitude/longitude points on earth)
35
Awards and Recognition • • •
• • • • • • 36
2016 Teradata EPIC Operational Excellence Award Finalist 2016 AF Group Team Excellence Award - Data Migration to DPAS Recognized by Government Fleet Magazine as Top 100 Best Fleets out of 38K--out ranked 99%! Ranked 46th in 2013, 56th in 2014, and 31st in 2015 Green Fleet award winner; 20th in 2014, now 11th best in Nation 12 A4/7 annual/quarterly award winners in last 24 months 7 A4L award winner in last 24 months 1 Top 15 Federal Fleet Manager of Year award winner in last 24 months Note of appreciation from CSAF for transformation efforts GSA accolades to POTUS on AF leading the way in fleet management
Vehicle View Impact Summary • • • • • • •
Sole source and means to perform daily AF fleet management functions Supports operational, tactical, and strategic operations Enables duties at over 300 sites, multiple MAJCOMS and the Enterprise Facilitated seamless transition to centralized management saving $7.6 Drove recognition by multiple Federal and Green fleet awards Selected as corporate approved solution in defending the Vehicle Buy Vehicle View, drove a 30-40 year advancement in technology
Challenging to further quantify into dollars, but saved numerous man hours for data calls, labor intensive daily fleet management decisions, training community on the use of multiple legacy systems and a multitude of manual processes 37
Lessons Learned • Develop quick proof-of-concept prototypes to help convey requirements • Perform Interactive demos during design and build phases • Utilize Teradata tools for verification and validation during build phase • Conduct three-to-four day in-person Technical Interchange Meetings (TIMs) every 6 weeks 38
Summary and Future Plans As stewards to the hard earned tax payer dollars, VSCOS is proud of the improved fleet management decisions and cost savings. We look forward to future capabilities: •
•
39
In Progress: • An Acquisition Agent/Item Manager View • Automated Ground Fuel Sales Data Feed • Tracking Vehicle add-on equipment • Data Quality reports Plans • Mobile Apps • Conditioned Base Maintenance Dashboard
Thank You Questions/Comments Email: [email protected] [email protected]
Rate This Session # 602 with the PARTNERS Mobile App
Remember To Share Your Virtual Passes
40
Darrin Gaines Principal Consultant, Teradata #TDPARTNERS16
GEORGIA WORLD CONGRESS CENTER
Data-Driven Vehicle Management at USAF 1. USAF Vehicles Overview 2. VSCOS Organization 3. Data Services Analytical Environment 4. Vehicle View & Other Applications 5. Lessons Learned and Futures
2
USAF Vehicles The AF vehicle fleet supports the mission of the United States Air Force to fly, fight and win … in air, space and cyberspace. The numerous unique missions across the globe require a diverse vehicle fleet comprised of commercial, specialized, and military designed assets to accomplish these complex tasks.
3
USAF Vehicle Fleet • Nation’s 4th largest federal vehicle fleet Valued at more than $7B Over 90K authorizations Over 78K assets • Installations in US and numerous countries across the globe
4
USAF Vehicle Types • Air Force bases at home and abroad are like self-contained cities, requiring all types of vehicles, from sedans to snowplows to fire trucks to refueling and more.
• There are over 500 distinct vehicle types authorized for use • Can you think of a few unique vehicle types the AF uses? 5
USAF Vehicle Examples There are some interesting types of vehicles needed to achieve mission success. Here are some examples:
6
The M1089A Military Designed Wrecker
USAF Vehicle Examples The 60K Aircraft Cargo Loader:
7
USAF Vehicle Examples The U2 Chase Car:
8
VSCOS Introduction •
Air Force Vehicle Support Chain Operations Squadron (441st VSCOS)
•
Headquartered at Langley, Va.
•
Provides centralized vehicle accountability 11 major commands 307 installations (locations) 6,100 technicians $300M+ annual budget
9
VSCOS Charter Charted to execute enterprise vehicle fleet management and sustainment processes in support of logistics readiness operations, via Direct Liaison Authority (DIRLAUTH), with base level units, MAJCOM, and HAF staff. Consolidated activities are executed in the most efficient manner through continuous and deliberate reengineering of processes; while enhancing global management and situational awareness of the AF’s $7B vehicle fleet.
10
USAF Enterprise Fleet Management
11
USAF GCSS-AF Data Services Overview • • •
Growing Enterprise Data Warehouse since 2001 Teradata 6690, 4+2 node, 20+ TB user data Informatica PowerCenter 200+ Data Feeds (130+ inbound and 70 outbound) 250 Workflows; 3,600+ mappings; 1,050 BTEQ scripts
•
Business Objects
•
12
25,000 Users, 67 Universes 83,000 User Mission Reports 450 Standard Corporate Reports 98 SOA Web Services
Rich Internet Applications (RIA) 12,000+ Users, 26 Mission Applications LIMS-EV (Logistics, Installations, and Mission SupportEnterprise View) applications
Data Services Architecture
Enterprise Data Warehouse
13
LIMS-EV Vehicle View Application
Note: screenshots captured from development system 14
Vehicle View Application Core Components Planning Components • Authorization Validation (What are our requirements?) • Budget Planning (What are our expected annual costs?) • Prioritized Buy Model (Which vehicles should we buy and replace?) Operational Components • Leadership View (Are our vehicles currently mission capable?) • Fleet Posture (What is authorized and what is our inventory?) • Sustainment Costs (What are our ongoing costs?) • Fleet Performance (What are the sensor-based usage statistics?) • Transaction Request Tool (How can we best utilize current assets?) 15
Authorization Validation - Status •
Identifies requirements to be validated for each USAF base Domestic International
•
Requirements are by Vehicle Type Using Organization Use Code
•
16
Each requirement requires re-validation within 3 years
Authorization Validation - Workflow 1. Questions and rules are created for the purpose of determining requirements 2. Surveys are generated for each base 3. Base fleet managers answer survey questions 4. Rules-processing engine calculates vehicle requirement quantities based on survey answers 17
5. VSCOS compares requirements to current authorizations and approves or denies change
Authorization Validation – Results! This capability and methodology contributed to substantial efficiencies and savings Over the past 3 years we have: • • • • 18
Reviewed 50K authorizations Deleted over 5K vehicle requirements Right Sized over 2K authorizations Saved over $309M tax payer $$!
Budget Planning This view automates the Air Forces vehicle budgeting process for both • AF owned (sustainment) • Leased The model substantiates maintenance budget requirements across the Future Years Defense Program (FYDP) planning period. Uses vehicle equivalence (numeric value denoting technical/maintenance complexities of a vehicle), historical budget spending, and other factors to calculate a budget. 19
Budget Planning – Model Initialization •
•
Budget justification model for annual Sustainment Costs Lease Costs Sustainment factors Historical spending Costs-per-Equivalent Environment Variances Inflation and fleet size adjustments 20
•
Results captured for upcoming fiscal year and across Future Years Defense Program (FYDP) planning period
Prioritized Buy Model The Pri-Buy model implements USAF vehicle replacement strategy algorithms to efficiently plan future year purchases. 1. 2. 3. 4. 5. 21
Calculates each vehicle’s projected “end-of-life” Prioritizes each vehicle for replacement Allocates funds to vehicle types to balance fleet health Simulates funding adjustments through “what-if scenarios” Generates vehicle “Buy List” for the upcoming fiscal year
Pri-Buy Model - Calculate Vehicle End-of-Life Vehicle Year
Current Year
Replacement Eligible
$70,000 $60,000
Original Value
$50,000 $40,000 $30,000
Depreciated Value Retain 85% of value of prior year
Maint & Ops Cost
Calculated End-of-Life
$20,000 $10,000
Average Actual Yearly Costs
Estimated 3% annual increase
$0 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026
Calculated End-of-Life Year is when Maintenance & Operations costs exceed Depreciated Value 22
Pri-Buy Model – Vehicle Replacement Priority Each current asset of the same vehicle type is ranked in priority order for replacement, based on the following criteria: Use: Mobility support over daily use and wartime storage Year: Ascending – oldest first End of Life: Ascending – projected end of life year. Miles or Hours: Descending – cumulative miles or hours Sustainment Cost: Descending – higher maintenance cost before low Item Code: Unsuitable substitutes first, all others second Base Fleet Age: Descending – the average age of the fleet for all vehicle types at each base 23
Pri-Buy Model – Funds Allocation Funded Amount:
Vehicle Type A B C D
$1,000,000 Replacement Vacancies Standard % of Fair-Share Need Buy Authorized Eligible without without Cost per Need Cost Need of Funded Qty Qty "due-in" "due-in" Vehicle Cost Amount 170 32 7 569
18 5 3 95
6 0 1 24
24 5 4 119
$31,288 $750,912 26% $260,292 $16,616 $83,080 3% $28,798 $22,830 $91,320 3% $31,655 $16,467 $1,959,573 68% $679,255 $2,884,885 $1,000,000
8 1 1 41
Funding is by category of vehicle, e.g. “Passenger Carrying Vehicles”. Each vehicle type within a category receives its “fair share” of the funding, to help balance the health of the fleet. A vehicle is replacement-eligible when it is within a user-specified number of years (typically 3) of it’s calculated end-of-life and there is not a vehicle allocated (due-in) to replace it. After Buy Quantities are calculated, the specific vehicles to replace are assigned based on priority. Also, the vacancies to fill are assigned. A user-entered ratio (typically 2:1) determines how many vehicles to replace vs. vacancies to fill. 24
Prioritized Buy Model – What-if Scenarios Enables users to create what-if scenarios to see the effect budget adjustments would have on model results: • Budget plus-ups • Budget cuts
25
Prioritized Buy Model – Model Results •
Metrics: results depict vehicle quantity and/or dollars which were funded/unfunded for upcoming years
•
Details: results generate the vehicle “Buy List” for the upcoming fiscal year.
The model and EOL structure reduced the AF Vehicle Buy Requirements by $1.5M in it’s first year! 26
Leadership View •
High level view of current vehicle mission capabilities across Vehicle category Major command
•
Drill-Down capability
Key enabler to identify/source mission capable vehicles to support natural disasters (i.e. Hurricane Sandy) 27
Leadership View – Drill Down •
Drill down to Major Command Base Asset
•
View vehicles which are not mission capable (NMC) (NMCM) In Maintenance (NMCS) Awaiting Supplies
•
28
Estimated return-to-service dates
Fleet Posture
29
•
View the vehicle authorizations including: Vehicle details Vacancies
•
Users select from 68 attributes upon which to view, filter, and sort
Sustainment Costs •
•
30
Current and historical vehicle sustainment costs Displays Computed Maintenance performance metrics Detailed maintenance actions
Fleet Performance • Provides the Air Force the ability to maintain the fleet using Conditioned Base Maintenance (CBM) methodology • Facilitates maintainability and reliability analytics • Data analyzed to review/compare current preventive maintenance measures and policy for efficiency opportunities • Benchmark and best practices opportunities Use data to compare AF with industry standards to help establish a baseline of new preventive maintenance measures 31
Fleet Performance - Typical Vehicle Install OBD-II connection to vehicle onboard computer
Filler Neck Ring
Acronyms: OBD – On-Board Diagnostics RFID – Radio Frequency
Automotive Information Module, 2nd Generation (RF Tag) 32
RFID Interface Module
Fleet Performance – Data Details Grid 26 attributes captured during time of fueling are available for analysis including: • Maximum speed • Gallons consumed • Engine run time • Engine idle time • Oil level • Diagnostic trouble codes • Etc. 33
Transaction Request Tool
• One location for customer requests • Provides workflow & status tracker • Built-in intelligence to support fleet management decisions, e.g. determine disposition for excess assets, broken assets, and redistribution 34
Transaction Request Tool • Gives fleet managers redistribution candidate list •
Teradata Geospatial functionality used to calculate distance between bases. (ST_SPHERICALDISTANCE: calculates distance in meters between two latitude/longitude points on earth)
35
Awards and Recognition • • •
• • • • • • 36
2016 Teradata EPIC Operational Excellence Award Finalist 2016 AF Group Team Excellence Award - Data Migration to DPAS Recognized by Government Fleet Magazine as Top 100 Best Fleets out of 38K--out ranked 99%! Ranked 46th in 2013, 56th in 2014, and 31st in 2015 Green Fleet award winner; 20th in 2014, now 11th best in Nation 12 A4/7 annual/quarterly award winners in last 24 months 7 A4L award winner in last 24 months 1 Top 15 Federal Fleet Manager of Year award winner in last 24 months Note of appreciation from CSAF for transformation efforts GSA accolades to POTUS on AF leading the way in fleet management
Vehicle View Impact Summary • • • • • • •
Sole source and means to perform daily AF fleet management functions Supports operational, tactical, and strategic operations Enables duties at over 300 sites, multiple MAJCOMS and the Enterprise Facilitated seamless transition to centralized management saving $7.6 Drove recognition by multiple Federal and Green fleet awards Selected as corporate approved solution in defending the Vehicle Buy Vehicle View, drove a 30-40 year advancement in technology
Challenging to further quantify into dollars, but saved numerous man hours for data calls, labor intensive daily fleet management decisions, training community on the use of multiple legacy systems and a multitude of manual processes 37
Lessons Learned • Develop quick proof-of-concept prototypes to help convey requirements • Perform Interactive demos during design and build phases • Utilize Teradata tools for verification and validation during build phase • Conduct three-to-four day in-person Technical Interchange Meetings (TIMs) every 6 weeks 38
Summary and Future Plans As stewards to the hard earned tax payer dollars, VSCOS is proud of the improved fleet management decisions and cost savings. We look forward to future capabilities: •
•
39
In Progress: • An Acquisition Agent/Item Manager View • Automated Ground Fuel Sales Data Feed • Tracking Vehicle add-on equipment • Data Quality reports Plans • Mobile Apps • Conditioned Base Maintenance Dashboard
Thank You Questions/Comments Email: [email protected] [email protected]
Rate This Session # 602 with the PARTNERS Mobile App
Remember To Share Your Virtual Passes
40
