RACI & RASCI Matrix Template Free Download: Excel and PPT with Examples

Share:

What is a RACI Matrix?

The RACI matrix is a table used to clarify the R&R (Roles & Responsibilities) in a matrix or cross functional organization, in regards to tasks that need to be completed throughout the projects’ lifecycle.

The RACI acronym stands for –
  • Responsible: who owns the activity and see it to fruition
  • Accountable: who signs off that it is completed
  • Consult: the SME (Subject Matter Expert) with whom there will be a two-way communication throughout the completion of the task
  • Inform: who will be informed of the progress of the task.

RACI Matrix Excel Template
RACI Matrix Excel Template

What is RASCI?

A RASCI Chart is a key ingredient in the toolkit of any project manager. RASCI is one of the most well-known variants of a responsibility assignment matrix whose main purpose is, as the name suggests, to assign responsibilities in a project or process, in this way ensuring that all involved are aware of what is expected of them.


RASCI is an acronym (you may have noticed already how much we love acronyms in the world of project management!) that stands for:
  • R: Responsible – this is the doer, the individual responsible for creating a deliverable or performing a task
  • A: Accountable – this is where the buck stops aka person whose head will roll if things don’t work out as they should
  • S: Support – this represents support elements, who are not responsible but will help when needed
  • C: Consulted – this is someone who will either provide inputs, endorse or advise on a certain task or deliverable
  • I: Informed – this is an individual who needs to needs to be kept in the loop, FYI-style. 

RASCI Template
RASCI Template

RASCI vs RACI

While RASCI is a renowned model, you may have also heard of its sibling RACI. RACI is equally useful as a tool; however, it doesn’t contain the role of Supporters, leaving it to the Responsible to identify who to ask for support. 

While both models can prove beneficial, there are advantages in using RASCI for large or complex projects involving a wider project team. 

When a crowd is brought together it is easy to get confused and even lost regarding responsibilities, thus, having the role of Supporters in your matrix may help you bring clarity to the group.

The responsibility-assignment-matrix-family is a vast one and you will certainly find alternative models, such as the brother RACI-VS (verifier and sign-off), the cousin PARIS (perform, accountable, control, suggest, informed), the aunty DACI (driver, approver, contributor, informed) or the grumpy old uncle CAIRO, who closely resembles RACI but has an additional responsibility, “omitted” or “out of the loop”.

Benefits of RASCI / RASCI Charts

  • Clarify responsibilities: There is no room for ambiguity since all responsibilities are documented
  • Remove duplication of efforts: Clarity on who does what prevents team members from working on tasks that they weren’t supposed to work on
  • Set expectations: Because everyone knows what is expected of them, motivation and performance are likely to increase
  • Drive ownership: By assigning responsibilities to tasks, commitment and accountability can be generated
  • Accelerate decision-making: Since people will know who do they need to go to for decision-making
  • Communicate better: When everyone is clear on their responsibilities, you no longer need to wonder who should be speaking to a supplier or making a decision

 Best Practices for a RACI Matrix

  1. There can be only one person responsible (R) for each task in the matrix.
  2. Usually whoever is accountable (A) is also who the responsible team member reports to. Like point #1 above, there can be only one person accountable for a task.
  3. The person consulted (C) on each task shouldn’t necessarily be from the same professional background as the one who is responsible. This allows a different perspective on the desired outcome of the task. There can be more than one person consulted on any given task.
  4. There should be more than one person informed (I), but they should have a certain stake in the successful completion of the task.
  5. Each task should have a due date.
  6. A certain function can have multiple mentions (For example: be informed and accountable per one specific task).
An updated RACI table is vital for the successful completion of a project in a matrix environment. It is a useful tool in the hands of the PM, allowing them to track progress, circumvent issues before they occur and free bottlenecks.

Best Practices for a RASCI Chart

A couple of best practices to check for when using a RASCI Chart are:
  • Each activity/deliverable should have one (1) and only one accountable (A)
  • Activities/deliverables can have more than one responsible (R) 
  • Beware of columns with no empty cells, it means there are individuals with too much work assigned to them
  • Beware of columns full of Accountables (A), as you may want to delegate authority to others instead of giving that burden (sorry, meant power!) to a single individual
  • Beware of activities/deliverables with too many people to be Consulted (C) since this can slow down the work
  • Present the RASCI Chart at the kick-off meeting, don’t wait until it’s too late
  • Ensure that people are happy with the RASCI Chart and have agreed to it.

RACI Matrix Examples

  1. This is an example of a Software Project RACI Table, that was put together after the kick off was approved. It is an example of how the project manager should track their tasks across the different divisions of the project. It includes positions which are directly under them (in the OBS diagram) such as COO and Admin, and matrix divisions such as QA, PMO and programming. Excel template 1:.
  2. This is an example of how the Supply Chain RACI Matrix should track their tasks for a sourcing process. It is how the Supply chain VP should track the tasks within the SP division, and defines the tasks and responsibilities between the various teams that make up the supply chain division. Excel Template 2.
  3. This is an example of an internal table which is used by a team leader of the QA Team Roles and Responsibilities. It shows how the tasks are split up between the team members, and is the only one who names them by name and not by function. This is because the other table present the tasks per teams and this table is for an internal team. PPT Slide #2.
  4. This is an example of a RACI for Recruitment Process done by the HR Division, with the help of the hiring manager (from another division in the company). It shows how the HRBP tracks the different tasks between all the divisions and team members, and also includes the preparations that the system admins need to do for the new employees to have the needed access and systems on their computer. PPT Slide #3.
RACI Matrix Template PPT
RACI Matrix PPT Template

How to create a RASCI Chart?

A RASCI Chart is very easy to create and that’s why you should definitely have one in your project (did I mention the great set of benefits of having one?). 

The Chart combines information from your Work Breakdown Structure (your deliverable and/or tasks) with information from your Organizational Breakdown Structure (the individuals or roles that are part of the project):
  1. Using verbs for activities and nouns for deliverable, list in the vertical all the activities, processes or deliverable to each you intend to assign responsibilities to, one per row
  2. In the horizontal, one per column, list the roles or names of the individuals who are part of the project
  3. Put the related letter of the responsibility (R, A, S, C, or I) you want to assign in the cell where activities intersect a role or a name.
However, even better than building your own RASCI from scratch, is using the template we developed just for you, ready to be used in the next worksheet!

No comments