Using Histograms to Get an Overview of your Resources

Looking like histograms: Mountains

Histograms for resource management

In the course of your resource planning, you have undoubtedly already tried out display formats to keep personnel requirements and available capacities in line with each other and to view several parallel projects and programs together. Histograms are especially well suited to this purpose. They give you a visual overview while highlighting your strengths in the context of resource planning and simulation.

Histograms are used in traditional and agile project processes to obtain the necessary overview of capacities and requirements. This compressed display format is often used to compare available capacities with several parallel projects and their requirements and to simulate a number of planning scenarios.

The axes of a histogram

To understand a histogram in the context of resource planning, it is first helpful to break it down into its individual components. We start with the two axes:

The time axis

Time proceeds from left to right on the x-axis, starting from the current time. The granularity of this variable, whether individual days or weeks and months, depends on the intended purpose and on how granular the resource management based on the histogram should be. In companies, planning and simulation is often done in weekly segments. Weekly segments are good for incorporating vacations, training, and the usual project phases. A month, in this case, would be too broad.

The requirement axis

The vertical y-axis of a histogram shows the necessary requirement. Possible units for the requirement axis are man-days, FTEs, story points, or other suitable units. Agile teams, when planning resources, often convert estimated story points into man-days in order to achieve overall comparability. Converting estimated efforts and capacities into the same unit for all teams and projects that need to be planned is a prerequisite for drawing conclusions from the histogram.

Histogramm Ressource planning Achses

The requirement range

Perspective based on organization, roles, people, or teams

For initial resource planning, it is necessary to be able to allocate people, including those with a certain skill set, teams or several individuals at the same time. This simultaneous initial allocation occurs, for example, by means of the decentralized project initiation for each organizational area. This is also the case when the attempt is made in agile organizations to define teams heterogeneously and to hold them together constantly.

Stacking the requirements of projects and plans

A histogram creates a consolidated view of all allocations from the perspective of the resource (Resource 1 in the figure). This means that all projects to which Resource 1 is allocated in a given week will be stacked on top of each other like a mountain range. The height of the project boxes represents the requirement per project and Resource 1; the combined area of all projects is an indicator for the total planned effort for this resource.

Histogram Resource planning Requirement

In the figure, Project C needs Resource 1 for a constant 80 man-days/week for three weeks between W2 and W4. Resource 1 could be testers, for example, to support planned integration tests during this period. The total effort for the testing has been estimated at 240 man-days.

Stacking order as a parameter for priority and criticality

The projects of the requirement range in the histogram are stacked from bottom to top. On the bottom are the “set” high-priority projects whose implementation delivers the greatest goodwill or strategic contribution, or for which there is no longer any time buffer.

The contour of the capacities as a basis for comparison

To enable comprehensive resource planning, the requirement range needs to be compared to the available capacities. Displayed as a contour, the following aspects are made visible at a glance:

  • When more or fewer capacities are available per organization, team or individual resource. This can be influenced by planned absences, hires, and fluctuation or by external reinforcement at certain times.
  • Which projects are affordable at the planned time and existing constraints.

The contour is defined in the same unit as the requirements displayed in the histogram and is in relation to the same resources. This means that the height of the graph represents, for example, the sum of all tester capacities in one calendar week.

Histogram Ressource planning Capacity

Histograms in use

Constraints and actions from the portfolio view

A histogram provides an easy overview of the timing and size of constraints. All projects that reach above the capacity contour are at risk of not having the required resources available in certain time periods.

A portfolio simulation with histograms can be used to pursue the planning objective of reducing this risk and balancing the ratio of requirements and available capacity. In the process, the following actions can help resolve the “red” areas in the histograms:

  • Move projects with time buffers
  • Stretch projects over time
  • Reduce the scope and associated resource requirements
  • Interrupt and resume projects
  • Shrink projects to gain time buffers
  • Expand the capacities, e.g., with external employees

In addition to balancing capabilities, portfolio planning involves allocating priorities that provide clarity in cases of doubt regarding who definitely has resources available and who does not. As mentioned above, high-priority requirements or projects are always found at the bottom of histograms.

Risk management for projects

For project managers, it is particularly helpful to be able to view and evaluate all histograms of the roles or resources allocated to a given project. This can lead to risk-minimizing actions, such as adjusting procedures, or to a planned, timely transfer of knowledge to bridge the loss of experts.

Conclusion

Histograms can be used as a means of comprehensive support for a resource planning project. Important conclusions can be drawn from the charts – both in the multi-project view and for individual departments or projects – with regard to constraints, capacities, requirements, and priorities. In addition, if histograms are embedded in planning and simulation tools, they provide a highly flexible control view of capacities and resources based on a consistent data basis and dynamic view selection.

Additional links

About the Author: Jens Hirschinger

Jens has gathered extensive experience in resource management, project portfolio management, and agile methods in his nearly 20 years as a project manager, adviser, requirements analyst, and trainer. He applies this experience both to theoretical issues as a guest lecturer at HTW Berlin – University of Applied Sciences and to his everyday e-commerce projects. He shares his knowledge regularly as a guest author on the Meisterplan blog.

Send this to a friend