The project numbers table offers numerical data based on allocations, expenses and given budgets. Some numbers come automatically from the system as you make resource allocations - some data is managed manually.
Income budget (eur)= estimated income budget for the project. Edited by clicking any of the slots in the table or by clicking the ellipsis icon. Hour budget (hours) = budgeted hours for the project. Edited by clicking any of the slots in the table or by clicking the ellipsis icon. Expense budget (eur) = estimated expense budget for the project. Edited by clicking any of the slots in the table.
Allocations (hours) = Cumulative sum of all the allocations for the project Allocations (eur) = Cumulative sum of all the allocations * forecast price from task / role Allocations, cost price (eur) = Cumulative sum of all the allocations * cost price from role
Realizations (hours) = Cumulative sum of all the actual hours registered for the project Realizations (eur) =Cumulative sum of all the actual hours registered for the project * price from task / role
Fixed expenses (eur) = fixed expenses for the project. Edited by clicking, explained below in this article Payment positions (eur) = Payment positions for the project. Edited by clicking, explained below in this article Invoiced (eur) = Amount invoiced for the project. Explained below in this article Uninvoiced (eur) = Amount uninvoiced for the project. Edited by clicking, explained below in this article
Income Budget
You can add the income budget for your project through the basic information section or through the project numbers table.
You can divide the budget evenly for the project's months (A) or sum the monthly values together into one budget (B).
A)Distribute to monthly income budget (colored orange):
We have set the Income budget as 10,000€. If we click on the ellipsis icon (blue circle) and choose Distribute to monthly income budget the budget will be divided evenly for all the slots depending on the project's schedule. In this example monthly income budget for each month will be 2,500€ (10,000€ divided for 4 months).
Takes all the current monthly income budgets and sets the total value as the new Own Income Budget in basic information. This will erase the previous value set in the basic information.
In the example above the new Own Income Budget would be 2500€ (only May has a value set). Note that this will take all the months into account, so the TOTAL row in the right will always be the value transferred over to basic information.
Hour Budget
There are two ways to add an hour budget for your project.
We also have two actions under the ellipsis icon in the Project Numbers table. A few features under the ellipsis icon Copy to project total hour budget which gathers all the monthly hour budgets (set in the Project Numbers table) and sets them as the new Hour Budget in the project's basic information. In this case the new hour budget would be 750 hours (200h + 250h + 300h). Note: any value set in the basic information will be overwritten.
Allocate a role allows you to immediately allocate the total hours from the Hour budget row to one specific role. In the screenshot below we are moving these hours for the unassigned role 'Accountant': More roles can be added by admins of Silverbucket After we save the changes the unassigned role Accountant will be allocated for 750 hours between the project's schedule, which is 1st of June - 30th of September.
Invoiced row shows the total amount of invoices made for each month. The hamburger icon in this row gives a more detailed view of each invoice made, and allows editing and deleting of invoice rows.
Deleting an invoice row releases connected payments and they appear back on the uninvoiced row.
The Uninvoiced row's hamburger icon opens a window for invoice creation. This window automatically creates a row for uninvoiced payment positions and the actual hours for chosen time range if any exist. You can also manually add your own rows.
You can also create invoices by directly clicking an uninvoiced amount on the row. This is a handy way of invoicing your project for the month you clicked.