Back to all posts
Iryna Viter

How to Make a Resource Calendar (Even if It's the First Time)

Having a resource calendar will help you better understand the availability of your resources, plan ahead for upcoming projects, and prevent overloads.

When you are working on projects, it is important to schedule your resources. One way that you can do this is by creating a resource calendar that shows when people are available and what they will be up to weeks or months in advance.

It happens way too often that people get overbooked with work. Agencies, for instance, are often struggling to manage the time and workload for their teams, because they lack visibility into who’s doing what and the demand is huge. And if you ask consultants why they jump ships so often, you might pretty well hear that resource management is not the forte of consulting firms, as people are often assigned only based on their availability (not even including their skills!).

But no judgment, with so many things going on, it can be easy for some of the smaller details to slip through the cracks. A resource calendar is a great way to stay organized and ensure you don't miss any inefficiencies! 

So whether you’re a team leader, a project manager, or the resource manager of your company, a resource calendar is an indispensable tool. We'll walk you through everything you need to know about building your own resource calendar from scratch!

New call-to-action

Long story short, what is a resource calendar? 

A resource calendar is the most straightforward way to help project managers understand their team’s schedules. It often has a view of a heatmap where you can track who’s over- or underallocated with assignments on any given day, week, or month. It also reminds a timetable that shows each worker’s booking at a given time, and displays how resources are utilized. Mind that it’s best when the workloads are balanced and don’t jump from one extreme to another. 

The purpose of resource calendars is to centralize your resource pool in one place and provide a bird’s eye view of everyone’s bookings. The ultimate goal is to make sure people don’t bite more than they can chew and their assignments are evenly distributed. 

At its best, a resource calendar should contains the following information:

  • Employees’ availability - this is the amount of time someone can work. 
  • Leaves of absence - this is the time someone is unavailable. It may be due to planned vacations, sick leave, etc. 
  • National holidays - these are employees’ non-working days in a year’s calendar.
  • Planned work - this is the time a team member is booked for a project.
  • Time-sheets/time entries - this is the actual amount of time an employee has taken to complete an assignment /project.

Among other things, a well-built resource calendar should factor in people’s skills, seniority, and even career goals. This is often achieved with tags for people in different solutions. 

Here is an example of what your resource calendar might look like if it was built with Runn. 


Runn’s People Planner gives you real-time access to your pool of employees and contractors. At a glance, you can see everyone’s workload, holidays, time off, and availability for work. Switch between days, hours, or FTEs to see the effort.

Resource calendar vs project calendar

Before we dive deeper, it’s important we clear that project and resource calendars aren’t the same.

Sure, they are both created in the project planning phase. But they’re different in the way they are used, who makes them, and what’s included in them.

Essentially, resource calendars are used to manage employee availability. You use them to review who is available and when. Their primary aim is managing and scheduling resources — regardless of the project.

On the other hand, a project calendar is used to manage specific project dates and progress. You use them to see who is assigned which task(s) and when it’s due. Put this way, a project calendar is used to track a particular project’s planned tasks and milestones.

Use both of these calendars to ensure projects run on their tracks without burning out employees with work overload. Project managers create both these calendars with resource managers often coordinating on creating a resource calendar.

Here’s a summary of the difference between resource and project calendars.

The benefits of having a resource calendar

We’ve touched upon the benefits of having a resource calendar in the introduction, but let’s look at the full picture. The thing is, having a well-built resource calendar is the best way to avoid poor resource scheduling practices. Resource calendars may look complex at first, but they play a crucial role in project management. Here are five reasons why.

1. Resource calendars help you assess resource availability  

Human resource availability is one of the topmost factors that affects project management. Using a resource calendar can help you plan your team’s work more effectively. You can do this by assessing each team member’s vacation time, availability, and national holidays. Sometimes the employees you need may be booked for a different project. Since you know how long they will be unavailable, you can reschedule your project’s timeline or negotiate with other team leaders over shared resources.

It is essential to select people with the right skills for the timely completion of your project. Underqualified personnel may cause you time delays, while overqualified staff are overpaid for the role, which creates more pressure on your budget.

You can use Runn resource availability charts to track your resources easily. The charts are ready to use and only require you to insert your company's resources and projects. The charts are easier to manage than updating manual spreadsheets.

2. Resource calendars assist in forecasting and visualizing resource demand

You may know you need resources on current or future projects, but struggle to visualize the placeholders for specific roles and eventually transfer the work to people. Using a resource management calendar with placeholder functionality will relieve the stress of resource demand planning.

Placeholders are used when you have a project to plan out but don't yet know who to assign to it. You can even add skills and proficiency levels to your placeholders so you know what level of expertise you require of the person to hire or transfer the work to. Here's how it looks on a resource calendar in Runn:

how to forecast resource demand

3. Resource calendars guide you in planning resources for complex projects

With a complex project you need efficient coordination of both workers and resources to ensure the project meets its deadline. A resource calendar can help a project manager work out how to assign tasks to each team member at their specific working times, and keep the process running smoothly until the goal is accomplished. 

4. Resource calendars help you in sharing resources across multiple projects

Resource planning for multiple projects can be a nightmare - for both employees and managers alike! If you don’t plan, you may have times where you end up with too many tasks and too few resources. Other times, you may find you don’t have enough tasks to allocate to your team. 

So how can you best coordinate resources across multiple projects? The key is to develop a complete resource pool. This gives you an overview of the work versus available resources. For example, you can see who’s available, who is fully occupied, and who might have too much on their plate and be at risk of burnout.  Team leaders can help give you an accurate picture of team allocations and remaining availability, so that you can feed this into your resource calendar.

5. Resource calendars provide overview of the company’s project pipeline

A resource calendar gives you a high-level overview of your company’s production pipeline. This helps you plan in advance, maximize efficiency and keep every person engaged on a task at the right time. Monitoring all the production steps and all your employees can be exhausting and unproductive in the long run. A resource calendar eases your work by presenting the workflow steps in a pre-arranged order, showing everyone when and how to do their work.

Knowing your company's production pipeline is an important aspect of planning for resource risk. Resource risk happens when the resources you need to complete a project aren’t available when you need them. Although these risks can be beyond your control, identifying the stages in your pipeline where risks might occur means you can make contingency plans. 

This overview also helps with capacity planning, to make sure your company's resources match current and upcoming demand. You can also use it in active succession planning, ensuring that staff are upskilled to fill the roles of existing experienced staff. In this way, an unexpected resignation won't leave your company's entire pipeline in the lurch!

6. Resource calendars help you review employees’ workloads 

By keeping track of your team’s bookings or timesheets, you can identify individuals who are overworked or underutilized and adjust their bookings accordingly.  

It is wise to remember that overworked employees can experience personal deterioration and will not be able to perform as well as you need them to.   

If you are alerted to an employee's heavy workload through your resource calendar, you can reassess the resource allocation, and decide whether you need to extend deadlines or allocate more resources to the task.

When to create a resource calendar?

Create a resource calendar at the start of a project. This way, you can get a snapshot of who is available for work, what their skills are, and how much they charge.

You’ll also be able to track their availability throughout the span of the project. Use the information to reduce project risk and assign tasks to other team members to cover up for their unavailability. If needed, hire external help.

Ideally, however, it’s helpful to use resource software to create a resource calendar that’s a single source of truth — tracking employee availability across the board. Such a resource calendar isn’t project-specific. Instead, it’s a calendar you can reference as you plan quarterly work and take on new projects. 

Which projects require resource calendars

Almost all businesses could benefit from using a resource calendar in their human resources departments, because of how they facilitate an overview of employee tasks and availability. 

In particular, digital agencies use resource calendars for easy monitoring of tasks, especially among team members. Consultancy organizations and professional services also have to monitor the limited resources involved, such as finances and personnel. Software projects also need resource calendars to help visualize what parts of the project require more resources than others. 

What’s included in the resource calendar?

A comprehensive resource calendar includes the following:

  • Employee availability (the days and hours they are available to work)
  • Employee skills (find them using a skills inventory that tracks all team members’ strengths)
  • Employee vacation dates (so you can see when specific resources will be unavailable during a project’s lifespan)
  • Public holiday (this ensures you aren’t planning work without taking national holidays into account)
  • Start and end dates for different project milestones (this way, you can shuffle the team if needed — for example, senior staff would be working on the project’s first phase, and they’ll be available for more projects after the specific project phase ends)

Make sure you have all this data available before you start working on building a resource calendar.

How to make a resource calendar using Runn

Although there are various ways to create a resource calendar, such as a Google calendar or Excel spreadsheet, investing in specialized software is more beneficial in monitoring the progress and budgets of your projects.

Runn is a resource management software that helps you manage team availability. It helps you identify your team’s skills, and also assigns and update tasks once a project enters your company’s production pipeline. It also assists you in maintaining proper communication with all team members.

Step by step creation of a resource calendar

  • Start a free trial at https://www.runn.io/ 
  • Login to your account, fill out your profile, and watch the video which provides clear instructions on how it works! You can also try a demo to better understand the process, before using the live account.
  • Your account page will look like this:
Runn resource calendar account page.
  • You can see four tabs on the top right side: Projects, People, Manage, and Reports. Click on Projects to add all the projects you have.
  • Click on People to add all your employees, and the list will appear on the right side.
  • Select the view you want to see your bookings in: Today, Month, Quarter, and Half year. These show the amount of availability your employees have for each time period.
  • The software uses different colors to show availability in hours, or you can choose to view it as a percentage. The colors mean: blue - fully booked; dark blue and red - overbooked; light blue - some availability; green - no scheduled assignments.
  • Click on a person to add their availability, annual leave, sick leaves, or any other type of absence and the date going across. Clicking once will select a day, but you can drag to select more days. You can assign projects below the person’s name.
Assign projects to each resource.
  • Once you’re done with one person, save your work and proceed to the next.
  • You can click the manage tab to narrate each employee’s role, employment type, team, and tags. After filling in all the required data, the software will calculate each worker’s utilization, time off, total work assigned, and billings.
Resource planning software allows you to view data on each individual.

The software will generate reports based on the information you’ve put in. The reports show clients, project status, contract status, pricing model, and budget.

How to view resource availability

Availability view in Runn project planner.
  • The people planner displays your employees’ availability in hours by default. To view the availability in percentage, you can click on the % utilization tab.
  • You can click on the Weekly Summary tab to view your team’s weekly availability or utilization percentage.
  • The group utilization function is on by default. The Group Utilization tab on the planner shows you high-level utilization charts per group and placeholders.
  • The Group By tab allows you to see people according to their similarities. The default grouping, ‘All,’ shows all people on the planner. You can also classify the people by their teams, roles, tags, or employment status.
  • The Sort By tab allows you to select how your resources are ordered on the planner. For example, you can choose alphabetical order, team, role, or first name.

Bottom line

Accurately planning projects around the availability of your human resources means you can optimize costs, increase margins, and bring in greater returns. When you know your resource availability, it also helps you to avoid under-utilization of resources, resource clashes, and overbooking of employees. Good resource calendar software helps with accurate resource planning, and ensures that the necessary resources are available at the right time.

Learn more about resource planning in our survival kit:


SIGN-UP FOR MORE
Enjoy the post? Sign up for the latest strategies, stories and product updates.

You might also like

Try Runn today for free!

Join over 10k users worldwide.
Start scheduling in less than 10 minutes.
No credit card needed