Total and Average Health Care Insurance Cost per Employee

Health Care Insurance is a policy that provides coverage for medical expenses and treatment of policyholder. Medical insurance can reimburse illness, injury, visits to the doctor, emergency room. Health policies vary in what the insurance companies cover and how much of deductibles your employer or you need to pay. Health insurance plan usually includes co-payment, deductible, co-insurance, premium and lifetime maximum. Co-payment and deductibles refer to non-reimbursable expenses and are also called out-of-pocket expenses. Various online calculators are now available to check out different health insurance options.

The KPI Health Care Insurance Cost per Employee shows the total and average cost of health care insurance the employer needs to pay for employees. Insurance cost along with Wages and other Direct Labor Costs make up total Direct Labor Cost.

If you need to calculate the total or average medical insurance cost per employee, please do the following:

• Create the custom field “Health Insurance Cost”:

Depending on the policy options you choose you can add the formula to this custom field to calculate Health Insurance Cost automatically for each employee.

• Create a task group for tasks related to insurance cost of employees and filter by this task group:

• to view the total medical insurance cost per employee on Task List, right click under the column “Health Insurance Cost” and select “Sum”

• to see the average Health Insurance Cost select “Average”

If you need to view the total or average “Health Insurance Cost” 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 the total or average number of defects select custom field “Health Insurance Cost”,  do the following:
  • select Enable
  • check “Aggregated” (for task group)
  • to display the total amount of defects select “Sum” and the custom field name “Health Insurance Cost”

• to display the average number of defects select “Average” and the custom field name “Health Insurance Cost”

• Select task group with tasks related to health insurance costs of employees, right click and select “Custom fields options”

• Select custom field “Health Insurance Cost” and select the option “Enable by parent”.

If the custom field uses the formula, select “Calculated by custom field formula (for task group)”

Total Health Insurance Cost on Task Tree

Average Health Insurance Cost on Task Tree