Many organizations track the number of hours in the pipeline. This helps you gauge whether enough — or too much — work has been taken on. The report Number of scheduled assignments per employee plots the number of scheduled direct hours against the productivity target, so you can see ahead of time whether enough work is planned.
The report shows scheduled assignments in the future as well as assignments that have already passed, going back up to 6 months.
Report structure
At the top is the filter bar; below it a totals block (Total), the chart Distributed by employee, the chart Totals in selected period, broken down by month, and the Detail view (the table).
Distributed by employee
Plots scheduled direct hours against the target per employee. This shows you who still has capacity in their schedule and who is fully booked.
Totals in selected period, broken down by month
Plots scheduled hours against the target per month, so you can see in which months the schedule is still below target.
Detail view
The table shows the scheduled hours, target, and remaining hours per employee. Use Columns to choose which columns are visible and Export to download the data.
Columns in the table
KPIs
KPI | Description |
Scheduled hours | The scheduled hours in the period. |
Registered leave | The registered leave in the period. |
Scheduled hours minus leave | The available hours after deducting leave. |
Productivity target excluding absence | The productivity target applied to the available hours (scheduled hours × target %). |
Hours scheduled (direct) | The number of scheduled direct hours. |
Remaining to target | The difference between the target and the scheduled direct hours. |
Hours scheduled (direct) vs. productivity target | The ratio of scheduled direct hours to the target (ideally 100% or more). |
Registered absence | The registered absence in the period. |
Hours scheduled (indirect) | The number of scheduled indirect hours. |
Remaining hours | The remaining hours. |
Dimensions
Date
Employee
Filters
Use Add filter to add filters; use Reset filters to clear everything. Choose how far ahead you look: the more months you select, the higher the expected target. For example, if you expect 1,000 hours per month and plan two months ahead, select two months to weigh the target of 2,000 hours against the scheduled hours.
Dimensions
Period
Employee
Team
Status
How the target is determined
The target is determined by the productivity target applied to the employee's schedule:
The number of hours someone is expected to work according to their schedule × the productivity target in %.
Example: someone works 32 hours per week with a productivity target of 75%. The productive hours target is then 32 × 0.75 = 24 hours.