Total Employee Cost of Task

Total Employee Cost of Task

Total employee cost of tasks  is a key performance indicator that shows the total amount of expenses that are associated directly with the employee performance. Employee costs can be calculated by the following formula:

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

This KPI helps to estimate whether you keep or exceed the budget by the employee cost item.

If you need to calculate total employee cost of tasks, please follow the steps below:

• Create the following custom fields:
  • Actual Work
  • Actual Overtime Work
  • Standard Rate
  • Overtime Rate
• 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

  

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



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



If you need to view the total cost of tasks for project(s) on Task Tree, please follow the steps below:

• On Task Tree select root task group and select "Custom fields options"



• To enable the displaying of total cost for task group select custom field "Employee Costs",  do the following:
  •  select Enable
  • check "Aggregated (for task group)
  • select "Sum" and the custom field name "Employee Costs"



• Select task group for which you need to view the total cost of tasks, right click and select "Custom fields options"



• Select custom field "Employee Costs" and select the option "Enable by parent".





Total Employee Cost of tasks per project on Task Tree