Indzara Support

Overview of steps:

1. Enter Settings
2. Enter the Capacity of each Resource along with their availabilities
3. Enter vacation and overtime
4. Enter Demand (tasks) data for each task under different projects
5. View the Dashboard, Calendar, and the Project/Resource view of demand
6. Address any over-utilization and under-utilization

Please read this article, for the step-by-step guide of the Version 1.1 of the template.

Step 1: Enter Settings

In the Settings sheet, we will enter the basic settings for this planner.

List of unique roles and Project Categories

You can enter the list of unique roles that are needed for various projects and the project categories, for which the resource planner shall be used.

Please note there are NO limits to the number of roles, resources, project categories, and projects. 

Resources

The template uses the term ‘Resource’. The most commonly used resource in most scenarios is the human resource (can be called as Employee). But a machine could be a resource too. Hence instead of using ‘Employee’, the term ‘resource’ is generally used. In here, you can enter the list of resources and their role.

Also, here you can enter the list of Projects and their categories. 

Holidays
Since most companies have holidays, it is important that we factor that in when we calculate capacity. We can enter our company holidays and the template will set the availability of resources to 0 by default on those days. Each holiday must be entered individually.

Enter List of Holidays 

Step 2: Enter Resources’ Capacity

Now, we move to the Capacity sheet in the template.

We must enter the resources, and provide start and end dates of availability, available hours for each of their work day.

Resources can be hired anytime and similarly resources may leave a company anytime. The template will assign 0 availability before start date and after end date.

In the above example we have entered the capacity details of each of the resource ( as entered in Settings) and we have not entered any details for SUN/SAT which will be accounted by the template as weekend (day-off). 

Once the capacity details are entered the template automatically calculates the total Capacity for the entered date range.

The Demand column will get updated once we enter demand data. 

Please note: The columns in Green are automatically calculated so do not delete or alter them.

Step 3: Enter Vacation and Overtime

Though we have entered standard availability above, we know that employees may take vacation or sometimes work overtime.
We can enter any vacation or overtime taken by resources in the VACATION_OVERTIME sheet.

Point to note in Vacation/Overtime:

1. Overtime is positive to capacity and Vacation is negative to capacity.
2. In the above example Davis does "Overtime" for a period of 11 days.
   1. For the overtime to impact the capacity on non working days, please ensure to assign Capacity as 0 on Non-Working Days. For ex., SAT / SUN (as shown in below image)
      

Step 4: Enter Demand data

In this template, demand is entered for each task in a Project in the Demand sheet.

Required fields: Task, Project, and the Role that is needed to fulfill the given task; the start and end date for that particular task, and the Demand for each task.

Once there is a Resource available to meet the demand, assign the resource in the "Resource" column.

The resources are a list of items in a drop-down based on the Role assigned. 

The automatically calculated columns are in Green which includes the total demand, the assigned demand and project category.

There's a Data Validation column which immediately displays if there is any error/correction needed in the data entry in the demand sheet.

Please do not delete or modify the calculated columns as they may break the functionality of the template.

If there are any active slicers in any of the dashboard, please remove them in the Demand sheet before adding new data.

Once we complete entering the demand, we are done with data entry.

Step 5: View Dashboard

Dashboard

Dashboard sheet shows the summary of demand that is assigned and the capacity' utilization in two sheets, respectively.

The Demand Assignment Dashboard:

Get a quick overview of the assigned and the unassigned project and project categories.

This dashboard helps in identifying which projects are yet unassigned and the roles that are unassigned too.

Assigned demand is those demand who have a resource assigned to them and are available to fulfil (in the Demand sheet)

The second sheet is the capacity utilization dashboard:

Get to see the number of resources and roles with Deficit and Surplus capacity and take immediate actions to ensure a smooth flow in the work.

Use this sheet to identify under-utilization and over-utilization in your project assignments.  

Why is this important?

By looking at the trade-off in the surplus and deficit capacities, you can take corrective measures to ensure proper resource allocation to meet unassigned demand.

This way, the Dashboard will aid you in achieving close to 100% optimal resource utilization and to meet 100% demand.

Hence it is important to view utilization at role and/or resource level.

Calendar

This calendar, provides you with an overview based on either at the Role or the Resource level (dimensions).

The calendar is very flexible you can choose to view it for either Capacity, Demand or Capacity-Demand, Utilization% making it easy for you to track.

You have the flexibility to choose the time dimension ranging from Daily to Annually.

Project View

Similar to the calendar, get a project level overview of the demand allocation. This visual shows, for a chosen time dimension (from Daily to Annually) the Projects and the list of resources currently on these projects.

Resource View

What if there is a need to have a similar Resource-level view? We have you covered! The Resource View gives you just that.

To change the Start Date of the Project/Resource View, go to the Calendar sheet and change the start date there.

You can filter the Dashboard and the Calendars based on Project, Project Category, Resources, and (or) Roles to drill down further in your analysis.

Please note: To remove any filters applied on the Dashboard and Calendars before going back to the Demand sheet to enter new data

Step 6: Addressing Over-utilization and Under-Utilization

In order to address the over-utilization and under-utilization, we must do one or more of the following:

1. Change Capacity
   • Adjust standard availability of resources in the Capacity sheet.
     1. Increase (to increase capacity) or Decrease (to reduce capacity) available hours
   • Add overtime (to increase capacity) or vacation time (to reduce capacity)
2. Change Demand
   • Change the demand hours if possible. This would reduce the demand and allow the capacity to fulfill the demand.
3. Change Allocation/Assignment
   • Change assignment of tasks (demand) to a different resource.