Prioritization Matrix : Priority Matrix Template to Set Task and Project Priorities

by Alex .

What is a Prioritization Matrix?

The Prioritization Matrix is a simple tool designed to compare the proposed projects or tasks, giving them all the same criteria and weighted grades. Once all of the proposals have been graded, it is easy to see which one should positively impact the company. Prioritization Matrix Template is a tool that is important because deciding which project should receive a green light to go ahead and start is hard work, with a profound impact on the company’s bottom line.

Task Priority Matrix-Excel Template,prioritization matrix, prioritization matrix template, priority matrix template

Prioritization Matrix

Many executives tasked with making these decisions rely on their experience and instincts, which don’t always lead to the most promising projects being given the go-ahead. The Prioritization Matrix tool can also be used to decide which tasks should be prioritized if the resources are limited (time, experts, machines, etc.).

How to Create a Prioritization Matrix?

Putting together a solid matrix is a team effort and needs to get input from all stakeholders and team members. The following steps need to be taken to put a matrix together –

Step 1: Agreeing on the criteria - Which criterion will be scored and measured for each proposal

Step 2: Setting the grading values: Each criterion must receive a grade, which depicts how it aligns. For example: If the criterion is “aligns with strategic goals,” then the grades may be: “0 – not at all”, “3 – with 2 or fewer goals”, “6 – with the majority of goals”, “9 – with all of the goals.”

Step 3: Assigning weights to each criterion: Agree on which criterion has the largest impact on the company

Step 4: Create the matrix: List the criterion in the left row, their weight in the next column, and the values in the following column.

Step 5: Column wise: Add the projects from the fourth column onwards

Step 6: Calculate the grade: Multiply each criterion's weight by the grade value for each project.

Add up the grades for each project, and then list them from the highest grade to the lowest.

Task Prioritization Matrix Template

Task Priority Matrix is an approach of categorizing the tasks you have into Critical, High, Medium, and Low. The categorization helps you to address the tasks on a priority basis. This priority matrix build in excel helps you to manage your tasks and priorities.

prioritization matrix template,task priority matrix excel template, prioritizing tasks, prioritization matrix template

Task Priority Matrix Template

How to Prioritize Tasks?

An alternative task prioritization method is called the “Important / Urgent” decision-making matrix. This method splits the tasks into four different quadrants, and the responsible party should complete the tasks in the top left quadrant first.

Once these are done, move to quadrant two, three, and finally to four and complete the tasks there. This method is attributed to Sir Winston Churchill and was used by him to prioritize his multiple tasks. The definition of these classifications is as follows –

Important: A task which, when completed, has a positive impact on achieving the goals (either the company’s or personal).

Urgent: A task that demands immediate attention and is more often than not associated with achieving someone else’s goals. Not completing these tasks is usually associated with immediate consequences.

The quadrants are determined as follows –

  • First (Upper Left) - Important and Urgent: These are the tasks that positively impact the goals and are important to someone else. These tasks should take precedence over any others.
  • A second (Upper Right) – Important but not Urgent: These are the tasks that positively impact either the company or person's goals and should be completed after the tasks in the first quadrant are done.
  • Third (Lower Left) - Urgent but not Important: These tasks require immediate attention but do not impact our goals. These are mostly tasks that other people ask of us in the organization and are important to them.
  • Fourth (Lower Right) – Not Important and Not Urgent: These tasks usually don’t get completed (or started for that matter) since they aren’t important to anyone.

Features of the Task Priority Matrix Excel Template

  • Allows task prioritization based on four categories - Critical, High, Medium, and Low.
  • Has a backlog section that can be used to list the tasks which need to be done.
  • Task has to be created once in the backlog and then moved to the required categories by simply entering task ID.
  • Critical tasks should be done immediately, High tasks should be done ASAP, Medium and Low can wait for a bit more time.
  • The matrix highlights tasks that are not assigned in any category.
  • Duplicate tasks are highlighted in red bold in all the categories.
  • Each task has a score that can be used to signify the priority.
  • Using CTRL + Q will execute the sort, which will sort the tasks based on their scores. The higher the score higher the task is listed.

Project Priority Matrix

In an ideal world, organizations would have all the budget and resources they need to carry out all projects in their pipeline – and I would be happily rich. Unfortunately for all of us, we don’t live in an ideal world, and organizations are always constrained in the number of projects they can deliver with limited resources.

Project Prioritization Process,project prioritization process,Project Priority Matrix,  priority matrix template excel

Project Prioritization Process

Why Prioritize Projects?

  • In a nutshell, in the same way, project management is all about doing projects right; portfolio management is about doing the right projects, that is, the ones that align to strategy.
  • However, most of the time, resources, not a strategy, determine what gets done and when and most organizations still rely on rudimentary approaches to select their projects, namely, “first-come-first-served,” “who-shouts-the-loudest,” the well-known “gut feel,” or even the “eeny, meeny, miny, moe.”
  • I’m certain there may be advantages in following your instinct, but, overall, not only are those emotional, biased, and subjective approaches, they also miss consistency, transparency, and alignment.
  • At the end of the day, you end up with nothing more than pet projects, fashionable projects with the word “strategic” on them, and a couple of projects that are not aligned to what you wanted to achieve in the first place.
  • Defining how to prioritize projects can be a daunting task (and you may even upset a person or two initially).
  • Fortunately, we’re here to suggest a prioritization model that you can take away and use on your own.

Features of the Project Prioritization Matrix

From the rigorous Analytical Hierarchical Process (AHP) to sophisticated PPM tools and the entertaining priority poker, there are plenty of techniques out there for portfolio prioritization. Still, perhaps the more commonly used and easy to implement and tailor is the prioritization matrix.

Project Prioritization Matrix,Project Prioritization Matrix, Project Priority Matrix, Prioritization Matrix

Project Prioritization Matrix

Identify your criteria

  • What matters to your business? Is it the return on investment? Customer satisfaction? Improving operational efficiencies? All of them?
  • Gather your senior leadership team, discuss your strategy, and agree on what criteria projects should be evaluated against.
  • As a best practice, my recommendation would be to, at least, include ‘strategic alignment’ and the 3R’s of portfolio management – risk, resources, and return.

Establish the weight of each criterion

  • If achieving cost-efficiencies is more important than protecting reputation risk, this should be made clear for all so that projects that contribute to this objective can be pursued. Others that don’t can be moved to the bottom of your list of priorities.
  • The different criteria weight should sum up 100%.

Define the rating scale of each criterion

  • Each criterion should have a scale – usually comprising 3 or 5 levels – that defines how it can range.
  • For instance, if the criteria in the analysis are “Strategic Alignment,” then the question to ask would be “to what extent is the project aligned with our strategic objectives?”, whose answers could vary from “1 – does not align”, to “2 – aligns to a minimum”, “3 – somewhat aligns”, “4 – strongly aligns”, to “5 – fully aligns”.

Score your projects against each criteria

  • Grab your list of projects, sit your Exec team, and start evaluating each project to each criterion, scoring them using the scale previously identified.
  • Some projects may be easier to score than others. Still, you will soon realize that the prioritization exercise's discussion is what matters the most to align expectations and clarify the strategy to be followed.

Calculate the project total score

  • Simply put: just do the maths. Your project total score is a sum of the scoring for each criterion x the weight of that criterion.
  • The higher the score, the higher the priority of the project. Simple, right? I told you so.

Project Prioritization Matrix Example

The following example compares three proposed projects for a local private (for profit) hospital. The board can budget only one of the projects.

Prioritization Matrix Example,Prioritization Matrix Example, project prioritization template, Prioritization matrix
Prioritization Matrix Example