An excerpt from my latest book, Everything is a Process. Available on Amazon.
I have twenty potential projects at my company. Which are the ones that provide the greatest benefit to the company and should be completed first?
Most people have heard a quote similar to that above. Where is the best place to spend effort to achieve results? This simple Excel tool provides a way of visually seeing all the projects and the value they bring based on a set of benefit and effort questions that are completed by a team of people in your organization.
Start with the Benefit Table
You start by looking at the Benefit Table worksheet. This table defines seven different benefits of a project.
- Revenue enhancement ($) – Will this positively impact the revenue of the company?
- Reduce Cost or Cost Avoidance within Company – Will this reduce costs within the Company by decreasing or avoiding time, labor, supplies, travel?
- Increase speed of delivery – Will this improve our ability to deliver results to our customers faster?
- Strategic Importance – Is this aligned with the Company strategy?
- Amount of Client Services “Pain” – What is the level of negative impact the process currently has on client services?
- Client Value – Does this deliver additional value to our clients? Or does this deliver savings to our client?
- Business Unit Impact – What is the scope of the project/project impact across business units?
Benefit Priority Worksheet
Rank each of these benefits for your projects. The ranking is a score of 0, 3, 6, or 9. For example, revenue enhancement is broken out as follows:
- Score of 0 – no impact
- Score of 3 – Impact < $500,000
- Score of 6 – Impact > $500,000 and < $5,000,000
- Score of 9 – Impact > $5,000,000
In this example, with an expected benefit of greater than $5,000,000 it would be scored as 9. If the trigger values do not work for your organization, change them to be more meaningful. For example, maybe $5,000,000 is too much and $700,000 would be more appropriate as the highest figure. Then change the trigger values to fit. You do this for each of the benefits shown in the table.
Next, you want to review the Effort Table. The effort table describes six different types of effort:
- Personnel Requirements – What are the average number of FTE’s (full time equivalent people) required to execute the project (independent of project duration)
- Project Duration – what are the number of weeks from start date to end date of the project?
- Budget Available – Are there budgeted funds available to support this effort?
- Capital Investment ($MM) – Are there any incremental capital expenditures or other costs that are required to implement the project?
- Risk Projection – What is the probability of not succeeding due to issues with respect to schedule, budget, customer requirements, etc.?
- Business Unit Impact – What is the effort and coordination required across departments and Business Units?
Effort Priority Worksheet
For example, personnel requirements are defined as follows:
- Score of 0 – 1-3 people
- Score of 3 – 3-6 people
- Score of 6 – 6-12 people
- Score of 9 – > 12 people
If the project requires 7 people it would be scored as a 6. You continue this activity for each benefit in the table.
Project Rating Worksheet
Copy your scores into the project rating worksheet. There is a weighting factor shown in red at the top of each column that I use as a default. If you want more exact weighting factors for your business, I suggest you perform the Analytical Hierarchy Process to calculate your own.
Once you have your scores in the project rating worksheet the software will automatically plot each project. The results will look something like what is shown in Figure 4. Now you have your projects in a pictorial format showing the benefit and effort for each project. The dotted box in the top middle represents the sweet spot. These are projects that are low to medium effort with medium to high benefit. The dotted box on the far left identifies those projects which would be suitable for a Kaizen effort (very low effort). Projects 1, 2, 3, 8 and 9 should be executed first. Projects 5 and 7 have little value and may not be done at all, unless they are regulatory or quality related. Project 4 may be a candidate for a Kaizen event.