Timesheet & Project Management Blog

 

Hey Warren. We have consultants working on billable projects for clients and they have a certain client billable rate that each client works on. Problem is they don’t always work on billable projects. Sometimes they work on an admin project or an in house project. What I’d like to know is the final effective billing rate that we end up with on these consultants. Is that something that Standard Time® can do?

Absolutely. There are a couple ways Standard Time can help you. One way is you can simply look at a person’s timesheet if you want to and see what projects they are working on, it’s as simple as that. Another idea and something Standard Time offers is a report that will show you some ones billable time or their effective billing rate. Let me touch base on both of those briefly here. I’m looking at my timesheet right now. If I wanted to see what a particular person was doing or see if they were working on a billable project; I can go up here to the Users menu, as an administrator I can do this whereas end users cannot. I can go ahead and see Jordan Ford; I open up my list of users and click on Jordan Ford’s name. When I do you’re going to notice my timesheet will change because now I’ll be viewing Jordan Ford’s timesheet. If I needed to I can make changes to this timesheet or make adjustments if I have the user right to do so. Even as an administrator you can prevent people from changing timesheets if necessary. Then when I want to go back to my normal view and see my timesheet or someone else’s you can either click on another name to view another timesheet or to remove the filter all together and go back to my normal view. I click the yellow X up here on the top of the toolbar and that will take me back to my normal view. Now the report I was talking about is found here under the Management Reports. If I expand that I can scroll down to the bottom and show Utilization and rates. So when I open up this report I can view it by user, by project or any number of ways I choose to. In this case I want to just look at a couple projects. Let’s look at LBIR-Phase 2 and if I hold down my control key I can look at Chevron at the same time. And every choice I make will appear in the bottom left corner of this window. And in fact let’s make one more choice; let’s say I just want to see only This week. I’ve made these choices at the bottom and I can save these choices if I want to run reports repetitively over the course of time. In this case I’m going to run it today so I click OK. When I do the report pops up and I can see what Jordan Ford worked on, we can see that Jordan was scheduled 40 hours, he actually worked 22.2 hours and of those 22.2 hours every one of them were billable so therefore he’s considered 100% billable. However a distinction here is utilization percentage. He was only 55% utilized, in other words although all of his time was billable he was scheduled 40 hours and only worked 22. Therefore he was underutilized.

I see that Effective Billing Rate over on the right hand side essentially $51.59 per hour.

Exactly. You can see at the bottom he was a net loss for the company. And if you look at this other person here, Warren, you can see he scheduled 44 hours, worked 40.45 all of them were billable, 100% billable. My Utilization was 91.9%. In that sense if you look at the Effective Billing Rate I’m pretty accurate, I’m pretty close to where I should be. And this employee is a net profit for the company. And when you combine the two at the bottom that’s what this bottom number gives you, the combined efforts of everybody in the report. It shows you that although one person was a net loss and one person was a net gain; combined together you still had a profit between the two employees.

OK, that about does it. Thank you.

Watch the video:   https://www.youtube.com/watch?v=mKVs1XnHMPo

FREE TRIAL


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
E-mail
Invalid email address.
Number of Employees
How many employees will use this?
Enter the text below
Enter the text below
Please enter the text above