Calculate FTE Using the FTE Report

Overview

The FTE Report allows you to compare the deployment of your employees at different workplaces and customers, comparing the Actual Work Effort against the Full Time Week.

The Actual Work Effort is the time that an employee has worked in a week. It is obtained from all Master and variable timesheet data, imported time data and pre-interpreted data which is in a status of Submitted or later.

The FTE Report analyses the deployment of employees for a particular period, based on the period of work (start and end dates of the timesheet).

Other dates associated with the timesheet (eg date submitted, approved, finalised, or paid) are not relevant to this report.

FTE Calculation for an Employee

FTE is calculated on the basis of Actual Work Effort divided by the Full Time Week. This is represented as a decimal value where:

• A value less than 1 means that the Actual Work Effort is less than the Full Time Week.
• A value greater than 1 means that the Actual Work Effort is more than the Full Time Week.

For example:

0.5 FTE	An employee works 50% as much as an employee working full time (eg 19 hours of an expected 38 hours)
1 FTE	An employee works 100% as much as an employee working full time (eg 38 hours of an expected 38 hours)
2 FTE	An employee works 200% as much as an employee working full time (eg 76 hours of an expected 38 hours)

FTE Calculation for Multiple Employees

If you have multiple employees, these will be added up to calculate the Total Available FTE and actual FTE.

For example, a Customer has three employees who are each expected to work a 38 hour week. One employee actually works 38 hours; two employees job share and work 2.5 days (19 hours) each.

If all three employees were to work an expected week, there are 114 hours (3 x 38 hours) assigned to the Customer. Based on the above, only 76 hours are recorded (1 x 38 hours, 2 x 19 hours).

In terms of FTE, the Total Available FTE is 3 and the actual FTE is 2.

FTE Reporting Over Multiple Weeks

FTE is calculated on a per week basis, however, you are able to report across multiple weeks.

The Total Available FTE for multiple weeks is calculated by adding the Total Available FTE for each week. For the example above, in a six week period the Total Available FTE would calculate as 18 (3 employees x 6 weeks), with an actual FTE of 12.