Billet Analysis Tool BAT Development

1
Billet Analysis Tool (BAT) Development
Presentation for 2008 Workforce Conference
Steven W. Belcher
2
Suite of BAT Tools
How will Force Structure changes affect Fleet
manpower requirements?
How will Force Structure changes affect Shore
manpower requirements?
What will Navys manpower requirements be in 10-,
15-, 20-, 30-years?
BAT Shore/ Support Module

• Original BAT

Enhanced BAT
Development complete integrating into BAT
Under development
Operational
3
In the Beginning .

• POM-08 Build Navy expressed a need to be able
  quickly produce manpower estimates for excursions
  for Total Force planning within and beyond the
  FYDP
• Rapidly calculate manpower requirements for
  different force structure scenarios (to include
  costing data) within and beyond the FYDP
• Provide Community Management drill-down
  capability (view requirements by
  rating/designator and paygrade)
• CNA developed Billet Analysis Tool

4
Original BAT

• Microsoft Access desktop application (no NMCI
  issues)
• Enables manpower analysts to quickly compile,
  filter, and analyze TFMMS manpower requirement
  data
• Billets authorizations requirements
• Manpower costs based on composite rates
• Contains future UICs (CVN-21, DD(X)) to allow
  analysis beyond the FYDP

• Sorts and displays output by
• Appropriation MPN, RPN, Civ
• Manpower type AC, FTS, SELRES, Civ
• Rating/EMC/designator and paygrade
• Enterprise
• IGCA functions
• Tool managed by WBB
• TFMMS data updated monthly

5
How BAT Works
Step 1
Step 2
Step 3
Saved scenario
Compute manpower requirements and costs
Build output reports
Define scenario
Output reports
Excel
Pay tables
TFMMS Billet data
Labels
TFMMS Activity data
Data tables
6
Build Scenario Module
7
But What About Shore Manning

• Rising manpower costs declining endstrength
  authorizations have elevated importance of total
  manpower requirements and costs in assessing
  force structure alternatives
• Current assessments look only at manpower
  requirements of force structure units
• E.g., if the Navy decommissions four destroyers,
  billets on the ships go away
• Current BAT supports this analysis
• Need to assess the manpower effects of force
  structure changes within the shore infrastructure
• E.g., if the Navy decommissions four destroyers,
  where should shore manpower requirements decrease
  and by how much?
• Module to augment BAT

8
BAT Shore/Support Module

• Estimates effects of force structure changes on
  shore manpower requirements in areas of
• Individuals account
• Enlisted student billets (A- C-school Recruit
  training)
• TPPH billets
• Instructor requirements (A- and C-school)
• Intermediate and Depot level maintenance
• Aviation
• Ship and shipboard systems
• Health care services
• Outputs billet requirements by rating or
  designator and paygrade

9
IA Billet Computations
Input
Computations
Output
Force Structure
Support Structure
10
Enlisted Student Billets Recruit and A-School
Training Model
Junior-Level Fleet Billets (E3-E5)
Billets filled per year
Fleet Sailors
Initial Training
Recruits
A-School Training
Recruit Training
C-School Training
Percentage of E3-E5 billets filled by Sailors
directly out of initial skills training
Instructor Billets
Instructor Billets
Student Billets
Student Billets
Student billets for Recruit and A-School Training
tied to change in E3-E5 billets in the fleet
11
Shore Maintenance Model Intermediate Depot
Levels
Workload tied to change in platforms squadrons
Contractor (outsource)
Not included
Workload Change (manyears)
Government Civilian (billets)
Distribute over paygrade
Scenario
Distribute over rating/desig paygrade
Workload based on historic maintenance data
budget planning factors
Military (billets)
Workload distribution based on historic split
activity manpower documents
12
Maintenance Areas Data Sources

