A format for creating a scored and ranked project list to aid in the process of project prioritization for portfolio management and resource allocation.
What this is
A worksheet for creating a scored and ranked project list to aid in portfolio management and resource allocation.
Why it's useful
Organizations often take on multiple projects at once and don't necessarily work on the most important ones for the business. This spreadsheet emphasizes mapping each project to one or more business drivers–i.e., business reasons for doing the project–and scoring the projects according to how much they contribute to those business goals.
How to use it
Use the format in the Excel file to create a list of your organization's projects. NOTE: several cells in the spreadsheet have comments attached, to explain the purpose of those cells.
Define the important business drivers that give your projects a reason to be. Examples of business drivers for different types of organizations are listed in the file. Projects will generally relate to revenue generation or cost savings (both of which drive profitability); they might be needed to satisfy a particular critical customer or user group; they might be necessary for keeping up with the competition, and so on.
Detailed instructions are continued in the Overview worksheet in the file; follow those steps to complete your fields appropriately for your environment and produce a final project ranking.
©Copyright 2000-2017 Emprend, Inc. All Rights Reserved.
About us Site Map View current sponsorship opportunities (PDF)
Contact us for more information or e-mail firstname.lastname@example.org