Billet Analysis Tool (BAT)

In building POM programs to meet future mission requirements, Navy force planners evaluate numerous force structure alternatives. Two key considerations in evaluating these alternatives are manpower requirements and costs. The Director of Total Force Programming and Manpower (N12) is responsible for determining the manpower requirements and costs of each alternative. Doing this using the current manpower database systems and tools, however, is a laborious, time-intensive process. To better support manpower planning and programming efforts, N12 needs an analytical tool that can quickly determine the manpower implications of force structure changes. To meet this need, CNA developed the Billet Analysis Tool (BAT). BAT is a Microsoft Access application that uses data from the Navy’s Total Force Manpower Management System (TFMMS) to determine the manpower implications of changes to the Navy’s force structure, shore/support infrastructure, and manning level policies. It calculates, for a user-defined scenario, the change in billet requirements and authorizations for each component of the total force: active duty, full-time support (FTS), Selected Reserve (SELRES), and government civilians. Results can be aggregated and displayed at various levels of detail down to the rating/designator and paygrade levels. The tool also calculates manpower costs using both programming and composite cost rates.