Adding Job Task Estimated Times for Scheduling and Capacity Planning

Job Task Estimated Times

In order for your scheduling and capacity planning to work it is essential that every job task has an estimated time that reflects the budget for the task.  Whether you are using Practice Ignition to roll over your jobs or using recurring jobs in Xero Practice Manager, our Job Templates will determine the tasks applied to our jobs each year and the estimated times on these.

The estimated times on our templates may be standard for some tasks eg. BAS Return, GST Return, Coaching Meetings but may need to be updated each year for others eg. Annual Accounts - Preparation. The way we estimate these tasks timeframes changes depending on the nature of the task.

There are two types of tasks on each job template:

Standard Tasks

Standard Tasks on a job template describe a task that doesn’t vary much in duration client to client. A task like ‘Quarterly Coaching - Q1’ might encompass a 1.5hr meeting and 2.5hrs of preparation regardless of who the client is. We can apply a time estimate of 4 hours to each of these tasks inside our Job Template.

Variable Tasks

Variable Tasks on a job template describe any task that varies in duration from client to client. A task like ‘Annual Accounts - Preparation’ will vary depending on the complexity and volume of transactions in the annual accounts being prepared. Time estimates for these tasks will need to be calculated from the budget of the engagement. The challenge we are faced with, is we are unlikely to have expressly priced each line in our proposal to the customer. We may have just provided them a list of services and a single price - eg. $3,000 per annum. Let’s take a look at an example.

Let’s say we have an annual engagement for Barry’s Boxers & Briefs Limited with a budget of $3,000 that includes preparation and filing of annual accounts, with six 2-monthly GSTs. The job template we apply to our recurring jobs in XPM or our engagement rollover in PI may look like this:

• Annual Accounts - Preparation

• Annual Accounts - Review

• GST - April/May

• GST - June/July

• GST - August/September

• GST - October/November

• GST - December/January

• GST - February/March

A job template like this may be called ‘Annual Accounts + 2 Monthly GSTs’. Some of the tasks in this template may have time estimates that don’t vary much from customer to customer. Others will vary depending on the complexity, volume or scope of the services being delivered.

For tasks we can estimate ahead of time we can save ourselves time each year at job rollover by adding these estimated times to the Job Template. GST’s might be an example here. We may determine that on average a GST return takes 2 hours to prepare and file. We can add this 2 hour estimate to the tasks on the Job Template. We may also determine that it takes 1.5 hours to review a set of annual accounts so we can add this estimate too. These tasks will be ready to schedule as soon as the job rolls over each year.

To arrive at an estimated time for ‘Annual Accounts - Preparation’ however, we need to approach it a bit differently. We need to figure out what time budget is left after we have allocated the times to our standard tasks. Another challenge we have is that all of our staff are billed out at different rates that reflect their skills and experience. We are unlikely to know who will be performing this work yet. So to do this we’re going to need to use a Task Rate for each of our standard tasks. These Task Rates can be found in Business > Settings > Tasks and represent the average billable rate of the people who typically perform this task. Because we’re on the Staff Billable Rate for our invoicing these Task Rates are very rarely used - except here.

Our Task Billable Rates might be:

• GST $100/hr

• Annual Accounts $150/hr

Here is an updated view of our job so far:

We first need to calculate the remaining budget after allocating the standard times to the tasks on this engagement. This is represented above as ‘Y’ and can be arrived at by subtracting the total billable value of those tasks from the value to the engagement. In the example above we can calculate the remaining budget for Annual Accounts - Preparation as $1,500.

By dividing by the known Task Billable Rate for Annual Accounts services we can calculate the estimated time for Annual Accounts - Preparation based on the budget remaining. In the above table this is represented by ‘X’ and is 10 hours. So we can estimate that based on the budget for this engagement we need to prepare the Annual Accounts for Barry’s Boxers & Briefs Limited in 10 hours.

Now that we’ve done all this hard work, let’s look at how we can speed this up.

<Link to next section>

<Link to youtube video>

<Link to appropriate course>