The HR director needs a September workforce pack for Northstar Fieldworks. Deliver a Composite of organization headcount and period exits, a reconciled closing headcount and attrition percentage, and the Excel output. All amounts and people are fictional practice inputs.
The HR director needs September's workforce review. Build separate current-headcount and period-exit components, assemble them by organization, and calculate the attrition rate from the tenant's dated worker records. The pack must let a reviewer inspect each population rather than accept a single unexplained percentage.
The fictional tenant closes September on the thirtieth. Count hires on their hire date, and exclude a worker from closing headcount on the effective termination date. September exits include both endpoints. Attrition uses September exits divided by the average of August 31 and September 30 headcount, multiplied by one hundred. Use those rules consistently. Each saved component and the final export carry into the next step, so your deliverable remains auditable after the numeric answer is entered.