Slide1: Navy Workforce Research and Analysis Conference N12 Billet Analysis Tool (BAT) A Users Perspective 02 May 2007 Mark Proctor WBB Consulting 11790 Sunrise Valley Drive Reston, VA 20191 703.448.6081 (x253) [email protected] Employing BAT: Employing BAT Manpower requirements beyond the FYDP with different force structure scenarios Analyzing impact of 30-year shipbuilding plan on manpower requirements Analysis of future force structure impacts on community health Community Management utilization of TFMMS data Identifying the “trade space” for manpower requirements in the FYDP Examples…………… 30-Year Shipbuilding Plan: 30-Year Shipbuilding Plan FY18 Ship Inventory TOTAL = 330 FY36 Ship Inventory TOTAL = 296 FY08 Ship Inventory TOTAL = 294 Will this result in an increased short-term MP requirement? 313 Baseline Ship Inventory vs Projected Ship BA: Ship Inventory vs Projected Ship BA 313 Baseline Inventory increase: - 11 LCS - 3 Support ships - 1 MPF vessel Carrier BA Beyond the FYDP : Carrier BA Beyond the FYDP 12 Carriers 11 Carriers ( - JFK) 10 Carriers ( - Enterprise) 12 Carriers ( + CVN-21) 12 Carriers ( + CVN-21 - Eisenhower) 11 Carriers ( - Kitty Hawk + Bush) 11 Carriers ( + CVN-21) 12 Carriers ( + CVN-21 - Nimitz) 12 Carriers ( + CVN-21 - Vinson) Surface Combatants (SC) : Surface Combatants (SC) 93 SC 55 LCS 91 SC - 22 CG - 56 DDG-51 - 13 DD(X) 44 LCS 99 SC 33 LCS 112 SC 21 LCS 73 SC - 19 CG - 13 DDG-51 - 41 DD(X) 55 LCS 108 SC - 22 CG - 62 DDG-51 - 24 FFG 1 LCS 87 SC 55 LCS 108 SC 4 LCS 93 SC 55 LCS SC force structure becomes smaller while manpower requirements become more senior….. 82 SC 55 LCS Analysis of Force Structure Change Impacts on Community Health : 2008 2016 2030 Cost/officer=$118.6K Billets - 2008 Billets - 2030 Cost/officer=$126.4K Billets - 2016 Cost/officer=$122.5K 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 O-1/O-2 base? Analysis of Force Structure Change Impacts on Community Health Surface URL Billets on All Ships (Ships Company) Community Management Drill Down : Community Management Drill Down Scenario example – Analysis of the ET(SW) rating/EMC What is the ET FY13 BA by pay grade, broken down into Sea/Shore billets? How many ET billets are in the CNI Enterprise? What is the annual cost of the ET community (in FY13 Composite Rate $$) to the CNI Enterprise? Are there any ET billets coded for Esprit de Corps? What percentage of Navy-wide shore billets are coded Esprit de Corps? How many ET billets are coded for Sea/Shore Rotation? How many ET billets have a PNEC of 1321? In FY13, how many ET billets are in the BUMED and PACFLT claimancies? How many shore billets would have to be eliminated/civ-sub’d in FY13 to move the ET community to a 4:3 Sea/Shore ratio? Of those needed for elimination, how many can realistically be looked at for review (from an IGCA perspective)? Scenario Answers: Scenario Answers CNI ET Billets = 349 Annual ET cost to CNI = $25.6M ET Esprit de Corps billets = 25 % Navy-wide shore billets coded Esprit de Corps ~4% (6771 billets) ET billets coded for rotation = 946 ET billets w/1321 PNEC = 47 FY13 ET billets in: BUMED Claimancy = 39 PACFLT Claimancy = 1964 Must eliminate/civ-sub 662 shore billets to get the ET rating to a 4:3 overall sea/shore ratio Billets coded X, R, P, J, and K = 1363 Note: Answers took less than 15 minutes to obtain 3 minutes to query the database 10 minutes to build this slide Why We Are the Size We Are(A breakdown of the AC) : Why We Are the Size We Are (A breakdown of the AC) MP = AC + RC + GS + CS AC = Sea + Shore Shore = Inherently Gov + Exemptions + Other + Under Review 322,023 = 158,321 + 163,702 Inherently Governmental = A + E + F + I 33,905 Exemptions = B + D + G + H + L + M + J + K 62,889 Other = Z (TPPH/Students) 48,288 Under Review = P + R + X + “9” 18,620 Total Shore 163,702 15,018 SSR 9,293 Career Prog Billet Tool Future…: Billet Tool Future… Select, prioritize, and implement upgrades resulting from user pilot Expand distribution to other users Community Managers Enterprise Leads/BSO’s Type Commander N1’s CNA Phase II – Shore Support Module Establish correlations between force structure and shore infrastructure Enhance capabilities based analysis/costing TFMMS to TFARS conversion Application to other tasking Mil-to-Civ conversions ($$$/impacts)/Competitive Sourcing analysis Sea/Shore Rotation Working Group applications Home Basing/Stability analysis Disaster planning analysis Training and Education requirements analysis Enhanced coordination between Enterprise Leads, BSOs, and Community Managers for POM/PR builds Women at Sea analysis Sizing the Navy Slide12: Questions ?? 30-Year Shipbuilding Plan: 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? Functional Categories (~6000 UICs): Functional Categories (~6000 UICs) Aviation Squadrons Communications Computer Support Construction Forces DoD Activities Expeditionary Forces Facility Engineering Fleet Command & Staff Headquarters Individuals Account Intelligence Investigation Joint Commands Legal Maintenance Marine Corps Support Medical Meteorology & Oceanography Military Sealift Ocean Surveillance Operational Bases Other Personnel Recruiting Reserve Activities Security Group Activities Ship: Combat Ships: Support SPEC WAR Submarines Supply Support - MISC Support Activities Support Services Technical Activities Training & Education US GOVT DEPT Unknown