Labor Cost forecasting with Anaplan

The challenge in this project was to create a tool for the Controller capable of generating long-term labor cost forecasts, per employee, in a multi-company context, for the main components of the employee’s payslip.

​

Starting from the acquisition of data present in the payroll processing for employees from the HR department, the proposed solution was to create a tool capable of:
 

• Centralizing all demographic and contractual information related to employees;

• Generating long-term forecasts for each contractual item through the automation of the logic defined by the Controllers at the base of the forecasting process;

• Ensuring a dynamic processing system that adapts to the acquisition of real data obtained from the HR department;

• Creating a flexible process that allows the Controller to easily and promptly update any parameter to guide the forecast and make more informed and thus more strategic decisions.

 

The solution structures the process into three main pillars:

1. Integration and analysis tools for data received from the HR department;

2. Tools for integrating manual adjustments at the level of new hires, expected terminations, contractual parameters such as minimum wage and contributions, variables such as leaves, overtime or bonuses, salary increases, vacations, part-time, and much more;

3. Analysis tools for processing by payroll item, budget item, employee or cost center, and headcount.