Excel errors are rampant. The more data you feed it — the higher the error rate will be.
In a study on Excel use, a representative from the University of Hawaii found that 88% of spreadsheets contained errors. Some of them were mechanical, logical, or caused by omission. But it all boils down to one thing — Excel is not reliable for large data sets and when you are calculating capacity, a single error can mean wrong expectations.
When doing capacity modelling, you need to pull all the relevant threads together and embrace the art of visualizing workload vs capacity to see how much your team can realistically accomplish.
But considering just how flawed Excel is, can you find better ways to build your staff capacity planning model?
In this article, we're going to look at the concept of this model, the values it brings, and the steps you can take to get the most out of it.
A capacity planning model is a (visual) representation of confirmed workload vs capacity — whether you're looking at a team, an individual role, or even a skill in your pool of resources.
There are three different ways you can take when building your capacity planning model template:
The purpose of the capacity model is to help you get a realistic understanding of what your capacity is, what the demand is like, as well as if and how your current resource pool can accommodate the latter without getting overworked or being left on standby.
Without a capacity model, you're flying blind. Not knowing how much work you can fit into a given period of time, you can't make smart decisions about where to invest time and resources. Having visibility into the available capacity helps with everything from recruiting to onboarding, and from project planning to prioritization.
Capacity planning allows you to
All things considered, capacity planning model is pretty complex, especially for IT organizations. There are lots of moving parts in it, you need to keep your capacity agile and dynamic — which can turn into a Herculean task if you are limited to Excel only.
Before you look into how to build a capacity planning model, consider the items you will need to add there:
In short, building your capacity planning model in excel is a risky business because you can easily get tangled in all the data or get blind-sided by some numbers that can slip through the cracks.
Here are some other limitations you are sure to run into when building your workforce capacity planning model using spreadsheets:
Building a project management capacity planning model and creating capacity reports in general is never an easy job. But there are sure ways you can make it more organized and effective.
Here are some tried and tested practices.
Thinking ahead and calculating your further steps before you actually need to take them is the way to avoid all the dangers of capacity planning and project management in general.
Now that you're convinced just how inefficient capacity planning model can turn out in Excel, here's how Runn, an advanced resource management software, can help you master capacity management from A to Z.
Suppose you have a design project coming up and need to look into the capacity of your resources to see if the project is feasible with what you currently have. If not, you can either push the delivery date so it fits your team's availability or do some hiring to start the project as planned.
But here's how you get to that decision using Runn's capacity charts.
In the chart below, you can easily see the capacity vs confirmed workload for your Team Orange in the second week of January. They have a maximum capacity of 180h. And with their confirmed workload standing at 105h, you can give this team an additional 75h-worth of work.
But what if you need a more granular view into the availability of your resources? You can then filter the chart based on roles, skills, employment type, people, tags, and projects.
Your project will be revolving around Figma — do you have enough experts who are good at designing in Figma? If yes, do they have enough capacity left to participate in the new design project?
Go ahead and filter your chart by skills! (see "Skill Figma" as a filter in the visual below).
Once you put the project dates in and filtered your resources by skill, you get a high-level overview of the profiles that match your search. Look at Rihanna Fenty! She knows Figma and starting from December 12th, has 4 hours free.
Want to drill in and look at all the other projects Rihanna is working on to double-check if she makes the best fit with the project you are planning?
She is assigned to one iCar website project for 4 hours per day and seems to have no time off planned, which means she has those 4 hours free!
Building a capacity model can give a company the ability to accurately predict and react to shifts in demand, without having to resort to costly, last-minute changes. It can also help identify potential bottlenecks that could cause problems down the line.
It's important to understand that there is no one right way to build a capacity model — there are countless different business models, and countless different ways that each business can make it through the year.
A capacity model is simply a tool that can be customized for any given situation, as long as it can accurately assess a company's current state and estimate its future needs based on the information provided.
Want to see how far Runn can get you with your capacity planning model? Book a demo today!
Tasked with agile resource planning, but don't know where to start? Here are some tips for agile organizations.
Among other benefits, having a project log will help you record your project history and understand any changes made to the project.