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
  1. Time slot is current day or in the past = actual hours - income budget for the slot
  2. Time 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.
Values are color-coded to easily spot possible budget inaccuracies

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
Value
Color
< 10%
Green
10% - 20%
Orange
20% - 40%
Yellow
> 40%
Red

Negative percentage values are converted to their opposite positive values.
How did we do with this article?