Every Budget comes with 3 charts at the top. See below.
Each chart behaves differently and calculates using different information. This article will explain what affects the charts and how to read them.
Let's start with the simplest one...
Invoicing
This chart is pretty straight forward. It calculates how much you've invoiced and how much you still need to invoice on this budget.
The example from the above is a Fixed price budget with a total revenue of $33,350.00.
We have invoiced $10,000.00 so far, meaning there's still $23,350.00 left to invoice.
Budget chart (Remaining %)
This chart calculates the remaining budget by multiplying billable rates with billable time and subtracting the calculated amount from the total budget as your team members track time.
The current status is that out of the total initial budget of $33,350.00 we still have $23,215.00 left.
So, how does the budget get spent, you wonder?
Let's look at the list of services that belong to this budget and focus on the first one in the list which is Website redesign. This is a service our client pays $80/h for.
If one of our team members tracks time against Website redesign, Productive will multiply the tracked time with the billable rate and subtract the calculated amount from the total budget. It works like this:
- Team member tracks 5 hours against Website redesign
- 5 hours * $80/h = $400
- $23,315.00 - $400 = $22,915.00, which will be the current remaining budget after those 5 hours have been tracked
Profitability (Revenue chart)
So, now that we know how the remaining budget gets calculated, it's time to look at the middle chart that calculates profitability.
This chart represents your internal profitability which we calculate using employee's Cost rates per hour, multiplied by the hours they've tracked.
In the example above, a team member has tracked 5 hours against this budget. This has reduced the total budget by $400. In the same time, the profitability of this budget was affected too.
Let's say that the employee who tracked these 5 hours was Charles Blake. This is his Cost rate (salary) per hour:
5 hours * $50 = $250 of internal cost, which is the amount by which the profit margin was reduced after the hours have been tracked.
Bottom line
So, all things considering, as soon as Charles logged 5 hours against this budget, two changes have happened:
- He reduced the total budget by $400 (what the client wants to know)
- He reduced the total profitability by $250 (what your agency wants to know)
Worth knowing
Cost overhead
Using this addon will increase the internal hourly cost of your staff, making the profitability calculation even more accurate.
Read this article to learn more.
Out of pocket expenses
Not only time tracking affects the remaining budget and the profitability of the budget. Out of pocket expenses can affect the budget too.
Read this article to learn more.