WFT_5.1a_Workforce_Capability_Capacity_Calculator (.xlsx)

Title: WFT_5.1a_Workforce_Capability_Capacity_Calculator (.xlsx)

​

Purpose: The OE21 WFT 5.1a Workforce Capability Capacity Calculator (.xlsx) tool is used to estimate the workforce capability (experience, education, onjob performance) and capacity (positions onboard vs. needs).

Responsibility: Workforce Focus Team (WFT)

​​

Value: Tracks current and estimated future requirements for workforce capability and capacity, to ensure that a capable and productive workforce is available to the organization. Helps determine the kinds of employees that need to be hired and what actions the organization should take to ensure that employees are fully capable of doing todays jobs as well as future anticipated jobs the organization provides.

WORKFORCE CAPABILITY INPUTS:

• Name

• Work Unit

• Highest Grade Level

• Relevant Experience (Years)

• Supervisor Job Performance Rating

​

WORKFORCE CAPABILITY CALCULATIONS:

• Workforce Capability Score

• Workforce Capability Requirement

• Workforce Capability Variance

• Percent of Capability Rating (per employee)

​

WORKFORCE CAPACITY INPUTS

• Position Titles

• Current Quantity per Position

• Currend Quantity of Demand

• Current Need Urgency

• Future Availability Forecast including dates

• Future Demand Quantity

• Future Need Urgency Rating

​

WORKFORCE CAPACITY CALCULATIONS

• Current Availability Short or Excess

• Future Availability Short or Excess

​

The complete explanation for all inputs and outputs is documented in OE21 Standard  5.1 Workforce Environment

​​

WFT_5.1a_Workforce_Capability_Capacity_Calculator (.xlsx) - Workforce Capability

WFT_5.1a_Workforce_Capability_Capacity_Calculator (.xlsx) - Workforce Capacity