Headcount
- Note that both
Start DateandEnd Dateare broken down by the Employee category - End date will have to have Empty Value setting of None (this is the default for variables formatted as Dates)
- The result is a flag, which returns a 1 for each month that the employee that is active with the company, and 0 when they are not
- The Total of all Employees will reflect Total Headcount for each month for the company
- As long as your employees are mapped to a department you can reference any variable broken by employee and group by Department (or any other mappings)
- Returns a 1 on the employees start date, useful for things like New Hire Capex (e.g. Laptops)
- The first part of the formula sets the bonus
monthto January (1) Start Date < date - 6ensures employees have been with the company at least 6 months before receiving a bonusAnnual Salary * Bonus Target %results in the bonus amount. Multiplying byHeadcountwill ensure that the bonus is paid only if the employee is active (see Headcount formula above)- Note that the
Bonus Target %can be set at Department level, seniority, or any other level depending on how you map your categories
- Simply set a per employee assumption (can be by department, etc.) as a flat rate
- Multiply that rate by your headcount
- Simply apply a % rate to the applicable cost base
- Like all inputs they can be split into categories for more granular approaches
- You can create if then statements based off category items, Causal will automatically apply the correct assumptions to the formula. No need to set any filters!
Last modified 1yr ago