Allocation Report
The Allocation Report shows you how many hours and tasks your team is assigned over a period of time. The report is a good way of find out if you have people available for upcoming projects, who maybe overbooked, or who could is under utilized.
Positions
Departments
Users
Projects
User Groups
The filters are set up to help find the people you need for a project. You can filter by name, department, position, and user groups.
The period filter is the only required filter on the report. You need to specify a range for the system to find all tasks where users are currently assigned and the hours assigned. The results will display differently depending on the length of a range you select.
If the date range is less than 21 days, days are displayed.
If the date range is more than 21 days, weeks are displayed.
If the date range is more than 182 days, then months are displayed.
If the start or end period is partial (starts after the 1st of a month and ends before last day of the month), different ranges will display and the start/end so the rest of the date periods are even.
Each row of the report will show a user if they are assigned a task in the period range. You will not see a user if they are not assigned to any task. The system will break up the assigned hours based on the time bucket.
If you want to see a detailed breakdown by task, click on the user's name and you will see a pop-up with all the projects and tasks the users are assigned in the period.
The allocation report allows you to see what hours your team is committed to over a period. The report uses a task’s date range and hours to estimate the bandwidth of your team. For example, if a task is scheduled for five days and there are 15 hours assigned to the task, the report will show a commitment of 3 hours for each day. You can filter the report by a date range to see the commitment for the next, month, etc. You must use Projects and the HR modules to leverage the report.
To use the allocation report, you must have a project set up with tasks, hours, and assign those tasks to a team member.
To check to see how much time you have allocated for an upcoming period, go to Reports > All Reports > Other > Allocation Report. You must select a period in order to run the report. You can also filter by project, user, and project attributes.
When the report is run, you will see a table broken down by date and user. Depending on how large of a date range searched, the table columns will either be individual days, weeks, or months. The last column shows the total hours for each user for the entire time searched.
There are two display options for the report: Hours or % Booked. When you use the Hour display option, the table will show the number of hours each user is booked for on each date. If the time range is large enough, these hours will be for a weekly or monthly total. When the % Booked display is used, instead of hours, you will see percentages each user is booked for, rather than the number of hours they are scheduled to work.
The % Booked view is helpful if not everyone on your team works an 8-hour day. For instance, if you have some staff members who work 6-hour days, you can see how much of their time they are scheduled for, rather than doing mental math, and remembering which employees work which hours.
The report is also color-coded to reflect how busy each user is. There are ten colors that show a user’s availability – one color for every 10% booked. Green shades mean a user has a lot of available time, yellow and orange mean they are somewhere in the middle, and red means the user is booked or over-booked.
Tip
You can set up your own color-codes by adjust your allocation levels.
Allocation Details Popup
Click on a user’s name in the report to open the Allocation Details popup. The popup further breaks down the report by showing a user’s hours based on project and task.
The Task Hours list the total numbers of hours assigned to the task.
Each day will list the number of hours estimated for the day based on the hours assigned to the task and the number of days assigned to the task.
The Period Hours list how many hours are allocated to the user for the task.