
START HERE: Training Video 6.1a Product, Service and Process Design
OE21tm
Managers Guide to
Organization Excellence

NOTICE: When you visit this site, you are subject to our 2022 License Agreement.
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