The data that timesheets provide is analytics gold for any growing business. Timesheets tell you how long tasks take. That means you can see how much time is spent on tasks and how much time is left, based on the estimate that you are working to. None of that is likely news to you.
However, assuming your team has adopted time sheets and is using them efficiently to record their time, you can start mining them for additional types of data.
Let’s look at how you can use that data to get better at estimating.
Tip 1: Historical Searching
The easiest way to use timesheets to get better estimates is to look back through your previous projects and find tasks that are similar to the one you are working on now. Find out how much time it took to do the job on that project. Use this as the baseline for the estimate this time round.
Pro Tip: Don’t take the past estimate into your current project without reviewing it. This project may have different characteristics that will affect the estimate, so apply some common sense before adding that data to your current project plan.
Tip 2: Capture Billable Hours
Estimates aren’t just for the time it takes to do a task. If you bill your client, either for a fixed price or per hour worked, you need to be able to estimate effectively to win the work.
There are two scenarios here. For fixed price work, you estimate how long the project will take, add your margin and quote. If they like the quote, you’re hired. Then you have to deliver. Tracking your time gives you the data you need to see if you are making that margin or not. Knowing how many hours the project actually took you will let you calculate the profit margin for that project.
With that information you can do a lot, including assessing whether you want to work for the client again! Most importantly, you can use that data to adjust the margin and your future quotes so that you don’t lose money on future work.
If you work on a per hour basis then you’ll still have had to quote for the work based on how long you think the job will take overall. Clients want to know if it’s a three-week job or a three-month job as that makes a huge difference if you are billing by the hour/day. You’ll end up with unhappy customers if you end up billing double what you said you would because it took longer than expected.
Timesheets help you avoid that problem in the future. You won’t repeat that mistake because the data tells you how long the task is likely to take and therefore what you need to be quoting. Clients will thank you for it, and be pleased that you delivered when you said you would, for the price you said you would.
Tip 3: Understand How Individuals Work
The length of time it takes one person to do a job is not the same as it takes someone else. Look at your previous project plans for similar tasks and find one that corresponds to what you are doing today. That task might have been carried out by someone who was an expert (so therefore did it quickly) or a junior member of the team (so therefore did it slowly). Use the estimate as a solid data point but adjust it accordingly based on what you know about the resources working on your current project.
The data from your timesheets can be used to compare staff performance. Look at how quickly it takes people to do similar work and think about how you can buddy up your team members so they can learn from each other. This is a good way of sharing tips and tricks and bringing everyone up to the same level of performance and productivity.
Pro Tip: Don’t forget to take quality into account if you do this. Fast doesn’t always mean good!
These three tips will help you explain the value of timesheets to your team and get them onboard with tracking what they are doing. They are also great ways to boost the quality of your estimates to help both your team and your clients plan better.
Time tracking is so easy to do and it provides such rich data about project performance that it’s one of the reasons why our customers choose ProjectManager.com. Getting started only takes a couple of clicks and you can be recording your time in minutes. Try it for yourself with a free trial.
I am pleased to share my experience using the PMAspire resource. I accidentally stumbled on PMAspire, and took to it. The free trial opened up a lot of my weaknesses and I had to subscribe since I was preparing for my PMP Exam. The resource proved highly highly invaluable. It's to me a one-stop online shop. This is my experience. I painstakingly tested myself using the Knowledeg area questions and those of the Processes. It exposed my gaps, which I had to work on seriously. There were times of discouragement but I was undaunted as per my knowledge gaps and Gbam! I MADE IT. I GOT MY PMP! I will always reference and recommend PMAspire to anyone who wishes to sit for the PMP certification exam. I am right away recommending this to my colleagues in my office. Thank you PMAspire for such a resource you offer for the exam preparation, it is very useful. It is a one-stop shop. The questions I encountered in my preparation using PMAspire resource helped shape my mind and helped me in the real exam. No regrets at all. I recommend PMAspire to potential candidates. Kudos and keep up the good job