Average amount of overspending
on budget for tasks is a
key performance indicator that shows how much on average you exceed your budget
for all tasks. If deviation in planned budget (Cost Variance) is calculated by
the formula:
Cost Variance = Cost - Baseline
Cost,
the KPI Average amount of overspending
on budget for tasks shows the average amount in money with Duration Variance
that has positive format.
This KPI
helps to define how successfully your budget planning was and estimate how much
you are over your budget.
If you need
to calculate the average amount of overspending
on budget for tasks,
please do the following:
- Create
the custom field "Cost Variance":
![](/images/tutorial/average-amount-of-overspending-on-budget-for-tasks2.png)
- If
you need to view the average
amount of overspending on budget per particular project on Task List, filter your to-do list by task
group with project tasks.
![](/images/tutorial/average-amount-of-overspending-on-budget-for-tasks4.png)
- To
display the average amount of overspending
on budget on Task List
set filter by custom field "Cost Variance"
![](/images/tutorial/average-amount-of-overspending-on-budget-for-tasks6.png)
- Set
footer:
- right
click under column "Cost Variance"
- select "Average"
![](/images/tutorial/average-amount-of-overspending-on-budget-for-tasks8.png)