The workforce manager at Harbor Motion Manufacturing needs October 31 employee headcount and FTE by department, plus an export for the planning workbook. Exclude contingent workers, preserve employee identifiers and distinguish vacant position capacity. Deliver a saved reporting view, detailed source export and checked controls.
A headcount handoff should let another analyst reproduce the result without guessing the population. Start with the effective date and employee class, preserve the person key, then calculate people count and FTE separately. A position-capacity report adds context, but vacancies should not be folded into employee headcount.
You'll build the October snapshot, calculate both controls, group FTE by department, save the view and export employee detail. Then inspect vacant capacity and return a final checked employee count. Each step carries the same reporting work forward. The deliverable is a reproducible table and its controls, not a number detached from the records or a count of all historical job-information rows.