See how many employees are working in each department.
Many of our users want to use the FTE values from their Employee Module in C2C and FOA formulas or for other analytical purposes. We have created a Non-Financial Group called Auto-Assumptions that calculates the FTE Values for each department in a category called FTE - Full Time Equivalent (Auto). This category can be seen in the data sheet and is automatically generated from the payroll information in the Employee Module. It is located on your Data Sheet in view only mode for any budget with at least one Employee with Payroll in the Employee Module.
The FTE Category Value for each month is determined as follows:
- Employees with Salary Comp Type: The FTE is equal to the percentage of their monthly allocation to that department.
- Employees with Hourly Comp Type: The FTE is determined by the employee's hours for that month and department divided by 173.33. 173.33 is equal to the monthly hours for a full time employee working 40 hours a week for 52 weeks.
Below is a screen shot of the Non-Financial FTE - Full Time Equivalent (Auto) Category