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.
Iryna Viter

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.

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 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. 

3. 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.

4. 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!

5. 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.

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. 

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:


Enjoy the post? Sign-up below for the latest strategies, stories and product updates from the team at Runn.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

You might also like

Try Runn on a single project, a whole team, or run your entire business

Try for free
14 day trial. No credit card required.
Smart resource and capacity planning