Budget Tracking by Projects
Budget tracking by projects displays the projects' income budgets compared to actual hours and future allocations.
Basic information
Income budget EUR = The budget set for the project (Project's Dashboard). Same number as in the "Project Numbers" table's "Income budget" per month
Allocations EUR = Allocations made for the project * hourly rate set in Edit forecast prices
Realizations EUR = Actual hours registered for the project * price set for these actual hours
Delta EUR has two equation types depending on viewing mode
.1Time slot is current day or in the past = actual hours - income budget for the slot
.2Time slot is in the future = allocations - income budget for the slot
Cumul. delta EUR = cumulative amount of the previously calculated Delta EUR
Color-coding
The values of Allocations and Realizations (=actual hours) are compared to budget (if no budget is set, report is colorless) and colored according to the equation below.
Allocations:
(allocations - budget) / ((allocations + budget) / 2) *100%
Realizations:
(actuals - budget) / ((actuals + budget) / 2) *100%
This value is then compared to the table below to give the corresponding color
< 10%
Green
10% - 20%
Orange
20% - 40%
Yellow
> 40%
Red
Negative percentage values are converted to their opposite positive values.