Average Employee Costs per Task

Average Employee Costs per Task

Average employee costs per task is a key performance indicator that shows the expenses amount calculated by dividing the total employee cost of tasks by the number of tasks. Average employee costs include all costs that depend on the employee performance. Employee costs themselves can be calculated by the following formula:

Employee Costs = (Actual Work * Standard Rate) + (Actual Overtime Work * Overtime Rate)

This KPI helps to compare the variation of employee costs for different time periods.

If you need to calculate average employee costs per task, please do the following:

1. Create the following custom fields:
• Actual Work
• Actual Overtime Work
• Standard Rate
• Overtime Rate
2. Create custom field "Employee Costs":

• Go to: Tools/Custom fields and press "Ins" button



• In "Title" field enter "Employee Costs"
• In "Code" field enter "cf_employee_costs"
• In "Type" field select "Currency" and click "Ok" button
• In Formula field enter the formula below:

ToFloat($cf_actual_work)*24 * $cf_standard_rate + ToFloat($cf_actual_overtime_work)*24 * $cf_overtime_rate

3. If you need to view the average employee costs per particular project, filter your to-do list by task group with project tasks.

4. Set footer to display the average employee costs for a given project or to-do list:
• right click under column "Employee Costs"
• select "Average"