The Hours Budget Forecast report compares budget, registered hours, and progress, and automatically calculates the expected spend and the expected remaining hours budget. This lets you identify early on whether a project is staying within budget or heading toward an overrun — a negative remaining amount indicates an expected overrun. Use the report to see how much of the budget has already been spent, to predict whether a project will go over budget, and to get a clear picture of the expected total hours spend.
Report layout
At the top is the filter bar; below it is the Detail view (the table) showing the budget, spend, progress, and forecasts per active project and project service.
Detail view
The table shows per project service how the budget is developing and what the expectation is at completion. Sort by Expected remaining hours budget to surface projects at risk of an overrun. Use Columns to choose which columns are visible, and use Export to download the data.
Table columns
KPIs
KPI | Explanation |
Hours budget (value) | The budgeted value of the hours. |
Hours spent (value) | The selling value of the registered hours. |
Budget spent (percentage) | The portion of the hours budget that has already been spent. |
Progress | The entered progress percentage of the project service. |
Expected hours spend | The expected final spend: the spend divided by the progress. |
Expected remaining hours budget | The budget minus the expected final spend (negative = expected overrun). |
Expected remaining hours budget (percentage) | The expected remaining amount as a percentage of the budget. |
Dimensions
Relation
Project
Service
Invoice method
Progress last modified
Filters
Use Add filter to add filters; use Reset filters to reset everything.
Dimensions
Project start date
Project end date
Registration date
Project category
My company
Project status
Project manager
Relation
Project
Project number
Invoice method
Example: predicting an overrun
A project has an hours budget (value) of € 50,000, a registered value of € 40,000, and a progress of 60%. This means 80% of the budget has been spent while the project is only 60% complete.
The expected spend becomes: € 40,000 / 60% = € 66,667.
Against a budget of € 50,000, the expected remaining amount is − € 16,667: an expected overrun of 33%.
Tips for use
Keep progress up to date. The forecasts are based on the progress percentages, so they are only as reliable as the progress entered.
Watch for differences between progress and spend. If spend is higher than progress, this may point to an underestimated progress figure, inefficiency, or budget issues.
Review negative remaining budgets. Projects with a negative expected remaining amount deserve extra attention and should be discussed with the project manager in a timely manner.