• Ship/submarine (class average)
• I-level maintenance workload VAMOSC
• D-level maintenance workload OPNAV Notice 4700
• Shipboard systems (data for 67 systems)
• I-level maintenance workload VAMOSC
• Data table maps shipboard systems to individual
  ships
• Aviation maintenance (by aircraft type/model)
• I-level maintenance workload VAMOSC ATMSR
• D-level maintenance workload VAMOSC ATMSR
• Data set that contains aircraft (by TMS) in
  each squadron by FY

Visibility and Management of Operating and
Support Costs
13
Defining the Support Structure Scenario by CA
Function Area
14
Change Data Parameters

• Users can view/edit the data for each functional
  area
• Allows many types of what if analysis
• Can easily be reset to original values

15
More Features Capabilities Enhanced BAT
Development

• Users identified additional features and
  capabilities that would improve the tools value
  and expand the range of issues it can address
• Add more TFMMS/billet description fields
• Functional area code identifies general-duty
  billets
• Map billets to location descriptors (geostability
  studies)
• Enhance the scenario development module
• Allow scenarios that change over time
• Incorporate long-term force structure plans
  (30-yr ship plan)
• Construct module to build/edit manpower
  requirements
• Change billet structure of existing
  platforms/activities
• Define requirements for new platforms
• Improve output reporting
• Tailor output reports to directly feed Community
  Health Matrix Reports and Sea/Shore Flow Model
• Add capability to filter output on specified data
  fields

16
30-Year Planning Tool
17
30-Year Shipbuilding Plan
FY18 Naval Force Ship Inventory - Carriers (11)
- Surface Combatants (93) - LCS (55) -
SSN/SSBN/SSGN (66) - Expeditionary Warfare Ships
(31) - CLF (30) - Mine Warfare Ships (12) -
MPF (12) - Support Vessels (20) - TOTAL 330
FY36 Naval Force Ship Inventory - Carriers (12)
- Surface Combatants (73) - LCS (55) -
SSN/SSBN/SSGN (63) - Expeditionary Warfare Ships
(30) - CLF (30) - Mine Warfare Ships (0) - MPF
(12) - Support Vessels (21) - TOTAL 296
FY08 Naval Force Ship Inventory - Carriers (11)
- Surface Combatants (108) - LCS (4) -
SSN/SSBN/SSGN (71) - Expeditionary Warfare Ships
(33) - CLF (35) - Mine Warfare Ships (14) -
MPF (0) - Support Vessels (18) - TOTAL 294
Will this result in an increased short-term MP
requirement?
Source WBB BAT Brief
18
Ship Inventory vs Projected Ship BA
Inventory increase - 11 LCS - 3
Support ships - 1 MPF vessel
313 Baseline
Source WBB BAT Brief
19
Force Structure Changes Affect Community Health
Surface URL Billets on All Ships (Ships Company)
2008
2016
2030
Cost/officer118.6K
Cost/officer126.4K
Cost/officer122.5K
Billets - 2008
Billets - 2030
Billets - 2016

• Beyond the FYDP, focus must shift from
  accessions to retention
• Results in a more senior and more expensive (cost
  per member) force.
• How do we grow enough Dept Heads with a shrinking
  Ensign Base?

Force structure decisions are creating
significant community challenges
Source WBB BAT Brief
20
User-Defined Unit Activity Manpower
Requirements Module

• Allows users to
• Modify billet structure of existing force
  structure units or shore activities
• Define manpower requirements for future units
• Requirements defined at rating/designator
  paygrade level

Billet-level data
21
User-Defined Unit Activity Manpower
Requirements Module
Activity-level data

• Interface to define or change activity-level data
• Can change location to study area manpower
  impacts of home port changes (geostability issues)

22
BAT Availability

• Original BAT operational and available on WBB
  website (with N12 approval)
• TFMMS data updated monthly
• Other data updated as available
• Pay tables
• Enhanced BAT with integrated Shore/Support module
  will be completed by October 2008

23

• Questions?