Budgetary Control on Project and Task Level

Friday, July 29, 2016 by Michael Kubitschka

In time cockpit version August 2016 we extended the existing project management functionalities. Up to now, time cockpit provided a list for budgetary control of projects. This list helps you to check whether the actual effort is within the project budget. In larger projects you will need more control over the status of you project, so we added a new list "Budgetary Control of Tasks", that allows you to monitor the progress of your projects on task level.

Budgetary Control of Tasks

Using the current list for budgetary control of projects, it’s possible to check whether the actual effort is within the entire project budget.

If a project is divided into several tasks (and thus the project budget) it is possible that the budget of some tasks is overspent. However, as long as the total project budget is not exceeded, this is not visible in the project budget control list. Usually, the tasks are not worked on simultaneously, instead they are completed stepwise. Exceedance of the project budget might come up only at the end of the project.

In order to recognize such trends earlier, we now provide an opportunity to control project budgets also on task level. The necessary field “Budget [h]” on task level was already included in the previous standard of time cockpit. Using the new list “Budget Control for Tasks” it’s possible to compare actual hours spent on a task and the respective budget.

The new list Budgetary Control of Tasks can be found in the Management module inside the section Billing and is structured as follows:

Budgetary Control of Tasks List

Per default the filter of the list loads only not closed tasks that contain unbilled billable hours. Of course these filter settings can be changed.

The following table contains a description of every column of the list:

Column Description
Project The project related to the task
Task The task to which the other columns reflect
Budget [h] Budget for the task in hours
Billable [h] Sum of billable hours that have been booked for the task
Billable open [h] Remaining billable hours for the task (Budget [h] – Billable [h])
Billable hours [%] Percentage visualization of Billable [h] and Budget [h]
Hours Worked [h] Sum of all worked hours (billable + not billable)
Total Open [h] Remaining hours for the task (Budget [h] – Hours Worked [h]), this value differs from the remaining billable hours when you decide to set some hours to unbillable (e.g. bug fixing), this leads to a lower effective hourly rate
Worked [%] Percentage visualization of Hours Worked [h] and Budget [h]
Unbilled [h] Billable hours that have not been already billed
Unbilled Revenue Unbilled revenue
Effective Hourly Rate Sum billable revenue / Hours Worked [h]
Time Sheet Entries Link to the related timesheets for the task
comments powered by Disqus