Progress Numbers

Progress Numbers section shows data regarding three key factors in a project:

- Hours
- Expenses
- Income


By setting the budgets for your projects you can monitor how the project is doing with the proposed resourcing plan.


Hours


Hour budget is inherited straight from Project Numbers' hour budget total row. If the hour budget row is empty the value will inherit straight from the project's basic information.
- If both have a value, the one in Project Numbers is prioritised. 
- If both are empty, the value will be zero (0).

Realized hours (=actual hours) is the sum of actual hours registered for the project. Same value is also found in the realizations row (hour) in Project Numbers table.

Future allocations is the sum of all the upcoming allocations.

Expenses


Expense budget is the total value of monthly expenses set in Project Numbers table

Realized expenses is calculated with the equation:
past actual hours * persons' cost price +  fixed expenses (amount * unit price)

Future expenses is calculated with the equation:
future allocated hours * persons' and/or roles' cost price 

Total expense forecast is the sum of Realized expenses and Future expenses.

Income


Income budget comes automatically from the total income row in the Project Numbers table. If that row is empty, the income budget is the sum of income budgets in the project's basic info section (own income budget + external income budget + other income budget)

Realized income comes from the Invoiced row of the project number tables, i.e. sum of invoiced realizations and invoiced payment positions.

Invoiced realizations are calculated by multiplying individual's actual hours with the set hourly rate. These hourly rates for realizations can be altered by modifying project's price model.

Future income comes from the Uninvoiced  row and Payment positions row of Project Numbers table. Depending on the project's invoicing type there are two variations for the formula:

Project's invoicing type is set as fixed
-> future income is direct sum of payment positions (amount * unit price).

Project's invoicing type is set as 'price ceiling' or 'time and material'
-> future income is sum of future allocations (hours * project role's hourly rate) + uninvoiced past realizations (hours * hourly rate from price model) and uninvoiced payment positions (amount * unit price).
How did we do with this article?