Workforce Calculator

The Public Health Workforce Calculator is a tool to help local health departments with workforce planning efforts by utilizing information provided about the local health department to estimate the number of full-time equivalents (FTEs) needed to ensure the provision of the Foundational Public Health Services. The Calculator is intended for use in decentralized public health systems that serve less than 500,000 residents.

The Calculator has two user options, basic and advanced. Basic users should use their best judgement to estimate approximately how many FTEs spend time contributing to each Foundational Capability and Foundational Area. Advanced users are health departments who have participated in the Foundational Public Health Services (FPHS) related Capacity and Cost assessing.

The User Guide should be used alongside the Calculator; it will help you determine which user option is best based on available data, provides definitions and details on how to enter data, and provides a template for advanced users to complete before inputting data into the Calculator.

The Calculator was developed through a partnership between the de Beaumont Foundation, Public Health National Center for Innovations at the Public Health Accreditation Board, UMN SPH Center for Public Health Systems, and Centers for Disease Control and Prevention, Center for State, Tribal, Local and Territorial Support.

Due to Tableau settings, third-party cookies must be enabled on your Internet browser to use the Calculator.

Data submitted through the Public Health Workforce Calculator are collected and stored for research purposes only.

On October 27, 2022, the Public Health Workforce Calculator was shared with the field. The discussion, below, included insights and examples from Jessica Solomon Fisher from the Public Health Accreditation Board, JP Leider from the University of Minnesota School of Public Health Center for Public Health Systems, Sarah Ravenhall from the New York State Association of County Health Officials, Moriah Robins from the de Beaumont Foundation, and Liza Corso from the Centers for Disease Control and Prevention, Center for State, Tribal, Local and Territorial Support.

The Public Health Workforce Calculator can be used as a tool to help determine a health departments’ workforce needs. It utilizes information provided by health departments to estimate the number of full-time equivalents (FTEs) needed to ensure the provision of the Foundational Public Health Services (FPHS) in a community. In some communities, the FPHS are provided solely by one governmental public health department and in others, the FPHS are provided through a system including a local health department plus other local health departments or the state health department.

The development of the Public Health Workforce Calculator began in September 2020; the Public Health National Center for Innovations at the Public Health Accreditation Board partnered with the de Beaumont Foundation to develop a national estimate of staffing needed to perform the FPHS. The estimate found that more than 80,000 additional FTEs are needed in state and local health departments to implement the FPHS. View the full project report here and a webinar recording on the research-based estimation here.

The Calculator is based on data collected from hundreds of local health departments in four states (Colorado, Ohio, Oregon, and Washington) as well as data obtained from secondary sources, including the National Association of County and City Health Officials and Association of State and Territorial Health Officials Profile surveys and the Public Health Workforce Interests and Needs Survey (PH WINS**). The key data element from each data source was full-time equivalents. Specifically, each LHD in the dataset reported current FTEs for each Foundational Capability and each Foundational Area as defined in the FPHS framework. In addition to current FTEs, LHDs also estimated the number of FTEs needed to fully implement the FPHS (“full implementation”) in their jurisdiction. Both current and full implementation FTE information was limited to FTEs providing the Foundational Capabilities and Areas and did not include FTEs providing community-specific services.

The data model underpinning the calculator are statistical curves that estimate the number of FTEs needed to fully implement the FPHS as a function of jurisdictional population size. Additional detail on the underlying models used to estimate the FTEs needed to fully implement the FPHS in a local health department can be found in the 2021 Staffing Up full project report.

  • Frequently Asked Questions about the Public Health Workforce Calculator
  • FPHS in Action: Examples of FPHS Implementation
  • Calculator Citation: de Beaumont Foundation, Public Health National Center for Innovations at the Public Health Accreditation Board, University of Minnesota School of Public Health Center for Public Health Systems, and Centers for Disease Control and Prevention, Center for State, Tribal, Local and Territorial Support. Public Health Workforce Calculator. October 27, 2022. phnci.org/transformation/workforce-calculator

The Public Health Workforce Calculator would not have been possible without contributions from a range of public health practitioners and experts, including the Staffing Up Steering Committee; Staffing Up Research Advisory Committee; Crow Insight, LLC; JP Leider Research and Consulting; Mac McCullough; Sieger Consulting SPC; Northwest Center for Public Health Practice, University of Washington; Singh Research and Consulting LLC; Valerie A. Yeager, LLC; UMN SPH Center for Public Health Systems; WE Public Health; de Beaumont Foundation; Centers for Disease Control and Prevention, Center for State, Tribal, Local and Territorial Support; Public Health National Center for Innovations at the Public Health Accreditation Board.