Capacity Management Dashboard

The Problem

A boutique consulting company needed to accurately predict availability of staff and executive resources up to one year into the future. Traditional spreadsheet based methods proved cumbersome to set up and hard to maintain. The planning team needed a way to easily visualize capacity for upcoming and prospective projects to support engagement decisions.

The Solution

The Capacity Management Dashboard is a single pane of insight into 12 month consulting capacity across resources. The tool provides an easy way to maintain project information, combining Google calendar and sheets to manage and store data, ensuring that at-a-glance capacity projections are available in the dashboard at all times.