The compensation partner at Northstar Fieldworks needs a fictional September review file. Build reusable monthly pay, FTE-normalized pay and tenure calculations. Deliver an exported active-worker report with raw inputs, derived fields, manager references and a review label. Don't initiate compensation changes.
The compensation partner needs a review file with annual pay, a monthly equivalent, salary per FTE and completed tenure. The file must preserve each worker's identity and manager relationship so reviewers can trace exceptions without receiving a separate lookup workbook. It's a review artifact, not an instruction to change pay.
Create the reusable calculations before adding them to the report. Keep the underlying salary and FTE beside the derived amount; that makes a surprising value easier to explain. A blank manager must stay visible. Finish with the review label and an Excel export of the final definition. Each step carries your prior calculations and saved report, and the final check evaluates the whole package on another tenant version.