The Official BQE Software Blog

Utilization vs. Realization of Billable Time in BQE Core

Utilization vs. Realization of Billable Time in BQE Core

Oct 28, 2020 | By Michael Ybarra | 0 Comments

Topics: Employee Performance, Featured, BQE CORE

 

Employees should always bring value to your company, whether their time is directly billable or not. Sometimes it is easy to identify your heavy hitters, but the relationship between employee value and cost is not always directly tied back to their time printed on an invoice. For example, your office manager may never track billable time, yet they may be the glue that holds a lot of your daily operations together.

Yet tracking expected billable time is one of the most effective means of understanding employee performance. This is because billable time is often related directly to task versus billing analysis. 

While Core cannot tell you the true value of any one employee, we can provide you with the critical data to evaluate who has been on task, and even which services you provide outperform others. The key is breaking down billable time into utilization vs. realization.


Utilization vs. Realization of Billable Time

In general, there are two ways to calculate billable time and thus the value that your employee provides to your company: utilization and realization.


Utilization of Billable Time

This refers to the ratio between billable and non-billable hours worked by any given employee. The Utilization Rate is then calculated as a percentage of daily billable hours. Specifically, the Utilization Percentage is calculated as billable hours divided by total hours.

If an employee typically works 10 hours in a day (easy math), and 8 of those are billable, then the expected Utilization Rate for this employee is 80%. You can then run an Employee Performance report in Core to see if employees are meeting these expected quotas.

Tip: When setting up an employee (or vendor) record in Core, consider updating the expected Target Utilization rate under the Rates & Options tab in the detail view.

You can also set a default Utilization Rate in Global Settings > Master Information.

For your convenience, Core also provides in-line performance views to quickly track employee utilization.


Realization of Billable Time

This refers to the ratio between the billable value of hours worked by an employee vs. how much you have invoiced for that time. It is simply the total value invoiced divided by the value of the hours billed. In other words, what you billed divided by what you could have billed.

For example:
Curtis Jameson has a typical bill rate of $100 per hour.
He works 1,332.5 hours for the given period.
His time is then invoiced for $181,574.41. 



Curtis would then have a Realization Rate of 136.27%, since the billed value is greater than the billable value of his logged time entries.

Realization rates can be found on the Employees > Performance screen as well as on the Employee Performance reports.

 

Why Track Utilization and Realization?

Tracking employee utilization provides critical information to assist with employee reviews, task allocations, and potential revenue forecasting. Tracking realization then allows your firm to use these valuation benchmarks to better understand project profitability and sources of revenue gains or losses. 

Let’s take a look at what it looks like when a firm loses out on billing the value of worked time and then a customer fails to pay the entire invoice.

 

 

2020

Realization 

Realization Rate

1

Value of Billable Work

$4,000

 

 

2

Invoice Value

$3,000

$ 3,000

 

3

Employee Realization

 

$3.000

75% 

4

Fee Collection (Customer pays less than expected)

$2,000

$ 2,000

75%

5=2-4

Fee Outstanding

$1,000

$(1,000)

 

6=1-4

Total Realization

 

$ 2,000

50%

As you can see, collecting the entire payment due from a client is important. Yet, it may be just as important to understand the billable value of the time worked as this can just as easily affect the bottom line of your firm. In the example above, losing out on both client payment and initial invoice value has caused this company to cut its earning potential in half, which is not obvious if you are simply reviewing collections of outstanding invoices.

 

Core Helps You Improve Billable Value

Core analytics are specifically designed to help you gain focus on employee performance, billing contracts, and earned value to supercharge both profitability and project performance. Other companies are using these tools to gain a cutting edge advantage in the market. Isn’t it about time that you do too?

 

The Author

Michael Ybarra

Michael Ybarra is Trainer at BQE Software. In his role as a trainer/consultant for BQE’s current and future users, Michael is passionate about understanding the crux of their problem in order to provide an accurate solution and building synergistic relationships. Michael is a proud father of three children (who make him smile even on Mondays), and when he isn’t solving user problems, Michael enjoys a little computer programming, community service, and viewing fine art performances.

More From This Author

Comments