Planning question and workforce baseline · Lesson 2
Clean the baseline and define capacity
6 min read
Lesson objectives
Reconcile mixed-status employee records into usable FTE capacity without double counting.
Reading tools
Please sign in to use all the tools
Once you sign in, the reading tools are yours: larger or smaller text, typeface, line spacing, focus mode, highlighting and bold, and notes saved to your account and gathered in My study.
An HR-system headcount is not automatically the capacity available to a plan. A record may describe someone on leave, an ended contract not yet closed, a worker split across teams, or two positions entered for one person. Start with the measurement point. ‘Active people at month-end’ is a stock measure; ‘hours available during the coming month’ is a capacity flow. Do not mix them. Full-time equivalent, or FTE, divides contractual or productive hours by a defined full-time reference, depending on the decision. Productive hours fit a case-processing question better than contracted hours, whereas a payroll allocation may use a different basis. Record the definition in a short data dictionary so two reports do not use one label for different measures.
Reconcile in an order that preserves the audit trail. First choose a stable person identifier and remove duplicate import rows; do not merge two people merely because their names look alike. Second apply contract start and end dates to the planning period so a historical record cannot become current capacity. Third allocate each person's hours across teams with total shares no greater than 100%; moving one person between teams is not a second hire. Fourth deduct expected absence, training and administration from case-processing hours, distinguishing confirmed leave from an estimate. Fifth separate skill eligibility: an unqualified hour cannot process a case reserved for a specialist reviewer. Check three invariants: a person's team shares sum to at most one, team hours reconcile to allocated person hours, and every removed or adjusted row has a recorded reason. Where identity or dates remain disputed, flag the record for verification instead of silently deleting it.
Lesson summary
Reconcile mixed-status employee records into usable FTE capacity without double counting.